安卓AndroidStudio大学生交友聊天社交app设计

/* Navicat Premium Data Transfer Source Server : 127.0.0.1 Source Server Type : MySQL Source Server Version : 50620 Source Host : localhost:3306 Source Schema : weiboinfoluntanfriendkebiao_ssm2 Target Server Type : MySQL Target Server Version : 50620 File Encoding : 65001 Date: 05/05/2021 16:03:33 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for wct_bill -- ---------------------------- DROP TABLE IF EXISTS `wct_bill`; CREATE TABLE `wct_bill` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gids` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `price` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `user` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `uid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `shop` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `bill` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `openid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ndate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `total` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `way` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `gnames` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sid` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `note` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `state` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `statecn` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cuidan` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `qid` int(11) NULL DEFAULT NULL, `qusername` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `qtel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for wct_blog -- ---------------------------- DROP TABLE IF EXISTS `wct_blog`; CREATE TABLE `wct_blog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `note` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ndate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `btype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `img` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `video` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `typeid` int(11) NULL DEFAULT NULL, `typecn` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `uid` int(11) NULL DEFAULT NULL, `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `favcount` int(11) NULL DEFAULT NULL, `zan` int(11) NULL DEFAULT NULL, `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nm` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 50 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of wct_blog -- ---------------------------- INSERT INTO `wct_blog` VALUES (48, '测试会议通知', '<p><span style=\"font-weight: bold;\">这里是详细的会议通知的详细内容 这里是详细的会议通知的详细内容&nbsp;</span></p>', '2021-04-16 14:34:54', '1', 'ce7b31f3-b2e2-4790-93fa-8681f0e9c814.jpg', '', 71, '会议通知', 1, 'admin', NULL, NULL, '', NULL); INSERT INTO `wct_blog` VALUES (49, '期中监考通知', '<p><span style=\"font-weight: bold;\">这里自己编辑通知内容</span></p><p><span style=\"font-weight: bold;\">这里是一个编辑器,自己可以任意编辑的,上传文件视频都是可以的</span></p><p><img src=\"upload/e013f8f3-16e6-443b-b379-1ec3f9239ac2.jpg\" style=\"max-width:100%;\"><span style=\"font-weight: bold;\"><br></span></p>', '2021-04-16 14:50:57', '1', 'ff84925d-8dff-4216-8303-2898538ce1b0.jpg', '', 69, '监考通知', 1, 'admin', 2, NULL, '', NULL); -- ---------------------------- -- Table structure for wct_choose -- ---------------------------- DROP TABLE IF EXISTS `wct_choose`; CREATE TABLE `wct_choose` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `daan` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `opa` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `opb` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `opc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `opd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `fenxi` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `typeid` int(11) NULL DEFAULT NULL, `img` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `leixing` int(11) NULL DEFAULT NULL, `rc` int(11) NULL DEFAULT NULL, `wc` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for wct_daka -- ---------------------------- DROP TABLE IF EXISTS `wct_daka`; CREATE TABLE `wct_daka` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `note` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `uid` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `username` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ndate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for wct_hobby -- ---------------------------- DROP TABLE IF EXISTS `wct_hobby`; CREATE TABLE `wct_hobby` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of wct_hobby -- ---------------------------- INSERT INTO `wct_hobby` VALUES (7, '运动'); INSERT INTO `wct_hobby` VALUES (8, '阅读'); INSERT INTO `wct_hobby` VALUES (9, '音乐'); -- ---------------------------- -- Table structure for wct_hobbysub -- ---------------------------- DROP TABLE IF EXISTS `wct_hobbysub`; CREATE TABLE `wct_hobbysub` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `hobbyid` int(11) NULL DEFAULT NULL, `hobbyname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = Inn