CREATE TABLE Capability (ID INTEGER NOT NULL, KIND VARCHAR(31), DESCRIPTION VARCHAR(255), STANDARDID VARCHAR(255), IMAGESERVICETYPE INTEGER, MAXFILESIZE INTEGER, MAXRECORDS INTEGER, MAXIMAGE_EXTENT_LONG FLOAT, lMAXIMAGE_EXTENT_LAT FLOAT, MAXIMAGESIZE_LONG INTEGER, MAXIMAGESIZE_LAT INTEGER, MAXQUERY_LONG FLOAT, MAXQUERY_LAT FLOAT, TESTQUERY_EXTRAS VARCHAR(255), TESTQUERY_VERB BIGINT, TESTQUERY_LONG DOUBLE, TESTQUERY_LAT DOUBLE, SERVICE_IDENTIFIER VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE DataType (ID INTEGER NOT NULL, KIND VARCHAR(31), ARRAYSIZE VARCHAR(255), DELIM VARCHAR(255), EXTENDEDSCHEMA VARCHAR(255), EXTENDEDTYPE VARCHAR(255), OTHERATTRIBUTES LONGBLOB, VALUE VARCHAR(255), SIZE BIGINT, PRIMARY KEY (ID))
CREATE TABLE TableSet (ID INTEGER NOT NULL, OTHERATTRIBUTES LONGBLOB, PRIMARY KEY (ID))
CREATE TABLE TableSchema (ID INTEGER NOT NULL, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), OTHERATTRIBUTES LONGBLOB, TITLE VARCHAR(255), UTYPE VARCHAR(255), TABLESET_IDENTIFIER INTEGER, PRIMARY KEY (ID))
CREATE TABLE BaseParam (ID INTEGER NOT NULL, KIND VARCHAR(31), DESCRIPTION VARCHAR(255), NAME VARCHAR(255), OTHERATTRIBUTES LONGBLOB, UCD VARCHAR(255), UNIT VARCHAR(255), UTYPE VARCHAR(255), FLAG VARCHAR(255), STD TINYINT(1) default 0, DATATYPE_ID INTEGER, PARAMUSE INTEGER, TABLE_IDENTIFIER INTEGER, PRIMARY KEY (ID))
CREATE TABLE TapTable (ID INTEGER NOT NULL, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), OTHERATTRIBUTES LONGBLOB, TITLE VARCHAR(255), TYPE VARCHAR(255), UTYPE VARCHAR(255), SCHEMA_IDENTIFIER INTEGER, PRIMARY KEY (ID))
CREATE TABLE Resource (IDENTIFIER VARCHAR(255) NOT NULL, KIND VARCHAR(31), CREATED DATETIME, SHORTNAME VARCHAR(255), STATUS VARCHAR(255), TITLE VARCHAR(255), UPDATED DATETIME, CONTENTLEVEL VARCHAR(255), DESCRIPTION VARCHAR(255), REFERENCEURL VARCHAR(255), SUBJECT VARCHAR(255), TYPE VARCHAR(255), SOURCE_FORMAT VARCHAR(255), SOURCE_VALUE VARCHAR(255), VERSION VARCHAR(255), PUBLISHER_IVOID VARCHAR(255), PUBLISHER_NAME VARCHAR(255), STCDESCRIPTION VARCHAR(255), RIGHTS VARCHAR(255), COVERAGE_ID INTEGER, ACCESSURL_ID INTEGER, TABLESET_ID INTEGER, PRIMARY KEY (IDENTIFIER))
CREATE TABLE Interface (ID INTEGER NOT NULL, KIND VARCHAR(31), ROLE VARCHAR(255), VERSION VARCHAR(255), QUERYTYPE VARCHAR(255), RESULTTYPE VARCHAR(255), TESTQUERY LONGBLOB, WSDLURL LONGBLOB, CAPABILITY_ID INTEGER, PRIMARY KEY (ID))
CREATE TABLE Format (ID INTEGER NOT NULL, ISMIMETYPE TINYINT(1) default 0, VALUE VARCHAR(255), RESOURCE_IDENTIFIER VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE ForeignKey (ID INTEGER NOT NULL, DESCRIPTION VARCHAR(255), TARGETTABLE VARCHAR(255), UTYPE VARCHAR(255), TABLE_IDENTIFIER INTEGER, PRIMARY KEY (ID))
CREATE TABLE FKColumn (ID INTEGER NOT NULL, FROMCOLUMN VARCHAR(255), TARGETCOLUMN VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE Coverage (ID INTEGER NOT NULL, REGIONOFREGARD FLOAT, WAVEBAND VARCHAR(255), FOOTPRINT_IVOID VARCHAR(255), FOOTPRINT_NAME VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE SecurityMethod (ID INTEGER NOT NULL, STANDARDID VARCHAR(255), INTERFACE_ID INTEGER, PRIMARY KEY (ID))
CREATE TABLE ResourceName (ID INTEGER NOT NULL, KIND VARCHAR(31), IVOID VARCHAR(255), NAME VARCHAR(255), RESOURCE_IDENTIFIER VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE RelatedResourceName (ID INTEGER NOT NULL, IVOID VARCHAR(255), NAME VARCHAR(255), RELATIONSHIP_ID INTEGER, PRIMARY KEY (ID))
CREATE TABLE ResourceValidation (ID INTEGER NOT NULL, VALIDATEDBY VARCHAR(255), VALUE BIGINT, RESOURCE_IDENTIFIER VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE Relationship (ID INTEGER NOT NULL, RELATIONSHIPTYPE VARCHAR(255), RESOURCE_IDENTIFIER VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE RDate (ID INTEGER NOT NULL, ROLE VARCHAR(255), VALUE VARCHAR(255), RESOURCE_IDENTIFIER VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE Creator (ID INTEGER NOT NULL, LOGO VARCHAR(255), IVOID VARCHAR(255), NAME VARCHAR(255), RESOURCE_IDENTIFIER VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE Contact (ID INTEGER NOT NULL, ADDRESS VARCHAR(255), EMAIL VARCHAR(255), TELEPHONE VARCHAR(255), IVOID VARCHAR(255), NAME VARCHAR(255), RESOURCE_IDENTIFIER VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE CapabilityValidation (ID INTEGER NOT NULL, VALIDATEDBY VARCHAR(255), VALUE BIGINT, CAPABILITY_ID INTEGER, PRIMARY KEY (ID))
CREATE TABLE AccessURL (ID INTEGER NOT NULL, FORM VARCHAR(255), URL VARCHAR(255), INTERFACE_ID INTEGER, PRIMARY KEY (ID))
CREATE TABLE Interface_BaseParam (ParamHTTP_ID INTEGER NOT NULL, param_ID INTEGER NOT NULL, PRIMARY KEY (ParamHTTP_ID, param_ID))
CREATE TABLE ForeignKey_FKColumn (ForeignKey_ID INTEGER NOT NULL, fkColumn_ID INTEGER NOT NULL, PRIMARY KEY (ForeignKey_ID, fkColumn_ID))
ALTER TABLE Capability ADD CONSTRAINT FK_Capability_SERVICE_IDENTIFIER FOREIGN KEY (SERVICE_IDENTIFIER) REFERENCES Resource (IDENTIFIER)
ALTER TABLE TableSchema ADD CONSTRAINT FK_TableSchema_TABLESET_IDENTIFIER FOREIGN KEY (TABLESET_IDENTIFIER) REFERENCES TableSet (ID)
ALTER TABLE BaseParam ADD CONSTRAINT FK_BaseParam_TABLE_IDENTIFIER FOREIGN KEY (TABLE_IDENTIFIER) REFERENCES TapTable (ID)
ALTER TABLE BaseParam ADD CONSTRAINT FK_BaseParam_DATATYPE_ID FOREIGN KEY (DATATYPE_ID) REFERENCES DataType (ID)
ALTER TABLE TapTable ADD CONSTRAINT FK_TapTable_SCHEMA_IDENTIFIER FOREIGN KEY (SCHEMA_IDENTIFIER) REFERENCES TableSchema (ID)
ALTER TABLE Resource ADD CONSTRAINT FK_Resource_TABLESET_ID FOREIGN KEY (TABLESET_ID) REFERENCES TableSet (ID)
ALTER TABLE Resource ADD CONSTRAINT FK_Resource_COVERAGE_ID FOREIGN KEY (COVERAGE_ID) REFERENCES Coverage (ID)
ALTER TABLE Resource ADD CONSTRAINT FK_Resource_ACCESSURL_ID FOREIGN KEY (ACCESSURL_ID) REFERENCES AccessURL (ID)
ALTER TABLE Interface ADD CONSTRAINT FK_Interface_CAPABILITY_ID FOREIGN KEY (CAPABILITY_ID) REFERENCES Capability (ID)
ALTER TABLE Format ADD CONSTRAINT FK_Format_RESOURCE_IDENTIFIER FOREIGN KEY (RESOURCE_IDENTIFIER) REFERENCES Resource (IDENTIFIER)
ALTER TABLE ForeignKey ADD CONSTRAINT FK_ForeignKey_TABLE_IDENTIFIER FOREIGN KEY (TABLE_IDENTIFIER) REFERENCES TapTable (ID)
ALTER TABLE SecurityMethod ADD CONSTRAINT FK_SecurityMethod_INTERFACE_ID FOREIGN KEY (INTERFACE_ID) REFERENCES Interface (ID)
ALTER TABLE ResourceName ADD CONSTRAINT FK_ResourceName_RESOURCE_IDENTIFIER FOREIGN KEY (RESOURCE_IDENTIFIER) REFERENCES Resource (IDENTIFIER)
ALTER TABLE RelatedResourceName ADD CONSTRAINT FK_RelatedResourceName_RELATIONSHIP_ID FOREIGN KEY (RELATIONSHIP_ID) REFERENCES Relationship (ID)
ALTER TABLE ResourceValidation ADD CONSTRAINT FK_ResourceValidation_RESOURCE_IDENTIFIER FOREIGN KEY (RESOURCE_IDENTIFIER) REFERENCES Resource (IDENTIFIER)
ALTER TABLE Relationship ADD CONSTRAINT FK_Relationship_RESOURCE_IDENTIFIER FOREIGN KEY (RESOURCE_IDENTIFIER) REFERENCES Resource (IDENTIFIER)
ALTER TABLE RDate ADD CONSTRAINT FK_Date_RESOURCE_IDENTIFIER FOREIGN KEY (RESOURCE_IDENTIFIER) REFERENCES Resource (IDENTIFIER)
ALTER TABLE Creator ADD CONSTRAINT FK_Creator_RESOURCE_IDENTIFIER FOREIGN KEY (RESOURCE_IDENTIFIER) REFERENCES Resource (IDENTIFIER)
ALTER TABLE Contact ADD CONSTRAINT FK_Contact_RESOURCE_IDENTIFIER FOREIGN KEY (RESOURCE_IDENTIFIER) REFERENCES Resource (IDENTIFIER)
ALTER TABLE CapabilityValidation ADD CONSTRAINT FK_CapabilityValidation_CAPABILITY_ID FOREIGN KEY (CAPABILITY_ID) REFERENCES Capability (ID)
ALTER TABLE AccessURL ADD CONSTRAINT FK_AccessURL_INTERFACE_ID FOREIGN KEY (INTERFACE_ID) REFERENCES Interface (ID)
ALTER TABLE Interface_BaseParam ADD CONSTRAINT FK_Interface_BaseParam_ParamHTTP_ID FOREIGN KEY (ParamHTTP_ID) REFERENCES Interface (ID)
ALTER TABLE Interface_BaseParam ADD CONSTRAINT FK_Interface_BaseParam_param_ID FOREIGN KEY (param_ID) REFERENCES BaseParam (ID)
ALTER TABLE ForeignKey_FKColumn ADD CONSTRAINT FK_ForeignKey_FKColumn_ForeignKey_ID FOREIGN KEY (ForeignKey_ID) REFERENCES ForeignKey (ID)
ALTER TABLE ForeignKey_FKColumn ADD CONSTRAINT FK_ForeignKey_FKColumn_fkColumn_ID FOREIGN KEY (fkColumn_ID) REFERENCES FKColumn (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)