Changeset 91 for trunk/dns.sql

Timestamp:

04/13/11 16:00:10 (13 years ago)

Author:

Kris Deugau

Message:

/trunk

SQL tabledef update:

• Tweak log table definition to cope with looooong entries (mainly from AXFR warnings)

DNSDB.pm:

• Add domainID and getRecCount subs in DNSDB
• Return more user-friendly error on attempting to add a domain with no name
• Nitpick-tweak DB calls and SQL formatting in domainName()
• Replace placeholderish OK message in importAXFR()

dns.cgi:

• Trim some more direct SQL out in reclist
• Uninitialized-variable cleanup in AXFR import
• Add logging to AXFR import
• Don't complain about uninitialized variables in record-display

File:

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

trunk/dns.sql

@@ -54 +54 @@
 \.
 
+-- entry is text due to possible long entries from AXFR - a domain with "many"
+-- odd records will overflow varchar(200)
 CREATE TABLE log (
     log_id serial NOT NULL,
@@ -61 +63 @@
     email character varying(60),
     name character varying(60),
-    entry character varying(200),
+    entry text,
     stamp timestamp with time zone DEFAULT now()
 );