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