(09-24-2015, 08:32 PM)kandrews Wrote: If you need to fix after the conversion over to sentora_ prefixed databases run the following:
Code:CREATE TABLE `sentora_core`.`x_htpasswd_file` ( `x_htpasswd_file_id` int(11) NOT NULL AUTO_INCREMENT, `x_htpasswd_file_target` varchar(255) NOT NULL, `x_htpasswd_file_message` varchar(255) NOT NULL, `x_htpasswd_file_created` int(11) NOT NULL, `x_htpasswd_file_deleted` int(11) DEFAULT NULL, `x_htpasswd_sentora_user_id` int(11) NOT NULL, PRIMARY KEY (`x_htpasswd_file_id`), UNIQUE KEY `x_htpasswd_file_target` (`x_htpasswd_file_target`), KEY `x_htpasswd_file_x_htpasswd_sentora_user_id_idx` (`x_htpasswd_sentora_user_id`) ) DEFAULT CHARSET=utf8; CREATE TABLE `sentora_core`.`x_htpasswd_mapper` ( `x_htpasswd_mapper_id` int(11) NOT NULL AUTO_INCREMENT, `x_htpasswd_file_id` int(11) NOT NULL, `x_htpasswd_user_id` int(11) NOT NULL, PRIMARY KEY (`x_htpasswd_mapper_id`), KEY `x_htpasswd_mapper_x_htpasswd_file_id_idx` (`x_htpasswd_file_id`), KEY `x_htpasswd_mapper_x_htpasswd_user_id_idx` (`x_htpasswd_user_id`) ) DEFAULT CHARSET=utf8; CREATE TABLE `sentora_core`.`x_htpasswd_user` ( `x_htpasswd_user_id` int(11) NOT NULL AUTO_INCREMENT, `x_htpasswd_user_username` varchar(255) NOT NULL, `x_htpasswd_user_password` varchar(255) NOT NULL, `x_htpasswd_user_created` int(11) NOT NULL, `x_htpasswd_user_deleted` int(11) DEFAULT NULL, `x_htpasswd_sentora_user_id` int(11) NOT NULL, PRIMARY KEY (`x_htpasswd_user_id`), UNIQUE KEY `x_htpasswd_user_username` (`x_htpasswd_user_username`), UNIQUE KEY `x_htpasswd_user_password` (`x_htpasswd_user_password`) ) DEFAULT CHARSET=utf8;
This code is in the update-structure.sql file. Strange it did not appeared.
Gone give it another go.


![[Image: logo2.png]](https://www.webimproved.nl/templates/web_improved/images/logo2.png)
