You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by cw...@apache.org on 2011/06/15 02:06:22 UTC
svn commit: r1135863 - in
/hive/branches/branch-0.7/metastore/scripts/upgrade: derby/ mysql/ postgres/
Author: cws
Date: Wed Jun 15 00:06:22 2011
New Revision: 1135863
URL: http://svn.apache.org/viewvc?rev=1135863&view=rev
Log:
HIVE-2176. Schema creation scripts are incomplete since they leave out tables that are specific to DataNucleus (Esteban Gutierrez via cws)
Modified:
hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.5.0.derby.sql
hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.6.0.derby.sql
hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.7.0.derby.sql
hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.5.0.mysql.sql
hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.6.0.mysql.sql
hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.7.0.mysql.sql
hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.5.0.postgres.sql
hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.6.0.postgres.sql
hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql
Modified: hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.5.0.derby.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.5.0.derby.sql?rev=1135863&r1=1135862&r2=1135863&view=diff
==============================================================================
--- hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.5.0.derby.sql (original)
+++ hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.5.0.derby.sql Wed Jun 15 00:06:22 2011
@@ -23,6 +23,10 @@ CREATE TABLE "APP"."TABLE_PARAMS" ("TBL_
CREATE TABLE "APP"."PARTITION_PARAMS" ("PART_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" VARCHAR(767));
+CREATE TABLE "APP"."SEQUENCE_TABLE" ("SEQUENCE_NAME" VARCHAR(256) NOT NULL, "NEXT_VAL" BIGINT NOT NULL);
+
+CREATE TABLE "APP"."NUCLEUS_TABLES" ("CLASS_NAME" VARCHAR(128) NOT NULL, "TABLE_NAME" VARCHAR(128) NOT NULL, "TYPE" VARCHAR(4) NOT NULL, "OWNER" VARCHAR(2) NOT NULL, "VERSION" VARCHAR(20) NOT NULL, "INTERFACE_NAME" VARCHAR(256) DEFAULT NULL);
+
CREATE TABLE "APP"."TYPES" ("TYPES_ID" BIGINT NOT NULL, "TYPE_NAME" VARCHAR(128), "TYPE1" VARCHAR(128), "TYPE2" VARCHAR(128));
CREATE TABLE "APP"."SERDE_PARAMS" ("SERDE_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" VARCHAR(767));
@@ -96,6 +100,10 @@ ALTER TABLE "APP"."TABLE_PARAMS" ADD CON
ALTER TABLE "APP"."PARTITION_PARAMS" ADD CONSTRAINT "PARTITION_PARAMS_PK" PRIMARY KEY ("PART_ID", "PARAM_KEY");
+ALTER TABLE "APP"."NUCLEUS_TABLES" ADD CONSTRAINT "NUCLEUS_TABLES_PK" PRIMARY KEY ("CLASS_NAME");
+
+ALTER TABLE "APP"."TYPE_FIELDS" ADD CONSTRAINT "TYPE_FIELDS_PK" PRIMARY KEY ("TYPE_NAME", "FIELD_NAME");
+
-- foreign
ALTER TABLE "APP"."BUCKETING_COLS" ADD CONSTRAINT "BUCKETING_COLS_FK1" FOREIGN KEY ("SD_ID") REFERENCES "APP"."SDS" ("SD_ID") ON DELETE NO ACTION ON UPDATE NO ACTION;
Modified: hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.6.0.derby.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.6.0.derby.sql?rev=1135863&r1=1135862&r2=1135863&view=diff
==============================================================================
--- hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.6.0.derby.sql (original)
+++ hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.6.0.derby.sql Wed Jun 15 00:06:22 2011
@@ -35,6 +35,10 @@ CREATE TABLE "APP"."PARTITION_KEYS" ("TB
CREATE TABLE "APP"."PARTITION_PARAMS" ("PART_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" VARCHAR(4000));
+CREATE TABLE "APP"."SEQUENCE_TABLE" ("SEQUENCE_NAME" VARCHAR(256) NOT NULL, "NEXT_VAL" BIGINT NOT NULL);
+
+CREATE TABLE "APP"."NUCLEUS_TABLES" ("CLASS_NAME" VARCHAR(128) NOT NULL, "TABLE_NAME" VARCHAR(128) NOT NULL, "TYPE" VARCHAR(4) NOT NULL, "OWNER" VARCHAR(2) NOT NULL, "VERSION" VARCHAR(20) NOT NULL, "INTERFACE_NAME" VARCHAR(256) DEFAULT NULL);
+
CREATE TABLE "APP"."TYPES" ("TYPES_ID" BIGINT NOT NULL, "TYPE_NAME" VARCHAR(128), "TYPE1" VARCHAR(767), "TYPE2" VARCHAR(767));
CREATE TABLE "APP"."BUCKETING_COLS" ("SD_ID" BIGINT NOT NULL, "BUCKET_COL_NAME" VARCHAR(256), "INTEGER_IDX" INTEGER NOT NULL);
@@ -92,6 +96,10 @@ ALTER TABLE "APP"."DBS" ADD CONSTRAINT "
ALTER TABLE "APP"."TYPE_FIELDS" ADD CONSTRAINT "TYPE_FIELDS_PK" PRIMARY KEY ("TYPE_NAME", "FIELD_NAME");
+ALTER TABLE "APP"."SEQUENCE_TABLE" ADD CONSTRAINT "SEQUENCE_TABLE_PK" PRIMARY KEY ("SEQUENCE_NAME");
+
+ALTER TABLE "APP"."NUCLEUS_TABLES" ADD CONSTRAINT "NUCLEUS_TABLES_PK" PRIMARY KEY ("CLASS_NAME");
+
ALTER TABLE "APP"."TABLE_PARAMS" ADD CONSTRAINT "TABLE_PARAMS_PK" PRIMARY KEY ("TBL_ID", "PARAM_KEY");
ALTER TABLE "APP"."SD_PARAMS" ADD CONSTRAINT "SD_PARAMS_PK" PRIMARY KEY ("SD_ID", "PARAM_KEY");
Modified: hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.7.0.derby.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.7.0.derby.sql?rev=1135863&r1=1135862&r2=1135863&view=diff
==============================================================================
--- hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.7.0.derby.sql (original)
+++ hive/branches/branch-0.7/metastore/scripts/upgrade/derby/hive-schema-0.7.0.derby.sql Wed Jun 15 00:06:22 2011
@@ -21,6 +21,10 @@ CREATE TABLE "APP"."GLOBAL_PRIVS" ("USER
CREATE TABLE "APP"."INDEX_PARAMS" ("INDEX_ID" BIGINT NOT NULL, "PARAM_KEY" VARCHAR(256) NOT NULL, "PARAM_VALUE" VARCHAR(4000));
+CREATE TABLE "APP"."SEQUENCE_TABLE" ("SEQUENCE_NAME" VARCHAR(256) NOT NULL, "NEXT_VAL" BIGINT NOT NULL);
+
+CREATE TABLE "APP"."NUCLEUS_TABLES" ("CLASS_NAME" VARCHAR(128) NOT NULL, "TABLE_NAME" VARCHAR(128) NOT NULL, "TYPE" VARCHAR(4) NOT NULL, "OWNER" VARCHAR(2) NOT NULL, "VERSION" VARCHAR(20) NOT NULL, "INTERFACE_NAME" VARCHAR(256) DEFAULT NULL);
+
CREATE TABLE "APP"."TYPES" ("TYPES_ID" BIGINT NOT NULL, "TYPE_NAME" VARCHAR(128), "TYPE1" VARCHAR(767), "TYPE2" VARCHAR(767));
CREATE TABLE "APP"."PART_COL_PRIVS" ("PART_COLUMN_GRANT_ID" BIGINT NOT NULL, "COLUMN_NAME" VARCHAR(128), "CREATE_TIME" INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128), "PART_ID" BIGINT, "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "PART_COL_PRIV" VARCHAR(128));
@@ -156,6 +160,10 @@ ALTER TABLE "APP"."TBL_COL_PRIVS" ADD CO
ALTER TABLE "APP"."GLOBAL_PRIVS" ADD CONSTRAINT "GLOBAL_PRIVS_PK" PRIMARY KEY ("USER_GRANT_ID");
+ALTER TABLE "APP"."SEQUENCE_TABLE" ADD CONSTRAINT "SEQUENCE_TABLE_PK" PRIMARY KEY ("SEQUENCE_NAME");
+
+ALTER TABLE "APP"."NUCLEUS_TABLES" ADD CONSTRAINT "NUCLEUS_TABLES_PK" PRIMARY KEY ("CLASS_NAME");
+
ALTER TABLE "APP"."TYPE_FIELDS" ADD CONSTRAINT "TYPE_FIELDS_PK" PRIMARY KEY ("TYPE_NAME", "FIELD_NAME");
-- foreign
Modified: hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.5.0.mysql.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.5.0.mysql.sql?rev=1135863&r1=1135862&r2=1135863&view=diff
==============================================================================
--- hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.5.0.mysql.sql (original)
+++ hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.5.0.mysql.sql Wed Jun 15 00:06:22 2011
@@ -278,6 +278,36 @@ CREATE TABLE IF NOT EXISTS `DBS` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `SEQUENCE_TABLE`
+--
+
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE IF NOT EXISTS `SEQUENCE_TABLE` (
+ `SEQUENCE_NAME` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `NEXT_VAL` bigint(20) NOT NULL,
+ PRIMARY KEY (`SEQUENCE_NAME`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `NUCLEUS_TABLES`
+--
+
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE IF NOT EXISTS `NUCLEUS_TABLES` (
+ `CLASS_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `TYPE` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `OWNER` varchar(2) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `VERSION` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `INTERFACE_NAME` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
+ PRIMARY KEY (`CLASS_NAME`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `TYPES`
--
Modified: hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.6.0.mysql.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.6.0.mysql.sql?rev=1135863&r1=1135862&r2=1135863&view=diff
==============================================================================
--- hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.6.0.mysql.sql (original)
+++ hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.6.0.mysql.sql Wed Jun 15 00:06:22 2011
@@ -282,6 +282,36 @@ CREATE TABLE IF NOT EXISTS `DBS` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `SEQUENCE_TABLE`
+--
+
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE IF NOT EXISTS `SEQUENCE_TABLE` (
+ `SEQUENCE_NAME` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `NEXT_VAL` bigint(20) NOT NULL,
+ PRIMARY KEY (`SEQUENCE_NAME`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `NUCLEUS_TABLES`
+--
+
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE IF NOT EXISTS `NUCLEUS_TABLES` (
+ `CLASS_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `TYPE` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `OWNER` varchar(2) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `VERSION` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `INTERFACE_NAME` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
+ PRIMARY KEY (`CLASS_NAME`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `TYPES`
--
Modified: hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.7.0.mysql.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.7.0.mysql.sql?rev=1135863&r1=1135862&r2=1135863&view=diff
==============================================================================
--- hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.7.0.mysql.sql (original)
+++ hive/branches/branch-0.7/metastore/scripts/upgrade/mysql/hive-schema-0.7.0.mysql.sql Wed Jun 15 00:06:22 2011
@@ -516,6 +516,36 @@ CREATE TABLE IF NOT EXISTS `ROLES` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `SEQUENCE_TABLE`
+--
+
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE IF NOT EXISTS `SEQUENCE_TABLE` (
+ `SEQUENCE_NAME` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `NEXT_VAL` bigint(20) NOT NULL,
+ PRIMARY KEY (`SEQUENCE_NAME`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `NUCLEUS_TABLES`
+--
+
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE IF NOT EXISTS `NUCLEUS_TABLES` (
+ `CLASS_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `TYPE` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `OWNER` varchar(2) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `VERSION` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `INTERFACE_NAME` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
+ PRIMARY KEY (`CLASS_NAME`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `TYPES`
--
Modified: hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.5.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.5.0.postgres.sql?rev=1135863&r1=1135862&r2=1135863&view=diff
==============================================================================
--- hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.5.0.postgres.sql (original)
+++ hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.5.0.postgres.sql Wed Jun 15 00:06:22 2011
@@ -186,6 +186,28 @@ CREATE TABLE "DBS" (
);
--
+-- Table: SEQUENCE_TABLE
+--
+CREATE TABLE "SEQUENCE_TABLE" (
+ "SEQUENCE_NAME" character varying(255) NOT NULL,
+ "NEXT_VAL" bigint NOT NULL,
+ PRIMARY KEY ("SEQUENCE_NAME")
+);
+
+--
+-- Table: NUCLEUS_TABLES
+--
+CREATE TABLE "NUCLEUS_TABLES" (
+ "CLASS_NAME" character varying(128) NOT NULL,
+ "TABLE_NAME" character varying(128) NOT NULL,
+ "TYPE" character varying(4) NOT NULL,
+ "OWNER" character varying(2) NOT NULL,
+ "VERSION" character varying(20) NOT NULL,
+ "INTERFACE_NAME" character varying(255) DEFAULT NULL,
+ PRIMARY KEY ("CLASS_NAME")
+);
+
+--
-- Table: TYPES
--
CREATE TABLE "TYPES" (
Modified: hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.6.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.6.0.postgres.sql?rev=1135863&r1=1135862&r2=1135863&view=diff
==============================================================================
--- hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.6.0.postgres.sql (original)
+++ hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.6.0.postgres.sql Wed Jun 15 00:06:22 2011
@@ -79,7 +79,7 @@ CREATE INDEX "PARTITION_PARAMS_N49" on "
CREATE TABLE "SDS" (
"SD_ID" bigint NOT NULL,
"INPUT_FORMAT" character varying(4000) DEFAULT NULL,
- "IS_COMPRESSED" bit(1) NOT NULL,
+ "IS_COMPRESSED" boolean NOT NULL,
"LOCATION" character varying(4000) DEFAULT NULL,
"NUM_BUCKETS" bigint NOT NULL,
"OUTPUT_FORMAT" character varying(4000) DEFAULT NULL,
@@ -190,6 +190,28 @@ CREATE TABLE "DBS" (
);
--
+-- Table: SEQUENCE_TABLE
+--
+CREATE TABLE "SEQUENCE_TABLE" (
+ "SEQUENCE_NAME" character varying(255) NOT NULL,
+ "NEXT_VAL" bigint NOT NULL,
+ PRIMARY KEY ("SEQUENCE_NAME")
+);
+
+--
+-- Table: NUCLEUS_TABLES
+--
+CREATE TABLE "NUCLEUS_TABLES" (
+ "CLASS_NAME" character varying(128) NOT NULL,
+ "TABLE_NAME" character varying(128) NOT NULL,
+ "TYPE" character varying(4) NOT NULL,
+ "OWNER" character varying(2) NOT NULL,
+ "VERSION" character varying(20) NOT NULL,
+ "INTERFACE_NAME" character varying(255) DEFAULT NULL,
+ PRIMARY KEY ("CLASS_NAME")
+);
+
+--
-- Table: TYPES
--
CREATE TABLE "TYPES" (
Modified: hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql?rev=1135863&r1=1135862&r2=1135863&view=diff
==============================================================================
--- hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql (original)
+++ hive/branches/branch-0.7/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql Wed Jun 15 00:06:22 2011
@@ -369,6 +369,28 @@ CREATE TABLE "ROLES" (
);
--
+-- Table: SEQUENCE_TABLE
+--
+CREATE TABLE "SEQUENCE_TABLE" (
+ "SEQUENCE_NAME" character varying(255) NOT NULL,
+ "NEXT_VAL" bigint NOT NULL,
+ PRIMARY KEY ("SEQUENCE_NAME")
+);
+
+--
+-- Table: NUCLEUS_TABLES
+--
+CREATE TABLE "NUCLEUS_TABLES" (
+ "CLASS_NAME" character varying(128) NOT NULL,
+ "TABLE_NAME" character varying(128) NOT NULL,
+ "TYPE" character varying(4) NOT NULL,
+ "OWNER" character varying(2) NOT NULL,
+ "VERSION" character varying(20) NOT NULL,
+ "INTERFACE_NAME" character varying(255) DEFAULT NULL,
+ PRIMARY KEY ("CLASS_NAME")
+);
+
+--
-- Table: TYPES
--
CREATE TABLE "TYPES" (