h2.edw.raw.ddl Maven / Gradle / Ivy

Go to download
CREATE TABLE PUBLIC.TBL (
	ID INT
);

CREATE TABLE PUBLIC.TABLE_WITH_IDENTITY (
	ID INT IDENTITY(1,1) NOT NULL,
	ID2 INT NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_WITH_TIMESTAMP (
	ID INT IDENTITY(1,1) NOT NULL,
	TS TIMESTAMP NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_WITH_DATE (
	ID INT IDENTITY(1,1) NOT NULL,
	TS DATE NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_WITH_TIMESTAMP2 (
	ID INT IDENTITY(1,1) NOT NULL,
	TS TIMESTAMP NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_WITH_DATE2 (
	ID INT IDENTITY(1,1) NOT NULL,
	TS DATE NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_1 (
	ID INT IDENTITY(1,1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_2 (
	ID INT IDENTITY(1,1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_3 (
	ID INT IDENTITY(1,1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_4 (
	ID INT IDENTITY(1,1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_5 (
	ID INT IDENTITY(1,1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_6 (
	ID INT IDENTITY(1,1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_7 (
	ID INT IDENTITY(1,1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_8 (
	ID INT IDENTITY(1,1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE VIEW PUBLIC.VW AS SELECT * FROM PUBLIC.TABLE_WITH_DATE;;

create schema apple;;
create table apple.abs(id int);;
create table apple.babs(id int);;
create table apple.sabs(id int);;
create table apple.mabs(id int);;

create schema google;;
create table google.mabs(id int);;

create schema purple;;
create table purple.mabs(id int);;