Changeset 2104

Timestamp:

03/27/11 23:13:46 (2 years ago)

Author:

ahu

Message:

document & implement the widening of the 'TYPE' field for the records table - NSEC3PARAM was longer than the old limit of 6.

Location:

trunk/pdns/pdns

Files:

• dnssec.schema.mysql.sql (modified) (1 diff)
• dnssec.schema.pgsql.sql (modified) (1 diff)
• docs/pdns.xml (modified) (10 diffs)

trunk/pdns/pdns/dnssec.schema.mysql.sql

@@ -34 +34 @@
 
 create unique index namealgoindex on tsigkeys(name, algorithm);
+alter table records change column type type VARCHAR(10);

trunk/pdns/pdns/dnssec.schema.pgsql.sql

@@ -39 +39 @@
 GRANT ALL ON tsigkeys TO pdns;
 GRANT ALL ON tsigkeys_id_seq TO pdns;
+alter table records alter column type type VARCHAR(10);

trunk/pdns/pdns/docs/pdns.xml

@@ -8499 +8499 @@
   domain_id       INT DEFAULT NULL,
   name            VARCHAR(255) DEFAULT NULL,
-  type            VARCHAR(6) DEFAULT NULL,
+  type            VARCHAR(10) DEFAULT NULL,
   content         VARCHAR(255) DEFAULT NULL,
   ttl             INT DEFAULT NULL,
@@ -13351 +13351 @@
           domain_id int(11) NOT NULL,
           name varchar(255) NOT NULL,
-          type varchar(6) NOT NULL,
+          type varchar(10) NOT NULL,
           content varchar(255) NOT NULL,
           ttl int(11) NOT NULL,
@@ -13750 +13750 @@
   domain_id       INT DEFAULT NULL,
   name            VARCHAR(255) DEFAULT NULL,
-  type            VARCHAR(6) DEFAULT NULL,
+  type            VARCHAR(10) DEFAULT NULL,
   content         VARCHAR(255) DEFAULT NULL,
   ttl             INT DEFAULT NULL,
@@ -13809 +13809 @@
 
 create unique index namealgoindex on tsigkeys(name, algorithm);
+
+alter table records change column type type VARCHAR(10);
 
 </programlisting>       
@@ -13850 +13852 @@
         domain_id       INT DEFAULT NULL,
         name            VARCHAR(255) DEFAULT NULL,
-        type            VARCHAR(6) DEFAULT NULL,
+        type            VARCHAR(10) DEFAULT NULL,
         content         VARCHAR(255) DEFAULT NULL,
         ttl             INT DEFAULT NULL,
@@ -13923 +13925 @@
 GRANT ALL ON tsigkeys TO pdns;
 GRANT ALL ON tsigkeys_id_seq TO pdns;
+alter table records alter column type type VARCHAR(10);
 
 </programlisting>  
@@ -13959 +13962 @@
         domain_id       INT DEFAULT NULL REFERENCES Domains(ID) ON DELETE CASCADE,
         name            VARCHAR(255) DEFAULT NULL,
-        type            VARCHAR(6) DEFAULT NULL,
+        type            VARCHAR(10) DEFAULT NULL,
         content         VARCHAR(255) DEFAULT NULL,
         ttl             INT DEFAULT NULL,
@@ -14587 +14590 @@
   ZoneID            number(11) default NULL REFERENCES Domains(ID) ON DELETE CASCADE,
   NAME              varchar2(255) default NULL,
-  TYPE              varchar2(6) default NULL,  
+  TYPE              varchar2(10) default NULL,  
   CONTENT           varchar2(255) default NULL,
   TimeToLive        number(11) default NULL,   
@@ -14688 +14691 @@
               domain_id       INTEGER DEFAULT NULL,
               name            VARCHAR(255) DEFAULT NULL, 
-              type            VARCHAR(6) DEFAULT NULL,
+              type            VARCHAR(10) DEFAULT NULL,
               content         VARCHAR(255) DEFAULT NULL,
               ttl             INTEGER DEFAULT NULL,
@@ -15073 +15076 @@
           domain_id int(11) default NULL,
           name varchar(255) default NULL,
-          type varchar(6) default NULL,
+          type varchar(10) default NULL,
           content varchar(255) default NULL,
           ttl int(11) default NULL,