Changeset 543 for trunk/dns.sql

Timestamp:

12/10/13 16:22:10 (10 years ago)

Author:

Kris Deugau

Message:

/trunk

Implement most of the UI and back end for handling scheduled changes
to records. See #40.

This turned out to be most of what I had vaguely imagined; only SOA
records can't sanely be set for scheduled changes yet (can't think of
a scenario where this would even be useful) and there's only a small
dusting of UI chrome left for another time.

Bumped up from projected 1.4 to 1.2 per request from Reid Sutherland.

File:

• trunk/dns.sql (modified) (1 diff)

trunk/dns.sql

@@ -166 +166 @@
     description text,
     rdns_id integer NOT NULL DEFAULT 0,
-    location character varying (4) DEFAULT '' NOT NULL
+    location character varying (4) DEFAULT '' NOT NULL,
+    stamp TIMESTAMP WITH TIME ZONE DEFAULT 'epoch' NOT NULL,
+    expires boolean DEFAULT 'n' NOT NULL,
+    stampactive boolean DEFAULT 'n' NOT NULL
 );
 CREATE INDEX rec_domain_index ON records USING btree (domain_id);