1 -- Enano CMS - upgrade SQL |
1 -- Enano CMS - upgrade SQL |
2 -- Variables are in the format {{VAR_NAME}} |
2 -- Variables are in the format {{VAR_NAME}} |
3 -- ALL NON-SQL LINES, even otherwise blank lines, must start with "--" or they will get sent to MySQL! |
3 -- ALL NON-SQL LINES, even otherwise blank lines, must start with "--" or they will get sent to MySQL! |
4 -- Common tasks (version numbers) |
4 -- Common tasks (version numbers) |
5 DELETE FROM {{TABLE_PREFIX}}config WHERE config_name='enano_version' OR config_name='enano_beta_version' OR config_name='enano_alpha_version' OR config_name='enano_rc_version'; |
5 DELETE FROM {{TABLE_PREFIX}}config WHERE config_name='enano_version' OR config_name='enano_beta_version' OR config_name='enano_alpha_version' OR config_name='enano_rc_version'; |
6 INSERT INTO {{TABLE_PREFIX}}config (config_name, config_value) VALUES( 'enano_version', '1.0' ),( 'enano_rc_version', '3' ); |
6 INSERT INTO {{TABLE_PREFIX}}config (config_name, config_value) VALUES( 'enano_version', '1.0' ); |
|
7 ---BEGIN 1.0RC3--- |
|
8 -- Placeholder (all versions need to have at least one query performed) |
|
9 UPDATE {{TABLE_PREFIX}}config SET config_value='' WHERE config_name=' '; |
|
10 ---END 1.0RC3--- |
7 ---BEGIN 1.0RC2--- |
11 ---BEGIN 1.0RC2--- |
8 -- Add the "Moderators" group |
12 -- Add the "Moderators" group |
9 UPDATE {{TABLE_PREFIX}}groups SET group_id=9999 WHERE group_id=3; |
13 UPDATE {{TABLE_PREFIX}}groups SET group_id=9999 WHERE group_id=3; |
10 UPDATE {{TABLE_PREFIX}}group_members SET group_id=9999 WHERE group_id=3; |
14 UPDATE {{TABLE_PREFIX}}group_members SET group_id=9999 WHERE group_id=3; |
11 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN system_group tinyint(1) NOT NULL DEFAULT 0; |
15 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN system_group tinyint(1) NOT NULL DEFAULT 0; |