forked from science-ation/science-ation
44 lines
2.3 KiB
SQL
44 lines
2.3 KiB
SQL
CREATE TABLE `rolestasks` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`pid` int(11) NOT NULL,
|
|
`roles_id` int(11) NOT NULL,
|
|
`level` int(11) NOT NULL,
|
|
`task` varchar(64) NOT NULL,
|
|
`ord` int(11) NOT NULL,
|
|
`link` varchar(255) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;
|
|
|
|
INSERT INTO `rolestasks` (`id`, `pid`, `roles_id`, `level`, `task`, `ord`, `link`) VALUES
|
|
(1, 0, 13, 0, 'Configuration', 0, '/config/index.php'),
|
|
(2, 0, 12, 0, 'Administration', 0, '/admin/index.php'),
|
|
(3, 2, 12, 1, 'General Tasks', 2, ''),
|
|
(4, 2, 12, 1, 'People Tasks', 1, ''),
|
|
(5, 2, 12, 1, 'Event Preparation', 3, ''),
|
|
(6, 2, 12, 1, 'Event Wrap-Up', 4, ''),
|
|
(7, 5, 12, 2, 'Awards Management', 0, ''),
|
|
(8, 5, 12, 2, 'Schools Management', 0, ''),
|
|
(9, 5, 12, 2, 'Tour Management', 0, ''),
|
|
(10, 5, 12, 2, 'Report Management', 0, ''),
|
|
(11, 7, 12, 3, 'Awards Editor', 0, '/admin/award_awards.php'),
|
|
(12, 7, 12, 3, 'Sponsors', 0, '/admin/sponsors.php'),
|
|
(13, 4, 12, 2, 'Participant Registration', 0, ''),
|
|
(14, 13, 12, 3, 'Input Received Signature Forms ', 0, '/admin/registration_receivedforms.php'),
|
|
(15, 13, 12, 3, 'Registration List and Student/Project Editor', 0, '/admin/registration_list.php'),
|
|
(16, 13, 12, 3, 'Registration Statistics', 0, '/admin/registration_stats.php'),
|
|
(17, 13, 12, 3, 'Website Consent', 0, '/admin/registration_webconsent.php'),
|
|
(18, 4, 12, 2, 'Committee Management', 2, ''),
|
|
(19, 4, 12, 2, 'Judging Management', 3, ''),
|
|
(20, 4, 12, 2, 'Tour Management', 4, ''),
|
|
(21, 18, 12, 3, 'Committee Management', 0, '/admin/committees.php'),
|
|
(22, 19, 12, 3, 'Invite Judges', 0, '/admin/user_invite.php?type=judge'),
|
|
(23, 19, 12, 3, 'Manage Judges', 2, '/admin/user_list.php?show_types[]=judge'),
|
|
(24, 19, 12, 3, 'Create/Edit Judging Timeslots', 3, '/admin/judges_timeslots.php'),
|
|
(25, 19, 12, 3, 'Create/Edit Divisional Judging Groupings', 4, '/admin/judges_jdiv.php'),
|
|
(26, 19, 12, 3, 'Run the Automatic Judging Scheduler', 5, '/admin/judges_schedulerconfig.php'),
|
|
(27, 19, 12, 3, 'Manage Judging Teams', 6, '/admin/judges_teams.php'),
|
|
(28, 19, 12, 3, 'Manage Judging Team Members', 7, '/admin/judges_teams_members.php'),
|
|
(29, 19, 12, 3, 'Manage Judging Team Timeslot Assignments', 8, '/admin/judges_teams_timeslots.php'),
|
|
(30, 19, 12, 3, 'Manage Judging Team Project Assignments', 9, '/admin/judges_teams_projects.php');
|
|
|