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
70 lines
1.5 KiB
SQL
70 lines
1.5 KiB
SQL
CREATE TYPE unused_enum AS ENUM (
|
|
'a', 'b'
|
|
);
|
|
|
|
CREATE TYPE unused_table_enum AS ENUM (
|
|
'c', 'd'
|
|
);
|
|
CREATE TABLE unused_table (
|
|
id INTEGER PRIMARY KEY,
|
|
value unused_table_enum
|
|
);
|
|
|
|
CREATE TYPE query_return_full_table_enum AS ENUM (
|
|
'e', 'f'
|
|
);
|
|
CREATE TABLE query_return_full_table (
|
|
id INTEGER PRIMARY KEY,
|
|
value query_return_full_table_enum
|
|
);
|
|
|
|
CREATE TYPE query_param_enum_table_enum AS ENUM (
|
|
'g', 'h'
|
|
);
|
|
CREATE TABLE query_param_enum_table (
|
|
id INTEGER PRIMARY KEY,
|
|
other query_param_enum_table_enum NOT NULL,
|
|
value query_param_enum_table_enum
|
|
);
|
|
|
|
CREATE TYPE query_param_struct_enum_table_enum AS ENUM (
|
|
'i', 'j'
|
|
);
|
|
CREATE TABLE query_param_struct_enum_table (
|
|
id INTEGER PRIMARY KEY,
|
|
value query_param_struct_enum_table_enum
|
|
);
|
|
|
|
CREATE TYPE query_return_enum_table_enum AS ENUM (
|
|
'k', 'l'
|
|
);
|
|
CREATE TABLE query_return_enum_table (
|
|
id INTEGER PRIMARY KEY,
|
|
value query_return_enum_table_enum
|
|
);
|
|
|
|
CREATE TYPE query_return_struct_enum_table_enum AS ENUM (
|
|
'k', 'l'
|
|
);
|
|
CREATE TABLE query_return_struct_enum_table (
|
|
id INTEGER PRIMARY KEY,
|
|
value query_return_struct_enum_table_enum,
|
|
another INTEGER
|
|
);
|
|
|
|
CREATE TYPE query_sqlc_embed_enum AS ENUM (
|
|
'm', 'n'
|
|
);
|
|
CREATE TABLE query_sqlc_embed_table (
|
|
id INTEGER PRIMARY KEY,
|
|
value query_sqlc_embed_enum
|
|
);
|
|
|
|
CREATE TYPE array_enum AS ENUM (
|
|
'o', 'p'
|
|
);
|
|
CREATE TABLE array_enum_table (
|
|
id INTEGER PRIMARY KEY,
|
|
value array_enum[]
|
|
);
|