← Back to team overview

launchpad-reviewers team mailing list archive

  1. launchpad-reviewers team
  2. Mailing list archive
  3. Message #20205

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

  Thread Previous • Date Previous • • Thread Next 
Colin Watson has proposed merging lp:~cjwatson/launchpad/db-person-settings-enf-not-null into lp:launchpad/db-devel.

Commit message:
Make PersonSettings.expanded_notification_footers NOT NULL.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~cjwatson/launchpad/db-person-settings-enf-not-null/+merge/291007

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.
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~cjwatson/launchpad/db-person-settings-enf-not-null into lp:launchpad/db-devel.

=== modified file 'database/sampledata/current-dev.sql'
--- database/sampledata/current-dev.sql	2016-02-24 06:08:16 +0000
+++ database/sampledata/current-dev.sql	2016-04-05 15:58:51 +0000
@@ -1710,6 +1710,16 @@
 
 
 
+ALTER TABLE archivefile DISABLE TRIGGER ALL;
+
+
+
+ALTER TABLE archivefile ENABLE TRIGGER ALL;
+
+
+
+
+
 ALTER TABLE archivejob DISABLE TRIGGER ALL;
 
 
@@ -6148,101 +6158,101 @@
 
 ALTER TABLE personsettings DISABLE TRIGGER ALL;
 
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (1, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (2, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (3, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (4, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (5, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (6, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (7, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (8, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (9, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (10, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (11, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (12, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (13, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (14, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (16, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (17, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (18, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (19, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (20, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (21, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (22, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (23, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (24, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (25, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (26, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (27, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (28, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (29, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (30, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (31, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (32, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (33, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (34, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (35, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (36, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (37, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (38, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (39, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (40, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (41, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (42, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (43, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (44, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (45, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (46, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (47, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (48, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (49, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (50, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (51, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (52, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (53, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (55, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (56, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (57, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (58, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (59, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (60, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (61, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (62, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (63, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (64, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (65, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (66, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (67, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (68, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (69, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (70, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243602, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243603, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243604, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243606, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243607, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243608, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243609, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243610, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243611, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243612, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243613, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243614, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243615, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243616, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243617, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243620, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243621, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243622, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243623, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243624, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243625, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243626, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243629, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243630, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, NULL);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (1, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (2, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (3, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (4, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (5, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (6, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (7, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (8, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (9, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (10, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (11, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (12, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (13, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (14, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (16, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (17, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (18, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (19, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (20, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (21, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (22, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (23, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (24, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (25, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (26, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (27, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (28, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (29, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (30, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (31, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (32, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (33, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (34, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (35, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (36, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (37, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (38, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (39, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (40, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (41, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (42, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (43, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (44, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (45, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (46, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (47, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (48, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (49, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (50, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (51, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (52, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (53, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (55, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (56, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (57, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (58, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (59, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (60, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (61, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (62, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (63, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (64, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (65, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (66, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (67, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (68, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (69, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (70, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243602, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243603, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243604, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243606, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243607, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243608, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243609, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243610, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243611, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243612, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243613, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243614, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243615, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243616, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243617, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243620, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243621, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243622, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243623, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243624, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243625, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243626, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243629, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243630, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, false);
 
 
 ALTER TABLE personsettings ENABLE TRIGGER ALL;

=== modified file 'database/sampledata/current.sql'
--- database/sampledata/current.sql	2016-03-18 03:07:48 +0000
+++ database/sampledata/current.sql	2016-04-05 15:58:51 +0000
@@ -1703,6 +1703,16 @@
 
 
 
+ALTER TABLE archivefile DISABLE TRIGGER ALL;
+
+
+
+ALTER TABLE archivefile ENABLE TRIGGER ALL;
+
+
+
+
+
 ALTER TABLE archivejob DISABLE TRIGGER ALL;
 
 
@@ -6063,101 +6073,101 @@
 
 ALTER TABLE personsettings DISABLE TRIGGER ALL;
 
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (1, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (2, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (3, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (4, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (5, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (6, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (7, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (8, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (9, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (10, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (11, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (12, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (13, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (14, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (16, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (17, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (18, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (19, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (20, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (21, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (22, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (23, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (24, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (25, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (26, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (27, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (28, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (29, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (30, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (31, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (32, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (33, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (34, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (35, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (36, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (37, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (38, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (39, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (40, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (41, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (42, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (43, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (44, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (45, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (46, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (47, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (48, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (49, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (50, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (51, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (52, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (53, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (55, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (56, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (57, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (58, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (59, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (60, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (61, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (62, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (63, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (64, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (65, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (66, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (67, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (68, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (69, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (70, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243602, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243603, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243604, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243606, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243607, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243608, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243609, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243610, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243611, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243612, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243613, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243614, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243615, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243616, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243617, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243620, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243621, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243622, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243623, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243624, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243625, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243626, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243629, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243630, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, NULL);
-INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, NULL);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (1, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (2, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (3, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (4, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (5, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (6, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (7, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (8, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (9, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (10, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (11, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (12, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (13, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (14, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (16, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (17, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (18, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (19, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (20, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (21, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (22, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (23, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (24, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (25, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (26, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (27, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (28, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (29, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (30, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (31, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (32, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (33, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (34, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (35, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (36, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (37, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (38, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (39, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (40, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (41, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (42, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (43, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (44, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (45, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (46, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (47, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (48, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (49, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (50, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (51, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (52, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (53, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (55, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (56, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (57, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (58, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (59, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (60, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (61, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (62, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (63, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (64, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (65, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (66, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (67, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (68, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (69, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (70, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243602, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243603, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243604, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243606, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243607, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243608, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243609, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243610, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243611, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243612, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243613, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243614, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243615, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243616, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243617, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243620, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243621, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243622, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243623, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243624, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243625, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243626, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243629, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243630, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243631, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243632, true, false);
+INSERT INTO personsettings (person, selfgenerated_bugnotifications, expanded_notification_footers) VALUES (243651, true, false);
 
 
 ALTER TABLE personsettings ENABLE TRIGGER ALL;

=== added file 'database/schema/patch-2209-68-1.sql'
--- database/schema/patch-2209-68-1.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-68-1.sql	2016-04-05 15:58:51 +0000
@@ -0,0 +1,8 @@
+-- Copyright 2016 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+ALTER TABLE PersonSettings ALTER COLUMN expanded_notification_footers SET NOT NULL;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 68, 1);
  Thread Previous • Date Previous • • Thread Next