diff options
| author | dims <dims@13f79535-47bb-0310-9956-ffa450edef68> | 2008-06-17 00:23:01 +0000 |
|---|---|---|
| committer | dims <dims@13f79535-47bb-0310-9956-ffa450edef68> | 2008-06-17 00:23:01 +0000 |
| commit | bdd0a41aed7edf21ec2a65cfa17a86af2ef8c48a (patch) | |
| tree | 38a92061c0793434c4be189f1d70c3458b6bc41d /interop/src/main/resources/createdb-mysql.ddl | |
Move Tuscany from Incubator to top level.
git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@668359 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'interop/src/main/resources/createdb-mysql.ddl')
| -rw-r--r-- | interop/src/main/resources/createdb-mysql.ddl | 54 |
1 files changed, 54 insertions, 0 deletions
diff --git a/interop/src/main/resources/createdb-mysql.ddl b/interop/src/main/resources/createdb-mysql.ddl new file mode 100644 index 0000000000..de40d836f9 --- /dev/null +++ b/interop/src/main/resources/createdb-mysql.ddl @@ -0,0 +1,54 @@ +--
+-- Copyright (c) 2006 The Apache Software Foundation or its licensors, as applicable.
+--
+-- 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 DATABASE INTEROP;
+USE INTEROP;
+
+------------------------------------------------
+-- DDL Statements for table "INTEROP"."ALLTYPES"
+------------------------------------------------
+
+CREATE TABLE ALLTYPE (
+ ABIT BIT,
+ ATINYINT TINYINT,
+ ABOOLEAN BOOLEAN,
+ ASMALLINT SMALLINT NOT NULL ,
+ AMEDIUMINT MEDIUMINT,
+ AINTEGER INTEGER,
+ ABIGINT BIGINT,
+ AFLOAT FLOAT,
+ ADOUBLE DOUBLE,
+ ADOUBLEPRECISION DOUBLE PRECISION,
+ AREAL REAL,
+ ADECIMAL DECIMAL,
+ ADATE DATE,
+ ADATETIME DATETIME,
+ ATIMESTAMP TIMESTAMP,
+ ATIME TIME,
+ AYEAR YEAR,
+ ACHAR CHAR,
+ AVARCHAR VARCHAR(14),
+ PARENTID SMALLINT ) ;
+
+-----------------------------------------------------
+-- DDL Statements for table "INTEROP"."ALLTYPEPARENT"
+-----------------------------------------------------
+
+CREATE TABLE ALLTYPEPARENT (
+ PARENTID SMALLINT NOT NULL ,
+ DESCRIPTION VARCHAR(14));
+
+
|