• Home
• com.github.marschall
• threeten-jpa-test
• 1.12
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

rschall.threeten-jpa-test.1.12.source-code.postgres-schema.sql Maven / Gradle / Ivy

DROP TABLE IF EXISTS JAVA_TIME_42;
CREATE TABLE JAVA_TIME_42 (
  ID BIGINT NOT NULL,
  DATE_COLUMN DATE,
  TIME_COLUMN TIME(6),
  TIMESTAMP_COLUMN TIMESTAMP(6),
  PRIMARY KEY (ID)
);

DROP TABLE IF EXISTS JAVA_TIME_42_WITH_ZONE;
CREATE TABLE JAVA_TIME_42_WITH_ZONE (
  ID BIGINT NOT NULL,
  OFFSET_DATE_TIME_COLUMN TIMESTAMP(6) WITH TIME ZONE,
  PRIMARY KEY (ID)
);

DROP TABLE IF EXISTS JAVA_TIME_42_ZONED;
CREATE TABLE JAVA_TIME_42_ZONED (
  ID BIGINT NOT NULL,
  TIMESTAMP_UTC TIMESTAMP(6) WITH TIME ZONE,
  ZONE_ID VARCHAR(32),
  PRIMARY KEY (ID)
);