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

Go to download
Show more of this group Show more artifacts with this name
Show all versions of java-unit-executor-integration-test Show documentation
The newest version!
CREATE TABLE PUBLIC.TBL (
	ID INT
);

CREATE TABLE PUBLIC.TABLE_WITH_IDENTITY (
	ID INT GENERATED BY DEFAULT AS IDENTITY (RESTART WITH 1) NOT NULL,
	ID2 INT NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_WITH_TIMESTAMP (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	TS TIMESTAMP NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_WITH_DATE (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	TS DATE NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_WITH_DATES (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	DT DATE NOT NULL,
	TS TIMESTAMP NOT NULL,
	TM TIME NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_WITH_TIMESTAMP2 (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	TS TIMESTAMP NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_WITH_DATE2 (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	TS DATE NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_1 (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_2 (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_3 (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_4 (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_5 (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_6 (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_7 (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	PRIMARY KEY (ID)
);;

CREATE TABLE PUBLIC.TABLE_8 (
	ID INT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL,
	TABLE_7_ID INT NOT NULL,
	TABLE_6_ID INT NOT NULL,
	CONSTRAINT FK_TABLE_6 FOREIGN KEY (TABLE_6_ID) REFERENCES TABLE_6(ID),
	PRIMARY KEY (ID)
);;

ALTER TABLE TABLE_8
  ADD FOREIGN KEY (TABLE_7_ID)
  REFERENCES TABLE_7(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);;