Author: bcarothers
Date: 2009-12-20 20:36:32 -0500 (Sun, 20 Dec 2009)
New Revision: 1468
Added:
trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/mysql5/create.ddl
Removed:
trunk/extensions/dna-connector-jdbc-metadata/src/test/data/
trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/create.ddl
trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/drop.ddl
Log:
DNA-37 Federate schema information from relational sources
Removed some unused files and added one missing DDL file.
Deleted: trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/create.ddl
===================================================================
--- trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/create.ddl 2009-12-21
01:22:00 UTC (rev 1467)
+++ trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/create.ddl 2009-12-21
01:36:32 UTC (rev 1468)
@@ -1,33 +0,0 @@
--- JBoss DNA (
http://www.jboss.org/dna)
--- See the COPYRIGHT.txt file distributed with this work for information
--- regarding copyright ownership. Some portions may be licensed
--- to Red Hat, Inc. under one or more contributor license agreements.
--- See the AUTHORS.txt file in the distribution for a full listing of
--- individual contributors.
---
--- JBoss DNA is free software. Unless otherwise indicated, all code in JBoss DNA
--- is licensed to you under the terms of the GNU Lesser General Public License as
--- published by the Free Software Foundation; either version 2.1 of
--- the License, or (at your option) any later version.
---
--- JBoss DNA is distributed in the hope that it will be useful,
--- but WITHOUT ANY WARRANTY; without even the implied warranty of
--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
--- Lesser General Public License for more details.
---
--- You should have received a copy of the GNU Lesser General Public
--- License along with this software; if not, write to the Free
--- Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
--- 02110-1301 USA, or see the FSF site:
http://www.fsf.org.
-
-CREATE TABLE CHAIN (ID NUMERIC NOT NULL PRIMARY KEY, NAME VARCHAR(30) NOT NULL)
-CREATE TABLE AREA (ID NUMERIC NOT NULL PRIMARY KEY, NAME VARCHAR(30) NOT NULL, CHAIN_ID
NUMERIC NOT NULL)
-CREATE TABLE REGION (ID NUMERIC NOT NULL PRIMARY KEY, NAME VARCHAR(30) NOT NULL, AREA_ID
NUMERIC NOT NULL)
-CREATE TABLE DISTRICT (ID NUMERIC NOT NULL PRIMARY KEY, NAME VARCHAR(30) NOT NULL,
REGION_ID NUMERIC NOT NULL)
-
-CREATE TABLE SALES (ID NUMERIC NOT NULL, SALES_DATE DATETIME NOT NULL, DISTRICT_ID
NUMERIC NOT NULL, AMOUNT NUMERIC(10, 2) NULL)
-ALTER TABLE SALES ADD CONSTRAINT PK_SALES PRIMARY KEY (ID, SALES_DATE)
-
-ALTER TABLE AREA ADD CONSTRAINT FK_CHAIN FOREIGN KEY(CHAIN_ID) REFERENCES CHAIN(ID) ON
DELETE CASCADE
-ALTER TABLE REGION ADD CONSTRAINT FK_AREA FOREIGN KEY(AREA_ID) REFERENCES AREA(ID) ON
DELETE CASCADE
-ALTER TABLE DISTRICT ADD CONSTRAINT FK_REGION FOREIGN KEY(REGION_ID) REFERENCES
REGION(ID) ON DELETE CASCADE
Deleted: trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/drop.ddl
===================================================================
--- trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/drop.ddl 2009-12-21
01:22:00 UTC (rev 1467)
+++ trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/drop.ddl 2009-12-21
01:36:32 UTC (rev 1468)
@@ -1,27 +0,0 @@
--- JBoss DNA (
http://www.jboss.org/dna)
--- See the COPYRIGHT.txt file distributed with this work for information
--- regarding copyright ownership. Some portions may be licensed
--- to Red Hat, Inc. under one or more contributor license agreements.
--- See the AUTHORS.txt file in the distribution for a full listing of
--- individual contributors.
---
--- JBoss DNA is free software. Unless otherwise indicated, all code in JBoss DNA
--- is licensed to you under the terms of the GNU Lesser General Public License as
--- published by the Free Software Foundation; either version 2.1 of
--- the License, or (at your option) any later version.
---
--- JBoss DNA is distributed in the hope that it will be useful,
--- but WITHOUT ANY WARRANTY; without even the implied warranty of
--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
--- Lesser General Public License for more details.
---
--- You should have received a copy of the GNU Lesser General Public
--- License along with this software; if not, write to the Free
--- Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
--- 02110-1301 USA, or see the FSF site:
http://www.fsf.org.
-
-DROP TABLE SALES
-DROP TABLE DISTRICT
-DROP TABLE REGION
-DROP TABLE AREA
-DROP TABLE CHAIN
Added: trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/mysql5/create.ddl
===================================================================
--- trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/mysql5/create.ddl
(rev 0)
+++
trunk/extensions/dna-connector-jdbc-metadata/src/test/resources/mysql5/create.ddl 2009-12-21
01:36:32 UTC (rev 1468)
@@ -0,0 +1,28 @@
+-- JBoss DNA (
http://www.jboss.org/dna)
+-- See the COPYRIGHT.txt file distributed with this work for information
+-- regarding copyright ownership. Some portions may be licensed
+-- to Red Hat, Inc. under one or more contributor license agreements.
+-- See the AUTHORS.txt file in the distribution for a full listing of
+-- individual contributors.
+--
+-- JBoss DNA is free software. Unless otherwise indicated, all code in JBoss DNA
+-- is licensed to you under the terms of the GNU Lesser General Public License as
+-- published by the Free Software Foundation; either version 2.1 of
+-- the License, or (at your option) any later version.
+--
+-- JBoss DNA is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+-- Lesser General Public License for more details.
+--
+-- You should have received a copy of the GNU Lesser General Public
+-- License along with this software; if not, write to the Free
+-- Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
+-- 02110-1301 USA, or see the FSF site:
http://www.fsf.org.
+
+CREATE TABLE IF NOT EXISTS chain (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(30) NOT NULL)
TYPE=INNODB;
+CREATE TABLE IF NOT EXISTS area (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(30) NOT NULL,
CHAIN_ID INT NOT NULL) TYPE=INNODB;
+CREATE TABLE IF NOT EXISTS region (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(30) NOT
NULL, AREA_ID INT NOT NULL) TYPE=INNODB;
+CREATE TABLE IF NOT EXISTS district (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(30) NOT
NULL, REGION_ID INT NOT NULL) TYPE=INNODB;
+
+CREATE TABLE IF NOT EXISTS sales (ID INT NOT NULL, SALES_DATE DATE NOT NULL, DISTRICT_ID
INT NOT NULL, AMOUNT INT NULL) TYPE=INNODB;