openfire数据库模式指南
导言
This document outlines the data type conventions and tables in the Openfire databa schema. Some information, like column indexes and foreign keys, is omitted.该文件概述了公约和数据类型中的表Openfire数据库架构。一些信息，比如列索引和外键，省略。 For this, plea read the individual schema of the databa you're interested in.为此，请参阅个别架构数据库您感兴趣
Data Type Conventions过春节的画数据类型公约
忽然的意思Date column type support varies widely across databas.日期柱式支持跨数据库的差别很大。 Therefore, Openfire specially encodes dates as VARCHAR values.因此， Openfire特殊编码日期VARCHAR价值观。Each date is a Java long value which is 0-padded to 15 characters.每一日期是基于Java的一种长期的价值是0 -棉衣为元宝怎么折15个字符。 The long value is the internal reprentation of Java Date objects, which can be obtained with code such as the following:长期价值是内部任职的红岩读后感800字Java日期物体，它可以得到的代码如下：
long currentDate = new Date().getTime();
布尔值都代表了数值： 0和1的虚假的真实。
数据库表
Below is a description of each of the tables in the Openfire databa schema. A denotes a primary key.以下是一个说明每个表格的Openfire数据库架构。黄色行表示主键。
∙ ofGroup
∙ ofGroupProp
∙ ofGroupUr
∙ ofID
∙ ofOffline
∙ ofPrence
∙ ofPrivate
∙ ofUr
∙ ofUrProp
∙ ofUrFlag
∙ ofRoster
∙ ofRosterGroups
∙ ofPrivacyList
∙ 崎岖不平ofVCard
∙ ofVersion
∙ ofProperty
∙ ofExtComponentConf
∙ ofRemoteServerConf
山合欢
∙ ofSecurityAuditLog
∙ ofMucService
∙ ofMucServiceProp
∙ ofMucRoom
阳雀菌∙ ofMucRoomProp
∙ ofMucAffiliation
∙ ofMucMember
∙ ofMucConversationLog
∙ ofPubsubNode
∙ ofPubsubNodeJIDs
∙ 爱和感恩 ofPubsubNodeGroups
∙ ofPubsubAffiliation
