SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- --------------------------------------------------------
-- Table structure for table `apps_shoutbox_messages`
CREATE TABLE `apps_shoutbox_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`base_user_login_id` int(11) NOT NULL,
`to_user_login_id` int(11) DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci,
`posted_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`deleted` tinyint(4) DEFAULT NULL,
KEY `base_user_login_id` (`base_user_login_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `available_modules`
CREATE TABLE `available_modules` (
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`version` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`name`,`vkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- Dumping data for table `available_modules`
INSERT INTO `available_modules` VALUES
('Applets_Birthdays', 0, '1.0'),
('Applets_Calc', 0, '1.1'),
('Applets_Clock', 0, '1.0'),
('Applets_Google', 0, '1.4'),
('Applets_Host', 0, '1.0'),
('Applets_MonthView', 0, '1.0'),
('Applets_Note', 0, '1.1'),
('Applets_RssFeed', 0, '1.0'),
('Applets_Weather', 0, '0.3'),
('Apps_ActivityReport', 0, '1.0'),
('Apps_Shoutbox', 0, '1.0'),
('Base_About', 0, '1.0'),
('Base_Acl', 0, '1.0.0'),
('Base_ActionBar', 0, '1.0'),
('Base_Admin', 0, '1.0.0'),
('Base_Box', 0, '1.0.0'),
('Base_Dashboard', 0, '1.0'),
('Base_EpesiStore', 0, '1.0'),
('Base_Error', 0, '1.0.0'),
('Base_EssClient', 0, '1.0'),
('Base_Help', 0, '1.0.0'),
('Base_HomePage', 0, '1.0'),
('Base_Lang', 0, '1.0.0'),
('Base_Lang_Administrator', 0, '1.0.0'),
('Base_Mail', 0, '1.0.0'),
('Base_Mail_ContactUs', 0, '1.0'),
('Base_MainModuleIndicator', 0, '1.0.0'),
('Base_Menu', 0, '1.0.0'),
('Base_Menu_QuickAccess', 0, '1.0.0'),
('Base_Notify', 0, '2.0'),
('Base_Print', 0, '1.5.0'),
('Base_RegionalSettings', 0, '1.0'),
('Base_Search', 0, '0.9.1'),
('Base_Setup', 0, '1.0.0'),
('Base_StatusBar', 0, '1.0.0'),
('Base_Theme', 0, '1.0.0'),
('Base_Theme_Administrator', 0, '1.0'),
('Base_User_Administrator', 0, '1.0.0'),
('Base_User_Login', 0, '1.0.0'),
('Base_User_Settings', 0, '1.0'),
('CRM_Calendar', 0, '0.1.0'),
('CRM_Calendar_Event', 0, '1.0'),
('CRM_Common', 0, '0.9'),
('CRM_Contacts', 0, '0.9'),
('CRM_Contacts_AccountManager', 0, '1.0'),
('CRM_Contacts_Activities', 0, '1.0'),
('CRM_Contacts_County', 0, '1.0'),
('CRM_Contacts_NotesAggregate', 0, '1.0'),
('CRM_Contacts_ParentCompany', 0, '1.0'),
('CRM_Contacts_Photo', 0, '1.0'),
('CRM_Filters', 0, '1.0'),
('CRM_Followup', 0, '1.0'),
('CRM_LoginAudit', 0, '1.0'),
('CRM_Meeting', 0, '1.0'),
('CRM_PhoneCall', 0, '1.0'),
('CRM_Roundcube', 0, '0.1'),
('CRM_WhoIsOnline', 0, '1.0'),
('Data_Countries', 0, '2008'),
('Data_TaxRates', 0, '1.0'),
('Libs_CKEditor', 0, '3.5.2'),
('Libs_Codepress', 0, '0.9.6'),
('Libs_Leightbox', 0, '2.03.3'),
('Libs_OpenFlashChart', 0, '1.0'),
('Libs_PHPExcel', 0, '1.7.0'),
('Libs_QuickForm', 0, '3.2.10'),
('Libs_ScriptAculoUs', 0, '1.8.0'),
('Libs_TCPDF', 0, '3.1.001'),
('Tests_Attachment', 0, '0'),
('Tests_Bugtrack', 0, '0.1'),
('Tests_Calendar', 0, '0.1'),
('Tests_Calendar_Event', 0, '0.1'),
('Tests_Callbacks', 0, '1.0.0'),
('Tests_Callbacks_a', 0, '0'),
('Tests_Codepress', 0, '0.1'),
('Tests_Colorpicker', 0, '0.1'),
('Tests_Comment', 0, '0'),
('Tests_GenericBrowser', 0, '0'),
('Tests_Leightbox', 0, '0'),
('Tests_OpenFlashChart', 0, '0.1'),
('Tests_QuickForm', 0, '0'),
('Tests_RecordBrowser', 0, '0'),
('Tests_Report', 0, '0.1'),
('Tests_Search', 0, '0'),
('Tests_SharedUniqueHref', 0, '0'),
('Tests_SharedUniqueHref_a', 0, '0'),
('Tests_TabbedBrowser', 0, '0'),
('Tests_Tooltip', 0, '1.0'),
('Tests_Tooltip', 1, '1.5'),
('Tests_Wizard', 0, '0'),
('Tools_SessionKeeper', 0, '0.9'),
('Tools_SetDefaults', 0, '1.0'),
('Tools_WhoIsOnline', 0, '1.0'),
('Utils_Attachment', 0, '1.0'),
('Utils_BBCode', 0, '1.0'),
('Utils_Calendar', 0, '1.0'),
('Utils_Calendar_Event', 0, '1.0.0'),
('Utils_CalendarBusyReport', 0, '0.1'),
('Utils_CalendarBusyReport_Event', 0, '1.0.0'),
('Utils_CatFile', 0, '1.0.0'),
('Utils_ChainedSelect', 0, '1.0'),
('Utils_Comment', 0, '1.0.0'),
('Utils_CommonData', 0, '0'),
('Utils_CurrencyField', 0, '0'),
('Utils_CustomMenu', 0, '1.0.0'),
('Utils_ExportXLS', 0, '1.0'),
('Utils_FileDownload', 0, '1.0'),
('Utils_FileStorage', 0, '0.1'),
('Utils_FileUpload', 0, '1.0'),
('Utils_FrontPage', 0, '1.0.0'),
('Utils_GenericBrowser', 0, '1.0'),
('Utils_Image', 0, '0.8.9'),
('Utils_LeightboxPrompt', 0, '1.0'),
('Utils_Menu', 0, '1.0.0'),
('Utils_Messenger', 0, '0.1'),
('Utils_Path', 0, '1.0'),
('Utils_Planner', 0, '1.0'),
('Utils_PopupCalendar', 0, '0'),
('Utils_QueryBuilder', 0, '1.0.0'),
('Utils_RecordBrowser', 0, '2.0'),
('Utils_RecordBrowser_CustomRecordsets', 0, '1.0'),
('Utils_RecordBrowser_Filters', 0, '0.1'),
('Utils_RecordBrowser_RecordPicker', 0, '0.1'),
('Utils_RecordBrowser_RecordPickerFS', 0, '0.1'),
('Utils_RecordBrowser_Reports', 0, '1.0'),
('Utils_Shortcut', 0, '1.0.0'),
('Utils_TabbedBrowser', 0, '1.0'),
('Utils_Tooltip', 0, '1.0.0'),
('Utils_Tray', 0, '2.0'),
('Utils_Tree', 0, '1.0'),
('Utils_Watchdog', 0, '1.0'),
('Utils_Wizard', 0, '1.0.0');
-- --------------------------------------------------------
-- Table structure for table `base_acl_clearance`
CREATE TABLE `base_acl_clearance` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`callback` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
-- Dumping data for table `base_acl_clearance`
INSERT INTO `base_acl_clearance` VALUES
(1, 'Base_AclCommon::basic_clearance'),
(2, 'CRM_ContactsCommon::crm_clearance');
-- --------------------------------------------------------
-- Table structure for table `base_acl_permission`
CREATE TABLE `base_acl_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;
-- Dumping data for table `base_acl_permission`
INSERT INTO `base_acl_permission` VALUES
(1, 'Advanced User Settings'),
(3, 'Dashboard - manage applets'),
(5, 'Watchdog - subscribe to categories'),
(6, 'Attachments - view full download history'),
(7, 'Manage Perspective'),
(10, 'View Activity Report'),
-- --------------------------------------------------------
-- Table structure for table `base_acl_rules`
CREATE TABLE `base_acl_rules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`permission_id` int(11) DEFAULT NULL,
KEY `permission_id` (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;
-- Dumping data for table `base_acl_rules`
INSERT INTO `base_acl_rules` VALUES
-- --------------------------------------------------------
-- Table structure for table `base_acl_rules_clearance`
CREATE TABLE `base_acl_rules_clearance` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`rule_id` int(11) DEFAULT NULL,
`clearance` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
KEY `rule_id` (`rule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;
-- Dumping data for table `base_acl_rules_clearance`
INSERT INTO `base_acl_rules_clearance` VALUES
(1, 1, 'ACCESS:employee'),
(2, 2, 'ACCESS:employee'),
(3, 3, 'ACCESS:employee'),
(4, 4, 'ACCESS:employee'),
(5, 5, 'ACCESS:employee'),
(6, 5, 'ACCESS:manager'),
(7, 6, 'ACCESS:employee'),
(8, 7, 'ACCESS:employee'),
(9, 8, 'ACCESS:employee'),
(10, 9, 'ACCESS:employee'),
(11, 10, 'ACCESS:employee'),
(12, 10, 'ACCESS:manager'),
(13, 11, 'ACCESS:employee'),
-- --------------------------------------------------------
-- Table structure for table `base_admin_access`
CREATE TABLE `base_admin_access` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`section` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`allow` tinyint(4) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `base_dashboard_applets`
CREATE TABLE `base_dashboard_applets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_login_id` int(11) DEFAULT NULL,
`module_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`col` smallint(6) DEFAULT '0',
`pos` smallint(6) DEFAULT '0',
`color` smallint(6) DEFAULT '0',
`tab` int(11) DEFAULT NULL,
KEY `user_login_id` (`user_login_id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
-- Dumping data for table `base_dashboard_applets`
INSERT INTO `base_dashboard_applets` VALUES
(1, 1, 'Applets_Clock', 2, 0, 1, 1),
(2, 1, 'CRM_Tasks', 1, 0, 6, 1),
(3, 1, 'Applets_Note', 2, 0, 10, 1),
(4, 1, 'Utils_Watchdog', 0, 0, 6, 1),
(5, 1, 'CRM_PhoneCall', 1, 0, 8, 1),
(6, 1, 'Apps_Shoutbox', 0, 0, 0, 1),
(7, 1, 'CRM_Calendar', 1, 0, 0, 1);
-- --------------------------------------------------------
-- Table structure for table `base_dashboard_default_applets`
CREATE TABLE `base_dashboard_default_applets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`col` smallint(6) DEFAULT '0',
`pos` smallint(6) DEFAULT '0',
`color` smallint(6) DEFAULT '0',
`tab` int(11) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
-- Dumping data for table `base_dashboard_default_applets`
INSERT INTO `base_dashboard_default_applets` VALUES
(1, 'Applets_Clock', 2, 0, 1, 1),
(2, 'CRM_Tasks', 1, 0, 6, 1),
(3, 'CRM_PhoneCall', 1, 1, 8, 1),
(4, 'Applets_Note', 2, 0, 10, 1),
(5, 'CRM_Calendar', 1, 2, 0, 1),
(6, 'Apps_Shoutbox', 0, 1, 0, 1),
(7, 'Utils_Watchdog', 0, 0, 6, 1);
-- --------------------------------------------------------
-- Table structure for table `base_dashboard_default_settings`
CREATE TABLE `base_dashboard_default_settings` (
`applet_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`value` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`applet_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- Dumping data for table `base_dashboard_default_settings`
INSERT INTO `base_dashboard_default_settings` VALUES
(4, 'bcolor', 'nice-yellow'),
(4, 'text', '<div><strong>Congratulations!</strong><br />You''ve just installed EPESI!</div><div>For more information, help and support please visit <a href="http://epe.si" target="_blank">EPESI website </a></div>'),
-- --------------------------------------------------------
-- Table structure for table `base_dashboard_default_tabs`
CREATE TABLE `base_dashboard_default_tabs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`pos` smallint(6) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- Dumping data for table `base_dashboard_default_tabs`
INSERT INTO `base_dashboard_default_tabs` VALUES
-- --------------------------------------------------------
-- Table structure for table `base_dashboard_settings`
CREATE TABLE `base_dashboard_settings` (
`applet_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`value` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`applet_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- Dumping data for table `base_dashboard_settings`
INSERT INTO `base_dashboard_settings` VALUES
(3, 'bcolor', 'nice-yellow'),
(3, 'text', '<div><strong>Congratulations!</strong><br />You''ve just installed EPESI!</div><div>For more information, help and support please visit <a href="http://epe.si" target="_blank">EPESI website </a></div>'),
-- --------------------------------------------------------
-- Table structure for table `base_dashboard_tabs`
CREATE TABLE `base_dashboard_tabs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_login_id` int(11) DEFAULT NULL,
`name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`pos` smallint(6) DEFAULT NULL,
KEY `user_login_id` (`user_login_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
-- Dumping data for table `base_dashboard_tabs`
INSERT INTO `base_dashboard_tabs` VALUES
-- --------------------------------------------------------
-- Table structure for table `base_home_page`
CREATE TABLE `base_home_page` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`priority` int(11) DEFAULT NULL,
`home_page` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
-- Dumping data for table `base_home_page`
INSERT INTO `base_home_page` VALUES
-- --------------------------------------------------------
-- Table structure for table `base_home_page_clearance`
CREATE TABLE `base_home_page_clearance` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`home_page_id` int(11) DEFAULT NULL,
`clearance` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
