openfire数据库模式指南

导言

This document outlines the data type conventions and tables in the Openfire database schema. Some information, like column indexes and foreign keys, is omitted.该文件概述了公约和数据类型中的表Openfire数据库架构。一些信息，比如列索引和外键，省略。?For this, please read the individual schema of the database you're interested in.为此，请参阅个别架构数据库您感兴趣

Data Type Conventions数据类型公约

Date column type support varies widely across databases.日期柱式支持跨数据库的差别很大。?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 representation of Java Date objects, which can be obtained with code such as the following:长期价值是内部任职的Java日期物体，它可以得到的代码如下：