From 6d336cd537cd88f4813d3168e0614812af5e0a5f Mon Sep 17 00:00:00 2001 From: lresende Date: Thu, 30 Oct 2008 16:49:05 +0000 Subject: Adding proper eol-style configuration for sql files and updating the existing ones with this configuration git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@709204 13f79535-47bb-0310-9956-ffa450edef68 --- java/etc/svn-props | 1 + java/sca/modules/implementation-das/company.sql | 54 ++++++++-------- .../modules/implementation-data-xml/company.sql | 54 ++++++++-------- .../tutorials/store/assets/services/db/cart.sql | 54 ++++++++-------- .../www-services/catalog-amazon/store-db/store.sql | 72 +++++++++++----------- 5 files changed, 118 insertions(+), 117 deletions(-) (limited to 'java') diff --git a/java/etc/svn-props b/java/etc/svn-props index 163dfaed03..38aa41c515 100644 --- a/java/etc/svn-props +++ b/java/etc/svn-props @@ -53,3 +53,4 @@ Makefile = svn:eol-style=native sca.subsystem = svn:eol-style=native;svn:mime-type=text/xml DISCLAIMER = svn:eol-style=native;svn:mime-type=text/plain *.composite = svn:mime-type=text/xml;svn:eol-style=native;svn:keywords=Rev Date +*.sql = svn:eol-style=native diff --git a/java/sca/modules/implementation-das/company.sql b/java/sca/modules/implementation-das/company.sql index 4911f9e62f..e9f8b06901 100644 --- a/java/sca/modules/implementation-das/company.sql +++ b/java/sca/modules/implementation-das/company.sql @@ -1,28 +1,28 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, --- software distributed under the License is distributed on an --- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY --- KIND, either express or implied. See the License for the --- specific language governing permissions and limitations --- under the License. --- - -DROP TABLE COMPANY; - -CREATE TABLE COMPANY ( - ID INT PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY, - NAME VARCHAR(30)); - -INSERT INTO COMPANY (NAME) VALUES('ACME Publishing'); -INSERT INTO COMPANY (NAME) VALUES('Do-rite plumbing'); +-- +-- Licensed to the Apache Software Foundation (ASF) under one +-- or more contributor license agreements. See the NOTICE file +-- distributed with this work for additional information +-- regarding copyright ownership. The ASF licenses this file +-- to you under the Apache License, Version 2.0 (the +-- "License"); you may not use this file except in compliance +-- with the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, +-- software distributed under the License is distributed on an +-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +-- KIND, either express or implied. See the License for the +-- specific language governing permissions and limitations +-- under the License. +-- + +DROP TABLE COMPANY; + +CREATE TABLE COMPANY ( + ID INT PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY, + NAME VARCHAR(30)); + +INSERT INTO COMPANY (NAME) VALUES('ACME Publishing'); +INSERT INTO COMPANY (NAME) VALUES('Do-rite plumbing'); INSERT INTO COMPANY (NAME) VALUES('MegaCorp'); \ No newline at end of file diff --git a/java/sca/modules/implementation-data-xml/company.sql b/java/sca/modules/implementation-data-xml/company.sql index 4911f9e62f..e9f8b06901 100644 --- a/java/sca/modules/implementation-data-xml/company.sql +++ b/java/sca/modules/implementation-data-xml/company.sql @@ -1,28 +1,28 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, --- software distributed under the License is distributed on an --- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY --- KIND, either express or implied. See the License for the --- specific language governing permissions and limitations --- under the License. --- - -DROP TABLE COMPANY; - -CREATE TABLE COMPANY ( - ID INT PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY, - NAME VARCHAR(30)); - -INSERT INTO COMPANY (NAME) VALUES('ACME Publishing'); -INSERT INTO COMPANY (NAME) VALUES('Do-rite plumbing'); +-- +-- Licensed to the Apache Software Foundation (ASF) under one +-- or more contributor license agreements. See the NOTICE file +-- distributed with this work for additional information +-- regarding copyright ownership. The ASF licenses this file +-- to you under the Apache License, Version 2.0 (the +-- "License"); you may not use this file except in compliance +-- with the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, +-- software distributed under the License is distributed on an +-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +-- KIND, either express or implied. See the License for the +-- specific language governing permissions and limitations +-- under the License. +-- + +DROP TABLE COMPANY; + +CREATE TABLE COMPANY ( + ID INT PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY, + NAME VARCHAR(30)); + +INSERT INTO COMPANY (NAME) VALUES('ACME Publishing'); +INSERT INTO COMPANY (NAME) VALUES('Do-rite plumbing'); INSERT INTO COMPANY (NAME) VALUES('MegaCorp'); \ No newline at end of file diff --git a/java/sca/tutorials/store/assets/services/db/cart.sql b/java/sca/tutorials/store/assets/services/db/cart.sql index 25f16cb36b..750e23ebde 100644 --- a/java/sca/tutorials/store/assets/services/db/cart.sql +++ b/java/sca/tutorials/store/assets/services/db/cart.sql @@ -1,27 +1,27 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, --- software distributed under the License is distributed on an --- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY --- KIND, either express or implied. See the License for the --- specific language governing permissions and limitations --- under the License. --- - -DROP TABLE CART; - -CREATE TABLE CART( - id VARCHAR(50) NOT NULL, - name VARCHAR(50), - price VARCHAR(10), - primary key (id) -); +-- +-- Licensed to the Apache Software Foundation (ASF) under one +-- or more contributor license agreements. See the NOTICE file +-- distributed with this work for additional information +-- regarding copyright ownership. The ASF licenses this file +-- to you under the Apache License, Version 2.0 (the +-- "License"); you may not use this file except in compliance +-- with the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, +-- software distributed under the License is distributed on an +-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +-- KIND, either express or implied. See the License for the +-- specific language governing permissions and limitations +-- under the License. +-- + +DROP TABLE CART; + +CREATE TABLE CART( + id VARCHAR(50) NOT NULL, + name VARCHAR(50), + price VARCHAR(10), + primary key (id) +); diff --git a/java/sca/tutorials/store/www-services/catalog-amazon/store-db/store.sql b/java/sca/tutorials/store/www-services/catalog-amazon/store-db/store.sql index 4c3186abe9..904fab3ce3 100644 --- a/java/sca/tutorials/store/www-services/catalog-amazon/store-db/store.sql +++ b/java/sca/tutorials/store/www-services/catalog-amazon/store-db/store.sql @@ -1,37 +1,37 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, --- software distributed under the License is distributed on an --- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY --- KIND, either express or implied. See the License for the --- specific language governing permissions and limitations --- under the License. --- - -DROP TABLE CATALOG; - -CREATE TABLE CATALOG( - id NUMERIC(5 , 0) NOT NULL, - product_name VARCHAR(30), - currency_code CHAR(3), - price REAL, - primary key (id) -); - - - -INSERT INTO CATALOG - VALUES(0,'Apple', 'USD', 2.99); -INSERT INTO CATALOG - VALUES(1,'Orange', 'USD', 3.55); -INSERT INTO CATALOG +-- +-- Licensed to the Apache Software Foundation (ASF) under one +-- or more contributor license agreements. See the NOTICE file +-- distributed with this work for additional information +-- regarding copyright ownership. The ASF licenses this file +-- to you under the Apache License, Version 2.0 (the +-- "License"); you may not use this file except in compliance +-- with the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, +-- software distributed under the License is distributed on an +-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +-- KIND, either express or implied. See the License for the +-- specific language governing permissions and limitations +-- under the License. +-- + +DROP TABLE CATALOG; + +CREATE TABLE CATALOG( + id NUMERIC(5 , 0) NOT NULL, + product_name VARCHAR(30), + currency_code CHAR(3), + price REAL, + primary key (id) +); + + + +INSERT INTO CATALOG + VALUES(0,'Apple', 'USD', 2.99); +INSERT INTO CATALOG + VALUES(1,'Orange', 'USD', 3.55); +INSERT INTO CATALOG VALUES(2,'Pear', 'USD', 1.55); \ No newline at end of file -- cgit v1.2.3