10 lines
347 B
SQL
10 lines
347 B
SQL
ALTER TABLE {PREFIX}images ADD COLUMN oldmime varchar(15);
|
|
UPDATE {PREFIX}images SET oldmime = mime;
|
|
ALTER TABLE {PREFIX}images DROP mime;
|
|
|
|
ALTER TABLE {PREFIX}images ADD COLUMN mime varchar(255);
|
|
UPDATE {PREFIX}images SET mime = oldmime;
|
|
ALTER TABLE {PREFIX}images DROP COLUMN oldmime;
|
|
ALTER TABLE {PREFIX}images ALTER COLUMN mime SET NOT NULL;
|
|
|