User Tools

Site Tools


software:poweradmin:table_fix_214
CREATE TABLE `zone_templ` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT '0',
  `descr` varchar(1024) NOT NULL DEFAULT '0',
  `owner` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `zone_templ_records` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `zone_templ_id` bigint(20) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '0',
  `type` varchar(6) NOT NULL DEFAULT '0',
  `content` varchar(255) NOT NULL DEFAULT '0',
  `ttl` bigint(20) NOT NULL DEFAULT '0',
  `prio` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
software/poweradmin/table_fix_214.txt · Last modified: 2010/01/26 16:42 by brielle