development_structure.sql

Revision 5, 438 bytes (checked in by jk, 3 years ago)
--

Line
1	CREATE TABLE `comments` (
2	`id` int(11) NOT NULL auto_increment,
3	`author` varchar(100) NOT NULL default '',
4	`content` text NOT NULL,
5	`content_id` int(11) default NULL,
6	PRIMARY KEY (`id`)
7	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
8
9	CREATE TABLE `contents` (
10	`id` int(11) NOT NULL auto_increment,
11	`title` varchar(100) NOT NULL default '',
12	`description` text NOT NULL,
13	PRIMARY KEY (`id`)
14	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
15

Note: See TracBrowser for help on using the browser.