Launchpad itself

Merge lp:~cjwatson/launchpad/db-person-settings-enf-not-null into lp:launchpad/db-devel

  1. db-person-settings-enf-not-null
  2. Merge into db-devel
Proposed by Colin Watson
Status: Merged
Merged at revision: 13399
Proposed branch: lp:~cjwatson/launchpad/db-person-settings-enf-not-null
Merge into: lp:launchpad/db-devel
Diff against target: 448 lines (+218/-190)
3 files modified
database/sampledata/current-dev.sql (+105/-95)
database/sampledata/current.sql (+105/-95)
database/schema/patch-2209-68-1.sql (+8/-0)
To merge this branch: bzr merge lp:~cjwatson/launchpad/db-person-settings-enf-not-null
Reviewer Review Type Date Requested Status
William Grant db Approve
Review via email: mp+291007@code.launchpad.net

Commit message

Make PersonSettings.expanded_notification_footers NOT NULL.

Description of the change

Make PersonSettings.expanded_notification_footers NOT NULL.

Ideally this would land before https://code.launchpad.net/~cjwatson/launchpad/remove-person-settings-enf-populator/+merge/291006, but I made a small mistake in future-proofing the garbo job so if we land this first then the test that's removed by that branch will fail. The ordering shouldn't make a difference in production, as the garbo job has long since completed and all new PersonSettings rows get a non-NULL value for expanded_notification_footers.

To post a comment you must log in.
Revision history for this message
William Grant (wgrant) :
review: Approve (db)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'database/sampledata/current-dev.sql'
2--- database/sampledata/current-dev.sql 2016-02-24 06:08:16 +0000
3+++ database/sampledata/current-dev.sql 2016-04-05 15:58:51 +0000
4@@ -1710,6 +1710,16 @@
5
6
7
8+ALTER TABLE archivefile DISABLE TRIGGER ALL;
9+
10+
11+
12+ALTER TABLE archivefile ENABLE TRIGGER ALL;
13+
14+
15+
16+
17+
18 ALTER TABLE archivejob DISABLE TRIGGER ALL;
19
20
21@@ -6148,101 +6158,101 @@
22
23 ALTER TABLE personsettings DISABLE TRIGGER ALL;
24
25-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (1, true, NULL);
26-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (2, true, NULL);
27-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (3, true, NULL);
28-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (4, true, NULL);
29-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (5, true, NULL);
30-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (6, true, NULL);
31-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (7, true, NULL);
32-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (8, true, NULL);
33-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (9, true, NULL);
34-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (10, true, NULL);
35-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (11, true, NULL);
36-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (12, true, NULL);
37-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (13, true, NULL);
38-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (14, true, NULL);
39-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (16, true, NULL);
40-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (17, true, NULL);
41-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (18, true, NULL);
42-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (19, true, NULL);
43-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (20, true, NULL);
44-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (21, true, NULL);
45-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (22, true, NULL);
46-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (23, true, NULL);
47-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (24, true, NULL);
48-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (25, true, NULL);
49-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (26, true, NULL);
50-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (27, true, NULL);
51-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (28, true, NULL);
52-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (29, true, NULL);
53-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (30, true, NULL);
54-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (31, true, NULL);
55-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (32, true, NULL);
56-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (33, true, NULL);
57-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (34, true, NULL);
58-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (35, true, NULL);
59-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (36, true, NULL);
60-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (37, true, NULL);
61-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (38, true, NULL);
62-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (39, true, NULL);
63-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (40, true, NULL);
64-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (41, true, NULL);
65-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (42, true, NULL);
66-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (43, true, NULL);
67-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (44, true, NULL);
68-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (45, true, NULL);
69-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (46, true, NULL);
70-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (47, true, NULL);
71-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (48, true, NULL);
72-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (49, true, NULL);
73-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (50, true, NULL);
74-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (51, true, NULL);
75-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (52, true, NULL);
76-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (53, true, NULL);
77-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (55, true, NULL);
78-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (56, true, NULL);
79-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (57, true, NULL);
80-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (58, true, NULL);
81-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (59, true, NULL);
82-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (60, true, NULL);
83-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (61, true, NULL);
84-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (62, true, NULL);
85-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (63, true, NULL);
86-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (64, true, NULL);
87-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (65, true, NULL);
88-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (66, true, NULL);
89-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (67, true, NULL);
90-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (68, true, NULL);
91-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (69, true, NULL);
92-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (70, true, NULL);
93-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243602, true, NULL);
94-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243603, true, NULL);
95-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243604, true, NULL);
96-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243606, true, NULL);
97-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243607, true, NULL);
98-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243608, true, NULL);
99-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243609, true, NULL);
100-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243610, true, NULL);
101-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243611, true, NULL);
102-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243612, true, NULL);
103-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243613, true, NULL);
104-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243614, true, NULL);
105-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243615, true, NULL);
106-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243616, true, NULL);
107-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243617, true, NULL);
108-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243620, true, NULL);
109-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243621, true, NULL);
110-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243622, true, NULL);
111-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243623, true, NULL);
112-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243624, true, NULL);
113-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243625, true, NULL);
114-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243626, true, NULL);
115-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243629, true, NULL);
116-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243630, true, NULL);
117-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, NULL);
118-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, NULL);
119-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, NULL);
120+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (1, true, false);
121+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (2, true, false);
122+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (3, true, false);
123+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (4, true, false);
124+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (5, true, false);
125+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (6, true, false);
126+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (7, true, false);
127+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (8, true, false);
128+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (9, true, false);
129+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (10, true, false);
130+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (11, true, false);
131+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (12, true, false);
132+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (13, true, false);
133+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (14, true, false);
134+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (16, true, false);
135+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (17, true, false);
136+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (18, true, false);
137+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (19, true, false);
138+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (20, true, false);
139+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (21, true, false);
140+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (22, true, false);
141+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (23, true, false);
142+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (24, true, false);
143+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (25, true, false);
144+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (26, true, false);
145+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (27, true, false);
146+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (28, true, false);
147+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (29, true, false);
148+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (30, true, false);
149+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (31, true, false);
150+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (32, true, false);
151+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (33, true, false);
152+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (34, true, false);
153+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (35, true, false);
154+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (36, true, false);
155+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (37, true, false);
156+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (38, true, false);
157+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (39, true, false);
158+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (40, true, false);
159+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (41, true, false);
160+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (42, true, false);
161+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (43, true, false);
162+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (44, true, false);
163+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (45, true, false);
164+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (46, true, false);
165+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (47, true, false);
166+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (48, true, false);
167+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (49, true, false);
168+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (50, true, false);
169+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (51, true, false);
170+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (52, true, false);
171+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (53, true, false);
172+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (55, true, false);
173+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (56, true, false);
174+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (57, true, false);
175+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (58, true, false);
176+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (59, true, false);
177+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (60, true, false);
178+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (61, true, false);
179+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (62, true, false);
180+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (63, true, false);
181+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (64, true, false);
182+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (65, true, false);
183+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (66, true, false);
184+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (67, true, false);
185+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (68, true, false);
186+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (69, true, false);
187+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (70, true, false);
188+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243602, true, false);
189+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243603, true, false);
190+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243604, true, false);
191+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243606, true, false);
192+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243607, true, false);
193+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243608, true, false);
194+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243609, true, false);
195+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243610, true, false);
196+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243611, true, false);
197+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243612, true, false);
198+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243613, true, false);
199+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243614, true, false);
200+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243615, true, false);
201+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243616, true, false);
202+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243617, true, false);
203+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243620, true, false);
204+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243621, true, false);
205+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243622, true, false);
206+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243623, true, false);
207+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243624, true, false);
208+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243625, true, false);
209+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243626, true, false);
210+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243629, true, false);
211+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243630, true, false);
212+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, false);
213+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, false);
214+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, false);
215
216
217 ALTER TABLE personsettings ENABLE TRIGGER ALL;
218
219=== modified file 'database/sampledata/current.sql'
220--- database/sampledata/current.sql 2016-03-18 03:07:48 +0000
221+++ database/sampledata/current.sql 2016-04-05 15:58:51 +0000
222@@ -1703,6 +1703,16 @@
223
224
225
226+ALTER TABLE archivefile DISABLE TRIGGER ALL;
227+
228+
229+
230+ALTER TABLE archivefile ENABLE TRIGGER ALL;
231+
232+
233+
234+
235+
236 ALTER TABLE archivejob DISABLE TRIGGER ALL;
237
238
239@@ -6063,101 +6073,101 @@
240
241 ALTER TABLE personsettings DISABLE TRIGGER ALL;
242
243-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (1, true, NULL);
244-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (2, true, NULL);
245-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (3, true, NULL);
246-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (4, true, NULL);
247-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (5, true, NULL);
248-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (6, true, NULL);
249-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (7, true, NULL);
250-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (8, true, NULL);
251-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (9, true, NULL);
252-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (10, true, NULL);
253-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (11, true, NULL);
254-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (12, true, NULL);
255-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (13, true, NULL);
256-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (14, true, NULL);
257-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (16, true, NULL);
258-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (17, true, NULL);
259-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (18, true, NULL);
260-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (19, true, NULL);
261-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (20, true, NULL);
262-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (21, true, NULL);
263-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (22, true, NULL);
264-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (23, true, NULL);
265-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (24, true, NULL);
266-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (25, true, NULL);
267-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (26, true, NULL);
268-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (27, true, NULL);
269-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (28, true, NULL);
270-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (29, true, NULL);
271-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (30, true, NULL);
272-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (31, true, NULL);
273-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (32, true, NULL);
274-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (33, true, NULL);
275-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (34, true, NULL);
276-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (35, true, NULL);
277-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (36, true, NULL);
278-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (37, true, NULL);
279-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (38, true, NULL);
280-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (39, true, NULL);
281-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (40, true, NULL);
282-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (41, true, NULL);
283-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (42, true, NULL);
284-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (43, true, NULL);
285-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (44, true, NULL);
286-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (45, true, NULL);
287-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (46, true, NULL);
288-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (47, true, NULL);
289-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (48, true, NULL);
290-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (49, true, NULL);
291-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (50, true, NULL);
292-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (51, true, NULL);
293-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (52, true, NULL);
294-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (53, true, NULL);
295-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (55, true, NULL);
296-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (56, true, NULL);
297-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (57, true, NULL);
298-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (58, true, NULL);
299-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (59, true, NULL);
300-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (60, true, NULL);
301-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (61, true, NULL);
302-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (62, true, NULL);
303-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (63, true, NULL);
304-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (64, true, NULL);
305-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (65, true, NULL);
306-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (66, true, NULL);
307-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (67, true, NULL);
308-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (68, true, NULL);
309-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (69, true, NULL);
310-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (70, true, NULL);
311-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243602, true, NULL);
312-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243603, true, NULL);
313-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243604, true, NULL);
314-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243606, true, NULL);
315-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243607, true, NULL);
316-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243608, true, NULL);
317-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243609, true, NULL);
318-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243610, true, NULL);
319-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243611, true, NULL);
320-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243612, true, NULL);
321-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243613, true, NULL);
322-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243614, true, NULL);
323-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243615, true, NULL);
324-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243616, true, NULL);
325-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243617, true, NULL);
326-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243620, true, NULL);
327-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243621, true, NULL);
328-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243622, true, NULL);
329-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243623, true, NULL);
330-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243624, true, NULL);
331-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243625, true, NULL);
332-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243626, true, NULL);
333-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243629, true, NULL);
334-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243630, true, NULL);
335-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, NULL);
336-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, NULL);
337-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, NULL);
338+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (1, true, false);
339+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (2, true, false);
340+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (3, true, false);
341+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (4, true, false);
342+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (5, true, false);
343+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (6, true, false);
344+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (7, true, false);
345+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (8, true, false);
346+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (9, true, false);
347+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (10, true, false);
348+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (11, true, false);
349+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (12, true, false);
350+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (13, true, false);
351+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (14, true, false);
352+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (16, true, false);
353+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (17, true, false);
354+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (18, true, false);
355+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (19, true, false);
356+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (20, true, false);
357+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (21, true, false);
358+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (22, true, false);
359+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (23, true, false);
360+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (24, true, false);
361+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (25, true, false);
362+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (26, true, false);
363+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (27, true, false);
364+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (28, true, false);
365+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (29, true, false);
366+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (30, true, false);
367+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (31, true, false);
368+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (32, true, false);
369+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (33, true, false);
370+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (34, true, false);
371+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (35, true, false);
372+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (36, true, false);
373+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (37, true, false);
374+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (38, true, false);
375+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (39, true, false);
376+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (40, true, false);
377+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (41, true, false);
378+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (42, true, false);
379+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (43, true, false);
380+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (44, true, false);
381+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (45, true, false);
382+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (46, true, false);
383+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (47, true, false);
384+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (48, true, false);
385+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (49, true, false);
386+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (50, true, false);
387+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (51, true, false);
388+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (52, true, false);
389+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (53, true, false);
390+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (55, true, false);
391+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (56, true, false);
392+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (57, true, false);
393+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (58, true, false);
394+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (59, true, false);
395+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (60, true, false);
396+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (61, true, false);
397+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (62, true, false);
398+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (63, true, false);
399+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (64, true, false);
400+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (65, true, false);
401+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (66, true, false);
402+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (67, true, false);
403+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (68, true, false);
404+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (69, true, false);
405+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (70, true, false);
406+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243602, true, false);
407+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243603, true, false);
408+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243604, true, false);
409+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243606, true, false);
410+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243607, true, false);
411+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243608, true, false);
412+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243609, true, false);
413+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243610, true, false);
414+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243611, true, false);
415+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243612, true, false);
416+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243613, true, false);
417+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243614, true, false);
418+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243615, true, false);
419+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243616, true, false);
420+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243617, true, false);
421+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243620, true, false);
422+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243621, true, false);
423+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243622, true, false);
424+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243623, true, false);
425+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243624, true, false);
426+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243625, true, false);
427+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243626, true, false);
428+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243629, true, false);
429+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243630, true, false);
430+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, false);
431+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, false);
432+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, false);
433
434
435 ALTER TABLE personsettings ENABLE TRIGGER ALL;
436
437=== added file 'database/schema/patch-2209-68-1.sql'
438--- database/schema/patch-2209-68-1.sql 1970-01-01 00:00:00 +0000
439+++ database/schema/patch-2209-68-1.sql 2016-04-05 15:58:51 +0000
440@@ -0,0 +1,8 @@
441+-- Copyright 2016 Canonical Ltd. This software is licensed under the
442+-- GNU Affero General Public License version 3 (see the file LICENSE).
443+
444+SET client_min_messages=ERROR;
445+
446+ALTER TABLE PersonSettings ALTER COLUMN expanded_notification_footers SET NOT NULL;
447+
448+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 68, 1);

Subscribers

People subscribed via source and target branches

to status/vote changes: