[Upcase-project-cvs] UpCase/config uc_tables.inc,1.1.1.1,1.2

[<jhe...@us...>]

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');",
  );