Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7367
Modified Files:
db.sql
Log Message:
Make current CVS install the new table.
"date" is no reserved word in my MySQL-DB. Does it work in postgresql as well? If not, we need to change it to a different word.
Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/db.sql,v
retrieving revision 1.24
retrieving revision 1.25
diff -u -d -r1.24 -r1.25
--- db.sql 13 Oct 2003 12:15:08 -0000 1.24
+++ db.sql 17 Feb 2004 12:20:47 -0000 1.25
@@ -140,3 +140,14 @@
category_description text,
authorid int(11) default NULL
);
+
+CREATE TABLE {PREFIX}images (
+ id {AUTOINCREMENT} {PRIMARY},
+ name varchar(255) not null default '',
+ extension varchar(5) not null default '',
+ mime varchar(15) 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',
+ date int(11) not null default '0'
+);
|
