Changeset 372 for trunk/dns-1.0-1.2.sql

Timestamp:

08/01/12 18:19:03 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Checkpoint adding location/view support. See #10.

• minor location list template tweak
• extend importer to deal with locations on records, and location definitions
• extend exporter to handle locations

Also:

• minor SQL error-log cleanup (boolean types use 'y'/'n' or 'true'/'false'). See #25, sort of
• Fix handling of CNAME exports for reverse zones; the records look ugly but there's no simple way to autoconvert them to the template types on import
• Fix lurking buglet in tabledef update; we're using a 4-char field for locations to allow for legacy uses.

File:

• trunk/dns-1.0-1.2.sql (modified) (1 diff)

trunk/dns-1.0-1.2.sql

@@ -3 +3 @@
 -- need this before we add any other bits
 CREATE TABLE locations (
-    loc character varying (4) PRIMARY KEY,
+    location character varying (4) PRIMARY KEY,
     group_id integer NOT NULL DEFAULT 1,
     iplist text NOT NULL DEFAULT '',