generic editable site

[wfpl-cms.git] / admin_pages.sql

diff --git a/admin_pages.sql b/admin_pages.sql
new file mode 100644 (file)
index 0000000..e82ed35
--- /dev/null
+++ b/admin_pages.sql
@@ -0,0 +1,11 @@
+drop table if exists pages;
+create table cms_pages (
+    id int unique auto_increment,
+    filename varchar(200) not null default "",
+    title varchar(200) not null default "",
+    nav_title varchar(200) not null default "",
+    navbar int not null default 0,
+    content text not null default "",
+    description text not null default "",
+    keywords text not null default ""
+);