-- http://www.phpmyadmin.net
--




--
-- Database: `cmccommy_job`
--

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

--
-- Table structure for table `clients`
--

CREATE TABLE IF NOT EXISTS `clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_by` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pic` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `clients_created_by_foreign` (`created_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=66 ;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `created_by`, `name`, `pic`, `email`, `phone`, `created_at`, `updated_at`) VALUES
(1, 2, 'Boustead Petroluem Marketing Sdn Bhd', 'MARKETING - Pn Rohaila', 'rohaila.razali@bhpetrol.com.my', '0193814375', '2017-02-14 19:06:39', '2017-02-20 08:05:57'),
(2, 2, 'Boustead Petroluem Marketing Sdn Bhd', 'SHOP - Mr Roger Sakai', 'roger.sakai@bhpetrol.com.my', '0133991823', '2017-02-15 18:03:11', '2017-02-20 08:06:59'),
(3, 2, 'Boustead Petroluem Marketing Sdn Bhd', 'SHOP - Ms Teo Sze Ying', 'sze_ying.teo@bhpetrol.com.my', '0163940429', '2017-02-15 18:19:12', '2017-02-20 08:07:12'),
(4, 2, 'Boustead Petroluem Marketing Sdn Bhd', 'SHOP - Ms Siti Sabirah', 'siti.sabira@bhpetrol.com.my', '0173636520', '2017-02-15 19:52:09', '2017-02-20 08:07:24'),
(5, 2, 'Boustead Petroluem Marketing Sdn Bhd', 'SHOP - Ms Noraina', 'noraina.idrus@bhpetrol.com.my', '0123742108', '2017-02-15 21:18:11', '2017-02-20 08:07:35'),
(7, 4, 'Gnommory Sdn Bhd', 'Mr Justin Ling', '', '0163314747', '2017-02-16 15:49:56', '2017-02-20 08:29:24'),
(8, 4, 'Ebizu Sdn Bhd', 'Mr Logan', 'logeswaran.sivanasen@ebizu.com', '0123698403', '2017-02-16 15:51:53', '2017-02-20 08:28:47'),
(9, 4, 'Tupperware Brands Malaysia Sdn. Bhd.', 'Ms Sharon Anne Rodrigues', 'sharonanne@tupperware.com', '0127835455', '2017-02-16 15:54:26', '2017-02-20 08:27:15'),
(10, 7, 'Power Root Marketing Sdn Bhd', 'Mr. Teo Cheng Liang (Sales Development Manager)', 'clteo@powerroot.com.my', '0127730270', '2017-02-17 02:32:03', '2017-02-17 02:32:56'),
(11, 7, 'Mydin Mohamed Holdings', 'Mr. Azahar Ibrahim (Assistant Manager)', '', '0192651031', '2017-02-17 02:37:13', '2017-02-17 02:37:13'),
(12, 7, 'Intrack Market Services Sdn Bhd (730339-D)', 'Mr CK Soon', 'soonck@intrack.com.my', '0193141513', '2017-02-17 12:48:20', '2017-02-20 08:29:33'),
(13, 4, 'Libroff Sdn Bhd ', 'Dato'' Maarof Rahman & Amelia Amir Husin', 'maarof@libroff.com & amelia@libroff.com', '0122777696', '2017-02-17 16:57:00', '2017-02-17 16:57:00'),
(14, 6, 'SUCCESS MONZA SDN.BHD', 'Ms ZIZIE', 'zizie@m7japan.com', '01137719266', '2017-02-20 02:57:57', '2017-02-20 08:27:03'),
(15, 6, 'UMOBILE SDN BHD', 'Mr YIP WENG SENG', 'wengseng.yip@u.com.my', '0182009992', '2017-02-20 03:01:40', '2017-02-20 08:26:21'),
(16, 6, 'ETIKA HOLDING', 'Mr Henry Cheow', 'jw.cheow@etikaholdings.com', '0129415633', '2017-02-20 03:02:39', '2017-02-20 08:28:01'),
(17, 6, 'TUNE TALK SDN BHD', 'Mr KARIM', 'karim.hamid@tunetalk.com', '0108171177', '2017-02-20 03:07:06', '2017-02-20 08:26:52'),
(18, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'TM - Mr Aziz', '', '0122098144', '2017-02-20 08:02:29', '2017-02-20 08:10:56'),
(19, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'TM - Mr Anand', '', '0126665153', '2017-02-20 08:06:47', '2017-02-20 08:06:47'),
(20, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'TM - Mr Azhan', '', '0126310572', '2017-02-20 08:08:48', '2017-02-20 08:08:48'),
(21, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'TM - Mr Ahmad Hidzri', '', '0129069177', '2017-02-20 08:09:24', '2017-02-20 08:09:24'),
(22, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'TM - Mr Fikri', '', '0123623970', '2017-02-20 08:10:07', '2017-02-20 08:10:07'),
(23, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'TM - Ms Chelcie', '', '0162223216', '2017-02-20 08:10:39', '2017-02-20 08:10:39'),
(24, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'TM - Mr Zabrin', '', '0196444236', '2017-02-20 08:11:31', '2017-02-20 08:11:31'),
(25, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'TM - Mr Yusry', '', '0178508303', '2017-02-20 08:12:26', '2017-02-20 08:24:58'),
(26, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'TM - Mr Oliver Thien', '', '0123879629', '2017-02-20 08:24:45', '2017-02-20 08:24:45'),
(27, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'TM - Mr Krishnan Nagoor', '', '0123731315', '2017-02-20 08:25:26', '2017-02-20 08:25:26'),
(28, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'Ecard - Ms Sum Yuet Yan', '', '0166669467', '2017-02-20 08:30:51', '2017-02-21 02:23:30'),
(29, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'Ecard - Ms Chong Mun Yee', '', '0174422290', '2017-02-20 08:32:02', '2017-02-20 08:32:02'),
(30, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'SHOP - Mr Azlan', '', '0194727786', '2017-02-21 02:15:23', '2017-02-21 02:15:50'),
(31, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'SHOP - Ms Umi Nazirah', '', '0122175170', '2017-02-21 02:16:41', '2017-02-21 02:16:41'),
(32, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'SHOP - Pn Farah Che Lodin', '', '0172244055', '2017-02-21 02:17:23', '2017-02-21 02:17:23'),
(33, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'Corporate Affair - Mr Hafiz', '', '0126738474', '2017-02-21 02:18:44', '2017-02-21 02:18:44'),
(34, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'CSU - JOEL', '', '7719', '2017-02-21 02:19:55', '2017-02-21 02:21:25'),
(35, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'LUBES - Mr Ahmadi', '', '0122145572', '2017-02-21 02:22:20', '2017-02-21 02:22:20'),
(36, 6, 'Boustead Petroluem Marketing Sdn Bhd', 'Trainer - Mr Velu', '', '0122775218', '2017-02-21 02:22:53', '2017-02-21 02:22:53'),
(37, 6, 'F&N Beverages Marketing Sdn Bhd', 'Ms Kimmy', 'kimmy@fn.com.my', '', '2017-02-21 02:25:21', '2017-02-21 02:25:21'),
(39, 7, 'J.CALLI (M) SDN BHD ', 'Ms. Lau You Yean (Chief Executive Officer)', 'lau4134@jcalli.com.my', '0123302378', '2017-02-21 02:44:08', '2017-02-21 02:44:08'),
(40, 7, 'FIPPER MARKETING SDN BHD', 'Hasbullah@Abu (Assistant Marketing Manager)', 'hasbullah@fipperslipper.com', '0142258184', '2017-02-21 02:46:40', '2017-02-21 02:46:40'),
(41, 7, 'A.W. Faber-Castell (M) Sdn. Bhd.', 'Mr. Chiam Long Thiam (Area Sales Manager)', 'chiam.longthiam@faber-castell.com.my', '0122952052', '2017-02-21 02:50:46', '2017-02-21 02:50:46'),
(42, 7, 'Celcom Planet Sdn Bhd (11street)', 'Kyungin Cha (Manager, Mobile Merchandising Division)', 'kyungin@11street.my', '0179048826', '2017-02-21 03:12:03', '2017-02-21 03:12:03'),
(43, 7, 'Celcom Planet Sdn Bhd (11street)', 'Lyle Yoo ( General Manager, Mobile Merchandising Division)', 'lyle@11street.my', '0192553111', '2017-02-21 03:13:48', '2017-02-21 03:13:48'),
(44, 7, 'FlyFirefly Sdn Bhd (346606-K)', 'Ms. Sufira Ibrahim ( Vice President Revenue Management)  ', 'sufira.ibrahim@fireflyz.com.my', '0192533038', '2017-02-21 03:38:21', '2017-02-21 03:38:21'),
(45, 7, 'FlyFirefly Sdn Bhd (346606-K)', 'Mr. Ignatius Ong (C.E.O)', 'ignatius.ong@fireflyz.com.my', '0122957164', '2017-02-21 03:41:19', '2017-02-21 03:41:19'),
(46, 10, 'Internal', 'Admin', '', '0361426333', '2017-02-22 10:15:29', '2017-02-22 10:16:51'),
(47, 7, 'Projek Tekad Sdn Bhd', 'En. Syahin Ahmad (Business Development Manager)', 'syahin.projektekad@gmail.com', '0122126665', '2017-02-23 03:46:24', '2017-02-23 03:46:24'),
(48, 7, 'Digi Telecommunications Sdn Bhd', 'Ms.Punitvaali Manoharan (Manager - Loyalty,Rewards & Previleges', 'PUNITAVA@DIGI.COM.MY', '0146690425', '2017-03-01 09:18:17', '2017-03-01 09:18:17'),
(49, 7, 'Coup Marketing Asia Pacific Sdn Bhd (CMAP)', 'Mr. Ryan Chong', 'ryanchong@cmap.my', '0162222961', '2017-03-01 09:20:03', '2017-03-01 09:20:03'),
(50, 7, 'Coup Marketing Asia Pacific Sdn Bhd (998850-U)', 'Mr.Ryan Chong ( Asst Manager Of Sales & Marketing)', 'ryanchong@cmap.my', '0162222961', '2017-03-01 09:22:18', '2017-03-01 09:22:18'),
(51, 7, 'Huawei', 'Weng Seng', '', '', '2017-03-02 02:42:27', '2017-03-02 02:42:27'),
(52, 7, 'FlyFirefly Sdn Bhd (346606-K)', 'Ms.Farah Angelina Wong (Manager,Inflight Services)', 'farah.wong@firefly.com.my', '0102722699', '2017-03-03 06:07:14', '2017-03-03 06:07:14'),
(53, 7, 'Senior Global Marketing LTD ', 'Mr. Zainal Arif (Daa) Managing Director', 'zainal@seniorglobalmarketing.com', '01114323727', '2017-03-03 06:11:13', '2017-03-03 06:11:13'),
(54, 7, 'Celcopon Sdn Bhd', 'Ms.Clarice Yao Ping Ping (Business Development Associate)', 'clarice.ypp@mcoopon.my', '0133236169', '2017-03-03 06:13:48', '2017-03-03 06:13:48'),
(55, 7, 'Celcom Axiatia Berhad (167469-A)', 'Ms. Sherly Khoo Kim Kim (Business Manager Direct Channel National Distribution & Field Sales)', 'sherly@celcom.com.my', '0192228332', '2017-03-03 06:17:22', '2017-03-03 06:17:22'),
(56, 7, 'BookDoc', 'Dato'' Chevy Beh (Founder)', 'chevybeh@bookdoc.com', '0125261331', '2017-03-03 06:30:52', '2017-03-03 06:30:52'),
(57, 4, 'Cocos field Resources ( Cafe''s Name ) ', 'En Razak', 'razak.asiaascend@gmail.com', '0133643216', '2017-03-09 09:11:28', '2017-03-09 09:11:28'),
(58, 4, 'Farmcochem Sdn Bhd', 'W S Goh', 'wsgoh@farcochem.com', '0162291787', '2017-03-09 13:21:10', '2017-03-09 13:21:10'),
(59, 4, 'Eeman Corporation Sdn Bhd', 'Gavin Singh CEO', 'gavinsingh73@gmail.com', '0196075553', '2017-03-09 13:27:42', '2017-03-09 13:27:42'),
(60, 4, 'Majestic Alps Sdn Bhd', 'P.Rajan Director', 'rajan@majesticalps.com.my', '0123329999', '2017-03-09 13:28:55', '2017-03-09 13:28:55'),
(61, 6, 'Nestle Products Sdn Bhd', 'Carolyn See', '', '0126015402', '2017-03-10 03:31:28', '2017-03-10 03:31:28'),
(62, 6, 'REDDUCK SDN BHD', 'Ms Fath', '', '0189899818', '2017-03-10 03:37:00', '2017-03-10 03:37:00'),
(63, 4, 'Boustead Petroluem Marketing Sdn Bhd', 'Mr Terry Lim', 'terry.lim@bhpetrol.com.my', '', '2017-03-11 05:43:46', '2017-03-11 05:43:46'),
(64, 7, 'omnitel,inc', 'Mr. Youngho Woo (Overseas Business Team Deputy General Manager)', 'yhwoo@omnitel.co.kr', '821030200302', '2017-03-17 04:05:21', '2017-03-17 04:05:21'),
(65, 7, 'Celcopon Sdn Bhd', 'Mr.Gunalaraj M. Devadasan @Martin', 'martin@mcoopon.my', '0192167900', '2017-03-17 04:07:59', '2017-03-17 04:07:59');

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

--
-- Table structure for table `companies`
--

CREATE TABLE IF NOT EXISTS `companies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Creative Minds Communication Sdn Bhd', '2017-02-16 07:24:47', '2017-02-16 15:55:55'),
(2, 'CMCNETMY SDN BHD', '2017-02-16 10:58:59', '2017-02-16 15:55:40'),
(4, 'Redduck Sdn Bhd', '2017-02-16 10:59:25', '2017-02-16 15:56:12'),
(5, 'Solution Gear Sdn Bhd', '2017-02-16 15:56:43', '2017-02-16 15:56:43');

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

--
-- Table structure for table `company_user`
--

CREATE TABLE IF NOT EXISTS `company_user` (
  `company_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`company_id`,`user_id`),
  KEY `company_user_company_id_index` (`company_id`),
  KEY `company_user_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `company_user`
--

INSERT INTO `company_user` (`company_id`, `user_id`) VALUES
(1, 5),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(2, 2),
(2, 3),
(2, 4),
(2, 5),
(2, 6),
(2, 7),
(2, 8),
(2, 9),
(2, 10),
(2, 11),
(2, 12),
(4, 1),
(4, 5),
(4, 11),
(4, 13),
(4, 14),
(4, 15),
(5, 1),
(5, 2),
(5, 11),
(5, 15);

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

--
-- Table structure for table `invoices`
--

CREATE TABLE IF NOT EXISTS `invoices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `job_id` int(10) unsigned NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `invoice_no` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `invoices_job_id_foreign` (`job_id`),
  KEY `invoices_created_by_foreign` (`created_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` (`id`, `job_id`, `created_by`, `invoice_no`, `created_at`, `updated_at`) VALUES
(5, 1023, 6, '', '2017-02-22 03:26:06', '2017-02-22 03:26:06'),
(7, 1008, 6, 'IV17/0132 BJP 5934', '2017-02-23 09:40:22', '2017-02-23 09:40:22'),
(8, 1008, 6, 'IV17/0131 WYE 9531', '2017-02-23 09:40:36', '2017-02-23 09:40:55'),
(9, 1008, 6, 'IV17/0130 BKW 8732', '2017-02-23 09:41:19', '2017-02-23 09:42:01'),
(11, 1008, 6, 'IV17/0129 WSN 2989', '2017-02-23 09:42:20', '2017-02-23 09:42:20');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE IF NOT EXISTS `jobs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `pic` int(10) unsigned NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `remark` text COLLATE utf8_unicode_ci,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `jobs_pic_foreign` (`pic`),
  KEY `jobs_client_id_foreign` (`client_id`),
  KEY `jobs_company_id_foreign` (`company_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1076 ;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `company_id`, `client_id`, `pic`, `title`, `remark`, `status`, `created_at`, `updated_at`) VALUES
(1000, 2, 10, 7, 'Power Root Chiller Door Advertising 2017', 'Power Root 6month Chiller Door Advertising - Quotation has been email to Teo for management approval. (Tax Invoice to be prepare by Vinny Upon receiving sign quotation)', 0, '2017-02-17 02:44:34', '2017-02-17 02:44:34'),
(1001, 2, 11, 7, 'U Mobile SIM card to be sold at Mydin', 'Mydin''s A&P Suggestion:\r\n- Big Banner at facade of the mall\r\n- Cashier Wrapping\r\n- Plastic Bags\r\n- Radio at Mydin FM (Real Time to all Mydin outlet)\r\n- Meria membership card (500k Members)\r\n\r\nMydin customer''s profile:\r\n- More Local people except sinar mydin, masjid india outlets with foreigners\r\n- Very strong is East coast area (Kelantan,Terengganu)\r\n\r\nMydin''s House Rules:\r\n- KRIM''S staff not allowed to used handphone (U Mobile to provide device for registration purpose to all KRIM''S outlet\r\n- Mydin''s Head of sales can carry handphone\r\n\r\nMydin''s Total outlets ( Around 300+ Below Breakdown)\r\n1) Hypermart & superstores - 48\r\n2) MyMydin - 50\r\n3) KRIM - 200 ( 150 Peninsular Malaysia; 50 East Malaysia)\r\n4) MyMart - 9\r\n5) Sam''s Groceria - 14', 0, '2017-02-17 03:13:08', '2017-02-17 03:13:08'),
(1002, 1, 3, 7, 'BHP, Smart shopper & Power Root Campaign (15TH March - 31st march) JN1002', 'ALL POSM Bill to BHPetrol', 0, '2017-02-17 12:14:21', '2017-02-17 12:14:21'),
(1003, 2, 10, 7, 'BHP, Smart shopper & Power Root Campaign (15TH March - 31st march) JN1002', 'Campaign Reimbursement for BHPetrol Stations ', 0, '2017-02-17 12:35:32', '2017-02-17 12:35:32'),
(1004, 2, 12, 7, 'BHP, Smart shopper & Power Root Campaign (15TH March - 31st march) JN1002', 'Front End Platform', 0, '2017-02-17 12:50:36', '2017-02-17 12:50:36'),
(1005, 2, 7, 4, 'Auto Services On The Go', 'To construct proposal/plans for this project and link them up with automotive school, SOS fast lane and Lubricant company', 0, '2017-02-17 17:04:06', '2017-02-17 17:04:06'),
(1006, 2, 14, 6, 'M7 SIGNAGES', 'Job cancel ', 1, '2017-02-20 03:04:55', '2017-02-23 11:37:03'),
(1007, 2, 17, 6, 'TUNETALK PLACEMENT FEE RENEWAL', 'PLACEMENT FEES DUE 31 JAN 2017', 0, '2017-02-20 03:08:30', '2017-02-20 03:08:30'),
(1008, 1, 1, 6, 'BHPETROL TRUCK BRANDING RENEWAL', '', 0, '2017-02-20 03:09:47', '2017-02-20 03:09:47'),
(1009, 2, 16, 6, 'KOPI TARIK CHILLER HANDLER ALTERNATIVE MEDIA (RENEWAL)', '', 0, '2017-02-20 03:12:44', '2017-02-20 03:12:44'),
(1010, 1, 4, 6, 'CHILLER SUCTION - REORDER', '', 0, '2017-02-20 03:14:45', '2017-02-20 03:14:45'),
(1011, 1, 3, 3, 'Hot Deals - March', 'Hot Deal for the month of March', 0, '2017-02-20 08:08:34', '2017-02-20 08:10:03'),
(1012, 1, 4, 6, 'Delivery of Shop Hardware Nescafe Rack to BHPetromart Nationwide', '', 0, '2017-02-20 08:41:54', '2017-02-20 08:41:54'),
(1013, 2, 9, 7, 'Tupperware 52year Roadshow ', 'Key PoInt - Celebrating 52 year Tupperware\r\n                - Recruitment drive roadshow ( 15 Location) \r\n                - Proposal by end week ( 1st Draft)', 0, '2017-02-20 11:06:32', '2017-02-20 11:06:32'),
(1014, 1, 30, 6, 'Collection Back of Magazine rack from Selected BHPetromart Nationwide', '', 0, '2017-02-21 02:28:56', '2017-02-21 02:29:14'),
(1015, 1, 34, 6, 'Delivery of Amenities Bin for the Month of Feb 2017', '', 0, '2017-02-21 02:30:10', '2017-02-22 09:31:01'),
(1016, 1, 32, 6, 'Monthly Bulletin for the Month of March 2017', '', 0, '2017-02-21 02:31:50', '2017-02-21 02:31:50'),
(1017, 2, 39, 7, 'BHPetrol - New Business (Product Placement) JN1017', '- J.calli agreed with RM25 monthly placement fee ( Request Treading  Term)', 0, '2017-02-21 02:55:53', '2017-02-21 02:55:53'),
(1018, 2, 41, 7, 'BHPetrol - New Business (Product Placement) JN1017', 'As Discussed 20/2/2017 - Chiam to get on 60 days term and new proposal', 0, '2017-02-21 02:59:29', '2017-02-21 02:59:29'),
(1019, 2, 40, 7, 'BHPetrol - New Business (Product Placement) JN1017', 'Last Meeting Recap - Fipper Agreed on return goods \r\n                                 - Deposit to be wave as Distributor)\r\n                                 - Distribution to all BHPetrol Mart By CMC\r\n                                 - 60day Term (Pending C.E.O Approval)', 0, '2017-02-21 03:03:53', '2017-02-21 03:03:53'),
(1020, 2, 43, 7, '11street Firefly E-Voucher Campaign JN1020', '-11street to draft contract for Firefly \r\n', 0, '2017-02-21 03:47:00', '2017-02-21 03:47:00'),
(1021, 1, 3, 6, 'Artic Standee POSM Printing', '', 1, '2017-02-22 03:14:33', '2017-02-22 03:15:11'),
(1022, 1, 29, 6, ' BHPetrol Ecard - Master Card Promo 15 Dec 2016 - 15 Jan 2017 - Bungy Ball for Banner', '', 0, '2017-02-22 03:21:24', '2017-02-22 03:21:24'),
(1023, 1, 18, 6, 'Replace New Trading Name for BHPetrol Sg Besi Harmony', '', 0, '2017-02-22 03:23:51', '2017-02-22 03:23:51'),
(1024, 1, 30, 6, 'Delivery of Shop Hardware for the Month Of Feb 2017', '', 0, '2017-02-22 03:30:37', '2017-02-22 03:30:37'),
(1025, 2, 37, 6, 'Services rendered for delivery charges of F&N racks to all BHPetrol outlets nationwide', '', 0, '2017-02-22 04:34:01', '2017-02-22 04:34:01'),
(1026, 2, 16, 6, 'Dismantling BHPetrol Chiller Handler - Kopi Tarik', '', 0, '2017-02-22 04:35:27', '2017-02-22 04:35:27'),
(1027, 4, 2, 1, 'For testing purpose only', 'Ignore this job', 0, '2017-02-16 02:44:34', '2017-03-20 04:38:01'),
(1028, 1, 46, 10, 'Job Bag System Issues', '', 0, '2017-02-22 10:17:52', '2017-02-23 02:31:10'),
(1029, 1, 27, 6, 'Bhpetrol Euro 5 diesel activation at bhpetrol Taman melawati', '', 0, '2017-02-22 15:03:43', '2017-02-22 15:03:43'),
(1030, 2, 47, 7, 'Gempak Keluarga Felda 2 (Roadshow)', 'Last Communicate 23.2.17 - Follow up on next meeting and payment\r\nProject still ongoing- TP is waiting for presentation date from felda\r\n- Revised proposal to be send upon collection RM 5K ( Have been invoice) ', 0, '2017-02-23 03:52:16', '2017-02-27 02:32:36'),
(1031, 1, 36, 6, 'SILA BAYAR DIDALAM SIGNAGES - ORANGE ACRYLIC', '', 0, '2017-02-23 08:57:44', '2017-02-23 08:57:44'),
(1032, 1, 1, 6, 'BHPetrol EV Charging POSM Signages', '', 0, '2017-02-23 09:31:51', '2017-02-23 09:31:51'),
(1033, 4, 46, 13, 'Order Stock - China', 'In process', 0, '2017-02-24 04:40:53', '2017-02-24 04:40:53'),
(1034, 1, 36, 6, 'Printing Motorist Assessment Audit Form 2017', '', 0, '2017-02-27 07:46:21', '2017-02-27 07:46:21'),
(1035, 1, 30, 6, 'BHPetrol Hot Meal Counter Dress Up @ BHPetrol Jalan Genting Klang 1', '', 0, '2017-02-27 07:54:14', '2017-02-27 07:54:14'),
(1036, 2, 48, 7, 'Digi Online Rewards Campaign', 'Propose for monthly 2 week campaign with partners', 0, '2017-03-01 09:33:07', '2017-03-01 09:33:07'),
(1037, 2, 49, 7, 'Cmap (Meeting with CEO)', 'Meeting up with Cmap@ 3PM (CEO from Korea)', 0, '2017-03-01 09:35:05', '2017-03-01 09:35:05'),
(1038, 1, 1, 6, 'BHPetrol Tissue Give Away - Gold Coin Contest', 'Target Date : 15th April 2017', 0, '2017-03-02 02:06:29', '2017-03-02 02:27:54'),
(1039, 2, 15, 6, 'BHPetrol Umobile Joint Promo 2017', 'Target date : 15th April 2017', 0, '2017-03-02 02:07:15', '2017-03-02 02:24:05'),
(1040, 1, 3, 6, 'BHPetrol Umobile Joint Promo 2017', 'Target Date : 15th April 2017', 0, '2017-03-02 02:09:50', '2017-03-02 02:24:53'),
(1041, 2, 15, 7, 'Huawei Tab Project', 'Follow up on contact from Weng seng', 0, '2017-03-02 02:44:03', '2017-03-02 02:44:03'),
(1043, 5, 42, 9, 'Monthly Meeting for 11Street - March 2017', '', 0, '2017-03-02 09:10:01', '2017-03-02 09:10:01'),
(1044, 1, 3, 7, 'Spot Me Partner Proposal Campaign', 'Campaign Header to be Working Title', 0, '2017-03-03 06:01:52', '2017-03-03 06:01:52'),
(1045, 2, 52, 7, 'Firefly Project - ( Vivani Pasta Chocolate )', 'Price to revised to RM0.80 (Requested by Farah)', 0, '2017-03-03 06:21:07', '2017-03-03 06:21:07'),
(1046, 2, 54, 7, 'M Coopon - Partnership for BHP Petrol ', '', 0, '2017-03-03 06:22:51', '2017-03-03 06:22:51'),
(1047, 2, 53, 7, 'Biscolata Project ( Distribution for product in BHP)', '', 0, '2017-03-03 06:24:27', '2017-03-03 06:24:27'),
(1048, 2, 55, 7, 'Celcom Sim Card Rack Placement', 'Looking to place simcard in BHP station ( Will update Ms.Sherly if got Empty slot)', 0, '2017-03-03 06:26:58', '2017-03-03 06:26:58'),
(1049, 2, 56, 7, 'Bookdoc - Astro Program sponsorship', '', 0, '2017-03-03 06:32:30', '2017-03-03 06:32:30'),
(1050, 1, 34, 9, 'Delivery Amenities Bin for the Month of March 2017', '', 0, '2017-03-06 01:44:51', '2017-03-06 01:44:51'),
(1051, 1, 32, 9, 'Monthly Bulletin for the Month of April 2017', '', 0, '2017-03-06 01:48:21', '2017-03-06 01:48:21'),
(1052, 1, 30, 9, 'Delivery of Shop Hardware for the Month of March 2017', '', 0, '2017-03-06 02:01:41', '2017-03-06 02:01:41'),
(1053, 4, 46, 13, 'Monthly Meeting for Red Duck Sdn Bhd', '', 0, '2017-03-06 09:16:03', '2017-03-06 09:16:03'),
(1054, 1, 2, 4, 'Pieface and Cyclone cross promo starts 15/3/2017 ends as we wish', '1. Polish at cyclone and get a free coffee.\r\n2. Purchase RM10 and above get RM1 discount for car wash. ', 0, '2017-03-06 09:34:28', '2017-03-06 09:34:28'),
(1055, 1, 2, 4, 'Pieface Chong Wei entrence standee change CNY to New Menu', 'Chong Wei shop entrance standee CNY menu change to New Menu', 0, '2017-03-07 06:49:20', '2017-03-07 06:49:20'),
(1056, 1, 2, 4, 'Pieface forecourt Menu for forecourt promoter ', 'A3 with lamination, both side printing. This is for freelance promoter at the forecourt.', 0, '2017-03-07 06:58:02', '2017-03-07 06:58:02'),
(1057, 2, 57, 4, 'To supply pie to Quuzy cafe ', 'To supply pies, puff & others ', 0, '2017-03-09 09:21:54', '2017-03-09 09:21:54'),
(1058, 2, 58, 4, 'Launch Event ', 'Daniel got the details', 1, '2017-03-09 13:23:34', '2017-03-16 11:51:19'),
(1059, 2, 1, 4, 'BHP Harley Convoy with Dato'' Awie to Thailand (ala amazing race)', '', 0, '2017-03-09 13:32:57', '2017-03-09 13:32:57'),
(1060, 2, 2, 4, 'Pieface forecourt promo BHPetrol Sg kayu Ara (1/4/2017 to 30/4/2017)', 'Still working on idea. mostly rejected by pieface', 0, '2017-03-09 14:22:03', '2017-03-11 05:20:03'),
(1061, 1, 2, 4, 'BHPetrol & Digi Campaign (1/5/2017 till 30/6/17) JN1061', '1. If Digi contribution is RM120K with GST we need to find for more partners.\r\n2. Not yet open partners JN', 0, '2017-03-09 15:52:07', '2017-03-09 15:54:48'),
(1062, 2, 61, 6, 'BHPetrol Hot Deal Promo for the Month Feb 2017 - Nescafe Tarik, Milo Stick & Orangemania Tissue', '', 0, '2017-03-10 03:33:50', '2017-03-10 03:33:50'),
(1063, 2, 62, 6, 'BHPetrol Hot Deal Promo for the Month Feb 2017 - Nescafe Tarik, Milo Stick & Orangemania Tissue', '', 0, '2017-03-10 03:37:40', '2017-03-10 03:37:40'),
(1064, 1, 1, 6, 'BHPetrol Fuel Display Board Fabrication Work', 'Outdoor team to fabrication Mock up based on the visual attached\r\nVisual : 3ft (w) x 4ft (H)\r\nOverall : 3ft (w) x 5ft (H)\r\nProject Dateline : All Display board to be display at station by 1st April 2017 (350 station)', 0, '2017-03-10 13:59:20', '2017-03-10 14:02:05'),
(1065, 2, 7, 4, 'Gnommory to sell e-voucher on 11st ', 'Gnommory to sell e-voucher on 11st and customers will collect the product at Gnommory''s dealers. ', 0, '2017-03-11 05:41:00', '2017-03-11 05:41:00'),
(1066, 1, 63, 4, 'Syngard Lubricant Retail Campaign 2017', 'To get syngard into workshops by using a reward system method. This method is to bypass distributers with them knowing it and agreeing to the project because of future projects.', 0, '2017-03-11 05:53:35', '2017-03-11 05:53:35'),
(1067, 1, 26, 6, 'NEW STATION OPENING KIT @ BHPETROL BACHANG', 'Station opening on 17th Mar 2017\r\nSetup 16th Mar 2017 Afternoon requested by Mr Oliver', 0, '2017-03-13 03:17:47', '2017-03-13 03:17:47'),
(1068, 1, 28, 9, 'Dismantle Banner Master Card', '', 0, '2017-03-13 09:50:42', '2017-03-13 10:04:45'),
(1069, 1, 30, 9, 'Sent Bunting Harap Maaf to BHPetrol Tmn Sri Endah', '', 0, '2017-03-15 02:04:28', '2017-03-15 02:04:28'),
(1070, 1, 30, 9, 'Sent Bunting Harap Maaf to BHPetrol Tmn Sri Endah', '', 0, '2017-03-15 02:04:35', '2017-03-15 02:04:35'),
(1071, 1, 2, 9, 'Sent Ev Charging to BHPetrol Sg Besi Harmony', '', 0, '2017-03-15 02:05:26', '2017-03-15 02:05:26'),
(1072, 1, 3, 4, 'Digi Loyalty Raya giveaway campaign (17/6 to 8/7/2017) JN1072', 'This campaign is using Digi loyalty apps with e-voucher (FMCG products) method and station will using OM for reimbursement purpose. If possible to include a contest into the campaign.', 0, '2017-03-15 05:34:14', '2017-03-15 05:34:14'),
(1073, 2, 48, 4, 'Digi Loyalty Raya giveaway campaign (17/6 to 8/7/2017) JN1072', 'Look at JN1072', 0, '2017-03-15 05:35:01', '2017-03-15 05:35:01'),
(1074, 1, 2, 4, 'T&G Spot and Pieface Bunting and Banner', '1. Currently at the lamp post and fencing there is T&G SPOT bunting and banner, we need to redo the visual and share the space between T&G and Pieface', 0, '2017-03-16 12:42:38', '2017-03-16 12:42:38'),
(1075, 1, 1, 6, 'BHPetrol Building Block - (Similar like logo)', '', 0, '2017-03-20 01:29:10', '2017-03-20 01:29:10');

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

--
-- Table structure for table `job_user`
--

CREATE TABLE IF NOT EXISTS `job_user` (
  `job_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`job_id`,`user_id`),
  KEY `job_user_job_id_index` (`job_id`),
  KEY `job_user_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `job_user`
--

INSERT INTO `job_user` (`job_id`, `user_id`) VALUES
(1000, 4),
(1000, 7),
(1001, 4),
(1001, 7),
(1002, 3),
(1002, 4),
(1002, 5),
(1002, 6),
(1002, 7),
(1002, 8),
(1002, 9),
(1003, 3),
(1003, 9),
(1003, 11),
(1004, 3),
(1004, 4),
(1004, 7),
(1005, 4),
(1006, 3),
(1006, 4),
(1006, 5),
(1007, 4),
(1008, 3),
(1008, 4),
(1008, 5),
(1008, 12),
(1009, 4),
(1009, 5),
(1009, 6),
(1009, 7),
(1009, 12),
(1010, 5),
(1010, 6),
(1010, 9),
(1010, 12),
(1011, 3),
(1011, 6),
(1011, 9),
(1012, 5),
(1012, 6),
(1012, 9),
(1013, 4),
(1013, 7),
(1013, 8),
(1014, 5),
(1014, 6),
(1014, 9),
(1015, 5),
(1015, 6),
(1015, 9),
(1016, 3),
(1016, 6),
(1016, 8),
(1016, 9),
(1017, 4),
(1017, 7),
(1018, 4),
(1018, 7),
(1019, 4),
(1019, 7),
(1020, 4),
(1020, 7),
(1021, 6),
(1021, 9),
(1022, 5),
(1022, 6),
(1022, 9),
(1022, 12),
(1023, 5),
(1023, 6),
(1023, 9),
(1023, 12),
(1024, 5),
(1024, 6),
(1024, 9),
(1024, 12),
(1025, 5),
(1025, 6),
(1025, 9),
(1025, 11),
(1025, 12),
(1026, 5),
(1026, 6),
(1026, 7),
(1026, 9),
(1026, 12),
(1027, 3),
(1028, 3),
(1028, 4),
(1028, 5),
(1028, 6),
(1028, 7),
(1028, 8),
(1028, 9),
(1028, 10),
(1028, 11),
(1028, 13),
(1029, 5),
(1029, 6),
(1030, 4),
(1030, 7),
(1031, 5),
(1031, 6),
(1031, 9),
(1032, 3),
(1032, 5),
(1032, 6),
(1032, 9),
(1032, 11),
(1033, 3),
(1033, 4),
(1033, 5),
(1033, 11),
(1034, 6),
(1034, 9),
(1034, 11),
(1035, 3),
(1035, 5),
(1035, 6),
(1035, 11),
(1036, 4),
(1036, 7),
(1037, 4),
(1037, 7),
(1038, 4),
(1038, 5),
(1038, 6),
(1038, 9),
(1038, 11),
(1039, 3),
(1039, 4),
(1039, 5),
(1039, 6),
(1039, 8),
(1039, 9),
(1039, 11),
(1040, 3),
(1040, 5),
(1040, 6),
(1040, 8),
(1040, 9),
(1040, 11),
(1041, 4),
(1041, 7),
(1043, 3),
(1043, 4),
(1043, 6),
(1043, 9),
(1043, 11),
(1044, 3),
(1044, 4),
(1044, 7),
(1044, 8),
(1045, 4),
(1045, 7),
(1046, 4),
(1046, 7),
(1047, 4),
(1047, 7),
(1048, 4),
(1048, 7),
(1049, 4),
(1049, 7),
(1050, 5),
(1050, 6),
(1050, 9),
(1051, 3),
(1051, 6),
(1051, 8),
(1051, 9),
(1052, 5),
(1052, 6),
(1052, 9),
(1052, 12),
(1053, 4),
(1053, 5),
(1054, 3),
(1054, 4),
(1054, 5),
(1054, 6),
(1054, 7),
(1054, 8),
(1054, 9),
(1054, 12),
(1055, 3),
(1055, 4),
(1055, 6),
(1056, 3),
(1056, 6),
(1057, 4),
(1057, 5),
(1058, 4),
(1059, 3),
(1059, 4),
(1059, 5),
(1059, 6),
(1059, 7),
(1059, 8),
(1059, 9),
(1059, 11),
(1059, 12),
(1060, 3),
(1060, 4),
(1060, 5),
(1060, 6),
(1060, 8),
(1060, 9),
(1060, 11),
(1060, 12),
(1061, 3),
(1061, 4),
(1061, 5),
(1061, 6),
(1061, 8),
(1061, 9),
(1061, 11),
(1061, 12),
(1062, 6),
(1062, 9),
(1062, 11),
(1063, 6),
(1063, 9),
(1063, 11),
(1064, 3),
(1064, 4),
(1064, 5),
(1064, 6),
(1064, 11),
(1065, 3),
(1065, 4),
(1066, 3),
(1066, 4),
(1066, 6),
(1067, 5),
(1067, 6),
(1067, 9),
(1067, 11),
(1067, 12),
(1068, 5),
(1068, 6),
(1068, 12),
(1069, 5),
(1069, 6),
(1069, 9),
(1069, 12),
(1070, 5),
(1070, 6),
(1070, 9),
(1070, 12),
(1071, 5),
(1071, 6),
(1071, 9),
(1071, 12),
(1072, 3),
(1072, 4),
(1072, 5),
(1072, 6),
(1072, 7),
(1072, 8),
(1072, 9),
(1072, 10),
(1072, 11),
(1072, 12),
(1073, 3),
(1073, 4),
(1073, 5),
(1073, 6),
(1073, 7),
(1073, 8),
(1073, 9),
(1073, 10),
(1073, 11),
(1073, 12),
(1074, 3),
(1074, 4),
(1074, 5),
(1074, 6),
(1074, 8),
(1074, 9),
(1074, 11),
(1074, 12),
(1075, 3),
(1075, 4),
(1075, 5),
(1075, 6),
(1075, 11);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`migration`, `batch`) VALUES
('2014_10_12_100000_create_password_resets_table', 1),
('2016_11_30_100823_create_users_table', 1),
('2016_11_30_100923_create_roles_tables', 1),
('2016_12_04_025649_create_jobs_table', 1),
('2016_12_06_025959_create_invoices_table', 1),
('2016_12_06_202436_create_tasks_table', 1),
('2017_02_07_230138_add_created_by_to_tasks_table', 1),
('2017_02_08_000102_add_status_to_tasks_table', 1),
('2017_02_10_124043_add_status_to_jobs_table', 1),
('2017_02_11_134546_create_job_user_pivot_table', 1),
('2017_02_13_025659_create_clients_table', 1),
('2017_02_13_033124_add_client_id_to_jobs_table', 1),
('2017_02_16_133652_create_companies_table', 1),
('2017_02_16_150635_add_company_id_to_jobs_table', 1);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES
(1, 'manage_user', 'Manage users', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'create_job', 'Create job', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'edit_job', 'Edit job', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 'delete_job', 'Delete job', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'manage_finance', 'Manage finance', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE IF NOT EXISTS `permission_role` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(2, 2),
(5, 3);

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

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES
(1, 'super', 'Manage everything', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'normal', 'Manage job', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'finance', 'Manage finance', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `role_user`
--

CREATE TABLE IF NOT EXISTS `role_user` (
  `role_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`user_id`),
  KEY `role_user_user_id_foreign` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`role_id`, `user_id`) VALUES
(1, 1),
(1, 2),
(2, 2),
(1, 3),
(2, 3),
(1, 4),
(2, 5),
(1, 6),
(2, 7),
(2, 8),
(2, 9),
(2, 10),
(2, 11),
(2, 12),
(2, 13),
(3, 13),
(2, 14),
(2, 15);

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

--
-- Table structure for table `tasks`
--

CREATE TABLE IF NOT EXISTS `tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `job_id` int(10) unsigned NOT NULL,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `outdoor` tinyint(1) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `tasks_job_id_foreign` (`job_id`),
  KEY `tasks_created_by_foreign` (`created_by`),
  KEY `tasks_updated_by_foreign` (`updated_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=278 ;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`id`, `job_id`, `created_by`, `updated_by`, `description`, `outdoor`, `status`, `created_at`, `updated_at`) VALUES
(1, 1000, 7, NULL, 'Vinny - Finance to Prepare TAX invoice Amount RM 76,850 (Upon receiving quotation) ', 0, 1, '2017-02-17 02:47:15', '2017-02-20 10:58:02'),
(9, 1001, 7, NULL, 'To Set appointment with Mydin to discussed on Umobile sim card distribution at Mydin ', 0, 0, '2017-02-17 03:30:33', '2017-02-17 03:30:33'),
(10, 1002, 7, NULL, 'Communication Pack', 0, 1, '2017-02-17 12:15:23', '2017-03-07 08:02:27'),
(12, 1002, 7, NULL, 'Chiller door sticker : Ah Huat & EPR', 0, 1, '2017-02-17 12:17:40', '2017-03-02 10:55:01'),
(14, 1002, 7, NULL, 'A4 Tent card', 0, 1, '2017-02-17 12:18:40', '2017-03-02 10:55:12'),
(15, 1002, 7, NULL, 'Courier All POSM system to All BHPetrol Mart ', 0, 0, '2017-02-17 12:20:17', '2017-02-17 12:20:17'),
(16, 1002, 7, NULL, 'Invoice - POSM to BHP', 0, 0, '2017-02-17 12:22:45', '2017-02-17 12:22:45'),
(17, 1003, 7, NULL, 'Reimbursement - Power Root to CMC ', 0, 0, '2017-02-17 12:37:50', '2017-02-17 12:37:50'),
(18, 1003, 7, NULL, 'Reimbursement - CMC to stations by 7/4/17', 0, 0, '2017-02-17 12:38:52', '2017-02-17 12:38:52'),
(19, 1003, 7, NULL, 'Quotation - Management Fee & Reimbursement Percentage ', 0, 0, '2017-02-17 12:40:44', '2017-02-17 12:40:44'),
(20, 1002, 7, NULL, 'Management Fee - For System & Careline ', 0, 0, '2017-02-17 12:43:18', '2017-02-17 12:43:18'),
(21, 1004, 7, NULL, 'Tan - To generate code ', 0, 1, '2017-02-17 12:52:51', '2017-03-07 08:04:52'),
(22, 1000, 4, NULL, 'Get visual from P.R ( Have requested already)', 0, 1, '2017-02-17 16:45:47', '2017-03-01 09:37:09'),
(23, 1000, 4, NULL, 'Printing - Pilot for P.R and BHP approval (17.3.2017) KAYU ARA STATION', 0, 0, '2017-02-17 16:46:32', '2017-03-14 08:36:54'),
(24, 1000, 4, NULL, 'Chiller Sizes - to make sure no wrong printing ( ALL MEASUREMENT DONE) ', 0, 0, '2017-02-17 16:47:12', '2017-03-14 08:38:14'),
(25, 1000, 4, NULL, 'printing 25 pcs (20-24.3.2017) chiller door sticker production', 0, 0, '2017-02-17 16:47:53', '2017-03-14 08:40:07'),
(26, 1000, 4, NULL, 'Duration - start - Campaign to start (April - September)  Date to be TBC by Teo', 0, 0, '2017-02-17 16:48:24', '2017-02-20 10:59:36'),
(27, 1001, 4, NULL, 'Advertising places at mydin', 0, 0, '2017-02-17 16:49:52', '2017-02-17 16:49:52'),
(28, 1010, 6, NULL, 'Quotation to client based on 200pcs', 0, 0, '2017-02-20 03:21:18', '2017-02-20 03:21:18'),
(29, 1010, 6, NULL, 'Mock up sample in progress', 0, 0, '2017-02-20 03:21:52', '2017-02-20 03:21:52'),
(30, 1009, 6, NULL, 'RENEWAL QUOTATION EMAIL TO CLIENT - AWAITING CLIENT TO REVERT ', 0, 0, '2017-02-20 03:23:13', '2017-02-20 03:23:13'),
(31, 1008, 6, NULL, 'NEW VISUAL TO SEND TO PIXIO', 0, 0, '2017-02-20 03:23:45', '2017-02-20 03:23:45'),
(33, 1008, 6, NULL, 'OUTDOOR TO SEND LORRY TO PIXIO - ALL LORRY', 0, 0, '2017-02-20 03:24:34', '2017-02-23 11:31:34'),
(34, 1006, 6, NULL, 'FABRICATION IN PROGRESS.    SIGNAGES at CMC office store', 0, 0, '2017-02-20 03:25:31', '2017-02-20 08:30:01'),
(35, 1011, 3, NULL, 'POSM - Chiller Decal, Freezer Decal, Upsell BackCard, A5 Tentcard, Guidebook', 0, 1, '2017-02-20 08:09:27', '2017-03-01 06:38:32'),
(37, 1013, 7, NULL, 'Kok Ming - to prepare all visual', 0, 1, '2017-02-20 11:07:15', '2017-03-06 10:02:57'),
(38, 1015, 6, NULL, 'BHPetrol Senai Depot : PPDC Booklet Qty : 200 booklet', 0, 1, '2017-02-21 02:30:39', '2017-02-27 08:09:07'),
(39, 1016, 6, NULL, 'Timeline for the Month of March (Niza)', 0, 1, '2017-02-21 02:32:30', '2017-02-22 05:11:36'),
(40, 1016, 6, NULL, 'Delivery Skynet Docket & Despatch Arrangement', 0, 1, '2017-02-21 02:33:07', '2017-02-22 05:11:50'),
(41, 1019, 7, NULL, 'To Prepare P&L', 0, 0, '2017-02-21 03:04:42', '2017-02-21 03:04:42'),
(42, 1018, 7, NULL, 'To Prepare P&L', 0, 0, '2017-02-21 03:05:18', '2017-02-21 03:05:18'),
(44, 1017, 7, NULL, 'To Prepare P&L', 0, 0, '2017-02-21 03:05:59', '2017-02-21 03:05:59'),
(45, 1020, 7, NULL, 'Follow up on Contract agreement with 11street  ', 0, 1, '2017-02-21 03:48:01', '2017-03-07 07:59:06'),
(46, 1019, 4, NULL, 'Trading contract', 0, 0, '2017-02-21 04:03:52', '2017-02-21 04:03:52'),
(47, 1019, 4, NULL, 'Time Line', 0, 0, '2017-02-21 04:04:07', '2017-02-21 04:04:07'),
(48, 1018, 4, NULL, 'Trading Contract', 0, 0, '2017-02-21 04:05:00', '2017-02-21 04:05:00'),
(49, 1018, 4, NULL, 'Timeline', 0, 0, '2017-02-21 04:05:07', '2017-02-21 04:05:07'),
(50, 1017, 4, NULL, 'Trading Contract ', 0, 0, '2017-02-21 04:05:35', '2017-02-21 04:05:35'),
(51, 1017, 4, NULL, 'Timeline', 0, 0, '2017-02-21 04:05:40', '2017-02-21 04:05:40'),
(52, 1020, 4, NULL, 'PR meeting with us', 0, 0, '2017-02-21 05:40:34', '2017-02-21 05:40:34'),
(53, 1022, 6, NULL, 'Order Bungy Ball from Pixio Due to Master Card Banner No Bungy Ball', 0, 0, '2017-02-22 03:21:57', '2017-02-22 03:21:57'),
(54, 1022, 6, NULL, 'Goods received from pixio, kindly raise invoice', 0, 0, '2017-02-22 03:22:43', '2017-02-22 03:22:43'),
(55, 1023, 6, NULL, 'Graphic to redesign the trading name & send to pixio to print (NURAZZAK ENTERPRISE 002575621-T) BHPETROL SG BESI HARMONY', 0, 0, '2017-02-22 03:25:02', '2017-02-22 03:27:41'),
(56, 1023, 6, NULL, 'Outdoor to Install New Trading Name by 25/2/2017', 0, 0, '2017-02-22 03:25:28', '2017-02-22 03:25:58'),
(57, 1024, 6, NULL, 'BHPetrol Pasir Gudang Highway 3 x 1 unit straw Dispenser by 25/2/2017', 0, 1, '2017-02-22 03:31:14', '2017-03-10 09:24:59'),
(58, 1024, 6, NULL, 'BHPetrol Jalan Tebrau 2 x 1 unit straw Dispenser by 25/2/2017', 0, 1, '2017-02-22 03:31:54', '2017-03-08 01:44:16'),
(59, 1024, 6, NULL, 'BHPetrol Raub 2 x 1 unit Chiller Suction Cup by 25/2/2017', 0, 1, '2017-02-22 03:33:02', '2017-03-06 01:58:25'),
(60, 1024, 6, NULL, 'BHPetrol Jawi  x 1 unit Chiller Suction Cup by 25/2/2017', 0, 1, '2017-02-22 03:34:46', '2017-02-28 04:18:44'),
(61, 1024, 6, NULL, 'BHPetrol Yong Peng 2 x 1 unit straw Dispenser by 25/2/2017', 0, 1, '2017-02-22 03:35:11', '2017-02-28 04:17:23'),
(62, 1025, 6, NULL, 'Raise quotation to client on 22/2/2017', 0, 0, '2017-02-22 04:34:29', '2017-02-22 04:36:49'),
(63, 1026, 6, NULL, 'Outdoor team to dismantle the chiller kopi tarik & reinstall back the handler', 0, 0, '2017-02-22 04:35:58', '2017-02-22 04:35:58'),
(64, 1016, 6, NULL, 'Printing POSM - Upsell Box, Chiller Sticker, GE Gondola, Shelftalker, Chiller Suction Cup, Tent Card, Bulletin Manual', 0, 1, '2017-02-22 05:04:08', '2017-02-27 08:08:12'),
(65, 1026, 6, NULL, 'Office admin to prepare dismantling list', 0, 0, '2017-02-22 05:10:56', '2017-02-22 05:10:56'),
(67, 1015, 6, NULL, 'BHPetrol Jalan Pantai : Watering Can x 4, Watering Bucket x 4, No Parking Signage x 2, Safety Cones x 10', 0, 1, '2017-02-22 09:31:34', '2017-02-28 04:15:26'),
(68, 1015, 6, NULL, 'BHPetrol Jitra : Watering Can x 4, Watering Bucket x 4, No Parking Signage x 2', 0, 0, '2017-02-22 09:32:23', '2017-02-22 09:32:23'),
(69, 1015, 6, NULL, 'BHPetrol Jelapang : Watering Can x 2 , Watering Bucket x 2', 0, 1, '2017-02-22 09:32:58', '2017-02-28 04:14:26'),
(70, 1015, 6, NULL, 'BHPetrol Ijok : Watering Can x 4, Watering Bucket x 4, Amenities Bin x 4', 0, 1, '2017-02-22 09:34:00', '2017-02-22 09:35:58'),
(71, 1015, 6, NULL, 'BHPetrol Mutiara Damansara : Safety Cones x 10', 0, 1, '2017-02-22 09:34:55', '2017-02-22 09:35:03'),
(72, 1015, 6, NULL, 'BHPetrol Serendah : Watering Can x 4, Watering Bucket x 4, Amenities Bin x 4', 0, 1, '2017-02-22 09:35:45', '2017-02-22 09:36:03'),
(73, 1024, 6, NULL, 'BHPetrol Jalan Gopeng x 1 unit Chiller Suction Cup by 25/2/2017', 0, 1, '2017-02-22 09:40:08', '2017-02-28 04:18:22'),
(74, 1024, 6, NULL, 'BHPetrol Jalan 222 x 1 unit Chiller Suction Cup by 25/2/2017', 0, 1, '2017-02-22 09:40:42', '2017-03-08 02:01:28'),
(75, 1024, 6, NULL, 'BHPetrol Jalan KTJB x 1 unit Chiller Suction Cup', 0, 1, '2017-02-22 09:41:43', '2017-02-28 04:19:33'),
(76, 1028, 10, NULL, 'Finance Dept - Just to put in invoice number in system (Tan)', 0, 1, '2017-02-22 10:18:22', '2017-03-01 05:06:48'),
(77, 1028, 10, NULL, 'All to upload new / on progress job (All) 6/3/2017 RM10 each job', 0, 0, '2017-02-22 10:19:58', '2017-03-02 04:53:48'),
(78, 1028, 10, NULL, 'Phone Number "0" - Add zero digit in the front of phone number (Tan)', 0, 0, '2017-02-22 10:21:03', '2017-02-22 10:26:42'),
(79, 1028, 10, NULL, 'Add New Client - Add the details like fax Number, Phone Number, Address, Company Reg Number, GST Number, and Job Title (Tan)', 0, 0, '2017-02-22 10:22:11', '2017-02-22 10:27:12'),
(80, 1028, 10, NULL, 'P.I.C Company - Visibility (Tan)', 0, 0, '2017-02-22 10:22:39', '2017-02-22 10:22:39'),
(81, 1028, 10, NULL, 'Receive Payment - Add button Right and Done (Tan)', 0, 0, '2017-02-22 10:24:25', '2017-02-22 10:25:13'),
(82, 1028, 10, NULL, 'If client is not on drop button to add a button "for new client" (Tan)', 0, 0, '2017-02-22 10:25:53', '2017-02-22 10:25:53'),
(83, 1028, 10, NULL, 'P.I.V - Just email the task (Tan)', 0, 0, '2017-02-22 10:26:32', '2017-02-22 10:26:32'),
(84, 1028, 10, NULL, 'Quotation by system in PDF - For now to include the quotation Done or Not (Tan)', 0, 0, '2017-02-22 10:28:18', '2017-02-22 10:28:18'),
(85, 1028, 10, NULL, 'Add New Client - S.O.P (Andy)', 0, 0, '2017-02-22 10:28:48', '2017-02-22 10:28:48'),
(86, 1028, 10, NULL, 'Invoice Button - Add new button Edit or Done (Tan)', 0, 0, '2017-02-22 10:29:49', '2017-02-22 10:29:49'),
(87, 1028, 10, NULL, 'Tracking On Job On Progress - Easy for trace (Tan)', 0, 0, '2017-02-22 10:30:15', '2017-02-22 10:30:15'),
(88, 1028, 10, NULL, 'Case Study  : 1) New Station (Andy) 2) Campaign with partners (All)  3) Replacement of banner - Tracing Done/Not (All)  4) Station Hardware -Hardware & Bulletin by products or by month (All)', 0, 0, '2017-02-22 10:31:03', '2017-02-22 10:35:38'),
(89, 1028, 4, NULL, 'Outdoor situation - can we have a way to just summarise all out door works, this task will be like a check list for them already. ', 0, 0, '2017-02-22 13:20:55', '2017-02-22 13:20:55'),
(90, 1029, 6, NULL, 'Install Euro 5 diesel POSM - banner, aboard x 1, leaflet x 1000, window poster x 1, pump topper x4', 0, 0, '2017-02-22 15:05:00', '2017-02-22 15:05:00'),
(91, 1024, 9, NULL, 'BHPetrol Ipoh Lumut Highway x 1 unit Hot Flush', 0, 1, '2017-02-23 01:54:24', '2017-02-28 04:17:04'),
(92, 1028, 6, NULL, 'Task to be insert with DO number upon Completion to proceed for invoice, Invoice must have remark to indicate which task invoice issued', 0, 0, '2017-02-23 03:32:39', '2017-02-23 03:35:35'),
(93, 1028, 6, NULL, 'Mobile web have difficulty to do selection, cannot be scroll down - Iphone 7', 0, 0, '2017-02-23 03:35:11', '2017-02-23 03:35:11'),
(94, 1030, 7, NULL, 'Follow up on payment RM5k ', 0, 0, '2017-02-23 03:53:02', '2017-02-23 03:53:02'),
(95, 1030, 7, NULL, 'Vip picture for proposal update', 0, 0, '2017-02-23 03:53:33', '2017-02-23 03:53:33'),
(96, 1024, 9, NULL, 'BHPetrol Jalan Pantai Baru - Safety Cones,10units ,Water bucket 4units ,Watering can 4units,No Parking Signage2units', 0, 1, '2017-02-23 07:14:16', '2017-02-28 04:16:59'),
(97, 1030, 4, NULL, '3D visual? ( Yes 3d visual too - Upon receving payment)', 0, 0, '2017-02-23 08:20:58', '2017-02-27 02:33:48'),
(98, 1028, 4, NULL, 'Finance - include invoice no and a brief description of the invoice', 0, 0, '2017-02-23 08:24:59', '2017-02-23 08:24:59'),
(99, 1031, 6, NULL, 'RAISE QUOTATION TO CLIENT', 0, 1, '2017-02-23 08:58:05', '2017-02-23 08:58:14'),
(100, 1031, 6, NULL, 'FABRICATION IN PROGRESS', 0, 1, '2017-02-23 08:58:53', '2017-02-23 08:59:01'),
(101, 1031, 6, NULL, 'SUPPLIER TO DELIVERED GOODS ON 22/2/2017', 0, 1, '2017-02-23 08:59:27', '2017-02-23 08:59:53'),
(102, 1031, 6, NULL, 'QUOTATION CONFIRM & PROCEED FOR INVOICE', 0, 1, '2017-02-23 09:00:12', '2017-03-10 14:07:01'),
(103, 1024, 6, NULL, 'BHPetrol Permas Jaya 2 x 1 unit chiller suction cup', 0, 1, '2017-02-23 09:11:14', '2017-02-28 04:19:45'),
(104, 1032, 6, NULL, 'RAISE QUOTATION TO CLIENT', 0, 1, '2017-02-23 09:32:34', '2017-02-23 09:33:22'),
(105, 1032, 6, NULL, 'FABRICATION IN PROGRESS', 0, 1, '2017-02-23 09:32:44', '2017-02-23 09:33:26'),
(106, 1032, 6, NULL, 'SUPPLIER TO DELIVERED GOODS 13/2/2017', 0, 1, '2017-02-23 09:32:59', '2017-02-23 09:33:31'),
(107, 1032, 6, NULL, 'QUOTATION CONFIRM & PROCEED FOR INVOICE', 0, 1, '2017-02-23 09:33:13', '2017-02-23 09:45:50'),
(108, 1008, 6, NULL, 'PROCEED FOR INVOICE', 0, 1, '2017-02-23 09:39:19', '2017-02-23 09:42:27'),
(109, 1008, 6, NULL, 'INVOICE HAND OVER TO ANDY ON 20/2/2017', 0, 1, '2017-02-23 09:48:32', '2017-02-23 11:30:41'),
(110, 1006, 4, NULL, 'Job Cancelled', 0, 1, '2017-02-23 11:35:22', '2017-02-23 11:35:29'),
(111, 1033, 13, NULL, 'DUAL PORT ( BLISTER ) - 100pcs', 0, 1, '2017-02-24 04:41:36', '2017-03-09 09:05:14'),
(112, 1033, 13, NULL, 'DUAL PORT ( NEW ) - 2,000pcs', 0, 1, '2017-02-24 04:41:59', '2017-03-09 09:05:23'),
(113, 1033, 13, NULL, 'MICRO USB CABLE - 2,300pcs', 0, 1, '2017-02-24 04:42:30', '2017-03-09 09:05:31'),
(114, 1033, 13, NULL, 'STEREO HEADSET ( NEW ) - 2,000pcs', 0, 1, '2017-02-24 04:43:15', '2017-03-17 14:46:24'),
(115, 1033, 13, NULL, 'WARRANTY STICKER - 5,000pcs', 0, 1, '2017-02-24 04:43:30', '2017-03-09 09:05:53'),
(116, 1033, 13, NULL, 'POWERBANK DUAL PORT IN CAR CHARGER - 500pcs (TBA)', 0, 0, '2017-02-24 04:44:11', '2017-02-24 04:44:11'),
(117, 1033, 13, NULL, 'USB POWER ADAPTER ( SPONGE ) - 1,000pcs (Replace Old Order)', 0, 0, '2017-02-24 04:50:05', '2017-02-24 04:50:05'),
(118, 1034, 6, NULL, 'Printing Complete', 0, 1, '2017-02-27 07:46:44', '2017-02-27 07:47:03'),
(119, 1034, 6, NULL, 'Raise Invoice', 0, 1, '2017-02-27 07:46:56', '2017-03-10 14:06:25'),
(120, 1035, 6, NULL, 'Raise Invoice', 0, 0, '2017-02-27 07:59:13', '2017-02-27 07:59:13'),
(121, 1028, 4, NULL, 'The last person amend must have their name there on the task or invoice', 0, 0, '2017-03-01 05:17:22', '2017-03-01 05:17:22'),
(122, 1011, 3, NULL, 'Line Blast 1st March', 0, 1, '2017-03-01 06:38:36', '2017-03-01 06:39:04'),
(123, 1036, 7, NULL, 'Follow up with punita on next meeting to discuss new campaign', 0, 0, '2017-03-01 09:36:08', '2017-03-01 09:36:08'),
(124, 1040, 6, NULL, 'Project Timeline', 0, 0, '2017-03-02 02:16:26', '2017-03-02 02:16:26'),
(125, 1040, 6, NULL, 'Type Of POSM - Banner, Pump topper, Tent Card, Process Flow, POS Display', 0, 0, '2017-03-02 02:16:29', '2017-03-02 02:22:10'),
(126, 1039, 6, NULL, 'Project Timeline', 0, 0, '2017-03-02 02:22:53', '2017-03-02 02:22:53'),
(127, 1039, 6, NULL, 'Type Of POSM - Banner, Pump topper, Tent Card, Process Flow, POS Display for proposal', 0, 0, '2017-03-02 02:22:59', '2017-03-02 02:23:38'),
(128, 1038, 6, NULL, 'Project timeline', 0, 1, '2017-03-02 02:25:15', '2017-03-10 14:08:03'),
(129, 1038, 6, NULL, 'RAISE QUOTATION TO CLIENT', 0, 1, '2017-03-02 02:25:29', '2017-03-10 14:08:06'),
(130, 1038, 6, NULL, 'Type Of POSM - Tent Card, Pump topper, Process Flow, Aboard, Window Poster - Artwork from Wizart', 0, 0, '2017-03-02 02:25:33', '2017-03-02 02:28:17'),
(131, 1038, 6, NULL, 'Back End System - Stock in & Stock Out Control', 0, 0, '2017-03-02 02:26:38', '2017-03-02 02:27:06'),
(132, 1038, 6, NULL, 'Total Updated Station List ', 0, 0, '2017-03-02 02:27:33', '2017-03-02 02:27:33'),
(133, 1039, 6, NULL, 'Back End System - Online Contest', 0, 0, '2017-03-02 02:28:47', '2017-03-02 02:28:47'),
(134, 1040, 6, NULL, 'Back End System - Online Contest', 0, 0, '2017-03-02 02:29:07', '2017-03-02 02:29:07'),
(135, 1040, 6, NULL, 'Quotation', 0, 0, '2017-03-02 02:29:13', '2017-03-02 02:29:13'),
(136, 1043, 9, NULL, 'Discuss for Monthly Report Profit & Lost - 11Street', 0, 0, '2017-03-02 09:11:41', '2017-03-02 09:11:41'),
(137, 1043, 9, NULL, 'Set Up Date For Monthly Meeting ', 0, 0, '2017-03-02 09:12:11', '2017-03-02 09:12:11'),
(138, 1043, 9, NULL, 'Discuss About 11Street Payment Problem Issues', 0, 0, '2017-03-02 09:13:50', '2017-03-02 09:14:33'),
(139, 1050, 9, NULL, 'BHPetrol Damansara Utama : Safety cones 4units, Water bucket 4units, Watering can 4units , NO Parking Signages 2units', 0, 1, '2017-03-06 01:46:22', '2017-03-08 01:31:39'),
(140, 1051, 9, NULL, 'Timeline for the Month of April (NIza)', 0, 1, '2017-03-06 01:48:48', '2017-03-13 03:22:57'),
(141, 1051, 9, NULL, 'Delivery Skynet Docket & Despatch Arrangement', 0, 0, '2017-03-06 01:49:39', '2017-03-06 01:49:39'),
(142, 1051, 9, NULL, 'Printing POSM, Upsell Box, Chiller Sticker , GE Gondola, Shelftalker, Chiller Suctiop Cup, Tent Card, Bulletin Manual', 0, 0, '2017-03-06 01:51:54', '2017-03-06 01:51:54'),
(143, 1054, 4, NULL, '1. POSM : leaflet, vouchers, banner and bunting.', 0, 1, '2017-03-06 09:36:50', '2017-03-16 12:10:25'),
(144, 1054, 4, NULL, '2. Design leaflet first with mechanics. Size A6', 0, 1, '2017-03-06 09:40:14', '2017-03-16 12:10:31'),
(145, 1054, 4, NULL, '3. Vouchers : cyclone voucher and Pieface vouchers with serial number. Size :  about the current pieface voucher size. Quantity : 500pcs for cyclone and 1500 for pieface', 0, 1, '2017-03-06 09:43:45', '2017-03-16 12:10:37'),
(146, 1054, 4, NULL, '4. Banner : Outdoor to measure', 0, 1, '2017-03-06 09:45:04', '2017-03-16 12:10:44'),
(147, 1054, 4, NULL, '5. Bunting : 2.5ft X 6ft X 10 pcs..this is to share with TnG spot. ', 0, 1, '2017-03-06 09:46:19', '2017-03-16 12:10:50'),
(148, 1054, 4, NULL, '6. All items must reach BHP kayu Ara station before 14/3/2017', 0, 1, '2017-03-06 09:52:36', '2017-03-16 12:10:19'),
(149, 1054, 4, NULL, '7. Invoice BHP..Andy to invoice', 0, 0, '2017-03-06 09:53:50', '2017-03-06 09:53:50'),
(150, 1050, 9, NULL, 'BHPetrol Jenjarom : Watering can 4units (27283)', 0, 1, '2017-03-07 02:25:53', '2017-03-10 09:24:28'),
(151, 1050, 9, NULL, 'BHPetrol Taman Sri Endah : Magnet GE Frame 8unit', 0, 0, '2017-03-07 02:52:49', '2017-03-07 02:52:49'),
(152, 1050, 9, NULL, 'BHPetrol Jalan Klang Lama 4 : Arctic Standee 2unit (27285)', 0, 1, '2017-03-07 06:25:10', '2017-03-15 04:18:43'),
(153, 1055, 4, NULL, '1. To change the CNY menu visual. only the MENU.', 0, 1, '2017-03-07 06:49:59', '2017-03-09 05:42:48'),
(154, 1055, 4, NULL, '2. Pixio to print PP hollow ', 0, 1, '2017-03-07 06:50:28', '2017-03-09 05:42:53'),
(156, 1055, 4, NULL, '3. Outdoor to deliver and install', 0, 1, '2017-03-07 06:52:16', '2017-03-10 03:59:57'),
(157, 1055, 4, NULL, '4. Invoice - Andy to speak to roger', 0, 0, '2017-03-07 06:54:04', '2017-03-07 06:54:04'),
(158, 1056, 4, NULL, '1. Tan to Design Visual ', 0, 1, '2017-03-07 06:58:21', '2017-03-09 09:05:21'),
(159, 1056, 4, NULL, '2. Nic to approve visual', 0, 1, '2017-03-07 06:58:38', '2017-03-09 09:05:27'),
(160, 1056, 4, NULL, '3. Print and Laminate X 10 sets ', 0, 1, '2017-03-07 06:59:33', '2017-03-09 13:09:26'),
(161, 1056, 4, NULL, '4. Deliver or Nic to collect - Andy to arrange with Nic', 0, 1, '2017-03-07 06:59:59', '2017-03-09 13:09:30'),
(162, 1056, 4, NULL, '5. invoice - Andy to discuss with Roger', 0, 0, '2017-03-07 07:00:19', '2017-03-07 07:00:19'),
(163, 1048, 7, NULL, 'To Update Sherly on empty space rack, once Tunetalk no longer selling at bhp', 0, 0, '2017-03-07 07:49:02', '2017-03-07 07:49:02'),
(165, 1047, 7, NULL, 'Follow up on the Vivani pasta from firefly', 0, 0, '2017-03-07 07:51:25', '2017-03-07 07:51:25'),
(166, 1049, 7, NULL, 'To Share costing for Sponsorship 50k', 0, 0, '2017-03-07 07:52:32', '2017-03-07 07:52:32'),
(167, 1037, 7, NULL, 'To revert back on voucher denomination 10,30 or 50 to be sold at lazada ', 0, 0, '2017-03-07 07:53:39', '2017-03-07 07:53:39'),
(168, 1041, 7, NULL, 'Follow up on Contact person from Huwei (Aaron)', 0, 0, '2017-03-07 07:54:51', '2017-03-07 07:54:51'),
(169, 1045, 7, NULL, 'Follow Up on Vivani pasta distribution with Ms. Farah ( Last spoken she will share the new price with Her C.E.O and get back )', 0, 0, '2017-03-07 07:57:20', '2017-03-07 07:57:20'),
(170, 1044, 7, NULL, 'Working on the new proposal and costing to share with SZE', 0, 0, '2017-03-07 07:58:23', '2017-03-07 07:58:23'),
(171, 1020, 7, NULL, 'Follow on Contract agreement with FireFly ( Spoke to Izra Her Legal dept will get back end week or following) ', 0, 0, '2017-03-07 08:00:43', '2017-03-07 08:00:43'),
(172, 1020, 7, NULL, 'FireFly Wants us to handle all PR Comunnication', 0, 0, '2017-03-07 08:01:31', '2017-03-07 08:01:31'),
(173, 1052, 9, NULL, 'BHPetrol Jalan Meru 2 - Arctic Standee 1unit (27292)', 0, 1, '2017-03-08 02:50:40', '2017-03-10 09:23:38'),
(174, 1052, 9, NULL, 'BHPetrol Jalan Kuari - Maggie Standee & 3in1 Nescafe 1unit (27286 & 03804)', 0, 1, '2017-03-08 02:52:11', '2017-03-15 04:17:57'),
(175, 1052, 9, NULL, 'BHPetrol Sg Ruan - Arctic Standee 1unit', 0, 0, '2017-03-08 02:52:27', '2017-03-08 02:53:01'),
(176, 1000, 7, NULL, 'Prepare Contract for chiller door advertising (signing by 17.3.2017)', 0, 0, '2017-03-08 03:02:57', '2017-03-14 08:38:54'),
(177, 1046, 4, NULL, 'Meeting with M Coupon 17th 10am at CMC office. terence to make sure the area is clean and fill the fridge with Drinks', 0, 0, '2017-03-09 04:50:02', '2017-03-09 04:50:02'),
(178, 1038, 4, NULL, 'Project to start by next week now checking with supplier', 0, 0, '2017-03-09 05:19:55', '2017-03-09 05:19:55'),
(179, 1038, 4, NULL, 'Klang Valley deliver next week if kokaa able too.', 0, 0, '2017-03-09 05:20:29', '2017-03-09 05:20:29'),
(180, 1038, 4, NULL, 'Aboard to deliver next week for klang valley after that nation wide. BT ask to do nationwide Aboard', 0, 0, '2017-03-09 05:21:21', '2017-03-09 05:21:21'),
(181, 1038, 4, NULL, 'Niza-to prepare total past project list by station', 0, 0, '2017-03-09 05:35:41', '2017-03-09 05:35:41'),
(182, 1038, 4, NULL, 'Exising Tissue box est 2,700 ctns to be distribute to highway station. Awaiting Mr Aziz/Pn Rohaila Instruction for School holiday period', 0, 0, '2017-03-09 05:40:10', '2017-03-10 14:10:17'),
(183, 1055, 4, NULL, '5. Outdoor to make sure to bring the T metal stand ', 0, 1, '2017-03-09 05:43:35', '2017-03-10 04:00:08'),
(184, 1055, 4, NULL, '6. Pixio printed on Sticker we changed it to sticker ', 0, 1, '2017-03-09 05:45:30', '2017-03-09 05:45:39'),
(185, 1057, 4, NULL, '1. To test pie at kayu Ara', 0, 1, '2017-03-09 13:10:26', '2017-03-16 12:07:04'),
(186, 1057, 4, NULL, '2. Pricing from Qban before 20/3/2017', 0, 1, '2017-03-09 13:13:26', '2017-03-16 12:06:59'),
(187, 1058, 4, NULL, '1. Daniel to lead on this project', 0, 1, '2017-03-09 13:25:18', '2017-03-16 11:51:04'),
(188, 1059, 4, NULL, '1. Tan to on Baba presentation', 0, 0, '2017-03-09 13:33:32', '2017-03-09 13:33:32'),
(189, 1060, 4, NULL, '1. A3 Menu for forecourt promoters', 0, 1, '2017-03-09 14:24:40', '2017-03-16 12:29:48'),
(190, 1060, 4, NULL, '2. Nic to approve visual by 22/3/2017', 0, 1, '2017-03-09 14:25:21', '2017-03-16 12:29:52'),
(191, 1060, 4, NULL, '3. Printing by 24/3/2017', 0, 1, '2017-03-09 14:27:26', '2017-03-16 12:29:56'),
(192, 1060, 4, NULL, '4. Delivery by 29/3/2017', 0, 1, '2017-03-09 14:27:40', '2017-03-16 12:30:06'),
(193, 1060, 4, NULL, '5. invoice - Andy to discuss with Roger', 0, 0, '2017-03-09 14:31:00', '2017-03-09 14:31:00'),
(194, 1061, 4, NULL, '1. Timeline by 14/3/2017', 0, 0, '2017-03-09 15:55:26', '2017-03-09 15:55:26'),
(195, 1061, 4, NULL, '2. Presentation mechanics by 14/3/2017', 0, 0, '2017-03-09 15:56:08', '2017-03-09 15:56:08'),
(196, 1061, 4, NULL, '3. All approval to proceed with other POSM by 16/3/2017', 0, 0, '2017-03-09 15:56:54', '2017-03-09 15:57:11'),
(197, 1061, 4, NULL, '4. All POSM for client approval by 21/3/2017', 0, 0, '2017-03-09 15:58:08', '2017-03-09 15:58:08'),
(198, 1061, 4, NULL, '5. FA approval by 24/3/2017', 0, 0, '2017-03-09 15:58:57', '2017-03-09 16:02:17'),
(199, 1061, 4, NULL, '6. Invoice - epay or digi by 1/4/2017', 0, 0, '2017-03-09 16:00:54', '2017-03-09 16:00:54'),
(200, 1061, 4, NULL, '7. POSM printing by 29/3/2017', 0, 0, '2017-03-09 16:02:08', '2017-03-09 16:02:08'),
(201, 1061, 4, NULL, '8. Delivery of POSM via courier or Outdoor start by 15/4/2017 ', 0, 0, '2017-03-09 16:03:55', '2017-03-09 16:03:55'),
(202, 1061, 4, NULL, '9. Invoice BHP', 0, 0, '2017-03-09 16:04:08', '2017-03-09 16:04:08'),
(203, 1028, 4, NULL, 'When Aaron open a JN he should be able to select PIC', 0, 0, '2017-03-09 16:05:53', '2017-03-09 16:05:53'),
(204, 1044, 4, NULL, 'Terence please look at JN I created and learn how to use the task area to improve your self', 0, 0, '2017-03-09 16:08:52', '2017-03-09 16:10:48'),
(205, 1062, 6, NULL, 'Client submitted reimbursement Report for Nescafe Tarik & Milo Stick', 0, 1, '2017-03-10 03:34:34', '2017-03-10 03:38:56'),
(206, 1062, 6, NULL, 'Raise Quotation & proceed for invoice', 0, 1, '2017-03-10 03:35:08', '2017-03-10 03:39:09'),
(207, 1063, 6, NULL, 'Client submitted reimbursement Report for Orangemania Tissue', 0, 1, '2017-03-10 03:37:58', '2017-03-10 03:39:30'),
(208, 1063, 6, NULL, 'Timeline for reimbursement to station', 0, 1, '2017-03-10 03:38:21', '2017-03-10 03:39:36'),
(209, 1062, 6, NULL, 'Timeline for reimbursement to station', 0, 1, '2017-03-10 03:38:34', '2017-03-10 03:38:49'),
(210, 1063, 6, NULL, 'Raise Quotation & proceed for invoice', 0, 1, '2017-03-10 03:39:58', '2017-03-10 03:40:36'),
(211, 1061, 4, NULL, 'Quotation by 15/3/2017', 0, 0, '2017-03-10 03:57:34', '2017-03-10 03:57:34'),
(212, 1052, 9, NULL, 'BHPetrol Jalan Pantai Baru - Chiller Suction Cup 1unit', 0, 0, '2017-03-10 04:23:08', '2017-03-10 04:23:08'),
(213, 1064, 6, NULL, 'Design (Tan) to design the artwork as per visual given. Visual Area : 3ft (W) x 4ft (H)', 0, 0, '2017-03-10 14:00:25', '2017-03-10 14:00:25'),
(214, 1064, 6, NULL, 'Outdoor (Ho) to Fabricate the Frame work', 0, 0, '2017-03-10 14:01:04', '2017-03-10 14:01:04'),
(215, 1064, 6, NULL, 'Mock up to present to client on 14/3/2017', 0, 0, '2017-03-10 14:01:26', '2017-03-10 14:01:26'),
(216, 1064, 6, NULL, 'Andy to raise quotation to client after the mock up presented', 0, 0, '2017-03-10 14:02:43', '2017-03-10 14:02:43'),
(217, 1064, 6, NULL, 'Andy to raise project timeline', 0, 0, '2017-03-10 14:03:13', '2017-03-10 14:03:13'),
(218, 1064, 6, NULL, 'Niza to prepare full station list for delivery', 0, 0, '2017-03-10 14:03:32', '2017-03-10 14:04:01'),
(219, 1034, 6, NULL, 'Sylog have collected back the Motorist Audit form due to error on 9/3/2017. Target to deliver back to CMC 5 working days', 0, 0, '2017-03-10 14:05:33', '2017-03-10 14:06:17'),
(220, 1031, 6, NULL, 'Awaiting Mr Velu for delivery date', 0, 0, '2017-03-10 14:07:26', '2017-03-10 14:07:26'),
(221, 1031, 6, NULL, 'Awaiting Mr Velu for delivery date', 0, 0, '2017-03-10 14:07:27', '2017-03-10 14:07:27'),
(222, 1038, 6, NULL, 'Andy to proposed tissue allocation station list for Pn Rohaila Approval. Subject to changes', 0, 0, '2017-03-10 14:11:24', '2017-03-10 14:11:24'),
(224, 1005, 4, NULL, '1. Daniel to lead on this project', 0, 0, '2017-03-11 05:37:24', '2017-03-11 05:37:24'),
(225, 1065, 4, NULL, '1. Daniel to lead on this project', 0, 0, '2017-03-11 05:41:17', '2017-03-11 05:41:17'),
(226, 1066, 4, NULL, '1. Daniel to covert GP presentation to Syngard ', 0, 1, '2017-03-11 05:56:55', '2017-03-16 12:07:52'),
(227, 1067, 6, NULL, 'Outdoor team to install banner, aboard, flagline, trading name, window poster, pump topper poster', 0, 1, '2017-03-13 03:19:05', '2017-03-20 01:31:37'),
(228, 1067, 6, NULL, 'Outdoor team to delivery All Shop Hardware ( Niza to prepare full list)', 0, 1, '2017-03-13 03:19:38', '2017-03-20 01:31:40'),
(229, 1067, 6, NULL, 'Outdoor team to delivery Amenities bin Hardware (Niza to prepare full list)', 0, 1, '2017-03-13 03:20:09', '2017-03-20 01:31:43'),
(230, 1033, 4, NULL, '4000mah power bank (New) 500pcs', 0, 0, '2017-03-13 08:09:24', '2017-03-13 08:09:24'),
(231, 1033, 4, NULL, 'new micro usb cable 2000pcs', 0, 0, '2017-03-13 08:10:50', '2017-03-13 08:10:50'),
(232, 1033, 4, NULL, 'micro usb cable with led 2000pcs', 0, 0, '2017-03-13 08:11:33', '2017-03-13 08:11:33'),
(233, 1033, 4, NULL, 'New C cable 2000pcs', 0, 0, '2017-03-13 08:11:53', '2017-03-13 08:11:53'),
(234, 1056, 4, NULL, '6. Wrong pricing for combo coffee need to do sticker RM7.50 to RM10', 0, 1, '2017-03-13 12:38:57', '2017-03-16 12:32:28'),
(235, 1053, 4, NULL, '1. Monthly stock check in Van', 0, 0, '2017-03-13 12:40:30', '2017-03-13 12:40:30'),
(236, 1053, 4, NULL, '2. Reduce will only have RAW material at store, we will monitor raw material', 0, 0, '2017-03-13 12:41:02', '2017-03-13 12:41:02'),
(237, 1052, 9, NULL, 'BHPetrol Sg Plong - GE Frame 4unit, Upsell Box 1unit, Sweet Container 1unit, Straw Dispenser 1unit, Chiller Suction Cup 1unit, GE Chiller POSM ( Tropicana Twister & Pepsi) 1unit, Artic Rack 1unit, Artic Chiller Decal POSM 1unit, Angle Rizer 2unit, Maggi Rack Standee & Hot Water Flask 1unit', 0, 0, '2017-03-14 10:26:26', '2017-03-14 10:26:26'),
(238, 1052, 9, NULL, 'BHPetrol Ks-Rawang - BHPetrol Sg Plong - GE Frame 4unit, Upsell Box 1unit, Sweet Container 1unit, Straw Dispenser 1unit, Chiller Suction Cup 1unit, GE Chiller POSM ( Tropicana Twister & Pepsi) 1unit, Artic Rack 1unit, Artic Chiller Decal POSM 1unit, Angle Rizer 2unit, Maggi Rack Standee & Hot Water Flask 1unit', 0, 0, '2017-03-14 10:26:44', '2017-03-14 10:26:44'),
(240, 1050, 9, NULL, 'BHPetrol Jalan Subang Utama - Watering Can 5unit', 0, 0, '2017-03-15 03:42:04', '2017-03-15 03:42:04'),
(241, 1058, 4, NULL, '2. Client KIV the project', 0, 0, '2017-03-16 11:50:35', '2017-03-16 11:50:57'),
(242, 1065, 4, NULL, '2. Presented to Justin waiting for feedback', 0, 0, '2017-03-16 11:52:14', '2017-03-16 11:52:14'),
(243, 1005, 4, NULL, '2. Presented to justin waiting for feedback', 0, 0, '2017-03-16 11:52:59', '2017-03-16 11:52:59'),
(244, 1072, 4, NULL, 'Timeline ', 0, 0, '2017-03-16 11:55:55', '2017-03-16 11:55:55'),
(245, 1072, 4, NULL, 'Mechanics / presentation 20/3/17', 0, 0, '2017-03-16 11:57:09', '2017-03-16 11:57:45'),
(246, 1072, 4, NULL, 'Quotation by 24/3/17', 0, 0, '2017-03-16 11:58:09', '2017-03-16 11:58:09'),
(247, 1072, 4, NULL, 'Andy/BHP to look for partners by 10/4/17', 0, 0, '2017-03-16 11:59:09', '2017-03-16 11:59:09'),
(248, 1072, 4, NULL, 'Creative to do POSM and back end reimbursement  ', 0, 0, '2017-03-16 11:59:45', '2017-03-16 11:59:45'),
(249, 1072, 4, NULL, 'Outdoo/Indoor delivery of POSM before 5/7/17', 0, 0, '2017-03-16 12:00:44', '2017-03-16 12:00:44'),
(250, 1072, 4, NULL, 'Invoice by Andy', 0, 0, '2017-03-16 12:01:15', '2017-03-16 12:01:15'),
(251, 1073, 4, NULL, '1. Timeline to digi by 20/3/17', 0, 0, '2017-03-16 12:03:01', '2017-03-16 12:03:01'),
(252, 1073, 4, NULL, '2. Mechanics/presentation by 20/3/17', 0, 0, '2017-03-16 12:04:14', '2017-03-16 12:04:14'),
(253, 1073, 4, NULL, '3. Quotation', 0, 0, '2017-03-16 12:04:41', '2017-03-16 12:04:41'),
(254, 1073, 4, NULL, '4. Invoice to DIGI by Terence', 0, 0, '2017-03-16 12:04:57', '2017-03-16 12:04:57'),
(255, 1073, 4, NULL, '5. Terence to prepare all partners visuals for DIGI', 0, 0, '2017-03-16 12:05:35', '2017-03-16 12:05:35'),
(256, 1057, 4, NULL, '3. Qban to Quote cafe', 0, 0, '2017-03-16 12:06:52', '2017-03-16 12:06:52'),
(257, 1066, 4, NULL, '2. Presentation ready 16/3/2017', 0, 0, '2017-03-16 12:07:47', '2017-03-16 12:07:47'),
(258, 1066, 4, NULL, '3. To set appointment with Terry', 0, 0, '2017-03-16 12:08:16', '2017-03-16 12:08:16'),
(259, 1054, 4, NULL, '8. Items to invoice Tent card, Aboard, Cyclone Vouchers X 60 pcs, Stamp chop.', 0, 0, '2017-03-16 12:10:13', '2017-03-16 12:16:27'),
(260, 1054, 4, NULL, '9. Outdoor to fix Aboard and another 100 Cyclone Vouchers by 17/3/17', 0, 0, '2017-03-16 12:15:46', '2017-03-16 12:18:27'),
(261, 1060, 4, NULL, '6. Printed 12pcs A3 with lamination', 0, 1, '2017-03-16 12:30:45', '2017-03-16 12:30:50'),
(262, 1060, 4, NULL, 'ANDY PLEASE IGNORE THIS. NEVER DO AT ALL MISTAKEN WITH FORECOURT MENU', 0, 0, '2017-03-16 12:33:24', '2017-03-16 12:33:24'),
(263, 1074, 4, NULL, '1. To design Bunting and Banner for T&G Spot and PIeface by 23/3/17', 0, 0, '2017-03-16 12:43:41', '2017-03-16 12:43:41'),
(264, 1074, 4, NULL, '2. Bunting size 2.5ft(W) X 6ft(H) X 12 pcs ', 0, 0, '2017-03-16 12:45:01', '2017-03-16 12:45:50'),
(265, 1074, 4, NULL, '3. Banner size 3ft(H) X 19ft (L) X 1pc', 0, 0, '2017-03-16 12:46:27', '2017-03-16 12:46:27'),
(266, 1074, 4, NULL, '4. Roger to approve visual with Quotation', 0, 0, '2017-03-16 12:46:49', '2017-03-16 12:46:49'),
(267, 1074, 4, NULL, '5. Printing by 24/3/17', 0, 0, '2017-03-16 12:49:03', '2017-03-16 12:49:03'),
(268, 1074, 4, NULL, '6. Installation 27/3/17', 0, 0, '2017-03-16 12:49:25', '2017-03-16 12:49:25'),
(269, 1074, 4, NULL, '7. Invoice - Andy to discuss with Roger', 0, 0, '2017-03-16 12:50:00', '2017-03-16 12:50:00'),
(270, 1037, 4, NULL, 'Cmap Contract to be sign by CMC', 0, 0, '2017-03-16 12:51:43', '2017-03-16 12:51:43'),
(271, 1037, 4, NULL, 'Cooprate Sales Only', 0, 0, '2017-03-16 12:52:16', '2017-03-16 12:52:16'),
(272, 1073, 4, NULL, '6. Punita to send their mechanics ', 0, 0, '2017-03-17 05:48:12', '2017-03-17 05:48:12'),
(273, 1071, 6, NULL, 'Delivery order done, raise invoice (Andy)', 0, 1, '2017-03-20 01:30:11', '2017-03-20 01:30:20'),
(274, 1068, 6, 6, 'Please put on hold, project must be extended - Client to advise', 0, 0, '2017-03-20 01:31:11', '2017-03-20 01:31:24'),
(275, 1067, 6, NULL, 'Process for invoice', 0, 0, '2017-03-20 01:31:55', '2017-03-20 01:31:55'),
(276, 1075, 6, NULL, 'To Contact RMZ city supplier', 0, 0, '2017-03-20 01:35:19', '2017-03-20 01:35:19'),
(277, 1027, 1, 1, 'Test task', 0, 0, '2017-03-20 04:38:17', '2017-03-20 05:09:12');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `clients`
--
ALTER TABLE `clients`
  ADD CONSTRAINT `clients_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `company_user`
--
ALTER TABLE `company_user`
  ADD CONSTRAINT `company_user_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `company_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `invoices`
--
ALTER TABLE `invoices`
  ADD CONSTRAINT `invoices_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `invoices_job_id_foreign` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `jobs`
--
ALTER TABLE `jobs`
  ADD CONSTRAINT `jobs_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  ADD CONSTRAINT `jobs_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`),
  ADD CONSTRAINT `jobs_pic_foreign` FOREIGN KEY (`pic`) REFERENCES `users` (`id`);

--
-- Constraints for table `job_user`
--
ALTER TABLE `job_user`
  ADD CONSTRAINT `job_user_job_id_foreign` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `job_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tasks`
--
ALTER TABLE `tasks`
  ADD CONSTRAINT `tasks_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `tasks_job_id_foreign` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tasks_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);

