[php-blog-cvs] serendipity db_update-0.5-0.5.1.sql,1.5,1.6

[<jt...@us...>]

Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3660

Modified Files:
	db_update-0.5-0.5.1.sql 
Log Message:
fixed the upgrade script to work with a postgres backend.  This is getting rediculous.

Index: db_update-0.5-0.5.1.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/db_update-0.5-0.5.1.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- db_update-0.5-0.5.1.sql	26 Feb 2004 11:37:42 -0000	1.5
+++ db_update-0.5-0.5.1.sql	29 Feb 2004 00:01:01 -0000	1.6
@@ -1,3 +1,5 @@
+/* Postgres users comment out the following table creating SQL
+   and uncomment the second */
 CREATE TABLE `serendipity_images` (
   `id` int(11) NOT NULL auto_increment,
   `name` varchar(255) NOT NULL default '',
@@ -11,6 +13,19 @@
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM;
 
+/* Postgres users execute the following
+CREATE TABLE serendipity_images (
+  id SERIAL primary key,
+  name varchar(255) NOT NULL default '',
+  extension varchar(5) NOT NULL default '',
+  mime varchar(15) NOT NULL default '',
+  size int NOT NULL default '0',
+  dimensions_width int NOT NULL default '0',
+  dimensions_height int NOT NULL default '0',
+  thumbnail_name varchar(255) NOT NULL default '',
+  date int NOT NULL default '0'
+); */
+
 /*
  If you were using the content_rewrite plugin, you need to execute:
  
@@ -32,7 +47,11 @@
  anywhere you like on the sidebars.
 */
 
+/* This will fail on postgres: comment it out and use the second */
 ALTER TABLE serendipity_entries ADD last_modified INT(10) UNSIGNED default null;
+/* Postgres users:
+ALTER TABLE serendipity_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;
@@ -44,4 +63,4 @@
 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);
\ No newline at end of file
+INSERT INTO serendipity_plugins(name, placement, sort_order) VALUES ('serendipity_event_trackexits:25e6d8eb7d662936abb6454956aaa8ab', 'event', 13);