LuckyCoinkydink/sql/db_update_0.6.3_0.6.4_postgres.sql
2006-08-02 10:07:34 +00:00

4 lines
175 B
SQL

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;