登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
4 Star 7 Fork 2

Gitee 极速下载 / aidigu

代码 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
此仓库是为了提升国内下载速度的镜像仓库，每日同步一次。 原始仓库： https://github.com/aidigu/aidigu
克隆/下载
aidigu.sql 24.04 KB
一键复制 编辑 原始数据 按行查看 历史
SR.李 提交于 2024-03-06 14:58 . 更新sql
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481


SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



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

-- Table structure for wb_app

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

DROP TABLE IF EXISTS `wb_app`;

CREATE TABLE `wb_app` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `app_name` varchar(255) CHARACTER SET utf8mb4 NOT NULL COMMENT '应用名称',

  `app_url` varchar(255) CHARACTER SET utf8mb4 NOT NULL COMMENT '链接',

  `app_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '0关闭，1开启（默认）',

  `app_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0全部，1pc,2手机',

  `app_image` varchar(255) CHARACTER SET utf8mb4 NOT NULL COMMENT '图片地址',

  `remind_key` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '提醒key',

  `app_config` text CHARACTER SET utf8mb4 NOT NULL COMMENT '配置',

  `open_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '打开方式，0frame,1直接打开，2新窗口打开',

  `create_time` datetime NOT NULL COMMENT '创建时间',

  `update_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_app

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

BEGIN;

INSERT INTO `wb_app` VALUES (1, '我的云盘', '/cloud/show/', 1, 1, '/static/tools/common/images/cloud.jpg', '', '{\"title\":\"我的云盘\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"80%\",\"80%\"],\"resize\":true,\"maxmin\":true,\"skin\":\"layui-layer-win10\",\"id\":\"app_1\",\"hideOnClose\":true,\"scrollbar\":false}', 0, '2024-01-16 11:31:53', '2024-02-06 16:35:07');

INSERT INTO `wb_app` VALUES (2, '嘀友聊天', '/chat', 1, 1, '/static/tools/common/images/chat.jpg', 'chat', '{\"title\":\"嘀友聊天\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"60%\",\"70%\"],\"resize\":true,\"maxmin\":true,\"id\":\"app_2\",\"hideOnClose\":true,\"scrollbar\":false}', 0, '2024-01-16 11:31:53', '2024-01-22 18:33:56');

INSERT INTO `wb_app` VALUES (3, '嘀咕影院', '/tools/movie', 1, 1, '/static/tools/common/images/movie.jpg', '', '{\"title\":\"嘀咕影院\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"80%\",\"80%\"],\"resize\":true,\"maxmin\":true,\"skin\":\"layui-layer-win10\",\"id\":\"app_3\",\"hideOnClose\":false,\"scrollbar\":false}', 0, '2024-01-16 11:31:53', '2024-01-22 18:33:56');

INSERT INTO `wb_app` VALUES (4, '开车啦', '/tools/onlinecar', 1, 1, '/static/tools/common/images/onlinecar.jpg', '', '{\"title\":\"开车啦\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"80%\",\"80%\"],\"resize\":true,\"maxmin\":true,\"skin\":\"layui-layer-win10\",\"id\":\"app_4\",\"hideOnClose\":true,\"scrollbar\":false}', 0, '2024-01-16 11:31:53', '2024-01-22 18:33:56');

INSERT INTO `wb_app` VALUES (5, 'BMI体重计算', '/tools/bmi', 1, 1, '/static/tools/common/images/bmi.jpg', '', '{\"title\":\"BMI体重计算\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"80%\",\"80%\"],\"resize\":true,\"maxmin\":true,\"skin\":\"layui-layer-win10\",\"id\":\"app_5\",\"hideOnClose\":true,\"scrollbar\":false}', 0, '2024-01-16 11:31:53', '2024-01-22 18:33:56');

INSERT INTO `wb_app` VALUES (6, '我的云盘', '/cloud/show/', 1, 2, '/static/tools/common/images/cloud.jpg', '', '{\"title\":\"我的云盘\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"100%\",\"100%\"],\"resize\":false,\"maxmin\":false,\"skin\":\"layui-layer-win10\",\"id\":\"app_8\",\"hideOnClose\":true,\"scrollbar\":false}', 0, '2024-01-16 11:31:53', '2024-01-22 18:46:07');

INSERT INTO `wb_app` VALUES (7, '嘀友聊天', '/chat', 1, 2, '/static/tools/common/images/chat.jpg', 'chat', '{\"title\":\"嘀友聊天\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"100%\",\"100%\"],\"resize\":false,\"maxmin\":false,\"id\":\"app_9\",\"hideOnClose\":true,\"scrollbar\":false}', 0, '2024-01-16 11:31:53', '2024-01-22 18:46:07');

INSERT INTO `wb_app` VALUES (8, '嘀咕影院', '/tools/movie', 1, 2, '/static/tools/common/images/movie.jpg', '', '{\"title\":\"嘀咕影院\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"100%\",\"100%\"],\"resize\":false,\"maxmin\":false,\"skin\":\"layui-layer-win10\",\"id\":\"app_10\",\"hideOnClose\":false,\"scrollbar\":false}', 0, '2024-01-16 11:31:53', '2024-01-22 18:46:07');

INSERT INTO `wb_app` VALUES (9, '开车啦', '/tools/onlinecar', 1, 2, '/static/tools/common/images/onlinecar.jpg', '', '{\"title\":\"开车啦\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"100%\",\"100%\"],\"resize\":false,\"maxmin\":false,\"skin\":\"layui-layer-win10\",\"id\":\"app_11\",\"hideOnClose\":true,\"scrollbar\":false}', 0, '2024-01-16 11:31:53', '2024-01-22 18:46:07');

INSERT INTO `wb_app` VALUES (10, 'BMI体重计算', '/tools/bmi', 1, 2, '/static/tools/common/images/bmi.jpg', '', '{\"title\":\"BMI体重计算\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"100%\",\"100%\"],\"resize\":false,\"maxmin\":false,\"skin\":\"layui-layer-win10\",\"id\":\"app_12\",\"hideOnClose\":true,\"scrollbar\":false}', 0, '2024-01-16 11:31:53', '2024-01-22 18:46:07');

INSERT INTO `wb_app` VALUES (11, '话题', '/topic/', 1, 2, '/static/tools/common/images/topic.jpeg', '', '{}', 1, '2024-01-16 11:31:53', '2024-01-23 16:15:21');

INSERT INTO `wb_app` VALUES (12, '群管理', '/tools/chat/list', 1, 1, '/static/tools/common/images/chatgroup.jpeg', '', '{\"title\":\"群管理\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"70%\",\"80%\"],\"resize\":true,\"maxmin\":true,\"skin\":\"layui-layer-win10\",\"id\":\"app_11\",\"hideOnClose\":false,\"scrollbar\":false}', 0, '2024-01-30 11:16:10', '2024-02-06 11:29:34');

INSERT INTO `wb_app` VALUES (13, '群管理', '/tools/chat/list', 1, 2, '/static/tools/common/images/chatgroup.jpeg', '', '{\"title\":\"群管理\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"100%\",\"100%\"],\"resize\":false,\"maxmin\":false,\"skin\":\"layui-layer-win10\",\"id\":\"app_12\",\"hideOnClose\":false,\"scrollbar\":false}', 0, '2024-01-30 11:16:10', '2024-02-05 23:36:10');

INSERT INTO `wb_app` VALUES (14, '邀请码', '/tools/userinvite/list', 1, 1, '/static/tools/common/images/userinvite.jpeg', '', '{\"title\":\"邀请码\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"70%\",\"80%\"],\"resize\":true,\"maxmin\":true,\"skin\":\"layui-layer-win10\",\"id\":\"app_13\",\"hideOnClose\":false,\"scrollbar\":false}', 0, '2024-01-30 11:16:10', '2024-02-06 11:29:34');

INSERT INTO `wb_app` VALUES (15, '邀请码', '/tools/userinvite/list', 1, 2, '/static/tools/common/images/userinvite.jpeg', '', '{\"title\":\"邀请码\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"100%\",\"100%\"],\"resize\":false,\"maxmin\":false,\"skin\":\"layui-layer-win10\",\"id\":\"app_14\",\"hideOnClose\":false,\"scrollbar\":false}', 0, '2024-01-30 11:16:10', '2024-02-05 23:36:23');

INSERT INTO `wb_app` VALUES (16, '收藏管理', '/tools/collect/list', 1, 1, '/static/tools/common/images/collect.jpeg', '', '{\"title\":\"收藏管理\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"70%\",\"80%\"],\"resize\":true,\"maxmin\":true,\"skin\":\"layui-layer-win10\",\"id\":\"app_15\",\"hideOnClose\":false,\"scrollbar\":false}', 0, '2024-01-30 11:16:10', '2024-02-06 11:29:54');

INSERT INTO `wb_app` VALUES (17, '收藏管理', '/tools/collect/list', 1, 2, '/static/tools/common/images/collect.jpeg', '', '{\"title\":\"收藏管理\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"100%\",\"100%\"],\"resize\":false,\"maxmin\":false,\"skin\":\"layui-layer-win10\",\"id\":\"app_16\",\"hideOnClose\":false,\"scrollbar\":false}', 0, '2024-01-30 11:16:10', '2024-02-06 11:29:54');

INSERT INTO `wb_app` VALUES (18, '素材管理', '/tools/sourcematerial/list', 1, 1, '/static/tools/common/images/sourcematerial.jpeg', '', '{\"title\":\"素材管理\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"70%\",\"80%\"],\"resize\":true,\"maxmin\":true,\"skin\":\"layui-layer-win10\",\"id\":\"app_18\",\"hideOnClose\":false,\"scrollbar\":false}', 0, '2024-01-30 11:16:10', '2024-03-04 17:03:55');

INSERT INTO `wb_app` VALUES (19, '素材管理', '/tools/sourcematerial/list', 1, 2, '/static/tools/common/images/sourcematerial.jpeg', '', '{\"title\":\"素材管理\",\"shade\":0.8,\"closeBtn\":true,\"shadeClose\":false,\"area\":[\"100%\",\"100%\"],\"resize\":false,\"maxmin\":false,\"skin\":\"layui-layer-win10\",\"id\":\"app_19\",\"hideOnClose\":false,\"scrollbar\":false}', 0, '2024-01-30 11:16:10', '2024-02-06 11:29:54');

COMMIT;



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

-- Table structure for wb_badword

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

DROP TABLE IF EXISTS `wb_badword`;

CREATE TABLE `wb_badword` (

  `bid` int(11) NOT NULL AUTO_INCREMENT,

  `word` varchar(50) COLLATE utf8mb4_bin NOT NULL,

  `ctype` tinyint(4) NOT NULL DEFAULT '0',

  PRIMARY KEY (`bid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_badword

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

BEGIN;

COMMIT;



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

-- Table structure for wb_chat_friends

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

DROP TABLE IF EXISTS `wb_chat_friends`;

CREATE TABLE `wb_chat_friends` (

  `fansid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `fromuid` bigint(20) NOT NULL,

  `touid` bigint(20) NOT NULL,

  `mutual_concern` tinyint(4) NOT NULL DEFAULT '0',

  `message_count` int(10) unsigned NOT NULL DEFAULT '0',

  `ctime` bigint(20) NOT NULL DEFAULT '0',

  `utime` bigint(20) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`fansid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_chat_friends

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

BEGIN;

COMMIT;



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

-- Table structure for wb_chat_friends_history

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

DROP TABLE IF EXISTS `wb_chat_friends_history`;

CREATE TABLE `wb_chat_friends_history` (

  `chat_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',

  `fromuid` int(11) NOT NULL COMMENT '来源id',

  `touid` int(11) NOT NULL COMMENT '目标id',

  `content` text COLLATE utf8mb4_bin NOT NULL COMMENT '内容',

  `content_type` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '内容类型',

  `send_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '发送状态',

  `create_time` datetime NOT NULL COMMENT '消息时间',

  PRIMARY KEY (`chat_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_chat_friends_history

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

BEGIN;

COMMIT;



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

-- Table structure for wb_chat_group

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

DROP TABLE IF EXISTS `wb_chat_group`;

CREATE TABLE `wb_chat_group` (

  `groupid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `groupname` char(11) COLLATE utf8mb4_bin DEFAULT '',

  `head_image` varchar(255) COLLATE utf8mb4_bin DEFAULT '',

  `head_image_info` varchar(255) COLLATE utf8mb4_bin DEFAULT '',

  `city` char(25) COLLATE utf8mb4_bin DEFAULT '',

  `fromuid` int(10) unsigned NOT NULL DEFAULT '0',

  `invite_code` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

  `invite_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否开启加群',

  `intro` varchar(210) COLLATE utf8mb4_bin DEFAULT '',

  `ctime` bigint(20) DEFAULT NULL,

  `utime` bigint(20) unsigned DEFAULT NULL,

  `usernum` int(11) NOT NULL DEFAULT '0' COMMENT '粉丝数',

  PRIMARY KEY (`groupid`) USING BTREE

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_chat_group

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

BEGIN;

COMMIT;



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

-- Table structure for wb_chat_group_history

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

DROP TABLE IF EXISTS `wb_chat_group_history`;

CREATE TABLE `wb_chat_group_history` (

  `chat_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',

  `fromuid` int(11) NOT NULL COMMENT '来源id',

  `groupid` int(11) NOT NULL COMMENT '目标id',

  `content` text COLLATE utf8mb4_bin NOT NULL COMMENT '内容',

  `content_type` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '内容类型',

  `create_time` datetime NOT NULL COMMENT '消息时间',

  PRIMARY KEY (`chat_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_chat_group_history

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

BEGIN;

COMMIT;



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

-- Table structure for wb_chat_group_user

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

DROP TABLE IF EXISTS `wb_chat_group_user`;

CREATE TABLE `wb_chat_group_user` (

  `fansid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `groupid` bigint(20) NOT NULL,

  `uid` bigint(20) NOT NULL,

  `message_count` int(10) unsigned NOT NULL DEFAULT '0',

  `ctime` bigint(20) NOT NULL DEFAULT '0' COMMENT '加入时间',

  `dtime` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',

  `utime` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',

  PRIMARY KEY (`fansid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_chat_group_user

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

BEGIN;

COMMIT;



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

-- Table structure for wb_chat_online

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

DROP TABLE IF EXISTS `wb_chat_online`;

CREATE TABLE `wb_chat_online` (

  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `uid` bigint(20) unsigned NOT NULL,

  `fd` bigint(20) unsigned NOT NULL,

  `online_time` bigint(20) unsigned NOT NULL,

  `offline_time` bigint(20) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_chat_online

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

BEGIN;

COMMIT;



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

-- Table structure for wb_chat_private_letter

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

DROP TABLE IF EXISTS `wb_chat_private_letter`;

CREATE TABLE `wb_chat_private_letter` (

  `fansid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `fromuid` bigint(20) NOT NULL,

  `touid` bigint(20) NOT NULL,

  `mutual_concern` tinyint(4) NOT NULL DEFAULT '0',

  `message_count` int(10) unsigned NOT NULL DEFAULT '0',

  `ctime` bigint(20) NOT NULL DEFAULT '0',

  `utime` bigint(20) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`fansid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_chat_private_letter

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

BEGIN;

COMMIT;



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

-- Table structure for wb_chat_private_letter_history

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

DROP TABLE IF EXISTS `wb_chat_private_letter_history`;

CREATE TABLE `wb_chat_private_letter_history` (

  `chat_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',

  `fromuid` int(11) NOT NULL COMMENT '来源id',

  `touid` int(11) NOT NULL COMMENT '目标id',

  `content` text COLLATE utf8mb4_bin NOT NULL COMMENT '内容',

  `content_type` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '内容类型',

  `send_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '发送状态',

  `create_time` datetime NOT NULL COMMENT '消息时间',

  PRIMARY KEY (`chat_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_chat_private_letter_history

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

BEGIN;

COMMIT;



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

-- Table structure for wb_comment

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

DROP TABLE IF EXISTS `wb_comment`;

CREATE TABLE `wb_comment` (

  `cid` bigint(20) NOT NULL AUTO_INCREMENT,

  `fromuid` bigint(20) NOT NULL,

  `msg` text COLLATE utf8mb4_bin NOT NULL,

  `msg_id` bigint(20) NOT NULL,

  `touid` mediumint(9) DEFAULT NULL,

  `ctime` int(11) NOT NULL,

  PRIMARY KEY (`cid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_comment

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

BEGIN;

COMMIT;



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

-- Table structure for wb_fans

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

DROP TABLE IF EXISTS `wb_fans`;

CREATE TABLE `wb_fans` (

  `fansid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `fromuid` bigint(20) NOT NULL,

  `touid` bigint(20) NOT NULL,

  `mutual_concern` tinyint(4) NOT NULL DEFAULT '0',

  `ctime` bigint(20) NOT NULL DEFAULT '0',

  PRIMARY KEY (`fansid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_fans

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

BEGIN;

COMMIT;



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

-- Table structure for wb_file

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

DROP TABLE IF EXISTS `wb_file`;

CREATE TABLE `wb_file` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',

  `userid` int(10) unsigned NOT NULL COMMENT '用户id',

  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0File, 1S3File',

  `file_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '文件名',

  `file_type` varchar(255) COLLATE utf8mb4_bin NOT NULL,

  `file_size` double NOT NULL COMMENT '文件大小',

  `file_location` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '文件地址',

  `file_path` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '文件地址',

  `create_time` datetime NOT NULL COMMENT '创建时间',

  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',

  `share_msg_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '是否站内分享0未分享',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_file

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

BEGIN;

COMMIT;



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

-- Table structure for wb_message

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

DROP TABLE IF EXISTS `wb_message`;

CREATE TABLE `wb_message` (

  `msg_id` mediumint(9) NOT NULL AUTO_INCREMENT,

  `uid` mediumint(9) NOT NULL,

  `contents` text COLLATE utf8mb4_bin NOT NULL,

  `repost` mediumtext COLLATE utf8mb4_bin,

  `refrom` varchar(50) COLLATE utf8mb4_bin NOT NULL,

  `media` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,

  `media_info` text COLLATE utf8mb4_bin,

  `repostsum` int(11) NOT NULL DEFAULT '0',

  `commentsum` int(11) NOT NULL DEFAULT '0',

  `collectsum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收藏点赞数',

  `topic_id` int(10) unsigned NOT NULL DEFAULT '0',

  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除0未删除，1已删除',

  `ctime` int(11) NOT NULL,

  PRIMARY KEY (`msg_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_message

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

BEGIN;

COMMIT;



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

-- Table structure for wb_reminder

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

DROP TABLE IF EXISTS `wb_reminder`;

CREATE TABLE `wb_reminder` (

  `id` bigint(20) NOT NULL AUTO_INCREMENT,

  `msg_id` bigint(20) DEFAULT NULL,

  `fromuid` bigint(20) NOT NULL,

  `touid` bigint(20) NOT NULL,

  `type` tinyint(4) NOT NULL,

  `ctime` bigint(20) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_reminder

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

BEGIN;

COMMIT;



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

-- Table structure for wb_source_material

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

DROP TABLE IF EXISTS `wb_source_material`;

CREATE TABLE `wb_source_material` (

  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',

  `uid` bigint(20) unsigned NOT NULL COMMENT '用户id',

  `title` varchar(255) NOT NULL DEFAULT '0' COMMENT '标题',

  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态0删除，1正常',

  `create_time` datetime NOT NULL COMMENT '创建时间',

  `push_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '投送时间',

  `share_msg_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '内容id',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



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

-- Records of wb_source_material

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

BEGIN;

COMMIT;



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

-- Table structure for wb_source_material_relation

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

DROP TABLE IF EXISTS `wb_source_material_relation`;

CREATE TABLE `wb_source_material_relation` (

  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',

  `media_info` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',

  `media_type` varchar(255) NOT NULL DEFAULT '' COMMENT '类型',

  `file_size` double NOT NULL COMMENT '文件大小',

  `file_name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',

  `source_material_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '是否站内分享0未分享',

  `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',

  `create_time` datetime NOT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



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

-- Records of wb_source_material_relation

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

BEGIN;

COMMIT;



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

-- Table structure for wb_topic

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

DROP TABLE IF EXISTS `wb_topic`;

CREATE TABLE `wb_topic` (

  `topic_id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '标题',

  `uid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建人，默认0',

  `create_time` datetime NOT NULL COMMENT '创建时间',

  `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '话题数量',

  PRIMARY KEY (`topic_id`) USING BTREE

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_topic

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

BEGIN;

COMMIT;



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

-- Table structure for wb_user

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

DROP TABLE IF EXISTS `wb_user`;

CREATE TABLE `wb_user` (

  `uid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `nickname` char(11) COLLATE utf8mb4_bin NOT NULL,

  `username` char(10) COLLATE utf8mb4_bin DEFAULT NULL,

  `blog` char(20) COLLATE utf8mb4_bin DEFAULT NULL,

  `phone` bigint(20) DEFAULT NULL COMMENT '手机号',

  `password` char(32) COLLATE utf8mb4_bin NOT NULL,

  `head_image` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,

  `head_image_info` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,

  `sex` tinyint(4) NOT NULL DEFAULT '0',

  `province` char(10) COLLATE utf8mb4_bin DEFAULT NULL,

  `city` char(25) COLLATE utf8mb4_bin DEFAULT NULL,

  `email` char(32) COLLATE utf8mb4_bin DEFAULT NULL,

  `intro` varchar(210) COLLATE utf8mb4_bin DEFAULT NULL,

  `ctime` bigint(20) NOT NULL,

  `message_sum` mediumint(9) NOT NULL DEFAULT '0',

  `theme` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,

  `fansnum` bigint(20) NOT NULL DEFAULT '0' COMMENT '粉丝数',

  `follownum` bigint(20) NOT NULL DEFAULT '0' COMMENT '关注数',

  `invisible` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '广场隐身1，默认0不隐身',

  PRIMARY KEY (`uid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;



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

-- Records of wb_user

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

BEGIN;

COMMIT;



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

-- Table structure for wb_user_collect

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

DROP TABLE IF EXISTS `wb_user_collect`;

CREATE TABLE `wb_user_collect` (

  `collect_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `msg_id` bigint(20) unsigned NOT NULL,

  `fromuid` int(10) unsigned NOT NULL,

  `collect_time` datetime NOT NULL,

  `delete_time` bigint(20) unsigned NOT NULL DEFAULT '0',

  PRIMARY KEY (`collect_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



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

-- Records of wb_user_collect

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

BEGIN;

COMMIT;



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

-- Table structure for wb_user_invite

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

DROP TABLE IF EXISTS `wb_user_invite`;

CREATE TABLE `wb_user_invite` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `fromuid` int(10) unsigned NOT NULL DEFAULT '0',

  `touid` int(10) unsigned NOT NULL DEFAULT '0',

  `invite_code` varchar(255) NOT NULL,

  `invite_status` tinyint(3) unsigned NOT NULL DEFAULT '0',

  `create_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



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

-- Records of wb_user_invite

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

BEGIN;

COMMIT;



SET FOREIGN_KEY_CHECKS = 1;
PHP
1
https://gitee.com/mirrors/aidigu.git
git@gitee.com:mirrors/aidigu.git
mirrors
aidigu
aidigu
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部