File: db_update_0.6.2_0.6.3_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 (4 lines) | stat: -rw-r--r-- 211 bytes parent folder | download | duplicates (3) 
1
2
3
4
 
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);