--
-- Powered by CentralNic
--

ALTER TABLE sknic_domains         DISABLE KEYS;
ALTER TABLE sknic_domains_history DISABLE KEYS;
ALTER TABLE sknic_domains_import  DISABLE KEYS;
ALTER TABLE sknic_domains_stats   DISABLE KEYS;

-- We *must* do this later (2017/10)
-- ALTER TABLE sknic_domains        DROP COLUMN ico_owner;
-- ALTER TABLE sknic_domains_import DROP COLUMN ico_owner;
-- NOTE: sknic_domains_history is still keeping ico_owner

ALTER TABLE sknic_domains         DROP COLUMN flag;
ALTER TABLE sknic_domains_history DROP COLUMN flag;
ALTER TABLE sknic_domains_import  DROP COLUMN flag;

ALTER TABLE sknic_domains         MODIFY status VARCHAR(10) DEFAULT NULL;
ALTER TABLE sknic_domains_history MODIFY status VARCHAR(10) DEFAULT NULL;
ALTER TABLE sknic_domains_import  MODIFY status VARCHAR(10) DEFAULT NULL;

ALTER TABLE sknic_domains         MODIFY id_reg VARCHAR(64) DEFAULT NULL;
ALTER TABLE sknic_domains_history MODIFY id_reg VARCHAR(64) DEFAULT NULL;
ALTER TABLE sknic_domains_import  MODIFY id_reg VARCHAR(64) DEFAULT NULL;

ALTER TABLE sknic_domains         MODIFY id_owner VARCHAR(64) DEFAULT NULL;
ALTER TABLE sknic_domains_history MODIFY id_owner VARCHAR(64) DEFAULT NULL;
ALTER TABLE sknic_domains_import  MODIFY id_owner VARCHAR(64) DEFAULT NULL;

ALTER TABLE sknic_domains_stats   MODIFY stat_value VARCHAR(64) DEFAULT '';

ALTER TABLE sknic_domains         ENABLE KEYS;
ALTER TABLE sknic_domains_history ENABLE KEYS;
ALTER TABLE sknic_domains_import  ENABLE KEYS;
ALTER TABLE sknic_domains_stats   ENABLE KEYS;