[phpBT-dev] CVS: phpbt/schemas mysql.in,1.9,1.10 pgsql.in,1.11,1.12

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv21854/schemas

Modified Files:
	mysql.in pgsql.in 
Log Message:
Group administration

Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- mysql.in	2001/11/06 16:42:05	1.9
+++ mysql.in	2001/12/04 14:32:24	1.10
@@ -27,6 +27,7 @@
 CREATE TABLE TBL_AUTH_GROUP (
   group_id int(10) unsigned NOT NULL default '0',
   group_name varchar(80) NOT NULL default '',
+  locked tinyint(1) unsigned NOT NULL default '0',
   created_by int(10) unsigned NOT NULL default '0',
   created_date bigint(20) unsigned NOT NULL default '0',
   last_modified_by int(10) unsigned NOT NULL default '0',
@@ -246,9 +247,10 @@
 INSERT INTO TBL_DB_SEQUENCE values ('TBL_AUTH_USER', 1);
 
 # Start off with three user levels...
-INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (1, 'Admin');
-INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (2, 'User');
-INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (3, 'Developer');
+INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1);
+INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1);
+INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1);
+INSERT INTO TBL_DB_SEQUENCE values ('TBL_AUTH_GROUP', 3);
 
 # ... and only two permissions 
 INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -r1.11 -r1.12
--- pgsql.in	2001/11/06 16:16:59	1.11
+++ pgsql.in	2001/12/04 14:32:24	1.12
@@ -33,7 +33,8 @@
 CREATE TABLE TBL_AUTH_GROUP (
   group_id INT4  NOT NULL DEFAULT '0',
   group_name varchar(80) NOT NULL DEFAULT '',
-  created_by INT4  NOT NULL DEFAULT '0',
+  locked INT2 NOT NULL DEFAULT 0,
+	created_by INT4  NOT NULL DEFAULT '0',
   created_date INT8  NOT NULL DEFAULT '0',
   last_modified_by INT4  NOT NULL DEFAULT '0',
   last_modified_date INT8  NOT NULL DEFAULT '0',
@@ -248,9 +249,10 @@
 INSERT INTO TBL_DB_SEQUENCE values ('TBL_AUTH_USER', 1);
 
 -- Start off with three user levels...
-INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (1, 'Admin');
-INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (2, 'User');
-INSERT INTO TBL_AUTH_GROUP (group_id, group_name) VALUES (3, 'Developer');
+INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1);
+INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1);
+INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1);
+INSERT INTO TBL_DB_SEQUENCE values ('TBL_AUTH_GROUP', 3);
 
 -- ... and only two permissions 
 INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');