/*
Script generated by Aqua Data Studio 15.0.0-rc-35 on Sep-11-2014 06:00:27 PM
Database: 12378
Schema: <All Schemas>
Objects: TABLE
*/
DROP TABLE "ADMIN"."Table_admin"
GO
DROP TABLE "INFORMATION_SCHEMA"."Table_Info"
GO
DROP TABLE "DEFINITION_SCHEMA"."Table_Def"
GO
DROP TABLE "INFORMATION_SCHEMA"."Table_All_Data_Types1"
GO
DROP TABLE "DEFINITION_SCHEMA"."Table_All_Data_Types"
GO
DROP TABLE "ADMIN"."Table_All_Data_Types"
GO

CREATE TABLE "ADMIN"."Table_All_Data_Types"  ( 
	"COL_DATE"    	DATE NULL,
	"COL_FLOAT4"  	FLOAT4 NULL,
	"COL_FLOAT8"  	FLOAT8 NULL,
	"COL_INT1"    	INT1 NULL,
	"COL_INT2"    	INT2 NULL,
	"COL_INT4"    	INT4 NULL,
	"COL_INT8"    	INT8 NULL,
	"COL_INTERVAL"	INTERVAL NULL,
	"COL_NUMERIC" 	NUMERIC(15,5) NULL,
	"COL_TIME"    	TIME NULL,
	"COL_TIMESTAP"	TIMESTAMP NULL,
	"COL_TIMETZ"  	TIMETZ NULL,
	"COL_VARCHAR" 	VARCHAR(100) NULL,
	"COL_NVARCHAR"	NVARCHAR(100) NULL,
	"COL_CHAR"    	CHAR(100) NULL,
	"COL_NCHAR"   	NCHAR(100) NULL,
	"COL_BOOL"    	BOOL NULL,
	"COL_ID"      	INT1 NOT NULL DEFAULT 1,
	CONSTRAINT "PK" PRIMARY KEY("COL_ID") DEFERRABLE INITIALLY IMMEDIATE
)	DISTRIBUTE ON ("COL_DATE") 
GO
CREATE TABLE "DEFINITION_SCHEMA"."Table_All_Data_Types"  ( 
	"COL_DATE"    	DATE NULL,
	"COL_FLOAT4"  	FLOAT4 NULL,
	"COL_FLOAT8"  	FLOAT8 NULL,
	"COL_INT1"    	INT1 NULL,
	"COL_INT2"    	INT2 NULL,
	"COL_INT4"    	INT4 NULL,
	"COL_INT8"    	INT8 NULL,
	"COL_INTERVAL"	INTERVAL NULL,
	"COL_NUMERIC" 	NUMERIC(15,5) NULL,
	"COL_TIME"    	TIME NULL,
	"COL_TIMESTAP"	TIMESTAMP NULL,
	"COL_TIMETZ"  	TIMETZ NULL,
	"COL_VARCHAR" 	VARCHAR(100) NULL,
	"COL_NVARCHAR"	NVARCHAR(100) NULL,
	"COL_CHAR"    	CHAR(100) NULL,
	"COL_NCHAR"   	NCHAR(100) NULL,
	"COL_BOOL"    	BOOL NULL,
	"COL_ID"      	INT1 NOT NULL DEFAULT 1,
	CONSTRAINT "PK" PRIMARY KEY("COL_ID") DEFERRABLE INITIALLY IMMEDIATE
)	DISTRIBUTE ON ("COL_DATE") 
GO
CREATE TABLE "INFORMATION_SCHEMA"."Table_All_Data_Types1"  ( 
	"COL_DATE"    	DATE NULL,
	"COL_FLOAT4"  	FLOAT4 NULL,
	"COL_FLOAT8"  	FLOAT8 NULL,
	"COL_INT1"    	INT1 NULL,
	"COL_INT2"    	INT2 NULL,
	"COL_INT4"    	INT4 NULL,
	"COL_INT8"    	INT8 NULL,
	"COL_INTERVAL"	INTERVAL NULL,
	"COL_NUMERIC" 	NUMERIC(15,5) NULL,
	"COL_TIME"    	TIME NULL,
	"COL_TIMESTAP"	TIMESTAMP NULL,
	"COL_TIMETZ"  	TIMETZ NULL,
	"COL_VARCHAR" 	VARCHAR(100) NULL,
	"COL_NVARCHAR"	NVARCHAR(100) NULL,
	"COL_CHAR"    	CHAR(100) NULL,
	"COL_NCHAR"   	NCHAR(100) NULL,
	"COL_BOOL"    	BOOL NULL,
	"COL_ID"      	INT1 NOT NULL DEFAULT 1 
	)	DISTRIBUTE ON ("COL_DATE") 
GO
CREATE TABLE "DEFINITION_SCHEMA"."Table_Def"  ( 
	"c1"	VARCHAR(25) NULL,
	"c2"	INT1 NULL 
	)	DISTRIBUTE ON ("c1") 
GO
CREATE TABLE "INFORMATION_SCHEMA"."Table_Info"  ( 
	"c1"	VARCHAR(25) NULL,
	"c2"	INT1 NULL 
	)	DISTRIBUTE ON ("c1") 
GO
CREATE TABLE "ADMIN"."Table_admin"  ( 
	"c1"	VARCHAR(25) NULL,
	"c2"	INT1 NULL 
	)	DISTRIBUTE ON ("c1") 
GO