You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tuscany.apache.org by lr...@apache.org on 2008/03/01 06:43:22 UTC
svn commit: r632557 -
/incubator/tuscany/java/sca/modules/implementation-das/company.sql
Author: lresende
Date: Fri Feb 29 21:43:12 2008
New Revision: 632557
URL: http://svn.apache.org/viewvc?rev=632557&view=rev
Log:
TUSCANY-2013 - Adding company.sql for dinamicaly generating derby db
Added:
incubator/tuscany/java/sca/modules/implementation-das/company.sql
Added: incubator/tuscany/java/sca/modules/implementation-das/company.sql
URL: http://svn.apache.org/viewvc/incubator/tuscany/java/sca/modules/implementation-das/company.sql?rev=632557&view=auto
==============================================================================
--- incubator/tuscany/java/sca/modules/implementation-das/company.sql (added)
+++ incubator/tuscany/java/sca/modules/implementation-das/company.sql Fri Feb 29 21:43:12 2008
@@ -0,0 +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');
+INSERT INTO COMPANY (NAME) VALUES('MegaCorp');
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-commits-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-commits-help@ws.apache.org