|
From: Joe S. <joe...@us...> - 2002-05-23 18:38:56
|
Update of /cvsroot/phpslash/phpslash-ft/tables/0.7
In directory usw-pr-cvs1:/tmp/cvs-serv22933/phpslash-ft/tables/0.7
Added Files:
65_to_7.sql slash-all.sql
Log Message:
Permission Groups
--- NEW FILE: 65_to_7.sql ---
# ALTER TABLE psl_story ADD story_options TEXT;
# ALTER TABLE psl_section ADD section_options TEXT;
# ALTER TABLE psl_author ADD author_options TEXT;
INSERT INTO db_sequence VALUES ('psl_permission_seq',80);
INSERT INTO db_sequence VALUES ('psl_group_seq',27);
INSERT INTO db_sequence VALUES ('psl_group_section_lut_seq',66);
INSERT INTO db_sequence VALUES ('psl_group_permission_lut_seq',109);
INSERT INTO db_sequence VALUES ('psl_group_group_lut_seq',64);
INSERT INTO db_sequence VALUES ('psl_author_group_lut_seq',26);
#
# Table structure for table 'psl_group'
#
CREATE TABLE psl_group (
group_id int(10) unsigned NOT NULL default '0',
group_name varchar(60) NOT NULL default '',
group_description text,
PRIMARY KEY (group_id),
UNIQUE KEY group_name (group_name)
) TYPE=MyISAM;
#
# Dumping data for table 'psl_group'
#
INSERT INTO psl_group VALUES (1,'author','administer site authors');
INSERT INTO psl_group VALUES (27,'PublicUserAccount','logged in Public User Account');
INSERT INTO psl_group VALUES (4,'block','Block Admin');
INSERT INTO psl_group VALUES (8,'comment','Comment Admin');
INSERT INTO psl_group VALUES (9,'glossary','Glossary Admin');
INSERT INTO psl_group VALUES (10,'groupAdmin','Group Admin');
INSERT INTO psl_group VALUES (11,'infolog','Infolog Admin');
INSERT INTO psl_group VALUES (12,'mailinglist','Mailing List Admin');
INSERT INTO psl_group VALUES (13,'permissionAdmin','Permission Admin');
INSERT INTO psl_group VALUES (14,'poll','Poll Admin');
INSERT INTO psl_group VALUES (15,'section','Section Admin');
INSERT INTO psl_group VALUES (16,'story','Story Admin');
INSERT INTO psl_group VALUES (17,'submission','Submission Admin');
INSERT INTO psl_group VALUES (18,'topic','Topic Admin');
INSERT INTO psl_group VALUES (19,'variable','Variable Admin');
INSERT INTO psl_group VALUES (20,'nobody','Anon user (not effective)');
INSERT INTO psl_group VALUES (21,'user','logged in user privileges. General users.');
INSERT INTO psl_group VALUES (22,'commentUser','User comment privileges');
INSERT INTO psl_group VALUES (23,'storyeditor','Special extend story editor privileges');
INSERT INTO psl_group VALUES (24,'root','All privileges');
INSERT INTO psl_group VALUES (25,'siteeditor','Site Editor');
#
# Table structure for table 'psl_group_group_lut'
#
CREATE TABLE psl_group_group_lut (
lut_id int(11) unsigned NOT NULL default '0',
group_id int(11) unsigned default NULL,
childgroup_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_group_group_lut'
#
INSERT INTO psl_group_group_lut VALUES (5,2,1);
INSERT INTO psl_group_group_lut VALUES (6,27,20);
INSERT INTO psl_group_group_lut VALUES (7,27,21);
INSERT INTO psl_group_group_lut VALUES (64,24,19);
INSERT INTO psl_group_group_lut VALUES (63,24,21);
INSERT INTO psl_group_group_lut VALUES (62,24,18);
INSERT INTO psl_group_group_lut VALUES (61,24,17);
INSERT INTO psl_group_group_lut VALUES (60,24,23);
INSERT INTO psl_group_group_lut VALUES (59,24,16);
INSERT INTO psl_group_group_lut VALUES (58,24,25);
INSERT INTO psl_group_group_lut VALUES (57,24,15);
INSERT INTO psl_group_group_lut VALUES (56,24,14);
INSERT INTO psl_group_group_lut VALUES (55,24,13);
INSERT INTO psl_group_group_lut VALUES (54,24,20);
INSERT INTO psl_group_group_lut VALUES (53,24,12);
INSERT INTO psl_group_group_lut VALUES (52,24,11);
INSERT INTO psl_group_group_lut VALUES (51,24,10);
INSERT INTO psl_group_group_lut VALUES (50,24,9);
INSERT INTO psl_group_group_lut VALUES (49,24,22);
INSERT INTO psl_group_group_lut VALUES (48,24,8);
INSERT INTO psl_group_group_lut VALUES (47,24,4);
INSERT INTO psl_group_group_lut VALUES (46,24,1);
#
# Table structure for table 'psl_group_permission_lut'
#
CREATE TABLE psl_group_permission_lut (
lut_id int(11) unsigned NOT NULL default '0',
group_id int(11) unsigned default NULL,
permission_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_group_permission_lut'
#
INSERT INTO psl_group_permission_lut VALUES (10,1,50);
INSERT INTO psl_group_permission_lut VALUES (9,1,47);
INSERT INTO psl_group_permission_lut VALUES (8,1,49);
INSERT INTO psl_group_permission_lut VALUES (7,1,48);
INSERT INTO psl_group_permission_lut VALUES (6,1,45);
INSERT INTO psl_group_permission_lut VALUES (11,1,46);
INSERT INTO psl_group_permission_lut VALUES (19,2,49);
INSERT INTO psl_group_permission_lut VALUES (20,4,35);
INSERT INTO psl_group_permission_lut VALUES (21,4,38);
INSERT INTO psl_group_permission_lut VALUES (22,4,39);
INSERT INTO psl_group_permission_lut VALUES (23,4,37);
INSERT INTO psl_group_permission_lut VALUES (24,4,36);
INSERT INTO psl_group_permission_lut VALUES (25,8,7);
INSERT INTO psl_group_permission_lut VALUES (26,8,9);
INSERT INTO psl_group_permission_lut VALUES (27,8,4);
INSERT INTO psl_group_permission_lut VALUES (28,8,6);
INSERT INTO psl_group_permission_lut VALUES (29,8,3);
INSERT INTO psl_group_permission_lut VALUES (30,8,8);
INSERT INTO psl_group_permission_lut VALUES (31,8,5);
INSERT INTO psl_group_permission_lut VALUES (32,9,56);
INSERT INTO psl_group_permission_lut VALUES (33,9,59);
INSERT INTO psl_group_permission_lut VALUES (34,9,60);
INSERT INTO psl_group_permission_lut VALUES (35,9,58);
INSERT INTO psl_group_permission_lut VALUES (36,9,57);
INSERT INTO psl_group_permission_lut VALUES (37,10,20);
INSERT INTO psl_group_permission_lut VALUES (38,10,23);
INSERT INTO psl_group_permission_lut VALUES (39,10,24);
INSERT INTO psl_group_permission_lut VALUES (40,10,22);
INSERT INTO psl_group_permission_lut VALUES (41,10,21);
INSERT INTO psl_group_permission_lut VALUES (42,11,66);
INSERT INTO psl_group_permission_lut VALUES (43,11,69);
INSERT INTO psl_group_permission_lut VALUES (44,11,70);
INSERT INTO psl_group_permission_lut VALUES (45,11,68);
INSERT INTO psl_group_permission_lut VALUES (46,11,67);
INSERT INTO psl_group_permission_lut VALUES (47,12,61);
INSERT INTO psl_group_permission_lut VALUES (48,12,64);
INSERT INTO psl_group_permission_lut VALUES (49,12,65);
INSERT INTO psl_group_permission_lut VALUES (50,12,63);
INSERT INTO psl_group_permission_lut VALUES (51,12,62);
INSERT INTO psl_group_permission_lut VALUES (52,13,25);
INSERT INTO psl_group_permission_lut VALUES (53,13,28);
INSERT INTO psl_group_permission_lut VALUES (54,13,29);
INSERT INTO psl_group_permission_lut VALUES (55,13,27);
INSERT INTO psl_group_permission_lut VALUES (56,13,26);
INSERT INTO psl_group_permission_lut VALUES (57,14,40);
INSERT INTO psl_group_permission_lut VALUES (58,14,43);
INSERT INTO psl_group_permission_lut VALUES (59,14,44);
INSERT INTO psl_group_permission_lut VALUES (60,14,42);
INSERT INTO psl_group_permission_lut VALUES (61,14,41);
INSERT INTO psl_group_permission_lut VALUES (62,15,30);
INSERT INTO psl_group_permission_lut VALUES (63,15,33);
INSERT INTO psl_group_permission_lut VALUES (64,15,34);
INSERT INTO psl_group_permission_lut VALUES (65,15,32);
INSERT INTO psl_group_permission_lut VALUES (66,15,31);
INSERT INTO psl_group_permission_lut VALUES (67,16,78);
INSERT INTO psl_group_permission_lut VALUES (68,16,77);
INSERT INTO psl_group_permission_lut VALUES (69,16,71);
INSERT INTO psl_group_permission_lut VALUES (70,16,79);
INSERT INTO psl_group_permission_lut VALUES (71,16,74);
INSERT INTO psl_group_permission_lut VALUES (72,16,76);
INSERT INTO psl_group_permission_lut VALUES (73,16,75);
INSERT INTO psl_group_permission_lut VALUES (74,16,80);
INSERT INTO psl_group_permission_lut VALUES (75,16,73);
INSERT INTO psl_group_permission_lut VALUES (76,16,72);
INSERT INTO psl_group_permission_lut VALUES (77,17,10);
INSERT INTO psl_group_permission_lut VALUES (78,17,13);
INSERT INTO psl_group_permission_lut VALUES (79,17,14);
INSERT INTO psl_group_permission_lut VALUES (80,17,12);
INSERT INTO psl_group_permission_lut VALUES (81,17,11);
INSERT INTO psl_group_permission_lut VALUES (82,18,15);
INSERT INTO psl_group_permission_lut VALUES (83,18,18);
INSERT INTO psl_group_permission_lut VALUES (84,18,19);
INSERT INTO psl_group_permission_lut VALUES (85,18,17);
INSERT INTO psl_group_permission_lut VALUES (86,18,16);
INSERT INTO psl_group_permission_lut VALUES (87,19,51);
INSERT INTO psl_group_permission_lut VALUES (88,19,54);
INSERT INTO psl_group_permission_lut VALUES (89,19,55);
INSERT INTO psl_group_permission_lut VALUES (90,19,53);
INSERT INTO psl_group_permission_lut VALUES (91,19,52);
INSERT INTO psl_group_permission_lut VALUES (92,20,4);
INSERT INTO psl_group_permission_lut VALUES (93,20,6);
INSERT INTO psl_group_permission_lut VALUES (94,20,3);
INSERT INTO psl_group_permission_lut VALUES (95,20,5);
INSERT INTO psl_group_permission_lut VALUES (96,21,4);
INSERT INTO psl_group_permission_lut VALUES (97,21,6);
INSERT INTO psl_group_permission_lut VALUES (98,21,3);
INSERT INTO psl_group_permission_lut VALUES (99,21,5);
INSERT INTO psl_group_permission_lut VALUES (100,22,4);
INSERT INTO psl_group_permission_lut VALUES (101,22,6);
INSERT INTO psl_group_permission_lut VALUES (102,22,3);
INSERT INTO psl_group_permission_lut VALUES (103,22,5);
INSERT INTO psl_group_permission_lut VALUES (104,23,78);
INSERT INTO psl_group_permission_lut VALUES (105,23,77);
INSERT INTO psl_group_permission_lut VALUES (106,23,79);
INSERT INTO psl_group_permission_lut VALUES (107,23,76);
INSERT INTO psl_group_permission_lut VALUES (108,23,80);
#
# Table structure for table 'psl_group_section_lut'
#
CREATE TABLE psl_group_section_lut (
lut_id int(11) unsigned NOT NULL default '0',
group_id int(11) unsigned default NULL,
section_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_group_section_lut'
#
INSERT INTO psl_group_section_lut VALUES (17,1,4);
INSERT INTO psl_group_section_lut VALUES (16,1,3);
INSERT INTO psl_group_section_lut VALUES (15,1,5);
INSERT INTO psl_group_section_lut VALUES (14,1,8);
INSERT INTO psl_group_section_lut VALUES (39,2,4);
INSERT INTO psl_group_section_lut VALUES (19,3,0);
INSERT INTO psl_group_section_lut VALUES (38,2,3);
INSERT INTO psl_group_section_lut VALUES (37,2,5);
INSERT INTO psl_group_section_lut VALUES (40,4,0);
INSERT INTO psl_group_section_lut VALUES (41,5,0);
INSERT INTO psl_group_section_lut VALUES (42,6,0);
INSERT INTO psl_group_section_lut VALUES (43,7,0);
INSERT INTO psl_group_section_lut VALUES (44,8,0);
INSERT INTO psl_group_section_lut VALUES (45,9,0);
INSERT INTO psl_group_section_lut VALUES (46,10,0);
INSERT INTO psl_group_section_lut VALUES (47,11,0);
INSERT INTO psl_group_section_lut VALUES (48,12,0);
INSERT INTO psl_group_section_lut VALUES (49,13,0);
INSERT INTO psl_group_section_lut VALUES (50,14,0);
INSERT INTO psl_group_section_lut VALUES (51,15,0);
INSERT INTO psl_group_section_lut VALUES (52,16,0);
INSERT INTO psl_group_section_lut VALUES (53,17,0);
INSERT INTO psl_group_section_lut VALUES (54,18,0);
INSERT INTO psl_group_section_lut VALUES (55,19,0);
INSERT INTO psl_group_section_lut VALUES (56,20,0);
INSERT INTO psl_group_section_lut VALUES (57,21,0);
INSERT INTO psl_group_section_lut VALUES (58,22,0);
INSERT INTO psl_group_section_lut VALUES (59,23,0);
INSERT INTO psl_group_section_lut VALUES (66,24,0);
INSERT INTO psl_group_section_lut VALUES (61,25,0);
INSERT INTO psl_group_section_lut VALUES (62,26,0);
INSERT INTO psl_group_section_lut VALUES (63,27,0);
#
# Table structure for table 'psl_permission'
#
CREATE TABLE psl_permission (
permission_id int(10) unsigned NOT NULL default '0',
permission_name varchar(60) NOT NULL default '',
permission_description text,
PRIMARY KEY (permission_id),
UNIQUE KEY permission_name (permission_name)
) TYPE=MyISAM;
#
# Dumping data for table 'psl_permission'
#
INSERT INTO psl_permission VALUES (3,'commentShow','can see comments');
INSERT INTO psl_permission VALUES (4,'commentPost','can post comments');
INSERT INTO psl_permission VALUES (5,'commentView','can preview? comments?');
INSERT INTO psl_permission VALUES (6,'commentSave','can edit comments?');
INSERT INTO psl_permission VALUES (7,'commentDelete','can delete comments');
INSERT INTO psl_permission VALUES (8,'commentUpdate','can moderate comments');
INSERT INTO psl_permission VALUES (9,'commentEdit','can edit comments');
INSERT INTO psl_permission VALUES (10,'submissionDelete','can delete submissions');
INSERT INTO psl_permission VALUES (11,'submissionSave','can save submissions');
INSERT INTO psl_permission VALUES (12,'submissionNew','can submit a story');
INSERT INTO psl_permission VALUES (13,'submissionEdit','can edit submissions');
INSERT INTO psl_permission VALUES (14,'submissioneditasstory','can post submissions as stories');
INSERT INTO psl_permission VALUES (15,'topicDelete','can delete topics');
INSERT INTO psl_permission VALUES (16,'topicSave','can save topics');
INSERT INTO psl_permission VALUES (17,'topicNew','can create new topics');
INSERT INTO psl_permission VALUES (18,'topicEdit','can update topics');
INSERT INTO psl_permission VALUES (19,'topicList','get lists of topics');
INSERT INTO psl_permission VALUES (20,'groupDelete','can delete groups');
INSERT INTO psl_permission VALUES (21,'groupSave','can save groups');
INSERT INTO psl_permission VALUES (22,'groupNew','can create groups');
INSERT INTO psl_permission VALUES (23,'groupEdit','can edit groups');
INSERT INTO psl_permission VALUES (24,'groupList','can list groups');
INSERT INTO psl_permission VALUES (25,'permissionDelete','can delete permissions');
INSERT INTO psl_permission VALUES (26,'permissionSave','can save permissions');
INSERT INTO psl_permission VALUES (27,'permissionNew','can create permissions');
INSERT INTO psl_permission VALUES (28,'permissionEdit','can edit permissions');
INSERT INTO psl_permission VALUES (29,'permissionList','can list permissions');
INSERT INTO psl_permission VALUES (30,'sectionDelete','delete sections');
INSERT INTO psl_permission VALUES (31,'sectionSave','save sections');
INSERT INTO psl_permission VALUES (32,'sectionNew','create sections');
INSERT INTO psl_permission VALUES (33,'sectionEdit','update sections');
INSERT INTO psl_permission VALUES (34,'sectionList','list sections');
INSERT INTO psl_permission VALUES (35,'blockDelete','delete blocks');
INSERT INTO psl_permission VALUES (36,'blockPut','save blocks');
INSERT INTO psl_permission VALUES (37,'blockNew','create blocks');
INSERT INTO psl_permission VALUES (38,'blockEdit','update a block');
INSERT INTO psl_permission VALUES (39,'blockList','list all blocks');
INSERT INTO psl_permission VALUES (40,'pollDelete','delete polls');
INSERT INTO psl_permission VALUES (41,'pollPut','save a poll');
INSERT INTO psl_permission VALUES (42,'pollNew','create a poll');
INSERT INTO psl_permission VALUES (43,'pollEdit','edit polls');
INSERT INTO psl_permission VALUES (44,'pollList','list all polls');
INSERT INTO psl_permission VALUES (45,'authorDelete','delete a user');
INSERT INTO psl_permission VALUES (46,'authorSave','save user info');
INSERT INTO psl_permission VALUES (47,'authorNew','create a user');
INSERT INTO psl_permission VALUES (48,'authorEdit','update user info');
INSERT INTO psl_permission VALUES (49,'authorList','list all authors');
INSERT INTO psl_permission VALUES (50,'authorprofileSave','update your own info');
INSERT INTO psl_permission VALUES (51,'variableDelete','delete a Variable');
INSERT INTO psl_permission VALUES (52,'variableSave','save a variable');
INSERT INTO psl_permission VALUES (53,'variableNew','create a variable');
INSERT INTO psl_permission VALUES (54,'variableEdit','edit a variable');
INSERT INTO psl_permission VALUES (55,'variableList','list all variables');
INSERT INTO psl_permission VALUES (56,'glossaryDelete','delete a glossary entry');
INSERT INTO psl_permission VALUES (57,'glossarySave','save a glossary entry');
INSERT INTO psl_permission VALUES (58,'glossaryNew','create a glossary entry');
INSERT INTO psl_permission VALUES (59,'glossaryEdit','update a glossary entry');
INSERT INTO psl_permission VALUES (60,'glossaryList','list all glossary entries');
INSERT INTO psl_permission VALUES (61,'mailinglistDelete','delete a list member');
INSERT INTO psl_permission VALUES (62,'mailinglistSave','save list member address');
INSERT INTO psl_permission VALUES (63,'mailinglistNew','new member form');
INSERT INTO psl_permission VALUES (64,'mailinglistEdit','update form');
INSERT INTO psl_permission VALUES (65,'mailinglistList','list all members');
INSERT INTO psl_permission VALUES (66,'infologDelete','delete a log entry');
INSERT INTO psl_permission VALUES (67,'infologSave','save a log entry');
INSERT INTO psl_permission VALUES (68,'infologNew','create a log entry');
INSERT INTO psl_permission VALUES (69,'infologEdit','change a log entry?');
INSERT INTO psl_permission VALUES (70,'infologList','display the infolog');
INSERT INTO psl_permission VALUES (71,'storyDelete','delete a story');
INSERT INTO psl_permission VALUES (72,'storySave','save a story');
INSERT INTO psl_permission VALUES (73,'storyNew','new story form');
INSERT INTO psl_permission VALUES (74,'storyEdit','edit story form');
INSERT INTO psl_permission VALUES (75,'storyList','list stories');
INSERT INTO psl_permission VALUES (76,'storyeditothers','edit other authors stories');
INSERT INTO psl_permission VALUES (77,'storychangedate','can change date of stories');
INSERT INTO psl_permission VALUES (78,'storychangeauthor','can change the author of the story');
INSERT INTO psl_permission VALUES (79,'storydeleteothers','can delete other author's stories');
INSERT INTO psl_permission VALUES (80,'storylistothers','story list contains other author's stories');
--- NEW FILE: slash-all.sql ---
# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : authperm
# --------------------------------------------------------
#
# Table structure for table 'active_sessions'
#
CREATE TABLE active_sessions (
sid varchar(32) NOT NULL,
name varchar(32) NOT NULL,
val text,
changed varchar(14) NOT NULL,
PRIMARY KEY (name, sid),
KEY changed (changed)
);
[...1165 lines suppressed...]
#
# Dumping data for table 'psl_variable'
#
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '3', 'poll_currentquestionid', '18', 'The Current Question on the homepage pollbooth', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '57', 'article_nextprevlinks', '0', 'Adds next/prev links when viewing an article, but also requires a FULL TABLE SCAN.', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '40', 'site_name', 'PHPSlash', 'This is the name of the website', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '41', 'site_title', 'PHPSlash: Another title', 'Title for the website', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '43', 'site_slogan', 'News for nerds in templates that matter!', 'Web Site Slogan', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '49', 'site_logosmall', '', 'small logo', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '50', 'site_owner', 'web...@ph...', 'email address of the siteowner', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '60', 'article_updatehits', '1', 'If you want to keep track of the number of hits on an article, set this to true. REQUIRES AN UPDATE FOR EACH ARTICLE VIEW', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '59', 'block_optioncount', '4', 'the number of options for the block.', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '58', 'search_maxresults', '20', 'The maximum number of search results in the search page.', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '55', 'comment_defaultmode', 'nested', 'The default mode for displaying comments (flat, thread, nested, index)', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '61', 'submission_autodelete', '0', 'Deletes the submission *instantly* after clicking on the', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '62', 'site_homesection', 'Home', 'this section
appears on the main index page.', '');
INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES ( '63', 'mailinglist_subject', 'Slash list', 'The Subject for the mailing list newsletters', '');
|
