CVS: phpwiki/schemas mysql.sql,1.4,1.5

Update of /cvsroot/phpwiki/phpwiki/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1076/schemas

Modified Files:
        mysql.sql 
Log Message:
added new tables to mysql schema
fixed default DBAUthParam samples to match these
added group constants (look terrible, I'd prefer strings instead of constants)


Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/schemas/mysql.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -2 -b -p -d -r1.4 -r1.5
--- mysql.sql   4 Mar 2003 05:26:49 -0000       1.4
+++ mysql.sql   27 Jan 2004 23:25:51 -0000      1.5
@@ -48,7 +48,30 @@ CREATE TABLE link (
 drop table if exists session;
 CREATE TABLE session (
-    sess_id varchar(32) not null default '',
-    sess_data blob not null,
+       sess_id         VARCHAR(32) NOT NULL DEFAULT '',
+       sess_data       BLOB NOT NULL,
     sess_date INT UNSIGNED NOT NULL,
     PRIMARY KEY (sess_id)
 );
+
+-- don't know if the pref table can hold the password. (it's stored there)
+drop table if exists pref;
+CREATE TABLE pref (
+       userid  CHAR(48) BINARY NOT NULL UNIQUE,
+       prefs   TEXT NULL DEFAULT '',
+       PRIMARY KEY (userid)
+) TYPE=MyISAM;
+
+drop table if exists user;
+CREATE TABLE user (
+       userid  CHAR(48) BINARY NOT NULL UNIQUE,
+       passwd  CHAR(48) BINARY DEFAULT '',
+--     groupname CHAR(48) BINARY DEFAULT 'users',
+       PRIMARY KEY (userid)
+) TYPE=MyISAM;
+
+CREATE TABLE member (
+       userid    CHAR(48) BINARY NOT NULL,
+       groupname CHAR(48) BINARY NOT NULL DEFAULT 'users',
+       INDEX (userid),
+       INDEX (groupname)
+) TYPE=MyISAM;



-------------------------------------------------------
The SF.Net email is sponsored by EclipseCon 2004
Premiere Conference on Open Tools Development and Integration
See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
http://www.eclipsecon.org/osdn