CREATE TABLE sknic_droplist_import (
	domain varchar(255),
	date_entered datetime,
	date_leaves datetime,
	date_purged datetime,
	dt_changed date DEFAULT NULL,
	PRIMARY KEY (domain),
	KEY sknic_droplist_import_date_entered (date_entered),
	KEY sknic_droplist_import_date_leaves (date_leaves),
	KEY sknic_droplist_import_date_purged (date_purged),
	KEY sknic_droplist_import_dt_changed (dt_changed)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE sknic_droplist (
	domain varchar(255),
	date_entered datetime,
	date_leaves datetime,
	date_purged datetime,
	dt_changed date NOT NULL,
	PRIMARY KEY (domain),
	KEY sknic_droplist_date_entered (date_entered),
	KEY sknic_droplist_date_leaves (date_leaves),
	KEY sknic_droplist_date_purged (date_purged),
	KEY sknic_droplist_dt_changed (dt_changed)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE sknic_droplist_history (
	domain varchar(255),
	date_entered datetime,
	date_leaves datetime,
	date_purged datetime,
	dt_changed date NOT NULL,
	dt_deleted date DEFAULT NULL,
	PRIMARY KEY (domain),
	KEY sknic_droplist_history_date_entered (date_entered),
	KEY sknic_droplist_history_date_leaves (date_leaves),
	KEY sknic_droplist_history_date_purged (date_purged),
	KEY sknic_droplist_history_dt_changed (dt_changed),
	KEY sknic_droplist_history_dt_deleted (dt_deleted)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;