Dialect.VERSION = 1.4.0
CREATE TABLE IF NOT EXISTS "new_table" (
id BIGSERIAL NOT NULL,
name VARCHAR(100) NOT NULL DEFAULT '',
categoryid BIGSERIAL NOT NULL DEFAULT 0,
companyid BIGSERIAL NOT NULL DEFAULT 0,
fields TEXT NOT NULL DEFAULT '',
start TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '0000-00-00 00:00:00',
end TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT '0000-00-00 00:00:00',
status SMALLSERIAL NOT NULL DEFAULT 0,
extra TEXT NOT NULL DEFAULT ''
)
CREATE VIEW "new_view" (
id,
name
) AS SELECT id, name FROM another_table
|
Download
