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 --- hubzilla_er/columns.byDefault.html | 7153 ++++++++++++++++++++++++++++++++++++ 1 file changed, 7153 insertions(+) create mode 100644 hubzilla_er/columns.byDefault.html (limited to 'hubzilla_er/columns.byDefault.html') diff --git a/hubzilla_er/columns.byDefault.html b/hubzilla_er/columns.byDefault.html new file mode 100644 index 000000000..6913d1c9f --- /dev/null +++ b/hubzilla_er/columns.byDefault.html @@ -0,0 +1,7153 @@ + + + + + SchemaSpy - zot - Columns + + + + + + +
+ +
+
+ + + + + +
SchemaSpy Analysis of zot - ColumnsGenerated by
SchemaSpy
+ + +
+Generated by SchemaSpy on on aug 19 21:08 CEST 2015 + + + + + + + +
Legend:SourceForge.net
+ + + + +
Primary key columns
Columns with indexes
+
+
+ + +
+  +
+

+

+ + +
+
+
+zot contains 705 columns - click on heading to sort: + +++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
TableColumnTypeSizeNullsAutoDefaultComments
abookabook_profilechar64
abookabook_xchanchar255
accountaccount_emailchar255
accountaccount_externalchar255
accountaccount_passwordchar255
accountaccount_resetchar255
accountaccount_saltchar32
accountaccount_service_classchar32
profileaddresschar255
photoalbumchar255
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
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
auth_codesclient_idvarchar20
clientsclient_idvarchar20
tokensclient_idvarchar20
itemcomment_policychar255
itemcoordchar255
profilecountry_namechar255
chatpresencecp_clientchar128
chatpresencecp_statuschar255
chatpresencecp_xchanchar255
chatroomcr_namechar255
attachcreatorchar128
convcreatorchar255
profile_checkdfrn_idchar255
eventevent_hashchar255
eventevent_statuschar255
eventevent_xchanchar255
profdeffield_descchar255
profdeffield_helpchar255
profdeffield_namechar255
profdeffield_typechar16
hookfilechar255
attachfilenamechar255
photofilenamechar255
attachfiletypechar64
attachfolderchar64
mailfrom_xchanchar255
hookfunctionchar255
profilegenderchar32
convguidchar255
attachhashchar64
groupshashchar255
notifyhashchar64
profexthashchar255
registerhashchar255
profilehomepagechar255
profilehometownchar255
hookhookchar255
hublochubloc_addrchar255
hublochubloc_callbackchar255
hublochubloc_connectchar255
hublochubloc_guidchar255
hublochubloc_hashchar255
hublochubloc_hostchar255
hublochubloc_networkchar32
hublochubloc_urlchar255
auth_codesidvarchar40
tokensidvarchar40
termimgurlchar255
issueissue_assignedchar255
issueissue_componentchar255
cachekchar255
configkchar255
pconfigkchar255
profextkchar255
sys_permskchar255
xconfigkchar255
itemlangchar64
registerlanguagechar16
itemlayout_midchar255
likeslikeechar128
likeslikerchar128
notifylinkchar255
itemllinkchar255
profilelocalitychar255
itemlocationchar255
profilemaritalchar255
menumenu_descchar255
menumenu_namechar255
verifymetachar255
itemmidchar255
mailmidchar255
itemmimetypechar255
menu_itemmitem_descchar255
menu_itemmitem_linkchar255
addonnamechar255
fsuggestnamechar255
groupsnamechar255
notifynamechar255
profilenamechar255
objobj_objchar255
objobj_pagechar64
itemobj_typechar255
objobj_verbchar255
notifyotypechar16
outqoutq_driverchar32
outqoutq_posturlchar255
itemowner_xchanchar255
notifyparentchar255
termparent_hashchar255
itemparent_midchar255
mailparent_midchar255
registerpasswordchar255
profilepdescchar255
fsuggestphotochar255
notifyphotochar255
profilephotochar255
itemplinkchar255
profilepoliticchar255
profilepostal_codechar32
fserverposturlchar255
profileprofile_guidchar64
profileprofile_namechar255
itempublic_policychar255
clientspwvarchar20
auth_codesredirect_urivarchar200
clientsredirect_urivarchar200
profileregionchar255
profilereligionchar255
fsuggestrequestchar255
itemresource_idchar255
photoresource_idchar255
itemresource_typechar16
auth_codesscopevarchar250
tokensscopevarchar200
profile_checksecchar255
fserverserverchar255
item_idservicechar255
profilesexualchar255
sharesshare_xchanchar255
item_idsidchar255
sessionsidchar255
signsignerchar255
sitesite_directorychar255
sitesite_locationchar255
sitesite_realmchar255
sitesite_sellpagechar255
itemsource_xchanchar255
sourcesrc_channel_xchanchar255
sourcesrc_xchanchar255
profilesummarychar255
likestarget_idchar128
likestarget_typechar255
spamtermchar255
termtermchar255
termterm_hashchar255
itemtgt_typechar255
itemthr_parentchar255
profilethumbchar255
phototitlechar255
mailto_xchanchar255
verifytokenchar255
eventtypechar255
verifytypechar32
updatesud_addrchar255
updatesud_guidchar255
updatesud_hashchar128
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_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
xpermxp_clientvarchar20
xpermxp_permvarchar64
xprofxprof_countrychar255
xprofxprof_descchar255
xprofxprof_dobchar12
xprofxprof_genderchar255
xprofxprof_homepagechar255
xprofxprof_hometownchar255
xprofxprof_localechar255
xprofxprof_maritalchar255
xprofxprof_postcodechar32
xprofxprof_regionchar255
xprofxprof_sexualchar255
xtagxtag_hashchar255
xtagxtag_termchar255
abookabook_accountint unsigned100
abookabook_archivedtinyint30
abookabook_blockedtinyint30
abookabook_channelint unsigned100
abookabook_feedtinyint30
abookabook_flagsint100
abookabook_hiddentinyint30
abookabook_ignoredtinyint30
abookabook_my_permsint100
abookabook_pendingtinyint30
abookabook_selftinyint30
abookabook_their_permsint100
abookabook_unconnectedtinyint30
accountaccount_default_channelint unsigned100
accountaccount_flagsint unsigned100
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
likeschannel_idint unsigned100
mailchannel_idint unsigned100
profextchannel_idint unsigned100
channelchannel_pageflagsint unsigned100
channelchannel_primarybit00
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_removedbit00
channelchannel_systembit00
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_roomint unsigned100
fsuggestcidint100
profile_checkcidint unsigned100
mailconvidint unsigned100
chatpresencecp_roomint unsigned100
chatroomcr_aidint unsigned100
chatroomcr_expireint unsigned100
chatroomcr_uidint unsigned100
groupsdeletedbit00
eventevent_percentsmallint50
eventevent_sequencesmallint50
profile_checkexpireint100
sessionexpirebigint unsigned200
auth_codesexpiresint100
tokensexpiresbigint unsigned200
attachfilesizeint unsigned100
attachflagsint unsigned100
group_membergidint unsigned100
spamhamint100
photoheightsmallint50
addonhiddenbit00
profilehide_friendsbit00
hublochubloc_deletedbit00
hublochubloc_errorbit00
hublochubloc_flagsint unsigned100
hublochubloc_orphancheckbit00
hublochubloc_primarybit00
hublochubloc_statusint unsigned100
eventignorebit00
item_idiidint100
likesiidint unsigned100
signiidint unsigned100
addoninstalledbit00
profileis_defaultbit00
attachis_dirbit00
photois_nsfwbit00
attachis_photobit00
issueissue_priorityint100
issueissue_statusint100
itemitem_blockedbit00
itemitem_consensusbit00
itemitem_delayedbit00
itemitem_deletedbit00
itemitem_flagsint100
itemitem_hiddenbit00
itemitem_mentionsmebit00
itemitem_nocommentbit00
itemitem_notshownbit00
itemitem_nsfwbit00
itemitem_obscuredbit00
itemitem_originbit00
itemitem_pending_removebit00
itemitem_privatebit00
itemitem_relaybit00
itemitem_restrictint100
itemitem_retainedbit00
itemitem_rssbit00
itemitem_starredbit00
itemitem_thread_topbit00
itemitem_typeint100
itemitem_unpublishedbit00
itemitem_unseenbit00
itemitem_uplinkbit00
itemitem_verifiedbit00
itemitem_wallbit00
mailmail_deletedtinyint30
mailmail_flagsint unsigned100
mailmail_isreplytinyint30
mailmail_obscuredsmallint50
mailmail_recalledtinyint30
mailmail_repliedtinyint30
mailmail_seentinyint30
menumenu_channel_idint unsigned100
menumenu_flagsint100
menu_itemmitem_channel_idint unsigned100
menu_itemmitem_flagsint100
menu_itemmitem_menu_idint unsigned100
menu_itemmitem_orderint100
eventnofinishbit00
objobj_channelint unsigned100
objobj_typeint unsigned100
termoidint unsigned100
attachos_storagebit00
photoos_storagebit00
termotypetinyint unsigned30
outqoutq_accountint unsigned100
outqoutq_asyncbit00
outqoutq_channelint unsigned100
outqoutq_deliveredbit00
outqoutq_prioritysmallint50
itemparentint unsigned100
poll_elmpelm_flagsint100
poll_elmpelm_pollint unsigned100
poll_elmpelm_resultfloat120
photophoto_flagsint unsigned100
photophoto_usagesmallint50
addonplugin_adminbit00
pollpoll_channelint unsigned100
pollpoll_flagsint100
pollpoll_votesint100
hookpriorityint unsigned100
photoprofilebit00
sys_permspublic_permbit00
profilepublishbit00
signretract_iidint unsigned100
attachrevisionint unsigned100
itemrevisionint unsigned100
photoscaletinyint30
notifyseenbit00
sharesshare_targetint unsigned100
sharesshare_typeint100
sitesite_accessint100
sitesite_deadsmallint50
sitesite_flagsint100
sitesite_registerint100
sitesite_validsmallint50
photosizeint unsigned100
spamspamint100
sourcesrc_channel_idint unsigned100
addontimestampbigint190
notifytypeint100
termtypetinyint unsigned30
updatesud_flagsint100
attachuidint unsigned100
clientsuidint100
convuidint100
eventuidint100
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
groupsvisiblebit00
votevote_elementint100
votevote_pollint100
photowidthsmallint50
xchanxchan_censoredbit00
xchanxchan_deletedbit00
xchanxchan_flagsint unsigned100
xchanxchan_hiddenbit00
xchanxchan_orphanbit00
xchanxchan_pubforumbit00
xchanxchan_selfcensoredbit00
xchanxchan_systembit00
xlinkxlink_ratingint100
xlinkxlink_staticbit00
xpermxp_channelint unsigned100
xprofxprof_agetinyint unsigned30
xtagxtag_flagsint100
profiledobchar320000-00-00
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
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
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
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
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
eventadjustbit01
channelchannel_max_anon_mailint unsigned1010
channelchannel_max_friend_reqint unsigned1010
channelchannel_notifyflagsint unsigned1065535
abookabook_closenesstinyint unsigned399
accountaccount_languagechar16en
phototypechar128image/jpeg
xchanxchan_photo_mimetypechar32image/jpeg
abookabook_excltext65535
abookabook_idint unsigned10 √ 
abookabook_incltext65535
profileabouttext65535
accountaccount_idint unsigned10 √ 
fcontactaddrchar255
fcontactaliaschar255
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
appapp_desctext65535
itemattachmediumtext16777215
mailattachmediumtext16777215
fcontactbatchchar255
itembodymediumtext16777215
mailbodymediumtext16777215
profilebooktext65535
profilechandesctext65535
channelchannel_allow_cidmediumtext16777215
channelchannel_allow_gidmediumtext16777215
channelchannel_deny_cidmediumtext16777215
channelchannel_deny_gidmediumtext16777215
channelchannel_guid_sigtext65535
channelchannel_idint unsigned10 √ 
channelchannel_prvkeytext65535
channelchannel_pubkeytext65535
profilechannelstext65535
chatchat_idint unsigned10 √ 
chatchat_textmediumtext16777215
ffindercidint unsigned10
fcontactconfirmchar255
profilecontacttext65535
chatpresencecp_idint unsigned10 √ 
chatroomcr_idint unsigned10 √ 
attachdatalongblob2147483647
photodatamediumblob16777215
sessiondatatext65535
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
eventdescriptiontext65535
photodescriptiontext65535
itemdiaspora_metamediumtext16777215
profiledislikestext65535
attachdisplay_pathmediumtext16777215
photodisplay_pathmediumtext16777215
profileeducationtext65535
eventevent_repeattext65535
ffinderfidint unsigned10
profdeffield_inputsmediumtext16777215
profilefilmtext65535
itemhtmlmediumtext16777215
hublochubloc_guid_sigtext65535
hublochubloc_idint unsigned10 √ 
hublochubloc_sitekeytext65535
hublochubloc_url_sigtext65535
clientsicontext65535 √ null
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 √ 
sessionidbigint unsigned20 √ 
signidint unsigned10 √ 
spamidint10 √ 
sys_permsidint unsigned10 √ 
verifyidint unsigned10 √ 
xconfigidint unsigned10 √ 
xignidint unsigned10 √ 
profileinteresttext65535
issueissue_idint unsigned10 √ 
fserverkeytext65535
profilekeywordstext65535
profilelikestext65535
eventlocationtext65535
menumenu_idint unsigned10 √ 
menu_itemmitem_idint unsigned10 √ 
notifymsgmediumtext16777215
profilemusictext65535
clientsnametext65535 √ null
fcontactnamechar255
fcontactnetworkchar32
fcontactnickchar255
fsuggestnotetext65535
fcontactnotifychar255
objobj_idint unsigned10 √ 
itemobjecttext65535
attachos_pathmediumtext16777215
photoos_pathmediumtext16777215
outqoutq_hashchar255
outqoutq_msgmediumtext16777215
outqoutq_notifymediumtext16777215
poll_elmpelm_desctext65535
poll_elmpelm_idint unsigned10 √ 
fcontactphotochar255
fcontactpollchar255
pollpoll_desctext65535
pollpoll_idint unsigned10 √ 
itempostoptstext65535
fcontactprioritybit0
fcontactpubkeytext65535
convrecipsmediumtext16777215
fcontactrequestchar255
profileromancetext65535
itemroutetext65535
tokenssecrettext65535
sharesshare_idint unsigned10 √ 
itemsigtext65535
mailsigtext65535
signsignaturetext65535
signsigned_textmediumtext16777215
sitesite_urlchar255
sourcesrc_idint unsigned10 √ 
sourcesrc_pattmediumtext16777215
convsubjectmediumtext16777215
eventsummarytext65535
itemtargettext65535
likestargetmediumtext16777215
termtidint unsigned10 √ 
itemtitletext65535
mailtitletext65535
profiletvtext65535
updatesud_idint unsigned10 √ 
ffinderuidint unsigned10
fcontacturlchar255
cachevtext65535
configvtext65535
pconfigvmediumtext16777215
profextvmediumtext16777215
sys_permsvmediumtext16777215
xconfigvmediumtext16777215
votevote_idint unsigned10 √ 
votevote_resulttext65535
profilewithtext65535
profileworktext65535
xchanxchan_guid_sigtext65535
xchanxchan_hashchar255
xchanxchan_pubkeytext65535
xchatxchat_idint unsigned10 √ 
xlinkxlink_idint unsigned10 √ 
xlinkxlink_rating_texttext65535
xlinkxlink_sigtext65535
xpermxp_idint unsigned10 √ 
xprofxprof_abouttext65535
xprofxprof_hashchar255
xprofxprof_keywordstext65535
xtagxtag_idint unsigned10 √ 
channelchannel_timezonechar128UTC
profiledob_tzchar255UTC
+
+
+ + -- cgit v1.2.3