DROP TABLE `domains`, `records`, `supermasters`; ALTER TABLE `dns_record` CHANGE `record_id` `id` INT(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `dns_record` CHANGE `zone_id` `domain_id` INT(11) NULL DEFAULT NULL; ALTER TABLE `dns_record` CHANGE `name` `name` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `dns_record` CHANGE `type` `type` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `dns_record` CHANGE `content` `content` VARCHAR(64000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `dns_record` ADD `disabled` TINYINT(1) NULL DEFAULT '0' AFTER `change_date`; ALTER TABLE `dns_record` ADD `ordername` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_bin NULL DEFAULT NULL AFTER `disabled`; ALTER TABLE `dns_record` ADD `auth` TINYINT(1) NULL DEFAULT '1' AFTER `ordername`; RENAME TABLE dns_record to records; UPDATE records set disabled="0"; CREATE INDEX nametype_index ON records(name,type); CREATE INDEX domain_id ON records(domain_id); CREATE INDEX recordorder ON records (domain_id, ordername); ALTER TABLE `dns_zone` CHANGE `name` `name` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `dns_zone` CHANGE `master` `master` VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `dns_zone` CHANGE `type` `type` VARCHAR(6) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL; ALTER TABLE `dns_zone` CHANGE `account` `account` VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; ALTER TABLE `dns_zone` DROP `client_id`, DROP `service_id`; ALTER TABLE `dns_zone` CHANGE `zone_id` `id` INT(11) NOT NULL AUTO_INCREMENT; RENAME TABLE dns_zone to domains; CREATE UNIQUE INDEX name_index ON domains(name); RENAME TABLE dns_supermaster to supermasters; ALTER TABLE supermasters MODIFY ip VARCHAR(64) NOT NULL; ALTER TABLE supermasters MODIFY account VARCHAR(40) NOT NULL;