Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1:/tmp/cvs-serv13073
Modified Files:
db_update-0.2-0.3.sql
Log Message:
!Major bug!
MySQL users can't run the .sql file because ' was used instead of `
Index: db_update-0.2-0.3.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/db_update-0.2-0.3.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- db_update-0.2-0.3.sql 20 Sep 2003 03:43:56 -0000 1.3
+++ db_update-0.2-0.3.sql 21 Oct 2003 20:35:08 -0000 1.4
@@ -1,10 +1,10 @@
-ALTER TABLE serendipity_entries ADD COLUMN trackbacks INT(4) DEFAULT 0 AFTER 'comments';
+ALTER TABLE serendipity_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 serendipity_entries ADD COLUMN isdraft ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER `categoryid`;
/* ENUM('true', 'false') NOT NULL DEFAULT 'false'
should be replaced by BOOLEAN NOT NULL for postgresql */
-ALTER TABLE serendipity_comments ADD COLUMN subscribed ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER 'type';
+ALTER TABLE serendipity_comments ADD COLUMN subscribed ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER `type`;
/* ENUM('true', 'false') NOT NULL DEFAULT 'false'
should be replaced by BOOLEAN NOT NULL for postgresql */
|