SSM校园通讯管理系统带数据库.rar

/* SQLyog v10.2 MySQL - 5.5.27 : Database - school ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!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 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`school` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `school`; /*Table structure for table `answer` */ DROP TABLE IF EXISTS `answer`; CREATE TABLE `answer` ( `id` char(50) DEFAULT NULL, `nid` char(50) DEFAULT NULL COMMENT '消息id', `uid` char(50) DEFAULT NULL COMMENT '用户id unitinfo的id', `flag` int(10) DEFAULT '0' COMMENT '0未处理 1已处理', `vote` int(10) DEFAULT NULL COMMENT ' 1同意 2不同意 ', `reason` varchar(500) DEFAULT NULL COMMENT '理由' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='回复表'; /*Data for the table `answer` */ insert into `answer`(`id`,`nid`,`uid`,`flag`,`vote`,`reason`) values ('0d61ad22-e183-4af2-8ccb-51a1d117fa07','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','3d7dc2bf-5e1c-4c87-87be-c78c1001f400',1,NULL,NULL),('a3335893-fa94-422f-aea8-76aaa5c4fe80','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','fd0c12c5-90fa-4403-b1a6-49b56120bdee',0,1,NULL),('fe405633-230c-4c81-871d-3d146adcd27e','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','674ee893-5278-4873-8daa-a5e544284eb5',0,0,NULL),('90dcdfd9-2945-48f7-8000-ae2eacff4c5a','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','97b34369-e9b2-499d-a8c8-07f14ed52ecf',0,NULL,NULL),('0f83a7bb-c79d-4c85-b45b-cf8e7e3d22c9','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','2d020f11-6755-4776-bd39-af9dcf386b72',0,NULL,NULL),('55dfb732-b70c-489f-9d4a-370699c08eb5','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','df4fd0a0-a5c9-4a8c-baa5-bc95cee50212',0,NULL,NULL),('5cc8672c-220e-4e3f-a6b7-e41f8d529b85','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','230d01ed-74e6-4438-b61b-ec94c335456f',0,NULL,NULL),('40e7accc-2f2b-4d07-9fbd-b57b3c9987d0','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','244d12c3-727d-4635-a8f5-a7fc22b76546',0,NULL,NULL),('b173427c-9b3e-4281-b0a1-cedea25f530f','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','4a0e0237-ea41-4880-92a9-07ddeb7a7dd2',0,NULL,NULL),('171c29a8-df25-4979-b2bf-ea37fd2124b7','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','2d9adf14-2200-4cba-846b-2272fb7d721d',0,NULL,NULL),('304401d5-54c9-4738-b239-2f8245564ec1','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','eb2f93ee-133b-4ff7-b483-88ed28880b78',0,NULL,NULL),('f016a48c-5eec-43e5-a3e1-771c7b2bc9ed','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','8d295ff8-0136-4b9f-b44e-54a4f9d16d43',0,NULL,NULL),('0a866cdc-2f66-4b22-aaea-756f50026d67','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','288cae76-1565-4459-b947-a32525d0ff18',0,NULL,NULL),('f7790702-bbe0-4c29-9940-04b60a3d8fb9','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','b62308f7-cf0c-4279-9a48-ad3ded9372de',0,NULL,NULL),('211897de-a64a-42c2-b58b-630c8e804f7a','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','ee0550a9-979b-498f-8a88-3b1f47be0712',0,NULL,NULL),('02be2009-538d-4b5b-b14d-c530b2c35aa4','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','a88249d7-8b2b-42c1-a20a-aa246f624563',0,NULL,NULL),('c71159fa-0c90-4864-911a-4f63eb150007','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','a9ef58f5-1352-4846-a17f-570940662416',0,NULL,NULL),('c8aa0f7e-aa72-4c7e-81cb-9638f5bc9843','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','378851c8-bd4f-4a5a-ae86-b8a691685318',0,NULL,NULL),('d197dab1-a46f-4d5e-b20e-c79bdf224643','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','663814f2-f30d-4998-a194-699096727a54',1,1,NULL),('defd6eae-0e92-4ce2-9001-d0a6022f86e3','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','0d6bcc46-4d95-4e04-99b0-66939cbc2952',0,NULL,NULL),('b7a30870-c5ef-4a23-9497-5c3353e02f75','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','f8a30b65-9bdf-4f01-a39e-8983537d4a3f',1,2,NULL),('16f2fb36-8330-4729-b824-2a569ad0dbc1','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','b9a4457f-44e2-4ad0-84a9-8008d722f8f1',0,NULL,NULL),('7808e2ad-306f-4608-badf-55cab56575c8','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','0b1c3f81-0d7c-4849-8e06-5636f7f994cc',0,NULL,NULL),('64deead3-616c-436f-a16a-5ed7d3cb37fc','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','d041c2d9-e585-4d69-a8ec-0cc9d0b33c59',0,NULL,NULL),('faaf4bec-6105-4bfc-9ac5-82568a17db0d','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','32d191ab-65f3-48db-a590-a916dfafca31',0,NULL,NULL),('892d86fb-0efd-4329-a447-799ee7e1d6e7','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','187c2fea-0f26-45bc-995f-7042cb50dc45',0,NULL,NULL),('d4fd74dd-df25-4c37-b652-ae143f6b2ac6','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','3bfdab91-60c0-475c-92ab-2980a4941991',0,NULL,NULL),('51cda500-7cfe-49ce-9032-1681952acdf1','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','9bbf7c58-3eb4-46cf-9807-06b6272ab4f1',0,NULL,NULL),('83328f89-2481-4673-82db-b40cfd377db5','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','5362e707-8b13-4b8d-a0fe-4cb7b1e15e57',0,NULL,NULL),('3ecf3a0d-0ee2-476f-89d4-deedd264676a','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','fdff7682-85b7-4de9-aba9-04787c197e7a',0,NULL,NULL),('4fe4ab8b-0db1-4692-b581-8683feb2f901','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','4a7754cf-9017-4122-899e-ee9d9f2d29b9',0,NULL,NULL),('613e216d-6ef6-4430-9d6c-da9965169581','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','130b0534-daeb-4ba6-95d3-586ca2bea495',0,NULL,NULL),('f7698296-44e7-4517-9440-272247d41601','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','295db42e-79a6-4538-a1d5-1ffa09a69192',0,NULL,NULL),('d75a68b6-30ae-4900-8b5a-003409e460d4','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','acd92ea1-6302-4d91-b7fb-3bc6f3ea400d',0,NULL,NULL),('016fc250-3338-441d-a7a2-4836740309b4','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','cdea074c-8a29-4cde-a979-284e40b370ea',0,NULL,NULL),('111f627b-25d5-4270-95a8-6dd76ad87b17','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','e3e1a8a0-23bc-44fd-84b0-3269d8843a2c',0,NULL,NULL),('87f52e3c-c61c-4553-9b13-b344a621104f','556d8c8e-a1f9-4a1b-9f9a-fc652445acd8','695f63db-91cc-4a5e-b428-43511536bbf5',0,NULL,NULL),('d6c60340-238b-48f6-a202-366fc81ba7a1','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','3a62e52f-2980-404d-a0b5-81b69888954b',0,NULL,NULL),('78e90e29-8b72-416f-bb2e-1fa1d2ffcfb6','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','f19d23b1-a83b-4450-bc8b-13cb0c33cd08',0,NULL,NULL),('744f5630-dda5-4f33-a66f-5f4f1cb4f135','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','4bd2e038-c614-4aff-92e8-3bda025d1a3b',0,NULL,NULL),('4293d289-9c90-44b5-8691-e81f88ef116a','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','e3f3bf75-6d71-49e3-92f8-18e700853466',1,1,NULL),('99059379-34f0-44c6-9bc1-88d495a1d3ba','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','02bdcc2a-c368-4008-8742-d490d4e9eec3',0,NULL,NULL),('0ba12d99-741d-4bd4-81e5-6fa72994d3ec','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','ab1f2be3-beb3-4836-bea0-4de830f1b002',0,NULL,NULL),('3463b024-b825-4f26-9bf6-17105cff44ae','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','09d2ddf8-3522-4f8c-90ca-1bcca6240cf1',0,NULL,NULL),('aa51459f-15ed-4b6f-9395-7f793a7de6c7','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','820ec4f4-20b9-4dd8-81f8-79453a8880ff',0,NULL,NULL),('7b720446-a700-4061-9aa2-52bcb8f9fddc','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','8c089b95-70b3-4e62-84d9-9a41cd0ec23b',0,NULL,NULL),('0660fe42-d9f4-49dc-8aef-9bb4d88216cc','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','bf398f44-34ac-446c-83c4-d2684f88da70',0,NULL,NULL),('f25adf15-b29b-4e52-86ee-44dd48322541','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','ba1fff51-46c8-4eaa-8329-646ac4eed151',0,NULL,NULL),('b16f64c0-7f68-4fa4-bf9c-9b0f195a77af','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','3109697f-e320-4cb0-bfa4-d6d0128b9523',0,NULL,NULL),('e6b003d0-d762-44c4-8a34-0b415e69c323','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','0a67b72a-74e1-4808-89ce-3490ff3eeffb',0,NULL,NULL),('7c15bf0b-b17b-4725-a5bc-7020567f4e1b','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','0d33db98-6ae6-48ab-bd6e-11b7128c632a',0,NULL,NULL),('abbcb433-a358-4e53-b808-67e1281c4e89','eefbfafc-baa4-4f7a-bc8c-6aece302eca4','9d3eb634-da1d-4dfd-a700-178be59fc624',0,NULL,NULL),('1e6