1
2
3
4
5
6
7
8

CREATE TABLE `itmpl_data` (
  `itmpl_id` int(10) unsigned NOT NULL,
  `page` varchar(127) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `control` varchar(127) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `state` enum('hide','adminOnly','show') NOT NULL DEFAULT 'hide',
  `control_type` enum('button','formControl') NOT NULL DEFAULT 'button',
  PRIMARY KEY (`itmpl_id`,`page`,`control`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `itmpl_data` ( `itmpl_id` int(10) unsigned NOT NULL, `page` varchar(127) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `control` varchar(127) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `state` enum('hide','adminOnly','show') NOT NULL DEFAULT 'hide', `control_type` enum('button','formControl') NOT NULL DEFAULT 'button', PRIMARY KEY (`itmpl_id`,`page`,`control`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1