You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafficcontrol.apache.org by da...@apache.org on 2016/11/15 16:45:31 UTC
[1/3] incubator-trafficcontrol git commit: runs reverse_schema after
mysql to psql data migration and column type fixes
Repository: incubator-trafficcontrol
Updated Branches:
refs/heads/psql-rebase 4895aeb12 -> 95e2703a8
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Regex.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Regex.pm b/traffic_ops/app/lib/Schema/Result/Regex.pm
index 3d91eab..8d3f886 100644
--- a/traffic_ops/app/lib/Schema/Result/Regex.pm
+++ b/traffic_ops/app/lib/Schema/Result/Regex.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("regex");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'regex_id_seq'
=head2 pattern
@@ -38,32 +39,37 @@ __PACKAGE__->table("regex");
=head2 type
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "regex_id_seq",
+ },
"pattern",
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
"type",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -83,7 +89,7 @@ __PACKAGE__->set_primary_key("id", "type");
=head1 UNIQUE CONSTRAINTS
-=head2 C<re_id_UNIQUE>
+=head2 C<idx_39734_re_id_unique>
=over 4
@@ -93,7 +99,7 @@ __PACKAGE__->set_primary_key("id", "type");
=cut
-__PACKAGE__->add_unique_constraint("re_id_UNIQUE", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_39734_re_id_unique", ["id"]);
=head1 RELATIONS
@@ -124,12 +130,12 @@ __PACKAGE__->belongs_to(
"type",
"Schema::Result::Type",
{ id => "type" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xCUxEKNSlL9G3qGq0MJDwA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:USUCydmnMZ6Tr0gm/jpVPg
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Region.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Region.pm b/traffic_ops/app/lib/Schema/Result/Region.pm
index 03626a4..391f7c1 100644
--- a/traffic_ops/app/lib/Schema/Result/Region.pm
+++ b/traffic_ops/app/lib/Schema/Result/Region.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("region");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'region_id_seq'
=head2 name
@@ -37,32 +38,37 @@ __PACKAGE__->table("region");
=head2 division
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "region_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"division",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -80,7 +86,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<name_UNIQUE>
+=head2 C<idx_39742_name_unique>
=over 4
@@ -90,7 +96,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("name_UNIQUE", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_39742_name_unique", ["name"]);
=head1 RELATIONS
@@ -106,7 +112,7 @@ __PACKAGE__->belongs_to(
"division",
"Schema::Result::Division",
{ id => "division" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
=head2 phys_locations
@@ -125,8 +131,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NvsRmrkhGooZnljic2zfBA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rWahmAZ6JkPd8ankOZ+/5w
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Role.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Role.pm b/traffic_ops/app/lib/Schema/Result/Role.pm
index 399053b..7e9a7ea 100644
--- a/traffic_ops/app/lib/Schema/Result/Role.pm
+++ b/traffic_ops/app/lib/Schema/Result/Role.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("role");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'role_id_seq'
=head2 name
@@ -43,20 +44,25 @@ __PACKAGE__->table("role");
=head2 priv_level
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 0
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "role_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"description",
{ data_type => "varchar", is_nullable => 1, size => 128 },
"priv_level",
- { data_type => "integer", is_nullable => 0 },
+ { data_type => "bigint", is_nullable => 0 },
);
=head1 PRIMARY KEY
@@ -104,8 +110,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-06-03 08:58:13
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eNrksFOoJ9HkhtHhBjrWpA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SCCjQ7mhGlXAj5JhPtqbnA
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Server.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Server.pm b/traffic_ops/app/lib/Schema/Result/Server.pm
index 5887ca4..baaf7e8 100644
--- a/traffic_ops/app/lib/Schema/Result/Server.pm
+++ b/traffic_ops/app/lib/Schema/Result/Server.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("server");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'server_id_seq'
=head2 host_name
@@ -43,8 +44,7 @@ __PACKAGE__->table("server");
=head2 tcp_port
- data_type: 'integer'
- extra: {unsigned => 1}
+ data_type: 'bigint'
is_nullable: 1
=head2 xmpp_id
@@ -97,13 +97,13 @@ __PACKAGE__->table("server");
=head2 interface_mtu
- data_type: 'integer'
+ data_type: 'bigint'
default_value: 9000
is_nullable: 0
=head2 phys_location
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
@@ -115,45 +115,44 @@ __PACKAGE__->table("server");
=head2 cachegroup
- data_type: 'integer'
+ data_type: 'bigint'
default_value: 0
is_foreign_key: 1
is_nullable: 0
=head2 type
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 status
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 offline_reason
data_type: 'varchar'
- default_value: 'N/A'
- is_nullable: 0
+ is_nullable: 1
size: 256
=head2 upd_pending
- data_type: 'tinyint'
- default_value: 0
+ data_type: 'boolean'
+ default_value: false
is_nullable: 0
=head2 profile
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 cdn_id
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
@@ -225,27 +224,32 @@ __PACKAGE__->table("server");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=head2 https_port
- data_type: 'smallint'
+ data_type: 'bigint'
is_nullable: 1
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "server_id_seq",
+ },
"host_name",
{ data_type => "varchar", is_nullable => 0, size => 63 },
"domain_name",
{ data_type => "varchar", is_nullable => 0, size => 63 },
"tcp_port",
- { data_type => "integer", extra => { unsigned => 1 }, is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"xmpp_id",
{ data_type => "varchar", is_nullable => 1, size => 256 },
"xmpp_passwd",
@@ -263,35 +267,30 @@ __PACKAGE__->add_columns(
"ip6_gateway",
{ data_type => "varchar", is_nullable => 1, size => 50 },
"interface_mtu",
- { data_type => "integer", default_value => 9000, is_nullable => 0 },
+ { data_type => "bigint", default_value => 9000, is_nullable => 0 },
"phys_location",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"rack",
{ data_type => "varchar", is_nullable => 1, size => 64 },
"cachegroup",
{
- data_type => "integer",
+ data_type => "bigint",
default_value => 0,
is_foreign_key => 1,
is_nullable => 0,
},
"type",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"status",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"offline_reason",
- {
- data_type => "varchar",
- default_value => "N/A",
- is_nullable => 0,
- size => 256,
- },
+ { data_type => "varchar", is_nullable => 1, size => 256 },
"upd_pending",
- { data_type => "tinyint", default_value => 0, is_nullable => 0 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 0 },
"profile",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"cdn_id",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"mgmt_ip_address",
{ data_type => "varchar", is_nullable => 1, size => 45 },
"mgmt_ip_netmask",
@@ -316,13 +315,13 @@ __PACKAGE__->add_columns(
{ data_type => "varchar", is_nullable => 1, size => 45 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
"https_port",
- { data_type => "smallint", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
);
=head1 PRIMARY KEY
@@ -347,7 +346,7 @@ __PACKAGE__->set_primary_key("id", "cachegroup", "type", "status", "profile");
=head1 UNIQUE CONSTRAINTS
-=head2 C<ip6_profile>
+=head2 C<idx_39755_ip6_profile>
=over 4
@@ -359,9 +358,9 @@ __PACKAGE__->set_primary_key("id", "cachegroup", "type", "status", "profile");
=cut
-__PACKAGE__->add_unique_constraint("ip6_profile", ["ip6_address", "profile"]);
+__PACKAGE__->add_unique_constraint("idx_39755_ip6_profile", ["ip6_address", "profile"]);
-=head2 C<ip_profile>
+=head2 C<idx_39755_ip_profile>
=over 4
@@ -373,9 +372,9 @@ __PACKAGE__->add_unique_constraint("ip6_profile", ["ip6_address", "profile"]);
=cut
-__PACKAGE__->add_unique_constraint("ip_profile", ["ip_address", "profile"]);
+__PACKAGE__->add_unique_constraint("idx_39755_ip_profile", ["ip_address", "profile"]);
-=head2 C<se_id_UNIQUE>
+=head2 C<idx_39755_se_id_unique>
=over 4
@@ -385,7 +384,7 @@ __PACKAGE__->add_unique_constraint("ip_profile", ["ip_address", "profile"]);
=cut
-__PACKAGE__->add_unique_constraint("se_id_UNIQUE", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_39755_se_id_unique", ["id"]);
=head1 RELATIONS
@@ -401,7 +400,7 @@ __PACKAGE__->belongs_to(
"cachegroup",
"Schema::Result::Cachegroup",
{ id => "cachegroup" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "RESTRICT" },
);
=head2 cdn
@@ -416,7 +415,7 @@ __PACKAGE__->belongs_to(
"cdn",
"Schema::Result::Cdn",
{ id => "cdn_id" },
- { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
+ { is_deferrable => 0, on_delete => "RESTRICT", on_update => "RESTRICT" },
);
=head2 deliveryservice_servers
@@ -461,7 +460,7 @@ __PACKAGE__->belongs_to(
"phys_location",
"Schema::Result::PhysLocation",
{ id => "phys_location" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
=head2 profile
@@ -476,7 +475,7 @@ __PACKAGE__->belongs_to(
"profile",
"Schema::Result::Profile",
{ id => "profile" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
=head2 servercheck
@@ -506,7 +505,7 @@ __PACKAGE__->belongs_to(
"status",
"Schema::Result::Status",
{ id => "status" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
=head2 type
@@ -521,12 +520,12 @@ __PACKAGE__->belongs_to(
"type",
"Schema::Result::Type",
{ id => "type" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-09-08 16:03:46
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I3HqV6I4I5taXrqaaNTESw
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bW9kYn0q4JnPYnYWFZ8FkA
# These lines were loaded from '/Users/drichard/projects/github.com/traffic_control/traffic_ops/app/lib/Schema/Result/Server.pm' found in @INC.
# They are now part of the custom portion of this file
# for you to hand-edit. If you do not either delete
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Servercheck.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Servercheck.pm b/traffic_ops/app/lib/Schema/Result/Servercheck.pm
index 4b828d3..9dd11a3 100644
--- a/traffic_ops/app/lib/Schema/Result/Servercheck.pm
+++ b/traffic_ops/app/lib/Schema/Result/Servercheck.pm
@@ -25,253 +25,259 @@ __PACKAGE__->table("servercheck");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'servercheck_id_seq'
=head2 server
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 aa
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ab
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ac
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ad
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ae
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 af
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ag
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ah
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ai
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 aj
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ak
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 al
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 am
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 an
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ao
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ap
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 aq
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ar
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 bf
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 at
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 au
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 av
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 aw
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ax
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ay
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 az
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 ba
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 bb
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 bc
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 bd
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 be
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "servercheck_id_seq",
+ },
"server",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"aa",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ab",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ac",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ad",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ae",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"af",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ag",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ah",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ai",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"aj",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ak",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"al",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"am",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"an",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ao",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ap",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"aq",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ar",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"bf",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"at",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"au",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"av",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"aw",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ax",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ay",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"az",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"ba",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"bb",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"bc",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"bd",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"be",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -291,7 +297,7 @@ __PACKAGE__->set_primary_key("id", "server");
=head1 UNIQUE CONSTRAINTS
-=head2 C<server>
+=head2 C<idx_39768_server>
=over 4
@@ -301,9 +307,9 @@ __PACKAGE__->set_primary_key("id", "server");
=cut
-__PACKAGE__->add_unique_constraint("server", ["server"]);
+__PACKAGE__->add_unique_constraint("idx_39768_server", ["server"]);
-=head2 C<ses_id_UNIQUE>
+=head2 C<idx_39768_ses_id_unique>
=over 4
@@ -313,7 +319,7 @@ __PACKAGE__->add_unique_constraint("server", ["server"]);
=cut
-__PACKAGE__->add_unique_constraint("ses_id_UNIQUE", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_39768_ses_id_unique", ["id"]);
=head1 RELATIONS
@@ -329,12 +335,12 @@ __PACKAGE__->belongs_to(
"server",
"Schema::Result::Server",
{ id => "server" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2016-08-09 09:23:54
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:usz1Un1hWx1h6ISbWLHixA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4g66dJwicKC8YDAnG0zZKQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Staticdnsentry.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Staticdnsentry.pm b/traffic_ops/app/lib/Schema/Result/Staticdnsentry.pm
index ceff320..758f565 100644
--- a/traffic_ops/app/lib/Schema/Result/Staticdnsentry.pm
+++ b/traffic_ops/app/lib/Schema/Result/Staticdnsentry.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("staticdnsentry");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'staticdnsentry_id_seq'
=head2 host
@@ -43,58 +44,63 @@ __PACKAGE__->table("staticdnsentry");
=head2 type
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 ttl
- data_type: 'integer'
+ data_type: 'bigint'
default_value: 3600
is_nullable: 0
=head2 deliveryservice
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 cachegroup
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 1
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "staticdnsentry_id_seq",
+ },
"host",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"address",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"type",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"ttl",
- { data_type => "integer", default_value => 3600, is_nullable => 0 },
+ { data_type => "bigint", default_value => 3600, is_nullable => 0 },
"deliveryservice",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"cachegroup",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -112,7 +118,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<combi_UNIQUE>
+=head2 C<idx_39775_combi_unique>
=over 4
@@ -129,7 +135,7 @@ __PACKAGE__->set_primary_key("id");
=cut
__PACKAGE__->add_unique_constraint(
- "combi_UNIQUE",
+ "idx_39775_combi_unique",
["host", "address", "deliveryservice", "cachegroup"],
);
@@ -148,7 +154,7 @@ __PACKAGE__->belongs_to(
"Schema::Result::Cachegroup",
{ id => "cachegroup" },
{
- is_deferrable => 1,
+ is_deferrable => 0,
join_type => "LEFT",
on_delete => "NO ACTION",
on_update => "NO ACTION",
@@ -167,7 +173,7 @@ __PACKAGE__->belongs_to(
"deliveryservice",
"Schema::Result::Deliveryservice",
{ id => "deliveryservice" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
=head2 type
@@ -182,12 +188,12 @@ __PACKAGE__->belongs_to(
"type",
"Schema::Result::Type",
{ id => "type" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YbVC0IfHXOcFfTeIDtGQpg
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d8VZCR5XOk2TlAmgByHkUQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/StatsSummary.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/StatsSummary.pm b/traffic_ops/app/lib/Schema/Result/StatsSummary.pm
index f2a0610..d33dd14 100644
--- a/traffic_ops/app/lib/Schema/Result/StatsSummary.pm
+++ b/traffic_ops/app/lib/Schema/Result/StatsSummary.pm
@@ -1,24 +1,6 @@
use utf8;
package Schema::Result::StatsSummary;
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-
-
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
@@ -43,9 +25,10 @@ __PACKAGE__->table("stats_summary");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'stats_summary_id_seq'
=head2 cdn_name
@@ -68,27 +51,31 @@ __PACKAGE__->table("stats_summary");
=head2 stat_value
- data_type: 'float'
+ data_type: 'double precision'
is_nullable: 0
=head2 summary_time
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 0
+ original: {default_value => \"now()"}
=head2 stat_date
data_type: 'date'
- datetime_undef_if_invalid: 1
is_nullable: 1
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "stats_summary_id_seq",
+ },
"cdn_name",
{
data_type => "varchar",
@@ -101,16 +88,16 @@ __PACKAGE__->add_columns(
"stat_name",
{ data_type => "varchar", is_nullable => 0, size => 255 },
"stat_value",
- { data_type => "float", is_nullable => 0 },
+ { data_type => "double precision", is_nullable => 0 },
"summary_time",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 0,
+ is_nullable => 0,
+ original => { default_value => \"now()" },
},
"stat_date",
- { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
+ { data_type => "date", is_nullable => 1 },
);
=head1 PRIMARY KEY
@@ -126,8 +113,8 @@ __PACKAGE__->add_columns(
__PACKAGE__->set_primary_key("id");
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-07-21 15:49:32
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LymxjQoZIaTrV1NC2uSgzA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+WiXimw9L6Qs/RIkuW4g5A
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Status.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Status.pm b/traffic_ops/app/lib/Schema/Result/Status.pm
index d605cad..f5532be 100644
--- a/traffic_ops/app/lib/Schema/Result/Status.pm
+++ b/traffic_ops/app/lib/Schema/Result/Status.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("status");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'status_id_seq'
=head2 name
@@ -43,26 +44,31 @@ __PACKAGE__->table("status");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "status_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"description",
{ data_type => "varchar", is_nullable => 1, size => 256 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -96,8 +102,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JHjZ124+SMUm6GcK45GdrQ
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WCYrI1lmooF+2+9TltjiuQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/SteeringTarget.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/SteeringTarget.pm b/traffic_ops/app/lib/Schema/Result/SteeringTarget.pm
index 6ec2879..a53f6cf 100644
--- a/traffic_ops/app/lib/Schema/Result/SteeringTarget.pm
+++ b/traffic_ops/app/lib/Schema/Result/SteeringTarget.pm
@@ -1,24 +1,6 @@
use utf8;
package Schema::Result::SteeringTarget;
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-
-
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
@@ -43,42 +25,42 @@ __PACKAGE__->table("steering_target");
=head2 deliveryservice
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 target
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 0
=head2 weight
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"deliveryservice",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"target",
- { data_type => "integer", is_nullable => 0 },
+ { data_type => "bigint", is_nullable => 0 },
"weight",
- { data_type => "integer", is_nullable => 0 },
+ { data_type => "bigint", is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -110,7 +92,7 @@ __PACKAGE__->belongs_to(
"deliveryservice",
"Schema::Result::Deliveryservice",
{ id => "deliveryservice" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 deliveryservice_2
@@ -125,12 +107,12 @@ __PACKAGE__->belongs_to(
"deliveryservice_2",
"Schema::Result::Deliveryservice",
{ id => "deliveryservice" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2016-05-16 14:09:12
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ChvC5DawEYbAVExudvT49g
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gZIXjQohI79d92yjQT6sxg
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/TmUser.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/TmUser.pm b/traffic_ops/app/lib/Schema/Result/TmUser.pm
index 9aae587..e13de2b 100644
--- a/traffic_ops/app/lib/Schema/Result/TmUser.pm
+++ b/traffic_ops/app/lib/Schema/Result/TmUser.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("tm_user");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'tm_user_id_seq'
=head2 username
@@ -43,18 +44,18 @@ __PACKAGE__->table("tm_user");
=head2 role
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 1
=head2 uid
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 gid
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 local_passwd
@@ -71,10 +72,10 @@ __PACKAGE__->table("tm_user");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=head2 company
@@ -96,8 +97,8 @@ __PACKAGE__->table("tm_user");
=head2 new_user
- data_type: 'tinyint'
- default_value: 1
+ data_type: 'boolean'
+ default_value: false
is_nullable: 0
=head2 address_line1
@@ -150,36 +151,39 @@ __PACKAGE__->table("tm_user");
=head2 registration_sent
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
- default_value: '0000-00-00 00:00:00'
- is_nullable: 0
+ data_type: 'timestamp with time zone'
+ is_nullable: 1
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "tm_user_id_seq",
+ },
"username",
{ data_type => "varchar", is_nullable => 1, size => 128 },
"public_ssh_key",
{ data_type => "varchar", is_nullable => 1, size => 2048 },
"role",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
"uid",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"gid",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"local_passwd",
{ data_type => "varchar", is_nullable => 1, size => 40 },
"confirm_local_passwd",
{ data_type => "varchar", is_nullable => 1, size => 40 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
"company",
{ data_type => "varchar", is_nullable => 1, size => 256 },
@@ -188,7 +192,7 @@ __PACKAGE__->add_columns(
"full_name",
{ data_type => "varchar", is_nullable => 1, size => 256 },
"new_user",
- { data_type => "tinyint", default_value => 1, is_nullable => 0 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 0 },
"address_line1",
{ data_type => "varchar", is_nullable => 1, size => 256 },
"address_line2",
@@ -206,12 +210,7 @@ __PACKAGE__->add_columns(
"token",
{ data_type => "varchar", is_nullable => 1, size => 50 },
"registration_sent",
- {
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
- default_value => "0000-00-00 00:00:00",
- is_nullable => 0,
- },
+ { data_type => "timestamp with time zone", is_nullable => 1 },
);
=head1 PRIMARY KEY
@@ -228,7 +227,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<tmuser_email_UNIQUE>
+=head2 C<idx_39805_tmuser_email_unique>
=over 4
@@ -238,9 +237,9 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("tmuser_email_UNIQUE", ["email"]);
+__PACKAGE__->add_unique_constraint("idx_39805_tmuser_email_unique", ["email"]);
-=head2 C<username_UNIQUE>
+=head2 C<idx_39805_username_unique>
=over 4
@@ -250,7 +249,7 @@ __PACKAGE__->add_unique_constraint("tmuser_email_UNIQUE", ["email"]);
=cut
-__PACKAGE__->add_unique_constraint("username_UNIQUE", ["username"]);
+__PACKAGE__->add_unique_constraint("idx_39805_username_unique", ["username"]);
=head1 RELATIONS
@@ -327,7 +326,7 @@ __PACKAGE__->belongs_to(
"Schema::Result::Role",
{ id => "role" },
{
- is_deferrable => 1,
+ is_deferrable => 0,
join_type => "LEFT",
on_delete => "SET NULL",
on_update => "NO ACTION",
@@ -335,8 +334,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-06-03 08:58:13
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5ScNDf57+7Av94KOEM/1dw
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rWwMHJlmbMYgX/L4y51AWA
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/ToExtension.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/ToExtension.pm b/traffic_ops/app/lib/Schema/Result/ToExtension.pm
index 298ee15..45514ea 100644
--- a/traffic_ops/app/lib/Schema/Result/ToExtension.pm
+++ b/traffic_ops/app/lib/Schema/Result/ToExtension.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("to_extension");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'to_extension_id_seq'
=head2 name
@@ -55,7 +56,8 @@ __PACKAGE__->table("to_extension");
=head2 isactive
- data_type: 'tinyint'
+ data_type: 'boolean'
+ default_value: false
is_nullable: 0
=head2 additional_config_json
@@ -84,22 +86,27 @@ __PACKAGE__->table("to_extension");
=head2 type
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 0
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "to_extension_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"version",
@@ -109,7 +116,7 @@ __PACKAGE__->add_columns(
"script_file",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"isactive",
- { data_type => "tinyint", is_nullable => 0 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 0 },
"additional_config_json",
{ data_type => "varchar", is_nullable => 1, size => 4096 },
"description",
@@ -119,13 +126,13 @@ __PACKAGE__->add_columns(
"servercheck_column_name",
{ data_type => "varchar", is_nullable => 1, size => 10 },
"type",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 0,
+ is_nullable => 0,
+ original => { default_value => \"now()" },
},
);
@@ -155,12 +162,12 @@ __PACKAGE__->belongs_to(
"type",
"Schema::Result::Type",
{ id => "type" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/YZDsslpM0Bp0vcpV6WEMw
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:au23HlVhC3y3hHGJ4cOUvQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Type.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Type.pm b/traffic_ops/app/lib/Schema/Result/Type.pm
index 1d89e4f..70a7973 100644
--- a/traffic_ops/app/lib/Schema/Result/Type.pm
+++ b/traffic_ops/app/lib/Schema/Result/Type.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("type");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'type_id_seq'
=head2 name
@@ -49,16 +50,21 @@ __PACKAGE__->table("type");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "type_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"description",
@@ -67,10 +73,10 @@ __PACKAGE__->add_columns(
{ data_type => "varchar", is_nullable => 1, size => 45 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -88,7 +94,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<NAME_UNIQUE>
+=head2 C<idx_39826_name_unique>
=over 4
@@ -98,7 +104,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("NAME_UNIQUE", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_39826_name_unique", ["name"]);
=head1 RELATIONS
@@ -208,8 +214,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-09-28 14:50:43
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:h5Bl3BAfcoDtSF94ETyFbw
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6/jizJUQmkHwt9g7bIOZRA
# You can replace this text with custom code or comments, and it will be preserved on regeneration
[3/3] incubator-trafficcontrol git commit: This closes #83
Posted by da...@apache.org.
This closes #83
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/95e2703a
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/95e2703a
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/95e2703a
Branch: refs/heads/psql-rebase
Commit: 95e2703a862f33a34359c921f4669c7718a96d7a
Parents: 610a17d
Author: Dan Kirkwood <da...@gmail.com>
Authored: Tue Nov 15 09:45:21 2016 -0700
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Tue Nov 15 09:45:21 2016 -0700
----------------------------------------------------------------------
----------------------------------------------------------------------
[2/3] incubator-trafficcontrol git commit: runs reverse_schema after
mysql to psql data migration and column type fixes
Posted by da...@apache.org.
runs reverse_schema after mysql to psql data migration and column type fixes
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/610a17d1
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/610a17d1
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/610a17d1
Branch: refs/heads/psql-rebase
Commit: 610a17d1a09dcd2764ed5b28ea4a6fd755f354b5
Parents: 4895aeb
Author: Jeremy Mitchell <mi...@gmail.com>
Authored: Tue Nov 15 09:37:00 2016 -0700
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Tue Nov 15 09:44:54 2016 -0700
----------------------------------------------------------------------
traffic_ops/app/lib/Schema/Result/Asn.pm | 38 ++--
traffic_ops/app/lib/Schema/Result/Cachegroup.pm | 62 ++++---
.../lib/Schema/Result/CachegroupParameter.pm | 26 +--
traffic_ops/app/lib/Schema/Result/Cdn.pm | 36 ++--
.../app/lib/Schema/Result/Deliveryservice.pm | 174 +++++++++----------
.../lib/Schema/Result/DeliveryserviceRegex.pm | 20 +--
.../lib/Schema/Result/DeliveryserviceServer.pm | 26 +--
.../lib/Schema/Result/DeliveryserviceTmuser.pm | 26 +--
traffic_ops/app/lib/Schema/Result/Division.pm | 28 +--
traffic_ops/app/lib/Schema/Result/Federation.pm | 42 ++---
.../Schema/Result/FederationDeliveryservice.pm | 44 ++---
.../Result/FederationFederationResolver.pm | 44 ++---
.../app/lib/Schema/Result/FederationResolver.pm | 52 +++---
.../app/lib/Schema/Result/FederationTmuser.pm | 50 ++----
.../app/lib/Schema/Result/GooseDbVersion.pm | 31 ++--
traffic_ops/app/lib/Schema/Result/Hwinfo.pm | 34 ++--
traffic_ops/app/lib/Schema/Result/Job.pm | 66 ++++---
traffic_ops/app/lib/Schema/Result/JobAgent.pm | 24 ++-
traffic_ops/app/lib/Schema/Result/JobResult.pm | 36 ++--
traffic_ops/app/lib/Schema/Result/JobStatus.pm | 24 ++-
traffic_ops/app/lib/Schema/Result/Log.pm | 30 ++--
traffic_ops/app/lib/Schema/Result/Parameter.pm | 34 ++--
.../app/lib/Schema/Result/PhysLocation.pm | 38 ++--
traffic_ops/app/lib/Schema/Result/Profile.pm | 28 +--
.../app/lib/Schema/Result/ProfileParameter.pm | 26 +--
traffic_ops/app/lib/Schema/Result/Regex.pm | 34 ++--
traffic_ops/app/lib/Schema/Result/Region.pm | 34 ++--
traffic_ops/app/lib/Schema/Result/Role.pm | 18 +-
traffic_ops/app/lib/Schema/Result/Server.pm | 101 ++++++-----
.../app/lib/Schema/Result/Servercheck.pm | 162 ++++++++---------
.../app/lib/Schema/Result/Staticdnsentry.pm | 50 +++---
.../app/lib/Schema/Result/StatsSummary.pm | 49 ++----
traffic_ops/app/lib/Schema/Result/Status.pm | 24 ++-
.../app/lib/Schema/Result/SteeringTarget.pm | 48 ++---
traffic_ops/app/lib/Schema/Result/TmUser.pm | 65 ++++---
.../app/lib/Schema/Result/ToExtension.pm | 35 ++--
traffic_ops/app/lib/Schema/Result/Type.pm | 28 +--
37 files changed, 844 insertions(+), 843 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Asn.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Asn.pm b/traffic_ops/app/lib/Schema/Result/Asn.pm
index eaf8a5c..35d1f31 100644
--- a/traffic_ops/app/lib/Schema/Result/Asn.pm
+++ b/traffic_ops/app/lib/Schema/Result/Asn.pm
@@ -25,49 +25,55 @@ __PACKAGE__->table("asn");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'asn_id_seq'
=head2 asn
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 0
=head2 cachegroup
- data_type: 'integer'
+ data_type: 'bigint'
default_value: 0
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "asn_id_seq",
+ },
"asn",
- { data_type => "integer", is_nullable => 0 },
+ { data_type => "bigint", is_nullable => 0 },
"cachegroup",
{
- data_type => "integer",
+ data_type => "bigint",
default_value => 0,
is_foreign_key => 1,
is_nullable => 0,
},
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -87,7 +93,7 @@ __PACKAGE__->set_primary_key("id", "cachegroup");
=head1 UNIQUE CONSTRAINTS
-=head2 C<cr_id_UNIQUE>
+=head2 C<idx_39541_cr_id_unique>
=over 4
@@ -97,7 +103,7 @@ __PACKAGE__->set_primary_key("id", "cachegroup");
=cut
-__PACKAGE__->add_unique_constraint("cr_id_UNIQUE", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_39541_cr_id_unique", ["id"]);
=head1 RELATIONS
@@ -113,12 +119,12 @@ __PACKAGE__->belongs_to(
"cachegroup",
"Schema::Result::Cachegroup",
{ id => "cachegroup" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WGDVL2+i4jTulNrU+p3cHg
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dFE+hx8bFq0RPzVZ0VSfhQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Cachegroup.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Cachegroup.pm b/traffic_ops/app/lib/Schema/Result/Cachegroup.pm
index 7bc7b84..ee103bd 100644
--- a/traffic_ops/app/lib/Schema/Result/Cachegroup.pm
+++ b/traffic_ops/app/lib/Schema/Result/Cachegroup.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("cachegroup");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'cachegroup_id_seq'
=head2 name
@@ -43,64 +44,69 @@ __PACKAGE__->table("cachegroup");
=head2 latitude
- data_type: 'double precision'
+ data_type: 'numeric'
is_nullable: 1
=head2 longitude
- data_type: 'double precision'
+ data_type: 'numeric'
is_nullable: 1
=head2 parent_cachegroup_id
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 1
=head2 secondary_parent_cachegroup_id
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 1
=head2 type
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "cachegroup_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"short_name",
{ data_type => "varchar", is_nullable => 0, size => 255 },
"latitude",
- { data_type => "double precision", is_nullable => 1 },
+ { data_type => "numeric", is_nullable => 1 },
"longitude",
- { data_type => "double precision", is_nullable => 1 },
+ { data_type => "numeric", is_nullable => 1 },
"parent_cachegroup_id",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
"secondary_parent_cachegroup_id",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
"type",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -120,7 +126,7 @@ __PACKAGE__->set_primary_key("id", "type");
=head1 UNIQUE CONSTRAINTS
-=head2 C<cg_name_UNIQUE>
+=head2 C<idx_39549_cg_name_unique>
=over 4
@@ -130,9 +136,9 @@ __PACKAGE__->set_primary_key("id", "type");
=cut
-__PACKAGE__->add_unique_constraint("cg_name_UNIQUE", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_39549_cg_name_unique", ["name"]);
-=head2 C<cg_short_UNIQUE>
+=head2 C<idx_39549_cg_short_unique>
=over 4
@@ -142,9 +148,9 @@ __PACKAGE__->add_unique_constraint("cg_name_UNIQUE", ["name"]);
=cut
-__PACKAGE__->add_unique_constraint("cg_short_UNIQUE", ["short_name"]);
+__PACKAGE__->add_unique_constraint("idx_39549_cg_short_unique", ["short_name"]);
-=head2 C<lo_id_UNIQUE>
+=head2 C<idx_39549_lo_id_unique>
=over 4
@@ -154,7 +160,7 @@ __PACKAGE__->add_unique_constraint("cg_short_UNIQUE", ["short_name"]);
=cut
-__PACKAGE__->add_unique_constraint("lo_id_UNIQUE", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_39549_lo_id_unique", ["id"]);
=head1 RELATIONS
@@ -231,7 +237,7 @@ __PACKAGE__->belongs_to(
"Schema::Result::Cachegroup",
{ id => "parent_cachegroup_id" },
{
- is_deferrable => 1,
+ is_deferrable => 0,
join_type => "LEFT",
on_delete => "NO ACTION",
on_update => "NO ACTION",
@@ -251,7 +257,7 @@ __PACKAGE__->belongs_to(
"Schema::Result::Cachegroup",
{ id => "secondary_parent_cachegroup_id" },
{
- is_deferrable => 1,
+ is_deferrable => 0,
join_type => "LEFT",
on_delete => "NO ACTION",
on_update => "NO ACTION",
@@ -300,12 +306,12 @@ __PACKAGE__->belongs_to(
"type",
"Schema::Result::Type",
{ id => "type" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-06-03 08:58:13
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wrtmgvbod7oMIUahcjwa/w
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LTQMxo73PQM85NrX7OWYHQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
#
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/CachegroupParameter.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/CachegroupParameter.pm b/traffic_ops/app/lib/Schema/Result/CachegroupParameter.pm
index 5380ee2..0decb10 100644
--- a/traffic_ops/app/lib/Schema/Result/CachegroupParameter.pm
+++ b/traffic_ops/app/lib/Schema/Result/CachegroupParameter.pm
@@ -25,42 +25,42 @@ __PACKAGE__->table("cachegroup_parameter");
=head2 cachegroup
- data_type: 'integer'
+ data_type: 'bigint'
default_value: 0
is_foreign_key: 1
is_nullable: 0
=head2 parameter
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"cachegroup",
{
- data_type => "integer",
+ data_type => "bigint",
default_value => 0,
is_foreign_key => 1,
is_nullable => 0,
},
"parameter",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -92,7 +92,7 @@ __PACKAGE__->belongs_to(
"cachegroup",
"Schema::Result::Cachegroup",
{ id => "cachegroup" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
);
=head2 parameter
@@ -107,12 +107,12 @@ __PACKAGE__->belongs_to(
"parameter",
"Schema::Result::Parameter",
{ id => "parameter" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BRGhe7It8jc9lvi87bvjHw
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L6VYCi7/8rY6mdQ2FJEYBQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Cdn.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Cdn.pm b/traffic_ops/app/lib/Schema/Result/Cdn.pm
index e6fd544..2c2ade1 100644
--- a/traffic_ops/app/lib/Schema/Result/Cdn.pm
+++ b/traffic_ops/app/lib/Schema/Result/Cdn.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("cdn");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'cdn_id_seq'
=head2 name
@@ -37,33 +38,38 @@ __PACKAGE__->table("cdn");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 0
+ original: {default_value => \"now()"}
=head2 dnssec_enabled
- data_type: 'tinyint'
- default_value: 0
- is_nullable: 1
+ data_type: 'boolean'
+ default_value: false
+ is_nullable: 0
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "cdn_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 1, size => 127 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 0,
+ is_nullable => 0,
+ original => { default_value => \"now()" },
},
"dnssec_enabled",
- { data_type => "tinyint", default_value => 0, is_nullable => 1 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 0 },
);
=head1 PRIMARY KEY
@@ -80,7 +86,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<cdn_cdn_UNIQUE>
+=head2 C<idx_39561_cdn_cdn_unique>
=over 4
@@ -90,7 +96,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("cdn_cdn_UNIQUE", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_39561_cdn_cdn_unique", ["name"]);
=head1 RELATIONS
@@ -125,8 +131,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-11-10 11:16:40
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uQW1V4fQTKv/ccBtWZawTQ
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qQPuTDHboEJBerVklb8U/A
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Deliveryservice.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Deliveryservice.pm b/traffic_ops/app/lib/Schema/Result/Deliveryservice.pm
index 8379ffc..e627560 100644
--- a/traffic_ops/app/lib/Schema/Result/Deliveryservice.pm
+++ b/traffic_ops/app/lib/Schema/Result/Deliveryservice.pm
@@ -1,24 +1,6 @@
use utf8;
package Schema::Result::Deliveryservice;
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-
-
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
@@ -43,9 +25,10 @@ __PACKAGE__->table("deliveryservice");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'deliveryservice_id_seq'
=head2 xml_id
@@ -55,27 +38,29 @@ __PACKAGE__->table("deliveryservice");
=head2 active
- data_type: 'tinyint'
+ data_type: 'boolean'
+ default_value: false
is_nullable: 0
=head2 dscp
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 0
=head2 signed
- data_type: 'tinyint'
+ data_type: 'boolean'
+ default_value: false
is_nullable: 1
=head2 qstring_ignore
- data_type: 'tinyint'
+ data_type: 'smallint'
is_nullable: 1
=head2 geo_limit
- data_type: 'tinyint'
+ data_type: 'smallint'
default_value: 0
is_nullable: 1
@@ -99,7 +84,7 @@ __PACKAGE__->table("deliveryservice");
=head2 dns_bypass_ttl
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 org_server_fqdn
@@ -110,35 +95,35 @@ __PACKAGE__->table("deliveryservice");
=head2 type
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 profile
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 cdn_id
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 ccr_dns_ttl
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 global_max_mbps
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 global_max_tps
- data_type: 'integer'
+ data_type: 'bigint'
is_nullable: 1
=head2 long_desc
@@ -161,7 +146,7 @@ __PACKAGE__->table("deliveryservice");
=head2 max_dns_answers
- data_type: 'integer'
+ data_type: 'bigint'
default_value: 0
is_nullable: 1
@@ -173,12 +158,12 @@ __PACKAGE__->table("deliveryservice");
=head2 miss_lat
- data_type: 'double precision'
+ data_type: 'numeric'
is_nullable: 1
=head2 miss_long
- data_type: 'double precision'
+ data_type: 'numeric'
is_nullable: 1
=head2 check_path
@@ -189,31 +174,32 @@ __PACKAGE__->table("deliveryservice");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=head2 protocol
- data_type: 'tinyint'
+ data_type: 'smallint'
default_value: 0
is_nullable: 1
=head2 ssl_key_version
- data_type: 'integer'
+ data_type: 'bigint'
default_value: 0
is_nullable: 1
=head2 ipv6_routing_enabled
- data_type: 'tinyint'
+ data_type: 'boolean'
+ default_value: false
is_nullable: 1
=head2 range_request_handling
- data_type: 'tinyint'
+ data_type: 'smallint'
default_value: 0
is_nullable: 1
@@ -255,7 +241,8 @@ __PACKAGE__->table("deliveryservice");
=head2 multi_site_origin
- data_type: 'tinyint'
+ data_type: 'boolean'
+ default_value: false
is_nullable: 1
=head2 display_name
@@ -272,7 +259,7 @@ __PACKAGE__->table("deliveryservice");
=head2 initial_dispersion
- data_type: 'integer'
+ data_type: 'bigint'
default_value: 1
is_nullable: 1
@@ -290,20 +277,16 @@ __PACKAGE__->table("deliveryservice");
=head2 regional_geo_blocking
- data_type: 'tinyint'
+ data_type: 'boolean'
+ default_value: false
is_nullable: 0
=head2 geo_provider
- data_type: 'tinyint'
+ data_type: 'smallint'
default_value: 0
is_nullable: 1
-=head2 multi_site_origin_algorithm
-
- data_type: 'tinyint'
- is_nullable: 1
-
=head2 geo_limit_countries
data_type: 'varchar'
@@ -312,8 +295,14 @@ __PACKAGE__->table("deliveryservice");
=head2 logs_enabled
- data_type: 'tinyint'
- is_nullable: 0
+ data_type: 'boolean'
+ default_value: false
+ is_nullable: 1
+
+=head2 multi_site_origin_algorithm
+
+ data_type: 'smallint'
+ is_nullable: 1
=head2 geolimit_redirect_url
@@ -325,19 +314,24 @@ __PACKAGE__->table("deliveryservice");
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "deliveryservice_id_seq",
+ },
"xml_id",
{ data_type => "varchar", is_nullable => 0, size => 48 },
"active",
- { data_type => "tinyint", is_nullable => 0 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 0 },
"dscp",
- { data_type => "integer", is_nullable => 0 },
+ { data_type => "bigint", is_nullable => 0 },
"signed",
- { data_type => "tinyint", is_nullable => 1 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 1 },
"qstring_ignore",
- { data_type => "tinyint", is_nullable => 1 },
+ { data_type => "smallint", is_nullable => 1 },
"geo_limit",
- { data_type => "tinyint", default_value => 0, is_nullable => 1 },
+ { data_type => "smallint", default_value => 0, is_nullable => 1 },
"http_bypass_fqdn",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"dns_bypass_ip",
@@ -345,21 +339,21 @@ __PACKAGE__->add_columns(
"dns_bypass_ip6",
{ data_type => "varchar", is_nullable => 1, size => 45 },
"dns_bypass_ttl",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"org_server_fqdn",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"type",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"profile",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"cdn_id",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"ccr_dns_ttl",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"global_max_mbps",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"global_max_tps",
- { data_type => "integer", is_nullable => 1 },
+ { data_type => "bigint", is_nullable => 1 },
"long_desc",
{ data_type => "varchar", is_nullable => 1, size => 1024 },
"long_desc_1",
@@ -367,30 +361,30 @@ __PACKAGE__->add_columns(
"long_desc_2",
{ data_type => "varchar", is_nullable => 1, size => 1024 },
"max_dns_answers",
- { data_type => "integer", default_value => 0, is_nullable => 1 },
+ { data_type => "bigint", default_value => 0, is_nullable => 1 },
"info_url",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"miss_lat",
- { data_type => "double precision", is_nullable => 1 },
+ { data_type => "numeric", is_nullable => 1 },
"miss_long",
- { data_type => "double precision", is_nullable => 1 },
+ { data_type => "numeric", is_nullable => 1 },
"check_path",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
"protocol",
- { data_type => "tinyint", default_value => 0, is_nullable => 1 },
+ { data_type => "smallint", default_value => 0, is_nullable => 1 },
"ssl_key_version",
- { data_type => "integer", default_value => 0, is_nullable => 1 },
+ { data_type => "bigint", default_value => 0, is_nullable => 1 },
"ipv6_routing_enabled",
- { data_type => "tinyint", is_nullable => 1 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 1 },
"range_request_handling",
- { data_type => "tinyint", default_value => 0, is_nullable => 1 },
+ { data_type => "smallint", default_value => 0, is_nullable => 1 },
"edge_header_rewrite",
{ data_type => "varchar", is_nullable => 1, size => 2048 },
"origin_shield",
@@ -404,27 +398,27 @@ __PACKAGE__->add_columns(
"remap_text",
{ data_type => "varchar", is_nullable => 1, size => 2048 },
"multi_site_origin",
- { data_type => "tinyint", is_nullable => 1 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 1 },
"display_name",
{ data_type => "varchar", is_nullable => 0, size => 48 },
"tr_response_headers",
{ data_type => "varchar", is_nullable => 1, size => 1024 },
"initial_dispersion",
- { data_type => "integer", default_value => 1, is_nullable => 1 },
+ { data_type => "bigint", default_value => 1, is_nullable => 1 },
"dns_bypass_cname",
{ data_type => "varchar", is_nullable => 1, size => 255 },
"tr_request_headers",
{ data_type => "varchar", is_nullable => 1, size => 1024 },
"regional_geo_blocking",
- { data_type => "tinyint", is_nullable => 0 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 0 },
"geo_provider",
- { data_type => "tinyint", default_value => 0, is_nullable => 1 },
- "multi_site_origin_algorithm",
- { data_type => "tinyint", is_nullable => 1 },
+ { data_type => "smallint", default_value => 0, is_nullable => 1 },
"geo_limit_countries",
{ data_type => "varchar", is_nullable => 1, size => 750 },
"logs_enabled",
- { data_type => "tinyint", is_nullable => 0 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 1 },
+ "multi_site_origin_algorithm",
+ { data_type => "smallint", is_nullable => 1 },
"geolimit_redirect_url",
{ data_type => "varchar", is_nullable => 1, size => 255 },
);
@@ -445,7 +439,7 @@ __PACKAGE__->set_primary_key("id", "type");
=head1 UNIQUE CONSTRAINTS
-=head2 C<ds_id_UNIQUE>
+=head2 C<idx_39569_ds_id_unique>
=over 4
@@ -455,9 +449,9 @@ __PACKAGE__->set_primary_key("id", "type");
=cut
-__PACKAGE__->add_unique_constraint("ds_id_UNIQUE", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_39569_ds_id_unique", ["id"]);
-=head2 C<ds_name_UNIQUE>
+=head2 C<idx_39569_ds_name_unique>
=over 4
@@ -467,7 +461,7 @@ __PACKAGE__->add_unique_constraint("ds_id_UNIQUE", ["id"]);
=cut
-__PACKAGE__->add_unique_constraint("ds_name_UNIQUE", ["xml_id"]);
+__PACKAGE__->add_unique_constraint("idx_39569_ds_name_unique", ["xml_id"]);
=head1 RELATIONS
@@ -483,7 +477,7 @@ __PACKAGE__->belongs_to(
"cdn",
"Schema::Result::Cdn",
{ id => "cdn_id" },
- { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
+ { is_deferrable => 0, on_delete => "RESTRICT", on_update => "RESTRICT" },
);
=head2 deliveryservice_regexes
@@ -573,7 +567,7 @@ __PACKAGE__->belongs_to(
"profile",
"Schema::Result::Profile",
{ id => "profile" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
=head2 staticdnsentries
@@ -633,12 +627,12 @@ __PACKAGE__->belongs_to(
"type",
"Schema::Result::Type",
{ id => "type" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-08-01 08:58:13
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k1aJ71tsV0AWeFF/OpHFUA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GVVqIebKToor4NvAz1DVPw
# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/DeliveryserviceRegex.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/DeliveryserviceRegex.pm b/traffic_ops/app/lib/Schema/Result/DeliveryserviceRegex.pm
index 9019618..aa85c24 100644
--- a/traffic_ops/app/lib/Schema/Result/DeliveryserviceRegex.pm
+++ b/traffic_ops/app/lib/Schema/Result/DeliveryserviceRegex.pm
@@ -25,19 +25,19 @@ __PACKAGE__->table("deliveryservice_regex");
=head2 deliveryservice
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 regex
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 set_number
- data_type: 'integer'
+ data_type: 'bigint'
default_value: 0
is_nullable: 1
@@ -45,11 +45,11 @@ __PACKAGE__->table("deliveryservice_regex");
__PACKAGE__->add_columns(
"deliveryservice",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"regex",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"set_number",
- { data_type => "integer", default_value => 0, is_nullable => 1 },
+ { data_type => "bigint", default_value => 0, is_nullable => 1 },
);
=head1 PRIMARY KEY
@@ -80,7 +80,7 @@ __PACKAGE__->belongs_to(
"deliveryservice",
"Schema::Result::Deliveryservice",
{ id => "deliveryservice" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 regex
@@ -95,12 +95,12 @@ __PACKAGE__->belongs_to(
"regex",
"Schema::Result::Regex",
{ id => "regex" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:trYSKBdbejUardk3QGm4Bg
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:F6QvoFC7jblt/8jDVI2pDw
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/DeliveryserviceServer.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/DeliveryserviceServer.pm b/traffic_ops/app/lib/Schema/Result/DeliveryserviceServer.pm
index 6159866..d3e6e20 100644
--- a/traffic_ops/app/lib/Schema/Result/DeliveryserviceServer.pm
+++ b/traffic_ops/app/lib/Schema/Result/DeliveryserviceServer.pm
@@ -25,36 +25,36 @@ __PACKAGE__->table("deliveryservice_server");
=head2 deliveryservice
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 server
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"deliveryservice",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"server",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -86,7 +86,7 @@ __PACKAGE__->belongs_to(
"deliveryservice",
"Schema::Result::Deliveryservice",
{ id => "deliveryservice" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 server
@@ -101,12 +101,12 @@ __PACKAGE__->belongs_to(
"server",
"Schema::Result::Server",
{ id => "server" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eRvXjjQnrQhZbcm5MrYl3A
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4C6p2bSPmbMu+sXa8QHukw
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/DeliveryserviceTmuser.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/DeliveryserviceTmuser.pm b/traffic_ops/app/lib/Schema/Result/DeliveryserviceTmuser.pm
index 983395b..9376613 100644
--- a/traffic_ops/app/lib/Schema/Result/DeliveryserviceTmuser.pm
+++ b/traffic_ops/app/lib/Schema/Result/DeliveryserviceTmuser.pm
@@ -25,36 +25,36 @@ __PACKAGE__->table("deliveryservice_tmuser");
=head2 deliveryservice
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 tm_user_id
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"deliveryservice",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"tm_user_id",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -86,7 +86,7 @@ __PACKAGE__->belongs_to(
"deliveryservice",
"Schema::Result::Deliveryservice",
{ id => "deliveryservice" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 tm_user
@@ -101,12 +101,12 @@ __PACKAGE__->belongs_to(
"tm_user",
"Schema::Result::TmUser",
{ id => "tm_user_id" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Qdz64xkxF7E2J45MH5MVsA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xwsJy5Fl9HvyGraz+6Pyvw
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Division.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Division.pm b/traffic_ops/app/lib/Schema/Result/Division.pm
index 7058d3d..3e23770 100644
--- a/traffic_ops/app/lib/Schema/Result/Division.pm
+++ b/traffic_ops/app/lib/Schema/Result/Division.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("division");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'division_id_seq'
=head2 name
@@ -37,24 +38,29 @@ __PACKAGE__->table("division");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "division_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -72,7 +78,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<name_UNIQUE>
+=head2 C<idx_39598_name_unique>
=over 4
@@ -82,7 +88,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("name_UNIQUE", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_39598_name_unique", ["name"]);
=head1 RELATIONS
@@ -102,8 +108,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FkRww7Gks2wYs1YuCwaBBQ
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HJfQpD4yPSpy57C4qwGH+Q
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Federation.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Federation.pm b/traffic_ops/app/lib/Schema/Result/Federation.pm
index 51d854d..231e03e 100644
--- a/traffic_ops/app/lib/Schema/Result/Federation.pm
+++ b/traffic_ops/app/lib/Schema/Result/Federation.pm
@@ -1,24 +1,6 @@
use utf8;
package Schema::Result::Federation;
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-
-
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
@@ -43,9 +25,10 @@ __PACKAGE__->table("federation");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'federation_id_seq'
=head2 cname
@@ -66,16 +49,21 @@ __PACKAGE__->table("federation");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "federation_id_seq",
+ },
"cname",
{ data_type => "varchar", is_nullable => 0, size => 1024 },
"description",
@@ -84,10 +72,10 @@ __PACKAGE__->add_columns(
{ data_type => "integer", is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -151,8 +139,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-01 14:21:23
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:z0P4j54QodUN1uxCvy3iRQ
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g9IDDq9eNa7+ljzIKnLCeA
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/FederationDeliveryservice.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/FederationDeliveryservice.pm b/traffic_ops/app/lib/Schema/Result/FederationDeliveryservice.pm
index 4b22f88..bf1792d 100644
--- a/traffic_ops/app/lib/Schema/Result/FederationDeliveryservice.pm
+++ b/traffic_ops/app/lib/Schema/Result/FederationDeliveryservice.pm
@@ -1,24 +1,6 @@
use utf8;
package Schema::Result::FederationDeliveryservice;
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-
-
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
@@ -43,36 +25,36 @@ __PACKAGE__->table("federation_deliveryservice");
=head2 federation
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 deliveryservice
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"federation",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"deliveryservice",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -104,7 +86,7 @@ __PACKAGE__->belongs_to(
"deliveryservice",
"Schema::Result::Deliveryservice",
{ id => "deliveryservice" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 federation
@@ -119,12 +101,12 @@ __PACKAGE__->belongs_to(
"federation",
"Schema::Result::Federation",
{ id => "federation" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-09-28 13:05:02
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WFPKsZLhl68a4TZwfNUURA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0p9zLxK4KyYgjGvnV3Gv+g
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/FederationFederationResolver.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/FederationFederationResolver.pm b/traffic_ops/app/lib/Schema/Result/FederationFederationResolver.pm
index 7d79ac5..2a90565 100644
--- a/traffic_ops/app/lib/Schema/Result/FederationFederationResolver.pm
+++ b/traffic_ops/app/lib/Schema/Result/FederationFederationResolver.pm
@@ -1,24 +1,6 @@
use utf8;
package Schema::Result::FederationFederationResolver;
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-
-
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
@@ -43,36 +25,36 @@ __PACKAGE__->table("federation_federation_resolver");
=head2 federation
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 federation_resolver
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"federation",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"federation_resolver",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -104,7 +86,7 @@ __PACKAGE__->belongs_to(
"federation",
"Schema::Result::Federation",
{ id => "federation" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 federation_resolver
@@ -119,12 +101,12 @@ __PACKAGE__->belongs_to(
"federation_resolver",
"Schema::Result::FederationResolver",
{ id => "federation_resolver" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-09-28 13:05:02
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Nkm0asIVOi/Mih+l1squCQ
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+rDQ18D+CIYbqA/JYyr4UA
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/FederationResolver.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/FederationResolver.pm b/traffic_ops/app/lib/Schema/Result/FederationResolver.pm
index 13a924f..0d24a79 100644
--- a/traffic_ops/app/lib/Schema/Result/FederationResolver.pm
+++ b/traffic_ops/app/lib/Schema/Result/FederationResolver.pm
@@ -1,24 +1,6 @@
use utf8;
package Schema::Result::FederationResolver;
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-
-
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
@@ -43,9 +25,10 @@ __PACKAGE__->table("federation_resolver");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'federation_resolver_id_seq'
=head2 ip_address
@@ -55,32 +38,37 @@ __PACKAGE__->table("federation_resolver");
=head2 type
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "federation_resolver_id_seq",
+ },
"ip_address",
{ data_type => "varchar", is_nullable => 0, size => 50 },
"type",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -98,7 +86,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<federation_resolver_ip_address>
+=head2 C<idx_39623_federation_resolver_ip_address>
=over 4
@@ -108,7 +96,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("federation_resolver_ip_address", ["ip_address"]);
+__PACKAGE__->add_unique_constraint("idx_39623_federation_resolver_ip_address", ["ip_address"]);
=head1 RELATIONS
@@ -139,12 +127,12 @@ __PACKAGE__->belongs_to(
"type",
"Schema::Result::Type",
{ id => "type" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-01 14:21:23
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aX5lihadg5MoMeZ+kt5amQ
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:x6/uBMhEXeRvCAn3fEj6rQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/FederationTmuser.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/FederationTmuser.pm b/traffic_ops/app/lib/Schema/Result/FederationTmuser.pm
index ee48d37..ac77507 100644
--- a/traffic_ops/app/lib/Schema/Result/FederationTmuser.pm
+++ b/traffic_ops/app/lib/Schema/Result/FederationTmuser.pm
@@ -1,24 +1,6 @@
use utf8;
package Schema::Result::FederationTmuser;
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-
-
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
@@ -43,44 +25,44 @@ __PACKAGE__->table("federation_tmuser");
=head2 federation
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 tm_user
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 role
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"federation",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"tm_user",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"role",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -112,7 +94,7 @@ __PACKAGE__->belongs_to(
"federation",
"Schema::Result::Federation",
{ id => "federation" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 role
@@ -127,7 +109,7 @@ __PACKAGE__->belongs_to(
"role",
"Schema::Result::Role",
{ id => "role" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 tm_user
@@ -142,12 +124,12 @@ __PACKAGE__->belongs_to(
"tm_user",
"Schema::Result::TmUser",
{ id => "tm_user" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-01 14:21:23
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GtS0uKLYINOgVL6K5muNag
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CpoLNIdmQI4fSvQCoBcRkQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/GooseDbVersion.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/GooseDbVersion.pm b/traffic_ops/app/lib/Schema/Result/GooseDbVersion.pm
index 6597988..d1dd43c 100644
--- a/traffic_ops/app/lib/Schema/Result/GooseDbVersion.pm
+++ b/traffic_ops/app/lib/Schema/Result/GooseDbVersion.pm
@@ -26,47 +26,48 @@ __PACKAGE__->table("goose_db_version");
=head2 id
data_type: 'bigint'
- extra: {unsigned => 1}
is_auto_increment: 1
is_nullable: 0
+ sequence: 'goose_db_version_id_seq'
=head2 version_id
- data_type: 'bigint'
+ data_type: 'numeric'
is_nullable: 0
=head2 is_applied
- data_type: 'tinyint'
+ data_type: 'boolean'
+ default_value: false
is_nullable: 0
=head2 tstamp
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
{
- data_type => "bigint",
- extra => { unsigned => 1 },
+ data_type => "bigint",
is_auto_increment => 1,
- is_nullable => 0,
+ is_nullable => 0,
+ sequence => "goose_db_version_id_seq",
},
"version_id",
- { data_type => "bigint", is_nullable => 0 },
+ { data_type => "numeric", is_nullable => 0 },
"is_applied",
- { data_type => "tinyint", is_nullable => 0 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 0 },
"tstamp",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -83,8 +84,8 @@ __PACKAGE__->add_columns(
__PACKAGE__->set_primary_key("id");
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:utMNoRDzBw9a2hNaMxsP3A
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kNbDG4yXcgqGB2dRrmtF6A
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Hwinfo.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Hwinfo.pm b/traffic_ops/app/lib/Schema/Result/Hwinfo.pm
index 0598e48..a47785e 100644
--- a/traffic_ops/app/lib/Schema/Result/Hwinfo.pm
+++ b/traffic_ops/app/lib/Schema/Result/Hwinfo.pm
@@ -25,13 +25,14 @@ __PACKAGE__->table("hwinfo");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'hwinfo_id_seq'
=head2 serverid
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
@@ -49,28 +50,33 @@ __PACKAGE__->table("hwinfo");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "hwinfo_id_seq",
+ },
"serverid",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"description",
{ data_type => "varchar", is_nullable => 0, size => 256 },
"val",
{ data_type => "varchar", is_nullable => 0, size => 256 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -88,7 +94,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<serverid>
+=head2 C<idx_39644_serverid>
=over 4
@@ -100,7 +106,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("serverid", ["serverid", "description"]);
+__PACKAGE__->add_unique_constraint("idx_39644_serverid", ["serverid", "description"]);
=head1 RELATIONS
@@ -116,12 +122,12 @@ __PACKAGE__->belongs_to(
"serverid",
"Schema::Result::Server",
{ id => "serverid" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Oq3GIhYgP8bbIBTlZvetMQ
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wVTEBN+UdPkHDLwwb39UHw
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Job.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Job.pm b/traffic_ops/app/lib/Schema/Result/Job.pm
index cfa5d12..ab8d389 100644
--- a/traffic_ops/app/lib/Schema/Result/Job.pm
+++ b/traffic_ops/app/lib/Schema/Result/Job.pm
@@ -25,13 +25,14 @@ __PACKAGE__->table("job");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'job_id_seq'
=head2 agent
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 1
@@ -73,38 +74,36 @@ __PACKAGE__->table("job");
=head2 status
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 start_time
- data_type: 'datetime'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
is_nullable: 0
=head2 entered_time
- data_type: 'datetime'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
is_nullable: 0
=head2 job_user
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=head2 job_deliveryservice
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 1
@@ -112,9 +111,14 @@ __PACKAGE__->table("job");
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "job_id_seq",
+ },
"agent",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
"object_type",
{ data_type => "varchar", is_nullable => 1, size => 48 },
"object_name",
@@ -128,30 +132,22 @@ __PACKAGE__->add_columns(
"asset_type",
{ data_type => "varchar", is_nullable => 0, size => 48 },
"status",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"start_time",
- {
- data_type => "datetime",
- datetime_undef_if_invalid => 1,
- is_nullable => 0,
- },
+ { data_type => "timestamp with time zone", is_nullable => 0 },
"entered_time",
- {
- data_type => "datetime",
- datetime_undef_if_invalid => 1,
- is_nullable => 0,
- },
+ { data_type => "timestamp with time zone", is_nullable => 0 },
"job_user",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
"job_deliveryservice",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
);
=head1 PRIMARY KEY
@@ -181,7 +177,7 @@ __PACKAGE__->belongs_to(
"Schema::Result::JobAgent",
{ id => "agent" },
{
- is_deferrable => 1,
+ is_deferrable => 0,
join_type => "LEFT",
on_delete => "CASCADE",
on_update => "NO ACTION",
@@ -201,7 +197,7 @@ __PACKAGE__->belongs_to(
"Schema::Result::Deliveryservice",
{ id => "job_deliveryservice" },
{
- is_deferrable => 1,
+ is_deferrable => 0,
join_type => "LEFT",
on_delete => "NO ACTION",
on_update => "NO ACTION",
@@ -235,7 +231,7 @@ __PACKAGE__->belongs_to(
"job_user",
"Schema::Result::TmUser",
{ id => "job_user" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
=head2 status
@@ -250,12 +246,12 @@ __PACKAGE__->belongs_to(
"status",
"Schema::Result::JobStatus",
{ id => "status" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AOQJIKcfi/ADgnVuB7U+rg
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:foiwqyk03075z2FsiHH+5g
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/JobAgent.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/JobAgent.pm b/traffic_ops/app/lib/Schema/Result/JobAgent.pm
index a106eaf..4c43e16 100644
--- a/traffic_ops/app/lib/Schema/Result/JobAgent.pm
+++ b/traffic_ops/app/lib/Schema/Result/JobAgent.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("job_agent");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'job_agent_id_seq'
=head2 name
@@ -49,16 +50,21 @@ __PACKAGE__->table("job_agent");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "job_agent_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 1, size => 128 },
"description",
@@ -67,10 +73,10 @@ __PACKAGE__->add_columns(
{ data_type => "integer", default_value => 0, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -119,8 +125,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YMfLLrEg+jj/eP7mdDiPnA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j67ZAM5DidOlp2Pp49bjiQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/JobResult.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/JobResult.pm b/traffic_ops/app/lib/Schema/Result/JobResult.pm
index a2f71dc..3ca0a05 100644
--- a/traffic_ops/app/lib/Schema/Result/JobResult.pm
+++ b/traffic_ops/app/lib/Schema/Result/JobResult.pm
@@ -25,19 +25,20 @@ __PACKAGE__->table("job_result");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'job_result_id_seq'
=head2 job
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 agent
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
@@ -55,30 +56,35 @@ __PACKAGE__->table("job_result");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "job_result_id_seq",
+ },
"job",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"agent",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"result",
{ data_type => "varchar", is_nullable => 0, size => 48 },
"description",
{ data_type => "varchar", is_nullable => 1, size => 512 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -108,7 +114,7 @@ __PACKAGE__->belongs_to(
"agent",
"Schema::Result::JobAgent",
{ id => "agent" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
);
=head2 job
@@ -123,12 +129,12 @@ __PACKAGE__->belongs_to(
"job",
"Schema::Result::Job",
{ id => "job" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6+gwHGyMRYmILsJvuVcKyQ
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kEkKns8EbsjqQc8VpR9N/w
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/JobStatus.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/JobStatus.pm b/traffic_ops/app/lib/Schema/Result/JobStatus.pm
index 7b3322a..e3c5903 100644
--- a/traffic_ops/app/lib/Schema/Result/JobStatus.pm
+++ b/traffic_ops/app/lib/Schema/Result/JobStatus.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("job_status");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'job_status_id_seq'
=head2 name
@@ -43,26 +44,31 @@ __PACKAGE__->table("job_status");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "job_status_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 1, size => 48 },
"description",
{ data_type => "varchar", is_nullable => 1, size => 256 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -96,8 +102,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XOVbBWCrr8WN0wfUO7wRHw
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sdc3sSeBQaq/N5hR9Zpu+Q
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Log.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Log.pm b/traffic_ops/app/lib/Schema/Result/Log.pm
index e5c2511..848dff0 100644
--- a/traffic_ops/app/lib/Schema/Result/Log.pm
+++ b/traffic_ops/app/lib/Schema/Result/Log.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("log");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'log_id_seq'
=head2 level
@@ -43,7 +44,7 @@ __PACKAGE__->table("log");
=head2 tm_user
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
@@ -55,30 +56,35 @@ __PACKAGE__->table("log");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "log_id_seq",
+ },
"level",
{ data_type => "varchar", is_nullable => 1, size => 45 },
"message",
{ data_type => "varchar", is_nullable => 0, size => 1024 },
"tm_user",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"ticketnum",
{ data_type => "varchar", is_nullable => 1, size => 64 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -110,12 +116,12 @@ __PACKAGE__->belongs_to(
"tm_user",
"Schema::Result::TmUser",
{ id => "tm_user" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XkJt7i4956YEhggYnKRF3A
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JBW6m8ZglGpSaWd7LJhsGQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Parameter.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Parameter.pm b/traffic_ops/app/lib/Schema/Result/Parameter.pm
index 2ec6c46..a89f633 100644
--- a/traffic_ops/app/lib/Schema/Result/Parameter.pm
+++ b/traffic_ops/app/lib/Schema/Result/Parameter.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("parameter");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'parameter_id_seq'
=head2 name
@@ -38,7 +39,7 @@ __PACKAGE__->table("parameter");
=head2 config_file
data_type: 'varchar'
- is_nullable: 0
+ is_nullable: 1
size: 256
=head2 value
@@ -49,37 +50,42 @@ __PACKAGE__->table("parameter");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=head2 secure
- data_type: 'tinyint'
- default_value: 0
+ data_type: 'boolean'
+ default_value: false
is_nullable: 0
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "parameter_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 0, size => 1024 },
"config_file",
- { data_type => "varchar", is_nullable => 0, size => 256 },
+ { data_type => "varchar", is_nullable => 1, size => 256 },
"value",
{ data_type => "varchar", is_nullable => 0, size => 1024 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
"secure",
- { data_type => "tinyint", default_value => 0, is_nullable => 0 },
+ { data_type => "boolean", default_value => \"false", is_nullable => 0 },
);
=head1 PRIMARY KEY
@@ -127,8 +133,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-03-15 23:28:01
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aTrkVhWmNRR9aZ9VqhH1Pg
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UI2NEBlM9FxffnQSUrnGxg
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/PhysLocation.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/PhysLocation.pm b/traffic_ops/app/lib/Schema/Result/PhysLocation.pm
index 8085073..25488d2 100644
--- a/traffic_ops/app/lib/Schema/Result/PhysLocation.pm
+++ b/traffic_ops/app/lib/Schema/Result/PhysLocation.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("phys_location");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'phys_location_id_seq'
=head2 name
@@ -91,22 +92,27 @@ __PACKAGE__->table("phys_location");
=head2 region
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "phys_location_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"short_name",
@@ -128,13 +134,13 @@ __PACKAGE__->add_columns(
"comments",
{ data_type => "varchar", is_nullable => 1, size => 256 },
"region",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -152,7 +158,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<name_UNIQUE>
+=head2 C<idx_39713_name_unique>
=over 4
@@ -162,9 +168,9 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("name_UNIQUE", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_39713_name_unique", ["name"]);
-=head2 C<short_name_UNIQUE>
+=head2 C<idx_39713_short_name_unique>
=over 4
@@ -174,7 +180,7 @@ __PACKAGE__->add_unique_constraint("name_UNIQUE", ["name"]);
=cut
-__PACKAGE__->add_unique_constraint("short_name_UNIQUE", ["short_name"]);
+__PACKAGE__->add_unique_constraint("idx_39713_short_name_unique", ["short_name"]);
=head1 RELATIONS
@@ -190,7 +196,7 @@ __PACKAGE__->belongs_to(
"region",
"Schema::Result::Region",
{ id => "region" },
- { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
=head2 servers
@@ -209,8 +215,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:P49VpYuUIcx6aOOUORrQyA
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qoZbC6exGiOWYVpc4lnPxw
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/Profile.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/Profile.pm b/traffic_ops/app/lib/Schema/Result/Profile.pm
index f6a4256..01504e6 100644
--- a/traffic_ops/app/lib/Schema/Result/Profile.pm
+++ b/traffic_ops/app/lib/Schema/Result/Profile.pm
@@ -25,9 +25,10 @@ __PACKAGE__->table("profile");
=head2 id
- data_type: 'integer'
+ data_type: 'bigint'
is_auto_increment: 1
is_nullable: 0
+ sequence: 'profile_id_seq'
=head2 name
@@ -43,26 +44,31 @@ __PACKAGE__->table("profile");
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"id",
- { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ {
+ data_type => "bigint",
+ is_auto_increment => 1,
+ is_nullable => 0,
+ sequence => "profile_id_seq",
+ },
"name",
{ data_type => "varchar", is_nullable => 0, size => 45 },
"description",
{ data_type => "varchar", is_nullable => 1, size => 256 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -80,7 +86,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<name_UNIQUE>
+=head2 C<idx_39723_name_unique>
=over 4
@@ -90,7 +96,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("name_UNIQUE", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_39723_name_unique", ["name"]);
=head1 RELATIONS
@@ -140,8 +146,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-10-05 11:28:28
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9iu0tHvzgk8ndjVwNDiB/w
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ExMUfMyEhu/F/kLx4guS+w
# You can replace this text with custom code or comments, and it will be preserved on regeneration
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/610a17d1/traffic_ops/app/lib/Schema/Result/ProfileParameter.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/ProfileParameter.pm b/traffic_ops/app/lib/Schema/Result/ProfileParameter.pm
index ef7199e..cac475e 100644
--- a/traffic_ops/app/lib/Schema/Result/ProfileParameter.pm
+++ b/traffic_ops/app/lib/Schema/Result/ProfileParameter.pm
@@ -25,36 +25,36 @@ __PACKAGE__->table("profile_parameter");
=head2 profile
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 parameter
- data_type: 'integer'
+ data_type: 'bigint'
is_foreign_key: 1
is_nullable: 0
=head2 last_updated
- data_type: 'timestamp'
- datetime_undef_if_invalid: 1
+ data_type: 'timestamp with time zone'
default_value: current_timestamp
is_nullable: 1
+ original: {default_value => \"now()"}
=cut
__PACKAGE__->add_columns(
"profile",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"parameter",
- { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
+ { data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
{
- data_type => "timestamp",
- datetime_undef_if_invalid => 1,
+ data_type => "timestamp with time zone",
default_value => \"current_timestamp",
- is_nullable => 1,
+ is_nullable => 1,
+ original => { default_value => \"now()" },
},
);
@@ -86,7 +86,7 @@ __PACKAGE__->belongs_to(
"parameter",
"Schema::Result::Parameter",
{ id => "parameter" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
);
=head2 profile
@@ -101,12 +101,12 @@ __PACKAGE__->belongs_to(
"profile",
"Schema::Result::Profile",
{ id => "profile" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "NO ACTION" },
+ { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
);
-# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-05-21 13:27:11
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CLysnLZXU7DgOfMenYwG9A
+# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bg3IAJfz8GX6uS5UXMPblA
# You can replace this text with custom code or comments, and it will be preserved on regeneration