File: db_update_0.6.3_0.6.4_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 (3 lines) | stat: -rw-r--r-- 175 bytes parent folder | download | duplicates (3)
1
2
3
ALTER TABLE {PREFIX}authors ADD COLUMN right_publish int2;
ALTER TABLE {PREFIX}authors ALTER COLUMN right_publish SET DEFAULT '1';
UPDATE {PREFIX}authors SET right_publish=1;