rs_formulare.sql

# Table structure for table 'rs_formulare'

CREATE TABLE `rs_formulare` (
`id_frm` int(10) unsigned NOT NULL auto_increment,
`nazev` varchar(100) default NULL,
`email` varchar(100) default NULL,
`aktivni` tinyint(3) unsigned default NULL,
`poradi` tinyint(3) unsigned default NULL,
`komentar` text,
PRIMARY KEY  (`id_frm`),
KEY `poradi` (`poradi`)
);

# Table structure for table 'rs_forminput'

CREATE TABLE `rs_forminput` (
`id_inp` int(10) unsigned NOT NULL auto_increment,
`formular` int(10) unsigned default NULL,
`poradi` tinyint(3) unsigned default NULL,
`label` varchar(50) default NULL,
`type` varchar(10) default NULL,
`name` varchar(25) default NULL,
`value` varchar(25) default NULL,
`size_cols` tinyint(3) unsigned default NULL,
`maxl_rows` tinyint(3) unsigned default NULL,
`option` text,
PRIMARY KEY  (`id_inp`),
KEY `formular` (`formular`),
KEY `poradi` (`poradi`)
);

# Upgrade 22.11.2007

ALTER TABLE rs_forminput ADD COLUMN povinne tinyint(3) default 0;