DB_51Aspx/shop.sql

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

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

/*
Navicat MySQL Data Transfer

Source Server         : 本机
Source Server Version : 50617
Source Host           : localhost:3306
Source Database       : shop

Target Server Type    : MYSQL
Target Server Version : 50617
File Encoding         : 65001

Date: 2024-02-19 21:10:50
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `tb_activity`
-- ----------------------------
DROP TABLE IF EXISTS `tb_activity`;
CREATE TABLE `tb_activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `remark` text,
  `start_time` date DEFAULT NULL,
  `end_time` date DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `act_type` int(11) DEFAULT '1' COMMENT '1=专场活动 2=日常活动',
  `gift_pkg_ids` varchar(255) DEFAULT NULL COMMENT '礼包',
  `create_time` datetime DEFAULT NULL,
  `idx` int(11) DEFAULT '0' COMMENT '排序值',
  `check_type` int(11) DEFAULT '1' COMMENT '1=后验券 2=先验券',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of tb_activity
-- ----------------------------
INSERT INTO `tb_activity` VALUES ('1', '测试活动', '测试活动', '2023-11-01', '2023-11-30', 'https://iwantit.oss-cn-hangzhou.aliyuncs.com/20231122/655d9d3cf3bd1.png', '-1', '1', '6,5,4,3', '2023-11-10 21:55:48', '0', '1');
INSERT INTO `tb_activity` VALUES ('2', '其他年货专场', '其他年货专场', '2023-11-15', '2023-12-31', 'https://iwantit.oss-cn-hangzhou.aliyuncs.com/20231122/655de9b8b3c52.png', '0', '2', '', '2023-11-15 21:59:59', '90', '1');
INSERT INTO `tb_activity` VALUES ('3', '杭州市儿童医院专场', '杭州市儿童医院春节福利专场', '2023-11-15', '2024-01-17', 'https://iwantit.oss-cn-hangzhou.aliyuncs.com/20240104/65965c5c8ad99.png', '0', '1', '7,6,5,4,3', '2023-11-15 22:06:47', '99', '2');
INSERT INTO `tb_activity` VALUES ('4', '微医员工生日福利', '微医员工生日福利', '2023-11-29', '2023-12-31', 'https://iwantit.oss-cn-hangzhou.aliyuncs.com/20231129/65674dc747b65.jpg', '0', '1', '15,14,13,12,11,10,9,8', '2023-11-29 22:42:42', '99', '1');

-- ----------------------------
-- Table structure for `tb_activity_card`
-- ----------------------------
DROP TABLE IF EXISTS `tb_activity_card`;
CREATE TABLE `tb_activity_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `act_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `user_phone` varchar(50) DEFAULT NULL,
  `card_no` varchar(100) DEFAULT NULL,
  `card_pwd` varchar(50) DEFAULT NULL,
  `ext_code` varchar(30) DEFAULT '' COMMENT '扩展码',
  `status` int(11) DEFAULT '0',
  `create_time` datetime DEFAULT NULL,