From c40f6060da9c014135e70f165fa7adbfb127bcf2 Mon Sep 17 00:00:00 2001 From: Haakon Meland Eriksen Date: Fri, 6 Nov 2015 17:26:04 +0100 Subject: Hubzilla report created by schemaSpy using zot.meta.xml to imply relationships --- doc/schemaspy_hubzilla/columns.bySize.html | 7375 ++++++++++++++++++++++++++++ 1 file changed, 7375 insertions(+) create mode 100644 doc/schemaspy_hubzilla/columns.bySize.html (limited to 'doc/schemaspy_hubzilla/columns.bySize.html') diff --git a/doc/schemaspy_hubzilla/columns.bySize.html b/doc/schemaspy_hubzilla/columns.bySize.html new file mode 100644 index 000000000..9b31cfa9a --- /dev/null +++ b/doc/schemaspy_hubzilla/columns.bySize.html @@ -0,0 +1,7375 @@ + + + + + SchemaSpy - zot - Columns + + + + + + +
+ +
+
+ + + + + +
SchemaSpy Analysis of zot - Columns +2015-11-04 - Hubzilla database schema with some corrected cross-table relationships supporting decentralized publishing. Haakon Meland Eriksen. +Generated by
SchemaSpy
+ + +
+Generated by SchemaSpy on fr nov 06 17:11 CET 2015 + + + + + + + +
Legend:SourceForge.net
+ + + + +
Primary key columns
Columns with indexes
+
+
+ + +
+  +
+

+

+ + +
+
+
+zot contains 727 columns - click on heading to sort: + +++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
TableColumnTypeSizeNullsAutoDefaultComments
eventadjustbit01
channelchannel_primarybit00
channelchannel_removedbit00
channelchannel_systembit00
groupsdeletedbit00
addonhiddenbit00
profilehide_friendsbit00
hublochubloc_deletedbit00
hublochubloc_errorbit00
hublochubloc_orphancheckbit00
hublochubloc_primarybit00
eventignorebit00
addoninstalledbit00
profileis_defaultbit00
attachis_dirbit00
photois_nsfwbit00
attachis_photobit00
itemitem_blockedbit00
itemitem_consensusbit00
itemitem_delayedbit00
itemitem_deletedbit00
itemitem_hiddenbit00
itemitem_mentionsmebit00
itemitem_nocommentbit00
itemitem_notshownbit00
itemitem_nsfwbit00
itemitem_obscuredbit00
itemitem_originbit00
itemitem_pending_removebit00
itemitem_privatebit00
itemitem_relaybit00
itemitem_retainedbit00
itemitem_rssbit00
itemitem_starredbit00
itemitem_thread_topbit00
itemitem_unpublishedbit00
itemitem_unseenbit00
itemitem_uplinkbit00
itemitem_verifiedbit00
itemitem_wallbit00
eventnofinishbit00
attachos_storagebit00
photoos_storagebit00
outqoutq_asyncbit00
outqoutq_deliveredbit00
addonplugin_adminbit00
fcontactprioritybit0
photoprofilebit00
sys_permspublic_permbit00
profilepublishbit00
notifyseenbit00
groupsvisiblebit00
xchanxchan_censoredbit00
xchanxchan_deletedbit00
xchanxchan_hiddenbit00
xchanxchan_orphanbit00
xchanxchan_pubforumbit00
xchanxchan_selfcensoredbit00
xchanxchan_systembit00
xlinkxlink_staticbit00
abookabook_archivedtinyint30
abookabook_blockedtinyint30
abookabook_closenesstinyint unsigned399
abookabook_feedtinyint30
abookabook_hiddentinyint30
abookabook_ignoredtinyint30
abookabook_pendingtinyint30
abookabook_selftinyint30
abookabook_unconnectedtinyint30
mailmail_deletedtinyint30
mailmail_isreplytinyint30
mailmail_recalledtinyint30
mailmail_repliedtinyint30
mailmail_seentinyint30
termotypetinyint unsigned30
photoscaletinyint30
termtypetinyint unsigned30
xprofxprof_agetinyint unsigned30
eventevent_percentsmallint50
eventevent_prioritysmallint50
eventevent_sequencesmallint50
photoheightsmallint50
mailmail_obscuredsmallint50
outqoutq_prioritysmallint50
photophoto_usagesmallint50
sitesite_deadsmallint50
sitesite_typesmallint50
sitesite_validsmallint50
photowidthsmallint50
abookabook_accountint unsigned100
abookabook_channelint unsigned100
abookabook_flagsint100
abookabook_idint unsigned10 √ 
abookabook_my_permsint100
abookabook_their_permsint100
accountaccount_default_channelint unsigned100
accountaccount_flagsint unsigned100
accountaccount_idint unsigned10 √ 
mailaccount_idint unsigned100
accountaccount_levelint unsigned100
accountaccount_parentint unsigned100
accountaccount_rolesint unsigned100
attachaidint unsigned100
eventaidint unsigned100
itemaidint unsigned100
notifyaidint100
photoaidint unsigned100
profileaidint unsigned100
termaidint unsigned100
appapp_channelint100
verifychannelint unsigned100
channelchannel_a_delegateint unsigned100
channelchannel_a_republishint unsigned100
channelchannel_account_idint unsigned100
channelchannel_expire_daysint100
channelchannel_idint unsigned10 √ 
likeschannel_idint unsigned100
mailchannel_idint unsigned100
profextchannel_idint unsigned100
channelchannel_max_anon_mailint unsigned1010
channelchannel_max_friend_reqint unsigned1010
channelchannel_notifyflagsint unsigned1065535
channelchannel_pageflagsint unsigned100
channelchannel_r_abookint unsigned100
channelchannel_r_pagesint unsigned100
channelchannel_r_photosint unsigned100
channelchannel_r_profileint unsigned100
channelchannel_r_storageint unsigned100
channelchannel_r_streamint unsigned100
channelchannel_w_chatint unsigned100
channelchannel_w_commentint unsigned100
channelchannel_w_likeint unsigned100
channelchannel_w_mailint unsigned100
channelchannel_w_pagesint unsigned100
channelchannel_w_photosint unsigned100
channelchannel_w_storageint unsigned100
channelchannel_w_streamint unsigned100
channelchannel_w_tagwallint unsigned100
channelchannel_w_wallint unsigned100
chatchat_idint unsigned10 √ 
chatchat_roomint unsigned100
ffindercidint unsigned10
fsuggestcidint100
profile_checkcidint unsigned100
mailconvidint unsigned100
chatpresencecp_idint unsigned10 √ 
chatpresencecp_roomint unsigned100
chatroomcr_aidint unsigned100
chatroomcr_expireint unsigned100
chatroomcr_idint unsigned10 √ 
chatroomcr_uidint unsigned100
dreportdreport_channelint100
dreportdreport_idint10 √ 
profile_checkexpireint100
auth_codesexpiresint100
ffinderfidint unsigned10
attachfilesizeint unsigned100
attachflagsint unsigned100
group_membergidint unsigned100
spamhamint100
hublochubloc_flagsint unsigned100
hublochubloc_idint unsigned10 √ 
hublochubloc_statusint unsigned100
addonidint10 √ 
appidint10 √ 
attachidint unsigned10 √ 
configidint unsigned10 √ 
convidint unsigned10 √ 
eventidint10 √ 
fcontactidint unsigned10 √ 
ffinderidint unsigned10 √ 
fserveridint10 √ 
fsuggestidint10 √ 
group_memberidint unsigned10 √ 
groupsidint unsigned10 √ 
hookidint10 √ 
itemidint unsigned10 √ 
item_ididint unsigned10 √ 
likesidint unsigned10 √ 
mailidint unsigned10 √ 
manageidint10 √ 
notifyidint10 √ 
pconfigidint10 √ 
photoidint unsigned10 √ 
profdefidint unsigned10 √ 
profextidint unsigned10 √ 
profileidint10 √ 
profile_checkidint unsigned10 √ 
registeridint unsigned10 √ 
signidint unsigned10 √ 
spamidint10 √ 
sys_permsidint unsigned10 √ 
verifyidint unsigned10 √ 
xconfigidint unsigned10 √ 
xignidint unsigned10 √ 
item_idiidint100
likesiidint unsigned100
signiidint unsigned100
issueissue_idint unsigned10 √ 
issueissue_priorityint100
issueissue_statusint100
itemitem_flagsint100
itemitem_restrictint100
itemitem_typeint100
mailmail_flagsint unsigned100
menumenu_channel_idint unsigned100
menumenu_flagsint100
menumenu_idint unsigned10 √ 
menu_itemmitem_channel_idint unsigned100
menu_itemmitem_flagsint100
menu_itemmitem_idint unsigned10 √ 
menu_itemmitem_menu_idint unsigned100
menu_itemmitem_orderint100
objobj_channelint unsigned100
objobj_idint unsigned10 √ 
objobj_typeint unsigned100
termoidint unsigned100
outqoutq_accountint unsigned100
outqoutq_channelint unsigned100
itemparentint unsigned100
poll_elmpelm_flagsint100
poll_elmpelm_idint unsigned10 √ 
poll_elmpelm_pollint unsigned100
photophoto_flagsint unsigned100
pollpoll_channelint unsigned100
pollpoll_flagsint100
pollpoll_idint unsigned10 √ 
pollpoll_votesint100
hookpriorityint unsigned100
signretract_iidint unsigned100
attachrevisionint unsigned100
itemrevisionint unsigned100
sharesshare_idint unsigned10 √ 
sharesshare_targetint unsigned100
sharesshare_typeint100
sitesite_accessint100
sitesite_flagsint100
sitesite_registerint100
photosizeint unsigned100
spamspamint100
sourcesrc_channel_idint unsigned100
sourcesrc_idint unsigned10 √ 
termtidint unsigned10 √ 
notifytypeint100
updatesud_flagsint100
updatesud_idint unsigned10 √ 
attachuidint unsigned100
clientsuidint100
convuidint100
eventuidint100
ffinderuidint unsigned10
fsuggestuidint100
group_memberuidint unsigned100
groupsuidint unsigned100
itemuidint unsigned100
item_iduidint100
manageuidint100
notifyuidint100
pconfiguidint100
photouidint unsigned100
profileuidint100
profile_checkuidint unsigned100
registeruidint unsigned100
spamuidint100
termuidint unsigned100
tokensuidint100
xignuidint100
votevote_elementint100
votevote_idint unsigned10 √ 
votevote_pollint100
xchanxchan_flagsint unsigned100
xchatxchat_idint unsigned10 √ 
xlinkxlink_idint unsigned10 √ 
xlinkxlink_ratingint100
xpermxp_channelint unsigned100
xpermxp_idint unsigned10 √ 
xtagxtag_flagsint100
xtagxtag_idint unsigned10 √ 
poll_elmpelm_resultfloat120
xprofxprof_dobchar12
accountaccount_languagechar16en
profdeffield_typechar16
registerlanguagechar16
notifyotypechar16
itemresource_typechar16
abookabook_connecteddatetime190000-00-00 00:00:00
abookabook_createddatetime190000-00-00 00:00:00
abookabook_dobdatetime190000-00-00 00:00:00
abookabook_updateddatetime190000-00-00 00:00:00
accountaccount_createddatetime190000-00-00 00:00:00
accountaccount_expire_notifieddatetime190000-00-00 00:00:00
accountaccount_expiresdatetime190000-00-00 00:00:00
accountaccount_lastlogdatetime190000-00-00 00:00:00
accountaccount_password_changeddatetime190000-00-00 00:00:00
appapp_createddatetime190000-00-00 00:00:00
appapp_editeddatetime190000-00-00 00:00:00
itemchangeddatetime190000-00-00 00:00:00
channelchannel_deleteddatetime190000-00-00 00:00:00
channelchannel_dirdatedatetime190000-00-00 00:00:00
channelchannel_lastpostdatetime190000-00-00 00:00:00
itemcommenteddatetime190000-00-00 00:00:00
itemcomments_closeddatetime190000-00-00 00:00:00
chatpresencecp_lastdatetime190000-00-00 00:00:00
chatroomcr_createddatetime190000-00-00 00:00:00
chatroomcr_editeddatetime190000-00-00 00:00:00
attachcreateddatetime190000-00-00 00:00:00
chatcreateddatetime190000-00-00 00:00:00
convcreateddatetime190000-00-00 00:00:00
eventcreateddatetime190000-00-00 00:00:00
fsuggestcreateddatetime190000-00-00 00:00:00
itemcreateddatetime190000-00-00 00:00:00
mailcreateddatetime190000-00-00 00:00:00
photocreateddatetime190000-00-00 00:00:00
registercreateddatetime190000-00-00 00:00:00
verifycreateddatetime190000-00-00 00:00:00
notifydatedatetime190000-00-00 00:00:00
spamdatedatetime190000-00-00 00:00:00
dreportdreport_timedatetime190000-00-00 00:00:00
attachediteddatetime190000-00-00 00:00:00
eventediteddatetime190000-00-00 00:00:00
itemediteddatetime190000-00-00 00:00:00
photoediteddatetime190000-00-00 00:00:00
eventevent_status_datedatetime190000-00-00 00:00:00
itemexpiresdatetime190000-00-00 00:00:00
mailexpiresdatetime190000-00-00 00:00:00
eventfinishdatetime190000-00-00 00:00:00
profilehowlongdatetime190000-00-00 00:00:00
hublochubloc_connecteddatetime190000-00-00 00:00:00
hublochubloc_updateddatetime190000-00-00 00:00:00
issueissue_createddatetime190000-00-00 00:00:00
issueissue_updateddatetime190000-00-00 00:00:00
menumenu_createddatetime190000-00-00 00:00:00
menumenu_editeddatetime190000-00-00 00:00:00
objobj_createddatetime190000-00-00 00:00:00
objobj_editeddatetime190000-00-00 00:00:00
outqoutq_createddatetime190000-00-00 00:00:00
outqoutq_updateddatetime190000-00-00 00:00:00
itemreceiveddatetime190000-00-00 00:00:00
sitesite_pulldatetime190000-00-00 00:00:00
sitesite_syncdatetime190000-00-00 00:00:00
sitesite_updatedatetime190000-00-00 00:00:00
eventstartdatetime190000-00-00 00:00:00
addontimestampbigint190
updatesud_datedatetime190000-00-00 00:00:00
updatesud_lastdatetime190000-00-00 00:00:00
cacheupdateddatetime190000-00-00 00:00:00
convupdateddatetime190000-00-00 00:00:00
fcontactupdateddatetime190000-00-00 00:00:00
xchanxchan_name_datedatetime190000-00-00 00:00:00
xchanxchan_photo_datedatetime190000-00-00 00:00:00
xchatxchat_editeddatetime190000-00-00 00:00:00
xlinkxlink_updateddatetime190000-00-00 00:00:00
auth_codesclient_idvarchar20
clientsclient_idvarchar20
tokensclient_idvarchar20
sessionexpirebigint unsigned200
tokensexpiresbigint unsigned200
sessionidbigint unsigned20 √ 
clientspwvarchar20
xpermxp_clientvarchar20
accountaccount_saltchar32
accountaccount_service_classchar32
profiledobchar320000-00-00
profilegenderchar32
hublochubloc_networkchar32
fcontactnetworkchar32
outqoutq_driverchar32
profilepostal_codechar32
verifytypechar32
xchanxchan_photo_mimetypechar32image/jpeg
xprofxprof_postcodechar32
auth_codesidvarchar40
tokensidvarchar40
abookabook_profilechar64
attachfiletypechar64
attachfolderchar64
attachhashchar64
notifyhashchar64
itemlangchar64
objobj_pagechar64
profileprofile_guidchar64
xpermxp_permvarchar64
channelchannel_timezonechar128UTC
chatpresencecp_clientchar128
attachcreatorchar128
likeslikeechar128
likeslikerchar128
likestarget_idchar128
phototypechar128image/jpeg
updatesud_hashchar128
auth_codesredirect_urivarchar200
clientsredirect_urivarchar200
tokensscopevarchar200
auth_codesscopevarchar250
abookabook_xchanchar255
accountaccount_emailchar255
accountaccount_externalchar255
accountaccount_passwordchar255
accountaccount_resetchar255
fcontactaddrchar255
profileaddresschar255
photoalbumchar255
fcontactaliaschar255
itemappchar255
appapp_addrchar255
appapp_authorchar255
appapp_idchar255
appapp_namechar255
appapp_pagechar255
appapp_photochar255
appapp_pricechar255
appapp_requireschar255
appapp_sigchar255
appapp_urlchar255
appapp_versionchar255
itemauthor_xchanchar255
fcontactbatchchar255
configcatchar255
pconfigcatchar255
sys_permscatchar255
xconfigcatchar255
channelchannel_addresschar255
channelchannel_default_groupchar255
channelchannel_guidchar255
channelchannel_hashchar255
channelchannel_locationchar255
channelchannel_namechar255
channelchannel_passwd_resetchar255
channelchannel_startpagechar255
channelchannel_themechar255
chatchat_xchanchar255
itemcomment_policychar255
fcontactconfirmchar255
mailconv_guidchar255
itemcoordchar255
profilecountry_namechar255
chatpresencecp_statuschar255
chatpresencecp_xchanchar255
chatroomcr_namechar255
convcreatorchar255
profile_checkdfrn_idchar255
profiledob_tzchar255UTC
dreportdreport_midchar255
dreportdreport_queuechar255
dreportdreport_recipchar255
dreportdreport_resultchar255
dreportdreport_sitechar255
dreportdreport_xchanchar255
eventevent_hashchar255
eventevent_statuschar255
eventevent_xchanchar255
profdeffield_descchar255
profdeffield_helpchar255
profdeffield_namechar255
hookfilechar255
attachfilenamechar255
photofilenamechar255
mailfrom_xchanchar255
hookfunctionchar255
convguidchar255
groupshashchar255
profexthashchar255
registerhashchar255
profilehomepagechar255
profilehometownchar255
hookhookchar255
hublochubloc_addrchar255
hublochubloc_callbackchar255
hublochubloc_connectchar255
hublochubloc_guidchar255
hublochubloc_hashchar255
hublochubloc_hostchar255
hublochubloc_urlchar255
likesi_midchar255
termimgurlchar255
issueissue_assignedchar255
issueissue_componentchar255
cachekchar255
configkchar255
pconfigkchar255
profextkchar255
sys_permskchar255
xconfigkchar255
itemlayout_midchar255
notifylinkchar255
itemllinkchar255
profilelocalitychar255
itemlocationchar255
profilemaritalchar255
menumenu_descchar255
menumenu_namechar255
verifymetachar255
itemmidchar255
mailmidchar255
itemmimetypechar255
menu_itemmitem_descchar255
menu_itemmitem_linkchar255
addonnamechar255
fcontactnamechar255
fsuggestnamechar255
groupsnamechar255
notifynamechar255
profilenamechar255
fcontactnickchar255
fcontactnotifychar255
objobj_imgurlchar255
objobj_objchar255
objobj_termchar255
itemobj_typechar255
objobj_urlchar255
objobj_verbchar255
outqoutq_hashchar255
outqoutq_posturlchar255
itemowner_xchanchar255
notifyparentchar255
termparent_hashchar255
itemparent_midchar255
mailparent_midchar255
registerpasswordchar255
profilepdescchar255
fcontactphotochar255
fsuggestphotochar255
notifyphotochar255
profilephotochar255
itemplinkchar255
profilepoliticchar255
fcontactpollchar255
fserverposturlchar255
profileprofile_namechar255
itempublic_policychar255
profileregionchar255
profilereligionchar255
fcontactrequestchar255
fsuggestrequestchar255
itemresource_idchar255
photoresource_idchar255
profile_checksecchar255
fserverserverchar255
item_idservicechar255
profilesexualchar255
sharesshare_xchanchar255
item_idsidchar255
sessionsidchar255
signsignerchar255
sitesite_directorychar255
sitesite_locationchar255
sitesite_projectchar255
sitesite_realmchar255
sitesite_sellpagechar255
sitesite_urlchar255
itemsource_xchanchar255
sourcesrc_channel_xchanchar255
sourcesrc_xchanchar255
profilesummarychar255
likestarget_typechar255
spamtermchar255
termtermchar255
termterm_hashchar255
itemtgt_typechar255
itemthr_parentchar255
profilethumbchar255
phototitlechar255
mailto_xchanchar255
verifytokenchar255
eventtypechar255
updatesud_addrchar255
updatesud_guidchar255
fcontacturlchar255
fsuggesturlchar255
notifyurlchar255
termurlchar255
itemverbchar255
likesverbchar255
notifyverbchar255
addonversionchar255
votevote_xchanchar255
group_memberxchanchar255
managexchanchar255
photoxchanchar255
xconfigxchanchar255
xignxchanchar255
xchanxchan_addrchar255
xchanxchan_connpagechar255
xchanxchan_connurlchar255
xchanxchan_followchar255
xchanxchan_guidchar255
xchanxchan_hashchar255
xchanxchan_instance_urlchar255
xchanxchan_namechar255
xchanxchan_networkchar255
xchanxchan_photo_lchar255
xchanxchan_photo_mchar255
xchanxchan_photo_schar255
xchanxchan_urlchar255
xchatxchat_descchar255
xchatxchat_urlchar255
xchatxchat_xchanchar255
xlinkxlink_linkchar255
xlinkxlink_xchanchar255
xprofxprof_countrychar255
xprofxprof_descchar255
xprofxprof_genderchar255
xprofxprof_hashchar255
xprofxprof_homepagechar255
xprofxprof_hometownchar255
xprofxprof_localechar255
xprofxprof_maritalchar255
xprofxprof_regionchar255
xprofxprof_sexualchar255
xtagxtag_hashchar255
xtagxtag_termchar255
abookabook_excltext65535
abookabook_incltext65535
profileabouttext65535
appapp_desctext65535
profilebooktext65535
profilechandesctext65535
channelchannel_guid_sigtext65535
channelchannel_prvkeytext65535
channelchannel_pubkeytext65535
profilechannelstext65535
profilecontacttext65535
sessiondatatext65535
eventdescriptiontext65535
photodescriptiontext65535
profiledislikestext65535
profileeducationtext65535
eventevent_repeattext65535
eventevent_vdatatext65535
profilefilmtext65535
hublochubloc_guid_sigtext65535
hublochubloc_sitekeytext65535
hublochubloc_url_sigtext65535
clientsicontext65535 √ null
profileinteresttext65535
fserverkeytext65535
profilekeywordstext65535
profilelikestext65535
eventlocationtext65535
profilemusictext65535
clientsnametext65535 √ null
fsuggestnotetext65535
itemobjecttext65535
poll_elmpelm_desctext65535
pollpoll_desctext65535
itempostoptstext65535
fcontactpubkeytext65535
profileromancetext65535
itemroutetext65535
tokenssecrettext65535
itemsigtext65535
mailsigtext65535
signsignaturetext65535
eventsummarytext65535
itemtargettext65535
itemtitletext65535
mailtitletext65535
profiletvtext65535
cachevtext65535
configvtext65535
votevote_resulttext65535
profilewithtext65535
profileworktext65535
xchanxchan_guid_sigtext65535
xchanxchan_pubkeytext65535
xlinkxlink_rating_texttext65535
xlinkxlink_sigtext65535
xprofxprof_abouttext65535
xprofxprof_keywordstext65535
attachallow_cidmediumtext16777215
chatroomallow_cidmediumtext16777215
eventallow_cidmediumtext16777215
itemallow_cidmediumtext16777215
menu_itemallow_cidmediumtext16777215
objallow_cidmediumtext16777215
photoallow_cidmediumtext16777215
attachallow_gidmediumtext16777215
chatroomallow_gidmediumtext16777215
eventallow_gidmediumtext16777215
itemallow_gidmediumtext16777215
menu_itemallow_gidmediumtext16777215
objallow_gidmediumtext16777215
photoallow_gidmediumtext16777215
itemattachmediumtext16777215
mailattachmediumtext16777215
itembodymediumtext16777215
mailbodymediumtext16777215
channelchannel_allow_cidmediumtext16777215
channelchannel_allow_gidmediumtext16777215
channelchannel_deny_cidmediumtext16777215
channelchannel_deny_gidmediumtext16777215
chatchat_textmediumtext16777215
photodatamediumblob16777215
attachdeny_cidmediumtext16777215
chatroomdeny_cidmediumtext16777215
eventdeny_cidmediumtext16777215
itemdeny_cidmediumtext16777215
menu_itemdeny_cidmediumtext16777215
objdeny_cidmediumtext16777215
photodeny_cidmediumtext16777215
attachdeny_gidmediumtext16777215
chatroomdeny_gidmediumtext16777215
eventdeny_gidmediumtext16777215
itemdeny_gidmediumtext16777215
menu_itemdeny_gidmediumtext16777215
objdeny_gidmediumtext16777215
photodeny_gidmediumtext16777215
itemdiaspora_metamediumtext16777215
attachdisplay_pathmediumtext16777215
photodisplay_pathmediumtext16777215
profdeffield_inputsmediumtext16777215
itemhtmlmediumtext16777215
notifymsgmediumtext16777215
attachos_pathmediumtext16777215
photoos_pathmediumtext16777215
outqoutq_msgmediumtext16777215
outqoutq_notifymediumtext16777215
convrecipsmediumtext16777215
signsigned_textmediumtext16777215
sourcesrc_pattmediumtext16777215
convsubjectmediumtext16777215
likestargetmediumtext16777215
pconfigvmediumtext16777215
profextvmediumtext16777215
sys_permsvmediumtext16777215
xconfigvmediumtext16777215
attachdatalongblob2147483647
+
+
+ + -- cgit v1.2.3