Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12103
Modified Files:
db_update_0.8-alpha4_0.8-alpha5_sqlite.sql
Log Message:
borked syntax
Index: db_update_0.8-alpha4_0.8-alpha5_sqlite.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.8-alpha4_0.8-alpha5_sqlite.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- db_update_0.8-alpha4_0.8-alpha5_sqlite.sql 3 Dec 2004 10:07:44 -0000 1.1
+++ db_update_0.8-alpha4_0.8-alpha5_sqlite.sql 16 Dec 2004 11:57:45 -0000 1.2
@@ -15,7 +15,7 @@
);
INSERT INTO {PREFIX}tempcomments (id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status) SELECT id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status FROM {PREFIX}comments;
-DROP TABLE comments;
+DROP TABLE {PREFIX}comments;
create table {PREFIX}comments (
id {AUTOINCREMENT} {PRIMARY},
@@ -34,5 +34,5 @@
referer varchar(200) default null
);
-INSERT INTO {PREFIX}comments (id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status) SELECT id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status FROM {PREFIX}comments;
-DROP TABLE tempcomments;
+INSERT INTO {PREFIX}comments (id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status) SELECT id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status FROM {PREFIX}tempcomments;
+DROP TABLE {PREFIX}tempcomments;
|
