Launchpad itself

Merge lp:~cprov/launchpad/bug-408528-ensurePerson-again into lp:launchpad

  1. bug-408528-ensurePerson-again
  2. Merge into devel
Proposed by Celso Providelo
Status: Superseded
Proposed branch: lp:~cprov/launchpad/bug-408528-ensurePerson-again
Merge into: lp:launchpad
Diff against target: 18423 lines
230 files modified
cronscripts/rosetta-approve-imports.py (+1/-1)
database/sampledata/current-dev.sql (+55/-41)
database/sampledata/current.sql (+52/-38)
database/schema/Makefile (+5/-4)
database/schema/comments.sql (+0/-45)
database/schema/launchpad-2207-00-0.sql (+2878/-2089)
database/schema/launchpad.html (+117/-484)
database/schema/patch-2109-01-0.sql (+0/-63)
database/schema/patch-2109-02-0.sql (+0/-24)
database/schema/patch-2109-03-0.sql (+0/-18)
database/schema/patch-2109-04-0.sql (+0/-24)
database/schema/patch-2109-05-0.sql (+0/-26)
database/schema/patch-2109-06-0.sql (+0/-19)
database/schema/patch-2109-07-0.sql (+0/-9)
database/schema/patch-2109-08-0.sql (+0/-20)
database/schema/patch-2109-09-0.sql (+0/-18)
database/schema/patch-2109-10-0.sql (+0/-9)
database/schema/patch-2109-11-0.sql (+0/-113)
database/schema/patch-2109-12-0.sql (+0/-15)
database/schema/patch-2109-13-0.sql (+0/-79)
database/schema/patch-2109-14-0.sql (+0/-37)
database/schema/patch-2109-15-0.sql (+0/-71)
database/schema/patch-2109-16-0.sql (+0/-10)
database/schema/patch-2109-17-0.sql (+0/-32)
database/schema/patch-2109-18-0.sql (+0/-6)
database/schema/patch-2109-19-0.sql (+0/-19)
database/schema/patch-2109-20-0.sql (+0/-12)
database/schema/patch-2109-21-0.sql (+0/-25)
database/schema/patch-2109-21-1.sql (+0/-13)
database/schema/patch-2109-22-0.sql (+0/-9)
database/schema/patch-2109-23-0.sql (+0/-9)
database/schema/patch-2109-24-0.sql (+0/-191)
database/schema/patch-2109-25-0.sql (+0/-14)
database/schema/patch-2109-26-0.sql (+0/-10)
database/schema/patch-2109-28-0.sql (+0/-37)
database/schema/patch-2109-29-0.sql (+0/-18)
database/schema/patch-2109-30-0.sql (+0/-18)
database/schema/patch-2109-32-0.sql (+0/-15)
database/schema/patch-2109-33-0.sql (+0/-14)
database/schema/patch-2109-33-1.sql (+0/-12)
database/schema/patch-2109-33-2.sql (+0/-22)
database/schema/patch-2109-35-0.sql (+0/-58)
database/schema/patch-2109-36-0.sql (+0/-24)
database/schema/patch-2109-37-0.sql (+0/-20)
database/schema/patch-2109-38-0.sql (+0/-27)
database/schema/patch-2109-39-0.sql (+0/-14)
database/schema/patch-2109-40-0.sql (+0/-110)
database/schema/patch-2109-42-0.sql (+0/-11)
database/schema/patch-2109-43-0.sql (+0/-45)
database/schema/patch-2109-44-0.sql (+0/-9)
database/schema/patch-2109-44-1.sql (+0/-9)
database/schema/patch-2109-44-2.sql (+0/-98)
database/schema/patch-2109-45-0.sql (+0/-148)
database/schema/patch-2109-46-0.sql (+0/-13)
database/schema/patch-2109-48-0.sql (+0/-206)
database/schema/patch-2109-49-0.sql (+0/-9)
database/schema/patch-2109-50-0.sql (+0/-64)
database/schema/patch-2109-51-0.sql (+0/-14)
database/schema/patch-2109-51-1.sql (+0/-11)
database/schema/patch-2109-51-2.sql (+0/-31)
database/schema/patch-2109-52-0.sql (+0/-132)
database/schema/patch-2109-53-0.sql (+0/-14)
database/schema/patch-2109-54-0.sql (+0/-12)
database/schema/patch-2109-55-0.sql (+0/-12)
database/schema/patch-2109-55-1.sql (+0/-19)
database/schema/patch-2109-55-2.sql (+0/-9)
database/schema/patch-2109-56-0.sql (+0/-7)
database/schema/patch-2109-57-0.sql (+0/-7)
database/schema/patch-2109-58-0.sql (+0/-9)
database/schema/patch-2109-59-0.sql (+0/-7)
database/schema/patch-2109-60-0.sql (+0/-8)
database/schema/patch-2109-61-0.sql (+0/-5)
database/schema/patch-2109-61-1.sql (+0/-71)
database/schema/patch-2109-62-0.sql (+0/-5)
database/schema/patch-2207-00-0.sql (+1/-1)
database/schema/patch-2207-00-1.sql (+54/-0)
database/schema/patch-2207-00-2.sql (+10/-0)
database/schema/patch-2207-00-3.sql (+11/-0)
database/schema/patch-2207-01-0.sql (+10/-0)
database/schema/patch-2207-02-0.sql (+45/-0)
database/schema/patch-2207-03-0.sql (+48/-0)
database/schema/security.cfg (+21/-0)
database/schema/trusted.sql (+42/-1)
database/schema/upgrade.py (+1/-1)
lib/canonical/database/constants.py (+2/-0)
lib/canonical/launchpad/database/account.py (+6/-5)
lib/canonical/launchpad/database/tests/test_account.py (+22/-5)
lib/canonical/launchpad/icing/style-3-0.css (+94/-2)
lib/canonical/launchpad/icing/style.css (+0/-110)
lib/canonical/launchpad/interfaces/account.py (+9/-2)
lib/canonical/launchpad/pagetests/packaging/xx-sourcepackage-packaging.txt (+11/-0)
lib/canonical/launchpad/pagetitles.py (+0/-14)
lib/canonical/launchpad/scripts/garbo.py (+134/-7)
lib/canonical/launchpad/scripts/logger.py (+19/-7)
lib/canonical/launchpad/scripts/tests/test_garbo.py (+118/-6)
lib/canonical/launchpad/templates/root-index.pt (+36/-36)
lib/canonical/launchpad/webapp/dbpolicy.py (+15/-4)
lib/canonical/twistedsupport/processmonitor.py (+22/-1)
lib/canonical/twistedsupport/tests/test_processmonitor.py (+44/-1)
lib/lp/answers/browser/configure.zcml (+1/-0)
lib/lp/answers/browser/faq.py (+17/-1)
lib/lp/answers/browser/faqcollection.py (+6/-4)
lib/lp/answers/browser/questiontarget.py (+51/-47)
lib/lp/answers/browser/tests/test_breadcrumbs.py (+3/-6)
lib/lp/answers/browser/tests/views.txt (+4/-4)
lib/lp/answers/configure.zcml (+4/-4)
lib/lp/answers/stories/answer-contact-report.txt (+1/-1)
lib/lp/answers/stories/faq-add.txt (+5/-5)
lib/lp/answers/stories/faq-browse-and-search.txt (+10/-10)
lib/lp/answers/stories/faq-edit.txt (+1/-1)
lib/lp/answers/stories/project-add-question.txt (+2/-2)
lib/lp/answers/stories/question-add-in-other-languages.txt (+3/-3)
lib/lp/answers/stories/question-add.txt (+6/-6)
lib/lp/answers/stories/question-answer-contact.txt (+6/-6)
lib/lp/answers/stories/question-answers-vhost.txt (+6/-6)
lib/lp/answers/stories/question-browse-and-search.txt (+34/-34)
lib/lp/answers/stories/question-compatibility-urls.txt (+4/-4)
lib/lp/answers/stories/question-message.txt (+3/-3)
lib/lp/answers/stories/question-obfuscation.txt (+3/-3)
lib/lp/answers/stories/question-overview.txt (+9/-9)
lib/lp/answers/stories/question-search-multiple-languages.txt (+3/-3)
lib/lp/answers/stories/questions-index.txt (+1/-1)
lib/lp/answers/stories/this-is-a-faq.txt (+5/-5)
lib/lp/answers/templates/faq-listing.pt (+4/-21)
lib/lp/answers/templates/question-listing.pt (+4/-40)
lib/lp/app/browser/tests/base-layout.txt (+4/-8)
lib/lp/app/browser/tests/watermark.txt (+1/-1)
lib/lp/app/browser/watermark.py (+8/-1)
lib/lp/app/templates/base-layout.pt (+3/-12)
lib/lp/blueprints/browser/sprint.py (+7/-2)
lib/lp/blueprints/configure.zcml (+22/-0)
lib/lp/blueprints/doc/specificationmessage.txt (+41/-0)
lib/lp/blueprints/interfaces/specificationmessage.py (+56/-0)
lib/lp/blueprints/model/specificationmessage.py (+56/-0)
lib/lp/blueprints/stories/blueprints/05-reviews.txt (+2/-3)
lib/lp/blueprints/stories/sprints/05-sprint-creation.txt (+20/-0)
lib/lp/blueprints/templates/specification-index.pt (+6/-6)
lib/lp/blueprints/templates/sprint-portlet-attendees.pt (+1/-2)
lib/lp/bugs/browser/bugtarget.py (+6/-7)
lib/lp/bugs/browser/bugtask.py (+9/-3)
lib/lp/bugs/browser/tests/test_breadcrumbs.py (+1/-1)
lib/lp/bugs/configure.zcml (+66/-66)
lib/lp/bugs/doc/externalbugtracker-bugzilla.txt (+65/-11)
lib/lp/bugs/doc/externalbugtracker.txt (+24/-21)
lib/lp/bugs/externalbugtracker/bugzilla.py (+62/-12)
lib/lp/bugs/model/bugnotification.py (+2/-0)
lib/lp/bugs/scripts/bugimport.py (+40/-13)
lib/lp/bugs/scripts/checkwatches.py (+13/-7)
lib/lp/bugs/scripts/tests/test_bugimport.py (+53/-23)
lib/lp/bugs/stories/bug-release-management/nomination-navigation.txt (+1/-2)
lib/lp/bugs/stories/bugattachments/10-add-bug-attachment.txt (+2/-2)
lib/lp/bugs/stories/bugattachments/xx-delete-bug-attachment.txt (+1/-1)
lib/lp/bugs/stories/bugattachments/xx-display-filesize-attachment.txt (+2/-2)
lib/lp/bugs/stories/bugs/xx-bug-activity.txt (+1/-2)
lib/lp/bugs/stories/bugs/xx-bug-comments-truncated.txt (+1/-1)
lib/lp/bugs/stories/bugs/xx-bug-contacts-reports.txt (+6/-6)
lib/lp/bugs/stories/bugs/xx-bug-create-question.txt (+2/-2)
lib/lp/bugs/stories/bugs/xx-front-page-search.txt (+4/-4)
lib/lp/bugs/stories/distribution/xx-distribution-upstream-bug-report.txt (+6/-12)
lib/lp/bugs/stories/guided-filebug/xx-bug-reporting-tools.txt (+1/-1)
lib/lp/bugs/stories/guided-filebug/xx-filebug-attachments.txt (+1/-1)
lib/lp/bugs/stories/guided-filebug/xx-ubuntu-filebug.txt (+14/-0)
lib/lp/bugs/templates/bug-portlet-attachments.pt (+1/-1)
lib/lp/bugs/templates/bugcomment-box.pt (+1/-1)
lib/lp/bugs/templates/buglisting-embedded-advanced-search.pt (+6/-16)
lib/lp/bugs/templates/bugtask-index.pt (+8/-11)
lib/lp/buildmaster/manager.py (+9/-6)
lib/lp/buildmaster/tests/test_manager.py (+53/-27)
lib/lp/code/browser/branch.py (+2/-1)
lib/lp/code/browser/branchlisting.py (+3/-6)
lib/lp/code/browser/configure.zcml (+1/-1)
lib/lp/code/mail/tests/test_codehandler.py (+16/-2)
lib/lp/code/model/tests/test_branchmergeproposals.py (+14/-0)
lib/lp/code/stories/branches/xx-branch-deletion.txt (+1/-1)
lib/lp/code/stories/branches/xx-branch-edit.txt (+1/-1)
lib/lp/code/stories/branches/xx-branch-index.txt (+4/-4)
lib/lp/code/stories/branches/xx-branch-merge-proposals.txt (+2/-2)
lib/lp/code/stories/branches/xx-creating-branches.txt (+12/-10)
lib/lp/code/stories/branches/xx-person-branches.txt (+3/-3)
lib/lp/code/stories/branches/xx-product-branches.txt (+1/-1)
lib/lp/code/stories/branches/xx-project-branches.txt (+2/-2)
lib/lp/code/stories/webservice/xx-branchmergeproposal.txt (+1/-1)
lib/lp/code/templates/branch-index.pt (+10/-22)
lib/lp/code/templates/branch-information.pt (+15/-10)
lib/lp/code/templates/branch-merge-link-summary.pt (+2/-1)
lib/lp/registry/browser/configure.zcml (+11/-9)
lib/lp/registry/browser/distributionsourcepackage.py (+52/-23)
lib/lp/registry/browser/person.py (+38/-7)
lib/lp/registry/browser/sourcepackage.py (+4/-0)
lib/lp/registry/help/home-page-staging-help.html (+30/-0)
lib/lp/registry/model/person.py (+26/-10)
lib/lp/registry/stories/distribution/xx-distribution-overview.txt (+3/-4)
lib/lp/registry/stories/distribution/xx-distribution-packages.txt (+73/-2)
lib/lp/registry/stories/distroseries/xx-distroseries-index.txt (+1/-2)
lib/lp/registry/stories/foaf/xx-changepassword.txt (+1/-1)
lib/lp/registry/stories/foaf/xx-person-bugs.txt (+6/-6)
lib/lp/registry/stories/product/xx-product-edit.txt (+3/-3)
lib/lp/registry/stories/project/xx-project-edit.txt (+2/-3)
lib/lp/registry/templates/distributionsourcepackage-changelog.pt (+10/-14)
lib/lp/registry/templates/product-index.pt (+7/-7)
lib/lp/registry/templates/project-details.pt (+0/-5)
lib/lp/registry/templates/project-index.pt (+6/-0)
lib/lp/registry/templates/sourcepackage-packaging.pt (+0/-2)
lib/lp/registry/tests/test_person.py (+3/-3)
lib/lp/registry/tests/test_personset.py (+20/-0)
lib/lp/soyuz/browser/configure.zcml (+8/-5)
lib/lp/soyuz/browser/distributionsourcepackagerelease.py (+13/-0)
lib/lp/soyuz/browser/sourcepackage.py (+2/-0)
lib/lp/soyuz/doc/archive.txt (+6/-3)
lib/lp/soyuz/doc/package-diff.txt (+26/-0)
lib/lp/soyuz/interfaces/archive.py (+9/-2)
lib/lp/soyuz/model/archive.py (+10/-5)
lib/lp/soyuz/model/sourcepackagerelease.py (+11/-2)
lib/lp/soyuz/stories/packaging/package-pages-navigation.txt (+2/-3)
lib/lp/soyuz/stories/ppa/xx-copy-packages.txt (+0/-1)
lib/lp/soyuz/stories/ppa/xx-delete-packages.txt (+1/-1)
lib/lp/soyuz/stories/soyuz/xx-build-record.txt (+0/-1)
lib/lp/soyuz/stories/soyuz/xx-distributionsourcepackagerelease-pages.txt (+7/-6)
lib/lp/soyuz/stories/soyuz/xx-sourcepackage-changelog.txt (+16/-8)
lib/lp/soyuz/stories/webservice/xx-archive.txt (+29/-0)
lib/lp/soyuz/templates/distributionsourcepackage-publishinghistory.pt (+0/-3)
lib/lp/soyuz/templates/sourcepackage-changelog.pt (+4/-10)
lib/lp/testing/factory.py (+29/-11)
lib/lp/translations/browser/translations.py (+1/-4)
lib/lp/translations/doc/translations-export-to-branch.txt (+0/-1)
lib/lp/translations/model/potemplate.py (+4/-0)
lib/lp/translations/scripts/tests/test_translations_to_branch.py (+6/-1)
lib/lp/translations/scripts/translations_to_branch.py (+23/-2)
lib/lp/translations/tests/test_autoapproval.py (+32/-8)
versions.cfg (+2/-2)
To merge this branch: bzr merge lp:~cprov/launchpad/bug-408528-ensurePerson-again
Reviewer Review Type Date Requested Status
Curtis Hovey Pending
Canonical Launchpad Engineering Pending
Review via email: mp+12356@code.launchpad.net

This proposal has been superseded by a proposal from 2009-09-29.

To post a comment you must log in.
Revision history for this message
Celso Providelo (cprov) wrote :

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

= Summary =

This branch is a refix for https://bugs.edge.launchpad.net/soyuz/+bug/408528.

Apparently, IPersonSet.ensurePerson() has to cope with account containing unlinked Person and EmailAddress.

I still have to talk to Curtis about how legitimate accounts in this condition are, but I have the impression the workaround is needed regardless of this diecision.

== Proposed fix ==

Before creating a new Person for an existing EmailAddress which is not associated to one we verify if its Account is already associated with a Person. If it is, we link the Person and EmailAddress and return the Person.

== Tests ==

/bin/test -vv -t test_ensurePerson_for_existing_account_with_person

== Demo and Q/A ==

Retrying https://edge.launchpad.net/ubuntu/+source/php-kolab-filter/0.1.5-2/+build/1255703 will successfully after this change.

= Launchpad lint =

Checking for conflicts. and issues in doctests and templates.
Running jslint, xmllint, pyflakes, and pylint.
Using normal rules.

Linting changed files:
  lib/lp/registry/tests/test_personset.py
  lib/lp/registry/model/person.py
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkq7jnAACgkQ7KBXuXyZSjAT9QCgjACag3RhRN+sQc7Hev6leo1O
hY0AnRN8P55UFA2ADQSGsnwvFcU3V4tf
=qTFa
-----END PGP SIGNATURE-----

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'cronscripts/rosetta-approve-imports.py'
2--- cronscripts/rosetta-approve-imports.py 2009-07-17 00:26:05 +0000
3+++ cronscripts/rosetta-approve-imports.py 2009-09-24 17:04:21 +0000
4@@ -26,7 +26,7 @@
5
6 if __name__ == '__main__':
7 script = RosettaImportApprover('rosetta-approve-imports',
8- dbuser=config.poimport.dbuser)
9+ dbuser='poimportapprover')
10 script.lock_or_quit()
11 try:
12 script.run()
13
14=== modified file 'database/sampledata/current-dev.sql'
15--- database/sampledata/current-dev.sql 2009-08-27 19:22:38 +0000
16+++ database/sampledata/current-dev.sql 2009-09-24 17:04:20 +0000
17@@ -1489,6 +1489,13 @@
18 ALTER TABLE bugnotification ENABLE TRIGGER ALL;
19
20
21+ALTER TABLE bugnotificationarchive DISABLE TRIGGER ALL;
22+
23+
24+
25+ALTER TABLE bugnotificationarchive ENABLE TRIGGER ALL;
26+
27+
28 ALTER TABLE bugnotificationattachment DISABLE TRIGGER ALL;
29
30
31@@ -1503,6 +1510,13 @@
32 ALTER TABLE bugnotificationrecipient ENABLE TRIGGER ALL;
33
34
35+ALTER TABLE bugnotificationrecipientarchive DISABLE TRIGGER ALL;
36+
37+
38+
39+ALTER TABLE bugnotificationrecipientarchive ENABLE TRIGGER ALL;
40+
41+
42 ALTER TABLE bugpackageinfestation DISABLE TRIGGER ALL;
43
44
45@@ -7946,47 +7960,47 @@
46
47 ALTER TABLE productseries DISABLE TRIGGER ALL;
48
49-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (1, 4, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.895136', NULL, 12, NULL, 2, 1, NULL, NULL);
50-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (2, 4, '1.0', 'The 1.0 branch of the Mozilla web browser. Currently, this is the stable branch of Mozilla, and all stable releases are made off this branch.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.898385', NULL, 12, NULL, 2, 1, NULL, NULL);
51-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (3, 5, 'trunk', 'The primary "trunk" of development for this product. This series
52-was automatically created and represents the idea of a primary trunk
53-of software development without "stable branches". For most
54-products, releases in this series will be "milestone" or "test"
55-releases, and there should be other series for the stable releases
56-of the product.', 5, NULL, NULL, 1, ':pserver:anonymous@anoncvs.gnome.org:/cvs/gnome', 'evolution', 'MAIN', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.914873', NULL, 12, NULL, 2, 1, 14, NULL);
57-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (4, 8, 'trunk', 'The primary "trunk" of development for this product. This series
58-was automatically created and represents the idea of a primary trunk
59-of software development without "stable branches". For most
60-products, releases in this series will be "milestone" or "test"
61-releases, and there should be other series for the stable releases
62-of the product.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.91214', NULL, 12, NULL, 2, 1, NULL, NULL);
63-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (5, 11, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.899819', NULL, 12, NULL, 2, 1, NULL, NULL);
64-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (6, 12, 'trunk', 'The primary upstream development branch, from which all releases are made.', 2, NULL, NULL, 1, ':pserver:anonymous@cvs.sourceforge.net:/cvsroot/liba52', 'a52dec', 'MAIN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, NULL, 2, 1, NULL, NULL);
65-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (7, 12, 'failedbranch', 'A branch where auto test has failed.', 3, NULL, NULL, 1, ':pserver:anonymous@cvs.sourceforge.net:/cvsroot/liba52', 'a52dec', 'AUTOTESTFAILED', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, NULL, 2, 1, NULL, NULL);
66-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (8, 15, 'trunk', 'The mainline for alsa-utils', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-09-15 09:10:03.531637', NULL, 1, NULL, 2, 1, NULL, NULL);
67-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (9, 16, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-07-11 19:59:17.311451', NULL, 12, NULL, 2, 1, NULL, NULL);
68-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (10, 14, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
69-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (11, 13, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, NULL, 2, 1, NULL, NULL);
70-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (12, 9, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, NULL, 2, 1, NULL, NULL);
71-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (13, 7, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
72-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (14, 6, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
73-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (15, 3, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 2, NULL, 2, 1, NULL, NULL);
74-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (16, 1, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 17, NULL, 2, 1, NULL, NULL);
75-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (17, 2, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, NULL, 2, 1, NULL, NULL);
76-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (18, 10, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, NULL, 2, 1, NULL, NULL);
77-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (19, 17, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-11-24 12:48:19.178553', NULL, 12, NULL, 2, 1, NULL, NULL);
78-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (20, 18, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-14 18:47:04.891546', NULL, 37, NULL, 2, 1, NULL, NULL);
79-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (21, 19, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-14 18:53:13.112116', NULL, 28, NULL, 2, 1, NULL, NULL);
80-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (22, 20, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-15 20:11:49.501871', NULL, 14, NULL, 2, 1, NULL, NULL);
81-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (23, 21, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-27 16:28:27.763632', NULL, 12, NULL, 2, 1, NULL, NULL);
82-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (24, 22, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-04-18 20:58:56.846607', NULL, 12, NULL, 2, 1, NULL, NULL);
83-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (25, 23, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-11-19 12:44:30.603892', NULL, 1, NULL, 2, 1, NULL, NULL);
84-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (26, 24, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-06-27 14:51:47.366199', NULL, 243623, NULL, 2, 1, NULL, NULL);
85-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (27, 25, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-10-02 10:12:40.909504', NULL, 16, NULL, 2, 1, NULL, NULL);
86-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (28, 26, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-05-02 21:33:15.310312', NULL, 16, NULL, 2, 1, NULL, NULL);
87-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (29, 27, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-08-24 14:36:04.699204', NULL, 243648, NULL, 2, 1, NULL, NULL);
88-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (30, 28, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-08-24 14:39:04.708167', NULL, 243649, NULL, 2, 1, NULL, NULL);
89-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (31, 29, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-08-24 14:41:04.427117', NULL, 243650, NULL, 2, 1, NULL, NULL);
90+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (1, 4, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2005-06-06 08:59:51.895136', NULL, 12, 2, 1, NULL, NULL);
91+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (2, 4, '1.0', 'The 1.0 branch of the Mozilla web browser. Currently, this is the stable branch of Mozilla, and all stable releases are made off this branch.', NULL, NULL, '2005-06-06 08:59:51.898385', NULL, 12, 2, 1, NULL, NULL);
92+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (3, 5, 'trunk', 'The primary "trunk" of development for this product. This series
93+was automatically created and represents the idea of a primary trunk
94+of software development without "stable branches". For most
95+products, releases in this series will be "milestone" or "test"
96+releases, and there should be other series for the stable releases
97+of the product.', NULL, NULL, '2005-06-06 08:59:51.914873', NULL, 12, 2, 1, 14, NULL);
98+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (4, 8, 'trunk', 'The primary "trunk" of development for this product. This series
99+was automatically created and represents the idea of a primary trunk
100+of software development without "stable branches". For most
101+products, releases in this series will be "milestone" or "test"
102+releases, and there should be other series for the stable releases
103+of the product.', NULL, NULL, '2005-06-06 08:59:51.91214', NULL, 12, 2, 1, NULL, NULL);
104+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (5, 11, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2005-06-06 08:59:51.899819', NULL, 12, 2, 1, NULL, NULL);
105+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (6, 12, 'trunk', 'The primary upstream development branch, from which all releases are made.', NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, 2, 1, NULL, NULL);
106+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (7, 12, 'failedbranch', 'A branch where auto test has failed.', NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, 2, 1, NULL, NULL);
107+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (8, 15, 'trunk', 'The mainline for alsa-utils', NULL, NULL, '2005-09-15 09:10:03.531637', NULL, 1, 2, 1, NULL, NULL);
108+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (9, 16, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-07-11 19:59:17.311451', NULL, 12, 2, 1, NULL, NULL);
109+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (10, 14, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
110+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (11, 13, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, 2, 1, NULL, NULL);
111+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (12, 9, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, 2, 1, NULL, NULL);
112+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (13, 7, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
113+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (14, 6, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
114+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (15, 3, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 2, 2, 1, NULL, NULL);
115+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (16, 1, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 17, 2, 1, NULL, NULL);
116+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (17, 2, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, 2, 1, NULL, NULL);
117+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (18, 10, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, 2, 1, NULL, NULL);
118+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (19, 17, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-11-24 12:48:19.178553', NULL, 12, 2, 1, NULL, NULL);
119+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (20, 18, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-14 18:47:04.891546', NULL, 37, 2, 1, NULL, NULL);
120+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (21, 19, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-14 18:53:13.112116', NULL, 28, 2, 1, NULL, NULL);
121+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (22, 20, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-15 20:11:49.501871', NULL, 14, 2, 1, NULL, NULL);
122+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (23, 21, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-27 16:28:27.763632', NULL, 12, 2, 1, NULL, NULL);
123+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (24, 22, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-04-18 20:58:56.846607', NULL, 12, 2, 1, NULL, NULL);
124+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (25, 23, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-11-19 12:44:30.603892', NULL, 1, 2, 1, NULL, NULL);
125+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (26, 24, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2008-06-27 14:51:47.366199', NULL, 243623, 2, 1, NULL, NULL);
126+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (27, 25, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2008-10-02 10:12:40.909504', NULL, 16, 2, 1, NULL, NULL);
127+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (28, 26, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2009-05-02 21:33:15.310312', NULL, 16, 2, 1, NULL, NULL);
128+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (29, 27, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2009-08-24 14:36:04.699204', NULL, 243648, 2, 1, NULL, NULL);
129+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (30, 28, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2009-08-24 14:39:04.708167', NULL, 243649, 2, 1, NULL, NULL);
130+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (31, 29, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2009-08-24 14:41:04.427117', NULL, 243650, 2, 1, NULL, NULL);
131
132
133 ALTER TABLE productseries ENABLE TRIGGER ALL;
134
135=== modified file 'database/sampledata/current.sql'
136--- database/sampledata/current.sql 2009-08-27 19:09:44 +0000
137+++ database/sampledata/current.sql 2009-09-24 17:04:20 +0000
138@@ -1471,6 +1471,13 @@
139 ALTER TABLE bugnotification ENABLE TRIGGER ALL;
140
141
142+ALTER TABLE bugnotificationarchive DISABLE TRIGGER ALL;
143+
144+
145+
146+ALTER TABLE bugnotificationarchive ENABLE TRIGGER ALL;
147+
148+
149 ALTER TABLE bugnotificationattachment DISABLE TRIGGER ALL;
150
151
152@@ -1485,6 +1492,13 @@
153 ALTER TABLE bugnotificationrecipient ENABLE TRIGGER ALL;
154
155
156+ALTER TABLE bugnotificationrecipientarchive DISABLE TRIGGER ALL;
157+
158+
159+
160+ALTER TABLE bugnotificationrecipientarchive ENABLE TRIGGER ALL;
161+
162+
163 ALTER TABLE bugpackageinfestation DISABLE TRIGGER ALL;
164
165
166@@ -7880,44 +7894,44 @@
167
168 ALTER TABLE productseries DISABLE TRIGGER ALL;
169
170-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (1, 4, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.895136', NULL, 12, NULL, 2, 1, NULL, NULL);
171-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (2, 4, '1.0', 'The 1.0 branch of the Mozilla web browser. Currently, this is the stable branch of Mozilla, and all stable releases are made off this branch.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.898385', NULL, 12, NULL, 2, 1, NULL, NULL);
172-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (3, 5, 'trunk', 'The primary "trunk" of development for this product. This series
173-was automatically created and represents the idea of a primary trunk
174-of software development without "stable branches". For most
175-products, releases in this series will be "milestone" or "test"
176-releases, and there should be other series for the stable releases
177-of the product.', 5, NULL, NULL, 1, ':pserver:anonymous@anoncvs.gnome.org:/cvs/gnome', 'evolution', 'MAIN', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.914873', NULL, 12, NULL, 2, 1, 14, NULL);
178-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (4, 8, 'trunk', 'The primary "trunk" of development for this product. This series
179-was automatically created and represents the idea of a primary trunk
180-of software development without "stable branches". For most
181-products, releases in this series will be "milestone" or "test"
182-releases, and there should be other series for the stable releases
183-of the product.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.91214', NULL, 12, NULL, 2, 1, NULL, NULL);
184-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (5, 11, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.899819', NULL, 12, NULL, 2, 1, NULL, NULL);
185-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (6, 12, 'trunk', 'The primary upstream development branch, from which all releases are made.', 2, NULL, NULL, 1, ':pserver:anonymous@cvs.sourceforge.net:/cvsroot/liba52', 'a52dec', 'MAIN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, NULL, 2, 1, NULL, NULL);
186-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (7, 12, 'failedbranch', 'A branch where auto test has failed.', 3, NULL, NULL, 1, ':pserver:anonymous@cvs.sourceforge.net:/cvsroot/liba52', 'a52dec', 'AUTOTESTFAILED', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, NULL, 2, 1, NULL, NULL);
187-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (8, 15, 'trunk', 'The mainline for alsa-utils', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-09-15 09:10:03.531637', NULL, 1, NULL, 2, 1, NULL, NULL);
188-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (9, 16, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-07-11 19:59:17.311451', NULL, 12, NULL, 2, 1, NULL, NULL);
189-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (10, 14, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
190-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (11, 13, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, NULL, 2, 1, NULL, NULL);
191-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (12, 9, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, NULL, 2, 1, NULL, NULL);
192-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (13, 7, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
193-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (14, 6, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
194-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (15, 3, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 2, NULL, 2, 1, NULL, NULL);
195-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (16, 1, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 17, NULL, 2, 1, NULL, NULL);
196-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (17, 2, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, NULL, 2, 1, NULL, NULL);
197-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (18, 10, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, NULL, 2, 1, NULL, NULL);
198-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (19, 17, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-11-24 12:48:19.178553', NULL, 12, NULL, 2, 1, NULL, NULL);
199-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (20, 18, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-14 18:47:04.891546', NULL, 37, NULL, 2, 1, NULL, NULL);
200-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (21, 19, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-14 18:53:13.112116', NULL, 28, NULL, 2, 1, NULL, NULL);
201-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (22, 20, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-15 20:11:49.501871', NULL, 14, NULL, 2, 1, NULL, NULL);
202-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (23, 21, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-27 16:28:27.763632', NULL, 12, NULL, 2, 1, NULL, NULL);
203-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (24, 22, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-04-18 20:58:56.846607', NULL, 12, NULL, 2, 1, NULL, NULL);
204-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (25, 23, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-11-19 12:44:30.603892', NULL, 1, NULL, 2, 1, NULL, NULL);
205-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (26, 24, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-06-27 14:51:47.366199', NULL, 243623, NULL, 2, 1, NULL, NULL);
206-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (27, 25, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-10-02 10:12:40.909504', NULL, 16, NULL, 2, 1, NULL, NULL);
207-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (28, 26, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-05-02 21:33:15.310312', NULL, 16, NULL, 2, 1, NULL, NULL);
208+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (1, 4, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2005-06-06 08:59:51.895136', NULL, 12, 2, 1, NULL, NULL);
209+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (2, 4, '1.0', 'The 1.0 branch of the Mozilla web browser. Currently, this is the stable branch of Mozilla, and all stable releases are made off this branch.', NULL, NULL, '2005-06-06 08:59:51.898385', NULL, 12, 2, 1, NULL, NULL);
210+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (3, 5, 'trunk', 'The primary "trunk" of development for this product. This series
211+was automatically created and represents the idea of a primary trunk
212+of software development without "stable branches". For most
213+products, releases in this series will be "milestone" or "test"
214+releases, and there should be other series for the stable releases
215+of the product.', NULL, NULL, '2005-06-06 08:59:51.914873', NULL, 12, 2, 1, 14, NULL);
216+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (4, 8, 'trunk', 'The primary "trunk" of development for this product. This series
217+was automatically created and represents the idea of a primary trunk
218+of software development without "stable branches". For most
219+products, releases in this series will be "milestone" or "test"
220+releases, and there should be other series for the stable releases
221+of the product.', NULL, NULL, '2005-06-06 08:59:51.91214', NULL, 12, 2, 1, NULL, NULL);
222+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (5, 11, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2005-06-06 08:59:51.899819', NULL, 12, 2, 1, NULL, NULL);
223+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (6, 12, 'trunk', 'The primary upstream development branch, from which all releases are made.', NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, 2, 1, NULL, NULL);
224+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (7, 12, 'failedbranch', 'A branch where auto test has failed.', NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, 2, 1, NULL, NULL);
225+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (8, 15, 'trunk', 'The mainline for alsa-utils', NULL, NULL, '2005-09-15 09:10:03.531637', NULL, 1, 2, 1, NULL, NULL);
226+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (9, 16, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-07-11 19:59:17.311451', NULL, 12, 2, 1, NULL, NULL);
227+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (10, 14, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
228+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (11, 13, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, 2, 1, NULL, NULL);
229+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (12, 9, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, 2, 1, NULL, NULL);
230+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (13, 7, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
231+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (14, 6, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
232+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (15, 3, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 2, 2, 1, NULL, NULL);
233+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (16, 1, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 17, 2, 1, NULL, NULL);
234+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (17, 2, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, 2, 1, NULL, NULL);
235+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (18, 10, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, 2, 1, NULL, NULL);
236+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (19, 17, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-11-24 12:48:19.178553', NULL, 12, 2, 1, NULL, NULL);
237+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (20, 18, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-14 18:47:04.891546', NULL, 37, 2, 1, NULL, NULL);
238+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (21, 19, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-14 18:53:13.112116', NULL, 28, 2, 1, NULL, NULL);
239+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (22, 20, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-15 20:11:49.501871', NULL, 14, 2, 1, NULL, NULL);
240+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (23, 21, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-27 16:28:27.763632', NULL, 12, 2, 1, NULL, NULL);
241+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (24, 22, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-04-18 20:58:56.846607', NULL, 12, 2, 1, NULL, NULL);
242+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (25, 23, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-11-19 12:44:30.603892', NULL, 1, 2, 1, NULL, NULL);
243+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (26, 24, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2008-06-27 14:51:47.366199', NULL, 243623, 2, 1, NULL, NULL);
244+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (27, 25, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2008-10-02 10:12:40.909504', NULL, 16, 2, 1, NULL, NULL);
245+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (28, 26, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2009-05-02 21:33:15.310312', NULL, 16, 2, 1, NULL, NULL);
246
247
248 ALTER TABLE productseries ENABLE TRIGGER ALL;
249
250=== modified file 'database/schema/Makefile'
251--- database/schema/Makefile 2009-08-04 11:07:08 +0000
252+++ database/schema/Makefile 2009-09-24 17:04:20 +0000
253@@ -57,14 +57,15 @@
254
255
256 # The latest schema dump from production. Database patches are relative
257-# to this baseline. This dump should be updated every production rollout
258+# to this baseline. This dump should be updated occasionally from production
259 # to ensure that the development database remains in sync with reality
260 # on production. It is generated using newbaseline.py in
261 # bzr+ssh://devpad.canonical.com/code/stub/dbascripts
262 #
263-REV=2109
264+REV=2207
265 BASELINE=launchpad-${REV}-00-0.sql
266-MD5SUM=8a2e8fb0c3665cf1b07487fe3650816e launchpad-2109-00-0.sql
267+MD5SUM=6a28c01a33ee2dc133ab4f8931d94282 launchpad-2207-00-0.sql
268+
269 default: all
270
271 # Create a launchpad_ftest_template DB and load the test sample data into it.
272@@ -107,7 +108,7 @@
273 # database schema, full text indexes and grants into it.
274 # It will also create session DBs for the test and dev environments.
275 # No sample data is added at this point.
276-create: check
277+create:
278 @ echo "* If this fails you need to run as the postgresql superuser"
279 @ echo "* eg. sudo -u postgres make create"
280 @ echo
281
282=== modified file 'database/schema/comments.sql'
283--- database/schema/comments.sql 2009-07-17 00:26:05 +0000
284+++ database/schema/comments.sql 2009-09-24 17:04:20 +0000
285@@ -630,32 +630,6 @@
286 COMMENT ON COLUMN ProductSeries.status IS 'The current status of this productseries.';
287 COMMENT ON COLUMN ProductSeries.summary IS 'A summary of this Product Series. A good example would include the date the series was initiated and whether this is the current recommended series for people to use. The summary is usually displayed at the top of the page, in bold, just beneath the title and above the description, if there is a description field.';
288 COMMENT ON COLUMN ProductSeries.driver IS 'This is a person or team who can approve spes and bugs for implementation or fixing in this specific series. Note that the product drivers and project drivers can also do this for any series in the product or project, so use this only for the specific team responsible for this specific series.';
289-COMMENT ON COLUMN ProductSeries.importstatus IS 'A status flag which
290-gives the state of our efforts to import the upstream code from its revision
291-control system and publish that in the baz revision control system. The
292-allowed values are documented in ImportStatus.';
293-COMMENT ON COLUMN ProductSeries.rcstype IS 'The revision control system used
294-by upstream for this product series. The value is defined in
295-dbschema.RevisionControlSystems. If NULL, then there should be no CVS or
296-SVN information attached to this productseries, otherwise the relevant
297-fields for CVS or SVN etc should be filled out.';
298-COMMENT ON COLUMN ProductSeries.cvsroot IS 'The CVS root where this
299-productseries hosts its code. Only used if rcstype is CVS.';
300-COMMENT ON COLUMN ProductSeries.cvsmodule IS 'The CVS module which contains
301-the upstream code for this productseries. Only used if rcstype is CVS.';
302-COMMENT ON COLUMN ProductSeries.cvsmodule IS 'The CVS branch that contains
303-the upstream code for this productseries. Only used if rcstype is CVS.';
304-COMMENT ON COLUMN ProductSeries.cvstarfileurl IS 'The URL of a tarfile of
305-the CVS repository for this productseries. This is an optimisation of the
306-CVS import process - instead of hitting the server to pass us every set of
307-changes in history, we can sometimes arrange to be given a tarfile of the
308-CVS repository and then process it all locally. Once imported, we switch
309-back to using the CVS server for ongoing syncronization. Only used if
310-rcstype is CVS.';
311-COMMENT ON COLUMN ProductSeries.svnrepository IS 'The URL of the SVN branch
312-where the upstream productseries code can be found. This single URL is the
313-equivalent of the cvsroot, cvsmodule and cvsbranch for CVS. Only used if
314-rcstype is SVN.';
315 COMMENT ON COLUMN ProductSeries.releasefileglob IS 'A fileglob that lets us
316 see which URLs are potentially new upstream tarball releases. For example:
317 http://ftp.gnu.org/gnu/libtool/libtool-1.5.*.gz.';
318@@ -663,25 +637,6 @@
319 of this product series release version numbering system. The options are
320 documented in dbschema.UpstreamReleaseVersionStyle. Most applications use
321 Gnu style numbering, but there are other alternatives.';
322-COMMENT ON COLUMN ProductSeries.dateprocessapproved IS 'The timestamp when
323-this upstream import was certified for processing. Processing means it has
324-passed autotesting, and is being moved towards production syncing. If the
325-sync goes well, it will be approved for sync and then be fully in
326-production.';
327-COMMENT ON COLUMN ProductSeries.datesyncapproved IS 'The timestamp when this
328-upstream import was certified for ongoing syncronisation.';
329-COMMENT ON COLUMN ProductSeries.dateautotested IS 'This upstream revision
330-control system target has passed automatic testing. It can probably be moved
331-towards production sync status. This date is the timestamp when it passed
332-the autotester. The autotester allows us to find the low hanging fruit that
333-is easily brought into the bazaar import system by highlighting repositories
334-which had no apparent difficulty in being imported.';
335-COMMENT ON COLUMN ProductSeries.datestarted IS 'The timestamp when we last
336-initiated an import test or sync of this upstream repository.';
337-COMMENT ON COLUMN ProductSeries.datefinished IS 'The timestamp when we last
338-completed an import test or sync of this upstream repository.';
339-COMMENT ON COLUMN ProductSeries.datelastsynced IS 'The timestamp when we last successfully completed a production sync of this upstream repository.';
340-COMMENT ON COLUMN ProductSeries.date_published_sync IS 'The saved value of datelastsynced from the last time it was older than the corresponding branch''s last_mirrored timestamp. The timestamp currently published import branch is either datelastsynced or datepublishedsync.';
341 COMMENT ON COLUMN ProductSeries.branch IS 'The branch for this product
342 series.';
343 COMMENT ON COLUMN ProductSeries.translations_autoimport_mode IS 'Level of
344
345=== renamed file 'database/schema/launchpad-2109-00-0.sql' => 'database/schema/launchpad-2207-00-0.sql'
346--- database/schema/launchpad-2109-00-0.sql 2008-10-06 04:17:49 +0000
347+++ database/schema/launchpad-2207-00-0.sql 2009-09-24 17:04:20 +0000
348@@ -1,4 +1,7 @@
349--- Generated Tue Sep 23 11:46:25 2008 UTC
350+-- Copyright 2009 Canonical Ltd. This software is licensed under the
351+-- GNU Affero General Public License version 3 (see the file LICENSE).
352+
353+-- Generated Mon Jul 27 08:43:04 2009 UTC
354
355 SET client_min_messages TO ERROR;
356
357@@ -11,10 +14,51 @@
358
359 SET search_path = public, pg_catalog;
360
361+CREATE TYPE pgstattuple_type AS (
362+ table_len bigint,
363+ tuple_count bigint,
364+ tuple_len bigint,
365+ tuple_percent double precision,
366+ dead_tuple_count bigint,
367+ dead_tuple_len bigint,
368+ dead_tuple_percent double precision,
369+ free_space bigint,
370+ free_percent double precision
371+);
372+
373 SET default_tablespace = '';
374
375 SET default_with_oids = false;
376
377+CREATE TABLE revision (
378+ id integer NOT NULL,
379+ date_created timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
380+ log_body text NOT NULL,
381+ revision_author integer NOT NULL,
382+ gpgkey integer,
383+ revision_id text NOT NULL,
384+ revision_date timestamp without time zone,
385+ karma_allocated boolean DEFAULT false
386+);
387+ALTER TABLE ONLY revision ALTER COLUMN revision_author SET STATISTICS 500;
388+ALTER TABLE ONLY revision ALTER COLUMN revision_date SET STATISTICS 500;
389+
390+CREATE FUNCTION pgstattuple(text) RETURNS pgstattuple_type
391+ AS '$libdir/pgstattuple', 'pgstattuple'
392+ LANGUAGE c STRICT;
393+
394+CREATE FUNCTION pgstattuple(oid) RETURNS pgstattuple_type
395+ AS '$libdir/pgstattuple', 'pgstattuplebyid'
396+ LANGUAGE c STRICT;
397+
398+CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
399+ AS '$libdir/plpgsql', 'plpgsql_call_handler'
400+ LANGUAGE c;
401+
402+CREATE FUNCTION plpython_call_handler() RETURNS language_handler
403+ AS '$libdir/plpython', 'plpython_call_handler'
404+ LANGUAGE c;
405+
406 CREATE TABLE account (
407 id integer NOT NULL,
408 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
409@@ -27,12 +71,31 @@
410 old_openid_identifier text
411 );
412
413+CREATE SEQUENCE account_id_seq
414+ INCREMENT BY 1
415+ NO MAXVALUE
416+ NO MINVALUE
417+ CACHE 1;
418+
419+ALTER SEQUENCE account_id_seq OWNED BY account.id;
420+
421 CREATE TABLE accountpassword (
422 id integer NOT NULL,
423 account integer NOT NULL,
424 password text NOT NULL
425 );
426
427+CREATE SEQUENCE accountpassword_id_seq
428+ INCREMENT BY 1
429+ NO MAXVALUE
430+ NO MINVALUE
431+ CACHE 1;
432+
433+ALTER SEQUENCE accountpassword_id_seq OWNED BY accountpassword.id;
434+
435+CREATE VIEW alllocks AS
436+ SELECT a.procpid, a.usename, (now() - a.query_start) AS age, c.relname, l.mode, l.granted, a.current_query FROM ((pg_locks l JOIN pg_class c ON ((l.relation = c.oid))) LEFT JOIN pg_stat_activity a ON ((a.procpid = l.pid)));
437+
438 CREATE TABLE announcement (
439 id integer NOT NULL,
440 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
441@@ -50,6 +113,14 @@
442 CONSTRAINT valid_url CHECK (valid_absolute_url(url))
443 );
444
445+CREATE SEQUENCE announcement_id_seq
446+ INCREMENT BY 1
447+ NO MAXVALUE
448+ NO MINVALUE
449+ CACHE 1;
450+
451+ALTER SEQUENCE announcement_id_seq OWNED BY announcement.id;
452+
453 CREATE TABLE answercontact (
454 id integer NOT NULL,
455 product integer,
456@@ -60,13 +131,20 @@
457 CONSTRAINT valid_target CHECK ((((product IS NULL) <> (distribution IS NULL)) AND ((product IS NULL) OR (sourcepackagename IS NULL))))
458 );
459
460+CREATE SEQUENCE answercontact_id_seq
461+ INCREMENT BY 1
462+ NO MAXVALUE
463+ NO MINVALUE
464+ CACHE 1;
465+
466+ALTER SEQUENCE answercontact_id_seq OWNED BY answercontact.id;
467+
468 CREATE TABLE archive (
469 id integer NOT NULL,
470 owner integer NOT NULL,
471 description text,
472 enabled boolean DEFAULT true NOT NULL,
473 authorized_size integer,
474- whiteboard text,
475 distribution integer NOT NULL,
476 purpose integer NOT NULL,
477 private boolean DEFAULT false NOT NULL,
478@@ -86,16 +164,36 @@
479 building_count integer DEFAULT 0 NOT NULL,
480 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
481 signing_key integer,
482+ removed_binary_retention_days integer,
483+ num_old_versions_published integer,
484+ displayname text NOT NULL,
485+ relative_build_score integer DEFAULT 0 NOT NULL,
486 CONSTRAINT valid_buildd_secret CHECK ((((private = true) AND (buildd_secret IS NOT NULL)) OR (private = false))),
487 CONSTRAINT valid_name CHECK (valid_name(name))
488 );
489
490+CREATE SEQUENCE archive_id_seq
491+ INCREMENT BY 1
492+ NO MAXVALUE
493+ NO MINVALUE
494+ CACHE 1;
495+
496+ALTER SEQUENCE archive_id_seq OWNED BY archive.id;
497+
498 CREATE TABLE archivearch (
499 id integer NOT NULL,
500 archive integer NOT NULL,
501 processorfamily integer NOT NULL
502 );
503
504+CREATE SEQUENCE archivearch_id_seq
505+ INCREMENT BY 1
506+ NO MAXVALUE
507+ NO MINVALUE
508+ CACHE 1;
509+
510+ALTER SEQUENCE archivearch_id_seq OWNED BY archivearch.id;
511+
512 CREATE TABLE archiveauthtoken (
513 id integer NOT NULL,
514 archive integer NOT NULL,
515@@ -105,16 +203,32 @@
516 token text NOT NULL
517 );
518
519+CREATE SEQUENCE archiveauthtoken_id_seq
520+ INCREMENT BY 1
521+ NO MAXVALUE
522+ NO MINVALUE
523+ CACHE 1;
524+
525+ALTER SEQUENCE archiveauthtoken_id_seq OWNED BY archiveauthtoken.id;
526+
527 CREATE TABLE archivedependency (
528 id integer NOT NULL,
529 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
530 archive integer NOT NULL,
531 dependency integer NOT NULL,
532- pocket integer,
533+ pocket integer NOT NULL,
534 component integer,
535 CONSTRAINT distinct_archives CHECK ((archive <> dependency))
536 );
537
538+CREATE SEQUENCE archivedependency_id_seq
539+ INCREMENT BY 1
540+ NO MAXVALUE
541+ NO MINVALUE
542+ CACHE 1;
543+
544+ALTER SEQUENCE archivedependency_id_seq OWNED BY archivedependency.id;
545+
546 CREATE TABLE archivepermission (
547 id integer NOT NULL,
548 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
549@@ -123,9 +237,19 @@
550 archive integer NOT NULL,
551 component integer,
552 sourcepackagename integer,
553- CONSTRAINT component_or_sourcepackagename CHECK (((component IS NULL) OR (sourcepackagename IS NULL)))
554+ packageset integer,
555+ explicit boolean DEFAULT false NOT NULL,
556+ CONSTRAINT one_target CHECK ((null_count(ARRAY[packageset, component, sourcepackagename]) = 2))
557 );
558
559+CREATE SEQUENCE archivepermission_id_seq
560+ INCREMENT BY 1
561+ NO MAXVALUE
562+ NO MINVALUE
563+ CACHE 1;
564+
565+ALTER SEQUENCE archivepermission_id_seq OWNED BY archivepermission.id;
566+
567 CREATE TABLE archivesubscriber (
568 id integer NOT NULL,
569 archive integer NOT NULL,
570@@ -139,6 +263,34 @@
571 cancelled_by integer
572 );
573
574+CREATE SEQUENCE archivesubscriber_id_seq
575+ INCREMENT BY 1
576+ NO MAXVALUE
577+ NO MINVALUE
578+ CACHE 1;
579+
580+ALTER SEQUENCE archivesubscriber_id_seq OWNED BY archivesubscriber.id;
581+
582+CREATE TABLE authtoken (
583+ id integer NOT NULL,
584+ date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
585+ date_consumed timestamp without time zone,
586+ token_type integer NOT NULL,
587+ token text NOT NULL,
588+ requester integer,
589+ requester_email text,
590+ email text NOT NULL,
591+ redirection_url text
592+);
593+
594+CREATE SEQUENCE authtoken_id_seq
595+ INCREMENT BY 1
596+ NO MAXVALUE
597+ NO MINVALUE
598+ CACHE 1;
599+
600+ALTER SEQUENCE authtoken_id_seq OWNED BY authtoken.id;
601+
602 CREATE TABLE binarypackagename (
603 id integer NOT NULL,
604 name text NOT NULL,
605@@ -161,6 +313,14 @@
606 id integer DEFAULT nextval(('binarypackagefile_id_seq'::text)::regclass) NOT NULL
607 );
608
609+CREATE SEQUENCE binarypackagefile_id_seq
610+ INCREMENT BY 1
611+ NO MAXVALUE
612+ NO MINVALUE
613+ CACHE 1;
614+
615+ALTER SEQUENCE binarypackagefile_id_seq OWNED BY binarypackagefile.id;
616+
617 CREATE TABLE binarypackagerelease (
618 id integer NOT NULL,
619 binarypackagename integer NOT NULL,
620@@ -271,6 +431,7 @@
621 last_accessed timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
622 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
623 restricted boolean DEFAULT false NOT NULL,
624+ hits integer DEFAULT 0 NOT NULL,
625 CONSTRAINT valid_filename CHECK ((filename !~~ '%/%'::text))
626 );
627
628@@ -329,9 +490,25 @@
629 CREATE VIEW binarypackagefilepublishing AS
630 SELECT (((libraryfilealias.id)::text || '.'::text) || (securebinarypackagepublishinghistory.id)::text) AS id, distroseries.distribution, securebinarypackagepublishinghistory.id AS binarypackagepublishing, component.name AS componentname, libraryfilealias.filename AS libraryfilealiasfilename, sourcepackagename.name AS sourcepackagename, binarypackagefile.libraryfile AS libraryfilealias, distroseries.name AS distroseriesname, distroarchseries.architecturetag, securebinarypackagepublishinghistory.status AS publishingstatus, securebinarypackagepublishinghistory.pocket, securebinarypackagepublishinghistory.archive FROM (((((((((securebinarypackagepublishinghistory JOIN binarypackagerelease ON ((securebinarypackagepublishinghistory.binarypackagerelease = binarypackagerelease.id))) JOIN build ON ((binarypackagerelease.build = build.id))) JOIN sourcepackagerelease ON ((build.sourcepackagerelease = sourcepackagerelease.id))) JOIN sourcepackagename ON ((sourcepackagerelease.sourcepackagename = sourcepackagename.id))) JOIN binarypackagefile ON ((binarypackagefile.binarypackagerelease = binarypackagerelease.id))) JOIN libraryfilealias ON ((binarypackagefile.libraryfile = libraryfilealias.id))) JOIN distroarchseries ON ((securebinarypackagepublishinghistory.distroarchseries = distroarchseries.id))) JOIN distroseries ON ((distroarchseries.distroseries = distroseries.id))) JOIN component ON ((securebinarypackagepublishinghistory.component = component.id))) WHERE (securebinarypackagepublishinghistory.dateremoved IS NULL);
631
632+CREATE SEQUENCE binarypackagename_id_seq
633+ INCREMENT BY 1
634+ NO MAXVALUE
635+ NO MINVALUE
636+ CACHE 1;
637+
638+ALTER SEQUENCE binarypackagename_id_seq OWNED BY binarypackagename.id;
639+
640 CREATE VIEW binarypackagepublishinghistory AS
641 SELECT securebinarypackagepublishinghistory.id, securebinarypackagepublishinghistory.binarypackagerelease, securebinarypackagepublishinghistory.status, securebinarypackagepublishinghistory.component, securebinarypackagepublishinghistory.section, securebinarypackagepublishinghistory.priority, securebinarypackagepublishinghistory.distroarchseries, securebinarypackagepublishinghistory.pocket, securebinarypackagepublishinghistory.archive, securebinarypackagepublishinghistory.datecreated, securebinarypackagepublishinghistory.datepublished, securebinarypackagepublishinghistory.datesuperseded, securebinarypackagepublishinghistory.supersededby, securebinarypackagepublishinghistory.datemadepending, securebinarypackagepublishinghistory.scheduleddeletiondate, securebinarypackagepublishinghistory.dateremoved, securebinarypackagepublishinghistory.removed_by, securebinarypackagepublishinghistory.removal_comment, securebinarypackagepublishinghistory.embargo, securebinarypackagepublishinghistory.embargolifted FROM securebinarypackagepublishinghistory WHERE (securebinarypackagepublishinghistory.embargo = false);
642
643+CREATE SEQUENCE binarypackagerelease_id_seq
644+ INCREMENT BY 1
645+ NO MAXVALUE
646+ NO MINVALUE
647+ CACHE 1;
648+
649+ALTER SEQUENCE binarypackagerelease_id_seq OWNED BY binarypackagerelease.id;
650+
651 CREATE TABLE bounty (
652 id integer NOT NULL,
653 name text NOT NULL,
654@@ -349,18 +526,42 @@
655 bountystatus integer DEFAULT 1 NOT NULL
656 );
657
658+CREATE SEQUENCE bounty_id_seq
659+ INCREMENT BY 1
660+ NO MAXVALUE
661+ NO MINVALUE
662+ CACHE 1;
663+
664+ALTER SEQUENCE bounty_id_seq OWNED BY bounty.id;
665+
666 CREATE TABLE bountymessage (
667 id integer NOT NULL,
668 bounty integer NOT NULL,
669 message integer NOT NULL
670 );
671
672+CREATE SEQUENCE bountymessage_id_seq
673+ INCREMENT BY 1
674+ NO MAXVALUE
675+ NO MINVALUE
676+ CACHE 1;
677+
678+ALTER SEQUENCE bountymessage_id_seq OWNED BY bountymessage.id;
679+
680 CREATE TABLE bountysubscription (
681 id integer NOT NULL,
682 bounty integer NOT NULL,
683 person integer NOT NULL
684 );
685
686+CREATE SEQUENCE bountysubscription_id_seq
687+ INCREMENT BY 1
688+ NO MAXVALUE
689+ NO MINVALUE
690+ CACHE 1;
691+
692+ALTER SEQUENCE bountysubscription_id_seq OWNED BY bountysubscription.id;
693+
694 CREATE TABLE branch (
695 id integer NOT NULL,
696 title text,
697@@ -376,7 +577,6 @@
698 last_mirrored timestamp without time zone,
699 last_mirror_attempt timestamp without time zone,
700 mirror_failures integer DEFAULT 0 NOT NULL,
701- pull_disabled boolean DEFAULT false NOT NULL,
702 mirror_status_message text,
703 last_scanned timestamp without time zone,
704 last_scanned_id text,
705@@ -395,15 +595,46 @@
706 repository_format integer,
707 metadir_format integer,
708 stacked_on integer,
709+ distroseries integer,
710+ sourcepackagename integer,
711+ owner_name text NOT NULL,
712+ target_suffix text,
713+ unique_name text,
714+ size_on_disk bigint,
715 CONSTRAINT branch_merge_control CHECK (((merge_robot IS NULL) OR (merge_control_status = ANY (ARRAY[3, 4])))),
716 CONSTRAINT branch_type_url_consistent CHECK (((((branch_type = 2) AND (url IS NOT NULL)) OR ((branch_type = ANY (ARRAY[1, 3])) AND (url IS NULL))) OR (branch_type = 4))),
717 CONSTRAINT branch_url_no_trailing_slash CHECK ((url !~~ '%/'::text)),
718 CONSTRAINT branch_url_not_supermirror CHECK ((url !~~ 'http://bazaar.launchpad.net/%'::text)),
719+ CONSTRAINT one_container CHECK ((((distroseries IS NULL) = (sourcepackagename IS NULL)) AND ((distroseries IS NULL) OR (product IS NULL)))),
720 CONSTRAINT valid_home_page CHECK (valid_absolute_url(home_page)),
721 CONSTRAINT valid_name CHECK (valid_branch_name(name)),
722 CONSTRAINT valid_url CHECK (valid_absolute_url(url))
723 );
724
725+CREATE SEQUENCE branch_id_seq
726+ INCREMENT BY 1
727+ NO MAXVALUE
728+ NO MINVALUE
729+ CACHE 1;
730+
731+ALTER SEQUENCE branch_id_seq OWNED BY branch.id;
732+
733+CREATE TABLE branchjob (
734+ id integer NOT NULL,
735+ job integer NOT NULL,
736+ branch integer,
737+ job_type integer NOT NULL,
738+ json_data text
739+);
740+
741+CREATE SEQUENCE branchjob_id_seq
742+ INCREMENT BY 1
743+ NO MAXVALUE
744+ NO MINVALUE
745+ CACHE 1;
746+
747+ALTER SEQUENCE branchjob_id_seq OWNED BY branchjob.id;
748+
749 CREATE TABLE branchmergeproposal (
750 id integer NOT NULL,
751 registrant integer NOT NULL,
752@@ -432,10 +663,36 @@
753 merge_log_file integer,
754 superseded_by integer,
755 root_message_id text,
756+ review_diff integer,
757+ merge_diff integer,
758 CONSTRAINT different_branches CHECK ((((source_branch <> target_branch) AND (dependent_branch <> source_branch)) AND (dependent_branch <> target_branch))),
759 CONSTRAINT positive_revno CHECK (((merged_revno IS NULL) OR (merged_revno > 0)))
760 );
761
762+CREATE SEQUENCE branchmergeproposal_id_seq
763+ INCREMENT BY 1
764+ NO MAXVALUE
765+ NO MINVALUE
766+ CACHE 1;
767+
768+ALTER SEQUENCE branchmergeproposal_id_seq OWNED BY branchmergeproposal.id;
769+
770+CREATE TABLE branchmergeproposaljob (
771+ id integer NOT NULL,
772+ job integer NOT NULL,
773+ branch_merge_proposal integer NOT NULL,
774+ job_type integer NOT NULL,
775+ json_data text
776+);
777+
778+CREATE SEQUENCE branchmergeproposaljob_id_seq
779+ INCREMENT BY 1
780+ NO MAXVALUE
781+ NO MINVALUE
782+ CACHE 1;
783+
784+ALTER SEQUENCE branchmergeproposaljob_id_seq OWNED BY branchmergeproposaljob.id;
785+
786 CREATE TABLE branchmergerobot (
787 id integer NOT NULL,
788 registrant integer NOT NULL,
789@@ -445,12 +702,30 @@
790 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
791 );
792
793+CREATE SEQUENCE branchmergerobot_id_seq
794+ INCREMENT BY 1
795+ NO MAXVALUE
796+ NO MINVALUE
797+ CACHE 1;
798+
799+ALTER SEQUENCE branchmergerobot_id_seq OWNED BY branchmergerobot.id;
800+
801 CREATE TABLE branchrevision (
802 id integer NOT NULL,
803 sequence integer,
804 branch integer NOT NULL,
805 revision integer NOT NULL
806 );
807+ALTER TABLE ONLY branchrevision ALTER COLUMN branch SET STATISTICS 500;
808+ALTER TABLE ONLY branchrevision ALTER COLUMN revision SET STATISTICS 500;
809+
810+CREATE SEQUENCE branchrevision_id_seq
811+ INCREMENT BY 1
812+ NO MAXVALUE
813+ NO MINVALUE
814+ CACHE 1;
815+
816+ALTER SEQUENCE branchrevision_id_seq OWNED BY branchrevision.id;
817
818 CREATE TABLE branchsubscription (
819 id integer NOT NULL,
820@@ -462,6 +737,14 @@
821 review_level integer DEFAULT 0 NOT NULL
822 );
823
824+CREATE SEQUENCE branchsubscription_id_seq
825+ INCREMENT BY 1
826+ NO MAXVALUE
827+ NO MINVALUE
828+ CACHE 1;
829+
830+ALTER SEQUENCE branchsubscription_id_seq OWNED BY branchsubscription.id;
831+
832 CREATE TABLE branchvisibilitypolicy (
833 id integer NOT NULL,
834 project integer,
835@@ -471,6 +754,14 @@
836 CONSTRAINT only_one_target CHECK (((project IS NULL) <> (product IS NULL)))
837 );
838
839+CREATE SEQUENCE branchvisibilitypolicy_id_seq
840+ INCREMENT BY 1
841+ NO MAXVALUE
842+ NO MINVALUE
843+ CACHE 1;
844+
845+ALTER SEQUENCE branchvisibilitypolicy_id_seq OWNED BY branchvisibilitypolicy.id;
846+
847 CREATE TABLE person (
848 id integer NOT NULL,
849 displayname text NOT NULL,
850@@ -565,13 +856,14 @@
851 official_codehosting boolean DEFAULT false NOT NULL,
852 license_approved boolean DEFAULT false NOT NULL,
853 registrant integer NOT NULL,
854+ remote_product text,
855 CONSTRAINT only_launchpad_has_expiration CHECK (((enable_bug_expiration IS FALSE) OR (official_malone IS TRUE))),
856 CONSTRAINT private_bugs_need_contact CHECK (((private_bugs IS FALSE) OR (bug_supervisor IS NOT NULL))),
857 CONSTRAINT valid_name CHECK (valid_name(name))
858 );
859
860 CREATE VIEW branchwithsortkeys AS
861- SELECT branch.id, branch.title, branch.summary, branch.owner, branch.product, branch.author, branch.name, branch.home_page, branch.url, branch.whiteboard, branch.lifecycle_status, branch.last_mirrored, branch.last_mirror_attempt, branch.mirror_failures, branch.pull_disabled, branch.mirror_status_message, branch.last_scanned, branch.last_scanned_id, branch.last_mirrored_id, branch.date_created, branch.revision_count, branch.next_mirror_time, branch.private, branch.branch_type, branch.reviewer, branch.merge_robot, branch.merge_control_status, branch.date_last_modified, branch.registrant, product.name AS product_name, author.displayname AS author_name, owner.displayname AS owner_name FROM (((branch JOIN person owner ON ((branch.owner = owner.id))) LEFT JOIN product ON ((branch.product = product.id))) LEFT JOIN person author ON ((branch.author = author.id)));
862+ SELECT branch.id, branch.title, branch.summary, branch.owner, branch.product, branch.author, branch.name, branch.home_page, branch.url, branch.whiteboard, branch.lifecycle_status, branch.last_mirrored, branch.last_mirror_attempt, branch.mirror_failures, branch.mirror_status_message, branch.last_scanned, branch.last_scanned_id, branch.last_mirrored_id, branch.date_created, branch.revision_count, branch.next_mirror_time, branch.private, branch.branch_type, branch.reviewer, branch.merge_robot, branch.merge_control_status, branch.date_last_modified, branch.registrant, branch.branch_format, branch.repository_format, branch.metadir_format, branch.stacked_on, product.name AS product_name, author.displayname AS author_name, owner.displayname AS owner_name FROM (((branch JOIN person owner ON ((branch.owner = owner.id))) LEFT JOIN product ON ((branch.product = product.id))) LEFT JOIN person author ON ((branch.author = author.id)));
863
864 CREATE TABLE bug (
865 id integer NOT NULL,
866@@ -591,11 +883,21 @@
867 number_of_duplicates integer DEFAULT 0 NOT NULL,
868 message_count integer DEFAULT 0 NOT NULL,
869 users_affected_count integer DEFAULT 0,
870+ users_unaffected_count integer DEFAULT 0,
871+ hotness integer DEFAULT 0 NOT NULL,
872 CONSTRAINT notduplicateofself CHECK ((NOT (id = duplicateof))),
873 CONSTRAINT sane_description CHECK (((ltrim(description) <> ''::text) AND (char_length(description) <= 50000))),
874 CONSTRAINT valid_bug_name CHECK (valid_bug_name(name))
875 );
876
877+CREATE SEQUENCE bug_id_seq
878+ INCREMENT BY 1
879+ NO MAXVALUE
880+ NO MINVALUE
881+ CACHE 1;
882+
883+ALTER SEQUENCE bug_id_seq OWNED BY bug.id;
884+
885 CREATE TABLE bugactivity (
886 id integer NOT NULL,
887 bug integer NOT NULL,
888@@ -607,12 +909,29 @@
889 message text
890 );
891
892+CREATE SEQUENCE bugactivity_id_seq
893+ INCREMENT BY 1
894+ NO MAXVALUE
895+ NO MINVALUE
896+ CACHE 1;
897+
898+ALTER SEQUENCE bugactivity_id_seq OWNED BY bugactivity.id;
899+
900 CREATE TABLE bugaffectsperson (
901 id integer NOT NULL,
902 bug integer NOT NULL,
903- person integer NOT NULL
904+ person integer NOT NULL,
905+ affected boolean DEFAULT true NOT NULL
906 );
907
908+CREATE SEQUENCE bugaffectsperson_id_seq
909+ INCREMENT BY 1
910+ NO MAXVALUE
911+ NO MINVALUE
912+ CACHE 1;
913+
914+ALTER SEQUENCE bugaffectsperson_id_seq OWNED BY bugaffectsperson.id;
915+
916 CREATE TABLE bugattachment (
917 id integer NOT NULL,
918 message integer NOT NULL,
919@@ -624,17 +943,32 @@
920 CONSTRAINT valid_name CHECK (valid_name(name))
921 );
922
923+CREATE SEQUENCE bugattachment_id_seq
924+ INCREMENT BY 1
925+ NO MAXVALUE
926+ NO MINVALUE
927+ CACHE 1;
928+
929+ALTER SEQUENCE bugattachment_id_seq OWNED BY bugattachment.id;
930+
931 CREATE TABLE bugbranch (
932 id integer NOT NULL,
933 datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
934 bug integer NOT NULL,
935 branch integer NOT NULL,
936 revision_hint integer,
937- status integer NOT NULL,
938 whiteboard text,
939 registrant integer NOT NULL
940 );
941
942+CREATE SEQUENCE bugbranch_id_seq
943+ INCREMENT BY 1
944+ NO MAXVALUE
945+ NO MINVALUE
946+ CACHE 1;
947+
948+ALTER SEQUENCE bugbranch_id_seq OWNED BY bugbranch.id;
949+
950 CREATE TABLE bugcve (
951 id integer NOT NULL,
952 bug integer NOT NULL,
953@@ -642,6 +976,14 @@
954 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
955 );
956
957+CREATE SEQUENCE bugcve_id_seq
958+ INCREMENT BY 1
959+ NO MAXVALUE
960+ NO MINVALUE
961+ CACHE 1;
962+
963+ALTER SEQUENCE bugcve_id_seq OWNED BY bugcve.id;
964+
965 CREATE TABLE bugmessage (
966 id integer NOT NULL,
967 bug integer NOT NULL,
968@@ -652,6 +994,14 @@
969 CONSTRAINT imported_comment CHECK (((remote_comment_id IS NULL) OR (bugwatch IS NOT NULL)))
970 );
971
972+CREATE SEQUENCE bugmessage_id_seq
973+ INCREMENT BY 1
974+ NO MAXVALUE
975+ NO MINVALUE
976+ CACHE 1;
977+
978+ALTER SEQUENCE bugmessage_id_seq OWNED BY bugmessage.id;
979+
980 CREATE TABLE bugnomination (
981 id integer NOT NULL,
982 bug integer NOT NULL,
983@@ -661,9 +1011,18 @@
984 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()),
985 date_decided timestamp without time zone,
986 owner integer NOT NULL,
987- decider integer
988+ decider integer,
989+ CONSTRAINT distroseries_or_productseries CHECK (((distroseries IS NULL) <> (productseries IS NULL)))
990 );
991
992+CREATE SEQUENCE bugnomination_id_seq
993+ INCREMENT BY 1
994+ NO MAXVALUE
995+ NO MINVALUE
996+ CACHE 1;
997+
998+ALTER SEQUENCE bugnomination_id_seq OWNED BY bugnomination.id;
999+
1000 CREATE TABLE bugnotification (
1001 id integer NOT NULL,
1002 bug integer NOT NULL,
1003@@ -672,6 +1031,28 @@
1004 date_emailed timestamp without time zone
1005 );
1006
1007+CREATE SEQUENCE bugnotification_id_seq
1008+ INCREMENT BY 1
1009+ NO MAXVALUE
1010+ NO MINVALUE
1011+ CACHE 1;
1012+
1013+ALTER SEQUENCE bugnotification_id_seq OWNED BY bugnotification.id;
1014+
1015+CREATE TABLE bugnotificationattachment (
1016+ id integer NOT NULL,
1017+ message integer NOT NULL,
1018+ bug_notification integer NOT NULL
1019+);
1020+
1021+CREATE SEQUENCE bugnotificationattachment_id_seq
1022+ INCREMENT BY 1
1023+ NO MAXVALUE
1024+ NO MINVALUE
1025+ CACHE 1;
1026+
1027+ALTER SEQUENCE bugnotificationattachment_id_seq OWNED BY bugnotificationattachment.id;
1028+
1029 CREATE TABLE bugnotificationrecipient (
1030 id integer NOT NULL,
1031 bug_notification integer NOT NULL,
1032@@ -680,6 +1061,14 @@
1033 reason_body text NOT NULL
1034 );
1035
1036+CREATE SEQUENCE bugnotificationrecipient_id_seq
1037+ INCREMENT BY 1
1038+ NO MAXVALUE
1039+ NO MINVALUE
1040+ CACHE 1;
1041+
1042+ALTER SEQUENCE bugnotificationrecipient_id_seq OWNED BY bugnotificationrecipient.id;
1043+
1044 CREATE TABLE bugpackageinfestation (
1045 id integer NOT NULL,
1046 bug integer NOT NULL,
1047@@ -694,6 +1083,14 @@
1048 lastmodifiedby integer NOT NULL
1049 );
1050
1051+CREATE SEQUENCE bugpackageinfestation_id_seq
1052+ INCREMENT BY 1
1053+ NO MAXVALUE
1054+ NO MINVALUE
1055+ CACHE 1;
1056+
1057+ALTER SEQUENCE bugpackageinfestation_id_seq OWNED BY bugpackageinfestation.id;
1058+
1059 CREATE TABLE bugproductinfestation (
1060 id integer NOT NULL,
1061 bug integer NOT NULL,
1062@@ -708,6 +1105,14 @@
1063 lastmodifiedby integer NOT NULL
1064 );
1065
1066+CREATE SEQUENCE bugproductinfestation_id_seq
1067+ INCREMENT BY 1
1068+ NO MAXVALUE
1069+ NO MINVALUE
1070+ CACHE 1;
1071+
1072+ALTER SEQUENCE bugproductinfestation_id_seq OWNED BY bugproductinfestation.id;
1073+
1074 CREATE TABLE bugsubscription (
1075 id integer NOT NULL,
1076 person integer NOT NULL,
1077@@ -716,6 +1121,14 @@
1078 subscribed_by integer NOT NULL
1079 );
1080
1081+CREATE SEQUENCE bugsubscription_id_seq
1082+ INCREMENT BY 1
1083+ NO MAXVALUE
1084+ NO MINVALUE
1085+ CACHE 1;
1086+
1087+ALTER SEQUENCE bugsubscription_id_seq OWNED BY bugsubscription.id;
1088+
1089 CREATE TABLE bugtag (
1090 id integer NOT NULL,
1091 bug integer NOT NULL,
1092@@ -723,6 +1136,14 @@
1093 CONSTRAINT valid_tag CHECK (valid_name(tag))
1094 );
1095
1096+CREATE SEQUENCE bugtag_id_seq
1097+ INCREMENT BY 1
1098+ NO MAXVALUE
1099+ NO MINVALUE
1100+ CACHE 1;
1101+
1102+ALTER SEQUENCE bugtag_id_seq OWNED BY bugtag.id;
1103+
1104 CREATE TABLE bugtask (
1105 id integer NOT NULL,
1106 bug integer NOT NULL,
1107@@ -752,9 +1173,20 @@
1108 date_triaged timestamp without time zone,
1109 date_fix_committed timestamp without time zone,
1110 date_fix_released timestamp without time zone,
1111+ date_left_closed timestamp without time zone,
1112+ hotness_rank integer DEFAULT 0 NOT NULL,
1113+ date_milestone_set timestamp without time zone,
1114 CONSTRAINT bugtask_assignment_checks CHECK (CASE WHEN (product IS NOT NULL) THEN ((((productseries IS NULL) AND (distribution IS NULL)) AND (distroseries IS NULL)) AND (sourcepackagename IS NULL)) WHEN (productseries IS NOT NULL) THEN (((distribution IS NULL) AND (distroseries IS NULL)) AND (sourcepackagename IS NULL)) WHEN (distribution IS NOT NULL) THEN (distroseries IS NULL) WHEN (distroseries IS NOT NULL) THEN true ELSE false END)
1115 );
1116
1117+CREATE SEQUENCE bugtask_id_seq
1118+ INCREMENT BY 1
1119+ NO MAXVALUE
1120+ NO MINVALUE
1121+ CACHE 1;
1122+
1123+ALTER SEQUENCE bugtask_id_seq OWNED BY bugtask.id;
1124+
1125 CREATE TABLE bugtracker (
1126 id integer NOT NULL,
1127 bugtrackertype integer NOT NULL,
1128@@ -768,15 +1200,32 @@
1129 version text,
1130 block_comment_pushing boolean DEFAULT false NOT NULL,
1131 has_lp_plugin boolean,
1132+ active boolean DEFAULT true NOT NULL,
1133 CONSTRAINT valid_name CHECK (valid_name(name))
1134 );
1135
1136+CREATE SEQUENCE bugtracker_id_seq
1137+ INCREMENT BY 1
1138+ NO MAXVALUE
1139+ NO MINVALUE
1140+ CACHE 1;
1141+
1142+ALTER SEQUENCE bugtracker_id_seq OWNED BY bugtracker.id;
1143+
1144 CREATE TABLE bugtrackeralias (
1145 id integer NOT NULL,
1146 bugtracker integer NOT NULL,
1147 base_url text NOT NULL
1148 );
1149
1150+CREATE SEQUENCE bugtrackeralias_id_seq
1151+ INCREMENT BY 1
1152+ NO MAXVALUE
1153+ NO MINVALUE
1154+ CACHE 1;
1155+
1156+ALTER SEQUENCE bugtrackeralias_id_seq OWNED BY bugtrackeralias.id;
1157+
1158 CREATE TABLE bugtrackerperson (
1159 id integer NOT NULL,
1160 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
1161@@ -785,6 +1234,14 @@
1162 name text NOT NULL
1163 );
1164
1165+CREATE SEQUENCE bugtrackerperson_id_seq
1166+ INCREMENT BY 1
1167+ NO MAXVALUE
1168+ NO MINVALUE
1169+ CACHE 1;
1170+
1171+ALTER SEQUENCE bugtrackerperson_id_seq OWNED BY bugtrackerperson.id;
1172+
1173 CREATE TABLE bugwatch (
1174 id integer NOT NULL,
1175 bug integer NOT NULL,
1176@@ -800,6 +1257,22 @@
1177 remote_lp_bug_id integer
1178 );
1179
1180+CREATE SEQUENCE bugwatch_id_seq
1181+ INCREMENT BY 1
1182+ NO MAXVALUE
1183+ NO MINVALUE
1184+ CACHE 1;
1185+
1186+ALTER SEQUENCE bugwatch_id_seq OWNED BY bugwatch.id;
1187+
1188+CREATE SEQUENCE build_id_seq
1189+ INCREMENT BY 1
1190+ NO MAXVALUE
1191+ NO MINVALUE
1192+ CACHE 1;
1193+
1194+ALTER SEQUENCE build_id_seq OWNED BY build.id;
1195+
1196 CREATE TABLE builder (
1197 id integer NOT NULL,
1198 processor integer NOT NULL,
1199@@ -819,6 +1292,14 @@
1200 CONSTRAINT valid_absolute_url CHECK (valid_absolute_url(url))
1201 );
1202
1203+CREATE SEQUENCE builder_id_seq
1204+ INCREMENT BY 1
1205+ NO MAXVALUE
1206+ NO MINVALUE
1207+ CACHE 1;
1208+
1209+ALTER SEQUENCE builder_id_seq OWNED BY builder.id;
1210+
1211 CREATE TABLE buildqueue (
1212 id integer NOT NULL,
1213 build integer NOT NULL,
1214@@ -830,6 +1311,14 @@
1215 manual boolean DEFAULT false NOT NULL
1216 );
1217
1218+CREATE SEQUENCE buildqueue_id_seq
1219+ INCREMENT BY 1
1220+ NO MAXVALUE
1221+ NO MINVALUE
1222+ CACHE 1;
1223+
1224+ALTER SEQUENCE buildqueue_id_seq OWNED BY buildqueue.id;
1225+
1226 CREATE TABLE codeimport (
1227 id integer NOT NULL,
1228 branch integer NOT NULL,
1229@@ -844,9 +1333,18 @@
1230 owner integer NOT NULL,
1231 assignee integer,
1232 update_interval interval,
1233- CONSTRAINT valid_vcs_details CHECK (CASE WHEN (rcs_type = 1) THEN (((((cvs_root IS NOT NULL) AND (cvs_root <> ''::text)) AND (cvs_module IS NOT NULL)) AND (cvs_module <> ''::text)) AND (svn_branch_url IS NULL)) WHEN (rcs_type = 2) THEN ((((cvs_root IS NULL) AND (cvs_module IS NULL)) AND (svn_branch_url IS NOT NULL)) AND valid_absolute_url(svn_branch_url)) ELSE false END)
1234+ git_repo_url text,
1235+ CONSTRAINT valid_vcs_details CHECK (CASE WHEN (rcs_type = 1) THEN ((((((cvs_root IS NOT NULL) AND (cvs_root <> ''::text)) AND (cvs_module IS NOT NULL)) AND (cvs_module <> ''::text)) AND (svn_branch_url IS NULL)) AND (git_repo_url IS NULL)) WHEN ((rcs_type = 2) OR (rcs_type = 3)) THEN (((((cvs_root IS NULL) AND (cvs_module IS NULL)) AND (svn_branch_url IS NOT NULL)) AND valid_absolute_url(svn_branch_url)) AND (git_repo_url IS NULL)) WHEN (rcs_type = 4) THEN ((((cvs_root IS NULL) AND (cvs_module IS NULL)) AND (svn_branch_url IS NULL)) AND (git_repo_url IS NOT NULL)) ELSE false END)
1236 );
1237
1238+CREATE SEQUENCE codeimport_id_seq
1239+ INCREMENT BY 1
1240+ NO MAXVALUE
1241+ NO MINVALUE
1242+ CACHE 1;
1243+
1244+ALTER SEQUENCE codeimport_id_seq OWNED BY codeimport.id;
1245+
1246 CREATE TABLE codeimportevent (
1247 id integer NOT NULL,
1248 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
1249@@ -856,6 +1354,14 @@
1250 machine integer
1251 );
1252
1253+CREATE SEQUENCE codeimportevent_id_seq
1254+ INCREMENT BY 1
1255+ NO MAXVALUE
1256+ NO MINVALUE
1257+ CACHE 1;
1258+
1259+ALTER SEQUENCE codeimportevent_id_seq OWNED BY codeimportevent.id;
1260+
1261 CREATE TABLE codeimporteventdata (
1262 id integer NOT NULL,
1263 event integer,
1264@@ -863,6 +1369,14 @@
1265 data_value text
1266 );
1267
1268+CREATE SEQUENCE codeimporteventdata_id_seq
1269+ INCREMENT BY 1
1270+ NO MAXVALUE
1271+ NO MINVALUE
1272+ CACHE 1;
1273+
1274+ALTER SEQUENCE codeimporteventdata_id_seq OWNED BY codeimporteventdata.id;
1275+
1276 CREATE TABLE codeimportjob (
1277 id integer NOT NULL,
1278 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
1279@@ -878,6 +1392,14 @@
1280 CONSTRAINT valid_state CHECK (CASE WHEN (state = 10) THEN (((((machine IS NULL) AND (ordering IS NULL)) AND (heartbeat IS NULL)) AND (date_started IS NULL)) AND (logtail IS NULL)) WHEN (state = 20) THEN (((((machine IS NOT NULL) AND (ordering IS NOT NULL)) AND (heartbeat IS NULL)) AND (date_started IS NULL)) AND (logtail IS NULL)) WHEN (state = 30) THEN (((((machine IS NOT NULL) AND (ordering IS NULL)) AND (heartbeat IS NOT NULL)) AND (date_started IS NOT NULL)) AND (logtail IS NOT NULL)) ELSE false END)
1281 );
1282
1283+CREATE SEQUENCE codeimportjob_id_seq
1284+ INCREMENT BY 1
1285+ NO MAXVALUE
1286+ NO MINVALUE
1287+ CACHE 1;
1288+
1289+ALTER SEQUENCE codeimportjob_id_seq OWNED BY codeimportjob.id;
1290+
1291 CREATE TABLE codeimportmachine (
1292 id integer NOT NULL,
1293 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
1294@@ -886,6 +1408,14 @@
1295 heartbeat timestamp without time zone
1296 );
1297
1298+CREATE SEQUENCE codeimportmachine_id_seq
1299+ INCREMENT BY 1
1300+ NO MAXVALUE
1301+ NO MINVALUE
1302+ CACHE 1;
1303+
1304+ALTER SEQUENCE codeimportmachine_id_seq OWNED BY codeimportmachine.id;
1305+
1306 CREATE TABLE codeimportresult (
1307 id integer NOT NULL,
1308 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
1309@@ -898,6 +1428,14 @@
1310 date_job_started timestamp without time zone
1311 );
1312
1313+CREATE SEQUENCE codeimportresult_id_seq
1314+ INCREMENT BY 1
1315+ NO MAXVALUE
1316+ NO MINVALUE
1317+ CACHE 1;
1318+
1319+ALTER SEQUENCE codeimportresult_id_seq OWNED BY codeimportresult.id;
1320+
1321 CREATE TABLE codereviewmessage (
1322 id integer NOT NULL,
1323 branch_merge_proposal integer NOT NULL,
1324@@ -906,6 +1444,14 @@
1325 vote_tag text
1326 );
1327
1328+CREATE SEQUENCE codereviewmessage_id_seq
1329+ INCREMENT BY 1
1330+ NO MAXVALUE
1331+ NO MINVALUE
1332+ CACHE 1;
1333+
1334+ALTER SEQUENCE codereviewmessage_id_seq OWNED BY codereviewmessage.id;
1335+
1336 CREATE TABLE codereviewvote (
1337 id integer NOT NULL,
1338 branch_merge_proposal integer NOT NULL,
1339@@ -916,6 +1462,14 @@
1340 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
1341 );
1342
1343+CREATE SEQUENCE codereviewvote_id_seq
1344+ INCREMENT BY 1
1345+ NO MAXVALUE
1346+ NO MINVALUE
1347+ CACHE 1;
1348+
1349+ALTER SEQUENCE codereviewvote_id_seq OWNED BY codereviewvote.id;
1350+
1351 CREATE TABLE commercialsubscription (
1352 id integer NOT NULL,
1353 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
1354@@ -930,6 +1484,22 @@
1355 sales_system_id text
1356 );
1357
1358+CREATE SEQUENCE commercialsubscription_id_seq
1359+ INCREMENT BY 1
1360+ NO MAXVALUE
1361+ NO MINVALUE
1362+ CACHE 1;
1363+
1364+ALTER SEQUENCE commercialsubscription_id_seq OWNED BY commercialsubscription.id;
1365+
1366+CREATE SEQUENCE component_id_seq
1367+ INCREMENT BY 1
1368+ NO MAXVALUE
1369+ NO MINVALUE
1370+ CACHE 1;
1371+
1372+ALTER SEQUENCE component_id_seq OWNED BY component.id;
1373+
1374 CREATE TABLE componentselection (
1375 id integer NOT NULL,
1376 distroseries integer NOT NULL,
1377@@ -937,12 +1507,28 @@
1378 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
1379 );
1380
1381+CREATE SEQUENCE componentselection_id_seq
1382+ INCREMENT BY 1
1383+ NO MAXVALUE
1384+ NO MINVALUE
1385+ CACHE 1;
1386+
1387+ALTER SEQUENCE componentselection_id_seq OWNED BY componentselection.id;
1388+
1389 CREATE TABLE continent (
1390 id integer NOT NULL,
1391 code text NOT NULL,
1392 name text NOT NULL
1393 );
1394
1395+CREATE SEQUENCE continent_id_seq
1396+ INCREMENT BY 1
1397+ NO MAXVALUE
1398+ NO MINVALUE
1399+ CACHE 1;
1400+
1401+ALTER SEQUENCE continent_id_seq OWNED BY continent.id;
1402+
1403 CREATE TABLE country (
1404 id integer NOT NULL,
1405 iso3166code2 character(2) NOT NULL,
1406@@ -953,6 +1539,14 @@
1407 continent integer NOT NULL
1408 );
1409
1410+CREATE SEQUENCE country_id_seq
1411+ INCREMENT BY 1
1412+ NO MAXVALUE
1413+ NO MINVALUE
1414+ CACHE 1;
1415+
1416+ALTER SEQUENCE country_id_seq OWNED BY country.id;
1417+
1418 CREATE TABLE customlanguagecode (
1419 id integer NOT NULL,
1420 product integer,
1421@@ -964,6 +1558,14 @@
1422 CONSTRAINT product_or_distro CHECK (((product IS NULL) <> (distribution IS NULL)))
1423 );
1424
1425+CREATE SEQUENCE customlanguagecode_id_seq
1426+ INCREMENT BY 1
1427+ NO MAXVALUE
1428+ NO MINVALUE
1429+ CACHE 1;
1430+
1431+ALTER SEQUENCE customlanguagecode_id_seq OWNED BY customlanguagecode.id;
1432+
1433 CREATE TABLE cve (
1434 id integer NOT NULL,
1435 sequence text NOT NULL,
1436@@ -975,6 +1577,14 @@
1437 CONSTRAINT valid_cve_ref CHECK (valid_cve(sequence))
1438 );
1439
1440+CREATE SEQUENCE cve_id_seq
1441+ INCREMENT BY 1
1442+ NO MAXVALUE
1443+ NO MINVALUE
1444+ CACHE 1;
1445+
1446+ALTER SEQUENCE cve_id_seq OWNED BY cve.id;
1447+
1448 CREATE TABLE cvereference (
1449 id integer NOT NULL,
1450 cve integer NOT NULL,
1451@@ -984,6 +1594,31 @@
1452 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
1453 );
1454
1455+CREATE SEQUENCE cvereference_id_seq
1456+ INCREMENT BY 1
1457+ NO MAXVALUE
1458+ NO MINVALUE
1459+ CACHE 1;
1460+
1461+ALTER SEQUENCE cvereference_id_seq OWNED BY cvereference.id;
1462+
1463+CREATE TABLE diff (
1464+ id integer NOT NULL,
1465+ diff_text integer,
1466+ diff_lines_count integer,
1467+ diffstat text,
1468+ added_lines_count integer,
1469+ removed_lines_count integer
1470+);
1471+
1472+CREATE SEQUENCE diff_id_seq
1473+ INCREMENT BY 1
1474+ NO MAXVALUE
1475+ NO MINVALUE
1476+ CACHE 1;
1477+
1478+ALTER SEQUENCE diff_id_seq OWNED BY diff.id;
1479+
1480 CREATE TABLE distribution (
1481 id integer NOT NULL,
1482 name text NOT NULL,
1483@@ -1022,6 +1657,14 @@
1484 CONSTRAINT valid_name CHECK (valid_name(name))
1485 );
1486
1487+CREATE SEQUENCE distribution_id_seq
1488+ INCREMENT BY 1
1489+ NO MAXVALUE
1490+ NO MINVALUE
1491+ CACHE 1;
1492+
1493+ALTER SEQUENCE distribution_id_seq OWNED BY distribution.id;
1494+
1495 CREATE TABLE distributionbounty (
1496 id integer NOT NULL,
1497 bounty integer NOT NULL,
1498@@ -1029,6 +1672,14 @@
1499 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
1500 );
1501
1502+CREATE SEQUENCE distributionbounty_id_seq
1503+ INCREMENT BY 1
1504+ NO MAXVALUE
1505+ NO MINVALUE
1506+ CACHE 1;
1507+
1508+ALTER SEQUENCE distributionbounty_id_seq OWNED BY distributionbounty.id;
1509+
1510 CREATE TABLE distributionmirror (
1511 id integer NOT NULL,
1512 distribution integer NOT NULL,
1513@@ -1056,6 +1707,14 @@
1514 CONSTRAINT valid_rsync_base_url CHECK (valid_absolute_url(rsync_base_url))
1515 );
1516
1517+CREATE SEQUENCE distributionmirror_id_seq
1518+ INCREMENT BY 1
1519+ NO MAXVALUE
1520+ NO MINVALUE
1521+ CACHE 1;
1522+
1523+ALTER SEQUENCE distributionmirror_id_seq OWNED BY distributionmirror.id;
1524+
1525 CREATE TABLE distributionsourcepackage (
1526 id integer NOT NULL,
1527 distribution integer NOT NULL,
1528@@ -1063,6 +1722,14 @@
1529 bug_reporting_guidelines text
1530 );
1531
1532+CREATE SEQUENCE distributionsourcepackage_id_seq
1533+ INCREMENT BY 1
1534+ NO MAXVALUE
1535+ NO MINVALUE
1536+ CACHE 1;
1537+
1538+ALTER SEQUENCE distributionsourcepackage_id_seq OWNED BY distributionsourcepackage.id;
1539+
1540 CREATE TABLE distributionsourcepackagecache (
1541 id integer NOT NULL,
1542 distribution integer NOT NULL,
1543@@ -1076,6 +1743,22 @@
1544 archive integer NOT NULL
1545 );
1546
1547+CREATE SEQUENCE distributionsourcepackagecache_id_seq
1548+ INCREMENT BY 1
1549+ NO MAXVALUE
1550+ NO MINVALUE
1551+ CACHE 1;
1552+
1553+ALTER SEQUENCE distributionsourcepackagecache_id_seq OWNED BY distributionsourcepackagecache.id;
1554+
1555+CREATE SEQUENCE distroarchseries_id_seq
1556+ INCREMENT BY 1
1557+ NO MAXVALUE
1558+ NO MINVALUE
1559+ CACHE 1;
1560+
1561+ALTER SEQUENCE distroarchseries_id_seq OWNED BY distroarchseries.id;
1562+
1563 CREATE TABLE distrocomponentuploader (
1564 id integer NOT NULL,
1565 distribution integer NOT NULL,
1566@@ -1084,6 +1767,22 @@
1567 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
1568 );
1569
1570+CREATE SEQUENCE distrocomponentuploader_id_seq
1571+ INCREMENT BY 1
1572+ NO MAXVALUE
1573+ NO MINVALUE
1574+ CACHE 1;
1575+
1576+ALTER SEQUENCE distrocomponentuploader_id_seq OWNED BY distrocomponentuploader.id;
1577+
1578+CREATE SEQUENCE distroseries_id_seq
1579+ INCREMENT BY 1
1580+ NO MAXVALUE
1581+ NO MINVALUE
1582+ CACHE 1;
1583+
1584+ALTER SEQUENCE distroseries_id_seq OWNED BY distroseries.id;
1585+
1586 CREATE TABLE distroserieslanguage (
1587 id integer NOT NULL,
1588 distroseries integer,
1589@@ -1096,6 +1795,14 @@
1590 unreviewed_count integer DEFAULT 0 NOT NULL
1591 );
1592
1593+CREATE SEQUENCE distroserieslanguage_id_seq
1594+ INCREMENT BY 1
1595+ NO MAXVALUE
1596+ NO MINVALUE
1597+ CACHE 1;
1598+
1599+ALTER SEQUENCE distroserieslanguage_id_seq OWNED BY distroserieslanguage.id;
1600+
1601 CREATE TABLE distroseriespackagecache (
1602 id integer NOT NULL,
1603 distroseries integer NOT NULL,
1604@@ -1109,6 +1816,14 @@
1605 archive integer NOT NULL
1606 );
1607
1608+CREATE SEQUENCE distroseriespackagecache_id_seq
1609+ INCREMENT BY 1
1610+ NO MAXVALUE
1611+ NO MINVALUE
1612+ CACHE 1;
1613+
1614+ALTER SEQUENCE distroseriespackagecache_id_seq OWNED BY distroseriespackagecache.id;
1615+
1616 CREATE TABLE emailaddress (
1617 id integer NOT NULL,
1618 email text NOT NULL,
1619@@ -1119,6 +1834,14 @@
1620 CONSTRAINT emailaddress__is_linked__chk CHECK (((person IS NOT NULL) OR (account IS NOT NULL)))
1621 );
1622
1623+CREATE SEQUENCE emailaddress_id_seq
1624+ INCREMENT BY 1
1625+ NO MAXVALUE
1626+ NO MINVALUE
1627+ CACHE 1;
1628+
1629+ALTER SEQUENCE emailaddress_id_seq OWNED BY emailaddress.id;
1630+
1631 CREATE TABLE entitlement (
1632 id integer NOT NULL,
1633 person integer,
1634@@ -1140,6 +1863,17 @@
1635 CONSTRAINT only_one_target CHECK ((null_count(ARRAY[person, product, project, distribution]) = 3))
1636 );
1637
1638+CREATE SEQUENCE entitlement_id_seq
1639+ INCREMENT BY 1
1640+ NO MAXVALUE
1641+ NO MINVALUE
1642+ CACHE 1;
1643+
1644+ALTER SEQUENCE entitlement_id_seq OWNED BY entitlement.id;
1645+
1646+CREATE VIEW exclusivelocks AS
1647+ SELECT alllocks.procpid, alllocks.usename, alllocks.age, alllocks.relname, alllocks.mode, alllocks.granted, alllocks.current_query FROM alllocks WHERE (alllocks.mode !~~ '%Share%'::text);
1648+
1649 CREATE TABLE faq (
1650 id integer NOT NULL,
1651 title text NOT NULL,
1652@@ -1155,17 +1889,56 @@
1653 CONSTRAINT product_or_distro CHECK (((product IS NULL) <> (distribution IS NULL)))
1654 );
1655
1656+CREATE SEQUENCE faq_id_seq
1657+ INCREMENT BY 1
1658+ NO MAXVALUE
1659+ NO MINVALUE
1660+ CACHE 1;
1661+
1662+ALTER SEQUENCE faq_id_seq OWNED BY faq.id;
1663+
1664 CREATE TABLE featuredproject (
1665 id integer NOT NULL,
1666 pillar_name integer NOT NULL
1667 );
1668
1669+CREATE SEQUENCE featuredproject_id_seq
1670+ INCREMENT BY 1
1671+ NO MAXVALUE
1672+ NO MINVALUE
1673+ CACHE 1;
1674+
1675+ALTER SEQUENCE featuredproject_id_seq OWNED BY featuredproject.id;
1676+
1677+CREATE TABLE flatpackagesetinclusion (
1678+ id integer NOT NULL,
1679+ parent integer NOT NULL,
1680+ child integer NOT NULL
1681+);
1682+
1683+CREATE SEQUENCE flatpackagesetinclusion_id_seq
1684+ START WITH 1
1685+ INCREMENT BY 1
1686+ NO MAXVALUE
1687+ NO MINVALUE
1688+ CACHE 1;
1689+
1690+ALTER SEQUENCE flatpackagesetinclusion_id_seq OWNED BY flatpackagesetinclusion.id;
1691+
1692 CREATE TABLE fticache (
1693 id integer NOT NULL,
1694 tablename text NOT NULL,
1695 columns text NOT NULL
1696 );
1697
1698+CREATE SEQUENCE fticache_id_seq
1699+ INCREMENT BY 1
1700+ NO MAXVALUE
1701+ NO MINVALUE
1702+ CACHE 1;
1703+
1704+ALTER SEQUENCE fticache_id_seq OWNED BY fticache.id;
1705+
1706 CREATE TABLE gpgkey (
1707 id integer NOT NULL,
1708 owner integer NOT NULL,
1709@@ -1180,6 +1953,14 @@
1710 CONSTRAINT valid_keyid CHECK (valid_keyid(keyid))
1711 );
1712
1713+CREATE SEQUENCE gpgkey_id_seq
1714+ INCREMENT BY 1
1715+ NO MAXVALUE
1716+ NO MINVALUE
1717+ CACHE 1;
1718+
1719+ALTER SEQUENCE gpgkey_id_seq OWNED BY gpgkey.id;
1720+
1721 CREATE TABLE hwdevice (
1722 id integer NOT NULL,
1723 bus_vendor_id integer NOT NULL,
1724@@ -1189,6 +1970,14 @@
1725 submissions integer NOT NULL
1726 );
1727
1728+CREATE SEQUENCE hwdevice_id_seq
1729+ INCREMENT BY 1
1730+ NO MAXVALUE
1731+ NO MINVALUE
1732+ CACHE 1;
1733+
1734+ALTER SEQUENCE hwdevice_id_seq OWNED BY hwdevice.id;
1735+
1736 CREATE TABLE hwdeviceclass (
1737 id integer NOT NULL,
1738 device integer NOT NULL,
1739@@ -1196,12 +1985,28 @@
1740 sub_class integer
1741 );
1742
1743+CREATE SEQUENCE hwdeviceclass_id_seq
1744+ INCREMENT BY 1
1745+ NO MAXVALUE
1746+ NO MINVALUE
1747+ CACHE 1;
1748+
1749+ALTER SEQUENCE hwdeviceclass_id_seq OWNED BY hwdeviceclass.id;
1750+
1751 CREATE TABLE hwdevicedriverlink (
1752 id integer NOT NULL,
1753 device integer NOT NULL,
1754 driver integer
1755 );
1756
1757+CREATE SEQUENCE hwdevicedriverlink_id_seq
1758+ INCREMENT BY 1
1759+ NO MAXVALUE
1760+ NO MINVALUE
1761+ CACHE 1;
1762+
1763+ALTER SEQUENCE hwdevicedriverlink_id_seq OWNED BY hwdevicedriverlink.id;
1764+
1765 CREATE TABLE hwdevicenamevariant (
1766 id integer NOT NULL,
1767 vendor_name integer NOT NULL,
1768@@ -1210,6 +2015,44 @@
1769 submissions integer NOT NULL
1770 );
1771
1772+CREATE SEQUENCE hwdevicenamevariant_id_seq
1773+ INCREMENT BY 1
1774+ NO MAXVALUE
1775+ NO MINVALUE
1776+ CACHE 1;
1777+
1778+ALTER SEQUENCE hwdevicenamevariant_id_seq OWNED BY hwdevicenamevariant.id;
1779+
1780+CREATE TABLE hwdmihandle (
1781+ id integer NOT NULL,
1782+ handle integer NOT NULL,
1783+ type integer NOT NULL,
1784+ submission integer
1785+);
1786+
1787+CREATE SEQUENCE hwdmihandle_id_seq
1788+ INCREMENT BY 1
1789+ NO MAXVALUE
1790+ NO MINVALUE
1791+ CACHE 1;
1792+
1793+ALTER SEQUENCE hwdmihandle_id_seq OWNED BY hwdmihandle.id;
1794+
1795+CREATE TABLE hwdmivalue (
1796+ id integer NOT NULL,
1797+ key text,
1798+ value text,
1799+ handle integer NOT NULL
1800+);
1801+
1802+CREATE SEQUENCE hwdmivalue_id_seq
1803+ INCREMENT BY 1
1804+ NO MAXVALUE
1805+ NO MINVALUE
1806+ CACHE 1;
1807+
1808+ALTER SEQUENCE hwdmivalue_id_seq OWNED BY hwdmivalue.id;
1809+
1810 CREATE TABLE hwdriver (
1811 id integer NOT NULL,
1812 package_name text,
1813@@ -1217,6 +2060,20 @@
1814 license integer
1815 );
1816
1817+CREATE SEQUENCE hwdriver_id_seq
1818+ INCREMENT BY 1
1819+ NO MAXVALUE
1820+ NO MINVALUE
1821+ CACHE 1;
1822+
1823+ALTER SEQUENCE hwdriver_id_seq OWNED BY hwdriver.id;
1824+
1825+CREATE VIEW hwdrivernames AS
1826+ SELECT DISTINCT ON (hwdriver.name) hwdriver.id, hwdriver.name FROM hwdriver ORDER BY hwdriver.name, hwdriver.id;
1827+
1828+CREATE VIEW hwdriverpackagenames AS
1829+ SELECT DISTINCT ON (hwdriver.package_name) hwdriver.id, hwdriver.package_name FROM hwdriver ORDER BY hwdriver.package_name, hwdriver.id;
1830+
1831 CREATE TABLE hwsubmission (
1832 id integer NOT NULL,
1833 date_created timestamp without time zone NOT NULL,
1834@@ -1233,12 +2090,28 @@
1835 raw_emailaddress text
1836 );
1837
1838+CREATE SEQUENCE hwsubmission_id_seq
1839+ INCREMENT BY 1
1840+ NO MAXVALUE
1841+ NO MINVALUE
1842+ CACHE 1;
1843+
1844+ALTER SEQUENCE hwsubmission_id_seq OWNED BY hwsubmission.id;
1845+
1846 CREATE TABLE hwsubmissionbug (
1847 id integer NOT NULL,
1848 submission integer NOT NULL,
1849 bug integer NOT NULL
1850 );
1851
1852+CREATE SEQUENCE hwsubmissionbug_id_seq
1853+ INCREMENT BY 1
1854+ NO MAXVALUE
1855+ NO MINVALUE
1856+ CACHE 1;
1857+
1858+ALTER SEQUENCE hwsubmissionbug_id_seq OWNED BY hwsubmissionbug.id;
1859+
1860 CREATE TABLE hwsubmissiondevice (
1861 id integer NOT NULL,
1862 device_driver_link integer NOT NULL,
1863@@ -1247,11 +2120,27 @@
1864 hal_device_id integer NOT NULL
1865 );
1866
1867+CREATE SEQUENCE hwsubmissiondevice_id_seq
1868+ INCREMENT BY 1
1869+ NO MAXVALUE
1870+ NO MINVALUE
1871+ CACHE 1;
1872+
1873+ALTER SEQUENCE hwsubmissiondevice_id_seq OWNED BY hwsubmissiondevice.id;
1874+
1875 CREATE TABLE hwsystemfingerprint (
1876 id integer NOT NULL,
1877 fingerprint text NOT NULL
1878 );
1879
1880+CREATE SEQUENCE hwsystemfingerprint_id_seq
1881+ INCREMENT BY 1
1882+ NO MAXVALUE
1883+ NO MINVALUE
1884+ CACHE 1;
1885+
1886+ALTER SEQUENCE hwsystemfingerprint_id_seq OWNED BY hwsystemfingerprint.id;
1887+
1888 CREATE TABLE hwtest (
1889 id integer NOT NULL,
1890 namespace text,
1891@@ -1259,6 +2148,14 @@
1892 version text NOT NULL
1893 );
1894
1895+CREATE SEQUENCE hwtest_id_seq
1896+ INCREMENT BY 1
1897+ NO MAXVALUE
1898+ NO MINVALUE
1899+ CACHE 1;
1900+
1901+ALTER SEQUENCE hwtest_id_seq OWNED BY hwtest.id;
1902+
1903 CREATE TABLE hwtestanswer (
1904 id integer NOT NULL,
1905 test integer NOT NULL,
1906@@ -1272,12 +2169,28 @@
1907 CONSTRAINT hwtestanswer_check CHECK (((((choice IS NULL) AND (unit IS NOT NULL)) AND ((intval IS NULL) <> (floatval IS NULL))) OR ((((choice IS NOT NULL) AND (unit IS NULL)) AND (intval IS NULL)) AND (floatval IS NULL))))
1908 );
1909
1910+CREATE SEQUENCE hwtestanswer_id_seq
1911+ INCREMENT BY 1
1912+ NO MAXVALUE
1913+ NO MINVALUE
1914+ CACHE 1;
1915+
1916+ALTER SEQUENCE hwtestanswer_id_seq OWNED BY hwtestanswer.id;
1917+
1918 CREATE TABLE hwtestanswerchoice (
1919 id integer NOT NULL,
1920 choice text NOT NULL,
1921 test integer NOT NULL
1922 );
1923
1924+CREATE SEQUENCE hwtestanswerchoice_id_seq
1925+ INCREMENT BY 1
1926+ NO MAXVALUE
1927+ NO MINVALUE
1928+ CACHE 1;
1929+
1930+ALTER SEQUENCE hwtestanswerchoice_id_seq OWNED BY hwtestanswerchoice.id;
1931+
1932 CREATE TABLE hwtestanswercount (
1933 id integer NOT NULL,
1934 test integer NOT NULL,
1935@@ -1290,18 +2203,42 @@
1936 CONSTRAINT hwtestanswercount_check CHECK ((((((choice IS NULL) AND (average IS NOT NULL)) AND (sum_square IS NOT NULL)) AND (unit IS NOT NULL)) OR ((((choice IS NOT NULL) AND (average IS NULL)) AND (sum_square IS NULL)) AND (unit IS NULL))))
1937 );
1938
1939+CREATE SEQUENCE hwtestanswercount_id_seq
1940+ INCREMENT BY 1
1941+ NO MAXVALUE
1942+ NO MINVALUE
1943+ CACHE 1;
1944+
1945+ALTER SEQUENCE hwtestanswercount_id_seq OWNED BY hwtestanswercount.id;
1946+
1947 CREATE TABLE hwtestanswercountdevice (
1948 id integer NOT NULL,
1949 answer integer NOT NULL,
1950 device_driver integer NOT NULL
1951 );
1952
1953+CREATE SEQUENCE hwtestanswercountdevice_id_seq
1954+ INCREMENT BY 1
1955+ NO MAXVALUE
1956+ NO MINVALUE
1957+ CACHE 1;
1958+
1959+ALTER SEQUENCE hwtestanswercountdevice_id_seq OWNED BY hwtestanswercountdevice.id;
1960+
1961 CREATE TABLE hwtestanswerdevice (
1962 id integer NOT NULL,
1963 answer integer NOT NULL,
1964 device_driver integer NOT NULL
1965 );
1966
1967+CREATE SEQUENCE hwtestanswerdevice_id_seq
1968+ INCREMENT BY 1
1969+ NO MAXVALUE
1970+ NO MINVALUE
1971+ CACHE 1;
1972+
1973+ALTER SEQUENCE hwtestanswerdevice_id_seq OWNED BY hwtestanswerdevice.id;
1974+
1975 CREATE TABLE hwvendorid (
1976 id integer NOT NULL,
1977 bus integer NOT NULL,
1978@@ -1309,11 +2246,27 @@
1979 vendor_name integer NOT NULL
1980 );
1981
1982+CREATE SEQUENCE hwvendorid_id_seq
1983+ INCREMENT BY 1
1984+ NO MAXVALUE
1985+ NO MINVALUE
1986+ CACHE 1;
1987+
1988+ALTER SEQUENCE hwvendorid_id_seq OWNED BY hwvendorid.id;
1989+
1990 CREATE TABLE hwvendorname (
1991 id integer NOT NULL,
1992 name text NOT NULL
1993 );
1994
1995+CREATE SEQUENCE hwvendorname_id_seq
1996+ INCREMENT BY 1
1997+ NO MAXVALUE
1998+ NO MINVALUE
1999+ CACHE 1;
2000+
2001+ALTER SEQUENCE hwvendorname_id_seq OWNED BY hwvendorname.id;
2002+
2003 CREATE TABLE ircid (
2004 id integer NOT NULL,
2005 person integer NOT NULL,
2006@@ -1321,12 +2274,54 @@
2007 nickname text NOT NULL
2008 );
2009
2010+CREATE SEQUENCE ircid_id_seq
2011+ INCREMENT BY 1
2012+ NO MAXVALUE
2013+ NO MINVALUE
2014+ CACHE 1;
2015+
2016+ALTER SEQUENCE ircid_id_seq OWNED BY ircid.id;
2017+
2018 CREATE TABLE jabberid (
2019 id integer NOT NULL,
2020 person integer NOT NULL,
2021 jabberid text NOT NULL
2022 );
2023
2024+CREATE SEQUENCE jabberid_id_seq
2025+ INCREMENT BY 1
2026+ NO MAXVALUE
2027+ NO MINVALUE
2028+ CACHE 1;
2029+
2030+ALTER SEQUENCE jabberid_id_seq OWNED BY jabberid.id;
2031+
2032+CREATE TABLE job (
2033+ id integer NOT NULL,
2034+ requester integer,
2035+ reason text,
2036+ status integer NOT NULL,
2037+ progress integer,
2038+ last_report_seen timestamp without time zone,
2039+ next_report_due timestamp without time zone,
2040+ attempt_count integer DEFAULT 0 NOT NULL,
2041+ max_retries integer DEFAULT 0 NOT NULL,
2042+ log text,
2043+ scheduled_start timestamp without time zone,
2044+ lease_expires timestamp without time zone,
2045+ date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
2046+ date_started timestamp without time zone,
2047+ date_finished timestamp without time zone
2048+);
2049+
2050+CREATE SEQUENCE job_id_seq
2051+ INCREMENT BY 1
2052+ NO MAXVALUE
2053+ NO MINVALUE
2054+ CACHE 1;
2055+
2056+ALTER SEQUENCE job_id_seq OWNED BY job.id;
2057+
2058 CREATE TABLE karma (
2059 id integer NOT NULL,
2060 datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
2061@@ -1337,6 +2332,14 @@
2062 sourcepackagename integer
2063 );
2064
2065+CREATE SEQUENCE karma_id_seq
2066+ INCREMENT BY 1
2067+ NO MAXVALUE
2068+ NO MINVALUE
2069+ CACHE 1;
2070+
2071+ALTER SEQUENCE karma_id_seq OWNED BY karma.id;
2072+
2073 CREATE TABLE karmaaction (
2074 id integer NOT NULL,
2075 category integer,
2076@@ -1346,6 +2349,14 @@
2077 summary text NOT NULL
2078 );
2079
2080+CREATE SEQUENCE karmaaction_id_seq
2081+ INCREMENT BY 1
2082+ NO MAXVALUE
2083+ NO MINVALUE
2084+ CACHE 1;
2085+
2086+ALTER SEQUENCE karmaaction_id_seq OWNED BY karmaaction.id;
2087+
2088 CREATE TABLE karmacache (
2089 id integer NOT NULL,
2090 person integer NOT NULL,
2091@@ -1361,6 +2372,14 @@
2092 CONSTRAINT sourcepackagename_requires_distribution CHECK (((sourcepackagename IS NULL) OR (distribution IS NOT NULL)))
2093 );
2094
2095+CREATE SEQUENCE karmacache_id_seq
2096+ INCREMENT BY 1
2097+ NO MAXVALUE
2098+ NO MINVALUE
2099+ CACHE 1;
2100+
2101+ALTER SEQUENCE karmacache_id_seq OWNED BY karmacache.id;
2102+
2103 CREATE TABLE karmacategory (
2104 id integer NOT NULL,
2105 name text NOT NULL,
2106@@ -1368,12 +2387,28 @@
2107 summary text NOT NULL
2108 );
2109
2110+CREATE SEQUENCE karmacategory_id_seq
2111+ INCREMENT BY 1
2112+ NO MAXVALUE
2113+ NO MINVALUE
2114+ CACHE 1;
2115+
2116+ALTER SEQUENCE karmacategory_id_seq OWNED BY karmacategory.id;
2117+
2118 CREATE TABLE karmatotalcache (
2119 id integer NOT NULL,
2120 person integer NOT NULL,
2121 karma_total integer NOT NULL
2122 );
2123
2124+CREATE SEQUENCE karmatotalcache_id_seq
2125+ INCREMENT BY 1
2126+ NO MAXVALUE
2127+ NO MINVALUE
2128+ CACHE 1;
2129+
2130+ALTER SEQUENCE karmatotalcache_id_seq OWNED BY karmatotalcache.id;
2131+
2132 CREATE TABLE language (
2133 id integer NOT NULL,
2134 code text NOT NULL,
2135@@ -1387,6 +2422,14 @@
2136 CONSTRAINT valid_language CHECK (((pluralforms IS NULL) = (pluralexpression IS NULL)))
2137 );
2138
2139+CREATE SEQUENCE language_id_seq
2140+ INCREMENT BY 1
2141+ NO MAXVALUE
2142+ NO MINVALUE
2143+ CACHE 1;
2144+
2145+ALTER SEQUENCE language_id_seq OWNED BY language.id;
2146+
2147 CREATE TABLE languagepack (
2148 id integer NOT NULL,
2149 file integer NOT NULL,
2150@@ -1398,6 +2441,14 @@
2151 CONSTRAINT valid_updates CHECK ((((type = 2) AND (updates IS NOT NULL)) OR ((type = 1) AND (updates IS NULL))))
2152 );
2153
2154+CREATE SEQUENCE languagepack_id_seq
2155+ INCREMENT BY 1
2156+ NO MAXVALUE
2157+ NO MINVALUE
2158+ CACHE 1;
2159+
2160+ALTER SEQUENCE languagepack_id_seq OWNED BY languagepack.id;
2161+
2162 CREATE TABLE launchpaddatabaserevision (
2163 major integer NOT NULL,
2164 minor integer NOT NULL,
2165@@ -1411,6 +2462,22 @@
2166 dateupdated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL
2167 );
2168
2169+CREATE SEQUENCE launchpadstatistic_id_seq
2170+ INCREMENT BY 1
2171+ NO MAXVALUE
2172+ NO MINVALUE
2173+ CACHE 1;
2174+
2175+ALTER SEQUENCE launchpadstatistic_id_seq OWNED BY launchpadstatistic.id;
2176+
2177+CREATE SEQUENCE libraryfilealias_id_seq
2178+ INCREMENT BY 1
2179+ NO MAXVALUE
2180+ NO MINVALUE
2181+ CACHE 1;
2182+
2183+ALTER SEQUENCE libraryfilealias_id_seq OWNED BY libraryfilealias.id;
2184+
2185 CREATE TABLE libraryfilecontent (
2186 id integer NOT NULL,
2187 datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
2188@@ -1418,8 +2485,33 @@
2189 filesize integer NOT NULL,
2190 sha1 character(40) NOT NULL,
2191 deleted boolean DEFAULT false NOT NULL,
2192- md5 character(32) NOT NULL
2193-);
2194+ md5 character(32) NOT NULL,
2195+ sha256 character(64)
2196+);
2197+
2198+CREATE SEQUENCE libraryfilecontent_id_seq
2199+ INCREMENT BY 1
2200+ NO MAXVALUE
2201+ NO MINVALUE
2202+ CACHE 1;
2203+
2204+ALTER SEQUENCE libraryfilecontent_id_seq OWNED BY libraryfilecontent.id;
2205+
2206+CREATE TABLE libraryfiledownloadcount (
2207+ id integer NOT NULL,
2208+ libraryfilealias integer NOT NULL,
2209+ day date NOT NULL,
2210+ count integer NOT NULL,
2211+ country integer
2212+);
2213+
2214+CREATE SEQUENCE libraryfiledownloadcount_id_seq
2215+ INCREMENT BY 1
2216+ NO MAXVALUE
2217+ NO MINVALUE
2218+ CACHE 1;
2219+
2220+ALTER SEQUENCE libraryfiledownloadcount_id_seq OWNED BY libraryfiledownloadcount.id;
2221
2222 CREATE TABLE logintoken (
2223 id integer NOT NULL,
2224@@ -1435,6 +2527,14 @@
2225 CONSTRAINT valid_fingerprint CHECK (((fingerprint IS NULL) OR valid_fingerprint(fingerprint)))
2226 );
2227
2228+CREATE SEQUENCE logintoken_id_seq
2229+ INCREMENT BY 1
2230+ NO MAXVALUE
2231+ NO MINVALUE
2232+ CACHE 1;
2233+
2234+ALTER SEQUENCE logintoken_id_seq OWNED BY logintoken.id;
2235+
2236 CREATE TABLE mailinglist (
2237 id integer NOT NULL,
2238 team integer NOT NULL,
2239@@ -1447,6 +2547,14 @@
2240 welcome_message text
2241 );
2242
2243+CREATE SEQUENCE mailinglist_id_seq
2244+ INCREMENT BY 1
2245+ NO MAXVALUE
2246+ NO MINVALUE
2247+ CACHE 1;
2248+
2249+ALTER SEQUENCE mailinglist_id_seq OWNED BY mailinglist.id;
2250+
2251 CREATE TABLE mailinglistban (
2252 id integer NOT NULL,
2253 person integer NOT NULL,
2254@@ -1455,6 +2563,14 @@
2255 reason text NOT NULL
2256 );
2257
2258+CREATE SEQUENCE mailinglistban_id_seq
2259+ INCREMENT BY 1
2260+ NO MAXVALUE
2261+ NO MINVALUE
2262+ CACHE 1;
2263+
2264+ALTER SEQUENCE mailinglistban_id_seq OWNED BY mailinglistban.id;
2265+
2266 CREATE TABLE mailinglistsubscription (
2267 id integer NOT NULL,
2268 person integer NOT NULL,
2269@@ -1463,6 +2579,14 @@
2270 email_address integer
2271 );
2272
2273+CREATE SEQUENCE mailinglistsubscription_id_seq
2274+ INCREMENT BY 1
2275+ NO MAXVALUE
2276+ NO MINVALUE
2277+ CACHE 1;
2278+
2279+ALTER SEQUENCE mailinglistsubscription_id_seq OWNED BY mailinglistsubscription.id;
2280+
2281 CREATE TABLE mentoringoffer (
2282 id integer NOT NULL,
2283 owner integer NOT NULL,
2284@@ -1473,6 +2597,29 @@
2285 CONSTRAINT context_required CHECK (((bug IS NULL) <> (specification IS NULL)))
2286 );
2287
2288+CREATE SEQUENCE mentoringoffer_id_seq
2289+ INCREMENT BY 1
2290+ NO MAXVALUE
2291+ NO MINVALUE
2292+ CACHE 1;
2293+
2294+ALTER SEQUENCE mentoringoffer_id_seq OWNED BY mentoringoffer.id;
2295+
2296+CREATE TABLE mergedirectivejob (
2297+ id integer NOT NULL,
2298+ job integer NOT NULL,
2299+ merge_directive integer NOT NULL,
2300+ action integer NOT NULL
2301+);
2302+
2303+CREATE SEQUENCE mergedirectivejob_id_seq
2304+ INCREMENT BY 1
2305+ NO MAXVALUE
2306+ NO MINVALUE
2307+ CACHE 1;
2308+
2309+ALTER SEQUENCE mergedirectivejob_id_seq OWNED BY mergedirectivejob.id;
2310+
2311 CREATE TABLE message (
2312 id integer NOT NULL,
2313 datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
2314@@ -1485,6 +2632,14 @@
2315 raw integer
2316 );
2317
2318+CREATE SEQUENCE message_id_seq
2319+ INCREMENT BY 1
2320+ NO MAXVALUE
2321+ NO MINVALUE
2322+ CACHE 1;
2323+
2324+ALTER SEQUENCE message_id_seq OWNED BY message.id;
2325+
2326 CREATE TABLE messageapproval (
2327 id integer NOT NULL,
2328 posted_by integer NOT NULL,
2329@@ -1498,6 +2653,14 @@
2330 message integer NOT NULL
2331 );
2332
2333+CREATE SEQUENCE messageapproval_id_seq
2334+ INCREMENT BY 1
2335+ NO MAXVALUE
2336+ NO MINVALUE
2337+ CACHE 1;
2338+
2339+ALTER SEQUENCE messageapproval_id_seq OWNED BY messageapproval.id;
2340+
2341 CREATE TABLE messagechunk (
2342 id integer NOT NULL,
2343 message integer NOT NULL,
2344@@ -1508,21 +2671,38 @@
2345 CONSTRAINT text_or_content CHECK ((((blob IS NULL) AND (content IS NULL)) OR ((blob IS NULL) <> (content IS NULL))))
2346 );
2347
2348+CREATE SEQUENCE messagechunk_id_seq
2349+ INCREMENT BY 1
2350+ NO MAXVALUE
2351+ NO MINVALUE
2352+ CACHE 1;
2353+
2354+ALTER SEQUENCE messagechunk_id_seq OWNED BY messagechunk.id;
2355+
2356 CREATE TABLE milestone (
2357 id integer NOT NULL,
2358 product integer,
2359 name text NOT NULL,
2360 distribution integer,
2361 dateexpected timestamp without time zone,
2362- visible boolean DEFAULT true NOT NULL,
2363+ active boolean DEFAULT true NOT NULL,
2364 productseries integer,
2365 distroseries integer,
2366 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
2367- description text,
2368+ summary text,
2369+ codename text,
2370 CONSTRAINT valid_name CHECK (valid_name(name)),
2371 CONSTRAINT valid_target CHECK ((NOT ((product IS NULL) AND (distribution IS NULL))))
2372 );
2373
2374+CREATE SEQUENCE milestone_id_seq
2375+ INCREMENT BY 1
2376+ NO MAXVALUE
2377+ NO MINVALUE
2378+ CACHE 1;
2379+
2380+ALTER SEQUENCE milestone_id_seq OWNED BY milestone.id;
2381+
2382 CREATE TABLE mirror (
2383 id integer NOT NULL,
2384 owner integer NOT NULL,
2385@@ -1536,6 +2716,14 @@
2386 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2387 );
2388
2389+CREATE SEQUENCE mirror_id_seq
2390+ INCREMENT BY 1
2391+ NO MAXVALUE
2392+ NO MINVALUE
2393+ CACHE 1;
2394+
2395+ALTER SEQUENCE mirror_id_seq OWNED BY mirror.id;
2396+
2397 CREATE TABLE mirrorcdimagedistroseries (
2398 id integer NOT NULL,
2399 distribution_mirror integer NOT NULL,
2400@@ -1544,6 +2732,14 @@
2401 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2402 );
2403
2404+CREATE SEQUENCE mirrorcdimagedistroseries_id_seq
2405+ INCREMENT BY 1
2406+ NO MAXVALUE
2407+ NO MINVALUE
2408+ CACHE 1;
2409+
2410+ALTER SEQUENCE mirrorcdimagedistroseries_id_seq OWNED BY mirrorcdimagedistroseries.id;
2411+
2412 CREATE TABLE mirrorcontent (
2413 id integer NOT NULL,
2414 mirror integer NOT NULL,
2415@@ -1552,6 +2748,14 @@
2416 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2417 );
2418
2419+CREATE SEQUENCE mirrorcontent_id_seq
2420+ INCREMENT BY 1
2421+ NO MAXVALUE
2422+ NO MINVALUE
2423+ CACHE 1;
2424+
2425+ALTER SEQUENCE mirrorcontent_id_seq OWNED BY mirrorcontent.id;
2426+
2427 CREATE TABLE mirrordistroarchseries (
2428 id integer NOT NULL,
2429 distribution_mirror integer NOT NULL,
2430@@ -1562,6 +2766,14 @@
2431 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2432 );
2433
2434+CREATE SEQUENCE mirrordistroarchseries_id_seq
2435+ INCREMENT BY 1
2436+ NO MAXVALUE
2437+ NO MINVALUE
2438+ CACHE 1;
2439+
2440+ALTER SEQUENCE mirrordistroarchseries_id_seq OWNED BY mirrordistroarchseries.id;
2441+
2442 CREATE TABLE mirrordistroseriessource (
2443 id integer NOT NULL,
2444 distribution_mirror integer NOT NULL,
2445@@ -1572,6 +2784,14 @@
2446 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2447 );
2448
2449+CREATE SEQUENCE mirrordistroseriessource_id_seq
2450+ INCREMENT BY 1
2451+ NO MAXVALUE
2452+ NO MINVALUE
2453+ CACHE 1;
2454+
2455+ALTER SEQUENCE mirrordistroseriessource_id_seq OWNED BY mirrordistroseriessource.id;
2456+
2457 CREATE TABLE mirrorproberecord (
2458 id integer NOT NULL,
2459 distribution_mirror integer NOT NULL,
2460@@ -1579,6 +2799,14 @@
2461 date_created timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL
2462 );
2463
2464+CREATE SEQUENCE mirrorproberecord_id_seq
2465+ INCREMENT BY 1
2466+ NO MAXVALUE
2467+ NO MINVALUE
2468+ CACHE 1;
2469+
2470+ALTER SEQUENCE mirrorproberecord_id_seq OWNED BY mirrorproberecord.id;
2471+
2472 CREATE TABLE mirrorsourcecontent (
2473 id integer NOT NULL,
2474 mirror integer NOT NULL,
2475@@ -1587,6 +2815,14 @@
2476 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2477 );
2478
2479+CREATE SEQUENCE mirrorsourcecontent_id_seq
2480+ INCREMENT BY 1
2481+ NO MAXVALUE
2482+ NO MINVALUE
2483+ CACHE 1;
2484+
2485+ALTER SEQUENCE mirrorsourcecontent_id_seq OWNED BY mirrorsourcecontent.id;
2486+
2487 CREATE TABLE nameblacklist (
2488 id integer NOT NULL,
2489 regexp text NOT NULL,
2490@@ -1594,6 +2830,14 @@
2491 CONSTRAINT valid_regexp CHECK (valid_regexp(regexp))
2492 );
2493
2494+CREATE SEQUENCE nameblacklist_id_seq
2495+ INCREMENT BY 1
2496+ NO MAXVALUE
2497+ NO MINVALUE
2498+ CACHE 1;
2499+
2500+ALTER SEQUENCE nameblacklist_id_seq OWNED BY nameblacklist.id;
2501+
2502 CREATE TABLE oauthaccesstoken (
2503 id integer NOT NULL,
2504 consumer integer NOT NULL,
2505@@ -1611,6 +2855,14 @@
2506 CONSTRAINT sourcepackagename_needs_distro CHECK (((sourcepackagename IS NULL) OR (distribution IS NOT NULL)))
2507 );
2508
2509+CREATE SEQUENCE oauthaccesstoken_id_seq
2510+ INCREMENT BY 1
2511+ NO MAXVALUE
2512+ NO MINVALUE
2513+ CACHE 1;
2514+
2515+ALTER SEQUENCE oauthaccesstoken_id_seq OWNED BY oauthaccesstoken.id;
2516+
2517 CREATE TABLE oauthconsumer (
2518 id integer NOT NULL,
2519 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
2520@@ -1619,6 +2871,14 @@
2521 secret text
2522 );
2523
2524+CREATE SEQUENCE oauthconsumer_id_seq
2525+ INCREMENT BY 1
2526+ NO MAXVALUE
2527+ NO MINVALUE
2528+ CACHE 1;
2529+
2530+ALTER SEQUENCE oauthconsumer_id_seq OWNED BY oauthconsumer.id;
2531+
2532 CREATE TABLE oauthnonce (
2533 id integer NOT NULL,
2534 request_timestamp timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
2535@@ -1626,6 +2886,14 @@
2536 access_token integer NOT NULL
2537 );
2538
2539+CREATE SEQUENCE oauthnonce_id_seq
2540+ INCREMENT BY 1
2541+ NO MAXVALUE
2542+ NO MINVALUE
2543+ CACHE 1;
2544+
2545+ALTER SEQUENCE oauthnonce_id_seq OWNED BY oauthnonce.id;
2546+
2547 CREATE TABLE oauthrequesttoken (
2548 id integer NOT NULL,
2549 consumer integer NOT NULL,
2550@@ -1645,6 +2913,14 @@
2551 CONSTRAINT sourcepackagename_needs_distro CHECK (((sourcepackagename IS NULL) OR (distribution IS NOT NULL)))
2552 );
2553
2554+CREATE SEQUENCE oauthrequesttoken_id_seq
2555+ INCREMENT BY 1
2556+ NO MAXVALUE
2557+ NO MINVALUE
2558+ CACHE 1;
2559+
2560+ALTER SEQUENCE oauthrequesttoken_id_seq OWNED BY oauthrequesttoken.id;
2561+
2562 CREATE TABLE officialbugtag (
2563 id integer NOT NULL,
2564 tag text NOT NULL,
2565@@ -1654,7 +2930,15 @@
2566 CONSTRAINT context_required CHECK (((product IS NOT NULL) OR (distribution IS NOT NULL)))
2567 );
2568
2569-CREATE TABLE openidassociations (
2570+CREATE SEQUENCE officialbugtag_id_seq
2571+ INCREMENT BY 1
2572+ NO MAXVALUE
2573+ NO MINVALUE
2574+ CACHE 1;
2575+
2576+ALTER SEQUENCE officialbugtag_id_seq OWNED BY officialbugtag.id;
2577+
2578+CREATE TABLE openidassociation (
2579 server_url character varying(2047) NOT NULL,
2580 handle character varying(255) NOT NULL,
2581 secret bytea,
2582@@ -1666,13 +2950,43 @@
2583
2584 CREATE TABLE openidauthorization (
2585 id integer NOT NULL,
2586- person integer NOT NULL,
2587+ account integer NOT NULL,
2588 client_id text,
2589 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
2590 date_expires timestamp without time zone NOT NULL,
2591 trust_root text NOT NULL
2592 );
2593
2594+CREATE SEQUENCE openidauthorization_id_seq
2595+ INCREMENT BY 1
2596+ NO MAXVALUE
2597+ NO MINVALUE
2598+ CACHE 1;
2599+
2600+ALTER SEQUENCE openidauthorization_id_seq OWNED BY openidauthorization.id;
2601+
2602+CREATE TABLE openidconsumerassociation (
2603+ server_url character varying(2047) NOT NULL,
2604+ handle character varying(255) NOT NULL,
2605+ secret bytea,
2606+ issued integer,
2607+ lifetime integer,
2608+ assoc_type character varying(64),
2609+ CONSTRAINT secret_length_constraint CHECK ((length(secret) <= 128))
2610+);
2611+
2612+CREATE TABLE openidconsumernonce (
2613+ server_url character varying(2047) NOT NULL,
2614+ "timestamp" integer NOT NULL,
2615+ salt character(40) NOT NULL
2616+);
2617+
2618+CREATE TABLE openidnonce (
2619+ server_url character varying(2047) NOT NULL,
2620+ "timestamp" integer NOT NULL,
2621+ salt character(40) NOT NULL
2622+);
2623+
2624 CREATE TABLE openidrpconfig (
2625 id integer NOT NULL,
2626 trust_root text NOT NULL,
2627@@ -1680,9 +2994,19 @@
2628 description text NOT NULL,
2629 logo integer,
2630 allowed_sreg text,
2631- creation_rationale integer DEFAULT 13 NOT NULL
2632+ creation_rationale integer DEFAULT 13 NOT NULL,
2633+ can_query_any_team boolean DEFAULT false NOT NULL,
2634+ auto_authorize boolean DEFAULT false NOT NULL
2635 );
2636
2637+CREATE SEQUENCE openidrpconfig_id_seq
2638+ INCREMENT BY 1
2639+ NO MAXVALUE
2640+ NO MINVALUE
2641+ CACHE 1;
2642+
2643+ALTER SEQUENCE openidrpconfig_id_seq OWNED BY openidrpconfig.id;
2644+
2645 CREATE TABLE openidrpsummary (
2646 id integer NOT NULL,
2647 account integer NOT NULL,
2648@@ -1693,6 +3017,14 @@
2649 total_logins integer DEFAULT 1 NOT NULL
2650 );
2651
2652+CREATE SEQUENCE openidrpsummary_id_seq
2653+ INCREMENT BY 1
2654+ NO MAXVALUE
2655+ NO MINVALUE
2656+ CACHE 1;
2657+
2658+ALTER SEQUENCE openidrpsummary_id_seq OWNED BY openidrpsummary.id;
2659+
2660 CREATE TABLE packagebugsupervisor (
2661 id integer NOT NULL,
2662 distribution integer NOT NULL,
2663@@ -1701,6 +3033,14 @@
2664 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2665 );
2666
2667+CREATE SEQUENCE packagebugsupervisor_id_seq
2668+ INCREMENT BY 1
2669+ NO MAXVALUE
2670+ NO MINVALUE
2671+ CACHE 1;
2672+
2673+ALTER SEQUENCE packagebugsupervisor_id_seq OWNED BY packagebugsupervisor.id;
2674+
2675 CREATE TABLE packagecopyrequest (
2676 id integer NOT NULL,
2677 target_archive integer NOT NULL,
2678@@ -1720,6 +3060,14 @@
2679 date_completed timestamp without time zone
2680 );
2681
2682+CREATE SEQUENCE packagecopyrequest_id_seq
2683+ INCREMENT BY 1
2684+ NO MAXVALUE
2685+ NO MINVALUE
2686+ CACHE 1;
2687+
2688+ALTER SEQUENCE packagecopyrequest_id_seq OWNED BY packagecopyrequest.id;
2689+
2690 CREATE TABLE packagediff (
2691 id integer NOT NULL,
2692 date_requested timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
2693@@ -1728,9 +3076,18 @@
2694 to_source integer NOT NULL,
2695 date_fulfilled timestamp without time zone,
2696 diff_content integer,
2697+ status integer DEFAULT 0 NOT NULL,
2698 CONSTRAINT distinct_sources CHECK ((from_source <> to_source))
2699 );
2700
2701+CREATE SEQUENCE packagediff_id_seq
2702+ INCREMENT BY 1
2703+ NO MAXVALUE
2704+ NO MINVALUE
2705+ CACHE 1;
2706+
2707+ALTER SEQUENCE packagediff_id_seq OWNED BY packagediff.id;
2708+
2709 CREATE TABLE packageselection (
2710 id integer NOT NULL,
2711 distroseries integer NOT NULL,
2712@@ -1743,17 +3100,81 @@
2713 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2714 );
2715
2716+CREATE SEQUENCE packageselection_id_seq
2717+ INCREMENT BY 1
2718+ NO MAXVALUE
2719+ NO MINVALUE
2720+ CACHE 1;
2721+
2722+ALTER SEQUENCE packageselection_id_seq OWNED BY packageselection.id;
2723+
2724+CREATE TABLE packageset (
2725+ id integer NOT NULL,
2726+ date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
2727+ owner integer NOT NULL,
2728+ name text NOT NULL,
2729+ description text NOT NULL,
2730+ CONSTRAINT packageset_name_check CHECK (valid_name(name))
2731+);
2732+
2733+CREATE SEQUENCE packageset_id_seq
2734+ START WITH 1
2735+ INCREMENT BY 1
2736+ NO MAXVALUE
2737+ NO MINVALUE
2738+ CACHE 1;
2739+
2740+ALTER SEQUENCE packageset_id_seq OWNED BY packageset.id;
2741+
2742+CREATE TABLE packagesetinclusion (
2743+ id integer NOT NULL,
2744+ parent integer NOT NULL,
2745+ child integer NOT NULL
2746+);
2747+
2748+CREATE SEQUENCE packagesetinclusion_id_seq
2749+ START WITH 1
2750+ INCREMENT BY 1
2751+ NO MAXVALUE
2752+ NO MINVALUE
2753+ CACHE 1;
2754+
2755+ALTER SEQUENCE packagesetinclusion_id_seq OWNED BY packagesetinclusion.id;
2756+
2757+CREATE TABLE packagesetsources (
2758+ id integer NOT NULL,
2759+ packageset integer NOT NULL,
2760+ sourcepackagename integer NOT NULL
2761+);
2762+
2763+CREATE SEQUENCE packagesetsources_id_seq
2764+ START WITH 1
2765+ INCREMENT BY 1
2766+ NO MAXVALUE
2767+ NO MINVALUE
2768+ CACHE 1;
2769+
2770+ALTER SEQUENCE packagesetsources_id_seq OWNED BY packagesetsources.id;
2771+
2772 CREATE TABLE packageupload (
2773 id integer NOT NULL,
2774 status integer DEFAULT 0 NOT NULL,
2775 distroseries integer NOT NULL,
2776 pocket integer NOT NULL,
2777- changesfile integer NOT NULL,
2778+ changesfile integer,
2779 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
2780 signing_key integer,
2781 archive integer NOT NULL
2782 );
2783
2784+CREATE SEQUENCE packageupload_id_seq
2785+ INCREMENT BY 1
2786+ NO MAXVALUE
2787+ NO MINVALUE
2788+ CACHE 1;
2789+
2790+ALTER SEQUENCE packageupload_id_seq OWNED BY packageupload.id;
2791+
2792 CREATE TABLE packageuploadbuild (
2793 id integer NOT NULL,
2794 packageupload integer NOT NULL,
2795@@ -1761,6 +3182,14 @@
2796 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2797 );
2798
2799+CREATE SEQUENCE packageuploadbuild_id_seq
2800+ INCREMENT BY 1
2801+ NO MAXVALUE
2802+ NO MINVALUE
2803+ CACHE 1;
2804+
2805+ALTER SEQUENCE packageuploadbuild_id_seq OWNED BY packageuploadbuild.id;
2806+
2807 CREATE TABLE packageuploadcustom (
2808 id integer NOT NULL,
2809 packageupload integer NOT NULL,
2810@@ -1769,6 +3198,14 @@
2811 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2812 );
2813
2814+CREATE SEQUENCE packageuploadcustom_id_seq
2815+ INCREMENT BY 1
2816+ NO MAXVALUE
2817+ NO MINVALUE
2818+ CACHE 1;
2819+
2820+ALTER SEQUENCE packageuploadcustom_id_seq OWNED BY packageuploadcustom.id;
2821+
2822 CREATE TABLE packageuploadsource (
2823 id integer NOT NULL,
2824 packageupload integer NOT NULL,
2825@@ -1776,6 +3213,14 @@
2826 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2827 );
2828
2829+CREATE SEQUENCE packageuploadsource_id_seq
2830+ INCREMENT BY 1
2831+ NO MAXVALUE
2832+ NO MINVALUE
2833+ CACHE 1;
2834+
2835+ALTER SEQUENCE packageuploadsource_id_seq OWNED BY packageuploadsource.id;
2836+
2837 CREATE TABLE packaging (
2838 packaging integer NOT NULL,
2839 id integer DEFAULT nextval(('packaging_id_seq'::text)::regclass) NOT NULL,
2840@@ -1787,6 +3232,37 @@
2841 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2842 );
2843
2844+CREATE SEQUENCE packaging_id_seq
2845+ INCREMENT BY 1
2846+ NO MAXVALUE
2847+ NO MINVALUE
2848+ CACHE 1;
2849+
2850+ALTER SEQUENCE packaging_id_seq OWNED BY packaging.id;
2851+
2852+CREATE TABLE parsedapachelog (
2853+ id integer NOT NULL,
2854+ first_line text NOT NULL,
2855+ bytes_read integer NOT NULL,
2856+ date_last_parsed timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2857+);
2858+
2859+CREATE SEQUENCE parsedapachelog_id_seq
2860+ INCREMENT BY 1
2861+ NO MAXVALUE
2862+ NO MINVALUE
2863+ CACHE 1;
2864+
2865+ALTER SEQUENCE parsedapachelog_id_seq OWNED BY parsedapachelog.id;
2866+
2867+CREATE SEQUENCE person_id_seq
2868+ INCREMENT BY 1
2869+ NO MAXVALUE
2870+ NO MINVALUE
2871+ CACHE 1;
2872+
2873+ALTER SEQUENCE person_id_seq OWNED BY person.id;
2874+
2875 CREATE TABLE personlanguage (
2876 id integer NOT NULL,
2877 person integer NOT NULL,
2878@@ -1794,6 +3270,14 @@
2879 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2880 );
2881
2882+CREATE SEQUENCE personlanguage_id_seq
2883+ INCREMENT BY 1
2884+ NO MAXVALUE
2885+ NO MINVALUE
2886+ CACHE 1;
2887+
2888+ALTER SEQUENCE personlanguage_id_seq OWNED BY personlanguage.id;
2889+
2890 CREATE TABLE personlocation (
2891 id integer NOT NULL,
2892 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
2893@@ -1808,6 +3292,14 @@
2894 CONSTRAINT latitude_and_longitude_together CHECK (((latitude IS NULL) = (longitude IS NULL)))
2895 );
2896
2897+CREATE SEQUENCE personlocation_id_seq
2898+ INCREMENT BY 1
2899+ NO MAXVALUE
2900+ NO MINVALUE
2901+ CACHE 1;
2902+
2903+ALTER SEQUENCE personlocation_id_seq OWNED BY personlocation.id;
2904+
2905 CREATE TABLE personnotification (
2906 id integer NOT NULL,
2907 person integer NOT NULL,
2908@@ -1817,6 +3309,14 @@
2909 subject text NOT NULL
2910 );
2911
2912+CREATE SEQUENCE personnotification_id_seq
2913+ INCREMENT BY 1
2914+ NO MAXVALUE
2915+ NO MINVALUE
2916+ CACHE 1;
2917+
2918+ALTER SEQUENCE personnotification_id_seq OWNED BY personnotification.id;
2919+
2920 CREATE TABLE pillarname (
2921 id integer NOT NULL,
2922 name text NOT NULL,
2923@@ -1829,6 +3329,14 @@
2924 CONSTRAINT valid_name CHECK (valid_name(name))
2925 );
2926
2927+CREATE SEQUENCE pillarname_id_seq
2928+ INCREMENT BY 1
2929+ NO MAXVALUE
2930+ NO MINVALUE
2931+ CACHE 1;
2932+
2933+ALTER SEQUENCE pillarname_id_seq OWNED BY pillarname.id;
2934+
2935 CREATE TABLE pocketchroot (
2936 id integer NOT NULL,
2937 distroarchseries integer,
2938@@ -1837,6 +3345,14 @@
2939 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2940 );
2941
2942+CREATE SEQUENCE pocketchroot_id_seq
2943+ INCREMENT BY 1
2944+ NO MAXVALUE
2945+ NO MINVALUE
2946+ CACHE 1;
2947+
2948+ALTER SEQUENCE pocketchroot_id_seq OWNED BY pocketchroot.id;
2949+
2950 CREATE TABLE pocomment (
2951 id integer NOT NULL,
2952 potemplate integer NOT NULL,
2953@@ -1848,6 +3364,31 @@
2954 person integer
2955 );
2956
2957+CREATE SEQUENCE pocomment_id_seq
2958+ INCREMENT BY 1
2959+ NO MAXVALUE
2960+ NO MINVALUE
2961+ CACHE 1;
2962+
2963+ALTER SEQUENCE pocomment_id_seq OWNED BY pocomment.id;
2964+
2965+CREATE TABLE poexportrequest (
2966+ id integer NOT NULL,
2967+ person integer NOT NULL,
2968+ potemplate integer NOT NULL,
2969+ pofile integer,
2970+ format integer NOT NULL,
2971+ date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
2972+);
2973+
2974+CREATE SEQUENCE poexportrequest_id_seq
2975+ INCREMENT BY 1
2976+ NO MAXVALUE
2977+ NO MINVALUE
2978+ CACHE 1;
2979+
2980+ALTER SEQUENCE poexportrequest_id_seq OWNED BY poexportrequest.id;
2981+
2982 CREATE TABLE pofile (
2983 id integer NOT NULL,
2984 potemplate integer NOT NULL,
2985@@ -1871,11 +3412,101 @@
2986 CONSTRAINT valid_variant CHECK ((variant <> ''::text))
2987 );
2988
2989+CREATE SEQUENCE pofile_id_seq
2990+ INCREMENT BY 1
2991+ NO MAXVALUE
2992+ NO MINVALUE
2993+ CACHE 1;
2994+
2995+ALTER SEQUENCE pofile_id_seq OWNED BY pofile.id;
2996+
2997+CREATE TABLE pofiletranslator (
2998+ id integer NOT NULL,
2999+ person integer NOT NULL,
3000+ pofile integer NOT NULL,
3001+ latest_message integer NOT NULL,
3002+ date_last_touched timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3003+);
3004+
3005+CREATE SEQUENCE pofiletranslator_id_seq
3006+ INCREMENT BY 1
3007+ NO MAXVALUE
3008+ NO MINVALUE
3009+ CACHE 1;
3010+
3011+ALTER SEQUENCE pofiletranslator_id_seq OWNED BY pofiletranslator.id;
3012+
3013+CREATE TABLE poll (
3014+ id integer NOT NULL,
3015+ team integer NOT NULL,
3016+ name text NOT NULL,
3017+ title text NOT NULL,
3018+ dateopens timestamp without time zone NOT NULL,
3019+ datecloses timestamp without time zone NOT NULL,
3020+ proposition text NOT NULL,
3021+ type integer NOT NULL,
3022+ allowspoilt boolean DEFAULT false NOT NULL,
3023+ secrecy integer NOT NULL,
3024+ date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
3025+ CONSTRAINT sane_dates CHECK ((dateopens < datecloses))
3026+);
3027+
3028+CREATE SEQUENCE poll_id_seq
3029+ INCREMENT BY 1
3030+ NO MAXVALUE
3031+ NO MINVALUE
3032+ CACHE 1;
3033+
3034+ALTER SEQUENCE poll_id_seq OWNED BY poll.id;
3035+
3036+CREATE TABLE polloption (
3037+ id integer NOT NULL,
3038+ poll integer NOT NULL,
3039+ name text NOT NULL,
3040+ title text NOT NULL,
3041+ active boolean DEFAULT true NOT NULL,
3042+ date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3043+);
3044+
3045+CREATE SEQUENCE polloption_id_seq
3046+ INCREMENT BY 1
3047+ NO MAXVALUE
3048+ NO MINVALUE
3049+ CACHE 1;
3050+
3051+ALTER SEQUENCE polloption_id_seq OWNED BY polloption.id;
3052+
3053 CREATE TABLE pomsgid (
3054 id integer NOT NULL,
3055 msgid text NOT NULL
3056 );
3057
3058+CREATE SEQUENCE pomsgid_id_seq
3059+ INCREMENT BY 1
3060+ NO MAXVALUE
3061+ NO MINVALUE
3062+ CACHE 1;
3063+
3064+ALTER SEQUENCE pomsgid_id_seq OWNED BY pomsgid.id;
3065+
3066+CREATE TABLE posubscription (
3067+ id integer NOT NULL,
3068+ person integer NOT NULL,
3069+ potemplate integer NOT NULL,
3070+ language integer,
3071+ notificationinterval interval,
3072+ lastnotified timestamp without time zone,
3073+ date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3074+);
3075+
3076+CREATE SEQUENCE posubscription_id_seq
3077+ INCREMENT BY 1
3078+ NO MAXVALUE
3079+ NO MINVALUE
3080+ CACHE 1;
3081+
3082+ALTER SEQUENCE posubscription_id_seq OWNED BY posubscription.id;
3083+
3084 CREATE TABLE potemplate (
3085 id integer NOT NULL,
3086 priority integer DEFAULT 0 NOT NULL,
3087@@ -1904,11 +3535,19 @@
3088 CONSTRAINT valid_link CHECK ((((productseries IS NULL) <> (distroseries IS NULL)) AND ((distroseries IS NULL) = (sourcepackagename IS NULL))))
3089 );
3090
3091+CREATE SEQUENCE potemplate_id_seq
3092+ INCREMENT BY 1
3093+ NO MAXVALUE
3094+ NO MINVALUE
3095+ CACHE 1;
3096+
3097+ALTER SEQUENCE potemplate_id_seq OWNED BY potemplate.id;
3098+
3099 CREATE TABLE potmsgset (
3100 id integer NOT NULL,
3101 msgid_singular integer NOT NULL,
3102- sequence integer NOT NULL,
3103- potemplate integer NOT NULL,
3104+ sequence integer,
3105+ potemplate integer,
3106 commenttext text,
3107 filereferences text,
3108 sourcecomment text,
3109@@ -1917,96 +3556,54 @@
3110 msgid_plural integer
3111 );
3112
3113+CREATE TABLE translationtemplateitem (
3114+ id integer NOT NULL,
3115+ potemplate integer NOT NULL,
3116+ sequence integer NOT NULL,
3117+ potmsgset integer NOT NULL,
3118+ CONSTRAINT translationtemplateitem_sequence_check CHECK ((sequence >= 0))
3119+);
3120+
3121+CREATE VIEW potexport AS
3122+ SELECT COALESCE((potmsgset.id)::text, 'X'::text) AS id, potemplate.productseries, potemplate.sourcepackagename, potemplate.distroseries, potemplate.id AS potemplate, potemplate.header AS template_header, potemplate.languagepack, translationtemplateitem.sequence, potmsgset.id AS potmsgset, potmsgset.commenttext AS comment, potmsgset.sourcecomment AS source_comment, potmsgset.filereferences AS file_references, potmsgset.flagscomment AS flags_comment, potmsgset.context, msgid_singular.msgid AS msgid_singular, msgid_plural.msgid AS msgid_plural FROM ((((potmsgset JOIN translationtemplateitem ON ((translationtemplateitem.potmsgset = potmsgset.id))) JOIN potemplate ON ((potemplate.id = translationtemplateitem.potemplate))) LEFT JOIN pomsgid msgid_singular ON ((potmsgset.msgid_singular = msgid_singular.id))) LEFT JOIN pomsgid msgid_plural ON ((potmsgset.msgid_plural = msgid_plural.id)));
3123+
3124+CREATE SEQUENCE potmsgset_id_seq
3125+ INCREMENT BY 1
3126+ NO MAXVALUE
3127+ NO MINVALUE
3128+ CACHE 1;
3129+
3130+ALTER SEQUENCE potmsgset_id_seq OWNED BY potmsgset.id;
3131+
3132 CREATE TABLE potranslation (
3133 id integer NOT NULL,
3134 translation text NOT NULL
3135 );
3136
3137-CREATE TABLE translationmessage (
3138- id integer NOT NULL,
3139- pofile integer NOT NULL,
3140- potmsgset integer NOT NULL,
3141- date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
3142- submitter integer NOT NULL,
3143- date_reviewed timestamp without time zone,
3144- reviewer integer,
3145- msgstr0 integer,
3146- msgstr1 integer,
3147- msgstr2 integer,
3148- msgstr3 integer,
3149- comment text,
3150- origin integer NOT NULL,
3151- validation_status integer DEFAULT 0 NOT NULL,
3152- is_current boolean DEFAULT false NOT NULL,
3153- is_fuzzy boolean DEFAULT false NOT NULL,
3154- is_imported boolean DEFAULT false NOT NULL,
3155- was_obsolete_in_last_import boolean DEFAULT false NOT NULL,
3156- was_fuzzy_in_last_import boolean DEFAULT false NOT NULL,
3157- msgstr4 integer,
3158- msgstr5 integer,
3159- potemplate integer,
3160- language integer,
3161- variant text,
3162- CONSTRAINT translationmessage__reviewer__date_reviewed__valid CHECK (((reviewer IS NULL) = (date_reviewed IS NULL)))
3163-);
3164-
3165-CREATE VIEW poexport AS
3166- SELECT ((COALESCE((potmsgset.id)::text, 'X'::text) || '.'::text) || COALESCE((translationmessage.id)::text, 'X'::text)) AS id, potemplate.productseries, potemplate.sourcepackagename, potemplate.distroseries, potemplate.id AS potemplate, potemplate.header AS template_header, potemplate.languagepack, pofile.id AS pofile, pofile.language, pofile.variant, pofile.topcomment AS translation_file_comment, pofile.header AS translation_header, pofile.fuzzyheader AS is_translation_header_fuzzy, potmsgset.sequence, potmsgset.id AS potmsgset, translationmessage.comment, potmsgset.sourcecomment AS source_comment, potmsgset.filereferences AS file_references, potmsgset.flagscomment AS flags_comment, potmsgset.context, msgid_singular.msgid AS msgid_singular, msgid_plural.msgid AS msgid_plural, translationmessage.is_current, translationmessage.is_imported, potranslation0.translation AS translation0, potranslation1.translation AS translation1, potranslation2.translation AS translation2, potranslation3.translation AS translation3, potranslation4.translation AS translation4, potranslation5.translation AS translation5 FROM (((((((((((potmsgset JOIN potemplate ON ((potemplate.id = potmsgset.potemplate))) JOIN pofile ON ((potemplate.id = pofile.potemplate))) LEFT JOIN translationmessage ON ((((potmsgset.id = translationmessage.potmsgset) AND (translationmessage.pofile = pofile.id)) AND (translationmessage.is_current IS TRUE)))) LEFT JOIN pomsgid msgid_singular ON ((msgid_singular.id = potmsgset.msgid_singular))) LEFT JOIN pomsgid msgid_plural ON ((msgid_plural.id = potmsgset.msgid_plural))) LEFT JOIN potranslation potranslation0 ON ((potranslation0.id = translationmessage.msgstr0))) LEFT JOIN potranslation potranslation1 ON ((potranslation1.id = translationmessage.msgstr1))) LEFT JOIN potranslation potranslation2 ON ((potranslation2.id = translationmessage.msgstr2))) LEFT JOIN potranslation potranslation3 ON ((potranslation3.id = translationmessage.msgstr3))) LEFT JOIN potranslation potranslation4 ON ((potranslation4.id = translationmessage.msgstr4))) LEFT JOIN potranslation potranslation5 ON ((potranslation5.id = translationmessage.msgstr5)));
3167-
3168-CREATE TABLE poexportrequest (
3169- id integer NOT NULL,
3170- person integer NOT NULL,
3171- potemplate integer NOT NULL,
3172- pofile integer,
3173- format integer NOT NULL,
3174- date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3175-);
3176-
3177-CREATE TABLE pofiletranslator (
3178- id integer NOT NULL,
3179- person integer NOT NULL,
3180- pofile integer NOT NULL,
3181- latest_message integer NOT NULL,
3182- date_last_touched timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3183-);
3184-
3185-CREATE TABLE poll (
3186- id integer NOT NULL,
3187- team integer NOT NULL,
3188- name text NOT NULL,
3189- title text NOT NULL,
3190- dateopens timestamp without time zone NOT NULL,
3191- datecloses timestamp without time zone NOT NULL,
3192- proposition text NOT NULL,
3193- type integer NOT NULL,
3194- allowspoilt boolean DEFAULT false NOT NULL,
3195- secrecy integer NOT NULL,
3196- date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
3197- CONSTRAINT is_team CHECK (is_team(team)),
3198- CONSTRAINT sane_dates CHECK ((dateopens < datecloses))
3199-);
3200-
3201-CREATE TABLE polloption (
3202- id integer NOT NULL,
3203- poll integer NOT NULL,
3204- name text NOT NULL,
3205- title text NOT NULL,
3206- active boolean DEFAULT true NOT NULL,
3207- date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3208-);
3209-
3210-CREATE TABLE posubscription (
3211- id integer NOT NULL,
3212- person integer NOT NULL,
3213- potemplate integer NOT NULL,
3214- language integer,
3215- notificationinterval interval,
3216- lastnotified timestamp without time zone,
3217- date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3218-);
3219-
3220-CREATE VIEW potexport AS
3221- SELECT COALESCE((potmsgset.id)::text, 'X'::text) AS id, potemplate.productseries, potemplate.sourcepackagename, potemplate.distroseries, potemplate.id AS potemplate, potemplate.header AS template_header, potemplate.languagepack, potmsgset.sequence, potmsgset.id AS potmsgset, potmsgset.commenttext AS comment, potmsgset.sourcecomment AS source_comment, potmsgset.filereferences AS file_references, potmsgset.flagscomment AS flags_comment, potmsgset.context, msgid_singular.msgid AS msgid_singular, msgid_plural.msgid AS msgid_plural FROM (((potmsgset JOIN potemplate ON ((potemplate.id = potmsgset.potemplate))) LEFT JOIN pomsgid msgid_singular ON ((potmsgset.msgid_singular = msgid_singular.id))) LEFT JOIN pomsgid msgid_plural ON ((potmsgset.msgid_plural = msgid_plural.id)));
3222+CREATE SEQUENCE potranslation_id_seq
3223+ INCREMENT BY 1
3224+ NO MAXVALUE
3225+ NO MINVALUE
3226+ CACHE 1;
3227+
3228+ALTER SEQUENCE potranslation_id_seq OWNED BY potranslation.id;
3229+
3230+CREATE TABLE previewdiff (
3231+ id integer NOT NULL,
3232+ source_revision_id text NOT NULL,
3233+ target_revision_id text NOT NULL,
3234+ dependent_revision_id text,
3235+ diff integer NOT NULL,
3236+ conflicts text
3237+);
3238+
3239+CREATE SEQUENCE previewdiff_id_seq
3240+ INCREMENT BY 1
3241+ NO MAXVALUE
3242+ NO MINVALUE
3243+ CACHE 1;
3244+
3245+ALTER SEQUENCE previewdiff_id_seq OWNED BY previewdiff.id;
3246
3247 CREATE TABLE processor (
3248 id integer NOT NULL,
3249@@ -2016,6 +3613,14 @@
3250 description text NOT NULL
3251 );
3252
3253+CREATE SEQUENCE processor_id_seq
3254+ INCREMENT BY 1
3255+ NO MAXVALUE
3256+ NO MINVALUE
3257+ CACHE 1;
3258+
3259+ALTER SEQUENCE processor_id_seq OWNED BY processor.id;
3260+
3261 CREATE TABLE processorfamily (
3262 id integer NOT NULL,
3263 name text NOT NULL,
3264@@ -2023,6 +3628,22 @@
3265 description text NOT NULL
3266 );
3267
3268+CREATE SEQUENCE processorfamily_id_seq
3269+ INCREMENT BY 1
3270+ NO MAXVALUE
3271+ NO MINVALUE
3272+ CACHE 1;
3273+
3274+ALTER SEQUENCE processorfamily_id_seq OWNED BY processorfamily.id;
3275+
3276+CREATE SEQUENCE product_id_seq
3277+ INCREMENT BY 1
3278+ NO MAXVALUE
3279+ NO MINVALUE
3280+ CACHE 1;
3281+
3282+ALTER SEQUENCE product_id_seq OWNED BY product.id;
3283+
3284 CREATE TABLE productbounty (
3285 id integer NOT NULL,
3286 bounty integer NOT NULL,
3287@@ -2030,6 +3651,14 @@
3288 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3289 );
3290
3291+CREATE SEQUENCE productbounty_id_seq
3292+ INCREMENT BY 1
3293+ NO MAXVALUE
3294+ NO MINVALUE
3295+ CACHE 1;
3296+
3297+ALTER SEQUENCE productbounty_id_seq OWNED BY productbounty.id;
3298+
3299 CREATE TABLE productcvsmodule (
3300 id integer NOT NULL,
3301 product integer NOT NULL,
3302@@ -2039,26 +3668,46 @@
3303 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3304 );
3305
3306+CREATE SEQUENCE productcvsmodule_id_seq
3307+ INCREMENT BY 1
3308+ NO MAXVALUE
3309+ NO MINVALUE
3310+ CACHE 1;
3311+
3312+ALTER SEQUENCE productcvsmodule_id_seq OWNED BY productcvsmodule.id;
3313+
3314 CREATE TABLE productlicense (
3315 id integer NOT NULL,
3316 product integer NOT NULL,
3317 license integer NOT NULL
3318 );
3319
3320+CREATE SEQUENCE productlicense_id_seq
3321+ INCREMENT BY 1
3322+ NO MAXVALUE
3323+ NO MINVALUE
3324+ CACHE 1;
3325+
3326+ALTER SEQUENCE productlicense_id_seq OWNED BY productlicense.id;
3327+
3328 CREATE TABLE productrelease (
3329 id integer NOT NULL,
3330 datereleased timestamp without time zone NOT NULL,
3331- version text NOT NULL,
3332- codename text,
3333- description text,
3334+ release_notes text,
3335 changelog text,
3336 owner integer NOT NULL,
3337- summary text,
3338- productseries integer NOT NULL,
3339 datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
3340- CONSTRAINT valid_version CHECK (sane_version(version))
3341+ milestone integer NOT NULL
3342 );
3343
3344+CREATE SEQUENCE productrelease_id_seq
3345+ INCREMENT BY 1
3346+ NO MAXVALUE
3347+ NO MINVALUE
3348+ CACHE 1;
3349+
3350+ALTER SEQUENCE productrelease_id_seq OWNED BY productrelease.id;
3351+
3352 CREATE TABLE productreleasefile (
3353 productrelease integer NOT NULL,
3354 libraryfile integer NOT NULL,
3355@@ -2071,12 +3720,19 @@
3356 signature integer
3357 );
3358
3359+CREATE SEQUENCE productreleasefile_id_seq
3360+ INCREMENT BY 1
3361+ NO MAXVALUE
3362+ NO MINVALUE
3363+ CACHE 1;
3364+
3365+ALTER SEQUENCE productreleasefile_id_seq OWNED BY productreleasefile.id;
3366+
3367 CREATE TABLE productseries (
3368 id integer NOT NULL,
3369 product integer NOT NULL,
3370 name text NOT NULL,
3371 summary text NOT NULL,
3372- import_branch integer,
3373 importstatus integer,
3374 datelastsynced timestamp without time zone,
3375 syncinterval interval,
3376@@ -2096,9 +3752,11 @@
3377 datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
3378 driver integer,
3379 owner integer NOT NULL,
3380- user_branch integer,
3381 date_published_sync timestamp without time zone,
3382 status integer DEFAULT 2 NOT NULL,
3383+ translations_autoimport_mode integer DEFAULT 1 NOT NULL,
3384+ branch integer,
3385+ translations_branch integer,
3386 CONSTRAINT complete_cvs CHECK ((((cvsroot IS NULL) = (cvsmodule IS NULL)) AND ((cvsroot IS NULL) = (cvsbranch IS NULL)))),
3387 CONSTRAINT no_empty_strings CHECK (((((cvsroot <> ''::text) AND (cvsmodule <> ''::text)) AND (cvsbranch <> ''::text)) AND (svnrepository <> ''::text))),
3388 CONSTRAINT valid_importseries CHECK (((importstatus IS NULL) OR (rcstype IS NOT NULL))),
3389@@ -2106,12 +3764,28 @@
3390 CONSTRAINT valid_releasefileglob CHECK (valid_absolute_url(releasefileglob))
3391 );
3392
3393+CREATE SEQUENCE productseries_id_seq
3394+ INCREMENT BY 1
3395+ NO MAXVALUE
3396+ NO MINVALUE
3397+ CACHE 1;
3398+
3399+ALTER SEQUENCE productseries_id_seq OWNED BY productseries.id;
3400+
3401 CREATE TABLE productseriescodeimport (
3402 id integer NOT NULL,
3403 productseries integer NOT NULL,
3404 codeimport integer NOT NULL
3405 );
3406
3407+CREATE SEQUENCE productseriescodeimport_id_seq
3408+ INCREMENT BY 1
3409+ NO MAXVALUE
3410+ NO MINVALUE
3411+ CACHE 1;
3412+
3413+ALTER SEQUENCE productseriescodeimport_id_seq OWNED BY productseriescodeimport.id;
3414+
3415 CREATE TABLE productsvnmodule (
3416 id integer NOT NULL,
3417 product integer NOT NULL,
3418@@ -2120,6 +3794,14 @@
3419 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3420 );
3421
3422+CREATE SEQUENCE productsvnmodule_id_seq
3423+ INCREMENT BY 1
3424+ NO MAXVALUE
3425+ NO MINVALUE
3426+ CACHE 1;
3427+
3428+ALTER SEQUENCE productsvnmodule_id_seq OWNED BY productsvnmodule.id;
3429+
3430 CREATE TABLE project (
3431 id integer NOT NULL,
3432 owner integer NOT NULL,
3433@@ -2151,6 +3833,14 @@
3434 CONSTRAINT valid_name CHECK (valid_name(name))
3435 );
3436
3437+CREATE SEQUENCE project_id_seq
3438+ INCREMENT BY 1
3439+ NO MAXVALUE
3440+ NO MINVALUE
3441+ CACHE 1;
3442+
3443+ALTER SEQUENCE project_id_seq OWNED BY project.id;
3444+
3445 CREATE TABLE projectbounty (
3446 id integer NOT NULL,
3447 bounty integer NOT NULL,
3448@@ -2158,6 +3848,14 @@
3449 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3450 );
3451
3452+CREATE SEQUENCE projectbounty_id_seq
3453+ INCREMENT BY 1
3454+ NO MAXVALUE
3455+ NO MINVALUE
3456+ CACHE 1;
3457+
3458+ALTER SEQUENCE projectbounty_id_seq OWNED BY projectbounty.id;
3459+
3460 CREATE TABLE projectrelationship (
3461 id integer NOT NULL,
3462 subject integer NOT NULL,
3463@@ -2165,6 +3863,14 @@
3464 object integer NOT NULL
3465 );
3466
3467+CREATE SEQUENCE projectrelationship_id_seq
3468+ INCREMENT BY 1
3469+ NO MAXVALUE
3470+ NO MINVALUE
3471+ CACHE 1;
3472+
3473+ALTER SEQUENCE projectrelationship_id_seq OWNED BY projectrelationship.id;
3474+
3475 CREATE TABLE section (
3476 id integer NOT NULL,
3477 name text NOT NULL
3478@@ -2180,6 +3886,14 @@
3479 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3480 );
3481
3482+CREATE SEQUENCE pushmirroraccess_id_seq
3483+ INCREMENT BY 1
3484+ NO MAXVALUE
3485+ NO MINVALUE
3486+ CACHE 1;
3487+
3488+ALTER SEQUENCE pushmirroraccess_id_seq OWNED BY pushmirroraccess.id;
3489+
3490 CREATE TABLE question (
3491 id integer NOT NULL,
3492 owner integer NOT NULL,
3493@@ -2208,6 +3922,14 @@
3494 CONSTRAINT sourcepackagename_needs_distro CHECK (((sourcepackagename IS NULL) OR (distribution IS NOT NULL)))
3495 );
3496
3497+CREATE SEQUENCE question_id_seq
3498+ INCREMENT BY 1
3499+ NO MAXVALUE
3500+ NO MINVALUE
3501+ CACHE 1;
3502+
3503+ALTER SEQUENCE question_id_seq OWNED BY question.id;
3504+
3505 CREATE TABLE questionbug (
3506 id integer NOT NULL,
3507 question integer NOT NULL,
3508@@ -2215,6 +3937,14 @@
3509 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3510 );
3511
3512+CREATE SEQUENCE questionbug_id_seq
3513+ INCREMENT BY 1
3514+ NO MAXVALUE
3515+ NO MINVALUE
3516+ CACHE 1;
3517+
3518+ALTER SEQUENCE questionbug_id_seq OWNED BY questionbug.id;
3519+
3520 CREATE TABLE questionmessage (
3521 id integer NOT NULL,
3522 question integer NOT NULL,
3523@@ -2223,6 +3953,14 @@
3524 new_status integer NOT NULL
3525 );
3526
3527+CREATE SEQUENCE questionmessage_id_seq
3528+ INCREMENT BY 1
3529+ NO MAXVALUE
3530+ NO MINVALUE
3531+ CACHE 1;
3532+
3533+ALTER SEQUENCE questionmessage_id_seq OWNED BY questionmessage.id;
3534+
3535 CREATE TABLE questionreopening (
3536 id integer NOT NULL,
3537 question integer NOT NULL,
3538@@ -2233,6 +3971,14 @@
3539 priorstate integer NOT NULL
3540 );
3541
3542+CREATE SEQUENCE questionreopening_id_seq
3543+ INCREMENT BY 1
3544+ NO MAXVALUE
3545+ NO MINVALUE
3546+ CACHE 1;
3547+
3548+ALTER SEQUENCE questionreopening_id_seq OWNED BY questionreopening.id;
3549+
3550 CREATE TABLE questionsubscription (
3551 id integer NOT NULL,
3552 question integer NOT NULL,
3553@@ -2240,6 +3986,14 @@
3554 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3555 );
3556
3557+CREATE SEQUENCE questionsubscription_id_seq
3558+ INCREMENT BY 1
3559+ NO MAXVALUE
3560+ NO MINVALUE
3561+ CACHE 1;
3562+
3563+ALTER SEQUENCE questionsubscription_id_seq OWNED BY questionsubscription.id;
3564+
3565 CREATE TABLE requestedcds (
3566 id integer NOT NULL,
3567 request integer NOT NULL,
3568@@ -2252,16 +4006,21 @@
3569 CONSTRAINT quantityapproved_is_positive CHECK ((quantityapproved >= 0))
3570 );
3571
3572-CREATE TABLE revision (
3573- id integer NOT NULL,
3574- date_created timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
3575- log_body text NOT NULL,
3576- revision_author integer NOT NULL,
3577- gpgkey integer,
3578- revision_id text NOT NULL,
3579- revision_date timestamp without time zone,
3580- karma_allocated boolean DEFAULT false
3581-);
3582+CREATE SEQUENCE requestedcds_id_seq
3583+ INCREMENT BY 1
3584+ NO MAXVALUE
3585+ NO MINVALUE
3586+ CACHE 1;
3587+
3588+ALTER SEQUENCE requestedcds_id_seq OWNED BY requestedcds.id;
3589+
3590+CREATE SEQUENCE revision_id_seq
3591+ INCREMENT BY 1
3592+ NO MAXVALUE
3593+ NO MINVALUE
3594+ CACHE 1;
3595+
3596+ALTER SEQUENCE revision_id_seq OWNED BY revision.id;
3597
3598 CREATE TABLE revisionauthor (
3599 id integer NOT NULL,
3600@@ -2270,6 +4029,34 @@
3601 person integer
3602 );
3603
3604+CREATE SEQUENCE revisionauthor_id_seq
3605+ INCREMENT BY 1
3606+ NO MAXVALUE
3607+ NO MINVALUE
3608+ CACHE 1;
3609+
3610+ALTER SEQUENCE revisionauthor_id_seq OWNED BY revisionauthor.id;
3611+
3612+CREATE TABLE revisioncache (
3613+ id integer NOT NULL,
3614+ revision integer NOT NULL,
3615+ revision_author integer NOT NULL,
3616+ revision_date timestamp without time zone NOT NULL,
3617+ product integer,
3618+ distroseries integer,
3619+ sourcepackagename integer,
3620+ private boolean NOT NULL,
3621+ CONSTRAINT valid_target CHECK ((((distroseries IS NULL) = (sourcepackagename IS NULL)) AND (((distroseries IS NULL) AND (product IS NULL)) OR ((distroseries IS NULL) <> (product IS NULL)))))
3622+);
3623+
3624+CREATE SEQUENCE revisioncache_id_seq
3625+ INCREMENT BY 1
3626+ NO MAXVALUE
3627+ NO MINVALUE
3628+ CACHE 1;
3629+
3630+ALTER SEQUENCE revisioncache_id_seq OWNED BY revisioncache.id;
3631+
3632 CREATE VIEW revisionnumber AS
3633 SELECT branchrevision.id, branchrevision.sequence, branchrevision.branch, branchrevision.revision FROM branchrevision;
3634
3635@@ -2280,6 +4067,14 @@
3636 parent_id text NOT NULL
3637 );
3638
3639+CREATE SEQUENCE revisionparent_id_seq
3640+ INCREMENT BY 1
3641+ NO MAXVALUE
3642+ NO MINVALUE
3643+ CACHE 1;
3644+
3645+ALTER SEQUENCE revisionparent_id_seq OWNED BY revisionparent.id;
3646+
3647 CREATE TABLE revisionproperty (
3648 id integer NOT NULL,
3649 revision integer NOT NULL,
3650@@ -2287,6 +4082,14 @@
3651 value text NOT NULL
3652 );
3653
3654+CREATE SEQUENCE revisionproperty_id_seq
3655+ INCREMENT BY 1
3656+ NO MAXVALUE
3657+ NO MINVALUE
3658+ CACHE 1;
3659+
3660+ALTER SEQUENCE revisionproperty_id_seq OWNED BY revisionproperty.id;
3661+
3662 CREATE TABLE scriptactivity (
3663 id integer NOT NULL,
3664 name text NOT NULL,
3665@@ -2295,6 +4098,22 @@
3666 date_completed timestamp without time zone NOT NULL
3667 );
3668
3669+CREATE SEQUENCE scriptactivity_id_seq
3670+ INCREMENT BY 1
3671+ NO MAXVALUE
3672+ NO MINVALUE
3673+ CACHE 1;
3674+
3675+ALTER SEQUENCE scriptactivity_id_seq OWNED BY scriptactivity.id;
3676+
3677+CREATE SEQUENCE section_id_seq
3678+ INCREMENT BY 1
3679+ NO MAXVALUE
3680+ NO MINVALUE
3681+ CACHE 1;
3682+
3683+ALTER SEQUENCE section_id_seq OWNED BY section.id;
3684+
3685 CREATE TABLE sectionselection (
3686 id integer NOT NULL,
3687 distroseries integer NOT NULL,
3688@@ -2302,6 +4121,22 @@
3689 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3690 );
3691
3692+CREATE SEQUENCE sectionselection_id_seq
3693+ INCREMENT BY 1
3694+ NO MAXVALUE
3695+ NO MINVALUE
3696+ CACHE 1;
3697+
3698+ALTER SEQUENCE sectionselection_id_seq OWNED BY sectionselection.id;
3699+
3700+CREATE SEQUENCE securebinarypackagepublishinghistory_id_seq
3701+ INCREMENT BY 1
3702+ NO MAXVALUE
3703+ NO MINVALUE
3704+ CACHE 1;
3705+
3706+ALTER SEQUENCE securebinarypackagepublishinghistory_id_seq OWNED BY securebinarypackagepublishinghistory.id;
3707+
3708 CREATE TABLE securesourcepackagepublishinghistory (
3709 id integer NOT NULL,
3710 sourcepackagerelease integer NOT NULL,
3711@@ -2324,29 +4159,87 @@
3712 removal_comment text
3713 );
3714
3715+CREATE SEQUENCE securesourcepackagepublishinghistory_id_seq
3716+ INCREMENT BY 1
3717+ NO MAXVALUE
3718+ NO MINVALUE
3719+ CACHE 1;
3720+
3721+ALTER SEQUENCE securesourcepackagepublishinghistory_id_seq OWNED BY securesourcepackagepublishinghistory.id;
3722+
3723+CREATE TABLE seriessourcepackagebranch (
3724+ id integer NOT NULL,
3725+ distroseries integer NOT NULL,
3726+ pocket integer NOT NULL,
3727+ sourcepackagename integer NOT NULL,
3728+ branch integer NOT NULL,
3729+ registrant integer NOT NULL,
3730+ date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3731+);
3732+
3733+CREATE SEQUENCE seriessourcepackagebranch_id_seq
3734+ INCREMENT BY 1
3735+ NO MAXVALUE
3736+ NO MINVALUE
3737+ CACHE 1;
3738+
3739+ALTER SEQUENCE seriessourcepackagebranch_id_seq OWNED BY seriessourcepackagebranch.id;
3740+
3741 CREATE TABLE shipitreport (
3742 id integer NOT NULL,
3743 datecreated timestamp without time zone NOT NULL,
3744 csvfile integer NOT NULL
3745 );
3746
3747+CREATE SEQUENCE shipitreport_id_seq
3748+ INCREMENT BY 1
3749+ NO MAXVALUE
3750+ NO MINVALUE
3751+ CACHE 1;
3752+
3753+ALTER SEQUENCE shipitreport_id_seq OWNED BY shipitreport.id;
3754+
3755 CREATE TABLE shipitsurvey (
3756 id integer NOT NULL,
3757- person integer NOT NULL,
3758+ account integer NOT NULL,
3759 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
3760 exported boolean DEFAULT false NOT NULL
3761 );
3762
3763+CREATE SEQUENCE shipitsurvey_id_seq
3764+ INCREMENT BY 1
3765+ NO MAXVALUE
3766+ NO MINVALUE
3767+ CACHE 1;
3768+
3769+ALTER SEQUENCE shipitsurvey_id_seq OWNED BY shipitsurvey.id;
3770+
3771 CREATE TABLE shipitsurveyanswer (
3772 id integer NOT NULL,
3773 answer text NOT NULL
3774 );
3775
3776+CREATE SEQUENCE shipitsurveyanswer_id_seq
3777+ INCREMENT BY 1
3778+ NO MAXVALUE
3779+ NO MINVALUE
3780+ CACHE 1;
3781+
3782+ALTER SEQUENCE shipitsurveyanswer_id_seq OWNED BY shipitsurveyanswer.id;
3783+
3784 CREATE TABLE shipitsurveyquestion (
3785 id integer NOT NULL,
3786 question text NOT NULL
3787 );
3788
3789+CREATE SEQUENCE shipitsurveyquestion_id_seq
3790+ INCREMENT BY 1
3791+ NO MAXVALUE
3792+ NO MINVALUE
3793+ CACHE 1;
3794+
3795+ALTER SEQUENCE shipitsurveyquestion_id_seq OWNED BY shipitsurveyquestion.id;
3796+
3797 CREATE TABLE shipitsurveyresult (
3798 id integer NOT NULL,
3799 survey integer NOT NULL,
3800@@ -2354,6 +4247,14 @@
3801 answer integer
3802 );
3803
3804+CREATE SEQUENCE shipitsurveyresult_id_seq
3805+ INCREMENT BY 1
3806+ NO MAXVALUE
3807+ NO MINVALUE
3808+ CACHE 1;
3809+
3810+ALTER SEQUENCE shipitsurveyresult_id_seq OWNED BY shipitsurveyresult.id;
3811+
3812 CREATE TABLE shipment (
3813 id integer NOT NULL,
3814 logintoken text NOT NULL,
3815@@ -2363,6 +4264,14 @@
3816 trackingcode text
3817 );
3818
3819+CREATE SEQUENCE shipment_id_seq
3820+ INCREMENT BY 1
3821+ NO MAXVALUE
3822+ NO MINVALUE
3823+ CACHE 1;
3824+
3825+ALTER SEQUENCE shipment_id_seq OWNED BY shipment.id;
3826+
3827 CREATE TABLE shippingrequest (
3828 id integer NOT NULL,
3829 recipient integer NOT NULL,
3830@@ -2385,10 +4294,19 @@
3831 status integer NOT NULL,
3832 normalized_address text NOT NULL,
3833 type integer,
3834+ is_admin_request boolean DEFAULT false NOT NULL,
3835 CONSTRAINT enforce_shipped_status CHECK (((status <> 4) OR (shipment IS NOT NULL))),
3836 CONSTRAINT printable_addresses CHECK (is_printable_ascii((((((((COALESCE(recipientdisplayname, ''::text) || COALESCE(addressline1, ''::text)) || COALESCE(addressline2, ''::text)) || COALESCE(organization, ''::text)) || COALESCE(city, ''::text)) || COALESCE(province, ''::text)) || COALESCE(postcode, ''::text)) || COALESCE(phone, ''::text))))
3837 );
3838
3839+CREATE SEQUENCE shippingrequest_id_seq
3840+ INCREMENT BY 1
3841+ NO MAXVALUE
3842+ NO MINVALUE
3843+ CACHE 1;
3844+
3845+ALTER SEQUENCE shippingrequest_id_seq OWNED BY shippingrequest.id;
3846+
3847 CREATE TABLE shippingrun (
3848 id integer NOT NULL,
3849 datecreated timestamp without time zone NOT NULL,
3850@@ -2397,6 +4315,14 @@
3851 requests_count integer NOT NULL
3852 );
3853
3854+CREATE SEQUENCE shippingrun_id_seq
3855+ INCREMENT BY 1
3856+ NO MAXVALUE
3857+ NO MINVALUE
3858+ CACHE 1;
3859+
3860+ALTER SEQUENCE shippingrun_id_seq OWNED BY shippingrun.id;
3861+
3862 CREATE TABLE signedcodeofconduct (
3863 id integer NOT NULL,
3864 owner integer NOT NULL,
3865@@ -2408,6 +4334,14 @@
3866 admincomment text
3867 );
3868
3869+CREATE SEQUENCE signedcodeofconduct_id_seq
3870+ INCREMENT BY 1
3871+ NO MAXVALUE
3872+ NO MINVALUE
3873+ CACHE 1;
3874+
3875+ALTER SEQUENCE signedcodeofconduct_id_seq OWNED BY signedcodeofconduct.id;
3876+
3877 CREATE TABLE sourcepackagereleasefile (
3878 sourcepackagerelease integer NOT NULL,
3879 libraryfile integer NOT NULL,
3880@@ -2418,9 +4352,33 @@
3881 CREATE VIEW sourcepackagefilepublishing AS
3882 SELECT (((libraryfilealias.id)::text || '.'::text) || (securesourcepackagepublishinghistory.id)::text) AS id, distroseries.distribution, securesourcepackagepublishinghistory.id AS sourcepackagepublishing, sourcepackagereleasefile.libraryfile AS libraryfilealias, libraryfilealias.filename AS libraryfilealiasfilename, sourcepackagename.name AS sourcepackagename, component.name AS componentname, distroseries.name AS distroseriesname, securesourcepackagepublishinghistory.status AS publishingstatus, securesourcepackagepublishinghistory.pocket, securesourcepackagepublishinghistory.archive FROM ((((((securesourcepackagepublishinghistory JOIN sourcepackagerelease ON ((securesourcepackagepublishinghistory.sourcepackagerelease = sourcepackagerelease.id))) JOIN sourcepackagename ON ((sourcepackagerelease.sourcepackagename = sourcepackagename.id))) JOIN sourcepackagereleasefile ON ((sourcepackagereleasefile.sourcepackagerelease = sourcepackagerelease.id))) JOIN libraryfilealias ON ((libraryfilealias.id = sourcepackagereleasefile.libraryfile))) JOIN distroseries ON ((securesourcepackagepublishinghistory.distroseries = distroseries.id))) JOIN component ON ((securesourcepackagepublishinghistory.component = component.id))) WHERE (securesourcepackagepublishinghistory.dateremoved IS NULL);
3883
3884+CREATE SEQUENCE sourcepackagename_id_seq
3885+ INCREMENT BY 1
3886+ NO MAXVALUE
3887+ NO MINVALUE
3888+ CACHE 1;
3889+
3890+ALTER SEQUENCE sourcepackagename_id_seq OWNED BY sourcepackagename.id;
3891+
3892 CREATE VIEW sourcepackagepublishinghistory AS
3893 SELECT securesourcepackagepublishinghistory.id, securesourcepackagepublishinghistory.sourcepackagerelease, securesourcepackagepublishinghistory.status, securesourcepackagepublishinghistory.component, securesourcepackagepublishinghistory.section, securesourcepackagepublishinghistory.distroseries, securesourcepackagepublishinghistory.pocket, securesourcepackagepublishinghistory.archive, securesourcepackagepublishinghistory.datecreated, securesourcepackagepublishinghistory.datepublished, securesourcepackagepublishinghistory.datesuperseded, securesourcepackagepublishinghistory.supersededby, securesourcepackagepublishinghistory.datemadepending, securesourcepackagepublishinghistory.scheduleddeletiondate, securesourcepackagepublishinghistory.dateremoved, securesourcepackagepublishinghistory.removed_by, securesourcepackagepublishinghistory.removal_comment, securesourcepackagepublishinghistory.embargo, securesourcepackagepublishinghistory.embargolifted FROM securesourcepackagepublishinghistory WHERE (securesourcepackagepublishinghistory.embargo = false);
3894
3895+CREATE SEQUENCE sourcepackagerelease_id_seq
3896+ INCREMENT BY 1
3897+ NO MAXVALUE
3898+ NO MINVALUE
3899+ CACHE 1;
3900+
3901+ALTER SEQUENCE sourcepackagerelease_id_seq OWNED BY sourcepackagerelease.id;
3902+
3903+CREATE SEQUENCE sourcepackagereleasefile_id_seq
3904+ INCREMENT BY 1
3905+ NO MAXVALUE
3906+ NO MINVALUE
3907+ CACHE 1;
3908+
3909+ALTER SEQUENCE sourcepackagereleasefile_id_seq OWNED BY sourcepackagereleasefile.id;
3910+
3911 CREATE TABLE specification (
3912 id integer NOT NULL,
3913 name text NOT NULL,
3914@@ -2469,6 +4427,14 @@
3915 CONSTRAINT valid_url CHECK (valid_absolute_url(specurl))
3916 );
3917
3918+CREATE SEQUENCE specification_id_seq
3919+ INCREMENT BY 1
3920+ NO MAXVALUE
3921+ NO MINVALUE
3922+ CACHE 1;
3923+
3924+ALTER SEQUENCE specification_id_seq OWNED BY specification.id;
3925+
3926 CREATE TABLE specificationbranch (
3927 id integer NOT NULL,
3928 datecreated timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
3929@@ -2478,12 +4444,28 @@
3930 registrant integer NOT NULL
3931 );
3932
3933+CREATE SEQUENCE specificationbranch_id_seq
3934+ INCREMENT BY 1
3935+ NO MAXVALUE
3936+ NO MINVALUE
3937+ CACHE 1;
3938+
3939+ALTER SEQUENCE specificationbranch_id_seq OWNED BY specificationbranch.id;
3940+
3941 CREATE TABLE specificationbug (
3942 id integer NOT NULL,
3943 specification integer NOT NULL,
3944 bug integer NOT NULL
3945 );
3946
3947+CREATE SEQUENCE specificationbug_id_seq
3948+ INCREMENT BY 1
3949+ NO MAXVALUE
3950+ NO MINVALUE
3951+ CACHE 1;
3952+
3953+ALTER SEQUENCE specificationbug_id_seq OWNED BY specificationbug.id;
3954+
3955 CREATE TABLE specificationdependency (
3956 id integer NOT NULL,
3957 specification integer NOT NULL,
3958@@ -2492,6 +4474,14 @@
3959 CONSTRAINT specificationdependency_not_self CHECK ((specification <> dependency))
3960 );
3961
3962+CREATE SEQUENCE specificationdependency_id_seq
3963+ INCREMENT BY 1
3964+ NO MAXVALUE
3965+ NO MINVALUE
3966+ CACHE 1;
3967+
3968+ALTER SEQUENCE specificationdependency_id_seq OWNED BY specificationdependency.id;
3969+
3970 CREATE TABLE specificationfeedback (
3971 id integer NOT NULL,
3972 specification integer NOT NULL,
3973@@ -2501,12 +4491,28 @@
3974 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
3975 );
3976
3977+CREATE SEQUENCE specificationfeedback_id_seq
3978+ INCREMENT BY 1
3979+ NO MAXVALUE
3980+ NO MINVALUE
3981+ CACHE 1;
3982+
3983+ALTER SEQUENCE specificationfeedback_id_seq OWNED BY specificationfeedback.id;
3984+
3985 CREATE TABLE specificationmessage (
3986 id integer NOT NULL,
3987 specification integer,
3988 message integer
3989 );
3990
3991+CREATE SEQUENCE specificationmessage_id_seq
3992+ INCREMENT BY 1
3993+ NO MAXVALUE
3994+ NO MINVALUE
3995+ CACHE 1;
3996+
3997+ALTER SEQUENCE specificationmessage_id_seq OWNED BY specificationmessage.id;
3998+
3999 CREATE TABLE specificationsubscription (
4000 id integer NOT NULL,
4001 specification integer NOT NULL,
4002@@ -2515,12 +4521,28 @@
4003 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
4004 );
4005
4006+CREATE SEQUENCE specificationsubscription_id_seq
4007+ INCREMENT BY 1
4008+ NO MAXVALUE
4009+ NO MINVALUE
4010+ CACHE 1;
4011+
4012+ALTER SEQUENCE specificationsubscription_id_seq OWNED BY specificationsubscription.id;
4013+
4014 CREATE TABLE spokenin (
4015 language integer NOT NULL,
4016 country integer NOT NULL,
4017 id integer DEFAULT nextval(('spokenin_id_seq'::text)::regclass) NOT NULL
4018 );
4019
4020+CREATE SEQUENCE spokenin_id_seq
4021+ INCREMENT BY 1
4022+ NO MAXVALUE
4023+ NO MINVALUE
4024+ CACHE 1;
4025+
4026+ALTER SEQUENCE spokenin_id_seq OWNED BY spokenin.id;
4027+
4028 CREATE TABLE sprint (
4029 id integer NOT NULL,
4030 owner integer NOT NULL,
4031@@ -2541,6 +4563,14 @@
4032 CONSTRAINT sprint_starts_before_ends CHECK ((time_starts < time_ends))
4033 );
4034
4035+CREATE SEQUENCE sprint_id_seq
4036+ INCREMENT BY 1
4037+ NO MAXVALUE
4038+ NO MINVALUE
4039+ CACHE 1;
4040+
4041+ALTER SEQUENCE sprint_id_seq OWNED BY sprint.id;
4042+
4043 CREATE TABLE sprintattendance (
4044 id integer NOT NULL,
4045 attendee integer NOT NULL,
4046@@ -2551,6 +4581,14 @@
4047 CONSTRAINT sprintattendance_starts_before_ends CHECK ((time_starts < time_ends))
4048 );
4049
4050+CREATE SEQUENCE sprintattendance_id_seq
4051+ INCREMENT BY 1
4052+ NO MAXVALUE
4053+ NO MINVALUE
4054+ CACHE 1;
4055+
4056+ALTER SEQUENCE sprintattendance_id_seq OWNED BY sprintattendance.id;
4057+
4058 CREATE TABLE sprintspecification (
4059 id integer NOT NULL,
4060 sprint integer NOT NULL,
4061@@ -2564,6 +4602,14 @@
4062 CONSTRAINT sprintspecification_decision_recorded CHECK (((status = 30) OR ((decider IS NOT NULL) AND (date_decided IS NOT NULL))))
4063 );
4064
4065+CREATE SEQUENCE sprintspecification_id_seq
4066+ INCREMENT BY 1
4067+ NO MAXVALUE
4068+ NO MINVALUE
4069+ CACHE 1;
4070+
4071+ALTER SEQUENCE sprintspecification_id_seq OWNED BY sprintspecification.id;
4072+
4073 CREATE TABLE sshkey (
4074 id integer NOT NULL,
4075 person integer,
4076@@ -2573,6 +4619,14 @@
4077 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
4078 );
4079
4080+CREATE SEQUENCE sshkey_id_seq
4081+ INCREMENT BY 1
4082+ NO MAXVALUE
4083+ NO MINVALUE
4084+ CACHE 1;
4085+
4086+ALTER SEQUENCE sshkey_id_seq OWNED BY sshkey.id;
4087+
4088 CREATE TABLE standardshipitrequest (
4089 id integer NOT NULL,
4090 quantityx86 integer NOT NULL,
4091@@ -2586,6 +4640,29 @@
4092 CONSTRAINT quantityx86_is_positive CHECK ((quantityx86 >= 0))
4093 );
4094
4095+CREATE SEQUENCE standardshipitrequest_id_seq
4096+ INCREMENT BY 1
4097+ NO MAXVALUE
4098+ NO MINVALUE
4099+ CACHE 1;
4100+
4101+ALTER SEQUENCE standardshipitrequest_id_seq OWNED BY standardshipitrequest.id;
4102+
4103+CREATE TABLE staticdiff (
4104+ id integer NOT NULL,
4105+ from_revision_id text NOT NULL,
4106+ to_revision_id text NOT NULL,
4107+ diff integer NOT NULL
4108+);
4109+
4110+CREATE SEQUENCE staticdiff_id_seq
4111+ INCREMENT BY 1
4112+ NO MAXVALUE
4113+ NO MINVALUE
4114+ CACHE 1;
4115+
4116+ALTER SEQUENCE staticdiff_id_seq OWNED BY staticdiff.id;
4117+
4118 CREATE TABLE structuralsubscription (
4119 id integer NOT NULL,
4120 product integer,
4121@@ -2605,6 +4682,14 @@
4122 CONSTRAINT sourcepackagename_requires_distribution CHECK (((sourcepackagename IS NULL) OR (distribution IS NOT NULL)))
4123 );
4124
4125+CREATE SEQUENCE structuralsubscription_id_seq
4126+ INCREMENT BY 1
4127+ NO MAXVALUE
4128+ NO MINVALUE
4129+ CACHE 1;
4130+
4131+ALTER SEQUENCE structuralsubscription_id_seq OWNED BY structuralsubscription.id;
4132+
4133 CREATE TABLE teammembership (
4134 id integer NOT NULL,
4135 person integer NOT NULL,
4136@@ -2627,12 +4712,28 @@
4137 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
4138 );
4139
4140+CREATE SEQUENCE teammembership_id_seq
4141+ INCREMENT BY 1
4142+ NO MAXVALUE
4143+ NO MINVALUE
4144+ CACHE 1;
4145+
4146+ALTER SEQUENCE teammembership_id_seq OWNED BY teammembership.id;
4147+
4148 CREATE TABLE teamparticipation (
4149 id integer NOT NULL,
4150 team integer NOT NULL,
4151 person integer NOT NULL
4152 );
4153
4154+CREATE SEQUENCE teamparticipation_id_seq
4155+ INCREMENT BY 1
4156+ NO MAXVALUE
4157+ NO MINVALUE
4158+ CACHE 1;
4159+
4160+ALTER SEQUENCE teamparticipation_id_seq OWNED BY teamparticipation.id;
4161+
4162 CREATE TABLE temporaryblobstorage (
4163 id integer NOT NULL,
4164 uuid text NOT NULL,
4165@@ -2640,15 +4741,32 @@
4166 file_alias integer NOT NULL
4167 );
4168
4169+CREATE SEQUENCE temporaryblobstorage_id_seq
4170+ INCREMENT BY 1
4171+ NO MAXVALUE
4172+ NO MINVALUE
4173+ CACHE 1;
4174+
4175+ALTER SEQUENCE temporaryblobstorage_id_seq OWNED BY temporaryblobstorage.id;
4176+
4177 CREATE TABLE translationgroup (
4178 id integer NOT NULL,
4179 name text NOT NULL,
4180 title text,
4181 summary text,
4182 datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
4183- owner integer NOT NULL
4184+ owner integer NOT NULL,
4185+ translation_guide_url text
4186 );
4187
4188+CREATE SEQUENCE translationgroup_id_seq
4189+ INCREMENT BY 1
4190+ NO MAXVALUE
4191+ NO MINVALUE
4192+ CACHE 1;
4193+
4194+ALTER SEQUENCE translationgroup_id_seq OWNED BY translationgroup.id;
4195+
4196 CREATE TABLE translationimportqueueentry (
4197 id integer NOT NULL,
4198 path text NOT NULL,
4199@@ -2664,9 +4782,54 @@
4200 status integer DEFAULT 5 NOT NULL,
4201 date_status_changed timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
4202 format integer DEFAULT 1 NOT NULL,
4203+ error_output text,
4204 CONSTRAINT valid_link CHECK ((((productseries IS NULL) <> (distroseries IS NULL)) AND ((distroseries IS NULL) = (sourcepackagename IS NULL))))
4205 );
4206
4207+CREATE SEQUENCE translationimportqueueentry_id_seq
4208+ INCREMENT BY 1
4209+ NO MAXVALUE
4210+ NO MINVALUE
4211+ CACHE 1;
4212+
4213+ALTER SEQUENCE translationimportqueueentry_id_seq OWNED BY translationimportqueueentry.id;
4214+
4215+CREATE TABLE translationmessage (
4216+ id integer NOT NULL,
4217+ pofile integer,
4218+ potmsgset integer NOT NULL,
4219+ date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
4220+ submitter integer NOT NULL,
4221+ date_reviewed timestamp without time zone,
4222+ reviewer integer,
4223+ msgstr0 integer,
4224+ msgstr1 integer,
4225+ msgstr2 integer,
4226+ msgstr3 integer,
4227+ comment text,
4228+ origin integer NOT NULL,
4229+ validation_status integer DEFAULT 0 NOT NULL,
4230+ is_current boolean DEFAULT false NOT NULL,
4231+ is_fuzzy boolean DEFAULT false NOT NULL,
4232+ is_imported boolean DEFAULT false NOT NULL,
4233+ was_obsolete_in_last_import boolean DEFAULT false NOT NULL,
4234+ was_fuzzy_in_last_import boolean DEFAULT false NOT NULL,
4235+ msgstr4 integer,
4236+ msgstr5 integer,
4237+ potemplate integer,
4238+ language integer,
4239+ variant text,
4240+ CONSTRAINT translationmessage__reviewer__date_reviewed__valid CHECK (((reviewer IS NULL) = (date_reviewed IS NULL)))
4241+);
4242+
4243+CREATE SEQUENCE translationmessage_id_seq
4244+ INCREMENT BY 1
4245+ NO MAXVALUE
4246+ NO MINVALUE
4247+ CACHE 1;
4248+
4249+ALTER SEQUENCE translationmessage_id_seq OWNED BY translationmessage.id;
4250+
4251 CREATE TABLE translationrelicensingagreement (
4252 id integer NOT NULL,
4253 person integer NOT NULL,
4254@@ -2674,21 +4837,55 @@
4255 date_decided timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
4256 );
4257
4258-CREATE TABLE translationtemplateitem (
4259- id integer NOT NULL,
4260- potemplate integer NOT NULL,
4261- sequence integer NOT NULL,
4262- potmsgset integer NOT NULL,
4263- CONSTRAINT translationtemplateitem_sequence_check CHECK ((sequence > 0))
4264-);
4265+CREATE SEQUENCE translationrelicensingagreement_id_seq
4266+ INCREMENT BY 1
4267+ NO MAXVALUE
4268+ NO MINVALUE
4269+ CACHE 1;
4270+
4271+ALTER SEQUENCE translationrelicensingagreement_id_seq OWNED BY translationrelicensingagreement.id;
4272+
4273+CREATE SEQUENCE translationtemplateitem_id_seq
4274+ INCREMENT BY 1
4275+ NO MAXVALUE
4276+ NO MINVALUE
4277+ CACHE 1;
4278+
4279+ALTER SEQUENCE translationtemplateitem_id_seq OWNED BY translationtemplateitem.id;
4280
4281 CREATE TABLE translator (
4282 id integer NOT NULL,
4283 translationgroup integer NOT NULL,
4284 language integer NOT NULL,
4285 translator integer NOT NULL,
4286- datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL
4287-);
4288+ datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
4289+ style_guide_url text
4290+);
4291+
4292+CREATE SEQUENCE translator_id_seq
4293+ INCREMENT BY 1
4294+ NO MAXVALUE
4295+ NO MINVALUE
4296+ CACHE 1;
4297+
4298+ALTER SEQUENCE translator_id_seq OWNED BY translator.id;
4299+
4300+CREATE TABLE usertouseremail (
4301+ id integer NOT NULL,
4302+ sender integer NOT NULL,
4303+ recipient integer NOT NULL,
4304+ date_sent timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
4305+ subject text NOT NULL,
4306+ message_id text NOT NULL
4307+);
4308+
4309+CREATE SEQUENCE usertouseremail_id_seq
4310+ INCREMENT BY 1
4311+ NO MAXVALUE
4312+ NO MINVALUE
4313+ CACHE 1;
4314+
4315+ALTER SEQUENCE usertouseremail_id_seq OWNED BY usertouseremail.id;
4316
4317 CREATE VIEW validpersoncache AS
4318 SELECT emailaddress.person AS id FROM emailaddress, account WHERE ((((emailaddress.account = account.id) AND (emailaddress.person IS NOT NULL)) AND (emailaddress.status = 4)) AND (account.status = 20));
4319@@ -2705,12 +4902,28 @@
4320 token text NOT NULL
4321 );
4322
4323+CREATE SEQUENCE vote_id_seq
4324+ INCREMENT BY 1
4325+ NO MAXVALUE
4326+ NO MINVALUE
4327+ CACHE 1;
4328+
4329+ALTER SEQUENCE vote_id_seq OWNED BY vote.id;
4330+
4331 CREATE TABLE votecast (
4332 id integer NOT NULL,
4333 person integer NOT NULL,
4334 poll integer NOT NULL
4335 );
4336
4337+CREATE SEQUENCE votecast_id_seq
4338+ INCREMENT BY 1
4339+ NO MAXVALUE
4340+ NO MINVALUE
4341+ CACHE 1;
4342+
4343+ALTER SEQUENCE votecast_id_seq OWNED BY votecast.id;
4344+
4345 CREATE TABLE webserviceban (
4346 id integer NOT NULL,
4347 date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()),
4348@@ -2723,6 +4936,14 @@
4349 CONSTRAINT person_or_consumer_or_token_or_none CHECK ((null_count(ARRAY[person, consumer, token]) >= 2))
4350 );
4351
4352+CREATE SEQUENCE webserviceban_id_seq
4353+ INCREMENT BY 1
4354+ NO MAXVALUE
4355+ NO MINVALUE
4356+ CACHE 1;
4357+
4358+ALTER SEQUENCE webserviceban_id_seq OWNED BY webserviceban.id;
4359+
4360 CREATE TABLE wikiname (
4361 id integer NOT NULL,
4362 person integer NOT NULL,
4363@@ -2730,1864 +4951,6 @@
4364 wikiname text NOT NULL
4365 );
4366
4367-CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
4368- AS '$libdir/plpgsql', 'plpgsql_call_handler'
4369- LANGUAGE c;
4370-
4371-CREATE FUNCTION plpython_call_handler() RETURNS language_handler
4372- AS '$libdir/plpython', 'plpython_call_handler'
4373- LANGUAGE c;
4374-
4375-CREATE SEQUENCE account_id_seq
4376- INCREMENT BY 1
4377- NO MAXVALUE
4378- NO MINVALUE
4379- CACHE 1;
4380-
4381-ALTER SEQUENCE account_id_seq OWNED BY account.id;
4382-
4383-CREATE SEQUENCE accountpassword_id_seq
4384- INCREMENT BY 1
4385- NO MAXVALUE
4386- NO MINVALUE
4387- CACHE 1;
4388-
4389-ALTER SEQUENCE accountpassword_id_seq OWNED BY accountpassword.id;
4390-
4391-CREATE SEQUENCE announcement_id_seq
4392- INCREMENT BY 1
4393- NO MAXVALUE
4394- NO MINVALUE
4395- CACHE 1;
4396-
4397-ALTER SEQUENCE announcement_id_seq OWNED BY announcement.id;
4398-
4399-CREATE SEQUENCE answercontact_id_seq
4400- INCREMENT BY 1
4401- NO MAXVALUE
4402- NO MINVALUE
4403- CACHE 1;
4404-
4405-ALTER SEQUENCE answercontact_id_seq OWNED BY answercontact.id;
4406-
4407-CREATE SEQUENCE archive_id_seq
4408- INCREMENT BY 1
4409- NO MAXVALUE
4410- NO MINVALUE
4411- CACHE 1;
4412-
4413-ALTER SEQUENCE archive_id_seq OWNED BY archive.id;
4414-
4415-CREATE SEQUENCE archivearch_id_seq
4416- START WITH 1
4417- INCREMENT BY 1
4418- NO MAXVALUE
4419- NO MINVALUE
4420- CACHE 1;
4421-
4422-ALTER SEQUENCE archivearch_id_seq OWNED BY archivearch.id;
4423-
4424-CREATE SEQUENCE archiveauthtoken_id_seq
4425- START WITH 1
4426- INCREMENT BY 1
4427- NO MAXVALUE
4428- NO MINVALUE
4429- CACHE 1;
4430-
4431-ALTER SEQUENCE archiveauthtoken_id_seq OWNED BY archiveauthtoken.id;
4432-
4433-CREATE SEQUENCE archivedependency_id_seq
4434- INCREMENT BY 1
4435- NO MAXVALUE
4436- NO MINVALUE
4437- CACHE 1;
4438-
4439-ALTER SEQUENCE archivedependency_id_seq OWNED BY archivedependency.id;
4440-
4441-CREATE SEQUENCE archivepermission_id_seq
4442- INCREMENT BY 1
4443- NO MAXVALUE
4444- NO MINVALUE
4445- CACHE 1;
4446-
4447-ALTER SEQUENCE archivepermission_id_seq OWNED BY archivepermission.id;
4448-
4449-CREATE SEQUENCE archivesubscriber_id_seq
4450- START WITH 1
4451- INCREMENT BY 1
4452- NO MAXVALUE
4453- NO MINVALUE
4454- CACHE 1;
4455-
4456-ALTER SEQUENCE archivesubscriber_id_seq OWNED BY archivesubscriber.id;
4457-
4458-CREATE SEQUENCE binarypackagefile_id_seq
4459- INCREMENT BY 1
4460- NO MAXVALUE
4461- NO MINVALUE
4462- CACHE 1;
4463-
4464-CREATE SEQUENCE binarypackagename_id_seq
4465- INCREMENT BY 1
4466- NO MAXVALUE
4467- NO MINVALUE
4468- CACHE 1;
4469-
4470-ALTER SEQUENCE binarypackagename_id_seq OWNED BY binarypackagename.id;
4471-
4472-CREATE SEQUENCE binarypackagerelease_id_seq
4473- INCREMENT BY 1
4474- NO MAXVALUE
4475- NO MINVALUE
4476- CACHE 1;
4477-
4478-ALTER SEQUENCE binarypackagerelease_id_seq OWNED BY binarypackagerelease.id;
4479-
4480-CREATE SEQUENCE bounty_id_seq
4481- INCREMENT BY 1
4482- NO MAXVALUE
4483- NO MINVALUE
4484- CACHE 1;
4485-
4486-ALTER SEQUENCE bounty_id_seq OWNED BY bounty.id;
4487-
4488-CREATE SEQUENCE bountymessage_id_seq
4489- INCREMENT BY 1
4490- NO MAXVALUE
4491- NO MINVALUE
4492- CACHE 1;
4493-
4494-ALTER SEQUENCE bountymessage_id_seq OWNED BY bountymessage.id;
4495-
4496-CREATE SEQUENCE bountysubscription_id_seq
4497- INCREMENT BY 1
4498- NO MAXVALUE
4499- NO MINVALUE
4500- CACHE 1;
4501-
4502-ALTER SEQUENCE bountysubscription_id_seq OWNED BY bountysubscription.id;
4503-
4504-CREATE SEQUENCE branch_id_seq
4505- INCREMENT BY 1
4506- NO MAXVALUE
4507- NO MINVALUE
4508- CACHE 1;
4509-
4510-ALTER SEQUENCE branch_id_seq OWNED BY branch.id;
4511-
4512-CREATE SEQUENCE branchmergeproposal_id_seq
4513- INCREMENT BY 1
4514- NO MAXVALUE
4515- NO MINVALUE
4516- CACHE 1;
4517-
4518-ALTER SEQUENCE branchmergeproposal_id_seq OWNED BY branchmergeproposal.id;
4519-
4520-CREATE SEQUENCE branchmergerobot_id_seq
4521- START WITH 1
4522- INCREMENT BY 1
4523- NO MAXVALUE
4524- NO MINVALUE
4525- CACHE 1;
4526-
4527-ALTER SEQUENCE branchmergerobot_id_seq OWNED BY branchmergerobot.id;
4528-
4529-CREATE SEQUENCE branchrelationship_id_seq
4530- START WITH 1
4531- INCREMENT BY 1
4532- NO MAXVALUE
4533- NO MINVALUE
4534- CACHE 1;
4535-
4536-CREATE SEQUENCE branchrevision_id_seq
4537- INCREMENT BY 1
4538- NO MAXVALUE
4539- NO MINVALUE
4540- CACHE 1;
4541-
4542-ALTER SEQUENCE branchrevision_id_seq OWNED BY branchrevision.id;
4543-
4544-CREATE SEQUENCE branchsubscription_id_seq
4545- INCREMENT BY 1
4546- NO MAXVALUE
4547- NO MINVALUE
4548- CACHE 1;
4549-
4550-ALTER SEQUENCE branchsubscription_id_seq OWNED BY branchsubscription.id;
4551-
4552-CREATE SEQUENCE branchvisibilitypolicy_id_seq
4553- INCREMENT BY 1
4554- NO MAXVALUE
4555- NO MINVALUE
4556- CACHE 1;
4557-
4558-ALTER SEQUENCE branchvisibilitypolicy_id_seq OWNED BY branchvisibilitypolicy.id;
4559-
4560-CREATE SEQUENCE bug_id_seq
4561- INCREMENT BY 1
4562- NO MAXVALUE
4563- NO MINVALUE
4564- CACHE 1;
4565-
4566-ALTER SEQUENCE bug_id_seq OWNED BY bug.id;
4567-
4568-CREATE SEQUENCE bugactivity_id_seq
4569- INCREMENT BY 1
4570- NO MAXVALUE
4571- NO MINVALUE
4572- CACHE 1;
4573-
4574-ALTER SEQUENCE bugactivity_id_seq OWNED BY bugactivity.id;
4575-
4576-CREATE SEQUENCE bugaffectsperson_id_seq
4577- START WITH 1
4578- INCREMENT BY 1
4579- NO MAXVALUE
4580- NO MINVALUE
4581- CACHE 1;
4582-
4583-ALTER SEQUENCE bugaffectsperson_id_seq OWNED BY bugaffectsperson.id;
4584-
4585-CREATE SEQUENCE bugattachment_id_seq
4586- INCREMENT BY 1
4587- NO MAXVALUE
4588- NO MINVALUE
4589- CACHE 1;
4590-
4591-ALTER SEQUENCE bugattachment_id_seq OWNED BY bugattachment.id;
4592-
4593-CREATE SEQUENCE bugbranch_id_seq
4594- INCREMENT BY 1
4595- NO MAXVALUE
4596- NO MINVALUE
4597- CACHE 1;
4598-
4599-ALTER SEQUENCE bugbranch_id_seq OWNED BY bugbranch.id;
4600-
4601-CREATE SEQUENCE bugcve_id_seq
4602- INCREMENT BY 1
4603- NO MAXVALUE
4604- NO MINVALUE
4605- CACHE 1;
4606-
4607-ALTER SEQUENCE bugcve_id_seq OWNED BY bugcve.id;
4608-
4609-CREATE SEQUENCE bugmessage_id_seq
4610- INCREMENT BY 1
4611- NO MAXVALUE
4612- NO MINVALUE
4613- CACHE 1;
4614-
4615-ALTER SEQUENCE bugmessage_id_seq OWNED BY bugmessage.id;
4616-
4617-CREATE SEQUENCE bugnomination_id_seq
4618- INCREMENT BY 1
4619- NO MAXVALUE
4620- NO MINVALUE
4621- CACHE 1;
4622-
4623-ALTER SEQUENCE bugnomination_id_seq OWNED BY bugnomination.id;
4624-
4625-CREATE SEQUENCE bugnotification_id_seq
4626- INCREMENT BY 1
4627- NO MAXVALUE
4628- NO MINVALUE
4629- CACHE 1;
4630-
4631-ALTER SEQUENCE bugnotification_id_seq OWNED BY bugnotification.id;
4632-
4633-CREATE SEQUENCE bugnotificationrecipient_id_seq
4634- INCREMENT BY 1
4635- NO MAXVALUE
4636- NO MINVALUE
4637- CACHE 1;
4638-
4639-ALTER SEQUENCE bugnotificationrecipient_id_seq OWNED BY bugnotificationrecipient.id;
4640-
4641-CREATE SEQUENCE bugpackageinfestation_id_seq
4642- START WITH 1
4643- INCREMENT BY 1
4644- NO MAXVALUE
4645- NO MINVALUE
4646- CACHE 1;
4647-
4648-ALTER SEQUENCE bugpackageinfestation_id_seq OWNED BY bugpackageinfestation.id;
4649-
4650-CREATE SEQUENCE bugproductinfestation_id_seq
4651- START WITH 1
4652- INCREMENT BY 1
4653- NO MAXVALUE
4654- NO MINVALUE
4655- CACHE 1;
4656-
4657-ALTER SEQUENCE bugproductinfestation_id_seq OWNED BY bugproductinfestation.id;
4658-
4659-CREATE SEQUENCE bugsubscription_id_seq
4660- INCREMENT BY 1
4661- NO MAXVALUE
4662- NO MINVALUE
4663- CACHE 1;
4664-
4665-ALTER SEQUENCE bugsubscription_id_seq OWNED BY bugsubscription.id;
4666-
4667-CREATE SEQUENCE bugtag_id_seq
4668- INCREMENT BY 1
4669- NO MAXVALUE
4670- NO MINVALUE
4671- CACHE 1;
4672-
4673-ALTER SEQUENCE bugtag_id_seq OWNED BY bugtag.id;
4674-
4675-CREATE SEQUENCE bugtask_id_seq
4676- INCREMENT BY 1
4677- NO MAXVALUE
4678- NO MINVALUE
4679- CACHE 1;
4680-
4681-ALTER SEQUENCE bugtask_id_seq OWNED BY bugtask.id;
4682-
4683-CREATE SEQUENCE bugtracker_id_seq
4684- INCREMENT BY 1
4685- NO MAXVALUE
4686- NO MINVALUE
4687- CACHE 1;
4688-
4689-ALTER SEQUENCE bugtracker_id_seq OWNED BY bugtracker.id;
4690-
4691-CREATE SEQUENCE bugtrackeralias_id_seq
4692- INCREMENT BY 1
4693- NO MAXVALUE
4694- NO MINVALUE
4695- CACHE 1;
4696-
4697-ALTER SEQUENCE bugtrackeralias_id_seq OWNED BY bugtrackeralias.id;
4698-
4699-CREATE SEQUENCE bugtrackerperson_id_seq
4700- START WITH 1
4701- INCREMENT BY 1
4702- NO MAXVALUE
4703- NO MINVALUE
4704- CACHE 1;
4705-
4706-ALTER SEQUENCE bugtrackerperson_id_seq OWNED BY bugtrackerperson.id;
4707-
4708-CREATE SEQUENCE bugwatch_id_seq
4709- INCREMENT BY 1
4710- NO MAXVALUE
4711- NO MINVALUE
4712- CACHE 1;
4713-
4714-ALTER SEQUENCE bugwatch_id_seq OWNED BY bugwatch.id;
4715-
4716-CREATE SEQUENCE build_id_seq
4717- INCREMENT BY 1
4718- NO MAXVALUE
4719- NO MINVALUE
4720- CACHE 1;
4721-
4722-ALTER SEQUENCE build_id_seq OWNED BY build.id;
4723-
4724-CREATE SEQUENCE builder_id_seq
4725- INCREMENT BY 1
4726- NO MAXVALUE
4727- NO MINVALUE
4728- CACHE 1;
4729-
4730-ALTER SEQUENCE builder_id_seq OWNED BY builder.id;
4731-
4732-CREATE SEQUENCE buildqueue_id_seq
4733- INCREMENT BY 1
4734- NO MAXVALUE
4735- NO MINVALUE
4736- CACHE 1;
4737-
4738-ALTER SEQUENCE buildqueue_id_seq OWNED BY buildqueue.id;
4739-
4740-CREATE SEQUENCE codeimport_id_seq
4741- INCREMENT BY 1
4742- NO MAXVALUE
4743- NO MINVALUE
4744- CACHE 1;
4745-
4746-ALTER SEQUENCE codeimport_id_seq OWNED BY codeimport.id;
4747-
4748-CREATE SEQUENCE codeimportevent_id_seq
4749- INCREMENT BY 1
4750- NO MAXVALUE
4751- NO MINVALUE
4752- CACHE 1;
4753-
4754-ALTER SEQUENCE codeimportevent_id_seq OWNED BY codeimportevent.id;
4755-
4756-CREATE SEQUENCE codeimporteventdata_id_seq
4757- INCREMENT BY 1
4758- NO MAXVALUE
4759- NO MINVALUE
4760- CACHE 1;
4761-
4762-ALTER SEQUENCE codeimporteventdata_id_seq OWNED BY codeimporteventdata.id;
4763-
4764-CREATE SEQUENCE codeimportjob_id_seq
4765- INCREMENT BY 1
4766- NO MAXVALUE
4767- NO MINVALUE
4768- CACHE 1;
4769-
4770-ALTER SEQUENCE codeimportjob_id_seq OWNED BY codeimportjob.id;
4771-
4772-CREATE SEQUENCE codeimportmachine_id_seq
4773- INCREMENT BY 1
4774- NO MAXVALUE
4775- NO MINVALUE
4776- CACHE 1;
4777-
4778-ALTER SEQUENCE codeimportmachine_id_seq OWNED BY codeimportmachine.id;
4779-
4780-CREATE SEQUENCE codeimportresult_id_seq
4781- INCREMENT BY 1
4782- NO MAXVALUE
4783- NO MINVALUE
4784- CACHE 1;
4785-
4786-ALTER SEQUENCE codeimportresult_id_seq OWNED BY codeimportresult.id;
4787-
4788-CREATE SEQUENCE codereviewmessage_id_seq
4789- INCREMENT BY 1
4790- NO MAXVALUE
4791- NO MINVALUE
4792- CACHE 1;
4793-
4794-ALTER SEQUENCE codereviewmessage_id_seq OWNED BY codereviewmessage.id;
4795-
4796-CREATE SEQUENCE codereviewvote_id_seq
4797- INCREMENT BY 1
4798- NO MAXVALUE
4799- NO MINVALUE
4800- CACHE 1;
4801-
4802-ALTER SEQUENCE codereviewvote_id_seq OWNED BY codereviewvote.id;
4803-
4804-CREATE SEQUENCE commercialsubscription_id_seq
4805- INCREMENT BY 1
4806- NO MAXVALUE
4807- NO MINVALUE
4808- CACHE 1;
4809-
4810-ALTER SEQUENCE commercialsubscription_id_seq OWNED BY commercialsubscription.id;
4811-
4812-CREATE SEQUENCE component_id_seq
4813- INCREMENT BY 1
4814- NO MAXVALUE
4815- NO MINVALUE
4816- CACHE 1;
4817-
4818-ALTER SEQUENCE component_id_seq OWNED BY component.id;
4819-
4820-CREATE SEQUENCE componentselection_id_seq
4821- INCREMENT BY 1
4822- NO MAXVALUE
4823- NO MINVALUE
4824- CACHE 1;
4825-
4826-ALTER SEQUENCE componentselection_id_seq OWNED BY componentselection.id;
4827-
4828-CREATE SEQUENCE continent_id_seq
4829- START WITH 1
4830- INCREMENT BY 1
4831- NO MAXVALUE
4832- NO MINVALUE
4833- CACHE 1;
4834-
4835-ALTER SEQUENCE continent_id_seq OWNED BY continent.id;
4836-
4837-CREATE SEQUENCE country_id_seq
4838- INCREMENT BY 1
4839- NO MAXVALUE
4840- NO MINVALUE
4841- CACHE 1;
4842-
4843-ALTER SEQUENCE country_id_seq OWNED BY country.id;
4844-
4845-CREATE SEQUENCE customlanguagecode_id_seq
4846- INCREMENT BY 1
4847- NO MAXVALUE
4848- NO MINVALUE
4849- CACHE 1;
4850-
4851-ALTER SEQUENCE customlanguagecode_id_seq OWNED BY customlanguagecode.id;
4852-
4853-CREATE SEQUENCE cve_id_seq
4854- INCREMENT BY 1
4855- NO MAXVALUE
4856- NO MINVALUE
4857- CACHE 1;
4858-
4859-ALTER SEQUENCE cve_id_seq OWNED BY cve.id;
4860-
4861-CREATE SEQUENCE cvereference_id_seq
4862- INCREMENT BY 1
4863- NO MAXVALUE
4864- NO MINVALUE
4865- CACHE 1;
4866-
4867-ALTER SEQUENCE cvereference_id_seq OWNED BY cvereference.id;
4868-
4869-CREATE SEQUENCE distribution_id_seq
4870- INCREMENT BY 1
4871- NO MAXVALUE
4872- NO MINVALUE
4873- CACHE 1;
4874-
4875-ALTER SEQUENCE distribution_id_seq OWNED BY distribution.id;
4876-
4877-CREATE SEQUENCE distributionbounty_id_seq
4878- INCREMENT BY 1
4879- NO MAXVALUE
4880- NO MINVALUE
4881- CACHE 1;
4882-
4883-ALTER SEQUENCE distributionbounty_id_seq OWNED BY distributionbounty.id;
4884-
4885-CREATE SEQUENCE distributionmirror_id_seq
4886- INCREMENT BY 1
4887- NO MAXVALUE
4888- NO MINVALUE
4889- CACHE 1;
4890-
4891-ALTER SEQUENCE distributionmirror_id_seq OWNED BY distributionmirror.id;
4892-
4893-CREATE SEQUENCE distributionrole_id_seq
4894- START WITH 1
4895- INCREMENT BY 1
4896- NO MAXVALUE
4897- NO MINVALUE
4898- CACHE 1;
4899-
4900-CREATE SEQUENCE distributionsourcepackage_id_seq
4901- START WITH 1
4902- INCREMENT BY 1
4903- NO MAXVALUE
4904- NO MINVALUE
4905- CACHE 1;
4906-
4907-ALTER SEQUENCE distributionsourcepackage_id_seq OWNED BY distributionsourcepackage.id;
4908-
4909-CREATE SEQUENCE distributionsourcepackagecache_id_seq
4910- INCREMENT BY 1
4911- NO MAXVALUE
4912- NO MINVALUE
4913- CACHE 1;
4914-
4915-ALTER SEQUENCE distributionsourcepackagecache_id_seq OWNED BY distributionsourcepackagecache.id;
4916-
4917-CREATE SEQUENCE distroarchseries_id_seq
4918- INCREMENT BY 1
4919- NO MAXVALUE
4920- NO MINVALUE
4921- CACHE 1;
4922-
4923-ALTER SEQUENCE distroarchseries_id_seq OWNED BY distroarchseries.id;
4924-
4925-CREATE SEQUENCE distrocomponentuploader_id_seq
4926- INCREMENT BY 1
4927- NO MAXVALUE
4928- NO MINVALUE
4929- CACHE 1;
4930-
4931-ALTER SEQUENCE distrocomponentuploader_id_seq OWNED BY distrocomponentuploader.id;
4932-
4933-CREATE SEQUENCE distroseries_id_seq
4934- INCREMENT BY 1
4935- NO MAXVALUE
4936- NO MINVALUE
4937- CACHE 1;
4938-
4939-ALTER SEQUENCE distroseries_id_seq OWNED BY distroseries.id;
4940-
4941-CREATE SEQUENCE distroserieslanguage_id_seq
4942- INCREMENT BY 1
4943- NO MAXVALUE
4944- NO MINVALUE
4945- CACHE 1;
4946-
4947-ALTER SEQUENCE distroserieslanguage_id_seq OWNED BY distroserieslanguage.id;
4948-
4949-CREATE SEQUENCE distroseriespackagecache_id_seq
4950- INCREMENT BY 1
4951- NO MAXVALUE
4952- NO MINVALUE
4953- CACHE 1;
4954-
4955-ALTER SEQUENCE distroseriespackagecache_id_seq OWNED BY distroseriespackagecache.id;
4956-
4957-CREATE SEQUENCE emailaddress_id_seq
4958- INCREMENT BY 1
4959- NO MAXVALUE
4960- NO MINVALUE
4961- CACHE 1;
4962-
4963-ALTER SEQUENCE emailaddress_id_seq OWNED BY emailaddress.id;
4964-
4965-CREATE SEQUENCE entitlement_id_seq
4966- START WITH 1
4967- INCREMENT BY 1
4968- NO MAXVALUE
4969- NO MINVALUE
4970- CACHE 1;
4971-
4972-ALTER SEQUENCE entitlement_id_seq OWNED BY entitlement.id;
4973-
4974-CREATE SEQUENCE faq_id_seq
4975- INCREMENT BY 1
4976- NO MAXVALUE
4977- NO MINVALUE
4978- CACHE 1;
4979-
4980-ALTER SEQUENCE faq_id_seq OWNED BY faq.id;
4981-
4982-CREATE SEQUENCE featuredproject_id_seq
4983- INCREMENT BY 1
4984- NO MAXVALUE
4985- NO MINVALUE
4986- CACHE 1;
4987-
4988-ALTER SEQUENCE featuredproject_id_seq OWNED BY featuredproject.id;
4989-
4990-CREATE SEQUENCE fticache_id_seq
4991- INCREMENT BY 1
4992- NO MAXVALUE
4993- NO MINVALUE
4994- CACHE 1;
4995-
4996-ALTER SEQUENCE fticache_id_seq OWNED BY fticache.id;
4997-
4998-CREATE SEQUENCE gpgkey_id_seq
4999- INCREMENT BY 1
5000- NO MAXVALUE
The diff has been truncated for viewing.