/* Navicat Premium Data Transfer Source Server : kaohe Source Server Type : MySQL Source Server Version : 50725 Source Host : localhost:6688 Source Schema : writeback Target Server Type : MySQL Target Server Version : 50725 File Encoding : 65001 Date: 12/06/2020 16:41:46 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for log -- ---------------------------- DROP TABLE IF EXISTS `log`; CREATE TABLE `log` ( `reportid` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL, `username` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, `logdate` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of log -- ---------------------------- INSERT INTO `log` VALUES ('I8a8a962a017291799179095a01729189de54007f', 'admin', '2020-06-08', 1); INSERT INTO `log` VALUES ('I8a8a962a017291799179095a01729189de54007f', 'admin', '2020-06-08', 2); INSERT INTO `log` VALUES ('I8a8a962a017291799179095a017293328210285e', 'admin', '2020-06-08', 3); -- ---------------------------- -- Table structure for product -- ---------------------------- DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL, `type` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, `price` double(10, 2) NULL DEFAULT NULL, `stock` int(255) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of product -- ---------------------------- INSERT INTO `product` VALUES (1, '香蕉', '水果', 3.60, 954); INSERT INTO `product` VALUES (2, '核桃酥', '甜点', 3.20, 2341); INSERT INTO `product` VALUES (3, '苹果', '水果', 8.80, 1342); INSERT INTO `product` VALUES (4, '甜甜圈', '甜点', 5.90, 13543); INSERT INTO `product` VALUES (5, '洗衣粉', '日用品', 18.10, 3234); INSERT INTO `product` VALUES (6, '沐浴露', '日用品', 20.90, 972); INSERT INTO `product` VALUES (7, '蛋糕', '甜点', 60.90, 23); -- ---------------------------- -- Table structure for product_2 -- ---------------------------- DROP TABLE IF EXISTS `product_2`; CREATE TABLE `product_2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL, `type` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, `price` double(10, 2) NULL DEFAULT NULL, `stock` int(255) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of product_2 -- ---------------------------- INSERT INTO `product_2` VALUES (1, '香蕉', '水果', 3.60, 954); INSERT INTO `product_2` VALUES (2, '核桃酥', '甜点', 3.20, 2341); INSERT INTO `product_2` VALUES (3, '苹果', '水果', 8.80, 1342); INSERT INTO `product_2` VALUES (4, '甜甜圈', '甜点', 5.90, 13543); INSERT INTO `product_2` VALUES (5, '洗衣粉', '日用品', 18.10, 3234); INSERT INTO `product_2` VALUES (6, '沐浴露', '日用品', 20.90, 972); INSERT INTO `product_2` VALUES (7, '蛋糕', '甜点', 60.90, 23); INSERT INTO `product_2` VALUES (8, '4', NULL, 4.00, 4); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `联系人` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, `性别` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, `省份` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, `城市` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, `联系方式` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (1, '王先生', '男', '广东', '深圳', 'wang@163.com'); INSERT INTO `user` VALUES (2, '邹女士', '女', '湖南', '衡阳', 'zou@163.com'); INSERT INTO `user` VALUES (3, '张女士', '女', '湖北', '武汉', 'zhang@163.com'); INSERT INTO `user` VALUES (4, '汪先生', '男', '香港', '香港', 'wang@163.com'); INSERT INTO `user` VALUES (5, '西小姐', '女', '广东', '广州', 'xixi@163.com'); INSERT INTO `user` VALUES (6, '赵先生', '男', '湖南', '长沙', 'zhao@163.com'); INSERT INTO `user` VALUES (7, '美女士', '女', '陕西', '西安', 'mm@163.com'); INSERT INTO `user` VALUES (8, '李先生', '男', '湖南', '张家界', 'lili@163.com'); SET FOREIGN_KEY_CHECKS = 1;