10 lines
No EOL
258 B
SQL
10 lines
No EOL
258 B
SQL
|
|
CREATE TABLE IF NOT EXISTS files(
|
|
id bigserial PRIMARY KEY,
|
|
library_id bigint REFERENCES libraries(id) NOT NULL,
|
|
md5 uuid NOT NULL,
|
|
size bigint NOT NULL,
|
|
status smallint NOT NULL,
|
|
health smallint NOT NULL,
|
|
path VARCHAR (500) NOT NULL
|
|
); |