launchpad-reviewers team mailing list archive
-
launchpad-reviewers team
-
Mailing list archive
-
Message #16086
[Merge] lp:~cjwatson/launchpad/db-builder-version into lp:launchpad
Colin Watson has proposed merging lp:~cjwatson/launchpad/db-builder-version into lp:launchpad.
Commit message:
Add Builder.version column.
Requested reviews:
William Grant (wgrant): db
Stuart Bishop (stub): db
Related bugs:
Bug #680514 in Launchpad itself: "No way to discover version of launchpad-buildd installed on builders"
https://bugs.launchpad.net/launchpad/+bug/680514
For more details, see:
https://code.launchpad.net/~cjwatson/launchpad/db-builder-version/+merge/190633
This adds a version column to Builder so that the slave scanner can record the version of launchpad-buildd installed on each builder slave, which we'll shortly be able to present in the API/UI. It may be NULL since old builders are necessarily still in the database whose version we'll never know, and since new builders may not have been scanned yet.
--
https://code.launchpad.net/~cjwatson/launchpad/db-builder-version/+merge/190633
Your team Launchpad code reviewers is subscribed to branch lp:launchpad.
=== modified file 'database/sampledata/current-dev.sql'
--- database/sampledata/current-dev.sql 2013-09-11 06:13:28 +0000
+++ database/sampledata/current-dev.sql 2013-10-11 12:06:15 +0000
@@ -1,6 +1,6 @@
-- Copyright 2010-2013 Canonical Ltd. This software is licensed under the
-- GNU Affero General Public License version 3 (see the file LICENSE).
--- Created using pg_dump (PostgreSQL) 9.1.9
+-- Created using pg_dump (PostgreSQL) 9.1.4
SET check_function_bodies = false;
SET client_encoding = 'UTF8';
@@ -12,6 +12,747 @@
SET search_path = public, pg_catalog;
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
SET SESSION AUTHORIZATION DEFAULT;
ALTER TABLE account DISABLE TRIGGER ALL;
@@ -1371,9 +2112,6 @@
ALTER TABLE accessartifact ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE accessartifactgrant DISABLE TRIGGER ALL;
INSERT INTO accessartifactgrant (artifact, grantee, grantor, date_created) VALUES (1, 14, 65, '2007-08-09 11:39:16.836856');
@@ -1460,9 +2198,6 @@
ALTER TABLE accesspolicy ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE accesspolicyartifact DISABLE TRIGGER ALL;
INSERT INTO accesspolicyartifact (artifact, policy) VALUES (1, 2);
@@ -1495,12 +2230,6 @@
ALTER TABLE accesspolicygrantflat ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE announcement DISABLE TRIGGER ALL;
INSERT INTO announcement (id, date_created, date_announced, registrant, product, distribution, project, title, summary, url, active, date_updated) VALUES (1, '2007-11-25 00:44:32.186178', '2007-11-20 03:00:00', 1, NULL, 1, NULL, 'Every Macedonian Student to Use Ubuntu-Powered Computer Workstations', 'The Macedonia Ministry of Education and Science will deploy more than 180,000 workstations running Canonical’s Edubuntu 7.04 as part of its "Computer for Every Child" project.', 'http://www.ubuntu.com/news/macedonia-school-computers', true, NULL);
@@ -1558,9 +2287,6 @@
ALTER TABLE announcement ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE answercontact DISABLE TRIGGER ALL;
INSERT INTO answercontact (id, product, distribution, sourcepackagename, person, date_created) VALUES (1, NULL, 1, 1, 16, '2007-03-14 20:07:25.233772');
@@ -1572,9 +2298,6 @@
ALTER TABLE answercontact ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE job DISABLE TRIGGER ALL;
INSERT INTO job (id, requester, reason, status, progress, last_report_seen, next_report_due, attempt_count, max_retries, log, scheduled_start, lease_expires, date_created, date_started, date_finished, json_data, job_type) VALUES (1, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, '2005-06-15 09:14:12.820778', '2005-06-15 09:20:12.820778', NULL, NULL, NULL);
@@ -1598,9 +2321,6 @@
ALTER TABLE apportjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE gpgkey DISABLE TRIGGER ALL;
INSERT INTO gpgkey (id, owner, keyid, fingerprint, active, algorithm, keysize, can_encrypt, date_created) VALUES (1, 16, '12345678', 'ABCDEF0123456789ABCDDCBA0000111112345678', true, 17, 1024, true, '2006-10-16 18:31:43.631499');
@@ -1630,9 +2350,6 @@
ALTER TABLE archive ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE archivearch DISABLE TRIGGER ALL;
@@ -1640,9 +2357,6 @@
ALTER TABLE archivearch ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE archiveauthtoken DISABLE TRIGGER ALL;
@@ -1650,9 +2364,6 @@
ALTER TABLE archiveauthtoken ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE component DISABLE TRIGGER ALL;
INSERT INTO component (id, name, description) VALUES (1, 'main', NULL);
@@ -1672,9 +2383,6 @@
ALTER TABLE archivedependency ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE archivejob DISABLE TRIGGER ALL;
@@ -1682,9 +2390,6 @@
ALTER TABLE archivejob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packagesetgroup DISABLE TRIGGER ALL;
@@ -1723,9 +2428,6 @@
ALTER TABLE archivepermission ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE archivesubscriber DISABLE TRIGGER ALL;
@@ -1733,13 +2435,10 @@
ALTER TABLE archivesubscriber ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE builder DISABLE TRIGGER ALL;
-INSERT INTO builder (id, processor, name, title, owner, speedindex, builderok, failnotes, virtualized, url, manual, date_created, vm_host, active, failure_count) VALUES (1, 1, 'bob', 'Bob The Builder', 61, NULL, true, NULL, false, 'http://localhost:8221/', false, '2006-10-16 18:31:43.226724', NULL, true, 0);
-INSERT INTO builder (id, processor, name, title, owner, speedindex, builderok, failnotes, virtualized, url, manual, date_created, vm_host, active, failure_count) VALUES (2, 1, 'frog', 'The frog builder', 61, NULL, false, NULL, true, 'http://localhost:9221/', false, '2006-10-31 18:31:43.226724', 'localhost-host.ppa', true, 0);
+INSERT INTO builder (id, processor, name, title, owner, speedindex, builderok, failnotes, virtualized, url, manual, date_created, vm_host, active, failure_count, version) VALUES (1, 1, 'bob', 'Bob The Builder', 61, NULL, true, NULL, false, 'http://localhost:8221/', false, '2006-10-16 18:31:43.226724', NULL, true, 0, NULL);
+INSERT INTO builder (id, processor, name, title, owner, speedindex, builderok, failnotes, virtualized, url, manual, date_created, vm_host, active, failure_count, version) VALUES (2, 1, 'frog', 'The frog builder', 61, NULL, false, NULL, true, 'http://localhost:9221/', false, '2006-10-31 18:31:43.226724', 'localhost-host.ppa', true, 0, NULL);
ALTER TABLE builder ENABLE TRIGGER ALL;
@@ -2000,9 +2699,6 @@
ALTER TABLE binarypackagebuild ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE binarypackagename DISABLE TRIGGER ALL;
INSERT INTO binarypackagename (id, name) VALUES (6, 'foobar');
@@ -2056,12 +2752,6 @@
ALTER TABLE binarypackagefile ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE binarypackagepath DISABLE TRIGGER ALL;
@@ -2069,9 +2759,6 @@
ALTER TABLE binarypackagepath ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE binarypackagepublishinghistory DISABLE TRIGGER ALL;
INSERT INTO binarypackagepublishinghistory (id, binarypackagerelease, distroarchseries, status, component, section, priority, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, binarypackagename, phased_update_percentage) VALUES (9, 12, 1, 2, 1, 1, 10, '2005-05-05 00:00:00', '2005-06-18 00:00:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, 8, NULL);
@@ -2105,12 +2792,6 @@
ALTER TABLE binarypackagepublishinghistory ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE binarypackagereleasecontents DISABLE TRIGGER ALL;
@@ -2386,12 +3067,6 @@
ALTER TABLE binarypackagereleasedownloadcount ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE branchjob DISABLE TRIGGER ALL;
@@ -2399,9 +3074,6 @@
ALTER TABLE branchjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE branchmergeproposal DISABLE TRIGGER ALL;
@@ -2409,9 +3081,6 @@
ALTER TABLE branchmergeproposal ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE branchmergeproposaljob DISABLE TRIGGER ALL;
@@ -2419,12 +3088,6 @@
ALTER TABLE branchmergeproposaljob ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE revisionauthor DISABLE TRIGGER ALL;
INSERT INTO revisionauthor (id, name, email, person) VALUES (1, 'mark.shuttleworth', NULL, NULL);
@@ -2501,12 +3164,6 @@
ALTER TABLE branchsubscription ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE bugactivity DISABLE TRIGGER ALL;
INSERT INTO bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (1, 1, '2004-09-24 00:00:00', 1, 'title', 'A silly problem', 'An odd problem', 'Decided problem wasn''t silly after all');
@@ -2550,9 +3207,6 @@
ALTER TABLE bugactivity ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugaffectsperson DISABLE TRIGGER ALL;
@@ -2560,9 +3214,6 @@
ALTER TABLE bugaffectsperson ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE message DISABLE TRIGGER ALL;
INSERT INTO message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible) VALUES (1, '2004-09-24 20:58:04.684057', 'PEBCAK', 16, NULL, NULL, 'foo@xxxxxxxxxxx-332342--1231', NULL, NULL, true);
@@ -2628,9 +3279,6 @@
ALTER TABLE bugattachment ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugbranch DISABLE TRIGGER ALL;
INSERT INTO bugbranch (id, datecreated, bug, branch, revision_hint, whiteboard, registrant) VALUES (1, '2006-03-22 18:44:27.438982', 5, 1, NULL, NULL, 12);
@@ -2641,9 +3289,6 @@
ALTER TABLE bugbranch ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE cve DISABLE TRIGGER ALL;
INSERT INTO cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (1, '1999-8979', 2, 'Firefox crashes all the time', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.508959', NULL);
@@ -2670,9 +3315,6 @@
ALTER TABLE bugcve ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugwatch DISABLE TRIGGER ALL;
INSERT INTO bugwatch (id, bug, bugtracker, remotebug, remotestatus, lastchanged, lastchecked, datecreated, owner, last_error_type, remote_importance, remote_lp_bug_id, next_check) VALUES (1, 2, 1, '42', 'FUBAR', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', 12, NULL, 'BAZBAZ', NULL, NULL);
@@ -2735,9 +3377,6 @@
ALTER TABLE bugmessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugmute DISABLE TRIGGER ALL;
@@ -2756,9 +3395,6 @@
ALTER TABLE bugnomination ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugnotification DISABLE TRIGGER ALL;
@@ -2766,9 +3402,6 @@
ALTER TABLE bugnotification ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugnotificationarchive DISABLE TRIGGER ALL;
@@ -2783,9 +3416,6 @@
ALTER TABLE bugnotificationattachment ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE structuralsubscription DISABLE TRIGGER ALL;
INSERT INTO structuralsubscription (id, product, productseries, project, milestone, distribution, distroseries, sourcepackagename, subscriber, subscribed_by, date_created, date_last_updated) VALUES (1, NULL, NULL, NULL, NULL, 1, NULL, 1, 16, 16, '2008-01-29 15:12:34.581468', '2008-01-29 15:12:34.581468');
@@ -2822,9 +3452,6 @@
ALTER TABLE bugnotificationrecipient ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugnotificationrecipientarchive DISABLE TRIGGER ALL;
@@ -2854,12 +3481,6 @@
ALTER TABLE bugsubscription ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE bugsubscriptionfilterimportance DISABLE TRIGGER ALL;
@@ -2895,9 +3516,6 @@
ALTER TABLE bugsubscriptionfiltertag ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugsummary DISABLE TRIGGER ALL;
INSERT INTO bugsummary (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy) VALUES (65, 1, 20, NULL, NULL, NULL, NULL, 14, 'lunch-money', 10, NULL, 5, false, NULL);
@@ -2971,9 +3589,6 @@
ALTER TABLE bugsummary ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugsummaryjournal DISABLE TRIGGER ALL;
@@ -2981,9 +3596,6 @@
ALTER TABLE bugsummaryjournal ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugtag DISABLE TRIGGER ALL;
INSERT INTO bugtag (id, bug, tag) VALUES (1, 9, 'crash');
@@ -2999,9 +3611,6 @@
ALTER TABLE bugtag ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugtask DISABLE TRIGGER ALL;
INSERT INTO bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set) VALUES (2, 1, 4, NULL, NULL, NULL, 10, 20, 1, '2005-01-02 11:07:20.330975', '2004-01-02 03:49:22.910878', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
@@ -3037,9 +3646,6 @@
ALTER TABLE bugtask ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugtaskflat DISABLE TRIGGER ALL;
INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed) VALUES (2, 1, '2004-01-02 03:49:22.910878', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, 4, NULL, NULL, NULL, NULL, 10, 20, 1, NULL, 12, true, NULL, NULL, NULL, NULL);
@@ -3075,9 +3681,6 @@
ALTER TABLE bugtaskflat ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugtrackeralias DISABLE TRIGGER ALL;
INSERT INTO bugtrackeralias (id, bugtracker, base_url) VALUES (1, 7, 'http://savannah.nognu.org/');
@@ -3089,9 +3692,6 @@
ALTER TABLE bugtrackeralias ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugtrackercomponentgroup DISABLE TRIGGER ALL;
@@ -3106,12 +3706,6 @@
ALTER TABLE bugtrackercomponent ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE bugtrackerperson DISABLE TRIGGER ALL;
@@ -3119,12 +3713,6 @@
ALTER TABLE bugtrackerperson ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE bugwatchactivity DISABLE TRIGGER ALL;
@@ -3132,15 +3720,6 @@
ALTER TABLE bugwatchactivity ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE buildpackagejob DISABLE TRIGGER ALL;
INSERT INTO buildpackagejob (id, job, build) VALUES (1, 1, 8);
@@ -3150,9 +3729,6 @@
ALTER TABLE buildpackagejob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE buildqueue DISABLE TRIGGER ALL;
INSERT INTO buildqueue (id, builder, logtail, lastscore, manual, job, job_type, estimated_duration, processor, virtualized) VALUES (1, 1, 'Dummy sampledata entry, not processing', 1, false, 1, 1, '00:00:00', 1, false);
@@ -3162,9 +3738,6 @@
ALTER TABLE buildqueue ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codeimport DISABLE TRIGGER ALL;
INSERT INTO codeimport (id, branch, date_created, registrant, rcs_type, cvs_root, cvs_module, review_status, date_last_successful, owner, assignee, update_interval, url) VALUES (1, 75, '2007-06-25 20:04:04.226605', 52, 2, NULL, NULL, 20, NULL, 52, NULL, NULL, 'http://svn.example.org/svnroot/gnome-terminal/trunk');
@@ -3174,9 +3747,6 @@
ALTER TABLE codeimport ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codeimportmachine DISABLE TRIGGER ALL;
INSERT INTO codeimportmachine (id, date_created, hostname, state, heartbeat) VALUES (1, '2007-08-02 16:36:17.817407', 'bazaar-importer', 20, NULL);
@@ -3192,9 +3762,6 @@
ALTER TABLE codeimportevent ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codeimporteventdata DISABLE TRIGGER ALL;
@@ -3202,9 +3769,6 @@
ALTER TABLE codeimporteventdata ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codeimportjob DISABLE TRIGGER ALL;
INSERT INTO codeimportjob (id, date_created, code_import, machine, date_due, state, requesting_user, ordering, heartbeat, logtail, date_started) VALUES (1, '2007-12-05 16:07:57.276112', 1, NULL, '2007-12-05 16:07:57.276112', 10, NULL, NULL, NULL, NULL, NULL);
@@ -3213,12 +3777,6 @@
ALTER TABLE codeimportjob ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE codeimportresult DISABLE TRIGGER ALL;
@@ -3226,9 +3784,6 @@
ALTER TABLE codeimportresult ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codereviewmessage DISABLE TRIGGER ALL;
@@ -3236,9 +3791,6 @@
ALTER TABLE codereviewmessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codereviewvote DISABLE TRIGGER ALL;
@@ -3246,9 +3798,6 @@
ALTER TABLE codereviewvote ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE commercialsubscription DISABLE TRIGGER ALL;
INSERT INTO commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id) VALUES (1, '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.838229', '2022-01-01 00:00:00', 10, 16, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:37.838229+00:00');
@@ -3258,12 +3807,6 @@
ALTER TABLE commercialsubscription ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE componentselection DISABLE TRIGGER ALL;
INSERT INTO componentselection (id, distroseries, component, date_created) VALUES (1, 3, 1, '2006-10-16 18:31:43.257508');
@@ -3285,15 +3828,6 @@
ALTER TABLE componentselection ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE customlanguagecode DISABLE TRIGGER ALL;
@@ -3301,12 +3835,6 @@
ALTER TABLE customlanguagecode ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE cvereference DISABLE TRIGGER ALL;
INSERT INTO cvereference (id, cve, source, content, url, date_created) VALUES (1, 1, 'NAI', 'Known problem #234234', 'http://nai.com/testing/foobar/', '2006-10-16 18:31:43.386902');
@@ -3352,9 +3880,6 @@
ALTER TABLE cvereference ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE databasecpustats DISABLE TRIGGER ALL;
@@ -3390,12 +3915,6 @@
ALTER TABLE diff ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE distributionjob DISABLE TRIGGER ALL;
@@ -3403,9 +3922,6 @@
ALTER TABLE distributionjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distributionmirror DISABLE TRIGGER ALL;
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);
@@ -3423,9 +3939,6 @@
ALTER TABLE distributionmirror ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distributionsourcepackage DISABLE TRIGGER ALL;
@@ -3433,9 +3946,6 @@
ALTER TABLE distributionsourcepackage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distributionsourcepackagecache DISABLE TRIGGER ALL;
INSERT INTO distributionsourcepackagecache (id, distribution, sourcepackagename, name, binpkgnames, binpkgsummaries, binpkgdescriptions, fti, changelog, archive) VALUES (1, 3, 19, 'alsa-utils', '', '', '', NULL, NULL, 1);
@@ -3464,15 +3974,6 @@
ALTER TABLE distributionsourcepackagecache ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE packagediff DISABLE TRIGGER ALL;
INSERT INTO packagediff (id, date_requested, requester, from_source, to_source, date_fulfilled, diff_content, status) VALUES (1, '2011-03-22 13:27:38.178011', 16, 43, 40, NULL, NULL, 0);
@@ -3492,9 +3993,6 @@
ALTER TABLE distroseriesdifference ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distroseriesdifferencemessage DISABLE TRIGGER ALL;
INSERT INTO distroseriesdifferencemessage (id, distro_series_difference, message) VALUES (1, 1, 50);
@@ -3505,9 +4003,6 @@
ALTER TABLE distroseriesdifferencemessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distroserieslanguage DISABLE TRIGGER ALL;
INSERT INTO distroserieslanguage (id, distroseries, language, currentcount, updatescount, rosettacount, contributorcount, dateupdated, unreviewed_count) VALUES (1, 3, 68, 62, 0, 0, 1, '2007-01-15 17:58:40.839938', 0);
@@ -3534,9 +4029,6 @@
ALTER TABLE distroserieslanguage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distroseriespackagecache DISABLE TRIGGER ALL;
INSERT INTO distroseriespackagecache (id, distroseries, binarypackagename, name, summary, description, summaries, descriptions, fti, archive) VALUES (1, 3, 13, 'pmount', 'pmount shortdesc', 'pmount description', 'pmount shortdesc', 'pmount description', NULL, 1);
@@ -3550,9 +4042,6 @@
ALTER TABLE distroseriespackagecache ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distroseriesparent DISABLE TRIGGER ALL;
@@ -3560,9 +4049,6 @@
ALTER TABLE distroseriesparent ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE emailaddress DISABLE TRIGGER ALL;
INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (1, 'mark@xxxxxxxxxxx', 1, 4, '2006-10-16 18:31:43.540582');
@@ -3650,9 +4136,6 @@
ALTER TABLE emailaddress ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE faq DISABLE TRIGGER ALL;
INSERT INTO faq (id, title, tags, content, product, distribution, owner, date_created, last_updated_by, date_last_updated, fti) VALUES (1, 'Wireless Networking Documentation', 'wifi', 'Installation instructions for many wireless cards can be found at:
@@ -3719,9 +4202,6 @@
ALTER TABLE faq ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE pillarname DISABLE TRIGGER ALL;
INSERT INTO pillarname (id, name, product, project, distribution, active, alias_for) VALUES (1, 'ubuntu', NULL, NULL, 1, true, NULL);
@@ -3786,9 +4266,6 @@
ALTER TABLE featuredproject ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE featureflag DISABLE TRIGGER ALL;
INSERT INTO featureflag (scope, priority, flag, value, date_modified) VALUES ('default', 0, 'js.combo_loader.enabled', 'true', '2012-05-18 07:34:39.239649');
@@ -3806,9 +4283,6 @@
ALTER TABLE featureflagchangelogentry ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE flatpackagesetinclusion DISABLE TRIGGER ALL;
@@ -3821,12 +4295,6 @@
-
-
-
-
-
-
ALTER TABLE garbojobstate DISABLE TRIGGER ALL;
@@ -3834,9 +4302,6 @@
ALTER TABLE garbojobstate ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwvendorname DISABLE TRIGGER ALL;
INSERT INTO hwvendorname (id, name) VALUES (1, 'MSI');
@@ -3877,9 +4342,6 @@
ALTER TABLE hwdevice ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwdeviceclass DISABLE TRIGGER ALL;
@@ -3887,9 +4349,6 @@
ALTER TABLE hwdeviceclass ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwdriver DISABLE TRIGGER ALL;
INSERT INTO hwdriver (id, package_name, name, license) VALUES (1, 'linux-image-2.6.24-19-generic', 'ehci_hcd', NULL);
@@ -3929,9 +4388,6 @@
ALTER TABLE hwdevicedriverlink ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwdevicenamevariant DISABLE TRIGGER ALL;
@@ -3939,9 +4395,6 @@
ALTER TABLE hwdevicenamevariant ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwsystemfingerprint DISABLE TRIGGER ALL;
INSERT INTO hwsystemfingerprint (id, fingerprint) VALUES (1, 'TONKA TUFFBOOK2600');
@@ -3967,9 +4420,6 @@
ALTER TABLE hwdmihandle ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwdmivalue DISABLE TRIGGER ALL;
@@ -3977,15 +4427,6 @@
ALTER TABLE hwdmivalue ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE hwsubmissionbug DISABLE TRIGGER ALL;
@@ -3993,9 +4434,6 @@
ALTER TABLE hwsubmissionbug ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwsubmissiondevice DISABLE TRIGGER ALL;
INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (1, 1, 2, NULL, 11);
@@ -4024,12 +4462,6 @@
ALTER TABLE hwsubmissiondevice ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE hwtest DISABLE TRIGGER ALL;
@@ -4037,9 +4469,6 @@
ALTER TABLE hwtest ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwtestanswerchoice DISABLE TRIGGER ALL;
@@ -4054,12 +4483,6 @@
ALTER TABLE hwtestanswer ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE hwtestanswercount DISABLE TRIGGER ALL;
@@ -4067,9 +4490,6 @@
ALTER TABLE hwtestanswercount ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwtestanswercountdevice DISABLE TRIGGER ALL;
@@ -4077,9 +4497,6 @@
ALTER TABLE hwtestanswercountdevice ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwtestanswerdevice DISABLE TRIGGER ALL;
@@ -4087,15 +4504,6 @@
ALTER TABLE hwtestanswerdevice ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE incrementaldiff DISABLE TRIGGER ALL;
@@ -4103,9 +4511,6 @@
ALTER TABLE incrementaldiff ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE ircid DISABLE TRIGGER ALL;
INSERT INTO ircid (id, person, network, nickname) VALUES (1, 1, 'irc.freenode.net', 'mark');
@@ -4122,9 +4527,6 @@
ALTER TABLE ircid ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE jabberid DISABLE TRIGGER ALL;
INSERT INTO jabberid (id, person, jabberid) VALUES (1, 1, 'markshuttleworth@xxxxxxxxxx');
@@ -4142,12 +4544,6 @@
ALTER TABLE jabberid ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE karmacategory DISABLE TRIGGER ALL;
INSERT INTO karmacategory (id, name, title, summary) VALUES (2, 'bugs', 'Bug Management', 'This karma category covers work in the Malone bug tracking system, such as filing, closing and otherwise working with bugs.');
@@ -4300,12 +4696,6 @@
ALTER TABLE karma ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE karmacache DISABLE TRIGGER ALL;
INSERT INTO karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1423, 12, 6, 22, 6, NULL, NULL, NULL);
@@ -4371,12 +4761,6 @@
ALTER TABLE karmacache ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE karmatotalcache DISABLE TRIGGER ALL;
INSERT INTO karmatotalcache (id, person, karma_total) VALUES (78, 12, 138);
@@ -4388,12 +4772,6 @@
ALTER TABLE karmatotalcache ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE languagepack DISABLE TRIGGER ALL;
INSERT INTO languagepack (id, file, date_exported, date_last_used, distroseries, type, updates) VALUES (1, 71, '2007-09-10 19:14:26.037382', '2007-09-10 19:14:26.037382', 3, 1, NULL);
@@ -4405,9 +4783,6 @@
ALTER TABLE languagepack ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packagecopyjob DISABLE TRIGGER ALL;
@@ -4518,9 +4893,6 @@
ALTER TABLE latestpersonsourcepackagereleasecache ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE launchpaddatabaserevision DISABLE TRIGGER ALL;
@@ -4535,9 +4907,6 @@
ALTER TABLE launchpaddatabaseupdatelog ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE launchpadstatistic DISABLE TRIGGER ALL;
INSERT INTO launchpadstatistic (id, name, value, dateupdated) VALUES (1, 'potemplate_count', 10, '2007-03-18 17:27:46.221219');
@@ -4571,15 +4940,6 @@
ALTER TABLE launchpadstatistic ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE libraryfiledownloadcount DISABLE TRIGGER ALL;
@@ -4587,9 +4947,6 @@
ALTER TABLE libraryfiledownloadcount ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE logintoken DISABLE TRIGGER ALL;
INSERT INTO logintoken (id, requester, requesteremail, email, created, tokentype, token, fingerprint, redirection_url, date_consumed) VALUES (1, NULL, NULL, 'bac@xxxxxxxxxxxxx', '2008-06-27 14:48:38.308457', 3, 'mzsJ6LBvNKjFqP1Csfw7', NULL, 'http://launchpad.dev', '2008-06-27 14:49:11.149508');
@@ -4599,9 +4956,6 @@
ALTER TABLE logintoken ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE lp_account DISABLE TRIGGER ALL;
INSERT INTO lp_account (id, openid_identifier) VALUES (11, 'mark_oid');
@@ -5081,9 +5435,6 @@
ALTER TABLE mailinglist ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mailinglistsubscription DISABLE TRIGGER ALL;
@@ -5091,9 +5442,6 @@
ALTER TABLE mailinglistsubscription ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mergedirectivejob DISABLE TRIGGER ALL;
@@ -5101,12 +5449,6 @@
ALTER TABLE mergedirectivejob ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE messageapproval DISABLE TRIGGER ALL;
@@ -5114,9 +5456,6 @@
ALTER TABLE messageapproval ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE messagechunk DISABLE TRIGGER ALL;
INSERT INTO messagechunk (id, message, sequence, content, blob, fti) VALUES (1, 7, 1, 'Malone pages that use more complex layouts with portlets and fancy CSS are sometimes not getting properly reflowed after rendering.', NULL, NULL);
@@ -5570,12 +5909,6 @@
ALTER TABLE messagechunk ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE milestonetag DISABLE TRIGGER ALL;
@@ -5583,9 +5916,6 @@
ALTER TABLE milestonetag ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirror DISABLE TRIGGER ALL;
@@ -5593,9 +5923,6 @@
ALTER TABLE mirror ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrorcdimagedistroseries DISABLE TRIGGER ALL;
INSERT INTO mirrorcdimagedistroseries (id, distribution_mirror, distroseries, flavour, date_created) VALUES (1, 6, 1, 'ubuntu', '2006-10-16 18:31:44.303183');
@@ -5607,9 +5934,6 @@
ALTER TABLE mirrorcdimagedistroseries ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrorcontent DISABLE TRIGGER ALL;
@@ -5617,9 +5941,6 @@
ALTER TABLE mirrorcontent ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrordistroarchseries DISABLE TRIGGER ALL;
INSERT INTO mirrordistroarchseries (id, distribution_mirror, distroarchseries, freshness, pocket, component, date_created) VALUES (1, 7, 1, 2, 10, 1, '2006-10-16 18:31:44.309753');
@@ -5631,9 +5952,6 @@
ALTER TABLE mirrordistroarchseries ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrordistroseriessource DISABLE TRIGGER ALL;
INSERT INTO mirrordistroseriessource (id, distribution_mirror, distroseries, freshness, pocket, component, date_created) VALUES (1, 7, 1, 1, 10, 1, '2006-10-16 18:31:44.314175');
@@ -5646,9 +5964,6 @@
ALTER TABLE mirrordistroseriessource ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrorproberecord DISABLE TRIGGER ALL;
INSERT INTO mirrorproberecord (id, distribution_mirror, log_file, date_created) VALUES (1, 6, 46, '2006-05-24 17:11:59.37369');
@@ -5658,9 +5973,6 @@
ALTER TABLE mirrorproberecord ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrorsourcecontent DISABLE TRIGGER ALL;
@@ -5668,9 +5980,6 @@
ALTER TABLE mirrorsourcecontent ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE nameblacklist DISABLE TRIGGER ALL;
INSERT INTO nameblacklist (id, regexp, comment, admin) VALUES (1, 'blacklist', 'For testing purposes', NULL);
@@ -5680,9 +5989,6 @@
ALTER TABLE nameblacklist ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE oauthconsumer DISABLE TRIGGER ALL;
INSERT INTO oauthconsumer (id, date_created, disabled, key, secret) VALUES (1, '2008-03-18 20:57:19.108004', false, 'foobar123451432', '');
@@ -5702,12 +6008,6 @@
ALTER TABLE oauthaccesstoken ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE oauthnonce DISABLE TRIGGER ALL;
@@ -5722,9 +6022,6 @@
ALTER TABLE oauthrequesttoken ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE officialbugtag DISABLE TRIGGER ALL;
@@ -5732,9 +6029,6 @@
ALTER TABLE officialbugtag ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE openidconsumerassociation DISABLE TRIGGER ALL;
@@ -5824,9 +6118,6 @@
ALTER TABLE openididentifier ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packagecopyrequest DISABLE TRIGGER ALL;
@@ -5834,18 +6125,6 @@
ALTER TABLE packagecopyrequest ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
-
-
-
ALTER TABLE packagesetinclusion DISABLE TRIGGER ALL;
@@ -5853,9 +6132,6 @@
ALTER TABLE packagesetinclusion ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packagesetsources DISABLE TRIGGER ALL;
@@ -5863,12 +6139,6 @@
ALTER TABLE packagesetsources ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE packageuploadbuild DISABLE TRIGGER ALL;
INSERT INTO packageuploadbuild (id, packageupload, build, date_created) VALUES (1, 1, 18, '2006-10-16 18:31:43.529327');
@@ -5879,9 +6149,6 @@
ALTER TABLE packageuploadbuild ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packageuploadcustom DISABLE TRIGGER ALL;
INSERT INTO packageuploadcustom (id, packageupload, customformat, libraryfilealias, date_created) VALUES (1, 5, 1, 1, '2006-10-16 18:31:43.532702');
@@ -5893,9 +6160,6 @@
ALTER TABLE packageuploadcustom ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packageuploadsource DISABLE TRIGGER ALL;
INSERT INTO packageuploadsource (id, packageupload, sourcepackagerelease, date_created) VALUES (1, 3, 17, '2006-10-16 18:31:43.536296');
@@ -5911,9 +6175,6 @@
ALTER TABLE packageuploadsource ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packaging DISABLE TRIGGER ALL;
INSERT INTO packaging (packaging, id, sourcepackagename, distroseries, productseries, datecreated, owner, date_created) VALUES (1, 1, 1, 3, 2, '2005-07-05 14:20:26.577312', NULL, '2006-10-16 18:31:44.336247');
@@ -5930,9 +6191,6 @@
ALTER TABLE packaging ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE potemplate DISABLE TRIGGER ALL;
INSERT INTO potemplate (id, priority, description, copyright, datecreated, path, iscurrent, messagecount, owner, sourcepackagename, distroseries, sourcepackageversion, header, binarypackagename, languagepack, productseries, from_sourcepackagename, date_last_updated, source_file, source_file_format, name, translation_domain) VALUES (1, 0, 'Template for evolution in hoary', NULL, '2005-03-18 18:20:12.273149', 'po/evolution-2.2.pot', true, 22, 30, NULL, NULL, NULL, 'Project-Id-Version: PACKAGE VERSION
@@ -6046,9 +6304,6 @@
ALTER TABLE packagingjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE parsedapachelog DISABLE TRIGGER ALL;
@@ -6056,12 +6311,6 @@
ALTER TABLE parsedapachelog ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE personlanguage DISABLE TRIGGER ALL;
INSERT INTO personlanguage (id, person, language, date_created) VALUES (1, 13, 387, '2006-10-16 18:31:44.536264');
@@ -6079,9 +6328,6 @@
ALTER TABLE personlanguage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE personlocation DISABLE TRIGGER ALL;
INSERT INTO personlocation (id, date_created, person, latitude, longitude, time_zone, last_modified_by, date_last_modified, visible, locked) VALUES (1, '2007-06-05 18:34:52.127945', 12, NULL, NULL, 'Australia/Perth', 12, '2007-06-05 18:34:52.127945', true, false);
@@ -6095,9 +6341,6 @@
ALTER TABLE personlocation ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE personnotification DISABLE TRIGGER ALL;
@@ -6105,9 +6348,6 @@
ALTER TABLE personnotification ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE personsettings DISABLE TRIGGER ALL;
INSERT INTO personsettings (person, selfgenerated_bugnotifications) VALUES (1, true);
@@ -6217,12 +6457,6 @@
ALTER TABLE persontransferjob ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE pocketchroot DISABLE TRIGGER ALL;
@@ -6230,9 +6464,6 @@
ALTER TABLE pocketchroot ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE pofile DISABLE TRIGGER ALL;
INSERT INTO pofile (id, potemplate, language, description, topcomment, header, fuzzyheader, lasttranslator, currentcount, updatescount, rosettacount, lastparsed, owner, path, datecreated, from_sourcepackagename, unreviewed_count, date_changed) VALUES (1, 1, 387, 'Spanish translation for evolution in hoary', ' traducción de es.po al Spanish
@@ -6845,12 +7076,6 @@
ALTER TABLE poexportrequest ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE pofilestatsjob DISABLE TRIGGER ALL;
@@ -6900,9 +7125,6 @@
ALTER TABLE pofiletranslator ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE poll DISABLE TRIGGER ALL;
INSERT INTO poll (id, team, name, title, dateopens, datecloses, proposition, type, allowspoilt, secrecy, date_created) VALUES (1, 17, 'director-2004', '2004 Director''s Elections', '2004-01-01 00:00:00', '2004-01-15 00:00:00', 'Who''s going to be the next director?', 2, true, 3, '2006-10-16 18:31:44.605729');
@@ -6917,9 +7139,6 @@
ALTER TABLE poll ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE polloption DISABLE TRIGGER ALL;
INSERT INTO polloption (id, poll, name, title, active, date_created) VALUES (1, 1, 'A', 'A', true, '2006-10-16 18:31:44.620851');
@@ -6951,9 +7170,6 @@
ALTER TABLE polloption ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE pomsgid DISABLE TRIGGER ALL;
INSERT INTO pomsgid (id, msgid) VALUES (1, 'evolution addressbook');
@@ -7268,12 +7484,6 @@
ALTER TABLE pomsgid ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE potmsgset DISABLE TRIGGER ALL;
INSERT INTO potmsgset (id, msgid_singular, commenttext, filereferences, sourcecomment, flagscomment, context, msgid_plural) VALUES (1, 1, '', 'a11y/addressbook/ea-addressbook-view.c:94
@@ -7500,9 +7710,6 @@
ALTER TABLE potmsgset ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE potranslation DISABLE TRIGGER ALL;
INSERT INTO potranslation (id, translation) VALUES (1, 'libreta de direcciones de Evolution');
@@ -8863,9 +9070,6 @@
ALTER TABLE potranslation ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE previewdiff DISABLE TRIGGER ALL;
@@ -8873,9 +9077,6 @@
ALTER TABLE previewdiff ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE processacceptedbugsjob DISABLE TRIGGER ALL;
@@ -8883,12 +9084,6 @@
ALTER TABLE processacceptedbugsjob ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE productjob DISABLE TRIGGER ALL;
@@ -8896,9 +9091,6 @@
ALTER TABLE productjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE productlicense DISABLE TRIGGER ALL;
INSERT INTO productlicense (id, product, license) VALUES (1, 1, 10);
@@ -8934,9 +9126,6 @@
ALTER TABLE productlicense ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE productrelease DISABLE TRIGGER ALL;
INSERT INTO productrelease (id, datereleased, release_notes, changelog, owner, datecreated, milestone) VALUES (1, '2004-06-28 00:00:00', '', '', 12, '2005-06-06 08:59:51.930201', 7);
@@ -9109,9 +9298,6 @@
ALTER TABLE productrelease ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE productreleasefile DISABLE TRIGGER ALL;
INSERT INTO productreleasefile (productrelease, libraryfile, filetype, id, description, uploader, date_uploaded, fti, signature) VALUES (5, 3, 1, 2, NULL, 16, '2005-06-06 08:59:51.926792', NULL, NULL);
@@ -9129,15 +9315,6 @@
ALTER TABLE productreleasefile ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE publisherconfig DISABLE TRIGGER ALL;
INSERT INTO publisherconfig (id, distribution, root_dir, base_url, copy_base_url) VALUES (1, 1, '/var/tmp/archive', 'http://archive.launchpad.dev/', 'http://rebuild-test.internal/');
@@ -9147,9 +9324,6 @@
ALTER TABLE publisherconfig ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE question DISABLE TRIGGER ALL;
INSERT INTO question (id, owner, title, description, assignee, answerer, product, distribution, sourcepackagename, status, priority, datecreated, datelastquery, dateaccepted, datedue, datelastresponse, date_solved, dateclosed, whiteboard, fti, answer, language, faq) VALUES (1, 11, 'Firefox cannot render Bank Site', 'Hello, I''m trying to access http://www.citibank.com/ and the page is not rendering correctly. Is there a setting I can use to get it right? Thanks.', NULL, NULL, 4, NULL, NULL, 10, 10, '2005-09-05 18:46:07.392021', '2005-09-05 18:46:07.392021', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 119, NULL);
@@ -9190,9 +9364,6 @@
ALTER TABLE question ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE questionbug DISABLE TRIGGER ALL;
@@ -9200,9 +9371,6 @@
ALTER TABLE questionbug ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE questionjob DISABLE TRIGGER ALL;
@@ -9210,9 +9378,6 @@
ALTER TABLE questionjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE questionmessage DISABLE TRIGGER ALL;
INSERT INTO questionmessage (id, question, message, action, new_status, owner) VALUES (1, 6, 12, 35, 18, 16);
@@ -9228,9 +9393,6 @@
ALTER TABLE questionmessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE questionreopening DISABLE TRIGGER ALL;
@@ -9238,9 +9400,6 @@
ALTER TABLE questionreopening ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE questionsubscription DISABLE TRIGGER ALL;
INSERT INTO questionsubscription (id, question, person, date_created) VALUES (1, 7, 16, '2006-10-16 18:31:53.201104');
@@ -9257,15 +9416,6 @@
ALTER TABLE questionsubscription ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE revisioncache DISABLE TRIGGER ALL;
@@ -9273,9 +9423,6 @@
ALTER TABLE revisioncache ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE revisionparent DISABLE TRIGGER ALL;
INSERT INTO revisionparent (id, sequence, revision, parent_id) VALUES (1, 0, 5, 'test@xxxxxxxxxxxxx-20051031165248-6f1bb97973c2b4f4');
@@ -9293,9 +9440,6 @@
ALTER TABLE revisionparent ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE revisionproperty DISABLE TRIGGER ALL;
INSERT INTO revisionproperty (id, revision, name, value) VALUES (1, 11, 'lp:foo', 'extended value');
@@ -9305,9 +9449,6 @@
ALTER TABLE revisionproperty ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE scriptactivity DISABLE TRIGGER ALL;
INSERT INTO scriptactivity (id, name, hostname, date_started, date_completed) VALUES (1, 'launchpad-targetnamecacheupdater', 'whatever', '2007-08-08 17:02:22.963565', '2007-08-08 17:02:23.869575');
@@ -9317,12 +9458,6 @@
ALTER TABLE scriptactivity ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE sectionselection DISABLE TRIGGER ALL;
INSERT INTO sectionselection (id, distroseries, section, date_created) VALUES (1, 3, 3, '2006-10-16 18:31:52.554214');
@@ -9413,9 +9548,6 @@
ALTER TABLE sectionselection ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE seriessourcepackagebranch DISABLE TRIGGER ALL;
@@ -9423,9 +9555,6 @@
ALTER TABLE seriessourcepackagebranch ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sharingjob DISABLE TRIGGER ALL;
@@ -9433,9 +9562,6 @@
ALTER TABLE sharingjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE signedcodeofconduct DISABLE TRIGGER ALL;
INSERT INTO signedcodeofconduct (id, owner, signingkey, datecreated, signedcode, recipient, active, admincomment) VALUES (1, 16, 1, '2005-09-27 10:01:13', 'Sampledata signedcode', NULL, true, NULL);
@@ -9444,9 +9570,6 @@
ALTER TABLE signedcodeofconduct ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sourcepackageformatselection DISABLE TRIGGER ALL;
INSERT INTO sourcepackageformatselection (id, distroseries, format) VALUES (1, 1, 0);
@@ -9467,21 +9590,6 @@
ALTER TABLE sourcepackageformatselection ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
ALTER TABLE sourcepackagerecipebuildjob DISABLE TRIGGER ALL;
@@ -9489,9 +9597,6 @@
ALTER TABLE sourcepackagerecipebuildjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sourcepackagerecipedata DISABLE TRIGGER ALL;
@@ -9499,9 +9604,6 @@
ALTER TABLE sourcepackagerecipedata ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sourcepackagerecipedatainstruction DISABLE TRIGGER ALL;
@@ -9509,9 +9611,6 @@
ALTER TABLE sourcepackagerecipedatainstruction ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sourcepackagerecipedistroseries DISABLE TRIGGER ALL;
@@ -9519,12 +9618,6 @@
ALTER TABLE sourcepackagerecipedistroseries ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE sourcepackagereleasefile DISABLE TRIGGER ALL;
INSERT INTO sourcepackagereleasefile (sourcepackagerelease, libraryfile, filetype, id) VALUES (14, 3, 6, 6);
@@ -9546,12 +9639,6 @@
ALTER TABLE sourcepackagereleasefile ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE specificationbranch DISABLE TRIGGER ALL;
INSERT INTO specificationbranch (id, datecreated, specification, branch, summary, registrant) VALUES (1, '2006-11-02 09:07:48.389829', 6, 20, 'This branch should fix the issue', 12);
@@ -9560,9 +9647,6 @@
ALTER TABLE specificationbranch ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationbug DISABLE TRIGGER ALL;
INSERT INTO specificationbug (id, specification, bug) VALUES (1, 3, 1);
@@ -9571,9 +9655,6 @@
ALTER TABLE specificationbug ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationdependency DISABLE TRIGGER ALL;
INSERT INTO specificationdependency (id, specification, dependency, date_created) VALUES (1, 4, 3, '2006-10-16 18:31:52.855436');
@@ -9583,9 +9664,6 @@
ALTER TABLE specificationdependency ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationmessage DISABLE TRIGGER ALL;
@@ -9593,9 +9671,6 @@
ALTER TABLE specificationmessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationsubscription DISABLE TRIGGER ALL;
INSERT INTO specificationsubscription (id, specification, person, essential, date_created) VALUES (1, 3, 16, false, '2006-10-16 18:31:52.870628');
@@ -9608,9 +9683,6 @@
ALTER TABLE specificationsubscription ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationworkitem DISABLE TRIGGER ALL;
@@ -9618,9 +9690,6 @@
ALTER TABLE specificationworkitem ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationworkitemchange DISABLE TRIGGER ALL;
@@ -9628,9 +9697,6 @@
ALTER TABLE specificationworkitemchange ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationworkitemstats DISABLE TRIGGER ALL;
@@ -9638,9 +9704,6 @@
ALTER TABLE specificationworkitemstats ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE spokenin DISABLE TRIGGER ALL;
INSERT INTO spokenin (language, country, id) VALUES (1, 60, 165);
@@ -9925,9 +9988,6 @@
ALTER TABLE spokenin ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sprint DISABLE TRIGGER ALL;
INSERT INTO sprint (id, owner, name, title, summary, home_page, address, time_zone, time_starts, time_ends, datecreated, driver, homepage_content, icon, mugshot, logo) VALUES (1, 12, 'ubz', 'Ubuntu Below Zero', 'This is the next Ubuntu developer Summit. Join us in Montreal for discussions around Ubuntu and Launchpad. The focus will be the road to Dapper, our April 2006 release, focused on the enterprise.', 'http://wiki.ubuntu.com/UbuntuBelowZero', 'Montreal, Canada', 'US/Eastern', '2005-10-07 23:30:00', '2005-11-17 00:11:00', '2005-09-15 09:04:01.762108', NULL, NULL, NULL, NULL, NULL);
@@ -9939,9 +9999,6 @@
ALTER TABLE sprint ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sprintattendance DISABLE TRIGGER ALL;
@@ -9949,9 +10006,6 @@
ALTER TABLE sprintattendance ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sprintspecification DISABLE TRIGGER ALL;
INSERT INTO sprintspecification (id, sprint, specification, status, whiteboard, registrant, date_created, decider, date_decided) VALUES (1, 1, 3, 10, NULL, 16, '2006-08-05 23:54:10.835093', 12, '2006-08-05 23:54:10.835093');
@@ -9964,9 +10018,6 @@
ALTER TABLE sprintspecification ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sshkey DISABLE TRIGGER ALL;
INSERT INTO sshkey (id, person, keytype, keytext, comment, date_created) VALUES (1, 12, 2, 'AAAAB3NzaC1kc3MAAAEBAPfhCA15ZaT08brwVXwpJjcZT6QFIipzF1sGy57HY7QPi/W+uljr1VcCHzWdlSmda7YpTCTx0NFYYQIccQRGX6zYL8v1w9FSRCAnxxUJmqEhsUDFYFdVTa9uLCrs3MSbmh7wwFPdRrGrO6X5x7T4dMZQwykSZrOVdpLcCHRgrMZslLomIAjERn6OAQNiGFz7B2tEi/3Soqd52bGJwOtGymRiAXkPSLbH7KfzSCe34ytdh6BD+4SrgSoa+TL3VDV70QAdlOFXD42ZHl3Sc0Tde4LbZeYq2Uf84DOATLZBbOYpRSqTLkM9XngpnvCRVb6dxEQfgODDw783tEuPpySLj2EAAAAVANpUVgivDjt9gFibN/AXfYy1meeBAAABAB6FtnMywmWZg2lr2I3nDfE5U5QbGUQB/ZEP98ZkSkhOcF29VlnGOxyb2/VZbVTLa/btlPF82L4An/c8VKtKZnel7LnAlMoArdgzQNXGVQQVtnaWwM26ydgDzkSSIes3elNZgsfnPRBvaF0ol9Tqju0rNGKjnr3ZOX/NX+42bxpjRnxYj1h56yP2jKKeGfjorI6JK1YfqBAiTxzaDMzSpknnrbztaKJoh7IFqMMOp9ANSFh7H106pEaCv3ebCTJZprtWqNKjb2zum7OQPRz3upA0qx22ocTokjv4itXJ6yj/BvGu9qdOIQFXuB2rsFtLZtS8ATueOly0GzyeiZBx/AEAAAEBAO8jRYjL7tAYnVlO1p6UzPOicAuGCFWfNbBEDRAXoSgLNdj451jStw+eUc9ZVz7tG/XRVZsiavtFHb2cbrcfX1YOd69xi0m+IY6mo3yKt3irQRokDtt376sHoUdHgj2ozySZJgG8IJndtoS+VQQy6NdClA3fNFb96bF865eNaRYoHJO9ZI84lkWQL++MLzIuyFfCs1hSlapyyuHC8kFmF7AQdrVZvbohSbnWs+w53nIW8nAA7z21wAukvE1Pl6AQyG0e7U1sYS8Pc8dtmzJvdtVZWBl02/gqQJ7f06mFvnsN45rR1Uyxnrwl6rbFwqabZDlyD5Ac6Icbvz9SG1gBOiI=', 'andrew@trogdor', '2006-10-16 18:31:53.030784');
@@ -9976,12 +10027,6 @@
ALTER TABLE sshkey ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE subunitstream DISABLE TRIGGER ALL;
@@ -9989,9 +10034,6 @@
ALTER TABLE subunitstream ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE suggestivepotemplate DISABLE TRIGGER ALL;
@@ -10107,9 +10149,6 @@
ALTER TABLE teammembership ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE teamparticipation DISABLE TRIGGER ALL;
INSERT INTO teamparticipation (id, team, person) VALUES (1, 17, 1);
@@ -10317,15 +10356,6 @@
ALTER TABLE teamparticipation ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE translationimportqueueentry DISABLE TRIGGER ALL;
INSERT INTO translationimportqueueentry (id, path, content, importer, dateimported, distroseries, sourcepackagename, productseries, by_maintainer, pofile, potemplate, status, date_status_changed, format, error_output) VALUES (1, 'po/evolution-2.2-test.pot', 57, 16, '2006-12-13 21:17:56.241901', NULL, NULL, 3, true, NULL, 6, 2, '2006-12-13 21:18:40.885499', 1, NULL);
@@ -10335,9 +10365,6 @@
ALTER TABLE translationimportqueueentry ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE translationmessage DISABLE TRIGGER ALL;
INSERT INTO translationmessage (id, potmsgset, date_created, submitter, date_reviewed, reviewer, msgstr0, msgstr1, msgstr2, msgstr3, comment, origin, validation_status, is_current_ubuntu, is_fuzzy, is_current_upstream, was_obsolete_in_last_import, was_fuzzy_in_last_import, msgstr4, msgstr5, potemplate, language) VALUES (1, 1, '2005-04-07 13:19:17.601068', 13, '2005-04-07 13:19:17.601068', 13, 1, NULL, NULL, NULL, '', 1, 1, true, false, true, false, false, NULL, NULL, 1, 387);
@@ -11000,9 +11027,6 @@
ALTER TABLE translationmessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE translationrelicensingagreement DISABLE TRIGGER ALL;
INSERT INTO translationrelicensingagreement (id, person, allow_relicensing, date_decided) VALUES (201, 58, true, '2008-05-23 16:29:22.319166');
@@ -11071,9 +11095,6 @@
ALTER TABLE translationrelicensingagreement ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE translationtemplateitem DISABLE TRIGGER ALL;
INSERT INTO translationtemplateitem (id, potemplate, sequence, potmsgset) VALUES (1, 1, 1, 1);
@@ -11277,9 +11298,6 @@
ALTER TABLE translationtemplateitem ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE translationtemplatesbuild DISABLE TRIGGER ALL;
@@ -11287,9 +11305,6 @@
ALTER TABLE translationtemplatesbuild ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE translator DISABLE TRIGGER ALL;
INSERT INTO translator (id, translationgroup, language, translator, datecreated, style_guide_url) VALUES (1, 1, 387, 53, '2005-07-13 13:14:19.748396', NULL);
@@ -11298,9 +11313,6 @@
ALTER TABLE translator ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE usertouseremail DISABLE TRIGGER ALL;
@@ -11308,9 +11320,6 @@
ALTER TABLE usertouseremail ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE vote DISABLE TRIGGER ALL;
INSERT INTO vote (id, person, poll, preference, option, token) VALUES (1, NULL, 1, 1, 4, '9WjxQq2V9p');
@@ -11346,9 +11355,6 @@
ALTER TABLE vote ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE votecast DISABLE TRIGGER ALL;
INSERT INTO votecast (id, person, poll) VALUES (1, 6, 1);
@@ -11366,9 +11372,6 @@
ALTER TABLE votecast ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE wikiname DISABLE TRIGGER ALL;
INSERT INTO wikiname (id, person, wiki, wikiname) VALUES (1, 1, 'https://wiki.ubuntu.com/', 'MarkShuttleworth');
@@ -11378,6 +11381,3 @@
ALTER TABLE wikiname ENABLE TRIGGER ALL;
-
-
-
=== modified file 'database/sampledata/current.sql'
--- database/sampledata/current.sql 2013-09-11 06:13:28 +0000
+++ database/sampledata/current.sql 2013-10-11 12:06:15 +0000
@@ -1,6 +1,6 @@
-- Copyright 2010-2013 Canonical Ltd. This software is licensed under the
-- GNU Affero General Public License version 3 (see the file LICENSE).
--- Created using pg_dump (PostgreSQL) 9.1.9
+-- Created using pg_dump (PostgreSQL) 9.1.4
SET check_function_bodies = false;
SET client_encoding = 'UTF8';
@@ -12,6 +12,747 @@
SET search_path = public, pg_catalog;
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
SET SESSION AUTHORIZATION DEFAULT;
ALTER TABLE account DISABLE TRIGGER ALL;
@@ -1369,9 +2110,6 @@
ALTER TABLE accessartifact ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE accessartifactgrant DISABLE TRIGGER ALL;
INSERT INTO accessartifactgrant (artifact, grantee, grantor, date_created) VALUES (1, 14, 65, '2007-08-09 11:39:16.836856');
@@ -1456,9 +2194,6 @@
ALTER TABLE accesspolicy ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE accesspolicyartifact DISABLE TRIGGER ALL;
INSERT INTO accesspolicyartifact (artifact, policy) VALUES (1, 2);
@@ -1491,12 +2226,6 @@
ALTER TABLE accesspolicygrantflat ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE announcement DISABLE TRIGGER ALL;
INSERT INTO announcement (id, date_created, date_announced, registrant, product, distribution, project, title, summary, url, active, date_updated) VALUES (1, '2007-11-25 00:44:32.186178', '2007-11-20 03:00:00', 1, NULL, 1, NULL, 'Every Macedonian Student to Use Ubuntu-Powered Computer Workstations', 'The Macedonia Ministry of Education and Science will deploy more than 180,000 workstations running Canonical’s Edubuntu 7.04 as part of its "Computer for Every Child" project.', 'http://www.ubuntu.com/news/macedonia-school-computers', true, NULL);
@@ -1554,9 +2283,6 @@
ALTER TABLE announcement ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE answercontact DISABLE TRIGGER ALL;
INSERT INTO answercontact (id, product, distribution, sourcepackagename, person, date_created) VALUES (1, NULL, 1, 1, 16, '2007-03-14 20:07:25.233772');
@@ -1568,9 +2294,6 @@
ALTER TABLE answercontact ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE job DISABLE TRIGGER ALL;
INSERT INTO job (id, requester, reason, status, progress, last_report_seen, next_report_due, attempt_count, max_retries, log, scheduled_start, lease_expires, date_created, date_started, date_finished, json_data, job_type) VALUES (1, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, '2005-06-15 09:14:12.820778', '2005-06-15 09:20:12.820778', NULL, NULL, NULL);
@@ -1594,9 +2317,6 @@
ALTER TABLE apportjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE gpgkey DISABLE TRIGGER ALL;
INSERT INTO gpgkey (id, owner, keyid, fingerprint, active, algorithm, keysize, can_encrypt, date_created) VALUES (1, 16, '12345678', 'ABCDEF0123456789ABCDDCBA0000111112345678', true, 17, 1024, true, '2006-10-16 18:31:43.631499');
@@ -1625,9 +2345,6 @@
ALTER TABLE archive ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE archivearch DISABLE TRIGGER ALL;
@@ -1635,9 +2352,6 @@
ALTER TABLE archivearch ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE archiveauthtoken DISABLE TRIGGER ALL;
@@ -1645,9 +2359,6 @@
ALTER TABLE archiveauthtoken ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE component DISABLE TRIGGER ALL;
INSERT INTO component (id, name, description) VALUES (1, 'main', NULL);
@@ -1667,9 +2378,6 @@
ALTER TABLE archivedependency ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE archivejob DISABLE TRIGGER ALL;
@@ -1677,9 +2385,6 @@
ALTER TABLE archivejob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packagesetgroup DISABLE TRIGGER ALL;
@@ -1718,9 +2423,6 @@
ALTER TABLE archivepermission ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE archivesubscriber DISABLE TRIGGER ALL;
@@ -1728,13 +2430,10 @@
ALTER TABLE archivesubscriber ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE builder DISABLE TRIGGER ALL;
-INSERT INTO builder (id, processor, name, title, owner, speedindex, builderok, failnotes, virtualized, url, manual, date_created, vm_host, active, failure_count) VALUES (1, 1, 'bob', 'Bob The Builder', 61, NULL, true, NULL, false, 'http://localhost:8221/', false, '2006-10-16 18:31:43.226724', NULL, true, 0);
-INSERT INTO builder (id, processor, name, title, owner, speedindex, builderok, failnotes, virtualized, url, manual, date_created, vm_host, active, failure_count) VALUES (2, 1, 'frog', 'The frog builder', 61, NULL, false, NULL, true, 'http://localhost:9221/', false, '2006-10-31 18:31:43.226724', 'localhost-host.ppa', true, 0);
+INSERT INTO builder (id, processor, name, title, owner, speedindex, builderok, failnotes, virtualized, url, manual, date_created, vm_host, active, failure_count, version) VALUES (1, 1, 'bob', 'Bob The Builder', 61, NULL, true, NULL, false, 'http://localhost:8221/', false, '2006-10-16 18:31:43.226724', NULL, true, 0, NULL);
+INSERT INTO builder (id, processor, name, title, owner, speedindex, builderok, failnotes, virtualized, url, manual, date_created, vm_host, active, failure_count, version) VALUES (2, 1, 'frog', 'The frog builder', 61, NULL, false, NULL, true, 'http://localhost:9221/', false, '2006-10-31 18:31:43.226724', 'localhost-host.ppa', true, 0, NULL);
ALTER TABLE builder ENABLE TRIGGER ALL;
@@ -1937,9 +2636,6 @@
ALTER TABLE binarypackagebuild ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE binarypackagename DISABLE TRIGGER ALL;
INSERT INTO binarypackagename (id, name) VALUES (6, 'foobar');
@@ -1993,12 +2689,6 @@
ALTER TABLE binarypackagefile ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE binarypackagepath DISABLE TRIGGER ALL;
@@ -2006,9 +2696,6 @@
ALTER TABLE binarypackagepath ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE binarypackagepublishinghistory DISABLE TRIGGER ALL;
INSERT INTO binarypackagepublishinghistory (id, binarypackagerelease, distroarchseries, status, component, section, priority, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, binarypackagename, phased_update_percentage) VALUES (9, 12, 1, 2, 1, 1, 10, '2005-05-05 00:00:00', '2005-06-18 00:00:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, 8, NULL);
@@ -2042,12 +2729,6 @@
ALTER TABLE binarypackagepublishinghistory ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE binarypackagereleasecontents DISABLE TRIGGER ALL;
@@ -2323,12 +3004,6 @@
ALTER TABLE binarypackagereleasedownloadcount ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE branchjob DISABLE TRIGGER ALL;
@@ -2336,9 +3011,6 @@
ALTER TABLE branchjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE branchmergeproposal DISABLE TRIGGER ALL;
@@ -2346,9 +3018,6 @@
ALTER TABLE branchmergeproposal ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE branchmergeproposaljob DISABLE TRIGGER ALL;
@@ -2356,12 +3025,6 @@
ALTER TABLE branchmergeproposaljob ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE revisionauthor DISABLE TRIGGER ALL;
INSERT INTO revisionauthor (id, name, email, person) VALUES (1, 'mark.shuttleworth', NULL, NULL);
@@ -2438,12 +3101,6 @@
ALTER TABLE branchsubscription ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE bugactivity DISABLE TRIGGER ALL;
INSERT INTO bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (1, 1, '2004-09-24 00:00:00', 1, 'title', 'A silly problem', 'An odd problem', 'Decided problem wasn''t silly after all');
@@ -2487,9 +3144,6 @@
ALTER TABLE bugactivity ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugaffectsperson DISABLE TRIGGER ALL;
@@ -2497,9 +3151,6 @@
ALTER TABLE bugaffectsperson ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE message DISABLE TRIGGER ALL;
INSERT INTO message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible) VALUES (1, '2004-09-24 20:58:04.684057', 'PEBCAK', 16, NULL, NULL, 'foo@xxxxxxxxxxx-332342--1231', NULL, NULL, true);
@@ -2562,9 +3213,6 @@
ALTER TABLE bugattachment ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugbranch DISABLE TRIGGER ALL;
INSERT INTO bugbranch (id, datecreated, bug, branch, revision_hint, whiteboard, registrant) VALUES (1, '2006-03-22 18:44:27.438982', 5, 1, NULL, NULL, 12);
@@ -2575,9 +3223,6 @@
ALTER TABLE bugbranch ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE cve DISABLE TRIGGER ALL;
INSERT INTO cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (1, '1999-8979', 2, 'Firefox crashes all the time', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.508959', NULL);
@@ -2604,9 +3249,6 @@
ALTER TABLE bugcve ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugwatch DISABLE TRIGGER ALL;
INSERT INTO bugwatch (id, bug, bugtracker, remotebug, remotestatus, lastchanged, lastchecked, datecreated, owner, last_error_type, remote_importance, remote_lp_bug_id, next_check) VALUES (1, 2, 1, '42', 'FUBAR', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', 12, NULL, 'BAZBAZ', NULL, NULL);
@@ -2669,9 +3311,6 @@
ALTER TABLE bugmessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugmute DISABLE TRIGGER ALL;
@@ -2690,9 +3329,6 @@
ALTER TABLE bugnomination ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugnotification DISABLE TRIGGER ALL;
@@ -2700,9 +3336,6 @@
ALTER TABLE bugnotification ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugnotificationarchive DISABLE TRIGGER ALL;
@@ -2717,9 +3350,6 @@
ALTER TABLE bugnotificationattachment ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE structuralsubscription DISABLE TRIGGER ALL;
INSERT INTO structuralsubscription (id, product, productseries, project, milestone, distribution, distroseries, sourcepackagename, subscriber, subscribed_by, date_created, date_last_updated) VALUES (1, NULL, NULL, NULL, NULL, 1, NULL, 1, 16, 16, '2008-01-29 15:12:34.581468', '2008-01-29 15:12:34.581468');
@@ -2756,9 +3386,6 @@
ALTER TABLE bugnotificationrecipient ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugnotificationrecipientarchive DISABLE TRIGGER ALL;
@@ -2788,12 +3415,6 @@
ALTER TABLE bugsubscription ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE bugsubscriptionfilterimportance DISABLE TRIGGER ALL;
@@ -2829,9 +3450,6 @@
ALTER TABLE bugsubscriptionfiltertag ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugsummary DISABLE TRIGGER ALL;
INSERT INTO bugsummary (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy) VALUES (65, 1, 20, NULL, NULL, NULL, NULL, 14, 'lunch-money', 10, NULL, 5, false, NULL);
@@ -2905,9 +3523,6 @@
ALTER TABLE bugsummary ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugsummaryjournal DISABLE TRIGGER ALL;
@@ -2915,9 +3530,6 @@
ALTER TABLE bugsummaryjournal ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugtag DISABLE TRIGGER ALL;
INSERT INTO bugtag (id, bug, tag) VALUES (1, 9, 'crash');
@@ -2933,9 +3545,6 @@
ALTER TABLE bugtag ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugtask DISABLE TRIGGER ALL;
INSERT INTO bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set) VALUES (2, 1, 4, NULL, NULL, NULL, 10, 20, 1, '2005-01-02 11:07:20.330975', '2004-01-02 03:49:22.910878', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
@@ -2971,9 +3580,6 @@
ALTER TABLE bugtask ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugtaskflat DISABLE TRIGGER ALL;
INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed) VALUES (2, 1, '2004-01-02 03:49:22.910878', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, 4, NULL, NULL, NULL, NULL, 10, 20, 1, NULL, 12, true, NULL, NULL, NULL, NULL);
@@ -3009,9 +3615,6 @@
ALTER TABLE bugtaskflat ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugtrackeralias DISABLE TRIGGER ALL;
INSERT INTO bugtrackeralias (id, bugtracker, base_url) VALUES (1, 7, 'http://savannah.nognu.org/');
@@ -3023,9 +3626,6 @@
ALTER TABLE bugtrackeralias ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE bugtrackercomponentgroup DISABLE TRIGGER ALL;
@@ -3040,12 +3640,6 @@
ALTER TABLE bugtrackercomponent ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE bugtrackerperson DISABLE TRIGGER ALL;
@@ -3053,12 +3647,6 @@
ALTER TABLE bugtrackerperson ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE bugwatchactivity DISABLE TRIGGER ALL;
@@ -3066,15 +3654,6 @@
ALTER TABLE bugwatchactivity ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE buildpackagejob DISABLE TRIGGER ALL;
INSERT INTO buildpackagejob (id, job, build) VALUES (1, 1, 8);
@@ -3084,9 +3663,6 @@
ALTER TABLE buildpackagejob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE buildqueue DISABLE TRIGGER ALL;
INSERT INTO buildqueue (id, builder, logtail, lastscore, manual, job, job_type, estimated_duration, processor, virtualized) VALUES (1, 1, 'Dummy sampledata entry, not processing', 1, false, 1, 1, '00:00:00', 1, false);
@@ -3096,9 +3672,6 @@
ALTER TABLE buildqueue ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codeimport DISABLE TRIGGER ALL;
INSERT INTO codeimport (id, branch, date_created, registrant, rcs_type, cvs_root, cvs_module, review_status, date_last_successful, owner, assignee, update_interval, url) VALUES (1, 75, '2007-06-25 20:04:04.226605', 52, 2, NULL, NULL, 20, NULL, 52, NULL, NULL, 'http://svn.example.org/svnroot/gnome-terminal/trunk');
@@ -3108,9 +3681,6 @@
ALTER TABLE codeimport ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codeimportmachine DISABLE TRIGGER ALL;
INSERT INTO codeimportmachine (id, date_created, hostname, state, heartbeat) VALUES (1, '2007-08-02 16:36:17.817407', 'bazaar-importer', 20, NULL);
@@ -3126,9 +3696,6 @@
ALTER TABLE codeimportevent ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codeimporteventdata DISABLE TRIGGER ALL;
@@ -3136,9 +3703,6 @@
ALTER TABLE codeimporteventdata ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codeimportjob DISABLE TRIGGER ALL;
INSERT INTO codeimportjob (id, date_created, code_import, machine, date_due, state, requesting_user, ordering, heartbeat, logtail, date_started) VALUES (1, '2007-12-05 16:07:57.276112', 1, NULL, '2007-12-05 16:07:57.276112', 10, NULL, NULL, NULL, NULL, NULL);
@@ -3147,12 +3711,6 @@
ALTER TABLE codeimportjob ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE codeimportresult DISABLE TRIGGER ALL;
@@ -3160,9 +3718,6 @@
ALTER TABLE codeimportresult ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codereviewmessage DISABLE TRIGGER ALL;
@@ -3170,9 +3725,6 @@
ALTER TABLE codereviewmessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE codereviewvote DISABLE TRIGGER ALL;
@@ -3180,9 +3732,6 @@
ALTER TABLE codereviewvote ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE commercialsubscription DISABLE TRIGGER ALL;
INSERT INTO commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id) VALUES (1, '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.838229', '2022-01-01 00:00:00', 10, 16, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:37.838229+00:00');
@@ -3192,12 +3741,6 @@
ALTER TABLE commercialsubscription ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE componentselection DISABLE TRIGGER ALL;
INSERT INTO componentselection (id, distroseries, component, date_created) VALUES (1, 3, 1, '2006-10-16 18:31:43.257508');
@@ -3224,15 +3767,6 @@
ALTER TABLE componentselection ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE customlanguagecode DISABLE TRIGGER ALL;
@@ -3240,12 +3774,6 @@
ALTER TABLE customlanguagecode ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE cvereference DISABLE TRIGGER ALL;
INSERT INTO cvereference (id, cve, source, content, url, date_created) VALUES (1, 1, 'NAI', 'Known problem #234234', 'http://nai.com/testing/foobar/', '2006-10-16 18:31:43.386902');
@@ -3291,9 +3819,6 @@
ALTER TABLE cvereference ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE databasecpustats DISABLE TRIGGER ALL;
@@ -3329,12 +3854,6 @@
ALTER TABLE diff ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE distributionjob DISABLE TRIGGER ALL;
@@ -3342,9 +3861,6 @@
ALTER TABLE distributionjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distributionmirror DISABLE TRIGGER ALL;
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);
@@ -3362,9 +3878,6 @@
ALTER TABLE distributionmirror ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distributionsourcepackage DISABLE TRIGGER ALL;
@@ -3372,9 +3885,6 @@
ALTER TABLE distributionsourcepackage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distributionsourcepackagecache DISABLE TRIGGER ALL;
INSERT INTO distributionsourcepackagecache (id, distribution, sourcepackagename, name, binpkgnames, binpkgsummaries, binpkgdescriptions, fti, changelog, archive) VALUES (1, 3, 19, 'alsa-utils', '', '', '', NULL, NULL, 1);
@@ -3403,15 +3913,6 @@
ALTER TABLE distributionsourcepackagecache ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE packagediff DISABLE TRIGGER ALL;
@@ -3426,9 +3927,6 @@
ALTER TABLE distroseriesdifference ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distroseriesdifferencemessage DISABLE TRIGGER ALL;
@@ -3436,9 +3934,6 @@
ALTER TABLE distroseriesdifferencemessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distroserieslanguage DISABLE TRIGGER ALL;
INSERT INTO distroserieslanguage (id, distroseries, language, currentcount, updatescount, rosettacount, contributorcount, dateupdated, unreviewed_count) VALUES (1, 3, 68, 62, 0, 0, 1, '2007-01-15 17:58:40.839938', 0);
@@ -3465,9 +3960,6 @@
ALTER TABLE distroserieslanguage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distroseriespackagecache DISABLE TRIGGER ALL;
INSERT INTO distroseriespackagecache (id, distroseries, binarypackagename, name, summary, description, summaries, descriptions, fti, archive) VALUES (1, 3, 13, 'pmount', 'pmount shortdesc', 'pmount description', 'pmount shortdesc', 'pmount description', NULL, 1);
@@ -3481,9 +3973,6 @@
ALTER TABLE distroseriespackagecache ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE distroseriesparent DISABLE TRIGGER ALL;
@@ -3491,9 +3980,6 @@
ALTER TABLE distroseriesparent ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE emailaddress DISABLE TRIGGER ALL;
INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (1, 'mark@xxxxxxxxxxx', 1, 4, '2006-10-16 18:31:43.540582');
@@ -3581,9 +4067,6 @@
ALTER TABLE emailaddress ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE faq DISABLE TRIGGER ALL;
INSERT INTO faq (id, title, tags, content, product, distribution, owner, date_created, last_updated_by, date_last_updated, fti) VALUES (1, 'Wireless Networking Documentation', 'wifi', 'Installation instructions for many wireless cards can be found at:
@@ -3650,9 +4133,6 @@
ALTER TABLE faq ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE pillarname DISABLE TRIGGER ALL;
INSERT INTO pillarname (id, name, product, project, distribution, active, alias_for) VALUES (1, 'ubuntu', NULL, NULL, 1, true, NULL);
@@ -3716,9 +4196,6 @@
ALTER TABLE featuredproject ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE featureflag DISABLE TRIGGER ALL;
@@ -3733,9 +4210,6 @@
ALTER TABLE featureflagchangelogentry ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE flatpackagesetinclusion DISABLE TRIGGER ALL;
@@ -3748,12 +4222,6 @@
-
-
-
-
-
-
ALTER TABLE garbojobstate DISABLE TRIGGER ALL;
@@ -3761,9 +4229,6 @@
ALTER TABLE garbojobstate ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwvendorname DISABLE TRIGGER ALL;
INSERT INTO hwvendorname (id, name) VALUES (1, 'MSI');
@@ -3804,9 +4269,6 @@
ALTER TABLE hwdevice ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwdeviceclass DISABLE TRIGGER ALL;
@@ -3814,9 +4276,6 @@
ALTER TABLE hwdeviceclass ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwdriver DISABLE TRIGGER ALL;
INSERT INTO hwdriver (id, package_name, name, license) VALUES (1, 'linux-image-2.6.24-19-generic', 'ehci_hcd', NULL);
@@ -3856,9 +4315,6 @@
ALTER TABLE hwdevicedriverlink ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwdevicenamevariant DISABLE TRIGGER ALL;
@@ -3866,9 +4322,6 @@
ALTER TABLE hwdevicenamevariant ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwsystemfingerprint DISABLE TRIGGER ALL;
INSERT INTO hwsystemfingerprint (id, fingerprint) VALUES (1, 'TONKA TUFFBOOK2600');
@@ -3894,9 +4347,6 @@
ALTER TABLE hwdmihandle ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwdmivalue DISABLE TRIGGER ALL;
@@ -3904,15 +4354,6 @@
ALTER TABLE hwdmivalue ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE hwsubmissionbug DISABLE TRIGGER ALL;
@@ -3920,9 +4361,6 @@
ALTER TABLE hwsubmissionbug ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwsubmissiondevice DISABLE TRIGGER ALL;
INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (1, 1, 2, NULL, 11);
@@ -3951,12 +4389,6 @@
ALTER TABLE hwsubmissiondevice ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE hwtest DISABLE TRIGGER ALL;
@@ -3964,9 +4396,6 @@
ALTER TABLE hwtest ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwtestanswerchoice DISABLE TRIGGER ALL;
@@ -3981,12 +4410,6 @@
ALTER TABLE hwtestanswer ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE hwtestanswercount DISABLE TRIGGER ALL;
@@ -3994,9 +4417,6 @@
ALTER TABLE hwtestanswercount ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwtestanswercountdevice DISABLE TRIGGER ALL;
@@ -4004,9 +4424,6 @@
ALTER TABLE hwtestanswercountdevice ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE hwtestanswerdevice DISABLE TRIGGER ALL;
@@ -4014,15 +4431,6 @@
ALTER TABLE hwtestanswerdevice ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE incrementaldiff DISABLE TRIGGER ALL;
@@ -4030,9 +4438,6 @@
ALTER TABLE incrementaldiff ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE ircid DISABLE TRIGGER ALL;
INSERT INTO ircid (id, person, network, nickname) VALUES (1, 1, 'irc.freenode.net', 'mark');
@@ -4049,9 +4454,6 @@
ALTER TABLE ircid ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE jabberid DISABLE TRIGGER ALL;
INSERT INTO jabberid (id, person, jabberid) VALUES (1, 1, 'markshuttleworth@xxxxxxxxxx');
@@ -4069,12 +4471,6 @@
ALTER TABLE jabberid ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE karmacategory DISABLE TRIGGER ALL;
INSERT INTO karmacategory (id, name, title, summary) VALUES (2, 'bugs', 'Bug Management', 'This karma category covers work in the Malone bug tracking system, such as filing, closing and otherwise working with bugs.');
@@ -4227,12 +4623,6 @@
ALTER TABLE karma ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE karmacache DISABLE TRIGGER ALL;
INSERT INTO karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1423, 12, 6, 22, 6, NULL, NULL, NULL);
@@ -4298,12 +4688,6 @@
ALTER TABLE karmacache ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE karmatotalcache DISABLE TRIGGER ALL;
INSERT INTO karmatotalcache (id, person, karma_total) VALUES (78, 12, 138);
@@ -4315,12 +4699,6 @@
ALTER TABLE karmatotalcache ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE languagepack DISABLE TRIGGER ALL;
INSERT INTO languagepack (id, file, date_exported, date_last_used, distroseries, type, updates) VALUES (1, 71, '2007-09-10 19:14:26.037382', '2007-09-10 19:14:26.037382', 3, 1, NULL);
@@ -4332,9 +4710,6 @@
ALTER TABLE languagepack ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packagecopyjob DISABLE TRIGGER ALL;
@@ -4435,9 +4810,6 @@
ALTER TABLE latestpersonsourcepackagereleasecache ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE launchpaddatabaserevision DISABLE TRIGGER ALL;
@@ -4452,9 +4824,6 @@
ALTER TABLE launchpaddatabaseupdatelog ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE launchpadstatistic DISABLE TRIGGER ALL;
INSERT INTO launchpadstatistic (id, name, value, dateupdated) VALUES (1, 'potemplate_count', 10, '2007-03-18 17:27:46.221219');
@@ -4488,15 +4857,6 @@
ALTER TABLE launchpadstatistic ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE libraryfiledownloadcount DISABLE TRIGGER ALL;
@@ -4504,9 +4864,6 @@
ALTER TABLE libraryfiledownloadcount ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE logintoken DISABLE TRIGGER ALL;
INSERT INTO logintoken (id, requester, requesteremail, email, created, tokentype, token, fingerprint, redirection_url, date_consumed) VALUES (1, NULL, NULL, 'bac@xxxxxxxxxxxxx', '2008-06-27 14:48:38.308457', 3, 'mzsJ6LBvNKjFqP1Csfw7', NULL, 'http://launchpad.dev', '2008-06-27 14:49:11.149508');
@@ -4516,9 +4873,6 @@
ALTER TABLE logintoken ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE lp_account DISABLE TRIGGER ALL;
INSERT INTO lp_account (id, openid_identifier) VALUES (11, 'mark_oid');
@@ -4998,9 +5352,6 @@
ALTER TABLE mailinglist ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mailinglistsubscription DISABLE TRIGGER ALL;
@@ -5008,9 +5359,6 @@
ALTER TABLE mailinglistsubscription ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mergedirectivejob DISABLE TRIGGER ALL;
@@ -5018,12 +5366,6 @@
ALTER TABLE mergedirectivejob ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE messageapproval DISABLE TRIGGER ALL;
@@ -5031,9 +5373,6 @@
ALTER TABLE messageapproval ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE messagechunk DISABLE TRIGGER ALL;
INSERT INTO messagechunk (id, message, sequence, content, blob, fti) VALUES (1, 7, 1, 'Malone pages that use more complex layouts with portlets and fancy CSS are sometimes not getting properly reflowed after rendering.', NULL, NULL);
@@ -5487,12 +5826,6 @@
ALTER TABLE messagechunk ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE milestonetag DISABLE TRIGGER ALL;
@@ -5500,9 +5833,6 @@
ALTER TABLE milestonetag ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirror DISABLE TRIGGER ALL;
@@ -5510,9 +5840,6 @@
ALTER TABLE mirror ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrorcdimagedistroseries DISABLE TRIGGER ALL;
INSERT INTO mirrorcdimagedistroseries (id, distribution_mirror, distroseries, flavour, date_created) VALUES (1, 6, 1, 'ubuntu', '2006-10-16 18:31:44.303183');
@@ -5524,9 +5851,6 @@
ALTER TABLE mirrorcdimagedistroseries ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrorcontent DISABLE TRIGGER ALL;
@@ -5534,9 +5858,6 @@
ALTER TABLE mirrorcontent ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrordistroarchseries DISABLE TRIGGER ALL;
INSERT INTO mirrordistroarchseries (id, distribution_mirror, distroarchseries, freshness, pocket, component, date_created) VALUES (1, 7, 1, 2, 10, 1, '2006-10-16 18:31:44.309753');
@@ -5548,9 +5869,6 @@
ALTER TABLE mirrordistroarchseries ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrordistroseriessource DISABLE TRIGGER ALL;
INSERT INTO mirrordistroseriessource (id, distribution_mirror, distroseries, freshness, pocket, component, date_created) VALUES (1, 7, 1, 1, 10, 1, '2006-10-16 18:31:44.314175');
@@ -5563,9 +5881,6 @@
ALTER TABLE mirrordistroseriessource ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrorproberecord DISABLE TRIGGER ALL;
INSERT INTO mirrorproberecord (id, distribution_mirror, log_file, date_created) VALUES (1, 6, 46, '2006-05-24 17:11:59.37369');
@@ -5575,9 +5890,6 @@
ALTER TABLE mirrorproberecord ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE mirrorsourcecontent DISABLE TRIGGER ALL;
@@ -5585,9 +5897,6 @@
ALTER TABLE mirrorsourcecontent ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE nameblacklist DISABLE TRIGGER ALL;
INSERT INTO nameblacklist (id, regexp, comment, admin) VALUES (1, 'blacklist', 'For testing purposes', NULL);
@@ -5597,9 +5906,6 @@
ALTER TABLE nameblacklist ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE oauthconsumer DISABLE TRIGGER ALL;
INSERT INTO oauthconsumer (id, date_created, disabled, key, secret) VALUES (1, '2008-03-18 20:57:19.108004', false, 'foobar123451432', '');
@@ -5619,12 +5925,6 @@
ALTER TABLE oauthaccesstoken ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE oauthnonce DISABLE TRIGGER ALL;
@@ -5639,9 +5939,6 @@
ALTER TABLE oauthrequesttoken ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE officialbugtag DISABLE TRIGGER ALL;
@@ -5649,9 +5946,6 @@
ALTER TABLE officialbugtag ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE openidconsumerassociation DISABLE TRIGGER ALL;
@@ -5741,9 +6035,6 @@
ALTER TABLE openididentifier ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packagecopyrequest DISABLE TRIGGER ALL;
@@ -5751,18 +6042,6 @@
ALTER TABLE packagecopyrequest ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
-
-
-
ALTER TABLE packagesetinclusion DISABLE TRIGGER ALL;
@@ -5770,9 +6049,6 @@
ALTER TABLE packagesetinclusion ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packagesetsources DISABLE TRIGGER ALL;
@@ -5780,12 +6056,6 @@
ALTER TABLE packagesetsources ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE packageuploadbuild DISABLE TRIGGER ALL;
INSERT INTO packageuploadbuild (id, packageupload, build, date_created) VALUES (1, 1, 18, '2006-10-16 18:31:43.529327');
@@ -5796,9 +6066,6 @@
ALTER TABLE packageuploadbuild ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packageuploadcustom DISABLE TRIGGER ALL;
INSERT INTO packageuploadcustom (id, packageupload, customformat, libraryfilealias, date_created) VALUES (1, 5, 1, 1, '2006-10-16 18:31:43.532702');
@@ -5810,9 +6077,6 @@
ALTER TABLE packageuploadcustom ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packageuploadsource DISABLE TRIGGER ALL;
INSERT INTO packageuploadsource (id, packageupload, sourcepackagerelease, date_created) VALUES (1, 3, 17, '2006-10-16 18:31:43.536296');
@@ -5828,9 +6092,6 @@
ALTER TABLE packageuploadsource ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE packaging DISABLE TRIGGER ALL;
INSERT INTO packaging (packaging, id, sourcepackagename, distroseries, productseries, datecreated, owner, date_created) VALUES (1, 1, 1, 3, 2, '2005-07-05 14:20:26.577312', NULL, '2006-10-16 18:31:44.336247');
@@ -5847,9 +6108,6 @@
ALTER TABLE packaging ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE potemplate DISABLE TRIGGER ALL;
INSERT INTO potemplate (id, priority, description, copyright, datecreated, path, iscurrent, messagecount, owner, sourcepackagename, distroseries, sourcepackageversion, header, binarypackagename, languagepack, productseries, from_sourcepackagename, date_last_updated, source_file, source_file_format, name, translation_domain) VALUES (1, 0, 'Template for evolution in hoary', NULL, '2005-03-18 18:20:12.273149', 'po/evolution-2.2.pot', true, 22, 30, NULL, NULL, NULL, 'Project-Id-Version: PACKAGE VERSION
@@ -5963,9 +6221,6 @@
ALTER TABLE packagingjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE parsedapachelog DISABLE TRIGGER ALL;
@@ -5973,12 +6228,6 @@
ALTER TABLE parsedapachelog ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE personlanguage DISABLE TRIGGER ALL;
INSERT INTO personlanguage (id, person, language, date_created) VALUES (1, 13, 387, '2006-10-16 18:31:44.536264');
@@ -5996,9 +6245,6 @@
ALTER TABLE personlanguage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE personlocation DISABLE TRIGGER ALL;
INSERT INTO personlocation (id, date_created, person, latitude, longitude, time_zone, last_modified_by, date_last_modified, visible, locked) VALUES (1, '2007-06-05 18:34:52.127945', 12, NULL, NULL, 'Australia/Perth', 12, '2007-06-05 18:34:52.127945', true, false);
@@ -6012,9 +6258,6 @@
ALTER TABLE personlocation ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE personnotification DISABLE TRIGGER ALL;
@@ -6022,9 +6265,6 @@
ALTER TABLE personnotification ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE personsettings DISABLE TRIGGER ALL;
INSERT INTO personsettings (person, selfgenerated_bugnotifications) VALUES (1, true);
@@ -6134,12 +6374,6 @@
ALTER TABLE persontransferjob ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE pocketchroot DISABLE TRIGGER ALL;
@@ -6147,9 +6381,6 @@
ALTER TABLE pocketchroot ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE pofile DISABLE TRIGGER ALL;
INSERT INTO pofile (id, potemplate, language, description, topcomment, header, fuzzyheader, lasttranslator, currentcount, updatescount, rosettacount, lastparsed, owner, path, datecreated, from_sourcepackagename, unreviewed_count, date_changed) VALUES (1, 1, 387, 'Spanish translation for evolution in hoary', ' traducción de es.po al Spanish
@@ -6762,12 +6993,6 @@
ALTER TABLE poexportrequest ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE pofilestatsjob DISABLE TRIGGER ALL;
@@ -6817,9 +7042,6 @@
ALTER TABLE pofiletranslator ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE poll DISABLE TRIGGER ALL;
INSERT INTO poll (id, team, name, title, dateopens, datecloses, proposition, type, allowspoilt, secrecy, date_created) VALUES (1, 17, 'director-2004', '2004 Director''s Elections', '2004-01-01 00:00:00', '2004-01-15 00:00:00', 'Who''s going to be the next director?', 2, true, 3, '2006-10-16 18:31:44.605729');
@@ -6834,9 +7056,6 @@
ALTER TABLE poll ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE polloption DISABLE TRIGGER ALL;
INSERT INTO polloption (id, poll, name, title, active, date_created) VALUES (1, 1, 'A', 'A', true, '2006-10-16 18:31:44.620851');
@@ -6868,9 +7087,6 @@
ALTER TABLE polloption ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE pomsgid DISABLE TRIGGER ALL;
INSERT INTO pomsgid (id, msgid) VALUES (1, 'evolution addressbook');
@@ -7185,12 +7401,6 @@
ALTER TABLE pomsgid ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE potmsgset DISABLE TRIGGER ALL;
INSERT INTO potmsgset (id, msgid_singular, commenttext, filereferences, sourcecomment, flagscomment, context, msgid_plural) VALUES (1, 1, '', 'a11y/addressbook/ea-addressbook-view.c:94
@@ -7417,9 +7627,6 @@
ALTER TABLE potmsgset ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE potranslation DISABLE TRIGGER ALL;
INSERT INTO potranslation (id, translation) VALUES (1, 'libreta de direcciones de Evolution');
@@ -8780,9 +8987,6 @@
ALTER TABLE potranslation ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE previewdiff DISABLE TRIGGER ALL;
@@ -8790,9 +8994,6 @@
ALTER TABLE previewdiff ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE processacceptedbugsjob DISABLE TRIGGER ALL;
@@ -8800,12 +9001,6 @@
ALTER TABLE processacceptedbugsjob ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE productjob DISABLE TRIGGER ALL;
@@ -8813,9 +9008,6 @@
ALTER TABLE productjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE productlicense DISABLE TRIGGER ALL;
INSERT INTO productlicense (id, product, license) VALUES (1, 1, 10);
@@ -8851,9 +9043,6 @@
ALTER TABLE productlicense ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE productrelease DISABLE TRIGGER ALL;
INSERT INTO productrelease (id, datereleased, release_notes, changelog, owner, datecreated, milestone) VALUES (1, '2004-06-28 00:00:00', '', '', 12, '2005-06-06 08:59:51.930201', 7);
@@ -9026,9 +9215,6 @@
ALTER TABLE productrelease ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE productreleasefile DISABLE TRIGGER ALL;
INSERT INTO productreleasefile (productrelease, libraryfile, filetype, id, description, uploader, date_uploaded, fti, signature) VALUES (5, 3, 1, 2, NULL, 16, '2005-06-06 08:59:51.926792', NULL, NULL);
@@ -9046,15 +9232,6 @@
ALTER TABLE productreleasefile ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE publisherconfig DISABLE TRIGGER ALL;
INSERT INTO publisherconfig (id, distribution, root_dir, base_url, copy_base_url) VALUES (1, 1, '/var/tmp/archive', 'http://archive.launchpad.dev/', 'http://rebuild-test.internal/');
@@ -9064,9 +9241,6 @@
ALTER TABLE publisherconfig ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE question DISABLE TRIGGER ALL;
INSERT INTO question (id, owner, title, description, assignee, answerer, product, distribution, sourcepackagename, status, priority, datecreated, datelastquery, dateaccepted, datedue, datelastresponse, date_solved, dateclosed, whiteboard, fti, answer, language, faq) VALUES (1, 11, 'Firefox cannot render Bank Site', 'Hello, I''m trying to access http://www.citibank.com/ and the page is not rendering correctly. Is there a setting I can use to get it right? Thanks.', NULL, NULL, 4, NULL, NULL, 10, 10, '2005-09-05 18:46:07.392021', '2005-09-05 18:46:07.392021', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 119, NULL);
@@ -9107,9 +9281,6 @@
ALTER TABLE question ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE questionbug DISABLE TRIGGER ALL;
@@ -9117,9 +9288,6 @@
ALTER TABLE questionbug ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE questionjob DISABLE TRIGGER ALL;
@@ -9127,9 +9295,6 @@
ALTER TABLE questionjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE questionmessage DISABLE TRIGGER ALL;
INSERT INTO questionmessage (id, question, message, action, new_status, owner) VALUES (1, 6, 12, 35, 18, 16);
@@ -9145,9 +9310,6 @@
ALTER TABLE questionmessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE questionreopening DISABLE TRIGGER ALL;
@@ -9155,9 +9317,6 @@
ALTER TABLE questionreopening ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE questionsubscription DISABLE TRIGGER ALL;
INSERT INTO questionsubscription (id, question, person, date_created) VALUES (1, 7, 16, '2006-10-16 18:31:53.201104');
@@ -9174,15 +9333,6 @@
ALTER TABLE questionsubscription ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE revisioncache DISABLE TRIGGER ALL;
@@ -9190,9 +9340,6 @@
ALTER TABLE revisioncache ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE revisionparent DISABLE TRIGGER ALL;
INSERT INTO revisionparent (id, sequence, revision, parent_id) VALUES (1, 0, 5, 'test@xxxxxxxxxxxxx-20051031165248-6f1bb97973c2b4f4');
@@ -9210,9 +9357,6 @@
ALTER TABLE revisionparent ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE revisionproperty DISABLE TRIGGER ALL;
INSERT INTO revisionproperty (id, revision, name, value) VALUES (1, 11, 'lp:foo', 'extended value');
@@ -9222,9 +9366,6 @@
ALTER TABLE revisionproperty ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE scriptactivity DISABLE TRIGGER ALL;
INSERT INTO scriptactivity (id, name, hostname, date_started, date_completed) VALUES (1, 'launchpad-targetnamecacheupdater', 'whatever', '2007-08-08 17:02:22.963565', '2007-08-08 17:02:23.869575');
@@ -9234,12 +9375,6 @@
ALTER TABLE scriptactivity ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE sectionselection DISABLE TRIGGER ALL;
INSERT INTO sectionselection (id, distroseries, section, date_created) VALUES (1, 3, 3, '2006-10-16 18:31:52.554214');
@@ -9330,9 +9465,6 @@
ALTER TABLE sectionselection ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE seriessourcepackagebranch DISABLE TRIGGER ALL;
@@ -9340,9 +9472,6 @@
ALTER TABLE seriessourcepackagebranch ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sharingjob DISABLE TRIGGER ALL;
@@ -9350,9 +9479,6 @@
ALTER TABLE sharingjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE signedcodeofconduct DISABLE TRIGGER ALL;
INSERT INTO signedcodeofconduct (id, owner, signingkey, datecreated, signedcode, recipient, active, admincomment) VALUES (1, 16, 1, '2005-09-27 10:01:13', 'Sampledata signedcode', NULL, true, NULL);
@@ -9361,9 +9487,6 @@
ALTER TABLE signedcodeofconduct ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sourcepackageformatselection DISABLE TRIGGER ALL;
INSERT INTO sourcepackageformatselection (id, distroseries, format) VALUES (1, 1, 0);
@@ -9384,21 +9507,6 @@
ALTER TABLE sourcepackageformatselection ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
ALTER TABLE sourcepackagerecipebuildjob DISABLE TRIGGER ALL;
@@ -9406,9 +9514,6 @@
ALTER TABLE sourcepackagerecipebuildjob ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sourcepackagerecipedata DISABLE TRIGGER ALL;
@@ -9416,9 +9521,6 @@
ALTER TABLE sourcepackagerecipedata ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sourcepackagerecipedatainstruction DISABLE TRIGGER ALL;
@@ -9426,9 +9528,6 @@
ALTER TABLE sourcepackagerecipedatainstruction ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sourcepackagerecipedistroseries DISABLE TRIGGER ALL;
@@ -9436,12 +9535,6 @@
ALTER TABLE sourcepackagerecipedistroseries ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE sourcepackagereleasefile DISABLE TRIGGER ALL;
INSERT INTO sourcepackagereleasefile (sourcepackagerelease, libraryfile, filetype, id) VALUES (14, 3, 6, 6);
@@ -9463,12 +9556,6 @@
ALTER TABLE sourcepackagereleasefile ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE specificationbranch DISABLE TRIGGER ALL;
INSERT INTO specificationbranch (id, datecreated, specification, branch, summary, registrant) VALUES (1, '2006-11-02 09:07:48.389829', 6, 20, 'This branch should fix the issue', 12);
@@ -9477,9 +9564,6 @@
ALTER TABLE specificationbranch ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationbug DISABLE TRIGGER ALL;
INSERT INTO specificationbug (id, specification, bug) VALUES (1, 3, 1);
@@ -9488,9 +9572,6 @@
ALTER TABLE specificationbug ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationdependency DISABLE TRIGGER ALL;
INSERT INTO specificationdependency (id, specification, dependency, date_created) VALUES (1, 4, 3, '2006-10-16 18:31:52.855436');
@@ -9500,9 +9581,6 @@
ALTER TABLE specificationdependency ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationmessage DISABLE TRIGGER ALL;
@@ -9510,9 +9588,6 @@
ALTER TABLE specificationmessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationsubscription DISABLE TRIGGER ALL;
INSERT INTO specificationsubscription (id, specification, person, essential, date_created) VALUES (1, 3, 16, false, '2006-10-16 18:31:52.870628');
@@ -9525,9 +9600,6 @@
ALTER TABLE specificationsubscription ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationworkitem DISABLE TRIGGER ALL;
@@ -9535,9 +9607,6 @@
ALTER TABLE specificationworkitem ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationworkitemchange DISABLE TRIGGER ALL;
@@ -9545,9 +9614,6 @@
ALTER TABLE specificationworkitemchange ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE specificationworkitemstats DISABLE TRIGGER ALL;
@@ -9555,9 +9621,6 @@
ALTER TABLE specificationworkitemstats ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE spokenin DISABLE TRIGGER ALL;
INSERT INTO spokenin (language, country, id) VALUES (1, 60, 165);
@@ -9842,9 +9905,6 @@
ALTER TABLE spokenin ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sprint DISABLE TRIGGER ALL;
INSERT INTO sprint (id, owner, name, title, summary, home_page, address, time_zone, time_starts, time_ends, datecreated, driver, homepage_content, icon, mugshot, logo) VALUES (1, 12, 'ubz', 'Ubuntu Below Zero', 'This is the next Ubuntu developer Summit. Join us in Montreal for discussions around Ubuntu and Launchpad. The focus will be the road to Dapper, our April 2006 release, focused on the enterprise.', 'http://wiki.ubuntu.com/UbuntuBelowZero', 'Montreal, Canada', 'US/Eastern', '2005-10-07 23:30:00', '2005-11-17 00:11:00', '2005-09-15 09:04:01.762108', NULL, NULL, NULL, NULL, NULL);
@@ -9856,9 +9916,6 @@
ALTER TABLE sprint ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sprintattendance DISABLE TRIGGER ALL;
@@ -9866,9 +9923,6 @@
ALTER TABLE sprintattendance ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sprintspecification DISABLE TRIGGER ALL;
INSERT INTO sprintspecification (id, sprint, specification, status, whiteboard, registrant, date_created, decider, date_decided) VALUES (1, 1, 3, 10, NULL, 16, '2006-08-05 23:54:10.835093', 12, '2006-08-05 23:54:10.835093');
@@ -9881,9 +9935,6 @@
ALTER TABLE sprintspecification ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE sshkey DISABLE TRIGGER ALL;
INSERT INTO sshkey (id, person, keytype, keytext, comment, date_created) VALUES (1, 12, 2, 'AAAAB3NzaC1kc3MAAAEBAPfhCA15ZaT08brwVXwpJjcZT6QFIipzF1sGy57HY7QPi/W+uljr1VcCHzWdlSmda7YpTCTx0NFYYQIccQRGX6zYL8v1w9FSRCAnxxUJmqEhsUDFYFdVTa9uLCrs3MSbmh7wwFPdRrGrO6X5x7T4dMZQwykSZrOVdpLcCHRgrMZslLomIAjERn6OAQNiGFz7B2tEi/3Soqd52bGJwOtGymRiAXkPSLbH7KfzSCe34ytdh6BD+4SrgSoa+TL3VDV70QAdlOFXD42ZHl3Sc0Tde4LbZeYq2Uf84DOATLZBbOYpRSqTLkM9XngpnvCRVb6dxEQfgODDw783tEuPpySLj2EAAAAVANpUVgivDjt9gFibN/AXfYy1meeBAAABAB6FtnMywmWZg2lr2I3nDfE5U5QbGUQB/ZEP98ZkSkhOcF29VlnGOxyb2/VZbVTLa/btlPF82L4An/c8VKtKZnel7LnAlMoArdgzQNXGVQQVtnaWwM26ydgDzkSSIes3elNZgsfnPRBvaF0ol9Tqju0rNGKjnr3ZOX/NX+42bxpjRnxYj1h56yP2jKKeGfjorI6JK1YfqBAiTxzaDMzSpknnrbztaKJoh7IFqMMOp9ANSFh7H106pEaCv3ebCTJZprtWqNKjb2zum7OQPRz3upA0qx22ocTokjv4itXJ6yj/BvGu9qdOIQFXuB2rsFtLZtS8ATueOly0GzyeiZBx/AEAAAEBAO8jRYjL7tAYnVlO1p6UzPOicAuGCFWfNbBEDRAXoSgLNdj451jStw+eUc9ZVz7tG/XRVZsiavtFHb2cbrcfX1YOd69xi0m+IY6mo3yKt3irQRokDtt376sHoUdHgj2ozySZJgG8IJndtoS+VQQy6NdClA3fNFb96bF865eNaRYoHJO9ZI84lkWQL++MLzIuyFfCs1hSlapyyuHC8kFmF7AQdrVZvbohSbnWs+w53nIW8nAA7z21wAukvE1Pl6AQyG0e7U1sYS8Pc8dtmzJvdtVZWBl02/gqQJ7f06mFvnsN45rR1Uyxnrwl6rbFwqabZDlyD5Ac6Icbvz9SG1gBOiI=', 'andrew@trogdor', '2006-10-16 18:31:53.030784');
@@ -9893,12 +9944,6 @@
ALTER TABLE sshkey ENABLE TRIGGER ALL;
-
-
-
-
-
-
ALTER TABLE subunitstream DISABLE TRIGGER ALL;
@@ -9906,9 +9951,6 @@
ALTER TABLE subunitstream ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE suggestivepotemplate DISABLE TRIGGER ALL;
@@ -10024,9 +10066,6 @@
ALTER TABLE teammembership ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE teamparticipation DISABLE TRIGGER ALL;
INSERT INTO teamparticipation (id, team, person) VALUES (1, 17, 1);
@@ -10234,15 +10273,6 @@
ALTER TABLE teamparticipation ENABLE TRIGGER ALL;
-
-
-
-
-
-
-
-
-
ALTER TABLE translationimportqueueentry DISABLE TRIGGER ALL;
INSERT INTO translationimportqueueentry (id, path, content, importer, dateimported, distroseries, sourcepackagename, productseries, by_maintainer, pofile, potemplate, status, date_status_changed, format, error_output) VALUES (1, 'po/evolution-2.2-test.pot', 57, 16, '2006-12-13 21:17:56.241901', NULL, NULL, 3, true, NULL, 6, 2, '2006-12-13 21:18:40.885499', 1, NULL);
@@ -10252,9 +10282,6 @@
ALTER TABLE translationimportqueueentry ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE translationmessage DISABLE TRIGGER ALL;
INSERT INTO translationmessage (id, potmsgset, date_created, submitter, date_reviewed, reviewer, msgstr0, msgstr1, msgstr2, msgstr3, comment, origin, validation_status, is_current_ubuntu, is_fuzzy, is_current_upstream, was_obsolete_in_last_import, was_fuzzy_in_last_import, msgstr4, msgstr5, potemplate, language) VALUES (1, 1, '2005-04-07 13:19:17.601068', 13, '2005-04-07 13:19:17.601068', 13, 1, NULL, NULL, NULL, '', 1, 1, true, false, true, false, false, NULL, NULL, 1, 387);
@@ -10917,9 +10944,6 @@
ALTER TABLE translationmessage ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE translationrelicensingagreement DISABLE TRIGGER ALL;
INSERT INTO translationrelicensingagreement (id, person, allow_relicensing, date_decided) VALUES (201, 58, true, '2008-05-23 16:29:22.319166');
@@ -10988,9 +11012,6 @@
ALTER TABLE translationrelicensingagreement ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE translationtemplateitem DISABLE TRIGGER ALL;
INSERT INTO translationtemplateitem (id, potemplate, sequence, potmsgset) VALUES (1, 1, 1, 1);
@@ -11194,9 +11215,6 @@
ALTER TABLE translationtemplateitem ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE translationtemplatesbuild DISABLE TRIGGER ALL;
@@ -11204,9 +11222,6 @@
ALTER TABLE translationtemplatesbuild ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE translator DISABLE TRIGGER ALL;
INSERT INTO translator (id, translationgroup, language, translator, datecreated, style_guide_url) VALUES (1, 1, 387, 53, '2005-07-13 13:14:19.748396', NULL);
@@ -11215,9 +11230,6 @@
ALTER TABLE translator ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE usertouseremail DISABLE TRIGGER ALL;
@@ -11225,9 +11237,6 @@
ALTER TABLE usertouseremail ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE vote DISABLE TRIGGER ALL;
INSERT INTO vote (id, person, poll, preference, option, token) VALUES (1, NULL, 1, 1, 4, '9WjxQq2V9p');
@@ -11263,9 +11272,6 @@
ALTER TABLE vote ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE votecast DISABLE TRIGGER ALL;
INSERT INTO votecast (id, person, poll) VALUES (1, 6, 1);
@@ -11283,9 +11289,6 @@
ALTER TABLE votecast ENABLE TRIGGER ALL;
-
-
-
ALTER TABLE wikiname DISABLE TRIGGER ALL;
INSERT INTO wikiname (id, person, wiki, wikiname) VALUES (1, 1, 'https://wiki.ubuntu.com/', 'MarkShuttleworth');
@@ -11295,6 +11298,3 @@
ALTER TABLE wikiname ENABLE TRIGGER ALL;
-
-
-
=== modified file 'database/schema/comments.sql'
--- database/schema/comments.sql 2013-09-11 06:13:28 +0000
+++ database/schema/comments.sql 2013-10-11 12:06:15 +0000
@@ -1739,6 +1739,7 @@
COMMENT ON COLUMN Builder.vm_host IS 'The virtual machine host associated to this builder. It should be empty for "native" builders (old fashion or architectures not yet supported by XEN).';
COMMENT ON COLUMN Builder.active IS 'Whether to present or not the builder in the public list of builders avaialble. It is used to hide transient or defunct builders while they get fixed.';
COMMENT ON COLUMN Builder.failure_count IS 'The number of consecutive failures on this builder. Is reset to zero after a sucessful dispatch.';
+COMMENT ON COLUMN Builder.version IS 'The version of launchpad-buildd on the slave.';
-- BuildQueue
COMMENT ON TABLE BuildQueue IS 'BuildQueue: The queue of jobs in progress/scheduled to run on the Soyuz build farm.';
=== added file 'database/schema/patch-2209-50-0.sql'
--- database/schema/patch-2209-50-0.sql 1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-50-0.sql 2013-10-11 12:06:15 +0000
@@ -0,0 +1,8 @@
+-- Copyright 2013 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 builder ADD COLUMN version TEXT;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 50, 0);
