title: On delete cascade to table
body: <p>How can I add on delete cascade to this table creation script? id_fk comes from mytable table.</p>
  
  <pre><code> CREATE TABLE IF NOT EXISTS `ip` (
  
    `ip_id` int(11) NOT NULL AUTO_INCREMENT,
  
    `id_fk` int(11) DEFAULT NULL,
  
    `ip_add` varchar(40) DEFAULT NULL,
  
    PRIMARY KEY (`ip_id`),
  
    KEY `id_fk` (`id_fk`)
  
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
  </code></pre>