-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `evalibiilling`
--

-- --------------------------------------------------------

--
-- Table structure for table `account_balances`
--

CREATE TABLE `account_balances` (
  `id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT 0,
  `currency_id` int(11) NOT NULL DEFAULT 0,
  `balance` decimal(16,4) NOT NULL DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `crm_actionplans`
--

CREATE TABLE `crm_actionplans` (
  `id` int(11) NOT NULL,
  `type` varchar(200) DEFAULT NULL,
  `topicid` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crm_actionplans`
--

INSERT INTO `crm_actionplans` (`id`, `type`, `topicid`) VALUES
(8, 'Identified weaknesses or gaps', '1'),
(9, 'QMS Skill Component', '1'),
(10, 'Capacity Building Action to be taken', '1'),
(11, 'Suggested Timelines', '1'),
(12, 'Identified System Gap', '2'),
(13, 'QMS Component', '2'),
(14, 'System Stengthening Action to be taken', '2'),
(15, 'Suggested Timelines', '2');

-- --------------------------------------------------------

--
-- Table structure for table `crm_customfields`
--

CREATE TABLE `crm_customfields` (
  `id` int(10) NOT NULL,
  `ctype` text DEFAULT NULL,
  `relid` int(10) NOT NULL DEFAULT 0,
  `fieldname` text DEFAULT NULL,
  `fieldtype` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `fieldoptions` text DEFAULT NULL,
  `regexpr` text DEFAULT NULL,
  `adminonly` text DEFAULT NULL,
  `required` text DEFAULT NULL,
  `showorder` text DEFAULT NULL,
  `showinvoice` text DEFAULT NULL,
  `sorder` int(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `crm_customfieldsvalues`
--

CREATE TABLE `crm_customfieldsvalues` (
  `id` int(10) NOT NULL,
  `fieldid` int(10) NOT NULL,
  `relid` int(10) NOT NULL,
  `fvalue` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `crm_groups`
--

CREATE TABLE `crm_groups` (
  `id` int(11) NOT NULL,
  `gname` varchar(200) DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  `discount` varchar(50) DEFAULT NULL,
  `parent` varchar(200) DEFAULT NULL,
  `pid` int(10) DEFAULT NULL,
  `exempt` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `separateinvoices` text DEFAULT NULL,
  `sorder` int(10) DEFAULT NULL,
  `c1` varchar(200) DEFAULT NULL,
  `c2` varchar(200) DEFAULT NULL,
  `c3` varchar(200) DEFAULT NULL,
  `c4` varchar(200) DEFAULT NULL,
  `c5` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crm_groups`
--

INSERT INTO `crm_groups` (`id`, `gname`, `color`, `discount`, `parent`, `pid`, `exempt`, `description`, `separateinvoices`, `sorder`, `c1`, `c2`, `c3`, `c4`, `c5`) VALUES
(1, 'test', '', '', '', 0, '', '', '', 0, '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `crm_industries`
--

CREATE TABLE `crm_industries` (
  `id` int(11) NOT NULL,
  `industry` varchar(200) DEFAULT NULL,
  `is_active` int(1) NOT NULL DEFAULT 1,
  `is_default` int(1) NOT NULL DEFAULT 0,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crm_industries`
--

INSERT INTO `crm_industries` (`id`, `industry`, `is_active`, `is_default`, `sorder`, `created_at`, `updated_at`) VALUES
(1, 'Agriculture', 1, 0, 0, NULL, NULL),
(2, 'Apparel', 1, 0, 0, NULL, NULL),
(3, 'Banking', 1, 0, 0, NULL, NULL),
(4, 'Biotechnology', 1, 0, 0, NULL, NULL),
(5, 'Chemicals', 1, 0, 0, NULL, NULL),
(6, 'Communications', 1, 0, 0, NULL, NULL),
(7, 'Construction', 1, 0, 0, NULL, NULL),
(8, 'Consulting', 1, 0, 0, NULL, NULL),
(9, 'Education', 1, 0, 0, NULL, NULL),
(10, 'Electronics', 1, 0, 0, NULL, NULL),
(11, 'Energy', 1, 0, 0, NULL, NULL),
(12, 'Engineering', 1, 0, 0, NULL, NULL),
(13, 'Entertainment', 1, 0, 0, NULL, NULL),
(14, 'Environmental', 1, 0, 0, NULL, NULL),
(15, 'Finance', 1, 0, 0, NULL, NULL),
(16, 'Food & Beverage', 1, 0, 0, NULL, NULL),
(17, 'Government', 1, 0, 0, NULL, NULL),
(18, 'Healthcare', 1, 0, 0, NULL, NULL),
(19, 'Hospitality', 1, 0, 0, NULL, NULL),
(20, 'Insurance', 1, 0, 0, NULL, NULL),
(21, 'Machinery', 1, 0, 0, NULL, NULL),
(22, 'Manufacturing', 1, 0, 0, NULL, NULL),
(23, 'Media', 1, 0, 0, NULL, NULL),
(24, 'Not For Profit', 1, 0, 0, NULL, NULL),
(25, 'Other', 1, 0, 0, NULL, NULL),
(26, 'Recreation', 1, 0, 0, NULL, NULL),
(27, 'Retail', 1, 0, 0, NULL, NULL),
(28, 'Shipping', 1, 0, 0, NULL, NULL),
(29, 'Technology', 1, 0, 0, NULL, NULL),
(30, 'Telecommunications', 1, 0, 0, NULL, NULL),
(31, 'Transportation', 1, 0, 0, NULL, NULL),
(32, 'Utilities', 1, 0, 0, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `crm_itesters`
--

CREATE TABLE `crm_itesters` (
  `id` int(11) NOT NULL,
  `noy` varchar(200) DEFAULT NULL,
  `userid` varchar(100) DEFAULT NULL,
  `itype` varchar(100) DEFAULT NULL,
  `age` varchar(200) DEFAULT NULL,
  `iname` varchar(100) DEFAULT NULL,
  `lvsd` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crm_itesters`
--

INSERT INTO `crm_itesters` (`id`, `noy`, `userid`, `itype`, `age`, `iname`, `lvsd`, `created_at`) VALUES
(1, '', '3', NULL, NULL, NULL, NULL, '2021-03-11 19:54:57'),
(2, '10', '3', NULL, NULL, NULL, NULL, '2021-03-11 20:07:48'),
(3, '', '3', NULL, NULL, NULL, NULL, '2021-03-27 14:22:16'),
(4, '', '11', NULL, NULL, NULL, NULL, '2021-04-01 23:57:15'),
(5, '2', '13', NULL, NULL, NULL, NULL, '2022-01-21 12:59:42');

-- --------------------------------------------------------

--
-- Table structure for table `crm_leads`
--

CREATE TABLE `crm_leads` (
  `id` int(11) NOT NULL,
  `secret` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `o` varchar(200) DEFAULT NULL,
  `oid` int(11) NOT NULL DEFAULT 0,
  `salutation` varchar(200) DEFAULT NULL,
  `first_name` varchar(200) DEFAULT NULL,
  `middle_name` varchar(200) DEFAULT NULL,
  `last_name` varchar(200) DEFAULT NULL,
  `suffix` varchar(200) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `company` varchar(200) DEFAULT NULL,
  `company_id` int(11) NOT NULL DEFAULT 0,
  `website` varchar(200) DEFAULT NULL,
  `industry` varchar(200) DEFAULT NULL,
  `employees` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `color` varchar(20) DEFAULT NULL,
  `source` varchar(200) DEFAULT NULL,
  `added_from` varchar(200) DEFAULT NULL,
  `mobile` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `street` varchar(200) DEFAULT NULL,
  `city` varchar(200) DEFAULT NULL,
  `state` varchar(200) DEFAULT NULL,
  `zip` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` varchar(200) DEFAULT NULL,
  `viewed_at` datetime DEFAULT NULL,
  `cid` int(11) NOT NULL DEFAULT 0,
  `aid` int(11) NOT NULL DEFAULT 0,
  `iid` int(11) NOT NULL DEFAULT 0,
  `rid` int(11) NOT NULL DEFAULT 0,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `assigned` int(11) NOT NULL DEFAULT 0,
  `last_contact` datetime DEFAULT NULL,
  `last_contact_by` varchar(200) DEFAULT NULL,
  `date_converted` datetime DEFAULT NULL,
  `public` int(1) NOT NULL DEFAULT 0,
  `ratings` varchar(50) DEFAULT NULL,
  `flag` int(1) NOT NULL DEFAULT 0,
  `lost` int(1) NOT NULL DEFAULT 0,
  `junk` int(1) NOT NULL DEFAULT 0,
  `trash` int(1) NOT NULL DEFAULT 0,
  `archived` int(1) NOT NULL DEFAULT 0,
  `memo` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `crm_lead_sources`
--

CREATE TABLE `crm_lead_sources` (
  `id` int(11) NOT NULL,
  `sname` varchar(200) DEFAULT NULL,
  `is_active` int(1) NOT NULL DEFAULT 1,
  `is_default` int(1) NOT NULL DEFAULT 1,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crm_lead_sources`
--

INSERT INTO `crm_lead_sources` (`id`, `sname`, `is_active`, `is_default`, `sorder`, `created_at`, `updated_at`) VALUES
(1, 'Advertisement', 1, 1, 0, NULL, NULL),
(2, 'Customer Event', 1, 1, 0, NULL, NULL),
(3, 'Employee Referral', 1, 1, 0, NULL, NULL),
(4, 'Google AdWords', 1, 1, 0, NULL, NULL),
(5, 'Other', 1, 1, 0, NULL, NULL),
(6, 'Partner', 1, 1, 0, NULL, NULL),
(7, 'Purchased List', 1, 1, 0, NULL, NULL),
(8, 'Trade Show', 1, 1, 0, NULL, NULL),
(9, 'Webinar', 1, 1, 0, NULL, NULL),
(10, 'Website', 1, 1, 0, NULL, NULL),
(11, 'Facebook', 1, 1, 0, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `crm_lead_status`
--

CREATE TABLE `crm_lead_status` (
  `id` int(11) NOT NULL,
  `sname` varchar(200) DEFAULT NULL,
  `is_active` int(1) NOT NULL DEFAULT 1,
  `is_default` int(1) NOT NULL DEFAULT 0,
  `is_converted` int(1) NOT NULL DEFAULT 0,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crm_lead_status`
--

INSERT INTO `crm_lead_status` (`id`, `sname`, `is_active`, `is_default`, `is_converted`, `sorder`, `created_at`, `updated_at`) VALUES
(1, 'Unqualified', 1, 0, 0, 0, NULL, NULL),
(2, 'New', 1, 1, 0, 0, NULL, NULL),
(3, 'Working', 1, 0, 0, 0, NULL, NULL),
(4, 'Nurturing', 1, 0, 0, 0, NULL, NULL),
(5, 'Qualified', 1, 0, 0, 0, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `crm_results_actionplan`
--

CREATE TABLE `crm_results_actionplan` (
  `id` int(11) NOT NULL,
  `testid` varchar(200) DEFAULT NULL,
  `userid` varchar(100) DEFAULT NULL,
  `actionplan` varchar(100) DEFAULT NULL,
  `useractionp` varchar(200) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `crm_salutations`
--

CREATE TABLE `crm_salutations` (
  `id` int(11) NOT NULL,
  `sname` varchar(200) DEFAULT NULL,
  `is_active` int(1) NOT NULL DEFAULT 1,
  `is_default` int(1) NOT NULL DEFAULT 0,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crm_salutations`
--

INSERT INTO `crm_salutations` (`id`, `sname`, `is_active`, `is_default`, `sorder`, `created_at`, `updated_at`) VALUES
(1, 'Mr.', 1, 0, 0, NULL, NULL),
(2, 'Ms.', 1, 0, 0, NULL, NULL),
(3, 'Mrs.', 1, 0, 0, NULL, NULL),
(4, 'Dr.', 1, 0, 0, NULL, NULL),
(5, 'Prof.', 1, 0, 0, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `crm_testers`
--

CREATE TABLE `crm_testers` (
  `id` int(11) NOT NULL,
  `noy` varchar(200) DEFAULT NULL,
  `userid` varchar(100) DEFAULT NULL,
  `eaddress` varchar(100) DEFAULT NULL,
  `gender` varchar(200) DEFAULT NULL,
  `lvledu` varchar(100) DEFAULT NULL,
  `training` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `yexp` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `crm_testers`
--

INSERT INTO `crm_testers` (`id`, `noy`, `userid`, `eaddress`, `gender`, `lvledu`, `training`, `created_at`, `yexp`) VALUES
(1, '', '3', '', '', '', '', '2020-10-20 12:42:29', ''),
(2, '', '6', '', '', '', '', '2020-10-20 18:32:09', ''),
(3, '', '3', '', '', '', '', '2021-01-05 09:52:08', ''),
(4, '', '7', '', '', '', '', '2021-01-07 20:45:16', ''),
(5, '3', '7', 'uredospores@yahoo.com', 'Male', 'Undergraduate', 'None', '2021-01-16 14:59:01', '1'),
(6, '10', '3', 'dennis@creativehaven.co.ke', 'Male', 'Degree', 'N/A', '2021-03-02 07:50:21', '5');

-- --------------------------------------------------------

--
-- Table structure for table `ib_doc_rel`
--

CREATE TABLE `ib_doc_rel` (
  `id` int(11) NOT NULL,
  `rtype` varchar(100) NOT NULL DEFAULT 'contact',
  `rid` int(11) NOT NULL DEFAULT 0,
  `did` int(11) NOT NULL DEFAULT 0,
  `can_download` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `ib_invoice_access_log`
--

CREATE TABLE `ib_invoice_access_log` (
  `id` int(11) NOT NULL,
  `lid` int(11) NOT NULL DEFAULT 0,
  `cid` int(11) NOT NULL DEFAULT 0,
  `iid` int(11) NOT NULL DEFAULT 0,
  `company_id` int(11) NOT NULL DEFAULT 0,
  `customer` varchar(200) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `browser` varchar(200) DEFAULT NULL,
  `referer` varchar(200) DEFAULT NULL,
  `city` varchar(200) DEFAULT NULL,
  `postal_code` varchar(50) DEFAULT NULL,
  `country` varchar(200) DEFAULT NULL,
  `country_iso` varchar(20) DEFAULT NULL,
  `viewed_at` varchar(200) DEFAULT NULL,
  `lat` varchar(100) DEFAULT NULL,
  `lon` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_accounts`
--

CREATE TABLE `sys_accounts` (
  `id` int(11) NOT NULL,
  `account` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `balance` decimal(18,2) NOT NULL DEFAULT 0.00,
  `bank_name` varchar(200) DEFAULT NULL,
  `account_number` varchar(200) DEFAULT NULL,
  `currency` varchar(20) DEFAULT NULL,
  `branch` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `contact_person` varchar(200) DEFAULT NULL,
  `contact_phone` varchar(100) DEFAULT NULL,
  `website` varchar(200) DEFAULT NULL,
  `ib_url` varchar(200) DEFAULT NULL,
  `created` date DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `sorder` int(11) DEFAULT NULL,
  `e` varchar(200) DEFAULT NULL,
  `token` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_actionplan`
--

CREATE TABLE `sys_actionplan` (
  `id` int(10) NOT NULL,
  `weakness` text DEFAULT NULL,
  `skills` text DEFAULT NULL,
  `capacity` text DEFAULT NULL,
  `suggested` text DEFAULT NULL,
  `itemno` text DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `resultid` varchar(200) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_actionplan`
--

INSERT INTO `sys_actionplan` (`id`, `weakness`, `skills`, `capacity`, `suggested`, `itemno`, `level`, `resultid`) VALUES
(1, 'cadsd', '', '', '', '1', 0, '2'),
(2, '', '', 'asdasdas', 'dasdasd', '3', 0, '2'),
(3, '', 'asdasdasd', '', '', '4', 0, '2'),
(4, '', '', 'asdasd', 'asdasd', '5', 0, '2'),
(5, 'Designing QI projects', 'QI project management and design', 'Training', '2 weeks', '1', NULL, '6');

-- --------------------------------------------------------

--
-- Table structure for table `sys_activity`
--

CREATE TABLE `sys_activity` (
  `id` int(11) NOT NULL,
  `cid` int(11) NOT NULL DEFAULT 0,
  `msg` text NOT NULL,
  `icon` varchar(100) NOT NULL DEFAULT '',
  `stime` varchar(50) NOT NULL,
  `sdate` date NOT NULL,
  `o` int(11) NOT NULL DEFAULT 0,
  `oname` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_appconfig`
--

CREATE TABLE `sys_appconfig` (
  `id` int(11) NOT NULL,
  `setting` text NOT NULL,
  `value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_appconfig`
--

INSERT INTO `sys_appconfig` (`id`, `setting`, `value`) VALUES
(1, 'CompanyName', 'Health Systems Evaluation'),
(29, 'theme', 'ibilling'),
(37, 'currency_code', 'Ksh'),
(56, 'language', 'en'),
(57, 'show-logo', '1'),
(58, 'nstyle', 'blue'),
(63, 'dec_point', '.'),
(64, 'thousands_sep', ','),
(65, 'timezone', 'Africa/Nairobi'),
(66, 'country', 'Kenya'),
(67, 'country_code', 'US'),
(68, 'df', 'd/m/Y'),
(69, 'caddress', 'SYSTEMS Evaluation Limited\r\nLutheran Church Compound,\r\nAlong Ondiek Road off Nairobi Road, Kisumu'),
(70, 'account_search', '1'),
(71, 'redirect_url', 'dashboard'),
(72, 'rtl', '0'),
(73, 'ckey', '0982995697'),
(74, 'networth_goal', '200000'),
(75, 'sysEmail', 'admin@systemsevaluation.co.ke'),
(76, 'url_rewrite', '0'),
(77, 'build', '4804'),
(78, 'animate', '0'),
(79, 'pdf_font', 'dejavusanscondensed'),
(80, 'accounting', '1'),
(81, 'invoicing', '1'),
(82, 'quotes', '1'),
(83, 'client_dashboard', '1'),
(84, 'contact_set_view_mode', 'search'),
(85, 'invoice_terms', ''),
(86, 'console_notify_invoice_created', '1'),
(87, 'i_driver', 'v2'),
(88, 'purchase_code', ''),
(89, 'c_cache', ''),
(90, 'mininav', '0'),
(91, 'hide_footer', '1'),
(92, 'design', 'default'),
(93, 'default_landing_page', 'login'),
(94, 'recaptcha', '0'),
(95, 'recaptcha_sitekey', ''),
(96, 'recaptcha_secretkey', ''),
(97, 'home_currency', 'KES'),
(98, 'currency_decimal_digits', 'true'),
(99, 'currency_symbol_position', 'p'),
(100, 'thousand_separator_placement', '3'),
(101, 'dashboard', 'canvas'),
(102, 'header_scripts', ''),
(103, 'footer_scripts', ''),
(104, 'ib_key', 'vLBLfhA6DNi1R2MFHO8IvFWr4Cn9665eHUF+L/sqAKM='),
(105, 'ib_s', 'PNhjeZ0sOFF3JNfzT2mLxvNNKPeh6ltqpE+G5LVSDSvgp/z79Sco7W4tJEoXYIl8'),
(106, 'ib_u_t', '1616929604'),
(107, 'ib_u_a', '0'),
(108, 'momentLocale', 'en'),
(109, 'contentAnimation', 'animated fadeIn'),
(110, 'calendar', '1'),
(111, 'leads', '1'),
(112, 'tasks', '1'),
(113, 'orders', '1'),
(114, 'show_quantity_as', ''),
(115, 'gmap_api_key', ''),
(116, 'license_key', ''),
(117, 'local_key', ''),
(118, 'add_fund', '0'),
(119, 'add_fund_minimum_deposit', '100'),
(120, 'add_fund_maximum_deposit', '2500'),
(121, 'add_fund_maximum_balance', '25000'),
(122, 'add_fund_require_active_order', '0'),
(123, 'sales_target', '10000'),
(124, 'industry', 'default'),
(125, 'inventory', '1'),
(126, 'secondary_currency', ''),
(127, 'customer_custom_username', '0'),
(128, 'documents', '1'),
(129, 'projects', '1'),
(130, 'purchase', '1'),
(131, 'suppliers', '1'),
(132, 'support', '1'),
(133, 'hrm', '1'),
(134, 'companies', '1'),
(135, 'plugins', '1'),
(136, 'country_flag_code', 'us'),
(137, 'graph_primary_color', '2196f3'),
(138, 'graph_secondary_color', 'eb3c00');

-- --------------------------------------------------------

--
-- Table structure for table `sys_cart`
--

CREATE TABLE `sys_cart` (
  `id` int(11) NOT NULL,
  `secret` varchar(100) DEFAULT NULL,
  `items` text DEFAULT NULL,
  `total` decimal(16,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(16,2) NOT NULL DEFAULT 0.00,
  `ip` varchar(100) DEFAULT NULL,
  `fullname` varchar(200) DEFAULT NULL,
  `phone` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `browser` varchar(200) DEFAULT NULL,
  `country` varchar(200) DEFAULT NULL,
  `currency` varchar(200) DEFAULT NULL,
  `language` varchar(200) DEFAULT NULL,
  `coupon` varchar(200) DEFAULT NULL,
  `lat` varchar(50) DEFAULT NULL,
  `lon` varchar(50) DEFAULT NULL,
  `item_count` int(11) NOT NULL DEFAULT 0,
  `cid` int(11) NOT NULL DEFAULT 0,
  `aid` int(11) NOT NULL DEFAULT 0,
  `lid` int(11) NOT NULL DEFAULT 0,
  `currency_id` int(11) NOT NULL DEFAULT 0,
  `company_id` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expiry` datetime DEFAULT NULL,
  `memo` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_cats`
--

CREATE TABLE `sys_cats` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `type` enum('Income','Expense') NOT NULL,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `total_amount` decimal(16,4) DEFAULT 0.0000,
  `budget` decimal(16,4) DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_cats`
--

INSERT INTO `sys_cats` (`id`, `name`, `type`, `sorder`, `total_amount`, `budget`, `created_at`, `updated_at`) VALUES
(14, 'Advertising', 'Expense', 1, '0.0000', '0.0000', NULL, NULL),
(15, 'Bank and Credit Card Interest', 'Expense', 23, '0.0000', '0.0000', NULL, NULL),
(16, 'Car and Truck', 'Expense', 24, '0.0000', '0.0000', NULL, NULL),
(17, 'Commissions and Fees', 'Expense', 25, '0.0000', '0.0000', NULL, NULL),
(18, 'Contract Labor', 'Expense', 26, '0.0000', '0.0000', NULL, NULL),
(19, 'Contributions', 'Expense', 27, '0.0000', '0.0000', NULL, NULL),
(20, 'Cost of Goods Sold', 'Expense', 28, '0.0000', '0.0000', NULL, NULL),
(21, 'Credit Card Interest', 'Expense', 29, '0.0000', '0.0000', NULL, NULL),
(22, 'Depreciation', 'Expense', 31, '0.0000', '0.0000', NULL, NULL),
(23, 'Dividend Payments', 'Expense', 32, '0.0000', '0.0000', NULL, NULL),
(24, 'Employee Benefit Programs', 'Expense', 33, '0.0000', '0.0000', NULL, NULL),
(25, 'Entertainment', 'Expense', 34, '0.0000', '0.0000', NULL, NULL),
(26, 'Gift', 'Expense', 35, '0.0000', '0.0000', NULL, NULL),
(27, 'Insurance', 'Expense', 36, '0.0000', '0.0000', NULL, NULL),
(28, 'Legal, Accountant &amp; Other Professional Services', 'Expense', 37, '0.0000', '0.0000', NULL, NULL),
(29, 'Meals', 'Expense', 38, '0.0000', '0.0000', NULL, NULL),
(30, 'Mortgage Interest', 'Expense', 39, '0.0000', '0.0000', NULL, NULL),
(31, 'Non-Deductible Expense', 'Expense', 40, '0.0000', '0.0000', NULL, NULL),
(33, 'Other Business Property Leasing', 'Expense', 22, '0.0000', '0.0000', NULL, NULL),
(34, 'Owner Draws', 'Expense', 21, '0.0000', '0.0000', NULL, NULL),
(35, 'Payroll Taxes', 'Expense', 8, '0.0000', '0.0000', NULL, NULL),
(37, 'Phone', 'Expense', 9, '0.0000', '0.0000', NULL, NULL),
(38, 'Postage', 'Expense', 10, '0.0000', '0.0000', NULL, NULL),
(39, 'Rent', 'Expense', 12, '0.0000', '0.0000', NULL, NULL),
(40, 'Repairs &amp; Maintenance', 'Expense', 11, '0.0000', '0.0000', NULL, NULL),
(41, 'Supplies', 'Expense', 13, '0.0000', '0.0000', NULL, NULL),
(42, 'Taxes and Licenses', 'Expense', 14, '0.0000', '0.0000', NULL, NULL),
(43, 'Transfer Funds', 'Expense', 15, '0.0000', '0.0000', NULL, NULL),
(44, 'Travel', 'Expense', 16, '0.0000', '0.0000', NULL, NULL),
(45, 'Utilities', 'Expense', 17, '0.0000', '0.0000', NULL, NULL),
(46, 'Vehicle, Machinery &amp; Equipment Rental or Leasing', 'Expense', 18, '0.0000', '0.0000', NULL, NULL),
(47, 'Wages', 'Expense', 19, '0.0000', '0.0000', NULL, NULL),
(48, 'Regular Income', 'Income', 1, '0.0000', '0.0000', NULL, NULL),
(49, 'Owner Contribution', 'Income', 12, '0.0000', '0.0000', NULL, NULL),
(50, 'Interest Income', 'Income', 11, '0.0000', '0.0000', NULL, NULL),
(51, 'Expense Refund', 'Income', 10, '0.0000', '0.0000', NULL, NULL),
(52, 'Other Income', 'Income', 9, '0.0000', '0.0000', NULL, NULL),
(53, 'Salary', 'Income', 8, '0.0000', '0.0000', NULL, NULL),
(54, 'Equities', 'Income', 7, '0.0000', '0.0000', NULL, NULL),
(55, 'Rent &amp; Royalties', 'Income', 6, '0.0000', '0.0000', NULL, NULL),
(56, 'Home equity', 'Income', 5, '0.0000', '0.0000', NULL, NULL),
(57, 'Part Time Work', 'Income', 3, '0.0000', '0.0000', NULL, NULL),
(58, 'Account Transfer', 'Income', 4, '0.0000', '0.0000', NULL, NULL),
(60, 'Health Care', 'Expense', 20, '0.0000', '0.0000', NULL, NULL),
(63, 'Loans', 'Expense', 30, '0.0000', '0.0000', NULL, NULL),
(64, 'Selling Software', 'Income', 2, '0.0000', '0.0000', NULL, NULL),
(65, 'Software Customization', 'Income', 13, '0.0000', '0.0000', NULL, NULL),
(66, 'Envato', 'Income', 0, '0.0000', '0.0000', NULL, NULL),
(67, 'Salary', 'Expense', 7, '0.0000', '0.0000', NULL, NULL),
(68, 'Paypal', 'Expense', 6, '0.0000', '0.0000', NULL, NULL),
(69, 'Office Equipment', 'Expense', 5, '0.0000', '0.0000', NULL, NULL),
(70, 'Staff Entertaining', 'Expense', 3, '0.0000', '0.0000', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_companies`
--

CREATE TABLE `sys_companies` (
  `id` int(11) NOT NULL,
  `company_name` varchar(200) DEFAULT NULL,
  `url` varchar(200) DEFAULT NULL,
  `logo_url` varchar(200) DEFAULT NULL,
  `logo_path` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(200) DEFAULT NULL,
  `emails` text DEFAULT NULL,
  `phones` text DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `address1` varchar(200) DEFAULT NULL,
  `address2` varchar(200) DEFAULT NULL,
  `city` varchar(200) DEFAULT NULL,
  `state` varchar(200) DEFAULT NULL,
  `zip` varchar(50) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `source` varchar(200) DEFAULT NULL,
  `added_from` varchar(200) DEFAULT NULL,
  `o` varchar(200) DEFAULT NULL,
  `cid` int(11) NOT NULL DEFAULT 0,
  `aid` int(11) NOT NULL DEFAULT 0,
  `pid` int(11) NOT NULL DEFAULT 0,
  `oid` int(11) NOT NULL DEFAULT 0,
  `rid` int(11) NOT NULL DEFAULT 0,
  `assigned` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` varchar(200) DEFAULT NULL,
  `last_contact` datetime DEFAULT NULL,
  `last_contact_by` varchar(200) DEFAULT NULL,
  `ratings` varchar(50) DEFAULT NULL,
  `trash` int(1) NOT NULL DEFAULT 0,
  `archived` int(1) NOT NULL DEFAULT 0,
  `c1` text DEFAULT NULL,
  `c2` text DEFAULT NULL,
  `c3` text DEFAULT NULL,
  `c4` text DEFAULT NULL,
  `c5` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_companies`
--

INSERT INTO `sys_companies` (`id`, `company_name`, `url`, `logo_url`, `logo_path`, `email`, `phone`, `emails`, `phones`, `tags`, `description`, `notes`, `address1`, `address2`, `city`, `state`, `zip`, `country`, `source`, `added_from`, `o`, `cid`, `aid`, `pid`, `oid`, `rid`, `assigned`, `created_at`, `created_by`, `updated_at`, `updated_by`, `last_contact`, `last_contact_by`, `ratings`, `trash`, `archived`, `c1`, `c2`, `c3`, `c4`, `c5`) VALUES
(1, 'CREATIVE HAVEN', 'http://www.creativehavne.co.ke', 'https://creativehaven.co.ke/wp-content/uploads/2019/02/logo-ch-orange.png', NULL, 'info@creativehaven.co.ke', '254722237136', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_currencies`
--

CREATE TABLE `sys_currencies` (
  `id` int(11) NOT NULL,
  `cname` varchar(100) DEFAULT NULL,
  `iso_code` varchar(10) DEFAULT NULL,
  `symbol` varchar(20) DEFAULT NULL,
  `rate` decimal(16,8) NOT NULL DEFAULT 1.00000000,
  `prefix` varchar(20) DEFAULT NULL,
  `suffix` varchar(20) DEFAULT NULL,
  `format` varchar(100) DEFAULT NULL,
  `decimal_separator` varchar(10) DEFAULT NULL,
  `thousand_separator` varchar(10) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(200) DEFAULT NULL,
  `available_in` text DEFAULT NULL,
  `isdefault` int(1) NOT NULL DEFAULT 0,
  `trash` int(1) NOT NULL DEFAULT 0,
  `archived` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_currencies`
--

INSERT INTO `sys_currencies` (`id`, `cname`, `iso_code`, `symbol`, `rate`, `prefix`, `suffix`, `format`, `decimal_separator`, `thousand_separator`, `created_at`, `created_by`, `updated_at`, `updated_by`, `available_in`, `isdefault`, `trash`, `archived`) VALUES
(1, 'KES', 'KES', 'KShs', '1.00000000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `sys_documents`
--

CREATE TABLE `sys_documents` (
  `id` int(11) NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `file_o_name` varchar(200) DEFAULT NULL,
  `file_r_name` varchar(200) DEFAULT NULL,
  `file_mime_type` varchar(200) DEFAULT NULL,
  `file_path` varchar(200) DEFAULT NULL,
  `file_dl_token` varchar(200) DEFAULT NULL,
  `file_owner` int(11) NOT NULL DEFAULT 0,
  `version` varchar(100) DEFAULT NULL,
  `link` varchar(100) DEFAULT NULL,
  `sha1` varchar(40) DEFAULT NULL,
  `md5` varchar(32) DEFAULT NULL,
  `cid` int(11) NOT NULL DEFAULT 0,
  `gid` int(11) NOT NULL DEFAULT 0,
  `company_id` int(11) NOT NULL DEFAULT 0,
  `aid` int(11) NOT NULL DEFAULT 0,
  `contacts` text DEFAULT NULL,
  `deals` text DEFAULT NULL,
  `leads` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(200) DEFAULT NULL,
  `customer_can_download` int(1) NOT NULL DEFAULT 0,
  `trash` int(1) NOT NULL DEFAULT 0,
  `archived` int(1) NOT NULL DEFAULT 0,
  `is_global` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_email_logs`
--

CREATE TABLE `sys_email_logs` (
  `id` int(10) NOT NULL,
  `userid` int(10) NOT NULL,
  `sender` varchar(200) NOT NULL,
  `email` text NOT NULL,
  `subject` text NOT NULL,
  `message` text NOT NULL,
  `date` datetime DEFAULT NULL,
  `iid` int(11) NOT NULL DEFAULT 0,
  `rel_type` varchar(100) DEFAULT NULL,
  `rel_id` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_email_templates`
--

CREATE TABLE `sys_email_templates` (
  `id` int(11) NOT NULL,
  `tplname` varchar(128) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `subject` text NOT NULL,
  `message` text NOT NULL,
  `send` varchar(50) DEFAULT 'Active',
  `core` enum('Yes','No') DEFAULT 'Yes',
  `hidden` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



-- --------------------------------------------------------

--
-- Table structure for table `sys_evalitems`
--

CREATE TABLE `sys_evalitems` (
  `id` int(10) NOT NULL,
  `evalid` int(10) NOT NULL DEFAULT 0,
  `userid` int(10) DEFAULT NULL,
  `type` text DEFAULT NULL,
  `relid` int(10) DEFAULT NULL,
  `itemcode` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `qty` varchar(20) NOT NULL DEFAULT '1',
  `amount` decimal(14,2) NOT NULL DEFAULT 0.00,
  `taxed` int(1) DEFAULT NULL,
  `taxamount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total` decimal(14,2) NOT NULL DEFAULT 0.00,
  `duedate` date DEFAULT NULL,
  `paymentmethod` text DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_evalitems`
--

INSERT INTO `sys_evalitems` (`id`, `evalid`, `userid`, `type`, `relid`, `itemcode`, `description`, `qty`, `amount`, `taxed`, `taxamount`, `total`, `duedate`, `paymentmethod`, `notes`) VALUES
(1, 1, 1, 'QI Vision and Mission development and advocacy', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(2, 1, 1, 'QI Strategic Plan/Policy development', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(3, 1, 1, 'QI Planning for an effective response', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(5, 1, 1, 'Integration of QI Activities', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(6, 1, 1, 'Capacity building', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(7, 1, 1, 'Partnerships', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(8, 2, 1, 'Routine QI Implementation', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(9, 2, 1, 'QI Surveys', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(10, 2, 1, 'Quality Management System', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(11, 3, 1, 'Design and Methods in QI implentation', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(12, 3, 1, 'QI Management', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(13, 4, 1, 'Findings Analysis', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(14, 4, 1, 'Findings Dissemination', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(15, 4, 1, 'Findings Use', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(16, 5, 1, 'Leadership/Team Management', NULL, NULL, 'Leadership/Team Management', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(17, 5, 1, 'Financial resource mobilization & financial tracking for QI activities', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(18, 5, 1, 'Coordination and collaboration', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(19, 5, 1, 'Negotiation		\r\n', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(20, 5, 1, 'Strategic communications		\r\n', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(4, 1, 1, 'Planning for effective QI system', NULL, NULL, NULL, '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(23, 6, 2, 'QM Leadership', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(24, 6, 2, 'Quality Improvement Management Policy', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(25, 6, 2, 'QI Planning for an effective response', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(26, 6, 2, 'Planning for effective QI system', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(27, 6, 2, 'Institutional Integration of QI Activities', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(28, 6, 2, 'Institutional Partnerships', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(29, 7, 2, 'Documents/Documentation', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(30, 7, 2, 'Reporting and Communication', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(31, 7, 2, 'QI Surveillance/Surveys', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(32, 8, 2, 'Recruitment and Selection', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(33, 8, 2, 'Induction/Orientation', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(34, 8, 2, 'Staffing Ratio', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(35, 8, 2, 'Training and Development', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(36, 8, 2, 'Performance and Feedback Management', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(37, 9, 2, 'Emergency Care', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(38, 9, 2, 'Patient Safety', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(39, 9, 2, 'Prevention Care', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(40, 9, 2, 'In Patient Care - Department Specific (e.g - E.N.T., Oncology, Renal Unit, Ophthalmology)', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(41, 9, 2, 'Nursing Care', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(42, 9, 2, 'Surgical Safety', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(43, 9, 2, 'Laboratory Safety and Quality Improvement', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(44, 9, 2, 'Pharmaceutical Safety and Quality Improvement', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(45, 9, 2, 'Radiology Safety and Quality Improvement', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(46, 10, 2, 'Customer focus', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(47, 10, 2, 'Engagement of people', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(48, 10, 2, 'Relationship Management', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(49, 10, 2, 'Process Approach', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(50, 10, 2, 'Improvement', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(51, 10, 2, 'Leadership', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL),
(52, 10, 2, 'Evidence-Based Decision Making', NULL, NULL, '', '1', '0.00', NULL, '0.00', '0.00', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_evaluations`
--

CREATE TABLE `sys_evaluations` (
  `id` int(10) NOT NULL,
  `topicid` int(10) NOT NULL,
  `account` varchar(200) DEFAULT NULL,
  `cn` varchar(100) DEFAULT '',
  `invoicenum` text DEFAULT NULL,
  `date` date DEFAULT NULL,
  `duedate` date DEFAULT NULL,
  `datepaid` datetime DEFAULT NULL,
  `subtotal` decimal(18,2) DEFAULT NULL,
  `discount_type` varchar(1) DEFAULT 'f',
  `discount_value` decimal(14,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(14,2) NOT NULL DEFAULT 0.00,
  `credit` decimal(10,2) NOT NULL DEFAULT 0.00,
  `taxname` varchar(100) DEFAULT NULL,
  `tax` decimal(10,2) DEFAULT NULL,
  `tax2` decimal(10,2) DEFAULT NULL,
  `total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `taxrate` decimal(10,2) DEFAULT NULL,
  `taxrate2` decimal(10,2) DEFAULT NULL,
  `status` text DEFAULT NULL,
  `paymentmethod` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `vtoken` varchar(20) DEFAULT NULL,
  `ptoken` varchar(20) DEFAULT NULL,
  `r` varchar(100) NOT NULL DEFAULT '0',
  `nd` date DEFAULT NULL,
  `eid` int(10) NOT NULL DEFAULT 0,
  `ename` varchar(200) DEFAULT '',
  `vid` int(11) NOT NULL DEFAULT 0,
  `currency` int(11) NOT NULL DEFAULT 0,
  `currency_symbol` varchar(10) DEFAULT NULL,
  `currency_prefix` varchar(10) DEFAULT NULL,
  `currency_suffix` varchar(10) DEFAULT NULL,
  `currency_rate` decimal(11,4) NOT NULL DEFAULT 1.0000,
  `recurring` tinyint(1) NOT NULL DEFAULT 0,
  `recurring_ends` date DEFAULT NULL,
  `last_recurring_date` date DEFAULT NULL,
  `source` varchar(200) DEFAULT NULL,
  `sale_agent` int(11) NOT NULL DEFAULT 0,
  `last_overdue_reminder` date DEFAULT NULL,
  `allowed_payment_methods` text DEFAULT NULL,
  `billing_street` varchar(200) DEFAULT NULL,
  `billing_city` varchar(100) DEFAULT NULL,
  `billing_state` varchar(100) DEFAULT NULL,
  `billing_zip` varchar(50) DEFAULT NULL,
  `billing_country` varchar(100) DEFAULT NULL,
  `shipping_street` varchar(200) DEFAULT NULL,
  `shipping_city` varchar(100) DEFAULT NULL,
  `shipping_state` varchar(100) DEFAULT NULL,
  `shipping_zip` varchar(100) DEFAULT NULL,
  `shipping_country` varchar(100) DEFAULT NULL,
  `q_hide` tinyint(1) NOT NULL DEFAULT 0,
  `show_quantity_as` varchar(100) DEFAULT NULL,
  `pid` int(11) NOT NULL DEFAULT 0,
  `is_credit_invoice` int(1) NOT NULL DEFAULT 0,
  `aid` int(11) NOT NULL DEFAULT 0,
  `aname` varchar(200) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_evaluations`
--

INSERT INTO `sys_evaluations` (`id`, `topicid`, `account`, `cn`, `invoicenum`, `date`, `duedate`, `datepaid`, `subtotal`, `discount_type`, `discount_value`, `discount`, `credit`, `taxname`, `tax`, `tax2`, `total`, `taxrate`, `taxrate2`, `status`, `paymentmethod`, `notes`, `vtoken`, `ptoken`, `r`, `nd`, `eid`, `ename`, `vid`, `currency`, `currency_symbol`, `currency_prefix`, `currency_suffix`, `currency_rate`, `recurring`, `recurring_ends`, `last_recurring_date`, `source`, `sale_agent`, `last_overdue_reminder`, `allowed_payment_methods`, `billing_street`, `billing_city`, `billing_state`, `billing_zip`, `billing_country`, `shipping_street`, `shipping_city`, `shipping_state`, `shipping_zip`, `shipping_country`, `q_hide`, `show_quantity_as`, `pid`, `is_credit_invoice`, `aid`, `aname`) VALUES
(1, 1, 'QI Leadership', '', NULL, NULL, NULL, NULL, NULL, 'f', '0.00', '0.00', '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 0, '', 0, 0, NULL, NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL),
(2, 1, 'QI Management', '', NULL, NULL, NULL, NULL, NULL, 'f', '0.00', '0.00', '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 0, '', 0, 0, NULL, NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL),
(3, 1, 'QI Competency', '', NULL, NULL, NULL, NULL, NULL, 'f', '0.00', '0.00', '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 0, '', 0, 0, NULL, NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL),
(4, 1, 'QI Findings Analysis, Dissemination and Use Competency', '', NULL, NULL, NULL, NULL, NULL, 'f', '0.00', '0.00', '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 0, '', 0, 0, NULL, NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL),
(5, 1, 'QI General Management', '', NULL, NULL, NULL, NULL, NULL, 'f', '0.00', '0.00', '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 0, '', 0, 0, NULL, NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL),
(6, 2, 'QM Leadership', '', NULL, NULL, NULL, NULL, NULL, 'f', '0.00', '0.00', '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 0, '', 0, 0, NULL, NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL),
(7, 2, 'QM System', '', NULL, NULL, NULL, NULL, NULL, 'f', '0.00', '0.00', '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 0, '', 0, 0, NULL, NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL),
(8, 2, 'HR for QM', '', NULL, NULL, NULL, NULL, NULL, 'f', '0.00', '0.00', '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 0, '', 0, 0, NULL, NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL),
(9, 2, 'QI Metrics', '', NULL, NULL, NULL, NULL, NULL, 'f', '0.00', '0.00', '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 0, '', 0, 0, NULL, NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL),
(10, 2, 'QMP', '', NULL, NULL, NULL, NULL, NULL, 'f', '0.00', '0.00', '0.00', NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 0, '', 0, 0, NULL, NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_events`
--

CREATE TABLE `sys_events` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `contacts` text DEFAULT NULL,
  `deals` text DEFAULT NULL,
  `owner` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `etype` varchar(200) DEFAULT NULL,
  `priority` varchar(200) DEFAULT NULL,
  `color` varchar(20) DEFAULT NULL,
  `o` varchar(200) DEFAULT NULL,
  `cid` int(11) NOT NULL DEFAULT 0,
  `aid` int(11) NOT NULL DEFAULT 0,
  `iid` int(11) NOT NULL DEFAULT 0,
  `oid` int(11) NOT NULL DEFAULT 0,
  `rid` int(11) NOT NULL DEFAULT 0,
  `company_id` int(11) NOT NULL DEFAULT 0,
  `start` datetime DEFAULT NULL,
  `end` datetime DEFAULT NULL,
  `allday` int(1) NOT NULL DEFAULT 0,
  `notification` int(1) NOT NULL DEFAULT 0,
  `trash` int(1) NOT NULL DEFAULT 0,
  `archived` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_invoiceitems`
--

CREATE TABLE `sys_invoiceitems` (
  `id` int(10) NOT NULL,
  `invoiceid` int(10) NOT NULL DEFAULT 0,
  `userid` int(10) NOT NULL,
  `type` text NOT NULL,
  `relid` int(10) NOT NULL,
  `itemcode` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `qty` varchar(20) NOT NULL DEFAULT '1',
  `amount` decimal(14,2) NOT NULL DEFAULT 0.00,
  `taxed` int(1) NOT NULL,
  `taxamount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total` decimal(14,2) NOT NULL DEFAULT 0.00,
  `duedate` date DEFAULT NULL,
  `paymentmethod` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_invoiceitems`
--

INSERT INTO `sys_invoiceitems` (`id`, `invoiceid`, `userid`, `type`, `relid`, `itemcode`, `description`, `qty`, `amount`, `taxed`, `taxamount`, `total`, `duedate`, `paymentmethod`, `notes`) VALUES
(1, 1, 3, '', 0, '', 'STANDARD', '1', '84630.00', 0, '0.00', '84630.00', '2020-09-02', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `sys_invoices`
--

CREATE TABLE `sys_invoices` (
  `id` int(10) NOT NULL,
  `userid` int(10) NOT NULL,
  `account` varchar(200) NOT NULL,
  `cn` varchar(100) NOT NULL DEFAULT '',
  `invoicenum` text NOT NULL,
  `date` date DEFAULT NULL,
  `duedate` date DEFAULT NULL,
  `datepaid` datetime DEFAULT NULL,
  `subtotal` decimal(18,2) NOT NULL,
  `discount_type` varchar(1) NOT NULL DEFAULT 'f',
  `discount_value` decimal(14,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(14,2) NOT NULL DEFAULT 0.00,
  `credit` decimal(10,2) NOT NULL DEFAULT 0.00,
  `taxname` varchar(100) NOT NULL,
  `tax` decimal(10,2) NOT NULL,
  `tax2` decimal(10,2) NOT NULL,
  `total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `taxrate` decimal(10,2) NOT NULL,
  `taxrate2` decimal(10,2) NOT NULL,
  `status` text NOT NULL,
  `paymentmethod` text NOT NULL,
  `notes` text NOT NULL,
  `vtoken` varchar(20) NOT NULL,
  `ptoken` varchar(20) NOT NULL,
  `r` varchar(100) NOT NULL DEFAULT '0',
  `nd` date DEFAULT NULL,
  `eid` int(10) NOT NULL DEFAULT 0,
  `ename` varchar(200) NOT NULL DEFAULT '',
  `vid` int(11) NOT NULL DEFAULT 0,
  `currency` int(11) NOT NULL DEFAULT 0,
  `currency_symbol` varchar(10) DEFAULT NULL,
  `currency_prefix` varchar(10) DEFAULT NULL,
  `currency_suffix` varchar(10) DEFAULT NULL,
  `currency_rate` decimal(11,4) NOT NULL DEFAULT 1.0000,
  `recurring` tinyint(1) NOT NULL DEFAULT 0,
  `recurring_ends` date DEFAULT NULL,
  `last_recurring_date` date DEFAULT NULL,
  `source` varchar(200) DEFAULT NULL,
  `sale_agent` int(11) NOT NULL DEFAULT 0,
  `last_overdue_reminder` date DEFAULT NULL,
  `allowed_payment_methods` text DEFAULT NULL,
  `billing_street` varchar(200) DEFAULT NULL,
  `billing_city` varchar(100) DEFAULT NULL,
  `billing_state` varchar(100) DEFAULT NULL,
  `billing_zip` varchar(50) DEFAULT NULL,
  `billing_country` varchar(100) DEFAULT NULL,
  `shipping_street` varchar(200) DEFAULT NULL,
  `shipping_city` varchar(100) DEFAULT NULL,
  `shipping_state` varchar(100) DEFAULT NULL,
  `shipping_zip` varchar(100) DEFAULT NULL,
  `shipping_country` varchar(100) DEFAULT NULL,
  `q_hide` tinyint(1) NOT NULL DEFAULT 0,
  `show_quantity_as` varchar(100) DEFAULT NULL,
  `pid` int(11) NOT NULL DEFAULT 0,
  `is_credit_invoice` int(1) NOT NULL DEFAULT 0,
  `aid` int(11) NOT NULL DEFAULT 0,
  `aname` varchar(200) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_invoices`
--

INSERT INTO `sys_invoices` (`id`, `userid`, `account`, `cn`, `invoicenum`, `date`, `duedate`, `datepaid`, `subtotal`, `discount_type`, `discount_value`, `discount`, `credit`, `taxname`, `tax`, `tax2`, `total`, `taxrate`, `taxrate2`, `status`, `paymentmethod`, `notes`, `vtoken`, `ptoken`, `r`, `nd`, `eid`, `ename`, `vid`, `currency`, `currency_symbol`, `currency_prefix`, `currency_suffix`, `currency_rate`, `recurring`, `recurring_ends`, `last_recurring_date`, `source`, `sale_agent`, `last_overdue_reminder`, `allowed_payment_methods`, `billing_street`, `billing_city`, `billing_state`, `billing_zip`, `billing_country`, `shipping_street`, `shipping_city`, `shipping_state`, `shipping_zip`, `shipping_country`, `q_hide`, `show_quantity_as`, `pid`, `is_credit_invoice`, `aid`, `aname`) VALUES
(1, 3, 'Albanus Mudhune', '', '', '2020-09-02', '2020-09-02', '2020-09-02 16:50:32', '84630.00', 'f', '0.00', '0.00', '0.00', '', '0.00', '0.00', '84630.00', '0.00', '0.00', 'Unpaid', '', '', '4398300314', '1994472525', '0', '2020-09-02', 0, '', 0, 0, 'Kshs', NULL, NULL, '1.0000', 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_items`
--

CREATE TABLE `sys_items` (
  `id` int(11) NOT NULL,
  `name` mediumtext NOT NULL,
  `unit` varchar(100) NOT NULL DEFAULT '',
  `sales_price` decimal(16,2) NOT NULL DEFAULT 0.00,
  `inventory` decimal(16,4) NOT NULL DEFAULT 0.0000,
  `weight` decimal(16,4) NOT NULL DEFAULT 0.0000,
  `width` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `length` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `height` decimal(12,4) NOT NULL DEFAULT 0.0000,
  `sku` varchar(50) DEFAULT NULL,
  `upc` varchar(50) DEFAULT NULL,
  `ean` varchar(50) DEFAULT NULL,
  `mpn` varchar(50) DEFAULT NULL,
  `isbn` varchar(50) DEFAULT NULL,
  `sid` int(11) NOT NULL DEFAULT 0,
  `supplier` varchar(200) DEFAULT NULL,
  `bid` int(11) NOT NULL DEFAULT 0,
  `brand` varchar(200) DEFAULT NULL,
  `sell_account` int(11) NOT NULL DEFAULT 0,
  `purchase_account` int(11) NOT NULL DEFAULT 0,
  `inventory_account` int(11) NOT NULL DEFAULT 0,
  `taxable` int(1) NOT NULL DEFAULT 0,
  `location` varchar(200) DEFAULT NULL,
  `item_number` varchar(100) NOT NULL DEFAULT '',
  `description` mediumtext NOT NULL,
  `type` enum('Service','Product') NOT NULL,
  `track_inventroy` enum('Yes','No') NOT NULL DEFAULT 'No',
  `negative_stock` enum('Yes','No') NOT NULL DEFAULT 'No',
  `available` int(11) NOT NULL DEFAULT 0,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `added` date DEFAULT NULL,
  `last_sold` date DEFAULT NULL,
  `e` mediumtext NOT NULL,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `gid` int(11) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `supplier_id` int(11) NOT NULL DEFAULT 0,
  `gname` varchar(100) DEFAULT NULL,
  `product_id` varchar(100) DEFAULT NULL,
  `size` varchar(100) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `expire_date` date DEFAULT NULL,
  `expire_days` int(11) NOT NULL DEFAULT 0,
  `image` text DEFAULT NULL,
  `flag` int(1) NOT NULL DEFAULT 0,
  `is_service` int(1) NOT NULL DEFAULT 0,
  `commission_percent` decimal(16,2) NOT NULL DEFAULT 0.00,
  `commission_percent_type` varchar(100) DEFAULT NULL,
  `commission_fixed` decimal(16,2) NOT NULL DEFAULT 0.00,
  `trash` int(1) NOT NULL DEFAULT 0,
  `payterm` varchar(200) DEFAULT NULL,
  `cost_price` decimal(16,2) NOT NULL DEFAULT 0.00,
  `unit_price` decimal(16,2) NOT NULL DEFAULT 0.00,
  `promo_price` decimal(16,2) NOT NULL DEFAULT 0.00,
  `setup` decimal(16,2) NOT NULL DEFAULT 0.00,
  `onetime` decimal(16,2) NOT NULL DEFAULT 0.00,
  `monthly` decimal(16,2) NOT NULL DEFAULT 0.00,
  `monthlysetup` decimal(16,2) NOT NULL DEFAULT 0.00,
  `quarterly` decimal(16,2) NOT NULL DEFAULT 0.00,
  `quarterlysetup` decimal(16,2) NOT NULL DEFAULT 0.00,
  `halfyearly` decimal(16,2) NOT NULL DEFAULT 0.00,
  `halfyearlysetup` decimal(16,2) NOT NULL DEFAULT 0.00,
  `annually` decimal(16,2) NOT NULL DEFAULT 0.00,
  `annuallysetup` decimal(16,2) NOT NULL DEFAULT 0.00,
  `biennially` decimal(16,2) NOT NULL DEFAULT 0.00,
  `bienniallysetup` decimal(16,2) NOT NULL DEFAULT 0.00,
  `triennially` decimal(16,2) NOT NULL DEFAULT 0.00,
  `trienniallysetup` decimal(16,2) NOT NULL DEFAULT 0.00,
  `has_domain` varchar(100) DEFAULT NULL,
  `free_domain` varchar(100) DEFAULT NULL,
  `email_rel` int(11) NOT NULL DEFAULT 0,
  `tags` text DEFAULT NULL,
  `c1` text DEFAULT NULL,
  `c2` text DEFAULT NULL,
  `c3` text DEFAULT NULL,
  `c4` text DEFAULT NULL,
  `c5` text DEFAULT NULL,
  `c6` text DEFAULT NULL,
  `c7` text DEFAULT NULL,
  `c8` text DEFAULT NULL,
  `c9` text DEFAULT NULL,
  `c10` text DEFAULT NULL,
  `c11` text DEFAULT NULL,
  `c12` text DEFAULT NULL,
  `c13` text DEFAULT NULL,
  `c14` text DEFAULT NULL,
  `c15` text DEFAULT NULL,
  `c16` text DEFAULT NULL,
  `c17` text DEFAULT NULL,
  `c18` text DEFAULT NULL,
  `c19` text DEFAULT NULL,
  `c20` text DEFAULT NULL,
  `c21` text DEFAULT NULL,
  `c22` text DEFAULT NULL,
  `c23` text DEFAULT NULL,
  `c24` text DEFAULT NULL,
  `c25` text DEFAULT NULL,
  `c26` text DEFAULT NULL,
  `c27` text DEFAULT NULL,
  `c28` text DEFAULT NULL,
  `c29` text DEFAULT NULL,
  `c30` text DEFAULT NULL,
  `sold_count` decimal(16,4) DEFAULT 0.0000,
  `total_amount` decimal(16,4) DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_items`
--

INSERT INTO `sys_items` (`id`, `name`, `unit`, `sales_price`, `inventory`, `weight`, `width`, `length`, `height`, `sku`, `upc`, `ean`, `mpn`, `isbn`, `sid`, `supplier`, `bid`, `brand`, `sell_account`, `purchase_account`, `inventory_account`, `taxable`, `location`, `item_number`, `description`, `type`, `track_inventroy`, `negative_stock`, `available`, `status`, `added`, `last_sold`, `e`, `sorder`, `gid`, `category_id`, `supplier_id`, `gname`, `product_id`, `size`, `start_date`, `end_date`, `expire_date`, `expire_days`, `image`, `flag`, `is_service`, `commission_percent`, `commission_percent_type`, `commission_fixed`, `trash`, `payterm`, `cost_price`, `unit_price`, `promo_price`, `setup`, `onetime`, `monthly`, `monthlysetup`, `quarterly`, `quarterlysetup`, `halfyearly`, `halfyearlysetup`, `annually`, `annuallysetup`, `biennially`, `bienniallysetup`, `triennially`, `trienniallysetup`, `has_domain`, `free_domain`, `email_rel`, `tags`, `c1`, `c2`, `c3`, `c4`, `c5`, `c6`, `c7`, `c8`, `c9`, `c10`, `c11`, `c12`, `c13`, `c14`, `c15`, `c16`, `c17`, `c18`, `c19`, `c20`, `c21`, `c22`, `c23`, `c24`, `c25`, `c26`, `c27`, `c28`, `c29`, `c30`, `sold_count`, `total_amount`, `created_at`, `updated_at`) VALUES
(1, 'DEMO : QI Competency Assessment Tool', '', '0.00', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, NULL, '3', '- One user - 2 Free log-ins – within 48hours - View Only Score-cards', 'Service', 'No', 'No', 0, 'Active', NULL, NULL, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '0.00', NULL, '0.00', 0, NULL, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0.0000', '0.0000', NULL, NULL),
(2, 'BASIC : QI Competency Assessment Tool', '', '33750.00', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, NULL, '6', '- Up to 5 users\r\n- Up 2 log-ins/Assessments - 3 months apart)\r\n- 1 online mentorship session\r\n- Email/Print Score card', 'Service', 'No', 'No', 0, 'Active', NULL, NULL, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '0.00', NULL, '0.00', 0, NULL, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0.0000', '0.0000', NULL, NULL),
(3, 'STANDARD : QI Competency Assessment Tool', '', '84630.00', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, NULL, '2', '- Up to 13 users\n- Up to 3 assessments per user – 3 months apart\n- Online Customer Support\n- 2 Online mentorship sessions\n- Email/Print Assessment Score-card', 'Service', 'No', 'No', 0, 'Active', NULL, NULL, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '0.00', NULL, '0.00', 0, NULL, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0.0000', '0.0000', NULL, NULL),
(4, 'EXECUTIVE : QI Competency Assessment Tool', '', '154750.00', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, NULL, '4', ' Up to 25 users  Up to 4 assessments per user – 3 months apart  Online Customer Support  3 online mentorship sessions  Email/Print Assessment Score-card', 'Service', 'No', 'No', 0, 'Active', NULL, NULL, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '0.00', NULL, '0.00', 0, NULL, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0.0000', '0.0000', NULL, NULL),
(5, 'ENTERPRISE : QI Competency Assessment Tool', '', '255150.00', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, NULL, '6', ' Up to 45 users  Up to 5 Assessments – 3 months apart  Online Customer Support  4 online mentorship sessions plus video tutorial  Email/Print Score-card', 'Service', 'No', 'No', 0, 'Active', NULL, NULL, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '0.00', NULL, '0.00', 0, NULL, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0.0000', '0.0000', NULL, NULL),
(6, 'DEMO : QMS Capacity Assessment Tool', '', '0.00', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, NULL, '3', '- One user - 2 Free log-ins – within 72hours - View Only Score-cards', 'Service', 'No', 'No', 0, 'Active', NULL, NULL, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '0.00', NULL, '0.00', 0, NULL, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0.0000', '0.0000', NULL, NULL),
(7, 'BASIC : QMS Capacity Assessment Tool', '', '158750.00', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, NULL, '6', '- Level 2-3 Facilities - Medical Clinics + Nursing Homes\r\n- Up 2 log-ins/Assessments - 3 months apart)\r\n- Technical Advise - 1 online mentorship\r\nsession for Unit heads\r\n- Assessment Report + Action Plan', 'Service', 'No', 'No', 0, 'Active', NULL, NULL, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '0.00', NULL, '0.00', 0, NULL, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0.0000', '0.0000', NULL, NULL),
(8, 'STANDARD : QMS Capacity Assessment Tool', '', '291900.00', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, NULL, '2', '- Level 4 Facilities – Medical Centres +\r\nHospitals\r\n- Up to 3 assessments per institution – 3\r\nmonths apart\r\n- Online Customer Support\r\n- Technical Advise - 2 Online mentorship\r\nsessions for unit heads\r\n- QMS Design\r\n- 2 quarterly progress assessment + Reports + Action Plans', 'Service', 'No', 'No', 0, 'Active', NULL, NULL, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '0.00', NULL, '0.00', 0, NULL, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0.0000', '0.0000', NULL, NULL),
(9, 'EXECUTIVE : QMS Capacity Assessment Tool', '', '418650.00', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, NULL, '4', '- Level 5-6 Facilities – Referral + Specialists’ Hospitals \r\n– Up to 4 assessments per user – 3 months\r\napart\r\n- Online Support \r\n- Technical Advise - 3 online mentorship and training sessions for unit heads\r\n- QMS Design + Operationalization\r\n- 4 Quarterly Progress Assessment + Reports + Action Plans', 'Service', 'No', 'No', 0, 'Active', NULL, NULL, '', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '0.00', NULL, '0.00', 0, NULL, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0.0000', '0.0000', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_item_cats`
--

CREATE TABLE `sys_item_cats` (
  `id` int(11) NOT NULL,
  `pid` int(11) NOT NULL DEFAULT 0,
  `name` varchar(200) DEFAULT NULL,
  `type` varchar(200) DEFAULT NULL,
  `img` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_leads`
--

CREATE TABLE `sys_leads` (
  `id` int(11) NOT NULL,
  `fullname` varchar(200) DEFAULT NULL,
  `company` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `color` varchar(20) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `source` varchar(200) DEFAULT NULL,
  `added_from` varchar(200) DEFAULT NULL,
  `o` varchar(200) DEFAULT NULL,
  `cid` int(11) NOT NULL DEFAULT 0,
  `aid` int(11) NOT NULL DEFAULT 0,
  `iid` int(11) NOT NULL DEFAULT 0,
  `oid` int(11) NOT NULL DEFAULT 0,
  `rid` int(11) NOT NULL DEFAULT 0,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `assigned` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(200) DEFAULT NULL,
  `last_contact` datetime DEFAULT NULL,
  `last_contact_by` varchar(200) DEFAULT NULL,
  `date_converted` datetime DEFAULT NULL,
  `public` int(1) NOT NULL DEFAULT 0,
  `ratings` varchar(50) DEFAULT NULL,
  `flag` int(1) NOT NULL DEFAULT 0,
  `lost` int(1) NOT NULL DEFAULT 0,
  `junk` int(1) NOT NULL DEFAULT 0,
  `trash` int(1) NOT NULL DEFAULT 0,
  `archived` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_logs`
--

CREATE TABLE `sys_logs` (
  `id` int(10) NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `userid` int(10) NOT NULL,
  `ip` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_logs`
--

INSERT INTO `sys_logs` (`id`, `date`, `type`, `description`, `userid`, `ip`) VALUES
(1, '2016-11-15 11:30:45', 'System', 'Build Updated to: 4600\r\nDocuments Table Created\r\nOrders Table Created\r\nsys_items table altered\r\nUpdate Completed!\r\n', 0, '::1'),
(2, '2017-04-18 08:37:23', 'System', 'Build Updated to: 4620\r\nUpdate Completed!\r\n', 0, '::1'),
(3, '2017-09-17 15:08:39', 'System', 'Build Updated to: 4671\r\nUpdate Completed!\r\n', 0, '127.0.0.1'),
(4, '2017-09-21 05:34:13', 'Admin', 'Login Successful demo@example.com', 1, '127.0.0.1'),
(5, '2017-09-28 05:07:55', 'Admin', 'Login Successful demo@example.com', 1, '127.0.0.1'),
(6, '2017-09-29 19:12:19', 'Admin', 'Login Successful demo@example.com', 1, '127.0.0.1'),
(7, '2017-11-13 04:44:33', 'Admin', 'Login Successful demo@example.com', 1, '127.0.0.1'),
(8, '2017-11-13 05:12:33', 'Admin', 'New Contact Added test [CID: 1]', 1, '127.0.0.1'),
(9, '2017-11-13 05:12:40', 'Admin', 'New Contact Added test 2 [CID: 2]', 1, '127.0.0.1'),
(10, '2017-11-18 11:52:45', 'Admin', 'Login Successful demo@example.com', 1, '127.0.0.1'),
(11, '2020-08-25 14:17:19', 'Admin', 'Login Successful albandmx@gmail.com', 1, '::1'),
(12, '2020-08-26 00:47:16', 'Admin', 'New Contact Added Albanus Mudhune [CID: 3]', 1, '::1'),
(13, '2020-08-27 01:02:44', 'Admin', 'Login Successful albandmx@gmail.com', 1, '::1'),
(14, '2020-08-27 01:11:48', 'Admin', 'Login Successful albandmx@gmail.com', 1, '::1'),
(15, '2020-08-27 08:37:07', 'Admin', 'Failed Login albandmx@gmail.com', 0, '::1'),
(16, '2020-08-27 08:37:15', 'Admin', 'Login Successful albandmx@gmail.com', 1, '::1'),
(17, '2020-08-27 08:38:13', 'Admin', 'Login Successful albandmx@gmail.com', 1, '::1'),
(18, '2020-08-31 02:11:54', 'Admin', 'Failed Login albandmx@gmail.com', 0, '::1'),
(19, '2020-08-31 02:12:43', 'Admin', 'Failed Login albandmx@gmail.com', 0, '::1'),
(20, '2020-08-31 02:12:54', 'Admin', 'Failed Login albandmx@gmail.com', 0, '::1'),
(21, '2020-08-31 02:13:17', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(22, '2020-09-01 18:23:30', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(23, '2020-09-02 16:49:19', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(24, '2020-09-03 08:10:37', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(25, '2020-09-03 22:53:12', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(26, '2020-09-04 17:20:56', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.139.245.198'),
(27, '2020-09-04 17:37:57', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.80.229.242'),
(28, '2020-09-04 17:45:52', 'Portal Registration', 'New Contact Added Dennis Sakwa [CID: 4]', 0, '41.80.229.242'),
(29, '2020-09-04 19:18:15', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.80.229.242'),
(30, '2020-09-04 20:50:52', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.80.229.242'),
(31, '2020-09-04 20:52:08', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '105.160.113.252'),
(32, '2020-09-04 22:23:58', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '105.160.113.252'),
(33, '2020-09-05 09:46:34', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.90.32.151'),
(34, '2020-09-08 00:32:15', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '154.159.145.204'),
(35, '2020-09-11 22:16:17', 'Admin', 'Failed Login support@creativehaven.co.ke', 0, '197.232.61.229'),
(36, '2020-09-11 22:16:41', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.232.61.229'),
(37, '2020-09-11 22:17:04', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.232.61.229'),
(38, '2020-09-11 22:17:22', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.232.61.229'),
(39, '2020-09-11 22:17:23', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.232.61.229'),
(40, '2020-09-11 22:17:33', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.232.61.229'),
(41, '2020-09-12 09:01:01', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '102.0.62.255'),
(42, '2020-09-12 10:15:23', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '196.216.71.206'),
(43, '2020-09-12 11:17:57', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.139.245.198'),
(44, '2020-09-12 11:18:02', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.139.245.198'),
(45, '2020-09-12 11:19:40', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.139.245.198'),
(46, '2020-09-12 11:19:55', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.139.245.198'),
(47, '2020-09-12 16:46:35', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.232.61.229'),
(48, '2020-09-12 16:46:52', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.232.61.229'),
(49, '2020-09-12 17:20:28', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.232.61.229'),
(50, '2020-09-12 17:30:23', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.232.61.229'),
(51, '2020-09-12 18:01:06', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '102.7.117.163'),
(52, '2020-09-12 18:43:51', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '196.96.179.1'),
(53, '2020-09-12 18:44:57', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '196.96.179.1'),
(54, '2020-09-12 18:46:47', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '196.96.179.1'),
(55, '2020-09-12 21:04:17', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.90.233.246'),
(56, '2020-09-14 02:45:24', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.139.245.198'),
(57, '2020-09-21 18:31:04', 'Admin', 'Failed Login albandmx@gmail.com', 0, '::1'),
(58, '2020-09-22 07:57:42', 'Admin', 'Failed Login albandmx@gmail.com', 0, '::1'),
(59, '2020-09-22 07:57:53', 'Admin', 'Failed Login albandmx@gmail.com', 0, '::1'),
(60, '2020-09-22 07:58:34', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(61, '2020-09-22 08:11:57', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(62, '2020-10-05 13:53:25', 'Admin', 'Failed Login support@creativehaven.co.ke', 0, '::1'),
(63, '2020-10-05 13:53:33', 'Admin', 'Failed Login support@creativehaven.co.ke', 0, '::1'),
(64, '2020-10-05 13:53:39', 'Admin', 'Failed Login support@creativehaven.co.ke', 0, '::1'),
(65, '2020-10-05 13:54:41', 'Admin', 'Failed Login support@creativehaven.co.ke', 0, '::1'),
(66, '2020-10-05 13:54:51', 'Admin', 'Failed Login support@creativehaven.co.ke', 0, '::1'),
(67, '2020-10-05 13:55:05', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(68, '2020-10-05 18:46:37', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(69, '2020-10-19 23:47:50', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(70, '2020-10-19 23:49:25', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '::1'),
(71, '2020-10-19 23:49:44', 'Admin', 'New Contact Added Thomas Partey [CID: 5]', 2, '::1'),
(72, '2020-10-20 18:27:27', 'Portal Registration', 'New Contact Added Fredrick Otieno [CID: 6]', 0, '196.105.249.52'),
(73, '2020-11-04 13:27:36', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.90.35.165'),
(74, '2020-11-23 14:11:23', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.80.245.105'),
(75, '2021-01-04 23:26:22', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.232.61.253'),
(76, '2021-01-07 19:50:58', 'Portal Registration', 'New Contact Added FREDRICK ODUOR OTIENO [CID: 7]', 0, '105.160.6.35'),
(77, '2021-01-14 21:48:24', 'Portal Registration', 'New Contact Added Henry [CID: 8]', 0, '41.212.54.196'),
(78, '2021-03-02 10:15:36', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.212.62.149'),
(79, '2021-03-04 14:42:04', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.212.62.149'),
(80, '2021-03-12 15:20:06', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.212.77.251'),
(81, '2021-03-12 16:21:41', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.212.77.251'),
(82, '2021-03-25 21:23:21', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.80.107.96'),
(83, '2021-03-25 21:34:54', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.80.107.96'),
(84, '2021-03-27 14:06:40', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.212.77.251'),
(85, '2021-03-27 15:19:32', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '41.212.77.251'),
(86, '2021-03-28 11:09:47', 'Portal Registration', 'New Contact Added Maxwell Owino [CID: 9]', 0, '105.160.112.194'),
(87, '2021-03-28 19:52:05', 'Portal Registration', 'New Contact Added Dee Dee [CID: 10]', 0, '154.159.238.49'),
(88, '2021-04-01 23:55:26', 'Portal Registration', 'New Contact Added dmarx [CID: 11]', 0, '154.154.113.199'),
(89, '2021-04-02 01:28:04', 'Portal Registration', 'New Contact Added kvhxkvh [CID: 12]', 0, '154.159.81.1'),
(90, '2021-04-13 21:18:52', 'Admin', 'Login Successful support@creativehaven.co.ke', 2, '197.237.18.53'),
(91, '2022-01-21 12:53:39', 'Portal Registration', 'New Contact Added Oduor Otieno [CID: 13]', 0, '197.179.136.86');

-- --------------------------------------------------------

--
-- Table structure for table `sys_orders`
--

CREATE TABLE `sys_orders` (
  `id` int(11) NOT NULL,
  `ordernum` varchar(50) DEFAULT NULL,
  `source` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `sales_person` varchar(100) DEFAULT NULL,
  `branch_name` varchar(100) DEFAULT NULL,
  `cname` varchar(100) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `contract_id` int(11) DEFAULT NULL,
  `bid` int(11) DEFAULT NULL,
  `date_added` date DEFAULT NULL,
  `date_expiry` date DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `stitle` varchar(200) DEFAULT NULL,
  `sid` int(11) DEFAULT NULL,
  `iid` int(11) DEFAULT NULL,
  `aid` int(11) DEFAULT NULL,
  `amount` decimal(16,2) NOT NULL DEFAULT 0.00,
  `recurring` decimal(16,2) NOT NULL DEFAULT 0.00,
  `setup_fee` decimal(16,2) NOT NULL DEFAULT 0.00,
  `billing_cycle` text DEFAULT NULL,
  `addon_ids` text DEFAULT NULL,
  `related_orders` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `upgrade_ids` text DEFAULT NULL,
  `xdata` text DEFAULT NULL,
  `xsecret` varchar(100) DEFAULT NULL,
  `promo_code` text DEFAULT NULL,
  `promo_type` text DEFAULT NULL,
  `promo_value` text DEFAULT NULL,
  `payment_method` text DEFAULT NULL,
  `ipaddress` text DEFAULT NULL,
  `fraud_module` text DEFAULT NULL,
  `fraud_output` text DEFAULT NULL,
  `activation_subject` text DEFAULT NULL,
  `activation_message` text DEFAULT NULL,
  `trash` int(1) NOT NULL DEFAULT 0,
  `archived` int(1) NOT NULL DEFAULT 0,
  `c1` text DEFAULT NULL,
  `c2` text DEFAULT NULL,
  `c3` text DEFAULT NULL,
  `c4` text DEFAULT NULL,
  `c5` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_orders`
--

INSERT INTO `sys_orders` (`id`, `ordernum`, `source`, `status`, `sales_person`, `branch_name`, `cname`, `cid`, `contract_id`, `bid`, `date_added`, `date_expiry`, `pid`, `stitle`, `sid`, `iid`, `aid`, `amount`, `recurring`, `setup_fee`, `billing_cycle`, `addon_ids`, `related_orders`, `description`, `upgrade_ids`, `xdata`, `xsecret`, `promo_code`, `promo_type`, `promo_value`, `payment_method`, `ipaddress`, `fraud_module`, `fraud_output`, `activation_subject`, `activation_message`, `trash`, `archived`, `c1`, `c2`, `c3`, `c4`, `c5`) VALUES
(1, '4665311202', NULL, 'Active', NULL, NULL, 'Albanus Mudhune', 3, NULL, NULL, '2020-09-02', NULL, 3, 'STANDARD', NULL, 1, NULL, '84630.00', '0.00', '0.00', 'Quarterly', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_permissions`
--

CREATE TABLE `sys_permissions` (
  `id` int(11) NOT NULL,
  `pname` varchar(200) DEFAULT NULL,
  `shortname` varchar(200) DEFAULT NULL,
  `available` int(1) NOT NULL DEFAULT 0,
  `core` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_permissions`
--

INSERT INTO `sys_permissions` (`id`, `pname`, `shortname`, `available`, `core`) VALUES
(1, 'Customers', 'customers', 0, 1),
(2, 'Companies', 'companies', 0, 1),
(3, 'Transactions', 'transactions', 0, 1),
(4, 'Sales', 'sales', 0, 1),
(5, 'Bank & Cash', 'bank_n_cash', 0, 1),
(6, 'Products & Services', 'products_n_services', 0, 1),
(7, 'Reports', 'reports', 0, 1),
(8, 'Utilities', 'utilities', 0, 1),
(9, 'Appearance', 'appearance', 0, 1),
(10, 'Plugins', 'plugins', 0, 1),
(11, 'Calendar', 'calendar', 0, 1),
(12, 'Leads', 'leads', 0, 1),
(13, 'Tasks', 'tasks', 0, 1),
(14, 'Contracts', 'contracts', 0, 1),
(15, 'Orders', 'orders', 0, 1),
(16, 'Settings', 'settings', 0, 1),
(17, 'Documents', 'documents', 0, 1);

-- --------------------------------------------------------

--
-- Table structure for table `sys_pg`
--

CREATE TABLE `sys_pg` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `settings` text NOT NULL,
  `value` text NOT NULL,
  `processor` text NOT NULL,
  `ins` text NOT NULL,
  `c1` text NOT NULL,
  `c2` text NOT NULL,
  `c3` text NOT NULL,
  `c4` text NOT NULL,
  `c5` text NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `sorder` int(2) NOT NULL,
  `logo` varchar(200) DEFAULT NULL,
  `mode` varchar(200) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_pg`
--

INSERT INTO `sys_pg` (`id`, `name`, `settings`, `value`, `processor`, `ins`, `c1`, `c2`, `c3`, `c4`, `c5`, `status`, `sorder`, `logo`, `mode`) VALUES
(1, 'Paypal', 'Paypal Email', 'demo@example.com', 'paypal', 'Invoices', 'USD', '1', '', '', '', 'Active', 1, NULL, NULL),
(2, 'Stripe', 'API Key', 'sk_test_ARblMczqDw61NusMMs7o1RVK', 'stripe', '', 'USD', '', '', '', '', 'Active', 2, NULL, NULL),
(3, 'Bank / Cash', 'Instructions', 'Make a Payment to Our Bank Account <br>Bank Name: City Bank <br>Account Name: Sadia Sharmin <br>Account Number: 1505XXXXXXXX <br>', 'manualpayment', '', '', '', '', '', '', 'Active', 3, NULL, NULL),
(4, 'Authorize.net', 'API_LOGIN_ID', 'Insert API Login ID here', 'authorize_net', '', 'Insert Transaction Key Here', '', '', '', '', 'Active', 4, NULL, NULL),
(5, 'Braintree', 'Merchant ID', 'your merchant id', 'braintree', '', 'your public key', 'your private key', 'bank account', 'sandbox', '', 'Inactive', 5, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_pl`
--

CREATE TABLE `sys_pl` (
  `id` int(11) NOT NULL,
  `c` varchar(50) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `build` int(10) DEFAULT 1,
  `c1` text DEFAULT NULL,
  `c2` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_pmethods`
--

CREATE TABLE `sys_pmethods` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `sorder` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_pmethods`
--

INSERT INTO `sys_pmethods` (`id`, `name`, `sorder`) VALUES
(1, 'Cash', 1),
(2, 'Check', 4),
(3, 'Credit Card', 5),
(4, 'Debit', 6),
(5, 'Electronic Transfer', 7),
(9, 'Paypal', 2),
(10, 'ATM Withdrawals', 3);

-- --------------------------------------------------------

--
-- Table structure for table `sys_questions`
--

CREATE TABLE `sys_questions` (
  `id` int(10) NOT NULL,
  `evalitemid` int(10) NOT NULL DEFAULT 0,
  `evalid` int(10) DEFAULT NULL,
  `type` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `qty` varchar(20) NOT NULL DEFAULT '1',
  `taxamount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `totalscore` decimal(14,0) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_questions`
--

INSERT INTO `sys_questions` (`id`, `evalitemid`, `evalid`, `type`, `description`, `qty`, `taxamount`, `totalscore`, `notes`) VALUES
(1, 1, 1, '', 'Knowledgeable about the role of QI in leading institutional decision making and service delivery.', '1', '0.00', '5', NULL),
(2, 1, 1, '', 'Able to develop a clear and compelling vision and mission for QI fully integrated in the institution\'s strategic plan/policies and other service delivery/program aspects.', '1', '0.00', '5', NULL),
(3, 1, 1, '', 'Able to articulates the QI vision and mission consistently and effectively to key internal  and external stakeholders and obtains meaningful support.', '1', '0.00', '5', NULL),
(4, 1, 1, '', 'Develops operational links between the QI vision/mission and other key aspects within the program/service delivery.', '1', '0.00', '5', NULL),
(5, 2, 1, '', 'Knowledgable about Operational plans and Policy documents development, able to take lead in developing a concise and living QI strategic plan/policy document.', '1', '0.00', '5', NULL),
(6, 2, 1, '', 'Able to effectively and efficiently operationalize a QI policy document.', '1', '0.00', '5', NULL),
(7, 2, 1, '', 'Able to implement QI policies and procedures and integrate the QI activities of the program into the unified institutional QM system.', '1', '0.00', '5', NULL),
(8, 2, 1, '', 'Able to purpose changes at the planning stage along with the potential results/consequences', '1', '0.00', '5', NULL),
(9, 3, 1, '', 'Able to determine the need and effectively plan for changes in line with the Institution\'s quality objectives', '1', '0.00', '5', NULL),
(10, 3, 1, '', 'Knowledgeable about the findings from routine QI activities/studies and their implications for strategic and operation planning.', '1', '0.00', '5', NULL),
(11, 3, 1, '', 'Able to clearly articulate the implications of findings from routine QI activities and how they can be integrated into strategic and operational planning.', '1', '0.00', '5', NULL),
(12, 3, 1, '', 'Able to develop a clear and concise inprovement plan for the program based on findings from routine QI activities.', '1', '0.00', '5', NULL),
(13, 4, 1, '', 'Knowledgeable about QI terminology and conceptual frameworks  and their utility in establishing a common approach to developing an effective QI system.', '1', '0.00', '5', NULL),
(14, 4, 1, '', 'Knowledgeable on QI quantitative methods and their role in establishing a comprehensive and effective QI approach for the program.', '1', '0.00', '5', NULL),
(15, 4, 1, '', 'Knowledgeable on QI qualitative methods and their role in establishing a comprehensive and effective QI approach for the program.', '1', '0.00', '5', NULL),
(16, 4, 1, '', 'Able to develop an evidence-based program logic model and uses  it as a tool for appropriate management of QI activities for the program.', '1', '0.00', '5', NULL),
(17, 4, 1, '', 'Able to manage a coordinated and participatory process for QI planning linking it to the program strategic plan, including periodic QI capacity  assessments and performance monitoring.', '1', '0.00', '5', NULL),
(18, 4, 1, '', 'Able to identify the QI interests of relevant stakeholders and assesses their information needs.', '1', '0.00', '5', NULL),
(19, 4, 1, '', 'Able to identify standardized QI indicators that are relevant, feasible, and in line with global standards and determine appropriate QI targets for the program.', '1', '0.00', '5', NULL),
(20, 4, 1, '', 'Able to identify human and financial resources needed to implement the QI strategy and secure adequate resources.', '1', '0.00', '5', NULL),
(21, 5, 1, '', 'Able to integrate QI activities/programs within existing service delivery schedules/components', '1', '0.00', '5', NULL),
(22, 5, 1, '', 'Able to utilize service delivery teams/human resource in executing QI initiatives', '1', '0.00', '5', NULL),
(23, 5, 1, '', 'Able to develop and plan QI initiatives alongside existing structures and across multiple departments/units', '1', '0.00', '5', NULL),
(24, 5, 1, '', 'Able to integrate QI activities/programs alongs relevant QI activities in partner institutions', '1', '0.00', '5', NULL),
(25, 6, 1, '', 'Knowledgeable about capacity-building approaches to lead the development of an effective QI capacity-building plan.', '1', '0.00', '5', NULL),
(26, 6, 1, '', 'Leads the development of an effective capacity-building plan, including performance objectives at individual, micro & macro-system levels.', '1', '0.00', '5', NULL),
(27, 6, 1, '', 'Able to identify financial and human resources needed to implement the QI capacity-building plan and secure adequate resources.', '1', '0.00', '5', NULL),
(28, 6, 1, '', 'Able to coordinate the acquisition of the necessary components required to implement the QI capacity -building plan (e.g., training  courses, technical assistance) and monitors/evaluates performance.', '1', '0.00', '5', NULL),
(29, 7, 1, '', 'Able to build professional relationships with key QI experts and partners, to ensure the viability and quality of the partnerships to enhance effective coordination and collaboration.', '1', '0.00', '5', NULL),
(30, 7, 1, '', 'Able to build partnerships to sustain an infrastructure for implementing QI.', '1', '0.00', '5', NULL),
(31, 8, 2, '', 'Knowledgeable about the role, procedures and tools/requirements for routine QI implementation.', '1', '0.00', '5', NULL),
(32, 8, 2, '', 'Able to manage the development and usage of QI approaches and models, functional  data collection, data transfer, and data reporting mechanisms, including standardized tools,  operational guidelines, and QIT responsibilities.', '1', '0.00', '5', NULL),
(33, 9, 2, '', 'Knowledgeable about the role and procedures for QI survey activities.', '1', '0.00', '5', NULL),
(34, 9, 2, '', 'Able to identify specific quality needs to be addressed by a QI initiative.', '1', '0.00', '5', NULL),
(35, 9, 2, '', 'Able to manage QI activities planning (including budgeting), implementation and monitoring.', '1', '0.00', '5', NULL),
(36, 10, 2, '', 'Knowledgeable about Quality Management Policy and Manual.', '1', '0.00', '5', NULL),
(37, 10, 2, '', 'Able to develop and implement a QM policy with reference to ISO 9001:2015', '1', '0.00', '5', NULL),
(38, 10, 2, '', 'Able to identify basic QMS gaps and Documentation needs.', '1', '0.00', '5', NULL),
(39, 10, 2, '', 'Able to dentify and secure financial and human  resources needed to implement QMS deliverables.', '1', '0.00', '5', NULL),
(40, 11, 3, '', 'Knowledgeable about the terms, concepts, models, theories and assumptions used in QI design and implemetation.', '1', '0.00', '5', NULL),
(41, 11, 3, '', 'Able to manage a collaborative process for the development of a QI program and a specific agenda for QI that is both relevant, feasible and focused towards actionable results.', '1', '0.00', '5', NULL),
(42, 11, 3, '', 'Able to develop and implement a mechanism to support dissemination of QI activities findings and their use for program improvement.', '1', '0.00', '5', NULL),
(43, 12, 3, '', 'Knowledgeable about professional QI standards, including ethical, confidentiality, and security requirements.', '1', '0.00', '5', NULL),
(44, 12, 3, '', 'Able to manage the development of the terms of reference for a QIT.', '1', '0.00', '5', NULL),
(45, 12, 3, '', 'Able articulate how QI findings from QI activities can be used to improve program outcomes.', '1', '0.00', '5', NULL),
(46, 12, 3, '', 'Able to establish the scope of QI initiatives with determined boundaries and applicability to the Institution\'s QMS', '1', '0.00', '5', NULL),
(47, 13, 4, '', 'Able to use QI methods/tools appropriate for analysis of quantitative/qualitative findings and results interpretation.', '1', '0.00', '5', NULL),
(48, 13, 4, '', 'Able to develop and implement a routine data monitoring and analysis plan for QI activities.', '1', '0.00', '5', NULL),
(49, 13, 4, '', 'Knowledgeable about the basic concepts and the role of evidence based data analysis.', '1', '0.00', '5', NULL),
(50, 13, 4, '', 'Knowledgeable about the QI cycle and analysis of findings at every implementation stage.', '1', '0.00', '5', NULL),
(51, 13, 4, '', 'Able to manage and integrate key findings from every QI cycle in the susbequent QI initiatives/processes.', '1', '0.00', '5', NULL),
(52, 14, 4, '', 'Knowledgeable about the specific data needs of key decision makers and how to respond to them.', '1', '0.00', '5', NULL),
(53, 14, 4, '', 'Able to develop and implement policies and procedures for the sharing, dissemination of QI activity findings and feedback to relevant stakeholders (such as teams assessed, program managers).', '1', '0.00', '5', NULL),
(54, 14, 4, '', 'Able to manage the production and dissemination of a variety of QI initiatives information and products tailored to specific audiences.', '1', '0.00', '5', NULL),
(55, 15, 4, '', 'Knowledgeable about new QI developments in the key areas of focus to the program activities and their implications in programming.', '1', '0.00', '5', NULL),
(56, 15, 4, '', 'Able to articulate the implications of findings from routine QI activities and their applications to the improvement of the program.', '1', '0.00', '5', NULL),
(57, 16, 5, '', 'Able to make sound and timely managerial/leadership decisions that are consistent with the institution\'s vision and mission.', '1', '0.00', '5', NULL),
(58, 16, 5, '', 'Assumes  responsibility and accepts accountability for decisions.', '1', '0.00', '5', NULL),
(59, 16, 5, '', 'Able to build a mutually supportive team in which all team members are motivated and encouraged to make their contribution.', '1', '0.00', '5', NULL),
(60, 16, 5, '', 'Seeks others’ views and ideas and respects their contribution.', '1', '0.00', '5', NULL),
(61, 16, 5, '', 'Brings problems out in the open and actively seeks  their resolution.', '1', '0.00', '5', NULL),
(62, 16, 5, '', 'Provides  advice in a manner that allows for mutual sharing and learning.', '1', '0.00', '5', NULL),
(63, 17, 5, '', 'Able to justify & articulate the need for financial resources for QI activities in line with the institutional resources and the program\'s priority needs.', '1', '0.00', '5', NULL),
(64, 17, 5, '', 'Able assesses the appropriateness and effectiveness of resource allocations.', '1', '0.00', '5', NULL),
(65, 17, 5, '', 'Able assesses the extent to which existing financial monitoring procedures and systems are transparent and accountable and articulates feasible enhancements.', '1', '0.00', '5', NULL),
(66, 18, 5, '', 'Inspires, influences, and motivate others to engage and perform effectively toward achieving common QI goals.', '1', '0.00', '5', NULL),
(67, 18, 5, '', 'Consults with relevant partners and incorporates their views in a transparent and appropriate manner.', '1', '0.00', '5', NULL),
(68, 18, 5, '', 'Able to translate ideas and opportunities into realistic plans and actions with agreed-upon roles and responsibilities.', '1', '0.00', '5', NULL),
(69, 19, 5, '', 'Able to take prompt and decisive actions when needed.', '1', '0.00', '5', NULL),
(70, 19, 5, '', 'Able to evaluate the implications of various options before deciding on a course of action.', '1', '0.00', '5', NULL),
(71, 19, 5, '', 'Able to deal with conflict in an open and constructive manner and reaches agreements from which both sides can benefit.', '1', '0.00', '5', NULL),
(72, 20, 5, '', 'Able to develop and implement policies and procedures to ensure that ougoing communications are consistently clear and effective, applicable to the relevant/applicable stakeholders.', '1', '0.00', '5', NULL),
(73, 20, 5, '', 'Able to develop and implement policies and procedures to ensure that incoming communications are dealt with in a responsible and timely manner.', '1', '0.00', '5', NULL),
(74, 23, 6, '', 'The institution/organization has has an organogram describing its organization of the QM team in relation to the overall management team', '1', '0.00', '5', NULL),
(75, 23, 6, '', 'There is a demonstrated commitment of the institution\'s top leadership with respect to the QMS', '1', '0.00', '5', NULL),
(76, 23, 6, '', 'There is demonstrated commitment from the institution\'s top leadership with respect client/customer quality needs', '1', '0.00', '5', NULL),
(77, 23, 6, '', 'There exists documented supervision procedures (how often, what to look at, what happens next) to aid the QM leadership', '1', '0.00', '5', NULL),
(78, 23, 6, '', 'There exists a QM Improvement plan for the Institution based on routine supervisory /assessments findings.', '1', '0.00', '5', NULL),
(79, 24, 6, '', 'There exists a QM Improvement plan for the Institution based on routine supervisory /assessments findings.', '1', '0.00', '5', NULL),
(80, 24, 6, '', 'The QM policy document/strategic plan for the institution has been effectively and efficiently operationalized.', '1', '0.00', '5', NULL),
(81, 24, 6, '', 'The QM Policy and procedures are integrated into the unified Financial Policy/system of the institution.', '1', '0.00', '5', NULL),
(82, 24, 6, '', 'The QP is appropriate to the purpose and context of the organization and supports its strategic direction', '1', '0.00', '5', NULL),
(83, 25, 6, '', 'There exists a framework to determine the need for and effectively plan for desired changes in line with the Institution\'s quality objectives.', '1', '0.00', '5', NULL),
(84, 25, 6, '', 'Findings from routine QI initiatives and their implications are clearly communicated and integrated into the instutiton\'s strategic and operational planning QMS strengthening activies.', '1', '0.00', '5', NULL),
(85, 25, 6, '', 'Institutional quality improvement plans are concise and clearly articulated and are based on findings from routine QI activities.', '1', '0.00', '5', NULL),
(86, 26, 6, '', 'The institution\'s QI frameworks  and model is well understood by all in conforminty with the establishment of a common approach to developing an effective QI system.', '1', '0.00', '5', NULL),
(87, 26, 6, '', 'The institution makes use of both quantitative and qualitative QI methods in establishing a comprehensive and effective QI approach for the institution.', '1', '0.00', '5', NULL),
(88, 26, 6, '', 'The Insitutional QI planning is a coordinated and partipatory process and linked to the institution\'s QI policy.', '1', '0.00', '5', NULL),
(89, 26, 6, '', 'Instituinal QI interests of relevant stakeholders has been identified and assessed based on the various levels of information needs.', '1', '0.00', '5', NULL),
(90, 26, 6, '', 'Human and financial resources needed to implement the Institutional QI strategy are planned for and adequate', '1', '0.00', '5', NULL),
(91, 27, 6, '', 'Institutional QI initiatives are integrated within routine service delivery schedules', '1', '0.00', '5', NULL),
(92, 27, 6, '', 'The institutional QI initiatives are developed and planned alongside existing frameworks within key standards and regulatory bodies.', '1', '0.00', '5', NULL),
(93, 27, 6, '', 'The institutional QI initiatives are integrated with relevant QI models by key partner institutions', '1', '0.00', '5', NULL),
(94, 28, 6, '', 'There is an established framework that assures the viability and quality of partnerships with key QI experts and partners for effective coordination and collaboration.', '1', '0.00', '5', NULL),
(95, 28, 6, '', 'There exists established partnerships to sustain an infrastructure for implementing QI.', '1', '0.00', '5', NULL),
(96, 29, 7, '', 'There is an established Quality Management System including process interactions inline with Institutional scope for QMS.', '1', '0.00', '5', NULL),
(97, 29, 7, '', 'The QMS has an established pathway for documentation, implementation, maintenance and continual improvement.', '1', '0.00', '5', NULL),
(98, 29, 7, '', 'There is a demonstrated commitment of the institution\'s top leadership in the development and implementation of institutional quality policy\r\n', '1', '0.00', '5', NULL),
(99, 29, 7, '', 'There is a demonstrated commitment of the institution\'s top leadership in the development and implementation of institutional quality manual\r\n', '1', '0.00', '5', NULL),
(100, 29, 7, '', 'There is a defined quality objectives at relevant levels, functions and processes within the institution\r\n', '1', '0.00', '5', NULL),
(101, 29, 7, '', 'There exists an institutional control of documents procedure and in use across the institution\r\n', '1', '0.00', '5', NULL),
(102, 29, 7, '', 'There exists an institutional control of records procedure and in use across the institution\r\n', '1', '0.00', '5', NULL),
(103, 29, 7, '', 'There exists an institutional QI Internal Audit Procedure and in use across the institution\r\n', '1', '0.00', '5', NULL),
(104, 29, 7, '', 'There exists an institutional Control of Nonconforming Products and in use across the institution\r\n', '1', '0.00', '5', NULL),
(105, 29, 7, '', 'There exists an institutional control of records procedure and in use across the institution\r\n', '1', '0.00', '5', NULL),
(106, 29, 7, '', 'There exists an institutional Corrective Action Procedure and in use across the institution\r\n', '1', '0.00', '5', NULL),
(107, 29, 7, '', 'There exists an institutional Preventive Action Procedure and in use across the institution\r\n', '1', '0.00', '5', NULL),
(108, 29, 7, '', 'There exists an institutional control of records procedure and in use across the institution\r\n', '1', '0.00', '5', NULL),
(109, 29, 7, '', 'There exists an institutional Quality Plan and in use across the institution\r\n', '1', '0.00', '5', NULL),
(110, 29, 7, '', 'There exists an institutional QI Control Plan and in use across the institution\r\n', '1', '0.00', '5', NULL),
(111, 29, 7, '', 'There is an established framework for determing and allocating resources needed for the establishment, implementation, maintenance and continual improvement of the quality management system \r\n', '1', '0.00', '5', NULL),
(112, 29, 7, '', 'There is an established framework to determine and provide the resources needed to ensure valid and reliable result when monitoring or measuring is used to verify the conformity of products and services to requirements.\r\n', '1', '0.00', '5', NULL),
(113, 30, 7, '', 'There is an established framework for communicating and ensuring the understanding of quality policy for implementation within the institution and externally to relevant stakeholders\r\n', '1', '0.00', '5', NULL),
(114, 30, 7, '', 'There exists a reporting framework to relay Key QM indicators.\r\n', '1', '0.00', '5', NULL),
(115, 30, 7, '', 'QM indicators reporting framework is fully operationalized (QM dashboard reviewed regularly).\r\n', '1', '0.00', '5', NULL),
(116, 30, 7, '', 'Management decisions are based on QI Indicators dashboard/reports.\r\n', '1', '0.00', '5', NULL),
(117, 31, 7, '', 'There exists a framework for QI surveillance activities.\r\n', '1', '0.00', '5', NULL),
(118, 31, 7, '', 'QI Surveys/Surveillance activities are tailored to identifying specific quality needs to be addressed.\r\n', '1', '0.00', '5', NULL),
(119, 31, 7, '', 'There exists a Operating Procedures for QI and implemented inline with industry/global standards.\r\n', '1', '0.00', '5', NULL),
(120, 31, 7, '', 'There exists fiancial and human resource capacity to implement QI surveillance and follow-up actions where needed.\r\n', '1', '0.00', '5', NULL),
(121, 32, 8, '', 'There is an established framework for staffing needs assessment for the quality management system\r\n', '1', '0.00', '5', NULL),
(122, 32, 8, '', 'There is an established framework to determine the necessary competence of person(s) working in the quality management system\r\n', '1', '0.00', '5', NULL),
(123, 32, 8, '', 'The Institution\'s top management has ensured a defined roles, responsibilities and authorities for persons in Quality Management and these are well communiated\r\n', '1', '0.00', '5', NULL),
(124, 33, 8, '', 'A procedure exists for orienting new staff on the institution\'s QM system in case of staff turnover\r\n', '1', '0.00', '5', NULL),
(125, 33, 8, '', 'QM staff have received initial orientation on the institution\'s QM System and the relevant policy/manuals. \r\n', '1', '0.00', '5', NULL),
(126, 33, 8, '', 'QM staff are continually oriented on the institution\'s QM System and the relevant policy/manuals changes overtime. \r\n', '1', '0.00', '5', NULL),
(127, 34, 8, '', 'There exists dedicated staffs for QMS\r\n', '1', '0.00', '5', NULL),
(128, 34, 8, '', 'The number of QM team staff is sufficient in relation to the institution size.\r\n', '1', '0.00', '5', NULL),
(129, 34, 8, '', 'The QM team  has an appropriate skills mix (For team of 3>persons - e.g. Clinical, HMIS/Data Analyst, M&E, Finance/Accounts literacy, Patient Representative)\r\n', '1', '0.00', '5', NULL),
(130, 35, 8, '', 'There is an established framework for training needs assessment for persons working in the quality management system\r\n', '1', '0.00', '5', NULL),
(131, 35, 8, '', 'QM staff have been trained at least once in the last two years.\r\n', '1', '0.00', '5', NULL),
(132, 35, 8, '', 'QM staff have received a mentoring/supervision from their supervisor in the last 6 months \r\n', '1', '0.00', '5', NULL),
(133, 36, 8, '', 'QM staff holds effective, efficient, and productive staff meetings at regular intervals.\r\n', '1', '0.00', '5', NULL),
(134, 36, 8, '', 'There exists a framework for performance evaluataion and appraisal for staff in QMS\r\n', '1', '0.00', '5', NULL),
(135, 36, 8, '', 'There exists an inclusisve framework for feedback management for QMS staff\r\n', '1', '0.00', '5', NULL),
(136, 37, 9, '', 'There exists Emergency Care Indicator reference guide \r\n', '1', '0.00', '5', NULL),
(137, 37, 9, '', 'Staffs are aware and have been trained on the indicator reference sheet fo emergency care\r\n', '1', '0.00', '5', NULL),
(138, 37, 9, '', 'Emergency care indicator reference guide is in use\r\n', '1', '0.00', '5', NULL),
(139, 38, 9, '', 'There exists a Patient Safety Indicator reference guide \r\n', '1', '0.00', '5', NULL),
(140, 38, 9, '', 'Staffs are aware and have been trained on the indicator reference sheet for Patient Safety\r\n', '1', '0.00', '5', NULL),
(141, 38, 9, '', 'Patient Safety indicator reference guide is in use\r\n', '1', '0.00', '5', NULL),
(142, 39, 9, '', 'There exists a Prevention Care Indicator reference guide \r\n', '1', '0.00', '5', NULL),
(143, 39, 9, '', 'Staffs are aware and have been trained on the indicator reference sheet for Prevention Care\r\n', '1', '0.00', '5', NULL),
(144, 39, 9, '', 'Prevention Care Indicator reference guide is in use\r\n', '1', '0.00', '5', NULL),
(145, 40, 9, '', 'There exist an In Patient Care Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(146, 40, 9, '', 'Staffs are aware and have been trained on the In Patient Care Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(147, 40, 9, '', 'In Patient Care indicator reference guide is in use\r\n', '1', '0.00', '5', NULL),
(148, 41, 9, '', 'There exist a Nursing Care Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(149, 41, 9, '', 'Staffs are aware and have been trained on the Nursing Care Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(150, 41, 9, '', 'Nursing Care Indicator reference guide is in use\r\n', '1', '0.00', '5', NULL),
(151, 42, 9, '', 'There exist a Surgical Safety and Quality Improvement Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(152, 42, 9, '', 'Staffs are aware and have been trained on the Surgical Safety and Quality Improvement Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(153, 42, 9, '', 'The Safety and Quality Improvement Indicator reference guide is in use\r\n', '1', '0.00', '5', NULL),
(154, 43, 9, '', 'There exist a Laboratory Safety and Quality Improvement Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(155, 43, 9, '', 'Staffs are aware and have been trained on the Laboratory Safety and Quality Improvement Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(156, 43, 9, '', 'The Safety and Quality Improvement Indicator reference guide is in use\r\n', '1', '0.00', '5', NULL),
(157, 44, 9, '', 'There exist a Pharmaceutical Safety and Quality Improvement Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(158, 44, 9, '', 'Staffs are aware and have been trained on the Pharmaceutical Safety and Quality Improvement Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(159, 44, 9, '', 'The Safety and Quality Improvement Indicator reference guide is in use\r\n', '1', '0.00', '5', NULL),
(160, 45, 9, '', 'There exists a Radiology Safety  and Quality Improvement Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(161, 45, 9, '', 'Staffs are aware and have been trained on the Radiology Safety  and Quality Improvement Indicator reference guide\r\n', '1', '0.00', '5', NULL),
(162, 45, 9, '', 'The Safety and Quality Improvement Indicator reference guide is in use\r\n', '1', '0.00', '5', NULL),
(163, 46, 10, '', '\"A framework to understand customers’ current and future needs\r\nand expectations exists and is in use.\"\r\n', '1', '0.00', '5', NULL),
(164, 46, 10, '', 'The Institution’s objectives are linked to the needs and expectations of the customer.\r\n', '1', '0.00', '5', NULL),
(165, 46, 10, '', 'The Institution has in a framework to measure and monitor customer satisfaction and take appropriate actions.\r\n', '1', '0.00', '5', NULL),
(166, 46, 10, '', '\"The Institution ctively manages relationships with its customers\r\nto achieve sustained success.\"\r\n', '1', '0.00', '5', NULL),
(167, 46, 10, '', 'Customer needs and expecatitions are clearly communicated across all levels of the Institution.\r\n', '1', '0.00', '5', NULL),
(168, 47, 10, '', 'The institution actively communicates with people to promote understanding of the importance of their individual contribution.\r\n', '1', '0.00', '5', NULL),
(169, 47, 10, '', 'The institution activiely promotes collaboration among service providers, customers and other stakeholders throughout the institution.\r\n', '1', '0.00', '5', NULL),
(170, 47, 10, '', 'The institution has in place a framework to empower its people to determine constraints to performance and to take initiatives without fear\r\n', '1', '0.00', '5', NULL),
(171, 47, 10, '', 'The institution recognizes and acknowledges people’s contribution towards learning and improvement.\r\n', '1', '0.00', '5', NULL),
(172, 47, 10, '', 'The institution enables self-evaluation of performance against personal objectives.\r\n', '1', '0.00', '5', NULL),
(173, 47, 10, '', 'The institution facilitates open discussion and sharing of knowledge and experience.\r\n', '1', '0.00', '5', NULL),
(174, 47, 10, '', 'The institution regularly conducts surveys to assess people’s satisfaction, communicate the results, and take appropriate actions.\r\n', '1', '0.00', '5', NULL),
(175, 48, 10, '', 'There exists a framework to determine relevant interested parties (such as suppliers, partners, customers, investors, employees, and society as a whole) and their relationship with the institution.\r\n', '1', '0.00', '5', NULL),
(176, 48, 10, '', 'The institution actively determines and prioritizes interested party relationships that need to be managed.\r\n', '1', '0.00', '5', NULL),
(177, 48, 10, '', 'There is established stakeholder relationships that balance short-term gains with long-term considerations.\r\n', '1', '0.00', '5', NULL),
(178, 48, 10, '', 'The institution actively pools and shares information, expertise and resources with relevant interested parties.\r\n', '1', '0.00', '5', NULL),
(179, 48, 10, '', 'The institution regularly measures performance and provides performance feedback to interested parties, as appropriate, to enhance improvement initiatives.\r\n', '1', '0.00', '5', NULL),
(180, 48, 10, '', 'There is an established relationship for collaborative development and improvement activities with suppliers, partners and other interested parties.\r\n', '1', '0.00', '5', NULL),
(181, 48, 10, '', 'The institution encourages and recognizes improvements and achievements by suppliers and partners.\r\n', '1', '0.00', '5', NULL),
(182, 49, 10, '', 'There exists a defined objectives of the quality management system, and processes necessary to achieve them.\r\n', '1', '0.00', '5', NULL),
(183, 49, 10, '', 'There is an established authority, responsibility and accountability for managing the quality management processes.\r\n', '1', '0.00', '5', NULL),
(184, 49, 10, '', 'There exists a framework to understand the institution’s capabilities and determine resource constraints prior to action.\r\n', '1', '0.00', '5', NULL),
(185, 49, 10, '', 'The institution has a framework to determine process interdependencies and analyse the effect of modifications to individual processes on the quality management system as a whole.\r\n', '1', '0.00', '5', NULL),
(186, 49, 10, '', 'The institution manages processes and their interrelations as a system to achieve the organization’s quality objectives effectively and efficiently.\r\n', '1', '0.00', '5', NULL),
(187, 49, 10, '', 'The necessary information to operate and improve the processes and to monitor, analyse and evaluate the performance of the overall quality management system has been availed.\r\n', '1', '0.00', '5', NULL),
(188, 49, 10, '', 'There exists a framework to manage risks that can affect outputs of the processes and overall outcomes of the quality management system.', '1', '0.00', '5', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_quoteitems`
--

CREATE TABLE `sys_quoteitems` (
  `id` int(10) NOT NULL,
  `qid` int(10) NOT NULL,
  `itemcode` text NOT NULL,
  `description` text NOT NULL,
  `qty` text NOT NULL,
  `amount` decimal(18,2) NOT NULL,
  `discount` decimal(10,2) NOT NULL,
  `total` decimal(18,2) NOT NULL,
  `taxable` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_quoteitems`
--

INSERT INTO `sys_quoteitems` (`id`, `qid`, `itemcode`, `description`, `qty`, `amount`, `discount`, `total`, `taxable`) VALUES
(1, 1, '', 'tes', '1', '600.00', '0.00', '600.00', 0),
(2, 1, '', '3asdas', '1', '100.00', '0.00', '100.00', 0);

-- --------------------------------------------------------

--
-- Table structure for table `sys_quotes`
--

CREATE TABLE `sys_quotes` (
  `id` int(10) NOT NULL,
  `subject` text NOT NULL,
  `stage` enum('Draft','Delivered','On Hold','Accepted','Lost','Dead') NOT NULL,
  `validuntil` date NOT NULL,
  `userid` int(10) NOT NULL,
  `invoicenum` text NOT NULL,
  `cn` text NOT NULL,
  `account` text NOT NULL,
  `firstname` text NOT NULL,
  `lastname` text NOT NULL,
  `companyname` text NOT NULL,
  `email` text NOT NULL,
  `address1` text NOT NULL,
  `address2` text NOT NULL,
  `city` text NOT NULL,
  `state` text NOT NULL,
  `postcode` text NOT NULL,
  `country` text NOT NULL,
  `phonenumber` text NOT NULL,
  `currency` int(10) NOT NULL,
  `subtotal` decimal(18,2) NOT NULL,
  `discount_type` text NOT NULL,
  `discount_value` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) NOT NULL,
  `taxname` text NOT NULL,
  `taxrate` decimal(10,2) NOT NULL,
  `tax1` decimal(10,2) NOT NULL,
  `tax2` decimal(10,2) NOT NULL,
  `total` decimal(18,2) NOT NULL,
  `proposal` text NOT NULL,
  `customernotes` text NOT NULL,
  `adminnotes` text NOT NULL,
  `datecreated` date NOT NULL,
  `lastmodified` date NOT NULL,
  `datesent` date NOT NULL,
  `dateaccepted` date NOT NULL,
  `vtoken` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_quotes`
--

INSERT INTO `sys_quotes` (`id`, `subject`, `stage`, `validuntil`, `userid`, `invoicenum`, `cn`, `account`, `firstname`, `lastname`, `companyname`, `email`, `address1`, `address2`, `city`, `state`, `postcode`, `country`, `phonenumber`, `currency`, `subtotal`, `discount_type`, `discount_value`, `discount`, `taxname`, `taxrate`, `tax1`, `tax2`, `total`, `proposal`, `customernotes`, `adminnotes`, `datecreated`, `lastmodified`, `datesent`, `dateaccepted`, `vtoken`) VALUES
(1, 'test', 'Draft', '2020-09-26', 3, '', '', 'Albanus Mudhune', '', '', '', '', '', '', '', '', '', '', '', 1, '700.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '700.00', '', '', '', '2020-08-26', '2020-08-26', '2020-08-26', '2020-08-26', '1703476895');

-- --------------------------------------------------------

--
-- Table structure for table `sys_results`
--

CREATE TABLE `sys_results` (
  `id` int(10) NOT NULL,
  `userid` int(10) DEFAULT NULL,
  `topicid` varchar(200) DEFAULT NULL,
  `testerid` varchar(100) DEFAULT '',
  `date` date DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `testid` varchar(200) DEFAULT NULL,
  `actionplanid` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_results`
--

INSERT INTO `sys_results` (`id`, `userid`, `topicid`, `testerid`, `date`, `status`, `testid`, `actionplanid`) VALUES
(1, 4, '1', '1', '2020-10-05', 'Active', NULL, NULL),
(2, 4, '1', '2', '2020-10-05', 'Active', NULL, 'Yes'),
(3, 5, '1', '3', '2020-10-19', 'Active', NULL, NULL),
(4, 4, '1', '4', '2020-10-20', 'Active', NULL, NULL),
(5, 3, '1', '1', '2020-10-20', 'Active', NULL, NULL),
(6, 6, '1', '2', '2020-10-20', 'Active', NULL, 'Yes'),
(7, 3, '2', '3', '2021-01-05', 'Active', NULL, NULL),
(8, 7, '1', '4', '2021-01-07', 'Active', NULL, NULL),
(9, 7, '1', '5', '2021-01-16', 'Active', NULL, NULL),
(10, 3, '1', '6', '2021-03-02', 'Active', NULL, NULL),
(11, 3, '2', '1', '2021-03-11', 'Active', NULL, NULL),
(12, 3, '2', '2', '2021-03-11', 'Active', NULL, NULL),
(13, 3, '2', '3', '2021-03-27', 'Active', NULL, NULL),
(14, 11, '2', '4', '2021-04-01', 'Active', NULL, NULL),
(15, 13, '2', '5', '2022-01-21', 'Active', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_roles`
--

CREATE TABLE `sys_roles` (
  `id` int(11) NOT NULL,
  `rname` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_roles`
--

INSERT INTO `sys_roles` (`id`, `rname`) VALUES
(1, 'Employee'),
(2, 'Accountant');

-- --------------------------------------------------------

--
-- Table structure for table `sys_sales`
--

CREATE TABLE `sys_sales` (
  `id` int(11) NOT NULL,
  `cid` int(11) NOT NULL DEFAULT 0,
  `oid` int(11) NOT NULL DEFAULT 0,
  `oname` varchar(200) NOT NULL,
  `description` mediumtext NOT NULL,
  `amount` decimal(14,2) NOT NULL,
  `term` varchar(100) NOT NULL,
  `milestone` varchar(100) NOT NULL,
  `p` int(11) NOT NULL,
  `o` int(11) NOT NULL,
  `open` date NOT NULL,
  `close` date NOT NULL,
  `status` enum('New','In Progress','Won','Lost') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_schedule`
--

CREATE TABLE `sys_schedule` (
  `id` int(11) NOT NULL,
  `cname` mediumtext NOT NULL,
  `val` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_schedule`
--

INSERT INTO `sys_schedule` (`id`, `cname`, `val`) VALUES
(1, 'accounting_snapshot', 'Active'),
(2, 'recurring_invoice', 'Active'),
(3, 'notify', 'Active'),
(4, 'notifyemail', 'admin@systemsevaluation.co.ke');

-- --------------------------------------------------------

--
-- Table structure for table `sys_schedulelogs`
--

CREATE TABLE `sys_schedulelogs` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `logs` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_schedulelogs`
--

INSERT INTO `sys_schedulelogs` (`id`, `date`, `logs`) VALUES
(4, '2015-03-14', '2015-03-14 20:17:15 : Schedule Jobs Started....... <br>2015-03-14 20:17:15 : Creating Accounting Snapshot <br>2015-03-14 20:17:15 : Accounting Snapshot created! <br>=============== Accounting Snaphsot ==================== <br>Accounting Snaphsot - Date: 2015-03-13<br>Total Income: Tk. 0.00<br>Total Expense: Tk. 0.00<br>================================================== <br>2015-03-14 20:17:15 : Creating Recurring Invoice <br>2015-03-14 20:17:15 : 1 Invoice created! <br>================================================== <br>');

-- --------------------------------------------------------

--
-- Table structure for table `sys_staffpermissions`
--

CREATE TABLE `sys_staffpermissions` (
  `id` int(11) NOT NULL,
  `rid` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `shortname` varchar(50) DEFAULT NULL,
  `can_view` int(1) NOT NULL DEFAULT 0,
  `can_edit` int(1) NOT NULL DEFAULT 0,
  `can_create` int(1) NOT NULL DEFAULT 0,
  `can_delete` int(1) NOT NULL DEFAULT 0,
  `all_data` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_staffpermissions`
--

INSERT INTO `sys_staffpermissions` (`id`, `rid`, `pid`, `shortname`, `can_view`, `can_edit`, `can_create`, `can_delete`, `all_data`) VALUES
(1, 2, 1, 'customers', 1, 1, 1, 1, 0),
(2, 2, 2, 'companies', 1, 1, 1, 1, 0),
(3, 2, 3, 'transactions', 1, 1, 1, 1, 0),
(4, 2, 4, 'sales', 1, 1, 1, 1, 0),
(5, 2, 5, 'bank_n_cash', 1, 1, 1, 1, 0),
(6, 2, 6, 'products_n_services', 1, 1, 1, 1, 0),
(7, 2, 7, 'reports', 0, 0, 0, 0, 0),
(8, 2, 8, 'utilities', 0, 0, 0, 0, 0),
(9, 2, 9, 'appearance', 0, 0, 0, 0, 0),
(10, 2, 10, 'plugins', 0, 0, 0, 0, 0),
(11, 2, 11, 'calendar', 0, 0, 0, 0, 0),
(12, 2, 12, 'leads', 0, 0, 0, 0, 0),
(13, 2, 13, 'tasks', 0, 0, 0, 0, 0),
(14, 2, 14, 'contracts', 0, 0, 0, 0, 0),
(15, 2, 15, 'orders', 1, 1, 1, 1, 0),
(16, 2, 16, 'settings', 0, 0, 0, 0, 0),
(17, 2, 17, 'documents', 1, 1, 1, 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `sys_tags`
--

CREATE TABLE `sys_tags` (
  `id` int(11) NOT NULL,
  `text` varchar(100) NOT NULL,
  `type` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_tasks`
--

CREATE TABLE `sys_tasks` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `cid` int(11) NOT NULL DEFAULT 0,
  `oid` int(11) NOT NULL DEFAULT 0,
  `iid` int(11) NOT NULL DEFAULT 0,
  `aid` int(11) NOT NULL DEFAULT 0,
  `tid` int(11) NOT NULL DEFAULT 0,
  `eid` int(11) NOT NULL DEFAULT 0,
  `pid` int(11) NOT NULL DEFAULT 0,
  `did` int(11) NOT NULL DEFAULT 0,
  `company_id` int(11) NOT NULL DEFAULT 0,
  `subscribers` text DEFAULT NULL,
  `assigned_to` text DEFAULT NULL,
  `priority` varchar(200) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(200) DEFAULT NULL,
  `vtoken` varchar(50) DEFAULT NULL,
  `ptoken` varchar(50) DEFAULT NULL,
  `started` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `stime` varchar(50) DEFAULT NULL,
  `dtime` varchar(50) DEFAULT NULL,
  `time_spent` varchar(50) DEFAULT NULL,
  `date_finished` date DEFAULT NULL,
  `source` varchar(100) DEFAULT NULL,
  `flag` int(1) NOT NULL DEFAULT 0,
  `finished` int(1) NOT NULL DEFAULT 0,
  `ratings` varchar(50) DEFAULT NULL,
  `rel_type` varchar(50) DEFAULT NULL,
  `rel_id` int(11) DEFAULT NULL,
  `parent` int(11) NOT NULL DEFAULT 0,
  `is_public` int(1) NOT NULL DEFAULT 0,
  `billable` int(1) NOT NULL DEFAULT 0,
  `billed` int(1) NOT NULL DEFAULT 0,
  `hourly_rate` decimal(14,2) NOT NULL DEFAULT 0.00,
  `milestone` int(11) DEFAULT NULL,
  `progress` int(3) DEFAULT NULL,
  `visible_to_client` int(1) NOT NULL DEFAULT 0,
  `notification` int(1) NOT NULL DEFAULT 0,
  `trash` int(1) NOT NULL DEFAULT 0,
  `archived` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_tax`
--

CREATE TABLE `sys_tax` (
  `id` int(10) NOT NULL,
  `name` text NOT NULL,
  `state` text NOT NULL,
  `country` text NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `aid` int(11) NOT NULL,
  `bal` decimal(10,2) NOT NULL DEFAULT 0.00
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_tax`
--

INSERT INTO `sys_tax` (`id`, `name`, `state`, `country`, `rate`, `aid`, `bal`) VALUES
(1, 'Sales Tax', '', '', '14.00', 0, '0.00');

-- --------------------------------------------------------

--
-- Table structure for table `sys_testitems`
--

CREATE TABLE `sys_testitems` (
  `id` int(10) NOT NULL,
  `invoiceid` int(10) NOT NULL DEFAULT 0,
  `userid` int(10) NOT NULL,
  `type` text NOT NULL,
  `relid` int(10) NOT NULL,
  `itemcode` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `qty` varchar(20) NOT NULL DEFAULT '1',
  `amount` decimal(14,2) NOT NULL DEFAULT 0.00,
  `taxed` int(1) NOT NULL,
  `taxamount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total` decimal(14,2) NOT NULL DEFAULT 0.00,
  `duedate` date DEFAULT NULL,
  `paymentmethod` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sys_tests`
--

CREATE TABLE `sys_tests` (
  `id` int(10) NOT NULL,
  `userid` int(10) DEFAULT NULL,
  `evalid` varchar(200) DEFAULT NULL,
  `testerid` varchar(100) DEFAULT '',
  `evalitemid` text DEFAULT NULL,
  `date` date DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `r` varchar(100) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT 0,
  `resultid` varchar(200) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_tests`
--

INSERT INTO `sys_tests` (`id`, `userid`, `evalid`, `testerid`, `evalitemid`, `date`, `status`, `r`, `level`, `resultid`) VALUES
(1, 3, '1', '1', '1', '2020-10-20', NULL, '0', 1, '1'),
(2, 3, '1', '1', '1', '2020-10-20', NULL, '0', 1, '1'),
(3, 3, '1', '1', '1', '2020-10-20', NULL, '0', 1, '1'),
(4, 3, '1', '1', '1', '2020-10-20', NULL, '0', 1, '1'),
(5, 3, '1', '1', '2', '2020-10-20', NULL, '0', 1, '1'),
(6, 3, '1', '1', '2', '2020-10-20', NULL, '0', 1, '1'),
(7, 3, '1', '1', '2', '2020-10-20', NULL, '0', 1, '1'),
(8, 3, '1', '1', '2', '2020-10-20', NULL, '0', 1, '1'),
(9, 3, '1', '1', '3', '2020-10-20', NULL, '0', 1, '1'),
(10, 3, '1', '1', '3', '2020-10-20', NULL, '0', 1, '1'),
(11, 3, '1', '1', '3', '2020-10-20', NULL, '0', 1, '1'),
(12, 3, '1', '1', '3', '2020-10-20', NULL, '0', 1, '1'),
(13, 3, '1', '1', '4', '2020-10-20', NULL, '0', 1, '1'),
(14, 3, '1', '1', '4', '2020-10-20', NULL, '0', 1, '1'),
(15, 3, '1', '1', '4', '2020-10-20', NULL, '0', 1, '1'),
(16, 3, '1', '1', '4', '2020-10-20', NULL, '0', 1, '1'),
(17, 3, '1', '1', '4', '2020-10-20', NULL, '0', 1, '1'),
(18, 3, '1', '1', '4', '2020-10-20', NULL, '0', 1, '1'),
(19, 3, '1', '1', '4', '2020-10-20', NULL, '0', 1, '1'),
(20, 3, '1', '1', '4', '2020-10-20', NULL, '0', 1, '1'),
(21, 3, '1', '1', '5', '2020-10-20', NULL, '0', 1, '1'),
(22, 3, '1', '1', '5', '2020-10-20', NULL, '0', 1, '1'),
(23, 3, '1', '1', '5', '2020-10-20', NULL, '0', 1, '1'),
(24, 3, '1', '1', '5', '2020-10-20', NULL, '0', 1, '1'),
(25, 3, '1', '1', '6', '2020-10-20', NULL, '0', 1, '1'),
(26, 3, '1', '1', '6', '2020-10-20', NULL, '0', 1, '1'),
(27, 3, '1', '1', '6', '2020-10-20', NULL, '0', 1, '1'),
(28, 3, '1', '1', '6', '2020-10-20', NULL, '0', 1, '1'),
(29, 3, '1', '1', '7', '2020-10-20', NULL, '0', 1, '1'),
(30, 3, '1', '1', '7', '2020-10-20', NULL, '0', 1, '1'),
(31, 3, '2', '1', '8', '2020-10-20', NULL, '0', 1, '1'),
(32, 3, '2', '1', '8', '2020-10-20', NULL, '0', 1, '1'),
(33, 3, '2', '1', '9', '2020-10-20', NULL, '0', 1, '1'),
(34, 3, '2', '1', '9', '2020-10-20', NULL, '0', 1, '1'),
(35, 3, '2', '1', '9', '2020-10-20', NULL, '0', 1, '1'),
(36, 3, '2', '1', '10', '2020-10-20', NULL, '0', 1, '1'),
(37, 3, '2', '1', '10', '2020-10-20', NULL, '0', 1, '1'),
(38, 3, '2', '1', '10', '2020-10-20', NULL, '0', 1, '1'),
(39, 3, '2', '1', '10', '2020-10-20', NULL, '0', 1, '1'),
(40, 3, '3', '1', '11', '2020-10-20', NULL, '0', 1, '1'),
(41, 3, '3', '1', '11', '2020-10-20', NULL, '0', 1, '1'),
(42, 3, '3', '1', '11', '2020-10-20', NULL, '0', 1, '1'),
(43, 3, '3', '1', '12', '2020-10-20', NULL, '0', 1, '1'),
(44, 3, '3', '1', '12', '2020-10-20', NULL, '0', 1, '1'),
(45, 3, '3', '1', '12', '2020-10-20', NULL, '0', 1, '1'),
(46, 3, '3', '1', '12', '2020-10-20', NULL, '0', 1, '1'),
(47, 3, '4', '1', '13', '2020-10-20', NULL, '0', 1, '1'),
(48, 3, '4', '1', '13', '2020-10-20', NULL, '0', 1, '1'),
(49, 3, '4', '1', '13', '2020-10-20', NULL, '0', 1, '1'),
(50, 3, '4', '1', '13', '2020-10-20', NULL, '0', 1, '1'),
(51, 3, '4', '1', '13', '2020-10-20', NULL, '0', 1, '1'),
(52, 3, '4', '1', '14', '2020-10-20', NULL, '0', 1, '1'),
(53, 3, '4', '1', '14', '2020-10-20', NULL, '0', 1, '1'),
(54, 3, '4', '1', '14', '2020-10-20', NULL, '0', 1, '1'),
(55, 3, '4', '1', '15', '2020-10-20', NULL, '0', 1, '1'),
(56, 3, '4', '1', '15', '2020-10-20', NULL, '0', 1, '1'),
(57, 3, '5', '1', '16', '2020-10-20', NULL, '0', 1, '1'),
(58, 3, '5', '1', '16', '2020-10-20', NULL, '0', 1, '1'),
(59, 3, '5', '1', '16', '2020-10-20', NULL, '0', 1, '1'),
(60, 3, '5', '1', '16', '2020-10-20', NULL, '0', 1, '1'),
(61, 3, '5', '1', '16', '2020-10-20', NULL, '0', 1, '1'),
(62, 3, '5', '1', '16', '2020-10-20', NULL, '0', 1, '1'),
(63, 3, '5', '1', '17', '2020-10-20', NULL, '0', 1, '1'),
(64, 3, '5', '1', '17', '2020-10-20', NULL, '0', 1, '1'),
(65, 3, '5', '1', '17', '2020-10-20', NULL, '0', 1, '1'),
(66, 3, '5', '1', '18', '2020-10-20', NULL, '0', 1, '1'),
(67, 3, '5', '1', '18', '2020-10-20', NULL, '0', 1, '1'),
(68, 3, '5', '1', '18', '2020-10-20', NULL, '0', 1, '1'),
(69, 3, '5', '1', '19', '2020-10-20', NULL, '0', 1, '1'),
(70, 3, '5', '1', '19', '2020-10-20', NULL, '0', 1, '1'),
(71, 3, '5', '1', '19', '2020-10-20', NULL, '0', 1, '1'),
(72, 3, '5', '1', '20', '2020-10-20', NULL, '0', 1, '1'),
(73, 3, '5', '1', '20', '2020-10-20', NULL, '0', 1, '1'),
(74, 6, '1', '2', '1', '2020-10-20', NULL, '0', 4, '2'),
(75, 6, '1', '2', '1', '2020-10-20', NULL, '0', 4, '2'),
(76, 6, '1', '2', '1', '2020-10-20', NULL, '0', 4, '2'),
(77, 6, '1', '2', '1', '2020-10-20', NULL, '0', 4, '2'),
(78, 6, '1', '2', '2', '2020-10-20', NULL, '0', 3, '2'),
(79, 6, '1', '2', '2', '2020-10-20', NULL, '0', 3, '2'),
(80, 6, '1', '2', '2', '2020-10-20', NULL, '0', 3, '2'),
(81, 6, '1', '2', '2', '2020-10-20', NULL, '0', 3, '2'),
(82, 6, '1', '2', '3', '2020-10-20', NULL, '0', 3, '2'),
(83, 6, '1', '2', '3', '2020-10-20', NULL, '0', 3, '2'),
(84, 6, '1', '2', '3', '2020-10-20', NULL, '0', 4, '2'),
(85, 6, '1', '2', '3', '2020-10-20', NULL, '0', 4, '2'),
(86, 6, '1', '2', '4', '2020-10-20', NULL, '0', 4, '2'),
(87, 6, '1', '2', '4', '2020-10-20', NULL, '0', 3, '2'),
(88, 6, '1', '2', '4', '2020-10-20', NULL, '0', 3, '2'),
(89, 6, '1', '2', '4', '2020-10-20', NULL, '0', 3, '2'),
(90, 6, '1', '2', '4', '2020-10-20', NULL, '0', 4, '2'),
(91, 6, '1', '2', '4', '2020-10-20', NULL, '0', 3, '2'),
(92, 6, '1', '2', '4', '2020-10-20', NULL, '0', 3, '2'),
(93, 6, '1', '2', '4', '2020-10-20', NULL, '0', 4, '2'),
(94, 6, '1', '2', '5', '2020-10-20', NULL, '0', 2, '2'),
(95, 6, '1', '2', '5', '2020-10-20', NULL, '0', 2, '2'),
(96, 6, '1', '2', '5', '2020-10-20', NULL, '0', 2, '2'),
(97, 6, '1', '2', '5', '2020-10-20', NULL, '0', 2, '2'),
(98, 6, '1', '2', '6', '2020-10-20', NULL, '0', 4, '2'),
(99, 6, '1', '2', '6', '2020-10-20', NULL, '0', 4, '2'),
(100, 6, '1', '2', '6', '2020-10-20', NULL, '0', 4, '2'),
(101, 6, '1', '2', '6', '2020-10-20', NULL, '0', 3, '2'),
(102, 6, '1', '2', '7', '2020-10-20', NULL, '0', 4, '2'),
(103, 6, '1', '2', '7', '2020-10-20', NULL, '0', 4, '2'),
(104, 6, '2', '2', '8', '2020-10-20', NULL, '0', 4, '2'),
(105, 6, '2', '2', '8', '2020-10-20', NULL, '0', 5, '2'),
(106, 6, '2', '2', '9', '2020-10-20', NULL, '0', 1, '2'),
(107, 6, '2', '2', '9', '2020-10-20', NULL, '0', 1, '2'),
(108, 6, '2', '2', '9', '2020-10-20', NULL, '0', 1, '2'),
(109, 6, '2', '2', '10', '2020-10-20', NULL, '0', 2, '2'),
(110, 6, '2', '2', '10', '2020-10-20', NULL, '0', 2, '2'),
(111, 6, '2', '2', '10', '2020-10-20', NULL, '0', 2, '2'),
(112, 6, '2', '2', '10', '2020-10-20', NULL, '0', 2, '2'),
(113, 6, '3', '2', '11', '2020-10-20', NULL, '0', 3, '2'),
(114, 6, '3', '2', '11', '2020-10-20', NULL, '0', 3, '2'),
(115, 6, '3', '2', '11', '2020-10-20', NULL, '0', 3, '2'),
(116, 6, '3', '2', '12', '2020-10-20', NULL, '0', 4, '2'),
(117, 6, '3', '2', '12', '2020-10-20', NULL, '0', 4, '2'),
(118, 6, '3', '2', '12', '2020-10-20', NULL, '0', 4, '2'),
(119, 6, '3', '2', '12', '2020-10-20', NULL, '0', 4, '2'),
(120, 6, '4', '2', '13', '2020-10-20', NULL, '0', 4, '2'),
(121, 6, '4', '2', '13', '2020-10-20', NULL, '0', 2, '2'),
(122, 6, '4', '2', '13', '2020-10-20', NULL, '0', 2, '2'),
(123, 6, '4', '2', '13', '2020-10-20', NULL, '0', 3, '2'),
(124, 6, '4', '2', '13', '2020-10-20', NULL, '0', 3, '2'),
(125, 6, '4', '2', '14', '2020-10-20', NULL, '0', 3, '2'),
(126, 6, '4', '2', '14', '2020-10-20', NULL, '0', 3, '2'),
(127, 6, '4', '2', '14', '2020-10-20', NULL, '0', 3, '2'),
(128, 6, '4', '2', '15', '2020-10-20', NULL, '0', 3, '2'),
(129, 6, '4', '2', '15', '2020-10-20', NULL, '0', 3, '2'),
(130, 6, '5', '2', '16', '2020-10-20', NULL, '0', 3, '2'),
(131, 6, '5', '2', '16', '2020-10-20', NULL, '0', 3, '2'),
(132, 6, '5', '2', '16', '2020-10-20', NULL, '0', 3, '2'),
(133, 6, '5', '2', '16', '2020-10-20', NULL, '0', 3, '2'),
(134, 6, '5', '2', '16', '2020-10-20', NULL, '0', 3, '2'),
(135, 6, '5', '2', '16', '2020-10-20', NULL, '0', 4, '2'),
(136, 6, '5', '2', '17', '2020-10-20', NULL, '0', 3, '2'),
(137, 6, '5', '2', '17', '2020-10-20', NULL, '0', 3, '2'),
(138, 6, '5', '2', '17', '2020-10-20', NULL, '0', 3, '2'),
(139, 6, '5', '2', '18', '2020-10-20', NULL, '0', 1, '2'),
(140, 6, '5', '2', '18', '2020-10-20', NULL, '0', 1, '2'),
(141, 6, '5', '2', '18', '2020-10-20', NULL, '0', 3, '2'),
(142, 6, '5', '2', '19', '2020-10-20', NULL, '0', 3, '2'),
(143, 6, '5', '2', '19', '2020-10-20', NULL, '0', 1, '2'),
(144, 6, '5', '2', '19', '2020-10-20', NULL, '0', 3, '2'),
(145, 6, '5', '2', '20', '2020-10-20', NULL, '0', 5, '2'),
(146, 6, '5', '2', '20', '2020-10-20', NULL, '0', 5, '2'),
(147, 3, '6', '3', '23', '2021-01-05', NULL, '0', 1, '3'),
(148, 3, '6', '3', '23', '2021-01-05', NULL, '0', 1, '3'),
(149, 3, '6', '3', '23', '2021-01-05', NULL, '0', 1, '3'),
(150, 3, '6', '3', '23', '2021-01-05', NULL, '0', 1, '3'),
(151, 3, '6', '3', '23', '2021-01-05', NULL, '0', 1, '3'),
(152, 3, '6', '3', '24', '2021-01-05', NULL, '0', 1, '3'),
(153, 3, '6', '3', '24', '2021-01-05', NULL, '0', 1, '3'),
(154, 3, '6', '3', '24', '2021-01-05', NULL, '0', 1, '3'),
(155, 3, '6', '3', '24', '2021-01-05', NULL, '0', 1, '3'),
(156, 3, '6', '3', '25', '2021-01-05', NULL, '0', 1, '3'),
(157, 3, '6', '3', '25', '2021-01-05', NULL, '0', 1, '3'),
(158, 3, '6', '3', '25', '2021-01-05', NULL, '0', 1, '3'),
(159, 3, '6', '3', '26', '2021-01-05', NULL, '0', 1, '3'),
(160, 3, '6', '3', '26', '2021-01-05', NULL, '0', 1, '3'),
(161, 3, '6', '3', '26', '2021-01-05', NULL, '0', 1, '3'),
(162, 3, '6', '3', '26', '2021-01-05', NULL, '0', 1, '3'),
(163, 3, '6', '3', '26', '2021-01-05', NULL, '0', 1, '3'),
(164, 3, '6', '3', '27', '2021-01-05', NULL, '0', 1, '3'),
(165, 3, '6', '3', '27', '2021-01-05', NULL, '0', 1, '3'),
(166, 3, '6', '3', '27', '2021-01-05', NULL, '0', 1, '3'),
(167, 3, '6', '3', '28', '2021-01-05', NULL, '0', 1, '3'),
(168, 3, '6', '3', '28', '2021-01-05', NULL, '0', 1, '3'),
(169, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(170, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(171, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(172, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(173, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(174, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(175, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(176, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(177, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(178, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(179, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(180, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(181, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(182, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(183, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(184, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(185, 3, '7', '3', '29', '2021-01-05', NULL, '0', 1, '3'),
(186, 3, '7', '3', '30', '2021-01-05', NULL, '0', 1, '3'),
(187, 3, '7', '3', '30', '2021-01-05', NULL, '0', 1, '3'),
(188, 3, '7', '3', '30', '2021-01-05', NULL, '0', 1, '3'),
(189, 3, '7', '3', '30', '2021-01-05', NULL, '0', 1, '3'),
(190, 3, '7', '3', '31', '2021-01-05', NULL, '0', 1, '3'),
(191, 3, '7', '3', '31', '2021-01-05', NULL, '0', 1, '3'),
(192, 3, '7', '3', '31', '2021-01-05', NULL, '0', 1, '3'),
(193, 3, '7', '3', '31', '2021-01-05', NULL, '0', 1, '3'),
(194, 3, '8', '3', '32', '2021-01-05', NULL, '0', 1, '3'),
(195, 3, '8', '3', '32', '2021-01-05', NULL, '0', 1, '3'),
(196, 3, '8', '3', '32', '2021-01-05', NULL, '0', 1, '3'),
(197, 3, '8', '3', '33', '2021-01-05', NULL, '0', 1, '3'),
(198, 3, '8', '3', '33', '2021-01-05', NULL, '0', 1, '3'),
(199, 3, '8', '3', '33', '2021-01-05', NULL, '0', 1, '3'),
(200, 3, '8', '3', '34', '2021-01-05', NULL, '0', 1, '3'),
(201, 3, '8', '3', '34', '2021-01-05', NULL, '0', 1, '3'),
(202, 3, '8', '3', '34', '2021-01-05', NULL, '0', 1, '3'),
(203, 3, '8', '3', '35', '2021-01-05', NULL, '0', 1, '3'),
(204, 3, '8', '3', '35', '2021-01-05', NULL, '0', 1, '3'),
(205, 3, '8', '3', '35', '2021-01-05', NULL, '0', 1, '3'),
(206, 3, '8', '3', '36', '2021-01-05', NULL, '0', 1, '3'),
(207, 3, '8', '3', '36', '2021-01-05', NULL, '0', 1, '3'),
(208, 3, '8', '3', '36', '2021-01-05', NULL, '0', 1, '3'),
(209, 3, '9', '3', '37', '2021-01-05', NULL, '0', 1, '3'),
(210, 3, '9', '3', '37', '2021-01-05', NULL, '0', 1, '3'),
(211, 3, '9', '3', '37', '2021-01-05', NULL, '0', 1, '3'),
(212, 3, '9', '3', '38', '2021-01-05', NULL, '0', 1, '3'),
(213, 3, '9', '3', '38', '2021-01-05', NULL, '0', 1, '3'),
(214, 3, '9', '3', '38', '2021-01-05', NULL, '0', 1, '3'),
(215, 3, '9', '3', '39', '2021-01-05', NULL, '0', 1, '3'),
(216, 3, '9', '3', '39', '2021-01-05', NULL, '0', 1, '3'),
(217, 3, '9', '3', '39', '2021-01-05', NULL, '0', 1, '3'),
(218, 3, '9', '3', '40', '2021-01-05', NULL, '0', 1, '3'),
(219, 3, '9', '3', '40', '2021-01-05', NULL, '0', 1, '3'),
(220, 3, '9', '3', '40', '2021-01-05', NULL, '0', 1, '3'),
(221, 3, '9', '3', '41', '2021-01-05', NULL, '0', 1, '3'),
(222, 3, '9', '3', '41', '2021-01-05', NULL, '0', 1, '3'),
(223, 3, '9', '3', '41', '2021-01-05', NULL, '0', 1, '3'),
(224, 3, '9', '3', '42', '2021-01-05', NULL, '0', 1, '3'),
(225, 3, '9', '3', '42', '2021-01-05', NULL, '0', 1, '3'),
(226, 3, '9', '3', '42', '2021-01-05', NULL, '0', 1, '3'),
(227, 3, '9', '3', '43', '2021-01-05', NULL, '0', 1, '3'),
(228, 3, '9', '3', '43', '2021-01-05', NULL, '0', 1, '3'),
(229, 3, '9', '3', '43', '2021-01-05', NULL, '0', 1, '3'),
(230, 3, '9', '3', '44', '2021-01-05', NULL, '0', 1, '3'),
(231, 3, '9', '3', '44', '2021-01-05', NULL, '0', 1, '3'),
(232, 3, '9', '3', '44', '2021-01-05', NULL, '0', 1, '3'),
(233, 3, '9', '3', '45', '2021-01-05', NULL, '0', 1, '3'),
(234, 3, '9', '3', '45', '2021-01-05', NULL, '0', 1, '3'),
(235, 3, '9', '3', '45', '2021-01-05', NULL, '0', 1, '3'),
(236, 3, '10', '3', '46', '2021-01-05', NULL, '0', 1, '3'),
(237, 3, '10', '3', '46', '2021-01-05', NULL, '0', 1, '3'),
(238, 3, '10', '3', '46', '2021-01-05', NULL, '0', 1, '3'),
(239, 3, '10', '3', '46', '2021-01-05', NULL, '0', 1, '3'),
(240, 3, '10', '3', '46', '2021-01-05', NULL, '0', 1, '3'),
(241, 3, '10', '3', '47', '2021-01-05', NULL, '0', 1, '3'),
(242, 3, '10', '3', '47', '2021-01-05', NULL, '0', 1, '3'),
(243, 3, '10', '3', '47', '2021-01-05', NULL, '0', 1, '3'),
(244, 3, '10', '3', '47', '2021-01-05', NULL, '0', 1, '3'),
(245, 3, '10', '3', '47', '2021-01-05', NULL, '0', 1, '3'),
(246, 3, '10', '3', '47', '2021-01-05', NULL, '0', 1, '3'),
(247, 3, '10', '3', '47', '2021-01-05', NULL, '0', 1, '3'),
(248, 3, '10', '3', '48', '2021-01-05', NULL, '0', 1, '3'),
(249, 3, '10', '3', '48', '2021-01-05', NULL, '0', 1, '3'),
(250, 3, '10', '3', '48', '2021-01-05', NULL, '0', 1, '3'),
(251, 3, '10', '3', '48', '2021-01-05', NULL, '0', 1, '3'),
(252, 3, '10', '3', '48', '2021-01-05', NULL, '0', 1, '3'),
(253, 3, '10', '3', '48', '2021-01-05', NULL, '0', 1, '3'),
(254, 3, '10', '3', '48', '2021-01-05', NULL, '0', 1, '3'),
(255, 3, '10', '3', '49', '2021-01-05', NULL, '0', 1, '3'),
(256, 3, '10', '3', '49', '2021-01-05', NULL, '0', 1, '3'),
(257, 3, '10', '3', '49', '2021-01-05', NULL, '0', 1, '3'),
(258, 3, '10', '3', '49', '2021-01-05', NULL, '0', 1, '3'),
(259, 3, '10', '3', '49', '2021-01-05', NULL, '0', 1, '3'),
(260, 3, '10', '3', '49', '2021-01-05', NULL, '0', 1, '3'),
(261, 3, '10', '3', '49', '2021-01-05', NULL, '0', 1, '3'),
(262, 7, '1', '4', '1', '2021-01-07', NULL, '0', 4, '4'),
(263, 7, '1', '4', '1', '2021-01-07', NULL, '0', 4, '4'),
(264, 7, '1', '4', '1', '2021-01-07', NULL, '0', 4, '4'),
(265, 7, '1', '4', '1', '2021-01-07', NULL, '0', 4, '4'),
(266, 7, '1', '4', '2', '2021-01-07', NULL, '0', 4, '4'),
(267, 7, '1', '4', '2', '2021-01-07', NULL, '0', 4, '4'),
(268, 7, '1', '4', '2', '2021-01-07', NULL, '0', 4, '4'),
(269, 7, '1', '4', '2', '2021-01-07', NULL, '0', 4, '4'),
(270, 7, '1', '4', '3', '2021-01-07', NULL, '0', 4, '4'),
(271, 7, '1', '4', '3', '2021-01-07', NULL, '0', 4, '4'),
(272, 7, '1', '4', '3', '2021-01-07', NULL, '0', 4, '4'),
(273, 7, '1', '4', '3', '2021-01-07', NULL, '0', 4, '4'),
(274, 7, '1', '4', '4', '2021-01-07', NULL, '0', 4, '4'),
(275, 7, '1', '4', '4', '2021-01-07', NULL, '0', 4, '4'),
(276, 7, '1', '4', '4', '2021-01-07', NULL, '0', 4, '4'),
(277, 7, '1', '4', '4', '2021-01-07', NULL, '0', 4, '4'),
(278, 7, '1', '4', '4', '2021-01-07', NULL, '0', 4, '4'),
(279, 7, '1', '4', '4', '2021-01-07', NULL, '0', 4, '4'),
(280, 7, '1', '4', '4', '2021-01-07', NULL, '0', 4, '4'),
(281, 7, '1', '4', '4', '2021-01-07', NULL, '0', 4, '4'),
(282, 7, '1', '4', '5', '2021-01-07', NULL, '0', 4, '4'),
(283, 7, '1', '4', '5', '2021-01-07', NULL, '0', 4, '4'),
(284, 7, '1', '4', '5', '2021-01-07', NULL, '0', 4, '4'),
(285, 7, '1', '4', '5', '2021-01-07', NULL, '0', 4, '4'),
(286, 7, '1', '4', '6', '2021-01-07', NULL, '0', 4, '4'),
(287, 7, '1', '4', '6', '2021-01-07', NULL, '0', 4, '4'),
(288, 7, '1', '4', '6', '2021-01-07', NULL, '0', 4, '4'),
(289, 7, '1', '4', '6', '2021-01-07', NULL, '0', 4, '4'),
(290, 7, '1', '4', '7', '2021-01-07', NULL, '0', 4, '4'),
(291, 7, '1', '4', '7', '2021-01-07', NULL, '0', 4, '4'),
(292, 7, '2', '4', '8', '2021-01-07', NULL, '0', 4, '4'),
(293, 7, '2', '4', '8', '2021-01-07', NULL, '0', 4, '4'),
(294, 7, '2', '4', '9', '2021-01-07', NULL, '0', 4, '4'),
(295, 7, '2', '4', '9', '2021-01-07', NULL, '0', 4, '4'),
(296, 7, '2', '4', '9', '2021-01-07', NULL, '0', 4, '4'),
(297, 7, '2', '4', '10', '2021-01-07', NULL, '0', 4, '4'),
(298, 7, '2', '4', '10', '2021-01-07', NULL, '0', 4, '4'),
(299, 7, '2', '4', '10', '2021-01-07', NULL, '0', 4, '4'),
(300, 7, '2', '4', '10', '2021-01-07', NULL, '0', 4, '4'),
(301, 7, '3', '4', '11', '2021-01-07', NULL, '0', 4, '4'),
(302, 7, '3', '4', '11', '2021-01-07', NULL, '0', 4, '4'),
(303, 7, '3', '4', '11', '2021-01-07', NULL, '0', 4, '4'),
(304, 7, '3', '4', '12', '2021-01-07', NULL, '0', 4, '4'),
(305, 7, '3', '4', '12', '2021-01-07', NULL, '0', 4, '4'),
(306, 7, '3', '4', '12', '2021-01-07', NULL, '0', 4, '4'),
(307, 7, '3', '4', '12', '2021-01-07', NULL, '0', 4, '4'),
(308, 7, '4', '4', '13', '2021-01-07', NULL, '0', 4, '4'),
(309, 7, '4', '4', '13', '2021-01-07', NULL, '0', 4, '4'),
(310, 7, '4', '4', '13', '2021-01-07', NULL, '0', 4, '4'),
(311, 7, '4', '4', '13', '2021-01-07', NULL, '0', 4, '4'),
(312, 7, '4', '4', '13', '2021-01-07', NULL, '0', 4, '4'),
(313, 7, '4', '4', '14', '2021-01-07', NULL, '0', 4, '4'),
(314, 7, '4', '4', '14', '2021-01-07', NULL, '0', 4, '4'),
(315, 7, '4', '4', '14', '2021-01-07', NULL, '0', 4, '4'),
(316, 7, '4', '4', '15', '2021-01-07', NULL, '0', 4, '4'),
(317, 7, '4', '4', '15', '2021-01-07', NULL, '0', 4, '4'),
(318, 7, '5', '4', '16', '2021-01-07', NULL, '0', 4, '4'),
(319, 7, '5', '4', '16', '2021-01-07', NULL, '0', 4, '4'),
(320, 7, '5', '4', '16', '2021-01-07', NULL, '0', 4, '4'),
(321, 7, '5', '4', '16', '2021-01-07', NULL, '0', 4, '4'),
(322, 7, '5', '4', '16', '2021-01-07', NULL, '0', 4, '4'),
(323, 7, '5', '4', '16', '2021-01-07', NULL, '0', 4, '4'),
(324, 7, '5', '4', '17', '2021-01-07', NULL, '0', 4, '4'),
(325, 7, '5', '4', '17', '2021-01-07', NULL, '0', 4, '4'),
(326, 7, '5', '4', '17', '2021-01-07', NULL, '0', 4, '4'),
(327, 7, '5', '4', '18', '2021-01-07', NULL, '0', 4, '4'),
(328, 7, '5', '4', '18', '2021-01-07', NULL, '0', 4, '4'),
(329, 7, '5', '4', '18', '2021-01-07', NULL, '0', 4, '4'),
(330, 7, '5', '4', '19', '2021-01-07', NULL, '0', 4, '4'),
(331, 7, '5', '4', '19', '2021-01-07', NULL, '0', 4, '4'),
(332, 7, '5', '4', '19', '2021-01-07', NULL, '0', 4, '4'),
(333, 7, '5', '4', '20', '2021-01-07', NULL, '0', 4, '4'),
(334, 7, '5', '4', '20', '2021-01-07', NULL, '0', 4, '4'),
(335, 7, '1', '5', '1', '2021-01-16', NULL, '0', 2, '5'),
(336, 7, '1', '5', '1', '2021-01-16', NULL, '0', 2, '5'),
(337, 7, '1', '5', '1', '2021-01-16', NULL, '0', 2, '5'),
(338, 7, '1', '5', '1', '2021-01-16', NULL, '0', 2, '5'),
(339, 7, '1', '5', '2', '2021-01-16', NULL, '0', 2, '5'),
(340, 7, '1', '5', '2', '2021-01-16', NULL, '0', 3, '5'),
(341, 7, '1', '5', '2', '2021-01-16', NULL, '0', 3, '5'),
(342, 7, '1', '5', '2', '2021-01-16', NULL, '0', 2, '5'),
(343, 7, '1', '5', '3', '2021-01-16', NULL, '0', 3, '5'),
(344, 7, '1', '5', '3', '2021-01-16', NULL, '0', 2, '5'),
(345, 7, '1', '5', '3', '2021-01-16', NULL, '0', 4, '5'),
(346, 7, '1', '5', '3', '2021-01-16', NULL, '0', 3, '5'),
(347, 7, '1', '5', '4', '2021-01-16', NULL, '0', 3, '5'),
(348, 7, '1', '5', '4', '2021-01-16', NULL, '0', 3, '5'),
(349, 7, '1', '5', '4', '2021-01-16', NULL, '0', 3, '5'),
(350, 7, '1', '5', '4', '2021-01-16', NULL, '0', 3, '5'),
(351, 7, '1', '5', '4', '2021-01-16', NULL, '0', 3, '5'),
(352, 7, '1', '5', '4', '2021-01-16', NULL, '0', 2, '5'),
(353, 7, '1', '5', '4', '2021-01-16', NULL, '0', 3, '5'),
(354, 7, '1', '5', '4', '2021-01-16', NULL, '0', 2, '5'),
(355, 7, '1', '5', '5', '2021-01-16', NULL, '0', 3, '5'),
(356, 7, '1', '5', '5', '2021-01-16', NULL, '0', 3, '5'),
(357, 7, '1', '5', '5', '2021-01-16', NULL, '0', 3, '5'),
(358, 7, '1', '5', '5', '2021-01-16', NULL, '0', 3, '5'),
(359, 7, '1', '5', '6', '2021-01-16', NULL, '0', 3, '5'),
(360, 7, '1', '5', '6', '2021-01-16', NULL, '0', 2, '5'),
(361, 7, '1', '5', '6', '2021-01-16', NULL, '0', 2, '5'),
(362, 7, '1', '5', '6', '2021-01-16', NULL, '0', 2, '5'),
(363, 7, '1', '5', '7', '2021-01-16', NULL, '0', 5, '5'),
(364, 7, '1', '5', '7', '2021-01-16', NULL, '0', 5, '5'),
(365, 7, '2', '5', '8', '2021-01-16', NULL, '0', 3, '5'),
(366, 7, '2', '5', '8', '2021-01-16', NULL, '0', 3, '5'),
(367, 7, '2', '5', '9', '2021-01-16', NULL, '0', 2, '5'),
(368, 7, '2', '5', '9', '2021-01-16', NULL, '0', 3, '5'),
(369, 7, '2', '5', '9', '2021-01-16', NULL, '0', 3, '5'),
(370, 7, '2', '5', '10', '2021-01-16', NULL, '0', 2, '5'),
(371, 7, '2', '5', '10', '2021-01-16', NULL, '0', 2, '5'),
(372, 7, '2', '5', '10', '2021-01-16', NULL, '0', 2, '5'),
(373, 7, '2', '5', '10', '2021-01-16', NULL, '0', 2, '5'),
(374, 7, '3', '5', '11', '2021-01-16', NULL, '0', 2, '5'),
(375, 7, '3', '5', '11', '2021-01-16', NULL, '0', 2, '5'),
(376, 7, '3', '5', '11', '2021-01-16', NULL, '0', 2, '5'),
(377, 7, '3', '5', '12', '2021-01-16', NULL, '0', 3, '5'),
(378, 7, '3', '5', '12', '2021-01-16', NULL, '0', 3, '5'),
(379, 7, '3', '5', '12', '2021-01-16', NULL, '0', 3, '5'),
(380, 7, '3', '5', '12', '2021-01-16', NULL, '0', 3, '5'),
(381, 7, '4', '5', '13', '2021-01-16', NULL, '0', 3, '5'),
(382, 7, '4', '5', '13', '2021-01-16', NULL, '0', 3, '5'),
(383, 7, '4', '5', '13', '2021-01-16', NULL, '0', 3, '5'),
(384, 7, '4', '5', '13', '2021-01-16', NULL, '0', 3, '5'),
(385, 7, '4', '5', '13', '2021-01-16', NULL, '0', 3, '5'),
(386, 7, '4', '5', '14', '2021-01-16', NULL, '0', 3, '5'),
(387, 7, '4', '5', '14', '2021-01-16', NULL, '0', 2, '5'),
(388, 7, '4', '5', '14', '2021-01-16', NULL, '0', 3, '5'),
(389, 7, '4', '5', '15', '2021-01-16', NULL, '0', 4, '5'),
(390, 7, '4', '5', '15', '2021-01-16', NULL, '0', 4, '5'),
(391, 7, '5', '5', '16', '2021-01-16', NULL, '0', 4, '5'),
(392, 7, '5', '5', '16', '2021-01-16', NULL, '0', 3, '5'),
(393, 7, '5', '5', '16', '2021-01-16', NULL, '0', 2, '5'),
(394, 7, '5', '5', '16', '2021-01-16', NULL, '0', 2, '5'),
(395, 7, '5', '5', '16', '2021-01-16', NULL, '0', 2, '5'),
(396, 7, '5', '5', '16', '2021-01-16', NULL, '0', 2, '5'),
(397, 7, '5', '5', '17', '2021-01-16', NULL, '0', 3, '5'),
(398, 7, '5', '5', '17', '2021-01-16', NULL, '0', 3, '5'),
(399, 7, '5', '5', '17', '2021-01-16', NULL, '0', 3, '5'),
(400, 7, '5', '5', '18', '2021-01-16', NULL, '0', 3, '5'),
(401, 7, '5', '5', '18', '2021-01-16', NULL, '0', 3, '5'),
(402, 7, '5', '5', '18', '2021-01-16', NULL, '0', 3, '5'),
(403, 7, '5', '5', '19', '2021-01-16', NULL, '0', 2, '5'),
(404, 7, '5', '5', '19', '2021-01-16', NULL, '0', 3, '5'),
(405, 7, '5', '5', '19', '2021-01-16', NULL, '0', 3, '5'),
(406, 7, '5', '5', '20', '2021-01-16', NULL, '0', 3, '5'),
(407, 7, '5', '5', '20', '2021-01-16', NULL, '0', 4, '5'),
(408, 3, '1', '6', '1', '2021-03-02', NULL, '0', 1, '6'),
(409, 3, '1', '6', '1', '2021-03-02', NULL, '0', 1, '6'),
(410, 3, '1', '6', '1', '2021-03-02', NULL, '0', 1, '6'),
(411, 3, '1', '6', '1', '2021-03-02', NULL, '0', 1, '6'),
(412, 3, '1', '6', '2', '2021-03-02', NULL, '0', 1, '6'),
(413, 3, '1', '6', '2', '2021-03-02', NULL, '0', 1, '6'),
(414, 3, '1', '6', '2', '2021-03-02', NULL, '0', 1, '6'),
(415, 3, '1', '6', '2', '2021-03-02', NULL, '0', 1, '6'),
(416, 3, '1', '6', '3', '2021-03-02', NULL, '0', 1, '6'),
(417, 3, '1', '6', '3', '2021-03-02', NULL, '0', 1, '6'),
(418, 3, '1', '6', '3', '2021-03-02', NULL, '0', 1, '6'),
(419, 3, '1', '6', '3', '2021-03-02', NULL, '0', 1, '6'),
(420, 3, '1', '6', '4', '2021-03-02', NULL, '0', 1, '6'),
(421, 3, '1', '6', '4', '2021-03-02', NULL, '0', 1, '6'),
(422, 3, '1', '6', '4', '2021-03-02', NULL, '0', 1, '6'),
(423, 3, '1', '6', '4', '2021-03-02', NULL, '0', 1, '6'),
(424, 3, '1', '6', '4', '2021-03-02', NULL, '0', 1, '6'),
(425, 3, '1', '6', '4', '2021-03-02', NULL, '0', 1, '6'),
(426, 3, '1', '6', '4', '2021-03-02', NULL, '0', 1, '6'),
(427, 3, '1', '6', '4', '2021-03-02', NULL, '0', 1, '6'),
(428, 3, '1', '6', '5', '2021-03-02', NULL, '0', 1, '6'),
(429, 3, '1', '6', '5', '2021-03-02', NULL, '0', 1, '6'),
(430, 3, '1', '6', '5', '2021-03-02', NULL, '0', 1, '6'),
(431, 3, '1', '6', '5', '2021-03-02', NULL, '0', 1, '6'),
(432, 3, '1', '6', '6', '2021-03-02', NULL, '0', 1, '6'),
(433, 3, '1', '6', '6', '2021-03-02', NULL, '0', 1, '6'),
(434, 3, '1', '6', '6', '2021-03-02', NULL, '0', 1, '6'),
(435, 3, '1', '6', '6', '2021-03-02', NULL, '0', 1, '6'),
(436, 3, '1', '6', '7', '2021-03-02', NULL, '0', 1, '6'),
(437, 3, '1', '6', '7', '2021-03-02', NULL, '0', 1, '6'),
(438, 3, '2', '6', '8', '2021-03-02', NULL, '0', 1, '6'),
(439, 3, '2', '6', '8', '2021-03-02', NULL, '0', 1, '6'),
(440, 3, '2', '6', '9', '2021-03-02', NULL, '0', 1, '6'),
(441, 3, '2', '6', '9', '2021-03-02', NULL, '0', 1, '6'),
(442, 3, '2', '6', '9', '2021-03-02', NULL, '0', 1, '6'),
(443, 3, '2', '6', '10', '2021-03-02', NULL, '0', 1, '6'),
(444, 3, '2', '6', '10', '2021-03-02', NULL, '0', 1, '6'),
(445, 3, '2', '6', '10', '2021-03-02', NULL, '0', 1, '6'),
(446, 3, '2', '6', '10', '2021-03-02', NULL, '0', 1, '6'),
(447, 3, '3', '6', '11', '2021-03-02', NULL, '0', 1, '6'),
(448, 3, '3', '6', '11', '2021-03-02', NULL, '0', 1, '6'),
(449, 3, '3', '6', '11', '2021-03-02', NULL, '0', 1, '6'),
(450, 3, '3', '6', '12', '2021-03-02', NULL, '0', 1, '6'),
(451, 3, '3', '6', '12', '2021-03-02', NULL, '0', 1, '6'),
(452, 3, '3', '6', '12', '2021-03-02', NULL, '0', 1, '6'),
(453, 3, '3', '6', '12', '2021-03-02', NULL, '0', 1, '6'),
(454, 3, '4', '6', '13', '2021-03-02', NULL, '0', 1, '6'),
(455, 3, '4', '6', '13', '2021-03-02', NULL, '0', 1, '6'),
(456, 3, '4', '6', '13', '2021-03-02', NULL, '0', 1, '6'),
(457, 3, '4', '6', '13', '2021-03-02', NULL, '0', 1, '6'),
(458, 3, '4', '6', '13', '2021-03-02', NULL, '0', 1, '6'),
(459, 3, '4', '6', '14', '2021-03-02', NULL, '0', 1, '6'),
(460, 3, '4', '6', '14', '2021-03-02', NULL, '0', 1, '6'),
(461, 3, '4', '6', '14', '2021-03-02', NULL, '0', 1, '6'),
(462, 3, '4', '6', '15', '2021-03-02', NULL, '0', 1, '6'),
(463, 3, '4', '6', '15', '2021-03-02', NULL, '0', 1, '6'),
(464, 3, '5', '6', '16', '2021-03-02', NULL, '0', 1, '6'),
(465, 3, '5', '6', '16', '2021-03-02', NULL, '0', 1, '6'),
(466, 3, '5', '6', '16', '2021-03-02', NULL, '0', 1, '6'),
(467, 3, '5', '6', '16', '2021-03-02', NULL, '0', 1, '6'),
(468, 3, '5', '6', '16', '2021-03-02', NULL, '0', 1, '6'),
(469, 3, '5', '6', '16', '2021-03-02', NULL, '0', 1, '6'),
(470, 3, '5', '6', '17', '2021-03-02', NULL, '0', 1, '6'),
(471, 3, '5', '6', '17', '2021-03-02', NULL, '0', 1, '6'),
(472, 3, '5', '6', '17', '2021-03-02', NULL, '0', 1, '6'),
(473, 3, '5', '6', '18', '2021-03-02', NULL, '0', 1, '6'),
(474, 3, '5', '6', '18', '2021-03-02', NULL, '0', 1, '6'),
(475, 3, '5', '6', '18', '2021-03-02', NULL, '0', 1, '6'),
(476, 3, '5', '6', '19', '2021-03-02', NULL, '0', 1, '6'),
(477, 3, '5', '6', '19', '2021-03-02', NULL, '0', 1, '6'),
(478, 3, '5', '6', '19', '2021-03-02', NULL, '0', 1, '6'),
(479, 3, '5', '6', '20', '2021-03-02', NULL, '0', 1, '6'),
(480, 3, '5', '6', '20', '2021-03-02', NULL, '0', 1, '6'),
(481, 3, '1', '1', '1', '2021-03-11', NULL, '0', 1, '1'),
(482, 3, '1', '1', '1', '2021-03-11', NULL, '0', 1, '1'),
(483, 3, '1', '1', '1', '2021-03-11', NULL, '0', 1, '1'),
(484, 3, '1', '1', '1', '2021-03-11', NULL, '0', 1, '1'),
(485, 3, '1', '1', '2', '2021-03-11', NULL, '0', 1, '1'),
(486, 3, '1', '1', '2', '2021-03-11', NULL, '0', 1, '1'),
(487, 3, '1', '1', '2', '2021-03-11', NULL, '0', 1, '1'),
(488, 3, '1', '1', '2', '2021-03-11', NULL, '0', 1, '1'),
(489, 3, '1', '1', '3', '2021-03-11', NULL, '0', 1, '1'),
(490, 3, '1', '1', '3', '2021-03-11', NULL, '0', 1, '1'),
(491, 3, '1', '1', '3', '2021-03-11', NULL, '0', 1, '1'),
(492, 3, '1', '1', '3', '2021-03-11', NULL, '0', 1, '1'),
(493, 3, '1', '1', '4', '2021-03-11', NULL, '0', 1, '1'),
(494, 3, '1', '1', '4', '2021-03-11', NULL, '0', 1, '1'),
(495, 3, '1', '1', '4', '2021-03-11', NULL, '0', 1, '1'),
(496, 3, '1', '1', '4', '2021-03-11', NULL, '0', 1, '1'),
(497, 3, '1', '1', '4', '2021-03-11', NULL, '0', 1, '1'),
(498, 3, '1', '1', '4', '2021-03-11', NULL, '0', 1, '1'),
(499, 3, '1', '1', '4', '2021-03-11', NULL, '0', 1, '1'),
(500, 3, '1', '1', '4', '2021-03-11', NULL, '0', 1, '1'),
(501, 3, '1', '1', '5', '2021-03-11', NULL, '0', 1, '1'),
(502, 3, '1', '1', '5', '2021-03-11', NULL, '0', 1, '1'),
(503, 3, '1', '1', '5', '2021-03-11', NULL, '0', 1, '1'),
(504, 3, '1', '1', '5', '2021-03-11', NULL, '0', 1, '1'),
(505, 3, '1', '1', '6', '2021-03-11', NULL, '0', 1, '1'),
(506, 3, '1', '1', '6', '2021-03-11', NULL, '0', 1, '1'),
(507, 3, '1', '1', '6', '2021-03-11', NULL, '0', 1, '1'),
(508, 3, '1', '1', '6', '2021-03-11', NULL, '0', 1, '1'),
(509, 3, '1', '1', '7', '2021-03-11', NULL, '0', 1, '1'),
(510, 3, '1', '1', '7', '2021-03-11', NULL, '0', 1, '1'),
(511, 3, '2', '1', '8', '2021-03-11', NULL, '0', 1, '1'),
(512, 3, '2', '1', '8', '2021-03-11', NULL, '0', 1, '1'),
(513, 3, '2', '1', '9', '2021-03-11', NULL, '0', 1, '1'),
(514, 3, '2', '1', '9', '2021-03-11', NULL, '0', 1, '1'),
(515, 3, '2', '1', '9', '2021-03-11', NULL, '0', 1, '1'),
(516, 3, '2', '1', '10', '2021-03-11', NULL, '0', 1, '1'),
(517, 3, '2', '1', '10', '2021-03-11', NULL, '0', 1, '1'),
(518, 3, '2', '1', '10', '2021-03-11', NULL, '0', 1, '1'),
(519, 3, '2', '1', '10', '2021-03-11', NULL, '0', 1, '1'),
(520, 3, '3', '1', '11', '2021-03-11', NULL, '0', 1, '1'),
(521, 3, '3', '1', '11', '2021-03-11', NULL, '0', 1, '1'),
(522, 3, '3', '1', '11', '2021-03-11', NULL, '0', 1, '1'),
(523, 3, '3', '1', '12', '2021-03-11', NULL, '0', 1, '1'),
(524, 3, '3', '1', '12', '2021-03-11', NULL, '0', 1, '1'),
(525, 3, '3', '1', '12', '2021-03-11', NULL, '0', 1, '1'),
(526, 3, '3', '1', '12', '2021-03-11', NULL, '0', 1, '1'),
(527, 3, '4', '1', '13', '2021-03-11', NULL, '0', 1, '1'),
(528, 3, '4', '1', '13', '2021-03-11', NULL, '0', 1, '1'),
(529, 3, '4', '1', '13', '2021-03-11', NULL, '0', 1, '1'),
(530, 3, '4', '1', '13', '2021-03-11', NULL, '0', 1, '1'),
(531, 3, '4', '1', '13', '2021-03-11', NULL, '0', 1, '1'),
(532, 3, '4', '1', '14', '2021-03-11', NULL, '0', 1, '1'),
(533, 3, '4', '1', '14', '2021-03-11', NULL, '0', 1, '1'),
(534, 3, '4', '1', '14', '2021-03-11', NULL, '0', 1, '1'),
(535, 3, '4', '1', '15', '2021-03-11', NULL, '0', 1, '1'),
(536, 3, '4', '1', '15', '2021-03-11', NULL, '0', 1, '1'),
(537, 3, '5', '1', '16', '2021-03-11', NULL, '0', 1, '1'),
(538, 3, '5', '1', '16', '2021-03-11', NULL, '0', 1, '1'),
(539, 3, '5', '1', '16', '2021-03-11', NULL, '0', 1, '1'),
(540, 3, '5', '1', '16', '2021-03-11', NULL, '0', 1, '1'),
(541, 3, '5', '1', '16', '2021-03-11', NULL, '0', 1, '1'),
(542, 3, '5', '1', '16', '2021-03-11', NULL, '0', 1, '1'),
(543, 3, '5', '1', '17', '2021-03-11', NULL, '0', 1, '1'),
(544, 3, '5', '1', '17', '2021-03-11', NULL, '0', 1, '1'),
(545, 3, '5', '1', '17', '2021-03-11', NULL, '0', 1, '1'),
(546, 3, '5', '1', '18', '2021-03-11', NULL, '0', 1, '1'),
(547, 3, '5', '1', '18', '2021-03-11', NULL, '0', 1, '1'),
(548, 3, '5', '1', '18', '2021-03-11', NULL, '0', 1, '1'),
(549, 3, '5', '1', '19', '2021-03-11', NULL, '0', 1, '1'),
(550, 3, '5', '1', '19', '2021-03-11', NULL, '0', 1, '1'),
(551, 3, '5', '1', '19', '2021-03-11', NULL, '0', 1, '1'),
(552, 3, '5', '1', '20', '2021-03-11', NULL, '0', 1, '1'),
(553, 3, '5', '1', '20', '2021-03-11', NULL, '0', 1, '1'),
(554, 3, '1', '2', '1', '2021-03-11', NULL, '0', 4, '2'),
(555, 3, '1', '2', '1', '2021-03-11', NULL, '0', 4, '2'),
(556, 3, '1', '2', '1', '2021-03-11', NULL, '0', 3, '2'),
(557, 3, '1', '2', '1', '2021-03-11', NULL, '0', 3, '2'),
(558, 3, '1', '2', '2', '2021-03-11', NULL, '0', 5, '2'),
(559, 3, '1', '2', '2', '2021-03-11', NULL, '0', 4, '2'),
(560, 3, '1', '2', '2', '2021-03-11', NULL, '0', 3, '2'),
(561, 3, '1', '2', '2', '2021-03-11', NULL, '0', 4, '2'),
(562, 3, '1', '2', '3', '2021-03-11', NULL, '0', 2, '2'),
(563, 3, '1', '2', '3', '2021-03-11', NULL, '0', 4, '2'),
(564, 3, '1', '2', '3', '2021-03-11', NULL, '0', 4, '2'),
(565, 3, '1', '2', '3', '2021-03-11', NULL, '0', 3, '2'),
(566, 3, '1', '2', '4', '2021-03-11', NULL, '0', 3, '2'),
(567, 3, '1', '2', '4', '2021-03-11', NULL, '0', 3, '2'),
(568, 3, '1', '2', '4', '2021-03-11', NULL, '0', 4, '2'),
(569, 3, '1', '2', '4', '2021-03-11', NULL, '0', 2, '2'),
(570, 3, '1', '2', '4', '2021-03-11', NULL, '0', 2, '2'),
(571, 3, '1', '2', '4', '2021-03-11', NULL, '0', 5, '2'),
(572, 3, '1', '2', '4', '2021-03-11', NULL, '0', 5, '2'),
(573, 3, '1', '2', '4', '2021-03-11', NULL, '0', 4, '2'),
(574, 3, '1', '2', '5', '2021-03-11', NULL, '0', 4, '2'),
(575, 3, '1', '2', '5', '2021-03-11', NULL, '0', 4, '2'),
(576, 3, '1', '2', '5', '2021-03-11', NULL, '0', 4, '2'),
(577, 3, '1', '2', '5', '2021-03-11', NULL, '0', 3, '2'),
(578, 3, '1', '2', '6', '2021-03-11', NULL, '0', 5, '2'),
(579, 3, '1', '2', '6', '2021-03-11', NULL, '0', 5, '2'),
(580, 3, '1', '2', '6', '2021-03-11', NULL, '0', 5, '2'),
(581, 3, '1', '2', '6', '2021-03-11', NULL, '0', 5, '2'),
(582, 3, '1', '2', '7', '2021-03-11', NULL, '0', 4, '2'),
(583, 3, '1', '2', '7', '2021-03-11', NULL, '0', 4, '2'),
(584, 3, '2', '2', '8', '2021-03-11', NULL, '0', 5, '2'),
(585, 3, '2', '2', '8', '2021-03-11', NULL, '0', 4, '2'),
(586, 3, '2', '2', '9', '2021-03-11', NULL, '0', 3, '2'),
(587, 3, '2', '2', '9', '2021-03-11', NULL, '0', 3, '2'),
(588, 3, '2', '2', '9', '2021-03-11', NULL, '0', 3, '2'),
(589, 3, '2', '2', '10', '2021-03-11', NULL, '0', 4, '2'),
(590, 3, '2', '2', '10', '2021-03-11', NULL, '0', 4, '2'),
(591, 3, '2', '2', '10', '2021-03-11', NULL, '0', 3, '2'),
(592, 3, '2', '2', '10', '2021-03-11', NULL, '0', 4, '2'),
(593, 3, '3', '2', '11', '2021-03-11', NULL, '0', 5, '2'),
(594, 3, '3', '2', '11', '2021-03-11', NULL, '0', 5, '2'),
(595, 3, '3', '2', '11', '2021-03-11', NULL, '0', 3, '2'),
(596, 3, '3', '2', '12', '2021-03-11', NULL, '0', 3, '2'),
(597, 3, '3', '2', '12', '2021-03-11', NULL, '0', 4, '2'),
(598, 3, '3', '2', '12', '2021-03-11', NULL, '0', 2, '2'),
(599, 3, '3', '2', '12', '2021-03-11', NULL, '0', 1, '2'),
(600, 3, '4', '2', '13', '2021-03-11', NULL, '0', 2, '2'),
(601, 3, '4', '2', '13', '2021-03-11', NULL, '0', 2, '2'),
(602, 3, '4', '2', '13', '2021-03-11', NULL, '0', 1, '2'),
(603, 3, '4', '2', '13', '2021-03-11', NULL, '0', 1, '2'),
(604, 3, '4', '2', '13', '2021-03-11', NULL, '0', 1, '2'),
(605, 3, '4', '2', '14', '2021-03-11', NULL, '0', 1, '2'),
(606, 3, '4', '2', '14', '2021-03-11', NULL, '0', 1, '2'),
(607, 3, '4', '2', '14', '2021-03-11', NULL, '0', 1, '2'),
(608, 3, '4', '2', '15', '2021-03-11', NULL, '0', 2, '2'),
(609, 3, '4', '2', '15', '2021-03-11', NULL, '0', 2, '2'),
(610, 3, '5', '2', '16', '2021-03-11', NULL, '0', 5, '2'),
(611, 3, '5', '2', '16', '2021-03-11', NULL, '0', 5, '2'),
(612, 3, '5', '2', '16', '2021-03-11', NULL, '0', 5, '2'),
(613, 3, '5', '2', '16', '2021-03-11', NULL, '0', 5, '2'),
(614, 3, '5', '2', '16', '2021-03-11', NULL, '0', 5, '2'),
(615, 3, '5', '2', '16', '2021-03-11', NULL, '0', 5, '2'),
(616, 3, '5', '2', '17', '2021-03-11', NULL, '0', 4, '2'),
(617, 3, '5', '2', '17', '2021-03-11', NULL, '0', 4, '2'),
(618, 3, '5', '2', '17', '2021-03-11', NULL, '0', 5, '2'),
(619, 3, '5', '2', '18', '2021-03-11', NULL, '0', 5, '2'),
(620, 3, '5', '2', '18', '2021-03-11', NULL, '0', 5, '2'),
(621, 3, '5', '2', '18', '2021-03-11', NULL, '0', 5, '2'),
(622, 3, '5', '2', '19', '2021-03-11', NULL, '0', 4, '2'),
(623, 3, '5', '2', '19', '2021-03-11', NULL, '0', 4, '2'),
(624, 3, '5', '2', '19', '2021-03-11', NULL, '0', 4, '2'),
(625, 3, '5', '2', '20', '2021-03-11', NULL, '0', 4, '2'),
(626, 3, '5', '2', '20', '2021-03-11', NULL, '0', 5, '2'),
(627, 3, '1', '3', '1', '2021-03-27', NULL, '0', 1, '3'),
(628, 3, '1', '3', '1', '2021-03-27', NULL, '0', 1, '3'),
(629, 3, '1', '3', '1', '2021-03-27', NULL, '0', 1, '3'),
(630, 3, '1', '3', '1', '2021-03-27', NULL, '0', 1, '3'),
(631, 3, '1', '3', '2', '2021-03-27', NULL, '0', 1, '3'),
(632, 3, '1', '3', '2', '2021-03-27', NULL, '0', 1, '3'),
(633, 3, '1', '3', '2', '2021-03-27', NULL, '0', 1, '3'),
(634, 3, '1', '3', '2', '2021-03-27', NULL, '0', 1, '3'),
(635, 3, '1', '3', '3', '2021-03-27', NULL, '0', 1, '3'),
(636, 3, '1', '3', '3', '2021-03-27', NULL, '0', 1, '3'),
(637, 3, '1', '3', '3', '2021-03-27', NULL, '0', 1, '3'),
(638, 3, '1', '3', '3', '2021-03-27', NULL, '0', 1, '3'),
(639, 3, '1', '3', '4', '2021-03-27', NULL, '0', 1, '3'),
(640, 3, '1', '3', '4', '2021-03-27', NULL, '0', 1, '3'),
(641, 3, '1', '3', '4', '2021-03-27', NULL, '0', 1, '3'),
(642, 3, '1', '3', '4', '2021-03-27', NULL, '0', 1, '3'),
(643, 3, '1', '3', '4', '2021-03-27', NULL, '0', 1, '3'),
(644, 3, '1', '3', '4', '2021-03-27', NULL, '0', 1, '3'),
(645, 3, '1', '3', '4', '2021-03-27', NULL, '0', 1, '3'),
(646, 3, '1', '3', '4', '2021-03-27', NULL, '0', 1, '3'),
(647, 3, '1', '3', '5', '2021-03-27', NULL, '0', 1, '3'),
(648, 3, '1', '3', '5', '2021-03-27', NULL, '0', 1, '3'),
(649, 3, '1', '3', '5', '2021-03-27', NULL, '0', 1, '3'),
(650, 3, '1', '3', '5', '2021-03-27', NULL, '0', 1, '3'),
(651, 3, '1', '3', '6', '2021-03-27', NULL, '0', 1, '3'),
(652, 3, '1', '3', '6', '2021-03-27', NULL, '0', 1, '3'),
(653, 3, '1', '3', '6', '2021-03-27', NULL, '0', 1, '3'),
(654, 3, '1', '3', '6', '2021-03-27', NULL, '0', 1, '3'),
(655, 3, '1', '3', '7', '2021-03-27', NULL, '0', 1, '3'),
(656, 3, '1', '3', '7', '2021-03-27', NULL, '0', 1, '3'),
(657, 3, '2', '3', '8', '2021-03-27', NULL, '0', 1, '3'),
(658, 3, '2', '3', '8', '2021-03-27', NULL, '0', 1, '3'),
(659, 3, '2', '3', '9', '2021-03-27', NULL, '0', 1, '3'),
(660, 3, '2', '3', '9', '2021-03-27', NULL, '0', 1, '3'),
(661, 3, '2', '3', '9', '2021-03-27', NULL, '0', 1, '3'),
(662, 3, '2', '3', '10', '2021-03-27', NULL, '0', 1, '3'),
(663, 3, '2', '3', '10', '2021-03-27', NULL, '0', 1, '3'),
(664, 3, '2', '3', '10', '2021-03-27', NULL, '0', 1, '3'),
(665, 3, '2', '3', '10', '2021-03-27', NULL, '0', 1, '3'),
(666, 3, '3', '3', '11', '2021-03-27', NULL, '0', 1, '3'),
(667, 3, '3', '3', '11', '2021-03-27', NULL, '0', 1, '3'),
(668, 3, '3', '3', '11', '2021-03-27', NULL, '0', 1, '3'),
(669, 3, '3', '3', '12', '2021-03-27', NULL, '0', 1, '3'),
(670, 3, '3', '3', '12', '2021-03-27', NULL, '0', 1, '3'),
(671, 3, '3', '3', '12', '2021-03-27', NULL, '0', 1, '3'),
(672, 3, '3', '3', '12', '2021-03-27', NULL, '0', 1, '3'),
(673, 3, '4', '3', '13', '2021-03-27', NULL, '0', 1, '3'),
(674, 3, '4', '3', '13', '2021-03-27', NULL, '0', 1, '3'),
(675, 3, '4', '3', '13', '2021-03-27', NULL, '0', 1, '3'),
(676, 3, '4', '3', '13', '2021-03-27', NULL, '0', 1, '3'),
(677, 3, '4', '3', '13', '2021-03-27', NULL, '0', 1, '3'),
(678, 3, '4', '3', '14', '2021-03-27', NULL, '0', 1, '3'),
(679, 3, '4', '3', '14', '2021-03-27', NULL, '0', 1, '3'),
(680, 3, '4', '3', '14', '2021-03-27', NULL, '0', 1, '3'),
(681, 3, '4', '3', '15', '2021-03-27', NULL, '0', 1, '3'),
(682, 3, '4', '3', '15', '2021-03-27', NULL, '0', 1, '3'),
(683, 3, '5', '3', '16', '2021-03-27', NULL, '0', 1, '3'),
(684, 3, '5', '3', '16', '2021-03-27', NULL, '0', 1, '3'),
(685, 3, '5', '3', '16', '2021-03-27', NULL, '0', 1, '3'),
(686, 3, '5', '3', '16', '2021-03-27', NULL, '0', 1, '3'),
(687, 3, '5', '3', '16', '2021-03-27', NULL, '0', 1, '3'),
(688, 3, '5', '3', '16', '2021-03-27', NULL, '0', 1, '3'),
(689, 3, '5', '3', '17', '2021-03-27', NULL, '0', 1, '3'),
(690, 3, '5', '3', '17', '2021-03-27', NULL, '0', 1, '3'),
(691, 3, '5', '3', '17', '2021-03-27', NULL, '0', 1, '3'),
(692, 3, '5', '3', '18', '2021-03-27', NULL, '0', 1, '3'),
(693, 3, '5', '3', '18', '2021-03-27', NULL, '0', 1, '3'),
(694, 3, '5', '3', '18', '2021-03-27', NULL, '0', 1, '3'),
(695, 3, '5', '3', '19', '2021-03-27', NULL, '0', 1, '3'),
(696, 3, '5', '3', '19', '2021-03-27', NULL, '0', 1, '3'),
(697, 3, '5', '3', '19', '2021-03-27', NULL, '0', 1, '3'),
(698, 3, '5', '3', '20', '2021-03-27', NULL, '0', 1, '3'),
(699, 3, '5', '3', '20', '2021-03-27', NULL, '0', 1, '3'),
(700, 11, '1', '4', '1', '2021-04-01', NULL, '0', 2, '4'),
(701, 11, '1', '4', '1', '2021-04-01', NULL, '0', 3, '4'),
(702, 11, '1', '4', '1', '2021-04-01', NULL, '0', 4, '4'),
(703, 11, '1', '4', '1', '2021-04-01', NULL, '0', 2, '4'),
(704, 11, '1', '4', '2', '2021-04-01', NULL, '0', 4, '4'),
(705, 11, '1', '4', '2', '2021-04-01', NULL, '0', 1, '4'),
(706, 11, '1', '4', '2', '2021-04-01', NULL, '0', 1, '4'),
(707, 11, '1', '4', '2', '2021-04-01', NULL, '0', 1, '4'),
(708, 11, '1', '4', '3', '2021-04-01', NULL, '0', 1, '4'),
(709, 11, '1', '4', '3', '2021-04-01', NULL, '0', 1, '4'),
(710, 11, '1', '4', '3', '2021-04-01', NULL, '0', 1, '4'),
(711, 11, '1', '4', '3', '2021-04-01', NULL, '0', 1, '4'),
(712, 11, '1', '4', '4', '2021-04-01', NULL, '0', 1, '4'),
(713, 11, '1', '4', '4', '2021-04-01', NULL, '0', 1, '4'),
(714, 11, '1', '4', '4', '2021-04-01', NULL, '0', 1, '4'),
(715, 11, '1', '4', '4', '2021-04-01', NULL, '0', 1, '4'),
(716, 11, '1', '4', '4', '2021-04-01', NULL, '0', 1, '4'),
(717, 11, '1', '4', '4', '2021-04-01', NULL, '0', 1, '4'),
(718, 11, '1', '4', '4', '2021-04-01', NULL, '0', 1, '4'),
(719, 11, '1', '4', '4', '2021-04-01', NULL, '0', 1, '4'),
(720, 11, '1', '4', '5', '2021-04-01', NULL, '0', 1, '4'),
(721, 11, '1', '4', '5', '2021-04-01', NULL, '0', 1, '4'),
(722, 11, '1', '4', '5', '2021-04-01', NULL, '0', 1, '4'),
(723, 11, '1', '4', '5', '2021-04-01', NULL, '0', 1, '4'),
(724, 11, '1', '4', '6', '2021-04-01', NULL, '0', 1, '4'),
(725, 11, '1', '4', '6', '2021-04-01', NULL, '0', 1, '4'),
(726, 11, '1', '4', '6', '2021-04-01', NULL, '0', 1, '4'),
(727, 11, '1', '4', '6', '2021-04-01', NULL, '0', 1, '4'),
(728, 11, '1', '4', '7', '2021-04-01', NULL, '0', 1, '4'),
(729, 11, '1', '4', '7', '2021-04-01', NULL, '0', 1, '4'),
(730, 11, '2', '4', '8', '2021-04-01', NULL, '0', 1, '4'),
(731, 11, '2', '4', '8', '2021-04-01', NULL, '0', 1, '4'),
(732, 11, '2', '4', '9', '2021-04-01', NULL, '0', 1, '4'),
(733, 11, '2', '4', '9', '2021-04-01', NULL, '0', 1, '4'),
(734, 11, '2', '4', '9', '2021-04-01', NULL, '0', 1, '4'),
(735, 11, '2', '4', '10', '2021-04-01', NULL, '0', 1, '4'),
(736, 11, '2', '4', '10', '2021-04-01', NULL, '0', 1, '4'),
(737, 11, '2', '4', '10', '2021-04-01', NULL, '0', 1, '4'),
(738, 11, '2', '4', '10', '2021-04-01', NULL, '0', 1, '4'),
(739, 11, '3', '4', '11', '2021-04-01', NULL, '0', 1, '4'),
(740, 11, '3', '4', '11', '2021-04-01', NULL, '0', 1, '4'),
(741, 11, '3', '4', '11', '2021-04-01', NULL, '0', 1, '4'),
(742, 11, '3', '4', '12', '2021-04-01', NULL, '0', 1, '4'),
(743, 11, '3', '4', '12', '2021-04-01', NULL, '0', 1, '4'),
(744, 11, '3', '4', '12', '2021-04-01', NULL, '0', 1, '4'),
(745, 11, '3', '4', '12', '2021-04-01', NULL, '0', 1, '4'),
(746, 11, '4', '4', '13', '2021-04-01', NULL, '0', 1, '4'),
(747, 11, '4', '4', '13', '2021-04-01', NULL, '0', 1, '4'),
(748, 11, '4', '4', '13', '2021-04-01', NULL, '0', 1, '4'),
(749, 11, '4', '4', '13', '2021-04-01', NULL, '0', 1, '4'),
(750, 11, '4', '4', '13', '2021-04-01', NULL, '0', 1, '4'),
(751, 11, '4', '4', '14', '2021-04-01', NULL, '0', 1, '4'),
(752, 11, '4', '4', '14', '2021-04-01', NULL, '0', 1, '4'),
(753, 11, '4', '4', '14', '2021-04-01', NULL, '0', 1, '4'),
(754, 11, '4', '4', '15', '2021-04-01', NULL, '0', 1, '4'),
(755, 11, '4', '4', '15', '2021-04-01', NULL, '0', 1, '4'),
(756, 11, '5', '4', '16', '2021-04-01', NULL, '0', 1, '4'),
(757, 11, '5', '4', '16', '2021-04-01', NULL, '0', 1, '4'),
(758, 11, '5', '4', '16', '2021-04-01', NULL, '0', 1, '4'),
(759, 11, '5', '4', '16', '2021-04-01', NULL, '0', 1, '4'),
(760, 11, '5', '4', '16', '2021-04-01', NULL, '0', 1, '4'),
(761, 11, '5', '4', '16', '2021-04-01', NULL, '0', 1, '4'),
(762, 11, '5', '4', '17', '2021-04-01', NULL, '0', 1, '4'),
(763, 11, '5', '4', '17', '2021-04-01', NULL, '0', 1, '4'),
(764, 11, '5', '4', '17', '2021-04-01', NULL, '0', 1, '4'),
(765, 11, '5', '4', '18', '2021-04-01', NULL, '0', 1, '4'),
(766, 11, '5', '4', '18', '2021-04-01', NULL, '0', 1, '4'),
(767, 11, '5', '4', '18', '2021-04-01', NULL, '0', 1, '4'),
(768, 11, '5', '4', '19', '2021-04-01', NULL, '0', 1, '4'),
(769, 11, '5', '4', '19', '2021-04-01', NULL, '0', 1, '4'),
(770, 11, '5', '4', '19', '2021-04-01', NULL, '0', 1, '4'),
(771, 11, '5', '4', '20', '2021-04-01', NULL, '0', 1, '4'),
(772, 11, '5', '4', '20', '2021-04-01', NULL, '0', 1, '4'),
(773, 13, '1', '5', '1', '2022-01-21', NULL, '0', 5, '5'),
(774, 13, '1', '5', '1', '2022-01-21', NULL, '0', 4, '5'),
(775, 13, '1', '5', '1', '2022-01-21', NULL, '0', 4, '5'),
(776, 13, '1', '5', '1', '2022-01-21', NULL, '0', 4, '5'),
(777, 13, '1', '5', '2', '2022-01-21', NULL, '0', 4, '5'),
(778, 13, '1', '5', '2', '2022-01-21', NULL, '0', 5, '5'),
(779, 13, '1', '5', '2', '2022-01-21', NULL, '0', 5, '5'),
(780, 13, '1', '5', '2', '2022-01-21', NULL, '0', 3, '5'),
(781, 13, '1', '5', '3', '2022-01-21', NULL, '0', 3, '5'),
(782, 13, '1', '5', '3', '2022-01-21', NULL, '0', 3, '5'),
(783, 13, '1', '5', '3', '2022-01-21', NULL, '0', 4, '5'),
(784, 13, '1', '5', '3', '2022-01-21', NULL, '0', 5, '5'),
(785, 13, '1', '5', '4', '2022-01-21', NULL, '0', 4, '5'),
(786, 13, '1', '5', '4', '2022-01-21', NULL, '0', 3, '5'),
(787, 13, '1', '5', '4', '2022-01-21', NULL, '0', 3, '5'),
(788, 13, '1', '5', '4', '2022-01-21', NULL, '0', 3, '5'),
(789, 13, '1', '5', '4', '2022-01-21', NULL, '0', 4, '5'),
(790, 13, '1', '5', '4', '2022-01-21', NULL, '0', 5, '5'),
(791, 13, '1', '5', '4', '2022-01-21', NULL, '0', 3, '5'),
(792, 13, '1', '5', '4', '2022-01-21', NULL, '0', 4, '5'),
(793, 13, '1', '5', '5', '2022-01-21', NULL, '0', 3, '5'),
(794, 13, '1', '5', '5', '2022-01-21', NULL, '0', 4, '5'),
(795, 13, '1', '5', '5', '2022-01-21', NULL, '0', 4, '5'),
(796, 13, '1', '5', '5', '2022-01-21', NULL, '0', 5, '5'),
(797, 13, '1', '5', '6', '2022-01-21', NULL, '0', 3, '5'),
(798, 13, '1', '5', '6', '2022-01-21', NULL, '0', 5, '5'),
(799, 13, '1', '5', '6', '2022-01-21', NULL, '0', 2, '5'),
(800, 13, '1', '5', '6', '2022-01-21', NULL, '0', 3, '5'),
(801, 13, '1', '5', '7', '2022-01-21', NULL, '0', 3, '5'),
(802, 13, '1', '5', '7', '2022-01-21', NULL, '0', 4, '5'),
(803, 13, '2', '5', '8', '2022-01-21', NULL, '0', 3, '5'),
(804, 13, '2', '5', '8', '2022-01-21', NULL, '0', 3, '5'),
(805, 13, '2', '5', '9', '2022-01-21', NULL, '0', 3, '5'),
(806, 13, '2', '5', '9', '2022-01-21', NULL, '0', 4, '5'),
(807, 13, '2', '5', '9', '2022-01-21', NULL, '0', 3, '5'),
(808, 13, '2', '5', '10', '2022-01-21', NULL, '0', 2, '5'),
(809, 13, '2', '5', '10', '2022-01-21', NULL, '0', 4, '5'),
(810, 13, '2', '5', '10', '2022-01-21', NULL, '0', 4, '5'),
(811, 13, '2', '5', '10', '2022-01-21', NULL, '0', 3, '5'),
(812, 13, '3', '5', '11', '2022-01-21', NULL, '0', 4, '5'),
(813, 13, '3', '5', '11', '2022-01-21', NULL, '0', 2, '5'),
(814, 13, '3', '5', '11', '2022-01-21', NULL, '0', 4, '5'),
(815, 13, '3', '5', '12', '2022-01-21', NULL, '0', 3, '5'),
(816, 13, '3', '5', '12', '2022-01-21', NULL, '0', 4, '5'),
(817, 13, '3', '5', '12', '2022-01-21', NULL, '0', 2, '5'),
(818, 13, '3', '5', '12', '2022-01-21', NULL, '0', 3, '5'),
(819, 13, '4', '5', '13', '2022-01-21', NULL, '0', 4, '5'),
(820, 13, '4', '5', '13', '2022-01-21', NULL, '0', 4, '5'),
(821, 13, '4', '5', '13', '2022-01-21', NULL, '0', 4, '5'),
(822, 13, '4', '5', '13', '2022-01-21', NULL, '0', 3, '5'),
(823, 13, '4', '5', '13', '2022-01-21', NULL, '0', 2, '5'),
(824, 13, '4', '5', '14', '2022-01-21', NULL, '0', 3, '5'),
(825, 13, '4', '5', '14', '2022-01-21', NULL, '0', 3, '5'),
(826, 13, '4', '5', '14', '2022-01-21', NULL, '0', 4, '5'),
(827, 13, '4', '5', '15', '2022-01-21', NULL, '0', 3, '5'),
(828, 13, '4', '5', '15', '2022-01-21', NULL, '0', 3, '5'),
(829, 13, '5', '5', '16', '2022-01-21', NULL, '0', 4, '5'),
(830, 13, '5', '5', '16', '2022-01-21', NULL, '0', 3, '5'),
(831, 13, '5', '5', '16', '2022-01-21', NULL, '0', 2, '5'),
(832, 13, '5', '5', '16', '2022-01-21', NULL, '0', 4, '5'),
(833, 13, '5', '5', '16', '2022-01-21', NULL, '0', 3, '5'),
(834, 13, '5', '5', '16', '2022-01-21', NULL, '0', 3, '5'),
(835, 13, '5', '5', '17', '2022-01-21', NULL, '0', 3, '5'),
(836, 13, '5', '5', '17', '2022-01-21', NULL, '0', 3, '5'),
(837, 13, '5', '5', '17', '2022-01-21', NULL, '0', 3, '5'),
(838, 13, '5', '5', '18', '2022-01-21', NULL, '0', 3, '5'),
(839, 13, '5', '5', '18', '2022-01-21', NULL, '0', 3, '5'),
(840, 13, '5', '5', '18', '2022-01-21', NULL, '0', 3, '5'),
(841, 13, '5', '5', '19', '2022-01-21', NULL, '0', 3, '5'),
(842, 13, '5', '5', '19', '2022-01-21', NULL, '0', 3, '5'),
(843, 13, '5', '5', '19', '2022-01-21', NULL, '0', 4, '5'),
(844, 13, '5', '5', '20', '2022-01-21', NULL, '0', 3, '5'),
(845, 13, '5', '5', '20', '2022-01-21', NULL, '0', 3, '5');

-- --------------------------------------------------------

--
-- Table structure for table `sys_topics`
--

CREATE TABLE `sys_topics` (
  `id` int(10) NOT NULL,
  `userid` int(10) NOT NULL,
  `account` varchar(200) DEFAULT NULL,
  `cn` varchar(100) DEFAULT '',
  `invoicenum` text DEFAULT NULL,
  `total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `status` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `r` varchar(100) NOT NULL DEFAULT '0',
  `source` varchar(200) DEFAULT NULL,
  `allowed_payment_methods` text DEFAULT NULL,
  `billing_state` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_topics`
--

INSERT INTO `sys_topics` (`id`, `userid`, `account`, `cn`, `invoicenum`, `total`, `status`, `notes`, `r`, `source`, `allowed_payment_methods`, `billing_state`) VALUES
(1, 1, 'QI INDIVIDUAL COMPETENCY', '', NULL, '0.00', 'Active', 'https://portal.systemsevaluation.co.ke/qi-individual-assessment.pdf', '0', NULL, NULL, NULL),
(2, 1, 'QMS CAPACITY', '', NULL, '0.00', 'Active', 'https://portal.systemsevaluation.co.ke/qms-capacity-assessment.pdf', '0', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_transactions`
--

CREATE TABLE `sys_transactions` (
  `id` int(11) NOT NULL,
  `account` varchar(200) NOT NULL,
  `type` enum('Income','Expense','Transfer') NOT NULL,
  `category` varchar(200) DEFAULT NULL,
  `amount` decimal(18,2) NOT NULL,
  `payer` varchar(200) DEFAULT NULL,
  `payee` varchar(200) DEFAULT NULL,
  `payerid` int(11) NOT NULL DEFAULT 0,
  `payeeid` int(11) NOT NULL DEFAULT 0,
  `method` varchar(200) DEFAULT NULL,
  `ref` varchar(200) DEFAULT NULL,
  `status` enum('Cleared','Uncleared','Reconciled','Void') NOT NULL DEFAULT 'Cleared',
  `description` text DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `tax` decimal(18,2) NOT NULL DEFAULT 0.00,
  `date` date NOT NULL,
  `dr` decimal(18,2) NOT NULL DEFAULT 0.00,
  `cr` decimal(18,2) NOT NULL DEFAULT 0.00,
  `bal` decimal(18,2) NOT NULL DEFAULT 0.00,
  `iid` int(11) NOT NULL DEFAULT 0,
  `currency` int(11) NOT NULL DEFAULT 0,
  `currency_symbol` varchar(10) DEFAULT NULL,
  `currency_prefix` varchar(10) DEFAULT NULL,
  `currency_suffix` varchar(10) DEFAULT NULL,
  `currency_rate` decimal(11,4) NOT NULL DEFAULT 1.0000,
  `base_amount` decimal(16,4) NOT NULL DEFAULT 0.0000,
  `company_id` int(11) NOT NULL DEFAULT 0,
  `vid` int(11) NOT NULL DEFAULT 0,
  `aid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) NOT NULL DEFAULT 0,
  `attachments` text DEFAULT NULL,
  `source` varchar(200) DEFAULT NULL,
  `rid` int(11) NOT NULL DEFAULT 0,
  `pid` int(11) NOT NULL DEFAULT 0,
  `archived` int(1) NOT NULL DEFAULT 0,
  `trash` int(1) NOT NULL DEFAULT 0,
  `flag` int(1) NOT NULL DEFAULT 0,
  `c1` text DEFAULT NULL,
  `c2` text DEFAULT NULL,
  `c3` text DEFAULT NULL,
  `c4` text DEFAULT NULL,
  `c5` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_transactions`
--

INSERT INTO `sys_transactions` (`id`, `account`, `type`, `category`, `amount`, `payer`, `payee`, `payerid`, `payeeid`, `method`, `ref`, `status`, `description`, `tags`, `tax`, `date`, `dr`, `cr`, `bal`, `iid`, `currency`, `currency_symbol`, `currency_prefix`, `currency_suffix`, `currency_rate`, `base_amount`, `company_id`, `vid`, `aid`, `created_at`, `updated_at`, `updated_by`, `attachments`, `source`, `rid`, `pid`, `archived`, `trash`, `flag`, `c1`, `c2`, `c3`, `c4`, `c5`) VALUES
(1, 'AM', 'Income', NULL, '28000.00', NULL, NULL, 3, 3, NULL, NULL, 'Cleared', NULL, NULL, '0.00', '2020-06-01', '0.00', '5000.00', '0.00', 0, 0, NULL, NULL, NULL, '1.0000', '0.0000', 0, 0, 1, NULL, NULL, 0, NULL, NULL, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sys_units`
--

CREATE TABLE `sys_units` (
  `id` int(11) NOT NULL,
  `type` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `reference` varchar(200) DEFAULT NULL,
  `conversion_factor` decimal(16,2) NOT NULL DEFAULT 0.00,
  `sorder` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account_balances`
--
ALTER TABLE `account_balances`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_actionplans`
--
ALTER TABLE `crm_actionplans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_customfields`
--
ALTER TABLE `crm_customfields`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_customfieldsvalues`
--
ALTER TABLE `crm_customfieldsvalues`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_groups`
--
ALTER TABLE `crm_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_industries`
--
ALTER TABLE `crm_industries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_itesters`
--
ALTER TABLE `crm_itesters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_leads`
--
ALTER TABLE `crm_leads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_lead_sources`
--
ALTER TABLE `crm_lead_sources`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_lead_status`
--
ALTER TABLE `crm_lead_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_results_actionplan`
--
ALTER TABLE `crm_results_actionplan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_salutations`
--
ALTER TABLE `crm_salutations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crm_testers`
--
ALTER TABLE `crm_testers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ib_doc_rel`
--
ALTER TABLE `ib_doc_rel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ib_invoice_access_log`
--
ALTER TABLE `ib_invoice_access_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_accounts`
--
ALTER TABLE `sys_accounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_actionplan`
--
ALTER TABLE `sys_actionplan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_activity`
--
ALTER TABLE `sys_activity`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_appconfig`
--
ALTER TABLE `sys_appconfig`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_cart`
--
ALTER TABLE `sys_cart`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_cats`
--
ALTER TABLE `sys_cats`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_companies`
--
ALTER TABLE `sys_companies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_currencies`
--
ALTER TABLE `sys_currencies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_documents`
--
ALTER TABLE `sys_documents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_email_logs`
--
ALTER TABLE `sys_email_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_email_templates`
--
ALTER TABLE `sys_email_templates`
  ADD PRIMARY KEY (`id`,`language_id`),
  ADD KEY `tplname` (`tplname`(32));

--
-- Indexes for table `sys_evalitems`
--
ALTER TABLE `sys_evalitems`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoiceid` (`evalid`);

--
-- Indexes for table `sys_evaluations`
--
ALTER TABLE `sys_evaluations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`topicid`),
  ADD KEY `status` (`status`(3));

--
-- Indexes for table `sys_events`
--
ALTER TABLE `sys_events`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_invoiceitems`
--
ALTER TABLE `sys_invoiceitems`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoiceid` (`invoiceid`);

--
-- Indexes for table `sys_invoices`
--
ALTER TABLE `sys_invoices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`userid`),
  ADD KEY `status` (`status`(3));

--
-- Indexes for table `sys_items`
--
ALTER TABLE `sys_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_item_cats`
--
ALTER TABLE `sys_item_cats`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_leads`
--
ALTER TABLE `sys_leads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_logs`
--
ALTER TABLE `sys_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_orders`
--
ALTER TABLE `sys_orders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_permissions`
--
ALTER TABLE `sys_permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_pg`
--
ALTER TABLE `sys_pg`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gateway_setting` (`name`(32),`processor`(32)),
  ADD KEY `setting_value` (`processor`(32),`ins`(32));

--
-- Indexes for table `sys_pl`
--
ALTER TABLE `sys_pl`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_pmethods`
--
ALTER TABLE `sys_pmethods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_questions`
--
ALTER TABLE `sys_questions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoiceid` (`evalitemid`);

--
-- Indexes for table `sys_quoteitems`
--
ALTER TABLE `sys_quoteitems`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_quotes`
--
ALTER TABLE `sys_quotes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_results`
--
ALTER TABLE `sys_results`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`userid`),
  ADD KEY `status` (`status`(3));

--
-- Indexes for table `sys_roles`
--
ALTER TABLE `sys_roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_sales`
--
ALTER TABLE `sys_sales`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_schedule`
--
ALTER TABLE `sys_schedule`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_schedulelogs`
--
ALTER TABLE `sys_schedulelogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_staffpermissions`
--
ALTER TABLE `sys_staffpermissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_tags`
--
ALTER TABLE `sys_tags`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_tasks`
--
ALTER TABLE `sys_tasks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_tax`
--
ALTER TABLE `sys_tax`
  ADD PRIMARY KEY (`id`),
  ADD KEY `state_country` (`state`(32),`country`(2));

--
-- Indexes for table `sys_testitems`
--
ALTER TABLE `sys_testitems`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoiceid` (`invoiceid`);

--
-- Indexes for table `sys_tests`
--
ALTER TABLE `sys_tests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`userid`),
  ADD KEY `status` (`status`(3));

--
-- Indexes for table `sys_topics`
--
ALTER TABLE `sys_topics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`userid`),
  ADD KEY `status` (`status`(3));

--
-- Indexes for table `sys_transactions`
--
ALTER TABLE `sys_transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_units`
--
ALTER TABLE `sys_units`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account_balances`
--
ALTER TABLE `account_balances`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_actionplans`
--
ALTER TABLE `crm_actionplans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `crm_customfields`
--
ALTER TABLE `crm_customfields`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_customfieldsvalues`
--
ALTER TABLE `crm_customfieldsvalues`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_groups`
--
ALTER TABLE `crm_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `crm_industries`
--
ALTER TABLE `crm_industries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `crm_itesters`
--
ALTER TABLE `crm_itesters`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `crm_leads`
--
ALTER TABLE `crm_leads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_lead_sources`
--
ALTER TABLE `crm_lead_sources`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `crm_lead_status`
--
ALTER TABLE `crm_lead_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `crm_results_actionplan`
--
ALTER TABLE `crm_results_actionplan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crm_salutations`
--
ALTER TABLE `crm_salutations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `crm_testers`
--
ALTER TABLE `crm_testers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `ib_doc_rel`
--
ALTER TABLE `ib_doc_rel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ib_invoice_access_log`
--
ALTER TABLE `ib_invoice_access_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_accounts`
--
ALTER TABLE `sys_accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_actionplan`
--
ALTER TABLE `sys_actionplan`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `sys_activity`
--
ALTER TABLE `sys_activity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_appconfig`
--
ALTER TABLE `sys_appconfig`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=139;

--
-- AUTO_INCREMENT for table `sys_cart`
--
ALTER TABLE `sys_cart`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_cats`
--
ALTER TABLE `sys_cats`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `sys_companies`
--
ALTER TABLE `sys_companies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sys_currencies`
--
ALTER TABLE `sys_currencies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sys_documents`
--
ALTER TABLE `sys_documents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_email_logs`
--
ALTER TABLE `sys_email_logs`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_email_templates`
--
ALTER TABLE `sys_email_templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `sys_evalitems`
--
ALTER TABLE `sys_evalitems`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

--
-- AUTO_INCREMENT for table `sys_evaluations`
--
ALTER TABLE `sys_evaluations`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `sys_events`
--
ALTER TABLE `sys_events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_invoiceitems`
--
ALTER TABLE `sys_invoiceitems`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sys_invoices`
--
ALTER TABLE `sys_invoices`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sys_items`
--
ALTER TABLE `sys_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `sys_item_cats`
--
ALTER TABLE `sys_item_cats`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_leads`
--
ALTER TABLE `sys_leads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_logs`
--
ALTER TABLE `sys_logs`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;

--
-- AUTO_INCREMENT for table `sys_orders`
--
ALTER TABLE `sys_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sys_permissions`
--
ALTER TABLE `sys_permissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `sys_pg`
--
ALTER TABLE `sys_pg`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `sys_pl`
--
ALTER TABLE `sys_pl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_pmethods`
--
ALTER TABLE `sys_pmethods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `sys_questions`
--
ALTER TABLE `sys_questions`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=189;

--
-- AUTO_INCREMENT for table `sys_quoteitems`
--
ALTER TABLE `sys_quoteitems`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sys_quotes`
--
ALTER TABLE `sys_quotes`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sys_results`
--
ALTER TABLE `sys_results`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `sys_roles`
--
ALTER TABLE `sys_roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sys_sales`
--
ALTER TABLE `sys_sales`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_schedule`
--
ALTER TABLE `sys_schedule`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sys_schedulelogs`
--
ALTER TABLE `sys_schedulelogs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sys_staffpermissions`
--
ALTER TABLE `sys_staffpermissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `sys_tags`
--
ALTER TABLE `sys_tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_tasks`
--
ALTER TABLE `sys_tasks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_tax`
--
ALTER TABLE `sys_tax`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sys_testitems`
--
ALTER TABLE `sys_testitems`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sys_tests`
--
ALTER TABLE `sys_tests`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=846;

--
-- AUTO_INCREMENT for table `sys_topics`
--
ALTER TABLE `sys_topics`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `sys_transactions`
--
ALTER TABLE `sys_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sys_units`
--
ALTER TABLE `sys_units`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

