CREATE TABLE sknic_registrars_import (
	id_reg varchar(64) NOT NULL,
	name varchar(255) DEFAULT NULL,
	street varchar(255) DEFAULT NULL,
	city varchar(255) DEFAULT NULL,
	phone varchar(255) DEFAULT NULL,
	email varchar(255) DEFAULT NULL,
	dt_changed date DEFAULT NULL,
	PRIMARY KEY (id_reg),
	KEY sknic_registrars_import_name (name),
	KEY sknic_registrars_import_dt_changed (dt_changed)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE sknic_registrars (
	id_reg varchar(64) NOT NULL,
	name varchar(255) DEFAULT NULL,
	street varchar(255) DEFAULT NULL,
	city varchar(255) DEFAULT NULL,
	phone varchar(255) DEFAULT NULL,
	email varchar(255) DEFAULT NULL,
	dt_changed date NOT NULL,
	PRIMARY KEY (id_reg),
	KEY sknic_registrars_name (name),
	KEY sknic_registrars_dt_changed (dt_changed)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE sknic_registrars_history (
	id_reg varchar(64) NOT NULL,
	name varchar(255) DEFAULT NULL,
	street varchar(255) DEFAULT NULL,
	city varchar(255) DEFAULT NULL,
	phone varchar(255) DEFAULT NULL,
	email varchar(255) DEFAULT NULL,
	dt_changed date NOT NULL,
	dt_deleted date DEFAULT NULL,
	PRIMARY KEY (id_reg, dt_changed),
	KEY sknic_registrars_name (name),
	KEY sknic_registrars_history_dt_changed (dt_changed),
	KEY sknic_registrars_history_dt_deleted (dt_deleted)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;