[php-blog-cvs] serendipity/sql db_update_0.6.2_0.6.3_mysql.sql,NONE,1.1 db_update_0.6.2_0.6.3_postgres.sql,NONE,1.1 db.sql,1.7,1.8

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

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

Modified Files:
	db.sql 
Added Files:
	db_update_0.6.2_0.6.3_mysql.sql 
	db_update_0.6.2_0.6.3_postgres.sql 
Log Message:
Upgraded image manager: Manage/upload to/sync/browse subdirectories.
Accept non-image files.

DB Layout upgrade needed!


--- NEW FILE: db_update_0.6.2_0.6.3_postgres.sql ---
ALTER TABLE {PREFIX}images ADD COLUMN path text DEFAULT '/';
CREATE {FULLTEXT} INDEX pathkey on {PREFIX}images (path);

--- NEW FILE: db_update_0.6.2_0.6.3_mysql.sql ---
ALTER TABLE {PREFIX}images ADD COLUMN path text;
CREATE {FULLTEXT} INDEX pathkey on {PREFIX}images (path);

Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- db.sql	26 Apr 2004 10:33:21 -0000	1.7
+++ db.sql	25 May 2004 16:16:16 -0000	1.8
@@ -162,5 +162,8 @@
   dimensions_height int(11) not null default '0',
   date int(11) not null default '0',
   thumbnail_name varchar(255) not null default '',
-  authorid int(11) default '0'
+  authorid int(11) default '0',
+  path text
 );
+
+CREATE {FULLTEXT} INDEX pathkey on {PREFIX}images (path);