-- Table structure for table `menu` CREATE TABLE `menu` ( `uid` int(11) NOT NULL auto_increment, `short_name` varchar(25) NOT NULL default '', `order` tinyint(4) NOT NULL default '0', `title` text NOT NULL, `subtitle` text NOT NULL, `bgcolor` varchar(6) NOT NULL default 'ddd', `bgcolor2` varchar(6) NOT NULL default '', `show` tinyint(1) NOT NULL default '1', PRIMARY KEY (`short_name`), UNIQUE KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- Table structure for table `content` CREATE TABLE `content` ( `uid` int(11) NOT NULL auto_increment, `short_name` varchar(25) NOT NULL default '', `content` text NOT NULL, `cshow` tinyint(1) NOT NULL default '1', UNIQUE KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;