we should not include DBIx::ClassDeploymentHandlerVersion as a table in its own right

diff --git a/Debbugs/DB/Result/DbixClassDeploymenthandlerVersion.pm b/Debbugs/DB/Result/DbixClassDeploymenthandlerVersion.pm
deleted file mode 100644 (file)
index 9ad1d94..0000000
--- a/Debbugs/DB/Result/DbixClassDeploymenthandlerVersion.pm
+++ /dev/null
@@ -1,111 +0,0 @@
-use utf8;
-package Debbugs::DB::Result::DbixClassDeploymenthandlerVersion;
-
-# Created by DBIx::Class::Schema::Loader
-# DO NOT MODIFY THE FIRST PART OF THIS FILE
-
-=head1 NAME
-
-Debbugs::DB::Result::DbixClassDeploymenthandlerVersion
-
-=cut
-
-use strict;
-use warnings;
-
-use base 'DBIx::Class::Core';
-
-=head1 COMPONENTS LOADED
-
-=over 4
-
-=item * L<DBIx::Class::InflateColumn::DateTime>
-
-=back
-
-=cut
-
-__PACKAGE__->load_components("InflateColumn::DateTime");
-
-=head1 TABLE: C<dbix_class_deploymenthandler_versions>
-
-=cut
-
-__PACKAGE__->table("dbix_class_deploymenthandler_versions");
-
-=head1 ACCESSORS
-
-=head2 id
-
-  data_type: 'integer'
-  is_auto_increment: 1
-  is_nullable: 0
-  sequence: 'dbix_class_deploymenthandler_versions_id_seq'
-
-=head2 version
-
-  data_type: 'varchar'
-  is_nullable: 0
-  size: 50
-
-=head2 ddl
-
-  data_type: 'text'
-  is_nullable: 1
-
-=head2 upgrade_sql
-
-  data_type: 'text'
-  is_nullable: 1
-
-=cut
-
-__PACKAGE__->add_columns(
-  "id",
-  {
-    data_type         => "integer",
-    is_auto_increment => 1,
-    is_nullable       => 0,
-    sequence          => "dbix_class_deploymenthandler_versions_id_seq",
-  },
-  "version",
-  { data_type => "varchar", is_nullable => 0, size => 50 },
-  "ddl",
-  { data_type => "text", is_nullable => 1 },
-  "upgrade_sql",
-  { data_type => "text", is_nullable => 1 },
-);
-
-=head1 PRIMARY KEY
-
-=over 4
-
-=item * L</id>
-
-=back
-
-=cut
-
-__PACKAGE__->set_primary_key("id");
-
-=head1 UNIQUE CONSTRAINTS
-
-=head2 C<dbix_class_deploymenthandler_versions_version>
-
-=over 4
-
-=item * L</version>
-
-=back
-
-=cut
-
-__PACKAGE__->add_unique_constraint("dbix_class_deploymenthandler_versions_version", ["version"]);
-
-
-# Created by DBIx::Class::Schema::Loader v0.07036 @ 2013-11-06 21:19:42
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d62Bah1PHAy1ZMhIt2HeIA
-
-
-# You can replace this text with custom code or comments, and it will be preserved on regeneration
-1;

diff --git a/sql/PostgreSQL/deploy/1/001-auto-__VERSION.sql b/sql/PostgreSQL/deploy/1/001-auto-__VERSION.sql
index d278f68211107298192c1ed4d9c5b97557913050..ba0884eb8c063f725c7059635fbb73854c235af2 100644 (file)
--- a/sql/PostgreSQL/deploy/1/001-auto-__VERSION.sql
+++ b/sql/PostgreSQL/deploy/1/001-auto-__VERSION.sql
@@ -1,6 +1,6 @@
 -- 
 -- Created by SQL::Translator::Producer::PostgreSQL
--- Created on Wed Aug  6 09:18:36 2014
+-- Created on Wed Aug  6 14:09:26 2014
 -- 
 ;
 --

diff --git a/sql/PostgreSQL/deploy/1/001-auto.sql b/sql/PostgreSQL/deploy/1/001-auto.sql
index 283b43fb2eeb9c38f11ad07089ff27299417e65e..0de4b8bf1b8013b1972730246d2c6345a9bfe105 100644 (file)
--- a/sql/PostgreSQL/deploy/1/001-auto.sql
+++ b/sql/PostgreSQL/deploy/1/001-auto.sql
@@ -1,6 +1,6 @@
 -- 
 -- Created by SQL::Translator::Producer::PostgreSQL
--- Created on Wed Aug  6 09:18:36 2014
+-- Created on Wed Aug  6 14:09:26 2014
 -- 
 ;
 --
@@ -71,19 +71,6 @@ CREATE TABLE "correspondent" (
   CONSTRAINT "correspondent_addr_idx" UNIQUE ("addr")
 );
 
-;
---
--- Table: dbix_class_deploymenthandler_versions.
---
-CREATE TABLE "dbix_class_deploymenthandler_versions" (
-  "id" serial NOT NULL,
-  "version" character varying(50) NOT NULL,
-  "ddl" text,
-  "upgrade_sql" text,
-  PRIMARY KEY ("id"),
-  CONSTRAINT "dbix_class_deploymenthandler_versions_version" UNIQUE ("version")
-);
-
 ;
 --
 -- Table: message.

diff --git a/sql/_source/deploy/1/001-auto.yml b/sql/_source/deploy/1/001-auto.yml
index 727ee14f16036d54934339565b60cb964ae6ac25..b130817fc697a45eb2b7a1846a5f42bd463c2766 100644 (file)
--- a/sql/_source/deploy/1/001-auto.yml
+++ b/sql/_source/deploy/1/001-auto.yml
@@ -161,7 +161,7 @@ schema:
           type: NORMAL
       name: bin_associations
       options: []
-      order: 30
+      order: 29
     bin_pkg:
       constraints:
         - deferrable: 1
@@ -337,7 +337,7 @@ schema:
           type: NORMAL
       name: bin_ver
       options: []
-      order: 28
+      order: 27
     binary_versions:
       constraints: []
       fields:
@@ -689,7 +689,7 @@ schema:
           type: NORMAL
       name: bug
       options: []
-      order: 17
+      order: 16
     bug_binpackage:
       constraints:
         - deferrable: 1
@@ -788,7 +788,7 @@ schema:
           type: NORMAL
       name: bug_binpackage
       options: []
-      order: 22
+      order: 21
     bug_blocks:
       constraints:
         - deferrable: 1
@@ -887,7 +887,7 @@ schema:
           type: NORMAL
       name: bug_blocks
       options: []
-      order: 19
+      order: 18
     bug_merged:
       constraints:
         - deferrable: 1
@@ -986,7 +986,7 @@ schema:
           type: NORMAL
       name: bug_merged
       options: []
-      order: 20
+      order: 19
     bug_message:
       constraints:
         - deferrable: 1
@@ -1115,7 +1115,7 @@ schema:
           type: NORMAL
       name: bug_message
       options: []
-      order: 23
+      order: 22
     bug_package:
       constraints: []
       fields:
@@ -1261,7 +1261,7 @@ schema:
           type: NORMAL
       name: bug_srcpackage
       options: []
-      order: 24
+      order: 23
     bug_status_cache:
       constraints:
         - deferrable: 1
@@ -1430,7 +1430,7 @@ schema:
           type: NORMAL
       name: bug_status_cache
       options: []
-      order: 26
+      order: 25
     bug_tag:
       constraints:
         - deferrable: 1
@@ -1529,7 +1529,7 @@ schema:
           type: NORMAL
       name: bug_tag
       options: []
-      order: 25
+      order: 24
     bug_ver:
       constraints:
         - deferrable: 1
@@ -1700,7 +1700,7 @@ schema:
           type: NORMAL
       name: bug_ver
       options: []
-      order: 29
+      order: 28
     column_comments:
       constraints:
         - deferrable: 1
@@ -1894,79 +1894,7 @@ schema:
           type: NORMAL
       name: correspondent_full_name
       options: []
-      order: 14
-    dbix_class_deploymenthandler_versions:
-      constraints:
-        - deferrable: 1
-          expression: ''
-          fields:
-            - id
-          match_type: ''
-          name: ''
-          on_delete: ''
-          on_update: ''
-          options: []
-          reference_fields: []
-          reference_table: ''
-          type: PRIMARY KEY
-        - deferrable: 1
-          expression: ''
-          fields:
-            - version
-          match_type: ''
-          name: dbix_class_deploymenthandler_versions_version
-          on_delete: ''
-          on_update: ''
-          options: []
-          reference_fields: []
-          reference_table: ''
-          type: UNIQUE
-      fields:
-        ddl:
-          data_type: text
-          default_value: ~
-          is_nullable: 1
-          is_primary_key: 0
-          is_unique: 0
-          name: ddl
-          order: 3
-          size:
-            - 0
-        id:
-          data_type: integer
-          default_value: ~
-          is_auto_increment: 1
-          is_nullable: 0
-          is_primary_key: 1
-          is_unique: 0
-          name: id
-          order: 1
-          size:
-            - 0
-        upgrade_sql:
-          data_type: text
-          default_value: ~
-          is_nullable: 1
-          is_primary_key: 0
-          is_unique: 0
-          name: upgrade_sql
-          order: 4
-          size:
-            - 0
-        version:
-          data_type: varchar
-          default_value: ~
-          is_nullable: 0
-          is_primary_key: 0
-          is_unique: 1
-          name: version
-          order: 2
-          size:
-            - 50
-      indices: []
-      name: dbix_class_deploymenthandler_versions
-      options: []
-      order: 7
+      order: 13
     maintainer:
       constraints:
         - deferrable: 1
@@ -2068,7 +1996,7 @@ schema:
           type: NORMAL
       name: maintainer
       options: []
-      order: 15
+      order: 14
     message:
       constraints:
         - deferrable: 1
@@ -2199,7 +2127,7 @@ schema:
       indices: []
       name: message
       options: []
-      order: 8
+      order: 7
     message_correspondent:
       constraints:
         - deferrable: 1
@@ -2316,7 +2244,7 @@ schema:
           type: NORMAL
       name: message_correspondent
       options: []
-      order: 18
+      order: 17
     message_refs:
       constraints:
         - deferrable: 1
@@ -2437,7 +2365,7 @@ schema:
           type: NORMAL
       name: message_refs
       options: []
-      order: 16
+      order: 15
     severity:
       constraints:
         - deferrable: 1
@@ -2521,7 +2449,7 @@ schema:
       indices: []
       name: severity
       options: []
-      order: 9
+      order: 8
     src_associations:
       constraints:
         - deferrable: 1
@@ -2629,7 +2557,7 @@ schema:
           type: NORMAL
       name: src_associations
       options: []
-      order: 27
+      order: 26
     src_pkg:
       constraints:
         - deferrable: 1
@@ -2764,7 +2692,7 @@ schema:
           type: NORMAL
       name: src_pkg
       options: []
-      order: 10
+      order: 9
     src_ver:
       constraints:
         - deferrable: 1
@@ -2912,7 +2840,7 @@ schema:
           type: NORMAL
       name: src_ver
       options: []
-      order: 21
+      order: 20
     suite:
       constraints:
         - deferrable: 1
@@ -2995,7 +2923,7 @@ schema:
       indices: []
       name: suite
       options: []
-      order: 11
+      order: 10
     table_comments:
       constraints:
         - deferrable: 1
@@ -3034,7 +2962,7 @@ schema:
       indices: []
       name: table_comments
       options: []
-      order: 12
+      order: 11
     tag:
       constraints:
         - deferrable: 1
@@ -3097,7 +3025,7 @@ schema:
       indices: []
       name: tag
       options: []
-      order: 13
+      order: 12
   triggers: {}
   views: {}
 translator:
@@ -3124,7 +3052,6 @@ translator:
       - ColumnComment
       - Correspondent
       - CorrespondentFullName
-      - DbixClassDeploymenthandlerVersion
       - Maintainer
       - Message
       - MessageCorrespondent