-
-
Notifications
You must be signed in to change notification settings - Fork 15
/
V5__Nullable_Settings.sql
74 lines (61 loc) · 2.43 KB
/
V5__Nullable_Settings.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
-- The idea here is that settings are optional, and should therefore be allowed to be NULL.
-- The database schema is just not a good place to put defaults in for tables that represent settings.
-- Just because the user sets one setting to a specific value, we should not automatically insert all other defaults
-- into a settings table row.
-- Maybe we want to change defaults in the future in the application code? We won't be able to tell which
-- settings were actually consciously set by a user, and which ones are just a result of table defaults being inserted.
-- guild settings
ALTER TABLE public.guild_settings
ALTER COLUMN name DROP NOT NULL;
ALTER TABLE public.guild_settings
ALTER COLUMN name DROP DEFAULT;
UPDATE public.guild_settings
SET name = NULL
WHERE name = 'Unknown Guild';
-- clean up the rows that have default values only
DELETE
FROM public.guild_settings
WHERE name IS NULL
AND icon_id IS NULL;
-- channel settings
ALTER TABLE public.channel_settings
ALTER COLUMN access_role_id DROP NOT NULL;
ALTER TABLE public.channel_settings
ALTER COLUMN access_role_id DROP DEFAULT;
UPDATE public.channel_settings
SET access_role_id = NULL
WHERE access_role_id = -1;
ALTER TABLE public.channel_settings
ALTER COLUMN tag_cooldown DROP NOT NULL;
ALTER TABLE public.channel_settings
ALTER COLUMN tag_cooldown DROP DEFAULT;
UPDATE public.channel_settings
SET tag_cooldown = NULL
WHERE tag_cooldown = 5;
/*
* Copyright (C) 2016-2020 the original author or authors
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published
* by the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
-- consolidate the two former defaults
UPDATE public.channel_settings
SET tag_last_used = 0
WHERE tag_last_used = -1;
-- clean up the rows that have default values only
DELETE
FROM public.channel_settings
WHERE access_role_id IS NULL
AND tag_cooldown IS NULL
AND tag_last_used = 0
AND tags = '{}';