DB_51Aspx/crm_system.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : localhost:3306
 Source Schema         : crm_system

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 14/07/2022 10:38:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for customer_order
-- ----------------------------
DROP TABLE IF EXISTS `customer_order`;
CREATE TABLE `customer_order`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `cus_id` int(11) NOT NULL COMMENT '客户id',
  `order_no` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单号',
  `order_date` datetime(0) NULL DEFAULT NULL COMMENT '订单时间',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地点',
  `state` int(11) NULL DEFAULT NULL COMMENT '状态（1=已支付，0=未支付）',
  `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货物名称',
  `goods_num` int(11) NULL DEFAULT NULL COMMENT '货物数量',
  `price` double(10, 2) NULL DEFAULT NULL COMMENT '价格',
  `sum` double(10, 2) NULL DEFAULT NULL COMMENT '总价',
  `is_valid` int(11) NULL DEFAULT 1,
  `create_date` datetime(0) NULL DEFAULT NULL,
  `update_date` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of customer_order
-- ----------------------------
INSERT INTO `customer_order` VALUES (1, 1, '001', '2019-07-24 00:00:00', '北京', 1, '电脑', 2, 5000.00, 10000.00, 1, '2021-04-24 18:41:56', '2021-04-25 10:06:45');
INSERT INTO `customer_order` VALUES (2, 1, '002', '2019-06-03 00:00:00', '北京市朝阳区中山路85号', 1, '小米手机', 3, 300.00, 900.00, 1, '2021-04-24 20:50:48', '2021-04-25 10:06:53');
INSERT INTO `customer_order` VALUES (3, 1, '003', '2020-01-03 00:00:00', '北京市朝阳区中山路185号', 1, '小米手机', 4, 300.00, 1200.00, 1, '2021-04-24 20:50:57', '2021-04-25 10:07:00');
INSERT INTO `customer_order` VALUES (4, 2, '004', '2020-01-03 00:00:00', '北京市朝阳区中山路185号', 1, '小米手机', 3, 300.00, 900.00, 1, '2021-04-24 20:51:05', '2021-04-25 11:28:29');
INSERT INTO `customer_order` VALUES (5, 3, '006', '2021-02-03 00:00:00', '上海北路333号', 1, '小米手机', 3, 300.00, 900.00, 1, '2021-04-24 20:51:07', '2021-04-24 20:51:09');
INSERT INTO `customer_order` VALUES (6, 2, '007', '2020-01-12 00:00:00', '北京', 0, '笔记本电脑', 12, 9500.00, 114000.00, 1, '2021-04-24 20:51:15', '2021-04-25 11:28:39');
INSERT INTO `customer_order` VALUES (7, 1, '008', '2020-01-01 00:00:00', '北京市朝阳区中山路185号', 1, '华为手机', 20, 6000.00, 120000.00, 1, '2021-04-24 20:50:30', '2021-04-25 10:07:23');
INSERT INTO `customer_order` VALUES (8, 3, '010', '2021-02-03 00:00:00', '北京市朝阳区中山路85号', 0, '小米手机', 3, 300.00, 900.00, 1, '2021-04-24 20:51:45', '2021-04-24 20:51:45');
INSERT INTO `customer_order` VALUES (9, 4, '011', '2021-03-12 00:00:00', '北京市朝阳区中山路85号', 1, '笔记本电脑', 100, 6000.00, 600000.00, 1, '2021-04-26 15:11:48', '2021-04-26 15:11:48');
INSERT INTO `customer_order` VALUES (10, 3, '4261519', '2021-04-26 00:00:00', '上海北路333号', 1, '相机', 100, 6000.00, 600000.00, 1, '2021-04-26 15:20:13', '2021-04-26 15:20:13');
INSERT INTO `customer_order` VALUES (11, 5, '4261922', '2021-04-26 00:00:00', '浙江宁波', 1, '耳机', 50, 30.00, 1500.00, 1, '2021-04-26 19:22:50', '2021-04-26 19:22:50');
INSERT INTO `customer_order` VALUES (12, 5, '4261923', '2021-04-26 00:00:00', '浙江宁波', 0, '手表', 100, 100.00, 10000.00, 1, '2021-04-26 19:23:23', '2021-04-26 19:23:23');
INSERT INTO `customer_order` VALUES (13, 9, '10001', '2022-07-13 00:00:00', '南京大行宫', 0, '货物名称', 11, 1.00, 11.00, 1, '2022-07-13 17:42:07', '2022-07-13 17:42:07');
INSERT INTO `customer_order` VALUES (14, 11, '10002', '2022-07-13 00:00:00', '南京大行宫', 1, '货物名称', 11, 1.00, 11.00, 1, '2022-07-13 17:56:02', '2022-07-13 17:56:02');
INSERT INTO `customer_order` VALUES (15, 12, '10003', '2022-07-14 00:00:00', '南京大行宫', 0, '货物名称', 11, 1.00, 11.00, 1, '2022-07-14 10:05:01', '2022-07-14 10:05:01');

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