Changeset 375 for trunk/dns.sql

Timestamp:

08/08/12 18:04:47 (12 years ago)

Author:

Kris Deugau

Message:

/trunk

Checkpoint adding locations/views. See #10.

• Tweak new locations table again with an internal serial for sorting and finding the "highest" previous location
• Complete "Add location" stub
• Fill in initial display page for "Edit location"
• Tweak location add/edit/update template a little, add new comments field to match new field in table
• Tweak location import so we don't end up with great long space-free fields similar to what can't be avoided with TXT (usually SPF/DomainKeys) records
• Fill in addLoc() stub
• Add getLoc()
• Tweak location export to strip commas and whitespace properly

File:

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

trunk/dns.sql

@@ -19 +19 @@
 CREATE TABLE locations (
     location character varying (4) PRIMARY KEY,
+    loc_id serial UNIQUE,
     group_id integer NOT NULL DEFAULT 1,
     iplist text NOT NULL DEFAULT '',
-    description text NOT NULL DEFAULT ''
+    description character varying(40) NOT NULL DEFAULT '',
+    comments text NOT NULL DEFAULT ''
 );