You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafficcontrol.apache.org by mi...@apache.org on 2016/11/18 23:00:39 UTC
[1/2] incubator-trafficcontrol git commit: Reverse schema with text
Repository: incubator-trafficcontrol
Updated Branches:
refs/heads/psql-rebase 4aa4af930 -> 030507336
Reverse schema with text
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/d71603a2
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/d71603a2
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/d71603a2
Branch: refs/heads/psql-rebase
Commit: d71603a27026e02284a481cb59a945aae90a292b
Parents: 4aa4af9
Author: Jan van Doorn <jv...@apache.org>
Authored: Fri Nov 18 22:46:00 2016 +0000
Committer: Jan van Doorn <jv...@apache.org>
Committed: Fri Nov 18 22:46:00 2016 +0000
----------------------------------------------------------------------
traffic_ops/app/lib/Schema/Result/Asn.pm | 8 +-
traffic_ops/app/lib/Schema/Result/Cachegroup.pm | 26 ++--
traffic_ops/app/lib/Schema/Result/Cdn.pm | 13 +-
.../app/lib/Schema/Result/Deliveryservice.pm | 122 +++++++----------
traffic_ops/app/lib/Schema/Result/Division.pm | 13 +-
traffic_ops/app/lib/Schema/Result/Federation.pm | 14 +-
.../app/lib/Schema/Result/FederationResolver.pm | 13 +-
traffic_ops/app/lib/Schema/Result/Hwinfo.pm | 18 ++-
traffic_ops/app/lib/Schema/Result/Job.pm | 34 ++---
traffic_ops/app/lib/Schema/Result/JobAgent.pm | 14 +-
traffic_ops/app/lib/Schema/Result/JobResult.pm | 14 +-
traffic_ops/app/lib/Schema/Result/JobStatus.pm | 14 +-
traffic_ops/app/lib/Schema/Result/Log.pm | 19 ++-
traffic_ops/app/lib/Schema/Result/Parameter.pm | 19 ++-
.../app/lib/Schema/Result/PhysLocation.pm | 62 ++++-----
traffic_ops/app/lib/Schema/Result/Profile.pm | 18 ++-
traffic_ops/app/lib/Schema/Result/Regex.pm | 13 +-
traffic_ops/app/lib/Schema/Result/Region.pm | 13 +-
traffic_ops/app/lib/Schema/Result/Role.pm | 14 +-
traffic_ops/app/lib/Schema/Result/Server.pm | 131 ++++++++-----------
.../app/lib/Schema/Result/Servercheck.pm | 12 +-
.../app/lib/Schema/Result/Staticdnsentry.pm | 18 ++-
.../app/lib/Schema/Result/StatsSummary.pm | 24 ++--
traffic_ops/app/lib/Schema/Result/Status.pm | 14 +-
traffic_ops/app/lib/Schema/Result/TmUser.pm | 87 +++++-------
.../app/lib/Schema/Result/ToExtension.pm | 44 +++----
traffic_ops/app/lib/Schema/Result/Type.pm | 23 ++--
27 files changed, 344 insertions(+), 470 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/d71603a2/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 35d1f31..1eb4f31 100644
--- a/traffic_ops/app/lib/Schema/Result/Asn.pm
+++ b/traffic_ops/app/lib/Schema/Result/Asn.pm
@@ -93,7 +93,7 @@ __PACKAGE__->set_primary_key("id", "cachegroup");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39541_cr_id_unique>
+=head2 C<idx_54244_cr_id_unique>
=over 4
@@ -103,7 +103,7 @@ __PACKAGE__->set_primary_key("id", "cachegroup");
=cut
-__PACKAGE__->add_unique_constraint("idx_39541_cr_id_unique", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_54244_cr_id_unique", ["id"]);
=head1 RELATIONS
@@ -123,8 +123,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dFE+hx8bFq0RPzVZ0VSfhQ
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NWsuURcmz5qyXRU30rgcow
# 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/d71603a2/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 ee103bd..fea22b3 100644
--- a/traffic_ops/app/lib/Schema/Result/Cachegroup.pm
+++ b/traffic_ops/app/lib/Schema/Result/Cachegroup.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("cachegroup");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 short_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 255
=head2 latitude
@@ -88,9 +86,9 @@ __PACKAGE__->add_columns(
sequence => "cachegroup_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"short_name",
- { data_type => "varchar", is_nullable => 0, size => 255 },
+ { data_type => "text", is_nullable => 0 },
"latitude",
{ data_type => "numeric", is_nullable => 1 },
"longitude",
@@ -126,7 +124,7 @@ __PACKAGE__->set_primary_key("id", "type");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39549_cg_name_unique>
+=head2 C<idx_54252_cg_name_unique>
=over 4
@@ -136,9 +134,9 @@ __PACKAGE__->set_primary_key("id", "type");
=cut
-__PACKAGE__->add_unique_constraint("idx_39549_cg_name_unique", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_54252_cg_name_unique", ["name"]);
-=head2 C<idx_39549_cg_short_unique>
+=head2 C<idx_54252_cg_short_unique>
=over 4
@@ -148,9 +146,9 @@ __PACKAGE__->add_unique_constraint("idx_39549_cg_name_unique", ["name"]);
=cut
-__PACKAGE__->add_unique_constraint("idx_39549_cg_short_unique", ["short_name"]);
+__PACKAGE__->add_unique_constraint("idx_54252_cg_short_unique", ["short_name"]);
-=head2 C<idx_39549_lo_id_unique>
+=head2 C<idx_54252_lo_id_unique>
=over 4
@@ -160,7 +158,7 @@ __PACKAGE__->add_unique_constraint("idx_39549_cg_short_unique", ["short_name"]);
=cut
-__PACKAGE__->add_unique_constraint("idx_39549_lo_id_unique", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_54252_lo_id_unique", ["id"]);
=head1 RELATIONS
@@ -310,8 +308,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LTQMxo73PQM85NrX7OWYHQ
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lU7dUVFuoTyhpC7x7BGaDg
# 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/d71603a2/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 2c2ade1..57dfc6e 100644
--- a/traffic_ops/app/lib/Schema/Result/Cdn.pm
+++ b/traffic_ops/app/lib/Schema/Result/Cdn.pm
@@ -32,9 +32,8 @@ __PACKAGE__->table("cdn");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 127
=head2 last_updated
@@ -60,7 +59,7 @@ __PACKAGE__->add_columns(
sequence => "cdn_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 1, size => 127 },
+ { data_type => "text", is_nullable => 1 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -86,7 +85,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39561_cdn_cdn_unique>
+=head2 C<idx_54267_cdn_cdn_unique>
=over 4
@@ -96,7 +95,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("idx_39561_cdn_cdn_unique", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_54267_cdn_cdn_unique", ["name"]);
=head1 RELATIONS
@@ -131,8 +130,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qQPuTDHboEJBerVklb8U/A
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YT90F9iN3AECS+hDmj/hwQ
# 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/d71603a2/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 e627560..bc482b4 100644
--- a/traffic_ops/app/lib/Schema/Result/Deliveryservice.pm
+++ b/traffic_ops/app/lib/Schema/Result/Deliveryservice.pm
@@ -32,9 +32,8 @@ __PACKAGE__->table("deliveryservice");
=head2 xml_id
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 48
=head2 active
@@ -66,21 +65,18 @@ __PACKAGE__->table("deliveryservice");
=head2 http_bypass_fqdn
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 255
=head2 dns_bypass_ip
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 dns_bypass_ip6
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 dns_bypass_ttl
@@ -89,9 +85,8 @@ __PACKAGE__->table("deliveryservice");
=head2 org_server_fqdn
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 255
=head2 type
@@ -128,21 +123,18 @@ __PACKAGE__->table("deliveryservice");
=head2 long_desc
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 1024
=head2 long_desc_1
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 1024
=head2 long_desc_2
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 1024
=head2 max_dns_answers
@@ -152,9 +144,8 @@ __PACKAGE__->table("deliveryservice");
=head2 info_url
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 255
=head2 miss_lat
@@ -168,9 +159,8 @@ __PACKAGE__->table("deliveryservice");
=head2 check_path
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 255
=head2 last_updated
@@ -205,39 +195,33 @@ __PACKAGE__->table("deliveryservice");
=head2 edge_header_rewrite
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 2048
=head2 origin_shield
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 1024
=head2 mid_header_rewrite
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 2048
=head2 regex_remap
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 1024
=head2 cacheurl
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 1024
=head2 remap_text
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 2048
=head2 multi_site_origin
@@ -247,15 +231,13 @@ __PACKAGE__->table("deliveryservice");
=head2 display_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 48
=head2 tr_response_headers
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 1024
=head2 initial_dispersion
@@ -265,15 +247,13 @@ __PACKAGE__->table("deliveryservice");
=head2 dns_bypass_cname
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 255
=head2 tr_request_headers
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 1024
=head2 regional_geo_blocking
@@ -289,9 +269,8 @@ __PACKAGE__->table("deliveryservice");
=head2 geo_limit_countries
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 750
=head2 logs_enabled
@@ -306,9 +285,8 @@ __PACKAGE__->table("deliveryservice");
=head2 geolimit_redirect_url
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 255
=cut
@@ -321,7 +299,7 @@ __PACKAGE__->add_columns(
sequence => "deliveryservice_id_seq",
},
"xml_id",
- { data_type => "varchar", is_nullable => 0, size => 48 },
+ { data_type => "text", is_nullable => 0 },
"active",
{ data_type => "boolean", default_value => \"false", is_nullable => 0 },
"dscp",
@@ -333,15 +311,15 @@ __PACKAGE__->add_columns(
"geo_limit",
{ data_type => "smallint", default_value => 0, is_nullable => 1 },
"http_bypass_fqdn",
- { data_type => "varchar", is_nullable => 1, size => 255 },
+ { data_type => "text", is_nullable => 1 },
"dns_bypass_ip",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"dns_bypass_ip6",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"dns_bypass_ttl",
{ data_type => "bigint", is_nullable => 1 },
"org_server_fqdn",
- { data_type => "varchar", is_nullable => 1, size => 255 },
+ { data_type => "text", is_nullable => 1 },
"type",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"profile",
@@ -355,21 +333,21 @@ __PACKAGE__->add_columns(
"global_max_tps",
{ data_type => "bigint", is_nullable => 1 },
"long_desc",
- { data_type => "varchar", is_nullable => 1, size => 1024 },
+ { data_type => "text", is_nullable => 1 },
"long_desc_1",
- { data_type => "varchar", is_nullable => 1, size => 1024 },
+ { data_type => "text", is_nullable => 1 },
"long_desc_2",
- { data_type => "varchar", is_nullable => 1, size => 1024 },
+ { data_type => "text", is_nullable => 1 },
"max_dns_answers",
{ data_type => "bigint", default_value => 0, is_nullable => 1 },
"info_url",
- { data_type => "varchar", is_nullable => 1, size => 255 },
+ { data_type => "text", is_nullable => 1 },
"miss_lat",
{ data_type => "numeric", is_nullable => 1 },
"miss_long",
{ data_type => "numeric", is_nullable => 1 },
"check_path",
- { data_type => "varchar", is_nullable => 1, size => 255 },
+ { data_type => "text", is_nullable => 1 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -386,41 +364,41 @@ __PACKAGE__->add_columns(
"range_request_handling",
{ data_type => "smallint", default_value => 0, is_nullable => 1 },
"edge_header_rewrite",
- { data_type => "varchar", is_nullable => 1, size => 2048 },
+ { data_type => "text", is_nullable => 1 },
"origin_shield",
- { data_type => "varchar", is_nullable => 1, size => 1024 },
+ { data_type => "text", is_nullable => 1 },
"mid_header_rewrite",
- { data_type => "varchar", is_nullable => 1, size => 2048 },
+ { data_type => "text", is_nullable => 1 },
"regex_remap",
- { data_type => "varchar", is_nullable => 1, size => 1024 },
+ { data_type => "text", is_nullable => 1 },
"cacheurl",
- { data_type => "varchar", is_nullable => 1, size => 1024 },
+ { data_type => "text", is_nullable => 1 },
"remap_text",
- { data_type => "varchar", is_nullable => 1, size => 2048 },
+ { data_type => "text", is_nullable => 1 },
"multi_site_origin",
{ data_type => "boolean", default_value => \"false", is_nullable => 1 },
"display_name",
- { data_type => "varchar", is_nullable => 0, size => 48 },
+ { data_type => "text", is_nullable => 0 },
"tr_response_headers",
- { data_type => "varchar", is_nullable => 1, size => 1024 },
+ { data_type => "text", is_nullable => 1 },
"initial_dispersion",
{ data_type => "bigint", default_value => 1, is_nullable => 1 },
"dns_bypass_cname",
- { data_type => "varchar", is_nullable => 1, size => 255 },
+ { data_type => "text", is_nullable => 1 },
"tr_request_headers",
- { data_type => "varchar", is_nullable => 1, size => 1024 },
+ { data_type => "text", is_nullable => 1 },
"regional_geo_blocking",
{ data_type => "boolean", default_value => \"false", is_nullable => 0 },
"geo_provider",
{ data_type => "smallint", default_value => 0, is_nullable => 1 },
"geo_limit_countries",
- { data_type => "varchar", is_nullable => 1, size => 750 },
+ { data_type => "text", is_nullable => 1 },
"logs_enabled",
{ 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 },
+ { data_type => "text", is_nullable => 1 },
);
=head1 PRIMARY KEY
@@ -439,7 +417,7 @@ __PACKAGE__->set_primary_key("id", "type");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39569_ds_id_unique>
+=head2 C<idx_54278_ds_id_unique>
=over 4
@@ -449,9 +427,9 @@ __PACKAGE__->set_primary_key("id", "type");
=cut
-__PACKAGE__->add_unique_constraint("idx_39569_ds_id_unique", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_54278_ds_id_unique", ["id"]);
-=head2 C<idx_39569_ds_name_unique>
+=head2 C<idx_54278_ds_name_unique>
=over 4
@@ -461,7 +439,7 @@ __PACKAGE__->add_unique_constraint("idx_39569_ds_id_unique", ["id"]);
=cut
-__PACKAGE__->add_unique_constraint("idx_39569_ds_name_unique", ["xml_id"]);
+__PACKAGE__->add_unique_constraint("idx_54278_ds_name_unique", ["xml_id"]);
=head1 RELATIONS
@@ -631,8 +609,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GVVqIebKToor4NvAz1DVPw
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OGL35PLFXtZ8BuzgP7IHzQ
# 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/d71603a2/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 3e23770..50e392f 100644
--- a/traffic_ops/app/lib/Schema/Result/Division.pm
+++ b/traffic_ops/app/lib/Schema/Result/Division.pm
@@ -32,9 +32,8 @@ __PACKAGE__->table("division");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 last_updated
@@ -54,7 +53,7 @@ __PACKAGE__->add_columns(
sequence => "division_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -78,7 +77,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39598_name_unique>
+=head2 C<idx_54307_name_unique>
=over 4
@@ -88,7 +87,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("idx_39598_name_unique", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_54307_name_unique", ["name"]);
=head1 RELATIONS
@@ -108,8 +107,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HJfQpD4yPSpy57C4qwGH+Q
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QFS9YnftrfmW/+HgC29RUQ
# 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/d71603a2/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 231e03e..e76e597 100644
--- a/traffic_ops/app/lib/Schema/Result/Federation.pm
+++ b/traffic_ops/app/lib/Schema/Result/Federation.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("federation");
=head2 cname
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 1024
=head2 description
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 1024
=head2 ttl
@@ -65,9 +63,9 @@ __PACKAGE__->add_columns(
sequence => "federation_id_seq",
},
"cname",
- { data_type => "varchar", is_nullable => 0, size => 1024 },
+ { data_type => "text", is_nullable => 0 },
"description",
- { data_type => "varchar", is_nullable => 1, size => 1024 },
+ { data_type => "text", is_nullable => 1 },
"ttl",
{ data_type => "integer", is_nullable => 0 },
"last_updated",
@@ -139,8 +137,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g9IDDq9eNa7+ljzIKnLCeA
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qM++z4wgPrUNASfGJ+5RNQ
# 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/d71603a2/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 0d24a79..bab6768 100644
--- a/traffic_ops/app/lib/Schema/Result/FederationResolver.pm
+++ b/traffic_ops/app/lib/Schema/Result/FederationResolver.pm
@@ -32,9 +32,8 @@ __PACKAGE__->table("federation_resolver");
=head2 ip_address
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 50
=head2 type
@@ -60,7 +59,7 @@ __PACKAGE__->add_columns(
sequence => "federation_resolver_id_seq",
},
"ip_address",
- { data_type => "varchar", is_nullable => 0, size => 50 },
+ { data_type => "text", is_nullable => 0 },
"type",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
@@ -86,7 +85,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39623_federation_resolver_ip_address>
+=head2 C<idx_54335_federation_resolver_ip_address>
=over 4
@@ -96,7 +95,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("idx_39623_federation_resolver_ip_address", ["ip_address"]);
+__PACKAGE__->add_unique_constraint("idx_54335_federation_resolver_ip_address", ["ip_address"]);
=head1 RELATIONS
@@ -131,8 +130,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:x6/uBMhEXeRvCAn3fEj6rQ
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PtOOjLrTI0OhFcdU0Qrg7g
# 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/d71603a2/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 a47785e..237e4dc 100644
--- a/traffic_ops/app/lib/Schema/Result/Hwinfo.pm
+++ b/traffic_ops/app/lib/Schema/Result/Hwinfo.pm
@@ -38,15 +38,13 @@ __PACKAGE__->table("hwinfo");
=head2 description
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 256
=head2 val
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 256
=head2 last_updated
@@ -68,9 +66,9 @@ __PACKAGE__->add_columns(
"serverid",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"description",
- { data_type => "varchar", is_nullable => 0, size => 256 },
+ { data_type => "text", is_nullable => 0 },
"val",
- { data_type => "varchar", is_nullable => 0, size => 256 },
+ { data_type => "text", is_nullable => 0 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -94,7 +92,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39644_serverid>
+=head2 C<idx_54359_serverid>
=over 4
@@ -106,7 +104,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("idx_39644_serverid", ["serverid", "description"]);
+__PACKAGE__->add_unique_constraint("idx_54359_serverid", ["serverid", "description"]);
=head1 RELATIONS
@@ -126,8 +124,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wVTEBN+UdPkHDLwwb39UHw
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I+M1bzpwgbsfvx1RyUqMDQ
# 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/d71603a2/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 ab8d389..97d814e 100644
--- a/traffic_ops/app/lib/Schema/Result/Job.pm
+++ b/traffic_ops/app/lib/Schema/Result/Job.pm
@@ -38,39 +38,33 @@ __PACKAGE__->table("job");
=head2 object_type
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 48
=head2 object_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 keyword
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 48
=head2 parameters
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 asset_url
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 512
=head2 asset_type
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 48
=head2 status
@@ -120,17 +114,17 @@ __PACKAGE__->add_columns(
"agent",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
"object_type",
- { data_type => "varchar", is_nullable => 1, size => 48 },
+ { data_type => "text", is_nullable => 1 },
"object_name",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"keyword",
- { data_type => "varchar", is_nullable => 0, size => 48 },
+ { data_type => "text", is_nullable => 0 },
"parameters",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"asset_url",
- { data_type => "varchar", is_nullable => 0, size => 512 },
+ { data_type => "text", is_nullable => 0 },
"asset_type",
- { data_type => "varchar", is_nullable => 0, size => 48 },
+ { data_type => "text", is_nullable => 0 },
"status",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"start_time",
@@ -250,8 +244,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:foiwqyk03075z2FsiHH+5g
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LSEFwyL7MpMXHLbKDM288A
# 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/d71603a2/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 4c43e16..4c7617d 100644
--- a/traffic_ops/app/lib/Schema/Result/JobAgent.pm
+++ b/traffic_ops/app/lib/Schema/Result/JobAgent.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("job_agent");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 128
=head2 description
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 512
=head2 active
@@ -66,9 +64,9 @@ __PACKAGE__->add_columns(
sequence => "job_agent_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 1, size => 128 },
+ { data_type => "text", is_nullable => 1 },
"description",
- { data_type => "varchar", is_nullable => 1, size => 512 },
+ { data_type => "text", is_nullable => 1 },
"active",
{ data_type => "integer", default_value => 0, is_nullable => 0 },
"last_updated",
@@ -125,8 +123,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j67ZAM5DidOlp2Pp49bjiQ
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V+a0k9GDm5P2qFfo75RoLw
# 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/d71603a2/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 3ca0a05..895e32a 100644
--- a/traffic_ops/app/lib/Schema/Result/JobResult.pm
+++ b/traffic_ops/app/lib/Schema/Result/JobResult.pm
@@ -44,15 +44,13 @@ __PACKAGE__->table("job_result");
=head2 result
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 48
=head2 description
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 512
=head2 last_updated
@@ -76,9 +74,9 @@ __PACKAGE__->add_columns(
"agent",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"result",
- { data_type => "varchar", is_nullable => 0, size => 48 },
+ { data_type => "text", is_nullable => 0 },
"description",
- { data_type => "varchar", is_nullable => 1, size => 512 },
+ { data_type => "text", is_nullable => 1 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -133,8 +131,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kEkKns8EbsjqQc8VpR9N/w
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NUnA85Q9jjI/gExK42pAzg
# 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/d71603a2/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 e3c5903..5c8a6c3 100644
--- a/traffic_ops/app/lib/Schema/Result/JobStatus.pm
+++ b/traffic_ops/app/lib/Schema/Result/JobStatus.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("job_status");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 48
=head2 description
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 last_updated
@@ -60,9 +58,9 @@ __PACKAGE__->add_columns(
sequence => "job_status_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 1, size => 48 },
+ { data_type => "text", is_nullable => 1 },
"description",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -102,8 +100,8 @@ __PACKAGE__->has_many(
);
-# 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
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2DDDF4SIFehss2fsgvDkjg
# 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/d71603a2/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 848dff0..7a3f171 100644
--- a/traffic_ops/app/lib/Schema/Result/Log.pm
+++ b/traffic_ops/app/lib/Schema/Result/Log.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("log");
=head2 level
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 message
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 1024
=head2 tm_user
@@ -50,9 +48,8 @@ __PACKAGE__->table("log");
=head2 ticketnum
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 64
=head2 last_updated
@@ -72,13 +69,13 @@ __PACKAGE__->add_columns(
sequence => "log_id_seq",
},
"level",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"message",
- { data_type => "varchar", is_nullable => 0, size => 1024 },
+ { data_type => "text", is_nullable => 0 },
"tm_user",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"ticketnum",
- { data_type => "varchar", is_nullable => 1, size => 64 },
+ { data_type => "text", is_nullable => 1 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -120,8 +117,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JBW6m8ZglGpSaWd7LJhsGQ
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/BiMbdnbr6B/YxMPjExknw
# 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/d71603a2/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 a89f633..162c256 100644
--- a/traffic_ops/app/lib/Schema/Result/Parameter.pm
+++ b/traffic_ops/app/lib/Schema/Result/Parameter.pm
@@ -32,21 +32,18 @@ __PACKAGE__->table("parameter");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 1024
=head2 config_file
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 value
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 1024
=head2 last_updated
@@ -72,11 +69,11 @@ __PACKAGE__->add_columns(
sequence => "parameter_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 0, size => 1024 },
+ { data_type => "text", is_nullable => 0 },
"config_file",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"value",
- { data_type => "varchar", is_nullable => 0, size => 1024 },
+ { data_type => "text", is_nullable => 0 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -133,8 +130,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UI2NEBlM9FxffnQSUrnGxg
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q+LUPAwMcqCwAJPKrrmF5Q
# 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/d71603a2/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 25488d2..c7c12e3 100644
--- a/traffic_ops/app/lib/Schema/Result/PhysLocation.pm
+++ b/traffic_ops/app/lib/Schema/Result/PhysLocation.pm
@@ -32,63 +32,53 @@ __PACKAGE__->table("phys_location");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 short_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 12
=head2 address
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 128
=head2 city
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 128
=head2 state
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 2
=head2 zip
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 5
=head2 poc
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 128
=head2 phone
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 email
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 128
=head2 comments
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 region
@@ -114,25 +104,25 @@ __PACKAGE__->add_columns(
sequence => "phys_location_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"short_name",
- { data_type => "varchar", is_nullable => 0, size => 12 },
+ { data_type => "text", is_nullable => 0 },
"address",
- { data_type => "varchar", is_nullable => 0, size => 128 },
+ { data_type => "text", is_nullable => 0 },
"city",
- { data_type => "varchar", is_nullable => 0, size => 128 },
+ { data_type => "text", is_nullable => 0 },
"state",
- { data_type => "varchar", is_nullable => 0, size => 2 },
+ { data_type => "text", is_nullable => 0 },
"zip",
- { data_type => "varchar", is_nullable => 0, size => 5 },
+ { data_type => "text", is_nullable => 0 },
"poc",
- { data_type => "varchar", is_nullable => 1, size => 128 },
+ { data_type => "text", is_nullable => 1 },
"phone",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"email",
- { data_type => "varchar", is_nullable => 1, size => 128 },
+ { data_type => "text", is_nullable => 1 },
"comments",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"region",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
@@ -158,7 +148,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39713_name_unique>
+=head2 C<idx_54431_name_unique>
=over 4
@@ -168,9 +158,9 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("idx_39713_name_unique", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_54431_name_unique", ["name"]);
-=head2 C<idx_39713_short_name_unique>
+=head2 C<idx_54431_short_name_unique>
=over 4
@@ -180,7 +170,7 @@ __PACKAGE__->add_unique_constraint("idx_39713_name_unique", ["name"]);
=cut
-__PACKAGE__->add_unique_constraint("idx_39713_short_name_unique", ["short_name"]);
+__PACKAGE__->add_unique_constraint("idx_54431_short_name_unique", ["short_name"]);
=head1 RELATIONS
@@ -215,8 +205,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qoZbC6exGiOWYVpc4lnPxw
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dfZ3YiJtRAHKueGHNdVM5Q
# 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/d71603a2/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 01504e6..5e7bc7f 100644
--- a/traffic_ops/app/lib/Schema/Result/Profile.pm
+++ b/traffic_ops/app/lib/Schema/Result/Profile.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("profile");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 description
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 last_updated
@@ -60,9 +58,9 @@ __PACKAGE__->add_columns(
sequence => "profile_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"description",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -86,7 +84,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39723_name_unique>
+=head2 C<idx_54441_name_unique>
=over 4
@@ -96,7 +94,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("idx_39723_name_unique", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_54441_name_unique", ["name"]);
=head1 RELATIONS
@@ -146,8 +144,8 @@ __PACKAGE__->has_many(
);
-# 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
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tmTPl52VUdJsn+y6JuSLlw
# 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/d71603a2/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 8d3f886..3ac0997 100644
--- a/traffic_ops/app/lib/Schema/Result/Regex.pm
+++ b/traffic_ops/app/lib/Schema/Result/Regex.pm
@@ -32,10 +32,9 @@ __PACKAGE__->table("regex");
=head2 pattern
- data_type: 'varchar'
+ data_type: 'text'
default_value: (empty string)
is_nullable: 0
- size: 255
=head2 type
@@ -61,7 +60,7 @@ __PACKAGE__->add_columns(
sequence => "regex_id_seq",
},
"pattern",
- { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
+ { data_type => "text", default_value => "", is_nullable => 0 },
"type",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
@@ -89,7 +88,7 @@ __PACKAGE__->set_primary_key("id", "type");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39734_re_id_unique>
+=head2 C<idx_54455_re_id_unique>
=over 4
@@ -99,7 +98,7 @@ __PACKAGE__->set_primary_key("id", "type");
=cut
-__PACKAGE__->add_unique_constraint("idx_39734_re_id_unique", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_54455_re_id_unique", ["id"]);
=head1 RELATIONS
@@ -134,8 +133,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:USUCydmnMZ6Tr0gm/jpVPg
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X7wUtNTSdxNlEUmk9/+XsA
# 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/d71603a2/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 391f7c1..860c782 100644
--- a/traffic_ops/app/lib/Schema/Result/Region.pm
+++ b/traffic_ops/app/lib/Schema/Result/Region.pm
@@ -32,9 +32,8 @@ __PACKAGE__->table("region");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 division
@@ -60,7 +59,7 @@ __PACKAGE__->add_columns(
sequence => "region_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"division",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
@@ -86,7 +85,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39742_name_unique>
+=head2 C<idx_54466_name_unique>
=over 4
@@ -96,7 +95,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("idx_39742_name_unique", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_54466_name_unique", ["name"]);
=head1 RELATIONS
@@ -131,8 +130,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rWahmAZ6JkPd8ankOZ+/5w
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iNYF/M+GNjkelzdbqrqzWA
# 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/d71603a2/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 7e9a7ea..e8d95c7 100644
--- a/traffic_ops/app/lib/Schema/Result/Role.pm
+++ b/traffic_ops/app/lib/Schema/Result/Role.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("role");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 description
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 128
=head2 priv_level
@@ -58,9 +56,9 @@ __PACKAGE__->add_columns(
sequence => "role_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"description",
- { data_type => "varchar", is_nullable => 1, size => 128 },
+ { data_type => "text", is_nullable => 1 },
"priv_level",
{ data_type => "bigint", is_nullable => 0 },
);
@@ -110,8 +108,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SCCjQ7mhGlXAj5JhPtqbnA
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ajSuzHN4h1M8WtwVQkjT8w
# 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/d71603a2/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 baaf7e8..927ddaf 100644
--- a/traffic_ops/app/lib/Schema/Result/Server.pm
+++ b/traffic_ops/app/lib/Schema/Result/Server.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("server");
=head2 host_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 63
=head2 domain_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 63
=head2 tcp_port
@@ -49,51 +47,43 @@ __PACKAGE__->table("server");
=head2 xmpp_id
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 xmpp_passwd
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 interface_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 ip_address
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 ip_netmask
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 ip_gateway
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 ip6_address
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 50
=head2 ip6_gateway
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 50
=head2 interface_mtu
@@ -109,9 +99,8 @@ __PACKAGE__->table("server");
=head2 rack
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 64
=head2 cachegroup
@@ -134,9 +123,8 @@ __PACKAGE__->table("server");
=head2 offline_reason
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 upd_pending
@@ -158,69 +146,58 @@ __PACKAGE__->table("server");
=head2 mgmt_ip_address
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 mgmt_ip_netmask
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 mgmt_ip_gateway
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 ilo_ip_address
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 ilo_ip_netmask
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 ilo_ip_gateway
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 ilo_username
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 ilo_password
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 router_host_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 router_port_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 guid
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 last_updated
@@ -245,33 +222,33 @@ __PACKAGE__->add_columns(
sequence => "server_id_seq",
},
"host_name",
- { data_type => "varchar", is_nullable => 0, size => 63 },
+ { data_type => "text", is_nullable => 0 },
"domain_name",
- { data_type => "varchar", is_nullable => 0, size => 63 },
+ { data_type => "text", is_nullable => 0 },
"tcp_port",
{ data_type => "bigint", is_nullable => 1 },
"xmpp_id",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"xmpp_passwd",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"interface_name",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"ip_address",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"ip_netmask",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"ip_gateway",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"ip6_address",
- { data_type => "varchar", is_nullable => 1, size => 50 },
+ { data_type => "text", is_nullable => 1 },
"ip6_gateway",
- { data_type => "varchar", is_nullable => 1, size => 50 },
+ { data_type => "text", is_nullable => 1 },
"interface_mtu",
{ data_type => "bigint", default_value => 9000, is_nullable => 0 },
"phys_location",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"rack",
- { data_type => "varchar", is_nullable => 1, size => 64 },
+ { data_type => "text", is_nullable => 1 },
"cachegroup",
{
data_type => "bigint",
@@ -284,7 +261,7 @@ __PACKAGE__->add_columns(
"status",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"offline_reason",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"upd_pending",
{ data_type => "boolean", default_value => \"false", is_nullable => 0 },
"profile",
@@ -292,27 +269,27 @@ __PACKAGE__->add_columns(
"cdn_id",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"mgmt_ip_address",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"mgmt_ip_netmask",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"mgmt_ip_gateway",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"ilo_ip_address",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"ilo_ip_netmask",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"ilo_ip_gateway",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"ilo_username",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"ilo_password",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"router_host_name",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"router_port_name",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"guid",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -346,7 +323,7 @@ __PACKAGE__->set_primary_key("id", "cachegroup", "type", "status", "profile");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39755_ip6_profile>
+=head2 C<idx_54485_ip6_profile>
=over 4
@@ -358,9 +335,9 @@ __PACKAGE__->set_primary_key("id", "cachegroup", "type", "status", "profile");
=cut
-__PACKAGE__->add_unique_constraint("idx_39755_ip6_profile", ["ip6_address", "profile"]);
+__PACKAGE__->add_unique_constraint("idx_54485_ip6_profile", ["ip6_address", "profile"]);
-=head2 C<idx_39755_ip_profile>
+=head2 C<idx_54485_ip_profile>
=over 4
@@ -372,9 +349,9 @@ __PACKAGE__->add_unique_constraint("idx_39755_ip6_profile", ["ip6_address", "pro
=cut
-__PACKAGE__->add_unique_constraint("idx_39755_ip_profile", ["ip_address", "profile"]);
+__PACKAGE__->add_unique_constraint("idx_54485_ip_profile", ["ip_address", "profile"]);
-=head2 C<idx_39755_se_id_unique>
+=head2 C<idx_54485_se_id_unique>
=over 4
@@ -384,7 +361,7 @@ __PACKAGE__->add_unique_constraint("idx_39755_ip_profile", ["ip_address", "profi
=cut
-__PACKAGE__->add_unique_constraint("idx_39755_se_id_unique", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_54485_se_id_unique", ["id"]);
=head1 RELATIONS
@@ -524,8 +501,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bW9kYn0q4JnPYnYWFZ8FkA
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3f6+Y6k32Vn3CDG7R7uToQ
# 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/d71603a2/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 9dd11a3..2b4f4d7 100644
--- a/traffic_ops/app/lib/Schema/Result/Servercheck.pm
+++ b/traffic_ops/app/lib/Schema/Result/Servercheck.pm
@@ -297,7 +297,7 @@ __PACKAGE__->set_primary_key("id", "server");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39768_server>
+=head2 C<idx_54498_server>
=over 4
@@ -307,9 +307,9 @@ __PACKAGE__->set_primary_key("id", "server");
=cut
-__PACKAGE__->add_unique_constraint("idx_39768_server", ["server"]);
+__PACKAGE__->add_unique_constraint("idx_54498_server", ["server"]);
-=head2 C<idx_39768_ses_id_unique>
+=head2 C<idx_54498_ses_id_unique>
=over 4
@@ -319,7 +319,7 @@ __PACKAGE__->add_unique_constraint("idx_39768_server", ["server"]);
=cut
-__PACKAGE__->add_unique_constraint("idx_39768_ses_id_unique", ["id"]);
+__PACKAGE__->add_unique_constraint("idx_54498_ses_id_unique", ["id"]);
=head1 RELATIONS
@@ -339,8 +339,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4g66dJwicKC8YDAnG0zZKQ
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GgkEbC3GilmdyYWOguEY7A
# 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/d71603a2/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 758f565..c00b414 100644
--- a/traffic_ops/app/lib/Schema/Result/Staticdnsentry.pm
+++ b/traffic_ops/app/lib/Schema/Result/Staticdnsentry.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("staticdnsentry");
=head2 host
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 address
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 type
@@ -84,9 +82,9 @@ __PACKAGE__->add_columns(
sequence => "staticdnsentry_id_seq",
},
"host",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"address",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"type",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"ttl",
@@ -118,7 +116,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39775_combi_unique>
+=head2 C<idx_54505_combi_unique>
=over 4
@@ -135,7 +133,7 @@ __PACKAGE__->set_primary_key("id");
=cut
__PACKAGE__->add_unique_constraint(
- "idx_39775_combi_unique",
+ "idx_54505_combi_unique",
["host", "address", "deliveryservice", "cachegroup"],
);
@@ -192,8 +190,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d8VZCR5XOk2TlAmgByHkUQ
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g7WdTA+fuHr6rlpFQR6R7w
# 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/d71603a2/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 d33dd14..5db5aad 100644
--- a/traffic_ops/app/lib/Schema/Result/StatsSummary.pm
+++ b/traffic_ops/app/lib/Schema/Result/StatsSummary.pm
@@ -32,22 +32,19 @@ __PACKAGE__->table("stats_summary");
=head2 cdn_name
- data_type: 'varchar'
+ data_type: 'text'
default_value: 'all'
is_nullable: 0
- size: 255
=head2 deliveryservice_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 255
=head2 stat_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 255
=head2 stat_value
@@ -77,16 +74,11 @@ __PACKAGE__->add_columns(
sequence => "stats_summary_id_seq",
},
"cdn_name",
- {
- data_type => "varchar",
- default_value => "all",
- is_nullable => 0,
- size => 255,
- },
+ { data_type => "text", default_value => "all", is_nullable => 0 },
"deliveryservice_name",
- { data_type => "varchar", is_nullable => 0, size => 255 },
+ { data_type => "text", is_nullable => 0 },
"stat_name",
- { data_type => "varchar", is_nullable => 0, size => 255 },
+ { data_type => "text", is_nullable => 0 },
"stat_value",
{ data_type => "double precision", is_nullable => 0 },
"summary_time",
@@ -113,8 +105,8 @@ __PACKAGE__->add_columns(
__PACKAGE__->set_primary_key("id");
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+WiXimw9L6Qs/RIkuW4g5A
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1osLwbS/Nzx/0LXJcCmZcA
# 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/d71603a2/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 f5532be..40e8b0b 100644
--- a/traffic_ops/app/lib/Schema/Result/Status.pm
+++ b/traffic_ops/app/lib/Schema/Result/Status.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("status");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 description
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 last_updated
@@ -60,9 +58,9 @@ __PACKAGE__->add_columns(
sequence => "status_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"description",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -102,8 +100,8 @@ __PACKAGE__->has_many(
);
-# 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
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UlN38sejUcrmLULxoiaUVA
# 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/d71603a2/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 e13de2b..bc0abc9 100644
--- a/traffic_ops/app/lib/Schema/Result/TmUser.pm
+++ b/traffic_ops/app/lib/Schema/Result/TmUser.pm
@@ -32,15 +32,13 @@ __PACKAGE__->table("tm_user");
=head2 username
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 128
=head2 public_ssh_key
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 2048
=head2 role
@@ -60,15 +58,13 @@ __PACKAGE__->table("tm_user");
=head2 local_passwd
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 40
=head2 confirm_local_passwd
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 40
=head2 last_updated
@@ -79,21 +75,18 @@ __PACKAGE__->table("tm_user");
=head2 company
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 email
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 128
=head2 full_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 new_user
@@ -103,51 +96,43 @@ __PACKAGE__->table("tm_user");
=head2 address_line1
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 address_line2
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 city
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 128
=head2 state_or_province
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 128
=head2 phone_number
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 25
=head2 postal_code
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 11
=head2 country
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 token
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 50
=head2 registration_sent
@@ -165,9 +150,9 @@ __PACKAGE__->add_columns(
sequence => "tm_user_id_seq",
},
"username",
- { data_type => "varchar", is_nullable => 1, size => 128 },
+ { data_type => "text", is_nullable => 1 },
"public_ssh_key",
- { data_type => "varchar", is_nullable => 1, size => 2048 },
+ { data_type => "text", is_nullable => 1 },
"role",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 1 },
"uid",
@@ -175,9 +160,9 @@ __PACKAGE__->add_columns(
"gid",
{ data_type => "bigint", is_nullable => 1 },
"local_passwd",
- { data_type => "varchar", is_nullable => 1, size => 40 },
+ { data_type => "text", is_nullable => 1 },
"confirm_local_passwd",
- { data_type => "varchar", is_nullable => 1, size => 40 },
+ { data_type => "text", is_nullable => 1 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -186,29 +171,29 @@ __PACKAGE__->add_columns(
original => { default_value => \"now()" },
},
"company",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"email",
- { data_type => "varchar", is_nullable => 1, size => 128 },
+ { data_type => "text", is_nullable => 1 },
"full_name",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"new_user",
{ data_type => "boolean", default_value => \"false", is_nullable => 0 },
"address_line1",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"address_line2",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"city",
- { data_type => "varchar", is_nullable => 1, size => 128 },
+ { data_type => "text", is_nullable => 1 },
"state_or_province",
- { data_type => "varchar", is_nullable => 1, size => 128 },
+ { data_type => "text", is_nullable => 1 },
"phone_number",
- { data_type => "varchar", is_nullable => 1, size => 25 },
+ { data_type => "text", is_nullable => 1 },
"postal_code",
- { data_type => "varchar", is_nullable => 1, size => 11 },
+ { data_type => "text", is_nullable => 1 },
"country",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"token",
- { data_type => "varchar", is_nullable => 1, size => 50 },
+ { data_type => "text", is_nullable => 1 },
"registration_sent",
{ data_type => "timestamp with time zone", is_nullable => 1 },
);
@@ -227,7 +212,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39805_tmuser_email_unique>
+=head2 C<idx_54541_tmuser_email_unique>
=over 4
@@ -237,9 +222,9 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("idx_39805_tmuser_email_unique", ["email"]);
+__PACKAGE__->add_unique_constraint("idx_54541_tmuser_email_unique", ["email"]);
-=head2 C<idx_39805_username_unique>
+=head2 C<idx_54541_username_unique>
=over 4
@@ -249,7 +234,7 @@ __PACKAGE__->add_unique_constraint("idx_39805_tmuser_email_unique", ["email"]);
=cut
-__PACKAGE__->add_unique_constraint("idx_39805_username_unique", ["username"]);
+__PACKAGE__->add_unique_constraint("idx_54541_username_unique", ["username"]);
=head1 RELATIONS
@@ -334,8 +319,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rWwMHJlmbMYgX/L4y51AWA
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SGrZkCGhmXed7UzWMLYfOg
# 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/d71603a2/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 45514ea..3bd1ad6 100644
--- a/traffic_ops/app/lib/Schema/Result/ToExtension.pm
+++ b/traffic_ops/app/lib/Schema/Result/ToExtension.pm
@@ -32,27 +32,23 @@ __PACKAGE__->table("to_extension");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 version
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 info_url
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 script_file
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 isactive
@@ -62,27 +58,23 @@ __PACKAGE__->table("to_extension");
=head2 additional_config_json
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 4096
=head2 description
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 4096
=head2 servercheck_short_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 8
=head2 servercheck_column_name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 10
=head2 type
@@ -108,23 +100,23 @@ __PACKAGE__->add_columns(
sequence => "to_extension_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"version",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"info_url",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"script_file",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"isactive",
{ data_type => "boolean", default_value => \"false", is_nullable => 0 },
"additional_config_json",
- { data_type => "varchar", is_nullable => 1, size => 4096 },
+ { data_type => "text", is_nullable => 1 },
"description",
- { data_type => "varchar", is_nullable => 1, size => 4096 },
+ { data_type => "text", is_nullable => 1 },
"servercheck_short_name",
- { data_type => "varchar", is_nullable => 1, size => 8 },
+ { data_type => "text", is_nullable => 1 },
"servercheck_column_name",
- { data_type => "varchar", is_nullable => 1, size => 10 },
+ { data_type => "text", is_nullable => 1 },
"type",
{ data_type => "bigint", is_foreign_key => 1, is_nullable => 0 },
"last_updated",
@@ -166,8 +158,8 @@ __PACKAGE__->belongs_to(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:au23HlVhC3y3hHGJ4cOUvQ
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rU86iSqXwU3lUEx55uNTIQ
# 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/d71603a2/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 70a7973..97fcacf 100644
--- a/traffic_ops/app/lib/Schema/Result/Type.pm
+++ b/traffic_ops/app/lib/Schema/Result/Type.pm
@@ -32,21 +32,18 @@ __PACKAGE__->table("type");
=head2 name
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 0
- size: 45
=head2 description
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 256
=head2 use_in_table
- data_type: 'varchar'
+ data_type: 'text'
is_nullable: 1
- size: 45
=head2 last_updated
@@ -66,11 +63,11 @@ __PACKAGE__->add_columns(
sequence => "type_id_seq",
},
"name",
- { data_type => "varchar", is_nullable => 0, size => 45 },
+ { data_type => "text", is_nullable => 0 },
"description",
- { data_type => "varchar", is_nullable => 1, size => 256 },
+ { data_type => "text", is_nullable => 1 },
"use_in_table",
- { data_type => "varchar", is_nullable => 1, size => 45 },
+ { data_type => "text", is_nullable => 1 },
"last_updated",
{
data_type => "timestamp with time zone",
@@ -94,7 +91,7 @@ __PACKAGE__->set_primary_key("id");
=head1 UNIQUE CONSTRAINTS
-=head2 C<idx_39826_name_unique>
+=head2 C<idx_54562_name_unique>
=over 4
@@ -104,7 +101,7 @@ __PACKAGE__->set_primary_key("id");
=cut
-__PACKAGE__->add_unique_constraint("idx_39826_name_unique", ["name"]);
+__PACKAGE__->add_unique_constraint("idx_54562_name_unique", ["name"]);
=head1 RELATIONS
@@ -214,8 +211,8 @@ __PACKAGE__->has_many(
);
-# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-11-15 09:35:47
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6/jizJUQmkHwt9g7bIOZRA
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2016-11-18 22:45:19
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JIvzUMeCc2ZVQpQLxITmHQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
[2/2] incubator-trafficcontrol git commit: This closes #97
Posted by mi...@apache.org.
This closes #97
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/03050733
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/03050733
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/03050733
Branch: refs/heads/psql-rebase
Commit: 03050733618ce3a94e595e30d339dde77a3ac7b7
Parents: d71603a
Author: Jeremy Mitchell <mi...@gmail.com>
Authored: Fri Nov 18 16:00:12 2016 -0700
Committer: Jeremy Mitchell <mi...@gmail.com>
Committed: Fri Nov 18 16:00:12 2016 -0700
----------------------------------------------------------------------
----------------------------------------------------------------------