1 drop table if exists pages;
2 create table cms_pages (
3 id int unique auto_increment,
4 filename varchar(200) not null default "",
5 title varchar(200) not null default "",
6 nav_title varchar(200) not null default "",
7 navbar int not null default 0,
8 layout int not null default 0,
9 content mediumtext not null default "",
10 sidebar_content mediumtext not null default "",
11 description text not null default "",
12 keywords text not null default ""
14 insert into cms_pages (filename,title,content,navbar) values ('index','Home','Under Construction',1000000000);