master

分支 (1)

管理

管理

master

new_bee_db
/
new_bee.sql

/*
 Navicat Premium Data Transfer

 Source Server         : youdianlao
 Source Server Type    : MariaDB
 Source Server Version : 100515
 Source Host           : localhost:3306
 Source Schema         : new_bee

 Target Server Type    : MariaDB
 Target Server Version : 100515
 File Encoding         : 65001

 Date: 14/06/2022 19:39:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for nbs_game_album
-- ----------------------------
DROP TABLE IF EXISTS `nbs_game_album`;
CREATE TABLE `nbs_game_album`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '记录id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相册名称',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相册简介',
  `sort` tinyint(3) UNSIGNED NULL DEFAULT 0 COMMENT '自定义排序序号',
  `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '数据创建时间',
  `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '数据最后修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_album_name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '相册' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_game_album
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_game_detail
-- ----------------------------
DROP TABLE IF EXISTS `nbs_game_detail`;
CREATE TABLE `nbs_game_detail`  (
  `id` int(11) NOT NULL,
  `en_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cn_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pinyin_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `version_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `game_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `developer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `release_date` date NULL DEFAULT NULL,
  `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `platform` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `current_ver_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `introduction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `price` decimal(10, 2) NULL DEFAULT NULL,
  `sale_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `download_count` int(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_game_detail
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_game_detail_stock_template
-- ----------------------------
DROP TABLE IF EXISTS `nbs_game_detail_stock_template`;
CREATE TABLE `nbs_game_detail_stock_template`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NULL DEFAULT NULL,
  `stock_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_game_detail_stock_template
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_game_dev
-- ----------------------------
DROP TABLE IF EXISTS `nbs_game_dev`;
CREATE TABLE `nbs_game_dev`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `developer` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `gmt_create` datetime(0) NULL DEFAULT NULL,
  `gmt_modified` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '开发商' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_game_dev
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_game_dev_type_template
-- ----------------------------
DROP TABLE IF EXISTS `nbs_game_dev_type_template`;
CREATE TABLE `nbs_game_dev_type_template`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dev_id` int(11) NULL DEFAULT NULL,
  `type_id` int(11) NULL DEFAULT NULL,
  `gmt_create` datetime(0) NULL DEFAULT NULL,
  `gmt_modified` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_game_dev_type_template
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_game_image
-- ----------------------------
DROP TABLE IF EXISTS `nbs_game_image`;
CREATE TABLE `nbs_game_image`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '记录id',
  `album_id` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT '相册id',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片url',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片简介',
  `width` smallint(5) UNSIGNED NULL DEFAULT NULL COMMENT '图片宽度，单位：px',
  `height` smallint(5) UNSIGNED NULL DEFAULT NULL COMMENT '图片高度，单位：px',
  `is_cover` tinyint(3) UNSIGNED NULL DEFAULT 0 COMMENT '是否为封面图片，1=是，0=否',
  `sort` tinyint(3) UNSIGNED NULL DEFAULT 0 COMMENT '自定义排序序号',
  `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '数据创建时间',
  `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '数据最后修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '图片' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_game_image
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_game_stock
-- ----------------------------
DROP TABLE IF EXISTS `nbs_game_stock`;
CREATE TABLE `nbs_game_stock`  (
  `id` int(64) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `current_stock` int(64) NULL DEFAULT NULL,
  `max_stock` int(64) NULL DEFAULT NULL,
  `min_stock` int(64) NULL DEFAULT NULL,
  `gmt_create_time` datetime(0) NULL DEFAULT NULL,
  `gmt_modified` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_game_stock
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_game_type
-- ----------------------------
DROP TABLE IF EXISTS `nbs_game_type`;
CREATE TABLE `nbs_game_type`  (
  `id` int(50) NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_game_type
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_sku
-- ----------------------------
DROP TABLE IF EXISTS `nbs_sku`;
CREATE TABLE `nbs_sku`  (
  `id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `spu_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `bar_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `attribute_template_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `specifications` varchar(2500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `album_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `pictures` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `price` decimal(10, 2) NULL DEFAULT NULL,
  `stock` int(10) UNSIGNED NULL DEFAULT NULL,
  `stock_threshold` int(10) UNSIGNED NULL DEFAULT NULL,
  `sales` int(10) UNSIGNED NULL DEFAULT NULL,
  `comment_count` int(10) UNSIGNED NULL DEFAULT NULL,
  `positive_comment_count` int(10) UNSIGNED NULL DEFAULT NULL,
  `sort` tinyint(4) NULL DEFAULT NULL,
  `gmt_create` datetime(0) NULL DEFAULT NULL,
  `gmt_modified` datetime(0) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'SKU（Stock Keeping Unit）' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_sku
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_sku_specification
-- ----------------------------
DROP TABLE IF EXISTS `nbs_sku_specification`;
CREATE TABLE `nbs_sku_specification`  (
  `id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `sku_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `attribute_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `attribute_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `attribute_value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `unit` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sort` tinyint(4) NULL DEFAULT NULL,
  `gmt_create` datetime(0) NULL DEFAULT NULL,
  `gmt_modified` datetime(0) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'SKU数据' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_sku_specification
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_spu
-- ----------------------------
DROP TABLE IF EXISTS `nbs_spu`;
CREATE TABLE `nbs_spu`  (
  `id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `type_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `list_price` decimal(10, 2) NULL DEFAULT NULL,
  `stock` int(10) UNSIGNED NULL DEFAULT NULL,
  `stock_threshold` int(10) UNSIGNED NULL DEFAULT NULL,
  `unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `brand_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `brand_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `category_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `attribute_template_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `album_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `pictures` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sales` int(10) UNSIGNED NULL DEFAULT NULL,
  `comment_count` int(10) UNSIGNED NULL DEFAULT NULL,
  `positive_comment_count` int(10) UNSIGNED NULL DEFAULT NULL,
  `sort` tinyint(4) NULL DEFAULT NULL,
  `is_deleted` tinyint(4) NULL DEFAULT NULL,
  `is_published` tinyint(4) NULL DEFAULT NULL,
  `is_new_arrival` tinyint(4) NULL DEFAULT NULL,
  `is_recommend` tinyint(4) NULL DEFAULT NULL,
  `is_checked` tinyint(4) NULL DEFAULT NULL,
  `check_user` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `gmt_check` datetime(0) NULL DEFAULT NULL,
  `gmt_create` datetime(0) NULL DEFAULT NULL,
  `gmt_modified` datetime(0) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'SPU（Standard Product Unit）' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_spu
-- ----------------------------

-- ----------------------------
-- Table structure for nbs_spu_detail
-- ----------------------------
DROP TABLE IF EXISTS `nbs_spu_detail`;
CREATE TABLE `nbs_spu_detail`  (
  `id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `spu_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `gmt_create` datetime(0) NULL DEFAULT NULL,
  `gmt_modified` datetime(0) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'SPU详情' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of nbs_spu_detail
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;