[php-blog-cvs] serendipity/sql db.sql,1.15,1.16 db_update_0.6.6_0.6.7_postgres.sql,1.1,1.2

[Garvin H. <gar...@us...>]

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);