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.byAuto.html | 7153 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 7153 insertions(+) create mode 100644 hubzilla_er/columns.byAuto.html (limited to 'hubzilla_er/columns.byAuto.html') diff --git a/hubzilla_er/columns.byAuto.html b/hubzilla_er/columns.byAuto.html new file mode 100644 index 000000000..f8d951d19 --- /dev/null +++ b/hubzilla_er/columns.byAuto.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_idint unsigned10 √ 
accountaccount_idint unsigned10 √ 
channelchannel_idint unsigned10 √ 
chatchat_idint unsigned10 √ 
chatpresencecp_idint unsigned10 √ 
chatroomcr_idint unsigned10 √ 
hublochubloc_idint unsigned10 √ 
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 √ 
issueissue_idint unsigned10 √ 
menumenu_idint unsigned10 √ 
menu_itemmitem_idint unsigned10 √ 
objobj_idint unsigned10 √ 
poll_elmpelm_idint unsigned10 √ 
pollpoll_idint unsigned10 √ 
sharesshare_idint unsigned10 √ 
sourcesrc_idint unsigned10 √ 
termtidint unsigned10 √ 
updatesud_idint unsigned10 √ 
votevote_idint unsigned10 √ 
xchatxchat_idint unsigned10 √ 
xlinkxlink_idint unsigned10 √ 
xpermxp_idint unsigned10 √ 
xtagxtag_idint unsigned10 √ 
abookabook_accountint unsigned100
abookabook_archivedtinyint30
abookabook_blockedtinyint30
abookabook_channelint unsigned100
abookabook_closenesstinyint unsigned399
abookabook_connecteddatetime190000-00-00 00:00:00
abookabook_createddatetime190000-00-00 00:00:00
abookabook_dobdatetime190000-00-00 00:00:00
abookabook_excltext65535
abookabook_feedtinyint30
abookabook_flagsint100
abookabook_hiddentinyint30
abookabook_ignoredtinyint30
abookabook_incltext65535
abookabook_my_permsint100
abookabook_pendingtinyint30
abookabook_profilechar64
abookabook_selftinyint30
abookabook_their_permsint100
abookabook_unconnectedtinyint30
abookabook_updateddatetime190000-00-00 00:00:00
abookabook_xchanchar255
profileabouttext65535
accountaccount_createddatetime190000-00-00 00:00:00
accountaccount_default_channelint unsigned100
accountaccount_emailchar255
accountaccount_expire_notifieddatetime190000-00-00 00:00:00
accountaccount_expiresdatetime190000-00-00 00:00:00
accountaccount_externalchar255
accountaccount_flagsint unsigned100
mailaccount_idint unsigned100
accountaccount_languagechar16en
accountaccount_lastlogdatetime190000-00-00 00:00:00
accountaccount_levelint unsigned100
accountaccount_parentint unsigned100
accountaccount_passwordchar255
accountaccount_password_changeddatetime190000-00-00 00:00:00
accountaccount_resetchar255
accountaccount_rolesint unsigned100
accountaccount_saltchar32
accountaccount_service_classchar32
fcontactaddrchar255
profileaddresschar255
eventadjustbit01
attachaidint unsigned100
eventaidint unsigned100
itemaidint unsigned100
notifyaidint100
photoaidint unsigned100
profileaidint unsigned100
termaidint unsigned100
photoalbumchar255
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
itemappchar255
appapp_addrchar255
appapp_authorchar255
appapp_channelint100
appapp_desctext65535
appapp_idchar255
appapp_namechar255
appapp_pagechar255
appapp_photochar255
appapp_pricechar255
appapp_requireschar255
appapp_sigchar255
appapp_urlchar255
appapp_versionchar255
itemattachmediumtext16777215
mailattachmediumtext16777215
itemauthor_xchanchar255
fcontactbatchchar255
itembodymediumtext16777215
mailbodymediumtext16777215
profilebooktext65535
configcatchar255
pconfigcatchar255
sys_permscatchar255
xconfigcatchar255
profilechandesctext65535
itemchangeddatetime190000-00-00 00:00:00
verifychannelint unsigned100
channelchannel_a_delegateint unsigned100
channelchannel_a_republishint unsigned100
channelchannel_account_idint unsigned100
channelchannel_addresschar255
channelchannel_allow_cidmediumtext16777215
channelchannel_allow_gidmediumtext16777215
channelchannel_default_groupchar255
channelchannel_deleteddatetime190000-00-00 00:00:00
channelchannel_deny_cidmediumtext16777215
channelchannel_deny_gidmediumtext16777215
channelchannel_dirdatedatetime190000-00-00 00:00:00
channelchannel_expire_daysint100
channelchannel_guidchar255
channelchannel_guid_sigtext65535
channelchannel_hashchar255
likeschannel_idint unsigned100
mailchannel_idint unsigned100
profextchannel_idint unsigned100
channelchannel_lastpostdatetime190000-00-00 00:00:00
channelchannel_locationchar255
channelchannel_max_anon_mailint unsigned1010
channelchannel_max_friend_reqint unsigned1010
channelchannel_namechar255
channelchannel_notifyflagsint unsigned1065535
channelchannel_pageflagsint unsigned100
channelchannel_passwd_resetchar255
channelchannel_primarybit00
channelchannel_prvkeytext65535
channelchannel_pubkeytext65535
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_startpagechar255
channelchannel_systembit00
channelchannel_themechar255
channelchannel_timezonechar128UTC
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
profilechannelstext65535
chatchat_roomint unsigned100
chatchat_textmediumtext16777215
chatchat_xchanchar255
ffindercidint unsigned10
fsuggestcidint100
profile_checkcidint unsigned100
auth_codesclient_idvarchar20
clientsclient_idvarchar20
tokensclient_idvarchar20
itemcomment_policychar255
itemcommenteddatetime190000-00-00 00:00:00
itemcomments_closeddatetime190000-00-00 00:00:00
fcontactconfirmchar255
profilecontacttext65535
mailconvidint unsigned100
itemcoordchar255
profilecountry_namechar255
chatpresencecp_clientchar128
chatpresencecp_lastdatetime190000-00-00 00:00:00
chatpresencecp_roomint unsigned100
chatpresencecp_statuschar255
chatpresencecp_xchanchar255
chatroomcr_aidint unsigned100
chatroomcr_createddatetime190000-00-00 00:00:00
chatroomcr_editeddatetime190000-00-00 00:00:00
chatroomcr_expireint unsigned100
chatroomcr_namechar255
chatroomcr_uidint unsigned100
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
attachcreatorchar128
convcreatorchar255
attachdatalongblob2147483647
photodatamediumblob16777215
sessiondatatext65535
notifydatedatetime190000-00-00 00:00:00
spamdatedatetime190000-00-00 00:00:00
groupsdeletedbit00
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
profile_checkdfrn_idchar255
itemdiaspora_metamediumtext16777215
profiledislikestext65535
attachdisplay_pathmediumtext16777215
photodisplay_pathmediumtext16777215
profiledobchar320000-00-00
profiledob_tzchar255UTC
attachediteddatetime190000-00-00 00:00:00
eventediteddatetime190000-00-00 00:00:00
itemediteddatetime190000-00-00 00:00:00
photoediteddatetime190000-00-00 00:00:00
profileeducationtext65535
eventevent_hashchar255
eventevent_percentsmallint50
eventevent_repeattext65535
eventevent_sequencesmallint50
eventevent_statuschar255
eventevent_status_datedatetime190000-00-00 00:00:00
eventevent_xchanchar255
profile_checkexpireint100
sessionexpirebigint unsigned200
auth_codesexpiresint100
itemexpiresdatetime190000-00-00 00:00:00
mailexpiresdatetime190000-00-00 00:00:00
tokensexpiresbigint unsigned200
ffinderfidint unsigned10
profdeffield_descchar255
profdeffield_helpchar255
profdeffield_inputsmediumtext16777215
profdeffield_namechar255
profdeffield_typechar16
hookfilechar255
attachfilenamechar255
photofilenamechar255
attachfilesizeint unsigned100
attachfiletypechar64
profilefilmtext65535
eventfinishdatetime190000-00-00 00:00:00
attachflagsint unsigned100
attachfolderchar64
mailfrom_xchanchar255
hookfunctionchar255
profilegenderchar32
group_membergidint unsigned100
convguidchar255
spamhamint100
attachhashchar64
groupshashchar255
notifyhashchar64
profexthashchar255
registerhashchar255
photoheightsmallint50
addonhiddenbit00
profilehide_friendsbit00
profilehomepagechar255
profilehometownchar255
hookhookchar255
profilehowlongdatetime190000-00-00 00:00:00
itemhtmlmediumtext16777215
hublochubloc_addrchar255
hublochubloc_callbackchar255
hublochubloc_connectchar255
hublochubloc_connecteddatetime190000-00-00 00:00:00
hublochubloc_deletedbit00
hublochubloc_errorbit00
hublochubloc_flagsint unsigned100
hublochubloc_guidchar255
hublochubloc_guid_sigtext65535
hublochubloc_hashchar255
hublochubloc_hostchar255
hublochubloc_networkchar32
hublochubloc_orphancheckbit00
hublochubloc_primarybit00
hublochubloc_sitekeytext65535
hublochubloc_statusint unsigned100
hublochubloc_updateddatetime190000-00-00 00:00:00
hublochubloc_urlchar255
hublochubloc_url_sigtext65535
clientsicontext65535 √ null
auth_codesidvarchar40
tokensidvarchar40
eventignorebit00
item_idiidint100
likesiidint unsigned100
signiidint unsigned100
termimgurlchar255
addoninstalledbit00
profileinteresttext65535
profileis_defaultbit00
attachis_dirbit00
photois_nsfwbit00
attachis_photobit00
issueissue_assignedchar255
issueissue_componentchar255
issueissue_createddatetime190000-00-00 00:00:00
issueissue_priorityint100
issueissue_statusint100
issueissue_updateddatetime190000-00-00 00:00:00
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
cachekchar255
configkchar255
pconfigkchar255
profextkchar255
sys_permskchar255
xconfigkchar255
fserverkeytext65535
profilekeywordstext65535
itemlangchar64
registerlanguagechar16
itemlayout_midchar255
likeslikeechar128
likeslikerchar128
profilelikestext65535
notifylinkchar255
itemllinkchar255
profilelocalitychar255
eventlocationtext65535
itemlocationchar255
mailmail_deletedtinyint30
mailmail_flagsint unsigned100
mailmail_isreplytinyint30
mailmail_obscuredsmallint50
mailmail_recalledtinyint30
mailmail_repliedtinyint30
mailmail_seentinyint30
profilemaritalchar255
menumenu_channel_idint unsigned100
menumenu_createddatetime190000-00-00 00:00:00
menumenu_descchar255
menumenu_editeddatetime190000-00-00 00:00:00
menumenu_flagsint100
menumenu_namechar255
verifymetachar255
itemmidchar255
mailmidchar255
itemmimetypechar255
menu_itemmitem_channel_idint unsigned100
menu_itemmitem_descchar255
menu_itemmitem_flagsint100
menu_itemmitem_linkchar255
menu_itemmitem_menu_idint unsigned100
menu_itemmitem_orderint100
notifymsgmediumtext16777215
profilemusictext65535
addonnamechar255
clientsnametext65535 √ null
fcontactnamechar255
fsuggestnamechar255
groupsnamechar255
notifynamechar255
profilenamechar255
fcontactnetworkchar32
fcontactnickchar255
eventnofinishbit00
fsuggestnotetext65535
fcontactnotifychar255
objobj_channelint unsigned100
objobj_objchar255
objobj_pagechar64
itemobj_typechar255
objobj_typeint unsigned100
objobj_verbchar255
itemobjecttext65535
termoidint unsigned100
attachos_pathmediumtext16777215
photoos_pathmediumtext16777215
attachos_storagebit00
photoos_storagebit00
notifyotypechar16
termotypetinyint unsigned30
outqoutq_accountint unsigned100
outqoutq_asyncbit00
outqoutq_channelint unsigned100
outqoutq_createddatetime190000-00-00 00:00:00
outqoutq_deliveredbit00
outqoutq_driverchar32
outqoutq_hashchar255
outqoutq_msgmediumtext16777215
outqoutq_notifymediumtext16777215
outqoutq_posturlchar255
outqoutq_prioritysmallint50
outqoutq_updateddatetime190000-00-00 00:00:00
itemowner_xchanchar255
itemparentint unsigned100
notifyparentchar255
termparent_hashchar255
itemparent_midchar255
mailparent_midchar255
registerpasswordchar255
profilepdescchar255
poll_elmpelm_desctext65535
poll_elmpelm_flagsint100
poll_elmpelm_pollint unsigned100
poll_elmpelm_resultfloat120
fcontactphotochar255
fsuggestphotochar255
notifyphotochar255
profilephotochar255
photophoto_flagsint unsigned100
photophoto_usagesmallint50
itemplinkchar255
addonplugin_adminbit00
profilepoliticchar255
fcontactpollchar255
pollpoll_channelint unsigned100
pollpoll_desctext65535
pollpoll_flagsint100
pollpoll_votesint100
profilepostal_codechar32
itempostoptstext65535
fserverposturlchar255
fcontactprioritybit0
hookpriorityint unsigned100
photoprofilebit00
profileprofile_guidchar64
profileprofile_namechar255
fcontactpubkeytext65535
sys_permspublic_permbit00
itempublic_policychar255
profilepublishbit00
clientspwvarchar20
itemreceiveddatetime190000-00-00 00:00:00
convrecipsmediumtext16777215
auth_codesredirect_urivarchar200
clientsredirect_urivarchar200
profileregionchar255
profilereligionchar255
fcontactrequestchar255
fsuggestrequestchar255
itemresource_idchar255
photoresource_idchar255
itemresource_typechar16
signretract_iidint unsigned100
attachrevisionint unsigned100
itemrevisionint unsigned100
profileromancetext65535
itemroutetext65535
photoscaletinyint30
auth_codesscopevarchar250
tokensscopevarchar200
profile_checksecchar255
tokenssecrettext65535
notifyseenbit00
fserverserverchar255
item_idservicechar255
profilesexualchar255
sharesshare_targetint unsigned100
sharesshare_typeint100
sharesshare_xchanchar255
item_idsidchar255
sessionsidchar255
itemsigtext65535
mailsigtext65535
signsignaturetext65535
signsigned_textmediumtext16777215
signsignerchar255
sitesite_accessint100
sitesite_deadsmallint50
sitesite_directorychar255
sitesite_flagsint100
sitesite_locationchar255
sitesite_pulldatetime190000-00-00 00:00:00
sitesite_realmchar255
sitesite_registerint100
sitesite_sellpagechar255
sitesite_syncdatetime190000-00-00 00:00:00
sitesite_updatedatetime190000-00-00 00:00:00
sitesite_urlchar255
sitesite_validsmallint50
photosizeint unsigned100
itemsource_xchanchar255
spamspamint100
sourcesrc_channel_idint unsigned100
sourcesrc_channel_xchanchar255
sourcesrc_pattmediumtext16777215
sourcesrc_xchanchar255
eventstartdatetime190000-00-00 00:00:00
convsubjectmediumtext16777215
eventsummarytext65535
profilesummarychar255
itemtargettext65535
likestargetmediumtext16777215
likestarget_idchar128
likestarget_typechar255
spamtermchar255
termtermchar255
termterm_hashchar255
itemtgt_typechar255
itemthr_parentchar255
profilethumbchar255
addontimestampbigint190
itemtitletext65535
mailtitletext65535
phototitlechar255
mailto_xchanchar255
verifytokenchar255
profiletvtext65535
eventtypechar255
notifytypeint100
phototypechar128image/jpeg
termtypetinyint unsigned30
verifytypechar32
updatesud_addrchar255
updatesud_datedatetime190000-00-00 00:00:00
updatesud_flagsint100
updatesud_guidchar255
updatesud_hashchar128
updatesud_lastdatetime190000-00-00 00:00:00
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
cacheupdateddatetime190000-00-00 00:00:00
convupdateddatetime190000-00-00 00:00:00
fcontactupdateddatetime190000-00-00 00:00:00
fcontacturlchar255
fsuggesturlchar255
notifyurlchar255
termurlchar255
cachevtext65535
configvtext65535
pconfigvmediumtext16777215
profextvmediumtext16777215
sys_permsvmediumtext16777215
xconfigvmediumtext16777215
itemverbchar255
likesverbchar255
notifyverbchar255
addonversionchar255
groupsvisiblebit00
votevote_elementint100
votevote_pollint100
votevote_resulttext65535
votevote_xchanchar255
photowidthsmallint50
profilewithtext65535
profileworktext65535
group_memberxchanchar255
managexchanchar255
photoxchanchar255
xconfigxchanchar255
xignxchanchar255
xchanxchan_addrchar255
xchanxchan_censoredbit00
xchanxchan_connpagechar255
xchanxchan_connurlchar255
xchanxchan_deletedbit00
xchanxchan_flagsint unsigned100
xchanxchan_followchar255
xchanxchan_guidchar255
xchanxchan_guid_sigtext65535
xchanxchan_hashchar255
xchanxchan_hiddenbit00
xchanxchan_instance_urlchar255
xchanxchan_namechar255
xchanxchan_name_datedatetime190000-00-00 00:00:00
xchanxchan_networkchar255
xchanxchan_orphanbit00
xchanxchan_photo_datedatetime190000-00-00 00:00:00
xchanxchan_photo_lchar255
xchanxchan_photo_mchar255
xchanxchan_photo_mimetypechar32image/jpeg
xchanxchan_photo_schar255
xchanxchan_pubforumbit00
xchanxchan_pubkeytext65535
xchanxchan_selfcensoredbit00
xchanxchan_systembit00
xchanxchan_urlchar255
xchatxchat_descchar255
xchatxchat_editeddatetime190000-00-00 00:00:00
xchatxchat_urlchar255
xchatxchat_xchanchar255
xlinkxlink_linkchar255
xlinkxlink_ratingint100
xlinkxlink_rating_texttext65535
xlinkxlink_sigtext65535
xlinkxlink_staticbit00
xlinkxlink_updateddatetime190000-00-00 00:00:00
xlinkxlink_xchanchar255
xpermxp_channelint unsigned100
xpermxp_clientvarchar20
xpermxp_permvarchar64
xprofxprof_abouttext65535
xprofxprof_agetinyint unsigned30
xprofxprof_countrychar255
xprofxprof_descchar255
xprofxprof_dobchar12
xprofxprof_genderchar255
xprofxprof_hashchar255
xprofxprof_homepagechar255
xprofxprof_hometownchar255
xprofxprof_keywordstext65535
xprofxprof_localechar255
xprofxprof_maritalchar255
xprofxprof_postcodechar32
xprofxprof_regionchar255
xprofxprof_sexualchar255
xtagxtag_flagsint100
xtagxtag_hashchar255
xtagxtag_termchar255
+
+
+ + -- cgit v1.2.3