Merge lp:~jml/launchpad/remove-vcs-imports into lp:launchpad/db-devel

[Jonathan Lange]

[Jonathan Lange (jml)]

This branch removes all of the dead vcs-import related columns from ProductSeries.

[Michael Hudson-Doyle (mwhudson)]

Looks absolutely fine, though you need to get stub to look at it too I guess.

The branch name is a little dramatic, perhaps :)

review: Approve

[Tim Penhey (thumper)]

On Mon, 31 Aug 2009 15:53:46 Michael Hudson wrote:
> Review: Approve
> Looks absolutely fine, though you need to get stub to look at it too I
> guess.
>
> The branch name is a little dramatic, perhaps :)

The branch name had me going WTF?

[Jonathan Lange (jml)]

> On Mon, 31 Aug 2009 15:53:46 Michael Hudson wrote:
> > Review: Approve
> > Looks absolutely fine, though you need to get stub to look at it too I
> > guess.
> >
> > The branch name is a little dramatic, perhaps :)
>
> The branch name had me going WTF?

In my head it was 'vcs-imports' as distinct from 'codeimport'. I guess I'll type more next time.

[Stuart Bishop (stub)]

Yay.

Approved as patch-2207-03-0.sql

review: Approve (db)

[Jonathan Lange (jml)]

On Tue, Sep 1, 2009 at 4:57 PM, Stuart
Bishop<email address hidden> wrote:
> Review: Approve db
> Yay.
>
> Approved as patch-2207-03-0.sql

Thanks. Do you want me to merge it in?

jml

[Jonathan Lange (jml)]

> On Tue, Sep 1, 2009 at 4:57 PM, Stuart
> Bishop<email address hidden> wrote:
> > Review: Approve db
> > Yay.
> >
> > Approved as patch-2207-03-0.sql
>
> Thanks. Do you want me to merge it in?
>
> jml

I'm taking the long silence as a "yes", and merging it in now.

jml

=== modified file 'database/sampledata/current-dev.sql'
--- database/sampledata/current-dev.sql	2009-08-25 10:53:03 +0000
+++ database/sampledata/current-dev.sql	2009-08-30 01:41:38 +0000
@@ -1489,6 +1489,13 @@
 ALTER TABLE bugnotification ENABLE TRIGGER ALL;
 
 
+ALTER TABLE bugnotificationarchive DISABLE TRIGGER ALL;
+
+
+
+ALTER TABLE bugnotificationarchive ENABLE TRIGGER ALL;
+
+
 ALTER TABLE bugnotificationattachment DISABLE TRIGGER ALL;
 
 
@@ -1503,6 +1510,13 @@
 ALTER TABLE bugnotificationrecipient ENABLE TRIGGER ALL;
 
 
+ALTER TABLE bugnotificationrecipientarchive DISABLE TRIGGER ALL;
+
+
+
+ALTER TABLE bugnotificationrecipientarchive ENABLE TRIGGER ALL;
+
+
 ALTER TABLE bugpackageinfestation DISABLE TRIGGER ALL;
 
 
@@ -7946,47 +7960,47 @@
 
 ALTER TABLE productseries DISABLE TRIGGER ALL;
 
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (1, 4, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.895136', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (2, 4, '1.0', 'The 1.0 branch of the Mozilla web browser. Currently, this is the stable branch of Mozilla, and all stable releases are made off this branch.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.898385', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (3, 5, 'trunk', 'The primary "trunk" of development for this product. This series
-was automatically created and represents the idea of a primary trunk
-of software development without "stable branches". For most
-products, releases in this series will be "milestone" or "test"
-releases, and there should be other series for the stable releases
-of the product.', 5, NULL, NULL, 1, ':pserver:[e-mail]:/cvs/gnome', 'evolution', 'MAIN', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.914873', NULL, 12, NULL, 2, 1, 14, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (4, 8, 'trunk', 'The primary "trunk" of development for this product. This series
-was automatically created and represents the idea of a primary trunk
-of software development without "stable branches". For most
-products, releases in this series will be "milestone" or "test"
-releases, and there should be other series for the stable releases
-of the product.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.91214', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (5, 11, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.899819', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (6, 12, 'trunk', 'The primary upstream development branch, from which all releases are made.', 2, NULL, NULL, 1, ':pserver:[e-mail]:/cvsroot/liba52', 'a52dec', 'MAIN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (7, 12, 'failedbranch', 'A branch where auto test has failed.', 3, NULL, NULL, 1, ':pserver:[e-mail]:/cvsroot/liba52', 'a52dec', 'AUTOTESTFAILED', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (8, 15, 'trunk', 'The mainline for alsa-utils', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-09-15 09:10:03.531637', NULL, 1, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (9, 16, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-07-11 19:59:17.311451', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (10, 14, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (11, 13, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (12, 9, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (13, 7, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (14, 6, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (15, 3, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 2, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (16, 1, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 17, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (17, 2, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (18, 10, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (19, 17, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-11-24 12:48:19.178553', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (20, 18, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-14 18:47:04.891546', NULL, 37, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (21, 19, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-14 18:53:13.112116', NULL, 28, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (22, 20, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-15 20:11:49.501871', NULL, 14, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (23, 21, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-27 16:28:27.763632', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (24, 22, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-04-18 20:58:56.846607', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (25, 23, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-11-19 12:44:30.603892', NULL, 1, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (26, 24, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-06-27 14:51:47.366199', NULL, 243623, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (27, 25, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-10-02 10:12:40.909504', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (28, 26, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-05-02 21:33:15.310312', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (29, 27, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-08-24 14:36:04.699204', NULL, 243648, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (30, 28, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-08-24 14:39:04.708167', NULL, 243649, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (31, 29, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-08-24 14:41:04.427117', NULL, 243650, NULL, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (1, 4, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2005-06-06 08:59:51.895136', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (2, 4, '1.0', 'The 1.0 branch of the Mozilla web browser. Currently, this is the stable branch of Mozilla, and all stable releases are made off this branch.', NULL, NULL, '2005-06-06 08:59:51.898385', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (3, 5, 'trunk', 'The primary "trunk" of development for this product. This series
+was automatically created and represents the idea of a primary trunk
+of software development without "stable branches". For most
+products, releases in this series will be "milestone" or "test"
+releases, and there should be other series for the stable releases
+of the product.', NULL, NULL, '2005-06-06 08:59:51.914873', NULL, 12, 2, 1, 14, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (4, 8, 'trunk', 'The primary "trunk" of development for this product. This series
+was automatically created and represents the idea of a primary trunk
+of software development without "stable branches". For most
+products, releases in this series will be "milestone" or "test"
+releases, and there should be other series for the stable releases
+of the product.', NULL, NULL, '2005-06-06 08:59:51.91214', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (5, 11, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2005-06-06 08:59:51.899819', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (6, 12, 'trunk', 'The primary upstream development branch, from which all releases are made.', NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (7, 12, 'failedbranch', 'A branch where auto test has failed.', NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (8, 15, 'trunk', 'The mainline for alsa-utils', NULL, NULL, '2005-09-15 09:10:03.531637', NULL, 1, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (9, 16, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-07-11 19:59:17.311451', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (10, 14, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (11, 13, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (12, 9, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (13, 7, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (14, 6, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (15, 3, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 2, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (16, 1, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 17, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (17, 2, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (18, 10, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (19, 17, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-11-24 12:48:19.178553', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (20, 18, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-14 18:47:04.891546', NULL, 37, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (21, 19, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-14 18:53:13.112116', NULL, 28, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (22, 20, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-15 20:11:49.501871', NULL, 14, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (23, 21, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-27 16:28:27.763632', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (24, 22, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-04-18 20:58:56.846607', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (25, 23, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-11-19 12:44:30.603892', NULL, 1, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (26, 24, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2008-06-27 14:51:47.366199', NULL, 243623, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (27, 25, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2008-10-02 10:12:40.909504', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (28, 26, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2009-05-02 21:33:15.310312', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (29, 27, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2009-08-24 14:36:04.699204', NULL, 243648, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (30, 28, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2009-08-24 14:39:04.708167', NULL, 243649, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (31, 29, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2009-08-24 14:41:04.427117', NULL, 243650, 2, 1, NULL, NULL);
 
 
 ALTER TABLE productseries ENABLE TRIGGER ALL;

=== modified file 'database/sampledata/current.sql'
--- database/sampledata/current.sql	2009-08-14 18:31:17 +0000
+++ database/sampledata/current.sql	2009-08-30 01:41:38 +0000
@@ -1471,6 +1471,13 @@
 ALTER TABLE bugnotification ENABLE TRIGGER ALL;
 
 
+ALTER TABLE bugnotificationarchive DISABLE TRIGGER ALL;
+
+
+
+ALTER TABLE bugnotificationarchive ENABLE TRIGGER ALL;
+
+
 ALTER TABLE bugnotificationattachment DISABLE TRIGGER ALL;
 
 
@@ -1485,6 +1492,13 @@
 ALTER TABLE bugnotificationrecipient ENABLE TRIGGER ALL;
 
 
+ALTER TABLE bugnotificationrecipientarchive DISABLE TRIGGER ALL;
+
+
+
+ALTER TABLE bugnotificationrecipientarchive ENABLE TRIGGER ALL;
+
+
 ALTER TABLE bugpackageinfestation DISABLE TRIGGER ALL;
 
 
@@ -7880,44 +7894,44 @@
 
 ALTER TABLE productseries DISABLE TRIGGER ALL;
 
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (1, 4, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.895136', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (2, 4, '1.0', 'The 1.0 branch of the Mozilla web browser. Currently, this is the stable branch of Mozilla, and all stable releases are made off this branch.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.898385', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (3, 5, 'trunk', 'The primary "trunk" of development for this product. This series
-was automatically created and represents the idea of a primary trunk
-of software development without "stable branches". For most
-products, releases in this series will be "milestone" or "test"
-releases, and there should be other series for the stable releases
-of the product.', 5, NULL, NULL, 1, ':pserver:[e-mail]:/cvs/gnome', 'evolution', 'MAIN', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.914873', NULL, 12, NULL, 2, 1, 14, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (4, 8, 'trunk', 'The primary "trunk" of development for this product. This series
-was automatically created and represents the idea of a primary trunk
-of software development without "stable branches". For most
-products, releases in this series will be "milestone" or "test"
-releases, and there should be other series for the stable releases
-of the product.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.91214', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (5, 11, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.899819', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (6, 12, 'trunk', 'The primary upstream development branch, from which all releases are made.', 2, NULL, NULL, 1, ':pserver:[e-mail]:/cvsroot/liba52', 'a52dec', 'MAIN', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (7, 12, 'failedbranch', 'A branch where auto test has failed.', 3, NULL, NULL, 1, ':pserver:[e-mail]:/cvsroot/liba52', 'a52dec', 'AUTOTESTFAILED', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (8, 15, 'trunk', 'The mainline for alsa-utils', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-09-15 09:10:03.531637', NULL, 1, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (9, 16, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-07-11 19:59:17.311451', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (10, 14, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (11, 13, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (12, 9, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (13, 7, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (14, 6, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (15, 3, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 2, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (16, 1, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 17, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (17, 2, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (18, 10, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (19, 17, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2006-11-24 12:48:19.178553', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (20, 18, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-14 18:47:04.891546', NULL, 37, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (21, 19, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-14 18:53:13.112116', NULL, 28, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (22, 20, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-15 20:11:49.501871', NULL, 14, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (23, 21, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-03-27 16:28:27.763632', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (24, 22, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-04-18 20:58:56.846607', NULL, 12, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (25, 23, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-11-19 12:44:30.603892', NULL, 1, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (26, 24, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-06-27 14:51:47.366199', NULL, 243623, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (27, 25, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2008-10-02 10:12:40.909504', NULL, 16, NULL, 2, 1, NULL, NULL);
-INSERT INTO productseries (id, product, name, summary, importstatus, datelastsynced, syncinterval, rcstype, cvsroot, cvsmodule, cvsbranch, cvstarfileurl, svnrepository, releasefileglob, releaseverstyle, dateautotested, dateprocessapproved, datesyncapproved, datestarted, datefinished, datecreated, driver, owner, date_published_sync, status, translations_autoimport_mode, branch, translations_branch) VALUES (28, 26, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-05-02 21:33:15.310312', NULL, 16, NULL, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (1, 4, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2005-06-06 08:59:51.895136', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (2, 4, '1.0', 'The 1.0 branch of the Mozilla web browser. Currently, this is the stable branch of Mozilla, and all stable releases are made off this branch.', NULL, NULL, '2005-06-06 08:59:51.898385', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (3, 5, 'trunk', 'The primary "trunk" of development for this product. This series
+was automatically created and represents the idea of a primary trunk
+of software development without "stable branches". For most
+products, releases in this series will be "milestone" or "test"
+releases, and there should be other series for the stable releases
+of the product.', NULL, NULL, '2005-06-06 08:59:51.914873', NULL, 12, 2, 1, 14, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (4, 8, 'trunk', 'The primary "trunk" of development for this product. This series
+was automatically created and represents the idea of a primary trunk
+of software development without "stable branches". For most
+products, releases in this series will be "milestone" or "test"
+releases, and there should be other series for the stable releases
+of the product.', NULL, NULL, '2005-06-06 08:59:51.91214', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (5, 11, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2005-06-06 08:59:51.899819', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (6, 12, 'trunk', 'The primary upstream development branch, from which all releases are made.', NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (7, 12, 'failedbranch', 'A branch where auto test has failed.', NULL, NULL, '2005-06-06 08:59:51.913564', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (8, 15, 'trunk', 'The mainline for alsa-utils', NULL, NULL, '2005-09-15 09:10:03.531637', NULL, 1, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (9, 16, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-07-11 19:59:17.311451', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (10, 14, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (11, 13, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (12, 9, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (13, 7, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (14, 6, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (15, 3, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 2, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (16, 1, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-11 06:16:00.934312', NULL, 17, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (17, 2, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (18, 10, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-09-14 07:56:10.631636', NULL, 2, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (19, 17, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2006-11-24 12:48:19.178553', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (20, 18, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-14 18:47:04.891546', NULL, 37, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (21, 19, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-14 18:53:13.112116', NULL, 28, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (22, 20, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-15 20:11:49.501871', NULL, 14, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (23, 21, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-03-27 16:28:27.763632', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (24, 22, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-04-18 20:58:56.846607', NULL, 12, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (25, 23, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2007-11-19 12:44:30.603892', NULL, 1, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (26, 24, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2008-06-27 14:51:47.366199', NULL, 243623, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (27, 25, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2008-10-02 10:12:40.909504', NULL, 16, 2, 1, NULL, NULL);
+INSERT INTO productseries (id, product, name, summary, releasefileglob, releaseverstyle, datecreated, driver, owner, status, translations_autoimport_mode, branch, translations_branch) VALUES (28, 26, 'trunk', 'The "trunk" series represents the primary line of development rather than a stable release branch. This is sometimes also called MAIN or HEAD.', NULL, NULL, '2009-05-02 21:33:15.310312', NULL, 16, 2, 1, NULL, NULL);
 
 
 ALTER TABLE productseries ENABLE TRIGGER ALL;

=== modified file 'database/schema/comments.sql'
--- database/schema/comments.sql	2009-07-17 00:26:05 +0000
+++ database/schema/comments.sql	2009-08-30 01:41:38 +0000
@@ -630,32 +630,6 @@
 COMMENT ON COLUMN ProductSeries.status IS 'The current status of this productseries.';
 COMMENT ON COLUMN ProductSeries.summary IS 'A summary of this Product Series. A good example would include the date the series was initiated and whether this is the current recommended series for people to use. The summary is usually displayed at the top of the page, in bold, just beneath the title and above the description, if there is a description field.';
 COMMENT ON COLUMN ProductSeries.driver IS 'This is a person or team who can approve spes and bugs for implementation or fixing in this specific series. Note that the product drivers and project drivers can also do this for any series in the product or project, so use this only for the specific team responsible for this specific series.';
-COMMENT ON COLUMN ProductSeries.importstatus IS 'A status flag which
-gives the state of our efforts to import the upstream code from its revision
-control system and publish that in the baz revision control system. The
-allowed values are documented in ImportStatus.';
-COMMENT ON COLUMN ProductSeries.rcstype IS 'The revision control system used
-by upstream for this product series. The value is defined in
-dbschema.RevisionControlSystems.  If NULL, then there should be no CVS or
-SVN information attached to this productseries, otherwise the relevant
-fields for CVS or SVN etc should be filled out.';
-COMMENT ON COLUMN ProductSeries.cvsroot IS 'The CVS root where this
-productseries hosts its code. Only used if rcstype is CVS.';
-COMMENT ON COLUMN ProductSeries.cvsmodule IS 'The CVS module which contains
-the upstream code for this productseries. Only used if rcstype is CVS.';
-COMMENT ON COLUMN ProductSeries.cvsmodule IS 'The CVS branch that contains
-the upstream code for this productseries.  Only used if rcstype is CVS.';
-COMMENT ON COLUMN ProductSeries.cvstarfileurl IS 'The URL of a tarfile of
-the CVS repository for this productseries. This is an optimisation of the
-CVS import process - instead of hitting the server to pass us every set of
-changes in history, we can sometimes arrange to be given a tarfile of the
-CVS repository and then process it all locally. Once imported, we switch
-back to using the CVS server for ongoing syncronization.  Only used if
-rcstype is CVS.';
-COMMENT ON COLUMN ProductSeries.svnrepository IS 'The URL of the SVN branch
-where the upstream productseries code can be found. This single URL is the
-equivalent of the cvsroot, cvsmodule and cvsbranch for CVS. Only used if
-rcstype is SVN.';
 COMMENT ON COLUMN ProductSeries.releasefileglob IS 'A fileglob that lets us
 see which URLs are potentially new upstream tarball releases. For example:
 http://ftp.gnu.org/gnu/libtool/libtool-1.5.*.gz.';
@@ -663,25 +637,6 @@
 of this product series release version numbering system.  The options are
 documented in dbschema.UpstreamReleaseVersionStyle.  Most applications use
 Gnu style numbering, but there are other alternatives.';
-COMMENT ON COLUMN ProductSeries.dateprocessapproved IS 'The timestamp when
-this upstream import was certified for processing. Processing means it has
-passed autotesting, and is being moved towards production syncing. If the
-sync goes well, it will be approved for sync and then be fully in
-production.';
-COMMENT ON COLUMN ProductSeries.datesyncapproved IS 'The timestamp when this
-upstream import was certified for ongoing syncronisation.';
-COMMENT ON COLUMN ProductSeries.dateautotested IS 'This upstream revision
-control system target has passed automatic testing. It can probably be moved
-towards production sync status. This date is the timestamp when it passed
-the autotester. The autotester allows us to find the low hanging fruit that
-is easily brought into the bazaar import system by highlighting repositories
-which had no apparent difficulty in being imported.';
-COMMENT ON COLUMN ProductSeries.datestarted IS 'The timestamp when we last
-initiated an import test or sync of this upstream repository.';
-COMMENT ON COLUMN ProductSeries.datefinished IS 'The timestamp when we last
-completed an import test or sync of this upstream repository.';
-COMMENT ON COLUMN ProductSeries.datelastsynced IS 'The timestamp when we last successfully completed a production sync of this upstream repository.';
-COMMENT ON COLUMN ProductSeries.date_published_sync IS 'The saved value of datelastsynced from the last time it was older than the corresponding branch''s last_mirrored timestamp. The timestamp currently published import branch is either datelastsynced or datepublishedsync.';
 COMMENT ON COLUMN ProductSeries.branch IS 'The branch for this product
 series.';
 COMMENT ON COLUMN ProductSeries.translations_autoimport_mode IS 'Level of

=== added file 'database/schema/patch-2207-99-0.sql'
--- database/schema/patch-2207-99-0.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2207-99-0.sql	2009-08-30 01:41:38 +0000
@@ -0,0 +1,48 @@
+SET client_min_messages=ERROR;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN importstatus;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN datelastsynced;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN syncinterval;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN rcstype;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN cvsroot;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN cvsmodule;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN cvsbranch;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN cvstarfileurl;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN svnrepository;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN dateautotested;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN dateprocessapproved;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN datesyncapproved;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN datestarted;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN datefinished;
+
+ALTER TABLE ProductSeries
+    DROP COLUMN date_published_sync;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 99, 0);