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/12/06 05:21:27 UTC
[3/6] incubator-trafficcontrol git commit: license for sql files
license for sql files
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/12ab333a
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/12ab333a
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/12ab333a
Branch: refs/heads/psql-rebase
Commit: 12ab333ac8f25017371ecf6180abefa00f319ed1
Parents: e377589
Author: Dan Kirkwood <da...@gmail.com>
Authored: Mon Dec 5 22:10:45 2016 +0000
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Mon Dec 5 22:10:45 2016 +0000
----------------------------------------------------------------------
.rat-excludes | 1 -
traffic_ops/app/db/create_tables.sql | 15 +++++++++++++++
.../migrations/20150504100001_add_param_index.sql | 15 +++++++++++++++
.../20150706084134_stats_summary_table.sql | 15 +++++++++++++++
.../db/migrations/20150721000000_add_stat_date.sql | 15 +++++++++++++++
.../migrations/20151020143912_unique_cdn_name.sql | 15 +++++++++++++++
.../20151027152323_tr_request_headers.sql | 15 +++++++++++++++
.../20151107000000_cdn_dnssec_enabled.sql | 15 +++++++++++++++
.../db/migrations/20151207000000_unique_email.sql | 15 +++++++++++++++
.../migrations/20160526140027_add_deploy_role.sql | 15 +++++++++++++++
.../migrations/20160603084204_add_logs_enabled.sql | 15 +++++++++++++++
.../app/db/migrations/20160613153313_add_guid.sql | 15 +++++++++++++++
.../20160809092015_update_serverchecks.sql | 15 +++++++++++++++
.../20160817171741_server_add_https_port.sql | 17 ++++++++++++++++-
.../20160909141413_add_offline_reason.sql | 15 +++++++++++++++
traffic_ops/experimental/server/db/schema.sql | 15 +++++++++++++++
.../server/tools/db/migrations/initial_cleanup.sql | 15 +++++++++++++++
.../experimental/traffic_ops_auth/schema.sql | 15 +++++++++++++++
18 files changed, 256 insertions(+), 2 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/.rat-excludes
----------------------------------------------------------------------
diff --git a/.rat-excludes b/.rat-excludes
index 6b785de..f2e604c 100644
--- a/.rat-excludes
+++ b/.rat-excludes
@@ -13,7 +13,6 @@ profiles
.*.json
.*.cfg
.*.conf
-.*.sql
.*.js
jquery.*
jMenu.*
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/create_tables.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/create_tables.sql b/traffic_ops/app/db/create_tables.sql
index a0e79d9..f37931c 100644
--- a/traffic_ops/app/db/create_tables.sql
+++ b/traffic_ops/app/db/create_tables.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
-- MySQL dump 10.13 Distrib 5.6.19, for osx10.9 (x86_64)
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20150504100001_add_param_index.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20150504100001_add_param_index.sql b/traffic_ops/app/db/migrations/20150504100001_add_param_index.sql
index e170cd6..bf98f00 100644
--- a/traffic_ops/app/db/migrations/20150504100001_add_param_index.sql
+++ b/traffic_ops/app/db/migrations/20150504100001_add_param_index.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
create index parameter_name_value_idx on parameter (name(512),value(512));
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20150706084134_stats_summary_table.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20150706084134_stats_summary_table.sql b/traffic_ops/app/db/migrations/20150706084134_stats_summary_table.sql
index 7a53b49..9fefeb9 100644
--- a/traffic_ops/app/db/migrations/20150706084134_stats_summary_table.sql
+++ b/traffic_ops/app/db/migrations/20150706084134_stats_summary_table.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
CREATE TABLE stats_summary
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20150721000000_add_stat_date.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20150721000000_add_stat_date.sql b/traffic_ops/app/db/migrations/20150721000000_add_stat_date.sql
index 8a7a4fd..c6c8550 100644
--- a/traffic_ops/app/db/migrations/20150721000000_add_stat_date.sql
+++ b/traffic_ops/app/db/migrations/20150721000000_add_stat_date.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
alter table stats_summary add column stat_date date;
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20151020143912_unique_cdn_name.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20151020143912_unique_cdn_name.sql b/traffic_ops/app/db/migrations/20151020143912_unique_cdn_name.sql
index c963f05..95e2427 100644
--- a/traffic_ops/app/db/migrations/20151020143912_unique_cdn_name.sql
+++ b/traffic_ops/app/db/migrations/20151020143912_unique_cdn_name.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20151027152323_tr_request_headers.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20151027152323_tr_request_headers.sql b/traffic_ops/app/db/migrations/20151027152323_tr_request_headers.sql
index f0b7d88..d2136b6 100644
--- a/traffic_ops/app/db/migrations/20151027152323_tr_request_headers.sql
+++ b/traffic_ops/app/db/migrations/20151027152323_tr_request_headers.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20151107000000_cdn_dnssec_enabled.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20151107000000_cdn_dnssec_enabled.sql b/traffic_ops/app/db/migrations/20151107000000_cdn_dnssec_enabled.sql
index e6441f3..72c3bb3 100644
--- a/traffic_ops/app/db/migrations/20151107000000_cdn_dnssec_enabled.sql
+++ b/traffic_ops/app/db/migrations/20151107000000_cdn_dnssec_enabled.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20151207000000_unique_email.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20151207000000_unique_email.sql b/traffic_ops/app/db/migrations/20151207000000_unique_email.sql
index 6889659..a580e9a 100644
--- a/traffic_ops/app/db/migrations/20151207000000_unique_email.sql
+++ b/traffic_ops/app/db/migrations/20151207000000_unique_email.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20160526140027_add_deploy_role.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160526140027_add_deploy_role.sql b/traffic_ops/app/db/migrations/20160526140027_add_deploy_role.sql
index 19649d7..29f2401 100644
--- a/traffic_ops/app/db/migrations/20160526140027_add_deploy_role.sql
+++ b/traffic_ops/app/db/migrations/20160526140027_add_deploy_role.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20160603084204_add_logs_enabled.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160603084204_add_logs_enabled.sql b/traffic_ops/app/db/migrations/20160603084204_add_logs_enabled.sql
index 0c4fbd6..412785a 100644
--- a/traffic_ops/app/db/migrations/20160603084204_add_logs_enabled.sql
+++ b/traffic_ops/app/db/migrations/20160603084204_add_logs_enabled.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20160613153313_add_guid.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160613153313_add_guid.sql b/traffic_ops/app/db/migrations/20160613153313_add_guid.sql
index 7b2a848..6007f52 100644
--- a/traffic_ops/app/db/migrations/20160613153313_add_guid.sql
+++ b/traffic_ops/app/db/migrations/20160613153313_add_guid.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20160809092015_update_serverchecks.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160809092015_update_serverchecks.sql b/traffic_ops/app/db/migrations/20160809092015_update_serverchecks.sql
index 60435b5..74eb294 100644
--- a/traffic_ops/app/db/migrations/20160809092015_update_serverchecks.sql
+++ b/traffic_ops/app/db/migrations/20160809092015_update_serverchecks.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20160817171741_server_add_https_port.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160817171741_server_add_https_port.sql b/traffic_ops/app/db/migrations/20160817171741_server_add_https_port.sql
index b7bb9fd..b77163d 100644
--- a/traffic_ops/app/db/migrations/20160817171741_server_add_https_port.sql
+++ b/traffic_ops/app/db/migrations/20160817171741_server_add_https_port.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
@@ -5,4 +20,4 @@ alter table server add https_port int(10) unsigned default NULL;
-- +goose Down
-- SQL section 'Down' is executed when this migration is rolled back
-alter table server drop column https_port;
\ No newline at end of file
+alter table server drop column https_port;
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/app/db/migrations/20160909141413_add_offline_reason.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160909141413_add_offline_reason.sql b/traffic_ops/app/db/migrations/20160909141413_add_offline_reason.sql
index 5373080..b118a4c 100644
--- a/traffic_ops/app/db/migrations/20160909141413_add_offline_reason.sql
+++ b/traffic_ops/app/db/migrations/20160909141413_add_offline_reason.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/experimental/server/db/schema.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/experimental/server/db/schema.sql b/traffic_ops/experimental/server/db/schema.sql
index db3e736..6dbedbc 100644
--- a/traffic_ops/experimental/server/db/schema.sql
+++ b/traffic_ops/experimental/server/db/schema.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
--
-- PostgreSQL database dump
--
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/experimental/server/tools/db/migrations/initial_cleanup.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/experimental/server/tools/db/migrations/initial_cleanup.sql b/traffic_ops/experimental/server/tools/db/migrations/initial_cleanup.sql
index 0d00acb..e9640ce 100644
--- a/traffic_ops/experimental/server/tools/db/migrations/initial_cleanup.sql
+++ b/traffic_ops/experimental/server/tools/db/migrations/initial_cleanup.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
alter table server rename column cdn_id to cdn;
alter table deliveryservice rename column cdn_id to cdn;
alter table deliveryservice_tmuser rename column tm_user_id to tm_user;
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/12ab333a/traffic_ops/experimental/traffic_ops_auth/schema.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/experimental/traffic_ops_auth/schema.sql b/traffic_ops/experimental/traffic_ops_auth/schema.sql
index b8723b7..d8fbb15 100644
--- a/traffic_ops/experimental/traffic_ops_auth/schema.sql
+++ b/traffic_ops/experimental/traffic_ops_auth/schema.sql
@@ -1,3 +1,18 @@
+/*
+
+ Licensed 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.
+*/
+
CREATE TABLE IF NOT EXISTS traffic_ops_auth_users (
username text PRIMARY KEY,
hash text NOT NULL,