diff options
Diffstat (limited to 'java/sca/tutorials')
-rw-r--r-- | java/sca/tutorials/store/assets/services/db/cart.sql | 54 | ||||
-rw-r--r-- | java/sca/tutorials/store/www-services/catalog-amazon/store-db/store.sql | 72 |
2 files changed, 63 insertions, 63 deletions
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 |