[Tikiwiki-cvs] tiki/db tiki-1.8-mysql.sql,1.15,1.16 tiki-1.8-oci8.sql,1.15,1.16 tiki.sql,1.78,1.79

[<re...@us...>]

Update of /cvsroot/tikiwiki/tiki/db
In directory sc8-pr-cvs1:/tmp/cvs-serv28684/db

Modified Files:
	tiki-1.8-mysql.sql tiki-1.8-oci8.sql tiki.sql 
Log Message:
install issues quick fixes


Index: tiki-1.8-mysql.sql
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.8-mysql.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -d -r1.15 -r1.16
--- tiki-1.8-mysql.sql	29 Oct 2003 01:48:24 -0000	1.15
+++ tiki-1.8-mysql.sql	31 Oct 2003 11:59:41 -0000	1.16
@@ -428,7 +428,7 @@
   postId int(8) NOT NULL auto_increment,
   blogId int(8) NOT NULL default '0',
   data text,
-	data_size int(11) NOT NULL unsigned default '0',
+  data_size int(11) unsigned NOT NULL default '0',
   created int(14) default NULL,
   user varchar(200) default NULL,
   trackbacks_to text,
@@ -1037,6 +1037,13 @@
 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
 # --------------------------------------------------------
 
+
+CREATE TABLE tiki_dynamic_variables (
+  name varchar(40) NOT NULL,
+  DATA text,
+  PRIMARY KEY  (name)
+);
+
 #
 # Table structure for table `tiki_eph`
 #
@@ -3869,5 +3876,4 @@
 INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_modulecontrols', 'y');
 
 # Dynamic variables
-CREATE  TABLE tiki_dynamic_variables( name varchar( 40  ) not null,  DATA text,  PRIMARY  KEY ( name )  );
 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_edit_dynvar', 'Can edit dynamic variables', 'editors', 'wiki');

Index: tiki-1.8-oci8.sql
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.8-oci8.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -d -r1.15 -r1.16
--- tiki-1.8-oci8.sql	31 Oct 2003 11:12:22 -0000	1.15
+++ tiki-1.8-oci8.sql	31 Oct 2003 11:59:41 -0000	1.16
@@ -539,7 +539,7 @@
   "postId" number(8) NOT NULL,
   "blogId" number(8) default '0' NOT NULL,
   "data" clob,
-	data_size number(11) NOT NULL unsigned default '0',
+  "data_size" number(11) default '0' NOT NULL,
   "created" number(14) default NULL,
   "user" varchar(200) default NULL,
   "trackbacks_to" clob,
@@ -1338,6 +1338,13 @@
 /
 
 -- --------------------------------------------------------
+CREATE TABLE "tiki_dynamic_variables" (
+  "name" varchar(40) NOT NULL,
+  "DATA" clob,
+  PRIMARY KEY ("name")
+);
+
+
 --
 -- Table structure for table `tiki_eph`
 --
@@ -2605,7 +2612,7 @@
   "cache_timestamp" number(14) default NULL,
   "pageRank" decimal(4,3) default NULL,
   "creator" varchar(200) default NULL,
-  "page_size" number(10) unsigned default 0,
+  "page_size" number(10) default 0,
   PRIMARY KEY ("pageName")
 ) ;
 
@@ -4744,7 +4751,7 @@
 INSERT INTO "users_users" ("email","login","password","realname","hash") VALUES ('','admin','admin','System Administrator','f6fdffe48c908deb0f4c3bd36c032e72');
 
 
-UPDATE users_users set currentLogin=lastLogin,registrationDate=lastLogin;
+UPDATE "users_users" SET "currentLogin"="lastLogin","registrationDate"="lastLogin";
 
 
 -- --------------------------------------------------------
@@ -5746,9 +5753,6 @@
 
 
 -- Dynamic variables
-CREATE  "TABLE" tiki_dynamic_variables( name varchar( 40  ) not null,  "DATA" clob,  PRIMARY  KEY ( name )  );
-
-
 INSERT INTO "users_permissions" ("permName","permDesc","level","type") VALUES ('tiki_p_edit_dynvar', 'Can edit dynamic variables', 'editors', 'wiki');
 
 

Index: tiki.sql
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/db/tiki.sql,v
retrieving revision 1.78
retrieving revision 1.79
diff -u -d -r1.78 -r1.79
--- tiki.sql	29 Oct 2003 17:10:43 -0000	1.78
+++ tiki.sql	31 Oct 2003 11:59:41 -0000	1.79
@@ -1037,6 +1037,13 @@
 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
 # --------------------------------------------------------
 
+
+CREATE TABLE tiki_dynamic_variables (
+  name varchar(40) NOT NULL,
+  DATA text,
+  PRIMARY KEY  (name)
+);
+
 #
 # Table structure for table `tiki_eph`
 #
@@ -3869,5 +3876,4 @@
 INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_modulecontrols', 'y');
 
 # Dynamic variables
-CREATE  TABLE tiki_dynamic_variables( name varchar( 40  ) not null,  DATA text,  PRIMARY  KEY ( name )  );
 INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_edit_dynvar', 'Can edit dynamic variables', 'editors', 'wiki');