Changeset 366 for trunk

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.

Location:

trunk

Files:

• dns-1.0-1.2.sql (modified) (2 diffs)
• dns.sql (modified) (2 diffs)

trunk/dns-1.0-1.2.sql

@@ -23 +23 @@
 SELECT pg_catalog.setval('default_rev_records_record_id_seq', 5, false);
 
+ALTER TABLE domains ADD COLUMN changed boolean;
+UPDATE domains SET changed=false;
+ALTER TABLE domains ALTER COLUMN changed SET DEFAULT true;
+ALTER TABLE domains ALTER COLUMN changed SET NOT NULL;
+
 CREATE TABLE revzones (
     rdns_id serial NOT NULL,
@@ -30 +35 @@
     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
 );
 

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
 );