-- Adminer 4.6.3 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `sl_ad`;
CREATE TABLE `sl_ad` (
  `A_id` int(11) NOT NULL AUTO_INCREMENT,
  `A_type` int(11) NOT NULL DEFAULT '0',
  `A_pic` text,
  `A_text` text,
  `A_url` text,
  `A_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `A_time` datetime DEFAULT NULL,
  `A_long` int(11) NOT NULL DEFAULT '0',
  `A_order` int(11) NOT NULL DEFAULT '0',
  `A_red` int(11) NOT NULL DEFAULT '0',
  `A_bold` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`A_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_ad` (`A_id`, `A_type`, `A_pic`, `A_text`, `A_url`, `A_price`, `A_time`, `A_long`, `A_order`, `A_red`, `A_bold`) VALUES
(3,	0,	'',	'*美国香港【专线】【高防】秒开',	'https://www.baidu.com/',	10.00,	'2020-09-03 14:38:05',	1000,	0,	0,	0),
(4,	0,	'',	'★香港专线服务器★不卡 不丢包★',	'https://www.baidu.com/',	10.00,	'2020-09-03 14:38:49',	1000,	0,	0,	0),
(5,	0,	'',	'【超级防御服务器】★打不死高防',	'https://www.baidu.com/',	10.00,	'2020-09-03 14:39:11',	10000,	0,	0,	0),
(6,	0,	'',	'傲翔云|香港韩国日本台湾独服VPS',	'https://www.baidu.com/',	10.00,	'2020-09-03 14:39:26',	1000,	0,	0,	0),
(7,	0,	'',	'五九盾高防&无视DDOS攻击',	'https://www.baidu.com/',	10.00,	'2020-09-03 14:39:49',	1000,	0,	0,	0),
(8,	0,	'nopic.png',	'Flash网站之家Flash云网站',	'https://www.baidu.com/',	10.00,	'2020-09-03 14:40:11',	1000,	0,	1,	1),
(9,	0,	'nopic.png',	'短网址微信QQ域名防拦截系统',	'https://7ym.me',	10.00,	'2020-09-03 14:40:30',	1000,	0,	1,	1),
(10,	1,	'1.jpg',	'',	'https://www.aliyun.com/activity/daily/bestoffer?userCode=oguhd2dz',	10.00,	'2020-09-03 14:46:38',	10000,	5,	0,	0),
(13,	1,	'4.png',	'',	'https://www.aliyun.com/daily-act/ecs/activity_selection?userCode=oguhd2dz',	10.00,	'2020-09-03 14:46:38',	10000,	4,	0,	0),
(14,	0,	'nopic.png',	'发货100虚拟商品自动发货系统',	'http://www.baidu.com',	10.00,	'2020-09-03 14:36:44',	1000,	0,	1,	1),
(16,	0,	'nopic.png',	'闪灵企业自助建站系统S-CMS',	'https://shanling.top',	10.00,	'2020-09-03 14:38:05',	1,	0,	1,	1),
(24,	1,	'2.png',	'',	'https://club.aliyun.com/?userCode=oguhd2dz',	10.00,	'2020-09-03 14:46:38',	10000,	3,	0,	0),
(25,	1,	'3.png',	'',	'https://www.aliyun.com/database/dbfirstbuy?userCode=oguhd2dz',	10.00,	'2020-09-03 14:46:38',	10000,	2,	0,	0),
(29,	2,	'20200905163907QL.gif',	'',	'https://www.baidu.com/',	0.00,	'2020-09-05 16:38:53',	1,	1,	0,	0);

DROP TABLE IF EXISTS `sl_config`;
CREATE TABLE `sl_config` (
  `C_title` text,
  `C_keyword` text,
  `C_description` text,
  `C_logo` text,
  `C_ico` text,
  `C_beian` text,
  `C_copyright` text,
  `C_code` text,
  `C_admin` text,
  `C_pwd` text,
  `C_urlprice` decimal(10,2) NOT NULL DEFAULT '0.00',
  `C_adprice1` decimal(10,2) NOT NULL DEFAULT '0.00',
  `C_adprice2` decimal(10,2) NOT NULL DEFAULT '0.00',
  `C_adprice3` decimal(10,2) NOT NULL DEFAULT '0.00',
  `C_day` int(11) NOT NULL DEFAULT '0',
  `C_qq` text,
  `C_mobile` text,
  `C_pid` text,
  `C_pkey` text,
  `C_authcode` text,
  `C_sign` text,
  `C_time` datetime DEFAULT NULL,
  `C_wxid` text,
  `C_wxkey` text,
  `C_swkey` text,
  `C_alipayid` text,
  `C_alipaykey` text,
  `C_dwzon` text,
  `C_payon` text,
  `C_domain` text,
  `C_qrcode` text,
  `C_wx` text,
  `C_limit` int(11) DEFAULT '0',
  `C_limit2` int(11) DEFAULT '0',
  `C_rewrite` int(11) DEFAULT '0',
  `C_regon` int(11) DEFAULT '0',
  `C_indexon` int(11) DEFAULT '0',
  `C_alipayon` int(11) DEFAULT '0',
  `C_wxpayon` int(11) DEFAULT '0',
  `C_creatprice` decimal(10,2) DEFAULT '0.00',
  `C_payurl` text,
  `C_vipprice` decimal(10,2) DEFAULT '0.00',
  `C_fdomain` text,
  `C_extra` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_config` (`C_title`, `C_keyword`, `C_description`, `C_logo`, `C_ico`, `C_beian`, `C_copyright`, `C_code`, `C_admin`, `C_pwd`, `C_urlprice`, `C_adprice1`, `C_adprice2`, `C_adprice3`, `C_day`, `C_qq`, `C_mobile`, `C_pid`, `C_pkey`, `C_authcode`, `C_sign`, `C_time`, `C_wxid`, `C_wxkey`, `C_swkey`, `C_alipayid`, `C_alipaykey`, `C_dwzon`, `C_payon`, `C_domain`, `C_qrcode`, `C_wx`, `C_limit`, `C_limit2`, `C_rewrite`, `C_regon`, `C_indexon`, `C_alipayon`, `C_wxpayon`, `C_creatprice`, `C_payurl`, `C_vipprice`, `C_fdomain`, `C_extra`) VALUES
('您的网站名称',	'短网址,短网址API接口,匿名短网址,批量生成短链接,带统计的免费短网址',	'HTTPS短网址服务专业的网址缩短服务,具有稳定、快速、安全的特点,支持批量缩短、批量短网址还原、数据报表、开放API接口等服务',	'20200905121906Oe.png',	'20200905122258PI.ico',	'京ICP证XXXXX号-21',	'Copyright © 2019-2023 7ym.me , All Rights Reserved',	'<script type=\"text/javascript\" src=\"//js.users.51.la/20929251.js\"></script>',	'admin',	'7fef6171469e80d32c0559f88b377245',	1.00,	0.00,	0.00,	0.00,	30,	'123123123',	'010-10086',	'xxx',	'xxx',	'xxx',	'0aab015be8b2eae6dd5c810664fe96d3',	'2023-06-17 12:16:45',	'',	'',	'',	'',	'',	'-2',	'',	NULL,	'20210116140653NF.jpg',	'20210116141950v8.jpg',	30,	30,	0,	1,	1,	1,	1,	0.00,	'https://7-pay.cn/',	368.00,	'localhost:7001',	'');

DROP TABLE IF EXISTS `sl_domain`;
CREATE TABLE `sl_domain` (
  `D_id` int(11) NOT NULL AUTO_INCREMENT,
  `D_domain` text,
  `D_http` text,
  `D_show` int(11) DEFAULT '0',
  PRIMARY KEY (`D_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_domain` (`D_id`, `D_domain`, `D_http`, `D_show`) VALUES
(8,	'abc.com',	'http://',	1);

DROP TABLE IF EXISTS `sl_link`;
CREATE TABLE `sl_link` (
  `L_id` int(11) NOT NULL AUTO_INCREMENT,
  `L_title` text,
  `L_url` text,
  `L_order` int(11) NOT NULL DEFAULT '0',
  `L_pic` text,
  PRIMARY KEY (`L_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_link` (`L_id`, `L_title`, `L_url`, `L_order`, `L_pic`) VALUES
(1,	'百度',	'http://www.baidu.com',	5,	'202101161330403i.png'),
(2,	'腾讯',	'http://www.qq.com',	4,	'20210116133050EI.png'),
(3,	'新浪',	'http://www.sina.com',	3,	'20210116133056Rn.png'),
(4,	'发货100虚拟商品自动发货',	'https://fahuo100.cn',	2,	'20210116133118NF.png'),
(5,	'淘宝网',	'http://www.taobao.com',	1,	'20210116133150Mm.png'),
(6,	'S-CMS建站系统',	'https://www.s-cms.cn',	0,	'2021011613312745.png');

DROP TABLE IF EXISTS `sl_member`;
CREATE TABLE `sl_member` (
  `M_id` int(11) NOT NULL AUTO_INCREMENT,
  `M_login` text,
  `M_pwd` text,
  `M_key` text,
  `M_email` text,
  `M_head` text,
  `M_regtime` datetime DEFAULT NULL,
  `M_pwdcode` text,
  `M_money` decimal(10,2) DEFAULT '0.00',
  `M_vip` int(11) DEFAULT '0',
  PRIMARY KEY (`M_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_member` (`M_id`, `M_login`, `M_pwd`, `M_key`, `M_email`, `M_head`, `M_regtime`, `M_pwdcode`, `M_money`, `M_vip`) VALUES
(1,	'anchen',	'121242323fewgsdvsdvgsdvgsd',	'121242323fewgsdvsdvgsdvgsd',	'121242323fewgsdvsdvgsdvgsd',	'head.jpg',	NULL,	NULL,	0.00,	0),
(2,	'user3',	'980ac217c6b51e7dc41040bec1edfec8',	'DKGXMYrigZqIrSd70oUwNIwbTrxeZn4E',	'user21@qq.com',	'head.jpg',	'2020-12-16 19:03:51',	'',	0.00,	0),
(3,	'user2',	'980ac217c6b51e7dc41040bec1edfec8',	'ieOx7OWP5La9WDF3yTtV3bdF5V8kPvS9',	'user2@qq.com',	'head.jpg',	'2021-03-25 14:17:50',	NULL,	99.00,	0),
(4,	'user5',	'980ac217c6b51e7dc41040bec1edfec8',	'AJeplQJ9o9YpgtNOPCp9fIzX2mzYOLrr',	'user5@qq.com',	'head.jpg',	'2021-07-09 12:07:15',	NULL,	0.00,	0);

DROP TABLE IF EXISTS `sl_orders`;
CREATE TABLE `sl_orders` (
  `O_id` int(11) NOT NULL AUTO_INCREMENT,
  `O_title` text,
  `O_attach` text,
  `O_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `O_time` datetime DEFAULT NULL,
  `O_tradeno` text,
  `O_state` int(11) NOT NULL DEFAULT '0',
  `O_contact` text,
  `O_mid` int(11) DEFAULT '0',
  PRIMARY KEY (`O_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_orders` (`O_id`, `O_title`, `O_attach`, `O_money`, `O_time`, `O_tradeno`, `O_state`, `O_contact`, `O_mid`) VALUES
(1,	'广告申请',	'0|4|1|2|3',	20.00,	'2020-09-05 21:36:23',	NULL,	0,	NULL,	0),
(2,	'广告申请',	'0|4|1|2|3',	20.00,	'2020-09-05 21:37:47',	NULL,	0,	NULL,	0),
(3,	'广告申请',	'0|1|直接输入网址访问||https://www.baidu.com/',	5.00,	'2020-09-06 09:55:38',	NULL,	0,	NULL,	0),
(4,	'广告申请',	'0|12|速发国际短信内容不限到达率90起1||https://www.baidu.com/',	60.00,	'2020-09-06 10:02:59',	NULL,	0,	NULL,	0),
(5,	'广告申请',	'0|1|2||1',	5.00,	'2020-09-06 10:25:56',	NULL,	0,	NULL,	0),
(6,	'升级永久',	'100034',	1.00,	'2020-09-06 11:01:13',	NULL,	0,	NULL,	0),
(7,	'短网址升级永久',	'100036',	1.00,	'2020-09-06 11:01:47',	NULL,	0,	NULL,	0),
(8,	'广告申请',	'0|1|1||2',	5.00,	'2020-09-07 10:48:00',	NULL,	0,	NULL,	0),
(9,	'广告申请',	'0|1|1||2',	5.00,	'2020-09-07 10:49:29',	NULL,	0,	NULL,	0),
(10,	'广告申请',	'0|1|测试文字||https://www.baidu.com/',	5.00,	'2020-09-08 12:48:28',	NULL,	0,	'6667777',	0),
(11,	'广告申请',	'0|1|测试文字||https://www.baidu.com/',	5.00,	'2020-09-08 20:58:09',	NULL,	0,	'6667777',	0),
(12,	'广告申请',	'0|1|1||2',	5.00,	'2020-09-08 20:58:29',	NULL,	0,	'2',	0),
(13,	'短网址升级永久',	'100067',	1.00,	'2020-10-24 11:55:46',	NULL,	0,	NULL,	0),
(27,	'账户充值1元',	'2',	1.00,	'2021-02-24 10:11:15',	NULL,	0,	NULL,	2),
(29,	'升级短链',	'23',	1.00,	'2021-07-11 14:12:16',	'2021071114121680680541',	1,	NULL,	3),
(26,	'升级短链',	'2',	1.00,	'2021-02-24 09:40:44',	'2021022409404487346496',	1,	NULL,	2),
(28,	'升级短链',	'2',	1.00,	'2021-02-24 13:51:36',	'2021022413513615526123',	1,	NULL,	2),
(30,	'账户充值1元',	'3',	1.00,	'2023-05-12 23:19:32',	NULL,	0,	NULL,	3),
(31,	'账户充值1元',	'3',	1.00,	'2023-05-12 23:19:41',	NULL,	0,	NULL,	3),
(32,	'账户充值1元',	'3',	1.00,	'2023-05-12 23:20:42',	NULL,	0,	NULL,	3);

DROP TABLE IF EXISTS `sl_short`;
CREATE TABLE `sl_short` (
  `S_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `S_url` text,
  `S_time` datetime DEFAULT NULL,
  `S_vip` int(11) NOT NULL DEFAULT '0',
  `S_times` int(11) NOT NULL DEFAULT '0',
  `S_short` text,
  `S_mid` int(11) DEFAULT '0',
  `S_d` int(11) DEFAULT '0',
  `S_sort` int(11) DEFAULT '0',
  `S_type` int(11) DEFAULT '0',
  `S_remark` text,
  `S_statistics` text,
  `S_statistics_domain` text,
  `S_fit` int(11) DEFAULT '0',
  PRIMARY KEY (`S_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `sl_sort`;
CREATE TABLE `sl_sort` (
  `S_id` int(11) NOT NULL AUTO_INCREMENT,
  `S_mid` int(11) NOT NULL DEFAULT '0',
  `S_title` text,
  PRIMARY KEY (`S_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_sort` (`S_id`, `S_mid`, `S_title`) VALUES
(1,	3,	'新短链'),
(2,	3,	'旧短链'),
(4,	4,	'前端开发'),
(5,	4,	'淘宝电商');

DROP TABLE IF EXISTS `sl_statistics`;
CREATE TABLE `sl_statistics` (
  `S_id` int(11) NOT NULL AUTO_INCREMENT,
  `S_lid` int(11) NOT NULL DEFAULT '0',
  `S_ip` text,
  `S_browser` text,
  `S_time` text,
  `S_terminal` text,
  `S_add` text,
  `S_mid` int(11) DEFAULT '0',
  PRIMARY KEY (`S_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_statistics` (`S_id`, `S_lid`, `S_ip`, `S_browser`, `S_time`, `S_terminal`, `S_add`, `S_mid`) VALUES
(1,	36,	'::1',	'Chrome',	'2022-06-10 16:45:04',	'电脑端',	'山东省淄博市',	-1);

-- 2023-12-02 06:36:12
