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.byTable.html | 7375 +++++++++++++++++++++++++++ 1 file changed, 7375 insertions(+) create mode 100644 doc/schemaspy_hubzilla/columns.byTable.html (limited to 'doc/schemaspy_hubzilla/columns.byTable.html') diff --git a/doc/schemaspy_hubzilla/columns.byTable.html b/doc/schemaspy_hubzilla/columns.byTable.html new file mode 100644 index 000000000..218b65362 --- /dev/null +++ b/doc/schemaspy_hubzilla/columns.byTable.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
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_idint unsigned10 √ 
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
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
accountaccount_idint unsigned10 √ 
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
addonhiddenbit00
addonidint10 √ 
addoninstalledbit00
addonnamechar255
addonplugin_adminbit00
addontimestampbigint190
addonversionchar255
appapp_addrchar255
appapp_authorchar255
appapp_channelint100
appapp_createddatetime190000-00-00 00:00:00
appapp_desctext65535
appapp_editeddatetime190000-00-00 00:00:00
appapp_idchar255
appapp_namechar255
appapp_pagechar255
appapp_photochar255
appapp_pricechar255
appapp_requireschar255
appapp_sigchar255
appapp_urlchar255
appapp_versionchar255
appidint10 √ 
attachaidint unsigned100
attachallow_cidmediumtext16777215
attachallow_gidmediumtext16777215
attachcreateddatetime190000-00-00 00:00:00
attachcreatorchar128
attachdatalongblob2147483647
attachdeny_cidmediumtext16777215
attachdeny_gidmediumtext16777215
attachdisplay_pathmediumtext16777215
attachediteddatetime190000-00-00 00:00:00
attachfilenamechar255
attachfilesizeint unsigned100
attachfiletypechar64
attachflagsint unsigned100
attachfolderchar64
attachhashchar64
attachidint unsigned10 √ 
attachis_dirbit00
attachis_photobit00
attachos_pathmediumtext16777215
attachos_storagebit00
attachrevisionint unsigned100
attachuidint unsigned100
auth_codesclient_idvarchar20
auth_codesexpiresint100
auth_codesidvarchar40
auth_codesredirect_urivarchar200
auth_codesscopevarchar250
cachekchar255
cacheupdateddatetime190000-00-00 00:00:00
cachevtext65535
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
channelchannel_idint unsigned10 √ 
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
chatchat_idint unsigned10 √ 
chatchat_roomint unsigned100
chatchat_textmediumtext16777215
chatchat_xchanchar255
chatcreateddatetime190000-00-00 00:00:00
chatpresencecp_clientchar128
chatpresencecp_idint unsigned10 √ 
chatpresencecp_lastdatetime190000-00-00 00:00:00
chatpresencecp_roomint unsigned100
chatpresencecp_statuschar255
chatpresencecp_xchanchar255
chatroomallow_cidmediumtext16777215
chatroomallow_gidmediumtext16777215
chatroomcr_aidint unsigned100
chatroomcr_createddatetime190000-00-00 00:00:00
chatroomcr_editeddatetime190000-00-00 00:00:00
chatroomcr_expireint unsigned100
chatroomcr_idint unsigned10 √ 
chatroomcr_namechar255
chatroomcr_uidint unsigned100
chatroomdeny_cidmediumtext16777215
chatroomdeny_gidmediumtext16777215
clientsclient_idvarchar20
clientsicontext65535 √ null
clientsnametext65535 √ null
clientspwvarchar20
clientsredirect_urivarchar200
clientsuidint100
configcatchar255
configidint unsigned10 √ 
configkchar255
configvtext65535
convcreateddatetime190000-00-00 00:00:00
convcreatorchar255
convguidchar255
convidint unsigned10 √ 
convrecipsmediumtext16777215
convsubjectmediumtext16777215
convuidint100
convupdateddatetime190000-00-00 00:00:00
dreportdreport_channelint100
dreportdreport_idint10 √ 
dreportdreport_midchar255
dreportdreport_queuechar255
dreportdreport_recipchar255
dreportdreport_resultchar255
dreportdreport_sitechar255
dreportdreport_timedatetime190000-00-00 00:00:00
dreportdreport_xchanchar255
eventadjustbit01
eventaidint unsigned100
eventallow_cidmediumtext16777215
eventallow_gidmediumtext16777215
eventcreateddatetime190000-00-00 00:00:00
eventdeny_cidmediumtext16777215
eventdeny_gidmediumtext16777215
eventdescriptiontext65535
eventediteddatetime190000-00-00 00:00:00
eventevent_hashchar255
eventevent_percentsmallint50
eventevent_prioritysmallint50
eventevent_repeattext65535
eventevent_sequencesmallint50
eventevent_statuschar255
eventevent_status_datedatetime190000-00-00 00:00:00
eventevent_vdatatext65535
eventevent_xchanchar255
eventfinishdatetime190000-00-00 00:00:00
eventidint10 √ 
eventignorebit00
eventlocationtext65535
eventnofinishbit00
eventstartdatetime190000-00-00 00:00:00
eventsummarytext65535
eventtypechar255
eventuidint100
fcontactaddrchar255
fcontactaliaschar255
fcontactbatchchar255
fcontactconfirmchar255
fcontactidint unsigned10 √ 
fcontactnamechar255
fcontactnetworkchar32
fcontactnickchar255
fcontactnotifychar255
fcontactphotochar255
fcontactpollchar255
fcontactprioritybit0
fcontactpubkeytext65535
fcontactrequestchar255
fcontactupdateddatetime190000-00-00 00:00:00
fcontacturlchar255
ffindercidint unsigned10
ffinderfidint unsigned10
ffinderidint unsigned10 √ 
ffinderuidint unsigned10
fserveridint10 √ 
fserverkeytext65535
fserverposturlchar255
fserverserverchar255
fsuggestcidint100
fsuggestcreateddatetime190000-00-00 00:00:00
fsuggestidint10 √ 
fsuggestnamechar255
fsuggestnotetext65535
fsuggestphotochar255
fsuggestrequestchar255
fsuggestuidint100
fsuggesturlchar255
group_membergidint unsigned100
group_memberidint unsigned10 √ 
group_memberuidint unsigned100
group_memberxchanchar255
groupsdeletedbit00
groupshashchar255
groupsidint unsigned10 √ 
groupsnamechar255
groupsuidint unsigned100
groupsvisiblebit00
hookfilechar255
hookfunctionchar255
hookhookchar255
hookidint10 √ 
hookpriorityint unsigned100
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_idint unsigned10 √ 
hublochubloc_networkchar32
hublochubloc_orphancheckbit00
hublochubloc_primarybit00
hublochubloc_sitekeytext65535
hublochubloc_statusint unsigned100
hublochubloc_updateddatetime190000-00-00 00:00:00
hublochubloc_urlchar255
hublochubloc_url_sigtext65535
issueissue_assignedchar255
issueissue_componentchar255
issueissue_createddatetime190000-00-00 00:00:00
issueissue_idint unsigned10 √ 
issueissue_priorityint100
issueissue_statusint100
issueissue_updateddatetime190000-00-00 00:00:00
itemaidint unsigned100
itemallow_cidmediumtext16777215
itemallow_gidmediumtext16777215
itemappchar255
itemattachmediumtext16777215
itemauthor_xchanchar255
itembodymediumtext16777215
itemchangeddatetime190000-00-00 00:00:00
itemcomment_policychar255
itemcommenteddatetime190000-00-00 00:00:00
itemcomments_closeddatetime190000-00-00 00:00:00
itemcoordchar255
itemcreateddatetime190000-00-00 00:00:00
itemdeny_cidmediumtext16777215
itemdeny_gidmediumtext16777215
itemdiaspora_metamediumtext16777215
itemediteddatetime190000-00-00 00:00:00
itemexpiresdatetime190000-00-00 00:00:00
itemhtmlmediumtext16777215
itemidint unsigned10 √ 
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
itemlangchar64
itemlayout_midchar255
itemllinkchar255
itemlocationchar255
itemmidchar255
itemmimetypechar255
itemobj_typechar255
itemobjecttext65535
itemowner_xchanchar255
itemparentint unsigned100
itemparent_midchar255
itemplinkchar255
itempostoptstext65535
itempublic_policychar255
itemreceiveddatetime190000-00-00 00:00:00
itemresource_idchar255
itemresource_typechar16
itemrevisionint unsigned100
itemroutetext65535
itemsigtext65535
itemsource_xchanchar255
itemtargettext65535
itemtgt_typechar255
itemthr_parentchar255
itemtitletext65535
itemuidint unsigned100
itemverbchar255
item_ididint unsigned10 √ 
item_idiidint100
item_idservicechar255
item_idsidchar255
item_iduidint100
likeschannel_idint unsigned100
likesi_midchar255
likesidint unsigned10 √ 
likesiidint unsigned100
likeslikeechar128
likeslikerchar128
likestargetmediumtext16777215
likestarget_idchar128
likestarget_typechar255
likesverbchar255
mailaccount_idint unsigned100
mailattachmediumtext16777215
mailbodymediumtext16777215
mailchannel_idint unsigned100
mailconv_guidchar255
mailconvidint unsigned100
mailcreateddatetime190000-00-00 00:00:00
mailexpiresdatetime190000-00-00 00:00:00
mailfrom_xchanchar255
mailidint unsigned10 √ 
mailmail_deletedtinyint30
mailmail_flagsint unsigned100
mailmail_isreplytinyint30
mailmail_obscuredsmallint50
mailmail_recalledtinyint30
mailmail_repliedtinyint30
mailmail_seentinyint30
mailmidchar255
mailparent_midchar255
mailsigtext65535
mailtitletext65535
mailto_xchanchar255
manageidint10 √ 
manageuidint100
managexchanchar255
menumenu_channel_idint unsigned100
menumenu_createddatetime190000-00-00 00:00:00
menumenu_descchar255
menumenu_editeddatetime190000-00-00 00:00:00
menumenu_flagsint100
menumenu_idint unsigned10 √ 
menumenu_namechar255
menu_itemallow_cidmediumtext16777215
menu_itemallow_gidmediumtext16777215
menu_itemdeny_cidmediumtext16777215
menu_itemdeny_gidmediumtext16777215
menu_itemmitem_channel_idint unsigned100
menu_itemmitem_descchar255
menu_itemmitem_flagsint100
menu_itemmitem_idint unsigned10 √ 
menu_itemmitem_linkchar255
menu_itemmitem_menu_idint unsigned100
menu_itemmitem_orderint100
notifyaidint100
notifydatedatetime190000-00-00 00:00:00
notifyhashchar64
notifyidint10 √ 
notifylinkchar255
notifymsgmediumtext16777215
notifynamechar255
notifyotypechar16
notifyparentchar255
notifyphotochar255
notifyseenbit00
notifytypeint100
notifyuidint100
notifyurlchar255
notifyverbchar255
objallow_cidmediumtext16777215
objallow_gidmediumtext16777215
objdeny_cidmediumtext16777215
objdeny_gidmediumtext16777215
objobj_channelint unsigned100
objobj_createddatetime190000-00-00 00:00:00
objobj_editeddatetime190000-00-00 00:00:00
objobj_idint unsigned10 √ 
objobj_imgurlchar255
objobj_objchar255
objobj_pagechar64
objobj_termchar255
objobj_typeint unsigned100
objobj_urlchar255
objobj_verbchar255
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
pconfigcatchar255
pconfigidint10 √ 
pconfigkchar255
pconfiguidint100
pconfigvmediumtext16777215
photoaidint unsigned100
photoalbumchar255
photoallow_cidmediumtext16777215
photoallow_gidmediumtext16777215
photocreateddatetime190000-00-00 00:00:00
photodatamediumblob16777215
photodeny_cidmediumtext16777215
photodeny_gidmediumtext16777215
photodescriptiontext65535
photodisplay_pathmediumtext16777215
photoediteddatetime190000-00-00 00:00:00
photofilenamechar255
photoheightsmallint50
photoidint unsigned10 √ 
photois_nsfwbit00
photoos_pathmediumtext16777215
photoos_storagebit00
photophoto_flagsint unsigned100
photophoto_usagesmallint50
photoprofilebit00
photoresource_idchar255
photoscaletinyint30
photosizeint unsigned100
phototitlechar255
phototypechar128image/jpeg
photouidint unsigned100
photowidthsmallint50
photoxchanchar255
pollpoll_channelint unsigned100
pollpoll_desctext65535
pollpoll_flagsint100
pollpoll_idint unsigned10 √ 
pollpoll_votesint100
poll_elmpelm_desctext65535
poll_elmpelm_flagsint100
poll_elmpelm_idint unsigned10 √ 
poll_elmpelm_pollint unsigned100
poll_elmpelm_resultfloat120
profdeffield_descchar255
profdeffield_helpchar255
profdeffield_inputsmediumtext16777215
profdeffield_namechar255
profdeffield_typechar16
profdefidint unsigned10 √ 
profextchannel_idint unsigned100
profexthashchar255
profextidint unsigned10 √ 
profextkchar255
profextvmediumtext16777215
profileabouttext65535
profileaddresschar255
profileaidint unsigned100
profilebooktext65535
profilechandesctext65535
profilechannelstext65535
profilecontacttext65535
profilecountry_namechar255
profiledislikestext65535
profiledobchar320000-00-00
profiledob_tzchar255UTC
profileeducationtext65535
profilefilmtext65535
profilegenderchar32
profilehide_friendsbit00
profilehomepagechar255
profilehometownchar255
profilehowlongdatetime190000-00-00 00:00:00
profileidint10 √ 
profileinteresttext65535
profileis_defaultbit00
profilekeywordstext65535
profilelikestext65535
profilelocalitychar255
profilemaritalchar255
profilemusictext65535
profilenamechar255
profilepdescchar255
profilephotochar255
profilepoliticchar255
profilepostal_codechar32
profileprofile_guidchar64
profileprofile_namechar255
profilepublishbit00
profileregionchar255
profilereligionchar255
profileromancetext65535
profilesexualchar255
profilesummarychar255
profilethumbchar255
profiletvtext65535
profileuidint100
profilewithtext65535
profileworktext65535
profile_checkcidint unsigned100
profile_checkdfrn_idchar255
profile_checkexpireint100
profile_checkidint unsigned10 √ 
profile_checksecchar255
profile_checkuidint unsigned100
registercreateddatetime190000-00-00 00:00:00
registerhashchar255
registeridint unsigned10 √ 
registerlanguagechar16
registerpasswordchar255
registeruidint unsigned100
sessiondatatext65535
sessionexpirebigint unsigned200
sessionidbigint unsigned20 √ 
sessionsidchar255
sharesshare_idint unsigned10 √ 
sharesshare_targetint unsigned100
sharesshare_typeint100
sharesshare_xchanchar255
signidint unsigned10 √ 
signiidint unsigned100
signretract_iidint unsigned100
signsignaturetext65535
signsigned_textmediumtext16777215
signsignerchar255
sitesite_accessint100
sitesite_deadsmallint50
sitesite_directorychar255
sitesite_flagsint100
sitesite_locationchar255
sitesite_projectchar255
sitesite_pulldatetime190000-00-00 00:00:00
sitesite_realmchar255
sitesite_registerint100
sitesite_sellpagechar255
sitesite_syncdatetime190000-00-00 00:00:00
sitesite_typesmallint50
sitesite_updatedatetime190000-00-00 00:00:00
sitesite_urlchar255
sitesite_validsmallint50
sourcesrc_channel_idint unsigned100
sourcesrc_channel_xchanchar255
sourcesrc_idint unsigned10 √ 
sourcesrc_pattmediumtext16777215
sourcesrc_xchanchar255
spamdatedatetime190000-00-00 00:00:00
spamhamint100
spamidint10 √ 
spamspamint100
spamtermchar255
spamuidint100
sys_permscatchar255
sys_permsidint unsigned10 √ 
sys_permskchar255
sys_permspublic_permbit00
sys_permsvmediumtext16777215
termaidint unsigned100
termimgurlchar255
termoidint unsigned100
termotypetinyint unsigned30
termparent_hashchar255
termtermchar255
termterm_hashchar255
termtidint unsigned10 √ 
termtypetinyint unsigned30
termuidint unsigned100
termurlchar255
tokensclient_idvarchar20
tokensexpiresbigint unsigned200
tokensidvarchar40
tokensscopevarchar200
tokenssecrettext65535
tokensuidint100
updatesud_addrchar255
updatesud_datedatetime190000-00-00 00:00:00
updatesud_flagsint100
updatesud_guidchar255
updatesud_hashchar128
updatesud_idint unsigned10 √ 
updatesud_lastdatetime190000-00-00 00:00:00
verifychannelint unsigned100
verifycreateddatetime190000-00-00 00:00:00
verifyidint unsigned10 √ 
verifymetachar255
verifytokenchar255
verifytypechar32
votevote_elementint100
votevote_idint unsigned10 √ 
votevote_pollint100
votevote_resulttext65535
votevote_xchanchar255
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_idint unsigned10 √ 
xchatxchat_urlchar255
xchatxchat_xchanchar255
xconfigcatchar255
xconfigidint unsigned10 √ 
xconfigkchar255
xconfigvmediumtext16777215
xconfigxchanchar255
xignidint unsigned10 √ 
xignuidint100
xignxchanchar255
xlinkxlink_idint unsigned10 √ 
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_idint unsigned10 √ 
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_idint unsigned10 √ 
xtagxtag_termchar255
+
+
+ + -- cgit v1.2.3