-- --------------------------------------------------------
--
-- Table structure for table `housekeeping_logins`
--
CREATE TABLE IF NOT EXISTS `housekeeping_logins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(999) NOT NULL,
`user_id` int(11) NOT NULL,
`time` int(11) NOT NULL,
`ip` varchar(999) NOT NULL,
`agent` varchar(999) NOT NULL,
`type` enum('WEBSITE','HOUSEKEEPING') NOT NULL,
`status` enum('TRUE','FALSE') NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `housekeeping_logs`
--
CREATE TABLE IF NOT EXISTS `housekeeping_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`staff_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`page` varchar(999) NOT NULL,
`note` text NOT NULL,
`ip` varchar(999) NOT NULL,
`timestamp` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `housekeeping_panel_catagories`
--
CREATE TABLE IF NOT EXISTS `housekeeping_panel_catagories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(999) NOT NULL,
`permission` varchar(999) NOT NULL,
`enabled` enum('1','0') NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `housekeeping_panel_pages`
--
CREATE TABLE IF NOT EXISTS `housekeeping_panel_pages` (
`id` int(99) NOT NULL AUTO_INCREMENT,
`cat_id` int(11) NOT NULL,
`title` varchar(999) NOT NULL,
`page` varchar(999) NOT NULL,
`permission` varchar(999) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `housekeeping_permissions`
--
CREATE TABLE IF NOT EXISTS `housekeeping_permissions` (
`rank_id` int(1) unsigned NOT NULL,
`hk.login` enum('1','0') NOT NULL DEFAULT '0',
`hk.system` enum('1','0') NOT NULL DEFAULT '0',
`hk.system_status` enum('1','0') NOT NULL DEFAULT '0',
`hk.system_staff` enum('1','0') NOT NULL DEFAULT '0',
`hk.system_version.check` enum('1','0') NOT NULL DEFAULT '0',
`hk.system_kill` enum('1','0') NOT NULL DEFAULT '0',
`hk.logs` enum('1','0') NOT NULL DEFAULT '0',
`hk.logs_site` enum('1','0') NOT NULL DEFAULT '0',
`hk.logs_panel` enum('1','0') NOT NULL DEFAULT '0',
`hk.users` enum('1','0') NOT NULL DEFAULT '0',
`hk.users_view` enum('1','0') NOT NULL DEFAULT '0',
`hk.users_edit` enum('1','0') NOT NULL DEFAULT '0',
`hk.users_reports` enum('1','0') NOT NULL DEFAULT '0',
`hk.users_reports.delete` enum('1','0') NOT NULL DEFAULT '0',
`hk.users_change.password` enum('1','0') NOT NULL DEFAULT '0',
`hk.users_ban` enum('1','0') NOT NULL DEFAULT '0',
`hk.users_unban` enum('1','0') NOT NULL DEFAULT '0',
`hk.users_update.rank` enum('1','0') NOT NULL DEFAULT '0',
`hk.users_permissions` enum('1','0') NOT NULL DEFAULT '0',
`hk.hotel` enum('1','0') NOT NULL DEFAULT '0',
`hk.hotel_users` enum('1','0') NOT NULL DEFAULT '0',
`hk.hotel_settings` enum('1','0') NOT NULL DEFAULT '0',
`hk.hotel_word.filter` enum('1','0') NOT NULL DEFAULT '0',
`hk.hotel_alert` enum('1','0') NOT NULL DEFAULT '0',
`hk.news` enum('1','0') NOT NULL DEFAULT '0',
`hk.news_post` enum('1','0') NOT NULL DEFAULT '0',
`hk.news_edit` enum('1','0') NOT NULL DEFAULT '0',
`hk.news_delete` enum('1','0') NOT NULL DEFAULT '0',
`hk.catalogue_edit` enum('1','0') NOT NULL DEFAULT '0',
`hk.rooms` enum('1','0') NOT NULL DEFAULT '0',
`hk.bots` enum('1','0') NOT NULL DEFAULT '0',
`hk.transactions` enum('1','0') NOT NULL DEFAULT '0',
`hk.cfhs` enum('1','0') NOT NULL DEFAULT '0',
`hk.chatlogs` enum('1','0') NOT NULL DEFAULT '0',
UNIQUE KEY `rank_id` (`rank_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `housekeeping_plugins`
--
CREATE TABLE IF NOT EXISTS `housekeeping_plugins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`plugin_name` varchar(999) NOT NULL,
`plugin_version` varchar(999) NOT NULL,
`plugin_author` int(225) NOT NULL,
`timestamp_added` int(11) NOT NULL,
`plugin_content` text NOT NULL,
`plugin_uninstall` int(11) NOT NULL,
`permission` varchar(999) NOT NULL,
`disable` enum('1','0') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `housekeeping_sessions`
--
CREATE TABLE IF NOT EXISTS `housekeeping_sessions` (
`user_id` int(225) NOT NULL,
`user_name` varchar(999) NOT NULL,
`user_session` varchar(999) NOT NULL,
`user_ip` varchar(999) NOT NULL,
`user_agent` text NOT NULL,
`timestamp` int(225) NOT NULL,
`timestamp_last` int(225) NOT NULL,
`location` text NOT NULL,
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `housekeeping_settings`
--
CREATE TABLE IF NOT EXISTS `housekeeping_settings` (
`variable` varchar(999) NOT NULL,
`content` text NOT NULL,
UNIQUE KEY `variable_2` (`variable`),
KEY `variable` (`variable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `housekeeping_user_reports`
--
CREATE TABLE IF NOT EXISTS `housekeeping_user_reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`staff_id` int(11) NOT NULL,
`title` text NOT NULL,
`timestamp` int(225) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `housekeeping_user_reports_reply`
--
CREATE TABLE IF NOT EXISTS `housekeeping_user_reports_reply` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`report_id` int(11) NOT NULL,
`staff_id` int(11) NOT NULL,
`message` text NOT NULL,
`timestamp` int(225) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;