github.com/wangyougui/gf/v2@v2.6.5/database/gdb/testdata/issue1380.sql (about)

     1  CREATE TABLE `jfy_gift`  (
     2  `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
     3  `gift_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '礼品名称',
     4  `at_least_recharge_count` int(0) UNSIGNED NOT NULL DEFAULT 1 COMMENT '最少兑换数量',
     5  `comments` json NOT NULL COMMENT '礼品留言',
     6  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '礼品详情',
     7  `cost_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '成本价',
     8  `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '封面',
     9  `covers` json NOT NULL COMMENT '礼品图片库',
    10  `description` varchar(62) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '礼品备注',
    11  `express_type` json NOT NULL COMMENT '配送方式',
    12  `gift_type` int(0) NOT NULL COMMENT '礼品类型：1：实物；2：虚拟；3：优惠券；4：积分券',
    13  `has_props` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有多个属性',
    14  `is_limit_sell` tinyint(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否限购',
    15  `limit_customer_tags` json NOT NULL COMMENT '语序购买的会员标签',
    16  `limit_sell_custom` tinyint(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否开启允许购买的会员标签',
    17  `limit_sell_cycle` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '限购周期',
    18  `limit_sell_cycle_count` int(0) NOT NULL COMMENT '限购期内允许购买的数量',
    19  `limit_sell_type` tinyint(0) NOT NULL COMMENT '限购类型',
    20  `market_price` decimal(10, 2) NOT NULL COMMENT '市场价',
    21  `out_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内部编码',
    22  `props` json NOT NULL COMMENT '规格',
    23  `skus` json NOT NULL COMMENT 'SKU',
    24  `score_price` decimal(10, 2) NOT NULL COMMENT '兑换所需积分',
    25  `stock` int(0) NOT NULL COMMENT '库存',
    26  `create_at` datetime(0) NOT NULL COMMENT '创建日期',
    27  `store_id` int(0) NOT NULL COMMENT '所属商城',
    28  `status` int(0) UNSIGNED NULL DEFAULT 1 COMMENT '1：下架；20：审核中；30：复审中；99：上架',
    29  `view_count` int(0) NOT NULL DEFAULT 0 COMMENT '访问量',
    30  `sell_count` int(0) NULL DEFAULT 0 COMMENT '销量',
    31  PRIMARY KEY (`id`) USING BTREE
    32  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    33  
    34  
    35  INSERT INTO `jfy_gift` VALUES (17, 'GIFT', 1, '[{\"name\": \"身份证\", \"field\": \"idcard\", \"required\": false}, {\"name\": \"留言2\", \"field\": \"text\", \"required\": false}]', '<p>礼品详情</p>', 0.00, '', '{\"list\": [{\"uid\": \"vc-upload-1629292486099-3\", \"url\": \"https://cdn.taobao.com/sULsYiwaOPjsKGoBXwKtuewPzACpBDfQ.jpg\", \"name\": \"O1CN01OH6PIP1Oc5ot06U17_!!922361725.jpg\", \"status\": \"done\"}, {\"uid\": \"vc-upload-1629292486099-4\", \"url\": \"https://cdn.taobao.com/lqLHDcrFTgNvlWyXfLYZwmsrODzIBtFH.jpg\", \"name\": \"O1CN018hBckI1Oc5ouc8ppl_!!922361725.jpg\", \"status\": \"done\"}, {\"uid\": \"vc-upload-1629292486099-5\", \"url\": \"https://cdn.taobao.com/pvqyutXckICmHhbPBQtrVLHuMlXuGxUg.jpg\", \"name\": \"O1CN0185Ubp91Oc5osQTTcc_!!922361725.jpg\", \"status\": \"done\"}]}', '支持个性定制的父亲节老师长辈的专属礼物', '[\"快递包邮\", \"同城配送\"]', 1, 0, 0, '[]', 0, 'day', 0, 1, 0.00, '259402', '[{\"name\": \"颜色\", \"values\": [\"红色\", \"蓝色\"]}]', '[{\"name\": \"red\", \"stock\": 10, \"gift_id\": 1, \"cost_price\": 80, \"score_price\": 188, \"market_price\": 388}, {\"name\": \"blue\", \"stock\": 100, \"gift_id\": 2, \"cost_price\": 81, \"score_price\": 200, \"market_price\": 288}]', 10.00, 0, '2021-08-18 21:26:13', 100004, 99, 0, 0);