Changeset 366 for trunk/dns.sql

Timestamp:

07/23/12 20:58:35 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Update initial tabledef and 1.0 -> 1.2 conversion SQL to add "changed"
flag intended to help speed up export of large datasets by not actually
actively exporting all zones each time. Note for tinydns this will
require a static cache directory for a workspace so that unchanged
zones can have their data streamed into the main tinydns data file.

File:

• trunk/dns.sql (modified) (2 diffs)

trunk/dns.sql

@@ -65 +65 @@
     status integer DEFAULT 1 NOT NULL,
     zserial integer,
-    sertype character(1) DEFAULT 'D'::bpchar
+    sertype character(1) DEFAULT 'D'::bpchar,
+    changed boolean DEFAULT true NOT NULL
 );
 
@@ -75 +76 @@
     status integer DEFAULT 1 NOT NULL,
     zserial integer,
-    sertype character(1) DEFAULT 'D'::bpchar
+    sertype character(1) DEFAULT 'D'::bpchar,
+    changed boolean DEFAULT true NOT NULL
 );