0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
32 lines
783 B
SQL
32 lines
783 B
SQL
-- FILE: schema.sql
|
|
|
|
DROP SCHEMA IF EXISTS td3 CASCADE;
|
|
CREATE SCHEMA td3;
|
|
|
|
CREATE TABLE td3.codes (
|
|
id SERIAL PRIMARY KEY,
|
|
ts_created timestamptz DEFAULT now() NOT NULL,
|
|
ts_updated timestamptz DEFAULT now() NOT NULL,
|
|
created_by text NOT NULL,
|
|
updated_by text NOT NULL,
|
|
|
|
code text,
|
|
hash text,
|
|
is_private boolean
|
|
);
|
|
|
|
|
|
CREATE TABLE td3.test_codes (
|
|
id SERIAL PRIMARY KEY,
|
|
ts_created timestamptz DEFAULT now() NOT NULL,
|
|
ts_updated timestamptz DEFAULT now() NOT NULL,
|
|
created_by text NOT NULL,
|
|
updated_by text NOT NULL,
|
|
|
|
test_id integer NOT NULL,
|
|
code_hash text NOT NULL
|
|
);
|
|
|
|
-- FILE: query.sql
|
|
|