From: <id...@us...> - 2009-02-18 19:55:11
|
Revision: 9 http://cse-ip.svn.sourceforge.net/cse-ip/?rev=9&view=rev Author: idueppe Date: 2009-02-18 19:55:09 +0000 (Wed, 18 Feb 2009) Log Message: ----------- removed generated files Removed Paths: ------------- cse-ip/trunk/sandbox/cse-ip/sc-idmapper/createDDL.jdbc cse-ip/trunk/sandbox/cse-ip/sc-idmapper/dropDDL.jdbc Deleted: cse-ip/trunk/sandbox/cse-ip/sc-idmapper/createDDL.jdbc =================================================================== --- cse-ip/trunk/sandbox/cse-ip/sc-idmapper/createDDL.jdbc 2009-02-18 19:48:31 UTC (rev 8) +++ cse-ip/trunk/sandbox/cse-ip/sc-idmapper/createDDL.jdbc 2009-02-18 19:55:09 UTC (rev 9) @@ -1,6 +0,0 @@ -CREATE TABLE IDMAPPER_CLIENT_OBJECT (ID BIGINT NOT NULL, CLIENT_OBJECT_ID VARCHAR(128), BUS_ID BIGINT NOT NULL, CLIENT_INSTANCE_ID BIGINT, PRIMARY KEY (ID)) -CREATE TABLE IDMAPPER_CLIENT_INSTANCE (ID BIGINT AUTO_INCREMENT NOT NULL, CLIENT_NAME VARCHAR(255), CLIENT_URL BLOB(64000), PRIMARY KEY (ID)) -ALTER TABLE IDMAPPER_CLIENT_OBJECT ADD CONSTRAINT UNQ_IDMAPPER_CLIENT_OBJECT_0 UNIQUE (CLIENT_OBJECT_ID, CLIENT_INSTANCE_ID) -ALTER TABLE IDMAPPER_CLIENT_OBJECT ADD CONSTRAINT FK_IDMAPPER_CLIENT_OBJECT_CLIENT_INSTANCE_ID FOREIGN KEY (CLIENT_INSTANCE_ID) REFERENCES IDMAPPER_CLIENT_INSTANCE (ID) -CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME)) -INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0) Deleted: cse-ip/trunk/sandbox/cse-ip/sc-idmapper/dropDDL.jdbc =================================================================== --- cse-ip/trunk/sandbox/cse-ip/sc-idmapper/dropDDL.jdbc 2009-02-18 19:48:31 UTC (rev 8) +++ cse-ip/trunk/sandbox/cse-ip/sc-idmapper/dropDDL.jdbc 2009-02-18 19:55:09 UTC (rev 9) @@ -1,5 +0,0 @@ -ALTER TABLE IDMAPPER_CLIENT_OBJECT DROP FOREIGN KEY FK_IDMAPPER_CLIENT_OBJECT_CLIENT_INSTANCE_ID -ALTER TABLE IDMAPPER_CLIENT_OBJECT DROP FOREIGN KEY UNQ_IDMAPPER_CLIENT_OBJECT_0 -DROP TABLE IDMAPPER_CLIENT_OBJECT -DROP TABLE IDMAPPER_CLIENT_INSTANCE -DELETE FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN' This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |