diff options
| author | Michael Foster <savetheinternet@tinyboard.org> | 2013-09-09 01:33:51 +1000 |
|---|---|---|
| committer | Michael Foster <savetheinternet@tinyboard.org> | 2013-09-09 01:33:51 +1000 |
| commit | eea4e42609e319b38f14bca9f31cc3327ffaf175 (patch) | |
| tree | 50eff229bcb7314e6f22837f1046a151adf3ddf7 /install.sql | |
| parent | 9a846d5ad5838d4db824623d9916d6b4e34c29ee (diff) | |
Add ability to create custom user/permissions groups
Diffstat (limited to 'install.sql')
| -rw-r--r-- | install.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/install.sql b/install.sql index 25c0a0f1..1e7a5011 100644 --- a/install.sql +++ b/install.sql @@ -131,7 +131,7 @@ CREATE TABLE IF NOT EXISTS `mods` ( `username` varchar(30) NOT NULL, `password` char(64) CHARACTER SET ascii NOT NULL COMMENT 'SHA256', `salt` char(32) CHARACTER SET ascii NOT NULL, - `type` smallint(1) NOT NULL COMMENT '0: janitor, 1: mod, 2: admin', + `type` smallint(2) NOT NULL, `boards` text CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`,`username`) @@ -142,7 +142,7 @@ CREATE TABLE IF NOT EXISTS `mods` ( -- INSERT INTO `mods` VALUES -(1, 'admin', 'cedad442efeef7112fed0f50b011b2b9bf83f6898082f995f69dd7865ca19fb7', '4a44c6c55df862ae901b413feecb0d49', 2, '*'); +(1, 'admin', 'cedad442efeef7112fed0f50b011b2b9bf83f6898082f995f69dd7865ca19fb7', '4a44c6c55df862ae901b413feecb0d49', 20, '*'); -- -------------------------------------------------------- |