~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/sampledata/current.sql

Committer: Launchpad Patch Queue Manager
Date: 2010-09-19 23:17:06 UTC
mfrom: (7675.826.14 branch-revision-db-update)
mto: (7675.847.1 bug-615654-queue-addmember-emails) (11486.3.12 incremental-db) (11526.5.1 structural-subscriptions-with-filters) (11149.12.82 lp-service) (11713.1.1 wire-up-filter-subs-bug-655567-devel) (13155.1.1 remote-bugtracker-components-ui-0) (11737.4.9 librarian) (12269.5.4 merge-job-schema) (12366.7.3 bug164196) (12411.5.2 auto-creation-merged) (12959.6.1 stevenk--db-use-dsp) (13023.7.1 bug-772763-remove-unmute-dialog-part1) (13164.2.1 init-multiple-parents-bug-777120-devel) (13117.2.2 init-multiple-parents-backend) (13168.12.1 init-series-bug-789091-devel) (13166.1.1 db-stable-merge-again) (13268.1.6 bug-534203) (13506.11.1 remove-unused-potmsgsets) (8758.3.19 garbo) (13465.2.23 staging) (13404.4.11 multiarch-translations) (14099.1.1 dsp-vocab-ui) (14181.1.1 db-stable-merge) (14183.1.1 db-stable-merge) (14187.1.1 db-stable-merge) (14186.5.20 observer-db) (9795.4.38 replication) (14403.2.5 recipe-format-0.4) (14046.1.1 bug-860245) (11881.1.1 mvo)
mto: This revision was merged to the branch mainline in revision 11695.
Revision ID: launchpad@pqm.canonical.com-20100919231706-2girg31c6lzimg5r

[r=gmb, stub][ui=none][bug=552701] Remove the BranchRevision.id column

files added:
database/schema/patch-2208-11-0.sql

files modified:
database/sampledata/current-dev.sql

database/sampledata/current.sql

database/schema/security.cfg

lib/lp/code/interfaces/branchrevision.py

lib/lp/code/model/branch.py

lib/lp/code/model/branchmergeproposal.py

lib/lp/code/model/branchrevision.py

lib/lp/code/model/tests/test_branchjob.py

Show diffs side-by-side

added added

removed removed

database/sampledata/current.sql

3095

3096

ALTER TABLE branchrevision DISABLE TRIGGER ALL;

3097

3098

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (1, 1, 10, 1);

3099

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (2, 1, 11, 2);

3100

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (3, 1, 12, 3);

3101

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (4, 1, 20, 4);

3102

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (5, 2, 20, 5);

3103

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (6, 3, 20, 6);

3104

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (7, 4, 20, 7);

3105

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (8, 5, 20, 8);

3106

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (9, 6, 20, 9);

3107

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (10, 1, 21, 4);

3108

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (11, 2, 21, 5);

3109

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (12, 3, 21, 10);

3110

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (13, 4, 21, 11);

3111

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (14, 5, 21, 8);

3112

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (15, 6, 21, 9);

3113

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (16, NULL, 20, 10);

3114

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (17, NULL, 20, 11);

3115

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (18, NULL, 21, 6);

3116

INSERT INTO branchrevision (id, sequence, branch, revision) VALUES (19, NULL, 21, 7);

3098

INSERT INTO branchrevision (sequence, branch, revision) VALUES (1, 10, 1);

3099

INSERT INTO branchrevision (sequence, branch, revision) VALUES (1, 11, 2);

3100

INSERT INTO branchrevision (sequence, branch, revision) VALUES (1, 12, 3);

3101

INSERT INTO branchrevision (sequence, branch, revision) VALUES (1, 20, 4);

3102

INSERT INTO branchrevision (sequence, branch, revision) VALUES (1, 21, 4);

3103

INSERT INTO branchrevision (sequence, branch, revision) VALUES (2, 20, 5);

3104

INSERT INTO branchrevision (sequence, branch, revision) VALUES (2, 21, 5);

3105

INSERT INTO branchrevision (sequence, branch, revision) VALUES (3, 20, 6);

3106

INSERT INTO branchrevision (sequence, branch, revision) VALUES (3, 21, 10);

3107

INSERT INTO branchrevision (sequence, branch, revision) VALUES (4, 20, 7);

3108

INSERT INTO branchrevision (sequence, branch, revision) VALUES (4, 21, 11);

3109

INSERT INTO branchrevision (sequence, branch, revision) VALUES (5, 20, 8);

3110

INSERT INTO branchrevision (sequence, branch, revision) VALUES (5, 21, 8);

3111

INSERT INTO branchrevision (sequence, branch, revision) VALUES (6, 20, 9);

3112

INSERT INTO branchrevision (sequence, branch, revision) VALUES (6, 21, 9);

3113

INSERT INTO branchrevision (sequence, branch, revision) VALUES (NULL, 20, 10);

3114

INSERT INTO branchrevision (sequence, branch, revision) VALUES (NULL, 20, 11);

3115

INSERT INTO branchrevision (sequence, branch, revision) VALUES (NULL, 21, 6);

3116

INSERT INTO branchrevision (sequence, branch, revision) VALUES (NULL, 21, 7);

3117

3118

3119

ALTER TABLE branchrevision ENABLE TRIGGER ALL;

3336

3337

ALTER TABLE bugmessage DISABLE TRIGGER ALL;

3338

3339

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (1, 2, 1, NULL, NULL, true);

3340

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (2, 1, 3, NULL, NULL, true);

3341

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (3, 1, 4, NULL, NULL, true);

3342

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (4, 2, 5, NULL, NULL, true);

3343

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (5, 2, 6, NULL, NULL, true);

3344

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (6, 4, 7, NULL, NULL, true);

3345

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (7, 5, 8, NULL, NULL, true);

3346

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (8, 6, 9, NULL, NULL, true);

3347

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (9, 3, 10, NULL, NULL, true);

3348

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (10, 7, 11, NULL, NULL, true);

3349

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (11, 8, 14, NULL, NULL, true);

3350

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (12, 9, 15, NULL, NULL, true);

3351

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (13, 10, 17, NULL, NULL, true);

3352

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (14, 10, 16, NULL, NULL, true);

3353

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (15, 11, 24, NULL, NULL, true);

3354

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (16, 11, 25, NULL, NULL, true);

3355

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (17, 11, 26, NULL, NULL, true);

3356

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (18, 11, 27, NULL, NULL, true);

3357

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (19, 11, 28, NULL, NULL, true);

3358

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (20, 11, 29, NULL, NULL, true);

3359

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (21, 11, 30, NULL, NULL, true);

3360

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (22, 12, 31, NULL, NULL, true);

3361

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (23, 12, 33, NULL, NULL, true);

3362

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (24, 12, 34, NULL, NULL, true);

3363

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (25, 12, 35, NULL, NULL, true);

3364

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (26, 12, 36, NULL, NULL, true);

3365

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (27, 13, 37, NULL, NULL, true);

3366

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (28, 13, 38, NULL, NULL, true);

3367

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (29, 14, 39, NULL, NULL, true);

3368

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (30, 15, 40, NULL, NULL, true);

3369

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (31, 15, 44, 11, '<4284D7D1.6010208@gmx.de>', true);

3370

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (32, 15, 45, 11, '<20050517185429.GB20786@spring.luon.net>', true);

3371

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (33, 15, 46, 11, '<428A44E9.6090802@gmx.de>', true);

3372

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (34, 15, 47, 11, '<20050517202044.GA23231@spring.luon.net>', true);

3373

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (35, 15, 48, 11, '<20050617140011.GA15638@piware.de>', true);

3374

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible) VALUES (36, 15, 49, 11, '<42BD2E36.9090809@gmx.de>', true);

3339

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (1, 2, 1, NULL, NULL, true, NULL);

3340

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (2, 1, 3, NULL, NULL, true, NULL);

3341

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (3, 1, 4, NULL, NULL, true, NULL);

3342

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (4, 2, 5, NULL, NULL, true, NULL);

3343

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (5, 2, 6, NULL, NULL, true, NULL);

3344

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (6, 4, 7, NULL, NULL, true, NULL);

3345

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (7, 5, 8, NULL, NULL, true, NULL);

3346

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (8, 6, 9, NULL, NULL, true, NULL);

3347

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (9, 3, 10, NULL, NULL, true, NULL);

3348

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (10, 7, 11, NULL, NULL, true, NULL);

3349

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (11, 8, 14, NULL, NULL, true, NULL);

3350

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (12, 9, 15, NULL, NULL, true, NULL);

3351

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (13, 10, 17, NULL, NULL, true, NULL);

3352

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (14, 10, 16, NULL, NULL, true, NULL);

3353

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (15, 11, 24, NULL, NULL, true, NULL);

3354

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (16, 11, 25, NULL, NULL, true, NULL);

3355

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (17, 11, 26, NULL, NULL, true, NULL);

3356

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (18, 11, 27, NULL, NULL, true, NULL);

3357

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (19, 11, 28, NULL, NULL, true, NULL);

3358

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (20, 11, 29, NULL, NULL, true, NULL);

3359

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (21, 11, 30, NULL, NULL, true, NULL);

3360

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (22, 12, 31, NULL, NULL, true, NULL);

3361

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (23, 12, 33, NULL, NULL, true, NULL);

3362

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (24, 12, 34, NULL, NULL, true, NULL);

3363

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (25, 12, 35, NULL, NULL, true, NULL);

3364

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (26, 12, 36, NULL, NULL, true, NULL);

3365

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (27, 13, 37, NULL, NULL, true, NULL);

3366

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (28, 13, 38, NULL, NULL, true, NULL);

3367

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (29, 14, 39, NULL, NULL, true, NULL);

3368

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (30, 15, 40, NULL, NULL, true, NULL);

3369

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (31, 15, 44, 11, '<4284D7D1.6010208@gmx.de>', true, NULL);

3370

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (32, 15, 45, 11, '<20050517185429.GB20786@spring.luon.net>', true, NULL);

3371

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (33, 15, 46, 11, '<428A44E9.6090802@gmx.de>', true, NULL);

3372

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (34, 15, 47, 11, '<20050517202044.GA23231@spring.luon.net>', true, NULL);

3373

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (35, 15, 48, 11, '<20050617140011.GA15638@piware.de>', true, NULL);

3374

INSERT INTO bugmessage (id, bug, message, bugwatch, remote_comment_id, visible, index) VALUES (36, 15, 49, 11, '<42BD2E36.9090809@gmx.de>', true, NULL);

3375

3376

3377

ALTER TABLE bugmessage ENABLE TRIGGER ALL;

3996

ALTER TABLE distributionbounty ENABLE TRIGGER ALL;

3997

3998

3999

ALTER TABLE distributionjob DISABLE TRIGGER ALL;

4000

4001

4002

4003

ALTER TABLE distributionjob ENABLE TRIGGER ALL;

4004

4005

3999

4006

ALTER TABLE distributionmirror DISABLE TRIGGER ALL;

4000

4007

4001

4008

INSERT INTO distributionmirror (id, distribution, name, http_base_url, ftp_base_url, rsync_base_url, displayname, description, owner, speed, country, content, official_candidate, enabled, date_created, whiteboard, status, date_reviewed, reviewer, country_dns_mirror) VALUES (1, 1, 'archive-mirror', 'http://localhost:11375/valid-mirror/', NULL, NULL, NULL, NULL, 1, 10, 75, 1, true, true, '2006-10-16 18:31:43.434567', NULL, 30, NULL, NULL, false);

Older »