[php-blog-cvs] serendipity/sql db_update_0.6.8_0.6.9_mysql.sql,NONE,1.1 db_update_0.6.8_0.6.9_postgres.sql,NONE,1.1 db.sql,1.16,1.17

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

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

Modified Files:
	db.sql 
Added Files:
	db_update_0.6.8_0.6.9_mysql.sql 
	db_update_0.6.8_0.6.9_postgres.sql 
Log Message:
changed 'mime' field of serendipity_images to a reasonable limit. 15 chars
was cutting entries like 'application/ms-word' to a wrong string and thus
always re-refreshing it on synchronize-database.
Postgres somehow sucks in changing columns. :(
(DB update bump to 0.6.9)


--- NEW FILE: db_update_0.6.8_0.6.9_mysql.sql ---
ALTER TABLE {PREFIX}images CHANGE mime mime VARCHAR(255) NOT NULL default '';

Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db.sql,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -d -r1.16 -r1.17
--- db.sql	17 Jul 2004 12:01:01 -0000	1.16
+++ db.sql	19 Jul 2004 09:31:52 -0000	1.17
@@ -171,7 +171,7 @@
   id {AUTOINCREMENT} {PRIMARY},
   name varchar(255) not null default '',
   extension varchar(5) not null default '',
-  mime varchar(15) not null default '',
+  mime varchar(255) not null default '',
   size int(11) not null default '0',
   dimensions_width int(11) not null default '0',
   dimensions_height int(11) not null default '0',

--- NEW FILE: db_update_0.6.8_0.6.9_postgres.sql ---
ALTER TABLE {PREFIX}images ADD oldmime varchar(15) not null default '';
UPDATE {PREFIX}images SET oldmime = mime;
ALTER TABLE {PREFIX}images DROP mime;

ALTER TABLE {PREFIX}images ADD mime varchar(255) not null default '';
UPDATE {PREFIX}images SET mime = oldmime;
ALTER TABLE {PREFIX}images DROP oldmime;