Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19988
Modified Files:
db.sql db_update_0.6.6_0.6.7_postgres.sql
Log Message:
DB update was missing in db.sql
Adjusted postgresql, so that it possibly could work :)
Index: db_update_0.6.6_0.6.7_postgres.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.6.6_0.6.7_postgres.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- db_update_0.6.6_0.6.7_postgres.sql 16 Jul 2004 22:17:24 -0000 1.1
+++ db_update_0.6.6_0.6.7_postgres.sql 17 Jul 2004 12:01:02 -0000 1.2
@@ -1,3 +1,3 @@
-ALTER TABLE `{PREFIX}entries` ADD `moderate_comments` ENUM('true','false') DEFAULT 'false' NOT NULL AFTER `allow_comments`;
-ALTER TABLE `{PREFIX}comments` ADD `status` VARCHAR( 50 ) NOT NULL AFTER `subscribed` ;
+ALTER TABLE {PREFIX}entries ADD moderate_comments BOOLEAN NOT NULL;
+ALTER TABLE {PREFIX}comments ADD status varchar(50) not null;
UPDATE {PREFIX}comments SET status = 'approved';
Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -d -r1.15 -r1.16
--- db.sql 14 Jul 2004 02:45:37 -0000 1.15
+++ db.sql 17 Jul 2004 12:01:01 -0000 1.16
@@ -38,7 +38,8 @@
ip varchar(15) default null,
body text,
type varchar(100) default 'regular',
- subscribed {BOOLEAN}
+ subscribed {BOOLEAN},
+ status varchar(50) not null
);
CREATE {FULLTEXT} INDEX body on {PREFIX}comments (body);
@@ -60,7 +61,8 @@
authorid int(11) default null,
isdraft {BOOLEAN},
allow_comments {BOOLEAN},
- last_modified int(10) {UNSIGNED} default null
+ last_modified int(10) {UNSIGNED} default null,
+ moderate_comments {BOOLEAN}
);
CREATE {FULLTEXT} INDEX entry on {PREFIX}entries (title,body,extended);
|
