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

START TRANSACTION;



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

--
-- 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 `flmcs_supports`
--

CREATE TABLE `flmcs_supports` (
  `id` int(11) NOT NULL,
  `tid` varchar(20) NOT NULL DEFAULT '0',
  `aid` int(11) NOT NULL DEFAULT 0,
  `fid` int(11) NOT NULL DEFAULT 0,
  `domain` varchar(100) NOT NULL,
  `tvid` varchar(30) NOT NULL,
  `tvpass` varchar(30) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `message` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `flmcs_users`
--

CREATE TABLE `flmcs_users` (
  `id` int(11) NOT NULL,
  `aid` int(11) NOT NULL DEFAULT 0,
  `domain` varchar(100) NOT NULL,
  `sid` int(11) NOT NULL,
  `server` varchar(100) NOT NULL,
  `client` varchar(250) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `email` varchar(100) NOT NULL,
  `address` mediumtext NOT NULL,
  `pdate` date NOT NULL,
  `rdid` varchar(100) NOT NULL,
  `rdpass` varchar(100) NOT NULL,
  `rdtype` varchar(50) NOT NULL,
  `sdir` varchar(50) NOT NULL,
  `cpuser` varchar(50) NOT NULL,
  `cppass` varchar(50) NOT NULL,
  `dbuser` varchar(50) NOT NULL,
  `dbpass` varchar(50) NOT NULL,
  `dbname` varchar(50) NOT NULL,
  `memo` mediumtext NOT NULL,
  `domain_oid` varchar(100) NOT NULL,
  `ns1` varchar(100) NOT NULL,
  `ns2` varchar(100) NOT NULL,
  `ns3` varchar(100) NOT NULL,
  `ns4` varchar(100) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `hrm_attendance`
--

CREATE TABLE `hrm_attendance` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `eid` int(11) NOT NULL,
  `ename` varchar(200) NOT NULL,
  `ent` datetime NOT NULL,
  `ex` datetime NOT NULL,
  `status` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `hrm_employees`
--

CREATE TABLE `hrm_employees` (
  `id` int(11) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `lname` varchar(100) NOT NULL,
  `email` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pl_assets`
--

CREATE TABLE `pl_assets` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `qty` int(11) NOT NULL,
  `price` decimal(14,2) NOT NULL,
  `total` decimal(14,2) NOT NULL,
  `pdate` date NOT NULL,
  `memo` mediumtext NOT 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_accounts`
--

INSERT INTO `sys_accounts` (`id`, `account`, `description`, `balance`) VALUES
(1, 'Barclays Account : 23513132151', 'Barclays Account - 23513132151', '145000.00'),
(2, 'NIC Account : 611651651651', 'NIC Account - 611651651651', '20000.00'),
(3, 'KCB Account : 51616515321', 'KCB Account - 51616515321', '0.00'),
(4, 'KCB Account : 516522222323', 'KCB Account - 516522222323', '30000.00');

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

--
-- 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_api`
--

CREATE TABLE `sys_api` (
  `id` int(11) NOT NULL,
  `label` text DEFAULT NULL,
  `ip` text DEFAULT NULL,
  `apikey` text DEFAULT 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', 'Creative Haven Limited'),
(29, 'theme', 'softhash'),
(37, 'currency_code', 'KShs'),
(56, 'language', 'en-us'),
(57, 'show-logo', '1'),
(58, 'nstyle', 'dark'),
(63, 'dec_point', '.'),
(64, 'thousands_sep', ','),
(65, 'timezone', 'Africa/Nairobi'),
(66, 'country', 'KE'),
(67, 'country_code', 'US'),
(68, 'df', 'd M Y'),
(69, 'caddress', 'Creative Haven Limited \r\n2nd Floor, Wilson Business Park Lang\'ata Road - Nairobi - Kenya\r\n\r\n (254) (716) 978 602\r\n www.creativehaven.co.ke\r\nPIN NO: P051754168Q'),
(70, 'account_search', '1'),
(71, 'redirect_url', 'dashboard'),
(72, 'rtl', '0'),
(73, 'ckey', '0982995697'),
(74, 'networth_goal', '2000000'),
(75, 'sysEmail', 'info@digitaedgekenya.com'),
(76, 'url_rewrite', '0'),
(77, 'build', '3600'),
(78, 'animate', '0'),
(79, 'pdf_font', 'Helvetica'),
(80, 'accounting', '1'),
(81, 'invoicing', '1'),
(82, 'quotes', '1'),
(83, 'client_dashboard', '1'),
(84, 'contact_set_view_mode', 'tbl'),
(85, 'invoice_terms', ''),
(86, 'console_notify_invoice_created', '0'),
(87, 'i_driver', 'default'),
(89, 'PIN', 'P123456789Z');

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

--
-- Table structure for table `sys_calls`
--

CREATE TABLE `sys_calls` (
  `id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `oid` int(11) NOT NULL,
  `summary` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `sys_cases`
--

CREATE TABLE `sys_cases` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `status` enum('Open','Closed') NOT NULL DEFAULT 'Open',
  `description` text NOT NULL,
  `source` text NOT NULL,
  `pid` int(11) NOT NULL DEFAULT 0,
  `cid` int(11) NOT NULL DEFAULT 0,
  `account` text NOT NULL,
  `aid` int(11) NOT NULL DEFAULT 0,
  `tags` text NOT NULL,
  `o` int(11) NOT NULL DEFAULT 0
) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_email_logs`
--

INSERT INTO `sys_email_logs` (`id`, `userid`, `sender`, `email`, `subject`, `message`, `date`, `iid`) VALUES
(1, 6, '', 'leonidah.anyoso@barclayscorp.com', 'CHRISTMAS DECOR', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear LEONIDAH ANYOSO,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 09 Jan 2017.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/3/token_4298086195\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/3/token_4298086195</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2016-12-09 17:02:41', 3),
(2, 6, '', 'leonidah.anyoso@barclayscorp.com', 'CHRISTMAS DECOR', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear LEONIDAH ANYOSO,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 09 Jan 2017.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/3/token_4298086195\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/3/token_4298086195</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2016-12-09 17:04:27', 3),
(3, 6, '', 'dennis@digitaledgekenya.com', 'CHRISTMAS DECOR', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear LEONIDAH ANYOSO,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 09 Jan 2017.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/3/token_4298086195\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/3/token_4298086195</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2016-12-09 17:16:53', 3),
(4, 7, '', 'shilpa@globalmice.in', 'TYRE PROMOTIONAL CAMPAIGN', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear Shilpa Sharma,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 07 Feb 2017.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/4/token_2815361831\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/4/token_2815361831</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2017-01-07 12:40:13', 4),
(5, 8, '', 'alice@hongsway.co.ke', 'DIGITAL MARKETING', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear ALICE ANJAVO,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 23 Feb 2017.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/5/token_1934413766\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/5/token_1934413766</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2017-01-23 17:18:52', 5),
(6, 11, '', 'raghav@globalmice.in', 'TYRE ACTIVATION', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear RAGHAV KHANNA,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 14 May 2017.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/8/token_3336483026\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/8/token_3336483026</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2017-04-14 18:21:19', 8),
(7, 11, '', 'raghav@globalmice.in', 'TYRE ACTIVATION', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear RAGHAV KHANNA,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 14 May 2017.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/8/token_1310207812\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/8/token_1310207812</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2017-04-15 12:38:55', 8),
(8, 15, '', 'june@usaficomfort.com', 'A4 FOLDED TO A5', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear JUNE ARUNGA KIMANI,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 08 Dec 2017.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/15/token_6019870619\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/15/token_6019870619</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2017-11-08 07:51:17', 15),
(9, 15, '', 'nairobi@digitaledgekenya.com', 'A4 FOLDED TO A5', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear JUNE ARUNGA KIMANI,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 08 Dec 2017.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/15/token_6019870619\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/15/token_6019870619</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2017-11-08 07:51:39', 15),
(10, 15, '', 'nairobi@digitaledgekenya.com', 'Digital Edge Limited Invoice', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,\'droid sans\',\'lucida sans\',sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		This email serves as your official invoice from <strong>Digital Edge Limited. </strong>	</div><div style=\"padding:10px 5px\">    Invoice URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/iview/1002/token_1512427784\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/iview/1002/token_1512427784</a><a target=\"_blank\" style=\"color:#1da9c0;font-weight:bold;padding:3px;text-decoration:none\" href=\"{{app_url}}\"></a><br>Invoice ID: 1002<br>Invoice Amount: 75,000.00<br>Due Date: 08 Nov 2017</div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">If you have any questions or need assistance, please don\'t hesitate to contact us.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2017-11-08 08:01:01', 1002),
(11, 20, '', 'loise.kathina@origy.co.ke', 'TUSKYS GREEN SQUARE', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear LOISE KATHINA,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 28 Mar 2018.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/16/token_8360171637\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/16/token_8360171637</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2018-02-28 18:04:33', 16),
(12, 20, '', 'loise.kathina@origy.co.ke', 'TUSKYS GREEN SQUARE', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear LOISE KATHINA,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 28 Mar 2018.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/16/token_2482200011\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/16/token_2482200011</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2018-03-01 12:09:46', 16),
(13, 20, '', 'loise.kathina@origy.co.ke', 'TUSKYS GREEN SQUARE', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Greetings,</div>	<div style=\"padding:5px\">		Dear LOISE KATHINA,&nbsp;<br> Here is the quote you requested for.  The quote is valid until 28 Mar 2018.	</div><div style=\"padding:10px 5px\">    Quote Unique URL: <a href=\"http://billing.digitaledgekenya.com/?ng=client/q/16/token_2482200011\" target=\"_blank\">http://billing.digitaledgekenya.com/?ng=client/q/16/token_2482200011</a><br></div><div style=\"padding:5px\"><span style=\"font-size: 13.3333330154419px; line-height: 21.3333320617676px;\">You may view the quote at any time and simply reply to this email with any further questions or requirement.</span><br></div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Digital Edge Limited Team</div></div></div>', '2018-03-01 12:15:07', 16),
(14, 0, '', 'albanus@digitaledgekenya.com', 'Obill password change request', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,\'droid sans\',\'lucida sans\',sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Hi Albanus,</div>	<div style=\"padding:5px\">		This is to confirm that we have received a Forgot Password request for your Account Username - albanus@digitaledgekenya.com <br>From the IP Address - 154.154.63.224	</div>	<div style=\"padding:5px\">		Click this linke to reset your password- <br><a target=\"_blank\" style=\"color:#1da9c0;font-weight:bold;padding:3px;text-decoration:none\" href=\"https://billing.digitaledgekenya.com/?ng=admin/pwreset-validate/3/token_1539090965\">https://billing.digitaledgekenya.com/?ng=admin/pwreset-validate/3/token_1539090965</a>	</div><div style=\"padding:5px\">Please note: until your password has been changed, your current password will remain valid. The Forgot Password Link will be available for a limited time only.</div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Obill Team</div></div></div>', '2019-08-25 14:07:00', 0),
(15, 0, '', 'albanus@digitaledgekenya.com', 'Obill New Password for Admin', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,\'droid sans\',\'lucida sans\',sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\">\n\n<div style=\"padding:5px;font-size:11pt;font-weight:bold\">\n   Hello Albanus\n</div>\n\n\n	<div style=\"padding:5px\">\n		Here is your new password for <strong>Obill. </strong>\n	</div>\n\n	\n<div style=\"padding:10px 5px\">\n    Log in URL: <a target=\"_blank\" style=\"color:#1da9c0;font-weight:bold;padding:3px;text-decoration:none\" href=\"https://billing.digitaledgekenya.com/?ng=admin/\">https://billing.digitaledgekenya.com/?ng=admin/</a><br>Username: albanus@digitaledgekenya.com<br>Password: 737295</div>\n\n<div style=\"padding:5px\">For security reason, Please change your password after login. </div>\n\n<div style=\"padding:0px 5px\">\n	<div>Best Regards,<br>Obill Team</div>\n\n</div>\n\n</div>', '2019-08-25 14:07:41', 0),
(16, 0, '', 'albanus@digitaledgekenya.com', 'Obill password change request', '<div style=\"line-height:1.6;color:#222;text-align:left;width:550px;font-size:10pt;margin:0px 10px;font-family:verdana,\'droid sans\',\'lucida sans\',sans-serif;padding:14px;border:3px solid #d8d8d8;border-top:3px solid #007bc3\"><div style=\"padding:5px;font-size:11pt;font-weight:bold\">   Hi Albanus,</div>	<div style=\"padding:5px\">		This is to confirm that we have received a Forgot Password request for your Account Username - albanus@digitaledgekenya.com <br>From the IP Address - 154.154.63.224	</div>	<div style=\"padding:5px\">		Click this linke to reset your password- <br><a target=\"_blank\" style=\"color:#1da9c0;font-weight:bold;padding:3px;text-decoration:none\" href=\"https://billing.digitaledgekenya.com/?ng=admin/pwreset-validate/3/token_7761068241\">https://billing.digitaledgekenya.com/?ng=admin/pwreset-validate/3/token_7761068241</a>	</div><div style=\"padding:5px\">Please note: until your password has been changed, your current password will remain valid. The Forgot Password Link will be available for a limited time only.</div><div style=\"padding:0px 5px\">	<div>Best Regards,<br>Obill Team</div></div></div>', '2019-08-25 14:09:26', 0);

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

--
-- 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_employees`
--

CREATE TABLE `sys_employees` (
  `id` int(11) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `middlename` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `nickname` varchar(100) NOT NULL,
  `birthdate` varchar(100) NOT NULL,
  `hiredate` date NOT NULL,
  `emid` varchar(100) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `payroll` enum('Salary','Hourly','Commission','Other') NOT NULL,
  `etype` enum('FullTime','PartTime','Other') NOT NULL,
  `classf` enum('Parmanent','Seasonal','Temp','Contract') NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `hphone` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `emname` varchar(100) NOT NULL,
  `emcontact` varchar(100) NOT NULL,
  `emrelation` varchar(100) NOT NULL,
  `jobtitle` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `supervisor` varchar(100) NOT NULL,
  `nextreview` date NOT NULL,
  `separation` date NOT NULL,
  `notes` mediumtext NOT NULL
) 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
(1194, 2487, 23, '', 0, '', 'STORAGE', '1', '20000.00', 0, '0.00', '20000.00', '2019-05-01', '', ''),
(1193, 2487, 23, '', 0, '', 'DISTRIBUTION OF MEDICAL MATERIAL', '1', '50000.00', 0, '0.00', '50000.00', '2019-05-01', '', ''),
(1195, 2488, 22, '', 0, '', 'CHAIRS', '30', '12000.00', 0, '0.00', '360000.00', '2019-05-01', '', ''),
(1196, 2488, 22, '', 0, '', 'CONFERENCE TABLES', '10', '50000.00', 0, '0.00', '500000.00', '2019-05-01', '', '');

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

--
-- 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 NOT NULL DEFAULT '0000-00-00 00:00:00',
  `subtotal` decimal(10,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(10,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 ''
) 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`) VALUES
(2487, 23, 'Africa PVC Industries Ltd', '', 'INV', '2019-05-01', '2019-05-01', '0000-00-00 00:00:00', '70000.00', 'p', '0.00', '0.00', '70000.00', '', '0.00', '0.00', '70000.00', '0.00', '0.00', 'Paid', '', '', '6903222354', '4081648932', '0', '2019-05-01', 0, ''),
(2488, 22, 'Furbicle Enterprises Ltd', '', 'INV', '2019-05-05', '2019-05-15', '0000-00-00 00:00:00', '860000.00', 'p', '0.00', '0.00', '0.00', '', '0.00', '0.00', '860000.00', '0.00', '0.00', 'Unpaid', '', '', '7882190049', '6469561315', '0', '2019-05-05', 0, '');

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

--
-- 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,
  `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 NOT NULL DEFAULT '0000-00-00',
  `last_sold` date NOT NULL DEFAULT '0000-00-00',
  `e` mediumtext NOT NULL
) 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
(184, '2015-07-22 15:12:31', 'Admin', 'Login Successful demo@example.com', 1, '::1'),
(185, '2016-05-28 13:53:51', 'Admin', 'Login Successful demo@example.com', 1, '127.0.0.1'),
(186, '2016-07-13 06:05:45', 'Admin', 'Login Successful demo@example.com', 1, '127.0.0.1'),
(187, '2016-07-13 06:52:47', 'Admin', 'Login Successful demo@example.com', 1, '127.0.0.1'),
(188, '2016-07-13 14:03:23', 'Admin', 'New Contact Added June Arunga Kimani [CID: 1]', 1, '127.0.0.1'),
(189, '2016-07-14 13:42:51', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '196.96.210.243'),
(190, '2016-07-15 18:27:17', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '154.122.41.84'),
(191, '2016-07-15 18:27:55', 'Admin', 'Contact Deleted ', 4, '154.122.41.84'),
(192, '2016-07-15 18:35:24', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.57.234.129'),
(193, '2016-07-15 18:36:28', 'Admin', 'New Contact Added Rashid Dina [CID: 2]', 4, '154.122.41.84'),
(194, '2016-07-15 20:09:04', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.57.234.129'),
(195, '2016-07-15 20:24:22', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '154.122.41.84'),
(196, '2016-07-15 20:28:30', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.57.234.129'),
(197, '2016-07-15 20:29:05', 'Admin', 'Login Successful nancysnr@gmail.com', 5, '154.122.41.84'),
(198, '2016-07-15 20:36:12', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '105.57.234.129'),
(199, '2016-07-15 20:36:18', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.57.234.129'),
(200, '2016-07-15 20:43:48', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.57.234.129'),
(201, '2016-07-16 14:13:33', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.161.146.7'),
(202, '2016-07-16 21:35:12', 'Admin', 'Login Successful nancysnr@gmail.com', 5, '154.123.31.246'),
(203, '2016-07-16 23:12:39', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.59.82.135'),
(204, '2016-07-16 23:21:51', 'Admin', 'New Expense: Marketting [TrID: 3 | Amount: 25000]', 3, '105.59.82.135'),
(205, '2016-07-17 00:29:42', 'Admin', 'Login Successful nancysnr@gmail.com', 5, '154.122.44.140'),
(206, '2016-07-18 15:49:48', 'Admin', 'Login Successful nancysnr@gmail.com', 5, '197.248.112.70'),
(207, '2016-07-27 15:16:23', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '41.80.78.221'),
(208, '2016-10-25 15:02:39', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '196.109.176.71'),
(209, '2016-10-25 15:16:31', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '196.109.176.71'),
(210, '2016-10-26 16:50:31', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.110.64.83'),
(211, '2016-10-26 16:56:11', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '196.98.200.215'),
(212, '2016-11-01 15:23:04', 'Admin', 'Failed Login dennis@digitaledgekenya.com', 0, '197.254.70.74'),
(213, '2016-11-01 15:29:02', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.106.140.162'),
(214, '2016-11-01 16:49:27', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.181.145.129'),
(215, '2016-11-04 05:11:43', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '105.231.168.150'),
(216, '2016-11-07 19:30:26', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '197.178.238.233'),
(217, '2016-11-08 21:50:32', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '105.167.146.64'),
(218, '2016-11-08 21:55:54', 'Admin', 'New Contact Added Robyn Henry [CID: 3]', 4, '105.167.146.64'),
(219, '2016-11-08 22:36:17', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '196.110.11.253'),
(220, '2016-11-09 16:55:28', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '105.50.101.250'),
(221, '2016-11-09 16:57:48', 'Admin', 'New Contact Added Izaak Job [CID: 4]', 4, '105.50.101.250'),
(222, '2016-11-09 17:11:53', 'Admin', 'New Contact Added Ruth [CID: 5]', 4, '105.50.101.250'),
(223, '2016-11-18 10:29:52', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.160.182'),
(224, '2016-11-21 12:04:18', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.55.178.30'),
(225, '2016-11-21 15:37:48', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.160.182'),
(226, '2016-11-28 13:00:54', 'Admin', 'Failed Login info@digitaledgekenya.com', 0, '196.207.160.182'),
(227, '2016-11-28 13:01:22', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.160.182'),
(228, '2016-11-28 15:06:56', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.160.182'),
(229, '2016-12-09 15:30:38', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '105.231.99.194'),
(230, '2016-12-09 16:37:23', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '105.231.59.190'),
(231, '2016-12-09 16:45:05', 'Admin', 'New Contact Added LEONIDAH ANYOSO [CID: 6]', 2, '105.231.59.190'),
(232, '2016-12-13 11:57:21', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.237.244.122'),
(233, '2016-12-13 11:57:44', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.237.244.122'),
(234, '2016-12-13 12:04:20', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.237.244.122'),
(235, '2016-12-13 12:14:27', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.237.244.122'),
(236, '2016-12-13 12:22:31', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.237.244.122'),
(237, '2016-12-13 12:25:07', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '105.160.136.210'),
(238, '2016-12-13 12:28:16', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.237.244.122'),
(239, '2016-12-13 12:28:31', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.165.87.58'),
(240, '2016-12-13 13:37:07', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.237.244.122'),
(241, '2016-12-14 10:28:26', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '154.76.219.87'),
(242, '2017-01-05 01:31:29', 'Admin', 'Failed Login info@digitaledgekenya.com', 0, '196.207.162.37'),
(243, '2017-01-05 01:31:51', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.162.37'),
(244, '2017-01-05 17:02:35', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.156.128.250'),
(245, '2017-01-07 11:11:26', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.254.70.74'),
(246, '2017-01-07 11:16:39', 'Admin', 'New Contact Added Shilpa Sharma [CID: 7]', 2, '197.254.70.74'),
(247, '2017-01-10 11:05:17', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '154.76.254.173'),
(248, '2017-01-11 15:54:42', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.232.22.163'),
(249, '2017-01-16 10:45:41', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '196.98.100.215'),
(250, '2017-01-23 16:39:40', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.254.70.74'),
(251, '2017-01-23 16:50:27', 'Admin', 'New Contact Added ALICE ANJAVO [CID: 8]', 2, '197.254.70.74'),
(252, '2017-01-24 11:39:14', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '105.230.50.135'),
(253, '2017-01-24 13:02:59', 'Admin', 'New Contact Added CARREN OLWENY [CID: 9]', 2, '154.122.125.118'),
(254, '2017-01-31 14:41:04', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '154.123.44.94'),
(255, '2017-01-31 14:45:04', 'Admin', 'New Contact Added CATHERINE AWINJA [CID: 10]', 2, '154.123.44.94'),
(256, '2017-02-09 14:47:01', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.162.86'),
(257, '2017-02-16 12:47:44', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.212.33.42'),
(258, '2017-02-27 14:13:28', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.232.52.128'),
(259, '2017-03-23 18:08:53', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.158.46'),
(260, '2017-04-03 19:08:44', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.63.148.32'),
(261, '2017-04-14 17:40:25', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.232.41.30'),
(262, '2017-04-14 17:44:38', 'Admin', 'New Contact Added RAGHAV KHANNA [CID: 11]', 2, '197.232.41.30'),
(263, '2017-04-14 17:57:28', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.232.41.30'),
(264, '2017-04-15 11:56:28', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.232.41.30'),
(265, '2017-04-15 12:16:20', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.232.41.30'),
(266, '2017-04-15 12:22:26', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.232.41.30'),
(267, '2017-04-15 12:50:31', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.232.41.30'),
(268, '2017-04-17 09:53:35', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.232.41.30'),
(269, '2017-06-13 11:49:51', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '197.232.41.30'),
(270, '2017-06-19 18:04:55', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '105.167.183.249'),
(271, '2017-06-19 18:05:20', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.167.183.249'),
(272, '2017-06-19 20:01:17', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.166.43.79'),
(273, '2017-06-19 20:02:32', 'Admin', 'New Contact Added Millicent Otieno [CID: 12]', 3, '105.166.43.79'),
(274, '2017-06-19 20:55:10', 'Admin', 'New Contact Added BEATRICE KAMAU [CID: 13]', 3, '105.166.43.79'),
(275, '2017-06-20 19:36:32', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.58.72.122'),
(276, '2017-06-20 19:40:22', 'Admin', 'New Contact Added Joshua Ashene [CID: 14]', 3, '197.183.8.224'),
(277, '2017-06-22 13:03:45', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.48.173.225'),
(278, '2017-06-29 08:58:49', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '105.58.200.149'),
(279, '2017-06-29 09:00:50', 'Admin', 'New Contact Added JUNE ARUNGA KIMANI [CID: 15]', 4, '105.58.200.149'),
(280, '2017-06-29 18:15:01', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.160.143.133'),
(281, '2017-07-14 12:14:22', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '196.104.43.178'),
(282, '2017-07-14 12:16:39', 'Admin', 'New Contact Added Nancy Kerubo [CID: 16]', 3, '196.104.43.178'),
(283, '2017-07-27 15:33:16', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '105.61.241.191'),
(284, '2017-07-27 16:40:23', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.162.243'),
(285, '2017-07-27 17:06:18', 'Admin', 'New Contact Added NISHA HOEK [CID: 17]', 4, '196.207.162.243'),
(286, '2017-07-27 19:13:18', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.162.243'),
(287, '2017-07-27 20:18:27', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.162.243'),
(288, '2017-07-27 21:17:44', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '196.207.162.243'),
(289, '2017-08-13 17:29:35', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '105.58.78.173'),
(290, '2017-09-20 09:03:20', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '41.212.82.143'),
(291, '2017-11-08 07:33:28', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '41.90.136.15'),
(292, '2017-11-08 07:59:52', 'Admin', 'Login Successful info@digitaledgekenya.com', 4, '41.90.136.15'),
(293, '2017-11-10 12:15:42', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.90.44.141'),
(294, '2017-11-23 18:29:11', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.90.44.141'),
(295, '2017-11-23 18:33:44', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.90.44.141'),
(296, '2017-11-29 14:48:40', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.167.168.133'),
(297, '2017-11-29 14:53:27', 'Admin', 'New Contact Added Alice [CID: 18]', 3, '105.167.168.133'),
(298, '2017-11-29 15:53:43', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.231.51.49'),
(299, '2017-12-02 12:40:23', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.57.90.184'),
(300, '2017-12-02 12:47:35', 'Admin', 'New Contact Added James Mureithi [CID: 19]', 3, '105.57.90.184'),
(301, '2017-12-02 15:47:05', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '196.101.113.207'),
(302, '2017-12-04 11:24:07', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.56.244.165'),
(303, '2017-12-04 11:59:42', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.77.119.100'),
(304, '2017-12-04 18:30:45', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.76.65.221'),
(305, '2018-02-28 16:23:11', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.90.154.172'),
(306, '2018-02-28 16:32:16', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.90.154.172'),
(307, '2018-02-28 16:35:10', 'Admin', 'New Contact Added LOISE KATHINA [CID: 20]', 2, '41.90.154.172'),
(308, '2018-02-28 16:58:02', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.90.154.172'),
(309, '2018-02-28 17:14:55', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.90.154.172'),
(310, '2018-03-01 11:53:18', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.90.154.172'),
(311, '2018-04-13 17:29:27', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.90.58.248'),
(312, '2018-04-13 17:40:45', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '197.177.75.54'),
(313, '2018-05-22 16:13:28', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '154.78.73.58'),
(314, '2018-05-22 16:39:50', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.76.30.93'),
(315, '2018-06-11 09:58:28', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.139.248.34'),
(316, '2018-06-11 10:06:38', 'Admin', 'New Contact Added MARGARET [CID: 21]', 2, '41.139.248.34'),
(317, '2018-06-12 01:35:12', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.77.106.69'),
(318, '2018-06-12 01:35:29', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.77.106.69'),
(319, '2018-08-03 00:53:15', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.212.64.221'),
(320, '2018-08-03 11:16:03', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.212.64.221'),
(321, '2018-08-27 08:51:13', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.90.148.189'),
(322, '2018-09-24 15:23:19', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.212.96.139'),
(323, '2018-10-02 10:07:21', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.212.110.89'),
(324, '2018-10-02 10:48:18', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.212.110.89'),
(325, '2018-10-19 13:41:33', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.80.70.142'),
(326, '2018-11-13 11:20:24', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '154.123.30.131'),
(327, '2018-12-07 17:12:31', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '154.79.37.61'),
(328, '2019-02-13 16:29:23', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.154.9.207'),
(329, '2019-02-13 16:29:43', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.154.9.207'),
(330, '2019-02-17 09:01:20', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '105.55.84.45'),
(331, '2019-02-24 13:18:33', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.79.118.40'),
(332, '2019-02-24 13:19:01', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.79.118.40'),
(333, '2019-04-10 11:59:53', 'Admin', 'Login Successful dennis@digitaledgekenya.com', 2, '41.212.13.201'),
(334, '2019-05-01 14:09:53', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.153.162.16'),
(335, '2019-05-01 14:24:37', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.153.162.16'),
(336, '2019-05-01 14:52:20', 'Admin', 'New Contact Added Furbicle Enterprises Ltd [CID: 22]', 3, '154.153.162.16'),
(337, '2019-05-01 14:53:38', 'Admin', 'New Contact Added Africa PVC Industries Ltd [CID: 23]', 3, '154.153.162.16'),
(338, '2019-05-01 14:54:31', 'Admin', 'New Contact Added Phillips Pharmaceuticals Ltd [CID: 24]', 3, '154.153.162.16'),
(339, '2019-05-01 14:58:22', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.153.162.16'),
(340, '2019-05-01 14:58:32', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.153.162.16'),
(341, '2019-05-01 15:26:29', 'Admin', 'New Deposit: Invoice 2487 Payment [TrID: 5 | Amount: 70000]', 3, '154.153.162.16'),
(342, '2019-05-01 22:58:30', 'Admin', 'Login Successful billing@b2bafrica.net', 5, '197.232.61.244'),
(343, '2019-05-04 08:21:33', 'Admin', 'Login Successful billing@b2bafrica.net', 5, '196.106.71.181'),
(344, '2019-06-29 18:29:15', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '197.232.61.197'),
(345, '2019-06-29 18:29:28', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '197.232.61.197'),
(346, '2019-06-29 18:29:49', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '197.232.61.197'),
(347, '2019-07-30 18:23:59', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.77.37.163'),
(348, '2019-07-30 18:40:47', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.77.37.163'),
(349, '2019-07-30 18:47:11', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '197.232.61.211'),
(350, '2019-07-30 18:47:31', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '197.232.61.211'),
(351, '2019-07-30 18:54:16', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.77.37.163'),
(352, '2019-07-30 18:54:20', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '197.232.61.211'),
(353, '2019-08-25 13:56:30', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.154.63.224'),
(354, '2019-08-25 13:56:39', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.154.63.224'),
(355, '2019-08-25 13:57:10', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.154.63.224'),
(356, '2019-08-25 13:57:21', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.154.63.224'),
(357, '2019-08-25 13:57:30', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.154.63.224'),
(358, '2019-08-25 13:57:39', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.154.63.224'),
(359, '2019-08-25 13:57:45', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.154.63.224'),
(360, '2019-08-25 14:02:47', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.154.63.224'),
(361, '2019-08-25 14:03:26', 'Admin', 'Failed Login info@digitaledgekenya.com', 0, '154.154.63.224'),
(362, '2019-08-25 14:03:44', 'Admin', 'Failed Login billing@b2bafrica.net', 0, '154.154.63.224'),
(363, '2019-08-25 14:04:32', 'Admin', 'Failed Login albanus@digitaledgekenya.com', 0, '154.154.63.224'),
(364, '2019-08-25 14:10:19', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.154.63.224'),
(365, '2019-08-25 14:38:56', 'Admin', 'Login Successful albanus@digitaledgekenya.com', 3, '154.157.194.0'),
(366, '2019-08-25 22:22:14', 'Admin', 'Login Successful dennis@creativehaven.co.ke', 5, '196.96.246.47'),
(367, '2019-08-25 22:22:14', 'Admin', 'Login Successful dennis@creativehaven.co.ke', 5, '196.96.246.47'),
(368, '2019-08-26 10:31:03', 'Admin', 'Login Successful demo@creativehave.co.ke', 4, '154.159.87.222'),
(369, '2019-08-26 10:31:37', 'Admin', 'Login Successful dennis@creativehaven.co.ke', 5, '154.159.87.222'),
(370, '2019-08-26 10:33:47', 'Admin', 'Login Successful demo@creativehave.co.ke', 4, '154.159.87.222'),
(371, '2019-08-26 11:24:29', 'Admin', 'Login Successful demo@creativehaven.co.ke', 4, '105.61.239.74'),
(372, '2019-09-05 21:54:35', 'Admin', 'Failed Login albanus@creativehaven.co.ke', 0, '154.159.142.67'),
(373, '2019-09-05 21:54:41', 'Admin', 'Failed Login albanus@creativehaven.co.ke', 0, '154.159.142.67'),
(374, '2019-09-05 21:54:49', 'Admin', 'Failed Login albanus@creativehaven.co.ke', 0, '154.159.142.67'),
(375, '2019-09-05 21:54:54', 'Admin', 'Login Successful albanus@creativehaven.co.ke', 3, '154.159.142.67'),
(376, '2019-09-06 06:31:34', 'Admin', 'Login Successful dennis@creativehaven.co.ke', 5, '154.155.197.53'),
(377, '2019-09-06 06:55:50', 'Admin', 'New Contact Added JUDY NJOGU [CID: 25]', 5, '154.155.197.53'),
(378, '2019-09-06 07:21:11', 'Admin', 'Login Successful dennis@creativehaven.co.ke', 5, '154.155.197.53'),
(379, '2019-09-06 12:28:00', 'Admin', 'Login Successful demo@creativehaven.co.ke', 4, '196.207.140.82'),
(380, '2019-10-06 09:03:42', 'Admin', 'Login Successful dennis@creativehaven.co.ke', 5, '41.81.240.207'),
(381, '2019-10-15 23:06:53', 'Admin', 'Login Successful dennis@creativehaven.co.ke', 5, '197.237.26.234');

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

--
-- Table structure for table `sys_lpoitems`
--

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

--
-- Dumping data for table `sys_lpoitems`
--

INSERT INTO `sys_lpoitems` (`id`, `qid`, `itemcode`, `description`, `qty`, `amount`, `discount`, `total`, `taxable`) VALUES
(1, 1, '', '1 x 20 ft Container - Port  - ICD Nairobi', '1', '62000.00', '0.00', '62000.00', 0),
(2, 2, '', '1x20 Msa - ICD Nairobi', '1', '62000.00', '0.00', '62000.00', 0),
(5, 3, '', 'ITEM 1', '20', '200.00', '0.00', '4000.00', 0),
(6, 3, '', 'ITEM 2', '3', '4520.00', '0.00', '13560.00', 0);

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

--
-- Table structure for table `sys_lpos`
--

CREATE TABLE `sys_lpos` (
  `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(10,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(10,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_lpos`
--

INSERT INTO `sys_lpos` (`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, 'Transport Services', 'Draft', '2019-08-30', 24, '', '', 'Phillips Pharmaceuticals Ltd', '', '', '', '', '', '', '', '', '', '', '', 0, '62000.00', 'p', '0.00', '0.00', 'VAT', '16.00', '9920.00', '0.00', '71920.00', '', '', '', '2019-07-30', '2019-07-30', '2019-07-30', '2019-07-30', '9908574238'),
(2, 'Transport Services', 'Draft', '2019-08-30', 24, '', '', 'Phillips Pharmaceuticals Ltd', '', '', '', '', '', '', '', '', '', '', '', 0, '62000.00', 'p', '0.00', '0.00', 'VAT', '16.00', '9920.00', '0.00', '71920.00', '', '', '', '2019-07-30', '2019-07-30', '2019-07-30', '2019-07-30', '5212493369'),
(3, 'TEST LPO', 'Draft', '2019-08-30', 24, '', '', 'Phillips Pharmaceuticals Ltd', '', '', '', '', '', '', '', '', '', '', '', 0, '17560.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '17560.00', '', '', '', '2019-07-30', '2019-07-30', '2019-07-30', '2019-07-30', '9363024283');

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

--
-- Table structure for table `sys_notes`
--

CREATE TABLE `sys_notes` (
  `id` int(11) NOT NULL,
  `contents` mediumtext NOT NULL,
  `type` enum('Private','Public') NOT NULL DEFAULT 'Private',
  `o` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  `updated` int(11) NOT NULL,
  `uo` int(11) NOT NULL,
  `vtoken` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `sys_orgs`
--

CREATE TABLE `sys_orgs` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `contacts` mediumtext NOT NULL,
  `phone` varchar(100) NOT NULL,
  `phones` mediumtext NOT NULL,
  `email` varchar(100) NOT NULL,
  `emails` mediumtext NOT NULL,
  `web` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `notes` mediumtext NOT NULL,
  `tags` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `sys_payee`
--

CREATE TABLE `sys_payee` (
  `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_payee`
--

INSERT INTO `sys_payee` (`id`, `name`, `sorder`) VALUES
(6, 'Amazon', 0),
(7, 'eBay', 0),
(8, 'Google', 0),
(12, 'Employee', 0),
(17, 'Gas Station', 0),
(18, 'Government', 0),
(19, 'Other', 0);

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

--
-- Table structure for table `sys_payers`
--

CREATE TABLE `sys_payers` (
  `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_payers`
--

INSERT INTO `sys_payers` (`id`, `name`, `sorder`) VALUES
(1, 'Employer', 2),
(2, 'City Bank', 3),
(5, 'Government', 0),
(7, 'John Doe', 0),
(8, 'Jane Doe', 0),
(9, 'Client X', 0);

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

--
-- 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
) 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`) VALUES
(1, 'Paypal', 'Paypal Email', 'demo@example.com', 'paypal', 'Invoices', 'USD', '1', '', '', '', 'Active', 1),
(2, 'Stripe', 'API Key', 'sk_test_ARblMczqDw61NusMMs7o1RVK', 'stripe', '', 'USD', '', '', '', '', 'Active', 2),
(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),
(4, 'Authorize.net', 'API_LOGIN_ID', 'Insert API Login ID here', 'authorize_net', '', 'Insert Transaction Key Here', '', '', '', '', 'Active', 4),
(5, 'Braintree', 'Merchant ID', 'your merchant id', 'braintree', '', 'your public key', 'your private key', 'bank account', 'sandbox', '', 'Inactive', 5),
(6, 'CCAvenue', 'Merchant ID', 'your merchant id', 'ccavenue', '', 'insert working key here', 'INR', '1', '', '', 'Inactive', 6);

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

--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_pl`
--

INSERT INTO `sys_pl` (`id`, `c`, `status`, `sorder`) VALUES
(1, 'flmcs', 0, 0);

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

--
-- 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_projects`
--

CREATE TABLE `sys_projects` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `status` enum('Open','Closed') NOT NULL DEFAULT 'Open',
  `description` text NOT NULL,
  `source` text NOT NULL,
  `started` date NOT NULL,
  `finished` date NOT NULL,
  `totaltime` varchar(20) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT 0,
  `account` text NOT NULL,
  `aid` int(11) NOT NULL DEFAULT 0,
  `tags` text NOT NULL,
  `o` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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(10,2) NOT NULL,
  `discount` decimal(10,2) NOT NULL,
  `total` decimal(10,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
(4, 1, '', '- 3 Panels Brochure (170 x 100mm)  Description:  3 panels Cards printed in full colour + Matt Lamination + Spot UV varnish.  CD supplied.  Final Size: Width 170.00 mm X Length 100.00 mm  Open Size: Width 300.00 mm X Length 170.00 mm  Paper 1: Art Matt 350g Paper   No. of Colours: Full Colour  card slot: for USB CARD', '200', '580.00', '0.00', '116000.00', 0),
(5, 1, '', '- Branded Card USB/8GB', '200', '1150.00', '0.00', '230000.00', 0),
(6, 2, '', 'CMS WEBSITE DEVELOPMENT: Mobile Enabled with products showcase', '1', '75000.00', '0.00', '75000.00', 0),
(14, 3, '', 'Blue LED lighting -Banking hall & Prestige tellers', '1', '10000.00', '0.00', '10000.00', 0),
(15, 3, '', 'Christmas tree decorations & gift boxes ', '1', '7000.00', '0.00', '7000.00', 0),
(16, 3, '', 'Christmas art on teller windows ', '1', '12000.00', '0.00', '12000.00', 0),
(17, 3, '', 'Hanging stars for the whole branch ', '1', '3000.00', '0.00', '3000.00', 0),
(18, 3, '', 'Red drapes & garlands ', '1', '10000.00', '0.00', '10000.00', 0),
(19, 3, '', 'Crew allowances ', '1', '8000.00', '0.00', '8000.00', 0),
(20, 3, '', 'Agency fees. 20% of total project fee ', '1', '10000.00', '0.00', '10000.00', 0),
(61, 4, '', 'Activators Allowances (1 Team of 2 activators) 2,000 x 2=4,000 x 60=240,000 ', '1', '240000.00', '0.00', '240000.00', 0),
(62, 4, '', ' Supervisors Allowance (1 supervisor 3,000 x 1=3,000 x 60=180,000', '1', '180000.00', '0.00', '180000.00', 0),
(63, 4, '', 'Project Manager (1 project manager 5,000 x 1 x 60 = 300,000', '1', '300000.00', '0.00', '300000.00', 0),
(64, 4, '', 'Accommodation (only outside Nairobi 4 x 3,000 x 53 =636,000', '1', '636000.00', '0.00', '636000.00', 0),
(65, 4, '', 'Non-branded full air conditioned 18 seated van hire + fuel 20,000 x 1 x 61 = 1,220,000', '1', '1220000.00', '0.00', '1220000.00', 0),
(66, 4, '', 'Full van branding and fabrication ', '1', '65000.00', '0.00', '65000.00', 0),
(67, 4, '', '32 smart digital Tv', '1', '30000.00', '0.00', '30000.00', 0),
(68, 4, '', 'N70 L battery', '1', '10000.00', '0.00', '10000.00', 0),
(69, 4, '', '240KV inverter ', '1', '12000.00', '0.00', '12000.00', 0),
(70, 4, '', 'County licenses including all branding material, van, sandwich men (1 x 40,000 x 22 =880,000', '1', '880000.00', '0.00', '880000.00', 0),
(71, 4, '', 'Refreshments for the entire campaign period', '1', '200000.00', '0.00', '200000.00', 0),
(72, 4, '', 'Design: All campaign collateral design ', '1', '150000.00', '0.00', '150000.00', 0),
(73, 4, '', 'Agency fees: 16% of Total project cost', '1', '627680.00', '0.00', '627680.00', 0),
(79, 5, '', 'SERVICE: MEDIA BUYING (TV ADVERTISING 1 CHANNEL SPONSORSHIP WEEKLY)', '1', '1200000.00', '0.00', '1200000.00', 0),
(80, 5, '', 'PRODUCT: OUTDOOR ADVERTISING (12m X 10m (3 BILLBOARDS FOR 3 MONTH)', '3', '250000.00', '0.00', '750000.00', 0),
(81, 5, '', 'SOCIAL MEDIA MANAGEMENT: 3 CHANNELS: FACEBOOK, TWITTER, INSTAGRAM', '12', '210000.00', '0.00', '2520000.00', 0),
(82, 5, '', 'AGENCY FEES: 10% of TOTAL PROJECT FEE', '1', '447000.00', '0.00', '447000.00', 0),
(87, 6, '', 'MATERIAL: FULL LOGO EMBROIDERED POLO T-SHIRTS ', '1', '1250.00', '0.00', '1250.00', 0),
(88, 6, '', 'MATERIAL: FULL COLOR SCREEN PRINTING HEAVY WEIGHT ROUND NECK T-SHIRT ', '1', '1000.00', '0.00', '1000.00', 0),
(89, 6, '', 'MATERIAL: FULL COLOR SCREEN PRINTING LIGHT WEIGHT ROUND NECK T-SHIRT', '1', '650.00', '0.00', '650.00', 0),
(90, 6, '', 'ONE OFF CHARGE: LOGO ORIGINATION', '1', '4500.00', '0.00', '4500.00', 0),
(97, 7, '', 'MATERIAL: FULL LOGO EMBROIDERED POLO T-SHIRTS', '200', '1250.00', '0.00', '250000.00', 0),
(98, 7, '', 'MATERIAL: FULL COLOR SCREEN PRINTING HEAVY WEIGHT ROUND NECK T-SHIRTS', '200', '1000.00', '0.00', '200000.00', 0),
(99, 7, '', 'ONE OFF CHARGE: LOGO SETUP/ORIGINATION', '1', '4500.00', '0.00', '4500.00', 0),
(122, 8, '', 'ACTIVATORS ALLOWANCES: (4 teams of 4 activators each) 16 x 2000 x 14 = 448000', '1', '448000.00', '0.00', '448000.00', 0),
(123, 8, '', 'SUPERVISOR ALLOWANCES: ( 1 Supervisor foe every region) 4 x 3000 x 14 = 168000', '1', '168000.00', '0.00', '168000.00', 0),
(124, 8, '', 'SUPERVISOR ACCOMMODATION: (Only outside Nairobi) 3 x 3000 x 14 = 126000', '1', '126000.00', '0.00', '126000.00', 0),
(125, 8, '', 'VANS: 4 Non-branded vans + fuel for hire per day. (1 van per region) 4 x 12000 x 14 = 672000', '1', '672000.00', '0.00', '672000.00', 0),
(126, 8, '', 'Training Day allowances: (20 activators) 20 x 500 = 10000', '1', '10000.00', '0.00', '10000.00', 0),
(127, 8, '', 'AGENCY FEES: 16% of Total project cost', '1', '227840.00', '0.00', '227840.00', 0),
(143, 9, '', 'Cypher USB Notebook  - GIFTSET-1710. Branded at one place. 2 color screen printing/debossed logo', '50', '4050.00', '0.00', '202500.00', 0),
(144, 9, '', 'Stanford A5 Notebook - NB 9335. Excludes the pen', '50', '1250.00', '0.00', '62500.00', 0),
(145, 9, '', 'PEN: PEN-1275  Matching Notebook Colour /Branded Logo Pad Print ', '50', '180.00', '0.00', '9000.00', 0),
(154, 10, '', 'Rocka Amplifier key holder Code TECH-4485 includes branding full colour / 1 side', '300', '450.00', '0.00', '135000.00', 0),
(155, 10, '', 'Nova Torch key holder Code KH-7400 includes branding full colour / 1 side', '300', '225.00', '0.00', '67500.00', 0),
(209, 11, '', 'A5 FLIERS - 135 gsm and Gloss Finishing. Digital Printing. Delivery 2 working days', '300', '25.00', '0.00', '7500.00', 0),
(210, 11, '', 'A1 POSTERS - 135 gsm and Gloss Finishing. Wide Format Press. Delivery 2 working days', '50', '2000.00', '0.00', '100000.00', 0),
(211, 11, '', 'A5 NOTEBOOKS - Laminated Cover.Chipboard 350 gsm. Bond 80 gsm. Cover Full colour. Inside 1 colour. Delivery 7-10 working days', '300', '650.00', '0.00', '195000.00', 0),
(212, 11, '', 'ROLLUP BANNERS - Heavy Base Flexi Material. Delivery 2 working days', '10', '12500.00', '0.00', '125000.00', 0),
(213, 11, '', '(OPTION 1) POLO SHIRTS - 100% Cotton. Embroidery at on Place. M - 100,L - 100, XL – 100. Delivery 7-10 working daysLOCAL. ', '300', '780.00', '0.00', '234000.00', 0),
(214, 11, '', '(OPTION 2) POLO SHIRTS - 100% Cotton. Embroidery at on Place.M - 100,L - 100, XL – 100. Delivery 7-10 working days. IMPORTED', '300', '1250.00', '0.00', '375000.00', 0),
(265, 14, '', 'USB-4605/Evergreen Memory Stick/bamboo 6.1 ( l ) x 2.2 ( w ) x 0.9 ( h ) version 2.0 microfibre presentation pouch: 10 ( l ) x 5 ( w )/8GB', '300', '1280.00', '0.00', '384000.00', 0),
(266, 14, '', '', '0', '0.00', '0.00', '0.00', 0),
(267, 14, '', ' BAG-3713-Lime Colour/Polka Tote/Environmentally friendly, re-usable. Laminated Jute / 30 (w)x 19 (d) x 30 (h)', '300', '820.00', '0.00', '246000.00', 0),
(268, 14, '', '', '0', '0.00', '0.00', '0.00', 0),
(269, 14, '', 'DW-6606/Vortex Tumbler - 450Ml/Unique slide-open colour accented lid. Wide screw on lid for easy fill and cleaning. BPA. ', '300', '750.00', '0.00', '225000.00', 0),
(270, 14, '', '', '0', '0.00', '0.00', '0.00', 0),
(510, 16, '', 'Road show truck; 35ft truck fully fabricated with sound, DJ cabin, two power back up generators 10Kva, VIP booth, first aid kit, roof canopy & parasol. Costs per day includes Driver, DJ & technician allowances.', '2', '114000.00', '0.00', '228000.00', 0),
(511, 16, '', 'Truck travelling fuel costs; To and From Kericho', '1', '25000.00', '0.00', '25000.00', 0),
(512, 16, '', 'Truck daily operational fuel costs (10,000 x2 = 20,000)', '2', '10000.00', '0.00', '20000.00', 0),
(513, 16, '', 'Emcees for hyping and key notes facilitators on road show truck ( 2 x 2500 = 5,000)', '2', '5000.00', '0.00', '10000.00', 0),
(514, 16, '', 'Administration police. ( 2 x 2500 = 5,000)', '2', '5000.00', '0.00', '10000.00', 0),
(515, 16, '', 'Foot soldiers ( 8 skaters) 8x 1500=12000', '2', '12000.00', '0.00', '24000.00', 0),
(516, 16, '', 'Dancers/ entertainers during roadshow ( 8 dancers) 8x 1500 = 12000', '2', '12000.00', '0.00', '24000.00', 0),
(517, 16, '', 'Scenery crew (2 x 2500 = 5000)', '2', '5000.00', '0.00', '10000.00', 0),
(518, 16, '', 'Brand Ambassadors (8 Activators for each team)(16 x 1300 = 20800', '2', '20800.00', '0.00', '41600.00', 0),
(519, 16, '', 'Supervisors (2 supervisors 1 for each team) ( 2 x 2000 = 4000)', '2', '4000.00', '0.00', '8000.00', 0),
(520, 16, '', 'Accommodation for 3 people ( 3 x 3500 = 10500', '2', '10500.00', '0.00', '21000.00', 0),
(521, 16, '', 'County licensing : Road show caravan & personnel ', '1', '14000.00', '0.00', '14000.00', 0),
(522, 16, '', 'Public Address ', '1', '10000.00', '0.00', '10000.00', 0),
(523, 16, '', 'Sand-witch men (2100 per person) (36 x 2100 = 75600', '1', '75600.00', '0.00', '75600.00', 0),
(524, 16, '', 'Banners ', '1', '8500.00', '0.00', '8500.00', 0),
(525, 16, '', 'PRSK', '1', '10000.00', '0.00', '10000.00', 0),
(526, 16, '', 'NEMA ', '1', '2200.00', '0.00', '2200.00', 0),
(527, 16, '', 'Flyer stamping (Ksh 5/= per flyer)', '0', '0.00', '0.00', '0.00', 0),
(528, 16, '', 'Transport; Two Non branded van hire (6000 per day for each) (6000 x 2 = 12000', '3', '12000.00', '0.00', '36000.00', 0),
(529, 16, '', 'Van fuel; To and From Kericho', '2', '7000.00', '0.00', '14000.00', 0),
(530, 16, '', 'Activation team accommodation. 8 skaters, 8 dancers, 2 scenery dancers, 16 BA\'s. Total 34 (2000 x 34 =68,000) ', '2', '68000.00', '0.00', '136000.00', 0),
(531, 16, '', 'Activation team transport; One Non branded Toyota Coaster + fuel per day 25,000', '3', '25000.00', '0.00', '75000.00', 0),
(532, 16, '', 'Agency Fees (12% of the Total Project Fees)', '1', '96348.00', '0.00', '96348.00', 0),
(535, 17, '', 'Clear Acrylic 2D Signage (2ft by 3ft)', '1', '39000.00', '0.00', '39000.00', 0),
(536, 17, '', 'Wall Pin Mounting ', '1', '5000.00', '0.00', '5000.00', 0),
(537, 18, '', 'RIBENA MT GOLD, SILVER & BRONZE ', '0', '0.00', '0.00', '0.00', 0),
(538, 18, '', 'Shelf Defenders', '0', '0.00', '0.00', '0.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(10,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(10,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, '3 PANEL BROCHURE WITH BRANDED CARD USB', 'Draft', '2016-12-08', 3, '', '', 'Robyn Henry', '', '', '', '', '', '', '', '', '', '', '', 0, '346000.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '346000.00', '', '<p>- Delivery 02 Weeks After Order Confirmation</p>', '', '2016-11-08', '2016-11-08', '2016-11-08', '2016-11-08', '4382595795'),
(2, 'WEBSITE DESIGN', 'Draft', '2016-12-09', 5, '', '462', 'Ruth', '', '', '', '', '', '', '', '', '', '', '', 0, '75000.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '75000.00', '', '<p>- Delivery 15 Days after project confirmation/approval of work submitted</p><p>- Client to provide all content, photos, logos/brand assets in acceptable format (softcopy)</p><p>- Deposit 60% on project confirmation, balance on approved demo completion prior to uploading on clients servers</p><p>- Digital edge will offer maintenance for 03 months after completion,thereafter training will be offered to Henkel</p>', '', '2016-11-09', '2016-11-09', '2016-11-09', '2016-11-09', '8811435387'),
(3, 'CHRISTMAS DECOR', 'Draft', '2017-01-09', 6, '', '', 'LEONIDAH ANYOSO', '', '', '', '', '', '', '', '', '', '', '', 0, '60000.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '60000.00', '', '<p>- PRICES ARE EXCLUSIVE VAT</p><p>- Estimate Based on Assumptions/Interpretation of the Specifications</p><p>- Project Timelines 1-2 days</p><p>- Additional features may attract additional Billing</p><p>- 60 % Deposit on Order confirmation</p>', '', '2016-12-09', '2016-12-09', '2016-12-09', '2016-12-09', '4298086195'),
(4, 'TYRE PROMOTIONAL CAMPAIGN', 'Draft', '2017-02-07', 7, '', '', 'Shilpa Sharma', '', '', '', '', '', '', '', '', '', '', '', 0, '4550680.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '4550680.00', '', '<p>- PRICES ARE EXCLUSIVE VAT</p><p>- Estimate Based on Assumptions/Interpretation of the Specifications on RFP Document (E&OE)</p><p>- Campaign Project Timeline  2 Months to cover all major cities and towns in kenya</p><p>- The above budget does not include the cost of any health certificates, activator uniforms, merchandise, giveaways, props and any associated         marketing cost.</p><p>- 3rd Party Charges, Council License(s) Fees Payable by Client Full on Confirmation</p><p>- Project fees 60 % Deposit on order confirmation and Balance as per approved Schedule/Milestones</p>', '', '2017-01-07', '2017-01-07', '2017-01-07', '2017-01-07', '2815361831'),
(5, 'DIGITAL MARKETING ', 'Draft', '2017-02-23', 8, '', '', 'ALICE ANJAVO', '', '', '', '', '', '', '', '', '', '', '', 0, '4917000.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '4917000.00', '', '<p>Notes</p><p>- PRICES ARE EXCLUSIVE VAT</p><p>- Estimate Based on Assumptions/Interpretation of the Specifications on RFP Document (E&OE)</p><p>- Campaign Project; (TV ADVERT TO RUN DURING & BEFORE PRIME TIMES) TV charges are exclusive of advert creation </p><p>- Social Media Campaign 12 Months. It will entail; Daily/weekly posting, engagement, post design/content creation, monitoring conversation & montly reporting</p><p>- Media, 3rd Party Charges, Council License(s) Fees Payable by Client Full on Confirmation</p><p>-Billboards to be erected on high traffic areas.</p><p>- Agency Fees 70 %  and Balance as per approved Schedule/Milestones</p>', '', '2017-01-23', '2017-01-23', '2017-01-23', '2017-01-23', '1934413766'),
(6, 'BRANDED T SHIRTS ', 'Draft', '2017-02-24', 9, '', '', 'CARREN OLWENY', '', '', '', '', '', '', '', '', '', '', '', 0, '7400.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '7400.00', '', '<p>Notes</p><p>Prices INCLUSIVE OF VAT</p><p>-Prices provided on the quote are of a single quantity.</p><p>- All Content Supplied By Client</p><p>- Design 07 Days subject to revisions</p><p>- 60 % deposit and balance on completion</p>', '', '2017-01-24', '2017-01-24', '2017-01-24', '2017-01-24', '2544668703'),
(7, 'BRANDED T-SHIRTS', 'Draft', '2017-03-03', 10, '', '', 'CATHERINE AWINJA', '', '', '', '', '', '', '', '', '', '', '', 0, '454500.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '454500.00', '', '<p><strong>NOTES</strong><strong></strong></p><p>Prices are INCLUSIVE OF VAT</p><p>-Logos and other content to be printed on the T-shirts to be provided by the Client.</p><p>-Designing/printing 07 days subject to revisions </p><p>-Kindly pay 60% deposit on order confirmation and balance on completion.</p>', '', '2017-01-31', '2017-01-31', '2017-01-31', '2017-01-31', '8203475275'),
(8, 'TYRE ACTIVATION', 'Draft', '2017-05-14', 11, '', '', 'RAGHAV KHANNA', '', '', '', '', '', '', '', '', '', '', '', 0, '1651840.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '1651840.00', '', '<p>- PRICES ARE EXCLUSIVE VAT</p><p>- Estimate based on assumptions/interpretation of the specifications on RFP Document (MAIL)</p><p>- Campaign Project Timeline: 14 days to cover all major cities and towns in Kenya</p><p>- The above budget does not include the cost of activators uniforms, merchandise if any, giveaways, props and any associated marketing cost if any applies.</p><p>- Project fees 60% Deposit on order confirmation and Balance as per approved schedule/milestones<br></p>', '', '2017-04-14', '2017-04-15', '2017-04-15', '2017-04-15', '1310207812'),
(9, 'Corporate Gift Notebooks', 'Draft', '2017-07-19', 12, '', '8496', 'Millicent Otieno', '', '', '', '', '', '', '', '', '', '', '', 0, '274000.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '274000.00', '', '<p>TERMS</p><ul>\r\n	<li>Delivery 2 -3 weeks (actual delivery timelines may reasonably vary, allow ample time)</li>\r\n	<li>Deposit 60% on confirmation, balance on delivery</li>\r\n	<li>PRICES EXCLUSIVE OF V.A.T</li>\r\n</ul>', '', '2017-06-19', '2017-06-19', '2017-06-19', '2017-06-19', '3812675797'),
(10, 'Branded Keyholders', 'Draft', '2017-07-19', 13, '', '8497', 'BEATRICE KAMAU', '', '', '', '', '', '', '', '', '', '', '', 0, '202500.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '202500.00', '', '<p>TERMS</p><ul><li>Delivery 2 -3 weeks (actual delivery timelines may reasonably vary, allow ample time)</li><li>Deposit 60% on confirmation, balance on delivery</li><li>PRICES EXCLUSIVE OF V.A.T</li></ul>', '', '2017-06-19', '2017-06-19', '2017-06-19', '2017-06-19', '1082621595'),
(11, 'Branded Merchandise', 'Draft', '2017-07-22', 14, '', '', 'Joshua Ashene', '', '', '', '', '', '', '', '', '', '', '', 0, '1036500.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '1036500.00', '', '<p>TERMS</p><ul><li>Deposit 60% on confirmation, balance on delivery</li><li>PRICES EXCLUSIVE OF V.A.T</li><li>All Artworks to be provided by client in print ready format, else artwork redraw charges may apply.</li></ul>', '', '2017-06-22', '2017-06-22', '2017-06-22', '2017-06-22', '5902898174'),
(14, 'BRANDED PROMOTIONAL ITEMS', 'Draft', '2017-08-27', 17, 'EST-', '581', 'NISHA HOEK', '', '', '', '', '', '', '', '', '', '', '', 0, '855000.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '855000.00', '', '<p>- PRICES EXCLUSIVE OF V.A.T<br>- Prices inclusive branding 1 colour at 1 place<br>- Deposit 60% on confirmation, balance on delivery<br>- Delivery 14 days from sample approval<br>- All Artworks to be provided by client in print ready format, else artwork redraw charges may apply.</p>', '', '2017-07-27', '2017-07-27', '2017-07-27', '2017-07-27', '2956330159'),
(16, 'TUSKYS GREEN SQUARE ', 'Draft', '2018-03-28', 20, '', '', 'LOISE KATHINA', '', '', '', '', '', '', '', '', '', '', '', 0, '899248.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '899248.00', '', '<p>NOTES</p><p>PRICES ARE EXCLUSIVE VAT</p><p>PRICES PROVIDED ON THE QUOTE ARE OF THE QUANTITY AND NUMBER OF DAYS PROVIDED IN THE BRIEF</p><p>ALL BRANDING MATERIAL TO BE PROVIDED BY THE CLIENT</p><p>KINDLY PAY 60% DOWN PAYMENT BALANCE ON COMPLETION </p>', '', '2018-02-28', '2018-03-01', '2018-03-01', '2018-03-01', '2482200011'),
(17, '2D SIGNAGE ', 'Draft', '2018-07-11', 21, '', '', 'MARGARET', '', '', '', '', '', '', '', '', '', '', '', 0, '44000.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '44000.00', '', '<p>-PRICES ARE EXCLUSIVE VAT</p><p>- Estimate Based on Assumptions/Interpretation of the Specifications</p><p>- Project Timelines 7 Days. Subject to approval process</p><p>- Additional features may attract additional Billing</p><p>- 60 % Deposit on Order confirmation , Balance on Completion</p>', '', '2018-06-11', '2018-06-11', '2018-06-11', '2018-06-11', '7405165278'),
(18, 'MARKETING POSM & BRANDING ', 'Draft', '2019-10-06', 25, '', '', 'JUDY NJOGU', '', '', '', '', '', '', '', '', '', '', '', 0, '0.00', 'p', '0.00', '0.00', '', '0.00', '0.00', '0.00', '0.00', '', '', '', '2019-09-06', '2019-09-06', '2019-09-06', '2019-09-06', '9174310020');

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

--
-- Table structure for table `sys_repeating`
--

CREATE TABLE `sys_repeating` (
  `id` int(11) NOT NULL,
  `account` varchar(200) NOT NULL,
  `type` enum('Income','Expense','Transfer') NOT NULL,
  `category` varchar(200) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payer` varchar(200) NOT NULL,
  `payee` varchar(200) NOT NULL,
  `method` varchar(200) NOT NULL,
  `ref` varchar(200) NOT NULL,
  `status` enum('Cleared','Uncleared','Reconciled','Void') NOT NULL DEFAULT 'Uncleared',
  `description` mediumtext NOT NULL,
  `tags` mediumtext NOT NULL,
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `date` date NOT NULL,
  `pdate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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', 'demo@example.com');

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

--
-- 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_servers`
--

CREATE TABLE `sys_servers` (
  `id` int(11) NOT NULL,
  `ip` varchar(50) NOT NULL,
  `hostname` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` mediumtext NOT NULL,
  `stype` varchar(50) NOT NULL,
  `apikey` mediumtext NOT NULL,
  `memo` mediumtext NOT NULL,
  `status` enum('Active','Inactive') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 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,
  `name` varchar(200) NOT NULL,
  `cid` int(11) NOT NULL,
  `oid` int(11) NOT NULL,
  `o` int(11) NOT NULL,
  `due` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `remind` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `notes` mediumtext NOT NULL,
  `status` enum('Completed','In Progress','Not Started') NOT NULL,
  `pid` int(11) NOT NULL,
  `ttime` varchar(50) NOT NULL,
  `sub` mediumtext NOT NULL
) 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
(7, 'VAT', '', '', '16.00', 0, '0.00');

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

--
-- 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) NOT NULL,
  `amount` decimal(18,2) NOT NULL,
  `payer` varchar(200) NOT NULL,
  `payee` varchar(200) NOT NULL,
  `payerid` int(11) NOT NULL DEFAULT 0,
  `payeeid` int(11) NOT NULL DEFAULT 0,
  `method` varchar(200) NOT NULL,
  `ref` varchar(200) NOT NULL,
  `status` enum('Cleared','Uncleared','Reconciled','Void') NOT NULL DEFAULT 'Cleared',
  `description` mediumtext NOT NULL,
  `tags` mediumtext NOT 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
) 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`) VALUES
(1, 'Barclays Account : 23513132151', 'Income', '', '300000.00', '', '', 0, 0, '', '', 'Cleared', 'Initial Balance', '', '0.00', '2016-07-16', '0.00', '300000.00', '300000.00', 0),
(2, 'NIC Account : 611651651651', 'Income', '', '100000.00', '', '', 0, 0, '', '', 'Cleared', 'Initial Balance', '', '0.00', '2016-07-16', '0.00', '100000.00', '100000.00', 0),
(3, 'Barclays Account : 23513132151', 'Expense', 'Uncategorized', '25000.00', '', '', 0, 0, '', '', 'Cleared', 'Marketting', '', '0.00', '2016-07-16', '25000.00', '0.00', '75000.00', 0),
(4, 'KCB Account : 516522222323', 'Income', '', '30000.00', '', '', 0, 0, '', '', 'Cleared', 'Initial Balance', '', '0.00', '2016-07-16', '0.00', '30000.00', '30000.00', 0),
(5, 'Barclays Account : 23513132151', 'Income', 'Regular Income', '70000.00', '', '', 23, 0, 'Check', '', 'Cleared', 'Invoice 2487 Payment', '', '0.00', '2019-05-01', '0.00', '70000.00', '145000.00', 2487);

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

--
-- Table structure for table `sys_tt`
--

CREATE TABLE `sys_tt` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `start` varchar(50) NOT NULL DEFAULT '0',
  `end` varchar(50) NOT NULL DEFAULT '0',
  `allday` enum('true','false') NOT NULL DEFAULT 'false',
  `url` varchar(200) NOT NULL DEFAULT '',
  `cid` int(11) NOT NULL DEFAULT 0,
  `tid` int(11) NOT NULL DEFAULT 0,
  `uid` int(11) NOT NULL DEFAULT 0,
  `pid` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `wm_sysemails`
--

CREATE TABLE `wm_sysemails` (
  `id` int(11) NOT NULL,
  `email` mediumtext NOT NULL,
  `password` mediumtext NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 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 `flmcs_users`
--
ALTER TABLE `flmcs_users`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `sys_cats`
--
ALTER TABLE `sys_cats`
  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_employees`
--
ALTER TABLE `sys_employees`
  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_logs`
--
ALTER TABLE `sys_logs`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

--
-- Indexes for table `sys_payers`
--
ALTER TABLE `sys_payers`
  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_projects`
--
ALTER TABLE `sys_projects`
  ADD PRIMARY KEY (`id`);

--
-- 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_repeating`
--
ALTER TABLE `sys_repeating`
  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_servers`
--
ALTER TABLE `sys_servers`
  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_transactions`
--
ALTER TABLE `sys_transactions`
  ADD PRIMARY KEY (`id`);

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

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

--
-- 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 `flmcs_users`
--
ALTER TABLE `flmcs_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `pl_assets`
--
ALTER TABLE `pl_assets`
  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=5;

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

--
-- AUTO_INCREMENT for table `sys_api`
--
ALTER TABLE `sys_api`
  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=90;

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

--
-- AUTO_INCREMENT for table `sys_cases`
--
ALTER TABLE `sys_cases`
  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=74;

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

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

--
-- AUTO_INCREMENT for table `sys_employees`
--
ALTER TABLE `sys_employees`
  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=1197;

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

--
-- AUTO_INCREMENT for table `sys_items`
--
ALTER TABLE `sys_items`
  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=382;

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

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

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

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

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

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

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

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

--
-- 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_projects`
--
ALTER TABLE `sys_projects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- 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_servers`
--
ALTER TABLE `sys_servers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- 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=8;

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

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

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

