Changeset 366 for trunk/dns-1.0-1.2.sql
- Timestamp:
- 07/23/12 20:58:35 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dns-1.0-1.2.sql
r365 r366 23 23 SELECT pg_catalog.setval('default_rev_records_record_id_seq', 5, false); 24 24 25 ALTER TABLE domains ADD COLUMN changed boolean; 26 UPDATE domains SET changed=false; 27 ALTER TABLE domains ALTER COLUMN changed SET DEFAULT true; 28 ALTER TABLE domains ALTER COLUMN changed SET NOT NULL; 29 25 30 CREATE TABLE revzones ( 26 31 rdns_id serial NOT NULL, … … 30 35 status integer DEFAULT 1 NOT NULL, 31 36 zserial integer, 32 sertype character(1) DEFAULT 'D'::bpchar 37 sertype character(1) DEFAULT 'D'::bpchar, 38 changed boolean DEFAULT true NOT NULL 33 39 ); 34 40
Note:
See TracChangeset
for help on using the changeset viewer.