Changeset 543 for trunk/dns-1.0-1.2.sql
- Timestamp:
- 12/10/13 16:22:10 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dns-1.0-1.2.sql
r507 r543 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
Note:
See TracChangeset
for help on using the changeset viewer.