Changeset 548 for branches/stable/dns-1.0-1.2.sql
- Timestamp:
- 12/11/13 16:01:18 (10 years ago)
- Location:
- branches/stable
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/stable
- Property svn:mergeinfo changed
/trunk merged: 493-534,536-543
- Property svn:mergeinfo changed
-
branches/stable/dns-1.0-1.2.sql
r547 r548 40 40 \. 41 41 42 SELECT pg_catalog.setval('default_rev_records_record_id_seq', 5, false);42 SELECT pg_catalog.setval('default_rev_records_record_id_seq', 4, true); 43 43 44 44 ALTER TABLE domains ADD COLUMN changed boolean DEFAULT true NOT NULL; … … 72 72 ALTER TABLE records ADD COLUMN rdns_id INTEGER DEFAULT 0 NOT NULL; 73 73 ALTER TABLE records ADD COLUMN location character varying (4) DEFAULT '' NOT NULL; 74 -- Scheduled changes. 75 ALTER TABLE records ADD COLUMN stamp TIMESTAMP WITH TIME ZONE DEFAULT 'epoch' NOT NULL; 76 ALTER TABLE records ADD COLUMN expires boolean DEFAULT 'n' NOT NULL; 77 ALTER TABLE records ADD COLUMN stampactive boolean DEFAULT 'n' NOT NULL; 74 78 75 79 -- ~120s -> 75s performance boost on 100K records when always exporting all records … … 171 175 \. 172 176 177 -- and readd the primary key 178 ALTER TABLE ONLY rectypes 179 ADD CONSTRAINT rectypes_pkey PRIMARY KEY (val, name); 180 173 181 -- Update dbversion 174 182 UPDATE misc SET value='1.2' WHERE key='dbversion';
Note:
See TracChangeset
for help on using the changeset viewer.