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