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); |