-- --------------------------------------------------------
-- Server OS:                    Win32
-- HeidiSQL Version:             10.2.0.5684
-- --------------------------------------------------------


-- Dumping structure for table crm3.crm3_activity
CREATE TABLE IF NOT EXISTS `crm3_activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_person` int(11) NOT NULL DEFAULT '0',
  `id_module` int(11) NOT NULL DEFAULT '0',
  `id_activity_type` int(11) NOT NULL DEFAULT '1',
  `id_user` int(6) NOT NULL DEFAULT '0',
  `related_id_object` int(9) NOT NULL DEFAULT '0',
  `reldated_id_module` int(9) NOT NULL DEFAULT '0',
  `event` int(1) NOT NULL DEFAULT '0',
  `due_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `closed_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `closed` int(2) NOT NULL DEFAULT '0',
  `subject` varchar(250) NOT NULL DEFAULT '',
  `start_date` date NOT NULL DEFAULT '2020-01-01',
  `start_time` time NOT NULL DEFAULT '00:00:00',
  `end_date` date NOT NULL DEFAULT '2020-01-01',
  `end_time` time NOT NULL DEFAULT '00:00:00',
  `id_priority` int(3) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `log` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=482 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_activity: ~17 rows (approximately)
INSERT INTO `crm3_activity` (`id`, `id_person`, `id_module`, `id_activity_type`, `id_user`, `related_id_object`, `reldated_id_module`, `event`, `due_date`, `closed_date`, `closed`, `subject`, `start_date`, `start_time`, `end_date`, `end_time`, `id_priority`, `description`, `log`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(462, 1029, 200, 400, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'test', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, 'note 1', '', 1, 1, '2020-01-23 17:26:56', 7, '2020-01-23 17:26:56', 0),
	(463, 1029, 200, 400, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'tes', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '123', '', 1, 1, '2020-01-23 17:28:34', 7, '2020-01-23 17:28:34', 0),
	(464, 1029, 200, 400, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'test', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '123123', '', 1, 1, '2020-01-23 17:29:06', 7, '2020-01-23 17:29:06', 0),
	(465, 1029, 200, 400, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'test', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '', '', 1, 1, '2020-01-23 17:29:37', 7, '2020-01-23 17:29:37', 0),
	(466, 1029, 200, 400, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'test', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, 'setset', '', 1, 1, '2020-01-23 17:30:37', 7, '2020-01-23 17:30:37', 0),
	(467, 1029, 200, 1, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 0, 'test 1', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '123', '', 1, 0, '2020-01-23 17:37:32', 7, '2020-01-23 23:38:43', 7),
	(468, 1029, 200, 1, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'New Product Presentation on the spot', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, 'we need more team to do this task, we have to presentation as soon as possible, before our competitor is coming', '', 1, 1, '2020-01-23 17:41:30', 7, '2020-01-23 23:55:45', 7),
	(469, 1029, 200, 1, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 0, 'test333', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '', '', 1, 0, '2020-01-23 17:48:38', 7, '2020-01-23 23:38:44', 7),
	(470, 1029, 200, 1, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 0, 'test 23', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '', '', 1, 0, '2020-01-23 17:49:12', 7, '2020-01-23 23:38:44', 7),
	(471, 1029, 200, 1, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'asfsdfsdf', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '', '', 1, 1, '2020-01-23 17:49:36', 7, '2020-01-23 23:55:41', 7),
	(472, 1029, 200, 1, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'agagagaga', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '', '', 1, 1, '2020-01-23 17:51:47', 7, '2020-01-23 23:55:39', 7),
	(473, 1029, 200, 1, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 0, '2234234', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '', '', 1, 1, '2020-01-23 17:52:44', 7, '2020-01-23 17:52:44', 0),
	(474, 1029, 200, 100, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, '234234', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '234234', '', 1, 1, '2020-01-23 17:52:58', 7, '2020-01-23 17:52:58', 0),
	(475, 1029, 200, 1, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 0, '123123123', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '', '', 1, 1, '2020-01-23 17:53:44', 7, '2020-01-23 17:53:44', 0),
	(476, 1029, 200, 1, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 0, '1', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '', '', 1, 0, '2020-01-23 17:53:48', 7, '2020-01-23 23:38:38', 7),
	(477, 1029, 200, 400, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, '1112323', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '', '', 1, 1, '2020-01-23 17:54:03', 7, '2020-01-23 17:54:03', 0),
	(478, 1029, 200, 400, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'a', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, '', '', 1, 1, '2020-01-23 17:54:09', 7, '2020-01-23 17:54:09', 0),
	(479, 1029, 200, 1, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 0, 'takut mencre', '2020-01-23', '00:00:00', '2020-01-23', '00:00:00', 0, 'takut mencre', 'Created by 7', 1, 0, '2020-01-23 18:25:30', 7, '2020-01-23 23:38:37', 7),
	(480, 21, 300, 400, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'Gibbi All song', '2020-01-27', '00:00:00', '2020-01-27', '00:00:00', 0, 'To all the people that are thankful for this music video. Thank you, but all is thanks to the composers Studio Ghibli. If you can and want to support them by one way or another - do it.', 'Created by 7', 1, 1, '2020-01-27 13:47:46', 7, '2020-01-27 13:47:46', 0),
	(481, 26, 300, 100, 7, 0, 0, 0, '2020-01-01 00:00:00', '2020-01-01 00:00:00', 1, 'call dengan client', '2020-01-27', '00:00:00', '2020-01-27', '00:00:00', 0, '', 'Created by 7', 1, 1, '2020-01-27 15:45:13', 7, '2020-01-27 15:45:13', 0);

-- Dumping structure for table crm3.crm3_activity_detail
CREATE TABLE IF NOT EXISTS `crm3_activity_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_activity` int(11) NOT NULL DEFAULT '0',
  `id_activity_type` int(11) NOT NULL DEFAULT '1',
  `id_user` int(6) NOT NULL DEFAULT '0',
  `id_company` int(6) NOT NULL DEFAULT '0',
  `id_opportunity` int(9) NOT NULL DEFAULT '0',
  `event` int(1) NOT NULL DEFAULT '0',
  `due_date` date NOT NULL DEFAULT '2019-01-01',
  `closed_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `closed` int(2) NOT NULL DEFAULT '0',
  `subject` varchar(250) NOT NULL DEFAULT '',
  `from_date` date NOT NULL DEFAULT '2019-01-01',
  `from_time` time NOT NULL DEFAULT '00:00:00',
  `to_date` date NOT NULL DEFAULT '2019-01-01',
  `to_time` time NOT NULL DEFAULT '00:00:00',
  `id_priority` int(3) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  `log` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=426 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_activity_detail: ~6 rows (approximately)
INSERT INTO `crm3_activity_detail` (`id`, `id_activity`, `id_activity_type`, `id_user`, `id_company`, `id_opportunity`, `event`, `due_date`, `closed_date`, `closed`, `subject`, `from_date`, `from_time`, `to_date`, `to_time`, `id_priority`, `comment`, `log`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(419, 213, 1001, 0, 93, 102, 0, '2019-01-01', '2019-01-01 00:00:00', 1, '', '2019-01-01', '00:00:00', '2019-01-01', '00:00:00', 10, '', 'Update Quote <span class=\'h100\'>000007</span> to <span class=\'h101\'>Review</span>', 1, 1, '2020-01-14 11:10:44', 7, '2020-01-14 11:10:44', 7),
	(420, 213, 1001, 0, 93, 102, 0, '2019-01-01', '2019-01-01 00:00:00', 1, '', '2019-01-01', '00:00:00', '2019-01-01', '00:00:00', 10, '', 'Update Quote <span class=\'h100\'>000007</span> to <span class=\'h101\'>Rejected</span>', 1, 1, '2020-01-14 11:10:45', 7, '2020-01-14 11:10:45', 7),
	(421, 213, 1001, 0, 93, 102, 0, '2019-01-01', '2019-01-01 00:00:00', 1, '', '2019-01-01', '00:00:00', '2019-01-01', '00:00:00', 10, '', 'Update Quote <span class=\'h100\'>000007</span> to <span class=\'h101\'>Draft</span>', 1, 1, '2020-01-14 11:10:47', 7, '2020-01-14 11:10:47', 7),
	(422, 213, 1, 0, 93, 102, 0, '2019-01-01', '2019-01-01 00:00:00', 1, '', '2019-01-01', '00:00:00', '2019-01-01', '00:00:00', 10, '', 'Update Quote <span class=\'h100\'>000007</span> to <span class=\'h101\'>Review</span>', 1, 1, '2020-01-14 11:10:48', 7, '2020-01-14 11:10:48', 7),
	(423, 213, 1, 0, 93, 102, 0, '2019-01-01', '2019-01-01 00:00:00', 1, '', '2019-01-01', '00:00:00', '2019-01-01', '00:00:00', 10, '', 'Update Quote <span class=\'h100\'>000007</span> to <span class=\'h101\'>Rejected</span>', 1, 1, '2020-01-14 11:18:42', 7, '2020-01-14 11:18:42', 7),
	(424, 213, 1, 0, 93, 102, 0, '2019-01-01', '2019-01-01 00:00:00', 1, '', '2019-01-01', '00:00:00', '2019-01-01', '00:00:00', 10, '', 'Update Quote <span class=\'h100\'>000007</span> to <span class=\'h101\'>Rejected</span>', 1, 1, '2020-01-14 12:17:24', 7, '2020-01-14 12:17:24', 7),
	(425, 216, 1, 1, 0, 0, 0, '2020-01-24', '2020-01-22 00:04:46', 0, 'meeting dengan orang baru', '2019-01-01', '00:00:00', '2019-01-01', '00:00:00', 1, 'bagiaman', '', 1, 1, '2020-01-22 00:04:46', 7, '2020-01-22 00:04:46', 0);

-- Dumping structure for table crm3.crm3_activity_priority
CREATE TABLE IF NOT EXISTS `crm3_activity_priority` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `value` int(11) NOT NULL DEFAULT '0',
  `color` varchar(50) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=301 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_activity_priority: ~4 rows (approximately)
INSERT INTO `crm3_activity_priority` (`id`, `name`, `value`, `color`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'Low', 0, 'light', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(10, 'Normal', 10, 'success', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(150, 'High', 80, 'warning', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(300, 'Urgent', 90, 'danger', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_activity_type
CREATE TABLE IF NOT EXISTS `crm3_activity_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `fas` varchar(50) NOT NULL DEFAULT '',
  `auto_closed` int(1) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1002 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_activity_type: ~6 rows (approximately)
INSERT INTO `crm3_activity_type` (`id`, `name`, `fas`, `auto_closed`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'Task', '<i class="far fa-check-square"></i>', 0, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(100, 'Log a Call', '<i class="fas fa-phone"></i>', 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(200, 'Visit', '<i class="far fa-check-square"></i>', 0, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(300, 'Event', '<i class="fas fa-street-view"></i>', 0, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(400, 'Note', '<i class="far fa-sticky-note"></i>', 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(1001, 'Log', '<i class="far fa-clipboard"></i>', 1, 0, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_activity_x
CREATE TABLE IF NOT EXISTS `crm3_activity_x` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_lead` int(6) NOT NULL DEFAULT '0',
  `id_contact` int(6) NOT NULL DEFAULT '0',
  `id_company` int(6) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_activity_x: ~13 rows (approximately)
INSERT INTO `crm3_activity_x` (`id`, `id_lead`, `id_contact`, `id_company`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(21, 102, 0, 0, 1, 1, '2019-07-22 15:05:52', 1, '2019-07-22 15:05:52', 0),
	(23, 1018, 28, 130, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(201, 1023, 0, 0, 1, 1, '2019-07-22 18:23:02', 1, '2019-07-22 18:23:02', 0),
	(202, 1025, 0, 0, 1, 1, '2019-07-23 18:39:31', 1, '2019-07-23 18:39:31', 0),
	(203, 0, 21, 1, 1, 1, '2019-07-25 16:00:06', 1, '2019-07-25 16:00:06', 0),
	(204, 1027, 0, 0, 1, 1, '2019-07-25 16:51:20', 1, '2019-07-25 16:51:20', 0),
	(208, 0, 27, 76, 1, 1, '2019-07-25 17:26:46', 1, '2019-07-25 17:28:31', 1),
	(209, 0, 43, 76, 1, 1, '2019-07-25 17:43:55', 1, '2019-07-25 17:43:55', 0),
	(210, 0, 41, 76, 1, 1, '2019-07-25 17:49:38', 1, '2019-07-25 17:49:38', 0),
	(211, 0, 42, 76, 1, 1, '2019-07-25 17:49:42', 1, '2019-07-25 17:49:42', 0),
	(212, 0, 25, 129, 1, 1, '2019-07-26 12:02:30', 1, '2019-07-26 12:02:30', 0),
	(213, 0, 26, 93, 1, 1, '2019-07-26 16:16:24', 1, '2019-07-26 16:16:24', 0),
	(214, 0, 22, 1, 1, 1, '2019-07-26 18:04:30', 1, '2019-07-26 18:04:30', 0),
	(215, 0, 30, 1, 1, 1, '2019-07-26 18:04:35', 1, '2019-07-26 18:04:35', 0),
	(216, 1029, 0, 0, 1, 1, '2020-01-22 00:04:46', 7, '2020-01-22 00:04:46', 0);

-- Dumping structure for table crm3.crm3_attachment
CREATE TABLE IF NOT EXISTS `crm3_attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) NOT NULL DEFAULT '',
  `id_module` int(9) NOT NULL DEFAULT '0',
  `full_path` text NOT NULL,
  `url` text NOT NULL,
  `file_name` varchar(250) NOT NULL DEFAULT '',
  `file_size` varchar(250) NOT NULL DEFAULT '',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `input_by` int(9) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `update_by` int(9) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_attachment: ~4 rows (approximately)
INSERT INTO `crm3_attachment` (`id`, `module`, `id_module`, `full_path`, `url`, `file_name`, `file_size`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(16, 'quote', 6, 'C:/xampp/htdocs/application/crm3-ng8/api-v1/upload/7/JW2_Daniella-Rugged-Cement_1416.jpg', './upload/7/JW2_Daniella-Rugged-Cement_1416.jpg', 'JW2_Daniella-Rugged-Cement_1416.jpg', '220.15', 1, '2020-01-15 16:24:38', 7, '2020-01-15 16:24:38', 0),
	(17, 'quote', 6, 'C:/xampp/htdocs/application/crm3-ng8/api-v1/upload/7/JW2_Daniella-Rugged-Cement_14161.jpg', './upload/7/JW2_Daniella-Rugged-Cement_14161.jpg', 'JW2_Daniella-Rugged-Cement_14161.jpg', '220.15', 0, '2020-01-15 16:37:34', 7, '2020-01-15 16:45:10', 7),
	(18, 'quote', 6, 'C:/xampp/htdocs/application/crm3-ng8/api-v1/upload/7/JW2_Daniella-Rugged-Cement_14162.jpg', './upload/7/JW2_Daniella-Rugged-Cement_14162.jpg', 'JW2_Daniella-Rugged-Cement_14162.jpg', '220.15', 0, '2020-01-15 16:37:50', 7, '2020-01-15 16:45:09', 7),
	(19, 'quote', 6, 'C:/xampp/htdocs/application/crm3-ng8/api-v1/upload/7/JW2_Daniella-Rugged-Cement_14163.jpg', './upload/7/JW2_Daniella-Rugged-Cement_14163.jpg', 'JW2_Daniella-Rugged-Cement_14163.jpg', '220.15', 0, '2020-01-15 16:38:21', 7, '2020-01-15 16:45:09', 7),
	(20, 'quote', 6, 'C:/xampp/htdocs/application/crm3-ng8/api-v1/upload/7/JW2_Daniella-Rugged-Cement_14164.jpg', './upload/7/JW2_Daniella-Rugged-Cement_14164.jpg', 'JW2_Daniella-Rugged-Cement_14164.jpg', '220.15', 0, '2020-01-15 16:40:11', 7, '2020-01-15 16:45:08', 7);

-- Dumping structure for table crm3.crm3_branch
CREATE TABLE IF NOT EXISTS `crm3_branch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_company` int(11) NOT NULL DEFAULT '0',
  `name` varchar(250) NOT NULL DEFAULT '',
  `code` varchar(250) NOT NULL DEFAULT '',
  `email` varchar(250) NOT NULL DEFAULT '',
  `phone` varchar(250) NOT NULL DEFAULT '',
  `fax` varchar(250) NOT NULL DEFAULT '',
  `id_branch_status` int(2) NOT NULL DEFAULT '1',
  `address_street` varchar(250) NOT NULL DEFAULT '',
  `address_city` varchar(250) NOT NULL DEFAULT '',
  `address_state` varchar(250) NOT NULL DEFAULT '',
  `address_code` varchar(6) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_branch: ~6 rows (approximately)
INSERT INTO `crm3_branch` (`id`, `id_company`, `name`, `code`, `email`, `phone`, `fax`, `id_branch_status`, `address_street`, `address_city`, `address_state`, `address_code`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(6, 119, 'sdfasdf', '', '', '2342341234', '', 1, '', '', '', '', 1, 1, '2019-07-16 18:41:53', 1, '2019-07-16 18:41:53', 0),
	(7, 119, 'sdfasdf', '', '', '123123123', '', 1, '', '', '', '', 1, 1, '2019-07-16 18:45:36', 1, '2019-07-16 18:45:36', 0),
	(8, 119, 'r33434343', '', '', '56456', '', 1, '', '', '', '', 1, 1, '2019-07-16 18:57:01', 1, '2019-07-16 18:57:01', 0),
	(9, 119, 'sdfasdf', '', '', '7777', '', 1, '', '', '', '', 1, 1, '2019-07-16 18:57:36', 1, '2019-07-16 18:57:36', 0),
	(10, 119, '345345', '', '', '653324234', '', 1, '', '', '', '', 1, 1, '2019-07-16 18:58:01', 1, '2019-07-16 18:58:01', 0),
	(11, 119, '1', '2', '4', '3', '', 1, '5', '6', '', '8', 1, 1, '2019-07-16 19:07:16', 1, '2019-07-16 19:07:16', 0);

-- Dumping structure for table crm3.crm3_branch_status
CREATE TABLE IF NOT EXISTS `crm3_branch_status` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_branch_status: ~2 rows (approximately)
INSERT INTO `crm3_branch_status` (`id`, `name`) VALUES
	(1, 'Active'),
	(100, 'Non Active');

-- Dumping structure for table crm3.crm3_company
CREATE TABLE IF NOT EXISTS `crm3_company` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_company_class` int(3) NOT NULL DEFAULT '0',
  `id_user` int(11) NOT NULL DEFAULT '0',
  `name` varchar(250) NOT NULL DEFAULT '',
  `website` varchar(250) NOT NULL DEFAULT '',
  `email` varchar(250) NOT NULL DEFAULT '',
  `phone` varchar(250) NOT NULL DEFAULT '',
  `fax` varchar(250) NOT NULL DEFAULT '',
  `id_industry` int(4) NOT NULL DEFAULT '0',
  `bill_name` varchar(250) NOT NULL DEFAULT '',
  `bill_street1` text NOT NULL,
  `bill_street2` varchar(250) NOT NULL DEFAULT '',
  `bill_city` varchar(250) NOT NULL DEFAULT '',
  `bill_state` varchar(250) NOT NULL DEFAULT '',
  `bill_code` varchar(250) NOT NULL DEFAULT '',
  `bill_country` varchar(250) NOT NULL DEFAULT '',
  `ship_name` varchar(250) NOT NULL DEFAULT '',
  `ship_street1` varchar(250) NOT NULL DEFAULT '',
  `ship_street2` varchar(250) NOT NULL DEFAULT '',
  `ship_city` varchar(250) NOT NULL DEFAULT '',
  `ship_state` varchar(250) NOT NULL DEFAULT '',
  `ship_code` varchar(250) NOT NULL DEFAULT '',
  `ship_country` varchar(250) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_company: ~37 rows (approximately)
INSERT INTO `crm3_company` (`id`, `id_company_class`, `id_user`, `name`, `website`, `email`, `phone`, `fax`, `id_industry`, `bill_name`, `bill_street1`, `bill_street2`, `bill_city`, `bill_state`, `bill_code`, `bill_country`, `ship_name`, `ship_street1`, `ship_street2`, `ship_city`, `ship_state`, `ship_code`, `ship_country`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 3, 1, 'Alexandra Abigail', '1', 'felix@cuvox.de', '8077666665', '123123123', 6, '', 'aa', 'aa', 'Bangka Barat', 'Bangka Belitung', '11160', 'b4', '', 'aa', '', 'c1', 'c3', 'c2', 'c4', 1, 1, '2019-01-01 00:00:00', 0, '2020-02-05 16:27:31', 7),
	(3, 0, 0, 'Ubisoft', 'Ubisoft.com', '', '', '', 6, '', 'a', '', 'b', 'c', '123456', '', '', '', '', '', '', '', '', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(5, 0, 0, 'SEGA Interactive R&D Division 2', 'sage.com', '', '', '', 6, '', 'a', '', 'b', 'c', '123456', '', '', '', '', '', '', '', '', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(8, 0, 0, 'Tencent', 'Tencent.com', '', '', '', 6, '', 'a', '', 'b', 'c', '123456', '', '', '', '', '', '', '', '', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(11, 2, 0, 'Konami', 'Konami.com', '', '', '', 6, '', 'a', 'a', 'b', 'c', '123456', '', '', '', '', '', '', '', '', 1, 1, '2019-01-01 00:00:00', 0, '2020-02-05 18:22:15', 7),
	(23, 0, 0, 'Codemasters', 'Codemasters.com', '', '', '', 6, '', 'a', '', 'b', 'c', '123456', '', '', '', '', '', '', '', '', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(35, 0, 0, 'Capcom Vancouver', 'Capcom Vancouver.oj', '', '', '', 6, '', 'a', '', 'b', 'c', '123456', '', '', '', '', '', '', '', '', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(43, 0, 0, 'Xbox Game Studios', 'xbox.com', '', '', '', 6, '', 'a', '', 'b', 'c', '123456', '', '', '', '', '', '', '', '', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(76, 0, 0, 'Cygames', 'Cygames.com', '', '', '', 6, '', 'a', '', 'b', 'c', '123456', '', '', '', '', '', '', '', '', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(93, 2, 0, 'Gameloft', 'Gameloft.com', 'email@yaho.com', '123', '7776', 6, '', 'a', 'a', '1', '2', '3', '4', '', 'b', '', 'a', 'b', 'c', 'd', 1, 1, '2019-01-01 00:00:00', 0, '2020-02-05 18:57:58', 7),
	(105, 0, 0, 'Pure Mature 1', 'mature.com.jp', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 1, '2019-07-14 17:22:05', 1, '2019-07-14 17:28:13', 1),
	(106, 0, 0, 'Alexandra Abigail', 'nanana.com', 'felix@cuvox.de', '8077666665', '4241234134', 0, '', 'graha bernadette building, jl. claire selatan ii/4, jakarta barat 11160, indonesia', '', 'Bangka Barat', 'Bangka Belitung', '11160', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:24:59', 1, '2019-07-15 16:24:59', 0),
	(107, 0, 0, 'Alexandra Abigail 2', 'hohoho', 'felix@cuvox.de', '8077666665', '77777', 0, '', 'graha bernadette building, jl. claire selatan ii/4, jakarta barat 11160, indonesia', '', 'Bangka Barat', 'Bangka Belitung', '11160', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:25:20', 1, '2019-07-15 16:25:20', 0),
	(108, 0, 0, 'Alexandra Abigail 2', 'hohoho', 'felix@cuvox.de', '8077666665', '77777', 0, '', 'graha bernadette building, jl. claire selatan ii/4, jakarta barat 11160, indonesia', '', 'Bangka Barat', 'Bangka Belitung', '11160', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:25:20', 1, '2019-07-15 16:25:20', 0),
	(109, 0, 0, 'Alexandra Abigail 4', '', 'felix@cuvox.de', '8077666665', '', 0, '', 'graha bernadette building, jl. claire selatan ii/4, jakarta barat 11160, indonesia', '', 'Bangka Barat', 'Bangka Belitung', '11160', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:25:35', 1, '2019-07-15 16:25:35', 0),
	(110, 0, 0, 'Alexandra Abigail 4', '', 'felix@cuvox.de', '8077666665', '', 0, '', 'graha bernadette building, jl. claire selatan ii/4, jakarta barat 11160, indonesia', '', 'Bangka Barat', 'Bangka Belitung', '11160', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:25:35', 1, '2019-07-15 16:25:35', 0),
	(111, 0, 0, 'Preston Galloway 1', '', 'reeserocha@cuvox.de', '8045743677', '', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:26:36', 1, '2019-07-15 16:26:36', 0),
	(112, 0, 0, 'Preston Galloway 2', '', 'reeserocha@cuvox.de', '8045743677', '', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:26:46', 1, '2019-07-15 16:26:46', 0),
	(113, 0, 0, 'Preston Galloway 2', '', 'reeserocha@cuvox.de', '8045743677', '', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:26:46', 1, '2019-07-15 16:26:46', 0),
	(114, 0, 0, 'Preston Galloway', '', 'reeserocha@cuvox.de', '8045743677', '', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:27:26', 1, '2019-07-15 16:27:26', 0),
	(115, 0, 0, 'Preston Galloway', '', 'reeserocha@cuvox.de', '8045743677', '', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:27:26', 1, '2019-07-15 16:27:26', 0),
	(116, 0, 0, 'Preston Galloway 5', 'nanana.com', 'reeserocha@cuvox.de', '8045743677', '2234234234', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:28:42', 1, '2019-07-15 16:28:42', 0),
	(117, 0, 0, 'Preston Galloway 5', 'nanana.com', 'reeserocha@cuvox.de', '8045743677', '2234234234', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:28:42', 1, '2019-07-15 16:28:42', 0),
	(118, 0, 0, 'Preston Galloway 7', '', 'reeserocha@cuvox.de', '8045743677', '', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:30:35', 1, '2019-07-15 16:30:35', 0),
	(119, 0, 0, 'PT. Audrey Bella 619', 'nanana.com', 'felix@cuvox.de', '80776666651', '80776666652', 1, '', 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', '', 'Jakarta Barat', 'DKI Jakarta', '11160', '', '', '', '', '', '', '', '', 1, 1, '2019-07-15 16:31:33', 1, '2019-07-15 17:58:44', 1),
	(120, 0, 0, 'Preston Galloway', 'webste', 'reeserocha@cuvox.de', '8045743677', '423423413', 5, '', '661 Wallabout Street, Chelsea, Arkansas, 3754444', '', 'Sidneyv1', 'Sidney2', '888643', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:31:33', 1, '2019-07-15 18:05:36', 1),
	(121, 0, 0, 'Preston Galloway 11', '', 'reeserocha@cuvox.de', '8045743677', '', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:32:01', 1, '2019-07-15 16:32:01', 0),
	(122, 0, 0, 'Preston Galloway 11', '', 'reeserocha@cuvox.de', '8045743677', '', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:32:01', 1, '2019-07-15 16:32:01', 0),
	(123, 0, 0, 'Alexandra Abigail 11', '', 'felix@cuvox.de', '8077666665', '', 0, '', 'graha bernadette building, jl. claire selatan ii/4, jakarta barat 11160, indonesia', '', 'Bangka Barat', 'Bangka Belitung', '11160', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:32:50', 1, '2019-07-15 16:32:50', 0),
	(124, 0, 0, 'Alexandra Abigail 11', '', 'felix@cuvox.de', '8077666665', '', 0, '', 'graha bernadette building, jl. claire selatan ii/4, jakarta barat 11160, indonesia', '', 'Bangka Barat', 'Bangka Belitung', '11160', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:32:50', 1, '2019-07-15 16:32:50', 0),
	(125, 0, 0, 'Preston Galloway 12', '', 'reeserocha@cuvox.de', '8045743677', '', 0, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:36:07', 1, '2019-07-15 16:36:07', 0),
	(126, 0, 0, 'Alexandra Abigail 20', '', 'felix@cuvox.de', '8077666665', '', 0, '', 'graha bernadette building, jl. claire selatan ii/4, jakarta barat 11160, indonesia', '', 'Bangka Barat', 'Bangka Belitung', '11160', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:36:25', 1, '2019-07-15 16:36:25', 0),
	(127, 0, 0, 'Alexandra Abigail 22', '', 'felix@cuvox.de', '8077666665', '', 0, '', 'graha bernadette building, jl. claire selatan ii/4, jakarta barat 11160, indonesia', '', 'Bangka Barat', 'Bangka Belitung', '11160', '', '', '', '', '', '', '', '', 1, 0, '2019-07-15 16:36:34', 1, '2019-07-15 16:36:34', 0),
	(128, 0, 0, 'Preston Galloway 77', '', 'reeserocha@cuvox.de', '8045743677', '', 3, '', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 1, '2019-07-16 09:52:19', 1, '2019-07-16 09:52:19', 0),
	(129, 0, 0, 'PT. Audrey Bella 3', '', '', '', '', 5, '', 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', '', 'Jakarta Barat', 'DKI Jakarta', '11160', '', '', '', '', '', '', '', '', 1, 1, '2019-07-17 13:46:06', 1, '2019-07-17 13:46:06', 0),
	(130, 0, 0, 'PT. Audrey Bella 97', '', '', '', '', 0, '', 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', '', 'Jakarta Barat', 'DKI Jakarta', '11160', '', '', '', '', '', '', '', '', 1, 1, '2019-07-17 14:53:44', 1, '2019-07-17 14:53:44', 0),
	(131, 0, 0, 'PT. Audrey Bella 75', '', '', '', '', 6, '', 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', '', 'Jakarta Barat', 'DKI Jakarta', '11160', '', '', '', '', '', '', '', '', 1, 1, '2019-07-17 16:12:02', 1, '2019-07-18 16:07:24', 1);

-- Dumping structure for table crm3.crm3_company_class
CREATE TABLE IF NOT EXISTS `crm3_company_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_company_class: ~4 rows (approximately)
INSERT INTO `crm3_company_class` (`id`, `name`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'Retail', 1, '2020-01-01 00:00:00', 0, '2020-01-01 00:00:00', 0),
	(2, 'Agent', 1, '2020-01-01 00:00:00', 0, '2020-01-01 00:00:00', 0),
	(3, 'Distributor', 1, '2020-01-01 00:00:00', 0, '2020-01-01 00:00:00', 0),
	(4, 'Partner', 1, '2020-01-01 00:00:00', 0, '2020-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_company_class_price_list
CREATE TABLE IF NOT EXISTS `crm3_company_class_price_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_company_class` int(11) NOT NULL DEFAULT '0',
  `id_product` int(11) NOT NULL DEFAULT '0',
  `price` float(10,0) NOT NULL DEFAULT '0',
  `input_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_company_class_price_list: ~9 rows (approximately)
INSERT INTO `crm3_company_class_price_list` (`id`, `id_company_class`, `id_product`, `price`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(14, 2, 2, 22, '2020-02-05 18:02:51', 7, '2020-02-05 18:02:59', 7),
	(18, 3, 3, 16, '2020-02-05 18:03:11', 7, '2020-02-05 18:03:20', 7),
	(19, 3, 2, 17, '2020-02-05 18:03:12', 7, '2020-02-05 18:03:20', 7),
	(20, 3, 4, 18, '2020-02-05 18:03:12', 7, '2020-02-05 18:03:19', 7),
	(21, 3, 8, 19, '2020-02-05 18:03:13', 7, '2020-02-05 18:03:19', 7),
	(22, 3, 5, 10, '2020-02-05 18:03:16', 7, '2020-02-05 18:03:16', 7),
	(23, 2, 4, 33, '2020-02-05 18:10:56', 7, '2020-02-05 18:10:56', 7),
	(24, 2, 8, 0, '2020-02-05 18:10:57', 7, '2020-02-05 18:32:29', 7);

-- Dumping structure for table crm3.crm3_contact
CREATE TABLE IF NOT EXISTS `crm3_contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_company` int(11) NOT NULL DEFAULT '0',
  `id_user` int(6) NOT NULL DEFAULT '0',
  `id_title` int(6) NOT NULL DEFAULT '0',
  `first_name` varchar(250) NOT NULL DEFAULT '',
  `last_name` varchar(250) NOT NULL DEFAULT '',
  `position` varchar(250) NOT NULL DEFAULT '',
  `email` varchar(250) NOT NULL DEFAULT '',
  `phone` varchar(250) NOT NULL DEFAULT '',
  `mobile` varchar(250) NOT NULL DEFAULT '',
  `id_lead_source` int(5) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_contact: ~36 rows (approximately)
INSERT INTO `crm3_contact` (`id`, `id_company`, `id_user`, `id_title`, `first_name`, `last_name`, `position`, `email`, `phone`, `mobile`, `id_lead_source`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(12, 119, 1, 0, 'Alexandra', 'Abigail', '', 'felix@cuvox.de', '', '8077666665', 0, 1, 0, '2019-07-16 13:38:56', 1, '2019-07-16 13:38:56', 0),
	(13, 119, 1, 0, 'Alexandra 3334', 'Abigail', '', 'felix@cuvox.de', '', '8077666665', 0, 1, 0, '2019-07-16 13:39:06', 1, '2019-07-16 13:39:06', 0),
	(14, 3, 1, 2, 'Preston 123', 'Galloway', '', 'reeserocha@cuvox.de', '123123123123', '8045743677', 2, 1, 0, '2019-07-16 13:39:35', 1, '2019-07-16 16:19:53', 1),
	(15, 119, 1, 1, 'Kazama', 'Yammi', '', '', '', '', 0, 1, 0, '2019-07-16 13:39:46', 1, '2019-07-16 13:39:46', 0),
	(16, 93, 1, 2, 'Alexandra', 'Abigail', '', 'felix@cuvox.de', '123123', '8077666665', 0, 1, 0, '2019-07-16 14:40:16', 1, '2019-07-16 14:40:16', 0),
	(17, 0, 1, 0, 'Preston 1', 'Galloway', '', 'reeserocha@cuvox.de', '', '8045743677', 0, 1, 1, '2019-07-16 14:40:42', 1, '2019-07-16 14:40:42', 0),
	(18, 3, 1, 0, 'Preston 44', 'Galloway', '', 'reeserocha@cuvox.de', '65666666', '2222222', 0, 1, 0, '2019-07-16 14:45:30', 1, '2019-07-16 14:45:30', 0),
	(19, 0, 1, 0, 'Preston', 'Galloway', '', 'reeserocha@cuvox.de', '', '8045743677', 0, 1, 1, '2019-07-16 14:48:20', 1, '2019-07-16 14:48:20', 0),
	(20, 0, 1, 0, 'Preston', 'Galloway', '', 'reeserocha@cuvox.de', '', '8045743677', 0, 1, 0, '2019-07-16 14:48:24', 1, '2019-07-16 14:48:24', 0),
	(21, 130, 7, 5, 'Alexandra1', 'Abigail1', 'VR Manager2', 'felix@cuvox.de3', '99867676', '80776666652', 2, 1, 1, '2019-07-16 16:26:55', 1, '2020-01-27 13:45:54', 7),
	(22, 1, 1, 1, 'Kazama', 'Yammi', '', '', '', '', 0, 1, 0, '2019-07-16 17:11:04', 1, '2019-07-16 17:11:04', 0),
	(23, 119, 1, 0, 'Preston 997', 'Galloway', '', 'reeserocha@cuvox.de', '', '8045743677', 0, 1, 1, '2019-07-16 18:45:23', 1, '2019-07-16 18:45:23', 0),
	(24, 119, 1, 0, 'Preston 933', 'Galloway', '', 'reeserocha@cuvox.de', '', '8045743677', 0, 1, 1, '2019-07-16 18:45:30', 1, '2019-07-16 18:45:30', 0),
	(25, 129, 1, 1, 'Alexandra', 'Abigail', '', 'felix@cuvox.de', '123123123', '8077666665', 0, 1, 0, '2019-07-17 13:46:06', 1, '2019-07-17 13:46:06', 0),
	(26, 93, 1, 1, 'Alexandra', 'Abigail', 'VR Manager', 'felix@cuvox.de', '', '8077666665', 1, 1, 0, '2019-07-17 14:22:15', 1, '2020-01-27 15:22:05', 7),
	(27, 93, 1, 1, 'Alexandra', 'Abigail', '', 'felix@cuvox.de', '77777', '8077666665', 0, 1, 0, '2019-07-17 14:28:41', 1, '2019-07-17 14:28:41', 0),
	(28, 93, 1, 1, 'Alexandra', 'Abigail', '', 'felix@cuvox.de', '', '8077666665', 0, 1, 1, '2019-07-17 14:53:44', 1, '2019-07-17 14:53:44', 0),
	(30, 93, 1, 1, 'Preston', 'Galloway', '', 'reeserocha@cuvox.de', '9999777', '8045743677', 0, 1, 1, '2019-07-17 16:12:59', 1, '2019-07-17 16:12:59', 0),
	(31, 93, 1, 4, 'Hana', '', '', '', '', '', 0, 1, 1, '2019-07-19 16:10:53', 1, '2019-07-19 16:10:53', 0),
	(32, 93, 1, 1, 'Hanura', 'Hana', '', '', '', '', 0, 1, 1, '2019-07-19 16:12:13', 1, '2019-07-19 16:12:13', 0),
	(33, 11, 1, 0, 'Kojima', '', '', '', '', '', 0, 1, 0, '2019-07-19 16:48:13', 1, '2019-07-19 16:48:13', 0),
	(34, 11, 1, 0, 'Hikaru', '', '', '', '', '', 0, 1, 1, '2019-07-19 16:48:18', 1, '2019-07-19 16:48:18', 0),
	(41, 76, 1, 5, 'Preston23 ', 'Galloway', '', 'reeserocha@cuvox.de', '', '8045743677', 0, 1, 1, '2019-07-25 17:43:04', 1, '2019-07-25 17:43:04', 0),
	(42, 76, 1, 1, 'Mico', '', '', '', '', '', 0, 1, 1, '2019-07-25 17:43:16', 1, '2019-07-25 17:43:16', 0),
	(43, 76, 1, 0, 'Kajo', '', '', '', '', '', 0, 1, 1, '2019-07-25 17:43:23', 1, '2019-07-25 17:43:23', 0),
	(44, 0, 7, 1, 'a 1', 'Abigail', '', 'felix@cuvox.de', '', '8077666665', 0, 1, 1, '2020-01-29 13:04:38', 7, '2020-01-29 13:04:38', 0),
	(45, 0, 7, 1, 'a 1', 'Abigail', '', 'felix@cuvox.de', '', '8077666665', 0, 1, 1, '2020-01-29 13:04:38', 7, '2020-01-29 13:04:38', 0),
	(46, 0, 7, 1, 'a 1', 'Abigail', '', 'felix@cuvox.de', '', '8077666665', 0, 1, 1, '2020-01-29 13:04:40', 7, '2020-01-29 13:04:40', 0),
	(47, 0, 7, 1, 'a 1', 'Abigail', '', 'felix@cuvox.de', '', '8077666665', 0, 1, 1, '2020-01-29 13:05:04', 7, '2020-01-29 13:05:04', 0),
	(48, 11, 7, 1, 'a 3', '', '', '', '', '', 0, 1, 1, '2020-01-29 13:15:40', 7, '2020-01-29 13:15:40', 0),
	(49, 11, 7, 1, 'a 3', '', '', '', '', '', 0, 1, 1, '2020-01-29 13:15:40', 7, '2020-01-29 13:15:40', 0),
	(50, 0, 7, 2, 'C1', '', '', '', '', '', 0, 1, 1, '2020-01-29 13:16:16', 7, '2020-01-29 13:16:16', 0),
	(51, 0, 7, 2, 'C1', '', '', '', '', '', 0, 1, 1, '2020-01-29 13:16:16', 7, '2020-01-29 13:16:16', 0),
	(52, 0, 7, 1, 'D1', '', '', '', '', '', 0, 1, 1, '2020-01-29 13:16:41', 7, '2020-01-29 13:16:41', 0),
	(53, 93, 7, 1, 'Jojo', '', '', '', '', '', 0, 1, 1, '2020-01-29 19:45:44', 7, '2020-01-29 19:45:44', 0),
	(54, 1, 1, 0, 'Alexandra', 'Abigail', '', 'felix@cuvox.de', '', '8077666665', 0, 1, 1, '2020-02-03 17:01:26', 7, '2020-02-03 17:01:26', 0),
	(55, 1, 1, 0, 'Preston', 'Galloway', '', 'reeserocha@cuvox.de', '', '8045743677', 0, 1, 1, '2020-02-03 17:01:30', 7, '2020-02-03 17:01:30', 0),
	(56, 1, 1, 0, 'Alexandra', 'Abigail', '', 'felix@cuvox.de', '8045743677', '8077666665', 0, 1, 1, '2020-02-03 17:01:55', 7, '2020-02-03 17:01:55', 0),
	(93, 93, 1, 1, 'Alexandra', 'Abigail', '', 'felix@cuvox.de', '', '8077666665', 0, 1, 0, '2019-07-17 16:12:02', 1, '2019-07-17 16:12:02', 0);

-- Dumping structure for table crm3.crm3_currency
CREATE TABLE IF NOT EXISTS `crm3_currency` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `isDefault` int(1) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `symbol` varchar(4) NOT NULL DEFAULT '',
  `code` varchar(4) NOT NULL DEFAULT '',
  `value` float(9,0) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(6) NOT NULL DEFAULT '0',
  `input_by` int(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_currency: ~1 rows (approximately)
INSERT INTO `crm3_currency` (`id`, `isDefault`, `name`, `symbol`, `code`, `value`, `input_date`, `update_date`, `update_by`, `input_by`) VALUES
	(1, 1, 'Rupiah', 'Rp', 'IDR', 1, '2019-01-01 00:00:00', '2019-01-01 00:00:00', 0, 0);

-- Dumping structure for table crm3.crm3_global
CREATE TABLE IF NOT EXISTS `crm3_global` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT '',
  `value` varchar(250) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_global: ~0 rows (approximately)
INSERT INTO `crm3_global` (`id`, `name`, `value`) VALUES
	(10, 'id_currency', '1');

-- Dumping structure for table crm3.crm3_industry
CREATE TABLE IF NOT EXISTS `crm3_industry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_industry: ~6 rows (approximately)
INSERT INTO `crm3_industry` (`id`, `name`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'Food', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(2, 'Retail', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(3, 'Manufactur', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(4, 'Consultant', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(5, 'Travel', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(6, 'Developer', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_label
CREATE TABLE IF NOT EXISTS `crm3_label` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_module` int(4) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `lang1` varchar(50) NOT NULL DEFAULT '',
  `lang2` varchar(50) NOT NULL DEFAULT '',
  `lang3` varchar(50) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_label: ~19 rows (approximately)
INSERT INTO `crm3_label` (`id`, `id_module`, `name`, `lang1`, `lang2`, `lang3`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 100, 'home', 'Home', 'Home', 'Home', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(2, 200, 'name', 'Name', 'Name', 'Name', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(3, 200, 'first_name', 'First Name', 'First Name', 'First Name', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(4, 200, 'last_name', 'Last Name', 'Last Name', 'Last Name', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(5, 200, 'mobile', 'Mobile', 'Mobile', 'Mobile', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(6, 200, 'phone', 'Phone', 'Phone', 'Phone', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(7, 200, 'email', 'Email', 'Email', 'Email', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(8, 200, 'lead_owner', 'Lead Owner', 'Lead Owner', 'Lead Owner', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(9, 200, 'lead_source', 'Lead Source', 'Lead Source', 'Lead Source', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(10, 0, 'create_date', 'create_date', 'create_date', 'create_date', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(11, 0, 'update_date', 'update_date', 'update_date', 'update_date', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(14, 200, 'lead_status', 'Lead Status', 'Lead Status', 'Lead Status', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(16, 0, 'print', 'Print', 'Print', 'Print', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(17, 0, 'search', 'Search', 'Search', 'Search', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(18, 0, 'new', 'New', 'New', 'New', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(19, 0, 'edit', 'Edit', 'Edit', 'Edit', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(20, 0, 'delete', 'Delete', 'Delete', 'Delete', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(21, 0, 'add', 'Add', 'Add', 'Add', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(22, 0, 'save', 'Save', 'Save', 'Save', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(23, 0, 'cancel', 'Cancel', 'Cancel', 'Cancel', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_lead
CREATE TABLE IF NOT EXISTS `crm3_lead` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `convert` int(1) NOT NULL DEFAULT '0',
  `id_user` int(6) NOT NULL DEFAULT '0',
  `id_company_class` int(6) NOT NULL DEFAULT '0',
  `id_lead_status` int(6) NOT NULL DEFAULT '1',
  `id_title` int(3) NOT NULL DEFAULT '0',
  `first_name` varchar(250) NOT NULL DEFAULT '',
  `last_name` varchar(250) NOT NULL DEFAULT '',
  `position` varchar(250) NOT NULL DEFAULT '',
  `company` varchar(250) NOT NULL DEFAULT '',
  `id_company` int(6) NOT NULL DEFAULT '0',
  `id_lead_source` int(3) NOT NULL DEFAULT '1',
  `id_industry` int(3) NOT NULL DEFAULT '1',
  `website` varchar(250) NOT NULL DEFAULT '',
  `email` varchar(250) NOT NULL DEFAULT '',
  `mobile` varchar(250) NOT NULL DEFAULT '',
  `phone` varchar(250) NOT NULL DEFAULT '',
  `fax` varchar(250) NOT NULL DEFAULT '',
  `opportunity` varchar(250) NOT NULL DEFAULT '',
  `amount` float(10,0) NOT NULL DEFAULT '0',
  `address_street` text NOT NULL,
  `address_city` varchar(250) NOT NULL DEFAULT '',
  `address_state` varchar(250) NOT NULL DEFAULT '',
  `address_code` varchar(250) NOT NULL DEFAULT '',
  `address_country` varchar(250) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1031 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_lead: ~30 rows (approximately)
INSERT INTO `crm3_lead` (`id`, `convert`, `id_user`, `id_company_class`, `id_lead_status`, `id_title`, `first_name`, `last_name`, `position`, `company`, `id_company`, `id_lead_source`, `id_industry`, `website`, `email`, `mobile`, `phone`, `fax`, `opportunity`, `amount`, `address_street`, `address_city`, `address_state`, `address_code`, `address_country`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1001, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella', 0, 1, 4, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:39:17', 1, '2019-07-10 15:39:17', 0),
	(1002, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'Tencent', 9, 1, 4, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:39:37', 1, '2019-07-10 15:39:37', 0),
	(1003, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'Cygames', 4, 1, 1, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, '', '', '', '', '', 1, 0, '2019-07-10 15:43:00', 1, '2019-07-10 15:43:00', 0),
	(1004, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'Cygames', 4, 1, 1, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, '', '', '', '', '', 1, 0, '2019-07-10 15:43:40', 1, '2019-07-10 15:43:40', 0),
	(1005, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'Cygames', 4, 1, 6, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, '', '', '', '', '', 1, 0, '2019-07-10 15:44:44', 1, '2019-07-10 15:44:44', 0),
	(1006, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'Cygames', 4, 1, 6, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, '', '', '', '', '', 1, 0, '2019-07-10 15:47:56', 1, '2019-07-10 15:47:56', 0),
	(1007, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 123', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:49:51', 1, '2019-07-10 15:49:51', 0),
	(1008, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:54:43', 1, '2019-07-10 15:54:43', 0),
	(1009, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:54:43', 1, '2019-07-10 15:54:43', 0),
	(1010, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:54:56', 1, '2019-07-10 15:54:56', 0),
	(1011, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 1', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:55:20', 1, '2019-07-10 15:55:20', 0),
	(1012, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 2', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:55:22', 1, '2019-07-10 15:55:22', 0),
	(1013, 0, 1, 0, 4, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 2', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:55:23', 1, '2019-07-10 15:55:23', 0),
	(1014, 1, 1, 0, 4, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 3', 0, 2, 5, '', 'felix@cuvox.de', '8077666665', '123123123', '', 'Project X', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:55:35', 1, '2019-07-12 00:06:00', 1),
	(1015, 0, 1, 0, 2, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 4', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:55:45', 1, '2019-07-10 15:55:45', 0),
	(1016, 0, 0, 0, 3, 0, '', '', '', '', 0, 0, 0, '', '', '', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 15:58:23', 1, '2019-07-11 10:35:12', 1),
	(1017, 1, 1, 0, 2, 1, 'Alexandra', 'Abigail', '', '123', 93, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 16:00:51', 1, '2019-07-10 16:00:51', 0),
	(1018, 1, 1, 0, 2, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 97', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 16:02:37', 1, '2019-07-10 16:02:37', 0),
	(1019, 1, 1, 0, 2, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 75', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 16:03:56', 1, '2019-07-10 16:03:56', 0),
	(1020, 0, 1, 0, 1, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 4325', 0, 1, 0, '', 'felix@cuvox.de', '8077666665', '', '', '', 0, 'Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', 'Jakarta Barat', 'DKI Jakarta', '11160', '', 1, 0, '2019-07-10 16:04:57', 1, '2019-07-10 16:04:57', 0),
	(1021, 1, 1, 0, 3, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 44435', 76, 1, 3, 'bella.com', 'felix@cuvox.de', '8077666665', '77777', '', '123123123123123', 0, '1Graha Bernadette Building, Jl. Claire Selatan II/4, Jakarta Barat 11160, Indonesia', '2Jakarta Barat', '3DKI Jakarta', '411160', '', 1, 0, '2019-07-10 16:06:16', 1, '2019-07-11 12:02:03', 1),
	(1022, 0, 1, 0, 1, 1, 'Preston', 'Galloway', '', 'Gameloft', 5, 1, 6, '', 'reeserocha@cuvox.de', '8045743677', '', '', '', 0, '', '', '', '', '', 1, 0, '2019-07-10 16:29:47', 1, '2019-07-10 16:29:47', 0),
	(1023, 0, 1, 0, 3, 1, 'Preston', 'Galloway', 'VR Manager', 'QUAILCOM, INC 22', 0, 1, 0, 'nanana.com', 'reeserocha@cuvox.de', '8045743677', '5555555', '', 'Project web support Telkom', 500000000, '661 Wallabout Street, Chelsea, Arkansas, 375', 'Sidney', 'Sidney', '88864', '', 1, 1, '2019-07-10 16:30:42', 1, '2020-01-24 15:26:50', 7),
	(1024, 0, 1, 0, 1, 1, 'Preston', 'Galloway', '', 'QUAILCOM, INC 4534', 0, 1, 0, '', 'reeserocha@cuvox.de', '8045743677', '', '', '', 0, '661 Wallabout Street, Chelsea, Arkansas, 375', 'Sidney', 'Sidney', '88864', '', 1, 0, '2019-07-10 16:31:41', 1, '2019-07-10 16:31:41', 0),
	(1025, 0, 1, 0, 2, 1, 'ZPreston', 'Galloway', '', 'QUAILCOM, INC', 0, 1, 2, '', 'reeserocha@cuvox.de', '8045743677', '', '', '', 0, '661 Wallabout Street, Chelsea, Arkansas, 375', 'Sidney', 'Sidney', '88864', '', 1, 1, '2019-07-10 16:37:44', 1, '2019-07-10 16:37:44', 0),
	(1026, 1, 1, 0, 1, 1, 'Preston', 'Galloway', '', 'Blizzard Entertainment	', 1, 1, 6, '', 'reeserocha@cuvox.de', '8045743677', '9999777', '', '', 0, '', '', '', '', '', 1, 0, '2019-07-11 14:26:07', 1, '2019-07-11 14:26:07', 0),
	(1027, 0, 1, 0, 4, 1, 'Preston 1', 'Galloway', '', 'QUAILCOM, INC', 0, 1, 1, '', 'reeserocha@cuvox.de', '8045743677', '+618045743677', '', '', 0, '661 Wallabout Street, Chelsea, Arkansas, 375', '', '', '88864', '', 1, 1, '2019-07-15 16:33:42', 1, '2019-07-15 16:33:42', 0),
	(1028, 0, 7, 0, 2, 1, 'Preston', 'Galloway12', '', 'QUAILCOM, INC', 0, 1, 0, '', 'reeserocha@cuvox.de', '8045743677', '', '', '', 0, '661 Wallabout Street, Chelsea, Arkansas, 375', '', '', '88864', '', 1, 0, '2019-07-29 15:32:35', 7, '2019-12-27 16:00:13', 7),
	(1029, 0, 1, 2, 3, 1, 'Otosaki', 'kaori', 'actress 69', 'madona', 0, 2, 5, 'madona.com', 'kaori@cuvox.de', '+6281943334', '5454454545', '', 'Project web support Telkom', 900000000, '1', '2', '3', '4', '5', 1, 1, '2020-01-21 11:52:49', 7, '2020-02-05 18:57:01', 7),
	(1030, 0, 79, 4, 1, 1, 'Alexandra', 'Abigail', '', 'PT. Audrey Bella 44', 0, 1, 1, 'mirrel.com', 'felix@cuvox.de', '8077666665', '', '', '', 900000, 'graha bernadette building\njl. claire selatan ii/4\njakarta barat 11160, indonesia', 'Bangka Barat', 'Bangka Belitung', '11160', '', 1, 1, '2020-01-26 00:18:49', 7, '2020-02-05 16:59:33', 7);

-- Dumping structure for table crm3.crm3_lead_convert
CREATE TABLE IF NOT EXISTS `crm3_lead_convert` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(6) NOT NULL DEFAULT '0',
  `id_lead` int(6) NOT NULL DEFAULT '0',
  `id_company` int(6) NOT NULL DEFAULT '0',
  `id_contact` int(6) NOT NULL DEFAULT '0',
  `id_opportunity` int(6) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `lead_input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `lead_input_by` int(11) NOT NULL DEFAULT '0',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_lead_convert: ~2 rows (approximately)
INSERT INTO `crm3_lead_convert` (`id`, `id_user`, `id_lead`, `id_company`, `id_contact`, `id_opportunity`, `status`, `presence`, `lead_input_date`, `lead_input_by`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(2, 1, 1018, 130, 28, 0, 1, 1, '2019-07-10 16:02:37', 1, '2019-07-17 14:53:44', 1, '2019-07-17 14:53:44', 0),
	(3, 1, 1019, 131, 29, 0, 1, 1, '2019-07-10 16:03:56', 1, '2019-07-17 16:12:02', 1, '2019-07-17 16:12:02', 0),
	(4, 1, 1026, 1, 30, 106, 1, 1, '2019-07-11 14:26:07', 1, '2019-07-17 16:12:59', 1, '2019-07-17 16:12:59', 0);

-- Dumping structure for table crm3.crm3_lead_product
CREATE TABLE IF NOT EXISTS `crm3_lead_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_lead` int(11) NOT NULL DEFAULT '0',
  `id_product` int(11) NOT NULL DEFAULT '0',
  `id_price_list` int(11) NOT NULL DEFAULT '0',
  `price` float(12,0) NOT NULL DEFAULT '0',
  `qty` int(6) NOT NULL DEFAULT '0',
  `discount` float(2,0) NOT NULL DEFAULT '0',
  `total` float(12,0) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_lead_product: ~23 rows (approximately)
INSERT INTO `crm3_lead_product` (`id`, `id_lead`, `id_product`, `id_price_list`, `price`, `qty`, `discount`, `total`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(5, 1029, 1, 14, 10000000, 1, 0, 10000000, 1, 0, '2020-01-21 17:27:14', 7, '2020-01-21 17:27:14', 0),
	(6, 1029, 1, 14, 10000000, 1, 0, 10000000, 1, 0, '2020-01-21 17:27:14', 7, '2020-01-21 17:27:14', 0),
	(7, 1029, 1, 16, 10000000, 1, 0, 10000000, 1, 0, '2020-01-21 17:27:14', 7, '2020-01-21 17:27:14', 0),
	(8, 1029, 4, 13, 80000000, 1, 0, 80000000, 1, 0, '2020-01-21 17:27:14', 7, '2020-01-21 17:27:14', 0),
	(9, 1029, 4, 13, 80000000, 1, 0, 80000000, 1, 0, '2020-01-21 17:50:25', 7, '2020-01-21 17:50:25', 0),
	(10, 1029, 2, 10, 30000000, 1, 0, 30000000, 1, 0, '2020-01-21 17:50:25', 7, '2020-01-21 17:50:25', 0),
	(11, 1029, 3, 11, 55000000, 1, 0, 55000000, 1, 0, '2020-01-21 17:50:25', 7, '2020-01-21 17:50:25', 0),
	(12, 1029, 4, 13, 80000000, 1, 0, 80000000, 1, 0, '2020-01-23 01:50:47', 7, '2020-01-23 01:50:47', 0),
	(13, 1023, 1, 15, 10000000, 1, 0, 10000000, 1, 0, '2020-01-30 00:49:03', 7, '2020-01-30 00:49:03', 0),
	(14, 1023, 1, 14, 10000000, 1, 0, 10000000, 1, 0, '2020-01-30 00:49:03', 7, '2020-01-30 00:49:03', 0),
	(15, 1029, 5, 0, 8000000, 1, 0, 8000000, 1, 0, '2020-02-05 15:37:25', 7, '2020-02-05 15:37:25', 0),
	(16, 1029, 8, 0, 3600000, 1, 0, 3600000, 1, 0, '2020-02-05 15:37:25', 7, '2020-02-05 15:37:25', 0),
	(17, 1029, 5, 0, 8000000, 1, 0, 8000000, 1, 0, '2020-02-05 15:37:35', 7, '2020-02-05 15:37:35', 0),
	(18, 1029, 8, 0, 3600000, 1, 0, 3600000, 1, 0, '2020-02-05 15:37:35', 7, '2020-02-05 15:37:35', 0),
	(19, 1029, 2, 0, 22, 1, 0, 22, 1, 0, '2020-02-05 18:57:10', 7, '2020-02-05 18:57:10', 0),
	(20, 1029, 5, 0, 8000000, 1, 0, 8000000, 1, 0, '2020-02-05 18:57:10', 7, '2020-02-05 18:57:10', 0),
	(21, 1029, 3, 0, 11, 1, 0, 11, 1, 0, '2020-02-05 18:57:10', 7, '2020-02-05 18:57:10', 0),
	(22, 1025, 5, 0, 8000000, 1, 0, 8000000, 1, 0, '2020-02-05 19:05:31', 7, '2020-02-05 19:05:31', 0),
	(23, 1025, 5, 0, 8000000, 1, 0, 8000000, 1, 1, '2020-02-05 19:05:31', 7, '2020-02-05 19:05:31', 0),
	(24, 1025, 2, 0, 600000, 1, 0, 600000, 1, 1, '2020-02-05 19:05:31', 7, '2020-02-05 19:05:31', 0),
	(25, 1025, 4, 0, 5000000, 1, 0, 5000000, 1, 1, '2020-02-05 19:05:31', 7, '2020-02-05 19:05:31', 0),
	(26, 1025, 3, 0, 1200000, 1, 0, 1200000, 1, 1, '2020-02-05 19:05:31', 7, '2020-02-05 19:05:31', 0),
	(27, 1025, 8, 0, 3600000, 1, 0, 3600000, 1, 1, '2020-02-05 19:05:31', 7, '2020-02-05 19:05:31', 0);

-- Dumping structure for table crm3.crm3_lead_source
CREATE TABLE IF NOT EXISTS `crm3_lead_source` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_lead_source: ~2 rows (approximately)
INSERT INTO `crm3_lead_source` (`id`, `name`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'Database', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(2, 'Refferal', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_lead_status
CREATE TABLE IF NOT EXISTS `crm3_lead_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL DEFAULT '',
  `value` int(3) NOT NULL DEFAULT '0',
  `color` varchar(50) NOT NULL DEFAULT '',
  `ilock` int(1) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_lead_status: ~4 rows (approximately)
INSERT INTO `crm3_lead_status` (`id`, `name`, `value`, `color`, `ilock`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'Low', 0, 'light', 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(2, 'Normal', 25, 'green', 0, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(3, 'High', 50, 'brown', 0, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(4, 'Priority', 90, 'red', 0, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_module
CREATE TABLE IF NOT EXISTS `crm3_module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `lang1` varchar(50) NOT NULL DEFAULT '',
  `lang2` varchar(50) NOT NULL DEFAULT '',
  `lang3` varchar(50) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=801 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_module: ~14 rows (approximately)
INSERT INTO `crm3_module` (`id`, `name`, `lang1`, `lang2`, `lang3`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(100, 'user', 'User', 'User', 'User', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(200, 'lead', 'Lead', 'Lead', 'Lead', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(300, 'contact', 'Contact', 'Contact', 'Contact', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(400, 'company', 'Company', 'Company', 'Company', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(410, 'companyClass', 'Company Class', 'Company Class', 'Company Class', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(411, 'CCPriceList', 'Class Price List', 'Class Price List', 'Class Price List', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(500, 'opportunity', 'Opportunity', 'Opportunity', 'Opportunity', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(510, 'lose', 'Closed Lose', 'Closed Lose', 'Closed Lose', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(520, 'deal', 'Deal', 'Deal', 'Deal', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(550, 'salesOrder', 'Sales Order', 'Sales Order', 'Sales Order', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(600, 'activity', 'Activity', 'Activity', 'Activity', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(700, 'product', 'Product', 'Product', 'Product', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(710, 'priceList', 'Price List', 'Price List', 'Price List', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(800, 'quote', 'Quotation', 'Quotation', 'Quotation', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_number
CREATE TABLE IF NOT EXISTS `crm3_number` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `runing_number` int(9) NOT NULL DEFAULT '0',
  `digit` int(9) NOT NULL DEFAULT '1',
  `rules` varchar(50) NOT NULL DEFAULT '',
  `latest_request_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `latest_request_by` int(9) NOT NULL DEFAULT '0',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(6) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_number: ~10 rows (approximately)
INSERT INTO `crm3_number` (`id`, `name`, `runing_number`, `digit`, `rules`, `latest_request_date`, `latest_request_by`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'lead', 1030, 1, '', '2020-01-26 00:18:49', 7, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(2, 'company', 131, 1, '', '2019-07-17 16:12:02', 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(3, 'contact', 56, 1, '', '2020-02-03 17:01:55', 7, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(4, 'branch', 11, 1, '', '2019-07-16 19:07:16', 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(5, 'opportunity', 149, 1, '', '2020-01-28 19:18:13', 7, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(6, 'lead_convert', 4, 1, '', '2019-07-17 16:12:59', 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(7, 'activity', 216, 1, '', '2020-01-22 00:04:46', 7, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(8, 'quote', 13, 6, '', '2020-01-29 14:59:41', 7, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(9, 'sales_order', 37, 6, '', '2020-02-11 01:23:21', 7, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(10, 'deal', 0, 1, '', '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(11, 'user', 102, 1, '', '2020-02-11 17:31:19', 7, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_opportunity
CREATE TABLE IF NOT EXISTS `crm3_opportunity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `closed` int(1) NOT NULL DEFAULT '0',
  `id_opportunity_business` int(3) NOT NULL DEFAULT '0',
  `id_user` int(6) NOT NULL DEFAULT '0',
  `id_lead` int(6) NOT NULL DEFAULT '0',
  `id_contact` int(6) NOT NULL DEFAULT '0',
  `id_company` int(6) NOT NULL DEFAULT '0',
  `id_currency` int(2) NOT NULL DEFAULT '1',
  `id_quote` int(8) NOT NULL DEFAULT '0',
  `sales_order` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(250) NOT NULL DEFAULT '',
  `amount` float(12,0) NOT NULL DEFAULT '0',
  `id_stage` int(6) NOT NULL DEFAULT '0',
  `id_lead_source` int(6) NOT NULL DEFAULT '0',
  `start_date` date NOT NULL DEFAULT '2019-01-01',
  `closed_date` date NOT NULL DEFAULT '2019-01-01',
  `notes` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_opportunity: ~26 rows (approximately)
INSERT INTO `crm3_opportunity` (`id`, `closed`, `id_opportunity_business`, `id_user`, `id_lead`, `id_contact`, `id_company`, `id_currency`, `id_quote`, `sales_order`, `name`, `amount`, `id_stage`, `id_lead_source`, `start_date`, `closed_date`, `notes`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(101, 0, 0, 1, 0, 25, 129, 0, 0, '', 'Project X 1001', 0, 104, 2, '2019-01-01', '2019-01-01', '', 1, 1, '2019-07-17 13:46:06', 1, '2020-01-31 15:10:40', 7),
	(102, 1, 1, 7, 1017, 32, 93, 1, 6, 'SO001', 'Project ERP Software House 1', 190, 10, 1, '2019-01-01', '2019-01-01', '', 1, 1, '2019-07-17 14:22:15', 1, '2020-01-31 14:58:45', 7),
	(103, 1, 0, 5, 1021, 27, 76, 1, 0, '', 'project x23', 0, 10, 1, '2019-01-01', '2019-07-18', 'Deal akhirnya dengan contract', 1, 1, '2019-07-17 14:28:41', 1, '2019-07-18 19:40:14', 1),
	(104, 0, 0, 1, 1018, 28, 130, 1, 0, '', 'ABC', 0, 104, 1, '2019-01-01', '2019-01-01', '', 1, 1, '2019-07-17 14:53:44', 1, '2019-07-18 17:49:08', 1),
	(105, 1, 0, 1, 1019, 29, 131, 1, 0, '', 'Project X-10', 0, 10, 1, '2019-01-01', '2019-07-19', 'Goald', 1, 1, '2019-07-17 16:12:02', 1, '2019-07-18 19:45:04', 1),
	(106, 0, 0, 5, 1026, 22, 1, 1, 0, '', 'End Game Project CGI', 0, 100, 2, '2019-01-01', '2019-01-01', '', 1, 0, '2019-07-17 16:12:59', 1, '2019-07-18 14:26:05', 1),
	(121, 0, 0, 1, 0, 26, 93, 1, 0, '', 'Project MRT Jakarta Selatan 4', 0, 0, 0, '2019-01-01', '2019-01-01', '', 1, 0, '2019-07-19 15:14:07', 1, '2019-07-19 17:33:38', 1),
	(122, 0, 0, 1, 0, 26, 93, 1, 0, '', 'Project MRT Jakarta Selatan 3', 0, 100, 1, '2019-01-01', '2019-01-01', '', 1, 0, '2019-07-19 15:19:09', 1, '2019-07-19 16:52:52', 1),
	(128, 0, 0, 1, 0, 0, 35, 1, 0, '', 'Project MRT Jakarta Selatan', 0, 100, 0, '2019-01-01', '2019-01-01', '', 1, 0, '2019-07-19 16:05:21', 1, '2019-07-19 17:33:38', 1),
	(129, 0, 0, 1, 0, 0, 35, 1, 0, '', 'Project MRT Jakarta Selatan', 0, 100, 0, '2019-01-01', '2019-01-01', '', 1, 0, '2019-07-19 16:08:47', 1, '2019-07-19 17:33:38', 1),
	(130, 0, 0, 1, 0, 21, 1, 1, 0, '', 'Project MRT Jakarta Selatan', 0, 100, 0, '2019-01-01', '2019-01-01', '', 1, 0, '2019-07-19 16:09:23', 1, '2019-07-19 17:33:38', 1),
	(131, 0, 0, 1, 0, 31, 1, 1, 0, '', 'Project MRT Jakarta Selatan', 0, 100, 0, '2019-01-01', '2019-01-01', '', 1, 0, '2019-07-19 16:10:53', 1, '2019-07-19 17:33:42', 1),
	(132, 0, 0, 1, 0, 32, 35, 1, 0, '', 'Project Bandara Kalimantan Selatan', 0, 100, 1, '2019-01-01', '2019-01-01', '', 1, 0, '2019-07-19 16:12:13', 1, '2019-07-19 16:52:46', 1),
	(134, 0, 0, 1, 0, 0, 0, 1, 0, '', 'Preston Galloway', 41604000, 0, 0, '2020-01-29', '2019-01-01', '', 1, 1, '2020-01-27 15:18:36', 7, '2020-01-27 15:18:36', 0),
	(136, 0, 0, 1, 0, 26, 93, 1, 0, '', 'Project Zelda', 900000000, 0, 0, '2020-01-29', '2019-01-01', '', 1, 1, '2020-01-27 15:22:20', 7, '2020-01-27 15:22:20', 0),
	(137, 0, 0, 1, 0, 26, 93, 1, 0, '', 'Project Mario Cart', 10000000, 0, 0, '2020-01-31', '2019-01-01', '', 1, 1, '2020-01-27 15:41:53', 7, '2020-01-27 15:41:53', 0),
	(138, 0, 0, 1, 0, 26, 93, 1, 0, '', 'project HHkaj', 9000000, 101, 0, '2020-01-29', '2019-01-01', '', 1, 1, '2020-01-27 15:43:35', 7, '2020-01-27 15:43:35', 0),
	(139, 0, 0, 1, 0, 28, 93, 1, 0, '', 'Project meykarta', 1000000000, 100, 0, '2020-02-06', '2019-01-01', '', 1, 1, '2020-01-28 16:42:26', 7, '2020-01-28 16:42:26', 0),
	(140, 0, 0, 1, 0, 28, 93, 1, 0, '', 'Project meykarta', 1000000000, 100, 0, '2020-02-06', '2019-01-01', '', 1, 1, '2020-01-28 16:42:31', 7, '2020-01-28 16:42:31', 0),
	(143, 0, 0, 0, 0, 0, 0, 1, 0, '', 'project metarl gaear', 0, 104, 0, '0000-00-00', '2019-01-01', '', 1, 1, '2020-01-28 17:52:25', 7, '2020-01-31 15:21:44', 7),
	(144, 0, 0, 1, 0, 0, 0, 1, 0, '', 'Project Metalgear 5', 180000000, 100, 0, '2020-01-24', '2019-01-01', '', 1, 1, '2020-01-28 17:55:53', 7, '2020-01-28 17:55:53', 0),
	(145, 0, 0, 1, 0, 0, 0, 1, 0, '', 'metalgear1', 41604, 100, 0, '2020-02-01', '2019-01-01', '', 1, 1, '2020-01-28 17:57:43', 7, '2020-01-28 17:57:43', 0),
	(146, 0, 0, 7, 0, 21, 130, 1, 0, '', 'Paket Tour project', 9700000, 100, 0, '2020-01-31', '2019-01-01', '', 1, 1, '2020-01-28 18:06:46', 7, '2020-01-28 18:06:46', 0),
	(147, 0, 0, 7, 0, 28, 93, 1, 0, '', 'h1', 41604, 100, 0, '2020-01-30', '2019-01-01', '', 1, 1, '2020-01-28 18:16:06', 7, '2020-01-28 18:22:27', 7),
	(148, 0, 0, 7, 0, 34, 11, 1, 0, '', 'Zelda', 90000000, 100, 0, '2020-01-30', '2019-01-01', '', 1, 1, '2020-01-28 19:15:10', 7, '2020-01-28 19:15:10', 0),
	(149, 1, 1, 7, 0, 34, 11, 1, 0, '', 'kamenrider', 9700000, 1000, 1, '2020-01-30', '2019-01-01', '', 1, 1, '2020-01-28 19:18:13', 7, '2020-01-31 15:52:35', 7);

-- Dumping structure for table crm3.crm3_opportunity_business
CREATE TABLE IF NOT EXISTS `crm3_opportunity_business` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL DEFAULT '',
  `presence` int(9) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `input_by` int(9) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `update_by` int(9) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_opportunity_business: ~2 rows (approximately)
INSERT INTO `crm3_opportunity_business` (`id`, `name`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'New Business', 1, '2020-01-01 00:00:00', 0, '2020-01-01 00:00:00', 0),
	(2, 'Existing Business', 1, '2020-01-01 00:00:00', 0, '2020-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_opportunity_log
CREATE TABLE IF NOT EXISTS `crm3_opportunity_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_opportunity` int(6) NOT NULL DEFAULT '0',
  `id_user` int(6) NOT NULL DEFAULT '0',
  `id_stage` int(6) NOT NULL DEFAULT '0',
  `id_currency` int(3) NOT NULL DEFAULT '0',
  `amount` float(12,0) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_opportunity_log: ~49 rows (approximately)
INSERT INTO `crm3_opportunity_log` (`id`, `id_opportunity`, `id_user`, `id_stage`, `id_currency`, `amount`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 105, 1, 100, 1, 0, 1, 1, '2019-07-18 16:01:30', 1, '2019-07-18 16:01:30', 0),
	(2, 105, 1, 101, 1, 0, 1, 1, '2019-07-18 16:03:07', 1, '2019-07-18 16:03:07', 0),
	(3, 105, 1, 103, 1, 0, 1, 1, '2019-07-18 16:03:59', 1, '2019-07-18 16:03:59', 0),
	(4, 105, 1, 101, 1, 0, 1, 1, '2019-07-18 16:04:08', 1, '2019-07-18 16:04:08', 0),
	(5, 105, 1, 103, 1, 0, 1, 1, '2019-07-18 16:04:11', 1, '2019-07-18 16:04:11', 0),
	(6, 105, 1, 104, 1, 0, 1, 1, '2019-07-18 16:04:15', 1, '2019-07-18 16:04:15', 0),
	(7, 105, 1, 101, 1, 0, 1, 1, '2019-07-18 17:34:51', 1, '2019-07-18 17:34:51', 0),
	(8, 104, 1, 100, 1, 0, 1, 1, '2019-07-18 17:49:08', 1, '2019-07-18 17:49:08', 0),
	(9, 103, 1, 100, 1, 0, 1, 1, '2019-07-18 18:33:22', 1, '2019-07-18 18:33:22', 0),
	(10, 103, 5, 104, 1, 0, 1, 1, '2019-07-18 19:33:06', 1, '2019-07-18 19:33:06', 0),
	(11, 103, 5, 104, 1, 0, 1, 1, '2019-07-18 19:33:06', 1, '2019-07-18 19:33:06', 0),
	(12, 103, 5, 104, 1, 0, 1, 1, '2019-07-18 19:33:19', 1, '2019-07-18 19:33:19', 0),
	(13, 103, 5, 104, 1, 0, 1, 1, '2019-07-18 19:33:19', 1, '2019-07-18 19:33:19', 0),
	(14, 103, 5, 104, 1, 0, 1, 1, '2019-07-18 19:34:24', 1, '2019-07-18 19:34:24', 0),
	(15, 103, 5, 104, 1, 0, 1, 1, '2019-07-18 19:34:24', 1, '2019-07-18 19:34:24', 0),
	(16, 103, 5, 104, 1, 0, 1, 1, '2019-07-18 19:35:50', 1, '2019-07-18 19:35:50', 0),
	(17, 103, 5, 100, 1, 0, 1, 1, '2019-07-18 19:35:50', 1, '2019-07-18 19:35:50', 0),
	(18, 103, 5, 100, 1, 0, 1, 1, '2019-07-18 19:39:52', 1, '2019-07-18 19:39:52', 0),
	(19, 103, 5, 104, 1, 0, 1, 1, '2019-07-18 19:40:08', 1, '2019-07-18 19:40:08', 0),
	(20, 103, 5, 10, 1, 0, 1, 1, '2019-07-18 19:40:08', 1, '2019-07-18 19:40:08', 0),
	(21, 103, 5, 10, 1, 0, 1, 1, '2019-07-18 19:40:14', 1, '2019-07-18 19:40:14', 0),
	(22, 103, 5, 10, 1, 0, 1, 1, '2019-07-18 19:40:14', 1, '2019-07-18 19:40:14', 0),
	(23, 105, 1, 104, 1, 0, 1, 1, '2019-07-18 19:45:04', 1, '2019-07-18 19:45:04', 0),
	(24, 105, 1, 10, 1, 0, 1, 1, '2019-07-18 19:45:04', 1, '2019-07-18 19:45:04', 0),
	(25, 102, 4, 100, 1, 0, 1, 1, '2020-01-03 17:53:04', 7, '2020-01-03 17:53:04', 0),
	(26, 101, 1, 100, 0, 0, 1, 1, '2020-01-12 01:54:41', 7, '2020-01-12 01:54:41', 0),
	(27, 102, 4, 104, 1, 0, 1, 1, '2020-01-16 09:52:59', 7, '2020-01-16 09:52:59', 0),
	(28, 147, 7, 101, 1, 0, 1, 1, '2020-01-28 18:22:27', 7, '2020-01-28 18:22:27', 0),
	(29, 149, 7, 100, 1, 0, 1, 1, '2020-01-31 12:06:21', 7, '2020-01-31 12:06:21', 0),
	(30, 102, 7, 101, 1, 0, 1, 1, '2020-01-31 12:20:48', 7, '2020-01-31 12:20:48', 0),
	(31, 102, 7, 104, 1, 0, 1, 1, '2020-01-31 14:58:45', 7, '2020-01-31 14:58:45', 0),
	(32, 102, 7, 104, 1, 0, 1, 1, '2020-01-31 14:58:45', 7, '2020-01-31 14:58:45', 0),
	(33, 101, 1, 101, 0, 0, 1, 1, '2020-01-31 15:10:27', 7, '2020-01-31 15:10:27', 0),
	(34, 101, 1, 104, 0, 0, 1, 1, '2020-01-31 15:10:31', 7, '2020-01-31 15:10:31', 0),
	(35, 101, 1, 104, 0, 0, 1, 1, '2020-01-31 15:10:40', 7, '2020-01-31 15:10:40', 0),
	(36, 143, 0, 0, 1, 0, 1, 1, '2020-01-31 15:21:44', 7, '2020-01-31 15:21:44', 0),
	(37, 149, 7, 104, 1, 0, 1, 1, '2020-01-31 15:35:49', 7, '2020-01-31 15:35:49', 0),
	(38, 149, 7, 10, 1, 0, 1, 1, '2020-01-31 15:35:49', 7, '2020-01-31 15:35:49', 0),
	(39, 149, 7, 10, 1, 0, 1, 1, '2020-01-31 15:43:07', 7, '2020-01-31 15:43:07', 0),
	(40, 149, 7, 10, 1, 0, 1, 1, '2020-01-31 15:43:20', 7, '2020-01-31 15:43:20', 0),
	(41, 149, 7, 10, 1, 0, 1, 1, '2020-01-31 15:43:24', 7, '2020-01-31 15:43:24', 0),
	(42, 149, 7, 10, 1, 0, 1, 1, '2020-01-31 15:43:27', 7, '2020-01-31 15:43:27', 0),
	(43, 149, 7, 10, 1, 0, 1, 1, '2020-01-31 15:44:14', 7, '2020-01-31 15:44:14', 0),
	(44, 149, 7, 10, 1, 0, 1, 1, '2020-01-31 15:44:33', 7, '2020-01-31 15:44:33', 0),
	(45, 149, 7, 10, 1, 0, 1, 1, '2020-01-31 15:44:59', 7, '2020-01-31 15:44:59', 0),
	(46, 149, 7, 103, 1, 0, 1, 1, '2020-01-31 15:46:11', 7, '2020-01-31 15:46:11', 0),
	(47, 149, 7, 104, 1, 0, 1, 1, '2020-01-31 15:46:32', 7, '2020-01-31 15:46:32', 0),
	(48, 149, 7, 10, 1, 0, 1, 1, '2020-01-31 15:46:32', 7, '2020-01-31 15:46:32', 0),
	(49, 149, 7, 10, 1, 0, 1, 1, '2020-01-31 15:48:50', 7, '2020-01-31 15:48:50', 0),
	(50, 149, 7, 104, 0, 9700000, 1, 1, '2020-01-31 15:52:35', 7, '2020-01-31 15:52:35', 0),
	(51, 149, 7, 1000, 0, 9700000, 1, 1, '2020-01-31 15:52:35', 7, '2020-01-31 15:52:35', 0);

-- Dumping structure for table crm3.crm3_opportunity_product
CREATE TABLE IF NOT EXISTS `crm3_opportunity_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_opportunity` int(11) NOT NULL DEFAULT '0',
  `id_product` int(11) NOT NULL DEFAULT '0',
  `id_price_list` int(11) NOT NULL DEFAULT '0',
  `price` float(12,0) NOT NULL DEFAULT '0',
  `qty` int(6) NOT NULL DEFAULT '0',
  `discount` float(2,0) NOT NULL DEFAULT '0',
  `total` float(12,0) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_opportunity_product: ~20 rows (approximately)
INSERT INTO `crm3_opportunity_product` (`id`, `id_opportunity`, `id_product`, `id_price_list`, `price`, `qty`, `discount`, `total`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 102, 1, 34, 10000000, 1, 0, 10000000, 1, 1, '2020-01-15 12:18:20', 7, '2020-01-15 12:18:20', 0),
	(2, 102, 2, 10, 30000000, 1, 0, 30000000, 1, 1, '2020-01-15 12:18:20', 7, '2020-01-15 12:18:20', 0),
	(3, 102, 3, 11, 55000000, 1, 0, 55000000, 1, 1, '2020-01-15 12:18:20', 7, '2020-01-15 12:18:20', 0),
	(4, 102, 4, 13, 80000000, 1, 0, 80000000, 1, 1, '2020-01-15 12:18:20', 7, '2020-01-15 12:18:20', 0),
	(5, 149, 1, 14, 10000000, 1, 0, 10000000, 1, 1, '2020-01-30 00:59:50', 7, '2020-01-30 00:59:50', 0),
	(6, 149, 1, 29, 10000000, 1, 0, 10000000, 1, 1, '2020-01-30 00:59:50', 7, '2020-01-30 00:59:50', 0),
	(7, 102, 4, 13, 80000000, 1, 0, 80000000, 1, 1, '2020-02-03 17:11:09', 7, '2020-02-03 17:11:09', 0),
	(8, 102, 2, 10, 30000000, 1, 0, 30000000, 1, 1, '2020-02-03 17:11:09', 7, '2020-02-03 17:11:09', 0),
	(9, 102, 1, 34, 10000000, 1, 0, 10000000, 1, 1, '2020-02-03 17:11:09', 7, '2020-02-03 17:11:09', 0),
	(10, 146, 2, 0, 600000, 1, 0, 600000, 1, 1, '2020-02-05 15:35:21', 7, '2020-02-05 15:35:21', 0),
	(11, 146, 4, 0, 5000000, 1, 0, 5000000, 1, 1, '2020-02-05 15:35:21', 7, '2020-02-05 15:35:21', 0),
	(12, 146, 3, 0, 1200000, 1, 0, 1200000, 1, 1, '2020-02-05 15:35:21', 7, '2020-02-05 15:35:21', 0),
	(13, 146, 3, 0, 1200000, 1, 0, 1200000, 1, 1, '2020-02-05 15:38:31', 7, '2020-02-05 15:38:31', 0),
	(14, 148, 2, 0, 22, 1, 0, 22, 1, 1, '2020-02-05 18:54:59', 7, '2020-02-05 18:54:59', 0),
	(15, 148, 2, 0, 22, 1, 0, 22, 1, 1, '2020-02-05 18:54:59', 7, '2020-02-05 18:54:59', 0),
	(16, 148, 5, 0, 8000000, 1, 0, 8000000, 1, 1, '2020-02-05 18:54:59', 7, '2020-02-05 18:54:59', 0),
	(17, 102, 4, 0, 33, 1, 0, 33, 1, 1, '2020-02-06 15:59:09', 7, '2020-02-06 15:59:09', 0),
	(18, 102, 5, 0, 8000000, 1, 0, 8000000, 1, 1, '2020-02-07 21:00:36', 7, '2020-02-07 21:00:36', 0),
	(19, 102, 2, 0, 22, 1, 0, 22, 1, 1, '2020-02-07 21:00:36', 7, '2020-02-07 21:00:36', 0),
	(20, 102, 4, 0, 33, 1, 0, 33, 1, 1, '2020-02-07 21:00:36', 7, '2020-02-07 21:00:36', 0),
	(21, 102, 3, 0, 11, 1, 0, 11, 1, 1, '2020-02-07 21:00:36', 7, '2020-02-07 21:00:36', 0),
	(22, 102, 8, 0, 3600000, 1, 0, 3600000, 1, 1, '2020-02-07 21:00:36', 7, '2020-02-07 21:00:36', 0);

-- Dumping structure for table crm3.crm3_opportunity_stage
CREATE TABLE IF NOT EXISTS `crm3_opportunity_stage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `progress` int(3) NOT NULL DEFAULT '0',
  `ilock` int(1) NOT NULL DEFAULT '0',
  `won` int(1) NOT NULL DEFAULT '0',
  `notes` text NOT NULL,
  `selectable` int(1) NOT NULL DEFAULT '1',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3001 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_opportunity_stage: ~7 rows (approximately)
INSERT INTO `crm3_opportunity_stage` (`id`, `name`, `progress`, `ilock`, `won`, `notes`, `selectable`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(10, 'New', 1, 1, 0, 'New Opportunity', 0, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(100, 'Prospecting', 10, 0, 0, 'Map out your sales process, his means actively defining the specific phases of your sales process and determining which of them you will reflect in your Salesforce Opportunity Stages', 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(101, 'Analysis', 30, 0, 0, 'Define entrance and exit criteria for each stage\r\nAn opportunity stage is not a one-off milestone, as it includes a number of key tasks to be completed before moving to the next stage', 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(103, 'Proposal', 50, 0, 0, 'Customize options for opportunities to help your sales reps close deals faster.', 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(104, 'Negotiation', 80, 0, 0, 'Revise your opportunity stages\r\nSince sales process evolves and may significantly change with time, you should periodically revisit your sales process to ensure your opportunity stages are still relevant.', 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(1000, 'Closed Deal', 100, 1, 1, '', 0, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(3000, 'Closed Lost', 99, 1, 0, '', 0, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_opportunity_stage_done
CREATE TABLE IF NOT EXISTS `crm3_opportunity_stage_done` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_opportunity` int(6) NOT NULL DEFAULT '0',
  `id_stage` int(6) NOT NULL DEFAULT '0',
  `done` int(1) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_opportunity_stage_done: ~21 rows (approximately)
INSERT INTO `crm3_opportunity_stage_done` (`id`, `id_opportunity`, `id_stage`, `done`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 105, 101, 1, 1, 1, '2019-07-18 17:15:33', 1, '2019-07-18 17:30:47', 1),
	(4, 105, 103, 1, 1, 1, '2019-07-18 17:25:03', 1, '2019-07-18 17:34:45', 1),
	(5, 105, 104, 1, 1, 1, '2019-07-18 17:27:43', 1, '2019-07-18 17:37:11', 1),
	(8, 105, 100, 1, 1, 1, '2019-07-18 17:27:57', 1, '2019-07-18 17:27:57', 0),
	(13, 104, 100, 1, 1, 1, '2019-07-18 17:48:59', 1, '2019-07-18 17:48:59', 0),
	(14, 104, 101, 1, 1, 1, '2019-07-18 17:49:01', 1, '2019-07-18 17:49:01', 0),
	(15, 102, 100, 1, 1, 1, '2020-01-16 09:52:10', 7, '2020-01-16 09:52:10', 0),
	(16, 102, 101, 1, 1, 1, '2020-01-16 14:21:23', 7, '2020-01-16 14:25:44', 7),
	(17, 102, 104, 1, 1, 1, '2020-01-16 14:21:54', 7, '2020-01-31 12:20:50', 7),
	(18, 102, 103, 1, 1, 1, '2020-01-16 14:24:24', 7, '2020-01-16 14:25:48', 7),
	(19, 147, 100, 1, 1, 1, '2020-01-28 18:22:33', 7, '2020-01-28 18:22:33', 0),
	(20, 147, 101, 1, 1, 1, '2020-01-28 18:22:35', 7, '2020-01-28 18:22:35', 0),
	(21, 149, 100, 1, 1, 1, '2020-01-31 11:57:47', 7, '2020-01-31 11:57:47', 0),
	(22, 149, 101, 1, 1, 1, '2020-01-31 11:57:49', 7, '2020-01-31 11:57:49', 0),
	(23, 149, 103, 1, 1, 1, '2020-01-31 11:57:50', 7, '2020-01-31 11:57:50', 0),
	(24, 149, 104, 1, 1, 1, '2020-01-31 11:57:51', 7, '2020-01-31 11:57:51', 0),
	(25, 101, 100, 1, 1, 1, '2020-01-31 15:10:19', 7, '2020-01-31 15:10:19', 0),
	(26, 101, 101, 1, 1, 1, '2020-01-31 15:10:21', 7, '2020-01-31 15:10:21', 0),
	(27, 101, 103, 1, 1, 1, '2020-01-31 15:10:24', 7, '2020-01-31 15:10:24', 0),
	(28, 101, 104, 1, 1, 1, '2020-01-31 15:10:25', 7, '2020-01-31 15:10:25', 0),
	(29, 143, 100, 1, 1, 1, '2020-01-31 15:21:39', 7, '2020-01-31 15:21:39', 0),
	(30, 143, 101, 1, 1, 1, '2020-01-31 15:21:40', 7, '2020-01-31 15:21:40', 0),
	(31, 143, 103, 1, 1, 1, '2020-01-31 15:21:42', 7, '2020-01-31 15:21:42', 0),
	(32, 143, 104, 1, 1, 1, '2020-01-31 15:21:43', 7, '2020-01-31 15:21:43', 0);

-- Dumping structure for table crm3.crm3_price_list
CREATE TABLE IF NOT EXISTS `crm3_price_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_currency` int(2) NOT NULL DEFAULT '1',
  `name` varchar(50) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `expired` date NOT NULL DEFAULT '2020-01-01',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_price_list: ~2 rows (approximately)
INSERT INTO `crm3_price_list` (`id`, `id_currency`, `name`, `description`, `expired`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 1, 'Product Samsung TV 2020', 'Description Samsung TV 2020', '2020-01-01', 1, 1, '2020-01-02 15:42:07', 7, '2020-01-02 15:42:07', 0),
	(2, 1, 'Diesel Generator 2020', '', '2020-01-01', 1, 1, '2020-01-02 15:53:13', 7, '2020-01-02 15:53:13', 0),
	(3, 1, 'Yamaya C80', 'Produk gitar yamaha klasis', '2020-01-01', 1, 1, '2020-02-11 01:26:02', 7, '2020-02-11 01:26:02', 0);

-- Dumping structure for table crm3.crm3_price_list_catalog
CREATE TABLE IF NOT EXISTS `crm3_price_list_catalog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_price_list` int(11) NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_price_list_catalog: ~4 rows (approximately)
INSERT INTO `crm3_price_list_catalog` (`id`, `id_price_list`, `name`, `description`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 1, 'TV LED', 'list TV LED', 1, 1, '2020-01-02 17:17:29', 7, '2020-01-02 17:17:29', 0),
	(2, 1, 'TV QLED 2020', '', 1, 1, '2020-01-02 17:19:59', 7, '2020-01-02 17:19:59', 0),
	(3, 1, 'Samsung OLED', '', 1, 1, '2020-01-02 17:51:45', 7, '2020-01-02 17:51:45', 0),
	(4, 2, '10000kw', '', 1, 1, '2020-01-02 17:56:56', 7, '2020-01-02 17:56:56', 0),
	(5, 2, '1000000kw', '', 1, 1, '2020-01-02 17:57:07', 7, '2020-01-02 17:57:07', 0);

-- Dumping structure for table crm3.crm3_price_list_class
CREATE TABLE IF NOT EXISTS `crm3_price_list_class` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `id_company_class` int(9) NOT NULL DEFAULT '0',
  `id_price_list` int(9) NOT NULL DEFAULT '0',
  `discount` float NOT NULL DEFAULT '0',
  `input_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `input_by` int(9) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `update_by` int(9) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_price_list_class: ~0 rows (approximately)

-- Dumping structure for table crm3.crm3_price_list_product
CREATE TABLE IF NOT EXISTS `crm3_price_list_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_price_list` int(11) NOT NULL DEFAULT '0',
  `id_price_list_catalog` int(11) NOT NULL DEFAULT '0',
  `id_product` int(11) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `price` float(12,0) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_price_list_product: ~34 rows (approximately)
INSERT INTO `crm3_price_list_product` (`id`, `id_price_list`, `id_price_list_catalog`, `id_product`, `description`, `price`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 1, 0, 2, '', 100000, 1, 1, '2020-01-02 19:09:49', 7, '2020-01-02 19:09:49', 0),
	(2, 221, 1, 4, '', 123123336, 1, 0, '2020-01-02 19:11:05', 7, '2020-01-03 13:00:02', 7),
	(3, 221, 5, 2, '', 1233213, 1, 1, '2020-01-02 19:11:16', 7, '2020-01-02 19:11:16', 0),
	(4, 2, 5, 4, '', 434343424, 1, 1, '2020-01-02 19:14:18', 7, '2020-01-02 19:14:18', 0),
	(5, 2, 5, 4, '', 434343424, 1, 1, '2020-01-02 19:14:29', 7, '2020-01-02 19:14:29', 0),
	(6, 2, 5, 1, '', 1, 1, 1, '2020-01-02 19:14:45', 7, '2020-01-02 19:14:45', 0),
	(7, 2, 5, 1, '', 2, 1, 1, '2020-01-02 19:14:46', 7, '2020-01-02 19:14:46', 0),
	(8, 2, 5, 1, '', 3, 1, 1, '2020-01-02 19:14:47', 7, '2020-01-02 19:14:47', 0),
	(9, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(10, 1, 1, 2, 'Discover millions of funny WhatsApp stickers and create your own stickers.\n- Explore millions of funny stickers and use them in your chats and status\n- Create stickers from your photos with new Auto Cut technology\n- Easily export your stickers to WhatsApp (WAStickerApps)\n- Share your sticker packs with friends through custom links', 30000000, 1, 1, '2020-01-03 11:42:09', 7, '2020-01-03 13:31:42', 7),
	(11, 1, 1, 3, '1. Setelah terinstal, tekan ikon kamera di sudut kiri bawah layar\n\n2. Kita bisa memotret langsung dengan mengarahkan wajah sesuai area atau memilih foto yang sudah ada dalam ponsel dengan menekan ikon foto di bagian kiri bawah\n\n3. Atur bentuk muka dan rambut sesuai keinginan. Tekan OK bila sudah\n\n4. Seketika puluhan stiker tersedia dengan muka yang telah dipotret tadi', 55000000, 1, 1, '2020-01-03 11:42:12', 7, '2020-01-03 13:32:01', 7),
	(12, 1, 1, 0, '', 0, 1, 0, '2020-01-03 11:43:16', 7, '2020-01-03 12:59:38', 7),
	(13, 1, 1, 4, '123123123', 80000000, 1, 1, '2020-01-03 12:25:04', 7, '2020-01-03 13:31:16', 7),
	(14, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(15, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(16, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(17, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(18, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(19, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(20, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(21, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(22, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(23, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(24, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(25, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(26, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(27, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(28, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(29, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(30, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(31, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(32, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(33, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(34, 1, 1, 1, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 1, 1, '2020-01-03 11:42:06', 7, '2020-01-03 13:31:02', 7),
	(35, 1, 2, 3, 'sfasdfasdf \nhahsfhasdf', 20000000, 1, 1, '2020-02-03 16:42:50', 7, '2020-02-03 16:43:45', 7),
	(36, 1, 2, 3, 'sfasdfasdfsfsdf asdf asdf\nasdfasdf\nasdfasdf', 2000000, 1, 1, '2020-02-03 16:42:59', 7, '2020-02-03 16:43:21', 7);

-- Dumping structure for table crm3.crm3_product
CREATE TABLE IF NOT EXISTS `crm3_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sku` varchar(50) NOT NULL DEFAULT '',
  `price` int(11) NOT NULL DEFAULT '0',
  `name` varchar(250) NOT NULL,
  `description` text NOT NULL,
  `id_currency` int(2) NOT NULL DEFAULT '1',
  `id_product_type` int(2) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `status` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `input_by` varchar(250) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `update_by` varchar(250) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_product: ~9 rows (approximately)
INSERT INTO `crm3_product` (`id`, `sku`, `price`, `name`, `description`, `id_currency`, `id_product_type`, `presence`, `status`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'CP01', 2351, 'CHECK PRINT SHIRT\r\n', '', 1, 10, 0, 1, '2020-01-01 00:00:00', '0', '2020-02-05 14:52:25', '7'),
	(2, 'CP021', 600000, 'GLORIA HIGH LOGO SNEAKER\r\n', '', 1, 10, 1, 1, '2020-01-01 00:00:00', '0', '2020-02-05 14:58:11', '7'),
	(3, 'CT.R.2x', 1200000, 'CATE RIGID BAG 2x', 'Please Subscribe!\nhttps://www.youtube.com/user/cafemusi...\n\n???? Music For Business?Cafe Music BGM Station?\nEnglish: https://bgm-station.com/en/\nJAPANESE: https://bgm-station.com\n????: https://bgm-station.com/tc/\nEspañol: https://bgm-station.com/es/\n???: https://bgm-station.com/ko/\nYou can use this music at your restaurants, shops, hospitals, offices, part­ies, etc..\nTry free for 14 days.', 1, 10, 1, 1, '2020-01-01 00:00:00', '0', '2020-02-05 14:57:50', '7'),
	(4, 'CP0983', 5000000, 'GUESS CONNECT WATCH', '', 1, 10, 1, 1, '2020-01-01 00:00:00', '0', '2020-02-05 14:58:00', '7'),
	(5, 'a', 8000000, 'Service Manufacture Pipe Gas', '', 1, 20, 1, 1, '2020-01-01 00:00:00', '0', '2020-02-05 14:58:20', '7'),
	(6, 'b', 0, 'Preston Galloway', '', 1, 10, 0, 1, '2020-02-03 12:51:27', '7', '2020-02-03 12:51:27', '0'),
	(7, 'c', 0, 'Preston Galloway', '', 1, 10, 0, 1, '2020-02-03 12:51:29', '7', '2020-02-03 12:51:29', '0'),
	(8, 'd', 3600000, 'Paket Standard', '', 1, 20, 1, 1, '2020-02-03 12:52:12', '7', '2020-02-05 14:58:28', '7'),
	(9, 'WEB01', 0, 'Preston Galloway', '', 1, 20, 0, 1, '2020-02-03 12:54:32', '7', '2020-02-03 12:54:32', '0'),
	(10, 'SA112', 8000000, 'Samsung A 2019', 'Meetings made easy. No paper or servers necessary. Meetings are more productive, efficient and greener when they’re powered by e-Meeting, a personal organizer with impressive sharing capabilities. With a simple mobile AP or WiFi connection, you can link meeting participants by sharing data simultaneously and even take notes on the same whiteboard', 1, 1, 1, 0, '2020-02-11 11:57:26', '7', '2020-02-11 11:57:26', '0'),
	(11, 'Sa19', 890000, 'Samsung A 2019', 'Meetings made easy. No paper or servers necessary. Meetings are more productive, efficient and greener when they’re powered by e-Meeting, a personal organizer with impressive sharing capabilities. With a simple mobile AP or WiFi connection, you can link meeting participants by sharing data simultaneously and even take notes on the same whiteboard', 1, 1, 0, 0, '2020-02-11 12:00:16', '7', '2020-02-11 12:00:16', '0'),
	(12, 'Sa19', 890000, 'Samsung A 2019', 'Meetings made easy. No paper or servers necessary. Meetings are more productive, efficient and greener when they’re powered by e-Meeting, a personal organizer with impressive sharing capabilities. With a simple mobile AP or WiFi connection, you can link meeting participants by sharing data simultaneously and even take notes on the same whiteboard', 1, 1, 0, 0, '2020-02-11 12:00:18', '7', '2020-02-11 12:00:18', '0'),
	(13, 'abc', 123333, 'abc', 'asf', 1, 1, 0, 0, '2020-02-11 12:09:21', '7', '2020-02-11 12:09:21', '0'),
	(14, 'abc', 123333, 'abc', 'asf', 1, 1, 0, 0, '2020-02-11 12:09:40', '7', '2020-02-11 12:09:40', '0'),
	(15, 'WEB012', 40000, 'ab', '1234', 1, 1, 1, 0, '2020-02-11 12:19:15', '7', '2020-02-11 12:19:15', '0');

-- Dumping structure for table crm3.crm3_product_location
CREATE TABLE IF NOT EXISTS `crm3_product_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_product` int(9) NOT NULL DEFAULT '1',
  `location` varchar(250) NOT NULL,
  `qty` int(9) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `input_by` varchar(250) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `update_by` varchar(250) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_product_location: ~20 rows (approximately)
INSERT INTO `crm3_product_location` (`id`, `id_product`, `location`, `qty`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 3, '43434fsdfsdf', 4, 1, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(2, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(3, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(4, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(5, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(6, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(7, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(8, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(9, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(10, 3, 'sfasdfasdfasdf', 32, 1, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(11, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(12, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(13, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(14, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(15, 3, '123123123', 12, 1, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(16, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(17, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(18, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(19, 3, '', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(20, 1, '12', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(21, 1, '22', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0'),
	(22, 1, '33', 1, 0, '2020-01-01 00:00:00', '0', '2020-01-01 00:00:00', '0');

-- Dumping structure for table crm3.crm3_product_type
CREATE TABLE IF NOT EXISTS `crm3_product_type` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `stock` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_product_type: ~2 rows (approximately)
INSERT INTO `crm3_product_type` (`id`, `name`, `stock`) VALUES
	(10, 'Good', 1),
	(20, 'Service', 0);

-- Dumping structure for table crm3.crm3_quote
CREATE TABLE IF NOT EXISTS `crm3_quote` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_opportunity` int(11) NOT NULL DEFAULT '0',
  `id_user` int(9) NOT NULL DEFAULT '0',
  `id_contact` int(9) NOT NULL DEFAULT '0',
  `syncing` int(1) NOT NULL DEFAULT '0',
  `quotes_number` varchar(50) NOT NULL DEFAULT '0',
  `name` varchar(250) NOT NULL DEFAULT '',
  `grand_total` float(20,2) NOT NULL DEFAULT '0.00',
  `expired_date` date NOT NULL DEFAULT '2019-01-01',
  `id_template` int(11) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `discount` float NOT NULL DEFAULT '0',
  `tax` float NOT NULL DEFAULT '0',
  `shipping` float NOT NULL DEFAULT '0',
  `email` text NOT NULL,
  `phone` text NOT NULL,
  `fax` text NOT NULL,
  `term` text NOT NULL,
  `bill_name` varchar(250) NOT NULL DEFAULT '',
  `bill_street1` varchar(250) NOT NULL DEFAULT '',
  `bill_street2` varchar(250) NOT NULL DEFAULT '',
  `bill_city` varchar(250) NOT NULL DEFAULT '',
  `bill_state` varchar(250) NOT NULL DEFAULT '',
  `bill_code` varchar(250) NOT NULL DEFAULT '',
  `bill_country` varchar(250) NOT NULL DEFAULT '',
  `ship_name` varchar(250) NOT NULL DEFAULT '',
  `ship_street1` varchar(250) NOT NULL DEFAULT '',
  `ship_street2` varchar(250) NOT NULL DEFAULT '',
  `ship_city` varchar(250) NOT NULL DEFAULT '',
  `ship_state` varchar(250) NOT NULL DEFAULT '',
  `ship_code` varchar(250) NOT NULL DEFAULT '',
  `ship_country` varchar(250) NOT NULL DEFAULT '',
  `id_quote_status` int(3) NOT NULL DEFAULT '1',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `quotes_number` (`quotes_number`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_quote: ~8 rows (approximately)
INSERT INTO `crm3_quote` (`id`, `id_opportunity`, `id_user`, `id_contact`, `syncing`, `quotes_number`, `name`, `grand_total`, `expired_date`, `id_template`, `description`, `discount`, `tax`, `shipping`, `email`, `phone`, `fax`, `term`, `bill_name`, `bill_street1`, `bill_street2`, `bill_city`, `bill_state`, `bill_code`, `bill_country`, `ship_name`, `ship_street1`, `ship_street2`, `ship_city`, `ship_state`, `ship_code`, `ship_country`, `id_quote_status`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(5, 102, 0, 0, 0, '000006', 'Alexandra Abigail', 77.00, '2020-01-18', 0, '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-01-07 13:08:01', 7, '2020-02-05 19:02:50', 7),
	(6, 102, 0, 32, 1, '000007', 'Preston Galloway', 39117716.00, '2020-02-15', 0, '4234234234234', 42, 12, 397000, 'reeserocha@cuvox.de', '8045743677', '123123', '', 'Preston Galloway', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', 'Alexandra Abigail', 'graha bernadette building', 'jl. claire selatan ii/4', 'Bangka Barat', 'Bangka Belitung', '11160', '', 400, 1, 1, '2020-01-07 13:44:29', 7, '2020-02-07 21:08:24', 7),
	(7, 102, 0, 0, 0, '000008', 'Project x023', 8000000.00, '2020-01-30', 0, '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-01-29 14:03:56', 7, '2020-02-05 15:57:43', 7),
	(8, 102, 0, 0, 0, '000009', 'taigahn 2', 0.00, '2020-01-31', 0, '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-01-29 14:53:40', 7, '2020-02-06 16:02:22', 7),
	(9, 102, 0, 0, 0, '000010', 'taigahan 3', 0.00, '2020-01-31', 0, '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-01-29 14:54:20', 7, '2020-02-06 16:08:04', 7),
	(10, 102, 0, 0, 0, '000011', 'taigahan 3', 11200000.00, '2020-01-31', 0, '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-01-29 14:54:25', 7, '2020-02-05 15:57:55', 7),
	(11, 102, 0, 0, 0, '000012', 'tagiah 4', 11.00, '2020-02-01', 0, '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-01-29 14:55:02', 7, '2020-02-06 16:08:20', 7),
	(12, 102, 0, 0, 0, '000013', 'tagiah 5', 0.00, '2020-02-01', 0, '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-01-29 14:59:41', 7, '2020-02-06 16:02:06', 7);

-- Dumping structure for table crm3.crm3_quote_detail
CREATE TABLE IF NOT EXISTS `crm3_quote_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_quote` int(11) NOT NULL DEFAULT '0',
  `id_product` int(11) NOT NULL DEFAULT '0',
  `id_price_list` int(11) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `price` float NOT NULL DEFAULT '0',
  `discount` float NOT NULL DEFAULT '0',
  `qty` int(6) NOT NULL DEFAULT '0',
  `total` float NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `sorting` int(3) NOT NULL DEFAULT '999',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_quote_detail: ~39 rows (approximately)
INSERT INTO `crm3_quote_detail` (`id`, `id_quote`, `id_product`, `id_price_list`, `description`, `price`, `discount`, `qty`, `total`, `status`, `presence`, `sorting`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(5, 6, 1, 9, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 1, 10000000, 1, 0, 999, '2020-01-08 17:08:37', 7, '2020-01-10 11:06:32', 7),
	(6, 6, 1, 14, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 34, 10000000, 1, 0, 999, '2020-01-08 17:08:37', 7, '2020-01-10 14:07:21', 7),
	(7, 6, 1, 15, 'roundown acara', 10000000, 12, 3, 26400000, 1, 0, 5, '2020-01-08 17:08:37', 7, '2020-01-15 12:17:39', 7),
	(8, 6, 1, 15, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 10, 32, 288000000, 1, 0, 999, '2020-01-08 17:08:37', 7, '2020-01-10 14:16:36', 7),
	(9, 6, 1, 15, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 21, 12, 94800000, 1, 0, 999, '2020-01-08 17:08:37', 7, '2020-01-10 14:14:56', 7),
	(10, 6, 1, 14, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 1, 10000000, 1, 0, 999, '2020-01-08 17:10:24', 7, '2020-01-10 14:14:54', 7),
	(11, 6, 1, 14, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 7, 10000000, 1, 0, 999, '2020-01-08 17:10:24', 7, '2020-01-10 14:14:25', 7),
	(12, 6, 1, 15, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 1, 10000000, 1, 0, 999, '2020-01-08 17:10:24', 7, '2020-01-10 11:06:35', 7),
	(13, 6, 1, 16, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 1, 10000000, 1, 0, 999, '2020-01-08 17:10:24', 7, '2020-01-10 11:06:35', 7),
	(14, 6, 4, 13, '123123123', 80000000, 0, 1, 80000000, 1, 0, 999, '2020-01-08 17:24:55', 7, '2020-01-10 11:06:34', 7),
	(15, 6, 1, 9, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 10, 4, 36000000, 1, 0, 2, '2020-01-10 14:20:44', 7, '2020-01-14 16:07:45', 7),
	(16, 6, 1, 9, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 1, 10000000, 1, 0, 999, '2020-01-10 14:20:44', 7, '2020-01-10 15:41:16', 7),
	(17, 6, 1, 15, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 1, 10000000, 1, 0, 999, '2020-01-10 14:20:44', 7, '2020-01-10 14:29:57', 7),
	(18, 6, 4, 13, '3', 80000000, 12, 4, 281600000, 1, 0, 4, '2020-01-10 14:20:44', 7, '2020-01-14 16:07:47', 7),
	(19, 6, 3, 11, '1. Setelah terinstal, tekan ikon kamera di sudut kiri bawah layar\n\n2. Kita bisa memotret langsung dengan mengarahkan wajah sesuai area atau memilih foto yang sudah ada dalam ponsel dengan menekan ikon foto di bagian kiri bawah\n\n3. Atur bentuk muka dan rambut sesuai keinginan. Tekan OK bila sudah\n\n4. Seketika puluhan stiker tersedia dengan muka yang telah dipotret tadi', 55000000, 4, 1, 52800000, 1, 0, 999, '2020-01-10 14:20:44', 7, '2020-01-10 15:42:29', 7),
	(20, 6, 2, 10, 'Discover millions of funny WhatsApp stickers and create your own stickers.\n- Explore millions of funny stickers and use them in your chats and status\n- Create stickers from your photos with new Auto Cut technology\n- Easily export your stickers to WhatsApp (WAStickerApps)\n- Share your sticker packs with friends through custom links', 30000000, 0, 1, 30000000, 1, 0, 999, '2020-01-10 14:20:44', 7, '2020-01-10 14:20:59', 7),
	(21, 6, 1, 18, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 1, 10000000, 1, 0, 999, '2020-01-10 15:42:15', 7, '2020-01-10 15:42:18', 7),
	(22, 6, 1, 15, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 1, 10000000, 1, 0, 999, '2020-01-10 15:42:15', 7, '2020-01-10 15:42:32', 7),
	(23, 6, 4, 13, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 80000000, 0, 1, 80000000, 1, 0, 1, '2020-01-10 15:48:34', 7, '2020-01-14 16:07:44', 7),
	(24, 6, 2, 10, 'Discover millions of funny WhatsApp stickers and create your own stickers.\n- Explore millions of funny stickers and use them in your chats and status\n- Create stickers from your photos with new Auto Cut technology\n- Easily export your stickers to WhatsApp (WAStickerApps)\n- Share your sticker packs with friends through custom links', 30000000, 0, 1, 30000000, 1, 0, 3, '2020-01-10 15:48:34', 7, '2020-01-14 16:07:46', 7),
	(25, 6, 3, 11, '1. Setelah terinstal, tekan ikon kamera di sudut kiri bawah layar\n\n2. Kita bisa memotret langsung dengan mengarahkan wajah sesuai area atau memilih foto yang sudah ada dalam ponsel dengan menekan ikon foto di bagian kiri bawah\n\n3. Atur bentuk muka dan rambut sesuai keinginan. Tekan OK bila sudah\n\n4. Seketika puluhan stiker tersedia dengan muka yang telah dipotret tadi', 55000000, 0, 1, 55000000, 1, 0, 999, '2020-01-10 15:48:34', 7, '2020-01-10 16:01:16', 7),
	(26, 6, 1, 34, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 1, 10000000, 1, 0, 999, '2020-01-15 12:14:50', 7, '2020-01-15 12:17:40', 7),
	(28, 6, 1, 34, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 2, 20000000, 1, 1, 999, '2020-01-15 12:18:20', 7, '2020-01-16 14:46:52', 7),
	(29, 6, 2, 10, 'Discover millions of funny WhatsApp stickers and create your own stickers.\n- Explore millions of funny stickers and use them in your chats and status\n- Create stickers from your photos with new Auto Cut technology\n- Easily export your stickers to WhatsApp (WAStickerApps)\n- Share your sticker packs with friends through custom links', 30000000, 0, 1, 30000000, 1, 0, 999, '2020-01-15 12:18:20', 7, '2020-02-06 15:59:16', 7),
	(30, 6, 3, 11, '1. Setelah terinstal, tekan ikon kamera di sudut kiri bawah layar\n\n2. Kita bisa memotret langsung dengan mengarahkan wajah sesuai area atau memilih foto yang sudah ada dalam ponsel dengan menekan ikon foto di bagian kiri bawah\n\n3. Atur bentuk muka dan rambut sesuai keinginan. Tekan OK bila sudah\n\n4. Seketika puluhan stiker tersedia dengan muka yang telah dipotret tadi', 55000000, 0, 1, 55000000, 1, 0, 999, '2020-01-15 12:18:20', 7, '2020-02-06 15:59:14', 7),
	(31, 6, 4, 13, '123123123', 80000000, 0, 1, 80000000, 1, 0, 999, '2020-01-15 12:18:20', 7, '2020-02-06 15:59:14', 7),
	(32, 6, 4, 13, '123123123', 80000000, 0, 1, 80000000, 1, 0, 999, '2020-02-03 17:11:09', 7, '2020-02-06 15:59:13', 7),
	(33, 6, 2, 10, 'Discover millions of funny WhatsApp stickers and create your own stickers.\n- Explore millions of funny stickers and use them in your chats and status\n- Create stickers from your photos with new Auto Cut technology\n- Easily export your stickers to WhatsApp (WAStickerApps)\n- Share your sticker packs with friends through custom links', 30000000, 0, 1, 30000000, 1, 0, 999, '2020-02-03 17:11:09', 7, '2020-02-06 15:59:16', 7),
	(34, 6, 1, 34, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 2, 20000000, 1, 1, 999, '2020-02-03 17:11:09', 7, '2020-02-06 15:59:54', 7),
	(35, 7, 2, 0, '', 600000, 0, 3, 1800000, 1, 1, 999, '2020-02-05 15:42:29', 7, '2020-02-05 15:57:24', 7),
	(36, 7, 4, 0, '', 5000000, 0, 1, 5000000, 1, 1, 999, '2020-02-05 15:42:29', 7, '2020-02-05 15:42:29', 0),
	(37, 7, 3, 0, 'Please Subscribe!\nhttps://www.youtube.com/user/cafemusi...\n\n???? Music For Business?Cafe Music BGM Station?\nEnglish: https://bgm-station.com/en/\nJAPANESE: https://bgm-station.com\n????: https://bgm-station.com/tc/\nEspañol: https://bgm-station.com/es/\n???: https://bgm-station.com/ko/\nYou can use this music at your restaurants, shops, hospitals, offices, part­ies, etc..\nTry free for 14 days.', 1200000, 0, 1, 1200000, 1, 1, 999, '2020-02-05 15:42:29', 7, '2020-02-05 15:42:29', 0),
	(38, 10, 4, 0, '', 5000000, 0, 2, 10000000, 1, 1, 999, '2020-02-05 15:53:38', 7, '2020-02-05 15:53:45', 7),
	(39, 10, 2, 0, '', 600000, 0, 2, 1200000, 1, 1, 999, '2020-02-05 15:53:38', 7, '2020-02-05 15:57:53', 7),
	(40, 5, 3, 0, 'Please Subscribe!\nhttps://www.youtube.com/user/cafemusi...\n\n???? Music For Business?Cafe Music BGM Station?\nEnglish: https://bgm-station.com/en/\nJAPANESE: https://bgm-station.com\n????: https://bgm-station.com/tc/\nEspañol: https://bgm-station.com/es/\n???: https://bgm-station.com/ko/\nYou can use this music at your restaurants, shops, hospitals, offices, part­ies, etc..\nTry free for 14 days.', 11, 0, 2, 22, 1, 1, 999, '2020-02-05 19:02:41', 7, '2020-02-05 19:02:45', 7),
	(41, 5, 2, 0, '', 22, 0, 1, 22, 1, 1, 999, '2020-02-05 19:02:41', 7, '2020-02-05 19:02:41', 0),
	(42, 5, 4, 0, '', 33, 0, 1, 33, 1, 1, 999, '2020-02-05 19:02:41', 7, '2020-02-05 19:02:41', 0),
	(44, 6, 4, 0, '', 33, 0, 1, 33, 1, 1, 999, '2020-02-06 15:59:09', 7, '2020-02-06 15:59:09', 0),
	(45, 12, 4, 0, '', 33, 0, 1, 33, 1, 1, 999, '2020-02-06 16:02:04', 7, '2020-02-06 16:02:04', 0),
	(46, 8, 3, 0, 'Please Subscribe!\nhttps://www.youtube.com/user/cafemusi...\n\n???? Music For Business?Cafe Music BGM Station?\nEnglish: https://bgm-station.com/en/\nJAPANESE: https://bgm-station.com\n????: https://bgm-station.com/tc/\nEspañol: https://bgm-station.com/es/\n???: https://bgm-station.com/ko/\nYou can use this music at your restaurants, shops, hospitals, offices, part­ies, etc..\nTry free for 14 days.', 11, 0, 1, 11, 1, 1, 999, '2020-02-06 16:02:20', 7, '2020-02-06 16:02:20', 0),
	(47, 11, 3, 0, 'Please Subscribe!\nhttps://www.youtube.com/user/cafemusi...\n\n???? Music For Business?Cafe Music BGM Station?\nEnglish: https://bgm-station.com/en/\nJAPANESE: https://bgm-station.com\n????: https://bgm-station.com/tc/\nEspañol: https://bgm-station.com/es/\n???: https://bgm-station.com/ko/\nYou can use this music at your restaurants, shops, hospitals, offices, part­ies, etc..\nTry free for 14 days.', 11, 0, 1, 11, 1, 1, 999, '2020-02-06 16:08:17', 7, '2020-02-06 16:08:17', 0),
	(48, 6, 5, 0, '', 8000000, 0, 1, 8000000, 1, 1, 999, '2020-02-07 21:00:36', 7, '2020-02-07 21:00:36', 0),
	(49, 6, 2, 0, '', 22, 0, 1, 22, 1, 1, 999, '2020-02-07 21:00:36', 7, '2020-02-07 21:00:36', 0),
	(50, 6, 4, 0, '', 33, 0, 1, 33, 1, 1, 999, '2020-02-07 21:00:36', 7, '2020-02-07 21:00:36', 0),
	(51, 6, 3, 0, 'Please Subscribe!\nhttps://www.youtube.com/user/cafemusi...\n\n???? Music For Business?Cafe Music BGM Station?\nEnglish: https://bgm-station.com/en/\nJAPANESE: https://bgm-station.com\n????: https://bgm-station.com/tc/\nEspañol: https://bgm-station.com/es/\n???: https://bgm-station.com/ko/\nYou can use this music at your restaurants, shops, hospitals, offices, part­ies, etc..\nTry free for 14 days.', 11, 0, 1, 11, 1, 1, 999, '2020-02-07 21:00:36', 7, '2020-02-07 21:00:36', 0),
	(52, 6, 8, 0, '', 3600000, 0, 1, 3600000, 1, 1, 999, '2020-02-07 21:00:36', 7, '2020-02-07 21:00:36', 0);

-- Dumping structure for table crm3.crm3_quote_status
CREATE TABLE IF NOT EXISTS `crm3_quote_status` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=401 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_quote_status: ~5 rows (approximately)
INSERT INTO `crm3_quote_status` (`id`, `name`) VALUES
	(1, 'Draft'),
	(200, 'Review'),
	(300, 'Rejected'),
	(400, 'Approved');

-- Dumping structure for table crm3.crm3_sales_order
CREATE TABLE IF NOT EXISTS `crm3_sales_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_company` int(11) NOT NULL DEFAULT '0',
  `id_opportunity` int(11) NOT NULL DEFAULT '0',
  `id_user` int(9) NOT NULL DEFAULT '0',
  `id_contact` int(9) NOT NULL DEFAULT '0',
  `id_quote` int(9) NOT NULL DEFAULT '0',
  `so_number` varchar(50) NOT NULL DEFAULT '0',
  `name` varchar(250) NOT NULL DEFAULT '',
  `grand_total` float(20,2) NOT NULL DEFAULT '0.00',
  `expired_date` date NOT NULL DEFAULT '2019-01-01',
  `id_template` int(11) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `discount` float NOT NULL DEFAULT '0',
  `tax` float NOT NULL DEFAULT '0',
  `shipping` float NOT NULL DEFAULT '0',
  `email` text NOT NULL,
  `phone` text NOT NULL,
  `fax` text NOT NULL,
  `term` text NOT NULL,
  `bill_name` varchar(250) NOT NULL DEFAULT '',
  `bill_street1` varchar(250) NOT NULL DEFAULT '',
  `bill_street2` varchar(250) NOT NULL DEFAULT '',
  `bill_city` varchar(250) NOT NULL DEFAULT '',
  `bill_state` varchar(250) NOT NULL DEFAULT '',
  `bill_code` varchar(250) NOT NULL DEFAULT '',
  `bill_country` varchar(250) NOT NULL DEFAULT '',
  `ship_name` varchar(250) NOT NULL DEFAULT '',
  `ship_street1` varchar(250) NOT NULL DEFAULT '',
  `ship_street2` varchar(250) NOT NULL DEFAULT '',
  `ship_city` varchar(250) NOT NULL DEFAULT '',
  `ship_state` varchar(250) NOT NULL DEFAULT '',
  `ship_code` varchar(250) NOT NULL DEFAULT '',
  `ship_country` varchar(250) NOT NULL DEFAULT '',
  `id_sales_order_status` int(3) NOT NULL DEFAULT '1',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `quotes_number` (`so_number`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_sales_order: ~7 rows (approximately)
INSERT INTO `crm3_sales_order` (`id`, `id_company`, `id_opportunity`, `id_user`, `id_contact`, `id_quote`, `so_number`, `name`, `grand_total`, `expired_date`, `id_template`, `description`, `discount`, `tax`, `shipping`, `email`, `phone`, `fax`, `term`, `bill_name`, `bill_street1`, `bill_street2`, `bill_city`, `bill_state`, `bill_code`, `bill_country`, `ship_name`, `ship_street1`, `ship_street2`, `ship_city`, `ship_state`, `ship_code`, `ship_country`, `id_sales_order_status`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(37, 0, 102, 7, 32, 6, '000025', 'Sales Order Baru 01a', 17037000.00, '2020-02-07', 0, '0', 20, 20, 397000, 'reeserocha@cuvox.de', 'reeserocha@cuvox.de', '123123', '0', 'Preston Galloway', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', 'Alexandra Abigail', 'graha bernadette building', 'jl. claire selatan ii/4', 'Bangka Barat', 'Bangka Belitung', '11160', '', 1, 1, 1, '2020-02-07 21:09:01', 7, '2020-02-10 17:43:42', 7),
	(38, 0, 102, 7, 32, 6, '000026', 'Sales Order Senin Feb 2020', 39117716.00, '2020-02-10', 0, '0', 42, 12, 397000, 'reeserocha@cuvox.de', 'reeserocha@cuvox.de', '123123', '0', 'Preston Galloway', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-02-10 13:38:55', 7, '2020-02-10 17:43:37', 7),
	(39, 0, 102, 7, 32, 6, '000027', 'SO 003', 13634056.00, '2020-02-10', 0, '0', 42, 12, 397000, 'reeserocha@cuvox.de', 'reeserocha@cuvox.de', '123123', '0', 'Preston Galloway', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 400, 1, 1, '2020-02-10 15:45:50', 7, '2020-02-10 17:11:09', 7),
	(45, 1, 0, 7, 54, 0, '000034', 'Sales Order Baru 05', 0.00, '2020-02-10', 0, '0', 2, 1, 3, 'felix@cuvox.de', '8077666665', '123123123', '0', 'aaaaaaaaaaaaaa', 'aa', 'aaa', 'Bangka Barat', 'Bangka Belitung', '11160', 'b4', 'bbbbbbbbbbbbbb', 'aa', 'bb', 'c1', 'c3', 'c2', 'c4', 1, 1, 1, '2020-02-10 18:57:15', 7, '2020-02-10 18:57:15', 0),
	(46, 5, 0, 7, 0, 0, '000035', 'apa apa emak', 0.00, '2020-02-10', 0, '0', 0, 0, 0, 'felix@cuvox.de', 'felix@cuvox.de', '', '0', 'bbbbbbbbb', 'aa', 'jl. claire selatan ii/4', 'c1', 'c3', 'c2', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-02-10 19:00:33', 7, '2020-02-10 19:05:59', 7),
	(47, 11, 0, 4, 34, 0, '000036', '112', 0.00, '2020-02-10', 0, '123123123', 0, 0, 0, 'asdf', 'sdfasd', 'asdfasdf', '0', '', 'a', 'a', 'b', 'c', '123456', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-02-10 19:07:41', 7, '2020-02-11 00:41:32', 7),
	(48, 93, 102, 5, 28, 6, '000037', 'SO 004', 397000.00, '2020-02-11', 0, '0', 42, 12, 397000, 'reeserocha@cuvox.de', '8045743677', '123123', '0', 'Preston Galloway', '661 Wallabout Street, Chelsea, Arkansas, 375', '', 'Sidney', 'Sidney', '88864', '', '', '', '', '', '', '', '', 1, 1, 1, '2020-02-11 01:23:21', 7, '2020-02-11 01:23:21', 0);

-- Dumping structure for table crm3.crm3_sales_order_detail
CREATE TABLE IF NOT EXISTS `crm3_sales_order_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_sales_order` int(11) NOT NULL DEFAULT '0',
  `id_product` int(11) NOT NULL DEFAULT '0',
  `id_price_list` int(11) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `price` float NOT NULL DEFAULT '0',
  `discount` float NOT NULL DEFAULT '0',
  `qty` int(6) NOT NULL DEFAULT '0',
  `total` float NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `sorting` int(3) NOT NULL DEFAULT '999',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_sales_order_detail: ~24 rows (approximately)
INSERT INTO `crm3_sales_order_detail` (`id`, `id_sales_order`, `id_product`, `id_price_list`, `description`, `price`, `discount`, `qty`, `total`, `status`, `presence`, `sorting`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(104, 37, 5, 0, '', 8000000, 0, 2, 16000000, 1, 1, 999, '2020-02-07 21:09:01', 7, '2020-02-10 16:06:15', 7),
	(105, 37, 2, 0, '', 22, 0, 1, 22, 1, 0, 999, '2020-02-07 21:09:01', 7, '2020-02-10 16:06:01', 7),
	(106, 37, 4, 0, '', 33, 0, 1, 33, 1, 0, 999, '2020-02-07 21:09:01', 7, '2020-02-10 16:06:01', 7),
	(107, 37, 3, 0, 'Please Subscribe!\nhttps://www.youtube.com/user/cafemusi...\n\n???? Music For Business?Cafe Music BGM Station?\nEnglish: https://bgm-station.com/en/\nJAPANESE: https://bgm-station.com\n????: https://bgm-station.com/tc/\nEspañol: https://bgm-station.com/es/\n???: https://bgm-station.com/ko/\nYou can use this music at your restaurants, shops, hospitals, offices, part­ies, etc..\nTry free for 14 days.', 11, 0, 1, 11, 1, 0, 999, '2020-02-07 21:09:01', 7, '2020-02-10 16:06:00', 7),
	(108, 37, 8, 0, '', 3600000, 0, 1, 3600000, 1, 0, 999, '2020-02-07 21:09:01', 7, '2020-02-10 16:06:04', 7),
	(109, 37, 4, 0, '', 33, 0, 1, 33, 1, 0, 999, '2020-02-07 21:09:01', 7, '2020-02-10 16:05:59', 7),
	(110, 37, 1, 34, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 2, 20000000, 1, 0, 999, '2020-02-07 21:09:01', 7, '2020-02-10 16:06:03', 7),
	(111, 37, 1, 34, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 2, 20000000, 1, 0, 999, '2020-02-07 21:09:01', 7, '2020-02-10 16:06:03', 7),
	(112, 38, 5, 0, '', 8000000, 0, 1, 8000000, 1, 1, 999, '2020-02-10 13:38:55', 7, '2020-02-10 13:38:55', 0),
	(113, 38, 2, 0, '', 22, 0, 1, 22, 1, 1, 999, '2020-02-10 13:38:55', 7, '2020-02-10 13:38:55', 0),
	(114, 38, 4, 0, '', 33, 0, 1, 33, 1, 1, 999, '2020-02-10 13:38:55', 7, '2020-02-10 13:38:55', 0),
	(115, 38, 3, 0, 'Please Subscribe!\nhttps://www.youtube.com/user/cafemusi...\n\n???? Music For Business?Cafe Music BGM Station?\nEnglish: https://bgm-station.com/en/\nJAPANESE: https://bgm-station.com\n????: https://bgm-station.com/tc/\nEspañol: https://bgm-station.com/es/\n???: https://bgm-station.com/ko/\nYou can use this music at your restaurants, shops, hospitals, offices, part­ies, etc..\nTry free for 14 days.', 11, 0, 1, 11, 1, 1, 999, '2020-02-10 13:38:55', 7, '2020-02-10 13:38:55', 0),
	(116, 38, 8, 0, '', 3600000, 0, 1, 3600000, 1, 1, 999, '2020-02-10 13:38:55', 7, '2020-02-10 13:38:55', 0),
	(117, 38, 4, 0, '', 33, 0, 1, 33, 1, 1, 999, '2020-02-10 13:38:55', 7, '2020-02-10 13:38:55', 0),
	(118, 38, 1, 34, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 2, 20000000, 1, 1, 999, '2020-02-10 13:38:55', 7, '2020-02-10 13:38:55', 0),
	(119, 38, 1, 34, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 2, 20000000, 1, 1, 999, '2020-02-10 13:38:55', 7, '2020-02-10 13:38:55', 0),
	(120, 39, 5, 0, '', 8000000, 10, 2, 14400000, 1, 1, 999, '2020-02-10 15:45:50', 7, '2020-02-10 16:04:35', 7),
	(121, 39, 2, 0, '', 22, 0, 1, 22, 1, 0, 999, '2020-02-10 15:45:50', 7, '2020-02-10 16:05:05', 7),
	(122, 39, 4, 0, '', 33, 0, 1, 33, 1, 0, 999, '2020-02-10 15:45:50', 7, '2020-02-10 16:05:05', 7),
	(123, 39, 3, 0, 'Please Subscribe!\nhttps://www.youtube.com/user/cafemusi...\n\n???? Music For Business?Cafe Music BGM Station?\nEnglish: https://bgm-station.com/en/\nJAPANESE: https://bgm-station.com\n????: https://bgm-station.com/tc/\nEspañol: https://bgm-station.com/es/\n???: https://bgm-station.com/ko/\nYou can use this music at your restaurants, shops, hospitals, offices, part­ies, etc..\nTry free for 14 days.', 11, 0, 1, 11, 1, 0, 999, '2020-02-10 15:45:50', 7, '2020-02-10 16:05:03', 7),
	(124, 39, 8, 0, '', 3600000, 10, 1, 3240000, 1, 1, 999, '2020-02-10 15:45:50', 7, '2020-02-10 16:10:28', 7),
	(125, 39, 4, 0, '', 33, 0, 1, 33, 1, 0, 999, '2020-02-10 15:45:50', 7, '2020-02-10 16:05:02', 7),
	(126, 39, 1, 34, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 2, 20000000, 1, 0, 999, '2020-02-10 15:45:50', 7, '2020-02-10 16:05:02', 7),
	(127, 39, 1, 34, '1. Run idman636build1.exe\n2. Follow installation instructions\n3. Run Internet Download Manager (IDM) from your start menu\n4. aappaaa', 10000000, 0, 2, 20000000, 1, 0, 999, '2020-02-10 15:45:50', 7, '2020-02-10 16:05:01', 7);

-- Dumping structure for table crm3.crm3_sales_order_status
CREATE TABLE IF NOT EXISTS `crm3_sales_order_status` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT '',
  `editable` int(1) DEFAULT '1',
  `presence` int(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=901 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_sales_order_status: ~3 rows (approximately)
INSERT INTO `crm3_sales_order_status` (`id`, `name`, `editable`, `presence`) VALUES
	(1, 'Draft', 1, 1),
	(400, 'Approved', 0, 1),
	(900, 'Submit', 0, 0);

-- Dumping structure for table crm3.crm3_title
CREATE TABLE IF NOT EXISTS `crm3_title` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_title: ~4 rows (approximately)
INSERT INTO `crm3_title` (`id`, `name`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'Bpk', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(2, 'Ibu', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(3, 'Mr', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(4, 'Mrs', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(5, 'Miss', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_user_access
CREATE TABLE IF NOT EXISTS `crm3_user_access` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_user_access: ~1 rows (approximately)
INSERT INTO `crm3_user_access` (`id`, `name`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'Adminsitrator', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(5, 'User 01', 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0);

-- Dumping structure for table crm3.crm3_user_access_rules
CREATE TABLE IF NOT EXISTS `crm3_user_access_rules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user_access` int(5) NOT NULL DEFAULT '0',
  `id_module` int(5) NOT NULL DEFAULT '0',
  `_access` int(1) NOT NULL DEFAULT '0',
  `_insert` int(1) NOT NULL DEFAULT '0',
  `_update` int(1) NOT NULL DEFAULT '0',
  `_delete` int(1) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_user_access_rules: ~12 rows (approximately)
INSERT INTO `crm3_user_access_rules` (`id`, `id_user_access`, `id_module`, `_access`, `_insert`, `_update`, `_delete`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 1, 200, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(2, 1, 300, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(3, 1, 400, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(4, 1, 500, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(5, 1, 600, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(6, 1, 700, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(7, 1, 410, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(8, 1, 510, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(9, 1, 520, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(10, 1, 550, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(11, 1, 710, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(12, 1, 800, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(14, 1, 411, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(29, 5, 100, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(30, 5, 200, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(31, 5, 300, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(32, 5, 400, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(33, 5, 410, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(34, 5, 411, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(35, 5, 500, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(36, 5, 510, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(37, 5, 520, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(38, 5, 550, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(39, 5, 600, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(40, 5, 700, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(41, 5, 710, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(42, 5, 800, 1, 1, 1, 1, 1, 1, '2020-02-11 13:23:17', 7, '2020-02-11 13:23:17', 0),
	(43, 1, 100, 1, 1, 1, 1, 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

-- Dumping structure for table crm3.crm3_user_group
CREATE TABLE IF NOT EXISTS `crm3_user_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '0',
  `status` int(1) NOT NULL DEFAULT '1',
  `presence` int(1) NOT NULL DEFAULT '1',
  `input_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `input_by` int(11) NOT NULL DEFAULT '0',
  `update_date` datetime NOT NULL DEFAULT '2019-01-01 00:00:00',
  `update_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- Dumping data for table crm3.crm3_user_group: ~0 rows (approximately)
INSERT INTO `crm3_user_group` (`id`, `name`, `status`, `presence`, `input_date`, `input_by`, `update_date`, `update_by`) VALUES
	(1, 'Sales Team 1', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0),
	(2, 'Sales Team 2', 1, 1, '2019-01-01 00:00:00', 0, '2019-01-01 00:00:00', 0);

