[Phpslash-commit] CVS: phpslash-ft/tables/0.7 65_to_7.sql,1.1,1.2
Brought to you by:
joestewart,
nhruby
From: Joe S. <joe...@us...> - 2002-05-23 19:21:31
|
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' |