-- phpMyAdmin SQL Dump
-- version 4.7.9
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: 2020-02-23 23:31:57
-- 服务器版本： 5.6.44-log
-- PHP Version: 7.0.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `fk_daokewl_com`
--

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

--
-- 表的结构 `article`
--

CREATE TABLE `article` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL COMMENT '文章标题',
  `time` varchar(20) DEFAULT NULL,
  `content` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `article`
--

INSERT INTO `article` (`id`, `title`, `time`, `content`) VALUES
(5, '网站公告', '2018-01-20 15:48:51', '<p>\r\n	<table id=\"Temp_Message\" style=\"width:500px;height:150px;border:0px;font-family:arial, \" font-size:12px;margin:-183px=\"\" 0px=\"\" -250px;color:#ffffff;background-color:#1d1f25;\"=\"\">\r\n	<tbody>\r\n		<tr>\r\n			<td style=\"font-size:9pt;text-align:center;background-color:#FFFFFF;\">\r\n				<table id=\"Temp_Message\" style=\"width:500px;height:150px;border:0px;font-family:arial, \" font-size:12px;margin:-183px=\"\" 0px=\"\" -250px;color:#ffffff;background-color:#1d1f25;\"=\"\">\r\n				<tbody>\r\n					<tr>\r\n						<td style=\"font-size:9pt;text-align:center;background-color:#FFFFFF;\">\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"font-size:9pt;text-align:center;\">\r\n							<div align=\"center\" style=\"padding:0px;margin:0px;\">\r\n								<table id=\"tab2\" style=\"width:468px;height:256px;border:1px;padding:0px;margin:0px;font-size:12px;font-family:;\">\r\n									<tbody>\r\n										<tr>\r\n											<td>\r\n												<div id=\"Temp_Text\" style=\"padding:0px;margin:0px;\">\r\n													<p>\r\n														<span style=\"font-size:18px;color:#E53333;\"><strong>测试一下网站的公告!</strong></span><br />\r\n<span style=\"font-size:16px;color:#EE33EE;\">全站商品支持7x24小时自动发货!</span>\r\n													</p>\r\n													<p style=\"font-size:9pt;\">\r\n														<br />\r\n													</p>\r\n													<p style=\"font-size:9pt;\">\r\n														<br />\r\n													</p>\r\n												</div>\r\n											</td>\r\n										</tr>\r\n									</tbody>\r\n								</table>\r\n							</div>\r\n						</td>\r\n					</tr>\r\n				</tbody>\r\n					</table>\r\n<br />\r\n						</td>\r\n							</tr>\r\n								</tbody>\r\n									</table>\r\n										</p>');

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

--
-- 表的结构 `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `abridge` varchar(30) DEFAULT NULL COMMENT '简称',
  `sort` int(3) NOT NULL DEFAULT '0' COMMENT '排序'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `categories`
--

INSERT INTO `categories` (`id`, `name`, `image`, `abridge`, `sort`) VALUES
(18, '测试分类2', '', 'ceshi2', 1),
(17, '测试分类1', '', 'ceshi1', 0),
(19, '测试分类3', '', 'ceshi3', 2),
(20, '其他分类', '', 'qita', 4);

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

--
-- 表的结构 `daili`
--

CREATE TABLE `daili` (
  `id` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL COMMENT '代理用户名',
  `password` varchar(50) DEFAULT NULL COMMENT '密码',
  `email` varchar(50) DEFAULT NULL,
  `money` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `level` int(1) NOT NULL DEFAULT '1' COMMENT '代理商等级',
  `create_time` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `daili`
--

INSERT INTO `daili` (`id`, `username`, `password`, `email`, `money`, `level`, `create_time`) VALUES
(9, '123123', '63ee451939ed580ef3c4b6f0109d1fd0', '123123@qq.com', '1109.43', 1, '2019-10-12 02:44:50'),
(10, 'hackzt', '49ffbd351aaed9fd72a8d5e70cd50ab5', '12345684@qq.com', '0.00', 1, '2020-02-23 15:28:42');

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

--
-- 表的结构 `goods`
--

CREATE TABLE `goods` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL COMMENT '商品名称',
  `images` varchar(255) NOT NULL DEFAULT '__STATIC__/images/noimg.jpg',
  `abridge` varchar(30) DEFAULT NULL,
  `price` decimal(6,2) NOT NULL DEFAULT '0.10',
  `Introduction` text,
  `sort` int(3) NOT NULL DEFAULT '0',
  `dailiprice` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '代理拿货价',
  `sales` int(11) NOT NULL DEFAULT '0' COMMENT '销量',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '商品状态 0出售中 1已下架',
  `mansl` int(11) NOT NULL,
  `yhprice` decimal(10,0) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `goods`
--

INSERT INTO `goods` (`id`, `name`, `images`, `abridge`, `price`, `Introduction`, `sort`, `dailiprice`, `sales`, `status`, `mansl`, `yhprice`) VALUES
(68, '测试商品2', 'http://fk.daokewl.com/public/static/images/1582468007.jpg', 'ceshi2', '0.10', '<p>\r\n	<span style=\"font-size:32px;color:#E53333;\">测试测试!<img src=\"http://fk.daokewl.com/public/static/editor/plugins/emoticons/images/44.gif\" border=\"0\" alt=\"\" /></span>\r\n</p>\r\n<p>\r\n	<span style=\"font-size:32px;color:#E53333;\"><img src=\"/public/static/editor/attached/image/20200223/20200223223026_89533.jpg\" alt=\"\" /><br />\r\n</span>\r\n</p>', 0, '0.10', 1, 0, 150, '0'),
(67, '测试商品1', 'http://fk.daokewl.com/public/static/images/1582467947.jpg', 'ceshi1', '10.00', '<span style=\"color:#006600;font-size:24px;\">这是测试商品!<img src=\"http://fk.daokewl.com/public/static/editor/plugins/emoticons/images/13.gif\" border=\"0\" alt=\"\" /></span>', 0, '8.00', 0, 0, 200, '6'),
(66, '公益商品1', 'http://fk.daokewl.com/public/static/images/1582467875.jpg', 'ceshi1', '2.00', '<p>\r\n	<span style=\"font-size:24px;\">这是一个测试商品!<img src=\"http://fk.daokewl.com/public/static/editor/plugins/emoticons/images/41.gif\" border=\"0\" alt=\"\" /></span>\r\n</p>\r\n<p>\r\n	<span style=\"font-size:24px;\"><img src=\"/public/static/editor/attached/image/20200223/20200223223044_41827.jpg\" alt=\"\" /><br />\r\n</span>\r\n</p>', 0, '1.80', 0, 0, 100, '1'),
(69, '公益商品2', 'http://fk.daokewl.com/public/static/images/1582468053.jpg', 'ceshi2', '66.00', '<p>\r\n	<span style=\"font-size:24px;\">测试商品!</span> \r\n</p>\r\n<p>\r\n	<span style=\"font-size:24px;\"><img src=\"/public/static/editor/attached/image/20200223/20200223223056_30599.jpg\" alt=\"\" /><br />\r\n</span> \r\n</p>', 0, '50.00', 0, 0, 100, '40'),
(70, '测试商品3', 'http://fk.daokewl.com/public/static/images/1582468321.jpg', 'ceshi3', '0.10', '<p>\r\n	<span style=\"color:#337FE5;font-size:24px;\">这是一个测试商品</span>\r\n</p>\r\n<p>\r\n	<span style=\"color:#337FE5;font-size:24px;\"><img src=\"/public/static/editor/attached/image/20200223/20200223223227_21026.jpg\" alt=\"\" /><br />\r\n</span>\r\n</p>', 0, '0.10', 0, 0, 100, '0'),
(71, '公益商品3', 'http://fk.daokewl.com/public/static/images/1582468389.jpg', 'ceshi3', '1.00', '<p>\r\n	<span style=\"font-size:24px;color:#EE33EE;\">测试商品的介绍!</span>\r\n</p>\r\n<p>\r\n	<span style=\"font-size:24px;color:#EE33EE;\"><img src=\"/public/static/editor/attached/image/20200223/20200223223335_39030.jpg\" alt=\"\" /><br />\r\n</span>\r\n</p>', 0, '0.50', 0, 0, 1000, '1'),
(72, '赞助本站', 'http://fk.daokewl.com/public/static/images/1582468447.jpg', 'qita', '1.66', '<p>\r\n	<span style=\"font-size:24px;\">赞助本站的商品介绍</span>\r\n</p>\r\n<p>\r\n	<span style=\"font-size:24px;\"><img src=\"/public/static/editor/attached/image/20200223/20200223223430_87911.jpg\" alt=\"\" /><br />\r\n</span>\r\n</p>', 0, '1.00', 0, 0, 1000, '1'),
(73, '测试商品4', 'http://fk.daokewl.com/public/static/images/1582468518.jpg', 'ceshi1', '100.00', '<p>\r\n	<span style=\"font-size:24px;color:#003399;\">这是测试商品4的商品介绍!</span>\r\n</p>\r\n<p>\r\n	<span style=\"font-size:24px;color:#003399;\"><img src=\"/public/static/editor/attached/image/20200223/20200223223543_37366.jpg\" alt=\"\" /><br />\r\n</span>\r\n</p>', 0, '90.00', 0, 0, 50, '90');

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

--
-- 表的结构 `kami`
--

CREATE TABLE `kami` (
  `id` int(11) NOT NULL,
  `goodid` int(5) DEFAULT NULL,
  `kahao` varchar(255) DEFAULT NULL,
  `mima` varchar(255) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '0',
  `ddid` varchar(50) DEFAULT NULL,
  `time` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `kami`
--

INSERT INTO `kami` (`id`, `goodid`, `kahao`, `mima`, `status`, `ddid`, `time`) VALUES
(931, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 1, '2020022322525960182', '2020-02-23 22:53:09'),
(930, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(929, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(928, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(927, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(926, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(925, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(924, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(923, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(922, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(921, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(920, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(919, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(915, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(916, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(917, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(918, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(914, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(932, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(933, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(934, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(935, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(936, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(937, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(938, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(939, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(940, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(941, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(942, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(943, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(944, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(945, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(946, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(947, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(948, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(949, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(950, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(951, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(952, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(953, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(954, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(955, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(956, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(957, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(958, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(959, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(960, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(961, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(962, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(963, 68, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(964, 67, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(965, 67, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(966, 67, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(967, 67, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(968, 67, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(969, 67, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(970, 67, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(971, 67, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(972, 67, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(973, 67, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(974, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(975, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(976, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(977, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(978, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(979, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(980, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(981, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(982, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(983, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(984, 69, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(985, 69, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(986, 69, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(987, 69, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(988, 69, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(989, 69, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(990, 69, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(991, 69, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(992, 69, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(993, 69, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(994, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(995, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(996, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(997, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(998, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(999, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1000, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1001, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1002, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1003, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1004, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1005, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1006, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1007, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1008, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1009, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1010, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1011, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1012, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1013, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1014, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1015, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1016, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1017, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1018, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1019, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1020, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1021, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1022, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1023, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1024, 71, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1025, 71, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1026, 71, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1027, 71, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1028, 71, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1029, 71, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1030, 71, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1031, 71, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1032, 71, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1033, 71, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1034, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1035, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1036, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1037, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1038, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1039, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1040, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1041, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1042, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1043, 70, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1044, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1045, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1046, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1047, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1048, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1049, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1050, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1051, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1052, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1053, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1054, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1055, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1056, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1057, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1058, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1059, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1060, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1061, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1062, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1063, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1064, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1065, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1066, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1067, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1068, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1069, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1070, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1071, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1072, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1073, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1074, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1075, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1076, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1077, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1078, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1079, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1080, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1081, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1082, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1083, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1084, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1085, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1086, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1087, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1088, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1089, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1090, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1091, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1092, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1093, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1094, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1095, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1096, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1097, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1098, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1099, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1100, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1101, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1102, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1103, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1104, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1105, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1106, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1107, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1108, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1109, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1110, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1111, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1112, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1113, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1114, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1115, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1116, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1117, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1118, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1119, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1120, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1121, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1122, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1123, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1124, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1125, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1126, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1127, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1128, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1129, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1130, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1131, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1132, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1133, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1134, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1135, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1136, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1137, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1138, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1139, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1140, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1141, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1142, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1143, 73, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1144, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1145, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1146, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1147, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1148, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1149, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1150, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1151, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1152, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1153, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1154, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1155, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1156, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1157, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1158, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1159, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1160, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1161, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1162, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1163, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1164, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1165, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1166, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1167, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1168, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1169, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1170, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1171, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1172, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1173, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1174, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1175, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1176, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1177, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1178, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1179, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1180, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1181, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1182, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1183, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1184, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1185, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1186, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1187, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1188, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1189, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1190, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1191, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1192, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1193, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1194, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1195, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1196, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1197, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1198, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1199, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1200, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1201, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1202, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1203, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1204, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1205, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1206, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1207, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1208, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1209, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1210, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1211, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1212, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1213, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1214, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1215, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1216, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1217, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1218, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1219, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1220, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1221, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1222, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1223, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1224, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1225, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1226, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1227, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1228, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1229, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1230, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1231, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1232, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1233, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1234, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1235, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1236, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1237, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1238, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1239, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1240, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1241, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1242, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1243, 66, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1244, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1245, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1246, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1247, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1248, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1249, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1250, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1251, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1252, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1253, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1254, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1255, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1256, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1257, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1258, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1259, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1260, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1261, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1262, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1263, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1264, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1265, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1266, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1267, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1268, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1269, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1270, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1271, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1272, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1273, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1274, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1275, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1276, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1277, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1278, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1279, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1280, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1281, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1282, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1283, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1284, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1285, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1286, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1287, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1288, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1289, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1290, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1291, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1292, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1293, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1294, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1295, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1296, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1297, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1298, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1299, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1300, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1301, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1302, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1303, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1304, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1305, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1306, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1307, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1308, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1309, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1310, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1311, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1312, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1313, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1314, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1315, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1316, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1317, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1318, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1319, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1320, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1321, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1322, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1323, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1324, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1325, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1326, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1327, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1328, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1329, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1330, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1331, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1332, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1333, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1334, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1335, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1336, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1337, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1338, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1339, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1340, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1341, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1342, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1343, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1344, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1345, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1346, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1347, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1348, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1349, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1350, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1351, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1352, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1353, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1354, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1355, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1356, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1357, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1358, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1359, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1360, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1361, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1362, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1363, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1364, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1365, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1366, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1367, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1368, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1369, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1370, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1371, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1372, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1373, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1374, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1375, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1376, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1377, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1378, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1379, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1380, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1381, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1382, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1383, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1384, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1385, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1386, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1387, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1388, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1389, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1390, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1391, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1392, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1393, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1394, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1395, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1396, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1397, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1398, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1399, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1400, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1401, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1402, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1403, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1404, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1405, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1406, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1407, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1408, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1409, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1410, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1411, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1412, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1413, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1414, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1415, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1416, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1417, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1418, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1419, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1420, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1421, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1422, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1423, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1424, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1425, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1426, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1427, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1428, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1429, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1430, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1431, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1432, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1433, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1434, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1435, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1436, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1437, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1438, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1439, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1440, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1441, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1442, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL),
(1443, 72, 'AAAAAAAAAA', 'BBBBBBBBBB', 0, NULL, NULL);

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

--
-- 表的结构 `links`
--

CREATE TABLE `links` (
  `id` int(11) NOT NULL,
  `sitename` varchar(20) DEFAULT NULL,
  `siteurl` varchar(50) DEFAULT NULL,
  `sort` int(3) DEFAULT NULL COMMENT '排序'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `links`
--

INSERT INTO `links` (`id`, `sitename`, `siteurl`, `sort`) VALUES
(1, '玖讯免签支付', 'https://www.3mpay.com', 0);

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

--
-- 表的结构 `options`
--

CREATE TABLE `options` (
  `id` int(11) NOT NULL,
  `sitename` varchar(8) DEFAULT NULL COMMENT '网站名称',
  `siteurl` varchar(50) DEFAULT NULL COMMENT '网站地址',
  `qq` int(11) DEFAULT NULL COMMENT '站长QQ',
  `gonggao` text COMMENT '网站首页公告',
  `keywords` varchar(100) DEFAULT NULL COMMENT '网站关键字',
  `description` varchar(200) DEFAULT NULL COMMENT '网站描述',
  `adminuser` varchar(20) DEFAULT NULL COMMENT '后台用户名',
  `adminpass` varchar(50) DEFAULT NULL COMMENT '后台密码',
  `tongji` text COMMENT '统计代码',
  `logoimg` varchar(255) DEFAULT NULL COMMENT 'LOGO图片地址',
  `paytype` int(1) NOT NULL DEFAULT '0' COMMENT '支付方式 2为玖讯支付',
  `partner` int(5) DEFAULT NULL COMMENT '支付商户ID',
  `key` varchar(32) DEFAULT NULL COMMENT '支付密匙',
  `alipay` int(1) DEFAULT '1' COMMENT '支付宝支付 1开启  0不开启',
  `wxpay` int(1) NOT NULL DEFAULT '1' COMMENT '微信支付 1开启 0不开启',
  `qqpay` int(1) NOT NULL DEFAULT '1' COMMENT 'QQ支付 1开启 0不开启',
  `mailon` int(1) NOT NULL DEFAULT '0' COMMENT '是否开启邮箱自动发卡 1开启 0不开启',
  `emailhost` varchar(50) DEFAULT NULL COMMENT '邮箱服务器地址',
  `emailport` int(4) DEFAULT NULL COMMENT '邮箱端口',
  `emailuser` varchar(50) DEFAULT NULL COMMENT '邮箱用户名',
  `emailpass` varchar(50) DEFAULT NULL COMMENT '邮箱密码',
  `bbspayid` int(10) DEFAULT NULL COMMENT '玖讯支付商户ID',
  `bbspaykey` varchar(32) DEFAULT NULL COMMENT '玖讯支付商户秘钥',
  `goodgg` text COMMENT '商品页公告',
  `indexmode` int(1) NOT NULL DEFAULT '0' COMMENT '首页显示模式 0为分类模式 1列表模式',
  `opdl` decimal(6,2) NOT NULL DEFAULT '0.01' COMMENT '代理开通费用',
  `maxsl` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='网站设置';

--
-- 转存表中的数据 `options`
--

INSERT INTO `options` (`id`, `sitename`, `siteurl`, `qq`, `gonggao`, `keywords`, `description`, `adminuser`, `adminpass`, `tongji`, `logoimg`, `paytype`, `partner`, `key`, `alipay`, `wxpay`, `qqpay`, `mailon`, `emailhost`, `emailport`, `emailuser`, `emailpass`, `bbspayid`, `bbspaykey`, `goodgg`, `indexmode`, `opdl`, `maxsl`) VALUES
(1, '自动发卡平台', 'http://fk.daokewl.com/', 1665555255, '<p style=\"text-align:center;\">\r\n	<br />\r\n</p>', '全自动发卡', '个人自动发卡平台', 'admin', '14e1b600b1fd579f47433b88e8d85291', '', 'https://www.3ka.cn/static/upload/2bc2951b2e31b4e0/68a0fc0ed8a61e56.png', 2, 561561, '123465456789', 1, 1, 0, 0, 'smtp.exmail.qq.com', 25, '1665555255@qq.com', '5284326chen', 1000, '2kcjy923i0bldu4o8lzc191f4mr4', '', 1, '0.10', 0);

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

--
-- 表的结构 `order`
--

CREATE TABLE `order` (
  `id` int(11) NOT NULL,
  `ddid` varchar(50) DEFAULT NULL,
  `goodid` int(5) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `price` decimal(6,2) DEFAULT NULL,
  `count` int(2) NOT NULL DEFAULT '1' COMMENT '购买数量',
  `email` varchar(50) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `time` varchar(30) DEFAULT NULL,
  `yeskm` int(1) NOT NULL DEFAULT '0' COMMENT '卡密是否写入数据库',
  `daili` int(5) DEFAULT NULL,
  `payno` varchar(60) DEFAULT NULL COMMENT '流水号'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='订单列表';

--
-- 转存表中的数据 `order`
--

INSERT INTO `order` (`id`, `ddid`, `goodid`, `name`, `price`, `count`, `email`, `type`, `status`, `time`, `yeskm`, `daili`, `payno`) VALUES
(1005, '2020022322525960182', 68, '测试商品2', '0.10', 1, '1665555255', 'alipay', 1, '2020-02-23 22:52:59', 1, NULL, '2020022322525960182');

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

--
-- 表的结构 `recharge`
--

CREATE TABLE `recharge` (
  `id` varchar(30) NOT NULL DEFAULT '',
  `dailiid` int(11) DEFAULT NULL COMMENT '代理ID',
  `money` decimal(7,2) DEFAULT NULL COMMENT '充值金额',
  `type` varchar(50) DEFAULT NULL COMMENT '支付方式',
  `time` varchar(30) DEFAULT NULL COMMENT '充值时间',
  `status` int(1) DEFAULT NULL COMMENT '0失败，1成功'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `recharge`
--

INSERT INTO `recharge` (`id`, `dailiid`, `money`, `type`, `time`, `status`) VALUES
('CZ202002232150021555', 9, '0.10', 'alipay', '2020-02-23 21:50:02', 1),
('CZ202002232158419688', 9, '0.01', 'qqpay', '2020-02-23 21:58:41', 1);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `article`
--
ALTER TABLE `article`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- 使用表AUTO_INCREMENT `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- 使用表AUTO_INCREMENT `daili`
--
ALTER TABLE `daili`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- 使用表AUTO_INCREMENT `goods`
--
ALTER TABLE `goods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- 使用表AUTO_INCREMENT `kami`
--
ALTER TABLE `kami`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1444;

--
-- 使用表AUTO_INCREMENT `links`
--
ALTER TABLE `links`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- 使用表AUTO_INCREMENT `options`
--
ALTER TABLE `options`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 使用表AUTO_INCREMENT `order`
--
ALTER TABLE `order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1006;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
