[Upcase-project-cvs] UpCase/config uc_tables.inc,1.4,1.5

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

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

Modified Files:
	uc_tables.inc 
Log Message:
added tables for installer, package manifests, variables


Index: uc_tables.inc
===================================================================
RCS file: /cvsroot/upcase-project/UpCase/config/uc_tables.inc,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** uc_tables.inc	13 Nov 2002 09:17:51 -0000	1.4
--- uc_tables.inc	5 Dec 2002 10:17:35 -0000	1.5
***************
*** 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 '',
--- 12,15 ----
***************
*** 51,60 ****
    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');",
! "INSERT INTO ${tblprefix}permissions VALUES ('menu', '1');",
! "INSERT INTO ${tblprefix}permissions VALUES ('mainIndex', '1');",
! "INSERT INTO ${tblprefix}permissions VALUES ('mainPage', '1');"
  );
  
--- 42,74 ----
    UNIQUE KEY username (username)
  ) TYPE=MyISAM;",
! "CREATE TABLE ${tblprefix}vars (
!   name varchar(255) NOT NULL default '',
!   value varchar(255) NOT NULL default ''
! ) TYPE=MyISAM;",
! "CREATE TABLE ${tblprefix}installer (
!   appid int(4) NOT NULL auto_increment,
!   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',
!   PRIMARY KEY  (appid),
!   UNIQUE KEY tblprefix (tblprefix),
!   UNIQUE KEY pkgpath (pkgpath)
! ) TYPE=MyISAM;",
! "CREATE TABLE ${tblprefix}files (
!   appid int(4) NOT NULL default '0',
!   type enum('R','D') NOT NULL default 'R',
!   filename blob NOT NULL,
!   checksum int(4) NOT NULL default '0',
!   mtime timestamp(14) NOT NULL,
!   mode int(1) NOT NULL default '0'	  
! ) TYPE=MyISAM;",
! "INSERT INTO ${tblprefix}groups VALUES ('" . ADMINS_GID . "','admins');",
! "INSERT INTO ${tblprefix}groups VALUES ('" . ALL_GID . "','all');",
! "INSERT INTO ${tblprefix}permissions VALUES ('menu', '". ALL_GID . "');",
! "INSERT INTO ${tblprefix}permissions VALUES ('mainIndex', '" . ALL_GID . "');",
! "INSERT INTO ${tblprefix}permissions VALUES ('mainPage', '" . ALL_GID . "');",
! "INSERT INTO ${tblprefix}vars VALUES ('home_page', 'upcase/conditions.html');"
  );