page edit history

[wfpl-cms.git] / inc / db_upgrade.php

diff --git a/inc/db_upgrade.php b/inc/db_upgrade.php
index 8bfa14f..c856fad 100644 (file)
--- a/inc/db_upgrade.php
+++ b/inc/db_upgrade.php
@@ -115,3 +115,54 @@ db_send_query(<<<EOLsql
 EOLsql
 );
 }
+
+function db_upgrade_to_2() {
+db_send_query(<<<EOLsql
+       create table history_cms_pages (
+               history_id int unique auto_increment,
+               history_when int not null default 0,
+               history_user_id int not null default 0,
+               id int,
+               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,
+               layout int not null default 0,
+               content mediumtext not null default "",
+               sidebar_content mediumtext not null default "",
+               description text not null default "",
+               keywords text not null default ""
+       );
+EOLsql
+);
+db_send_query(<<<EOLsql
+       insert into history_cms_pages (
+               history_when,
+               history_user_id,
+               id,
+               filename,
+               title,
+               nav_title,
+               navbar,
+               layout,
+               content,
+               sidebar_content,
+               description,
+               keywords
+       ) select
+               0,
+               0,
+               id,
+               filename,
+               title,
+               nav_title,
+               navbar,
+               layout,
+               content,
+               sidebar_content,
+               description,
+               keywords
+       from cms_pages;
+EOLsql
+);
+}