- create table paypal_ipn (
- id int unique auto_increment,
- txn_id varchar(250) not null default "",
- status varchar(250) not null default "",
- ipn_at int(11) not null default 0,
- txn_type varchar(100) not null default "",
- subscr_id varchar(100) not null default "",
- custom varchar(250) not null default "",
- for_table_id int not null default 0,
- for_row_id int not null default 0,
- processed int(1) not null default 0,
- item_name varchar(250) not null default "",
- item_number varchar(250) not null default "",
- needs_review int(1) not null default 0,
- payment_status varchar(250) not null default "",
- mc_gross varchar(250) not null default "",
- mc_currency varchar(250) not null default "",
- receiver_email varchar(250) not null default "",
- payer_email varchar(250) not null default "",
- log text not null default ""
- ) CHARSET=utf8;
+ create table paypal_ipn (
+ id int unique auto_increment,
+ txn_id varchar(250) not null default "",
+ status varchar(250) not null default "",
+ ipn_at int(11) not null default 0,
+ txn_type varchar(100) not null default "",
+ subscr_id varchar(100) not null default "",
+ custom varchar(250) not null default "",
+ for_table_id int not null default 0,
+ for_row_id int not null default 0,
+ processed int(1) not null default 0,
+ item_name varchar(250) not null default "",
+ item_number varchar(250) not null default "",
+ needs_review int(1) not null default 0,
+ payment_status varchar(250) not null default "",
+ mc_gross varchar(250) not null default "",
+ mc_currency varchar(250) not null default "",
+ receiver_email varchar(250) not null default "",
+ payer_email varchar(250) not null default "",
+ log text not null default ""
+ ) CHARSET=utf8;
+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;