CREATE TABLE hd_zone_$mid (
  id int(11) NOT NULL auto_increment,
  contract_id int(11) NOT NULL default '-1',
  zone varchar(255) NOT NULL,
  data TEXT NOT NULL,
  comment varchar(255) default NULL,
  from_date date default NULL,
  to_date date default NULL,
  config text,
  whois tinyint(1) NOT NULL default '1',
  whois_last_update DATETIME NOT NULL,
  avto tinyint(4) NOT NULL,
  last_update datetime NOT NULL,
  PRIMARY KEY  (id)
);

ALTER TABLE hd_zone_$mid ADD COLUMN avto TINYINT(4) NOT NULL AFTER whois;
ALTER TABLE hd_zone_$mid ADD COLUMN whois_last_update DATETIME NOT NULL AFTER whois;
ALTER TABLE hd_zone_$mid ADD COLUMN data TEXT NOT NULL AFTER zone;
