Update of /cvsroot/php-blog/serendipity/sql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv18455 Modified Files: db_update_0.2_0.3_mysql.sql db_update_0.2_0.3_pqsql.sql db_update_0.3_0.4_mysql.sql db_update_0.3_0.4_pgsql.sql db_update_0.5_0.5.1_mysql.sql db_update_0.5_0.5.1_pgsql.sql Log Message: mmmm prefixes, tasty :) Index: db_update_0.2_0.3_mysql.sql =================================================================== RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.2_0.3_mysql.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- db_update_0.2_0.3_mysql.sql 29 Feb 2004 19:44:04 -0000 1.1 +++ db_update_0.2_0.3_mysql.sql 2 Mar 2004 17:57:05 -0000 1.2 @@ -1,17 +1,17 @@ -ALTER TABLE serendipity_entries ADD COLUMN trackbacks INT(4) DEFAULT 0 AFTER `comments`; +ALTER TABLE {PREFIX}entries ADD COLUMN trackbacks INT(4) DEFAULT 0 AFTER `comments`; -ALTER TABLE serendipity_entries ADD COLUMN isdraft ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER `categoryid`; +ALTER TABLE {PREFIX}entries ADD COLUMN isdraft ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER `categoryid`; -ALTER TABLE serendipity_comments ADD COLUMN subscribed ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER `type`; +ALTER TABLE {PREFIX}comments ADD COLUMN subscribed ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER `type`; -INSERT INTO serendipity_config (name, value) VALUES ('allowSubscriptions', 'false'); +INSERT INTO {PREFIX}config (name, value) VALUES ('allowSubscriptions', 'false'); -INSERT INTO serendipity_config (name, value) VALUES ('template', 'default'); +INSERT INTO {PREFIX}config (name, value) VALUES ('template', 'default'); -INSERT INTO serendipity_config (name, value) VALUES ('embed', 'false'); +INSERT INTO {PREFIX}config (name, value) VALUES ('embed', 'false'); -INSERT INTO serendipity_config (name, value) VALUES ('indexFile', 'index.php'); +INSERT INTO {PREFIX}config (name, value) VALUES ('indexFile', 'index.php'); -INSERT INTO serendipity_config (name, value) VALUES ('blockReferer', ';'); +INSERT INTO {PREFIX}config (name, value) VALUES ('blockReferer', ';'); -INSERT INTO serendipity_config (name, value) VALUES ('XHTML11', 'false'); +INSERT INTO {PREFIX}config (name, value) VALUES ('XHTML11', 'false'); Index: db_update_0.2_0.3_pqsql.sql =================================================================== RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.2_0.3_pqsql.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- db_update_0.2_0.3_pqsql.sql 29 Feb 2004 19:44:04 -0000 1.1 +++ db_update_0.2_0.3_pqsql.sql 2 Mar 2004 17:57:05 -0000 1.2 @@ -1,17 +1,17 @@ -ALTER TABLE serendipity_entries ADD COLUMN trackbacks INT(4) DEFAULT 0 AFTER `comments`; +ALTER TABLE {PREFIX}entries ADD COLUMN trackbacks INT(4) DEFAULT 0 AFTER `comments`; -ALTER TABLE serendipity_entries ADD COLUMN isdraft BOOLEAN NOT NULL FALSE AFTER `categoryid`; +ALTER TABLE {PREFIX}entries ADD COLUMN isdraft BOOLEAN NOT NULL FALSE AFTER `categoryid`; -ALTER TABLE serendipity_comments ADD COLUMN subscribed BOOLEAN NOT NULL AFTER `type`; +ALTER TABLE {PREFIX}comments ADD COLUMN subscribed BOOLEAN NOT NULL AFTER `type`; -INSERT INTO serendipity_config (name, value) VALUES ('allowSubscriptions', 'false'); +INSERT INTO {PREFIX}config (name, value) VALUES ('allowSubscriptions', 'false'); -INSERT INTO serendipity_config (name, value) VALUES ('template', 'default'); +INSERT INTO {PREFIX}config (name, value) VALUES ('template', 'default'); -INSERT INTO serendipity_config (name, value) VALUES ('embed', 'false'); +INSERT INTO {PREFIX}config (name, value) VALUES ('embed', 'false'); -INSERT INTO serendipity_config (name, value) VALUES ('indexFile', 'index.php'); +INSERT INTO {PREFIX}config (name, value) VALUES ('indexFile', 'index.php'); -INSERT INTO serendipity_config (name, value) VALUES ('blockReferer', ';'); +INSERT INTO {PREFIX}config (name, value) VALUES ('blockReferer', ';'); -INSERT INTO serendipity_config (name, value) VALUES ('XHTML11', 'false'); +INSERT INTO {PREFIX}config (name, value) VALUES ('XHTML11', 'false'); Index: db_update_0.3_0.4_mysql.sql =================================================================== RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.3_0.4_mysql.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- db_update_0.3_0.4_mysql.sql 29 Feb 2004 19:44:04 -0000 1.1 +++ db_update_0.3_0.4_mysql.sql 2 Mar 2004 17:57:05 -0000 1.2 @@ -1 +1 @@ -ALTER TABLE serendipity_entries ADD COLUMN allow_comments ENUM('true', 'false') NOT NULL DEFAULT 'true' AFTER isdraft; +ALTER TABLE {PREFIX}entries ADD COLUMN allow_comments ENUM('true', 'false') NOT NULL DEFAULT 'true' AFTER isdraft; Index: db_update_0.3_0.4_pgsql.sql =================================================================== RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.3_0.4_pgsql.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- db_update_0.3_0.4_pgsql.sql 29 Feb 2004 19:44:04 -0000 1.1 +++ db_update_0.3_0.4_pgsql.sql 2 Mar 2004 17:57:05 -0000 1.2 @@ -1 +1 @@ -ALTER TABLE serendipity_entries ADD COLUMN allow_comments BOOLEAN NOT NULL TRUE AFTER isdraft; +ALTER TABLE {PREFIX}entries ADD COLUMN allow_comments BOOLEAN NOT NULL TRUE AFTER isdraft; Index: db_update_0.5_0.5.1_mysql.sql =================================================================== RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.5_0.5.1_mysql.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- db_update_0.5_0.5.1_mysql.sql 29 Feb 2004 19:44:04 -0000 1.1 +++ db_update_0.5_0.5.1_mysql.sql 2 Mar 2004 17:57:05 -0000 1.2 @@ -1,4 +1,4 @@ -CREATE TABLE `s9ytest_images` ( +CREATE TABLE `{PREFIX}images` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `extension` varchar(5) NOT NULL default '', @@ -11,13 +11,24 @@ PRIMARY KEY (`id`) ) TYPE=MyISAM; +UPDATE {PREFIX}plugins + SET name = REPLACE(name, 'serendipity_plugin_content_rewrite', 'serendipity_event_contentrewrite') + WHERE name LIKE '%serendipity_plugin_content_rewrite%'; -ALTER TABLE s9ytest_entries ADD last_modified INT(10) UNSIGNED default null; -CREATE INDEX timestamp ON s9ytest_entries (timestamp); -CREATE INDEX last_modified ON s9ytest_entries (last_modified); -UPDATE s9ytest_entries SET last_modified = timestamp; +UPDATE {PREFIX}config + SET name = REPLACE(name, 'serendipity_plugin_content_rewrite', 'serendipity_event_contentrewrite') + WHERE name LIKE '%serendipity_plugin_content_rewrite%'; + +UPDATE {PREFIX}plugins + SET placement = 'event' + WHERE name LIKE '%serendipity_event_contentrewrite%'; -INSERT INTO s9ytest_plugins(name, placement, sort_order) VALUES ('serendipity_event_nl2br:39979424fea674e78399659e67edaf12', 'event', 10); -INSERT INTO s9ytest_plugins(name, placement, sort_order) VALUES ('serendipity_event_s9ymarkup:fdd8bf23ff500827cf76d7d31957d3c8', 'event', 11); -INSERT INTO s9ytest_plugins(name, placement, sort_order) VALUES ('serendipity_event_emoticate:e30b433546aa10a632b0d703ebe1aa29', 'event', 12); -INSERT INTO s9ytest_plugins(name, placement, sort_order) VALUES ('serendipity_event_trackexits:25e6d8eb7d662936abb6454956aaa8ab', 'event', 13); +ALTER TABLE {PREFIX}entries ADD last_modified INT(10) UNSIGNED default null; +CREATE INDEX timestamp ON {PREFIX}entries (timestamp); +CREATE INDEX last_modified ON {PREFIX}entries (last_modified); +UPDATE {PREFIX}entries SET last_modified = timestamp; + +INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_nl2br:39979424fea674e78399659e67edaf12', 'event', 10); +INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_s9ymarkup:fdd8bf23ff500827cf76d7d31957d3c8', 'event', 11); +INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_emoticate:e30b433546aa10a632b0d703ebe1aa29', 'event', 12); +INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_trackexits:25e6d8eb7d662936abb6454956aaa8ab', 'event', 13); Index: db_update_0.5_0.5.1_pgsql.sql =================================================================== RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.5_0.5.1_pgsql.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- db_update_0.5_0.5.1_pgsql.sql 29 Feb 2004 19:44:04 -0000 1.1 +++ db_update_0.5_0.5.1_pgsql.sql 2 Mar 2004 17:57:05 -0000 1.2 @@ -1,4 +1,4 @@ -CREATE TABLE serendipity_images ( +CREATE TABLE {PREFIX}images ( id SERIAL primary key, name varchar(255) NOT NULL default '', extension varchar(5) NOT NULL default '', @@ -10,25 +10,25 @@ date int NOT NULL default '0' ); -UPDATE serendipity_plugins +UPDATE {PREFIX}plugins SET name = REPLACE(name, 'serendipity_plugin_content_rewrite', 'serendipity_event_contentrewrite') WHERE name LIKE '%serendipity_plugin_content_rewrite%'; -UPDATE serendipity_config +UPDATE {PREFIX}config SET name = REPLACE(name, 'serendipity_plugin_content_rewrite', 'serendipity_event_contentrewrite') WHERE name LIKE '%serendipity_plugin_content_rewrite%'; -UPDATE serendipity_plugins +UPDATE {PREFIX}plugins SET placement = 'event' WHERE name LIKE '%serendipity_event_contentrewrite%'; -ALTER TABLE serendipity_entries ADD last_modified INT UNSIGNED default null; +ALTER TABLE {PREFIX}entries ADD last_modified INT UNSIGNED default null; -CREATE INDEX timestamp ON serendipity_entries (timestamp); -CREATE INDEX last_modified ON serendipity_entries (last_modified); -UPDATE serendipity_entries SET last_modified = timestamp; +CREATE INDEX timestamp ON {PREFIX}entries (timestamp); +CREATE INDEX last_modified ON {PREFIX}entries (last_modified); +UPDATE {PREFIX}entries SET last_modified = timestamp; -INSERT INTO serendipity_plugins(name, placement, sort_order) VALUES ('serendipity_event_nl2br:39979424fea674e78399659e67edaf12', 'event', 10); -INSERT INTO serendipity_plugins(name, placement, sort_order) VALUES ('serendipity_event_s9ymarkup:fdd8bf23ff500827cf76d7d31957d3c8', 'event', 11); -INSERT INTO serendipity_plugins(name, placement, sort_order) VALUES ('serendipity_event_emoticate:e30b433546aa10a632b0d703ebe1aa29', 'event', 12); -INSERT INTO serendipity_plugins(name, placement, sort_order) VALUES ('serendipity_event_trackexits:25e6d8eb7d662936abb6454956aaa8ab', 'event', 13); +INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_nl2br:39979424fea674e78399659e67edaf12', 'event', 10); +INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_s9ymarkup:fdd8bf23ff500827cf76d7d31957d3c8', 'event', 11); +INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_emoticate:e30b433546aa10a632b0d703ebe1aa29', 'event', 12); +INSERT INTO {PREFIX}plugins(name, placement, sort_order) VALUES ('serendipity_event_trackexits:25e6d8eb7d662936abb6454956aaa8ab', 'event', 13); |
