Changeset 761 for trunk/pdns/pdns/docs/pdns.sgml

Timestamp:

04/22/06 17:30:35 (7 years ago)

Author:

ahu

Message:

fix david g's bug one level up as well - we used to do the wrong thing with truncated packets, leaving untrue an, ns and arcounts around
change version to 3.0.1-snapshot

Files:

• trunk/pdns/pdns/docs/pdns.sgml (modified) (1 diff)

trunk/pdns/pdns/docs/pdns.sgml

@@ -8504 +8504 @@
         </para>
         <para>
+          Zone2sql with the --gmysql flag also assumes this layout is in place.
+        </para>
+        <para>
           This schema contains all elements needed for master, slave and superslave operation. Depending on which features will be used, the 'GRANT' statements
           can be trimmed to make sure PDNS cannot subvert the contents of your database.
         </para>
         <para>
-          Zone2sql with the --gmysql flag also assumes this layout is in place.
+          When using the InnoDB storage engine, we suggest adding the following lines to the 'create table records' command above:
+<programlisting>
+CONSTRAINT `records_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES `domains`
+(`id`) ON DELETE CASCADE
+</programlisting>
+        </para>
+        <para>
+          This automates deletion of records on deletion of a domain from the domains table.
         </para>
       </sect2>