5 lines
211 B
SQL
5 lines
211 B
SQL
ALTER TABLE {PREFIX}images ADD COLUMN path text;
|
|
ALTER TABLE {PREFIX}images ALTER COLUMN path SET DEFAULT '/';
|
|
UPDATE {PREFIX}images SET path = '/';
|
|
CREATE {FULLTEXT} INDEX pathkey_idx on {PREFIX}images (path);
|