Changeset 130 for trunk/dns.sql

Timestamp:

10/04/11 10:34:18 (13 years ago)

Author:

Kris Deugau

Message:

/trunk

Duhhhhh... "text" fields don't have any performance penalty
over varchar or char. Rip out the longrecs business in favour
of much simpler record tables. Reverts addition of same from
r90.

File:

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

trunk/dns.sql

@@ -8 +8 @@
 CREATE TABLE default_records (
     record_id serial NOT NULL,
-    longrec_id integer,
     group_id integer DEFAULT 1 NOT NULL,
-    host character varying(100) DEFAULT ''::character varying NOT NULL,
+    host text DEFAULT '' NOT NULL,
     "type" integer DEFAULT 1 NOT NULL,
-    val character varying(100) DEFAULT ''::character varying NOT NULL,
+    val text DEFAULT '' NOT NULL,
     distance integer DEFAULT 0 NOT NULL,
     weight integer DEFAULT 0 NOT NULL,
     port integer DEFAULT 0 NOT NULL,
     ttl integer DEFAULT 86400 NOT NULL,
-    description character varying(255)
+    description text
 );
 
@@ -97 +96 @@
     domain_id integer NOT NULL,
     record_id serial NOT NULL,
-    longrec_id integer,
-    host character varying(100) DEFAULT ''::character varying NOT NULL,
+    host text DEFAULT '' NOT NULL,
     "type" integer DEFAULT 1 NOT NULL,
-    val character varying(100) DEFAULT ''::character varying NOT NULL,
+    val text DEFAULT '' NOT NULL,
     distance integer DEFAULT 0 NOT NULL,
     weight integer DEFAULT 0 NOT NULL,
     port integer DEFAULT 0 NOT NULL,
     ttl integer DEFAULT 7200 NOT NULL,
-    description character varying(255)
-);
-
-CREATE TABLE longrecs (
-    longrec_id serial NOT NULL,
-    recdata text
+    description text
 );