hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From c..@apache.org
Subject svn commit: r1135863 - in /hive/branches/branch-0.7/metastore/scripts/upgrade: derby/ mysql/ postgres/
Date Wed, 15 Jun 2011 00:06:22 GMT
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" (



Mime
View raw message