X-Git-Url: https://jasonwoof.com/gitweb/?p=wfpl-cms.git;a=blobdiff_plain;f=inc%2Fdb_upgrade.php;fp=inc%2Fdb_upgrade.php;h=c856faddfe31ed459744e32b58dfef3fbbedc67f;hp=8bfa14f34ebb9b18e055ccf6ec6815aad1fafecd;hb=2de7be27f43afd1c2ea911cd3235b56a44f74573;hpb=d15f2b1e0aac45e7798c2b32816d233d633e2ca4

diff --git a/inc/db_upgrade.php b/inc/db_upgrade.php
index 8bfa14f..c856fad 100644
--- 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
+);
+}