File: db_update_0.6.8_0.6.9_postgres.sql

package info (click to toggle)
serendipity 1.0.4-1%2Betch1
  • links: PTS
  • area: main
  • in suites: etch
  • size: 14,692 kB
  • ctags: 10,206
  • sloc: php: 83,899; sql: 1,024; sh: 597; makefile: 56
file content (9 lines) | stat: -rw-r--r-- 347 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
 
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;