From e72ab0adc8adcb2c4bd455e1e6d17acdefdcd685 Mon Sep 17 00:00:00 2001 From: Chuck Hagenbuch Date: Sun, 3 Oct 2010 13:41:31 -0400 Subject: [PATCH] Remove old Wicked SQL scripts and upgrades --- wicked/scripts/sql/wicked.mssql.sql | 59 ---------- wicked/scripts/sql/wicked.oci8.sql | 59 ---------- wicked/scripts/sql/wicked.sql | 58 ---------- wicked/scripts/upgrades/2009-09-29_drop_locks.sql | 1 - wicked/scripts/upgrades/convert_to_utf8.php | 126 ---------------------- 5 files changed, 303 deletions(-) delete mode 100644 wicked/scripts/sql/wicked.mssql.sql delete mode 100644 wicked/scripts/sql/wicked.oci8.sql delete mode 100644 wicked/scripts/sql/wicked.sql delete mode 100644 wicked/scripts/upgrades/2009-09-29_drop_locks.sql delete mode 100755 wicked/scripts/upgrades/convert_to_utf8.php diff --git a/wicked/scripts/sql/wicked.mssql.sql b/wicked/scripts/sql/wicked.mssql.sql deleted file mode 100644 index 2f79b6b08..000000000 --- a/wicked/scripts/sql/wicked.mssql.sql +++ /dev/null @@ -1,59 +0,0 @@ -CREATE TABLE wicked_pages ( - page_id INT NOT NULL, - page_name VARCHAR(100) NOT NULL, - page_text VARCHAR(MAX), - page_hits INT DEFAULT 0, - page_majorversion SMALLINT NOT NULL, - page_minorversion INT NOT NULL, - version_created INT NOT NULL, - change_author VARCHAR(255), - change_log VARCHAR(MAX), --- - PRIMARY KEY (page_id), - UNIQUE (page_name) -); - -CREATE TABLE wicked_history ( - page_id INT NOT NULL, - page_name VARCHAR(100) NOT NULL, - page_text VARCHAR(MAX), - page_majorversion SMALLINT NOT NULL, - page_minorversion INT NOT NULL, - version_created INT NOT NULL, - change_author VARCHAR(255), - change_log VARCHAR(MAX), --- - PRIMARY KEY (page_id, page_majorversion, page_minorversion) -); - -CREATE INDEX wicked_history_name_idx ON wicked_history (page_name); -CREATE INDEX wicked_history_version_idx ON wicked_history (page_majorversion, page_minorversion); - -CREATE TABLE wicked_attachments ( - page_id INT NOT NULL, - attachment_name VARCHAR(100) NOT NULL, - attachment_hits INT DEFAULT 0, - attachment_majorversion SMALLINT NOT NULL, - attachment_minorversion INT NOT NULL, - attachment_created INT NOT NULL, - change_author VARCHAR(255), - change_log VARCHAR(MAX), --- - PRIMARY KEY (page_id, attachment_name) -); - -CREATE TABLE wicked_attachment_history ( - page_id INT NOT NULL, - attachment_name VARCHAR(100) NOT NULL, - attachment_majorversion SMALLINT NOT NULL, - attachment_minorversion INT NOT NULL, - attachment_created INT NOT NULL, - change_author VARCHAR(255), - change_log VARCHAR(MAX), --- - PRIMARY KEY (page_id, attachment_name, attachment_majorversion, - attachment_minorversion) -); - -CREATE INDEX wicked_attachment_history_name_idx ON wicked_attachment_history (page_id, attachment_name); -CREATE INDEX wicked_attachment_history_version_idx ON wicked_attachment_history (attachment_majorversion, attachment_minorversion); diff --git a/wicked/scripts/sql/wicked.oci8.sql b/wicked/scripts/sql/wicked.oci8.sql deleted file mode 100644 index 1c41e6d42..000000000 --- a/wicked/scripts/sql/wicked.oci8.sql +++ /dev/null @@ -1,59 +0,0 @@ -CREATE TABLE wicked_pages ( - page_id NUMBER(16) NOT NULL, - page_name VARCHAR2(100) NOT NULL, - page_text CLOB, - page_hits NUMBER(16) DEFAULT 0, - page_majorversion NUMBER(8) NOT NULL, - page_minorversion NUMBER(16) NOT NULL, - version_created NUMBER(16) NOT NULL, - change_author VARCHAR2(255), - change_log CLOB, --- - PRIMARY KEY (page_id), - UNIQUE (page_name) -); - -CREATE TABLE wicked_history ( - page_id NUMBER(16) NOT NULL, - page_name VARCHAR2(100) NOT NULL, - page_text CLOB, - page_majorversion NUMBER(8) NOT NULL, - page_minorversion NUMBER(16) NOT NULL, - version_created NUMBER(16) NOT NULL, - change_author VARCHAR2(255), - change_log CLOB, --- - PRIMARY KEY (page_id, page_majorversion, page_minorversion) -); - -CREATE INDEX wicked_history_name_idx ON wicked_history (page_name); -CREATE INDEX wicked_history_version_idx ON wicked_history (page_majorversion, page_minorversion); - -CREATE TABLE wicked_attachments ( - page_id NUMBER(16) NOT NULL, - attachment_name VARCHAR2(100) NOT NULL, - attachment_hits NUMBER(16) DEFAULT 0, - attachment_majorversion NUMBER(8) NOT NULL, - attachment_minorversion NUMBER(16) NOT NULL, - attachment_created NUMBER(16) NOT NULL, - change_author VARCHAR2(255), - change_log CLOB, --- - PRIMARY KEY (page_id, attachment_name) -); - -CREATE TABLE wicked_attachment_history ( - page_id NUMBER(16) NOT NULL, - attachment_name VARCHAR2(100) NOT NULL, - attachment_majorversion NUMBER(8) NOT NULL, - attachment_minorversion NUMBER(16) NOT NULL, - attachment_created NUMBER(16) NOT NULL, - change_author VARCHAR2(255), - change_log CLOB, --- - PRIMARY KEY (page_id, attachment_name, attachment_majorversion, - attachment_minorversion) -); - -CREATE INDEX wicked_attach_hist_name_idx ON wicked_attachment_history (page_id, attachment_name); -CREATE INDEX wicked_attach_hist_version_idx ON wicked_attachment_history (attachment_majorversion, attachment_minorversion); diff --git a/wicked/scripts/sql/wicked.sql b/wicked/scripts/sql/wicked.sql deleted file mode 100644 index c82f81a1f..000000000 --- a/wicked/scripts/sql/wicked.sql +++ /dev/null @@ -1,58 +0,0 @@ -CREATE TABLE wicked_pages ( - page_id INT NOT NULL, - page_name VARCHAR(100) NOT NULL, - page_text TEXT, - page_hits INT DEFAULT 0, - page_majorversion SMALLINT NOT NULL, - page_minorversion INT NOT NULL, - version_created INT NOT NULL, - change_author VARCHAR(255), - change_log TEXT, --- - PRIMARY KEY (page_id), - UNIQUE (page_name) -); - -CREATE TABLE wicked_history ( - page_id INT NOT NULL, - page_name VARCHAR(100) NOT NULL, - page_text TEXT, - page_majorversion SMALLINT NOT NULL, - page_minorversion INT NOT NULL, - version_created INT NOT NULL, - change_author VARCHAR(255), - change_log TEXT, --- - PRIMARY KEY (page_id, page_majorversion, page_minorversion) -); - -CREATE INDEX wicked_history_name_idx ON wicked_history (page_name); -CREATE INDEX wicked_history_version_idx ON wicked_history (page_majorversion, page_minorversion); - -CREATE TABLE wicked_attachments ( - page_id INT NOT NULL, - attachment_name VARCHAR(100) NOT NULL, - attachment_hits INT DEFAULT 0, - attachment_majorversion SMALLINT NOT NULL, - attachment_minorversion INT NOT NULL, - attachment_created INT NOT NULL, - change_author VARCHAR(255), - change_log TEXT, --- - PRIMARY KEY (page_id, attachment_name) -); - -CREATE TABLE wicked_attachment_history ( - page_id INT NOT NULL, - attachment_name VARCHAR(100) NOT NULL, - attachment_majorversion SMALLINT NOT NULL, - attachment_minorversion INT NOT NULL, - attachment_created INT NOT NULL, - change_author VARCHAR(255), - change_log TEXT, --- - PRIMARY KEY (page_id, attachment_name, attachment_majorversion, attachment_minorversion) -); - -CREATE INDEX wicked_attachment_history_name_idx ON wicked_attachment_history (page_id, attachment_name); -CREATE INDEX wicked_attachment_history_version_idx ON wicked_attachment_history (attachment_majorversion, attachment_minorversion); diff --git a/wicked/scripts/upgrades/2009-09-29_drop_locks.sql b/wicked/scripts/upgrades/2009-09-29_drop_locks.sql deleted file mode 100644 index b8785b22b..000000000 --- a/wicked/scripts/upgrades/2009-09-29_drop_locks.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE wicked_pages DROP COLUMN page_locked; diff --git a/wicked/scripts/upgrades/convert_to_utf8.php b/wicked/scripts/upgrades/convert_to_utf8.php deleted file mode 100755 index 47b5ddd09..000000000 --- a/wicked/scripts/upgrades/convert_to_utf8.php +++ /dev/null @@ -1,126 +0,0 @@ -#!/usr/bin/php - - */ - -require_once dirname(__FILE__) . '/../lib/Application.php'; -Horde_Registry::appInit('wicked', array('authentication' => 'none', 'cli' => true)); - -// Create driver instance. -if ($conf['storage']['driver'] != 'sql') { - exit("You must have an SQL backend configured.\n"); -} -$db = $wicked->_db; - -// Get current charset. -$charset = $cli->prompt('Please specify the current charset of the data', - null, 'ISO-8859-1'); - -// Read existing attachments. -echo 'Converting attachments'; -$result = $db->query( - 'SELECT page_id, attachment_name, change_log FROM ' - . $conf['storage']['params']['attachmenttable']); -if (is_a($result, 'PEAR_Error')) { - $cli->fatal($result->toString()); -} -$sth = $db->prepare( - 'UPDATE ' . $conf['storage']['params']['attachmenttable'] - . ' SET attachment_name = ?, change_log = ?' - . ' WHERE page_id = ? AND attachment_name = ?'); -while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) { - $values = Horde_String::convertCharset( - array($row['attachment_name'], $row['change_log']), - $charset, 'UTF-8'); - $values[] = $row['page_id']; - $values[] = $row['attachment_name']; - $executed = $db->execute($sth, $values); - if (is_a($executed, 'PEAR_Error')) { - $cli->fatal($executed->toString()); - } - echo '.'; -} -$result = $db->query( - 'SELECT page_id, attachment_name, change_log FROM ' - . $conf['storage']['params']['attachmenthistorytable']); -if (is_a($result, 'PEAR_Error')) { - $cli->fatal($result->toString()); -} -$sth = $db->prepare( - 'UPDATE ' . $conf['storage']['params']['attachmenthistorytable'] - . ' SET attachment_name = ?, change_log = ?' - . ' WHERE page_id = ? AND attachment_name = ?'); -while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) { - $values = Horde_String::convertCharset( - array($row['attachment_name'], $row['change_log']), - $charset, 'UTF-8'); - $values[] = $row['page_id']; - $values[] = $row['attachment_name']; - $executed = $db->execute($sth, $values); - if (is_a($executed, 'PEAR_Error')) { - $cli->fatal($executed->toString()); - } - echo '.'; -} -$cli->writeln($cli->green('Done')); - -// Read existing history. -$result = $db->query( - 'SELECT page_id, page_majorversion, page_minorversion, page_name, page_text, change_log FROM ' - . $conf['storage']['params']['historytable']); -if (is_a($result, 'PEAR_Error')) { - $cli->fatal($result->toString()); -} -$sth = $db->prepare( - 'UPDATE ' . $conf['storage']['params']['historytable'] - . ' SET page_name = ?, page_text = ?, change_log = ?' - . ' WHERE page_id = ? AND page_majorversion = ? AND page_minorversion = ?'); -echo 'Converting history'; -while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) { - $values = Horde_String::convertCharset( - array($row['page_name'], $row['page_text'], $row['change_log']), - $charset, 'UTF-8'); - $values[] = $row['page_id']; - $values[] = $row['page_majorversion']; - $values[] = $row['page_minorversion']; - $executed = $db->execute($sth, $values); - if (is_a($executed, 'PEAR_Error')) { - $cli->fatal($executed->toString()); - } - echo '.'; -} -$cli->writeln($cli->green('Done')); - -// Read existing pages. -$result = $db->query( - 'SELECT page_id, page_name, page_text, change_log FROM ' - . $conf['storage']['params']['table']); -if (is_a($result, 'PEAR_Error')) { - $cli->fatal($result->toString()); -} -$sth = $db->prepare( - 'UPDATE ' . $conf['storage']['params']['table'] - . ' SET page_name = ?, page_text = ?, change_log = ?' - . ' WHERE page_id = ?'); -echo 'Converting pages'; -while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) { - $values = Horde_String::convertCharset( - array($row['page_name'], $row['page_text'], $row['change_log']), - $charset, 'UTF-8'); - $values[] = $row['page_id']; - $executed = $db->execute($sth, $values); - if (is_a($executed, 'PEAR_Error')) { - $cli->fatal($executed->toString()); - } - echo '.'; -} -$cli->writeln($cli->green('Done')); -- 2.11.0