[Tikiwiki-cvs] tiki/db tiki-1.8-mysql.sql,1.9,1.10 tiki-1.8-oci8.sql,1.8,1.9 tiki-1.8-pgsql.sql,1.8,1.9 tiki-1.8-sybase.sql,1.10,1.11 tiki.sql,1.63,1.64

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

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

Modified Files:
	tiki-1.8-mysql.sql tiki-1.8-oci8.sql tiki-1.8-pgsql.sql 
	tiki-1.8-sybase.sql tiki.sql 
Log Message:
fix for oracle
the value column seems not to be used for now. why then NOT NULL?


Index: tiki-1.8-mysql.sql
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.8-mysql.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- tiki-1.8-mysql.sql	16 Oct 2003 22:26:03 -0000	1.9
+++ tiki-1.8-mysql.sql	18 Oct 2003 16:35:09 -0000	1.10
@@ -3243,7 +3243,7 @@
 CREATE TABLE users_grouppermissions (
   groupName varchar(30) NOT NULL default '',
   permName varchar(30) NOT NULL default '',
-  value char(1) NOT NULL default '',
+  value char(1) default '',
   PRIMARY KEY  (groupName,permName)
 ) TYPE=MyISAM;
 # --------------------------------------------------------

Index: tiki-1.8-oci8.sql
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.8-oci8.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- tiki-1.8-oci8.sql	16 Oct 2003 22:26:03 -0000	1.8
+++ tiki-1.8-oci8.sql	18 Oct 2003 16:35:09 -0000	1.9
@@ -4493,7 +4493,7 @@
 CREATE TABLE "users_grouppermissions" (
   "groupName" varchar(30) default '' NOT NULL,
   "permName" varchar(30) default '' NOT NULL,
-  "value" char(1) default '' NOT NULL,
+  "value" char(1) default '',
   PRIMARY KEY ("groupName","permName")
 ) ;
 

Index: tiki-1.8-pgsql.sql
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.8-pgsql.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- tiki-1.8-pgsql.sql	16 Oct 2003 22:26:03 -0000	1.8
+++ tiki-1.8-pgsql.sql	18 Oct 2003 16:35:09 -0000	1.9
@@ -3941,7 +3941,7 @@
 CREATE TABLE "users_grouppermissions" (
   "groupName" varchar(30) NOT NULL default '',
   "permName" varchar(30) NOT NULL default '',
-  "value" char(1) NOT NULL default '',
+  "value" char(1) default '',
   PRIMARY KEY ("groupName","permName")
 ) ;
 

Index: tiki-1.8-sybase.sql
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/db/tiki-1.8-sybase.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- tiki-1.8-sybase.sql	16 Oct 2003 22:26:03 -0000	1.10
+++ tiki-1.8-sybase.sql	18 Oct 2003 16:35:09 -0000	1.11
@@ -4642,7 +4642,7 @@
 CREATE TABLE "users_grouppermissions" (
   "groupName" varchar(30) default '' NOT NULL,
   "permName" varchar(30) default '' NOT NULL,
-  "value" char(1) default '' NOT NULL,
+  "value" char(1) default '',
   PRIMARY KEY ("groupName","permName")
 ) 
 go

Index: tiki.sql
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/db/tiki.sql,v
retrieving revision 1.63
retrieving revision 1.64
diff -u -d -r1.63 -r1.64
--- tiki.sql	16 Oct 2003 22:26:03 -0000	1.63
+++ tiki.sql	18 Oct 2003 16:35:09 -0000	1.64
@@ -3243,7 +3243,7 @@
 CREATE TABLE users_grouppermissions (
   groupName varchar(30) NOT NULL default '',
   permName varchar(30) NOT NULL default '',
-  value char(1) NOT NULL default '',
+  value char(1) default '',
   PRIMARY KEY  (groupName,permName)
 ) TYPE=MyISAM;
 # --------------------------------------------------------