高仿qq,服务器为openfire

      /*
SQLyog Community v8.4 Beta1
MySQL - 5.0.22-community-nt : Database - chatdb
*********************************************************************
*/


/*!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*/`chatdb` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;

USE `chatdb`;

/*Table structure for table `ofbookmark` */

DROP TABLE IF EXISTS `ofbookmark`;

CREATE TABLE `ofbookmark` (
  `bookmarkID` bigint(20) NOT NULL,
  `bookmarkType` varchar(50) collate utf8_bin NOT NULL,
  `bookmarkName` varchar(255) collate utf8_bin NOT NULL,
  `bookmarkValue` varchar(255) collate utf8_bin NOT NULL,
  `isGlobal` int(11) NOT NULL,
  PRIMARY KEY  (`bookmarkID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofbookmark` */

/*Table structure for table `ofbookmarkperm` */

DROP TABLE IF EXISTS `ofbookmarkperm`;

CREATE TABLE `ofbookmarkperm` (
  `bookmarkID` bigint(20) NOT NULL,
  `bookmarkType` tinyint(4) NOT NULL,
  `name` varchar(255) collate utf8_bin NOT NULL,
  PRIMARY KEY  (`bookmarkID`,`name`,`bookmarkType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofbookmarkperm` */

/*Table structure for table `ofbookmarkprop` */

DROP TABLE IF EXISTS `ofbookmarkprop`;

CREATE TABLE `ofbookmarkprop` (
  `bookmarkID` bigint(20) NOT NULL,
  `name` varchar(100) collate utf8_bin NOT NULL,
  `propValue` text collate utf8_bin NOT NULL,
  PRIMARY KEY  (`bookmarkID`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofbookmarkprop` */

/*Table structure for table `ofextcomponentconf` */

DROP TABLE IF EXISTS `ofextcomponentconf`;

CREATE TABLE `ofextcomponentconf` (
  `subdomain` varchar(255) collate utf8_bin NOT NULL,
  `wildcard` tinyint(4) NOT NULL,
  `secret` varchar(255) collate utf8_bin default NULL,
  `permission` varchar(10) collate utf8_bin NOT NULL,
  PRIMARY KEY  (`subdomain`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofextcomponentconf` */

/*Table structure for table `ofgroup` */

DROP TABLE IF EXISTS `ofgroup`;

CREATE TABLE `ofgroup` (
  `groupName` varchar(50) collate utf8_bin NOT NULL,
  `description` varchar(255) collate utf8_bin default NULL,
  PRIMARY KEY  (`groupName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofgroup` */

/*Table structure for table `ofgroupprop` */

DROP TABLE IF EXISTS `ofgroupprop`;

CREATE TABLE `ofgroupprop` (
  `groupName` varchar(50) collate utf8_bin NOT NULL,
  `name` varchar(100) collate utf8_bin NOT NULL,
  `propValue` text collate utf8_bin NOT NULL,
  PRIMARY KEY  (`groupName`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofgroupprop` */

/*Table structure for table `ofgroupuser` */

DROP TABLE IF EXISTS `ofgroupuser`;

CREATE TABLE `ofgroupuser` (
  `groupName` varchar(50) collate utf8_bin NOT NULL,
  `username` varchar(100) collate utf8_bin NOT NULL,
  `administrator` tinyint(4) NOT NULL,
  PRIMARY KEY  (`groupName`,`username`,`administrator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofgroupuser` */

/*Table structure for table `ofid` */

DROP TABLE IF EXISTS `ofid`;

CREATE TABLE `ofid` (
  `idType` int(11) NOT NULL,
  `id` bigint(20) NOT NULL,
  PRIMARY KEY  (`idType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofid` */

insert  into `ofid`(`idType`,`id`) values (18,191),(19,25),(23,1),(25,151),(26,2);

/*Table structure for table `ofmucaffiliation` */

DROP TABLE IF EXISTS `ofmucaffiliation`;

CREATE TABLE `ofmucaffiliation` (
  `roomID` bigint(20) NOT NULL,
  `jid` text collate utf8_bin NOT NULL,
  `affiliation` tinyint(4) NOT NULL,
  PRIMARY KEY  (`roomID`,`jid`(70))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofmucaffiliation` */

/*Table structure for table `ofmucconversationlog` */

DROP TABLE IF EXISTS `ofmucconversationlog`;

CREATE TABLE `ofmucconversationlog` (
  `roomID` bigint(20) NOT NULL,
  `sender` text collate utf8_bin NOT NULL,
  `nickname` varchar(255) collate utf8_bin default NULL,
  `logTime` char(15) collate utf8_bin NOT NULL,
  `subject` varchar(255) collate utf8_bin default NULL,
  `body` text collate utf8_bin,
  KEY `ofMucConversationLog_time_idx` (`logTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofmucconversationlog` */

/*Table structure for table `ofmucmember` */

DROP TABLE IF EXISTS `ofmucmember`;

CREATE TABLE `ofmucmember` (
  `roomID` bigint(20) NOT NULL,
  `jid` text collate utf8_bin NOT NULL,
  `nickname` varchar(255) collate utf8_bin default NULL,
  `firstName` varchar(100) collate utf8_bin default NULL,
  `lastName` varchar(100) collate utf8_bin default NULL,
  `url` varchar(100) collate utf8_bin default NULL,
  `email` varchar(100) collate utf8_bin default NULL,
  `faqentry` varchar(100) collate utf8_bin default NULL,
  PRIMARY KEY  (`roomID`,`jid`(70))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofmucmember` */

/*Table structure for table `ofmucroom` */

DROP TABLE IF EXISTS `ofmucroom`;

CREATE TABLE `ofmucroom` (
  `serviceID` bigint(20) NOT NULL,
  `roomID` bigint(20) NOT NULL,
  `creationDate` char(15) collate utf8_bin NOT NULL,
  `modificationDate` char(15) collate utf8_bin NOT NULL,
  `name` varchar(50) collate utf8_bin NOT NULL,
  `naturalName` varchar(255) collate utf8_bin NOT NULL,
  `description` varchar(255) collate utf8_bin default NULL,
  `lockedDate` char(15) collate utf8_bin NOT NULL,
  `emptyDate` char(15) collate utf8_bin default NULL,
  `canChangeSubject` tinyint(4) NOT NULL,
  `maxUsers` int(11) NOT NULL,
  `publicRoom` tinyint(4) NOT NULL,
  `moderated` tinyint(4) NOT NULL,
  `membersOnly` tinyint(4) NOT NULL,
  `canInvite` tinyint(4) NOT NULL,
  `roomPassword` varchar(50) collate utf8_bin default NULL,
  `canDiscoverJID` tinyint(4) NOT NULL,
  `logEnabled` tinyint(4) NOT NULL,
  `subject` varchar(100) collate utf8_bin default NULL,
  `rolesToBroadcast` tinyint(4) NOT NULL,
  `useReservedNick` tinyint(4) NOT NULL,
  `canChangeNick` tinyint(4) NOT NULL,
  `canRegister` tinyint(4) NOT NULL,
  PRIMARY KEY  (`serviceID`,`name`),
  KEY `ofMucRoom_roomid_idx` (`roomID`),
  KEY `ofMucRoom_serviceid_idx` (`serviceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofmucroom` */

/*Table structure for table `ofmucroomprop` */

DROP TABLE IF EXISTS `ofmucroomprop`;

CREATE TABLE `ofmucroomprop` (
  `roomID` bigint(20) NOT NULL,
  `name` varchar(100) collate utf8_bin NOT NULL,
  `propValue` text collate utf8_bin NOT NULL,
  PRIMARY KEY  (`roomID`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofmucroomprop` */

/*Table structure for table `ofmucservice` */

DROP TABLE IF EXISTS `ofmucservice`;

CREATE TABLE `ofmucservice` (
  `serviceID` bigint(20) NOT NULL,
  `subdomain` varchar(255) collate utf8_bin NOT NULL,
  `description` varchar(255) collate utf8_bin default NULL,
  `isHidden` tinyint(4) NOT NULL,
  PRIMARY KEY  (`subdomain`),
  KEY `ofMucService_serviceid_idx` (`serviceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `ofmucservice` */

insert  into `ofmucservice`(`serviceID`,`subdomain`,`description`,`isHidden`) values (1,'conference',NULL,0);

/*Table structure for table `ofmucserviceprop` */

DROP TABLE IF EXISTS `