t8mStpJh

1CREATE TABLE IF NOT EXISTS `article` (
2  `ID` int(11) NOT NULL AUTO_INCREMENT,
3  `uri` varchar(5) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
4  `raw` text NOT NULL,
5  `html` text NOT NULL,
6  `title` varchar(120) NOT NULL DEFAULT 'Untitled Article',
7  `user_id` int(11) NOT NULL,
8  `date_created` datetime NOT NULL,
9  `date_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
10  `public` int(1) NOT NULL DEFAULT '1',
11  PRIMARY KEY (`ID`),
12  UNIQUE KEY `uri` (`uri`)
13) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;
14CREATE TABLE IF NOT EXISTS `user` (
15  `ID` int(11) NOT NULL AUTO_INCREMENT,
16  `username` varchar(18) NOT NULL,
17  `password` char(40) NOT NULL,
18  `email` varchar(255) NOT NULL,
19  PRIMARY KEY (`ID`),
20  UNIQUE KEY `username` (`username`,`email`)
21) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;