From 29bf6a61f8b31f4e192dfe66584b0eef54697b10 Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Wed, 6 Aug 2014 14:13:21 -0700 Subject: [PATCH] we should not include DBIx::ClassDeploymentHandlerVersion as a table in its own right --- .../DbixClassDeploymenthandlerVersion.pm | 111 ---------------- .../deploy/1/001-auto-__VERSION.sql | 2 +- sql/PostgreSQL/deploy/1/001-auto.sql | 15 +-- sql/_source/deploy/1/001-auto.yml | 119 ++++-------------- 4 files changed, 25 insertions(+), 222 deletions(-) delete mode 100644 Debbugs/DB/Result/DbixClassDeploymenthandlerVersion.pm diff --git a/Debbugs/DB/Result/DbixClassDeploymenthandlerVersion.pm b/Debbugs/DB/Result/DbixClassDeploymenthandlerVersion.pm deleted file mode 100644 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 - -=back - -=cut - -__PACKAGE__->load_components("InflateColumn::DateTime"); - -=head1 TABLE: C - -=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 - -=back - -=cut - -__PACKAGE__->set_primary_key("id"); - -=head1 UNIQUE CONSTRAINTS - -=head2 C - -=over 4 - -=item * L - -=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 d278f68..ba0884e 100644 --- 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 283b43f..0de4b8b 100644 --- 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 727ee14..b130817 100644 --- 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 -- 2.39.2