[php-blog-cvs] serendipity/sql db_update_0.8-alpha1_0.8-alpha2_mysql.sql,NONE,1.1.2.1 db.sql,1.18,1.18.2.1

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

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

Modified Files:
      Tag: branch-smarty
	db.sql 
Added Files:
      Tag: branch-smarty
	db_update_0.8-alpha1_0.8-alpha2_mysql.sql 
Log Message:
see NEWS entry - entry properties for more plugin power :)


Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db.sql,v
retrieving revision 1.18
retrieving revision 1.18.2.1
diff -u -d -r1.18 -r1.18.2.1
--- db.sql	28 Jul 2004 16:39:48 -0000	1.18
+++ db.sql	21 Sep 2004 20:43:16 -0000	1.18.2.1
@@ -179,3 +179,12 @@
 );
 
 CREATE UNIQUE INDEX entryid ON {PREFIX}entrycat (entryid, categoryid);
+
+create table {PREFIX}entryproperties (
+  entryid int(11) not null,
+  property varchar(255) not null,
+  value text
+);
+
+CREATE INDEX entryid ON {PREFIX}entryproperties (entryid);
+CREATE UNIQUE INDEX prop ON {PREFIX}entryproperties (entryid, property);

--- NEW FILE: db_update_0.8-alpha1_0.8-alpha2_mysql.sql ---
create table {PREFIX}entryproperties (
  entryid int(11) not null,
  property varchar(255) not null,
  value text
);

CREATE UNIQUE INDEX prop ON {PREFIX}entryproperties (entryid, property);
CREATE INDEX entryid ON {PREFIX}entryproperties (entryid);