PeterAlbus
/
SocialPractiseManagementSys
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
DEV
main
1.0-SNAPSHOT
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
SocialPractiseManagementSys/sql/social_practice_sys_test_da...

120 lines
18 KiB
MySQL
Raw Permalink Normal View History Unescape Escape

update sql
3 years ago
CREATE DATABASE IF NOT EXISTS `social_practice_sys` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `social_practice_sys`;
-- MySQL dump 10.13 Distrib 8.0.25, for Win64 (x86_64)
--
-- Host: www.peteralbus.com Database: social_practice_sys
-- ------------------------------------------------------
-- Server version 8.0.23
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `activity`
--
LOCK TABLES `activity` WRITE;
/*!40000 ALTER TABLE `activity` DISABLE KEYS */;
INSERT INTO `activity` VALUES (1471003733598167042,'社会实践活动测试','暖心公益','请参与该活动进行社会实践体验',2,12,1,'2021-12-15 14:26:35','2021-12-21 13:27:17',1),(1471006403608207361,'一个社会实践活动测试','阳光社区','请华山派弟子多多参加，锻炼自己！',2,12,2,'2021-12-15 14:37:11','2021-12-21 20:00:01',0),(1471070570541260801,'帮助老人打扫房间','阳光社区','大学生参加社会实践，了解社会、认识国情，增长才干、奉献社会，锻炼毅力、培养品格，对于加深对邓小平理论和“三个代表”重要思想的理解，深化对党的路线方针政策的认识，坚定在中国共产党领导下，走中国特色社会主义道路，实现中华民族伟大复兴的共同理想和信念，增强历史使命感和社会责任感，具有不可替代的重要作用。',1,12,1,'2021-12-15 18:52:10','2021-12-15 18:52:10',0),(1471356997938208769,'帮吴兴识写档案','暖心公益','党章中规定党员有下列义务：认真学习马克思列宁主义、毛泽东思想，学习党的基本知识和党的路线、方针、政策和决议，学习科学，文化和业务；坚持党和人民的利益高于一切，个人利益服从党和人民的利益；执行党的决定，服从组织分配；维护党的团结和统一等。',1,12,1,'2021-12-16 13:50:19','2021-12-16 13:50:20',0),(1472193438482194433,'扫大街','暖心公益','帮辛苦的环卫工人们进行劳动工作！',1,12,1,'2021-12-18 21:14:02','2021-12-18 21:14:02',0),(1472194243511738369,'探访养老院','阳光社区','慰问孤寡老人，给与温暖和关心',4,8,1,'2021-12-18 21:17:14','2021-12-21 12:03:38',0),(1472573328322760705,'扫厕所','阳光社区','辛苦工作',1,12,1,'2021-12-19 22:23:35','2021-12-19 22:23:35',0),(1472576652371591169,'321','暖心公益','123312',1,12,1,'2021-12-19 22:36:48','2021-12-19 22:36:48',1),(1472576717941145602,'321','阳光社区','21313',1,12,1,'2021-12-19 22:37:03','2021-12-19 22:37:03',1),(1472857727215923201,'帮河鱼打扫房间?','暖心公益','这是对河鱼的奖励！只有一个人可以报名！',1,1,1,'2021-12-20 17:13:41','2021-12-20 17:13:41',0),(1472857974679859202,'帮劳资的女朋友烧饭','阳光社区','呵呵，不报名的别想入党?',1,12,1,'2021-12-20 17:14:40','2021-12-20 17:14:40',0),(1473617643866189825,'帮hyc洗衣服','暖心公益','我爱劳动',1,16,1,'2021-12-22 19:33:19','2021-12-22 19:33:19',0),(1473984085396303873,'?','阳光社区','?',1,12,1,'2021-12-23 19:49:26','2021-12-23 19:49:26',1),(1473984116148940802,'?','阳光社区','?',1,12,1,'2021-12-23 19:49:33','2021-12-23 19:49:33',0);
/*!40000 ALTER TABLE `activity` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `group`
--
LOCK TABLES `group` WRITE;
/*!40000 ALTER TABLE `group` DISABLE KEYS */;
INSERT INTO `group` VALUES (1472398506099810306,'华山组',1468460994968981505,1471003733598167042,1,'2021-12-19 10:48:54','2021-12-19 10:48:54',1),(1472529404019425281,'华山组',1468460994968981505,1471070570541260801,1,'2021-12-19 19:29:03','2021-12-19 19:29:03',0),(1472858233690714114,'???',1472856951055773698,1472857727215923201,1,'2021-12-20 17:15:42','2021-12-20 17:15:42',0),(1472903300358922242,'侠',1468460994968981505,1472194243511738369,1,'2021-12-20 20:14:47','2021-12-20 20:14:47',0),(1472946593872527361,'hyc讨厌ljh',1468460994968981505,1472857974679859202,1,'2021-12-20 23:06:49','2021-12-23 19:23:13',1),(1473540628286820353,'岳组',1472557280903118850,1471356997938208769,1,'2021-12-22 14:27:18','2021-12-22 14:27:18',0),(1473671605499752450,'213',1468460994968981505,1471006403608207361,1,'2021-12-22 23:07:45','2021-12-22 23:07:45',1),(1473671668871491586,'213',1468460994968981505,1472193438482194433,1,'2021-12-22 23:08:00','2021-12-22 23:08:00',1);
/*!40000 ALTER TABLE `group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `manage`
--
LOCK TABLES `manage` WRITE;
/*!40000 ALTER TABLE `manage` DISABLE KEYS */;
INSERT INTO `manage` VALUES (1471003735829536770,1471003733598167042,1469628381600796673,1,'2021-12-15 14:26:35','2021-12-15 14:26:35',1),(1471006403662733314,1471006403608207361,1469628381600796673,1,'2021-12-15 14:37:11','2021-12-15 14:37:11',0),(1471070571006828545,1471070570541260801,1469628381600796673,1,'2021-12-15 18:52:10','2021-12-15 18:52:10',0),(1471084992567484418,1471070570541260801,1471082273513447426,1,'2021-12-15 19:49:28','2021-12-15 19:49:28',0),(1471357000878415873,1471356997938208769,1469628381600796673,1,'2021-12-16 13:50:20','2021-12-16 13:50:20',0),(1472193439413329921,1472193438482194433,1469628381600796673,1,'2021-12-18 21:14:03','2021-12-18 21:14:03',0),(1472194243612401666,1472194243511738369,1469628381600796673,1,'2021-12-18 21:17:14','2021-12-18 21:17:14',0),(1472573329228730369,1472573328322760705,1471082273513447426,1,'2021-12-19 22:23:35','2021-12-19 22:23:35',0),(1472576653193674754,1472576652371591169,1469628381600796673,1,'2021-12-19 22:36:48','2021-12-19 22:36:48',1),(1472576718008254466,1472576717941145602,1469628381600796673,1,'2021-12-19 22:37:03','2021-12-19 22:37:03',1),(1472857727278837761,1472857727215923201,1471088947431251969,1,'2021-12-20 17:13:41','2021-12-20 17:13:41',0),(1472857974755356674,1472857974679859202,1471088947431251969,1,'2021-12-20 17:14:40','2021-12-20 17:14:40',0),(1473140383329599490,1471003733598167042,1471088947431251969,1,'2021-12-21 11:56:52','2021-12-21 11:56:52',1),(1473617643933298690,1473617643866189825,1469628381600796673,1,'2021-12-22 19:33:19','2021-12-22 19:33:19',0),(1473984085467607042,1473984085396303873,1473983627780960257,1,'2021-12-23 19:49:26','2021-12-23 19:49:26',1),(1473984116169912322,1473984116148940802,1473983627780960257,1,'2021-12-23 19:49:33','2021-12-23 19:49:33',0);
/*!40000 ALTER TABLE `manage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `message`
--
LOCK TABLES `message` WRITE;
/*!40000 ALTER TABLE `message` DISABLE KEYS */;
INSERT INTO `message` VALUES (1,'123',1468460994968981505,'1','666',1,2,'2021-12-22 13:39:25','2021-12-22 14:11:22',0),(1473540826367021058,'小组申请通过通知',1468460994968981505,'系统','先前申请社会实践小组的申请通过了！快去看看！',1,5,'2021-12-22 14:28:05','2021-12-22 19:24:35',0),(1473616720880234498,'新的活动记录',1469628381600796673,'系统','你管理的活动有学生提交了新的活动记录！（活动id：1471356997938208769）',1,2,'2021-12-22 19:29:39','2021-12-22 19:30:44',0),(1473620077166489602,'社会实践活动评分',1468460994968981505,'系统','老师对你参与的社会实践活动进行了打分，快去看看！（活动id：1471356997938208769）',1,2,'2021-12-22 19:43:00','2021-12-22 19:43:18',0),(1473620077212626946,'社会实践活动评分',1472557280903118850,'系统','老师对你参与的社会实践活动进行了打分，快去看看！（活动id：1471356997938208769）',1,2,'2021-12-22 19:43:00','2021-12-23 14:08:07',0),(1474398537530748929,'新的小组申请',1472856951055773698,'系统','你的小组???有新的组员想要申请加入！你可以前往该活动的管理页面查看（活动id：1472857727215923201）',1,2,'2021-12-24 23:16:19','2021-12-24 23:16:59',0),(1474398754627923970,'小组申请通过通知',1472557280903118850,'系统','先前申请社会实践小组的申请通过了！快去看看！（活动id：1472857727215923201）',1,2,'2021-12-24 23:17:11','2021-12-25 10:13:31',0),(1474398909636816897,'新的活动记录',1471088947431251969,'系统','你管理的活动有学生提交了新的活动记录！（活动id：1472857727215923201）',1,2,'2021-12-24 23:17:48','2021-12-24 23:18:23',0),(1474564073216819202,'新的小组申请',1472856951055773698,'系统','你的小组???有新的组员想要申请加入！你可以前往该活动的管理页面查看（活动id：1472857727215923201）',0,1,'2021-12-25 10:14:06','2021-12-25 10:14:06',0);
/*!40000 ALTER TABLE `message` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `participate`
--
LOCK TABLES `participate` WRITE;
/*!40000 ALTER TABLE `participate` DISABLE KEYS */;
INSERT INTO `participate` VALUES (1472398507060305922,1468460994968981505,1471003733598167042,1472398506099810306,1,1,3,'2021-12-19 10:48:55','2021-12-21 15:17:15',1),(1472529404786982914,1468460994968981505,1471070570541260801,1472529404019425281,1,1,3,'2021-12-19 19:29:03','2021-12-21 16:11:21',0),(1472559383516102658,1472557280903118850,1471003733598167042,1472398506099810306,1,1,4,'2021-12-19 21:28:11','2021-12-21 15:17:15',1),(1472858233774600193,1472856951055773698,1472857727215923201,1472858233690714114,0,1,1,'2021-12-20 17:15:42','2021-12-20 17:15:42',0),(1472903301147451394,1468460994968981505,1472194243511738369,1472903300358922242,0,1,1,'2021-12-20 20:14:47','2021-12-20 20:14:47',0),(1472903541514625025,1472557280903118850,1472194243511738369,1472903300358922242,0,0,1,'2021-12-20 20:15:44','2021-12-20 20:16:14',1),(1472904832093577217,1472557280903118850,1472194243511738369,1472903300358922242,0,1,2,'2021-12-20 20:20:52','2021-12-20 20:21:15',1),(1472946595923542017,1468460994968981505,1472857974679859202,1472946593872527361,0,1,1,'2021-12-20 23:06:49','2021-12-20 23:06:49',1),(1473221402799947778,1472557280903118850,1472194243511738369,1472903300358922242,0,0,1,'2021-12-21 17:18:48','2021-12-21 17:18:48',1),(1473221457799856130,1472557280903118850,1472194243511738369,1472903300358922242,0,1,2,'2021-12-21 17:19:01','2021-12-21 17:19:32',0),(1473540629184401410,1472557280903118850,1471356997938208769,1473540628286820353,1,1,2,'2021-12-22 14:27:18','2021-12-22 19:43:00',0),(1473540719617789954,1468460994968981505,1471356997938208769,1473540628286820353,1,1,3,'2021-12-22 14:27:39','2021-12-22 19:43:00',0),(1473671606338613250,1468460994968981505,1471006403608207361,1473671605499752450,0,1,1,'2021-12-22 23:07:45','2021-12-22 23:07:45',1),(1473671668963766273,1468460994968981505,1472193438482194433,1473671668871491586,0,1,1,'2021-12-22 23:08:00','2021-12-22 23:08:00',1),(1474398537472028673,1472557280903118850,1472857727215923201,1472858233690714114,0,1,2,'2021-12-24 23:16:19','2021-12-24 23:17:11',1),(1474564071966916610,1472557280903118850,1472857727215923201,1472858233690714114,0,0,1,'2021-12-25 10:14:05','2021-12-25 10:14:05',1);
/*!40000 ALTER TABLE `participate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `record`
--
LOCK TABLES `record` WRITE;
/*!40000 ALTER TABLE `record` DISABLE KEYS */;
INSERT INTO `record` VALUES (1472919575395086337,1472529404786982914,'帮老人打扫房间的体会','21312321312312',1,2,'2021-12-20 21:19:27','2021-12-21 13:47:05',0),(1472921707183648770,1472529404786982914,'22','33',1,2,'2021-12-20 21:27:55','2021-12-21 13:50:45',0),(1472946653242900482,1472946595923542017,'','',0,1,'2021-12-20 23:07:03','2021-12-20 23:07:03',1),(1472947091715440642,1472858233774600193,'恋爱的第一天','??????????????????????????????????????????????????????????????????????????????????????????????????????????????????',1,2,'2021-12-20 23:08:47','2021-12-23 18:53:35',0),(1473180204605419522,1472398507060305922,'123','123213',1,2,'2021-12-21 14:35:06','2021-12-21 14:36:11',1),(1473616718833414146,1473540719617789954,'写档案有感','党章中规定党员有下列义务：认真学习马克思列宁主义、毛泽东思想，学习党的基本知识和党的路线、方针、政策和决议，学习科学，文化和业务；坚持党和人民的利益高于一切，个人利益服从党和人民的利益；执行党的决定，服从组织分配；维护党的团结和统一等。',1,2,'2021-12-22 19:29:39','2021-12-22 19:42:46',0),(1474398909179637762,1474398537472028673,'213321','312321312',1,2,'2021-12-24 23:17:48','2021-12-24 23:18:18',1);
/*!40000 ALTER TABLE `record` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `score_group`
--
LOCK TABLES `score_group` WRITE;
/*!40000 ALTER TABLE `score_group` DISABLE KEYS */;
INSERT INTO `score_group` VALUES (1473188731017277442,1472398506099810306,1469628381600796673,5,1,'2021-12-21 15:08:59','2021-12-21 15:08:59',0),(1473203957070606338,1472529404019425281,1471082273513447426,3.5,1,'2021-12-21 16:09:29','2021-12-21 16:09:29',0),(1473204427952533506,1472529404019425281,1469628381600796673,1.5,1,'2021-12-21 16:11:21','2021-12-21 16:11:21',0),(1473620076449263617,1473540628286820353,1469628381600796673,3,1,'2021-12-22 19:42:59','2021-12-22 19:42:59',0);
/*!40000 ALTER TABLE `score_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `score_stu`
--
LOCK TABLES `score_stu` WRITE;
/*!40000 ALTER TABLE `score_stu` DISABLE KEYS */;
INSERT INTO `score_stu` VALUES (1473188731168272386,1472398507060305922,1469628381600796673,5,1,'2021-12-21 15:08:59','2021-12-21 15:08:59',0),(1473188731176660993,1472559383516102658,1469628381600796673,3,1,'2021-12-21 15:08:59','2021-12-21 15:08:59',0),(1473203957972381698,1472529404786982914,1471082273513447426,4,1,'2021-12-21 16:09:29','2021-12-21 16:09:29',0),(1473204428069974018,1472529404786982914,1469628381600796673,1.5,1,'2021-12-21 16:11:21','2021-12-21 16:11:21',0),(1473620076730281986,1473540629184401410,1469628381600796673,1,1,'2021-12-22 19:42:59','2021-12-22 19:42:59',0),(1473620076730281987,1473540719617789954,1469628381600796673,4,1,'2021-12-22 19:42:59','2021-12-22 19:42:59',0);
/*!40000 ALTER TABLE `score_stu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1467474435167854594,'PeterAlbus','4cbcef304a545bfc03e8bf868b376ed8','吴鸿','15000508468','https://www.peteralbus.com:8440/assets/social/5b01cc86-5c91-4a04-9249-7548e71b23e8.jpg_THUMB.jpg',0,'Hb@dxT',17,'2021-12-05 20:42:24','2021-12-23 20:01:14',0),(1468460994968981505,'独孤剑','e7840377f8f2a8e1f801d2d110298510','令狐冲','12300005678','https://www.peteralbus.com:8440/assets/social/fae7928d-4542-437a-962f-2d7a00367e46.jpg_THUMB.jpg',1,'DrSz!F',6,'2021-12-08 14:02:39','2021-12-23 15:07:09',0),(1469628381600796673,'华山君子','f99288fdd4a47c6e84ed634ad13844fd','岳不群','17317792001','https://www.peteralbus.com:8440/assets/social/098822f2-3ff8-4d2a-b13e-8f1fd4cea5cd.jpg_THUMB.jpg',2,'&NXkc&',2,'2021-12-11 19:21:25','2021-12-23 15:09:46',0),(1471082273513447426,'东邪','6bebabea663d53de76bb10023ab27171','黄药师','17788889999','https://www.peteralbus.com:8440/assets/social/avatar.jpg',2,'cvIGHf',1,'2021-12-15 19:38:40','2021-12-15 19:38:40',0),(1471088947431251969,'吴老板','3d9f99816934cc2b4685d099ce10638d','吴兴识','14844448888','https://www.peteralbus.com:8440/assets/social/03e9cf6e-21b4-402e-a936-446d4c39d91a.jpg_THUMB.jpg',2,'dcn$Yu',5,'2021-12-15 20:05:11','2021-12-23 20:06:36',0),(1472557280903118850,'小师妹','b8969aefd205019e862540ab47619b20','岳灵珊','18999886654','https://www.peteralbus.com:8440/assets/social/avatar.jpg',1,'*vIFYw',2,'2021-12-19 21:19:49','2021-12-21 20:33:00',0),(1472856951055773698,'cyh','11cf5d3226d75eb3aa5db91e673066a4','hyc','17315561883','https://www.peteralbus.com:8440/assets/social/avatar.jpg',1,'T!bciu',1,'2021-12-20 17:10:36','2021-12-20 17:10:36',0),(1473916887260999682,'admin','7fa9b6cc604dcfe2be25a653211891f6','上海海洋大学管理员','15266894321','https://www.peteralbus.com:8440/assets/social/7c0ae676-89ff-4ff4-8634-15b5346ac509.jpg_THUMB.jpg',0,'JkTJTi',1,'2021-12-23 15:22:25','2021-12-23 15:22:25',0),(1473924454318206978,'adminHua','4c2531d5cb5b55d495716fc6abb5f525','华山派管理员','78966665555','https://www.peteralbus.com:8440/assets/social/f39cd185-6d77-40ed-8dba-2d6b5696560a.jpg_THUMB.jpg',0,'pLUNmj',2,'2021-12-23 15:52:29','2021-12-23 15:52:50',0),(1473982642346012673,'jacklee','86222b16ec6892baff5473e04df727d7','李家豪','18621169006','https://www.peteralbus.com:8440/assets/social/avatar.jpg',2,'FtzDWq',1,'2021-12-23 19:43:42','2021-12-23 19:43:42',0),(1473982673853624321,'jacking','b01a0cae50e88348652fc16640c3dd3e','紫禁成','18655212863','https://www.peteralbus.com:8440/assets/social/avatar.jpg',2,'@NBumM',1,'2021-12-23 19:43:49','2021-12-23 19:43:49',0),(1473983627780960257,'whdb','b35c662adc0a2a245f1d8a00bef2d6c4','whdb','12345678910','https://www.peteralbus.com:8440/assets/social/51a12c7f-4c93-4aa0-841e-8d8bfe8068d6.jpg_THUMB.jpg',2,'&Unpnh',5,'2021-12-23 19:47:37','2021-12-25 16:14:38',0),(1473984166371536898,'wxs','5d57eb306b7d0f4c7616350be7e3029d','wxs','12345678901','https://www.peteralbus.com:8440/assets/social/avatar.jpg',1,'JvE*&c',1,'2021-12-23 19:49:45','2021-12-23 19:49:45',0);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-12-25 17:56:53