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

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

Update of /cvsroot/upcase-project/UpCase/config
In directory usw-pr-cvs1:/tmp/cvs-serv10187

Modified Files:
	uc_tables.inc 
Log Message:
added table for installer


Index: uc_tables.inc
===================================================================
RCS file: /cvsroot/upcase-project/UpCase/config/uc_tables.inc,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** uc_tables.inc	8 Aug 2002 10:00:42 -0000	1.2
--- uc_tables.inc	13 Nov 2002 08:58:21 -0000	1.3
***************
*** 1,5 ****
  <?php
  
! $tables_create = array(
  "CREATE TABLE ${tblprefix}groupmembers (
    gid int(4) default NULL,
--- 1,5 ----
  <?php
  
! $queries = array(
  "CREATE TABLE ${tblprefix}groupmembers (
    gid int(4) default NULL,
***************
*** 12,15 ****
--- 12,24 ----
    UNIQUE KEY groupname (groupname)
  ) TYPE=MyISAM;",
+ "CREATE TABLE ${tblprefix}installer (
+ 	pkgname varchar(50) default NULL,
+ 	pkgversion varchar(50) default NULL,
+ 	tblprefix varchar(50) default NULL,
+ 	pkgpath varchar(255) default NULL,
+ 	installed tinyint(1) NOT NULL default '0',
+ 	UNIQUE KEY tblprefix (tblprefix),
+ 	UNIQUE KEY pkgpath (pkgpath)
+ ) TYPE=MyISAM;",
  "CREATE TABLE ${tblprefix}permissions (
    oid varchar(50) NOT NULL default '',
***************
*** 34,50 ****
    groupid int(4) NOT NULL default '0',
    username varchar(50) NOT NULL default '',
    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');",
  );
  
--- 43,57 ----
    groupid int(4) NOT NULL default '0',
    username varchar(50) NOT NULL default '',
+   firstname varchar(50) NOT NULL default '',
+   lastname varchar(50) NOT NULL default '',
    password varchar(50) NOT NULL default '',
    preferred_lang char(2) default NULL,
+   email varchar(50) default NULL,
    PRIMARY KEY  (uid),
    UNIQUE KEY username (username)
  ) TYPE=MyISAM;",
  "INSERT INTO ${tblprefix}groups VALUES (0,'admins');",
  "UPDATE ${tblprefix}groups SET gid='0' WHERE groupname='admins';",
! "INSERT INTO ${tblprefix}groups VALUES (1,'all');",
  );