16 lines
614 B
MySQL
16 lines
614 B
MySQL
|
-- the type column should be indexed
|
||
|
|
CREATE INDEX json_stores_type ON json_stores USING btree(type);
|
||
|
|
|
||
|
|
-- mobile recording media S3 upload
|
||
|
|
CREATE TABLE mobile_recording_uploads (
|
||
|
|
id character varying(64) NOT NULL DEFAULT uuid_generate_v4(),
|
||
|
|
mobile_recording_id varchar(64) NOT NULL,
|
||
|
|
file_url varchar(1024) DEFAULT NULL,
|
||
|
|
file_name varchar(255) DEFAULT NULL,
|
||
|
|
size integer,
|
||
|
|
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE INDEX mobile_recording_id_idx ON mobile_recording_uploads USING btree(mobile_recording_id);
|