File: 4.3.0_to_4.7.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 (5 lines) | stat: -rw-r--r-- 194 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
 
ALTER TABLE domains ALTER COLUMN type TYPE text;
ALTER TABLE domains ADD COLUMN options TEXT DEFAULT NULL,
  ADD COLUMN catalog TEXT DEFAULT NULL;

CREATE INDEX catalog_idx ON domains(catalog);