Debian Codegraph @

rc/sql/8.sql

raw
1 -- Optimizations for media table
2
3 ALTER TABLE MediaTable ADD COLUMN timestamp INT DEFAULT NULL;
4 ALTER TABLE MediaTable ADD COLUMN exposure_time INT DEFAULT NULL;
5 ALTER TABLE MediaTable ADD COLUMN original_orientation INT DEFAULT NULL;
6 ALTER TABLE MediaTable ADD COLUMN filesize INT DEFAULT NULL;
7
8 CREATE INDEX MediaTableFilenameIndex ON MediaTable(filename);