File: 4.2.0_to_4.3.0_schema.pgsql.sql

package info (click to toggle)
pdns 5.0.2-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 10,824 kB
  • sloc: cpp: 101,240; sh: 5,616; makefile: 2,318; sql: 860; ansic: 675; python: 635; yacc: 245; perl: 161; lex: 131
file content (8 lines) | stat: -rw-r--r-- 291 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
 
BEGIN;
  ALTER TABLE cryptokeys ADD COLUMN published BOOL DEFAULT TRUE;

  ALTER TABLE cryptokeys ADD COLUMN content_new TEXT;
  UPDATE cryptokeys SET content_new = content;
  ALTER TABLE cryptokeys DROP COLUMN content;
  ALTER TABLE cryptokeys RENAME COLUMN content_new TO content;
COMMIT;