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:32 UTC
[2/3] incubator-trafficcontrol git commit: runs reverse_schema after
mysql to psql data migration and column type fixes
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