38 lines
1.6 KiB
MySQL
38 lines
1.6 KiB
MySQL
|
/*
|
||
|
|
Navicat Premium Data Transfer
|
||
|
|
|
||
|
|
Source Server : 本机数据库
|
||
|
|
Source Server Type : MySQL
|
||
|
|
Source Server Version : 50726 (5.7.26)
|
||
|
|
Source Host : localhost:3306
|
||
|
|
Source Schema : siwu_iot_2
|
||
|
|
|
||
|
|
Target Server Type : MySQL
|
||
|
|
Target Server Version : 50726 (5.7.26)
|
||
|
|
File Encoding : 65001
|
||
|
|
|
||
|
|
Date: 21/03/2025 15:21:36
|
||
|
|
*/
|
||
|
|
|
||
|
|
SET NAMES utf8mb4;
|
||
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Table structure for big_screen_share
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `big_screen_share`;
|
||
|
|
CREATE TABLE `big_screen_share` (
|
||
|
|
`id` bigint(64) NOT NULL AUTO_INCREMENT,
|
||
|
|
`code` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '允许访问列表',
|
||
|
|
`user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '页面编码，页面唯一标识符',
|
||
|
|
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '2' COMMENT '创建人',
|
||
|
|
`create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
|
|
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '2' COMMENT '更新人',
|
||
|
|
`update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
|
|
`remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备忘',
|
||
|
|
`del_flag` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标识符 1 删除 0未删',
|
||
|
|
PRIMARY KEY (`id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '页面被允许访问信息表' ROW_FORMAT = Dynamic;
|
||
|
|
|
||
|
|
SET FOREIGN_KEY_CHECKS = 1;
|