Update of /cvsroot/upcase-project/UpCase/config
In directory usw-pr-cvs1:/tmp/cvs-serv11126
Modified Files:
uc_tables.inc
Log Message:
corrected tables script creation, add a default user admin
Index: uc_tables.inc
===================================================================
RCS file: /cvsroot/upcase-project/UpCase/config/uc_tables.inc,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** uc_tables.inc 16 Jul 2002 15:32:14 -0000 1.1.1.1
--- uc_tables.inc 8 Aug 2002 10:00:42 -0000 1.2
***************
*** 1,27 ****
<?php
! $tables = array(
! "CREATE TABLE " . $tblprefix . "groupmembers (
gid int(4) default NULL,
uid int(4) default NULL
) TYPE=MyISAM;",
!
! "CREATE TABLE " . $tblprefix . "groups (
gid int(4) NOT NULL auto_increment,
groupname varchar(50) NOT NULL default '',
! PRIMARY KEY (gid)
) TYPE=MyISAM;",
!
! "CREATE TABLE " . $tblprefix . "sessions (
sessid varchar(50) NOT NULL default '',
uid int(4) default NULL,
start_time int(10) default NULL,
! last_access_time int(10) default NULL,
ip varchar(16) default NULL,
logged_in int(4) default '0',
PRIMARY KEY (sessid)
) TYPE=MyISAM;",
!
! "CREATE TABLE " . $tblprefix . "users (
uid int(4) NOT NULL auto_increment,
groupid int(4) NOT NULL default '0',
--- 1,34 ----
<?php
! $tables_create = array(
! "CREATE TABLE ${tblprefix}groupmembers (
gid int(4) default NULL,
uid int(4) default NULL
) TYPE=MyISAM;",
! "CREATE TABLE ${tblprefix}groups (
gid int(4) NOT NULL auto_increment,
groupname varchar(50) NOT NULL default '',
! PRIMARY KEY (gid),
! UNIQUE KEY groupname (groupname)
) TYPE=MyISAM;",
! "CREATE TABLE ${tblprefix}permissions (
! oid varchar(50) NOT NULL default '',
! gid int(4) default NULL
! ) TYPE=MyISAM;",
! "CREATE TABLE ${tblprefix}session_data (
! sessid varchar(50) NOT NULL default '',
! data text,
! PRIMARY KEY (sessid)
! ) TYPE=MyISAM;",
! "CREATE TABLE ${tblprefix}sessions (
sessid varchar(50) NOT NULL default '',
uid int(4) default NULL,
start_time int(10) default NULL,
! expiry int(10) default NULL,
ip varchar(16) default NULL,
logged_in int(4) default '0',
PRIMARY KEY (sessid)
) TYPE=MyISAM;",
! "CREATE TABLE ${tblprefix}users (
uid int(4) NOT NULL auto_increment,
groupid int(4) NOT NULL default '0',
***************
*** 29,34 ****
password varchar(50) NOT NULL default '',
preferred_lang char(2) default NULL,
! PRIMARY KEY (uid)
! ) TYPE=MyISAM;"
);
--- 36,50 ----
password varchar(50) NOT NULL default '',
preferred_lang char(2) default NULL,
! PRIMARY KEY (uid),
! UNIQUE KEY username (username)
! ) TYPE=MyISAM;",
! );
!
!
! $tables_insert = array(
! "INSERT INTO ${tblprefix}groups VALUES (0,'admins');",
! "UPDATE ${tblprefix}groups SET gid='0' WHERE groupname='admins';",
! "INSERT INTO ${tblprefix}groups VALUES (-1,'all');",
! "INSERT INTO ${tblprefix}users VALUES (1,0,'admin','admin','en');",
);
|
