Update of /cvsroot/phpslash/phpslash-ft/tables/0.7
In directory usw-pr-cvs1:/tmp/cvs-serv4222/0.7
Modified Files:
65_to_7.sql
Log Message:
Permission Groups
Index: 65_to_7.sql
===================================================================
RCS file: /cvsroot/phpslash/phpslash-ft/tables/0.7/65_to_7.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** 65_to_7.sql 23 May 2002 18:38:53 -0000 1.1
--- 65_to_7.sql 23 May 2002 19:21:28 -0000 1.2
***************
*** 8,11 ****
--- 8,27 ----
INSERT INTO db_sequence VALUES ('psl_group_group_lut_seq',64);
INSERT INTO db_sequence VALUES ('psl_author_group_lut_seq',26);
+
+ CREATE TABLE psl_author_group_lut (
+ lut_id int(11) unsigned NOT NULL default '0',
+ author_id int(11) unsigned default NULL,
+ group_id int(11) unsigned default NULL,
+ UNIQUE KEY lut_id_2 (lut_id),
+ KEY lut_id (lut_id)
+ ) TYPE=MyISAM;
+
+ #
+ # Dumping data for table 'psl_author_group_lut'
+ #
+
+ INSERT INTO psl_author_group_lut VALUES (26,1,24);
+
+
#
# Table structure for table 'psl_group'
|
