Merge lp:~andrea.corbellini/launchpad/blueprint-comments-part2 into lp:launchpad/db-devel

[Andrea Corbellini]

[Andrea Corbellini (andrea.corbellini)]

= Summary =

Bug #49698 is about giving the ability to comment on specifications.

== Proposed fix ==

This branch contains the interfaces and model changes needed.
Database schema changes can be found in
lp:~andrea-bs/launchpad/blueprint-comments-part1.

I've added two new interfaces: ISpecificationMessage and
ISpecificationMessageSet, following the bug comments' code.

== Pre-implementation notes ==

I discussed this part of the bug fix with intellectronica. He told me which
packages I had to modify and which classes I needed to write.

== Implementation details ==

lib/lp/blueprints/interfaces/specificationmessage.py:
 * Add ISpecificationMessage that represents a blueprint comment.
 * Add ISpecificationMessageSet, a set of all blueprint comments.

lib/lp/blueprints/model/specificationmessage.py:
 * Implement ISpecificationMessage and ISpecificationMessageSet.

lib/lp/blueprints/configure.zcml:
 * Add the configuration for the two new interfaces.

lib/lp/blueprints/doc/specificationmessage.txt:
 * Test comment creation and retrieval.

== Tests ==

bin/test -vv -t specificationmessage

== Demo and Q/A ==

There isn't a UI yet, so the only way to try the changes is using the doc
test.

= 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/blueprints/configure.zcml
  lib/lp/blueprints/doc/specificationmessage.txt
  lib/lp/blueprints/interfaces/specificationmessage.py
  lib/lp/blueprints/model/specificationmessage.py

[Eleanor Berger (intellectronica)]

(Here's the correct diff)

=== modified file 'lib/lp/blueprints/configure.zcml'
--- lib/lp/blueprints/configure.zcml 2009-07-13 18:15:02 +0000
+++ lib/lp/blueprints/configure.zcml 2009-08-10 09:34:05 +0000
@@ -219,6 +219,28 @@
             <allow
                 interface="lp.blueprints.interfaces.specification.ISpecificationDelta"/>
         </class>
+
+ <!-- SpecificationMessage -->
+
+ <class
+ class="lp.blueprints.model.specificationmessage.SpecificationMessage">
+ <allow
+ interface="lp.blueprints.interfaces.specificationmessage.ISpecificationMessage"/>
+ </class>
+
+ <!-- SpecificationMessageSet -->
+
+ <class
+ class="lp.blueprints.model.specificationmessage.SpecificationMessageSet">
+ <allow
+ interface="lp.blueprints.interfaces.specificationmessage.ISpecificationMessageSet"/>
+ </class>
+ <securedutility
+ class="lp.blueprints.model.specificationmessage.SpecificationMessageSet"
+ provides="lp.blueprints.interfaces.specificationmessage.ISpecificationMessageSet">
+ <allow
+ interface="lp.blueprints.interfaces.specificationmessage.ISpecificationMessageSet"/>
+ </securedutility>
     </facet>
     <subscriber
         for="lp.blueprints.interfaces.specification.ISpecification lazr.lifecycle.interfaces.IObjectModifiedEvent"

=== added file 'lib/lp/blueprints/doc/specificationmessage.txt'
--- lib/lp/blueprints/doc/specificationmessage.txt 1970-01-01 00:00:00 +0000
+++ lib/lp/blueprints/doc/specificationmessage.txt 2009-08-10 09:34:05 +0000
@@ -0,0 +1,38 @@
+= Specification Messages =
+
+Specification messages are messages associated with blueprints. A specifiction
+message is described by the ISpecificationMessage interface.
+
+One IMessage can be associated with many ISpecification, but one
+ISpecificationMessage is always associated with exactly one specification.
+
+ >>> from lp.blueprints.interfaces.specification import ISpecificationSet
+ >>> from lp.blueprints.interfaces.specificationmessage import (
+ ... ISpecificationMessageSet)
+ >>> specset = getUtility(ISpecificationSet)
+ >>> specmessageset = getUtility(ISpecificationMessageSet)
+
+== Creating specification messages ==
+
+To create a specification message, use ISpecificationMessageSet.createMessage:
+
+ >>> from canonical.launchpad.interfaces import IPersonSet
+ >>> sample_person = getUtility(IPersonSet).get(12)
+ >>> spec = specset.getByURL('http://developer.mozilla.org/en/docs/SVG')
+ >>> test_message = specmessageset.createMessage(
+ ... subject="test message subject",
+ ... content="text message content",
+ ... owner=sample_person,
+ ... spec=spec)
+ >>> test_message.message.subject
+ u'test message subject'
+
+== Retrieving specification messages ==
+
+ISpecificationMessageSet represents the set of all ISpecificationMessages in
+the system. An individual ISpecificationMessage can be retrieved with
+ISpecificationMessageSet.get:
+
+ >>> specmessage_one = specmessageset.get(1)
+ >>> specmessage_on...

[Eleanor Berger (intellectronica)]

Hi Andrea,

Thanks again for working on this. Your branch looks very good and is almost ready to land. There are a few things I'd like you to fix, and I also have a couple of questions, so I'm marking this Needs Fixing for now, but it should be very easy to fix.

> === modified file 'lib/lp/blueprints/configure.zcml'
> --- lib/lp/blueprints/configure.zcml 2009-07-13 18:15:02 +0000
> +++ lib/lp/blueprints/configure.zcml 2009-08-10 09:34:05 +0000
> @@ -219,6 +219,28 @@
> <allow
> interface="lp.blueprints.interfaces.specification.ISpecificationDelta"/>
> </class>
> +
> + <!-- SpecificationMessage -->
> +
> + <class
> +
> class="lp.blueprints.model.specificationmessage.SpecificationMessage">
> + <allow
> + interface="lp.blueprints.interfaces.specificationmessage.ISpe
> cificationMessage"/>
> + </class>
> +
> + <!-- SpecificationMessageSet -->
> +
> + <class
> +
> class="lp.blueprints.model.specificationmessage.SpecificationMessageSet">
> + <allow
> + interface="lp.blueprints.interfaces.specificationmessage.ISpe
> cificationMessageSet"/>
> + </class>
> + <securedutility
> +
> class="lp.blueprints.model.specificationmessage.SpecificationMessageSet"
> + provides="lp.blueprints.interfaces.specificationmessage.ISpecific
> ationMessageSet">
> + <allow
> + interface="lp.blueprints.interfaces.specificationmessage.ISpe
> cificationMessageSet"/>
> + </securedutility>
> </facet>
> <subscriber
> for="lp.blueprints.interfaces.specification.ISpecification
> lazr.lifecycle.interfaces.IObjectModifiedEvent"
>
> === added file 'lib/lp/blueprints/doc/specificationmessage.txt'
> --- lib/lp/blueprints/doc/specificationmessage.txt 1970-01-01 00:00:00
> +0000
> +++ lib/lp/blueprints/doc/specificationmessage.txt 2009-08-10 09:34:05
> +0000
> @@ -0,0 +1,38 @@
> += Specification Messages =
> +
> +Specification messages are messages associated with blueprints. A specifiction
> +message is described by the ISpecificationMessage interface.

Narrative in doctests should wrap around 72 characters.

> +
> +One IMessage can be associated with many ISpecification, but one
> +ISpecificationMessage is always associated with exactly one specification.

That's techincally true, but I don't think very relevant. You will never want
to do that, so I think this bit can be removed.

> +
> + >>> from lp.blueprints.interfaces.specification import ISpecificationSet
> + >>> from lp.blueprints.interfaces.specificationmessage import (
> + ... ISpecificationMessageSet)
> + >>> specset = getUtility(ISpecificationSet)
> + >>> specmessageset = getUtility(ISpecificationMessageSet)

It's a bit odd to do this assignment at the end of a test (though I understand
why you did it). I think it's better to merge the code part of this section
with the next one.

> +

Please add an extra blank line between sections (so there are two blank lines).

> +== Creating specification messages ==
> +
> +To create a specification message, use
> ISpecificationMessageSet.createMessage:
> +
> + >>> fr...

review: Needs Fixing (code)

[Andrea Corbellini (andrea.corbellini)]

Thank you for your review.

Most of the errors that you have reported can be also found in
bugmessage. Should I fix them in a separate branch?

> > +# pylint: disable-msg=E0211,E0213
>
> Why are you disabling these lint messages?

I'm disabling E0213 because it says:

  Method should have "self" as first argument

> > + messageID = Int(title=u"The message id.", readonly=True)
>
> Why is this attribute needed? We only very rarely need to work with IDs. Normally
> Storm should take care of references for us.

I've included it because I saw that it is used in IBugMessage and in
ICodeReviewComment.

Here's the incremental diff:

=== modified file 'lib/lp/blueprints/doc/specificationmessage.txt'
--- lib/lp/blueprints/doc/specificationmessage.txt 2009-08-07 18:24:33
+0000
+++ lib/lp/blueprints/doc/specificationmessage.txt 2009-08-10 12:34:20
+0000
@@ -1,24 +1,26 @@
 = Specification Messages =

-Specification messages are messages associated with blueprints. A
specifiction
-message is described by the ISpecificationMessage interface.
-
-One IMessage can be associated with many ISpecification, but one
-ISpecificationMessage is always associated with exactly one
specification.
-
- >>> from lp.blueprints.interfaces.specification import
ISpecificationSet
+Specification messages are messages associated with blueprints. A
+specifiction message is described by the ISpecificationMessage
+interface.
+
+
+== Creating specification messages ==
+
+To create a specification message, use
+ISpecificationMessageSet.createMessage:
+
+ >>> from lp.blueprints.interfaces.specification import (
+ ... ISpecificationSet)
     >>> from lp.blueprints.interfaces.specificationmessage import (
     ... ISpecificationMessageSet)
     >>> specset = getUtility(ISpecificationSet)
     >>> specmessageset = getUtility(ISpecificationMessageSet)

-== Creating specification messages ==
-
-To create a specification message, use
ISpecificationMessageSet.createMessage:
-
     >>> from canonical.launchpad.interfaces import IPersonSet
     >>> sample_person = getUtility(IPersonSet).get(12)
- >>> spec =
specset.getByURL('http://developer.mozilla.org/en/docs/SVG')
+ >>> spec = specset.getByURL(
+ ... 'http://developer.mozilla.org/en/docs/SVG')
     >>> test_message = specmessageset.createMessage(
     ... subject="test message subject",
     ... content="text message content",
@@ -27,10 +29,11 @@
     >>> test_message.message.subject
     u'test message subject'

+
 == Retrieving specification messages ==

-ISpecificationMessageSet represents the set of all
ISpecificationMessages in
-the system. An individual ISpecificationMessage can be retrieved with
+ISpecificationMessageSet represents the set of all messages in the
+system. An individual ISpecificationMessage can be retrieved with
 ISpecificationMessageSet.get:

     >>> specmessage_one = specmessageset.get(1)

=== modified file 'lib/lp/blueprints/interfaces/specificationmessage.py'
--- lib/lp/blueprints/interfaces/specificationmessage.py 2009-08-07
16:27:15 +0000
+++ lib/lp/blueprints/interfaces/specificationmessage.py 2009-08-10
12:34:20 +0000
@@ -1,7 +1,7 @@
 # Copyright 2009 Canonical ...

[Eleanor Berger (intellectronica)]

> Thank you for your review.
>
> Most of the errors that you have reported can be also found in
> bugmessage. Should I fix them in a separate branch?
>
> > > +# pylint: disable-msg=E0211,E0213
> >
> > Why are you disabling these lint messages?
>
> I'm disabling E0213 because it says:
>
> Method should have "self" as first argument

OK, sorry, this was a stupid question :-/ These are disabled in all interfaces for obvious reasons.

>
> > > + messageID = Int(title=u"The message id.", readonly=True)
> >
> > Why is this attribute needed? We only very rarely need to work with IDs.
> Normally
> > Storm should take care of references for us.
>
> I've included it because I saw that it is used in IBugMessage and in
> ICodeReviewComment.

I think you should avoid it unless you have no choice. This trick is used elsewhere for optimization, but as long as you don't have at least one call-site you shouldn't include this.

>
>
> Here's the incremental diff:
>
> === modified file 'lib/lp/blueprints/doc/specificationmessage.txt'
> --- lib/lp/blueprints/doc/specificationmessage.txt 2009-08-07 18:24:33
> +0000
> +++ lib/lp/blueprints/doc/specificationmessage.txt 2009-08-10 12:34:20
> +0000
> @@ -1,24 +1,26 @@
> = Specification Messages =
>
> -Specification messages are messages associated with blueprints. A
> specifiction
> -message is described by the ISpecificationMessage interface.
> -
> -One IMessage can be associated with many ISpecification, but one
> -ISpecificationMessage is always associated with exactly one
> specification.
> -
> - >>> from lp.blueprints.interfaces.specification import
> ISpecificationSet
> +Specification messages are messages associated with blueprints. A
> +specifiction message is described by the ISpecificationMessage
> +interface.
> +
> +
> +== Creating specification messages ==
> +
> +To create a specification message, use
> +ISpecificationMessageSet.createMessage:
> +
> + >>> from lp.blueprints.interfaces.specification import (
> + ... ISpecificationSet)
> >>> from lp.blueprints.interfaces.specificationmessage import (
> ... ISpecificationMessageSet)
> >>> specset = getUtility(ISpecificationSet)
> >>> specmessageset = getUtility(ISpecificationMessageSet)
>
> -== Creating specification messages ==
> -
> -To create a specification message, use
> ISpecificationMessageSet.createMessage:
> -
> >>> from canonical.launchpad.interfaces import IPersonSet
> >>> sample_person = getUtility(IPersonSet).get(12)
> - >>> spec =
> specset.getByURL('http://developer.mozilla.org/en/docs/SVG')
> + >>> spec = specset.getByURL(
> + ... 'http://developer.mozilla.org/en/docs/SVG')
> >>> test_message = specmessageset.createMessage(
> ... subject="test message subject",
> ... content="text message content",
> @@ -27,10 +29,11 @@
> >>> test_message.message.subject
> u'test message subject'
>
> +
> == Retrieving specification messages ==
>
> -ISpecificationMessageSet represents the set of all
> ISpecificationMessages in
> -the system. An individual ISpecificationMessage can be retrieved with
> +ISpecificationMessageSet represents the ...

review: Approve (code)

=== modified file 'cronscripts/rosetta-approve-imports.py'
--- cronscripts/rosetta-approve-imports.py	2009-07-17 00:26:05 +0000
+++ cronscripts/rosetta-approve-imports.py	2009-08-04 09:24:21 +0000
@@ -26,7 +26,7 @@
 
 if __name__ == '__main__':
     script = RosettaImportApprover('rosetta-approve-imports',
-        dbuser=config.poimport.dbuser)
+        dbuser='poimportapprover')
     script.lock_or_quit()
     try:
         script.run()

=== modified file 'database/schema/Makefile'
--- database/schema/Makefile	2009-08-04 11:07:08 +0000
+++ database/schema/Makefile	2009-08-04 22:16:48 +0000
@@ -57,14 +57,15 @@
 
 
 # The latest schema dump from production. Database patches are relative
-# to this baseline. This dump should be updated every production rollout
+# to this baseline. This dump should be updated occasionally from production
 # to ensure that the development database remains in sync with reality
 # on production. It is generated using newbaseline.py in
 # bzr+ssh://devpad.canonical.com/code/stub/dbascripts
 # 
-REV=2109
+REV=2207
 BASELINE=launchpad-${REV}-00-0.sql
-MD5SUM=8a2e8fb0c3665cf1b07487fe3650816e  launchpad-2109-00-0.sql
+MD5SUM=6a28c01a33ee2dc133ab4f8931d94282  launchpad-2207-00-0.sql
+
 default: all
 
 # Create a launchpad_ftest_template DB and load the test sample data into it.
@@ -107,7 +108,7 @@
 # database schema, full text indexes and grants into it.
 # It will also create session DBs for the test and dev environments.
 # No sample data is added at this point.
-create: check
+create: 
 	@ echo "* If this fails you need to run as the postgresql superuser"
 	@ echo "* eg. sudo -u postgres make create"
 	@ echo

=== renamed file 'database/schema/launchpad-2109-00-0.sql' => 'database/schema/launchpad-2207-00-0.sql'
--- database/schema/launchpad-2109-00-0.sql	2008-10-06 04:17:49 +0000
+++ database/schema/launchpad-2207-00-0.sql	2009-07-27 08:11:44 +0000
@@ -1,4 +1,7 @@
--- Generated Tue Sep 23 11:46:25 2008 UTC
+-- Copyright 2009 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+-- Generated Mon Jul 27 08:43:04 2009 UTC
 
 SET client_min_messages TO ERROR;
 
@@ -11,10 +14,51 @@
 
 SET search_path = public, pg_catalog;
 
+CREATE TYPE pgstattuple_type AS (
+	table_len bigint,
+	tuple_count bigint,
+	tuple_len bigint,
+	tuple_percent double precision,
+	dead_tuple_count bigint,
+	dead_tuple_len bigint,
+	dead_tuple_percent double precision,
+	free_space bigint,
+	free_percent double precision
+);
+
 SET default_tablespace = '';
 
 SET default_with_oids = false;
 
+CREATE TABLE revision (
+    id integer NOT NULL,
+    date_created timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
+    log_body text NOT NULL,
+    revision_author integer NOT NULL,
+    gpgkey integer,
+    revision_id text NOT NULL,
+    revision_date timestamp without time zone,
+    karma_allocated boolean DEFAULT false
+);
+ALTER TABLE ONLY revision ALTER COLUMN revision_author SET STATISTICS 500;
+ALTER TABLE ONLY revision ALTER COLUMN revision_date SET STATISTICS 500;
+
+CREATE FUNCTION pgstattuple(text) RETURNS pgstattuple_type
+    AS '$libdir/pgstattuple', 'pgstattuple'
+    LANGUAGE c STRICT;
+
+CREATE FUNCTION pgstattuple(oid) RETURNS pgstattuple_type
+    AS '$libdir/pgstattuple', 'pgstattuplebyid'
+    LANGUAGE c STRICT;
+
+CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
+    AS '$libdir/plpgsql', 'plpgsql_call_handler'
+    LANGUAGE c;
+
+CREATE FUNCTION plpython_call_handler() RETURNS language_handler
+    AS '$libdir/plpython', 'plpython_call_handler'
+    LANGUAGE c;
+
 CREATE TABLE account (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -27,12 +71,31 @@
     old_openid_identifier text
 );
 
+CREATE SEQUENCE account_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE account_id_seq OWNED BY account.id;
+
 CREATE TABLE accountpassword (
     id integer NOT NULL,
     account integer NOT NULL,
     password text NOT NULL
 );
 
+CREATE SEQUENCE accountpassword_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE accountpassword_id_seq OWNED BY accountpassword.id;
+
+CREATE VIEW alllocks AS
+    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)));
+
 CREATE TABLE announcement (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -50,6 +113,14 @@
     CONSTRAINT valid_url CHECK (valid_absolute_url(url))
 );
 
+CREATE SEQUENCE announcement_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE announcement_id_seq OWNED BY announcement.id;
+
 CREATE TABLE answercontact (
     id integer NOT NULL,
     product integer,
@@ -60,13 +131,20 @@
     CONSTRAINT valid_target CHECK ((((product IS NULL) <> (distribution IS NULL)) AND ((product IS NULL) OR (sourcepackagename IS NULL))))
 );
 
+CREATE SEQUENCE answercontact_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE answercontact_id_seq OWNED BY answercontact.id;
+
 CREATE TABLE archive (
     id integer NOT NULL,
     owner integer NOT NULL,
     description text,
     enabled boolean DEFAULT true NOT NULL,
     authorized_size integer,
-    whiteboard text,
     distribution integer NOT NULL,
     purpose integer NOT NULL,
     private boolean DEFAULT false NOT NULL,
@@ -86,16 +164,36 @@
     building_count integer DEFAULT 0 NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
     signing_key integer,
+    removed_binary_retention_days integer,
+    num_old_versions_published integer,
+    displayname text NOT NULL,
+    relative_build_score integer DEFAULT 0 NOT NULL,
     CONSTRAINT valid_buildd_secret CHECK ((((private = true) AND (buildd_secret IS NOT NULL)) OR (private = false))),
     CONSTRAINT valid_name CHECK (valid_name(name))
 );
 
+CREATE SEQUENCE archive_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE archive_id_seq OWNED BY archive.id;
+
 CREATE TABLE archivearch (
     id integer NOT NULL,
     archive integer NOT NULL,
     processorfamily integer NOT NULL
 );
 
+CREATE SEQUENCE archivearch_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE archivearch_id_seq OWNED BY archivearch.id;
+
 CREATE TABLE archiveauthtoken (
     id integer NOT NULL,
     archive integer NOT NULL,
@@ -105,16 +203,32 @@
     token text NOT NULL
 );
 
+CREATE SEQUENCE archiveauthtoken_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE archiveauthtoken_id_seq OWNED BY archiveauthtoken.id;
+
 CREATE TABLE archivedependency (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
     archive integer NOT NULL,
     dependency integer NOT NULL,
-    pocket integer,
+    pocket integer NOT NULL,
     component integer,
     CONSTRAINT distinct_archives CHECK ((archive <> dependency))
 );
 
+CREATE SEQUENCE archivedependency_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE archivedependency_id_seq OWNED BY archivedependency.id;
+
 CREATE TABLE archivepermission (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -123,9 +237,19 @@
     archive integer NOT NULL,
     component integer,
     sourcepackagename integer,
-    CONSTRAINT component_or_sourcepackagename CHECK (((component IS NULL) OR (sourcepackagename IS NULL)))
+    packageset integer,
+    explicit boolean DEFAULT false NOT NULL,
+    CONSTRAINT one_target CHECK ((null_count(ARRAY[packageset, component, sourcepackagename]) = 2))
 );
 
+CREATE SEQUENCE archivepermission_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE archivepermission_id_seq OWNED BY archivepermission.id;
+
 CREATE TABLE archivesubscriber (
     id integer NOT NULL,
     archive integer NOT NULL,
@@ -139,6 +263,34 @@
     cancelled_by integer
 );
 
+CREATE SEQUENCE archivesubscriber_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE archivesubscriber_id_seq OWNED BY archivesubscriber.id;
+
+CREATE TABLE authtoken (
+    id integer NOT NULL,
+    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
+    date_consumed timestamp without time zone,
+    token_type integer NOT NULL,
+    token text NOT NULL,
+    requester integer,
+    requester_email text,
+    email text NOT NULL,
+    redirection_url text
+);
+
+CREATE SEQUENCE authtoken_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE authtoken_id_seq OWNED BY authtoken.id;
+
 CREATE TABLE binarypackagename (
     id integer NOT NULL,
     name text NOT NULL,
@@ -161,6 +313,14 @@
     id integer DEFAULT nextval(('binarypackagefile_id_seq'::text)::regclass) NOT NULL
 );
 
+CREATE SEQUENCE binarypackagefile_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE binarypackagefile_id_seq OWNED BY binarypackagefile.id;
+
 CREATE TABLE binarypackagerelease (
     id integer NOT NULL,
     binarypackagename integer NOT NULL,
@@ -271,6 +431,7 @@
     last_accessed timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
     restricted boolean DEFAULT false NOT NULL,
+    hits integer DEFAULT 0 NOT NULL,
     CONSTRAINT valid_filename CHECK ((filename !~~ '%/%'::text))
 );
 
@@ -329,9 +490,25 @@
 CREATE VIEW binarypackagefilepublishing AS
     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);
 
+CREATE SEQUENCE binarypackagename_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE binarypackagename_id_seq OWNED BY binarypackagename.id;
+
 CREATE VIEW binarypackagepublishinghistory AS
     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);
 
+CREATE SEQUENCE binarypackagerelease_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE binarypackagerelease_id_seq OWNED BY binarypackagerelease.id;
+
 CREATE TABLE bounty (
     id integer NOT NULL,
     name text NOT NULL,
@@ -349,18 +526,42 @@
     bountystatus integer DEFAULT 1 NOT NULL
 );
 
+CREATE SEQUENCE bounty_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bounty_id_seq OWNED BY bounty.id;
+
 CREATE TABLE bountymessage (
     id integer NOT NULL,
     bounty integer NOT NULL,
     message integer NOT NULL
 );
 
+CREATE SEQUENCE bountymessage_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bountymessage_id_seq OWNED BY bountymessage.id;
+
 CREATE TABLE bountysubscription (
     id integer NOT NULL,
     bounty integer NOT NULL,
     person integer NOT NULL
 );
 
+CREATE SEQUENCE bountysubscription_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bountysubscription_id_seq OWNED BY bountysubscription.id;
+
 CREATE TABLE branch (
     id integer NOT NULL,
     title text,
@@ -376,7 +577,6 @@
     last_mirrored timestamp without time zone,
     last_mirror_attempt timestamp without time zone,
     mirror_failures integer DEFAULT 0 NOT NULL,
-    pull_disabled boolean DEFAULT false NOT NULL,
     mirror_status_message text,
     last_scanned timestamp without time zone,
     last_scanned_id text,
@@ -395,15 +595,46 @@
     repository_format integer,
     metadir_format integer,
     stacked_on integer,
+    distroseries integer,
+    sourcepackagename integer,
+    owner_name text NOT NULL,
+    target_suffix text,
+    unique_name text,
+    size_on_disk bigint,
     CONSTRAINT branch_merge_control CHECK (((merge_robot IS NULL) OR (merge_control_status = ANY (ARRAY[3, 4])))),
     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))),
     CONSTRAINT branch_url_no_trailing_slash CHECK ((url !~~ '%/'::text)),
     CONSTRAINT branch_url_not_supermirror CHECK ((url !~~ 'http://bazaar.launchpad.net/%'::text)),
+    CONSTRAINT one_container CHECK ((((distroseries IS NULL) = (sourcepackagename IS NULL)) AND ((distroseries IS NULL) OR (product IS NULL)))),
     CONSTRAINT valid_home_page CHECK (valid_absolute_url(home_page)),
     CONSTRAINT valid_name CHECK (valid_branch_name(name)),
     CONSTRAINT valid_url CHECK (valid_absolute_url(url))
 );
 
+CREATE SEQUENCE branch_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE branch_id_seq OWNED BY branch.id;
+
+CREATE TABLE branchjob (
+    id integer NOT NULL,
+    job integer NOT NULL,
+    branch integer,
+    job_type integer NOT NULL,
+    json_data text
+);
+
+CREATE SEQUENCE branchjob_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE branchjob_id_seq OWNED BY branchjob.id;
+
 CREATE TABLE branchmergeproposal (
     id integer NOT NULL,
     registrant integer NOT NULL,
@@ -432,10 +663,36 @@
     merge_log_file integer,
     superseded_by integer,
     root_message_id text,
+    review_diff integer,
+    merge_diff integer,
     CONSTRAINT different_branches CHECK ((((source_branch <> target_branch) AND (dependent_branch <> source_branch)) AND (dependent_branch <> target_branch))),
     CONSTRAINT positive_revno CHECK (((merged_revno IS NULL) OR (merged_revno > 0)))
 );
 
+CREATE SEQUENCE branchmergeproposal_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE branchmergeproposal_id_seq OWNED BY branchmergeproposal.id;
+
+CREATE TABLE branchmergeproposaljob (
+    id integer NOT NULL,
+    job integer NOT NULL,
+    branch_merge_proposal integer NOT NULL,
+    job_type integer NOT NULL,
+    json_data text
+);
+
+CREATE SEQUENCE branchmergeproposaljob_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE branchmergeproposaljob_id_seq OWNED BY branchmergeproposaljob.id;
+
 CREATE TABLE branchmergerobot (
     id integer NOT NULL,
     registrant integer NOT NULL,
@@ -445,12 +702,30 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE branchmergerobot_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE branchmergerobot_id_seq OWNED BY branchmergerobot.id;
+
 CREATE TABLE branchrevision (
     id integer NOT NULL,
     sequence integer,
     branch integer NOT NULL,
     revision integer NOT NULL
 );
+ALTER TABLE ONLY branchrevision ALTER COLUMN branch SET STATISTICS 500;
+ALTER TABLE ONLY branchrevision ALTER COLUMN revision SET STATISTICS 500;
+
+CREATE SEQUENCE branchrevision_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE branchrevision_id_seq OWNED BY branchrevision.id;
 
 CREATE TABLE branchsubscription (
     id integer NOT NULL,
@@ -462,6 +737,14 @@
     review_level integer DEFAULT 0 NOT NULL
 );
 
+CREATE SEQUENCE branchsubscription_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE branchsubscription_id_seq OWNED BY branchsubscription.id;
+
 CREATE TABLE branchvisibilitypolicy (
     id integer NOT NULL,
     project integer,
@@ -471,6 +754,14 @@
     CONSTRAINT only_one_target CHECK (((project IS NULL) <> (product IS NULL)))
 );
 
+CREATE SEQUENCE branchvisibilitypolicy_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE branchvisibilitypolicy_id_seq OWNED BY branchvisibilitypolicy.id;
+
 CREATE TABLE person (
     id integer NOT NULL,
     displayname text NOT NULL,
@@ -565,13 +856,14 @@
     official_codehosting boolean DEFAULT false NOT NULL,
     license_approved boolean DEFAULT false NOT NULL,
     registrant integer NOT NULL,
+    remote_product text,
     CONSTRAINT only_launchpad_has_expiration CHECK (((enable_bug_expiration IS FALSE) OR (official_malone IS TRUE))),
     CONSTRAINT private_bugs_need_contact CHECK (((private_bugs IS FALSE) OR (bug_supervisor IS NOT NULL))),
     CONSTRAINT valid_name CHECK (valid_name(name))
 );
 
 CREATE VIEW branchwithsortkeys AS
-    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)));
+    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)));
 
 CREATE TABLE bug (
     id integer NOT NULL,
@@ -591,11 +883,21 @@
     number_of_duplicates integer DEFAULT 0 NOT NULL,
     message_count integer DEFAULT 0 NOT NULL,
     users_affected_count integer DEFAULT 0,
+    users_unaffected_count integer DEFAULT 0,
+    hotness integer DEFAULT 0 NOT NULL,
     CONSTRAINT notduplicateofself CHECK ((NOT (id = duplicateof))),
     CONSTRAINT sane_description CHECK (((ltrim(description) <> ''::text) AND (char_length(description) <= 50000))),
     CONSTRAINT valid_bug_name CHECK (valid_bug_name(name))
 );
 
+CREATE SEQUENCE bug_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bug_id_seq OWNED BY bug.id;
+
 CREATE TABLE bugactivity (
     id integer NOT NULL,
     bug integer NOT NULL,
@@ -607,12 +909,29 @@
     message text
 );
 
+CREATE SEQUENCE bugactivity_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugactivity_id_seq OWNED BY bugactivity.id;
+
 CREATE TABLE bugaffectsperson (
     id integer NOT NULL,
     bug integer NOT NULL,
-    person integer NOT NULL
+    person integer NOT NULL,
+    affected boolean DEFAULT true NOT NULL
 );
 
+CREATE SEQUENCE bugaffectsperson_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugaffectsperson_id_seq OWNED BY bugaffectsperson.id;
+
 CREATE TABLE bugattachment (
     id integer NOT NULL,
     message integer NOT NULL,
@@ -624,17 +943,32 @@
     CONSTRAINT valid_name CHECK (valid_name(name))
 );
 
+CREATE SEQUENCE bugattachment_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugattachment_id_seq OWNED BY bugattachment.id;
+
 CREATE TABLE bugbranch (
     id integer NOT NULL,
     datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
     bug integer NOT NULL,
     branch integer NOT NULL,
     revision_hint integer,
-    status integer NOT NULL,
     whiteboard text,
     registrant integer NOT NULL
 );
 
+CREATE SEQUENCE bugbranch_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugbranch_id_seq OWNED BY bugbranch.id;
+
 CREATE TABLE bugcve (
     id integer NOT NULL,
     bug integer NOT NULL,
@@ -642,6 +976,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE bugcve_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugcve_id_seq OWNED BY bugcve.id;
+
 CREATE TABLE bugmessage (
     id integer NOT NULL,
     bug integer NOT NULL,
@@ -652,6 +994,14 @@
     CONSTRAINT imported_comment CHECK (((remote_comment_id IS NULL) OR (bugwatch IS NOT NULL)))
 );
 
+CREATE SEQUENCE bugmessage_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugmessage_id_seq OWNED BY bugmessage.id;
+
 CREATE TABLE bugnomination (
     id integer NOT NULL,
     bug integer NOT NULL,
@@ -661,9 +1011,18 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()),
     date_decided timestamp without time zone,
     owner integer NOT NULL,
-    decider integer
+    decider integer,
+    CONSTRAINT distroseries_or_productseries CHECK (((distroseries IS NULL) <> (productseries IS NULL)))
 );
 
+CREATE SEQUENCE bugnomination_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugnomination_id_seq OWNED BY bugnomination.id;
+
 CREATE TABLE bugnotification (
     id integer NOT NULL,
     bug integer NOT NULL,
@@ -672,6 +1031,28 @@
     date_emailed timestamp without time zone
 );
 
+CREATE SEQUENCE bugnotification_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugnotification_id_seq OWNED BY bugnotification.id;
+
+CREATE TABLE bugnotificationattachment (
+    id integer NOT NULL,
+    message integer NOT NULL,
+    bug_notification integer NOT NULL
+);
+
+CREATE SEQUENCE bugnotificationattachment_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugnotificationattachment_id_seq OWNED BY bugnotificationattachment.id;
+
 CREATE TABLE bugnotificationrecipient (
     id integer NOT NULL,
     bug_notification integer NOT NULL,
@@ -680,6 +1061,14 @@
     reason_body text NOT NULL
 );
 
+CREATE SEQUENCE bugnotificationrecipient_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugnotificationrecipient_id_seq OWNED BY bugnotificationrecipient.id;
+
 CREATE TABLE bugpackageinfestation (
     id integer NOT NULL,
     bug integer NOT NULL,
@@ -694,6 +1083,14 @@
     lastmodifiedby integer NOT NULL
 );
 
+CREATE SEQUENCE bugpackageinfestation_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugpackageinfestation_id_seq OWNED BY bugpackageinfestation.id;
+
 CREATE TABLE bugproductinfestation (
     id integer NOT NULL,
     bug integer NOT NULL,
@@ -708,6 +1105,14 @@
     lastmodifiedby integer NOT NULL
 );
 
+CREATE SEQUENCE bugproductinfestation_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugproductinfestation_id_seq OWNED BY bugproductinfestation.id;
+
 CREATE TABLE bugsubscription (
     id integer NOT NULL,
     person integer NOT NULL,
@@ -716,6 +1121,14 @@
     subscribed_by integer NOT NULL
 );
 
+CREATE SEQUENCE bugsubscription_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugsubscription_id_seq OWNED BY bugsubscription.id;
+
 CREATE TABLE bugtag (
     id integer NOT NULL,
     bug integer NOT NULL,
@@ -723,6 +1136,14 @@
     CONSTRAINT valid_tag CHECK (valid_name(tag))
 );
 
+CREATE SEQUENCE bugtag_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugtag_id_seq OWNED BY bugtag.id;
+
 CREATE TABLE bugtask (
     id integer NOT NULL,
     bug integer NOT NULL,
@@ -752,9 +1173,20 @@
     date_triaged timestamp without time zone,
     date_fix_committed timestamp without time zone,
     date_fix_released timestamp without time zone,
+    date_left_closed timestamp without time zone,
+    hotness_rank integer DEFAULT 0 NOT NULL,
+    date_milestone_set timestamp without time zone,
     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)
 );
 
+CREATE SEQUENCE bugtask_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugtask_id_seq OWNED BY bugtask.id;
+
 CREATE TABLE bugtracker (
     id integer NOT NULL,
     bugtrackertype integer NOT NULL,
@@ -768,15 +1200,32 @@
     version text,
     block_comment_pushing boolean DEFAULT false NOT NULL,
     has_lp_plugin boolean,
+    active boolean DEFAULT true NOT NULL,
     CONSTRAINT valid_name CHECK (valid_name(name))
 );
 
+CREATE SEQUENCE bugtracker_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugtracker_id_seq OWNED BY bugtracker.id;
+
 CREATE TABLE bugtrackeralias (
     id integer NOT NULL,
     bugtracker integer NOT NULL,
     base_url text NOT NULL
 );
 
+CREATE SEQUENCE bugtrackeralias_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugtrackeralias_id_seq OWNED BY bugtrackeralias.id;
+
 CREATE TABLE bugtrackerperson (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -785,6 +1234,14 @@
     name text NOT NULL
 );
 
+CREATE SEQUENCE bugtrackerperson_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugtrackerperson_id_seq OWNED BY bugtrackerperson.id;
+
 CREATE TABLE bugwatch (
     id integer NOT NULL,
     bug integer NOT NULL,
@@ -800,6 +1257,22 @@
     remote_lp_bug_id integer
 );
 
+CREATE SEQUENCE bugwatch_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE bugwatch_id_seq OWNED BY bugwatch.id;
+
+CREATE SEQUENCE build_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE build_id_seq OWNED BY build.id;
+
 CREATE TABLE builder (
     id integer NOT NULL,
     processor integer NOT NULL,
@@ -819,6 +1292,14 @@
     CONSTRAINT valid_absolute_url CHECK (valid_absolute_url(url))
 );
 
+CREATE SEQUENCE builder_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE builder_id_seq OWNED BY builder.id;
+
 CREATE TABLE buildqueue (
     id integer NOT NULL,
     build integer NOT NULL,
@@ -830,6 +1311,14 @@
     manual boolean DEFAULT false NOT NULL
 );
 
+CREATE SEQUENCE buildqueue_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE buildqueue_id_seq OWNED BY buildqueue.id;
+
 CREATE TABLE codeimport (
     id integer NOT NULL,
     branch integer NOT NULL,
@@ -844,9 +1333,18 @@
     owner integer NOT NULL,
     assignee integer,
     update_interval interval,
-    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)
+    git_repo_url text,
+    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)
 );
 
+CREATE SEQUENCE codeimport_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE codeimport_id_seq OWNED BY codeimport.id;
+
 CREATE TABLE codeimportevent (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -856,6 +1354,14 @@
     machine integer
 );
 
+CREATE SEQUENCE codeimportevent_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE codeimportevent_id_seq OWNED BY codeimportevent.id;
+
 CREATE TABLE codeimporteventdata (
     id integer NOT NULL,
     event integer,
@@ -863,6 +1369,14 @@
     data_value text
 );
 
+CREATE SEQUENCE codeimporteventdata_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE codeimporteventdata_id_seq OWNED BY codeimporteventdata.id;
+
 CREATE TABLE codeimportjob (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -878,6 +1392,14 @@
     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)
 );
 
+CREATE SEQUENCE codeimportjob_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE codeimportjob_id_seq OWNED BY codeimportjob.id;
+
 CREATE TABLE codeimportmachine (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -886,6 +1408,14 @@
     heartbeat timestamp without time zone
 );
 
+CREATE SEQUENCE codeimportmachine_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE codeimportmachine_id_seq OWNED BY codeimportmachine.id;
+
 CREATE TABLE codeimportresult (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -898,6 +1428,14 @@
     date_job_started timestamp without time zone
 );
 
+CREATE SEQUENCE codeimportresult_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE codeimportresult_id_seq OWNED BY codeimportresult.id;
+
 CREATE TABLE codereviewmessage (
     id integer NOT NULL,
     branch_merge_proposal integer NOT NULL,
@@ -906,6 +1444,14 @@
     vote_tag text
 );
 
+CREATE SEQUENCE codereviewmessage_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE codereviewmessage_id_seq OWNED BY codereviewmessage.id;
+
 CREATE TABLE codereviewvote (
     id integer NOT NULL,
     branch_merge_proposal integer NOT NULL,
@@ -916,6 +1462,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE codereviewvote_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE codereviewvote_id_seq OWNED BY codereviewvote.id;
+
 CREATE TABLE commercialsubscription (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -930,6 +1484,22 @@
     sales_system_id text
 );
 
+CREATE SEQUENCE commercialsubscription_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE commercialsubscription_id_seq OWNED BY commercialsubscription.id;
+
+CREATE SEQUENCE component_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE component_id_seq OWNED BY component.id;
+
 CREATE TABLE componentselection (
     id integer NOT NULL,
     distroseries integer NOT NULL,
@@ -937,12 +1507,28 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE componentselection_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE componentselection_id_seq OWNED BY componentselection.id;
+
 CREATE TABLE continent (
     id integer NOT NULL,
     code text NOT NULL,
     name text NOT NULL
 );
 
+CREATE SEQUENCE continent_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE continent_id_seq OWNED BY continent.id;
+
 CREATE TABLE country (
     id integer NOT NULL,
     iso3166code2 character(2) NOT NULL,
@@ -953,6 +1539,14 @@
     continent integer NOT NULL
 );
 
+CREATE SEQUENCE country_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE country_id_seq OWNED BY country.id;
+
 CREATE TABLE customlanguagecode (
     id integer NOT NULL,
     product integer,
@@ -964,6 +1558,14 @@
     CONSTRAINT product_or_distro CHECK (((product IS NULL) <> (distribution IS NULL)))
 );
 
+CREATE SEQUENCE customlanguagecode_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE customlanguagecode_id_seq OWNED BY customlanguagecode.id;
+
 CREATE TABLE cve (
     id integer NOT NULL,
     sequence text NOT NULL,
@@ -975,6 +1577,14 @@
     CONSTRAINT valid_cve_ref CHECK (valid_cve(sequence))
 );
 
+CREATE SEQUENCE cve_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE cve_id_seq OWNED BY cve.id;
+
 CREATE TABLE cvereference (
     id integer NOT NULL,
     cve integer NOT NULL,
@@ -984,6 +1594,31 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE cvereference_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE cvereference_id_seq OWNED BY cvereference.id;
+
+CREATE TABLE diff (
+    id integer NOT NULL,
+    diff_text integer,
+    diff_lines_count integer,
+    diffstat text,
+    added_lines_count integer,
+    removed_lines_count integer
+);
+
+CREATE SEQUENCE diff_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE diff_id_seq OWNED BY diff.id;
+
 CREATE TABLE distribution (
     id integer NOT NULL,
     name text NOT NULL,
@@ -1022,6 +1657,14 @@
     CONSTRAINT valid_name CHECK (valid_name(name))
 );
 
+CREATE SEQUENCE distribution_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE distribution_id_seq OWNED BY distribution.id;
+
 CREATE TABLE distributionbounty (
     id integer NOT NULL,
     bounty integer NOT NULL,
@@ -1029,6 +1672,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE distributionbounty_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE distributionbounty_id_seq OWNED BY distributionbounty.id;
+
 CREATE TABLE distributionmirror (
     id integer NOT NULL,
     distribution integer NOT NULL,
@@ -1056,6 +1707,14 @@
     CONSTRAINT valid_rsync_base_url CHECK (valid_absolute_url(rsync_base_url))
 );
 
+CREATE SEQUENCE distributionmirror_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE distributionmirror_id_seq OWNED BY distributionmirror.id;
+
 CREATE TABLE distributionsourcepackage (
     id integer NOT NULL,
     distribution integer NOT NULL,
@@ -1063,6 +1722,14 @@
     bug_reporting_guidelines text
 );
 
+CREATE SEQUENCE distributionsourcepackage_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE distributionsourcepackage_id_seq OWNED BY distributionsourcepackage.id;
+
 CREATE TABLE distributionsourcepackagecache (
     id integer NOT NULL,
     distribution integer NOT NULL,
@@ -1076,6 +1743,22 @@
     archive integer NOT NULL
 );
 
+CREATE SEQUENCE distributionsourcepackagecache_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE distributionsourcepackagecache_id_seq OWNED BY distributionsourcepackagecache.id;
+
+CREATE SEQUENCE distroarchseries_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE distroarchseries_id_seq OWNED BY distroarchseries.id;
+
 CREATE TABLE distrocomponentuploader (
     id integer NOT NULL,
     distribution integer NOT NULL,
@@ -1084,6 +1767,22 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE distrocomponentuploader_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE distrocomponentuploader_id_seq OWNED BY distrocomponentuploader.id;
+
+CREATE SEQUENCE distroseries_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE distroseries_id_seq OWNED BY distroseries.id;
+
 CREATE TABLE distroserieslanguage (
     id integer NOT NULL,
     distroseries integer,
@@ -1096,6 +1795,14 @@
     unreviewed_count integer DEFAULT 0 NOT NULL
 );
 
+CREATE SEQUENCE distroserieslanguage_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE distroserieslanguage_id_seq OWNED BY distroserieslanguage.id;
+
 CREATE TABLE distroseriespackagecache (
     id integer NOT NULL,
     distroseries integer NOT NULL,
@@ -1109,6 +1816,14 @@
     archive integer NOT NULL
 );
 
+CREATE SEQUENCE distroseriespackagecache_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE distroseriespackagecache_id_seq OWNED BY distroseriespackagecache.id;
+
 CREATE TABLE emailaddress (
     id integer NOT NULL,
     email text NOT NULL,
@@ -1119,6 +1834,14 @@
     CONSTRAINT emailaddress__is_linked__chk CHECK (((person IS NOT NULL) OR (account IS NOT NULL)))
 );
 
+CREATE SEQUENCE emailaddress_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE emailaddress_id_seq OWNED BY emailaddress.id;
+
 CREATE TABLE entitlement (
     id integer NOT NULL,
     person integer,
@@ -1140,6 +1863,17 @@
     CONSTRAINT only_one_target CHECK ((null_count(ARRAY[person, product, project, distribution]) = 3))
 );
 
+CREATE SEQUENCE entitlement_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE entitlement_id_seq OWNED BY entitlement.id;
+
+CREATE VIEW exclusivelocks AS
+    SELECT alllocks.procpid, alllocks.usename, alllocks.age, alllocks.relname, alllocks.mode, alllocks.granted, alllocks.current_query FROM alllocks WHERE (alllocks.mode !~~ '%Share%'::text);
+
 CREATE TABLE faq (
     id integer NOT NULL,
     title text NOT NULL,
@@ -1155,17 +1889,56 @@
     CONSTRAINT product_or_distro CHECK (((product IS NULL) <> (distribution IS NULL)))
 );
 
+CREATE SEQUENCE faq_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE faq_id_seq OWNED BY faq.id;
+
 CREATE TABLE featuredproject (
     id integer NOT NULL,
     pillar_name integer NOT NULL
 );
 
+CREATE SEQUENCE featuredproject_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE featuredproject_id_seq OWNED BY featuredproject.id;
+
+CREATE TABLE flatpackagesetinclusion (
+    id integer NOT NULL,
+    parent integer NOT NULL,
+    child integer NOT NULL
+);
+
+CREATE SEQUENCE flatpackagesetinclusion_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE flatpackagesetinclusion_id_seq OWNED BY flatpackagesetinclusion.id;
+
 CREATE TABLE fticache (
     id integer NOT NULL,
     tablename text NOT NULL,
     columns text NOT NULL
 );
 
+CREATE SEQUENCE fticache_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE fticache_id_seq OWNED BY fticache.id;
+
 CREATE TABLE gpgkey (
     id integer NOT NULL,
     owner integer NOT NULL,
@@ -1180,6 +1953,14 @@
     CONSTRAINT valid_keyid CHECK (valid_keyid(keyid))
 );
 
+CREATE SEQUENCE gpgkey_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE gpgkey_id_seq OWNED BY gpgkey.id;
+
 CREATE TABLE hwdevice (
     id integer NOT NULL,
     bus_vendor_id integer NOT NULL,
@@ -1189,6 +1970,14 @@
     submissions integer NOT NULL
 );
 
+CREATE SEQUENCE hwdevice_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwdevice_id_seq OWNED BY hwdevice.id;
+
 CREATE TABLE hwdeviceclass (
     id integer NOT NULL,
     device integer NOT NULL,
@@ -1196,12 +1985,28 @@
     sub_class integer
 );
 
+CREATE SEQUENCE hwdeviceclass_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwdeviceclass_id_seq OWNED BY hwdeviceclass.id;
+
 CREATE TABLE hwdevicedriverlink (
     id integer NOT NULL,
     device integer NOT NULL,
     driver integer
 );
 
+CREATE SEQUENCE hwdevicedriverlink_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwdevicedriverlink_id_seq OWNED BY hwdevicedriverlink.id;
+
 CREATE TABLE hwdevicenamevariant (
     id integer NOT NULL,
     vendor_name integer NOT NULL,
@@ -1210,6 +2015,44 @@
     submissions integer NOT NULL
 );
 
+CREATE SEQUENCE hwdevicenamevariant_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwdevicenamevariant_id_seq OWNED BY hwdevicenamevariant.id;
+
+CREATE TABLE hwdmihandle (
+    id integer NOT NULL,
+    handle integer NOT NULL,
+    type integer NOT NULL,
+    submission integer
+);
+
+CREATE SEQUENCE hwdmihandle_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwdmihandle_id_seq OWNED BY hwdmihandle.id;
+
+CREATE TABLE hwdmivalue (
+    id integer NOT NULL,
+    key text,
+    value text,
+    handle integer NOT NULL
+);
+
+CREATE SEQUENCE hwdmivalue_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwdmivalue_id_seq OWNED BY hwdmivalue.id;
+
 CREATE TABLE hwdriver (
     id integer NOT NULL,
     package_name text,
@@ -1217,6 +2060,20 @@
     license integer
 );
 
+CREATE SEQUENCE hwdriver_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwdriver_id_seq OWNED BY hwdriver.id;
+
+CREATE VIEW hwdrivernames AS
+    SELECT DISTINCT ON (hwdriver.name) hwdriver.id, hwdriver.name FROM hwdriver ORDER BY hwdriver.name, hwdriver.id;
+
+CREATE VIEW hwdriverpackagenames AS
+    SELECT DISTINCT ON (hwdriver.package_name) hwdriver.id, hwdriver.package_name FROM hwdriver ORDER BY hwdriver.package_name, hwdriver.id;
+
 CREATE TABLE hwsubmission (
     id integer NOT NULL,
     date_created timestamp without time zone NOT NULL,
@@ -1233,12 +2090,28 @@
     raw_emailaddress text
 );
 
+CREATE SEQUENCE hwsubmission_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwsubmission_id_seq OWNED BY hwsubmission.id;
+
 CREATE TABLE hwsubmissionbug (
     id integer NOT NULL,
     submission integer NOT NULL,
     bug integer NOT NULL
 );
 
+CREATE SEQUENCE hwsubmissionbug_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwsubmissionbug_id_seq OWNED BY hwsubmissionbug.id;
+
 CREATE TABLE hwsubmissiondevice (
     id integer NOT NULL,
     device_driver_link integer NOT NULL,
@@ -1247,11 +2120,27 @@
     hal_device_id integer NOT NULL
 );
 
+CREATE SEQUENCE hwsubmissiondevice_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwsubmissiondevice_id_seq OWNED BY hwsubmissiondevice.id;
+
 CREATE TABLE hwsystemfingerprint (
     id integer NOT NULL,
     fingerprint text NOT NULL
 );
 
+CREATE SEQUENCE hwsystemfingerprint_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwsystemfingerprint_id_seq OWNED BY hwsystemfingerprint.id;
+
 CREATE TABLE hwtest (
     id integer NOT NULL,
     namespace text,
@@ -1259,6 +2148,14 @@
     version text NOT NULL
 );
 
+CREATE SEQUENCE hwtest_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwtest_id_seq OWNED BY hwtest.id;
+
 CREATE TABLE hwtestanswer (
     id integer NOT NULL,
     test integer NOT NULL,
@@ -1272,12 +2169,28 @@
     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))))
 );
 
+CREATE SEQUENCE hwtestanswer_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwtestanswer_id_seq OWNED BY hwtestanswer.id;
+
 CREATE TABLE hwtestanswerchoice (
     id integer NOT NULL,
     choice text NOT NULL,
     test integer NOT NULL
 );
 
+CREATE SEQUENCE hwtestanswerchoice_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwtestanswerchoice_id_seq OWNED BY hwtestanswerchoice.id;
+
 CREATE TABLE hwtestanswercount (
     id integer NOT NULL,
     test integer NOT NULL,
@@ -1290,18 +2203,42 @@
     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))))
 );
 
+CREATE SEQUENCE hwtestanswercount_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwtestanswercount_id_seq OWNED BY hwtestanswercount.id;
+
 CREATE TABLE hwtestanswercountdevice (
     id integer NOT NULL,
     answer integer NOT NULL,
     device_driver integer NOT NULL
 );
 
+CREATE SEQUENCE hwtestanswercountdevice_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwtestanswercountdevice_id_seq OWNED BY hwtestanswercountdevice.id;
+
 CREATE TABLE hwtestanswerdevice (
     id integer NOT NULL,
     answer integer NOT NULL,
     device_driver integer NOT NULL
 );
 
+CREATE SEQUENCE hwtestanswerdevice_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwtestanswerdevice_id_seq OWNED BY hwtestanswerdevice.id;
+
 CREATE TABLE hwvendorid (
     id integer NOT NULL,
     bus integer NOT NULL,
@@ -1309,11 +2246,27 @@
     vendor_name integer NOT NULL
 );
 
+CREATE SEQUENCE hwvendorid_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwvendorid_id_seq OWNED BY hwvendorid.id;
+
 CREATE TABLE hwvendorname (
     id integer NOT NULL,
     name text NOT NULL
 );
 
+CREATE SEQUENCE hwvendorname_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE hwvendorname_id_seq OWNED BY hwvendorname.id;
+
 CREATE TABLE ircid (
     id integer NOT NULL,
     person integer NOT NULL,
@@ -1321,12 +2274,54 @@
     nickname text NOT NULL
 );
 
+CREATE SEQUENCE ircid_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE ircid_id_seq OWNED BY ircid.id;
+
 CREATE TABLE jabberid (
     id integer NOT NULL,
     person integer NOT NULL,
     jabberid text NOT NULL
 );
 
+CREATE SEQUENCE jabberid_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE jabberid_id_seq OWNED BY jabberid.id;
+
+CREATE TABLE job (
+    id integer NOT NULL,
+    requester integer,
+    reason text,
+    status integer NOT NULL,
+    progress integer,
+    last_report_seen timestamp without time zone,
+    next_report_due timestamp without time zone,
+    attempt_count integer DEFAULT 0 NOT NULL,
+    max_retries integer DEFAULT 0 NOT NULL,
+    log text,
+    scheduled_start timestamp without time zone,
+    lease_expires timestamp without time zone,
+    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
+    date_started timestamp without time zone,
+    date_finished timestamp without time zone
+);
+
+CREATE SEQUENCE job_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE job_id_seq OWNED BY job.id;
+
 CREATE TABLE karma (
     id integer NOT NULL,
     datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
@@ -1337,6 +2332,14 @@
     sourcepackagename integer
 );
 
+CREATE SEQUENCE karma_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE karma_id_seq OWNED BY karma.id;
+
 CREATE TABLE karmaaction (
     id integer NOT NULL,
     category integer,
@@ -1346,6 +2349,14 @@
     summary text NOT NULL
 );
 
+CREATE SEQUENCE karmaaction_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE karmaaction_id_seq OWNED BY karmaaction.id;
+
 CREATE TABLE karmacache (
     id integer NOT NULL,
     person integer NOT NULL,
@@ -1361,6 +2372,14 @@
     CONSTRAINT sourcepackagename_requires_distribution CHECK (((sourcepackagename IS NULL) OR (distribution IS NOT NULL)))
 );
 
+CREATE SEQUENCE karmacache_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE karmacache_id_seq OWNED BY karmacache.id;
+
 CREATE TABLE karmacategory (
     id integer NOT NULL,
     name text NOT NULL,
@@ -1368,12 +2387,28 @@
     summary text NOT NULL
 );
 
+CREATE SEQUENCE karmacategory_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE karmacategory_id_seq OWNED BY karmacategory.id;
+
 CREATE TABLE karmatotalcache (
     id integer NOT NULL,
     person integer NOT NULL,
     karma_total integer NOT NULL
 );
 
+CREATE SEQUENCE karmatotalcache_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE karmatotalcache_id_seq OWNED BY karmatotalcache.id;
+
 CREATE TABLE language (
     id integer NOT NULL,
     code text NOT NULL,
@@ -1387,6 +2422,14 @@
     CONSTRAINT valid_language CHECK (((pluralforms IS NULL) = (pluralexpression IS NULL)))
 );
 
+CREATE SEQUENCE language_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE language_id_seq OWNED BY language.id;
+
 CREATE TABLE languagepack (
     id integer NOT NULL,
     file integer NOT NULL,
@@ -1398,6 +2441,14 @@
     CONSTRAINT valid_updates CHECK ((((type = 2) AND (updates IS NOT NULL)) OR ((type = 1) AND (updates IS NULL))))
 );
 
+CREATE SEQUENCE languagepack_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE languagepack_id_seq OWNED BY languagepack.id;
+
 CREATE TABLE launchpaddatabaserevision (
     major integer NOT NULL,
     minor integer NOT NULL,
@@ -1411,6 +2462,22 @@
     dateupdated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL
 );
 
+CREATE SEQUENCE launchpadstatistic_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE launchpadstatistic_id_seq OWNED BY launchpadstatistic.id;
+
+CREATE SEQUENCE libraryfilealias_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE libraryfilealias_id_seq OWNED BY libraryfilealias.id;
+
 CREATE TABLE libraryfilecontent (
     id integer NOT NULL,
     datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
@@ -1418,8 +2485,33 @@
     filesize integer NOT NULL,
     sha1 character(40) NOT NULL,
     deleted boolean DEFAULT false NOT NULL,
-    md5 character(32) NOT NULL
-);
+    md5 character(32) NOT NULL,
+    sha256 character(64)
+);
+
+CREATE SEQUENCE libraryfilecontent_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE libraryfilecontent_id_seq OWNED BY libraryfilecontent.id;
+
+CREATE TABLE libraryfiledownloadcount (
+    id integer NOT NULL,
+    libraryfilealias integer NOT NULL,
+    day date NOT NULL,
+    count integer NOT NULL,
+    country integer
+);
+
+CREATE SEQUENCE libraryfiledownloadcount_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE libraryfiledownloadcount_id_seq OWNED BY libraryfiledownloadcount.id;
 
 CREATE TABLE logintoken (
     id integer NOT NULL,
@@ -1435,6 +2527,14 @@
     CONSTRAINT valid_fingerprint CHECK (((fingerprint IS NULL) OR valid_fingerprint(fingerprint)))
 );
 
+CREATE SEQUENCE logintoken_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE logintoken_id_seq OWNED BY logintoken.id;
+
 CREATE TABLE mailinglist (
     id integer NOT NULL,
     team integer NOT NULL,
@@ -1447,6 +2547,14 @@
     welcome_message text
 );
 
+CREATE SEQUENCE mailinglist_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mailinglist_id_seq OWNED BY mailinglist.id;
+
 CREATE TABLE mailinglistban (
     id integer NOT NULL,
     person integer NOT NULL,
@@ -1455,6 +2563,14 @@
     reason text NOT NULL
 );
 
+CREATE SEQUENCE mailinglistban_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mailinglistban_id_seq OWNED BY mailinglistban.id;
+
 CREATE TABLE mailinglistsubscription (
     id integer NOT NULL,
     person integer NOT NULL,
@@ -1463,6 +2579,14 @@
     email_address integer
 );
 
+CREATE SEQUENCE mailinglistsubscription_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mailinglistsubscription_id_seq OWNED BY mailinglistsubscription.id;
+
 CREATE TABLE mentoringoffer (
     id integer NOT NULL,
     owner integer NOT NULL,
@@ -1473,6 +2597,29 @@
     CONSTRAINT context_required CHECK (((bug IS NULL) <> (specification IS NULL)))
 );
 
+CREATE SEQUENCE mentoringoffer_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mentoringoffer_id_seq OWNED BY mentoringoffer.id;
+
+CREATE TABLE mergedirectivejob (
+    id integer NOT NULL,
+    job integer NOT NULL,
+    merge_directive integer NOT NULL,
+    action integer NOT NULL
+);
+
+CREATE SEQUENCE mergedirectivejob_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mergedirectivejob_id_seq OWNED BY mergedirectivejob.id;
+
 CREATE TABLE message (
     id integer NOT NULL,
     datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
@@ -1485,6 +2632,14 @@
     raw integer
 );
 
+CREATE SEQUENCE message_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE message_id_seq OWNED BY message.id;
+
 CREATE TABLE messageapproval (
     id integer NOT NULL,
     posted_by integer NOT NULL,
@@ -1498,6 +2653,14 @@
     message integer NOT NULL
 );
 
+CREATE SEQUENCE messageapproval_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE messageapproval_id_seq OWNED BY messageapproval.id;
+
 CREATE TABLE messagechunk (
     id integer NOT NULL,
     message integer NOT NULL,
@@ -1508,21 +2671,38 @@
     CONSTRAINT text_or_content CHECK ((((blob IS NULL) AND (content IS NULL)) OR ((blob IS NULL) <> (content IS NULL))))
 );
 
+CREATE SEQUENCE messagechunk_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE messagechunk_id_seq OWNED BY messagechunk.id;
+
 CREATE TABLE milestone (
     id integer NOT NULL,
     product integer,
     name text NOT NULL,
     distribution integer,
     dateexpected timestamp without time zone,
-    visible boolean DEFAULT true NOT NULL,
+    active boolean DEFAULT true NOT NULL,
     productseries integer,
     distroseries integer,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
-    description text,
+    summary text,
+    codename text,
     CONSTRAINT valid_name CHECK (valid_name(name)),
     CONSTRAINT valid_target CHECK ((NOT ((product IS NULL) AND (distribution IS NULL))))
 );
 
+CREATE SEQUENCE milestone_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE milestone_id_seq OWNED BY milestone.id;
+
 CREATE TABLE mirror (
     id integer NOT NULL,
     owner integer NOT NULL,
@@ -1536,6 +2716,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE mirror_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mirror_id_seq OWNED BY mirror.id;
+
 CREATE TABLE mirrorcdimagedistroseries (
     id integer NOT NULL,
     distribution_mirror integer NOT NULL,
@@ -1544,6 +2732,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE mirrorcdimagedistroseries_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mirrorcdimagedistroseries_id_seq OWNED BY mirrorcdimagedistroseries.id;
+
 CREATE TABLE mirrorcontent (
     id integer NOT NULL,
     mirror integer NOT NULL,
@@ -1552,6 +2748,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE mirrorcontent_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mirrorcontent_id_seq OWNED BY mirrorcontent.id;
+
 CREATE TABLE mirrordistroarchseries (
     id integer NOT NULL,
     distribution_mirror integer NOT NULL,
@@ -1562,6 +2766,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE mirrordistroarchseries_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mirrordistroarchseries_id_seq OWNED BY mirrordistroarchseries.id;
+
 CREATE TABLE mirrordistroseriessource (
     id integer NOT NULL,
     distribution_mirror integer NOT NULL,
@@ -1572,6 +2784,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE mirrordistroseriessource_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mirrordistroseriessource_id_seq OWNED BY mirrordistroseriessource.id;
+
 CREATE TABLE mirrorproberecord (
     id integer NOT NULL,
     distribution_mirror integer NOT NULL,
@@ -1579,6 +2799,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL
 );
 
+CREATE SEQUENCE mirrorproberecord_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mirrorproberecord_id_seq OWNED BY mirrorproberecord.id;
+
 CREATE TABLE mirrorsourcecontent (
     id integer NOT NULL,
     mirror integer NOT NULL,
@@ -1587,6 +2815,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE mirrorsourcecontent_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE mirrorsourcecontent_id_seq OWNED BY mirrorsourcecontent.id;
+
 CREATE TABLE nameblacklist (
     id integer NOT NULL,
     regexp text NOT NULL,
@@ -1594,6 +2830,14 @@
     CONSTRAINT valid_regexp CHECK (valid_regexp(regexp))
 );
 
+CREATE SEQUENCE nameblacklist_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE nameblacklist_id_seq OWNED BY nameblacklist.id;
+
 CREATE TABLE oauthaccesstoken (
     id integer NOT NULL,
     consumer integer NOT NULL,
@@ -1611,6 +2855,14 @@
     CONSTRAINT sourcepackagename_needs_distro CHECK (((sourcepackagename IS NULL) OR (distribution IS NOT NULL)))
 );
 
+CREATE SEQUENCE oauthaccesstoken_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE oauthaccesstoken_id_seq OWNED BY oauthaccesstoken.id;
+
 CREATE TABLE oauthconsumer (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -1619,6 +2871,14 @@
     secret text
 );
 
+CREATE SEQUENCE oauthconsumer_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE oauthconsumer_id_seq OWNED BY oauthconsumer.id;
+
 CREATE TABLE oauthnonce (
     id integer NOT NULL,
     request_timestamp timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -1626,6 +2886,14 @@
     access_token integer NOT NULL
 );
 
+CREATE SEQUENCE oauthnonce_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE oauthnonce_id_seq OWNED BY oauthnonce.id;
+
 CREATE TABLE oauthrequesttoken (
     id integer NOT NULL,
     consumer integer NOT NULL,
@@ -1645,6 +2913,14 @@
     CONSTRAINT sourcepackagename_needs_distro CHECK (((sourcepackagename IS NULL) OR (distribution IS NOT NULL)))
 );
 
+CREATE SEQUENCE oauthrequesttoken_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE oauthrequesttoken_id_seq OWNED BY oauthrequesttoken.id;
+
 CREATE TABLE officialbugtag (
     id integer NOT NULL,
     tag text NOT NULL,
@@ -1654,7 +2930,15 @@
     CONSTRAINT context_required CHECK (((product IS NOT NULL) OR (distribution IS NOT NULL)))
 );
 
-CREATE TABLE openidassociations (
+CREATE SEQUENCE officialbugtag_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE officialbugtag_id_seq OWNED BY officialbugtag.id;
+
+CREATE TABLE openidassociation (
     server_url character varying(2047) NOT NULL,
     handle character varying(255) NOT NULL,
     secret bytea,
@@ -1666,13 +2950,43 @@
 
 CREATE TABLE openidauthorization (
     id integer NOT NULL,
-    person integer NOT NULL,
+    account integer NOT NULL,
     client_id text,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
     date_expires timestamp without time zone NOT NULL,
     trust_root text NOT NULL
 );
 
+CREATE SEQUENCE openidauthorization_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE openidauthorization_id_seq OWNED BY openidauthorization.id;
+
+CREATE TABLE openidconsumerassociation (
+    server_url character varying(2047) NOT NULL,
+    handle character varying(255) NOT NULL,
+    secret bytea,
+    issued integer,
+    lifetime integer,
+    assoc_type character varying(64),
+    CONSTRAINT secret_length_constraint CHECK ((length(secret) <= 128))
+);
+
+CREATE TABLE openidconsumernonce (
+    server_url character varying(2047) NOT NULL,
+    "timestamp" integer NOT NULL,
+    salt character(40) NOT NULL
+);
+
+CREATE TABLE openidnonce (
+    server_url character varying(2047) NOT NULL,
+    "timestamp" integer NOT NULL,
+    salt character(40) NOT NULL
+);
+
 CREATE TABLE openidrpconfig (
     id integer NOT NULL,
     trust_root text NOT NULL,
@@ -1680,9 +2994,19 @@
     description text NOT NULL,
     logo integer,
     allowed_sreg text,
-    creation_rationale integer DEFAULT 13 NOT NULL
+    creation_rationale integer DEFAULT 13 NOT NULL,
+    can_query_any_team boolean DEFAULT false NOT NULL,
+    auto_authorize boolean DEFAULT false NOT NULL
 );
 
+CREATE SEQUENCE openidrpconfig_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE openidrpconfig_id_seq OWNED BY openidrpconfig.id;
+
 CREATE TABLE openidrpsummary (
     id integer NOT NULL,
     account integer NOT NULL,
@@ -1693,6 +3017,14 @@
     total_logins integer DEFAULT 1 NOT NULL
 );
 
+CREATE SEQUENCE openidrpsummary_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE openidrpsummary_id_seq OWNED BY openidrpsummary.id;
+
 CREATE TABLE packagebugsupervisor (
     id integer NOT NULL,
     distribution integer NOT NULL,
@@ -1701,6 +3033,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE packagebugsupervisor_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packagebugsupervisor_id_seq OWNED BY packagebugsupervisor.id;
+
 CREATE TABLE packagecopyrequest (
     id integer NOT NULL,
     target_archive integer NOT NULL,
@@ -1720,6 +3060,14 @@
     date_completed timestamp without time zone
 );
 
+CREATE SEQUENCE packagecopyrequest_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packagecopyrequest_id_seq OWNED BY packagecopyrequest.id;
+
 CREATE TABLE packagediff (
     id integer NOT NULL,
     date_requested timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -1728,9 +3076,18 @@
     to_source integer NOT NULL,
     date_fulfilled timestamp without time zone,
     diff_content integer,
+    status integer DEFAULT 0 NOT NULL,
     CONSTRAINT distinct_sources CHECK ((from_source <> to_source))
 );
 
+CREATE SEQUENCE packagediff_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packagediff_id_seq OWNED BY packagediff.id;
+
 CREATE TABLE packageselection (
     id integer NOT NULL,
     distroseries integer NOT NULL,
@@ -1743,17 +3100,81 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE packageselection_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packageselection_id_seq OWNED BY packageselection.id;
+
+CREATE TABLE packageset (
+    id integer NOT NULL,
+    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
+    owner integer NOT NULL,
+    name text NOT NULL,
+    description text NOT NULL,
+    CONSTRAINT packageset_name_check CHECK (valid_name(name))
+);
+
+CREATE SEQUENCE packageset_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packageset_id_seq OWNED BY packageset.id;
+
+CREATE TABLE packagesetinclusion (
+    id integer NOT NULL,
+    parent integer NOT NULL,
+    child integer NOT NULL
+);
+
+CREATE SEQUENCE packagesetinclusion_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packagesetinclusion_id_seq OWNED BY packagesetinclusion.id;
+
+CREATE TABLE packagesetsources (
+    id integer NOT NULL,
+    packageset integer NOT NULL,
+    sourcepackagename integer NOT NULL
+);
+
+CREATE SEQUENCE packagesetsources_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packagesetsources_id_seq OWNED BY packagesetsources.id;
+
 CREATE TABLE packageupload (
     id integer NOT NULL,
     status integer DEFAULT 0 NOT NULL,
     distroseries integer NOT NULL,
     pocket integer NOT NULL,
-    changesfile integer NOT NULL,
+    changesfile integer,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
     signing_key integer,
     archive integer NOT NULL
 );
 
+CREATE SEQUENCE packageupload_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packageupload_id_seq OWNED BY packageupload.id;
+
 CREATE TABLE packageuploadbuild (
     id integer NOT NULL,
     packageupload integer NOT NULL,
@@ -1761,6 +3182,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE packageuploadbuild_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packageuploadbuild_id_seq OWNED BY packageuploadbuild.id;
+
 CREATE TABLE packageuploadcustom (
     id integer NOT NULL,
     packageupload integer NOT NULL,
@@ -1769,6 +3198,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE packageuploadcustom_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packageuploadcustom_id_seq OWNED BY packageuploadcustom.id;
+
 CREATE TABLE packageuploadsource (
     id integer NOT NULL,
     packageupload integer NOT NULL,
@@ -1776,6 +3213,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE packageuploadsource_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packageuploadsource_id_seq OWNED BY packageuploadsource.id;
+
 CREATE TABLE packaging (
     packaging integer NOT NULL,
     id integer DEFAULT nextval(('packaging_id_seq'::text)::regclass) NOT NULL,
@@ -1787,6 +3232,37 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE packaging_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE packaging_id_seq OWNED BY packaging.id;
+
+CREATE TABLE parsedapachelog (
+    id integer NOT NULL,
+    first_line text NOT NULL,
+    bytes_read integer NOT NULL,
+    date_last_parsed timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
+);
+
+CREATE SEQUENCE parsedapachelog_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE parsedapachelog_id_seq OWNED BY parsedapachelog.id;
+
+CREATE SEQUENCE person_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE person_id_seq OWNED BY person.id;
+
 CREATE TABLE personlanguage (
     id integer NOT NULL,
     person integer NOT NULL,
@@ -1794,6 +3270,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE personlanguage_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE personlanguage_id_seq OWNED BY personlanguage.id;
+
 CREATE TABLE personlocation (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -1808,6 +3292,14 @@
     CONSTRAINT latitude_and_longitude_together CHECK (((latitude IS NULL) = (longitude IS NULL)))
 );
 
+CREATE SEQUENCE personlocation_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE personlocation_id_seq OWNED BY personlocation.id;
+
 CREATE TABLE personnotification (
     id integer NOT NULL,
     person integer NOT NULL,
@@ -1817,6 +3309,14 @@
     subject text NOT NULL
 );
 
+CREATE SEQUENCE personnotification_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE personnotification_id_seq OWNED BY personnotification.id;
+
 CREATE TABLE pillarname (
     id integer NOT NULL,
     name text NOT NULL,
@@ -1829,6 +3329,14 @@
     CONSTRAINT valid_name CHECK (valid_name(name))
 );
 
+CREATE SEQUENCE pillarname_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE pillarname_id_seq OWNED BY pillarname.id;
+
 CREATE TABLE pocketchroot (
     id integer NOT NULL,
     distroarchseries integer,
@@ -1837,6 +3345,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE pocketchroot_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE pocketchroot_id_seq OWNED BY pocketchroot.id;
+
 CREATE TABLE pocomment (
     id integer NOT NULL,
     potemplate integer NOT NULL,
@@ -1848,6 +3364,31 @@
     person integer
 );
 
+CREATE SEQUENCE pocomment_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE pocomment_id_seq OWNED BY pocomment.id;
+
+CREATE TABLE poexportrequest (
+    id integer NOT NULL,
+    person integer NOT NULL,
+    potemplate integer NOT NULL,
+    pofile integer,
+    format integer NOT NULL,
+    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
+);
+
+CREATE SEQUENCE poexportrequest_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE poexportrequest_id_seq OWNED BY poexportrequest.id;
+
 CREATE TABLE pofile (
     id integer NOT NULL,
     potemplate integer NOT NULL,
@@ -1871,11 +3412,101 @@
     CONSTRAINT valid_variant CHECK ((variant <> ''::text))
 );
 
+CREATE SEQUENCE pofile_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE pofile_id_seq OWNED BY pofile.id;
+
+CREATE TABLE pofiletranslator (
+    id integer NOT NULL,
+    person integer NOT NULL,
+    pofile integer NOT NULL,
+    latest_message integer NOT NULL,
+    date_last_touched timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
+);
+
+CREATE SEQUENCE pofiletranslator_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE pofiletranslator_id_seq OWNED BY pofiletranslator.id;
+
+CREATE TABLE poll (
+    id integer NOT NULL,
+    team integer NOT NULL,
+    name text NOT NULL,
+    title text NOT NULL,
+    dateopens timestamp without time zone NOT NULL,
+    datecloses timestamp without time zone NOT NULL,
+    proposition text NOT NULL,
+    type integer NOT NULL,
+    allowspoilt boolean DEFAULT false NOT NULL,
+    secrecy integer NOT NULL,
+    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
+    CONSTRAINT sane_dates CHECK ((dateopens < datecloses))
+);
+
+CREATE SEQUENCE poll_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE poll_id_seq OWNED BY poll.id;
+
+CREATE TABLE polloption (
+    id integer NOT NULL,
+    poll integer NOT NULL,
+    name text NOT NULL,
+    title text NOT NULL,
+    active boolean DEFAULT true NOT NULL,
+    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
+);
+
+CREATE SEQUENCE polloption_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE polloption_id_seq OWNED BY polloption.id;
+
 CREATE TABLE pomsgid (
     id integer NOT NULL,
     msgid text NOT NULL
 );
 
+CREATE SEQUENCE pomsgid_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE pomsgid_id_seq OWNED BY pomsgid.id;
+
+CREATE TABLE posubscription (
+    id integer NOT NULL,
+    person integer NOT NULL,
+    potemplate integer NOT NULL,
+    language integer,
+    notificationinterval interval,
+    lastnotified timestamp without time zone,
+    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
+);
+
+CREATE SEQUENCE posubscription_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE posubscription_id_seq OWNED BY posubscription.id;
+
 CREATE TABLE potemplate (
     id integer NOT NULL,
     priority integer DEFAULT 0 NOT NULL,
@@ -1904,11 +3535,19 @@
     CONSTRAINT valid_link CHECK ((((productseries IS NULL) <> (distroseries IS NULL)) AND ((distroseries IS NULL) = (sourcepackagename IS NULL))))
 );
 
+CREATE SEQUENCE potemplate_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE potemplate_id_seq OWNED BY potemplate.id;
+
 CREATE TABLE potmsgset (
     id integer NOT NULL,
     msgid_singular integer NOT NULL,
-    sequence integer NOT NULL,
-    potemplate integer NOT NULL,
+    sequence integer,
+    potemplate integer,
     commenttext text,
     filereferences text,
     sourcecomment text,
@@ -1917,96 +3556,54 @@
     msgid_plural integer
 );
 
+CREATE TABLE translationtemplateitem (
+    id integer NOT NULL,
+    potemplate integer NOT NULL,
+    sequence integer NOT NULL,
+    potmsgset integer NOT NULL,
+    CONSTRAINT translationtemplateitem_sequence_check CHECK ((sequence >= 0))
+);
+
+CREATE VIEW potexport AS
+    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)));
+
+CREATE SEQUENCE potmsgset_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE potmsgset_id_seq OWNED BY potmsgset.id;
+
 CREATE TABLE potranslation (
     id integer NOT NULL,
     translation text NOT NULL
 );
 
-CREATE TABLE translationmessage (
-    id integer NOT NULL,
-    pofile integer NOT NULL,
-    potmsgset integer NOT NULL,
-    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
-    submitter integer NOT NULL,
-    date_reviewed timestamp without time zone,
-    reviewer integer,
-    msgstr0 integer,
-    msgstr1 integer,
-    msgstr2 integer,
-    msgstr3 integer,
-    comment text,
-    origin integer NOT NULL,
-    validation_status integer DEFAULT 0 NOT NULL,
-    is_current boolean DEFAULT false NOT NULL,
-    is_fuzzy boolean DEFAULT false NOT NULL,
-    is_imported boolean DEFAULT false NOT NULL,
-    was_obsolete_in_last_import boolean DEFAULT false NOT NULL,
-    was_fuzzy_in_last_import boolean DEFAULT false NOT NULL,
-    msgstr4 integer,
-    msgstr5 integer,
-    potemplate integer,
-    language integer,
-    variant text,
-    CONSTRAINT translationmessage__reviewer__date_reviewed__valid CHECK (((reviewer IS NULL) = (date_reviewed IS NULL)))
-);
-
-CREATE VIEW poexport AS
-    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)));
-
-CREATE TABLE poexportrequest (
-    id integer NOT NULL,
-    person integer NOT NULL,
-    potemplate integer NOT NULL,
-    pofile integer,
-    format integer NOT NULL,
-    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
-);
-
-CREATE TABLE pofiletranslator (
-    id integer NOT NULL,
-    person integer NOT NULL,
-    pofile integer NOT NULL,
-    latest_message integer NOT NULL,
-    date_last_touched timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
-);
-
-CREATE TABLE poll (
-    id integer NOT NULL,
-    team integer NOT NULL,
-    name text NOT NULL,
-    title text NOT NULL,
-    dateopens timestamp without time zone NOT NULL,
-    datecloses timestamp without time zone NOT NULL,
-    proposition text NOT NULL,
-    type integer NOT NULL,
-    allowspoilt boolean DEFAULT false NOT NULL,
-    secrecy integer NOT NULL,
-    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
-    CONSTRAINT is_team CHECK (is_team(team)),
-    CONSTRAINT sane_dates CHECK ((dateopens < datecloses))
-);
-
-CREATE TABLE polloption (
-    id integer NOT NULL,
-    poll integer NOT NULL,
-    name text NOT NULL,
-    title text NOT NULL,
-    active boolean DEFAULT true NOT NULL,
-    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
-);
-
-CREATE TABLE posubscription (
-    id integer NOT NULL,
-    person integer NOT NULL,
-    potemplate integer NOT NULL,
-    language integer,
-    notificationinterval interval,
-    lastnotified timestamp without time zone,
-    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
-);
-
-CREATE VIEW potexport AS
-    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)));
+CREATE SEQUENCE potranslation_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE potranslation_id_seq OWNED BY potranslation.id;
+
+CREATE TABLE previewdiff (
+    id integer NOT NULL,
+    source_revision_id text NOT NULL,
+    target_revision_id text NOT NULL,
+    dependent_revision_id text,
+    diff integer NOT NULL,
+    conflicts text
+);
+
+CREATE SEQUENCE previewdiff_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE previewdiff_id_seq OWNED BY previewdiff.id;
 
 CREATE TABLE processor (
     id integer NOT NULL,
@@ -2016,6 +3613,14 @@
     description text NOT NULL
 );
 
+CREATE SEQUENCE processor_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE processor_id_seq OWNED BY processor.id;
+
 CREATE TABLE processorfamily (
     id integer NOT NULL,
     name text NOT NULL,
@@ -2023,6 +3628,22 @@
     description text NOT NULL
 );
 
+CREATE SEQUENCE processorfamily_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE processorfamily_id_seq OWNED BY processorfamily.id;
+
+CREATE SEQUENCE product_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE product_id_seq OWNED BY product.id;
+
 CREATE TABLE productbounty (
     id integer NOT NULL,
     bounty integer NOT NULL,
@@ -2030,6 +3651,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE productbounty_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE productbounty_id_seq OWNED BY productbounty.id;
+
 CREATE TABLE productcvsmodule (
     id integer NOT NULL,
     product integer NOT NULL,
@@ -2039,26 +3668,46 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE productcvsmodule_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE productcvsmodule_id_seq OWNED BY productcvsmodule.id;
+
 CREATE TABLE productlicense (
     id integer NOT NULL,
     product integer NOT NULL,
     license integer NOT NULL
 );
 
+CREATE SEQUENCE productlicense_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE productlicense_id_seq OWNED BY productlicense.id;
+
 CREATE TABLE productrelease (
     id integer NOT NULL,
     datereleased timestamp without time zone NOT NULL,
-    version text NOT NULL,
-    codename text,
-    description text,
+    release_notes text,
     changelog text,
     owner integer NOT NULL,
-    summary text,
-    productseries integer NOT NULL,
     datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
-    CONSTRAINT valid_version CHECK (sane_version(version))
+    milestone integer NOT NULL
 );
 
+CREATE SEQUENCE productrelease_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE productrelease_id_seq OWNED BY productrelease.id;
+
 CREATE TABLE productreleasefile (
     productrelease integer NOT NULL,
     libraryfile integer NOT NULL,
@@ -2071,12 +3720,19 @@
     signature integer
 );
 
+CREATE SEQUENCE productreleasefile_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE productreleasefile_id_seq OWNED BY productreleasefile.id;
+
 CREATE TABLE productseries (
     id integer NOT NULL,
     product integer NOT NULL,
     name text NOT NULL,
     summary text NOT NULL,
-    import_branch integer,
     importstatus integer,
     datelastsynced timestamp without time zone,
     syncinterval interval,
@@ -2096,9 +3752,11 @@
     datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
     driver integer,
     owner integer NOT NULL,
-    user_branch integer,
     date_published_sync timestamp without time zone,
     status integer DEFAULT 2 NOT NULL,
+    translations_autoimport_mode integer DEFAULT 1 NOT NULL,
+    branch integer,
+    translations_branch integer,
     CONSTRAINT complete_cvs CHECK ((((cvsroot IS NULL) = (cvsmodule IS NULL)) AND ((cvsroot IS NULL) = (cvsbranch IS NULL)))),
     CONSTRAINT no_empty_strings CHECK (((((cvsroot <> ''::text) AND (cvsmodule <> ''::text)) AND (cvsbranch <> ''::text)) AND (svnrepository <> ''::text))),
     CONSTRAINT valid_importseries CHECK (((importstatus IS NULL) OR (rcstype IS NOT NULL))),
@@ -2106,12 +3764,28 @@
     CONSTRAINT valid_releasefileglob CHECK (valid_absolute_url(releasefileglob))
 );
 
+CREATE SEQUENCE productseries_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE productseries_id_seq OWNED BY productseries.id;
+
 CREATE TABLE productseriescodeimport (
     id integer NOT NULL,
     productseries integer NOT NULL,
     codeimport integer NOT NULL
 );
 
+CREATE SEQUENCE productseriescodeimport_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE productseriescodeimport_id_seq OWNED BY productseriescodeimport.id;
+
 CREATE TABLE productsvnmodule (
     id integer NOT NULL,
     product integer NOT NULL,
@@ -2120,6 +3794,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE productsvnmodule_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE productsvnmodule_id_seq OWNED BY productsvnmodule.id;
+
 CREATE TABLE project (
     id integer NOT NULL,
     owner integer NOT NULL,
@@ -2151,6 +3833,14 @@
     CONSTRAINT valid_name CHECK (valid_name(name))
 );
 
+CREATE SEQUENCE project_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE project_id_seq OWNED BY project.id;
+
 CREATE TABLE projectbounty (
     id integer NOT NULL,
     bounty integer NOT NULL,
@@ -2158,6 +3848,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE projectbounty_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE projectbounty_id_seq OWNED BY projectbounty.id;
+
 CREATE TABLE projectrelationship (
     id integer NOT NULL,
     subject integer NOT NULL,
@@ -2165,6 +3863,14 @@
     object integer NOT NULL
 );
 
+CREATE SEQUENCE projectrelationship_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE projectrelationship_id_seq OWNED BY projectrelationship.id;
+
 CREATE TABLE section (
     id integer NOT NULL,
     name text NOT NULL
@@ -2180,6 +3886,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE pushmirroraccess_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE pushmirroraccess_id_seq OWNED BY pushmirroraccess.id;
+
 CREATE TABLE question (
     id integer NOT NULL,
     owner integer NOT NULL,
@@ -2208,6 +3922,14 @@
     CONSTRAINT sourcepackagename_needs_distro CHECK (((sourcepackagename IS NULL) OR (distribution IS NOT NULL)))
 );
 
+CREATE SEQUENCE question_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE question_id_seq OWNED BY question.id;
+
 CREATE TABLE questionbug (
     id integer NOT NULL,
     question integer NOT NULL,
@@ -2215,6 +3937,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE questionbug_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE questionbug_id_seq OWNED BY questionbug.id;
+
 CREATE TABLE questionmessage (
     id integer NOT NULL,
     question integer NOT NULL,
@@ -2223,6 +3953,14 @@
     new_status integer NOT NULL
 );
 
+CREATE SEQUENCE questionmessage_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE questionmessage_id_seq OWNED BY questionmessage.id;
+
 CREATE TABLE questionreopening (
     id integer NOT NULL,
     question integer NOT NULL,
@@ -2233,6 +3971,14 @@
     priorstate integer NOT NULL
 );
 
+CREATE SEQUENCE questionreopening_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE questionreopening_id_seq OWNED BY questionreopening.id;
+
 CREATE TABLE questionsubscription (
     id integer NOT NULL,
     question integer NOT NULL,
@@ -2240,6 +3986,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE questionsubscription_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE questionsubscription_id_seq OWNED BY questionsubscription.id;
+
 CREATE TABLE requestedcds (
     id integer NOT NULL,
     request integer NOT NULL,
@@ -2252,16 +4006,21 @@
     CONSTRAINT quantityapproved_is_positive CHECK ((quantityapproved >= 0))
 );
 
-CREATE TABLE revision (
-    id integer NOT NULL,
-    date_created timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
-    log_body text NOT NULL,
-    revision_author integer NOT NULL,
-    gpgkey integer,
-    revision_id text NOT NULL,
-    revision_date timestamp without time zone,
-    karma_allocated boolean DEFAULT false
-);
+CREATE SEQUENCE requestedcds_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE requestedcds_id_seq OWNED BY requestedcds.id;
+
+CREATE SEQUENCE revision_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE revision_id_seq OWNED BY revision.id;
 
 CREATE TABLE revisionauthor (
     id integer NOT NULL,
@@ -2270,6 +4029,34 @@
     person integer
 );
 
+CREATE SEQUENCE revisionauthor_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE revisionauthor_id_seq OWNED BY revisionauthor.id;
+
+CREATE TABLE revisioncache (
+    id integer NOT NULL,
+    revision integer NOT NULL,
+    revision_author integer NOT NULL,
+    revision_date timestamp without time zone NOT NULL,
+    product integer,
+    distroseries integer,
+    sourcepackagename integer,
+    private boolean NOT NULL,
+    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)))))
+);
+
+CREATE SEQUENCE revisioncache_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE revisioncache_id_seq OWNED BY revisioncache.id;
+
 CREATE VIEW revisionnumber AS
     SELECT branchrevision.id, branchrevision.sequence, branchrevision.branch, branchrevision.revision FROM branchrevision;
 
@@ -2280,6 +4067,14 @@
     parent_id text NOT NULL
 );
 
+CREATE SEQUENCE revisionparent_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE revisionparent_id_seq OWNED BY revisionparent.id;
+
 CREATE TABLE revisionproperty (
     id integer NOT NULL,
     revision integer NOT NULL,
@@ -2287,6 +4082,14 @@
     value text NOT NULL
 );
 
+CREATE SEQUENCE revisionproperty_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE revisionproperty_id_seq OWNED BY revisionproperty.id;
+
 CREATE TABLE scriptactivity (
     id integer NOT NULL,
     name text NOT NULL,
@@ -2295,6 +4098,22 @@
     date_completed timestamp without time zone NOT NULL
 );
 
+CREATE SEQUENCE scriptactivity_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE scriptactivity_id_seq OWNED BY scriptactivity.id;
+
+CREATE SEQUENCE section_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE section_id_seq OWNED BY section.id;
+
 CREATE TABLE sectionselection (
     id integer NOT NULL,
     distroseries integer NOT NULL,
@@ -2302,6 +4121,22 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE sectionselection_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE sectionselection_id_seq OWNED BY sectionselection.id;
+
+CREATE SEQUENCE securebinarypackagepublishinghistory_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE securebinarypackagepublishinghistory_id_seq OWNED BY securebinarypackagepublishinghistory.id;
+
 CREATE TABLE securesourcepackagepublishinghistory (
     id integer NOT NULL,
     sourcepackagerelease integer NOT NULL,
@@ -2324,29 +4159,87 @@
     removal_comment text
 );
 
+CREATE SEQUENCE securesourcepackagepublishinghistory_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE securesourcepackagepublishinghistory_id_seq OWNED BY securesourcepackagepublishinghistory.id;
+
+CREATE TABLE seriessourcepackagebranch (
+    id integer NOT NULL,
+    distroseries integer NOT NULL,
+    pocket integer NOT NULL,
+    sourcepackagename integer NOT NULL,
+    branch integer NOT NULL,
+    registrant integer NOT NULL,
+    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
+);
+
+CREATE SEQUENCE seriessourcepackagebranch_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE seriessourcepackagebranch_id_seq OWNED BY seriessourcepackagebranch.id;
+
 CREATE TABLE shipitreport (
     id integer NOT NULL,
     datecreated timestamp without time zone NOT NULL,
     csvfile integer NOT NULL
 );
 
+CREATE SEQUENCE shipitreport_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE shipitreport_id_seq OWNED BY shipitreport.id;
+
 CREATE TABLE shipitsurvey (
     id integer NOT NULL,
-    person integer NOT NULL,
+    account integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
     exported boolean DEFAULT false NOT NULL
 );
 
+CREATE SEQUENCE shipitsurvey_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE shipitsurvey_id_seq OWNED BY shipitsurvey.id;
+
 CREATE TABLE shipitsurveyanswer (
     id integer NOT NULL,
     answer text NOT NULL
 );
 
+CREATE SEQUENCE shipitsurveyanswer_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE shipitsurveyanswer_id_seq OWNED BY shipitsurveyanswer.id;
+
 CREATE TABLE shipitsurveyquestion (
     id integer NOT NULL,
     question text NOT NULL
 );
 
+CREATE SEQUENCE shipitsurveyquestion_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE shipitsurveyquestion_id_seq OWNED BY shipitsurveyquestion.id;
+
 CREATE TABLE shipitsurveyresult (
     id integer NOT NULL,
     survey integer NOT NULL,
@@ -2354,6 +4247,14 @@
     answer integer
 );
 
+CREATE SEQUENCE shipitsurveyresult_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE shipitsurveyresult_id_seq OWNED BY shipitsurveyresult.id;
+
 CREATE TABLE shipment (
     id integer NOT NULL,
     logintoken text NOT NULL,
@@ -2363,6 +4264,14 @@
     trackingcode text
 );
 
+CREATE SEQUENCE shipment_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE shipment_id_seq OWNED BY shipment.id;
+
 CREATE TABLE shippingrequest (
     id integer NOT NULL,
     recipient integer NOT NULL,
@@ -2385,10 +4294,19 @@
     status integer NOT NULL,
     normalized_address text NOT NULL,
     type integer,
+    is_admin_request boolean DEFAULT false NOT NULL,
     CONSTRAINT enforce_shipped_status CHECK (((status <> 4) OR (shipment IS NOT NULL))),
     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))))
 );
 
+CREATE SEQUENCE shippingrequest_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE shippingrequest_id_seq OWNED BY shippingrequest.id;
+
 CREATE TABLE shippingrun (
     id integer NOT NULL,
     datecreated timestamp without time zone NOT NULL,
@@ -2397,6 +4315,14 @@
     requests_count integer NOT NULL
 );
 
+CREATE SEQUENCE shippingrun_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE shippingrun_id_seq OWNED BY shippingrun.id;
+
 CREATE TABLE signedcodeofconduct (
     id integer NOT NULL,
     owner integer NOT NULL,
@@ -2408,6 +4334,14 @@
     admincomment text
 );
 
+CREATE SEQUENCE signedcodeofconduct_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE signedcodeofconduct_id_seq OWNED BY signedcodeofconduct.id;
+
 CREATE TABLE sourcepackagereleasefile (
     sourcepackagerelease integer NOT NULL,
     libraryfile integer NOT NULL,
@@ -2418,9 +4352,33 @@
 CREATE VIEW sourcepackagefilepublishing AS
     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);
 
+CREATE SEQUENCE sourcepackagename_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE sourcepackagename_id_seq OWNED BY sourcepackagename.id;
+
 CREATE VIEW sourcepackagepublishinghistory AS
     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);
 
+CREATE SEQUENCE sourcepackagerelease_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE sourcepackagerelease_id_seq OWNED BY sourcepackagerelease.id;
+
+CREATE SEQUENCE sourcepackagereleasefile_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE sourcepackagereleasefile_id_seq OWNED BY sourcepackagereleasefile.id;
+
 CREATE TABLE specification (
     id integer NOT NULL,
     name text NOT NULL,
@@ -2469,6 +4427,14 @@
     CONSTRAINT valid_url CHECK (valid_absolute_url(specurl))
 );
 
+CREATE SEQUENCE specification_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE specification_id_seq OWNED BY specification.id;
+
 CREATE TABLE specificationbranch (
     id integer NOT NULL,
     datecreated timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
@@ -2478,12 +4444,28 @@
     registrant integer NOT NULL
 );
 
+CREATE SEQUENCE specificationbranch_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE specificationbranch_id_seq OWNED BY specificationbranch.id;
+
 CREATE TABLE specificationbug (
     id integer NOT NULL,
     specification integer NOT NULL,
     bug integer NOT NULL
 );
 
+CREATE SEQUENCE specificationbug_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE specificationbug_id_seq OWNED BY specificationbug.id;
+
 CREATE TABLE specificationdependency (
     id integer NOT NULL,
     specification integer NOT NULL,
@@ -2492,6 +4474,14 @@
     CONSTRAINT specificationdependency_not_self CHECK ((specification <> dependency))
 );
 
+CREATE SEQUENCE specificationdependency_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE specificationdependency_id_seq OWNED BY specificationdependency.id;
+
 CREATE TABLE specificationfeedback (
     id integer NOT NULL,
     specification integer NOT NULL,
@@ -2501,12 +4491,28 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE specificationfeedback_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE specificationfeedback_id_seq OWNED BY specificationfeedback.id;
+
 CREATE TABLE specificationmessage (
     id integer NOT NULL,
     specification integer,
     message integer
 );
 
+CREATE SEQUENCE specificationmessage_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE specificationmessage_id_seq OWNED BY specificationmessage.id;
+
 CREATE TABLE specificationsubscription (
     id integer NOT NULL,
     specification integer NOT NULL,
@@ -2515,12 +4521,28 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE specificationsubscription_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE specificationsubscription_id_seq OWNED BY specificationsubscription.id;
+
 CREATE TABLE spokenin (
     language integer NOT NULL,
     country integer NOT NULL,
     id integer DEFAULT nextval(('spokenin_id_seq'::text)::regclass) NOT NULL
 );
 
+CREATE SEQUENCE spokenin_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE spokenin_id_seq OWNED BY spokenin.id;
+
 CREATE TABLE sprint (
     id integer NOT NULL,
     owner integer NOT NULL,
@@ -2541,6 +4563,14 @@
     CONSTRAINT sprint_starts_before_ends CHECK ((time_starts < time_ends))
 );
 
+CREATE SEQUENCE sprint_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE sprint_id_seq OWNED BY sprint.id;
+
 CREATE TABLE sprintattendance (
     id integer NOT NULL,
     attendee integer NOT NULL,
@@ -2551,6 +4581,14 @@
     CONSTRAINT sprintattendance_starts_before_ends CHECK ((time_starts < time_ends))
 );
 
+CREATE SEQUENCE sprintattendance_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE sprintattendance_id_seq OWNED BY sprintattendance.id;
+
 CREATE TABLE sprintspecification (
     id integer NOT NULL,
     sprint integer NOT NULL,
@@ -2564,6 +4602,14 @@
     CONSTRAINT sprintspecification_decision_recorded CHECK (((status = 30) OR ((decider IS NOT NULL) AND (date_decided IS NOT NULL))))
 );
 
+CREATE SEQUENCE sprintspecification_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE sprintspecification_id_seq OWNED BY sprintspecification.id;
+
 CREATE TABLE sshkey (
     id integer NOT NULL,
     person integer,
@@ -2573,6 +4619,14 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE sshkey_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE sshkey_id_seq OWNED BY sshkey.id;
+
 CREATE TABLE standardshipitrequest (
     id integer NOT NULL,
     quantityx86 integer NOT NULL,
@@ -2586,6 +4640,29 @@
     CONSTRAINT quantityx86_is_positive CHECK ((quantityx86 >= 0))
 );
 
+CREATE SEQUENCE standardshipitrequest_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE standardshipitrequest_id_seq OWNED BY standardshipitrequest.id;
+
+CREATE TABLE staticdiff (
+    id integer NOT NULL,
+    from_revision_id text NOT NULL,
+    to_revision_id text NOT NULL,
+    diff integer NOT NULL
+);
+
+CREATE SEQUENCE staticdiff_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE staticdiff_id_seq OWNED BY staticdiff.id;
+
 CREATE TABLE structuralsubscription (
     id integer NOT NULL,
     product integer,
@@ -2605,6 +4682,14 @@
     CONSTRAINT sourcepackagename_requires_distribution CHECK (((sourcepackagename IS NULL) OR (distribution IS NOT NULL)))
 );
 
+CREATE SEQUENCE structuralsubscription_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE structuralsubscription_id_seq OWNED BY structuralsubscription.id;
+
 CREATE TABLE teammembership (
     id integer NOT NULL,
     person integer NOT NULL,
@@ -2627,12 +4712,28 @@
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
+CREATE SEQUENCE teammembership_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE teammembership_id_seq OWNED BY teammembership.id;
+
 CREATE TABLE teamparticipation (
     id integer NOT NULL,
     team integer NOT NULL,
     person integer NOT NULL
 );
 
+CREATE SEQUENCE teamparticipation_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE teamparticipation_id_seq OWNED BY teamparticipation.id;
+
 CREATE TABLE temporaryblobstorage (
     id integer NOT NULL,
     uuid text NOT NULL,
@@ -2640,15 +4741,32 @@
     file_alias integer NOT NULL
 );
 
+CREATE SEQUENCE temporaryblobstorage_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE temporaryblobstorage_id_seq OWNED BY temporaryblobstorage.id;
+
 CREATE TABLE translationgroup (
     id integer NOT NULL,
     name text NOT NULL,
     title text,
     summary text,
     datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
-    owner integer NOT NULL
+    owner integer NOT NULL,
+    translation_guide_url text
 );
 
+CREATE SEQUENCE translationgroup_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE translationgroup_id_seq OWNED BY translationgroup.id;
+
 CREATE TABLE translationimportqueueentry (
     id integer NOT NULL,
     path text NOT NULL,
@@ -2664,9 +4782,54 @@
     status integer DEFAULT 5 NOT NULL,
     date_status_changed timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
     format integer DEFAULT 1 NOT NULL,
+    error_output text,
     CONSTRAINT valid_link CHECK ((((productseries IS NULL) <> (distroseries IS NULL)) AND ((distroseries IS NULL) = (sourcepackagename IS NULL))))
 );
 
+CREATE SEQUENCE translationimportqueueentry_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE translationimportqueueentry_id_seq OWNED BY translationimportqueueentry.id;
+
+CREATE TABLE translationmessage (
+    id integer NOT NULL,
+    pofile integer,
+    potmsgset integer NOT NULL,
+    date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
+    submitter integer NOT NULL,
+    date_reviewed timestamp without time zone,
+    reviewer integer,
+    msgstr0 integer,
+    msgstr1 integer,
+    msgstr2 integer,
+    msgstr3 integer,
+    comment text,
+    origin integer NOT NULL,
+    validation_status integer DEFAULT 0 NOT NULL,
+    is_current boolean DEFAULT false NOT NULL,
+    is_fuzzy boolean DEFAULT false NOT NULL,
+    is_imported boolean DEFAULT false NOT NULL,
+    was_obsolete_in_last_import boolean DEFAULT false NOT NULL,
+    was_fuzzy_in_last_import boolean DEFAULT false NOT NULL,
+    msgstr4 integer,
+    msgstr5 integer,
+    potemplate integer,
+    language integer,
+    variant text,
+    CONSTRAINT translationmessage__reviewer__date_reviewed__valid CHECK (((reviewer IS NULL) = (date_reviewed IS NULL)))
+);
+
+CREATE SEQUENCE translationmessage_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE translationmessage_id_seq OWNED BY translationmessage.id;
+
 CREATE TABLE translationrelicensingagreement (
     id integer NOT NULL,
     person integer NOT NULL,
@@ -2674,21 +4837,55 @@
     date_decided timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL
 );
 
-CREATE TABLE translationtemplateitem (
-    id integer NOT NULL,
-    potemplate integer NOT NULL,
-    sequence integer NOT NULL,
-    potmsgset integer NOT NULL,
-    CONSTRAINT translationtemplateitem_sequence_check CHECK ((sequence > 0))
-);
+CREATE SEQUENCE translationrelicensingagreement_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE translationrelicensingagreement_id_seq OWNED BY translationrelicensingagreement.id;
+
+CREATE SEQUENCE translationtemplateitem_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE translationtemplateitem_id_seq OWNED BY translationtemplateitem.id;
 
 CREATE TABLE translator (
     id integer NOT NULL,
     translationgroup integer NOT NULL,
     language integer NOT NULL,
     translator integer NOT NULL,
-    datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL
-);
+    datecreated timestamp without time zone DEFAULT timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone) NOT NULL,
+    style_guide_url text
+);
+
+CREATE SEQUENCE translator_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE translator_id_seq OWNED BY translator.id;
+
+CREATE TABLE usertouseremail (
+    id integer NOT NULL,
+    sender integer NOT NULL,
+    recipient integer NOT NULL,
+    date_sent timestamp without time zone DEFAULT timezone('UTC'::text, now()) NOT NULL,
+    subject text NOT NULL,
+    message_id text NOT NULL
+);
+
+CREATE SEQUENCE usertouseremail_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE usertouseremail_id_seq OWNED BY usertouseremail.id;
 
 CREATE VIEW validpersoncache AS
     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));
@@ -2705,12 +4902,28 @@
     token text NOT NULL
 );
 
+CREATE SEQUENCE vote_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE vote_id_seq OWNED BY vote.id;
+
 CREATE TABLE votecast (
     id integer NOT NULL,
     person integer NOT NULL,
     poll integer NOT NULL
 );
 
+CREATE SEQUENCE votecast_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE votecast_id_seq OWNED BY votecast.id;
+
 CREATE TABLE webserviceban (
     id integer NOT NULL,
     date_created timestamp without time zone DEFAULT timezone('UTC'::text, now()),
@@ -2723,6 +4936,14 @@
     CONSTRAINT person_or_consumer_or_token_or_none CHECK ((null_count(ARRAY[person, consumer, token]) >= 2))
 );
 
+CREATE SEQUENCE webserviceban_id_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+ALTER SEQUENCE webserviceban_id_seq OWNED BY webserviceban.id;
+
 CREATE TABLE wikiname (
     id integer NOT NULL,
     person integer NOT NULL,
@@ -2730,1864 +4951,6 @@
     wikiname text NOT NULL
 );
 
-CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
-    AS '$libdir/plpgsql', 'plpgsql_call_handler'
-    LANGUAGE c;
-
-CREATE FUNCTION plpython_call_handler() RETURNS language_handler
-    AS '$libdir/plpython', 'plpython_call_handler'
-    LANGUAGE c;
-
-CREATE SEQUENCE account_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE account_id_seq OWNED BY account.id;
-
-CREATE SEQUENCE accountpassword_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE accountpassword_id_seq OWNED BY accountpassword.id;
-
-CREATE SEQUENCE announcement_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE announcement_id_seq OWNED BY announcement.id;
-
-CREATE SEQUENCE answercontact_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE answercontact_id_seq OWNED BY answercontact.id;
-
-CREATE SEQUENCE archive_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE archive_id_seq OWNED BY archive.id;
-
-CREATE SEQUENCE archivearch_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE archivearch_id_seq OWNED BY archivearch.id;
-
-CREATE SEQUENCE archiveauthtoken_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE archiveauthtoken_id_seq OWNED BY archiveauthtoken.id;
-
-CREATE SEQUENCE archivedependency_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE archivedependency_id_seq OWNED BY archivedependency.id;
-
-CREATE SEQUENCE archivepermission_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE archivepermission_id_seq OWNED BY archivepermission.id;
-
-CREATE SEQUENCE archivesubscriber_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE archivesubscriber_id_seq OWNED BY archivesubscriber.id;
-
-CREATE SEQUENCE binarypackagefile_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-CREATE SEQUENCE binarypackagename_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE binarypackagename_id_seq OWNED BY binarypackagename.id;
-
-CREATE SEQUENCE binarypackagerelease_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE binarypackagerelease_id_seq OWNED BY binarypackagerelease.id;
-
-CREATE SEQUENCE bounty_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bounty_id_seq OWNED BY bounty.id;
-
-CREATE SEQUENCE bountymessage_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bountymessage_id_seq OWNED BY bountymessage.id;
-
-CREATE SEQUENCE bountysubscription_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bountysubscription_id_seq OWNED BY bountysubscription.id;
-
-CREATE SEQUENCE branch_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE branch_id_seq OWNED BY branch.id;
-
-CREATE SEQUENCE branchmergeproposal_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE branchmergeproposal_id_seq OWNED BY branchmergeproposal.id;
-
-CREATE SEQUENCE branchmergerobot_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE branchmergerobot_id_seq OWNED BY branchmergerobot.id;
-
-CREATE SEQUENCE branchrelationship_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-CREATE SEQUENCE branchrevision_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE branchrevision_id_seq OWNED BY branchrevision.id;
-
-CREATE SEQUENCE branchsubscription_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE branchsubscription_id_seq OWNED BY branchsubscription.id;
-
-CREATE SEQUENCE branchvisibilitypolicy_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE branchvisibilitypolicy_id_seq OWNED BY branchvisibilitypolicy.id;
-
-CREATE SEQUENCE bug_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bug_id_seq OWNED BY bug.id;
-
-CREATE SEQUENCE bugactivity_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugactivity_id_seq OWNED BY bugactivity.id;
-
-CREATE SEQUENCE bugaffectsperson_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugaffectsperson_id_seq OWNED BY bugaffectsperson.id;
-
-CREATE SEQUENCE bugattachment_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugattachment_id_seq OWNED BY bugattachment.id;
-
-CREATE SEQUENCE bugbranch_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugbranch_id_seq OWNED BY bugbranch.id;
-
-CREATE SEQUENCE bugcve_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugcve_id_seq OWNED BY bugcve.id;
-
-CREATE SEQUENCE bugmessage_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugmessage_id_seq OWNED BY bugmessage.id;
-
-CREATE SEQUENCE bugnomination_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugnomination_id_seq OWNED BY bugnomination.id;
-
-CREATE SEQUENCE bugnotification_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugnotification_id_seq OWNED BY bugnotification.id;
-
-CREATE SEQUENCE bugnotificationrecipient_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugnotificationrecipient_id_seq OWNED BY bugnotificationrecipient.id;
-
-CREATE SEQUENCE bugpackageinfestation_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugpackageinfestation_id_seq OWNED BY bugpackageinfestation.id;
-
-CREATE SEQUENCE bugproductinfestation_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugproductinfestation_id_seq OWNED BY bugproductinfestation.id;
-
-CREATE SEQUENCE bugsubscription_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugsubscription_id_seq OWNED BY bugsubscription.id;
-
-CREATE SEQUENCE bugtag_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugtag_id_seq OWNED BY bugtag.id;
-
-CREATE SEQUENCE bugtask_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugtask_id_seq OWNED BY bugtask.id;
-
-CREATE SEQUENCE bugtracker_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugtracker_id_seq OWNED BY bugtracker.id;
-
-CREATE SEQUENCE bugtrackeralias_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugtrackeralias_id_seq OWNED BY bugtrackeralias.id;
-
-CREATE SEQUENCE bugtrackerperson_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugtrackerperson_id_seq OWNED BY bugtrackerperson.id;
-
-CREATE SEQUENCE bugwatch_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE bugwatch_id_seq OWNED BY bugwatch.id;
-
-CREATE SEQUENCE build_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE build_id_seq OWNED BY build.id;
-
-CREATE SEQUENCE builder_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE builder_id_seq OWNED BY builder.id;
-
-CREATE SEQUENCE buildqueue_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE buildqueue_id_seq OWNED BY buildqueue.id;
-
-CREATE SEQUENCE codeimport_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE codeimport_id_seq OWNED BY codeimport.id;
-
-CREATE SEQUENCE codeimportevent_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE codeimportevent_id_seq OWNED BY codeimportevent.id;
-
-CREATE SEQUENCE codeimporteventdata_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE codeimporteventdata_id_seq OWNED BY codeimporteventdata.id;
-
-CREATE SEQUENCE codeimportjob_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE codeimportjob_id_seq OWNED BY codeimportjob.id;
-
-CREATE SEQUENCE codeimportmachine_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE codeimportmachine_id_seq OWNED BY codeimportmachine.id;
-
-CREATE SEQUENCE codeimportresult_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE codeimportresult_id_seq OWNED BY codeimportresult.id;
-
-CREATE SEQUENCE codereviewmessage_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE codereviewmessage_id_seq OWNED BY codereviewmessage.id;
-
-CREATE SEQUENCE codereviewvote_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE codereviewvote_id_seq OWNED BY codereviewvote.id;
-
-CREATE SEQUENCE commercialsubscription_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE commercialsubscription_id_seq OWNED BY commercialsubscription.id;
-
-CREATE SEQUENCE component_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE component_id_seq OWNED BY component.id;
-
-CREATE SEQUENCE componentselection_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE componentselection_id_seq OWNED BY componentselection.id;
-
-CREATE SEQUENCE continent_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE continent_id_seq OWNED BY continent.id;
-
-CREATE SEQUENCE country_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE country_id_seq OWNED BY country.id;
-
-CREATE SEQUENCE customlanguagecode_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE customlanguagecode_id_seq OWNED BY customlanguagecode.id;
-
-CREATE SEQUENCE cve_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE cve_id_seq OWNED BY cve.id;
-
-CREATE SEQUENCE cvereference_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE cvereference_id_seq OWNED BY cvereference.id;
-
-CREATE SEQUENCE distribution_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE distribution_id_seq OWNED BY distribution.id;
-
-CREATE SEQUENCE distributionbounty_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE distributionbounty_id_seq OWNED BY distributionbounty.id;
-
-CREATE SEQUENCE distributionmirror_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE distributionmirror_id_seq OWNED BY distributionmirror.id;
-
-CREATE SEQUENCE distributionrole_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-CREATE SEQUENCE distributionsourcepackage_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE distributionsourcepackage_id_seq OWNED BY distributionsourcepackage.id;
-
-CREATE SEQUENCE distributionsourcepackagecache_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE distributionsourcepackagecache_id_seq OWNED BY distributionsourcepackagecache.id;
-
-CREATE SEQUENCE distroarchseries_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE distroarchseries_id_seq OWNED BY distroarchseries.id;
-
-CREATE SEQUENCE distrocomponentuploader_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE distrocomponentuploader_id_seq OWNED BY distrocomponentuploader.id;
-
-CREATE SEQUENCE distroseries_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE distroseries_id_seq OWNED BY distroseries.id;
-
-CREATE SEQUENCE distroserieslanguage_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE distroserieslanguage_id_seq OWNED BY distroserieslanguage.id;
-
-CREATE SEQUENCE distroseriespackagecache_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE distroseriespackagecache_id_seq OWNED BY distroseriespackagecache.id;
-
-CREATE SEQUENCE emailaddress_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE emailaddress_id_seq OWNED BY emailaddress.id;
-
-CREATE SEQUENCE entitlement_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE entitlement_id_seq OWNED BY entitlement.id;
-
-CREATE SEQUENCE faq_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE faq_id_seq OWNED BY faq.id;
-
-CREATE SEQUENCE featuredproject_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE featuredproject_id_seq OWNED BY featuredproject.id;
-
-CREATE SEQUENCE fticache_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE fticache_id_seq OWNED BY fticache.id;
-
-CREATE SEQUENCE gpgkey_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE gpgkey_id_seq OWNED BY gpgkey.id;
-
-CREATE SEQUENCE hwdevice_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwdevice_id_seq OWNED BY hwdevice.id;
-
-CREATE SEQUENCE hwdeviceclass_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwdeviceclass_id_seq OWNED BY hwdeviceclass.id;
-
-CREATE SEQUENCE hwdevicedriverlink_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwdevicedriverlink_id_seq OWNED BY hwdevicedriverlink.id;
-
-CREATE SEQUENCE hwdevicenamevariant_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwdevicenamevariant_id_seq OWNED BY hwdevicenamevariant.id;
-
-CREATE SEQUENCE hwdriver_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwdriver_id_seq OWNED BY hwdriver.id;
-
-CREATE SEQUENCE hwsubmission_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwsubmission_id_seq OWNED BY hwsubmission.id;
-
-CREATE SEQUENCE hwsubmissionbug_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwsubmissionbug_id_seq OWNED BY hwsubmissionbug.id;
-
-CREATE SEQUENCE hwsubmissiondevice_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwsubmissiondevice_id_seq OWNED BY hwsubmissiondevice.id;
-
-CREATE SEQUENCE hwsystemfingerprint_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwsystemfingerprint_id_seq OWNED BY hwsystemfingerprint.id;
-
-CREATE SEQUENCE hwtest_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwtest_id_seq OWNED BY hwtest.id;
-
-CREATE SEQUENCE hwtestanswer_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwtestanswer_id_seq OWNED BY hwtestanswer.id;
-
-CREATE SEQUENCE hwtestanswerchoice_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwtestanswerchoice_id_seq OWNED BY hwtestanswerchoice.id;
-
-CREATE SEQUENCE hwtestanswercount_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwtestanswercount_id_seq OWNED BY hwtestanswercount.id;
-
-CREATE SEQUENCE hwtestanswercountdevice_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwtestanswercountdevice_id_seq OWNED BY hwtestanswercountdevice.id;
-
-CREATE SEQUENCE hwtestanswerdevice_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwtestanswerdevice_id_seq OWNED BY hwtestanswerdevice.id;
-
-CREATE SEQUENCE hwvendorid_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwvendorid_id_seq OWNED BY hwvendorid.id;
-
-CREATE SEQUENCE hwvendorname_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE hwvendorname_id_seq OWNED BY hwvendorname.id;
-
-CREATE SEQUENCE ircid_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE ircid_id_seq OWNED BY ircid.id;
-
-CREATE SEQUENCE jabberid_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE jabberid_id_seq OWNED BY jabberid.id;
-
-CREATE SEQUENCE karma_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE karma_id_seq OWNED BY karma.id;
-
-CREATE SEQUENCE karmaaction_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE karmaaction_id_seq OWNED BY karmaaction.id;
-
-CREATE SEQUENCE karmacache_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE karmacache_id_seq OWNED BY karmacache.id;
-
-CREATE SEQUENCE karmacategory_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE karmacategory_id_seq OWNED BY karmacategory.id;
-
-CREATE SEQUENCE karmatotalcache_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE karmatotalcache_id_seq OWNED BY karmatotalcache.id;
-
-CREATE SEQUENCE language_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE language_id_seq OWNED BY language.id;
-
-CREATE SEQUENCE languagepack_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE languagepack_id_seq OWNED BY languagepack.id;
-
-CREATE SEQUENCE launchpadstatistic_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE launchpadstatistic_id_seq OWNED BY launchpadstatistic.id;
-
-CREATE SEQUENCE libraryfilealias_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE libraryfilealias_id_seq OWNED BY libraryfilealias.id;
-
-CREATE SEQUENCE libraryfilecontent_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE libraryfilecontent_id_seq OWNED BY libraryfilecontent.id;
-
-CREATE SEQUENCE logintoken_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE logintoken_id_seq OWNED BY logintoken.id;
-
-CREATE SEQUENCE mailinglist_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE mailinglist_id_seq OWNED BY mailinglist.id;
-
-CREATE SEQUENCE mailinglistban_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE mailinglistban_id_seq OWNED BY mailinglistban.id;
-
-CREATE SEQUENCE mailinglistsubscription_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE mailinglistsubscription_id_seq OWNED BY mailinglistsubscription.id;
-
-CREATE SEQUENCE mentoringoffer_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-ALTER SEQUENCE mentoringoffer_id_seq OWNED BY mentoringoffer.id;
-
-CREATE SEQUENCE message_id_seq
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-