Changeset 548 for branches/stable/dns-1.0-1.2.sql

Timestamp:

12/11/13 16:01:18 (12 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Merge reverse DNS work and object conversion from /trunk, part 5

Includes changes through r543 with a few more minor conflicts.

Location:

branches/stable

Files:

• . (modified) (1 prop)
• dns-1.0-1.2.sql (modified) (3 diffs)

branches/stable/dns-1.0-1.2.sql

@@ -40 +40 @@
 \.
  
-SELECT pg_catalog.setval('default_rev_records_record_id_seq', 5, false);
+SELECT pg_catalog.setval('default_rev_records_record_id_seq', 4, true);
 
 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;
 ALTER TABLE records ADD COLUMN location character varying (4) DEFAULT '' NOT NULL;
+-- Scheduled changes.
+ALTER TABLE records ADD COLUMN stamp TIMESTAMP WITH TIME ZONE DEFAULT 'epoch' NOT NULL;
+ALTER TABLE records ADD COLUMN expires boolean DEFAULT 'n' NOT NULL;
+ALTER TABLE records ADD COLUMN stampactive boolean DEFAULT 'n' NOT NULL;
 
 -- ~120s -> 75s performance boost on 100K records when always exporting all records
@@ -171 +175 @@
 \.
 
+-- and readd the primary key
+ALTER TABLE ONLY rectypes
+     ADD CONSTRAINT rectypes_pkey PRIMARY KEY (val, name);
+
 -- Update dbversion
 UPDATE misc SET value='1.2' WHERE key='dbversion';