From 3f69fee7453fc777effb260fd7ef936d7dbf5121 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Thu, 2 Jan 2014 12:28:06 +0100 Subject: [PATCH] Using fixed IDs to prevent issues with auto_increment_increment --- wcfsetup/setup/db/install.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 533431a9d0..a6394fb118 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -1548,17 +1548,17 @@ ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (userID) REFERENCES wcf1_user /* default inserts */ -- default user groups -INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group1', 1); -INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group2', 2); -INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group3', 3); -INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group4', 4); -INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group5', 4); -INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group6', 4); +INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (1, 'wcf.acp.group.group1', 1); -- Everyone +INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (2, 'wcf.acp.group.group2', 2); -- Guests +INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (3, 'wcf.acp.group.group3', 3); -- Registered Users +INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (4, 'wcf.acp.group.group4', 4); -- Administrators +INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (5, 'wcf.acp.group.group5', 4); -- Moderators +INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (6, 'wcf.acp.group.group6', 4); -- Super-Moderators -- default user group options -INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, showOrder) VALUES ('admin.general.canUseAcp', 'admin.general', 'boolean', '0', 1); -INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, showOrder) VALUES ('admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', 1); -INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, showOrder) VALUES ('admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', 1); +INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder) VALUES (1, 'admin.general.canUseAcp', 'admin.general', 'boolean', '0', 1); +INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder) VALUES (2, 'admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', 1); +INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder) VALUES (3, 'admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', 1); -- default user group option values INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0'); -- Everyone -- 2.20.1