forked from science-ation/science-ation
17 lines
450 B
SQL
17 lines
450 B
SQL
INSERT INTO `roles` (`roletype`, `rolename`)
|
|
VALUES
|
|
('alumni', 'Alumni'),
|
|
('committee', 'Committee'),
|
|
('fair', 'Fair'),
|
|
('judge', 'Judge'),
|
|
('mentor', 'Mentor'),
|
|
('parent', 'Parent'),
|
|
('principal', 'Principal'),
|
|
('sponsor', 'Sponsor'),
|
|
('student', 'Student'),
|
|
('teacher', 'Teacher'),
|
|
('volunteer', 'Volunteer');
|
|
|
|
ALTER TABLE `accounts` ADD `superuser` ENUM( 'no', 'yes' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'no';
|
|
|