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

START TRANSACTION;



--
-- Database: `mm101_db`
--

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

--
-- Table structure for table `setting_default`
--

CREATE TABLE `setting_default` (
  `def_id` int(11) NOT NULL,
  `def_title` varchar(255) NOT NULL,
  `def_footer` text NOT NULL,
  `def_banner` varchar(100) NOT NULL,
  `def_status` enum('On','Off') NOT NULL,
  `def_info` enum('On','Off') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `setting_default`
--

INSERT INTO `setting_default` (`def_id`, `def_title`, `def_footer`, `def_banner`, `def_status`, `def_info`) VALUES
(1, 'Welcome to mm101.com', '', 'images/banner.jpg', 'On', 'On');

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

--
-- Table structure for table `setting_templates`
--

CREATE TABLE `setting_templates` (
  `tem_id` int(11) NOT NULL,
  `tem_name` varchar(255) NOT NULL,
  `tem_url` varchar(255) NOT NULL,
  `tem_status` enum('on','off') NOT NULL,
  `tem_img` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `setting_templates`
--

INSERT INTO `setting_templates` (`tem_id`, `tem_name`, `tem_url`, `tem_status`, `tem_img`) VALUES
(1, 'Cosmo (Default)', 'https://bootswatch.com/cosmo/bootstrap.min.css', 'off', 'Cosmo.jpg'),
(2, 'Cerulean', 'https://bootswatch.com/cerulean/bootstrap.min.css', 'on', 'Cerulean.jpg'),
(3, 'Slate', 'https://bootswatch.com/slate/bootstrap.min.css', 'off', 'Slate.jpg');

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

--
-- Table structure for table `tb_account`
--

CREATE TABLE `tb_account` (
  `acc_id` int(11) NOT NULL,
  `acc_user` varchar(50) NOT NULL,
  `acc_pass` varchar(64) NOT NULL,
  `acc_status` varchar(5) NOT NULL,
  `acc_lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `acc_fname` varchar(100) NOT NULL,
  `acc_lname` varchar(100) NOT NULL,
  `acc_phone` varchar(20) NOT NULL,
  `acc_commission` double NOT NULL,
  `rate1` double NOT NULL,
  `rate2` double NOT NULL,
  `rate3` double NOT NULL,
  `rate4` double NOT NULL,
  `rate5` double NOT NULL,
  `rate6` double NOT NULL,
  `acc_com5` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tb_account`
--

INSERT INTO `tb_account` (`acc_id`, `acc_user`, `acc_pass`, `acc_status`, `acc_lastupdate`, `acc_fname`, `acc_lname`, `acc_phone`, `acc_commission`, `rate1`, `rate2`, `rate3`, `rate4`, `rate5`, `rate6`, `acc_com5`) VALUES
(1, 'admin01', '1234', 'admin', '2017-09-08 13:51:13', 'ทดสอบ', 'นามสกุลนะจ๊ะ', '00000', 5.99, 9, 5, 9, 5, 9, 5, 0),
(3, 'test02', '1234', 'user', '2017-09-04 12:53:49', 'ประชา', 'รึดีนะ', '096-880-1412', 25, 70, 400, 70, 12, 3, 4, 5),
(4, 'admin02', '1234', 'admin', '2017-09-04 12:53:53', 'EE', 'BB', '088888888', 3.5, 10, 1, 10, 2, 10, 5, 0),
(7, 'test001', '1234', 'user', '2017-09-08 15:08:06', 'นโม', 'สามจบ', '085-111-4444', 25, 10, 10, 10, 10, 10, 10, 0),
(8, 'test002', '1234', 'user', '2017-09-08 14:09:16', 'TEST002', 'TEST002', '085-111-4444', 25.5, 71, 400, 70, 1000, 3, 4, 5),
(9, 'test003', '1111', 'user', '2017-09-04 13:48:46', 'TEST003', 'TEST003', '085-111-4444', 25, 70, 400, 70, 1000, 3, 4, 0),
(10, 'ppoe', '5555', 'user', '2017-09-04 12:54:34', 'PpOe', 'Jaris', '096-880-1412', 25, 70, 400, 70, 12, 3, 4, 5);

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

--
-- Table structure for table `tb_award`
--

CREATE TABLE `tb_award` (
  `awa_id` int(11) NOT NULL,
  `awa_6` varchar(6) NOT NULL,
  `awa_2` varchar(2) NOT NULL,
  `awa_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tb_award`
--

INSERT INTO `tb_award` (`awa_id`, `awa_6`, `awa_2`, `awa_date`) VALUES
(3, '465456', '50', '2017-07-26'),
(4, '414780', '12', '2017-08-16'),
(5, '154', '35', '2017-09-05');

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

--
-- Table structure for table `tb_locknum`
--

CREATE TABLE `tb_locknum` (
  `loc_id` int(11) NOT NULL,
  `loc_num` varchar(3) NOT NULL,
  `loc_type` varchar(1) NOT NULL,
  `loc_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tb_locknum`
--

INSERT INTO `tb_locknum` (`loc_id`, `loc_num`, `loc_type`, `loc_created`) VALUES
(2, '10', 'A', '2017-08-16 17:59:26'),
(5, '040', 'D', '2017-08-16 17:59:26'),
(8, '77', 'A', '2017-08-16 18:29:43'),
(9, '08', 'A', '2017-08-16 18:29:43'),
(10, '90', 'A', '2017-08-16 18:29:43'),
(11, '45', 'A', '2017-08-18 15:43:06'),
(12, '22', 'A', '2017-08-18 15:43:06'),
(13, '78', 'A', '2017-08-18 15:43:06'),
(14, '68', 'A', '2017-08-18 15:43:06'),
(15, '88', 'A', '2017-08-18 15:43:20'),
(16, '89', 'A', '2017-08-18 15:43:20'),
(17, '91', 'A', '2017-08-18 15:43:20'),
(27, '456', 'D', '2017-08-18 16:04:47'),
(28, '123', 'D', '2017-08-18 16:04:47'),
(29, '789', 'D', '2017-08-18 16:04:47'),
(30, '784', 'D', '2017-08-18 16:04:47'),
(31, '450', 'D', '2017-08-18 16:04:47'),
(33, '442', 'D', '2017-08-18 16:05:12'),
(35, '443', 'D', '2017-08-18 16:05:12'),
(37, '774', 'D', '2017-08-18 16:05:12'),
(38, '08', 'B', '2017-08-18 16:39:51'),
(39, '12', 'B', '2017-08-18 16:59:07'),
(40, '007', 'D', '2017-08-18 18:16:01'),
(41, '008', 'D', '2017-08-18 18:16:01'),
(42, '008', 'C', '2017-08-18 18:16:01'),
(43, '2', 'F', '2017-08-18 18:21:33'),
(44, '8', 'E', '2017-08-18 18:22:39'),
(45, '9', 'E', '2017-08-18 18:22:39');

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

--
-- Table structure for table `tb_number`
--

CREATE TABLE `tb_number` (
  `num_id` int(11) NOT NULL,
  `num_buy` varchar(3) NOT NULL,
  `num_one` int(11) NOT NULL,
  `num_two` int(11) NOT NULL,
  `num_type` enum('a','b','c','d') NOT NULL,
  `num_created` datetime NOT NULL,
  `acc_id` int(11) NOT NULL,
  `num_payment` enum('No','Yes','Next') NOT NULL,
  `num_clear` enum('No','Yes') NOT NULL,
  `awa_id` int(11) NOT NULL,
  `num_result` enum('unknow','true','false') NOT NULL,
  `num_money` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `tb_number`
--

INSERT INTO `tb_number` (`num_id`, `num_buy`, `num_one`, `num_two`, `num_type`, `num_created`, `acc_id`, `num_payment`, `num_clear`, `awa_id`, `num_result`, `num_money`) VALUES
(30, '56', 100, 50, 'a', '2017-07-23 17:43:39', 3, 'Yes', 'Yes', 0, 'unknow', ''),
(31, '57', 200, 50, 'a', '2017-07-09 23:41:28', 3, 'Yes', 'Yes', 0, 'unknow', ''),
(33, '30', 200, 0, 'a', '2017-07-09 23:42:31', 3, 'Yes', 'Yes', 0, 'unknow', ''),
(34, '55', 200, 15, 'a', '2017-07-09 23:42:31', 3, 'Yes', 'Yes', 0, 'unknow', ''),
(63, '1', 200, 0, 'c', '2017-07-23 22:48:55', 3, 'Yes', 'Yes', 0, 'unknow', ''),
(64, '6', 100, 100, 'c', '2017-07-23 22:48:55', 3, 'Yes', 'Yes', 0, 'unknow', ''),
(65, '0', 50, 100, 'c', '2017-07-23 22:48:55', 3, 'Yes', 'Yes', 0, 'unknow', ''),
(68, '088', 200, 200, 'b', '2017-07-23 12:00:32', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(69, '456', 100, 100, 'b', '2017-07-23 21:19:52', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(70, '250', 100, 100, 'b', '2017-07-23 12:01:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(71, '645', 100, 50, 'b', '2017-07-23 21:52:05', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(75, '26', 100, 100, 'd', '2017-07-23 22:39:20', 3, 'Yes', 'Yes', 0, 'unknow', ''),
(76, '56', 50, 50, 'd', '2017-07-23 22:39:20', 3, 'Yes', 'Yes', 0, 'unknow', ''),
(77, '50', 10, 10, 'd', '2017-07-23 22:48:06', 3, 'Yes', 'Yes', 0, 'unknow', ''),
(89, '56', 100, 0, 'a', '2017-08-03 00:39:54', 7, 'Yes', 'Yes', 0, 'unknow', ''),
(90, '42', 0, 100, 'a', '2017-08-03 00:39:54', 7, 'Yes', 'Yes', 0, 'unknow', ''),
(91, '78', 100, 100, 'a', '2017-08-03 00:39:54', 7, 'Yes', 'Yes', 0, 'unknow', ''),
(92, '50', 100, 100, 'd', '0000-00-00 00:00:00', 8, 'Yes', 'Yes', 4, 'unknow', ''),
(93, '52', 50, 50, 'd', '0000-00-00 00:00:00', 8, 'Yes', 'Yes', 4, 'unknow', ''),
(94, '55', 50, 100, 'd', '0000-00-00 00:00:00', 8, 'Yes', 'Yes', 0, 'unknow', ''),
(95, '26', 50, 100, 'd', '0000-00-00 00:00:00', 9, 'No', 'Yes', 4, 'unknow', ''),
(96, '50', 50, 100, 'd', '0000-00-00 00:00:00', 9, 'No', 'Yes', 4, 'unknow', ''),
(97, '56', 50, 100, 'd', '0000-00-00 00:00:00', 9, 'No', 'Yes', 4, 'unknow', ''),
(98, '88', 100, 100, 'a', '2017-08-05 16:11:38', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(99, '89', 100, 100, 'a', '2017-08-05 16:11:38', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(100, '00', 100, 100, 'a', '2017-08-11 22:40:15', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(101, '23', 100, 100, 'a', '2017-08-11 22:40:22', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(102, '09', 100, 100, 'a', '2017-08-11 22:40:35', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(103, '56', 0, 0, 'd', '2017-08-11 22:42:31', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(104, '56', 0, 0, 'a', '2017-08-11 22:42:44', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(105, '20', 0, 0, 'a', '2017-08-11 22:48:22', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(106, '00', 10, 10, 'a', '2017-08-11 22:48:46', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(107, '05', 50, 40, 'a', '2017-08-11 22:51:23', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(108, '77', 200, 50, 'a', '2017-08-16 21:03:42', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(109, '40', 60, 90, 'a', '2017-08-16 21:03:42', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(110, '30', 20, 15, 'a', '2017-08-16 21:03:42', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(111, '20', 100, 100, 'a', '2017-08-16 21:29:35', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(112, '25', 10, 10, 'd', '2017-08-16 21:35:03', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(113, '10', 0, 0, 'c', '2017-08-16 21:36:52', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(114, '20', 100, 100, 'c', '2017-08-16 21:37:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(115, '30', 20, 20, 'c', '2017-08-16 21:37:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(116, '010', 100, 100, 'b', '2017-08-16 21:38:02', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(117, '10', 100, 0, 'a', '2017-08-18 23:36:47', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(118, '10', 100, 100, 'a', '2017-08-18 23:36:47', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(119, '10', 0, 100, 'a', '2017-08-18 23:39:35', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(120, '08', 100, 100, 'a', '2017-08-18 23:40:16', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(121, '10', 0, 0, 'a', '2017-08-18 23:40:16', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(122, '08', 0, 0, 'a', '2017-08-18 23:44:45', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(123, '08', 0, 0, 'a', '2017-08-18 23:47:05', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(124, '08', 10, 0, 'a', '2017-08-18 23:48:30', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(125, '10', 0, 0, 'a', '2017-08-18 23:49:43', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(126, '10', 0, 0, 'a', '2017-08-18 23:50:28', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(127, '10', 0, 0, 'a', '2017-08-18 23:52:46', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(128, '10', 0, 0, 'a', '2017-08-18 23:53:32', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(129, '10', 100, 100, 'a', '2017-08-18 23:55:31', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(130, '10', 100, 100, 'a', '2017-08-18 23:56:25', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(131, '10', 100, 100, 'a', '2017-08-18 23:56:54', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(132, '10', 100, 100, 'a', '2017-08-18 23:57:41', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(133, '10', 100, 100, 'a', '2017-08-18 23:58:13', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(134, '10', 100, 100, 'a', '2017-08-18 23:58:32', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(135, '12', 100, 100, 'a', '2017-08-18 23:59:18', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(136, '12', 100, 100, 'a', '2017-08-18 23:59:34', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(137, '65', 0, 0, 'd', '2017-08-19 00:53:32', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(138, '40', 40, 40, 'a', '2017-08-19 01:04:25', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(139, '40', 40, 0, 'a', '2017-08-19 01:08:38', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(140, '50', 0, 50, 'a', '2017-08-19 01:08:44', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(141, '505', 0, 50, 'b', '2017-08-19 01:08:50', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(142, '567', 50, 0, 'b', '2017-08-19 01:09:05', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(143, '6', 456, 456, 'c', '2017-08-19 01:15:18', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(144, '6', 456, 0, 'c', '2017-08-19 01:15:18', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(145, '8', 0, 100, 'c', '2017-08-19 01:15:30', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(146, '8', 100, 0, 'c', '2017-08-19 01:16:23', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(147, '8', 0, 100, 'c', '2017-08-19 01:16:23', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(148, '7', 100, 0, 'c', '2017-08-19 01:16:23', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(149, '7', 0, 100, 'c', '2017-08-19 01:16:23', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(150, '7', 100, 100, 'c', '2017-08-19 01:16:23', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(151, '8', 100, 0, 'c', '2017-08-19 01:23:07', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(152, '8', 0, 100, 'c', '2017-08-19 01:23:07', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(153, '9', 100, 0, 'c', '2017-08-19 01:23:07', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(154, '9', 0, 100, 'c', '2017-08-19 01:23:07', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(161, '12', 100, 100, 'a', '2017-08-19 23:54:26', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(162, '12', 500, 0, 'a', '2017-08-19 23:55:56', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(163, '45', 0, 500, 'a', '2017-08-19 23:56:15', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(164, '10', 0, 100, 'a', '2017-08-20 22:08:54', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(165, '10', 0, 50, 'a', '2017-08-20 22:09:07', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(166, '450', -50, 0, 'b', '2017-08-20 22:13:45', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(167, '12', 100, 0, 'a', '2017-08-26 21:41:32', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(168, '12', 100, 0, 'a', '2017-08-26 21:41:44', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(169, '13', 0, 100, 'a', '2017-08-26 21:41:44', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(170, '14', 50, 50, 'a', '2017-08-26 21:41:44', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(173, '15', 50, 0, 'd', '2017-08-26 22:33:28', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(174, '05', 50, 0, 'd', '2017-08-26 22:33:28', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(175, '100', 50, 0, 'b', '2017-08-26 22:57:47', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(176, '144', 0, 50, 'b', '2017-08-26 22:57:47', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(177, '088', 100, 100, 'b', '2017-08-26 23:04:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(178, '238', 50, 80, 'b', '2017-08-26 23:04:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(179, '341', 70, 70, 'b', '2017-08-26 23:04:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(180, '499', 100, 100, 'b', '2017-08-26 23:04:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(181, '522', 100, 100, 'b', '2017-08-26 23:04:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(182, '688', 100, 100, 'b', '2017-08-26 23:04:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(183, '747', 50, 50, 'b', '2017-08-26 23:04:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(184, '816', 80, 80, 'b', '2017-08-26 23:04:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(185, '984', 50, 50, 'b', '2017-08-26 23:04:01', 3, 'Yes', 'Yes', 4, 'unknow', ''),
(186, '50', 45, 45, 'a', '2017-08-30 00:17:36', 3, 'No', 'No', 0, 'unknow', ''),
(187, '456', 50, 0, 'b', '2017-08-31 22:24:51', 3, 'No', 'No', 0, 'unknow', ''),
(188, '078', 50, 50, 'b', '2017-08-31 22:24:51', 3, 'No', 'No', 0, 'unknow', ''),
(189, '879', 100, 0, 'b', '2017-08-31 22:24:51', 3, 'No', 'No', 0, 'unknow', ''),
(190, '4', 100, 0, 'c', '2017-08-31 22:25:06', 3, 'No', 'No', 0, 'unknow', ''),
(191, '6', 100, 50, 'c', '2017-08-31 22:25:06', 3, 'No', 'No', 0, 'unknow', ''),
(192, '50', 500, 100, 'd', '2017-08-31 22:25:20', 3, 'No', 'No', 0, 'unknow', ''),
(193, '88', 500, 0, 'd', '2017-08-31 22:25:20', 3, 'No', 'No', 0, 'unknow', ''),
(194, '56', 50, 50, 'd', '2017-08-31 22:25:20', 3, 'No', 'No', 0, 'unknow', ''),
(195, '88', 0, 100, 'a', '2017-08-31 23:01:34', 3, 'No', 'No', 0, 'unknow', ''),
(196, '78', 0, 100, 'a', '2017-08-31 23:01:34', 3, 'No', 'No', 0, 'unknow', ''),
(197, '99', 100, 100, 'a', '2017-08-31 23:02:12', 3, 'No', 'No', 0, 'unknow', ''),
(198, '456', 200, 0, 'b', '2017-08-31 23:21:17', 3, 'No', 'No', 0, 'unknow', ''),
(199, '4', 200, 500, 'c', '2017-08-31 23:21:33', 3, 'No', 'No', 0, 'unknow', ''),
(200, '35', 150, 150, 'a', '2017-09-04 17:47:31', 3, 'No', 'No', 0, 'unknow', ''),
(201, '54', 100, 0, 'a', '2017-09-04 17:48:06', 3, 'No', 'No', 0, 'unknow', ''),
(202, '45', 0, 0, 'a', '2017-09-04 17:48:06', 3, 'No', 'No', 0, 'unknow', ''),
(203, '15', 100, 0, 'a', '2017-09-04 17:48:06', 3, 'No', 'No', 0, 'unknow', ''),
(204, '154', 100, 100, 'b', '2017-09-04 17:48:53', 3, 'No', 'No', 0, 'unknow', ''),
(205, '415', 20, 20, 'b', '2017-09-04 17:48:53', 3, 'No', 'No', 0, 'unknow', ''),
(206, '35', 100, 100, 'd', '2017-09-04 17:49:46', 3, 'No', 'No', 0, 'unknow', ''),
(207, '54', 100, 100, 'd', '2017-09-04 17:49:46', 3, 'No', 'No', 0, 'unknow', ''),
(208, '35', 100, 100, 'a', '2017-09-04 19:22:08', 8, 'No', 'No', 0, 'unknow', ''),
(209, '88', 0, 50, 'a', '2017-09-04 19:22:08', 8, 'No', 'No', 0, 'unknow', ''),
(210, '78', 0, 50, 'a', '2017-09-04 19:22:08', 8, 'No', 'No', 0, 'unknow', ''),
(211, '455', 100, 100, 'b', '2017-09-04 19:22:21', 8, 'No', 'No', 0, 'unknow', ''),
(212, '145', 100, 100, 'b', '2017-09-04 19:22:21', 8, 'No', 'No', 0, 'unknow', ''),
(213, '558', 100, 100, 'b', '2017-09-04 19:22:21', 8, 'No', 'No', 0, 'unknow', ''),
(214, '79', 100, 100, 'd', '2017-09-04 19:23:26', 8, 'No', 'No', 0, 'unknow', ''),
(215, '55', 100, 100, 'd', '2017-09-04 19:23:26', 8, 'No', 'No', 0, 'unknow', ''),
(216, '8', 0, 100, 'c', '2017-09-04 19:23:40', 8, 'No', 'No', 0, 'unknow', ''),
(217, '88', 100, 100, 'd', '2017-09-04 20:49:08', 9, 'No', 'No', 0, 'unknow', ''),
(218, '79', 100, 100, 'd', '2017-09-04 20:49:08', 9, 'No', 'No', 0, 'unknow', ''),
(219, '50', 0, 500, 'd', '2017-09-04 20:49:08', 9, 'No', 'No', 0, 'unknow', ''),
(220, '50', 0, 50, 'd', '2017-09-04 20:49:37', 9, 'No', 'No', 0, 'unknow', ''),
(221, '465', 0, 500, 'b', '2017-09-08 21:09:42', 8, 'No', 'No', 0, 'unknow', ''),
(222, '256', 50, 200, 'b', '2017-09-08 21:09:42', 8, 'No', 'No', 0, 'unknow', ''),
(223, '078', 70, 50, 'b', '2017-09-08 21:09:42', 8, 'No', 'No', 0, 'unknow', ''),
(224, '415', 0, 70, 'b', '2017-09-08 21:09:42', 8, 'No', 'No', 0, 'unknow', ''),
(225, '154', 0, 800, 'b', '2017-09-08 22:08:12', 7, 'No', 'No', 0, 'unknow', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `setting_default`
--
ALTER TABLE `setting_default`
  ADD PRIMARY KEY (`def_id`);

--
-- Indexes for table `setting_templates`
--
ALTER TABLE `setting_templates`
  ADD PRIMARY KEY (`tem_id`);

--
-- Indexes for table `tb_account`
--
ALTER TABLE `tb_account`
  ADD PRIMARY KEY (`acc_id`);

--
-- Indexes for table `tb_award`
--
ALTER TABLE `tb_award`
  ADD PRIMARY KEY (`awa_id`);

--
-- Indexes for table `tb_locknum`
--
ALTER TABLE `tb_locknum`
  ADD PRIMARY KEY (`loc_id`);

--
-- Indexes for table `tb_number`
--
ALTER TABLE `tb_number`
  ADD PRIMARY KEY (`num_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `setting_default`
--
ALTER TABLE `setting_default`
  MODIFY `def_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `setting_templates`
--
ALTER TABLE `setting_templates`
  MODIFY `tem_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tb_account`
--
ALTER TABLE `tb_account`
  MODIFY `acc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `tb_award`
--
ALTER TABLE `tb_award`
  MODIFY `awa_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `tb_locknum`
--
ALTER TABLE `tb_locknum`
  MODIFY `loc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
--
-- AUTO_INCREMENT for table `tb_number`
--
ALTER TABLE `tb_number`
  MODIFY `num_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=226;COMMIT;

