0007_media_image.up.sql (392B)
1 CREATE TABLE IF NOT EXISTS media_image ( 2 id CHAR(36) PRIMARY KEY NOT NULL UNIQUE CHECK(length(id) = 36), 3 created_at DATETIME NOT NULL CHECK(length(created_at) = 24), 4 updated_at DATETIME NOT NULL CHECK(length(updated_at) = 24), 5 file_path TEXT NOT NULL, 6 mime_type TEXT NOT NULL, 7 res_base TEXT NOT NULL, 8 res_path TEXT NOT NULL, 9 label TEXT, 10 description TEXT 11 );