drop table if exists sknic_domains_stats;
create table sknic_domains_stats
(
	stat_date		date	not null,
	stat_type		enum('id_reg', 'id_owner', 'status', 'revenue') default NULL,
	stat_value		varchar(9),
	stat_count		integer,
	primary key (stat_date, stat_type, stat_value),
	key sknic_domains_stats_stat_date (stat_date),
	key sknic_domains_stats_stat_type (stat_type),
	key sknic_domains_stats_value (stat_value),
	key sknic_domains_stats_count (stat_count)
);

drop table if exists sknic_domains;
create table sknic_domains -- means sknic_domains_current
(
	domain		varchar(255) not NULL,
	id_reg		varchar(9) default NULL,
	id_owner	varchar(9) default NULL,
	flag enum('NEW','OLD') default NULL,
	status enum('DOM_LNOT','DOM_OK','DOM_TA','DOM_TRAN','DOM_WARN') default NULL,
	ns1 varchar(255) default NULL,
	ns2 varchar(255) default NULL,
	ns3 varchar(255) default NULL,
	ns4 varchar(255) default NULL,
	ico_owner varchar(8) default NULL,
	dt_valid	date	default NULL,
	dt_changed	date	not NULL,
	primary key (domain),
	key sknic_domains_id_reg		(id_reg),
	key sknic_domains_id_owner	(id_owner),
	key sknic_domains_flag		(flag),
	key sknic_domains_status		(status),
	key sknic_domains_ns1			(ns1),
	key sknic_domains_ns2			(ns2),
	key sknic_domains_ns3			(ns3),
	key sknic_domains_ns4			(ns4),
	key sknic_domains_ico_owner	(ico_owner),
	key sknic_domains_dt_valid	(dt_valid),
	key sknic_domains_dt_changed	(dt_changed)
);

drop table if exists sknic_domains_import;
create table sknic_domains_import
(
	domain		varchar(255) not NULL,
	id_reg		varchar(9) default NULL,
	id_owner	varchar(9) default NULL,
	flag enum('NEW','OLD') default NULL,
	status enum('DOM_LNOT','DOM_OK','DOM_TA','DOM_TRAN','DOM_WARN') default NULL,
	ns1 varchar(255) default NULL,
	ns2 varchar(255) default NULL,
	ns3 varchar(255) default NULL,
	ns4 varchar(255) default NULL,
	ico_owner varchar(8) default NULL,
	dt_valid	date	default NULL,
	dt_changed	date	default NULL,
	primary key (domain),
	key sknic_domains_import_id_reg		(id_reg),
	key sknic_domains_import_id_owner	(id_owner),
	key sknic_domains_import_flag		(flag),
	key sknic_domains_import_status		(status),
	key sknic_domains_import_ns1			(ns1),
	key sknic_domains_import_ns2			(ns2),
	key sknic_domains_import_ns3			(ns3),
	key sknic_domains_import_ns4			(ns4),
	key sknic_domains_import_ico_owner	(ico_owner),
	key sknic_domains_import_dt_valid		(dt_valid),
	key sknic_domains_import_dt_changed	(dt_changed)
);

drop table if exists sknic_domains_history;
create table sknic_domains_history
(
	domain		varchar(255) not NULL,
	id_reg		varchar(9) default NULL,
	id_owner	varchar(9) default NULL,
	flag enum('NEW','OLD') default NULL,
	status enum('DOM_LNOT','DOM_OK','DOM_TA','DOM_TRAN','DOM_WARN') default NULL,
	ns1 varchar(255) default NULL,
	ns2 varchar(255) default NULL,
	ns3 varchar(255) default NULL,
	ns4 varchar(255) default NULL,
	ico_owner varchar(8) default NULL,
	dt_valid	date	default NULL,
	dt_changed	date	not NULL,
	dt_deleted	date,
	primary key (domain, dt_changed), -- note PRIMARY KEY change
	key sknic_domains_history_id_reg		(id_reg),
	key sknic_domains_history_id_owner	(id_owner),
	key sknic_domains_history_flag		(flag),
	key sknic_domains_history_status		(status),
	key sknic_domains_history_ns1			(ns1),
	key sknic_domains_history_ns2			(ns2),
	key sknic_domains_history_ns3			(ns3),
	key sknic_domains_history_ns4			(ns4),
	key sknic_domains_history_ico_owner	(ico_owner),
	key sknic_domains_history_dt_valid	(dt_valid),
	key sknic_domains_history_dt_changed	(dt_changed),
	key sknic_domains_history_dt_deleted	(dt_deleted)
);