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

START TRANSACTION;



--
-- Database: `cp945037_101sby`
--

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

--
-- 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 101sby.com', '', 'images/banner.jpg', 'Off', '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_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, '224', '65', '2017-09-01'),
(6, '143224', '65', '2017-09-01');

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

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

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

--
-- 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, '22', 0, 50, 'a', '2017-08-30 00:13:04', 3, 'Yes', 'Yes', 6, 'unknow', ''),
(187, '401', 100, 0, 'b', '2017-08-30 22:35:08', 7, 'Yes', 'Yes', 6, 'unknow', ''),
(188, '570', 50, 50, 'b', '2017-08-30 22:35:08', 7, 'Yes', 'Yes', 6, 'unknow', ''),
(189, '16', 5, 5, 'd', '2017-08-30 22:35:30', 7, 'Yes', 'Yes', 6, 'unknow', ''),
(190, '77', 10, 10, 'd', '2017-08-30 22:35:30', 7, 'Yes', 'Yes', 6, 'unknow', ''),
(191, '131', 100, 0, 'b', '2017-08-30 22:36:23', 8, 'Next', 'No', 0, 'unknow', ''),
(192, '224', 0, 100, 'b', '2017-08-30 22:36:23', 8, 'Next', 'No', 0, 'unknow', ''),
(193, '407', 100, 100, 'b', '2017-08-30 22:36:23', 8, 'Next', 'No', 0, 'unknow', ''),
(194, '557', 100, 100, 'b', '2017-08-30 22:36:23', 8, 'Next', 'No', 0, 'unknow', ''),
(195, '668', 100, 0, 'b', '2017-08-30 22:36:23', 8, 'Next', 'No', 0, 'unknow', ''),
(196, '10', 0, 100, 'a', '2017-08-30 22:36:47', 8, 'Next', 'No', 0, 'unknow', ''),
(197, '15', 50, 100, 'a', '2017-08-30 22:36:47', 8, 'Next', 'No', 0, 'unknow', ''),
(198, '20', 50, 100, 'a', '2017-08-30 22:36:47', 8, 'Next', 'No', 0, 'unknow', ''),
(199, '25', 50, 100, 'a', '2017-08-30 22:36:47', 8, 'Next', 'No', 0, 'unknow', ''),
(200, '30', 50, 100, 'a', '2017-08-30 22:36:47', 8, 'Next', 'No', 0, 'unknow', ''),
(201, '5', 50, 50, 'c', '2017-08-30 22:37:18', 8, 'Next', 'No', 0, 'unknow', ''),
(202, '8', 0, 50, 'c', '2017-08-30 22:37:18', 8, 'Next', 'No', 0, 'unknow', ''),
(203, '2', 100, 0, 'c', '2017-08-30 23:25:06', 3, 'Yes', 'Yes', 6, 'unknow', ''),
(204, '12', 33, 122, 'd', '2017-08-30 23:25:55', 3, 'Yes', 'Yes', 6, 'unknow', ''),
(205, '063', 100, 100, 'b', '2017-08-31 14:01:11', 10, 'No', 'No', 0, 'unknow', ''),
(206, '359', 100, 100, 'b', '2017-08-31 14:01:11', 10, 'No', 'No', 0, 'unknow', ''),
(207, '182', 50, 50, 'b', '2017-08-31 14:01:11', 10, 'No', 'No', 0, 'unknow', ''),
(208, '342', 50, 50, 'b', '2017-08-31 14:01:11', 10, 'No', 'No', 0, 'unknow', ''),
(209, '59', 50, 50, 'a', '2017-08-31 14:05:07', 10, 'No', 'No', 0, 'unknow', ''),
(210, '95', 50, 50, 'a', '2017-08-31 14:05:07', 10, 'No', 'No', 0, 'unknow', ''),
(211, '82', 50, 50, 'a', '2017-08-31 14:05:07', 10, 'No', 'No', 0, 'unknow', ''),
(212, '63', 70, 70, 'a', '2017-08-31 14:05:07', 10, 'No', 'No', 0, 'unknow', ''),
(213, '68', 50, 50, 'a', '2017-08-31 15:09:56', 11, 'Next', 'Yes', 6, 'unknow', ''),
(214, '86', 50, 50, 'a', '2017-08-31 15:09:56', 11, 'Next', 'Yes', 6, 'unknow', ''),
(215, '688', 100, 0, 'b', '2017-08-31 15:10:32', 11, 'Next', 'Yes', 6, 'unknow', ''),
(216, '868', 100, 0, 'b', '2017-08-31 15:10:32', 11, 'Next', 'Yes', 6, 'unknow', ''),
(217, '886', 100, 0, 'b', '2017-08-31 15:10:32', 11, 'Next', 'Yes', 6, 'unknow', ''),
(218, '196', 20, 20, 'b', '2017-09-01 12:52:42', 12, 'No', 'No', 0, 'unknow', ''),
(219, '142', 20, 20, 'b', '2017-09-01 12:52:42', 12, 'No', 'No', 0, 'unknow', ''),
(220, '953', 20, 20, 'b', '2017-09-01 12:52:42', 12, 'No', 'No', 0, 'unknow', ''),
(221, '182', 20, 20, 'b', '2017-09-01 12:52:42', 12, 'No', 'No', 0, 'unknow', ''),
(222, '82', 2, 2, 'd', '2017-09-01 13:08:30', 12, 'No', 'No', 0, 'unknow', ''),
(223, '28', 2, 2, 'd', '2017-09-01 13:08:30', 12, 'No', 'No', 0, 'unknow', ''),
(224, '14', 2, 2, 'd', '2017-09-01 13:08:30', 12, 'No', 'No', 0, 'unknow', ''),
(225, '41', 2, 2, 'd', '2017-09-01 13:08:30', 12, 'No', 'No', 0, 'unknow', ''),
(226, '85', 2, 2, 'd', '2017-09-01 13:56:54', 12, 'No', 'No', 0, 'unknow', ''),
(227, '58', 2, 2, 'd', '2017-09-01 13:56:54', 12, 'No', 'No', 0, 'unknow', ''),
(228, '65', 2, 2, 'd', '2017-09-01 13:56:54', 12, 'No', 'No', 0, 'unknow', ''),
(229, '56', 2, 2, 'd', '2017-09-01 13:56:54', 12, 'No', 'No', 0, 'unknow', ''),
(230, '13', 2, 2, 'd', '2017-09-01 13:56:54', 12, 'No', 'No', 0, 'unknow', ''),
(231, '31', 2, 2, 'd', '2017-09-01 13:56:54', 12, 'No', 'No', 0, 'unknow', ''),
(232, '30', 2, 2, 'd', '2017-09-01 13:56:54', 12, 'No', 'No', 0, 'unknow', ''),
(233, '03', 2, 2, 'd', '2017-09-01 13:56:54', 12, 'No', 'No', 0, 'unknow', ''),
(234, '953', 20, 20, 'b', '2017-09-01 14:04:59', 12, 'No', 'No', 0, 'unknow', ''),
(235, '277', 20, 0, 'b', '2017-09-01 14:04:59', 12, 'No', 'No', 0, 'unknow', ''),
(236, '727', 20, 0, 'b', '2017-09-01 14:04:59', 12, 'No', 'No', 0, 'unknow', ''),
(237, '772', 20, 0, 'b', '2017-09-01 14:04:59', 12, 'No', 'No', 0, 'unknow', ''),
(238, '53', 2, 2, 'd', '2017-09-01 14:05:36', 12, 'No', 'No', 0, 'unknow', ''),
(239, '35', 2, 2, 'd', '2017-09-01 14:05:36', 12, 'No', 'No', 0, 'unknow', ''),
(240, '77', 2, 2, 'd', '2017-09-01 14:05:36', 12, 'No', 'No', 0, 'unknow', ''),
(241, '48', 2, 2, 'd', '2017-09-01 14:15:02', 12, 'No', 'No', 0, 'unknow', ''),
(242, '84', 2, 2, 'd', '2017-09-01 14:15:02', 12, 'No', 'No', 0, 'unknow', ''),
(243, '97', 1, 1, 'd', '2017-09-01 14:15:02', 12, 'No', 'No', 0, 'unknow', ''),
(244, '79', 1, 1, 'd', '2017-09-01 14:15:02', 12, '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_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_award`
--
ALTER TABLE `tb_award`
  MODIFY `awa_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `tb_locknum`
--
ALTER TABLE `tb_locknum`
  MODIFY `loc_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `tb_number`
--
ALTER TABLE `tb_number`
  MODIFY `num_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=245;COMMIT;

