5 lines
362 B
SQL
5 lines
362 B
SQL
ALTER TABLE `resources` ADD COLUMN `hasEncodedVersion` INTEGER DEFAULT 0;
|
|
ALTER TABLE `resources` ADD COLUMN `encodedVersion` TEXT DEFAULT NULL;
|
|
|
|
CREATE INDEX IF NOT EXISTS `resources_hasEncodedVersion` ON `resources` (`hasEncodedVersion`);
|
|
CREATE INDEX IF NOT EXISTS `resources_blurhash_hasEncodedVersion` ON `resources` (`blurhash`, `hasEncodedVersion`);
|