2 Star 1 Fork 1

夏天 / 网址缩短-短网址

Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
This repository doesn't specify license. Without author's permission, this code is only for learning and cannot be used for other purposes.
Clone or download
python.sql 9.18 KB
Copy Edit Web IDE Raw Blame History
夏天 authored 2019-07-10 18:36 . 提交代码
/*
Navicat Premium Data Transfer
Source Server : 127.0.0.1
Source Server Type : MySQL
Source Server Version : 50719
Source Host : localhost:3306
Source Schema : python
Target Server Type : MySQL
Target Server Version : 50719
File Encoding : 65001
Date: 10/07/2019 18:27:51
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for suoim_dwz
-- ----------------------------
DROP TABLE IF EXISTS `suoim_dwz`;
CREATE TABLE `suoim_dwz` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time_date` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`short_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `time_date`(`time_date`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of suoim_dwz
-- ----------------------------
INSERT INTO `suoim_dwz` VALUES (2, '20180911', 'http://suo.im/5rCDls');
INSERT INTO `suoim_dwz` VALUES (6, '20190424', 'http://suo.im/4AZLup\n');
INSERT INTO `suoim_dwz` VALUES (8, '20190425', 'http://suo.im/5rFHjG\n');
INSERT INTO `suoim_dwz` VALUES (20, '20190426', 'http://suo.im/4Q7cof\n');
INSERT INTO `suoim_dwz` VALUES (23, '20190427', 'http://suo.im/5cHkLu\n');
INSERT INTO `suoim_dwz` VALUES (25, '20190428', 'http://suo.im/4XHTcC\n');
INSERT INTO `suoim_dwz` VALUES (26, '20190503', 'http://www.biaohua123.com/a/jingyan/46.html');
INSERT INTO `suoim_dwz` VALUES (27, '20190506', 'http://suo.im/4CgfyH\n');
-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`password` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`age` int(11) NULL DEFAULT NULL,
`height` double NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (1, 'tom', '123', 18, 180.5);
INSERT INTO `t_user` VALUES (2, '夏京', '123', 18, 180.5);
INSERT INTO `t_user` VALUES (3, 'xj', '123', 18, 180.5);
-- ----------------------------
-- Table structure for xj_dwz
-- ----------------------------
DROP TABLE IF EXISTS `xj_dwz`;
CREATE TABLE `xj_dwz` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time_date` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`short_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`long_url` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `time_date`(`time_date`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100044 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of xj_dwz
-- ----------------------------
INSERT INTO `xj_dwz` VALUES (100000, '1561738584', 'bHGT8a', 'http://127.0.0.1:5050/');
INSERT INTO `xj_dwz` VALUES (100001, '1561738646', 'bHGT9a', 'http://127.0.0.1:5050/');
INSERT INTO `xj_dwz` VALUES (100002, '1561738753', 'bHGTAJ', 'https://www.so.com/?src=se_favorite');
INSERT INTO `xj_dwz` VALUES (100003, '1561739503', 'bHGTMP', 'http://www.google.com.hk/search?client=aff-cs-360se-channel&channel=bookmark&q=');
INSERT INTO `xj_dwz` VALUES (100004, '1561740777', 'bHGUhx', 'http://www.51cto.com/');
INSERT INTO `xj_dwz` VALUES (100005, '1561740963', 'bHGUkx', 'https://www.m5c.top/');
INSERT INTO `xj_dwz` VALUES (100006, '1561741067', 'bHGUmd', 'www.biaohua123.com');
INSERT INTO `xj_dwz` VALUES (100007, '1561741394', 'bHGUru', 'https://hao.360.com/?src=bm');
INSERT INTO `xj_dwz` VALUES (100008, '1561741436', 'bHGUsa', 'https://www.360kan.com/dianshi/index.html');
INSERT INTO `xj_dwz` VALUES (100009, '1561764477', 'bHHarD', 'https://mini.eastday.com/a/190628104854881.html?qid=02160');
INSERT INTO `xj_dwz` VALUES (100010, '1561767147', 'bHHaYH', 'http://wan.360.cn/?src=se-scj-top01&channel=515460173');
INSERT INTO `xj_dwz` VALUES (100011, '1561767490', 'bHHbeo', 'http://wan.360.cn/game');
INSERT INTO `xj_dwz` VALUES (100012, '1561792441', 'bHHh8F', 'https://www.360kuai.com/pc/detail?url=http%3A%2F%2Ffawen.news.so.com%2F3009e1f2c47fff4d594ccfe1fe56aa79&check=45283ce1c50be748&subt=fifteen_words_title&subi=fifteen_image&uid=g1561792357697445250&sign=360_8910f42c&tj_url=99ceb19851124f7b0&scene=&refer_scene=0');
INSERT INTO `xj_dwz` VALUES (100013, '1561820046', 'bHHoJU', 'https://mini.eastday.com/a/190629193906571.html?qid=02160');
INSERT INTO `xj_dwz` VALUES (100014, '1561820092', 'bHHoKE', 'https://mini.eastday.com/topic/index.html?uk=190629083159495&newstype=guonei&channel=mainland');
INSERT INTO `xj_dwz` VALUES (100015, '1561942750', 'bHHKFa', 'https://www.tmall.com/?ali_trackid=2:mm_26632323_6762370_25910656:1561942743_278_690565481');
INSERT INTO `xj_dwz` VALUES (100016, '1561942781', 'bHHKF5', 'http://www.china.com.cn/');
INSERT INTO `xj_dwz` VALUES (100017, '3044903', 'mMhv', 'http://blog.chinaunix.net/uid/30810013.html');
INSERT INTO `xj_dwz` VALUES (100018, '1249389', 'fpb1', 'https://gitee.com/sun0591/gopub');
INSERT INTO `xj_dwz` VALUES (100019, '1224278', 'fi40', 'http://doc.zhrt.com.cn/web/#/15?page_id=9');
INSERT INTO `xj_dwz` VALUES (100020, '881292', 'dHqy', 'http://doc.zhrt.com.cn/web/#/15?page_id=9');
INSERT INTO `xj_dwz` VALUES (100021, '243690', 'bby4', 'https://www.so.com/?src=se_favorite');
INSERT INTO `xj_dwz` VALUES (100022, '81348', 'vke', 'https://hao.360.com/?src=bm');
INSERT INTO `xj_dwz` VALUES (100023, '292389', 'bodX', 'https://hao.360.com/?src=bm');
INSERT INTO `xj_dwz` VALUES (100024, '125973', '6LP', 'http://www.biaohua123.com');
INSERT INTO `xj_dwz` VALUES (100025, '193453', 'Oun', 'http://www.biaohua123.com');
INSERT INTO `xj_dwz` VALUES (100026, '1282741', 'fxHx', 'http://pay.wan.360.cn/');
INSERT INTO `xj_dwz` VALUES (100027, '134213', '8UJ', 'http://www.biaohua123.com');
INSERT INTO `xj_dwz` VALUES (100028, '103249', '0Rt', 'http://wan.360.cn/?src=se-scj-top01&channel=515460173');
INSERT INTO `xj_dwz` VALUES (100029, '165331', 'HaD', 'http://wan.360.cn/?src=se-scj-top01&channel=515460173');
INSERT INTO `xj_dwz` VALUES (100030, '117239', '44X', 'www.biaohua123.com');
INSERT INTO `xj_dwz` VALUES (100031, '86301', 'w1X', 'http://wan.360.cn/?src=se-scj-top01&channel=515460173');
INSERT INTO `xj_dwz` VALUES (100032, '652387', 'cJIx', 'http://wan.360.cn/?src=se-scj-top01&channel=515460173');
INSERT INTO `xj_dwz` VALUES (100033, '105343', '1zf', 'http://wan.360.cn/?src=se-scj-top01&channel=515460173');
INSERT INTO `xj_dwz` VALUES (100034, '2358049', 'jT1d', 'http://wan.360.cn/?src=se-scj-top01&channel=515460173');
INSERT INTO `xj_dwz` VALUES (100035, '4951292', 'uMd8', 'http://wan.360.cn/?src=se-scj-top01&channel=515460173');
INSERT INTO `xj_dwz` VALUES (100036, '86923', 'wBZ', 'https://ke.qq.com/webcourse/index.html#cid=293104&term_id=100347314&taid=2203876568889584&vid=i14257135jy');
INSERT INTO `xj_dwz` VALUES (100037, '6489260', '1oj4', 'http://kibana.zlkjbj.cn/app/kibana#/dashboard/8626ca70-9ad9-11e8-a7ec-a309ac1859b4?_g=(refreshInterval:(display:Off,pause:!f,value:0),time:(from:now-15m,mode:quick,to:now))&_a=(filters:!(),options:(darkTheme:!f),panels:!((col:1,id:\'2ffdcb80-e0e3-11e8-828a-292cfa475b92\',panelIndex:8,row:4,size_x:6,size_y:3,type:visualization),(col:1,id:\'69eedd20-e0e3-11e8-828a-292cfa475b92\',panelIndex:9,row:7,size_x:6,size_y:3,type:visualization),(col:7,id:c0a7f1b0-e0e3-11e8-828a-292cfa475b92,panelIndex:10,row:7,size_x:6,size_y:3,type:visualization),(col:7,id:f500c820-e0e2-11e8-828a-292cfa475b92,panelIndex:11,row:4,size_x:6,size_y:3,type:visualization),(col:1,id:f9e11f90-e194-11e8-a0ca-11264b4b2ec8,panelIndex:12,row:10,size_x:6,size_y:3,type:visualization),(col:7,id:d4ead7d0-e194-11e8-a0ca-11264b4b2ec8,panelIndex:13,row:10,size_x:6,size_y:3,type:visualization),(col:1,id:\'4515aab0-1ee6-11e9-a4ff-7bffc5070c8b\',panelIndex:15,row:1,size_x:6,size_y:3,type:visualization),(col:7,id:\'58c15f50-1ee6-11e9-a4ff-7bffc5070c8b\',panelIndex:16,row:1,size_x:6,size_y:3,type:visualization),(col:1,id:\'1e0255d0-aaa7-11e8-b1cf-99795ccf5f91\',panelIndex:17,row:13,size_x:6,size_y:3,type:visualization)),query:(query_string:(analyze_wildcard:!t,query:\'*\')),timeRestore:!f,title:access_suo_im-95nginx%E7%BB%9F%E8%AE%A1%E4%BF%A1%E6%81%AF,uiState:(),viewMode:view)');
INSERT INTO `xj_dwz` VALUES (100038, '606327', 'c7J3', 'https://new.qq.com/omn/20190708/20190708V0FSUK00.html');
INSERT INTO `xj_dwz` VALUES (100039, '87290', 'wHU', 'http://www.biaohua123.com');
INSERT INTO `xj_dwz` VALUES (100040, '121324', '58Q', 'https://translate.google.cn/');
INSERT INTO `xj_dwz` VALUES (100041, '564812', 'cwVS', 'http://www.360doc.com/content/18/0207/17/16915_728405707.shtml');
INSERT INTO `xj_dwz` VALUES (100042, '122851', '5X3', 'http://www.360doc.com/content/18/0207/17/16915_728405707.shtml');
INSERT INTO `xj_dwz` VALUES (100043, '228272', 'XxO', 'http://www.biaohua123.com');
SET FOREIGN_KEY_CHECKS = 1;

Comment ( 0 )

Sign in for post a comment

Python
1
https://gitee.com/Xiajing869/test_dwz.git
git@gitee.com:Xiajing869/test_dwz.git
Xiajing869
test_dwz
网址缩短-短网址
master

Search