← Back to team overview

launchpad-reviewers team mailing list archive

[Merge] ~lgp171188/launchpad:update-sampledata into launchpad:master

 

Guruprasad has proposed merging ~lgp171188/launchpad:update-sampledata into launchpad:master.

Commit message:
Update the sampledata for the recent database changes

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~lgp171188/launchpad/+git/launchpad/+merge/419302
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of ~lgp171188/launchpad:update-sampledata into launchpad:master.
diff --git a/database/sampledata/current-dev.sql b/database/sampledata/current-dev.sql
index 7af2686..3fd98d5 100644
--- a/database/sampledata/current-dev.sql
+++ b/database/sampledata/current-dev.sql
@@ -971,22 +971,22 @@ ALTER TABLE public.translationgroup ENABLE TRIGGER ALL;
 
 ALTER TABLE public.distribution DISABLE TRIGGER ALL;
 
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (1, 'ubuntu', 'Ubuntu Linux', 'Ubuntu is a new approach to Linux Distribution that includes regular releases, and a simplified single-CD installation system.', 'ubuntulinux.org', 17, 'Ubuntu', 'Ubuntu is a new approach to Linux Distribution that includes regular releases, and a simplified single-CD installation system.', 17, NULL, 1, NULL, true, true, NULL, 3, 59, NULL, '2006-10-16 18:31:43.415195', NULL, NULL, NULL, NULL, NULL, true, NULL, true, true, NULL, NULL, NULL, NULL, 20, 20, 20, 60, '{package_name}_derivatives@xxxxxxxxxxxxxxxxxxxxxx', false, NULL, true, true, true, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (2, 'redhat', 'Redhat Advanced Server', 'Red Hat is a commercial distribution of the GNU/Linux Operating System.', 'redhat.com', 1, 'Red Hat', 'Red Hat is a commercial distribution of the GNU/Linux Operating System.', 1, NULL, 1, NULL, false, false, 8, NULL, 1, NULL, '2006-10-16 18:31:43.417928', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (3, 'debian', 'Debian GNU/Linux', 'Debian GNU/Linux is
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (1, 'ubuntu', 'Ubuntu Linux', 'Ubuntu is a new approach to Linux Distribution that includes regular releases, and a simplified single-CD installation system.', 'ubuntulinux.org', 17, 'Ubuntu', 'Ubuntu is a new approach to Linux Distribution that includes regular releases, and a simplified single-CD installation system.', 17, NULL, 1, NULL, true, true, NULL, 3, 59, NULL, '2006-10-16 18:31:43.415195', NULL, NULL, NULL, NULL, NULL, true, NULL, true, true, NULL, NULL, NULL, NULL, 20, 20, 20, 60, '{package_name}_derivatives@xxxxxxxxxxxxxxxxxxxxxx', false, NULL, true, true, true, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (2, 'redhat', 'Redhat Advanced Server', 'Red Hat is a commercial distribution of the GNU/Linux Operating System.', 'redhat.com', 1, 'Red Hat', 'Red Hat is a commercial distribution of the GNU/Linux Operating System.', 1, NULL, 1, NULL, false, false, 8, NULL, 1, NULL, '2006-10-16 18:31:43.417928', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (3, 'debian', 'Debian GNU/Linux', 'Debian GNU/Linux is
 a non commercial distribution of a GNU/Linux Operating System for many
 platforms.', 'debian.org', 1, 'Debian', 'Debian GNU/Linux is
 a non commercial distribution of a GNU/Linux Operating System for many
-platforms.', 1, NULL, 1, NULL, false, false, NULL, NULL, 1, NULL, '2006-10-16 18:31:43.418942', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (4, 'gentoo', 'The Gentoo Linux', 'Gentoo is a very
+platforms.', 1, NULL, 1, NULL, false, false, NULL, NULL, 1, NULL, '2006-10-16 18:31:43.418942', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (4, 'gentoo', 'The Gentoo Linux', 'Gentoo is a very
 customizeable GNU/Linux Distribution that is designed to let you build every
-single package yourself, with your own preferences.', 'gentoo.org', 1, 'Gentoo', 'Gentoo is a very customizeable GNU/Linux Distribution that is designed to let you build every single package yourself, with your own preferences.', 1, NULL, 1, NULL, true, false, NULL, NULL, 1, NULL, '2006-10-16 18:31:43.41974', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (5, 'kubuntu', 'Kubuntu - Free KDE-based Linux', 'Kubuntu is an entirely free Linux distribution that uses the K Desktop
+single package yourself, with your own preferences.', 'gentoo.org', 1, 'Gentoo', 'Gentoo is a very customizeable GNU/Linux Distribution that is designed to let you build every single package yourself, with your own preferences.', 1, NULL, 1, NULL, true, false, NULL, NULL, 1, NULL, '2006-10-16 18:31:43.41974', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (5, 'kubuntu', 'Kubuntu - Free KDE-based Linux', 'Kubuntu is an entirely free Linux distribution that uses the K Desktop
 Environment as its default desktop after install.', 'kubuntu.org', 1, 'Kubuntu', 'Kubuntu is an entirely free Linux distribution that uses the K Desktop
-Environment as its default desktop after install.', 1, NULL, 1, NULL, false, false, 8, NULL, 1, NULL, '2006-10-16 18:31:43.420551', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (7, 'guadalinex', 'GuadaLinex: Linux for Andalucia', 'GuadaLinex is based on Ubuntu and adds full support for applications specific to the local environment in Andalucia.', 'guadalinex.es', 4, 'GuadaLinex', 'The GuadaLinex team produces a high quality linux for the Andalucian marketplace.', 32, NULL, 1, NULL, false, false, NULL, NULL, 4, NULL, '2006-10-16 18:31:43.421329', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (8, 'ubuntutest', 'Ubuntu Test', 'Ubuntu Test', 'ubuntulinux.org', 17, 'ubuntutest', 'Ubuntu Test summary', 17, NULL, 1, NULL, false, false, NULL, NULL, 17, NULL, '2006-10-16 18:31:43.422162', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (9, 'deribuntu', 'Deribuntu', 'Deribuntu', 'deribuntu', 16, 'Deribuntu', 'Deribuntu', 16, NULL, 1, NULL, false, false, NULL, NULL, 16, NULL, '2011-03-17 14:28:54.354337', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
+Environment as its default desktop after install.', 1, NULL, 1, NULL, false, false, 8, NULL, 1, NULL, '2006-10-16 18:31:43.420551', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (7, 'guadalinex', 'GuadaLinex: Linux for Andalucia', 'GuadaLinex is based on Ubuntu and adds full support for applications specific to the local environment in Andalucia.', 'guadalinex.es', 4, 'GuadaLinex', 'The GuadaLinex team produces a high quality linux for the Andalucian marketplace.', 32, NULL, 1, NULL, false, false, NULL, NULL, 4, NULL, '2006-10-16 18:31:43.421329', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (8, 'ubuntutest', 'Ubuntu Test', 'Ubuntu Test', 'ubuntulinux.org', 17, 'ubuntutest', 'Ubuntu Test summary', 17, NULL, 1, NULL, false, false, NULL, NULL, 17, NULL, '2006-10-16 18:31:43.422162', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (9, 'deribuntu', 'Deribuntu', 'Deribuntu', 'deribuntu', 16, 'Deribuntu', 'Deribuntu', 16, NULL, 1, NULL, false, false, NULL, NULL, 16, NULL, '2011-03-17 14:28:54.354337', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
 
 
 ALTER TABLE public.distribution ENABLE TRIGGER ALL;
@@ -1227,19 +1227,19 @@ ALTER TABLE public.branch ENABLE TRIGGER ALL;
 
 ALTER TABLE public.bug DISABLE TRIGGER ALL;
 
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (1, '2004-01-01 20:58:04.553583', NULL, 'Firefox does not support SVG', 'Firefox needs to support embedded SVG images, now that the standard has been finalised.
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (1, '2004-01-01 20:58:04.553583', NULL, 'Firefox does not support SVG', 'Firefox needs to support embedded SVG images, now that the standard has been finalised.
 
-The SVG standard 1.0 is complete, and draft implementations for Firefox exist. One of these implementations needs to be integrated with the base install of Firefox. Ideally, the implementation needs to include support for the manipulation of SVG objects from JavaScript to enable interactive and dynamic SVG drawings.', 12, NULL, NULL, '2006-05-19 06:37:40.344941', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (2, '2004-01-02 20:58:04.572546', 'blackhole', 'Blackhole Trash folder', 'The Trash folder seems to have significant problems! At the moment, dragging an item to the trash results in immediate deletion. The item does not appear in the Trash, it is just deleted from my hard disk. There is no undo or ability to recover the deleted file. Help!', 12, NULL, NULL, '2006-07-14 08:47:36.124403', NULL, NULL, NULL, 0, 3, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (3, '2004-01-03 00:00:00', NULL, 'Bug Title Test', 'Shirtpkdf user@xxxxxxxxxx lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo
+The SVG standard 1.0 is complete, and draft implementations for Firefox exist. One of these implementations needs to be integrated with the base install of Firefox. Ideally, the implementation needs to include support for the manipulation of SVG objects from JavaScript to enable interactive and dynamic SVG drawings.', 12, NULL, NULL, '2022-04-11 10:21:37.227528', NULL, NULL, NULL, 0, 2, 0, 0, 4, '2022-04-11 10:21:37.028851', NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (2, '2004-01-02 20:58:04.572546', 'blackhole', 'Blackhole Trash folder', 'The Trash folder seems to have significant problems! At the moment, dragging an item to the trash results in immediate deletion. The item does not appear in the Trash, it is just deleted from my hard disk. There is no undo or ability to recover the deleted file. Help!', 12, NULL, NULL, '2006-07-14 08:47:36.124403', NULL, NULL, NULL, 0, 3, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (3, '2004-01-03 00:00:00', NULL, 'Bug Title Test', 'Shirtpkdf user@xxxxxxxxxx lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo
 
 y idu yifdxhfgffxShirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xoShirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo
 Shirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xoShirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo
 
-Shirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xoShirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo', 16, NULL, NULL, '2006-07-14 08:48:52.922462', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (4, '2004-01-04 00:00:00', NULL, 'Reflow problems with complex page layouts', 'Malone pages that use more complex layouts with portlets and fancy CSS are sometimes not getting properly reflowed after rendering.', 12, NULL, NULL, '2006-07-14 08:49:17.124885', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (5, '2004-01-05 00:00:00', NULL, 'Firefox install instructions should be complete', 'All ways of downloading firefox should provide complete install instructions. At present, they are only visible on the Release Notes page.', 12, NULL, NULL, '2006-07-14 08:49:40.553212', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (6, '2004-01-06 00:00:00', NULL, 'Firefox crashes when Save As dialog for a nonexistent window is closed', 'User-Agent:
+Shirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xoShirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo', 16, NULL, NULL, '2006-07-14 08:48:52.922462', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (4, '2004-01-04 00:00:00', NULL, 'Reflow problems with complex page layouts', 'Malone pages that use more complex layouts with portlets and fancy CSS are sometimes not getting properly reflowed after rendering.', 12, NULL, NULL, '2006-07-14 08:49:17.124885', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (5, '2004-01-05 00:00:00', NULL, 'Firefox install instructions should be complete', 'All ways of downloading firefox should provide complete install instructions. At present, they are only visible on the Release Notes page.', 12, NULL, NULL, '2006-07-14 08:49:40.553212', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (6, '2004-01-06 00:00:00', NULL, 'Firefox crashes when Save As dialog for a nonexistent window is closed', 'User-Agent:
 Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040207 Firefox/0.8
 
 If a Save As dialog for a nonexistent window exists, when the dialog is closed Firefox will crash.  It''s possible to cause this to happen using the "Open With/Save As" dialog.
@@ -1258,12 +1258,12 @@ Actual Results:
 Crash!
 
 Expected Results:
-Not crashed.', 12, 5, NULL, '2006-05-19 06:37:40.389193', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (7, '2004-01-07 15:12:29.602117', NULL, 'A test bug', 'A test description', 16, NULL, NULL, '2006-05-19 06:37:40.391822', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (8, '2004-01-08 09:10:17.13237', NULL, 'Printing doesn''t work', 'When I press print in Firefox, nothing happens, not even a print dialog comes up.', 12, NULL, NULL, '2006-05-19 06:37:40.393303', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (9, '2004-01-09 16:42:14.080227', NULL, 'Thunderbird crashes', 'Every time I start Thunderbird it crashes.', 16, NULL, NULL, '2006-07-14 08:45:10.600579', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (10, '2004-01-10 19:42:21.890299', NULL, 'another test bug', 'test bug', 16, NULL, NULL, '2006-07-14 08:54:19.453881', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (11, '2007-03-15 20:33:56.67893', NULL, 'Make Jokosher use autoaudiosink', 'I''ve had problems when switching from Jokosher to Totem to play an Ogg.
+Not crashed.', 12, 5, NULL, '2006-05-19 06:37:40.389193', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (7, '2004-01-07 15:12:29.602117', NULL, 'A test bug', 'A test description', 16, NULL, NULL, '2006-05-19 06:37:40.391822', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (8, '2004-01-08 09:10:17.13237', NULL, 'Printing doesn''t work', 'When I press print in Firefox, nothing happens, not even a print dialog comes up.', 12, NULL, NULL, '2006-05-19 06:37:40.393303', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (9, '2004-01-09 16:42:14.080227', NULL, 'Thunderbird crashes', 'Every time I start Thunderbird it crashes.', 16, NULL, NULL, '2006-07-14 08:45:10.600579', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (10, '2004-01-10 19:42:21.890299', NULL, 'another test bug', 'test bug', 16, NULL, NULL, '2006-07-14 08:54:19.453881', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (11, '2007-03-15 20:33:56.67893', NULL, 'Make Jokosher use autoaudiosink', 'I''ve had problems when switching from Jokosher to Totem to play an Ogg.
 
 Totem appears to be playing normally but does not produce any sound.
 If I close Jokosher then you can hear totem.
@@ -1289,11 +1289,11 @@ I had to restart!
 Is there some way to reset alsa or the device driver - with out having
 to restart?
 
-Running on Ubuntu - with Jokosher 0.2 runscript.', 16, NULL, NULL, '2007-03-15 20:37:51.603369', NULL, NULL, NULL, 0, 7, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (12, '2007-03-15 20:41:18.635493', NULL, 'Copy, Cut and Delete operations should work on selections', 'When trying to copy, cut or delete just a selected portion of an event, the operations affect the event completely. That is, you can''t select a portion and cut that piece. The whole event will be cut. Same goes for the other 2 operations.', 16, NULL, NULL, '2007-03-15 20:46:49.909153', NULL, NULL, NULL, 0, 5, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (13, '2007-07-27 20:00:58.299796', NULL, 'Launchpad CSS and JS is not testible', 'The messages placed on this bug are for eyeball viewing of JS and CSS behaviour.', 12, NULL, NULL, '2007-07-27 20:29:46.336737', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (14, '2007-08-09 11:39:16.836856', NULL, 'jokosher exposes personal details in its actions portlet', 'Jokosher discloses to any passerby the fact that I am single and unwed in its actions portlet. Please fix this blatant violacion of privacy now!!', 63, NULL, NULL, '2007-08-09 11:39:16.836856', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 3);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (15, '2007-12-18 16:30:19.103679', NULL, 'Nonsensical bugs are useless', 'Like this one, natch.', 16, NULL, NULL, '2007-12-18 16:31:34.972893', NULL, NULL, '2007-12-18 16:31:34.790641', 0, 7, 0, 0, 0, NULL, NULL, 1);
+Running on Ubuntu - with Jokosher 0.2 runscript.', 16, NULL, NULL, '2007-03-15 20:37:51.603369', NULL, NULL, NULL, 0, 7, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (12, '2007-03-15 20:41:18.635493', NULL, 'Copy, Cut and Delete operations should work on selections', 'When trying to copy, cut or delete just a selected portion of an event, the operations affect the event completely. That is, you can''t select a portion and cut that piece. The whole event will be cut. Same goes for the other 2 operations.', 16, NULL, NULL, '2022-04-08 14:02:24.757276', NULL, NULL, NULL, 0, 5, 0, 0, 2, '2022-04-08 14:02:24.620004', NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (13, '2007-07-27 20:00:58.299796', NULL, 'Launchpad CSS and JS is not testible', 'The messages placed on this bug are for eyeball viewing of JS and CSS behaviour.', 12, NULL, NULL, '2007-07-27 20:29:46.336737', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (14, '2007-08-09 11:39:16.836856', NULL, 'jokosher exposes personal details in its actions portlet', 'Jokosher discloses to any passerby the fact that I am single and unwed in its actions portlet. Please fix this blatant violacion of privacy now!!', 63, NULL, NULL, '2007-08-09 11:39:16.836856', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 3, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (15, '2007-12-18 16:30:19.103679', NULL, 'Nonsensical bugs are useless', 'Like this one, natch.', 16, NULL, NULL, '2022-04-08 13:37:05.466916', NULL, NULL, '2007-12-18 16:31:34.790641', 0, 7, 0, 0, 2, '2022-04-08 13:37:03.39021', NULL, 1, 0, NULL);
 
 
 ALTER TABLE public.bug ENABLE TRIGGER ALL;
@@ -2564,6 +2564,22 @@ INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldva
 INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (34, 15, '2007-12-18 16:30:19.103679', 16, 'bug', NULL, NULL, 'added bug');
 INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (35, 15, '2007-12-18 16:30:47.889614', 16, 'bug', NULL, NULL, 'assigned to thunderbird');
 INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (36, 15, '2007-12-18 16:31:34.790641', 62, 'thunderbird: status', 'Unknown', 'New', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (37, 15, '2022-04-08 09:19:01.601347', 16, 'redfish: importance', 'Undecided', 'Low', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (38, 15, '2022-04-08 09:34:06.779599', 16, 'redfish: importance', 'Low', 'High', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (39, 15, '2022-04-08 09:44:10.184713', 16, 'redfish: importance', 'High', 'Low', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (40, 15, '2022-04-08 10:16:33.962557', 16, 'redfish: importance', 'Low', 'High', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (41, 15, '2022-04-08 10:16:53.481613', 16, 'redfish: importance', 'High', 'Low', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (42, 15, '2022-04-08 12:50:17.708175', 16, 'redfish: importance_explanation', 'bar!!!!', 'bazZZZZ', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (43, 15, '2022-04-08 13:03:15.158636', 16, 'redfish: importance_explanation', 'bazZZZZ', 'BAZ', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (44, 15, '2022-04-08 13:37:03.39021', 16, 'redfish: importance_explanation', 'BAZ', 'BAZZ', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (45, 12, '2022-04-08 14:02:24.620004', 16, 'jokosher: importance explanation', NULL, 'Critically important', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (46, 1, '2022-04-11 09:11:57.768144', 16, 'firefox: importance explanation', 'This is low priority', 'This is low priority!', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (47, 1, '2022-04-11 10:13:47.727648', 16, 'firefox: importance explanation', 'This is low priority!', NULL, NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (48, 1, '2022-04-11 10:15:52.315636', 16, 'firefox: importance explanation', NULL, 'This is low priority!', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (49, 1, '2022-04-11 10:18:02.155517', 16, 'firefox: importance explanation', 'This is low priority!', NULL, NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (50, 1, '2022-04-11 10:18:42.517758', 16, 'firefox: importance explanation', NULL, 'This is low priority!', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (51, 1, '2022-04-11 10:21:15.790517', 16, 'firefox: importance explanation', 'This is low priority!', 'unset', NULL);
+INSERT INTO public.bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (52, 1, '2022-04-11 10:21:37.028851', 16, 'firefox: importance explanation', 'unset', 'This is low priority!', NULL);
 
 
 ALTER TABLE public.bugactivity ENABLE TRIGGER ALL;
@@ -2629,6 +2645,22 @@ INSERT INTO public.message (id, datecreated, subject, owner, parent, distributio
 INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (50, '2010-06-25 10:13:10', 'Sample comment 1', 1, NULL, NULL, '<42BD2E36.9090810@xxxxx>', NULL, 81, true, NULL, NULL);
 INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (51, '2010-06-26 10:13:10', 'Sample comment 2', 1, NULL, NULL, '<42BD2E36.9090810@xxxxx>', NULL, 81, true, NULL, NULL);
 INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (52, '2010-06-27 10:13:10', 'Sample comment 3', 1, NULL, NULL, '<42BD2E36.9090810@xxxxx>', NULL, 81, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (53, '2022-04-08 09:19:01.601347', 'Re: Nonsensical bugs are useless', 16, NULL, NULL, '<164940958123.5085.2499327339168058496.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (54, '2022-04-08 09:34:06.779599', 'Re: Nonsensical bugs are useless', 16, NULL, NULL, '<164941045102.5083.17835343459582558083.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (55, '2022-04-08 09:44:10.184713', 'Re: Nonsensical bugs are useless', 16, NULL, NULL, '<164941105581.5085.15100639661280917685.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (56, '2022-04-08 10:16:33.962557', 'Re: Nonsensical bugs are useless', 16, NULL, NULL, '<164941299839.12245.15899171465985218533.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (57, '2022-04-08 10:16:53.481613', 'Re: Nonsensical bugs are useless', 16, NULL, NULL, '<164941301548.12245.3300822785038689303.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (58, '2022-04-08 12:50:17.708175', 'Re: Nonsensical bugs are useless', 16, NULL, NULL, '<164942221965.40186.7357404230390125047.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (59, '2022-04-08 13:03:15.158636', 'Re: Nonsensical bugs are useless', 16, NULL, NULL, '<164942299781.41944.14838335127474294252.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (60, '2022-04-08 13:37:03.39021', 'Re: Nonsensical bugs are useless', 16, NULL, NULL, '<164942502545.51704.6337945259220100486.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (61, '2022-04-08 14:02:24.620004', 'Re: Copy, Cut and Delete operations should work on selections', 16, NULL, NULL, '<164942654474.56930.12821276847282714961.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (62, '2022-04-11 09:11:57.768144', 'Re: Firefox does not support SVG', 16, NULL, NULL, '<164966831795.131786.2808311902370338214.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (63, '2022-04-11 10:13:47.727648', 'Re: Firefox does not support SVG', 16, NULL, NULL, '<164967202790.145824.12478160898057813262.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (64, '2022-04-11 10:15:52.315636', 'Re: Firefox does not support SVG', 16, NULL, NULL, '<164967215248.147416.5222484240825426442.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (65, '2022-04-11 10:18:02.155517', 'Re: Firefox does not support SVG', 16, NULL, NULL, '<164967229462.148208.9736406846212431483.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (66, '2022-04-11 10:18:42.517758', 'Re: Firefox does not support SVG', 16, NULL, NULL, '<164967235889.148208.6591947987022086670.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (67, '2022-04-11 10:21:15.790517', 'Re: Firefox does not support SVG', 16, NULL, NULL, '<164967247596.149051.10825977457073723279.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
+INSERT INTO public.message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible, date_deleted, date_last_edited) VALUES (68, '2022-04-11 10:21:37.028851', 'Re: Firefox does not support SVG', 16, NULL, NULL, '<164967249721.149053.17131941193414115967.launchpad@xxxxxxxxxxxxxx>', NULL, NULL, true, NULL, NULL);
 
 
 ALTER TABLE public.message ENABLE TRIGGER ALL;
@@ -2733,6 +2765,22 @@ ALTER TABLE public.bugnomination ENABLE TRIGGER ALL;
 
 ALTER TABLE public.bugnotification DISABLE TRIGGER ALL;
 
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (1, 15, 53, false, NULL, 10, 37);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (2, 15, 54, false, NULL, 10, 38);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (3, 15, 55, false, NULL, 10, 39);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (4, 15, 56, false, NULL, 10, 40);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (5, 15, 57, false, NULL, 10, 41);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (6, 15, 58, false, NULL, 10, 42);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (7, 15, 59, false, NULL, 10, 43);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (8, 15, 60, false, NULL, 10, 44);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (9, 12, 61, false, NULL, 10, 45);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (10, 1, 62, false, NULL, 10, 46);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (11, 1, 63, false, NULL, 10, 47);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (12, 1, 64, false, NULL, 10, 48);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (13, 1, 65, false, NULL, 10, 49);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (14, 1, 66, false, NULL, 10, 50);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (15, 1, 67, false, NULL, 10, 51);
+INSERT INTO public.bugnotification (id, bug, message, is_comment, date_emailed, status, activity) VALUES (16, 1, 68, false, NULL, 10, 52);
 
 
 ALTER TABLE public.bugnotification ENABLE TRIGGER ALL;
@@ -2776,6 +2824,21 @@ ALTER TABLE public.bugsubscriptionfilter ENABLE TRIGGER ALL;
 
 ALTER TABLE public.bugnotificationfilter DISABLE TRIGGER ALL;
 
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (1, 3);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (2, 3);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (3, 3);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (4, 3);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (5, 3);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (6, 3);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (7, 3);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (8, 3);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (10, 1);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (11, 1);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (12, 1);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (13, 1);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (14, 1);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (15, 1);
+INSERT INTO public.bugnotificationfilter (bug_notification, bug_subscription_filter) VALUES (16, 1);
 
 
 ALTER TABLE public.bugnotificationfilter ENABLE TRIGGER ALL;
@@ -2783,6 +2846,51 @@ ALTER TABLE public.bugnotificationfilter ENABLE TRIGGER ALL;
 
 ALTER TABLE public.bugnotificationrecipient DISABLE TRIGGER ALL;
 
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (1, 1, 16, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (2, 1, 64, 'Subscriber (Redfish) @landscape-developers', 'You received this bug notification because you are a member of Landscape Developers, which is subscribed to Redfish.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (3, 2, 16, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (4, 2, 64, 'Subscriber (Redfish) @landscape-developers', 'You received this bug notification because you are a member of Landscape Developers, which is subscribed to Redfish.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (5, 3, 16, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (6, 3, 64, 'Subscriber (Redfish) @landscape-developers', 'You received this bug notification because you are a member of Landscape Developers, which is subscribed to Redfish.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (7, 4, 16, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (8, 4, 64, 'Subscriber (Redfish) @landscape-developers', 'You received this bug notification because you are a member of Landscape Developers, which is subscribed to Redfish.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (9, 5, 16, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (10, 5, 64, 'Subscriber (Redfish) @landscape-developers', 'You received this bug notification because you are a member of Landscape Developers, which is subscribed to Redfish.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (11, 6, 16, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (12, 6, 64, 'Subscriber (Redfish) @landscape-developers', 'You received this bug notification because you are a member of Landscape Developers, which is subscribed to Redfish.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (13, 7, 16, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (14, 7, 64, 'Subscriber (Redfish) @landscape-developers', 'You received this bug notification because you are a member of Landscape Developers, which is subscribed to Redfish.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (15, 8, 16, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (16, 8, 64, 'Subscriber (Redfish) @landscape-developers', 'You received this bug notification because you are a member of Landscape Developers, which is subscribed to Redfish.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (17, 9, 16, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (18, 10, 16, 'Subscriber (mozilla-firefox in Ubuntu)', 'You received this bug notification because you are subscribed to mozilla-firefox in Ubuntu.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (19, 10, 1, 'Assignee', 'You received this bug notification because you are a bug assignee.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (20, 10, 12, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (21, 10, 11, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (22, 11, 16, 'Subscriber (mozilla-firefox in Ubuntu)', 'You received this bug notification because you are subscribed to mozilla-firefox in Ubuntu.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (23, 11, 1, 'Assignee', 'You received this bug notification because you are a bug assignee.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (24, 11, 12, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (25, 11, 11, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (26, 12, 16, 'Subscriber (mozilla-firefox in Ubuntu)', 'You received this bug notification because you are subscribed to mozilla-firefox in Ubuntu.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (27, 12, 1, 'Assignee', 'You received this bug notification because you are a bug assignee.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (28, 12, 12, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (29, 12, 11, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (30, 13, 16, 'Subscriber (mozilla-firefox in Ubuntu)', 'You received this bug notification because you are subscribed to mozilla-firefox in Ubuntu.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (31, 13, 1, 'Assignee', 'You received this bug notification because you are a bug assignee.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (32, 13, 12, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (33, 13, 11, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (34, 14, 16, 'Subscriber (mozilla-firefox in Ubuntu)', 'You received this bug notification because you are subscribed to mozilla-firefox in Ubuntu.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (35, 14, 1, 'Assignee', 'You received this bug notification because you are a bug assignee.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (36, 14, 12, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (37, 14, 11, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (38, 15, 16, 'Subscriber (mozilla-firefox in Ubuntu)', 'You received this bug notification because you are subscribed to mozilla-firefox in Ubuntu.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (39, 15, 1, 'Assignee', 'You received this bug notification because you are a bug assignee.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (40, 15, 12, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (41, 15, 11, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (42, 16, 16, 'Subscriber (mozilla-firefox in Ubuntu)', 'You received this bug notification because you are subscribed to mozilla-firefox in Ubuntu.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (43, 16, 1, 'Assignee', 'You received this bug notification because you are a bug assignee.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (44, 16, 12, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
+INSERT INTO public.bugnotificationrecipient (id, bug_notification, person, reason_header, reason_body) VALUES (45, 16, 11, 'Subscriber', 'You received this bug notification because you are subscribed to the bug report.');
 
 
 ALTER TABLE public.bugnotificationrecipient ENABLE TRIGGER ALL;
@@ -2927,6 +3035,16 @@ ALTER TABLE public.bugsummary ENABLE TRIGGER ALL;
 
 ALTER TABLE public.bugsummaryjournal DISABLE TRIGGER ALL;
 
+INSERT INTO public.bugsummaryjournal (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy, ociproject, ociprojectseries) VALUES (1, -1, 22, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 5, false, NULL, NULL, NULL);
+INSERT INTO public.bugsummaryjournal (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy, ociproject, ociprojectseries) VALUES (2, 1, 22, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 20, false, NULL, NULL, NULL);
+INSERT INTO public.bugsummaryjournal (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy, ociproject, ociprojectseries) VALUES (3, 1, 22, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 40, false, NULL, NULL, NULL);
+INSERT INTO public.bugsummaryjournal (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy, ociproject, ociprojectseries) VALUES (4, -1, 22, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 20, false, NULL, NULL, NULL);
+INSERT INTO public.bugsummaryjournal (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy, ociproject, ociprojectseries) VALUES (5, -1, 22, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 40, false, NULL, NULL, NULL);
+INSERT INTO public.bugsummaryjournal (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy, ociproject, ociprojectseries) VALUES (6, 1, 22, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 20, false, NULL, NULL, NULL);
+INSERT INTO public.bugsummaryjournal (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy, ociproject, ociprojectseries) VALUES (7, 1, 22, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 40, false, NULL, NULL, NULL);
+INSERT INTO public.bugsummaryjournal (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy, ociproject, ociprojectseries) VALUES (8, -1, 22, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 20, false, NULL, NULL, NULL);
+INSERT INTO public.bugsummaryjournal (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy, ociproject, ociprojectseries) VALUES (9, -1, 22, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 40, false, NULL, NULL, NULL);
+INSERT INTO public.bugsummaryjournal (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy, ociproject, ociprojectseries) VALUES (10, 1, 22, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, 20, false, NULL, NULL, NULL);
 
 
 ALTER TABLE public.bugsummaryjournal ENABLE TRIGGER ALL;
@@ -2949,34 +3067,34 @@ ALTER TABLE public.bugtag ENABLE TRIGGER ALL;
 
 ALTER TABLE public.bugtask DISABLE TRIGGER ALL;
 
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (2, 1, 4, NULL, NULL, NULL, 10, 20, 1, '2005-01-02 11:07:20.330975', '2004-01-02 03:49:22.910878', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (3, 2, 1, NULL, NULL, NULL, 10, 20, NULL, '2005-01-03 11:07:20.330975', '2004-01-03 03:49:22.908491', 12, NULL, NULL, 'Tomcat', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (4, 1, NULL, 3, NULL, 1, 20, 20, NULL, '2005-01-04 11:07:20.584746', '2004-01-04 03:49:22.79024', 12, NULL, 8, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (5, 2, NULL, 3, NULL, 1, 20, 20, 12, '2005-01-05 11:07:20.584746', '2004-01-05 03:49:22.824591', 12, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (6, 3, NULL, 3, NULL, 1, 10, 999, NULL, '2005-01-06 11:07:20.584746', '2004-01-06 03:49:22.825533', 16, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (13, 4, 4, NULL, NULL, NULL, 10, 30, NULL, '2005-01-13 17:20:12.820778', '2004-01-13 17:20:12.820778', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (14, 5, 4, NULL, NULL, NULL, 10, 50, 12, '2005-01-14 17:27:03.702622', '2004-01-14 17:27:03.702622', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (15, 6, 4, NULL, NULL, NULL, 10, 40, NULL, '2005-01-15 17:35:39.548665', '2004-01-15 17:35:39.548665', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (16, 5, NULL, NULL, 1, 1, 10, 30, NULL, '2005-01-16 14:43:02.452716', '2004-01-16 14:43:02.452716', 12, NULL, NULL, 'mozilla-firefox (Ubuntu Warty)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (17, 1, NULL, 1, NULL, 1, 10, 30, NULL, '2005-01-17 01:15:48.241836', '2004-01-17 01:15:48.241836', 16, NULL, NULL, 'mozilla-firefox (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (18, 3, NULL, NULL, 6, 1, 10, 30, NULL, '2005-01-18 16:30:32.295049', '2004-01-18 16:30:32.295049', 12, NULL, NULL, 'mozilla-firefox (Debian Woody)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (19, 3, NULL, NULL, 7, 1, 10, 30, NULL, '2005-01-19 16:30:47.448639', '2004-01-19 16:30:47.448639', 12, 2, 10, 'mozilla-firefox (Debian Sarge)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (20, 2, NULL, NULL, 6, 1, 10, 30, NULL, '2005-01-20 13:54:57.840344', '2004-01-20 13:54:57.840344', 12, NULL, NULL, 'mozilla-firefox (Debian Woody)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (21, 7, 5, NULL, NULL, NULL, 10, 30, 16, '2005-01-21 15:12:29.602117', '2004-01-21 15:12:29.602117', 16, NULL, NULL, 'Evolution', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (22, 8, NULL, 3, NULL, 1, 30, 30, 16, '2005-01-22 09:10:17.13237', '2004-01-22 09:10:17.13237', 12, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, '2005-01-25 09:10:17.13237', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (23, 9, NULL, 1, NULL, 18, 20, 30, NULL, '2005-01-23 16:42:14.080227', '2004-01-23 16:42:14.080227', 16, NULL, NULL, 'thunderbird (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (24, 9, 8, NULL, NULL, NULL, 999, 999, NULL, '2005-01-24 16:43:25.744534', '2004-01-24 16:43:25.744534', 12, NULL, 6, 'Mozilla Thunderbird', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (25, 10, NULL, 1, NULL, 22, 10, 30, NULL, '2005-01-25 19:42:21.890299', '2004-01-25 19:42:21.890299', 16, NULL, NULL, 'linux-source-2.6.15 (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (26, 2, NULL, 1, NULL, NULL, 10, 30, NULL, '2005-01-26 10:11:02.729077', '2004-01-26 10:11:02.729077', 16, NULL, NULL, 'Ubuntu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (27, 7, NULL, 3, NULL, 9, 999, 999, NULL, '2005-01-27 16:45:45.054836', '2004-01-27 16:45:45.054836', 12, NULL, 7, 'evolution (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (28, 2, NULL, NULL, 3, NULL, 10, 5, NULL, NULL, '2006-08-21 22:23:08.163936', 1, NULL, NULL, 'Ubuntu Hoary', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (29, 5, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-01-04 15:00:50.431687', 16, NULL, NULL, 'Mozilla Firefox 1.0', NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (30, 11, 20, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-03-15 20:33:56.67893', 16, NULL, NULL, 'Jokosher', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (31, 12, 20, NULL, NULL, NULL, 20, 50, NULL, NULL, '2007-03-15 20:41:18.635493', 16, NULL, NULL, 'Jokosher', '2007-03-15 20:41:42.256326', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (32, 13, 17, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-07-27 20:00:58.299796', 12, NULL, NULL, 'Launchpad', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (33, 14, 20, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-08-09 11:39:16.836856', 63, NULL, NULL, 'Jokosher', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (34, 15, 22, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-12-18 16:30:19.103679', 16, NULL, NULL, 'Redfish', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (35, 15, 8, NULL, NULL, NULL, 10, 999, NULL, NULL, '2007-12-18 16:30:47.889614', 16, NULL, 11, 'Mozilla Thunderbird', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (2, 1, 4, NULL, NULL, NULL, 10, 20, 1, '2005-01-02 11:07:20.330975', '2004-01-02 03:49:22.910878', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'This is low priority!');
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (3, 2, 1, NULL, NULL, NULL, 10, 20, NULL, '2005-01-03 11:07:20.330975', '2004-01-03 03:49:22.908491', 12, NULL, NULL, 'Tomcat', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (4, 1, NULL, 3, NULL, 1, 20, 20, NULL, '2005-01-04 11:07:20.584746', '2004-01-04 03:49:22.79024', 12, NULL, 8, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (5, 2, NULL, 3, NULL, 1, 20, 20, 12, '2005-01-05 11:07:20.584746', '2004-01-05 03:49:22.824591', 12, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (6, 3, NULL, 3, NULL, 1, 10, 999, NULL, '2005-01-06 11:07:20.584746', '2004-01-06 03:49:22.825533', 16, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (13, 4, 4, NULL, NULL, NULL, 10, 30, NULL, '2005-01-13 17:20:12.820778', '2004-01-13 17:20:12.820778', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (14, 5, 4, NULL, NULL, NULL, 10, 50, 12, '2005-01-14 17:27:03.702622', '2004-01-14 17:27:03.702622', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (15, 6, 4, NULL, NULL, NULL, 10, 40, NULL, '2005-01-15 17:35:39.548665', '2004-01-15 17:35:39.548665', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (16, 5, NULL, NULL, 1, 1, 10, 30, NULL, '2005-01-16 14:43:02.452716', '2004-01-16 14:43:02.452716', 12, NULL, NULL, 'mozilla-firefox (Ubuntu Warty)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (17, 1, NULL, 1, NULL, 1, 10, 30, NULL, '2005-01-17 01:15:48.241836', '2004-01-17 01:15:48.241836', 16, NULL, NULL, 'mozilla-firefox (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (18, 3, NULL, NULL, 6, 1, 10, 30, NULL, '2005-01-18 16:30:32.295049', '2004-01-18 16:30:32.295049', 12, NULL, NULL, 'mozilla-firefox (Debian Woody)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (19, 3, NULL, NULL, 7, 1, 10, 30, NULL, '2005-01-19 16:30:47.448639', '2004-01-19 16:30:47.448639', 12, 2, 10, 'mozilla-firefox (Debian Sarge)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (20, 2, NULL, NULL, 6, 1, 10, 30, NULL, '2005-01-20 13:54:57.840344', '2004-01-20 13:54:57.840344', 12, NULL, NULL, 'mozilla-firefox (Debian Woody)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (21, 7, 5, NULL, NULL, NULL, 10, 30, 16, '2005-01-21 15:12:29.602117', '2004-01-21 15:12:29.602117', 16, NULL, NULL, 'Evolution', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (22, 8, NULL, 3, NULL, 1, 30, 30, 16, '2005-01-22 09:10:17.13237', '2004-01-22 09:10:17.13237', 12, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, '2005-01-25 09:10:17.13237', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (23, 9, NULL, 1, NULL, 18, 20, 30, NULL, '2005-01-23 16:42:14.080227', '2004-01-23 16:42:14.080227', 16, NULL, NULL, 'thunderbird (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (24, 9, 8, NULL, NULL, NULL, 999, 999, NULL, '2005-01-24 16:43:25.744534', '2004-01-24 16:43:25.744534', 12, NULL, 6, 'Mozilla Thunderbird', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (25, 10, NULL, 1, NULL, 22, 10, 30, NULL, '2005-01-25 19:42:21.890299', '2004-01-25 19:42:21.890299', 16, NULL, NULL, 'linux-source-2.6.15 (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (26, 2, NULL, 1, NULL, NULL, 10, 30, NULL, '2005-01-26 10:11:02.729077', '2004-01-26 10:11:02.729077', 16, NULL, NULL, 'Ubuntu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (27, 7, NULL, 3, NULL, 9, 999, 999, NULL, '2005-01-27 16:45:45.054836', '2004-01-27 16:45:45.054836', 12, NULL, 7, 'evolution (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (28, 2, NULL, NULL, 3, NULL, 10, 5, NULL, NULL, '2006-08-21 22:23:08.163936', 1, NULL, NULL, 'Ubuntu Hoary', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (29, 5, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-01-04 15:00:50.431687', 16, NULL, NULL, 'Mozilla Firefox 1.0', NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (30, 11, 20, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-03-15 20:33:56.67893', 16, NULL, NULL, 'Jokosher', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (31, 12, 20, NULL, NULL, NULL, 20, 50, NULL, NULL, '2007-03-15 20:41:18.635493', 16, NULL, NULL, 'Jokosher', '2007-03-15 20:41:42.256326', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Critically important');
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (32, 13, 17, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-07-27 20:00:58.299796', 12, NULL, NULL, 'Launchpad', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (33, 14, 20, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-08-09 11:39:16.836856', 63, NULL, NULL, 'Jokosher', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (34, 15, 22, NULL, NULL, NULL, 10, 20, NULL, NULL, '2007-12-18 16:30:19.103679', 16, NULL, NULL, 'Redfish', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'BAZZ');
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (35, 15, 8, NULL, NULL, NULL, 10, 999, NULL, NULL, '2007-12-18 16:30:47.889614', 16, NULL, 11, 'Mozilla Thunderbird', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 
 
 ALTER TABLE public.bugtask ENABLE TRIGGER ALL;
@@ -2984,16 +3102,16 @@ ALTER TABLE public.bugtask ENABLE TRIGGER ALL;
 
 ALTER TABLE public.bugtaskflat DISABLE TRIGGER ALL;
 
-INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (2, 1, '2004-01-02 03:49:22.910878', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, 4, NULL, NULL, NULL, NULL, 10, 20, 1, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (2, 1, '2004-01-02 03:49:22.910878', NULL, 12, NULL, 1, '2022-04-11 10:21:37.227528', 4, 4, NULL, NULL, NULL, NULL, 10, 20, 1, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (3, 2, '2004-01-03 03:49:22.908491', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, 1, NULL, NULL, NULL, NULL, 10, 20, NULL, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (4, 1, '2004-01-04 03:49:22.79024', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, NULL, NULL, 3, NULL, 1, 20, 20, NULL, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (4, 1, '2004-01-04 03:49:22.79024', NULL, 12, NULL, 1, '2022-04-11 10:21:37.227528', 4, NULL, NULL, 3, NULL, 1, 20, 20, NULL, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (5, 2, '2004-01-05 03:49:22.824591', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, 3, NULL, 1, 20, 20, 12, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (6, 3, '2004-01-06 03:49:22.825533', NULL, 16, NULL, 1, '2006-07-14 08:48:52.922462', 0, NULL, NULL, 3, NULL, 1, 10, 999, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (13, 4, '2004-01-13 17:20:12.820778', NULL, 12, NULL, 1, '2006-07-14 08:49:17.124885', 0, 4, NULL, NULL, NULL, NULL, 10, 30, NULL, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (14, 5, '2004-01-14 17:27:03.702622', NULL, 12, NULL, 1, '2006-07-14 08:49:40.553212', 0, 4, NULL, NULL, NULL, NULL, 10, 50, 12, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (15, 6, '2004-01-15 17:35:39.548665', 5, 12, NULL, 1, '2006-05-19 06:37:40.389193', 0, 4, NULL, NULL, NULL, NULL, 10, 40, NULL, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (16, 5, '2004-01-16 14:43:02.452716', NULL, 12, NULL, 1, '2006-07-14 08:49:40.553212', 0, NULL, NULL, NULL, 1, 1, 10, 30, NULL, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (17, 1, '2004-01-17 01:15:48.241836', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, NULL, NULL, 1, NULL, 1, 10, 30, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (17, 1, '2004-01-17 01:15:48.241836', NULL, 12, NULL, 1, '2022-04-11 10:21:37.227528', 4, NULL, NULL, 1, NULL, 1, 10, 30, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (18, 3, '2004-01-18 16:30:32.295049', NULL, 16, NULL, 1, '2006-07-14 08:48:52.922462', 0, NULL, NULL, NULL, 6, 1, 10, 30, NULL, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (19, 3, '2004-01-19 16:30:47.448639', NULL, 16, NULL, 1, '2006-07-14 08:48:52.922462', 0, NULL, NULL, NULL, 7, 1, 10, 30, NULL, 2, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (20, 2, '2004-01-20 13:54:57.840344', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, NULL, 6, 1, 10, 30, NULL, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
@@ -3007,11 +3125,11 @@ INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owne
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (28, 2, '2006-08-21 22:23:08.163936', NULL, 12, NULL, 1, '2006-07-14 08:47:36.124403', 0, NULL, NULL, NULL, 3, NULL, 10, 5, NULL, NULL, 1, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (29, 5, '2007-01-04 15:00:50.431687', NULL, 12, NULL, 1, '2006-07-14 08:49:40.553212', 0, NULL, 2, NULL, NULL, NULL, 10, 5, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (30, 11, '2007-03-15 20:33:56.67893', NULL, 16, NULL, 1, '2007-03-15 20:37:51.603369', 0, 20, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (31, 12, '2007-03-15 20:41:18.635493', NULL, 16, NULL, 1, '2007-03-15 20:46:49.909153', 0, 20, NULL, NULL, NULL, NULL, 20, 50, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (31, 12, '2007-03-15 20:41:18.635493', NULL, 16, NULL, 1, '2022-04-08 14:02:24.757276', 2, 20, NULL, NULL, NULL, NULL, 20, 50, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (32, 13, '2007-07-27 20:00:58.299796', NULL, 12, NULL, 1, '2007-07-27 20:29:46.336737', 0, 17, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 12, true, NULL, NULL, NULL, NULL, NULL, NULL);
 INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (33, 14, '2007-08-09 11:39:16.836856', NULL, 63, NULL, 3, '2007-08-09 11:39:16.836856', 0, 20, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 63, true, '{2}', '{14,63}', NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (34, 15, '2007-12-18 16:30:19.103679', NULL, 16, NULL, 1, '2007-12-18 16:31:34.972893', 0, 22, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (35, 15, '2007-12-18 16:30:47.889614', NULL, 16, NULL, 1, '2007-12-18 16:31:34.972893', 0, 8, NULL, NULL, NULL, NULL, 10, 999, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (34, 15, '2007-12-18 16:30:19.103679', NULL, 16, NULL, 1, '2022-04-08 13:37:05.466916', 2, 22, NULL, NULL, NULL, NULL, 10, 20, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed, ociproject, ociprojectseries) VALUES (35, 15, '2007-12-18 16:30:47.889614', NULL, 16, NULL, 1, '2022-04-08 13:37:05.466916', 2, 8, NULL, NULL, NULL, NULL, 10, 999, NULL, NULL, 16, true, NULL, NULL, NULL, NULL, NULL, NULL);
 
 
 ALTER TABLE public.bugtaskflat ENABLE TRIGGER ALL;
@@ -3123,6 +3241,13 @@ ALTER TABLE public.charmrecipejob DISABLE TRIGGER ALL;
 ALTER TABLE public.charmrecipejob ENABLE TRIGGER ALL;
 
 
+ALTER TABLE public.cibuild DISABLE TRIGGER ALL;
+
+
+
+ALTER TABLE public.cibuild ENABLE TRIGGER ALL;
+
+
 ALTER TABLE public.codeimport DISABLE TRIGGER ALL;
 
 INSERT INTO public.codeimport (id, branch, date_created, registrant, rcs_type, cvs_root, cvs_module, review_status, date_last_successful, owner, assignee, update_interval, url, git_repository) VALUES (1, 75, '2007-06-25 20:04:04.226605', 52, 2, NULL, NULL, 20, NULL, 52, NULL, NULL, 'http://svn.example.org/svnroot/gnome-terminal/trunk', NULL);
@@ -3213,8 +3338,8 @@ ALTER TABLE public.codereviewvote ENABLE TRIGGER ALL;
 
 ALTER TABLE public.commercialsubscription DISABLE TRIGGER ALL;
 
-INSERT INTO public.commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id) VALUES (1, '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.838229', '2032-01-01 00:00:00', 10, 16, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:37.838229+00:00');
-INSERT INTO public.commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id) VALUES (2, '2012-10-08 11:09:46.861812', '2012-10-08 11:09:46.861812', '2012-10-08 11:09:46.912691', '2032-01-01 00:00:00', 10, 17, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:46.912691+00:00');
+INSERT INTO public.commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id, distribution) VALUES (1, '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.838229', '2032-01-01 00:00:00', 10, 16, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:37.838229+00:00', NULL);
+INSERT INTO public.commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id, distribution) VALUES (2, '2012-10-08 11:09:46.861812', '2012-10-08 11:09:46.861812', '2012-10-08 11:09:46.912691', '2032-01-01 00:00:00', 10, 17, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:46.912691+00:00', NULL);
 
 
 ALTER TABLE public.commercialsubscription ENABLE TRIGGER ALL;
@@ -3250,16 +3375,16 @@ ALTER TABLE public.customlanguagecode ENABLE TRIGGER ALL;
 
 ALTER TABLE public.cve DISABLE TRIGGER ALL;
 
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (1, '1999-8979', 2, 'Firefox crashes all the time', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.508959', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (2, '1999-2345', 1, 'Possible data loss', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.513099', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (3, '2005-2730', 1, 'The HTTP proxy in Astaro Security Linux 6.0 allows remote attackers to obtain sensitive information via an invalid request, which reveals a Proxy-authorization string in an error message.', '2005-09-13 14:05:15.669384', '2005-09-13 14:05:15.669384', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (4, '2005-2731', 1, 'Directory traversal vulnerability in Astaro Security Linux 6.0, when using Webmin, allows remote authenticated webmin users to read arbitrary files via a ..  (dot dot) in the wfe_download parameter to index.fpl.', '2005-09-13 14:05:15.91729', '2005-09-13 14:05:15.91729', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (5, '2005-2732', 1, 'AWStats 6.4, and possibly earlier versions, allows remote attackers to obtain sensitive information via a file that does not exist in the config parameter, which reveals the path in an error message.', '2005-09-13 14:05:15.992007', '2005-09-13 14:05:15.992007', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (6, '2005-2733', 1, 'upload_img_cgi.php in Simple PHP Blog (SPHPBlog) does not properly restrict file extensions of uploaded files, which could allow remote attackers to execute arbitrary code.', '2005-09-13 14:05:16.072418', '2005-09-13 14:05:16.072418', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (7, '2005-2734', 1, 'Cross-site scripting (XSS) vulnerability in Gallery 1.5.1-RC2 and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.202393', '2005-09-13 14:05:16.202393', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (8, '2005-2735', 1, 'Cross-site scripting (XSS) vulnerability in phpGraphy 0.9.9a and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.412226', '2005-09-13 14:05:16.412226', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (9, '2005-2736', 1, 'Cross-site scripting (XSS) vulnerability in YaPig 0.95 and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.841572', '2005-09-13 14:05:16.841572', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (10, '2005-2737', 1, 'Cross-site scripting (XSS) vulnerability in PhotoPost PHP Pro 5.1 allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:17.043865', '2005-09-13 14:05:17.043865', NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (1, '1999-8979', 2, 'Firefox crashes all the time', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.508959', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (2, '1999-2345', 1, 'Possible data loss', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.513099', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (3, '2005-2730', 1, 'The HTTP proxy in Astaro Security Linux 6.0 allows remote attackers to obtain sensitive information via an invalid request, which reveals a Proxy-authorization string in an error message.', '2005-09-13 14:05:15.669384', '2005-09-13 14:05:15.669384', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (4, '2005-2731', 1, 'Directory traversal vulnerability in Astaro Security Linux 6.0, when using Webmin, allows remote authenticated webmin users to read arbitrary files via a ..  (dot dot) in the wfe_download parameter to index.fpl.', '2005-09-13 14:05:15.91729', '2005-09-13 14:05:15.91729', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (5, '2005-2732', 1, 'AWStats 6.4, and possibly earlier versions, allows remote attackers to obtain sensitive information via a file that does not exist in the config parameter, which reveals the path in an error message.', '2005-09-13 14:05:15.992007', '2005-09-13 14:05:15.992007', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (6, '2005-2733', 1, 'upload_img_cgi.php in Simple PHP Blog (SPHPBlog) does not properly restrict file extensions of uploaded files, which could allow remote attackers to execute arbitrary code.', '2005-09-13 14:05:16.072418', '2005-09-13 14:05:16.072418', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (7, '2005-2734', 1, 'Cross-site scripting (XSS) vulnerability in Gallery 1.5.1-RC2 and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.202393', '2005-09-13 14:05:16.202393', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (8, '2005-2735', 1, 'Cross-site scripting (XSS) vulnerability in phpGraphy 0.9.9a and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.412226', '2005-09-13 14:05:16.412226', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (9, '2005-2736', 1, 'Cross-site scripting (XSS) vulnerability in YaPig 0.95 and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.841572', '2005-09-13 14:05:16.841572', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (10, '2005-2737', 1, 'Cross-site scripting (XSS) vulnerability in PhotoPost PHP Pro 5.1 allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:17.043865', '2005-09-13 14:05:17.043865', NULL, NULL, NULL, NULL);
 
 
 ALTER TABLE public.cve ENABLE TRIGGER ALL;
@@ -4111,6 +4236,11 @@ INSERT INTO public.karma (id, datecreated, person, action, product, distribution
 INSERT INTO public.karma (id, datecreated, person, action, product, distribution, sourcepackagename) VALUES (61, '2000-03-13 20:46:49.83307', 16, 2, 20, NULL, NULL);
 INSERT INTO public.karma (id, datecreated, person, action, product, distribution, sourcepackagename) VALUES (62, '2001-07-03 21:30:51.583356', 12, 47, NULL, 1, NULL);
 INSERT INTO public.karma (id, datecreated, person, action, product, distribution, sourcepackagename) VALUES (63, '2001-08-09 11:39:16.836856', 63, 1, 20, NULL, NULL);
+INSERT INTO public.karma (id, datecreated, person, action, product, distribution, sourcepackagename) VALUES (64, '2022-04-08 09:19:01.601347', 16, 18, 22, NULL, NULL);
+INSERT INTO public.karma (id, datecreated, person, action, product, distribution, sourcepackagename) VALUES (65, '2022-04-08 09:34:06.779599', 16, 18, 22, NULL, NULL);
+INSERT INTO public.karma (id, datecreated, person, action, product, distribution, sourcepackagename) VALUES (66, '2022-04-08 09:44:10.184713', 16, 18, 22, NULL, NULL);
+INSERT INTO public.karma (id, datecreated, person, action, product, distribution, sourcepackagename) VALUES (67, '2022-04-08 10:16:33.962557', 16, 18, 22, NULL, NULL);
+INSERT INTO public.karma (id, datecreated, person, action, product, distribution, sourcepackagename) VALUES (68, '2022-04-08 10:16:53.481613', 16, 18, 22, NULL, NULL);
 
 
 ALTER TABLE public.karma ENABLE TRIGGER ALL;
@@ -4118,64 +4248,64 @@ ALTER TABLE public.karma ENABLE TRIGGER ALL;
 
 ALTER TABLE public.karmacache DISABLE TRIGGER ALL;
 
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1423, 12, 6, 22, 6, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1424, 12, 2, 15, 12, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1425, 13, 3, 9, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1426, 12, 6, 22, 9, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1427, 12, 2, 13, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1428, 12, 2, 66, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1429, 1, 6, 22, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1430, 16, 2, 15, 8, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1431, 1, 6, 27, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1432, 16, 2, 2, 14, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1433, 16, 2, 15, 13, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1434, 1, 6, 37, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1435, 1, 6, 18, 15, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1437, 16, 2, 26, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1438, 1, 6, 17, 12, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1439, 1, 6, 9, 11, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1440, 16, 3, 164, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1441, 16, 2, 11, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1442, 16, 2, 8, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1443, 1, 6, 130, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1444, 12, 2, 94, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1445, 12, 6, 44, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1446, 13, 3, 9, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1447, 16, 2, 77, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1448, 16, 3, 164, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1449, 12, NULL, 22, 9, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1450, 12, NULL, 15, 12, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1451, 16, NULL, 8, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1452, 16, NULL, 175, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1453, 1, NULL, 27, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1454, 1, NULL, 22, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1455, 16, NULL, 15, 8, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1456, 1, NULL, 9, 11, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1457, 12, NULL, 66, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1458, 16, NULL, 15, 13, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1459, 1, NULL, 18, 15, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1460, 12, NULL, 22, 6, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1461, 16, NULL, 2, 14, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1462, 1, NULL, 17, 12, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1463, 13, NULL, 9, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1464, 12, NULL, 13, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1465, 16, NULL, 26, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1466, 1, NULL, 37, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1467, 16, NULL, 23, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1468, 12, NULL, 66, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1469, 16, NULL, 190, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1470, 12, NULL, 44, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1471, 1, NULL, 27, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1472, 13, NULL, 9, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1473, 1, NULL, 31, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1474, 1, 6, 31, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1475, 1, 6, 27, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1476, 16, 3, 164, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1477, 16, 2, 26, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1478, 12, 6, 44, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1479, 16, 2, 23, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1480, 12, 2, 66, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1481, 13, 3, 9, NULL, NULL, NULL, 5);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 130, NULL, NULL, NULL, NULL, 1443);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 17, 12, NULL, NULL, NULL, 1438);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 18, 15, NULL, NULL, NULL, 1435);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 22, 5, NULL, NULL, NULL, 1429);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 27, 4, NULL, NULL, NULL, 1431);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 27, NULL, NULL, NULL, 4, 1475);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 31, NULL, NULL, NULL, 5, 1474);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 37, NULL, 1, NULL, NULL, 1434);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 9, 11, NULL, NULL, NULL, 1439);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 17, 12, NULL, NULL, NULL, 1462);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 18, 15, NULL, NULL, NULL, 1459);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 22, 5, NULL, NULL, NULL, 1454);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 27, 4, NULL, NULL, NULL, 1453);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 27, NULL, NULL, NULL, 4, 1471);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 31, NULL, NULL, NULL, 5, 1473);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 37, NULL, 1, NULL, NULL, 1466);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 9, 11, NULL, NULL, NULL, 1456);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 2, 13, NULL, 1, NULL, NULL, 1427);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 2, 15, 12, NULL, NULL, NULL, 1424);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 2, 66, 4, NULL, NULL, NULL, 1428);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 2, 66, NULL, NULL, NULL, 4, 1480);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 2, 94, NULL, NULL, NULL, NULL, 1444);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 6, 22, 6, NULL, NULL, NULL, 1423);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 6, 22, 9, NULL, NULL, NULL, 1426);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 6, 44, NULL, NULL, NULL, 5, 1478);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 6, 44, NULL, NULL, NULL, NULL, 1445);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 13, NULL, 1, NULL, NULL, 1464);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 15, 12, NULL, NULL, NULL, 1450);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 22, 6, NULL, NULL, NULL, 1460);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 22, 9, NULL, NULL, NULL, 1449);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 44, NULL, NULL, NULL, 5, 1470);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 66, 4, NULL, NULL, NULL, 1457);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 66, NULL, NULL, NULL, 4, 1468);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (13, 3, 9, 5, NULL, NULL, NULL, 1425);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (13, 3, 9, NULL, NULL, NULL, 5, 1481);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (13, 3, 9, NULL, NULL, NULL, NULL, 1446);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (13, NULL, 9, 5, NULL, NULL, NULL, 1463);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (13, NULL, 9, NULL, NULL, NULL, 5, 1472);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 11, 5, NULL, NULL, NULL, 1441);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 15, 13, NULL, NULL, NULL, 1433);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 15, 8, NULL, NULL, NULL, 1430);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 2, 14, NULL, NULL, NULL, 1432);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 23, NULL, NULL, NULL, 4, 1479);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 26, NULL, 1, NULL, NULL, 1437);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 26, NULL, NULL, NULL, 5, 1477);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 77, NULL, NULL, NULL, NULL, 1447);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 8, 4, NULL, NULL, NULL, 1442);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 3, 164, 5, NULL, NULL, NULL, 1440);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 3, 164, NULL, NULL, NULL, 5, 1476);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 3, 164, NULL, NULL, NULL, NULL, 1448);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 15, 13, NULL, NULL, NULL, 1458);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 15, 8, NULL, NULL, NULL, 1455);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 175, 5, NULL, NULL, NULL, 1452);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 190, NULL, NULL, NULL, 5, 1469);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 2, 14, NULL, NULL, NULL, 1461);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 23, NULL, NULL, NULL, 4, 1467);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 26, NULL, 1, NULL, NULL, 1465);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 8, 4, NULL, NULL, NULL, 1451);
 
 
 ALTER TABLE public.karmacache ENABLE TRIGGER ALL;
@@ -5344,6 +5474,38 @@ Martin Pitt wrote:
 
 
 ', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (51, 53, 1, '** Changed in: redfish
+   Importance: Undecided => Low', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (52, 54, 1, '** Changed in: redfish
+   Importance: Low => High', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (53, 55, 1, '** Changed in: redfish
+   Importance: High => Low', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (54, 56, 1, '** Changed in: redfish
+   Importance: Low => High', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (55, 57, 1, '** Changed in: redfish
+   Importance: High => Low', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (56, 58, 1, '** Changed in redfish
+     Importance explanation: bar!!!! => bazZZZZ', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (57, 59, 1, '** Changed in redfish
+     Importance explanation: bazZZZZ => BAZ', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (58, 60, 1, '** Changed in redfish
+     Importance explanation: BAZ => BAZZ', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (59, 61, 1, '** Changed in jokosher
+     Importance explanation: None => Critically important', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (60, 62, 1, '** Changed in firefox
+     Importance explanation: This is low priority => This is low priority!', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (61, 63, 1, '** Changed in firefox
+     Importance explanation: This is low priority! => None', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (62, 64, 1, '** Changed in firefox
+     Importance explanation: unset => This is low priority!', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (63, 65, 1, '** Changed in firefox
+     Importance explanation: This is low priority! => unset', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (64, 66, 1, '** Changed in firefox
+     Importance explanation: unset => This is low priority!', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (65, 67, 1, '** Changed in firefox
+     Importance explanation: This is low priority! => unset', NULL, NULL);
+INSERT INTO public.messagechunk (id, message, sequence, content, blob, fti) VALUES (66, 68, 1, '** Changed in firefox
+     Importance explanation: unset => This is low priority!', NULL, NULL);
 
 
 ALTER TABLE public.messagechunk ENABLE TRIGGER ALL;
@@ -5426,6 +5588,7 @@ ALTER TABLE public.oauthconsumer DISABLE TRIGGER ALL;
 
 INSERT INTO public.oauthconsumer (id, date_created, disabled, key, secret) VALUES (1, '2008-03-18 20:57:19.108004', false, 'foobar123451432', 'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855');
 INSERT INTO public.oauthconsumer (id, date_created, disabled, key, secret) VALUES (2, '2008-03-18 20:57:44.710251', false, 'launchpad-library', 'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855');
+INSERT INTO public.oauthconsumer (id, date_created, disabled, key, secret) VALUES (3, '2022-04-08 09:43:39.940585', false, 'System-wide: Ubuntu (precious)', 'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855');
 
 
 ALTER TABLE public.oauthconsumer ENABLE TRIGGER ALL;
@@ -5436,6 +5599,7 @@ ALTER TABLE public.oauthaccesstoken DISABLE TRIGGER ALL;
 INSERT INTO public.oauthaccesstoken (id, consumer, person, permission, date_created, date_expires, key, secret, product, project, distribution, sourcepackagename) VALUES (1, 1, 29, 20, '2008-03-18 20:57:44.710251', NULL, 'salgado-read-nonprivate', '2bb80d537b1da3e38bd30361aa855686bde0eacd7162fef6a25fe97bf527a25b', NULL, NULL, NULL, NULL);
 INSERT INTO public.oauthaccesstoken (id, consumer, person, permission, date_created, date_expires, key, secret, product, project, distribution, sourcepackagename) VALUES (2, 2, 29, 50, '2008-03-18 20:57:44.710251', NULL, 'salgado-change-anything', '9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08', NULL, NULL, NULL, NULL);
 INSERT INTO public.oauthaccesstoken (id, consumer, person, permission, date_created, date_expires, key, secret, product, project, distribution, sourcepackagename) VALUES (3, 2, 52, 20, '2008-05-19 21:36:47.994029', NULL, 'nopriv-read-nonprivate', '4f0d9e5f2d159c8bd63247f9470d09f15e1ff431cb88d5a101df49c4c01882e6', NULL, NULL, NULL, NULL);
+INSERT INTO public.oauthaccesstoken (id, consumer, person, permission, date_created, date_expires, key, secret, product, project, distribution, sourcepackagename) VALUES (4, 3, 16, 60, '2022-04-08 09:43:52.630427', NULL, '7fNqbDl39qbDRJKk8kvG', '98d3f29ce30305e2c2ead54f198c2275619831bff5795af0e57fb6cf8c87155f', NULL, NULL, NULL, NULL);
 
 
 ALTER TABLE public.oauthaccesstoken ENABLE TRIGGER ALL;
@@ -11733,3 +11897,6 @@ ALTER TABLE public.xref ENABLE TRIGGER ALL;
 
 
 
+
+
+
diff --git a/database/sampledata/current.sql b/database/sampledata/current.sql
index ec85793..fd26f75 100644
--- a/database/sampledata/current.sql
+++ b/database/sampledata/current.sql
@@ -971,21 +971,21 @@ ALTER TABLE public.translationgroup ENABLE TRIGGER ALL;
 
 ALTER TABLE public.distribution DISABLE TRIGGER ALL;
 
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (1, 'ubuntu', 'Ubuntu Linux', 'Ubuntu is a new approach to Linux Distribution that includes regular releases, and a simplified single-CD installation system.', 'ubuntulinux.org', 17, 'Ubuntu', 'Ubuntu is a new approach to Linux Distribution that includes regular releases, and a simplified single-CD installation system.', 17, NULL, 1, NULL, true, true, NULL, 3, 59, NULL, '2006-10-16 18:31:43.415195', NULL, NULL, NULL, NULL, NULL, true, NULL, true, true, NULL, NULL, NULL, NULL, 10, 10, 20, 60, '{package_name}_derivatives@xxxxxxxxxxxxxxxxxxxxxx', false, NULL, true, true, true, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (2, 'redhat', 'Redhat Advanced Server', 'Red Hat is a commercial distribution of the GNU/Linux Operating System.', 'redhat.com', 1, 'Red Hat', 'Red Hat is a commercial distribution of the GNU/Linux Operating System.', 1, NULL, 1, NULL, false, false, 8, NULL, 1, NULL, '2006-10-16 18:31:43.417928', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (3, 'debian', 'Debian GNU/Linux', 'Debian GNU/Linux is
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (1, 'ubuntu', 'Ubuntu Linux', 'Ubuntu is a new approach to Linux Distribution that includes regular releases, and a simplified single-CD installation system.', 'ubuntulinux.org', 17, 'Ubuntu', 'Ubuntu is a new approach to Linux Distribution that includes regular releases, and a simplified single-CD installation system.', 17, NULL, 1, NULL, true, true, NULL, 3, 59, NULL, '2006-10-16 18:31:43.415195', NULL, NULL, NULL, NULL, NULL, true, NULL, true, true, NULL, NULL, NULL, NULL, 10, 10, 20, 60, '{package_name}_derivatives@xxxxxxxxxxxxxxxxxxxxxx', false, NULL, true, true, true, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (2, 'redhat', 'Redhat Advanced Server', 'Red Hat is a commercial distribution of the GNU/Linux Operating System.', 'redhat.com', 1, 'Red Hat', 'Red Hat is a commercial distribution of the GNU/Linux Operating System.', 1, NULL, 1, NULL, false, false, 8, NULL, 1, NULL, '2006-10-16 18:31:43.417928', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (3, 'debian', 'Debian GNU/Linux', 'Debian GNU/Linux is
 a non commercial distribution of a GNU/Linux Operating System for many
 platforms.', 'debian.org', 1, 'Debian', 'Debian GNU/Linux is
 a non commercial distribution of a GNU/Linux Operating System for many
-platforms.', 1, NULL, 1, NULL, false, false, NULL, NULL, 1, NULL, '2006-10-16 18:31:43.418942', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (4, 'gentoo', 'The Gentoo Linux', 'Gentoo is a very
+platforms.', 1, NULL, 1, NULL, false, false, NULL, NULL, 1, NULL, '2006-10-16 18:31:43.418942', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (4, 'gentoo', 'The Gentoo Linux', 'Gentoo is a very
 customizeable GNU/Linux Distribution that is designed to let you build every
-single package yourself, with your own preferences.', 'gentoo.org', 1, 'Gentoo', 'Gentoo is a very customizeable GNU/Linux Distribution that is designed to let you build every single package yourself, with your own preferences.', 1, NULL, 1, NULL, true, false, NULL, NULL, 1, NULL, '2006-10-16 18:31:43.41974', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (5, 'kubuntu', 'Kubuntu - Free KDE-based Linux', 'Kubuntu is an entirely free Linux distribution that uses the K Desktop
+single package yourself, with your own preferences.', 'gentoo.org', 1, 'Gentoo', 'Gentoo is a very customizeable GNU/Linux Distribution that is designed to let you build every single package yourself, with your own preferences.', 1, NULL, 1, NULL, true, false, NULL, NULL, 1, NULL, '2006-10-16 18:31:43.41974', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (5, 'kubuntu', 'Kubuntu - Free KDE-based Linux', 'Kubuntu is an entirely free Linux distribution that uses the K Desktop
 Environment as its default desktop after install.', 'kubuntu.org', 1, 'Kubuntu', 'Kubuntu is an entirely free Linux distribution that uses the K Desktop
-Environment as its default desktop after install.', 1, NULL, 1, NULL, false, false, 8, NULL, 1, NULL, '2006-10-16 18:31:43.420551', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (7, 'guadalinex', 'GuadaLinex: Linux for Andalucia', 'GuadaLinex is based on Ubuntu and adds full support for applications specific to the local environment in Andalucia.', 'guadalinex.es', 4, 'GuadaLinex', 'The GuadaLinex team produces a high quality linux for the Andalucian marketplace.', 32, NULL, 1, NULL, false, false, NULL, NULL, 4, NULL, '2006-10-16 18:31:43.421329', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
-INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials) VALUES (8, 'ubuntutest', 'Ubuntu Test', 'Ubuntu Test', 'ubuntulinux.org', 17, 'ubuntutest', 'Ubuntu Test summary', 17, NULL, 1, NULL, false, false, NULL, NULL, 17, NULL, '2006-10-16 18:31:43.422162', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL);
+Environment as its default desktop after install.', 1, NULL, 1, NULL, false, false, 8, NULL, 1, NULL, '2006-10-16 18:31:43.420551', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (7, 'guadalinex', 'GuadaLinex: Linux for Andalucia', 'GuadaLinex is based on Ubuntu and adds full support for applications specific to the local environment in Andalucia.', 'guadalinex.es', 4, 'GuadaLinex', 'The GuadaLinex team produces a high quality linux for the Andalucian marketplace.', 32, NULL, 1, NULL, false, false, NULL, NULL, 4, NULL, '2006-10-16 18:31:43.421329', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
+INSERT INTO public.distribution (id, name, title, description, domainname, owner, displayname, summary, members, translationgroup, translationpermission, bug_supervisor, official_malone, official_rosetta, driver, translation_focus, mirror_admin, upload_sender, date_created, homepage_content, icon, mugshot, logo, fti, official_answers, language_pack_admin, official_blueprints, enable_bug_expiration, bug_reporting_guidelines, reviewer_whiteboard, max_bug_heat, bug_reported_acknowledgement, answers_usage, blueprints_usage, translations_usage, registrant, package_derivatives_email, redirect_release_uploads, development_series_alias, official_packages, supports_ppas, supports_mirrors, vcs, oci_project_admin, default_traversal_policy, redirect_default_traversal, oci_credentials, branch_sharing_policy, bug_sharing_policy, specification_sharing_policy, information_type, access_policies) VALUES (8, 'ubuntutest', 'Ubuntu Test', 'Ubuntu Test', 'ubuntulinux.org', 17, 'ubuntutest', 'Ubuntu Test summary', 17, NULL, 1, NULL, false, false, NULL, NULL, 17, NULL, '2006-10-16 18:31:43.422162', NULL, NULL, NULL, NULL, NULL, false, NULL, false, false, NULL, NULL, NULL, NULL, 10, 10, 10, 60, NULL, false, NULL, false, false, false, NULL, NULL, 0, false, NULL, 1, 1, 1, 1, NULL);
 
 
 ALTER TABLE public.distribution ENABLE TRIGGER ALL;
@@ -1224,19 +1224,19 @@ ALTER TABLE public.branch ENABLE TRIGGER ALL;
 
 ALTER TABLE public.bug DISABLE TRIGGER ALL;
 
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (1, '2004-01-01 20:58:04.553583', NULL, 'Firefox does not support SVG', 'Firefox needs to support embedded SVG images, now that the standard has been finalised.
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (1, '2004-01-01 20:58:04.553583', NULL, 'Firefox does not support SVG', 'Firefox needs to support embedded SVG images, now that the standard has been finalised.
 
-The SVG standard 1.0 is complete, and draft implementations for Firefox exist. One of these implementations needs to be integrated with the base install of Firefox. Ideally, the implementation needs to include support for the manipulation of SVG objects from JavaScript to enable interactive and dynamic SVG drawings.', 12, NULL, NULL, '2006-05-19 06:37:40.344941', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (2, '2004-01-02 20:58:04.572546', 'blackhole', 'Blackhole Trash folder', 'The Trash folder seems to have significant problems! At the moment, dragging an item to the trash results in immediate deletion. The item does not appear in the Trash, it is just deleted from my hard disk. There is no undo or ability to recover the deleted file. Help!', 12, NULL, NULL, '2006-07-14 08:47:36.124403', NULL, NULL, NULL, 0, 3, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (3, '2004-01-03 00:00:00', NULL, 'Bug Title Test', 'Shirtpkdf user@xxxxxxxxxx lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo
+The SVG standard 1.0 is complete, and draft implementations for Firefox exist. One of these implementations needs to be integrated with the base install of Firefox. Ideally, the implementation needs to include support for the manipulation of SVG objects from JavaScript to enable interactive and dynamic SVG drawings.', 12, NULL, NULL, '2006-05-19 06:37:40.344941', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (2, '2004-01-02 20:58:04.572546', 'blackhole', 'Blackhole Trash folder', 'The Trash folder seems to have significant problems! At the moment, dragging an item to the trash results in immediate deletion. The item does not appear in the Trash, it is just deleted from my hard disk. There is no undo or ability to recover the deleted file. Help!', 12, NULL, NULL, '2006-07-14 08:47:36.124403', NULL, NULL, NULL, 0, 3, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (3, '2004-01-03 00:00:00', NULL, 'Bug Title Test', 'Shirtpkdf user@xxxxxxxxxx lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo
 
 y idu yifdxhfgffxShirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xoShirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo
 Shirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xoShirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo
 
-Shirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xoShirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo', 16, NULL, NULL, '2006-07-14 08:48:52.922462', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (4, '2004-01-04 00:00:00', NULL, 'Reflow problems with complex page layouts', 'Malone pages that use more complex layouts with portlets and fancy CSS are sometimes not getting properly reflowed after rendering.', 12, NULL, NULL, '2006-07-14 08:49:17.124885', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (5, '2004-01-05 00:00:00', NULL, 'Firefox install instructions should be complete', 'All ways of downloading firefox should provide complete install instructions. At present, they are only visible on the Release Notes page.', 12, NULL, NULL, '2006-07-14 08:49:40.553212', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (6, '2004-01-06 00:00:00', NULL, 'Firefox crashes when Save As dialog for a nonexistent window is closed', 'User-Agent:
+Shirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xoShirtpkdf jlkdsj;lkd lkjd hlkjfds gkfdsg kfd glkfd gifdsytoxdiytxoiufdytoidxf yxoigfyoigfxuyfxoiug yxoiuy oiugf hyoifxugyoixgfuy xoiuyxoiyxoifuy xo', 16, NULL, NULL, '2006-07-14 08:48:52.922462', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (4, '2004-01-04 00:00:00', NULL, 'Reflow problems with complex page layouts', 'Malone pages that use more complex layouts with portlets and fancy CSS are sometimes not getting properly reflowed after rendering.', 12, NULL, NULL, '2006-07-14 08:49:17.124885', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (5, '2004-01-05 00:00:00', NULL, 'Firefox install instructions should be complete', 'All ways of downloading firefox should provide complete install instructions. At present, they are only visible on the Release Notes page.', 12, NULL, NULL, '2006-07-14 08:49:40.553212', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (6, '2004-01-06 00:00:00', NULL, 'Firefox crashes when Save As dialog for a nonexistent window is closed', 'User-Agent:
 Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040207 Firefox/0.8
 
 If a Save As dialog for a nonexistent window exists, when the dialog is closed Firefox will crash.  It''s possible to cause this to happen using the "Open With/Save As" dialog.
@@ -1255,12 +1255,12 @@ Actual Results:
 Crash!
 
 Expected Results:
-Not crashed.', 12, 5, NULL, '2006-05-19 06:37:40.389193', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (7, '2004-01-07 15:12:29.602117', NULL, 'A test bug', 'A test description', 16, NULL, NULL, '2006-05-19 06:37:40.391822', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (8, '2004-01-08 09:10:17.13237', NULL, 'Printing doesn''t work', 'When I press print in Firefox, nothing happens, not even a print dialog comes up.', 12, NULL, NULL, '2006-05-19 06:37:40.393303', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (9, '2004-01-09 16:42:14.080227', NULL, 'Thunderbird crashes', 'Every time I start Thunderbird it crashes.', 16, NULL, NULL, '2006-07-14 08:45:10.600579', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (10, '2004-01-10 19:42:21.890299', NULL, 'another test bug', 'test bug', 16, NULL, NULL, '2006-07-14 08:54:19.453881', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (11, '2007-03-15 20:33:56.67893', NULL, 'Make Jokosher use autoaudiosink', 'I''ve had problems when switching from Jokosher to Totem to play an Ogg.
+Not crashed.', 12, 5, NULL, '2006-05-19 06:37:40.389193', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (7, '2004-01-07 15:12:29.602117', NULL, 'A test bug', 'A test description', 16, NULL, NULL, '2006-05-19 06:37:40.391822', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (8, '2004-01-08 09:10:17.13237', NULL, 'Printing doesn''t work', 'When I press print in Firefox, nothing happens, not even a print dialog comes up.', 12, NULL, NULL, '2006-05-19 06:37:40.393303', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (9, '2004-01-09 16:42:14.080227', NULL, 'Thunderbird crashes', 'Every time I start Thunderbird it crashes.', 16, NULL, NULL, '2006-07-14 08:45:10.600579', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (10, '2004-01-10 19:42:21.890299', NULL, 'another test bug', 'test bug', 16, NULL, NULL, '2006-07-14 08:54:19.453881', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (11, '2007-03-15 20:33:56.67893', NULL, 'Make Jokosher use autoaudiosink', 'I''ve had problems when switching from Jokosher to Totem to play an Ogg.
 
 Totem appears to be playing normally but does not produce any sound.
 If I close Jokosher then you can hear totem.
@@ -1286,11 +1286,11 @@ I had to restart!
 Is there some way to reset alsa or the device driver - with out having
 to restart?
 
-Running on Ubuntu - with Jokosher 0.2 runscript.', 16, NULL, NULL, '2007-03-15 20:37:51.603369', NULL, NULL, NULL, 0, 7, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (12, '2007-03-15 20:41:18.635493', NULL, 'Copy, Cut and Delete operations should work on selections', 'When trying to copy, cut or delete just a selected portion of an event, the operations affect the event completely. That is, you can''t select a portion and cut that piece. The whole event will be cut. Same goes for the other 2 operations.', 16, NULL, NULL, '2007-03-15 20:46:49.909153', NULL, NULL, NULL, 0, 5, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (13, '2007-07-27 20:00:58.299796', NULL, 'Launchpad CSS and JS is not testible', 'The messages placed on this bug are for eyeball viewing of JS and CSS behaviour.', 12, NULL, NULL, '2007-07-27 20:29:46.336737', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (14, '2007-08-09 11:39:16.836856', NULL, 'jokosher exposes personal details in its actions portlet', 'Jokosher discloses to any passerby the fact that I am single and unwed in its actions portlet. Please fix this blatant violacion of privacy now!!', 63, NULL, NULL, '2007-08-09 11:39:16.836856', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 3);
-INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type) VALUES (15, '2007-12-18 16:30:19.103679', NULL, 'Nonsensical bugs are useless', 'Like this one, natch.', 16, NULL, NULL, '2007-12-18 16:31:34.972893', NULL, NULL, '2007-12-18 16:31:34.790641', 0, 7, 0, 0, 0, NULL, NULL, 1);
+Running on Ubuntu - with Jokosher 0.2 runscript.', 16, NULL, NULL, '2007-03-15 20:37:51.603369', NULL, NULL, NULL, 0, 7, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (12, '2007-03-15 20:41:18.635493', NULL, 'Copy, Cut and Delete operations should work on selections', 'When trying to copy, cut or delete just a selected portion of an event, the operations affect the event completely. That is, you can''t select a portion and cut that piece. The whole event will be cut. Same goes for the other 2 operations.', 16, NULL, NULL, '2007-03-15 20:46:49.909153', NULL, NULL, NULL, 0, 5, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (13, '2007-07-27 20:00:58.299796', NULL, 'Launchpad CSS and JS is not testible', 'The messages placed on this bug are for eyeball viewing of JS and CSS behaviour.', 12, NULL, NULL, '2007-07-27 20:29:46.336737', NULL, NULL, NULL, 0, 2, 0, 0, 0, NULL, NULL, 1, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (14, '2007-08-09 11:39:16.836856', NULL, 'jokosher exposes personal details in its actions portlet', 'Jokosher discloses to any passerby the fact that I am single and unwed in its actions portlet. Please fix this blatant violacion of privacy now!!', 63, NULL, NULL, '2007-08-09 11:39:16.836856', NULL, NULL, NULL, 0, 1, 0, 0, 0, NULL, NULL, 3, 0, NULL);
+INSERT INTO public.bug (id, datecreated, name, title, description, owner, duplicateof, fti, date_last_updated, date_made_private, who_made_private, date_last_message, number_of_duplicates, message_count, users_affected_count, users_unaffected_count, heat, heat_last_updated, latest_patch_uploaded, information_type, lock_status, lock_reason) VALUES (15, '2007-12-18 16:30:19.103679', NULL, 'Nonsensical bugs are useless', 'Like this one, natch.', 16, NULL, NULL, '2007-12-18 16:31:34.972893', NULL, NULL, '2007-12-18 16:31:34.790641', 0, 7, 0, 0, 0, NULL, NULL, 1, 0, NULL);
 
 
 ALTER TABLE public.bug ENABLE TRIGGER ALL;
@@ -2881,34 +2881,34 @@ ALTER TABLE public.bugtag ENABLE TRIGGER ALL;
 
 ALTER TABLE public.bugtask DISABLE TRIGGER ALL;
 
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (2, 1, 4, NULL, NULL, NULL, 10, 20, 1, '2005-01-02 11:07:20.330975', '2004-01-02 03:49:22.910878', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (3, 2, 1, NULL, NULL, NULL, 10, 20, NULL, '2005-01-03 11:07:20.330975', '2004-01-03 03:49:22.908491', 12, NULL, NULL, 'Tomcat', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (4, 1, NULL, 3, NULL, 1, 20, 20, NULL, '2005-01-04 11:07:20.584746', '2004-01-04 03:49:22.79024', 12, NULL, 8, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (5, 2, NULL, 3, NULL, 1, 20, 20, 12, '2005-01-05 11:07:20.584746', '2004-01-05 03:49:22.824591', 12, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (6, 3, NULL, 3, NULL, 1, 10, 999, NULL, '2005-01-06 11:07:20.584746', '2004-01-06 03:49:22.825533', 16, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (13, 4, 4, NULL, NULL, NULL, 10, 30, NULL, '2005-01-13 17:20:12.820778', '2004-01-13 17:20:12.820778', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (14, 5, 4, NULL, NULL, NULL, 10, 50, 12, '2005-01-14 17:27:03.702622', '2004-01-14 17:27:03.702622', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (15, 6, 4, NULL, NULL, NULL, 10, 40, NULL, '2005-01-15 17:35:39.548665', '2004-01-15 17:35:39.548665', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (16, 5, NULL, NULL, 1, 1, 10, 30, NULL, '2005-01-16 14:43:02.452716', '2004-01-16 14:43:02.452716', 12, NULL, NULL, 'mozilla-firefox (Ubuntu Warty)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (17, 1, NULL, 1, NULL, 1, 10, 30, NULL, '2005-01-17 01:15:48.241836', '2004-01-17 01:15:48.241836', 16, NULL, NULL, 'mozilla-firefox (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (18, 3, NULL, NULL, 6, 1, 10, 30, NULL, '2005-01-18 16:30:32.295049', '2004-01-18 16:30:32.295049', 12, NULL, NULL, 'mozilla-firefox (Debian Woody)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (19, 3, NULL, NULL, 7, 1, 10, 30, NULL, '2005-01-19 16:30:47.448639', '2004-01-19 16:30:47.448639', 12, 2, 10, 'mozilla-firefox (Debian Sarge)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (20, 2, NULL, NULL, 6, 1, 10, 30, NULL, '2005-01-20 13:54:57.840344', '2004-01-20 13:54:57.840344', 12, NULL, NULL, 'mozilla-firefox (Debian Woody)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (21, 7, 5, NULL, NULL, NULL, 10, 30, 16, '2005-01-21 15:12:29.602117', '2004-01-21 15:12:29.602117', 16, NULL, NULL, 'Evolution', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (22, 8, NULL, 3, NULL, 1, 30, 30, 16, '2005-01-22 09:10:17.13237', '2004-01-22 09:10:17.13237', 12, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, '2005-01-25 09:10:17.13237', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (23, 9, NULL, 1, NULL, 18, 20, 30, NULL, '2005-01-23 16:42:14.080227', '2004-01-23 16:42:14.080227', 16, NULL, NULL, 'thunderbird (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (24, 9, 8, NULL, NULL, NULL, 999, 999, NULL, '2005-01-24 16:43:25.744534', '2004-01-24 16:43:25.744534', 12, NULL, 6, 'Mozilla Thunderbird', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (25, 10, NULL, 1, NULL, 22, 10, 30, NULL, '2005-01-25 19:42:21.890299', '2004-01-25 19:42:21.890299', 16, NULL, NULL, 'linux-source-2.6.15 (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (26, 2, NULL, 1, NULL, NULL, 10, 30, NULL, '2005-01-26 10:11:02.729077', '2004-01-26 10:11:02.729077', 16, NULL, NULL, 'Ubuntu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (27, 7, NULL, 3, NULL, 9, 999, 999, NULL, '2005-01-27 16:45:45.054836', '2004-01-27 16:45:45.054836', 12, NULL, 7, 'evolution (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (28, 2, NULL, NULL, 3, NULL, 10, 5, NULL, NULL, '2006-08-21 22:23:08.163936', 1, NULL, NULL, 'Ubuntu Hoary', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (29, 5, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-01-04 15:00:50.431687', 16, NULL, NULL, 'Mozilla Firefox 1.0', NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (30, 11, 20, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-03-15 20:33:56.67893', 16, NULL, NULL, 'Jokosher', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (31, 12, 20, NULL, NULL, NULL, 20, 50, NULL, NULL, '2007-03-15 20:41:18.635493', 16, NULL, NULL, 'Jokosher', '2007-03-15 20:41:42.256326', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (32, 13, 17, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-07-27 20:00:58.299796', 12, NULL, NULL, 'Launchpad', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (33, 14, 20, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-08-09 11:39:16.836856', 63, NULL, NULL, 'Jokosher', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (34, 15, 22, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-12-18 16:30:19.103679', 16, NULL, NULL, 'Redfish', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries) VALUES (35, 15, 8, NULL, NULL, NULL, 10, 999, NULL, NULL, '2007-12-18 16:30:47.889614', 16, NULL, 11, 'Mozilla Thunderbird', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (2, 1, 4, NULL, NULL, NULL, 10, 20, 1, '2005-01-02 11:07:20.330975', '2004-01-02 03:49:22.910878', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (3, 2, 1, NULL, NULL, NULL, 10, 20, NULL, '2005-01-03 11:07:20.330975', '2004-01-03 03:49:22.908491', 12, NULL, NULL, 'Tomcat', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (4, 1, NULL, 3, NULL, 1, 20, 20, NULL, '2005-01-04 11:07:20.584746', '2004-01-04 03:49:22.79024', 12, NULL, 8, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (5, 2, NULL, 3, NULL, 1, 20, 20, 12, '2005-01-05 11:07:20.584746', '2004-01-05 03:49:22.824591', 12, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (6, 3, NULL, 3, NULL, 1, 10, 999, NULL, '2005-01-06 11:07:20.584746', '2004-01-06 03:49:22.825533', 16, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (13, 4, 4, NULL, NULL, NULL, 10, 30, NULL, '2005-01-13 17:20:12.820778', '2004-01-13 17:20:12.820778', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (14, 5, 4, NULL, NULL, NULL, 10, 50, 12, '2005-01-14 17:27:03.702622', '2004-01-14 17:27:03.702622', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (15, 6, 4, NULL, NULL, NULL, 10, 40, NULL, '2005-01-15 17:35:39.548665', '2004-01-15 17:35:39.548665', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (16, 5, NULL, NULL, 1, 1, 10, 30, NULL, '2005-01-16 14:43:02.452716', '2004-01-16 14:43:02.452716', 12, NULL, NULL, 'mozilla-firefox (Ubuntu Warty)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (17, 1, NULL, 1, NULL, 1, 10, 30, NULL, '2005-01-17 01:15:48.241836', '2004-01-17 01:15:48.241836', 16, NULL, NULL, 'mozilla-firefox (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (18, 3, NULL, NULL, 6, 1, 10, 30, NULL, '2005-01-18 16:30:32.295049', '2004-01-18 16:30:32.295049', 12, NULL, NULL, 'mozilla-firefox (Debian Woody)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (19, 3, NULL, NULL, 7, 1, 10, 30, NULL, '2005-01-19 16:30:47.448639', '2004-01-19 16:30:47.448639', 12, 2, 10, 'mozilla-firefox (Debian Sarge)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (20, 2, NULL, NULL, 6, 1, 10, 30, NULL, '2005-01-20 13:54:57.840344', '2004-01-20 13:54:57.840344', 12, NULL, NULL, 'mozilla-firefox (Debian Woody)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (21, 7, 5, NULL, NULL, NULL, 10, 30, 16, '2005-01-21 15:12:29.602117', '2004-01-21 15:12:29.602117', 16, NULL, NULL, 'Evolution', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (22, 8, NULL, 3, NULL, 1, 30, 30, 16, '2005-01-22 09:10:17.13237', '2004-01-22 09:10:17.13237', 12, NULL, NULL, 'mozilla-firefox (Debian)', NULL, NULL, '2005-01-25 09:10:17.13237', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (23, 9, NULL, 1, NULL, 18, 20, 30, NULL, '2005-01-23 16:42:14.080227', '2004-01-23 16:42:14.080227', 16, NULL, NULL, 'thunderbird (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (24, 9, 8, NULL, NULL, NULL, 999, 999, NULL, '2005-01-24 16:43:25.744534', '2004-01-24 16:43:25.744534', 12, NULL, 6, 'Mozilla Thunderbird', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (25, 10, NULL, 1, NULL, 22, 10, 30, NULL, '2005-01-25 19:42:21.890299', '2004-01-25 19:42:21.890299', 16, NULL, NULL, 'linux-source-2.6.15 (Ubuntu)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (26, 2, NULL, 1, NULL, NULL, 10, 30, NULL, '2005-01-26 10:11:02.729077', '2004-01-26 10:11:02.729077', 16, NULL, NULL, 'Ubuntu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (27, 7, NULL, 3, NULL, 9, 999, 999, NULL, '2005-01-27 16:45:45.054836', '2004-01-27 16:45:45.054836', 12, NULL, 7, 'evolution (Debian)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (28, 2, NULL, NULL, 3, NULL, 10, 5, NULL, NULL, '2006-08-21 22:23:08.163936', 1, NULL, NULL, 'Ubuntu Hoary', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (29, 5, NULL, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-01-04 15:00:50.431687', 16, NULL, NULL, 'Mozilla Firefox 1.0', NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (30, 11, 20, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-03-15 20:33:56.67893', 16, NULL, NULL, 'Jokosher', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (31, 12, 20, NULL, NULL, NULL, 20, 50, NULL, NULL, '2007-03-15 20:41:18.635493', 16, NULL, NULL, 'Jokosher', '2007-03-15 20:41:42.256326', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (32, 13, 17, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-07-27 20:00:58.299796', 12, NULL, NULL, 'Launchpad', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (33, 14, 20, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-08-09 11:39:16.836856', 63, NULL, NULL, 'Jokosher', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (34, 15, 22, NULL, NULL, NULL, 10, 5, NULL, NULL, '2007-12-18 16:30:19.103679', 16, NULL, NULL, 'Redfish', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+INSERT INTO public.bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set, ociproject, ociprojectseries, status_explanation, importance_explanation) VALUES (35, 15, 8, NULL, NULL, NULL, 10, 999, NULL, NULL, '2007-12-18 16:30:47.889614', 16, NULL, 11, 'Mozilla Thunderbird', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
 
 
 ALTER TABLE public.bugtask ENABLE TRIGGER ALL;
@@ -3055,6 +3055,13 @@ ALTER TABLE public.charmrecipejob DISABLE TRIGGER ALL;
 ALTER TABLE public.charmrecipejob ENABLE TRIGGER ALL;
 
 
+ALTER TABLE public.cibuild DISABLE TRIGGER ALL;
+
+
+
+ALTER TABLE public.cibuild ENABLE TRIGGER ALL;
+
+
 ALTER TABLE public.codeimport DISABLE TRIGGER ALL;
 
 INSERT INTO public.codeimport (id, branch, date_created, registrant, rcs_type, cvs_root, cvs_module, review_status, date_last_successful, owner, assignee, update_interval, url, git_repository) VALUES (1, 75, '2007-06-25 20:04:04.226605', 52, 2, NULL, NULL, 20, NULL, 52, NULL, NULL, 'http://svn.example.org/svnroot/gnome-terminal/trunk', NULL);
@@ -3145,8 +3152,8 @@ ALTER TABLE public.codereviewvote ENABLE TRIGGER ALL;
 
 ALTER TABLE public.commercialsubscription DISABLE TRIGGER ALL;
 
-INSERT INTO public.commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id) VALUES (1, '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.838229', '2032-01-01 00:00:00', 10, 16, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:37.838229+00:00');
-INSERT INTO public.commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id) VALUES (2, '2012-10-08 11:09:46.861812', '2012-10-08 11:09:46.861812', '2012-10-08 11:09:46.912691', '2032-01-01 00:00:00', 10, 17, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:46.912691+00:00');
+INSERT INTO public.commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id, distribution) VALUES (1, '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.838229', '2032-01-01 00:00:00', 10, 16, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:37.838229+00:00', NULL);
+INSERT INTO public.commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id, distribution) VALUES (2, '2012-10-08 11:09:46.861812', '2012-10-08 11:09:46.861812', '2012-10-08 11:09:46.912691', '2032-01-01 00:00:00', 10, 17, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:46.912691+00:00', NULL);
 
 
 ALTER TABLE public.commercialsubscription ENABLE TRIGGER ALL;
@@ -3187,16 +3194,16 @@ ALTER TABLE public.customlanguagecode ENABLE TRIGGER ALL;
 
 ALTER TABLE public.cve DISABLE TRIGGER ALL;
 
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (1, '1999-8979', 2, 'Firefox crashes all the time', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.508959', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (2, '1999-2345', 1, 'Possible data loss', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.513099', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (3, '2005-2730', 1, 'The HTTP proxy in Astaro Security Linux 6.0 allows remote attackers to obtain sensitive information via an invalid request, which reveals a Proxy-authorization string in an error message.', '2005-09-13 14:05:15.669384', '2005-09-13 14:05:15.669384', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (4, '2005-2731', 1, 'Directory traversal vulnerability in Astaro Security Linux 6.0, when using Webmin, allows remote authenticated webmin users to read arbitrary files via a ..  (dot dot) in the wfe_download parameter to index.fpl.', '2005-09-13 14:05:15.91729', '2005-09-13 14:05:15.91729', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (5, '2005-2732', 1, 'AWStats 6.4, and possibly earlier versions, allows remote attackers to obtain sensitive information via a file that does not exist in the config parameter, which reveals the path in an error message.', '2005-09-13 14:05:15.992007', '2005-09-13 14:05:15.992007', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (6, '2005-2733', 1, 'upload_img_cgi.php in Simple PHP Blog (SPHPBlog) does not properly restrict file extensions of uploaded files, which could allow remote attackers to execute arbitrary code.', '2005-09-13 14:05:16.072418', '2005-09-13 14:05:16.072418', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (7, '2005-2734', 1, 'Cross-site scripting (XSS) vulnerability in Gallery 1.5.1-RC2 and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.202393', '2005-09-13 14:05:16.202393', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (8, '2005-2735', 1, 'Cross-site scripting (XSS) vulnerability in phpGraphy 0.9.9a and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.412226', '2005-09-13 14:05:16.412226', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (9, '2005-2736', 1, 'Cross-site scripting (XSS) vulnerability in YaPig 0.95 and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.841572', '2005-09-13 14:05:16.841572', NULL);
-INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (10, '2005-2737', 1, 'Cross-site scripting (XSS) vulnerability in PhotoPost PHP Pro 5.1 allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:17.043865', '2005-09-13 14:05:17.043865', NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (1, '1999-8979', 2, 'Firefox crashes all the time', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.508959', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (2, '1999-2345', 1, 'Possible data loss', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.513099', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (3, '2005-2730', 1, 'The HTTP proxy in Astaro Security Linux 6.0 allows remote attackers to obtain sensitive information via an invalid request, which reveals a Proxy-authorization string in an error message.', '2005-09-13 14:05:15.669384', '2005-09-13 14:05:15.669384', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (4, '2005-2731', 1, 'Directory traversal vulnerability in Astaro Security Linux 6.0, when using Webmin, allows remote authenticated webmin users to read arbitrary files via a ..  (dot dot) in the wfe_download parameter to index.fpl.', '2005-09-13 14:05:15.91729', '2005-09-13 14:05:15.91729', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (5, '2005-2732', 1, 'AWStats 6.4, and possibly earlier versions, allows remote attackers to obtain sensitive information via a file that does not exist in the config parameter, which reveals the path in an error message.', '2005-09-13 14:05:15.992007', '2005-09-13 14:05:15.992007', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (6, '2005-2733', 1, 'upload_img_cgi.php in Simple PHP Blog (SPHPBlog) does not properly restrict file extensions of uploaded files, which could allow remote attackers to execute arbitrary code.', '2005-09-13 14:05:16.072418', '2005-09-13 14:05:16.072418', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (7, '2005-2734', 1, 'Cross-site scripting (XSS) vulnerability in Gallery 1.5.1-RC2 and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.202393', '2005-09-13 14:05:16.202393', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (8, '2005-2735', 1, 'Cross-site scripting (XSS) vulnerability in phpGraphy 0.9.9a and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.412226', '2005-09-13 14:05:16.412226', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (9, '2005-2736', 1, 'Cross-site scripting (XSS) vulnerability in YaPig 0.95 and earlier allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:16.841572', '2005-09-13 14:05:16.841572', NULL, NULL, NULL, NULL);
+INSERT INTO public.cve (id, sequence, status, description, datecreated, datemodified, fti, date_made_public, discoverer, cvss) VALUES (10, '2005-2737', 1, 'Cross-site scripting (XSS) vulnerability in PhotoPost PHP Pro 5.1 allows remote attackers to inject arbitrary web script or HTML via EXIF data, such as the Camera Model Tag.', '2005-09-13 14:05:17.043865', '2005-09-13 14:05:17.043865', NULL, NULL, NULL, NULL);
 
 
 ALTER TABLE public.cve ENABLE TRIGGER ALL;
@@ -4042,64 +4049,64 @@ ALTER TABLE public.karma ENABLE TRIGGER ALL;
 
 ALTER TABLE public.karmacache DISABLE TRIGGER ALL;
 
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1423, 12, 6, 22, 6, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1424, 12, 2, 15, 12, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1425, 13, 3, 9, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1426, 12, 6, 22, 9, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1427, 12, 2, 13, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1428, 12, 2, 66, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1429, 1, 6, 22, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1430, 16, 2, 15, 8, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1431, 1, 6, 27, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1432, 16, 2, 2, 14, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1433, 16, 2, 15, 13, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1434, 1, 6, 37, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1435, 1, 6, 18, 15, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1437, 16, 2, 26, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1438, 1, 6, 17, 12, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1439, 1, 6, 9, 11, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1440, 16, 3, 164, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1441, 16, 2, 11, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1442, 16, 2, 8, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1443, 1, 6, 130, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1444, 12, 2, 94, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1445, 12, 6, 44, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1446, 13, 3, 9, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1447, 16, 2, 77, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1448, 16, 3, 164, NULL, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1449, 12, NULL, 22, 9, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1450, 12, NULL, 15, 12, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1451, 16, NULL, 8, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1452, 16, NULL, 175, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1453, 1, NULL, 27, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1454, 1, NULL, 22, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1455, 16, NULL, 15, 8, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1456, 1, NULL, 9, 11, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1457, 12, NULL, 66, 4, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1458, 16, NULL, 15, 13, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1459, 1, NULL, 18, 15, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1460, 12, NULL, 22, 6, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1461, 16, NULL, 2, 14, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1462, 1, NULL, 17, 12, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1463, 13, NULL, 9, 5, NULL, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1464, 12, NULL, 13, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1465, 16, NULL, 26, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1466, 1, NULL, 37, NULL, 1, NULL, NULL);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1467, 16, NULL, 23, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1468, 12, NULL, 66, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1469, 16, NULL, 190, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1470, 12, NULL, 44, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1471, 1, NULL, 27, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1472, 13, NULL, 9, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1473, 1, NULL, 31, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1474, 1, 6, 31, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1475, 1, 6, 27, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1476, 16, 3, 164, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1477, 16, 2, 26, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1478, 12, 6, 44, NULL, NULL, NULL, 5);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1479, 16, 2, 23, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1480, 12, 2, 66, NULL, NULL, NULL, 4);
-INSERT INTO public.karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1481, 13, 3, 9, NULL, NULL, NULL, 5);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 130, NULL, NULL, NULL, NULL, 1443);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 17, 12, NULL, NULL, NULL, 1438);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 18, 15, NULL, NULL, NULL, 1435);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 22, 5, NULL, NULL, NULL, 1429);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 27, 4, NULL, NULL, NULL, 1431);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 27, NULL, NULL, NULL, 4, 1475);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 31, NULL, NULL, NULL, 5, 1474);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 37, NULL, 1, NULL, NULL, 1434);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, 6, 9, 11, NULL, NULL, NULL, 1439);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 17, 12, NULL, NULL, NULL, 1462);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 18, 15, NULL, NULL, NULL, 1459);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 22, 5, NULL, NULL, NULL, 1454);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 27, 4, NULL, NULL, NULL, 1453);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 27, NULL, NULL, NULL, 4, 1471);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 31, NULL, NULL, NULL, 5, 1473);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 37, NULL, 1, NULL, NULL, 1466);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (1, NULL, 9, 11, NULL, NULL, NULL, 1456);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 2, 13, NULL, 1, NULL, NULL, 1427);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 2, 15, 12, NULL, NULL, NULL, 1424);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 2, 66, 4, NULL, NULL, NULL, 1428);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 2, 66, NULL, NULL, NULL, 4, 1480);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 2, 94, NULL, NULL, NULL, NULL, 1444);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 6, 22, 6, NULL, NULL, NULL, 1423);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 6, 22, 9, NULL, NULL, NULL, 1426);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 6, 44, NULL, NULL, NULL, 5, 1478);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, 6, 44, NULL, NULL, NULL, NULL, 1445);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 13, NULL, 1, NULL, NULL, 1464);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 15, 12, NULL, NULL, NULL, 1450);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 22, 6, NULL, NULL, NULL, 1460);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 22, 9, NULL, NULL, NULL, 1449);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 44, NULL, NULL, NULL, 5, 1470);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 66, 4, NULL, NULL, NULL, 1457);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (12, NULL, 66, NULL, NULL, NULL, 4, 1468);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (13, 3, 9, 5, NULL, NULL, NULL, 1425);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (13, 3, 9, NULL, NULL, NULL, 5, 1481);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (13, 3, 9, NULL, NULL, NULL, NULL, 1446);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (13, NULL, 9, 5, NULL, NULL, NULL, 1463);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (13, NULL, 9, NULL, NULL, NULL, 5, 1472);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 11, 5, NULL, NULL, NULL, 1441);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 15, 13, NULL, NULL, NULL, 1433);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 15, 8, NULL, NULL, NULL, 1430);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 2, 14, NULL, NULL, NULL, 1432);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 23, NULL, NULL, NULL, 4, 1479);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 26, NULL, 1, NULL, NULL, 1437);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 26, NULL, NULL, NULL, 5, 1477);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 77, NULL, NULL, NULL, NULL, 1447);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 2, 8, 4, NULL, NULL, NULL, 1442);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 3, 164, 5, NULL, NULL, NULL, 1440);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 3, 164, NULL, NULL, NULL, 5, 1476);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, 3, 164, NULL, NULL, NULL, NULL, 1448);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 15, 13, NULL, NULL, NULL, 1458);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 15, 8, NULL, NULL, NULL, 1455);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 175, 5, NULL, NULL, NULL, 1452);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 190, NULL, NULL, NULL, 5, 1469);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 2, 14, NULL, NULL, NULL, 1461);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 23, NULL, NULL, NULL, 4, 1467);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 26, NULL, 1, NULL, NULL, 1465);
+INSERT INTO public.karmacache (person, category, karmavalue, product, distribution, sourcepackagename, project, id) VALUES (16, NULL, 8, 4, NULL, NULL, NULL, 1451);
 
 
 ALTER TABLE public.karmacache ENABLE TRIGGER ALL;
@@ -11647,3 +11654,6 @@ ALTER TABLE public.xref ENABLE TRIGGER ALL;
 
 
 
+
+
+