CREATE TABLE IF NOT EXISTS ohrm_data_list_settings (id int(10) AUTO_INCREMENT, user_id int(10), data_list_id int(10) NOT NULL, search_parameters TEXT, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE IF NOT EXISTS ohrm_data_list (id int(10) AUTO_INCREMENT, name varchar(255), PRIMARY KEY(id)) ENGINE = INNODB;

INSERT INTO ohrm_data_list (`name`) VALUES ('employee_list');

ALTER TABLE `ohrm_data_list_settings`
  ADD CONSTRAINT `fk_ohrm_data_list_settings_ohrm_user` FOREIGN KEY (`user_id`) REFERENCES `ohrm_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;