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/tables/abook.html | 502 +++++++++++++ hubzilla_er/tables/account.html | 417 +++++++++++ hubzilla_er/tables/addon.html | 255 +++++++ hubzilla_er/tables/app.html | 356 +++++++++ hubzilla_er/tables/attach.html | 513 +++++++++++++ hubzilla_er/tables/auth_codes.html | 216 ++++++ hubzilla_er/tables/cache.html | 215 ++++++ hubzilla_er/tables/channel.html | 924 +++++++++++++++++++++++ hubzilla_er/tables/chat.html | 202 +++++ hubzilla_er/tables/chatpresence.html | 219 ++++++ hubzilla_er/tables/chatroom.html | 286 +++++++ hubzilla_er/tables/clients.html | 224 ++++++ hubzilla_er/tables/config.html | 231 ++++++ hubzilla_er/tables/conv.html | 270 +++++++ hubzilla_er/tables/event.html | 507 +++++++++++++ hubzilla_er/tables/fcontact.html | 358 +++++++++ hubzilla_er/tables/ffinder.html | 232 ++++++ hubzilla_er/tables/fserver.html | 216 ++++++ hubzilla_er/tables/fsuggest.html | 259 +++++++ hubzilla_er/tables/group_member.html | 232 ++++++ hubzilla_er/tables/groups.html | 260 +++++++ hubzilla_er/tables/hook.html | 221 ++++++ hubzilla_er/tables/hubloc.html | 433 +++++++++++ hubzilla_er/tables/issue.html | 242 ++++++ hubzilla_er/tables/item.html | 1315 +++++++++++++++++++++++++++++++++ hubzilla_er/tables/item_id.html | 249 +++++++ hubzilla_er/tables/likes.html | 321 ++++++++ hubzilla_er/tables/mail.html | 517 +++++++++++++ hubzilla_er/tables/manage.html | 205 +++++ hubzilla_er/tables/menu.html | 236 ++++++ hubzilla_er/tables/menu_item.html | 268 +++++++ hubzilla_er/tables/notify.html | 434 +++++++++++ hubzilla_er/tables/obj.html | 269 +++++++ hubzilla_er/tables/outq.html | 309 ++++++++ hubzilla_er/tables/pconfig.html | 235 ++++++ hubzilla_er/tables/photo.html | 556 ++++++++++++++ hubzilla_er/tables/poll.html | 202 +++++ hubzilla_er/tables/poll_elm.html | 196 +++++ hubzilla_er/tables/profdef.html | 242 ++++++ hubzilla_er/tables/profext.html | 264 +++++++ hubzilla_er/tables/profile.html | 728 ++++++++++++++++++ hubzilla_er/tables/profile_check.html | 266 +++++++ hubzilla_er/tables/register.html | 254 +++++++ hubzilla_er/tables/session.html | 185 +++++ hubzilla_er/tables/shares.html | 191 +++++ hubzilla_er/tables/sign.html | 248 +++++++ hubzilla_er/tables/site.html | 332 +++++++++ hubzilla_er/tables/source.html | 202 +++++ hubzilla_er/tables/spam.html | 250 +++++++ hubzilla_er/tables/sys_perms.html | 236 ++++++ hubzilla_er/tables/term.html | 304 ++++++++ hubzilla_er/tables/tokens.html | 245 ++++++ hubzilla_er/tables/updates.html | 242 ++++++ hubzilla_er/tables/verify.html | 383 ++++++++++ hubzilla_er/tables/vote.html | 202 +++++ hubzilla_er/tables/xchan.html | 511 +++++++++++++ hubzilla_er/tables/xchat.html | 208 ++++++ hubzilla_er/tables/xconfig.html | 254 +++++++ hubzilla_er/tables/xign.html | 215 ++++++ hubzilla_er/tables/xlink.html | 247 +++++++ hubzilla_er/tables/xperm.html | 191 +++++ hubzilla_er/tables/xprof.html | 360 +++++++++ hubzilla_er/tables/xtag.html | 191 +++++ 63 files changed, 20053 insertions(+) create mode 100644 hubzilla_er/tables/abook.html create mode 100644 hubzilla_er/tables/account.html create mode 100644 hubzilla_er/tables/addon.html create mode 100644 hubzilla_er/tables/app.html create mode 100644 hubzilla_er/tables/attach.html create mode 100644 hubzilla_er/tables/auth_codes.html create mode 100644 hubzilla_er/tables/cache.html create mode 100644 hubzilla_er/tables/channel.html create mode 100644 hubzilla_er/tables/chat.html create mode 100644 hubzilla_er/tables/chatpresence.html create mode 100644 hubzilla_er/tables/chatroom.html create mode 100644 hubzilla_er/tables/clients.html create mode 100644 hubzilla_er/tables/config.html create mode 100644 hubzilla_er/tables/conv.html create mode 100644 hubzilla_er/tables/event.html create mode 100644 hubzilla_er/tables/fcontact.html create mode 100644 hubzilla_er/tables/ffinder.html create mode 100644 hubzilla_er/tables/fserver.html create mode 100644 hubzilla_er/tables/fsuggest.html create mode 100644 hubzilla_er/tables/group_member.html create mode 100644 hubzilla_er/tables/groups.html create mode 100644 hubzilla_er/tables/hook.html create mode 100644 hubzilla_er/tables/hubloc.html create mode 100644 hubzilla_er/tables/issue.html create mode 100644 hubzilla_er/tables/item.html create mode 100644 hubzilla_er/tables/item_id.html create mode 100644 hubzilla_er/tables/likes.html create mode 100644 hubzilla_er/tables/mail.html create mode 100644 hubzilla_er/tables/manage.html create mode 100644 hubzilla_er/tables/menu.html create mode 100644 hubzilla_er/tables/menu_item.html create mode 100644 hubzilla_er/tables/notify.html create mode 100644 hubzilla_er/tables/obj.html create mode 100644 hubzilla_er/tables/outq.html create mode 100644 hubzilla_er/tables/pconfig.html create mode 100644 hubzilla_er/tables/photo.html create mode 100644 hubzilla_er/tables/poll.html create mode 100644 hubzilla_er/tables/poll_elm.html create mode 100644 hubzilla_er/tables/profdef.html create mode 100644 hubzilla_er/tables/profext.html create mode 100644 hubzilla_er/tables/profile.html create mode 100644 hubzilla_er/tables/profile_check.html create mode 100644 hubzilla_er/tables/register.html create mode 100644 hubzilla_er/tables/session.html create mode 100644 hubzilla_er/tables/shares.html create mode 100644 hubzilla_er/tables/sign.html create mode 100644 hubzilla_er/tables/site.html create mode 100644 hubzilla_er/tables/source.html create mode 100644 hubzilla_er/tables/spam.html create mode 100644 hubzilla_er/tables/sys_perms.html create mode 100644 hubzilla_er/tables/term.html create mode 100644 hubzilla_er/tables/tokens.html create mode 100644 hubzilla_er/tables/updates.html create mode 100644 hubzilla_er/tables/verify.html create mode 100644 hubzilla_er/tables/vote.html create mode 100644 hubzilla_er/tables/xchan.html create mode 100644 hubzilla_er/tables/xchat.html create mode 100644 hubzilla_er/tables/xconfig.html create mode 100644 hubzilla_er/tables/xign.html create mode 100644 hubzilla_er/tables/xlink.html create mode 100644 hubzilla_er/tables/xperm.html create mode 100644 hubzilla_er/tables/xprof.html create mode 100644 hubzilla_er/tables/xtag.html (limited to 'hubzilla_er/tables') diff --git a/hubzilla_er/tables/abook.html b/hubzilla_er/tables/abook.html new file mode 100644 index 000000000..7e103df6f --- /dev/null +++ b/hubzilla_er/tables/abook.html @@ -0,0 +1,502 @@ + + + + + SchemaSpy - Table zot.abook + + + + + + + +
+ +
+
+ + + + + +
Table zot.abookGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
abook_idint unsigned10 √ 
abook_accountint unsigned100
abook_channelint unsigned100
abook_xchanchar255
abook_my_permsint100
abook_their_permsint100
abook_closenesstinyint unsigned399
abook_createddatetime190000-00-00 00:00:00
abook_updateddatetime190000-00-00 00:00:00
abook_connecteddatetime190000-00-00 00:00:00
abook_dobdatetime190000-00-00 00:00:00
abook_flagsint100
abook_blockedtinyint30
abook_ignoredtinyint30
abook_hiddentinyint30
abook_archivedtinyint30
abook_pendingtinyint30
abook_unconnectedtinyint30
abook_selftinyint30
abook_feedtinyint30
abook_profilechar64
abook_incltext65535
abook_excltext65535
+

Table contained 12 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
abook_idPrimary keyAscPRIMARY
abook_accountPerformanceAscabook_account
abook_archivedPerformanceAscabook_archived
abook_blockedPerformanceAscabook_blocked
abook_channelPerformanceAscabook_channel
abook_closenessPerformanceAscabook_closeness
abook_connectedPerformanceAscabook_connected
abook_createdPerformanceAscabook_created
abook_dobPerformanceAscabook_dob
abook_feedPerformanceAscabook_feed
abook_flagsPerformanceAscabook_flags
abook_hiddenPerformanceAscabook_hidden
abook_ignoredPerformanceAscabook_ignored
abook_my_permsPerformanceAscabook_my_perms
abook_pendingPerformanceAscabook_pending
abook_profilePerformanceAscabook_profile
abook_selfPerformanceAscabook_self
abook_their_permsPerformanceAscabook_their_perms
abook_unconnectedPerformanceAscabook_unconnected
abook_updatedPerformanceAscabook_updated
abook_xchanPerformanceAscabook_xchan
+
+
+ + diff --git a/hubzilla_er/tables/account.html b/hubzilla_er/tables/account.html new file mode 100644 index 000000000..cd2e46eb1 --- /dev/null +++ b/hubzilla_er/tables/account.html @@ -0,0 +1,417 @@ + + + + + SchemaSpy - Table zot.account + + + + + + + +
+ +
+
+ + + + + +
Table zot.accountGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
account_idint unsigned10 √  + + + + + +
mail.account_id + Implied Constraint R
+
account_parentint unsigned100
account_default_channelint unsigned100
account_saltchar32
account_passwordchar255
account_emailchar255
account_externalchar255
account_languagechar16en
account_createddatetime190000-00-00 00:00:00
account_lastlogdatetime190000-00-00 00:00:00
account_flagsint unsigned100
account_rolesint unsigned100
account_resetchar255
account_expiresdatetime190000-00-00 00:00:00
account_expire_notifieddatetime190000-00-00 00:00:00
account_service_classchar32
account_levelint unsigned100
account_password_changeddatetime190000-00-00 00:00:00
+

Table contained 1 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
account_idPrimary keyAscPRIMARY
account_default_channelPerformanceAscaccount_default_channel
account_emailPerformanceAscaccount_email
account_expiresPerformanceAscaccount_expires
account_externalPerformanceAscaccount_external
account_flagsPerformanceAscaccount_flags
account_lastlogPerformanceAscaccount_lastlog
account_levelPerformanceAscaccount_level
account_parentPerformanceAscaccount_parent
account_password_changedPerformanceAscaccount_password_changed
account_rolesPerformanceAscaccount_roles
account_service_classPerformanceAscaccount_service_class
+
+
+
Close relationships:
+ + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/addon.html b/hubzilla_er/tables/addon.html new file mode 100644 index 000000000..512eac7d1 --- /dev/null +++ b/hubzilla_er/tables/addon.html @@ -0,0 +1,255 @@ + + + + + SchemaSpy - Table zot.addon + + + + + + + +
+ +
+
+ + + + + +
Table zot.addonGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + +
notify.id + Implied Constraint R
+
namechar255
versionchar255
installedbit00
hiddenbit00
timestampbigint190
plugin_adminbit00
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
hiddenPerformanceAschidden
installedPerformanceAscinstalled
namePerformanceAscname
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/app.html b/hubzilla_er/tables/app.html new file mode 100644 index 000000000..0189a9224 --- /dev/null +++ b/hubzilla_er/tables/app.html @@ -0,0 +1,356 @@ + + + + + SchemaSpy - Table zot.app + + + + + + + +
+ +
+
+ + + + + +
Table zot.appGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + +
notify.id + Implied Constraint R
+
app_idchar255
app_sigchar255
app_authorchar255
app_namechar255
app_desctext65535
app_urlchar255
app_photochar255
app_versionchar255
app_channelint100
app_addrchar255
app_pricechar255
app_pagechar255
app_requireschar255
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
app_channelPerformanceAscapp_channel
app_idPerformanceAscapp_id
app_namePerformanceAscapp_name
app_photoPerformanceAscapp_photo
app_pricePerformanceAscapp_price
app_urlPerformanceAscapp_url
app_versionPerformanceAscapp_version
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/attach.html b/hubzilla_er/tables/attach.html new file mode 100644 index 000000000..ea0353d38 --- /dev/null +++ b/hubzilla_er/tables/attach.html @@ -0,0 +1,513 @@ + + + + + SchemaSpy - Table zot.attach + + + + + + + +
+ +
+
+ + + + + +
Table zot.attachGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
aidint unsigned100
uidint unsigned100
hashchar64
creatorchar128
filenamechar255
filetypechar64
filesizeint unsigned100
revisionint unsigned100
folderchar64
flagsint unsigned100
is_dirbit00
is_photobit00
os_storagebit00
os_pathmediumtext16777215
display_pathmediumtext16777215
datalongblob2147483647
createddatetime190000-00-00 00:00:00
editeddatetime190000-00-00 00:00:00
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
createdPerformanceAsccreated
creatorPerformanceAsccreator
editedPerformanceAscedited
filenamePerformanceAscfilename
filesizePerformanceAscfilesize
filetypePerformanceAscfiletype
flagsPerformanceAscflags
folderPerformanceAscfolder
hashPerformanceAschash
is_dirPerformanceAscis_dir
is_photoPerformanceAscis_photo
os_storagePerformanceAscos_storage
revisionPerformanceAscrevision
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/auth_codes.html b/hubzilla_er/tables/auth_codes.html new file mode 100644 index 000000000..842fb3c15 --- /dev/null +++ b/hubzilla_er/tables/auth_codes.html @@ -0,0 +1,216 @@ + + + + + SchemaSpy - Table zot.auth_codes + + + + + + + +
+ +
+
+ + + + + +
Table zot.auth_codesGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idvarchar40 + + + + + +
tokens.id + Implied Constraint R
+
client_idvarchar20 + + + + + +
clients.client_id + Implied Constraint R
+
redirect_urivarchar200
expiresint100
scopevarchar250
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
+
+
+
Close relationships:
+ + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/cache.html b/hubzilla_er/tables/cache.html new file mode 100644 index 000000000..e6238f822 --- /dev/null +++ b/hubzilla_er/tables/cache.html @@ -0,0 +1,215 @@ + + + + + SchemaSpy - Table zot.cache + + + + + + + +
+ +
+
+ + + + + +
Table zot.cacheGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
kchar255 + + + + + + + + + + + + + + + + + + + + + +
config.k + Implied Constraint R
pconfig.k + Implied Constraint R
profext.k + Implied Constraint R
sys_perms.k + Implied Constraint R
xconfig.k + Implied Constraint R
+
vtext65535
updateddatetime190000-00-00 00:00:00
+

Table contained 21 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
kPrimary keyAscPRIMARY
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/channel.html b/hubzilla_er/tables/channel.html new file mode 100644 index 000000000..1222058de --- /dev/null +++ b/hubzilla_er/tables/channel.html @@ -0,0 +1,924 @@ + + + + + SchemaSpy - Table zot.channel + + + + + + + +
+ +
+
+ + + + + +
Table zot.channelGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
channel_idint unsigned10 √  + + + + + + + + + + + + + +
likes.channel_id + Implied Constraint R
mail.channel_id + Implied Constraint R
profext.channel_id + Implied Constraint R
+
channel_account_idint unsigned100
channel_primarybit00
channel_namechar255
channel_addresschar255
channel_guidchar255
channel_guid_sigtext65535
channel_hashchar255
channel_timezonechar128UTC
channel_locationchar255
channel_themechar255
channel_startpagechar255
channel_pubkeytext65535
channel_prvkeytext65535
channel_notifyflagsint unsigned1065535
channel_pageflagsint unsigned100
channel_dirdatedatetime190000-00-00 00:00:00
channel_lastpostdatetime190000-00-00 00:00:00
channel_deleteddatetime190000-00-00 00:00:00
channel_max_anon_mailint unsigned1010
channel_max_friend_reqint unsigned1010
channel_expire_daysint100
channel_passwd_resetchar255
channel_default_groupchar255
channel_allow_cidmediumtext16777215
channel_allow_gidmediumtext16777215
channel_deny_cidmediumtext16777215
channel_deny_gidmediumtext16777215
channel_r_streamint unsigned100
channel_r_profileint unsigned100
channel_r_photosint unsigned100
channel_r_abookint unsigned100
channel_w_streamint unsigned100
channel_w_wallint unsigned100
channel_w_tagwallint unsigned100
channel_w_commentint unsigned100
channel_w_mailint unsigned100
channel_w_photosint unsigned100
channel_w_chatint unsigned100
channel_a_delegateint unsigned100
channel_r_storageint unsigned100
channel_w_storageint unsigned100
channel_r_pagesint unsigned100
channel_w_pagesint unsigned100
channel_a_republishint unsigned100
channel_w_likeint unsigned100
channel_removedbit00
channel_systembit00
+

Table contained 5 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
channel_idPrimary keyAscPRIMARY
channel_a_delegatePerformanceAscchannel_a_delegate
channel_a_republishPerformanceAscchannel_a_republish
channel_account_idPerformanceAscchannel_account_id
channel_addressMust be uniqueAscchannel_address_unique
channel_default_groupPerformanceAscchannel_default_gid
channel_deletedPerformanceAscchannel_deleted
channel_dirdatePerformanceAscchannel_dirdate
channel_expire_daysPerformanceAscchannel_expire_days
channel_guidPerformanceAscchannel_guid
channel_hashPerformanceAscchannel_hash
channel_lastpostPerformanceAscchannel_lastpost
channel_locationPerformanceAscchannel_location
channel_max_anon_mailPerformanceAscchannel_max_anon_mail
channel_max_friend_reqPerformanceAscchannel_max_friend_req
channel_namePerformanceAscchannel_name
channel_notifyflagsPerformanceAscchannel_notifyflags
channel_pageflagsPerformanceAscchannel_pageflags
channel_primaryPerformanceAscchannel_primary
channel_r_abookPerformanceAscchannel_r_abook
channel_r_pagesPerformanceAscchannel_r_pages
channel_r_photosPerformanceAscchannel_r_photos
channel_r_profilePerformanceAscchannel_r_profile
channel_r_storagePerformanceAscchannel_r_storage
channel_r_streamPerformanceAscchannel_r_stream
channel_removedPerformanceAscchannel_removed
channel_systemPerformanceAscchannel_system
channel_themePerformanceAscchannel_theme
channel_timezonePerformanceAscchannel_timezone
channel_w_chatPerformanceAscchannel_w_chat
channel_w_commentPerformanceAscchannel_w_comment
channel_w_likePerformanceAscchannel_w_like
channel_w_mailPerformanceAscchannel_w_mail
channel_w_pagesPerformanceAscchannel_w_pages
channel_w_photosPerformanceAscchannel_w_photos
channel_w_storagePerformanceAscchannel_w_storage
channel_w_streamPerformanceAscchannel_w_stream
channel_w_tagwallPerformanceAscchannel_w_tagwall
channel_w_wallPerformanceAscchannel_w_wall
+
+
+
Close relationships:
+ + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/chat.html b/hubzilla_er/tables/chat.html new file mode 100644 index 000000000..fb914f215 --- /dev/null +++ b/hubzilla_er/tables/chat.html @@ -0,0 +1,202 @@ + + + + + SchemaSpy - Table zot.chat + + + + + + + +
+ +
+
+ + + + + +
Table zot.chatGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
chat_idint unsigned10 √ 
chat_roomint unsigned100
chat_xchanchar255
chat_textmediumtext16777215
createddatetime190000-00-00 00:00:00
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
chat_idPrimary keyAscPRIMARY
chat_roomPerformanceAscchat_room
chat_xchanPerformanceAscchat_xchan
createdPerformanceAsccreated
+
+
+ + diff --git a/hubzilla_er/tables/chatpresence.html b/hubzilla_er/tables/chatpresence.html new file mode 100644 index 000000000..9b6c8c7f0 --- /dev/null +++ b/hubzilla_er/tables/chatpresence.html @@ -0,0 +1,219 @@ + + + + + SchemaSpy - Table zot.chatpresence + + + + + + + +
+ +
+
+ + + + + +
Table zot.chatpresenceGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
cp_idint unsigned10 √ 
cp_roomint unsigned100
cp_xchanchar255
cp_lastdatetime190000-00-00 00:00:00
cp_statuschar255
cp_clientchar128
+

Table contained 1 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
cp_idPrimary keyAscPRIMARY
cp_lastPerformanceAsccp_last
cp_roomPerformanceAsccp_room
cp_statusPerformanceAsccp_status
cp_xchanPerformanceAsccp_xchan
+
+
+ + diff --git a/hubzilla_er/tables/chatroom.html b/hubzilla_er/tables/chatroom.html new file mode 100644 index 000000000..cb7db7985 --- /dev/null +++ b/hubzilla_er/tables/chatroom.html @@ -0,0 +1,286 @@ + + + + + SchemaSpy - Table zot.chatroom + + + + + + + +
+ +
+
+ + + + + +
Table zot.chatroomGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
cr_idint unsigned10 √ 
cr_aidint unsigned100
cr_uidint unsigned100
cr_namechar255
cr_createddatetime190000-00-00 00:00:00
cr_editeddatetime190000-00-00 00:00:00
cr_expireint unsigned100
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
cr_idPrimary keyAscPRIMARY
cr_aidPerformanceAsccr_aid
cr_createdPerformanceAsccr_created
cr_editedPerformanceAsccr_edited
cr_expirePerformanceAsccr_expire
cr_namePerformanceAsccr_name
cr_uidPerformanceAsccr_uid
+
+
+ + diff --git a/hubzilla_er/tables/clients.html b/hubzilla_er/tables/clients.html new file mode 100644 index 000000000..81d48f281 --- /dev/null +++ b/hubzilla_er/tables/clients.html @@ -0,0 +1,224 @@ + + + + + SchemaSpy - Table zot.clients + + + + + + + +
+ +
+
+ + + + + +
Table zot.clientsGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
client_idvarchar20 + + + + + + + + + +
auth_codes.client_id + Implied Constraint R
tokens.client_id + Implied Constraint R
+
pwvarchar20
redirect_urivarchar200
nametext65535 √ null
icontext65535 √ null
uidint100
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
client_idPrimary keyAscPRIMARY
+
+
+
Close relationships:
+ + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/config.html b/hubzilla_er/tables/config.html new file mode 100644 index 000000000..62536d7ce --- /dev/null +++ b/hubzilla_er/tables/config.html @@ -0,0 +1,231 @@ + + + + + SchemaSpy - Table zot.config + + + + + + + +
+ +
+
+ + + + + +
Table zot.configGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
catchar255
kchar255 + + + + + +
cache.k + Implied Constraint R
+
vtext65535
+

Table contained 52 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
cat + kMust be uniqueAsc/Ascaccess
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/conv.html b/hubzilla_er/tables/conv.html new file mode 100644 index 000000000..bf3cda01f --- /dev/null +++ b/hubzilla_er/tables/conv.html @@ -0,0 +1,270 @@ + + + + + SchemaSpy - Table zot.conv + + + + + + + +
+ +
+
+ + + + + +
Table zot.convGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
guidchar255
recipsmediumtext16777215
uidint100
creatorchar255
createddatetime190000-00-00 00:00:00
updateddatetime190000-00-00 00:00:00
subjectmediumtext16777215
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
createdPerformanceAsccreated
updatedPerformanceAscupdated
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/event.html b/hubzilla_er/tables/event.html new file mode 100644 index 000000000..da92cb295 --- /dev/null +++ b/hubzilla_er/tables/event.html @@ -0,0 +1,507 @@ + + + + + SchemaSpy - Table zot.event + + + + + + + +
+ +
+
+ + + + + +
Table zot.eventGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + +
notify.id + Implied Constraint R
+
aidint unsigned100
uidint100
event_xchanchar255
event_hashchar255
createddatetime190000-00-00 00:00:00
editeddatetime190000-00-00 00:00:00
startdatetime190000-00-00 00:00:00
finishdatetime190000-00-00 00:00:00
summarytext65535
descriptiontext65535
locationtext65535
typechar255
nofinishbit00
adjustbit01
ignorebit00
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
event_statuschar255
event_status_datedatetime190000-00-00 00:00:00
event_percentsmallint50
event_repeattext65535
event_sequencesmallint50
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
adjustPerformanceAscadjust
aidPerformanceAscaid
event_hashPerformanceAscevent_hash
event_sequencePerformanceAscevent_sequence
event_statusPerformanceAscevent_status
event_xchanPerformanceAscevent_xchan
finishPerformanceAscfinish
ignorePerformanceAscignore
nofinishPerformanceAscnofinish
startPerformanceAscstart
typePerformanceAsctype
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/fcontact.html b/hubzilla_er/tables/fcontact.html new file mode 100644 index 000000000..10af48116 --- /dev/null +++ b/hubzilla_er/tables/fcontact.html @@ -0,0 +1,358 @@ + + + + + SchemaSpy - Table zot.fcontact + + + + + + + +
+ +
+
+ + + + + +
Table zot.fcontactGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
urlchar255
namechar255
photochar255
requestchar255
nickchar255
addrchar255
batchchar255
notifychar255
pollchar255
confirmchar255
prioritybit0
networkchar32
aliaschar255
pubkeytext65535
updateddatetime190000-00-00 00:00:00
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
addrPerformanceAscaddr
networkPerformanceAscnetwork
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/ffinder.html b/hubzilla_er/tables/ffinder.html new file mode 100644 index 000000000..8c6a09711 --- /dev/null +++ b/hubzilla_er/tables/ffinder.html @@ -0,0 +1,232 @@ + + + + + SchemaSpy - Table zot.ffinder + + + + + + + +
+ +
+
+ + + + + +
Table zot.ffinderGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
uidint unsigned10
cidint unsigned10
fidint unsigned10
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
cidPerformanceAsccid
fidPerformanceAscfid
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/fserver.html b/hubzilla_er/tables/fserver.html new file mode 100644 index 000000000..0becc814d --- /dev/null +++ b/hubzilla_er/tables/fserver.html @@ -0,0 +1,216 @@ + + + + + SchemaSpy - Table zot.fserver + + + + + + + +
+ +
+
+ + + + + +
Table zot.fserverGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + +
notify.id + Implied Constraint R
+
serverchar255
posturlchar255
keytext65535
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
posturlPerformanceAscposturl
serverPerformanceAscserver
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/fsuggest.html b/hubzilla_er/tables/fsuggest.html new file mode 100644 index 000000000..7f0b446e5 --- /dev/null +++ b/hubzilla_er/tables/fsuggest.html @@ -0,0 +1,259 @@ + + + + + SchemaSpy - Table zot.fsuggest + + + + + + + +
+ +
+
+ + + + + +
Table zot.fsuggestGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + +
notify.id + Implied Constraint R
+
uidint100
cidint100
namechar255
urlchar255
requestchar255
photochar255
notetext65535
createddatetime190000-00-00 00:00:00
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/group_member.html b/hubzilla_er/tables/group_member.html new file mode 100644 index 000000000..f66faa853 --- /dev/null +++ b/hubzilla_er/tables/group_member.html @@ -0,0 +1,232 @@ + + + + + SchemaSpy - Table zot.group_member + + + + + + + +
+ +
+
+ + + + + +
Table zot.group_memberGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
uidint unsigned100
gidint unsigned100
xchanchar255
+

Table contained 2 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
gidPerformanceAscgid
uidPerformanceAscuid
xchanPerformanceAscxchan
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/groups.html b/hubzilla_er/tables/groups.html new file mode 100644 index 000000000..5e0b4163f --- /dev/null +++ b/hubzilla_er/tables/groups.html @@ -0,0 +1,260 @@ + + + + + SchemaSpy - Table zot.groups + + + + + + + +
+ +
+
+ + + + + +
Table zot.groupsGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
hashchar255
uidint unsigned100
visiblebit00
deletedbit00
namechar255
+

Table contained 5 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
deletedPerformanceAscdeleted
hashPerformanceAschash
uidPerformanceAscuid
visiblePerformanceAscvisible
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/hook.html b/hubzilla_er/tables/hook.html new file mode 100644 index 000000000..08d9b1aa7 --- /dev/null +++ b/hubzilla_er/tables/hook.html @@ -0,0 +1,221 @@ + + + + + SchemaSpy - Table zot.hook + + + + + + + +
+ +
+
+ + + + + +
Table zot.hookGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + +
notify.id + Implied Constraint R
+
hookchar255
filechar255
functionchar255
priorityint unsigned100
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
hookPerformanceAschook
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/hubloc.html b/hubzilla_er/tables/hubloc.html new file mode 100644 index 000000000..06c3e388b --- /dev/null +++ b/hubzilla_er/tables/hubloc.html @@ -0,0 +1,433 @@ + + + + + SchemaSpy - Table zot.hubloc + + + + + + + +
+ +
+
+ + + + + +
Table zot.hublocGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
hubloc_idint unsigned10 √ 
hubloc_guidchar255
hubloc_guid_sigtext65535
hubloc_hashchar255
hubloc_addrchar255
hubloc_networkchar32
hubloc_flagsint unsigned100
hubloc_statusint unsigned100
hubloc_urlchar255
hubloc_url_sigtext65535
hubloc_hostchar255
hubloc_callbackchar255
hubloc_connectchar255
hubloc_sitekeytext65535
hubloc_updateddatetime190000-00-00 00:00:00
hubloc_connecteddatetime190000-00-00 00:00:00
hubloc_primarybit00
hubloc_orphancheckbit00
hubloc_errorbit00
hubloc_deletedbit00
+

Table contained 1 513 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
hubloc_idPrimary keyAscPRIMARY
hubloc_addrPerformanceAschubloc_addr
hubloc_connectPerformanceAschubloc_connect
hubloc_connectedPerformanceAschubloc_connected
hubloc_deletedPerformanceAschubloc_deleted
hubloc_errorPerformanceAschubloc_error
hubloc_flagsPerformanceAschubloc_flags
hubloc_guidPerformanceAschubloc_guid
hubloc_hostPerformanceAschubloc_host
hubloc_networkPerformanceAschubloc_network
hubloc_orphancheckPerformanceAschubloc_orphancheck
hubloc_primaryPerformanceAschubloc_primary
hubloc_statusPerformanceAschubloc_status
hubloc_updatedPerformanceAschubloc_updated
hubloc_urlPerformanceAschubloc_url
+
+
+ + diff --git a/hubzilla_er/tables/issue.html b/hubzilla_er/tables/issue.html new file mode 100644 index 000000000..f4befe07f --- /dev/null +++ b/hubzilla_er/tables/issue.html @@ -0,0 +1,242 @@ + + + + + SchemaSpy - Table zot.issue + + + + + + + +
+ +
+
+ + + + + +
Table zot.issueGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
issue_idint unsigned10 √ 
issue_createddatetime190000-00-00 00:00:00
issue_updateddatetime190000-00-00 00:00:00
issue_assignedchar255
issue_priorityint100
issue_statusint100
issue_componentchar255
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
issue_idPrimary keyAscPRIMARY
issue_assignedPerformanceAscissue_assigned
issue_componentPerformanceAscissue_component
issue_createdPerformanceAscissue_created
issue_priorityPerformanceAscissue_priority
issue_statusPerformanceAscissue_status
issue_updatedPerformanceAscissue_updated
+
+
+ + diff --git a/hubzilla_er/tables/item.html b/hubzilla_er/tables/item.html new file mode 100644 index 000000000..8f2684aa5 --- /dev/null +++ b/hubzilla_er/tables/item.html @@ -0,0 +1,1315 @@ + + + + + SchemaSpy - Table zot.item + + + + + + + +
+ +
+
+ + + + + +
Table zot.itemGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
midchar255
aidint unsigned100
uidint unsigned100
parentint unsigned100
parent_midchar255
thr_parentchar255
createddatetime190000-00-00 00:00:00
editeddatetime190000-00-00 00:00:00
expiresdatetime190000-00-00 00:00:00
commenteddatetime190000-00-00 00:00:00
receiveddatetime190000-00-00 00:00:00
changeddatetime190000-00-00 00:00:00
comments_closeddatetime190000-00-00 00:00:00
owner_xchanchar255
author_xchanchar255
source_xchanchar255
mimetypechar255
titletext65535
bodymediumtext16777215
htmlmediumtext16777215
appchar255
langchar64
revisionint unsigned100
verbchar255
obj_typechar255
objecttext65535
tgt_typechar255
targettext65535
layout_midchar255
postoptstext65535
routetext65535
llinkchar255
plinkchar255
resource_idchar255
resource_typechar16
attachmediumtext16777215
sigtext65535
diaspora_metamediumtext16777215
locationchar255
coordchar255
public_policychar255
comment_policychar255
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
item_restrictint100
item_flagsint100
item_privatebit00
item_originbit00
item_unseenbit00
item_starredbit00
item_uplinkbit00
item_consensusbit00
item_wallbit00
item_thread_topbit00
item_notshownbit00
item_nsfwbit00
item_relaybit00
item_mentionsmebit00
item_nocommentbit00
item_obscuredbit00
item_verifiedbit00
item_retainedbit00
item_rssbit00
item_deletedbit00
item_typeint100
item_hiddenbit00
item_unpublishedbit00
item_delayedbit00
item_pending_removebit00
item_blockedbit00
+

Table contained 9 613 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
allow_cidPerformanceAscallow_cid
allow_gidPerformanceAscallow_gid
author_xchanPerformanceAscauthor_xchan
bodyPerformanceAscbody
changedPerformanceAscchanged
comment_policyPerformanceAsccomment_policy
commentedPerformanceAsccommented
comments_closedPerformanceAsccomments_closed
createdPerformanceAsccreated
deny_cidPerformanceAscdeny_cid
deny_gidPerformanceAscdeny_gid
editedPerformanceAscedited
expiresPerformanceAscexpires
item_blockedPerformanceAscitem_blocked
item_consensusPerformanceAscitem_consensus
item_delayedPerformanceAscitem_delayed
item_deletedPerformanceAscitem_deleted
item_flagsPerformanceAscitem_flags
item_hiddenPerformanceAscitem_hidden
item_mentionsmePerformanceAscitem_mentionsme
item_nocommentPerformanceAscitem_nocomment
item_notshownPerformanceAscitem_notshown
item_nsfwPerformanceAscitem_nsfw
item_obscuredPerformanceAscitem_obscured
item_originPerformanceAscitem_origin
item_pending_removePerformanceAscitem_pending_remove
item_privatePerformanceAscitem_private
item_relayPerformanceAscitem_relay
item_restrictPerformanceAscitem_restrict
item_retainedPerformanceAscitem_retained
item_rssPerformanceAscitem_rss
item_starredPerformanceAscitem_starred
item_thread_topPerformanceAscitem_thread_top
item_typePerformanceAscitem_type
item_unpublishedPerformanceAscitem_unpublished
item_unseenPerformanceAscitem_unseen
item_uplinkPerformanceAscitem_uplink
item_verifiedPerformanceAscitem_verified
item_wallPerformanceAscitem_wall
layout_midPerformanceAsclayout_mid
llinkPerformanceAscllink
midPerformanceAscmid
mimetypePerformanceAscmimetype
owner_xchanPerformanceAscowner_xchan
parentPerformanceAscparent
parent_midPerformanceAscparent_mid
public_policyPerformanceAscpublic_policy
receivedPerformanceAscreceived
resource_typePerformanceAscresource_type
revisionPerformanceAscrevision
titlePerformanceAsctitle
uidPerformanceAscuid
uid + commentedPerformanceAsc/Ascuid_commented
uid + createdPerformanceAsc/Ascuid_created
mid + uidPerformanceAsc/Ascuid_mid
verbPerformanceAscverb
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/item_id.html b/hubzilla_er/tables/item_id.html new file mode 100644 index 000000000..ec66e3999 --- /dev/null +++ b/hubzilla_er/tables/item_id.html @@ -0,0 +1,249 @@ + + + + + SchemaSpy - Table zot.item_id + + + + + + + +
+ +
+
+ + + + + +
Table zot.item_idGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
iidint100
uidint100
sidchar255
servicechar255
+

Table contained 1 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
iidPerformanceAsciid
servicePerformanceAscservice
sidPerformanceAscsid
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/likes.html b/hubzilla_er/tables/likes.html new file mode 100644 index 000000000..6d085fa5a --- /dev/null +++ b/hubzilla_er/tables/likes.html @@ -0,0 +1,321 @@ + + + + + SchemaSpy - Table zot.likes + + + + + + + +
+ +
+
+ + + + + +
Table zot.likesGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
channel_idint unsigned100 + + + + + +
channel.channel_id + Implied Constraint R
+
likerchar128
likeechar128
iidint unsigned100
verbchar255
target_typechar255
target_idchar128
targetmediumtext16777215
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
channel_idPerformanceAscchannel_id
iidPerformanceAsciid
likeePerformanceAsclikee
likerPerformanceAscliker
target_idPerformanceAsctarget_id
target_typePerformanceAsctarget_type
verbPerformanceAscverb
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/mail.html b/hubzilla_er/tables/mail.html new file mode 100644 index 000000000..96056d5ce --- /dev/null +++ b/hubzilla_er/tables/mail.html @@ -0,0 +1,517 @@ + + + + + SchemaSpy - Table zot.mail + + + + + + + +
+ +
+
+ + + + + +
Table zot.mailGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
convidint unsigned100
mail_flagsint unsigned100
from_xchanchar255
to_xchanchar255
account_idint unsigned100 + + + + + +
account.account_id + Implied Constraint R
+
channel_idint unsigned100 + + + + + +
channel.channel_id + Implied Constraint R
+
titletext65535
bodymediumtext16777215
sigtext65535
attachmediumtext16777215
midchar255
parent_midchar255
mail_deletedtinyint30
mail_repliedtinyint30
mail_isreplytinyint30
mail_seentinyint30
mail_recalledtinyint30
mail_obscuredsmallint50
createddatetime190000-00-00 00:00:00
expiresdatetime190000-00-00 00:00:00
+

Table contained 7 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
account_idPerformanceAscaccount_id
channel_idPerformanceAscchannel_id
convidPerformanceAscconvid
createdPerformanceAsccreated
expiresPerformanceAscexpires
from_xchanPerformanceAscfrom_xchan
mail_deletedPerformanceAscmail_deleted
mail_flagsPerformanceAscmail_flags
mail_isreplyPerformanceAscmail_isreply
mail_obscuredPerformanceAscmail_obscured
mail_recalledPerformanceAscmail_recalled
mail_repliedPerformanceAscmail_replied
mail_seenPerformanceAscmail_seen
midPerformanceAscmid
parent_midPerformanceAscparent_mid
to_xchanPerformanceAscto_xchan
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/manage.html b/hubzilla_er/tables/manage.html new file mode 100644 index 000000000..0275c18c2 --- /dev/null +++ b/hubzilla_er/tables/manage.html @@ -0,0 +1,205 @@ + + + + + SchemaSpy - Table zot.manage + + + + + + + +
+ +
+
+ + + + + +
Table zot.manageGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + +
notify.id + Implied Constraint R
+
uidint100
xchanchar255
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
uidPerformanceAscuid
xchanPerformanceAscxchan
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/menu.html b/hubzilla_er/tables/menu.html new file mode 100644 index 000000000..e165beb4d --- /dev/null +++ b/hubzilla_er/tables/menu.html @@ -0,0 +1,236 @@ + + + + + SchemaSpy - Table zot.menu + + + + + + + +
+ +
+
+ + + + + +
Table zot.menuGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
menu_idint unsigned10 √ 
menu_channel_idint unsigned100
menu_namechar255
menu_descchar255
menu_flagsint100
menu_createddatetime190000-00-00 00:00:00
menu_editeddatetime190000-00-00 00:00:00
+

Table contained 1 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
menu_idPrimary keyAscPRIMARY
menu_channel_idPerformanceAscmenu_channel_id
menu_createdPerformanceAscmenu_created
menu_editedPerformanceAscmenu_edited
menu_flagsPerformanceAscmenu_flags
menu_namePerformanceAscmenu_name
+
+
+ + diff --git a/hubzilla_er/tables/menu_item.html b/hubzilla_er/tables/menu_item.html new file mode 100644 index 000000000..92e2eacc9 --- /dev/null +++ b/hubzilla_er/tables/menu_item.html @@ -0,0 +1,268 @@ + + + + + SchemaSpy - Table zot.menu_item + + + + + + + +
+ +
+
+ + + + + +
Table zot.menu_itemGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
mitem_idint unsigned10 √ 
mitem_linkchar255
mitem_descchar255
mitem_flagsint100
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
mitem_channel_idint unsigned100
mitem_menu_idint unsigned100
mitem_orderint100
+

Table contained 1 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
mitem_idPrimary keyAscPRIMARY
mitem_channel_idPerformanceAscmitem_channel_id
mitem_flagsPerformanceAscmitem_flags
mitem_menu_idPerformanceAscmitem_menu_id
+
+
+ + diff --git a/hubzilla_er/tables/notify.html b/hubzilla_er/tables/notify.html new file mode 100644 index 000000000..2eec3e2ce --- /dev/null +++ b/hubzilla_er/tables/notify.html @@ -0,0 +1,434 @@ + + + + + SchemaSpy - Table zot.notify + + + + + + + +
+ +
+
+ + + + + +
Table zot.notifyGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
addon.id + Implied Constraint R
app.id + Implied Constraint R
event.id + Implied Constraint R
fserver.id + Implied Constraint R
fsuggest.id + Implied Constraint R
hook.id + Implied Constraint R
manage.id + Implied Constraint R
pconfig.id + Implied Constraint R
profile.id + Implied Constraint R
spam.id + Implied Constraint R
+
hashchar64
namechar255
urlchar255
photochar255
datedatetime190000-00-00 00:00:00
msgmediumtext16777215
aidint100
uidint100
linkchar255
parentchar255
seenbit00
typeint100
verbchar255
otypechar16
+

Table contained 59 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
datePerformanceAscdate
hashPerformanceAschash
linkPerformanceAsclink
otypePerformanceAscotype
parentPerformanceAscparent
seenPerformanceAscseen
typePerformanceAsctype
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/obj.html b/hubzilla_er/tables/obj.html new file mode 100644 index 000000000..97f010598 --- /dev/null +++ b/hubzilla_er/tables/obj.html @@ -0,0 +1,269 @@ + + + + + SchemaSpy - Table zot.obj + + + + + + + +
+ +
+
+ + + + + +
Table zot.objGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
obj_idint unsigned10 √ 
obj_pagechar64
obj_verbchar255
obj_typeint unsigned100
obj_objchar255
obj_channelint unsigned100
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
obj_idPrimary keyAscPRIMARY
obj_channelPerformanceAscobj_channel
obj_objPerformanceAscobj_obj
obj_pagePerformanceAscobj_page
obj_typePerformanceAscobj_type
obj_verbPerformanceAscobj_verb
+
+
+ + diff --git a/hubzilla_er/tables/outq.html b/hubzilla_er/tables/outq.html new file mode 100644 index 000000000..ceca68f09 --- /dev/null +++ b/hubzilla_er/tables/outq.html @@ -0,0 +1,309 @@ + + + + + SchemaSpy - Table zot.outq + + + + + + + +
+ +
+
+ + + + + +
Table zot.outqGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
outq_hashchar255
outq_accountint unsigned100
outq_channelint unsigned100
outq_driverchar32
outq_posturlchar255
outq_asyncbit00
outq_deliveredbit00
outq_createddatetime190000-00-00 00:00:00
outq_updateddatetime190000-00-00 00:00:00
outq_notifymediumtext16777215
outq_msgmediumtext16777215
outq_prioritysmallint50
+

Table contained 2 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
outq_hashPrimary keyAscPRIMARY
outq_accountPerformanceAscoutq_account
outq_asyncPerformanceAscoutq_async
outq_channelPerformanceAscoutq_channel
outq_createdPerformanceAscoutq_created
outq_deliveredPerformanceAscoutq_delivered
outq_posturlPerformanceAscoutq_hub
outq_priorityPerformanceAscoutq_priority
outq_updatedPerformanceAscoutq_updated
+
+
+ + diff --git a/hubzilla_er/tables/pconfig.html b/hubzilla_er/tables/pconfig.html new file mode 100644 index 000000000..3a4eb4fc6 --- /dev/null +++ b/hubzilla_er/tables/pconfig.html @@ -0,0 +1,235 @@ + + + + + SchemaSpy - Table zot.pconfig + + + + + + + +
+ +
+
+ + + + + +
Table zot.pconfigGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + +
notify.id + Implied Constraint R
+
uidint100
catchar255
kchar255 + + + + + +
cache.k + Implied Constraint R
+
vmediumtext16777215
+

Table contained 232 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
uid + cat + kMust be uniqueAsc/Asc/Ascaccess
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/photo.html b/hubzilla_er/tables/photo.html new file mode 100644 index 000000000..0bc69e071 --- /dev/null +++ b/hubzilla_er/tables/photo.html @@ -0,0 +1,556 @@ + + + + + SchemaSpy - Table zot.photo + + + + + + + +
+ +
+
+ + + + + +
Table zot.photoGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
aidint unsigned100
uidint unsigned100
xchanchar255
resource_idchar255
createddatetime190000-00-00 00:00:00
editeddatetime190000-00-00 00:00:00
titlechar255
descriptiontext65535
albumchar255
filenamechar255
typechar128image/jpeg
heightsmallint50
widthsmallint50
sizeint unsigned100
datamediumblob16777215
scaletinyint30
photo_usagesmallint50
profilebit00
is_nsfwbit00
os_storagebit00
os_pathmediumtext16777215
display_pathmediumtext16777215
photo_flagsint unsigned100
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
+

Table contained 3 495 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
albumPerformanceAscalbum
is_nsfwPerformanceAscis_nsfw
os_storagePerformanceAscos_storage
photo_flagsPerformanceAscphoto_flags
photo_usagePerformanceAscphoto_usage
profilePerformanceAscprofile
resource_idPerformanceAscresource_id
scalePerformanceAscscale
sizePerformanceAscsize
typePerformanceAsctype
uidPerformanceAscuid
xchanPerformanceAscxchan
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/poll.html b/hubzilla_er/tables/poll.html new file mode 100644 index 000000000..7ad9eea73 --- /dev/null +++ b/hubzilla_er/tables/poll.html @@ -0,0 +1,202 @@ + + + + + SchemaSpy - Table zot.poll + + + + + + + +
+ +
+
+ + + + + +
Table zot.pollGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
poll_idint unsigned10 √ 
poll_channelint unsigned100
poll_desctext65535
poll_flagsint100
poll_votesint100
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
poll_idPrimary keyAscPRIMARY
poll_channelPerformanceAscpoll_channel
poll_flagsPerformanceAscpoll_flags
poll_votesPerformanceAscpoll_votes
+
+
+ + diff --git a/hubzilla_er/tables/poll_elm.html b/hubzilla_er/tables/poll_elm.html new file mode 100644 index 000000000..cb6b95fbe --- /dev/null +++ b/hubzilla_er/tables/poll_elm.html @@ -0,0 +1,196 @@ + + + + + SchemaSpy - Table zot.poll_elm + + + + + + + +
+ +
+
+ + + + + +
Table zot.poll_elmGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
pelm_idint unsigned10 √ 
pelm_pollint unsigned100
pelm_desctext65535
pelm_flagsint100
pelm_resultfloat120
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
pelm_idPrimary keyAscPRIMARY
pelm_pollPerformanceAscpelm_poll
pelm_resultPerformanceAscpelm_result
+
+
+ + diff --git a/hubzilla_er/tables/profdef.html b/hubzilla_er/tables/profdef.html new file mode 100644 index 000000000..2734deed0 --- /dev/null +++ b/hubzilla_er/tables/profdef.html @@ -0,0 +1,242 @@ + + + + + SchemaSpy - Table zot.profdef + + + + + + + +
+ +
+
+ + + + + +
Table zot.profdefGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
field_namechar255
field_typechar16
field_descchar255
field_helpchar255
field_inputsmediumtext16777215
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
field_namePerformanceAscfield_name
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/profext.html b/hubzilla_er/tables/profext.html new file mode 100644 index 000000000..36472fcf9 --- /dev/null +++ b/hubzilla_er/tables/profext.html @@ -0,0 +1,264 @@ + + + + + SchemaSpy - Table zot.profext + + + + + + + +
+ +
+
+ + + + + +
Table zot.profextGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
channel_idint unsigned100 + + + + + +
channel.channel_id + Implied Constraint R
+
hashchar255
kchar255 + + + + + +
cache.k + Implied Constraint R
+
vmediumtext16777215
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
channel_idPerformanceAscchannel_id
hashPerformanceAschash
kPerformanceAsck
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/profile.html b/hubzilla_er/tables/profile.html new file mode 100644 index 000000000..e439f0e0b --- /dev/null +++ b/hubzilla_er/tables/profile.html @@ -0,0 +1,728 @@ + + + + + SchemaSpy - Table zot.profile + + + + + + + +
+ +
+
+ + + + + +
Table zot.profileGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + +
notify.id + Implied Constraint R
+
profile_guidchar64
aidint unsigned100
uidint100
profile_namechar255
is_defaultbit00
hide_friendsbit00
namechar255
pdescchar255
chandesctext65535
dobchar320000-00-00
dob_tzchar255UTC
addresschar255
localitychar255
regionchar255
postal_codechar32
country_namechar255
hometownchar255
genderchar32
maritalchar255
withtext65535
howlongdatetime190000-00-00 00:00:00
sexualchar255
politicchar255
religionchar255
keywordstext65535
likestext65535
dislikestext65535
abouttext65535
summarychar255
musictext65535
booktext65535
tvtext65535
filmtext65535
interesttext65535
romancetext65535
worktext65535
educationtext65535
contacttext65535
channelstext65535
homepagechar255
photochar255
thumbchar255
publishbit00
+

Table contained 4 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
country_namePerformanceAsccountry_name
genderPerformanceAscgender
profile_guid + uidMust be uniqueAsc/Ascguid
hide_friendsPerformanceAschide_friends
hometownPerformanceAschometown
is_defaultPerformanceAscis_default
localityPerformanceAsclocality
maritalPerformanceAscmarital
postal_codePerformanceAscpostal_code
profile_guidPerformanceAscprofile_guid
publishPerformanceAscpublish
sexualPerformanceAscsexual
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/profile_check.html b/hubzilla_er/tables/profile_check.html new file mode 100644 index 000000000..72ef92044 --- /dev/null +++ b/hubzilla_er/tables/profile_check.html @@ -0,0 +1,266 @@ + + + + + SchemaSpy - Table zot.profile_check + + + + + + + +
+ +
+
+ + + + + +
Table zot.profile_checkGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
uidint unsigned100
cidint unsigned100
dfrn_idchar255
secchar255
expireint100
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
cidPerformanceAsccid
dfrn_idPerformanceAscdfrn_id
expirePerformanceAscexpire
secPerformanceAscsec
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/register.html b/hubzilla_er/tables/register.html new file mode 100644 index 000000000..42a6ec3ed --- /dev/null +++ b/hubzilla_er/tables/register.html @@ -0,0 +1,254 @@ + + + + + SchemaSpy - Table zot.register + + + + + + + +
+ +
+
+ + + + + +
Table zot.registerGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
hashchar255
createddatetime190000-00-00 00:00:00
uidint unsigned100
passwordchar255
languagechar16
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
createdPerformanceAsccreated
hashPerformanceAschash
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/session.html b/hubzilla_er/tables/session.html new file mode 100644 index 000000000..452d1b776 --- /dev/null +++ b/hubzilla_er/tables/session.html @@ -0,0 +1,185 @@ + + + + + SchemaSpy - Table zot.session + + + + + + + +
+ +
+
+ + + + + +
Table zot.sessionGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idbigint unsigned20 √ 
sidchar255
datatext65535
expirebigint unsigned200
+

Table contained 23 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
expirePerformanceAscexpire
sidPerformanceAscsid
+
+
+ + diff --git a/hubzilla_er/tables/shares.html b/hubzilla_er/tables/shares.html new file mode 100644 index 000000000..e370e5c9a --- /dev/null +++ b/hubzilla_er/tables/shares.html @@ -0,0 +1,191 @@ + + + + + SchemaSpy - Table zot.shares + + + + + + + +
+ +
+
+ + + + + +
Table zot.sharesGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
share_idint unsigned10 √ 
share_typeint100
share_targetint unsigned100
share_xchanchar255
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
share_idPrimary keyAscPRIMARY
share_targetPerformanceAscshare_target
share_typePerformanceAscshare_type
share_xchanPerformanceAscshare_xchan
+
+
+ + diff --git a/hubzilla_er/tables/sign.html b/hubzilla_er/tables/sign.html new file mode 100644 index 000000000..3ab4d8d31 --- /dev/null +++ b/hubzilla_er/tables/sign.html @@ -0,0 +1,248 @@ + + + + + SchemaSpy - Table zot.sign + + + + + + + +
+ +
+
+ + + + + +
Table zot.signGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
iidint unsigned100
retract_iidint unsigned100
signed_textmediumtext16777215
signaturetext65535
signerchar255
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
iidPerformanceAsciid
retract_iidPerformanceAscretract_iid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/site.html b/hubzilla_er/tables/site.html new file mode 100644 index 000000000..0f4631eea --- /dev/null +++ b/hubzilla_er/tables/site.html @@ -0,0 +1,332 @@ + + + + + SchemaSpy - Table zot.site + + + + + + + +
+ +
+
+ + + + + +
Table zot.siteGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
site_urlchar255
site_accessint100
site_flagsint100
site_updatedatetime190000-00-00 00:00:00
site_pulldatetime190000-00-00 00:00:00
site_syncdatetime190000-00-00 00:00:00
site_directorychar255
site_registerint100
site_sellpagechar255
site_locationchar255
site_realmchar255
site_validsmallint50
site_deadsmallint50
+

Table contained 117 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
site_urlPrimary keyAscPRIMARY
site_accessPerformanceAscsite_access
site_deadPerformanceAscsite_dead
site_directoryPerformanceAscsite_directory
site_flagsPerformanceAscsite_flags
site_pullPerformanceAscsite_pull
site_realmPerformanceAscsite_realm
site_registerPerformanceAscsite_register
site_sellpagePerformanceAscsite_sellpage
site_updatePerformanceAscsite_update
site_validPerformanceAscsite_valid
+
+
+ + diff --git a/hubzilla_er/tables/source.html b/hubzilla_er/tables/source.html new file mode 100644 index 000000000..ac58a2798 --- /dev/null +++ b/hubzilla_er/tables/source.html @@ -0,0 +1,202 @@ + + + + + SchemaSpy - Table zot.source + + + + + + + +
+ +
+
+ + + + + +
Table zot.sourceGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
src_idint unsigned10 √ 
src_channel_idint unsigned100
src_channel_xchanchar255
src_xchanchar255
src_pattmediumtext16777215
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
src_idPrimary keyAscPRIMARY
src_channel_idPerformanceAscsrc_channel_id
src_channel_xchanPerformanceAscsrc_channel_xchan
src_xchanPerformanceAscsrc_xchan
+
+
+ + diff --git a/hubzilla_er/tables/spam.html b/hubzilla_er/tables/spam.html new file mode 100644 index 000000000..9996c49cd --- /dev/null +++ b/hubzilla_er/tables/spam.html @@ -0,0 +1,250 @@ + + + + + SchemaSpy - Table zot.spam + + + + + + + +
+ +
+
+ + + + + +
Table zot.spamGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint10 √  + + + + + +
notify.id + Implied Constraint R
+
uidint100
spamint100
hamint100
termchar255
datedatetime190000-00-00 00:00:00
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
hamPerformanceAscham
spamPerformanceAscspam
termPerformanceAscterm
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/sys_perms.html b/hubzilla_er/tables/sys_perms.html new file mode 100644 index 000000000..672b98166 --- /dev/null +++ b/hubzilla_er/tables/sys_perms.html @@ -0,0 +1,236 @@ + + + + + SchemaSpy - Table zot.sys_perms + + + + + + + +
+ +
+
+ + + + + +
Table zot.sys_permsGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
catchar255
kchar255 + + + + + +
cache.k + Implied Constraint R
+
vmediumtext16777215
public_permbit00
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/term.html b/hubzilla_er/tables/term.html new file mode 100644 index 000000000..5f1039d06 --- /dev/null +++ b/hubzilla_er/tables/term.html @@ -0,0 +1,304 @@ + + + + + SchemaSpy - Table zot.term + + + + + + + +
+ +
+
+ + + + + +
Table zot.termGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
tidint unsigned10 √ 
aidint unsigned100
uidint unsigned100
oidint unsigned100
otypetinyint unsigned30
typetinyint unsigned30
termchar255
urlchar255
imgurlchar255
term_hashchar255
parent_hashchar255
+

Table contained 7 585 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
tidPrimary keyAscPRIMARY
aidPerformanceAscaid
imgurlPerformanceAscimgurl
oidPerformanceAscoid
otypePerformanceAscotype
parent_hashPerformanceAscparent_hash
termPerformanceAscterm
term_hashPerformanceAscterm_hash
typePerformanceAsctype
uidPerformanceAscuid
+
+
+ + diff --git a/hubzilla_er/tables/tokens.html b/hubzilla_er/tables/tokens.html new file mode 100644 index 000000000..0217c4f11 --- /dev/null +++ b/hubzilla_er/tables/tokens.html @@ -0,0 +1,245 @@ + + + + + SchemaSpy - Table zot.tokens + + + + + + + +
+ +
+
+ + + + + +
Table zot.tokensGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idvarchar40 + + + + + +
auth_codes.id + Implied Constraint R
+
secrettext65535
client_idvarchar20 + + + + + +
clients.client_id + Implied Constraint R
+
expiresbigint unsigned200
scopevarchar200
uidint100
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
client_idPerformanceAscclient_id
expiresPerformanceAscexpires
uidPerformanceAscuid
+
+
+
Close relationships:
+ + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/updates.html b/hubzilla_er/tables/updates.html new file mode 100644 index 000000000..78d0b01ad --- /dev/null +++ b/hubzilla_er/tables/updates.html @@ -0,0 +1,242 @@ + + + + + SchemaSpy - Table zot.updates + + + + + + + +
+ +
+
+ + + + + +
Table zot.updatesGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
ud_idint unsigned10 √ 
ud_hashchar128
ud_guidchar255
ud_datedatetime190000-00-00 00:00:00
ud_lastdatetime190000-00-00 00:00:00
ud_flagsint100
ud_addrchar255
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
ud_idPrimary keyAscPRIMARY
ud_addrPerformanceAscud_addr
ud_datePerformanceAscud_date
ud_flagsPerformanceAscud_flags
ud_guidPerformanceAscud_guid
ud_hashPerformanceAscud_hash
ud_lastPerformanceAscud_last
+
+
+ + diff --git a/hubzilla_er/tables/verify.html b/hubzilla_er/tables/verify.html new file mode 100644 index 000000000..e01eb4f62 --- /dev/null +++ b/hubzilla_er/tables/verify.html @@ -0,0 +1,383 @@ + + + + + SchemaSpy - Table zot.verify + + + + + + + +
+ +
+
+ + + + + +
Table zot.verifyGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
attach.id + Implied Constraint R
config.id + Implied Constraint R
conv.id + Implied Constraint R
fcontact.id + Implied Constraint R
ffinder.id + Implied Constraint R
group_member.id + Implied Constraint R
groups.id + Implied Constraint R
item.id + Implied Constraint R
item_id.id + Implied Constraint R
likes.id + Implied Constraint R
mail.id + Implied Constraint R
photo.id + Implied Constraint R
profdef.id + Implied Constraint R
profext.id + Implied Constraint R
profile_check.id + Implied Constraint R
register.id + Implied Constraint R
sign.id + Implied Constraint R
sys_perms.id + Implied Constraint R
xconfig.id + Implied Constraint R
xign.id + Implied Constraint R
+
channelint unsigned100
typechar32
tokenchar255
metachar255
createddatetime190000-00-00 00:00:00
+

Table contained 1 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
channelPerformanceAscchannel
createdPerformanceAsccreated
metaPerformanceAscmeta
tokenPerformanceAsctoken
typePerformanceAsctype
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/vote.html b/hubzilla_er/tables/vote.html new file mode 100644 index 000000000..641c39857 --- /dev/null +++ b/hubzilla_er/tables/vote.html @@ -0,0 +1,202 @@ + + + + + SchemaSpy - Table zot.vote + + + + + + + +
+ +
+
+ + + + + +
Table zot.voteGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
vote_idint unsigned10 √ 
vote_pollint100
vote_elementint100
vote_resulttext65535
vote_xchanchar255
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
vote_idPrimary keyAscPRIMARY
vote_elementPerformanceAscvote_element
vote_pollPerformanceAscvote_poll
vote_poll + vote_element + vote_xchanMust be uniqueAsc/Asc/Ascvote_vote
+
+
+ + diff --git a/hubzilla_er/tables/xchan.html b/hubzilla_er/tables/xchan.html new file mode 100644 index 000000000..97be20010 --- /dev/null +++ b/hubzilla_er/tables/xchan.html @@ -0,0 +1,511 @@ + + + + + SchemaSpy - Table zot.xchan + + + + + + + +
+ +
+
+ + + + + +
Table zot.xchanGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
xchan_hashchar255
xchan_guidchar255
xchan_guid_sigtext65535
xchan_pubkeytext65535
xchan_photo_mimetypechar32image/jpeg
xchan_photo_lchar255
xchan_photo_mchar255
xchan_photo_schar255
xchan_addrchar255
xchan_urlchar255
xchan_connurlchar255
xchan_followchar255
xchan_connpagechar255
xchan_namechar255
xchan_networkchar255
xchan_instance_urlchar255
xchan_flagsint unsigned100
xchan_photo_datedatetime190000-00-00 00:00:00
xchan_name_datedatetime190000-00-00 00:00:00
xchan_hiddenbit00
xchan_orphanbit00
xchan_censoredbit00
xchan_selfcensoredbit00
xchan_systembit00
xchan_pubforumbit00
xchan_deletedbit00
+

Table contained 1 168 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
xchan_hashPrimary keyAscPRIMARY
xchan_addrPerformanceAscxchan_addr
xchan_censoredPerformanceAscxchan_censored
xchan_connurlPerformanceAscxchan_connurl
xchan_deletedPerformanceAscxchan_deleted
xchan_flagsPerformanceAscxchan_flags
xchan_followPerformanceAscxchan_follow
xchan_guidPerformanceAscxchan_guid
xchan_hiddenPerformanceAscxchan_hidden
xchan_instance_urlPerformanceAscxchan_instance_url
xchan_namePerformanceAscxchan_name
xchan_networkPerformanceAscxchan_network
xchan_orphanPerformanceAscxchan_orphan
xchan_pubforumPerformanceAscxchan_pubforum
xchan_selfcensoredPerformanceAscxchan_selfcensored
xchan_systemPerformanceAscxchan_system
xchan_urlPerformanceAscxchan_url
+
+
+ + diff --git a/hubzilla_er/tables/xchat.html b/hubzilla_er/tables/xchat.html new file mode 100644 index 000000000..707f80199 --- /dev/null +++ b/hubzilla_er/tables/xchat.html @@ -0,0 +1,208 @@ + + + + + SchemaSpy - Table zot.xchat + + + + + + + +
+ +
+
+ + + + + +
Table zot.xchatGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
xchat_idint unsigned10 √ 
xchat_urlchar255
xchat_descchar255
xchat_xchanchar255
xchat_editeddatetime190000-00-00 00:00:00
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
xchat_idPrimary keyAscPRIMARY
xchat_descPerformanceAscxchat_desc
xchat_editedPerformanceAscxchat_edited
xchat_urlPerformanceAscxchat_url
xchat_xchanPerformanceAscxchat_xchan
+
+
+ + diff --git a/hubzilla_er/tables/xconfig.html b/hubzilla_er/tables/xconfig.html new file mode 100644 index 000000000..c3e3c453a --- /dev/null +++ b/hubzilla_er/tables/xconfig.html @@ -0,0 +1,254 @@ + + + + + SchemaSpy - Table zot.xconfig + + + + + + + +
+ +
+
+ + + + + +
Table zot.xconfigGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
xchanchar255
catchar255
kchar255 + + + + + +
cache.k + Implied Constraint R
+
vmediumtext16777215
+

Table contained 4 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
catPerformanceAsccat
kPerformanceAsck
xchanPerformanceAscxchan
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/xign.html b/hubzilla_er/tables/xign.html new file mode 100644 index 000000000..a8d430c34 --- /dev/null +++ b/hubzilla_er/tables/xign.html @@ -0,0 +1,215 @@ + + + + + SchemaSpy - Table zot.xign + + + + + + + +
+ +
+
+ + + + + +
Table zot.xignGenerated by
SchemaSpy
+ +
+
+ + + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint unsigned10 √  + + + + + +
verify.id + Implied Constraint R
+
uidint100
xchanchar255
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
uidPerformanceAscuid
xchanPerformanceAscxchan
+
+
+
Close relationships:
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+
+ + diff --git a/hubzilla_er/tables/xlink.html b/hubzilla_er/tables/xlink.html new file mode 100644 index 000000000..8b4c81ad7 --- /dev/null +++ b/hubzilla_er/tables/xlink.html @@ -0,0 +1,247 @@ + + + + + SchemaSpy - Table zot.xlink + + + + + + + +
+ +
+
+ + + + + +
Table zot.xlinkGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
xlink_idint unsigned10 √ 
xlink_xchanchar255
xlink_linkchar255
xlink_ratingint100
xlink_rating_texttext65535
xlink_updateddatetime190000-00-00 00:00:00
xlink_staticbit00
xlink_sigtext65535
+

Table contained 244 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
xlink_idPrimary keyAscPRIMARY
xlink_linkPerformanceAscxlink_link
xlink_ratingPerformanceAscxlink_rating
xlink_staticPerformanceAscxlink_static
xlink_updatedPerformanceAscxlink_updated
xlink_xchanPerformanceAscxlink_xchan
+
+
+ + diff --git a/hubzilla_er/tables/xperm.html b/hubzilla_er/tables/xperm.html new file mode 100644 index 000000000..466a84bfa --- /dev/null +++ b/hubzilla_er/tables/xperm.html @@ -0,0 +1,191 @@ + + + + + SchemaSpy - Table zot.xperm + + + + + + + +
+ +
+
+ + + + + +
Table zot.xpermGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
xp_idint unsigned10 √ 
xp_clientvarchar20
xp_channelint unsigned100
xp_permvarchar64
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
xp_idPrimary keyAscPRIMARY
xp_channelPerformanceAscxp_channel
xp_clientPerformanceAscxp_client
xp_permPerformanceAscxp_perm
+
+
+ + diff --git a/hubzilla_er/tables/xprof.html b/hubzilla_er/tables/xprof.html new file mode 100644 index 000000000..c5d7695fb --- /dev/null +++ b/hubzilla_er/tables/xprof.html @@ -0,0 +1,360 @@ + + + + + SchemaSpy - Table zot.xprof + + + + + + + +
+ +
+
+ + + + + +
Table zot.xprofGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
xprof_hashchar255
xprof_agetinyint unsigned30
xprof_descchar255
xprof_dobchar12
xprof_genderchar255
xprof_maritalchar255
xprof_sexualchar255
xprof_localechar255
xprof_regionchar255
xprof_postcodechar32
xprof_countrychar255
xprof_keywordstext65535
xprof_abouttext65535
xprof_homepagechar255
xprof_hometownchar255
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
xprof_hashPrimary keyAscPRIMARY
xprof_agePerformanceAscxprof_age
xprof_countryPerformanceAscxprof_country
xprof_descPerformanceAscxprof_desc
xprof_dobPerformanceAscxprof_dob
xprof_genderPerformanceAscxprof_gender
xprof_hometownPerformanceAscxprof_hometown
xprof_localePerformanceAscxprof_locale
xprof_maritalPerformanceAscxprof_marital
xprof_postcodePerformanceAscxprof_postcode
xprof_regionPerformanceAscxprof_region
xprof_sexualPerformanceAscxprof_sexual
+
+
+ + diff --git a/hubzilla_er/tables/xtag.html b/hubzilla_er/tables/xtag.html new file mode 100644 index 000000000..bdd04c26e --- /dev/null +++ b/hubzilla_er/tables/xtag.html @@ -0,0 +1,191 @@ + + + + + SchemaSpy - Table zot.xtag + + + + + + + +
+ +
+
+ + + + + +
Table zot.xtagGenerated by
SchemaSpy
+ +
+
+ + + + +
+		 + + + + + + +
Legend:SourceForge.net
+ + + + + + + +
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
+
+
+ + +
+  +
+ + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
xtag_idint unsigned10 √ 
xtag_hashchar255
xtag_termchar255
xtag_flagsint100
+

Table contained 0 rows at on aug 19 21:08 CEST 2015

+

+
+Indexes: ++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Column(s)TypeSortConstraint Name
xtag_idPrimary keyAscPRIMARY
xtag_flagsPerformanceAscxtag_flags
xtag_hashPerformanceAscxtag_hash
xtag_termPerformanceAscxtag_term
+
+
+ + -- cgit v1.2.3