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/14 17:07:27 UTC
[24/53] [abbrv] incubator-trafficcontrol git commit: renames
migration to be at the end of the migration list
renames migration to be at the end of the migration list
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/7a7575da
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/7a7575da
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/7a7575da
Branch: refs/heads/psql-rebase
Commit: 7a7575da4dd8d4218febd7893e73622677c00173
Parents: e363f58
Author: Jeremy Mitchell <mi...@gmail.com>
Authored: Thu Sep 22 10:54:10 2016 -0600
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Fri Nov 11 13:53:57 2016 -0700
----------------------------------------------------------------------
.../20160808092026_fix_column_types.sql | 77 --------------------
.../20160910092026_fix_column_types.sql | 77 ++++++++++++++++++++
2 files changed, 77 insertions(+), 77 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/7a7575da/traffic_ops/app/db/migrations/20160808092026_fix_column_types.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160808092026_fix_column_types.sql b/traffic_ops/app/db/migrations/20160808092026_fix_column_types.sql
deleted file mode 100644
index f764311..0000000
--- a/traffic_ops/app/db/migrations/20160808092026_fix_column_types.sql
+++ /dev/null
@@ -1,77 +0,0 @@
-
--- +goose Up
--- SQL in section 'Up' is executed when this migration is applied
-
-ALTER TABLE cachegroup ALTER COLUMN latitude TYPE numeric;
-ALTER TABLE cachegroup ALTER COLUMN longitude TYPE numeric;
-
-ALTER TABLE deliveryservice ALTER COLUMN signed TYPE smallint USING (signed::int::smallint);
-ALTER TABLE deliveryservice ALTER COLUMN qstring_ignore TYPE smallint USING (qstring_ignore::int::smallint);
-
-ALTER TABLE deliveryservice
- ALTER COLUMN geo_limit DROP DEFAULT,
- ALTER COLUMN geo_limit TYPE smallint USING (geo_limit::int::smallint),
- ALTER COLUMN geo_limit SET DEFAULT '0';
-
-ALTER TABLE deliveryservice ALTER COLUMN miss_lat TYPE numeric;
-ALTER TABLE deliveryservice ALTER COLUMN miss_long TYPE numeric;
-ALTER TABLE deliveryservice ALTER COLUMN multi_site_origin TYPE smallint USING (multi_site_origin::int::smallint);
-ALTER TABLE deliveryservice ALTER COLUMN regional_geo_blocking TYPE smallint USING (regional_geo_blocking::int::smallint);
-ALTER TABLE deliveryservice ALTER COLUMN logs_enabled TYPE smallint USING (logs_enabled::int::smallint);
-ALTER TABLE deliveryservice ALTER COLUMN multi_site_origin_algorithm TYPE smallint USING (multi_site_origin_algorithm::int::smallint);
-
-ALTER TABLE parameter
- ALTER COLUMN secure DROP DEFAULT,
- ALTER COLUMN secure TYPE smallint USING (secure::int::smallint),
- ALTER COLUMN secure SET DEFAULT '0';
-
-ALTER TABLE server
- ALTER COLUMN upd_pending DROP DEFAULT,
- ALTER COLUMN upd_pending TYPE smallint USING (upd_pending::int::smallint),
- ALTER COLUMN upd_pending SET DEFAULT '0';
-
-ALTER TABLE tm_user
- ALTER COLUMN new_user DROP DEFAULT,
- ALTER COLUMN new_user TYPE smallint USING (new_user::int::smallint),
- ALTER COLUMN new_user SET DEFAULT '1';
-
-ALTER TABLE to_extension ALTER COLUMN isactive TYPE smallint USING (isactive::int::smallint);
-
-
-
--- +goose Down
--- SQL section 'Down' is executed when this migration is rolled back
-
-ALTER TABLE cachegroup ALTER COLUMN latitude TYPE double precision;
-ALTER TABLE cachegroup ALTER COLUMN longitude TYPE double precision;
-
-ALTER TABLE deliveryservice ALTER COLUMN signed TYPE boolean USING (signed::int::boolean);
-ALTER TABLE deliveryservice ALTER COLUMN qstring_ignore TYPE boolean USING (qstring_ignore::int::boolean);
-
-ALTER TABLE deliveryservice
- ALTER COLUMN geo_limit DROP DEFAULT,
- ALTER COLUMN geo_limit TYPE boolean USING (geo_limit::int::boolean),
- ALTER COLUMN geo_limit SET DEFAULT FALSE;
-
-ALTER TABLE deliveryservice ALTER COLUMN miss_lat TYPE double precision;
-ALTER TABLE deliveryservice ALTER COLUMN miss_long TYPE double precision;
-ALTER TABLE deliveryservice ALTER COLUMN multi_site_origin TYPE boolean USING (multi_site_origin::int::boolean);
-ALTER TABLE deliveryservice ALTER COLUMN regional_geo_blocking TYPE boolean USING (regional_geo_blocking::int::boolean);
-ALTER TABLE deliveryservice ALTER COLUMN multi_site_origin_algorithm TYPE boolean USING (multi_site_origin_algorithm::int::boolean);
-
-ALTER TABLE parameter
- ALTER COLUMN secure DROP DEFAULT,
- ALTER COLUMN secure TYPE boolean USING (secure::int::boolean),
- ALTER COLUMN secure SET DEFAULT FALSE;
-
-ALTER TABLE server
- ALTER COLUMN upd_pending DROP DEFAULT,
- ALTER COLUMN upd_pending TYPE boolean USING (upd_pending::int::boolean),
- ALTER COLUMN upd_pending SET DEFAULT FALSE;
-
-ALTER TABLE tm_user
- ALTER COLUMN new_user DROP DEFAULT,
- ALTER COLUMN new_user TYPE boolean USING (new_user::int::boolean),
- ALTER COLUMN new_user SET DEFAULT TRUE;
-
-ALTER TABLE to_extension ALTER COLUMN isactive TYPE boolean USING (isactive::int::boolean);
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/7a7575da/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql b/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql
new file mode 100644
index 0000000..f764311
--- /dev/null
+++ b/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql
@@ -0,0 +1,77 @@
+
+-- +goose Up
+-- SQL in section 'Up' is executed when this migration is applied
+
+ALTER TABLE cachegroup ALTER COLUMN latitude TYPE numeric;
+ALTER TABLE cachegroup ALTER COLUMN longitude TYPE numeric;
+
+ALTER TABLE deliveryservice ALTER COLUMN signed TYPE smallint USING (signed::int::smallint);
+ALTER TABLE deliveryservice ALTER COLUMN qstring_ignore TYPE smallint USING (qstring_ignore::int::smallint);
+
+ALTER TABLE deliveryservice
+ ALTER COLUMN geo_limit DROP DEFAULT,
+ ALTER COLUMN geo_limit TYPE smallint USING (geo_limit::int::smallint),
+ ALTER COLUMN geo_limit SET DEFAULT '0';
+
+ALTER TABLE deliveryservice ALTER COLUMN miss_lat TYPE numeric;
+ALTER TABLE deliveryservice ALTER COLUMN miss_long TYPE numeric;
+ALTER TABLE deliveryservice ALTER COLUMN multi_site_origin TYPE smallint USING (multi_site_origin::int::smallint);
+ALTER TABLE deliveryservice ALTER COLUMN regional_geo_blocking TYPE smallint USING (regional_geo_blocking::int::smallint);
+ALTER TABLE deliveryservice ALTER COLUMN logs_enabled TYPE smallint USING (logs_enabled::int::smallint);
+ALTER TABLE deliveryservice ALTER COLUMN multi_site_origin_algorithm TYPE smallint USING (multi_site_origin_algorithm::int::smallint);
+
+ALTER TABLE parameter
+ ALTER COLUMN secure DROP DEFAULT,
+ ALTER COLUMN secure TYPE smallint USING (secure::int::smallint),
+ ALTER COLUMN secure SET DEFAULT '0';
+
+ALTER TABLE server
+ ALTER COLUMN upd_pending DROP DEFAULT,
+ ALTER COLUMN upd_pending TYPE smallint USING (upd_pending::int::smallint),
+ ALTER COLUMN upd_pending SET DEFAULT '0';
+
+ALTER TABLE tm_user
+ ALTER COLUMN new_user DROP DEFAULT,
+ ALTER COLUMN new_user TYPE smallint USING (new_user::int::smallint),
+ ALTER COLUMN new_user SET DEFAULT '1';
+
+ALTER TABLE to_extension ALTER COLUMN isactive TYPE smallint USING (isactive::int::smallint);
+
+
+
+-- +goose Down
+-- SQL section 'Down' is executed when this migration is rolled back
+
+ALTER TABLE cachegroup ALTER COLUMN latitude TYPE double precision;
+ALTER TABLE cachegroup ALTER COLUMN longitude TYPE double precision;
+
+ALTER TABLE deliveryservice ALTER COLUMN signed TYPE boolean USING (signed::int::boolean);
+ALTER TABLE deliveryservice ALTER COLUMN qstring_ignore TYPE boolean USING (qstring_ignore::int::boolean);
+
+ALTER TABLE deliveryservice
+ ALTER COLUMN geo_limit DROP DEFAULT,
+ ALTER COLUMN geo_limit TYPE boolean USING (geo_limit::int::boolean),
+ ALTER COLUMN geo_limit SET DEFAULT FALSE;
+
+ALTER TABLE deliveryservice ALTER COLUMN miss_lat TYPE double precision;
+ALTER TABLE deliveryservice ALTER COLUMN miss_long TYPE double precision;
+ALTER TABLE deliveryservice ALTER COLUMN multi_site_origin TYPE boolean USING (multi_site_origin::int::boolean);
+ALTER TABLE deliveryservice ALTER COLUMN regional_geo_blocking TYPE boolean USING (regional_geo_blocking::int::boolean);
+ALTER TABLE deliveryservice ALTER COLUMN multi_site_origin_algorithm TYPE boolean USING (multi_site_origin_algorithm::int::boolean);
+
+ALTER TABLE parameter
+ ALTER COLUMN secure DROP DEFAULT,
+ ALTER COLUMN secure TYPE boolean USING (secure::int::boolean),
+ ALTER COLUMN secure SET DEFAULT FALSE;
+
+ALTER TABLE server
+ ALTER COLUMN upd_pending DROP DEFAULT,
+ ALTER COLUMN upd_pending TYPE boolean USING (upd_pending::int::boolean),
+ ALTER COLUMN upd_pending SET DEFAULT FALSE;
+
+ALTER TABLE tm_user
+ ALTER COLUMN new_user DROP DEFAULT,
+ ALTER COLUMN new_user TYPE boolean USING (new_user::int::boolean),
+ ALTER COLUMN new_user SET DEFAULT TRUE;
+
+ALTER TABLE to_extension ALTER COLUMN isactive TYPE boolean USING (isactive::int::boolean);