schema.sql

Revision 30, 487 bytes (checked in by jk, 2 years ago)
simple sti scenario

Line
1	drop table if exists contents;
2	create table contents (
3	id int not null auto_increment,
4	type varchar(255) not null,
5	title varchar(100) not null,
6	description text not null,
7	special varchar(255) not null,
8	primary key (id)
9	) TYPE=InnoDB DEFAULT CHARSET=utf8;
10
11	drop table if exists comments;
12	create table comments (
13	id int not null auto_increment,
14	author varchar(100) not null,
15	content text not null,
16	content_id int,
17	primary key (id)
18	) TYPE=InnoDB DEFAULT CHARSET=utf8;

Note: See TracBrowser for help on using the browser.