mysql8.0 tp5_tp5.sql · 雨絡丶縋憶/Tp5.1 后台 - Gitee.com

最新推荐文章于 2021-12-01 17:45:38 发布
最新推荐文章于 2021-12-01 17:45:38 发布
阅读量2.4k 收藏
点赞数
文章标签： mysql8.0 tp5
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_28866303/article/details/114341040
版权

/*

Navicat MySQL Data Transfer

Source Server : localhost

Source Server Version : 50617

Source Host : localhost:3306

Source Database : tp5

Target Server Type : MYSQL

Target Server Version : 50617

File Encoding : 65001

Date: 2018-12-27 15:31:05

*/

SET FOREIGN_KEY_CHECKS=0;

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

-- Table structure for admins

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

DROP TABLE IF EXISTS `admins`;

CREATE TABLE `admins` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',

`name` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',

`phone` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',

`password` varchar(35) NOT NULL DEFAULT '' COMMENT '密码',

`avatar` varchar(100) DEFAULT '' COMMENT '头像',

`email` varchar(100) NOT NULL DEFAULT '' COMMENT '电子邮箱',

`login_at` timestamp NULL DEFAULT NULL COMMENT '登录时间',

`create_at` timestamp NOT NULL COMMENT '创建时间',

`logout_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',

`token` varchar(59) NOT NULL DEFAULT '' COMMENT 'Session标识',

`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',

`update_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',

PRIMARY KEY (`id`),

UNIQUE KEY `username` (`name`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='管理员表';

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

-- Records of admins

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

INSERT INTO `admins` VALUES ('1', 'admin', '13377875828', '7f44b13955235245b2497399d7', '', '164875052@qq.com', '2018-12-10 10:43:07', '2018-12-10 10:42:59', '0000-00-00 00:00:00', '2018122714164499995598', '1', null);

INSERT INTO `admins` VALUES ('2', 'user1', '13377875828', '7f44b13955235245b2497399d7', '', '123123@qq.com', '2018-12-15 14:14:45', '2018-12-10 17:16:07', '0000-00-00 00:00:00', '2018122610405353545149', '1', '2018-12-19 10:42:01');

INSERT INTO `admins` VALUES ('3', 'admin1', '13377875828', '7f44b13955235245b2497399d7', '', '123123@qq.com', '2018-12-15 14:14:51', '2018-12-11 14:05:46', '0000-00-00 00:00:00', '2018122710262751545597', '1', '2018-12-15 14:05:30');

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

-- Table structure for areas

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

DROP TABLE IF EXISTS `areas`;

CREATE TABLE `areas` (

`id` int(10) NOT NULL AUTO_INCREMENT,

`name` varchar(30) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`)

) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='地区';

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

-- Records of areas

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

INSERT INTO `areas` VALUES ('8', '东西湖区');

INSERT INTO `areas` VALUES ('27', '仙桃市');

INSERT INTO `areas` VALUES ('17', '十堰市');

INSERT INTO `areas` VALUES ('24', '咸宁市');

INSERT INTO `areas` VALUES ('29', '天门市');

INSERT INTO `areas` VALUES ('22', '孝感市');

INSERT INTO `areas` VALUES ('31', '安徽省');

INSERT INTO `areas` VALUES ('19', '宜昌市');

INSERT INTO `areas` VALUES ('26', '恩施市');

INSERT INTO `areas` VALUES ('13', '新洲区');

INSERT INTO `areas` VALUES ('5', '武昌区');

INSERT INTO `areas` VALUES ('14', '武汉市');

INSERT INTO `areas` VALUES ('9', '汉南区');

INSERT INTO `areas` VALUES ('4', '汉阳区');

INSERT INTO `areas` VALUES ('11', '江夏区');

INSERT INTO `areas` VALUES ('1', '江岸区');

INSERT INTO `areas` VALUES ('2', '江汉区');

INSERT INTO `areas` VALUES ('33', '河南省');

INSERT INTO `areas` VALUES ('7', '洪山区');

INSERT INTO `areas` VALUES ('32', '湖南省');

INSERT INTO `areas` VALUES ('28', '潜江市');

INSERT INTO `areas` VALUES ('30', '省外');

INSERT INTO `areas` VALUES ('3', '硚口区');

INSERT INTO `areas` VALUES ('18', '荆州市');

INSERT INTO `areas` VALUES ('20', '荆门市');

INSERT INTO `areas` VALUES ('10', '蔡甸区');

INSERT INTO `areas` VALUES ('16', '襄樊市');

INSERT INTO `areas` VALUES ('21', '鄂州市');

INSERT INTO `areas` VALUES ('25', '随州市');

INSERT INTO `areas` VALUES ('6', '青山区');

INSERT INTO `areas` VALUES ('23', '黄冈市');

INSERT INTO `areas` VALUES ('15', '黄石市');

INSERT INTO `areas` VALUES ('12', '黄陂区');

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

-- Table structure for articles

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

DROP TABLE IF EXISTS `articles`;

CREATE TABLE `articles` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',

`category_id` int(10) NOT NULL COMMENT '文章分类',

`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文章标题',

`is_top` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1是0否',

`sort_order` tinyint(2) DEFAULT NULL COMMENT '排序',

`content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文章内容',

`view_num` int(10) NOT NULL DEFAULT '0' COMMENT '点击量',

`photo_id` int(11) DEFAULT NULL COMMENT '缩略图',

`is_recommend` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1是0否',

`create_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',

`update_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',

`keyword` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE,

KEY `articles_category_id_index` (`category_id`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='新闻管理';

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

-- Records of articles

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

INSERT INTO `articles` VALUES ('66', '34', '1111', '1', '77', '

1111111111111111111111

', '0', '35', '0', '2018-12-17 13:14:18', '2018-12-17 13:14:18', '1111', '111111111');

INSERT INTO `articles` VALUES ('68', '27', '111111', '0', '88', '

123123123

', '0', '34', '1', '2018-12-17 11:16:12', '2018-12-17 11:16:12', '1113333333333', '123123123');

INSERT INTO `articles` VALUES ('69', '14', '555555555555', '0', '55', '

3333333333333333

', '0', '36', '1', '2018-12-17 13:14:26', '2018-12-17 13:14:26', '33333', '3333333');

INSERT INTO `articles` VALUES ('70', '34', '驱蚊器翁e驱蚊器翁e', '1', '66', '

123123123\"home.png\"/

', '0', '25', '0', '2018-12-17 09:47:10', '2018-12-17 09:47:10', ' 123123', '123123');

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

-- Table structure for categories

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

DROP TABLE IF EXISTS `categories`;

CREATE TABLE `categories` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',

`name` varchar(30) NOT NULL DEFAULT '',

`description` varchar(255) DEFAULT NULL,

`photo_id` int(11) DEFAULT NULL COMMENT '图片',

`create_at` timestamp NOT NULL COMMENT '创建时间',

`update_at` timestamp NOT NULL COMMENT '更新时间',

`sort_order` tinyint(2) NOT NULL DEFAULT '0' COMMENT '权重',

PRIMARY KEY (`id`),

KEY `weigh` (`sort_order`,`id`),

KEY `pid` (`parent_id`)

) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='分类表';

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

-- Records of categories

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

INSERT INTO `categories` VALUES ('1', '0', '品牌介绍', null, '0', '2018-12-17 09:44:51', '2018-12-17 09:44:59', '1');

INSERT INTO `categories` VALUES ('2', '0', '基地拍摄', null, '0', '2018-12-17 09:44:55', '2018-12-17 09:44:59', '2');

INSERT INTO `categories` VALUES ('3', '2', '白日梦内景', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '3');

INSERT INTO `categories` VALUES ('4', '2', '基地总览', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '4');

INSERT INTO `categories` VALUES ('5', '0', '妆面特写', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '5');

INSERT INTO `categories` VALUES ('7', '5', '每日特写', null, '0', '2018-12-17 09:44:59', '2018-12-27 14:29:40', '9');

INSERT INTO `categories` VALUES ('14', '0', '服务流程', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '14');

INSERT INTO `categories` VALUES ('16', '0', '服饰细节', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '16');

INSERT INTO `categories` VALUES ('17', '0', '男士与男装', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '17');

INSERT INTO `categories` VALUES ('18', '0', '关于产品', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '55');

INSERT INTO `categories` VALUES ('19', '1', '品牌介绍', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '19');

INSERT INTO `categories` VALUES ('20', '1', '果石品牌', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '20');

INSERT INTO `categories` VALUES ('21', '1', '果石发展', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '21');

INSERT INTO `categories` VALUES ('22', '1', '果石荣誉', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '22');

INSERT INTO `categories` VALUES ('23', '1', '跨界联合', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '23');

INSERT INTO `categories` VALUES ('24', '1', '店面介绍', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '24');

INSERT INTO `categories` VALUES ('25', '5', '花', null, '0', '2018-12-17 09:44:59', '2018-12-27 14:57:21', '17');

INSERT INTO `categories` VALUES ('26', '5', '妆面', null, '0', '2018-12-17 09:44:59', '2018-12-27 15:18:05', '6');

INSERT INTO `categories` VALUES ('27', '5', '创意', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '27');

INSERT INTO `categories` VALUES ('28', '5', '男士', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '28');

INSERT INTO `categories` VALUES ('29', '5', '竞品对比', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '29');

INSERT INTO `categories` VALUES ('30', '2', '白日梦外景', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '30');

INSERT INTO `categories` VALUES ('31', '2', '场景理念', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '31');

INSERT INTO `categories` VALUES ('32', '2', '白日梦实景图', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '32');

INSERT INTO `categories` VALUES ('33', '2', '白日梦理念', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '33');

INSERT INTO `categories` VALUES ('34', '0', '摄影团队', null, '0', '2018-12-17 09:44:59', '2018-12-17 09:44:59', '34');

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

-- Table structure for clerks

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

DROP TABLE IF EXISTS `clerks`;

CREATE TABLE `clerks` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(30) DEFAULT NULL COMMENT '店员',

`category_id` smallint(5) DEFAULT NULL COMMENT '1店长2组长3化妆师4礼服师5前台',

`status` tinyint(1) DEFAULT '1' COMMENT '是否在职1是0否',

`create_at` timestamp NULL DEFAULT NULL,

`update_at` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='店员表';

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

-- Records of clerks

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

INSERT INTO `clerks` VALUES ('1', '齐莎莎', '1', '1', '2018-12-07 16:03:54', '2018-12-07 16:03:57');

INSERT INTO `clerks` VALUES ('3', '天天', '2', '1', '2018-12-07 17:11:11', null);

INSERT INTO `clerks` VALUES ('4', '刘明黎', '2', '1', '2018-12-07 17:11:28', null);

INSERT INTO `clerks` VALUES ('5', '小邬', '5', '1', '2018-12-07 16:57:25', null);

INSERT INTO `clerks` VALUES ('9', '修亿', '3', '1', '2018-12-07 17:59:36', null);

INSERT INTO `clerks` VALUES ('10', '张蔷', '3', '1', '2018-12-07 17:59:45', null);

INSERT INTO `clerks` VALUES ('11', '陈梦', '3', '1', '2018-12-07 17:59:58', null);

INSERT INTO `clerks` VALUES ('12', '尹燕燕', '3', '1', '2018-12-08 09:11:21', null);

INSERT INTO `clerks` VALUES ('13', '京京', '3', '1', '2018-12-08 09:11:51', null);

INSERT INTO `clerks` VALUES ('14', '宋晶晶', '3', '1', '2018-12-08 09:11:59', null);

INSERT INTO `clerks` VALUES ('15', '贾唯', '3', '1', '2018-12-08 09:12:07', null);

INSERT INTO `clerks` VALUES ('16', '奚晶', '3', '1', '2018-12-08 09:12:14', null);

INSERT INTO `clerks` VALUES ('17', '伊妮', '3', '1', '2018-12-08 09:12:23', null);

INSERT INTO `clerks` VALUES ('18', '月月', '3', '1', '2018-12-08 09:12:30', null);

INSERT INTO `clerks` VALUES ('19', '瞿朝', '3', '1', '2018-12-08 09:12:39', null);

INSERT INTO `clerks` VALUES ('20', '陈芳', '3', '1', '2018-12-08 09:12:48', null);

INSERT INTO `clerks` VALUES ('21', '易玮佳', '3', '1', '2018-12-08 09:12:56', null);

INSERT INTO `clerks` VALUES ('22', '晓琼', '3', '1', '2018-12-08 09:13:05', null);

INSERT INTO `clerks` VALUES ('23', 'coco', '3', '1', '2018-12-08 09:13:14', null);

INSERT INTO `clerks` VALUES ('24', '诗敏', '4', '1', '2018-12-08 09:13:26', null);

INSERT INTO `clerks` VALUES ('25', '小倩', '4', '1', '2018-12-08 09:13:34', null);

INSERT INTO `clerks` VALUES ('26', '任瑞恒', '4', '1', '2018-12-08 09:13:43', null);

INSERT INTO `clerks` VALUES ('27', '898989', '5', '1', '2018-12-22 09:33:11', null);

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

-- Table structure for customers

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

DROP TABLE IF EXISTS `customers`;

CREATE TABLE `customers` (

`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',

`name` varchar(30) NOT NULL COMMENT '姓名',

`phone` char(11) NOT NULL COMMENT '手机号',

`name1` varchar(30) DEFAULT NULL COMMENT '姓名1',

`phone1` char(11) DEFAULT NULL,

`wx` varchar(255) NOT NULL COMMENT '微信号',

`qq` char(11) NOT NULL,

`area_id` smallint(5) DEFAULT NULL COMMENT '地域',

`is_phone` tinyint(1) DEFAULT NULL COMMENT '电话客资1是0否',

`quren` smallint(5) DEFAULT NULL COMMENT '渠道确认',

`type` smallint(5) DEFAULT NULL COMMENT '客资类型',

`qudao_id` smallint(5) DEFAULT NULL COMMENT '渠道',

`is_urgent` tinyint(1) DEFAULT NULL COMMENT '紧急客资1是0否',

`style` smallint(5) DEFAULT NULL COMMENT '套系性质',

`kefu` varchar(35) DEFAULT NULL,

`wang` varchar(35) DEFAULT NULL,

`dian` varchar(30) DEFAULT NULL,

`mark` text,

`wedding_day` timestamp NULL DEFAULT NULL,

`create_at` timestamp NULL DEFAULT NULL COMMENT '录入时间',

`update_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='客资表';

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

-- Records of customers

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

INSERT INTO `customers` VALUES ('1', '5555533', '12313131313', '5555', '555131313', '666', '777', '2', '1', '1', '1', '2', '1', '0', '123123', 'user1', '汉口', '888889678678', '2018-12-21 00:00:00', '2018-12-17 18:06:19', '2018-12-17 18:06:21');

INSERT INTO `customers` VALUES ('3', '55555', '898989', '艾斯德斯', '13111111111', '666', '55555', '1', '0', '3', '2', '2', '0', '0', 'admin', 'user1', '未分配', '99999', '2018-12-21 00:00:00', '2018-12-18 15:08:31', null);

INSERT INTO `customers` VALUES ('5', '上课了', '13377875828', '阿萨德', '13111111111', '111111', '111111', '3', '1', '1', null, '5', '0', '0', 'admin', 'admin1', '汉口', '23123', '2018-12-21 00:00:00', '2018-12-19 17:18:30', null);

INSERT INTO `customers` VALUES ('6', '890890890', '15907193281', '艾斯德斯', '', '', '', '3', '1', '2', '3', '0', '0', '2', 'admin', 'user1', '未分配', '', null, '2018-12-22 11:09:52', null);

INSERT INTO `customers` VALUES ('10', '体育体育', '', '', '', '', '', '0', '1', null, null, '0', '0', '0', 'admin', 'user1', '未分配', '', null, '2018-12-24 13:16:31', null);

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

-- Table structure for customer_logs

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

DROP TABLE IF EXISTS `customer_logs`;

CREATE TABLE `customer_logs` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`customer_id` int(11) DEFAULT NULL COMMENT '客资ID',

`name` varchar(35) DEFAULT NULL COMMENT '姓名',

`log` varchar(255) DEFAULT NULL COMMENT '日志记录',

`create_at` timestamp NULL DEFAULT NULL,

`update_at` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COMMENT='客资列表操作日志';

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

-- Records of customer_logs

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

INSERT INTO `customer_logs` VALUES ('1', '6', 'admin', 'admin录入客资6', '2018-12-22 11:09:52', null);

INSERT INTO `customer_logs` VALUES ('2', '6', 'admin', 'admin更新客资6phone为15907193281', '2018-12-22 11:17:17', null);

INSERT INTO `customer_logs` VALUES ('7', '6', 'admin', 'admin更新客资6地区为武昌区', '2018-12-22 11:51:54', null);

INSERT INTO `customer_logs` VALUES ('8', '6', 'admin', 'admin更新客资6渠道确认为有效客资', '2018-12-22 11:52:49', null);

INSERT INTO `customer_logs` VALUES ('9', '6', 'admin', 'admin更新客资6客资类型为C', '2018-12-22 11:52:59', null);

INSERT INTO `customer_logs` VALUES ('10', '6', 'admin', 'admin更新客资6客户需求为单订跟妆', '2018-12-22 11:53:03', null);

INSERT INTO `customer_logs` VALUES ('11', '6', 'admin', 'admin更新客资6网销为user1', '2018-12-22 11:55:27', null);

INSERT INTO `customer_logs` VALUES ('12', '6', 'admin', 'admin更新客资6姓名1为艾斯德斯', '2018-12-22 11:57:18', null);

INSERT INTO `customer_logs` VALUES ('13', '5', 'admin', 'admin更新客资5渠道确认为无效毛客资', '2018-12-22 13:52:26', null);

INSERT INTO `customer_logs` VALUES ('14', '3', 'admin', 'admin更新客资3[地区]为东西湖区', '2018-12-22 13:53:28', null);

INSERT INTO `customer_logs` VALUES ('15', '1', 'admin', 'admin更新客资1[备注]为888889678678', '2018-12-22 13:57:27', null);

INSERT INTO `customer_logs` VALUES ('16', '7', 'admin', 'admin录入客资7', '2018-12-24 13:10:00', null);

INSERT INTO `customer_logs` VALUES ('17', '7', 'admin', 'admin更新客资7[网销]为user1', '2018-12-24 13:10:23', null);

INSERT INTO `customer_logs` VALUES ('18', '0', 'admin', 'admin删除了客资7', '2018-12-24 13:12:41', null);

INSERT INTO `customer_logs` VALUES ('19', '8', 'admin', 'admin录入客资8', '2018-12-24 13:13:12', null);

INSERT INTO `customer_logs` VALUES ('20', '0', 'admin', 'admin删除了客资8', '2018-12-24 13:14:26', null);

INSERT INTO `customer_logs` VALUES ('21', '9', 'admin', 'admin录入客资9', '2018-12-24 13:14:37', null);

INSERT INTO `customer_logs` VALUES ('22', '0', 'admin', 'admin删除了客资9', '2018-12-24 13:16:24', null);

INSERT INTO `customer_logs` VALUES ('23', '10', 'admin', 'admin录入客资10', '2018-12-24 13:16:32', null);

INSERT INTO `customer_logs` VALUES ('24', '10', 'admin', 'admin更新客资10[网销]为user1', '2018-12-24 13:16:55', null);

INSERT INTO `customer_logs` VALUES ('25', '11', 'admin', 'admin录入客资11', '2018-12-24 13:32:07', null);

INSERT INTO `customer_logs` VALUES ('26', '0', 'admin', 'admin删除了客资11', '2018-12-24 13:35:24', null);

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

-- Table structure for galleries

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

DROP TABLE IF EXISTS `galleries`;

CREATE TABLE `galleries` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`img` varchar(255) DEFAULT NULL,

`title` varchar(30) DEFAULT NULL,

`category_id` int(10) DEFAULT NULL,

`create_at` timestamp NULL DEFAULT NULL,

`update_at` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4;

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

-- Records of galleries

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

INSERT INTO `galleries` VALUES ('1', 'http://tp5.test/uploads/images/20181213091435_956630.png', '123123', '1', '2018-12-13 17:14:39', null);

INSERT INTO `galleries` VALUES ('3', 'http://tp5.test/uploads/images/20181213091435_580301.png', '33333', '1', '2018-12-13 17:14:39', null);

INSERT INTO `galleries` VALUES ('25', 'http://tp5.test/uploads/images/20181214012742_155371.png', '66666', '1', '2018-12-14 09:27:45', null);

INSERT INTO `galleries` VALUES ('26', 'http://tp5.test/uploads/images/20181214012743_340720.jpg', null, '1', '2018-12-14 09:27:45', null);

INSERT INTO `galleries` VALUES ('27', 'http://tp5.test/uploads/images/20181214012743_377001.png', null, '1', '2018-12-14 09:27:45', null);

INSERT INTO `galleries` VALUES ('28', 'http://tp5.test/uploads/images/20181214012743_834784.png', null, '1', '2018-12-14 09:27:45', null);

INSERT INTO `galleries` VALUES ('29', 'http://tp5.test/uploads/images/20181217010337_678819.png', '1111', '2', '2018-12-17 09:03:39', null);

INSERT INTO `galleries` VALUES ('30', 'http://tp5.test/uploads/images/20181217010337_714825.jpg', '33333', '2', '2018-12-17 09:03:39', null);

INSERT INTO `galleries` VALUES ('31', 'http://tp5.test/uploads/images/20181217010337_622326.png', '687678', '2', '2018-12-17 09:03:39', null);

INSERT INTO `galleries` VALUES ('32', 'http://tp5.test/uploads/images/20181217010337_695367.png', '555', '2', '2018-12-17 09:03:39', null);

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

-- Table structure for orders

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

DROP TABLE IF EXISTS `orders`;

CREATE TABLE `orders` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`customer_id` int(11) DEFAULT NULL COMMENT '客资id',

`ordercode` varchar(255) DEFAULT NULL COMMENT '订单编号',

`is_order` tinyint(1) DEFAULT NULL COMMENT '是否有效1有0否',

`taocan` varchar(50) DEFAULT NULL COMMENT '套餐',

`order_mark` text COMMENT '订单说明',

`order_time` timestamp NULL DEFAULT NULL COMMENT '订单时间',

`zje` decimal(8,2) DEFAULT NULL COMMENT '总金额',

`pay_type` varchar(35) DEFAULT NULL COMMENT '支付方式',

`sfje` decimal(8,2) DEFAULT NULL COMMENT '实付金额',

`yk` decimal(8,2) DEFAULT NULL COMMENT '余款',

`qtje` decimal(8,2) DEFAULT NULL,

`hz_name` varchar(35) DEFAULT NULL COMMENT '化妆师',

`hz_time` timestamp NULL DEFAULT NULL COMMENT '跟妆日期',

`mark` text COMMENT '备注',

`create_at` timestamp NULL DEFAULT NULL,

`update_at` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

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

-- Records of orders

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

INSERT INTO `orders` VALUES ('1', '5', '1231', '1', '33333', '1231231231', '2018-12-21 16:08:14', '1111.00', '银行卡', '656.00', '566.00', null, '小倩', '2018-12-21 16:08:18', '678678', null, null);

INSERT INTO `orders` VALUES ('2', '3', null, '1', '33333', '1111我去恶趣味v', null, null, null, null, null, null, null, null, null, null, null);

INSERT INTO `orders` VALUES ('3', '1', null, '1', null, null, null, null, null, null, null, null, null, null, null, null, null);

INSERT INTO `orders` VALUES ('4', '6', null, '1', null, null, null, null, null, null, null, null, null, null, null, null, null);

INSERT INTO `orders` VALUES ('8', '10', null, null, '33333', null, null, '0.00', null, '0.00', '0.00', '0.00', null, null, null, '2018-12-24 13:16:31', null);

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

-- Table structure for order_logs

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

DROP TABLE IF EXISTS `order_logs`;

CREATE TABLE `order_logs` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`customer_id` int(11) DEFAULT NULL,

`name` varchar(35) DEFAULT NULL,

`log` varchar(255) DEFAULT NULL,

`create_at` timestamp NULL DEFAULT NULL,

`update_at` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='客资订单操作日志';

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

-- Records of order_logs

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

INSERT INTO `order_logs` VALUES ('1', '5', 'admin', 'admin更新客资5[套餐]为555555', '2018-12-22 15:04:18', null);

INSERT INTO `order_logs` VALUES ('2', '3', 'admin', 'admin更新客资3[是否订单]为否', '2018-12-22 15:07:13', null);

INSERT INTO `order_logs` VALUES ('3', '3', 'admin', 'admin更新客资3[订单说明]为1111我去恶趣味v', '2018-12-22 15:10:05', null);

INSERT INTO `order_logs` VALUES ('4', '5', 'admin', 'admin更新客资5[化妆师]为小倩', '2018-12-22 15:16:31', null);

INSERT INTO `order_logs` VALUES ('5', '5', 'admin', 'admin更新客资5[套餐]为33333', '2018-12-24 09:32:05', null);

INSERT INTO `order_logs` VALUES ('6', '5', 'admin', 'admin更新客资5[备注]为909090', '2018-12-24 09:33:12', null);

INSERT INTO `order_logs` VALUES ('7', '5', 'admin', 'admin更新客资5[支付方式]为银行卡', '2018-12-24 10:56:13', null);

INSERT INTO `order_logs` VALUES ('8', '5', 'admin', 'admin更新客资5[实付金额]为555', '2018-12-24 10:56:54', null);

INSERT INTO `order_logs` VALUES ('9', '5', 'admin', 'admin更新客资5[实付金额]为656', '2018-12-24 10:57:51', null);

INSERT INTO `order_logs` VALUES ('10', '5', 'admin', 'admin更新客资5[备注]为678678', '2018-12-24 10:59:08', null);

INSERT INTO `order_logs` VALUES ('11', '3', 'admin', 'admin更新客资3[是否订单]为是', '2018-12-24 12:55:41', null);

INSERT INTO `order_logs` VALUES ('12', '10', 'user1', 'user1更新客资10[套餐]为33333', '2018-12-25 17:12:01', null);

INSERT INTO `order_logs` VALUES ('13', '3', 'user1', 'user1更新客资3[套餐]为33333', '2018-12-26 10:28:33', null);

INSERT INTO `order_logs` VALUES ('14', '5', 'admin1', 'admin1更新客资5[余款]为[566]', '2018-12-27 13:06:20', null);

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

-- Table structure for permissions

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

DROP TABLE IF EXISTS `permissions`;

CREATE TABLE `permissions` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`parent_id` tinyint(11) unsigned DEFAULT '0',

`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,

`label` varchar(255) CHARACTER SET utf8mb4 NOT NULL,

`icon` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,

`sort_order` tinyint(2) DEFAULT '99',

`create_at` timestamp NULL DEFAULT NULL,

`update_at` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

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

-- Records of permissions

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

INSERT INTO `permissions` VALUES ('1', '0', '首页', '/admin/index/main', 'fa fa-home', '99', '2018-12-11 14:32:43', '2018-12-11 17:32:50');

INSERT INTO `permissions` VALUES ('2', '0', '内容管理', 'articles', 'fa fa-dashboard', '97', '2018-12-11 14:51:34', '2018-12-11 14:51:37');

INSERT INTO `permissions` VALUES ('3', '0', '系统设置', 'systems', 'fa fa-gears', '96', '2018-12-11 14:52:18', null);

INSERT INTO `permissions` VALUES ('4', '2', '文章列表', '/admin/articles/index', 'fa fa-columns', '99', '2018-12-11 16:55:47', null);

INSERT INTO `permissions` VALUES ('5', '4', '新增', '/admin/articles/create', null, '99', '2018-12-11 16:56:24', null);

INSERT INTO `permissions` VALUES ('6', '4', '保存', '/admin/articles/save', null, '99', '2018-12-11 16:56:57', null);

INSERT INTO `permissions` VALUES ('7', '4', '编辑', '/admin/articles/edit', null, '99', '2018-12-11 16:57:26', null);

INSERT INTO `permissions` VALUES ('8', '4', '更新', '/admin/articles/update', null, '99', '2018-12-11 16:58:19', null);

INSERT INTO `permissions` VALUES ('9', '4', '删除', '/admin/articles/delete', null, '99', '2018-12-11 16:59:06', null);

INSERT INTO `permissions` VALUES ('10', '4', '排序', '/admin/articles/sort', null, '99', '2018-12-11 16:59:49', null);

INSERT INTO `permissions` VALUES ('11', '4', '改变属性', '/admin/articles/change', null, '99', '2018-12-11 17:00:19', null);

INSERT INTO `permissions` VALUES ('12', '4', '多选删除', '/admin/articles/delete_all', null, '99', '2018-12-11 17:00:44', null);

INSERT INTO `permissions` VALUES ('13', '2', '文章分类', '/admin/categories/index', 'fa fa-th-list', '99', '2018-12-11 17:02:07', null);

INSERT INTO `permissions` VALUES ('14', '13', '新增', '/admin/categories/create', null, '99', '2018-12-11 17:02:34', null);

INSERT INTO `permissions` VALUES ('15', '13', '保存', '/admin/categories/save', null, '99', '2018-12-11 17:03:00', null);

INSERT INTO `permissions` VALUES ('16', '13', '编辑', '/admin/categories/edit', null, '99', '2018-12-11 17:03:24', null);

INSERT INTO `permissions` VALUES ('17', '13', '更新', '/admin/categories/update', null, '99', '2018-12-11 17:03:47', null);

INSERT INTO `permissions` VALUES ('18', '13', '删除', '/admin/categories/delete', null, '99', '2018-12-11 17:04:11', null);

INSERT INTO `permissions` VALUES ('19', '13', '排序', '/admin/categories/sort', null, '99', '2018-12-11 17:04:52', null);

INSERT INTO `permissions` VALUES ('20', '13', '多选删除', '/admin/categories/delete_all', null, '99', '2018-12-11 17:05:16', null);

INSERT INTO `permissions` VALUES ('21', '3', '用户列表', '/admin/admins/index', 'fa fa-users', '99', '2018-12-11 17:35:29', null);

INSERT INTO `permissions` VALUES ('22', '21', '新增', '/admin/admins/create', null, '99', '2018-12-11 17:35:57', null);

INSERT INTO `permissions` VALUES ('23', '21', '保存', '/admin/admins/save', null, '99', '2018-12-11 17:36:21', null);

INSERT INTO `permissions` VALUES ('24', '21', '编辑', '/admin/admins/edit', '', '99', '2018-12-15 13:43:18', null);

INSERT INTO `permissions` VALUES ('25', '21', '更新', '/admin/admins/update', '', '11', '2018-12-15 13:42:32', null);

INSERT INTO `permissions` VALUES ('26', '21', '删除', '/admin/admins/delete', null, '99', '2018-12-15 13:43:21', null);

INSERT INTO `permissions` VALUES ('27', '21', '改变属性', '/admin/admins/change', null, '99', '2018-12-15 13:43:59', null);

INSERT INTO `permissions` VALUES ('28', '21', '多选删除', '/admin/admins/delete_all', null, '99', '2018-12-15 13:44:35', null);

INSERT INTO `permissions` VALUES ('29', '3', '用户组', '/admin/roles/index', 'fa fa-vcard', '99', '2018-12-15 13:45:37', null);

INSERT INTO `permissions` VALUES ('30', '29', '新增', '/admin/roles/create', null, '99', '2018-12-15 13:46:07', null);

INSERT INTO `permissions` VALUES ('31', '29', '保存', '/admin/roles/save', null, '99', '2018-12-15 13:46:34', null);

INSERT INTO `permissions` VALUES ('32', '29', '编辑', '/admin/roles/edit', null, '99', '2018-12-15 13:46:53', null);

INSERT INTO `permissions` VALUES ('33', '29', '更新', '/admin/roles/update', null, '99', '2018-12-15 13:47:17', null);

INSERT INTO `permissions` VALUES ('34', '29', '删除', '/admin/roles/delete', null, '99', '2018-12-15 13:47:39', null);

INSERT INTO `permissions` VALUES ('35', '29', '改变属性', '/admin/roles/change', null, '99', '2018-12-15 13:48:10', null);

INSERT INTO `permissions` VALUES ('36', '29', '多选删除', '/admin/roles/delete_all', null, '99', '2018-12-15 13:48:32', null);

INSERT INTO `permissions` VALUES ('37', '3', '菜单权限', '/admin/permissions/index', 'fa fa-user-circle', '99', '2018-12-15 13:49:36', null);

INSERT INTO `permissions` VALUES ('38', '37', '新增', '/admin/permissions/create', null, '99', '2018-12-15 13:50:08', null);

INSERT INTO `permissions` VALUES ('39', '37', '保存', '/admin/permissions/save', null, '99', '2018-12-15 13:50:24', null);

INSERT INTO `permissions` VALUES ('40', '37', '编辑', '/admin/permissions/edit', null, '99', '2018-12-15 13:50:38', null);

INSERT INTO `permissions` VALUES ('41', '37', '更新', '/admin/permissions/update', null, '99', '2018-12-15 13:51:01', null);

INSERT INTO `permissions` VALUES ('42', '37', '删除', '/admin/permissions/delete', null, '99', '2018-12-15 13:51:32', null);

INSERT INTO `permissions` VALUES ('43', '37', '排序', '/admin/permissions/sort', null, '99', '2018-12-15 13:52:04', null);

INSERT INTO `permissions` VALUES ('44', '2', '相册管理', '/admin/galleries/index', 'fa fa-photo', '99', '2018-12-15 13:53:07', null);

INSERT INTO `permissions` VALUES ('45', '44', '新增', '/admin/galleries/create', null, '99', '2018-12-15 13:53:38', null);

INSERT INTO `permissions` VALUES ('46', '44', '保存', '/admin/galleries/save', null, '99', '2018-12-15 13:54:00', null);

INSERT INTO `permissions` VALUES ('47', '44', '编辑', '/admin/galleries/index', null, '99', '2018-12-15 13:54:11', null);

INSERT INTO `permissions` VALUES ('48', '44', '更新', '/admin/galleries/update', null, '99', '2018-12-15 13:54:29', null);

INSERT INTO `permissions` VALUES ('49', '44', '多选删除', '/admin/galleries/delete_all', null, '99', '2018-12-15 13:55:35', null);

INSERT INTO `permissions` VALUES ('50', '0', '客资管理', '/customers', 'fa fa-user-plus', '99', '2018-12-21 17:01:24', null);

INSERT INTO `permissions` VALUES ('51', '50', '客资列表', '/admin/customers/index', 'fa fa-user-plus', '99', '2018-12-21 17:03:02', null);

INSERT INTO `permissions` VALUES ('52', '51', '新增', '/admin/customers/create', null, '99', '2018-12-21 17:03:27', null);

INSERT INTO `permissions` VALUES ('53', '51', '保存', '/admin/customers/index', null, '99', '2018-12-21 17:03:43', null);

INSERT INTO `permissions` VALUES ('54', '51', '改变属性', '/admin/customers/change', null, '99', '2018-12-21 17:04:15', null);

INSERT INTO `permissions` VALUES ('55', '51', '更新客资', '/admin/customers/edit_customer', null, '99', '2018-12-21 17:04:51', null);

INSERT INTO `permissions` VALUES ('56', '51', '删除', '/admin/customers/delete_all', null, '99', '2018-12-21 17:05:27', null);

INSERT INTO `permissions` VALUES ('57', '51', '导出', '/admin/customers/export_customer', null, '98', '2018-12-21 17:06:42', null);

INSERT INTO `permissions` VALUES ('58', '50', '客资追踪', '/admin/tracks/index', 'fa fa-viacoin', '99', '2018-12-21 17:08:24', null);

INSERT INTO `permissions` VALUES ('59', '58', '改变属性', '/admin/tracks/change', null, '99', '2018-12-21 17:09:13', null);

INSERT INTO `permissions` VALUES ('60', '58', '更新信息', '/admin/tracks/edit_track', null, '99', '2018-12-21 17:09:46', null);

INSERT INTO `permissions` VALUES ('61', '58', '删除', '/admin/tracks/delete_all', null, '99', '2018-12-21 17:10:16', null);

INSERT INTO `permissions` VALUES ('62', '50', '客资订单', '/admin/orders/index', 'fa fa-cny', '99', '2018-12-21 17:11:16', null);

INSERT INTO `permissions` VALUES ('63', '62', '改变属性', '/admin/orders/change', null, '99', '2018-12-21 17:11:46', null);

INSERT INTO `permissions` VALUES ('64', '62', '更新订单', '/admin/orders/edit_order', null, '99', '2018-12-21 17:12:15', null);

INSERT INTO `permissions` VALUES ('65', '62', '删除', '/admin/orders/delete_all', null, '98', '2018-12-21 17:12:35', null);

INSERT INTO `permissions` VALUES ('66', '51', '查看日志', '/admin/customers/showLog', null, '99', '2018-12-24 10:40:40', null);

INSERT INTO `permissions` VALUES ('67', '58', '查看日志', '/admin/tracks/showLog', null, '99', '2018-12-24 10:42:46', null);

INSERT INTO `permissions` VALUES ('68', '58', '导出', '/admin/tracks/export_track', null, '99', '2018-12-24 10:43:24', null);

INSERT INTO `permissions` VALUES ('69', '62', '查看日志', '/admin/orders/showLog', null, '99', '2018-12-24 10:44:07', null);

INSERT INTO `permissions` VALUES ('70', '62', '导出', '/admin/orders/export_order', null, '99', '2018-12-24 10:44:34', null);

INSERT INTO `permissions` VALUES ('71', '4', '导出', '/admin/articles/export_article', null, '99', '2018-12-27 15:30:43', null);

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

-- Table structure for permission_role

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

DROP TABLE IF EXISTS `permission_role`;

CREATE TABLE `permission_role` (

`permission_id` int(8) DEFAULT NULL,

`role_id` int(8) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- Records of permission_role

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

INSERT INTO `permission_role` VALUES ('1', '2');

INSERT INTO `permission_role` VALUES ('2', '2');

INSERT INTO `permission_role` VALUES ('4', '2');

INSERT INTO `permission_role` VALUES ('5', '2');

INSERT INTO `permission_role` VALUES ('6', '2');

INSERT INTO `permission_role` VALUES ('7', '2');

INSERT INTO `permission_role` VALUES ('8', '2');

INSERT INTO `permission_role` VALUES ('11', '2');

INSERT INTO `permission_role` VALUES ('13', '2');

INSERT INTO `permission_role` VALUES ('14', '2');

INSERT INTO `permission_role` VALUES ('15', '2');

INSERT INTO `permission_role` VALUES ('16', '2');

INSERT INTO `permission_role` VALUES ('17', '2');

INSERT INTO `permission_role` VALUES ('1', '1');

INSERT INTO `permission_role` VALUES ('2', '1');

INSERT INTO `permission_role` VALUES ('4', '1');

INSERT INTO `permission_role` VALUES ('5', '1');

INSERT INTO `permission_role` VALUES ('6', '1');

INSERT INTO `permission_role` VALUES ('7', '1');

INSERT INTO `permission_role` VALUES ('8', '1');

INSERT INTO `permission_role` VALUES ('9', '1');

INSERT INTO `permission_role` VALUES ('10', '1');

INSERT INTO `permission_role` VALUES ('11', '1');

INSERT INTO `permission_role` VALUES ('12', '1');

INSERT INTO `permission_role` VALUES ('13', '1');

INSERT INTO `permission_role` VALUES ('14', '1');

INSERT INTO `permission_role` VALUES ('15', '1');

INSERT INTO `permission_role` VALUES ('16', '1');

INSERT INTO `permission_role` VALUES ('17', '1');

INSERT INTO `permission_role` VALUES ('18', '1');

INSERT INTO `permission_role` VALUES ('19', '1');

INSERT INTO `permission_role` VALUES ('20', '1');

INSERT INTO `permission_role` VALUES ('44', '1');

INSERT INTO `permission_role` VALUES ('45', '1');

INSERT INTO `permission_role` VALUES ('46', '1');

INSERT INTO `permission_role` VALUES ('47', '1');

INSERT INTO `permission_role` VALUES ('48', '1');

INSERT INTO `permission_role` VALUES ('49', '1');

INSERT INTO `permission_role` VALUES ('3', '1');

INSERT INTO `permission_role` VALUES ('21', '1');

INSERT INTO `permission_role` VALUES ('22', '1');

INSERT INTO `permission_role` VALUES ('23', '1');

INSERT INTO `permission_role` VALUES ('24', '1');

INSERT INTO `permission_role` VALUES ('1', '4');

INSERT INTO `permission_role` VALUES ('2', '4');

INSERT INTO `permission_role` VALUES ('4', '4');

INSERT INTO `permission_role` VALUES ('5', '4');

INSERT INTO `permission_role` VALUES ('6', '4');

INSERT INTO `permission_role` VALUES ('7', '4');

INSERT INTO `permission_role` VALUES ('8', '4');

INSERT INTO `permission_role` VALUES ('9', '4');

INSERT INTO `permission_role` VALUES ('10', '4');

INSERT INTO `permission_role` VALUES ('11', '4');

INSERT INTO `permission_role` VALUES ('12', '4');

INSERT INTO `permission_role` VALUES ('1', '3');

INSERT INTO `permission_role` VALUES ('2', '3');

INSERT INTO `permission_role` VALUES ('4', '3');

INSERT INTO `permission_role` VALUES ('5', '3');

INSERT INTO `permission_role` VALUES ('6', '3');

INSERT INTO `permission_role` VALUES ('13', '3');

INSERT INTO `permission_role` VALUES ('14', '3');

INSERT INTO `permission_role` VALUES ('1', '5');

INSERT INTO `permission_role` VALUES ('50', '5');

INSERT INTO `permission_role` VALUES ('51', '5');

INSERT INTO `permission_role` VALUES ('52', '5');

INSERT INTO `permission_role` VALUES ('53', '5');

INSERT INTO `permission_role` VALUES ('54', '5');

INSERT INTO `permission_role` VALUES ('55', '5');

INSERT INTO `permission_role` VALUES ('58', '5');

INSERT INTO `permission_role` VALUES ('59', '5');

INSERT INTO `permission_role` VALUES ('60', '5');

INSERT INTO `permission_role` VALUES ('62', '5');

INSERT INTO `permission_role` VALUES ('63', '5');

INSERT INTO `permission_role` VALUES ('64', '5');

INSERT INTO `permission_role` VALUES ('2', '5');

INSERT INTO `permission_role` VALUES ('4', '5');

INSERT INTO `permission_role` VALUES ('5', '5');

INSERT INTO `permission_role` VALUES ('6', '5');

INSERT INTO `permission_role` VALUES ('7', '5');

INSERT INTO `permission_role` VALUES ('8', '5');

INSERT INTO `permission_role` VALUES ('9', '5');

INSERT INTO `permission_role` VALUES ('10', '5');

INSERT INTO `permission_role` VALUES ('11', '5');

INSERT INTO `permission_role` VALUES ('12', '5');

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

-- Table structure for photos

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

DROP TABLE IF EXISTS `photos`;

CREATE TABLE `photos` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`image` varchar(255) DEFAULT NULL,

`create_at` timestamp NULL DEFAULT NULL,

`update_at` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4;

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

-- Records of photos

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

INSERT INTO `photos` VALUES ('24', 'http://tp5.test/uploads/20181208\\8abc6d1adb85d1d6f841c156dabb7688.png', '2018-12-08 17:28:10', '2018-12-08 17:28:10');

INSERT INTO `photos` VALUES ('25', 'http://tp5.test/uploads/20181217\\1cfcb2192e5ca917b8d758e2c5790d17.png', '2018-12-17 09:46:54', '2018-12-17 09:46:54');

INSERT INTO `photos` VALUES ('26', 'http://tp5.test/uploads/20181217\\5152334172a1df1d9e55de48c1a20487.png', '2018-12-17 11:02:55', '2018-12-17 11:02:55');

INSERT INTO `photos` VALUES ('27', 'http://tp5.test/uploads/20181217\\dae8ccc6e322e578d627dc6e7b8c05bd.png', '2018-12-17 11:04:04', '2018-12-17 11:04:04');

INSERT INTO `photos` VALUES ('28', 'http://tp5.test/uploads/20181217\\2ebdf7bbd624253db3678be194ba8d01.png', '2018-12-17 11:05:54', '2018-12-17 11:05:54');

INSERT INTO `photos` VALUES ('29', 'http://tp5.test/uploads/20181217\\ece170c9168eaba98024c4ecc1e8e156.png', '2018-12-17 11:06:43', '2018-12-17 11:06:43');

INSERT INTO `photos` VALUES ('30', 'http://tp5.test/uploads/20181217\\09b90d86dd31b01d92f332bc7c915ca7.png', '2018-12-17 11:11:32', '2018-12-17 11:11:32');

INSERT INTO `photos` VALUES ('31', 'http://tp5.test/uploads/20181217\\9d844ecdad1333d627f352d7ceeced8a.png', '2018-12-17 11:11:51', '2018-12-17 11:11:51');

INSERT INTO `photos` VALUES ('32', 'http://tp5.test/uploads/20181217\\d892f42a546e6d65177ee5cb91c42fbd.png', '2018-12-17 11:12:13', '2018-12-17 11:12:13');

INSERT INTO `photos` VALUES ('33', 'http://tp5.test/uploads/20181217\\b7a883af80f7ce2af0f62572a2973b04.png', '2018-12-17 11:13:05', '2018-12-17 11:13:05');

INSERT INTO `photos` VALUES ('34', 'http://tp5.test/uploads/20181217\\de269ef44d79bf4ed77c466ed9b90486.png', '2018-12-17 11:16:10', '2018-12-17 11:16:10');

INSERT INTO `photos` VALUES ('35', 'http://tp5.test/uploads/20181217\\8903af5476172b05dadd9aff7a0b3c20.png', '2018-12-17 13:14:12', '2018-12-17 13:14:12');

INSERT INTO `photos` VALUES ('36', 'http://tp5.test/uploads/20181217\\339595829544c521baeb8566ec8aee40.png', '2018-12-17 13:14:23', '2018-12-17 13:14:23');

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

-- Table structure for qudaos

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

DROP TABLE IF EXISTS `qudaos`;

CREATE TABLE `qudaos` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(30) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

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

-- Records of qudaos

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

INSERT INTO `qudaos` VALUES ('1', '婚礼纪');

INSERT INTO `qudaos` VALUES ('2', '大众');

INSERT INTO `qudaos` VALUES ('3', '果石');

INSERT INTO `qudaos` VALUES ('4', '璞拾');

INSERT INTO `qudaos` VALUES ('5', '转介绍');

INSERT INTO `qudaos` VALUES ('6', '婚博会');

INSERT INTO `qudaos` VALUES ('7', '微信');

INSERT INTO `qudaos` VALUES ('8', '微博');

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

-- Table structure for roles

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

DROP TABLE IF EXISTS `roles`;

CREATE TABLE `roles` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(30) NOT NULL COMMENT '用户组名',

`description` text COMMENT '权限描述',

`status` tinyint(1) DEFAULT '1' COMMENT '状态',

`create_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',

`update_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

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

-- Records of roles

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

INSERT INTO `roles` VALUES ('1', '超级管理员', '所有权限', '1', '2018-12-11 09:50:13', '2018-12-15 17:09:17');

INSERT INTO `roles` VALUES ('2', '店长', '仅此于管理员的权限', '1', '2018-12-10 14:15:11', '2018-12-15 16:35:01');

INSERT INTO `roles` VALUES ('3', '网销主管', '一般权限', '0', '2018-12-10 17:06:36', '2018-12-24 11:54:31');

INSERT INTO `roles` VALUES ('4', '客服', '一般权限', '1', '2018-12-17 10:03:09', '2018-12-18 15:12:53');

INSERT INTO `roles` VALUES ('5', 'A1', '一般权限', '1', '2018-12-18 15:13:08', '2018-12-25 17:10:10');

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

-- Table structure for role_admin

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

DROP TABLE IF EXISTS `role_admin`;

CREATE TABLE `role_admin` (

`admin_id` int(11) DEFAULT NULL,

`role_id` int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

-- Records of role_admin

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

INSERT INTO `role_admin` VALUES ('1', '1');

INSERT INTO `role_admin` VALUES ('3', '5');

INSERT INTO `role_admin` VALUES ('2', '5');

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

-- Table structure for tracks

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

DROP TABLE IF EXISTS `tracks`;

CREATE TABLE `tracks` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`customer_id` int(11) DEFAULT NULL COMMENT '客资ID',

`first_time` timestamp NULL DEFAULT NULL COMMENT '第一次追踪时间',

`first_detail` text COMMENT '一次追踪详情',

`second_time` timestamp NULL DEFAULT NULL COMMENT '二次追踪时间',

`second_detail` text COMMENT '二次追踪详情',

`detail` text,

`menshi` varchar(35) DEFAULT NULL COMMENT '门市',

`fuwu` varchar(35) DEFAULT NULL COMMENT '客服顾问',

`in_date` timestamp NULL DEFAULT NULL COMMENT '预计进店日期',

`is_come` tinyint(1) DEFAULT NULL COMMENT '是否进店1是0否',

`come_date` timestamp NULL DEFAULT NULL,

`lifu` varchar(35) DEFAULT NULL COMMENT '礼服师',

`huazhuang` varchar(35) DEFAULT NULL COMMENT '化妆师',

`first_mark` text COMMENT '一次备注',

`lifu1` varchar(35) DEFAULT NULL COMMENT '二次礼服师',

`huazhuang1` varchar(35) DEFAULT NULL COMMENT '二次化妆师',

`second_mark` text COMMENT '二次备注',

`again_date` timestamp NULL DEFAULT NULL,

`create_at` timestamp NULL DEFAULT NULL,

`update_at` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

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

-- Records of tracks

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

INSERT INTO `tracks` VALUES ('1', '3', '2018-12-21 17:02:34', 'qqqqqqqqqqqqqqq', '2018-12-21 00:00:00', 'wwwwwwwwwwww11111', 'eeeeeeeeeeeee', '张蔷', '小倩', '2018-12-19 14:08:46', '0', '2018-12-22 17:59:31', '张蔷', '小倩', 'rrrrrrrrrrrrrrrr', '奚晶', '任瑞恒', 'tttttttttttttttttt', '2018-12-19 17:27:10', '2018-12-19 14:33:24', null);

INSERT INTO `tracks` VALUES ('2', '5', '2018-12-27 00:00:00', '999999999', null, 'qweqweqwe', '8888888888888', '宋晶晶', '任瑞恒', '2018-12-26 10:34:10', '1', '2018-12-21 14:05:59', null, '诗敏', '123123123', null, null, null, '2018-12-21 13:10:45', null, null);

INSERT INTO `tracks` VALUES ('3', '1', '2018-12-22 14:51:31', null, '2018-12-22 14:52:35', null, null, '京京', '小倩', '2018-12-25 00:00:00', '0', null, null, null, null, null, null, null, null, null, null);

INSERT INTO `tracks` VALUES ('4', '6', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

INSERT INTO `tracks` VALUES ('8', '10', null, null, null, null, null, '陈梦', null, null, null, null, null, null, null, null, null, null, null, '2018-12-24 13:16:31', null);

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

-- Table structure for track_logs

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

DROP TABLE IF EXISTS `track_logs`;

CREATE TABLE `track_logs` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`customer_id` int(11) DEFAULT NULL,

`name` varchar(35) DEFAULT NULL,

`log` varchar(255) DEFAULT NULL,

`create_at` timestamp NULL DEFAULT NULL,

`update_at` timestamp NULL DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COMMENT='客资追踪操作记录';

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

-- Records of track_logs

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

INSERT INTO `track_logs` VALUES ('13', '3', 'admin', 'admin更新客资3[是否进店]为否', '2018-12-22 14:37:57', null);

INSERT INTO `track_logs` VALUES ('14', '3', 'admin', 'admin更新客资3[是否进店]为是', '2018-12-22 14:38:04', null);

INSERT INTO `track_logs` VALUES ('15', '1', 'admin', 'admin更新客资1[一次追踪时间]为2018-12-22 00:00:00', '2018-12-22 14:40:42', null);

INSERT INTO `track_logs` VALUES ('16', '1', 'admin', 'admin更新客资1[一次追踪时间]为2018-12-22 14:51:31', '2018-12-22 14:51:32', null);

INSERT INTO `track_logs` VALUES ('17', '1', 'admin', 'admin更新客资1[二次追踪时间]为2018-12-22 14:52:35', '2018-12-22 14:52:36', null);

INSERT INTO `track_logs` VALUES ('18', '3', 'admin', 'admin更新客资3[门市]为修亿', '2018-12-22 15:15:17', null);

INSERT INTO `track_logs` VALUES ('19', '3', 'admin', 'admin更新客资3[客服顾问]为小倩', '2018-12-22 15:15:20', null);

INSERT INTO `track_logs` VALUES ('20', '3', 'admin', 'admin更新客资3[礼服师1]为张蔷', '2018-12-22 15:15:25', null);

INSERT INTO `track_logs` VALUES ('21', '3', 'admin', 'admin更新客资3[化妆师1]为小倩', '2018-12-22 15:15:31', null);

INSERT INTO `track_logs` VALUES ('22', '5', 'admin', 'admin更新客资5[化妆师1]为诗敏', '2018-12-22 15:15:36', null);

INSERT INTO `track_logs` VALUES ('23', '3', 'admin', 'admin更新客资3[礼服师2]为奚晶', '2018-12-22 15:15:41', null);

INSERT INTO `track_logs` VALUES ('24', '3', 'admin', 'admin更新客资3[化妆师2]为任瑞恒', '2018-12-22 15:15:45', null);

INSERT INTO `track_logs` VALUES ('25', '3', 'admin', 'admin更新客资3[进店时间]为2018-12-22 17:59:31', '2018-12-22 17:59:32', null);

INSERT INTO `track_logs` VALUES ('26', '10', 'user1', 'user1更新客资10[门市]为宋晶晶', '2018-12-25 17:14:16', null);

INSERT INTO `track_logs` VALUES ('27', '10', 'user1', 'user1更新客资10[门市]为张蔷', '2018-12-25 17:15:39', null);

INSERT INTO `track_logs` VALUES ('28', '10', 'user1', 'user1更新客资10[门市]为修亿', '2018-12-25 17:16:12', null);

INSERT INTO `track_logs` VALUES ('89', '1', 'user1', 'user1更新客资1[门市]为张蔷', '2018-12-26 10:03:11', null);

INSERT INTO `track_logs` VALUES ('90', '5', 'user1', 'user1更新客资5[门市]为尹燕燕', '2018-12-26 10:03:30', null);

INSERT INTO `track_logs` VALUES ('91', '3', 'user1', 'user1更新客资3[门市]为陈梦', '2018-12-26 10:03:36', null);

INSERT INTO `track_logs` VALUES ('92', '5', 'user1', 'user1更新客资5[门市]为陈梦', '2018-12-26 10:13:59', null);

INSERT INTO `track_logs` VALUES ('93', '5', 'user1', 'user1更新客资5[门市]为宋晶晶', '2018-12-26 10:14:04', null);

INSERT INTO `track_logs` VALUES ('94', '1', 'user1', 'user1更新客资1[门市]为尹燕燕', '2018-12-26 10:14:09', null);

INSERT INTO `track_logs` VALUES ('95', '3', 'user1', 'user1更新客资3[门市]为奚晶', '2018-12-26 10:14:13', null);

INSERT INTO `track_logs` VALUES ('96', '5', 'user1', 'user1更新客资5[门市]为京京', '2018-12-26 10:18:43', null);

INSERT INTO `track_logs` VALUES ('97', '1', 'user1', 'user1更新客资1[门市]为张蔷', '2018-12-26 10:19:45', null);

INSERT INTO `track_logs` VALUES ('98', '1', 'user1', 'user1更新客资1[门市]为陈梦', '2018-12-26 10:21:54', null);

INSERT INTO `track_logs` VALUES ('99', '1', 'user1', 'user1更新客资1[门市]为尹燕燕', '2018-12-26 10:22:27', null);

INSERT INTO `track_logs` VALUES ('100', '5', 'admin', 'admin更新客资5[门市]为宋晶晶', '2018-12-26 10:23:05', null);

INSERT INTO `track_logs` VALUES ('101', '1', 'admin', 'admin更新客资1[门市]为张蔷', '2018-12-26 10:23:09', null);

INSERT INTO `track_logs` VALUES ('102', '3', 'user1', 'user1更新客资3[二次追踪详情]为wwwwwwwwwwww11111', '2018-12-26 10:32:02', null);

INSERT INTO `track_logs` VALUES ('103', '5', 'admin1', 'admin1更新客资5[门市]为尹燕燕', '2018-12-26 10:33:51', null);

INSERT INTO `track_logs` VALUES ('104', '5', 'admin1', 'admin1更新客资5[预计进店日期]为2018-12-26 10:34:10', '2018-12-26 10:34:12', null);

INSERT INTO `track_logs` VALUES ('105', '1', 'admin1', 'admin1更新客资1[门市]为张蔷', '2018-12-26 10:36:44', null);

INSERT INTO `track_logs` VALUES ('106', '1', 'admin1', 'admin1更新客资1[门市]为尹燕燕', '2018-12-26 10:36:47', null);

INSERT INTO `track_logs` VALUES ('107', '3', 'user1', 'user1更新客资3[门市]为张蔷', '2018-12-26 10:41:03', null);

INSERT INTO `track_logs` VALUES ('108', '1', 'user1', 'user1更新客资1[门市]为京京', '2018-12-26 10:41:08', null);

INSERT INTO `track_logs` VALUES ('109', '1', 'admin', 'admin更新客资1[预计进店日期]为2018-12-26 00:00:00', '2018-12-26 14:48:47', null);

INSERT INTO `track_logs` VALUES ('110', '1', 'admin', 'admin更新客资1[预计进店日期]为2018-12-25 00:00:00', '2018-12-26 15:16:00', null);

INSERT INTO `track_logs` VALUES ('111', '5', 'admin1', 'admin1更新客资5[门市]为宋晶晶', '2018-12-27 10:26:45', null);

SET FOREIGN_KEY_CHECKS=1;

一键复制

编辑

Web IDE

原始数据

按行查看

历史

AU茄子
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
thinkphp - 超详细导入 / 导出 Excel 表格文件功能，导入与导出 *.xls 文件详细示例（也有前端 html 源码，附带完整源码及注意事项，完美搞定开箱即用！）
高级前端工程师
05-06 3439
thinkphp 导出导入excel，tp如何实现导入导出excel功能，php怎么做导入导出offce excel 表格，tp使用PHPExcel导出excel数据表完整代码，Thinkphp导入导出excel表格，thinkphp实现Excel的xls、csv文件的导入导出功能，tp对excel表格进行导入导出的操作，tp详细导入导出excel文章教程，Thinkphp phpexcel导出导入表格，ThinkPHP6 excel 导出导入功能完整实现，thinkphp6导入Excel表格，thinkp
Python常用组件、命令大总结(持续更新)
LDC，公众号【轻松学编程】
03-12 1万+
Python后端开发常用组件、命令（干货） 持续更新中… 1、生成6位数字随机验证码 import random import string def num_code(length=6): """ 生成长度为length的数字随机验证码 :param length: 验证码长度 :return: 验证码 """ return ''.jo.....................
tp5连接mysql数据库_TP5的链接数据库
weixin_39747595的博客
01-21 520
静态配置在config文件夹下创建database.php配置文件，把原始的database.php文件中的内容复制进来，以下没用到的内容不全写了：return [//数据库类型'type' => 'mysql',//服务器地址'hostname' => '127.0.0.1',//数据库名'database' => 'tp5',//用户名'username' => 'ro...
TCP Ports list (3498 ports in list)
热门推荐
zyb378747350的专栏
01-11 43万+
参考地址:https://www.gasmi.net/tcp.php TCP Ports list (3498 ports in list) 1 tcpmux TCP Port Service Multiplexer 2 compressnet Management Utility 3 compressnet Compression Process
（HTML5）第一章
u010619243的博客
03-29 1788
《HTML5秘籍》 一、HTML5语法的变化 HTML5验证器可以保证遵循HTML5标准的这一部分；帮你抓住那些与HTML5标准不相符的标记。 ·lang的作用 指明网页中使用的自然语言。这个信息有时候对他人有用，比如搜索引擎可以通过它来筛选搜索结果，确保只向搜索者返回页面语言与他使用的语言相同的页面。 ·rel标签这是w3c的标准 rel: 属性用于定义连接的文件
vue pc端打印二维码
jingruoannan的博客
07-12 39万+
import Vue from "vue"; let a = "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAeAAAAKoCAYAAACvNywJAAAABHNCSVQICAgIfAhkiAAAIABJREFUeF7svQmcZVdV73+6q7tr6Bq6q+fupDN15lETZEgkiIkSME4BgYeAQp78ow/Rv/8HweERnnwk8p5/RP+apwQUkI9IiCI8jRoQ0BDgETAkIWNn6KTn6qGqurrmqv6v7.
http://coffeejp.com/bbs/forum.php?mod=viewthread,问题列表_华泰证券网络路演_新浪网
weixin_33481022的博客
06-07 10万+
游客问：http://keralaartsandcrafts.com/profession.php http://www.coffeecatscoffee.com/personal.php http://www.condorgun.com/pocket.php http://www.clinton-family-dentistry.com/relations.php http://nyvd...
ThinkPHP6.0以上兼容mysql下JSON_CONTAINS使用
12-08
本篇将详细探讨在ThinkPHP6.0及以上版本中，如何有效地利用MySQL的`JSON_CONTAINS`函数处理JSON类型的数据。 一、MySQL的JSON类型与JSON_CONTAINS函数 MySQL自5.7版本开始引入了对JSON数据类型的原生支持，这使得...
thinkphp5支持mysql8吗_thinkphp5支持oracle吗
weixin_42121086的博客
01-26 734
首先，我们知道php是完全支持oracle的，那么作为php框架的thinkphp5也是完全可以支持oracle的。thinkphp5如何连接oracle？数据库：ray表的结构：ray_userCREATE TABLE IF NOT EXISTS ray_user (user_id int(11) unsigned NOT NULL AUTO_INCREMENT,user_name varcha...
thinkphp悲观锁机制处理高并发
阿猫的和谐号高铁
07-03 3883
文章目录问题分析PS解决思路悲观锁介绍排他锁行锁和表锁实验thinkphp5.0实现坑点参考 问题分析 突然间被运营滴滴说某个活动的报名人数超过了限制人数，问怎么回事，我一下子还挺蒙的，我明明有在报名的操作之前设置了检查如果超过报名人数代码逻辑会抛错继续报名的呀。 然后我又打开数据库看了一下，出现了以下的情况： 于是情况就很明了了，这明显就是并发控制没有做好。为了叙述清楚这个情况，下面讲述一下业务逻辑：首先是从meeting表查是否报名已满，如果未满，则开始事务，将signed字段自增1，然后把参会记录
http://www.houdeblog.com/fakeoakleys/ 55555
ciw8992的博客
07-16 2万+
Designers these days are styling gold wedding shoes with creativity Additionally, it absolutely was paramount to...
www.51.com
just_0专栏 水一样的男子！
01-16 1万+
我的邮箱：hanen_0@51.com
Exploit writing tutorial part 6 : Bypassing Stack Cookies, SafeSeh, SEHOP, HW DEP and ASLR
I'm a hack----
11-01 1万+
In all previous tutorials in this Exploit writing tutorial series, we have looked at building exploits that would work on Windows XP / 2003 server. The success of all of these exploits (whether they
【Linux】 grep命令
qq_42320804的博客
08-17 1736
基础详解 https://www.runoob.com/linux/linux-comm-grep.html
Android Platform 3.0 SDK和Eclipse ADT安装记录（最初版本，纪念用）
weimingtom的待宵草
02-25 455
（注意：此文非常非常地过时，只是用于个人回想。请参看《二》以后的笔记） （20110926：注意！此文由于结构过于混乱且内容过时，将会被删除，用新的学习日记取代——如果我有时间的话）   注：我只是为了学习简单的Android编程和模拟， 所以没有考虑SDK和设备的版本兼容问题。 下面以Android Platform 3.0 API Level 11为例 旧版本的Android P...
SeSe 2005-02-11 -- 2005-02-12
星☆空 | 对生活要知足,学习要不知足,为人处事要知不足. 卍 ♂ | ♀ 卐 - 科技以人为本.
02-12 8034
绿色学院 - Green Institute - 不听人间乐 - 想得到 - 做得到 - Xoops2005-02-11 23:40:08 /:|Ｄ.Ｎ.Ａ 可以用yahoo邮箱申请MSN 2005-02-11 23:40:10 /:|Ｄ.Ｎ.Ａ 哈哈 2005-02-11 23:40:10 十愛。by顔
Tp5.1--远程连接mysql8.0
红尘炼炼心的博客
12-01 1776
宝塔环境下Tp5.1远程连接mysql8.0，开通安全组(平台及服务器环境)3306端口,允许外部访问(可设置IP做限制)，mysql创建授权外部连接的账号密码。
http://wp.qq.com/index.html,登录页
weixin_39754603的博客
07-02 1万+
1Tj@HOKWyW28&TMmb(}Xf=-OJiNeTZg9K?yE)!>%f*oxqaOEW9&jFA_LtDl6zX(wJXf+lC*nHKnU2Txt1ISzG1B3mhYAL90*e;9DBh8eGt>u7b3F-&r%Yl1gg+|zF=z17(y@orIY({oMVl{Z?4poAIzYwKWb7g9DGA;#925Nad8C(HT-TTrF0o...
JS中URL编码参数(UrlEncode)
weixin_34383618的博客
07-10 4085
网上有很多文字作品写涉及在JS中呈现类似UrlEncode功能时都是自定义参数来呈现，其实JS中本身就有那样的参数。参数parameter由于用类似URL的形式传过去 ， 所以别直接就那样赋值以下是对变量值的URL编码总结 ： 意见用encodeURIComponent() ， GET 和POST方法都能够发送过去Java编程script中存在几种对URL字符串停止编码的窍门：escape()，e...
#!/bin/sh #安装插件 cd /root/mysql if test -e ./sharutils-4.6.1-2.x86_64.rpm then echo 'sharutils开始安装...' rpm -ivh sharutils-4.6.1-2.x86_64.rpm echo 'sharutils安装完成...' else echo 'sharutils文件不存在!' exit fi #安装msql8 if test -e ./mysql8.0.19_64-636.sh then if test -e ./mysql8.0.19_64-636.sh.sha256 then echo '准备安装mysql8' sh ./mysql8.0.19_64-636.sh else echo 'mysql8.sha256文件不存在!' exit fi else echo 'mysql8.sh文件不存在!' exit fi if [ $? -eq 0 ]; then echo 'mysql安装完成...' else echo 'mysql安装失败!' exit fi #执行重启不需验证 /topwalk/baseapp/bin/mysqld restart --skip_grant_tables #安装tcl sh ./tcl-install.sh if [ $? -eq 0 ]; then echo 'tcl安装完成...' else echo 'tcl安装失败!' exit fi #安装expect sh ./expect-install.sh if [ $? -eq 0 ]; then echo 'expect安装完成...' else echo 'expect安装失败!' exit fi #创建mysql用户,授权 sh ./initdb.sh if [ $? -eq 0 ]; then echo 'mysql用户创建,授权完成...' else echo 'mysql用户创建,授权失败!' exit fi ln -s /topwalk/baseapp/bin/mysqld /etc/init.d/ sed -i '/MYSQL_HOME/d' /etc/profile echo "export MYSQL_HOME=/topwalk/baseapp/mysql" >>/etc/profile echo 'export PATH=$PATH:$MYSQL_HOME/bin' >>/etc/profile systemctl enable mysqld source /etc/profile service mysqld restart #初始化库 /topwalk/baseapp/mysql/bin/mysql -udms -ptRstOpwalkroot0823 < topsql/CREATE_TOPBASIC.sql /topwalk/baseapp/mysql/bin/mysql -udms -ptRstOpwalkroot0823 < topsql/CREATE_TOPDMS.sql /topwalk/baseapp/mysql/bin/mysql -udms -ptRstOpwalkroot0823 < topsql/CREATE_TOPUIS.sql #初始化表 /topwalk/baseapp/mysql/bin/mysql -udms -ptRstOpwalkroot0823 TOPBASIC < topsql/TOPBASIC.sql /topwalk/baseapp/mysql/bin/mysql -udms -ptRstOpwalkroot0823 TOPDMS < topsql/TOPDMS.sql /topwalk/baseapp/mysql/bin/mysql -udms -ptRstOpwalkroot0823 TOPUIS < topsql/TOPUIS.sql #安装nginx cp -dpRf ./nginx /usr/local/ useradd nginx -m -d /usr/local/nginx/ -s /bin/bash chown -R nginx.nginx /usr/local/ngi
最新发布
07-14
接下来，脚本会检查是否存在 `mysql8.0.19_64-636.sh` 文件和 `mysql8.0.19_64-636.sh.sha256` 文件。如果两个文件都存在，则执行 `mysql8.0.19_64-636.sh` 安装 MySQL 8。 安装 MySQL 之后，脚本会执行 `/topwalk/...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值