[Tikiwiki-cvs] tiki/db tiki_1.8to1.9.sql,1.79.2.43,1.79.2.44

[<dam...@us...>]

Update of /cvsroot/tikiwiki/tiki/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11842

Modified Files:
      Tag: BRANCH-1-9
	tiki_1.8to1.9.sql 
Log Message:
upgrade script for tiki_projects_preferences

Index: tiki_1.8to1.9.sql
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/db/tiki_1.8to1.9.sql,v
retrieving revision 1.79.2.43
retrieving revision 1.79.2.44
diff -u -d -r1.79.2.43 -r1.79.2.44
--- tiki_1.8to1.9.sql	24 Oct 2004 13:34:55 -0000	1.79.2.43
+++ tiki_1.8to1.9.sql	24 Oct 2004 22:32:07 -0000	1.79.2.44
@@ -795,3 +795,10 @@
 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
 		
 INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('https','auto');
+
+CREATE TABLE tiki_projects_preferences;
+  preferenceId int(10) NOT NULL auto_increment,
+  projectId int(10) NOT NULL default '0',
+  name varchar(40) NOT NULL,
+  value varchar(250) default NULL
+) TYPE=MyISAM AUTO_INCREMENT=1 ;