Linux系统下基于Qt的局域网即时通信系统

-- MySQL dump 10.13 Distrib 5.5.34, for debian-linux-gnu (i686) -- -- Host: localhost Database: serverIMDB -- ------------------------------------------------------ -- Server version 5.5.34-0ubuntu0.12.04.1 /*!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 */; /*!40101 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 */; -- -- Table structure for table `DateCounter` -- DROP TABLE IF EXISTS `DateCounter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `DateCounter` ( `date` date NOT NULL, `userTimes` int(11) NOT NULL, `flockTimes` int(11) NOT NULL, `discussionTimes` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='utf8_general_ci'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `DateCounter` -- LOCK TABLES `DateCounter` WRITE; /*!40000 ALTER TABLE `DateCounter` DISABLE KEYS */; INSERT INTO `DateCounter` VALUES ('2014-05-07',4,4,0),('2014-05-08',0,0,4),('2014-05-09',0,1,17),('2014-05-10',0,6,11),('2014-05-11',0,1,3),('2014-05-13',0,1,0),('2014-05-17',1,1,1),('2014-05-18',0,3,1),('2014-05-24',0,2,0); /*!40000 ALTER TABLE `DateCounter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `DiscussionInformation` -- DROP TABLE IF EXISTS `DiscussionInformation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `DiscussionInformation` ( `discussionID` varchar(15) NOT NULL, `creatorID` varchar(15) NOT NULL, `createDate` date NOT NULL, `discussionName` varchar(50) NOT NULL, `theme` varchar(100) NOT NULL, PRIMARY KEY (`discussionID`), KEY `UserInformation_DiscussionInformation_creatorID` (`creatorID`), CONSTRAINT `UserInformation_DiscussionInformation_creatorID` FOREIGN KEY (`creatorID`) REFERENCES `UserInformation` (`userID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='utf8_general_ci'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `DiscussionInformation` -- LOCK TABLES `DiscussionInformation` WRITE; /*!40000 ALTER TABLE `DiscussionInformation` DISABLE KEYS */; INSERT INTO `DiscussionInformation` VALUES ('2014051121','2014050702','2014-05-11','dddd','ddd'),('2014051123','2014050703','2014-05-11','apple的IM讨论组','没有主题'),('2014051721','2014051701','2014-05-17','haa的IM讨论组','没有主题'),('2014051821','2014051701','2014-05-18','haa的IM讨论组','没有主题'); /*!40000 ALTER TABLE `DiscussionInformation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FlockInformation` -- DROP TABLE IF EXISTS `FlockInformation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `FlockInformation` ( `flockID` varchar(15) NOT NULL, `creatorID` varchar(15) NOT NULL, `createDate` date NOT NULL, `flockName` varchar(50) NOT NULL, `theme` varchar(100) NOT NULL, PRIMARY KEY (`flockID`), KEY `UserInformation_FlockInformation_creatorID` (`creatorID`), CONSTRAINT `UserInformation_FlockInformation_creatorID` FOREIGN KEY (`creatorID`) REFERENCES `UserInformation` (`userID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='utf8_general_ci'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `FlockInformation` -- LOCK TABLES `FlockInformation` WRITE; /*!40000 ALTER TABLE `FlockInformation` DISABLE KEYS */; INSERT INTO `FlockInformation` VALUES ('2014051111','2014050702','2014-05-11','sdfsdfsd','sdfsd'),('2014051311','2014050701','2014-05-13','yun的IM群','没有主题'),('2014051711','2014051701','2014-05-17','haa的IM群','没有主题'),('2014051811','2014050704','2014-05-18','mick的IM群','没有主题'),('2014051812','2014051701','2014-05-18','haafgf的IM群','没有主题'),('2014051813','2014050701','2014-05-18','雨舒意的IM群','没有主题'),('2014052411','2014050703','2014-05-24','apple的IM群','没有主题'),('2014052412','2014050702','2014-05-24','dd','没有主题'); /*!40000 ALTER TABLE `FlockInformation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FlockSpace` -- DROP TABLE IF EXISTS `FlockSpace`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `FlockSpace` ( `flockSpaceNum` int(11) NOT NULL AUTO_INCREMENT, `flockID` varchar(15) NOT NULL, `fileType` varchar(20) NOT NULL, `filePath` varchar(50) NOT NULL, `fileName` varchar(50) NOT NULL, `fileInformation` varchar(100) DEFAULT NULL, `senderID` varchar(15) NOT NULL, `downloadTimes` int(11) NOT NULL, PRIMARY KEY (`flockSpaceNum`), KEY `FlockInformation_FlockSpace_flockID` (`flockID`), KEY `UserInformation_FlockSpace_senderID` (`senderID`), CONSTRAINT `FlockInformation_FlockSpace_flockID` FOREIGN KEY (`flockID`) REFERENCES `FlockInformation` (`flockID`), CONSTRAINT `UserInformation_FlockSpace_senderID` FOREIGN KEY (`senderID`) REFERENCES `UserInformation` (`userID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `FlockSpace` -- LOCK TABLES `FlockSpace` WRITE; /*!40000 ALTER TABLE `FlockSpace` DISABLE KEYS */; /*!40000 ALTER TABLE `FlockSpace` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `HistoryMessage` -- DROP TABLE IF EXISTS `HistoryMessage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `HistoryMessage` ( `messageID` int(11) NOT NULL AUTO_INCREMENT, `senderID` varchar(15) NOT NULL, `receiverID` varchar(15) NOT NULL, `content` varchar(1000) NOT NULL DEFAULT '', `dateTime` datetime NOT NULL, PRIMARY KEY (`messageID`), KEY `UserInformation_HistoryMessage_senderID` (`senderID`), KEY `UserInformation_HistoryMessage_receiverID` (`receiverID`), CONSTRAINT `UserInformation_HistoryMessage_receiverID` FOREIGN KEY (`receiverID`) REFERENCES `UserInformation` (`userID`), CONSTRAINT `UserInformation_HistoryMessage_senderID` FOREIGN KEY (`senderID`) REFERENCES `UserInformation` (`userID`) ) ENGINE=InnoDB AUTO_INCREMENT=374 DEFAULT CHARSET=utf8 COMMENT='utf8_general_ci'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `HistoryMessage` -- LOCK TABLES `HistoryMessage` WRITE; /*!40000 ALTER TABLE `HistoryMessage` DISABLE KEYS */; INSERT INTO `HistoryMessage` VALUES (202,'2014050702','2014050701','erer','2014-05-21 22:24:22'),(203,'2014050702','2014050701','rtrtrtrtrtrtrrt','2014-05-21 22:24:30'),(204,'2014050701','2014050702','hgjghjgh','2014-05-21 22:33:59'),(205,'2014050701','2014050702','ghjgh','2014-05-21 22:34:10'),(206,'2014050701','2014050702','sdfds','2014-05-21 22:35:20'),(207,'2014050701','2014050702','sdfdsfsd','2014-05-21 22:35:36'),(208,'2014050702','2014050701','.m,','2014-05-21 22:36:33'),(209,'2014050702','2014050703','m,.m,','2014-05-21 22:36:48'),(210,'2014050702','2014050701','ghjfg','2014-05-21 22:37:15'),(211,'2014050702','2014050701','ghjgh','2014-05-21 22:37:16'),(212,'2014050702','2014050701','ghjghghjghghjghj','2014-05-21 22:37:33'),(213,'2014050702','2014050701','ghjghjghghjgh','2014-05-21 22:37:39'),(214,'2014050702','2014050701','ghjgh','2014-05-21 22:37:45'),(215,'2014050702','2014050701','dfgdf','2014-05-21 22:52:42'),(216,'2014050701','2014050702','dsfg','2014-05-21 23:07:01'),(217,'2014050701','2014050702','dsfgsdfgsd','2014-05-21 23:07:02'),(218,'2014