From 0fbea73581c7d2f578afdf5391396020901c5d3a Mon Sep 17 00:00:00 2001 From: Haakon Meland Eriksen Date: Mon, 9 Nov 2015 06:24:02 +0100 Subject: Keep only zot.meta.xml for schemaSpy report generation, not the report itself --- doc/schemaspy_hubzilla/tables/abook.html | 554 --------- doc/schemaspy_hubzilla/tables/account.html | 418 ------- doc/schemaspy_hubzilla/tables/addon.html | 258 ---- doc/schemaspy_hubzilla/tables/app.html | 393 ------ doc/schemaspy_hubzilla/tables/attach.html | 593 --------- doc/schemaspy_hubzilla/tables/auth_codes.html | 216 ---- doc/schemaspy_hubzilla/tables/cache.html | 217 ---- doc/schemaspy_hubzilla/tables/channel.html | 1104 ----------------- doc/schemaspy_hubzilla/tables/chat.html | 254 ---- doc/schemaspy_hubzilla/tables/chatpresence.html | 271 ----- doc/schemaspy_hubzilla/tables/chatroom.html | 286 ----- doc/schemaspy_hubzilla/tables/clients.html | 224 ---- doc/schemaspy_hubzilla/tables/config.html | 231 ---- doc/schemaspy_hubzilla/tables/conv.html | 270 ----- doc/schemaspy_hubzilla/tables/dreport.html | 316 ----- doc/schemaspy_hubzilla/tables/event.html | 632 ---------- doc/schemaspy_hubzilla/tables/fcontact.html | 358 ------ doc/schemaspy_hubzilla/tables/ffinder.html | 232 ---- doc/schemaspy_hubzilla/tables/fserver.html | 219 ---- doc/schemaspy_hubzilla/tables/fsuggest.html | 262 ---- doc/schemaspy_hubzilla/tables/group_member.html | 298 ----- doc/schemaspy_hubzilla/tables/groups.html | 340 ------ doc/schemaspy_hubzilla/tables/hook.html | 224 ---- doc/schemaspy_hubzilla/tables/hubloc.html | 642 ---------- doc/schemaspy_hubzilla/tables/issue.html | 242 ---- doc/schemaspy_hubzilla/tables/item.html | 1399 ---------------------- doc/schemaspy_hubzilla/tables/item_id.html | 249 ---- doc/schemaspy_hubzilla/tables/likes.html | 347 ------ doc/schemaspy_hubzilla/tables/mail.html | 608 ---------- doc/schemaspy_hubzilla/tables/manage.html | 278 ----- doc/schemaspy_hubzilla/tables/menu.html | 236 ---- doc/schemaspy_hubzilla/tables/menu_item.html | 268 ----- doc/schemaspy_hubzilla/tables/notify.html | 522 -------- doc/schemaspy_hubzilla/tables/obj.html | 354 ------ doc/schemaspy_hubzilla/tables/outq.html | 411 ------- doc/schemaspy_hubzilla/tables/pconfig.html | 238 ---- doc/schemaspy_hubzilla/tables/photo.html | 622 ---------- doc/schemaspy_hubzilla/tables/poll.html | 202 ---- doc/schemaspy_hubzilla/tables/poll_elm.html | 196 --- doc/schemaspy_hubzilla/tables/profdef.html | 242 ---- doc/schemaspy_hubzilla/tables/profext.html | 343 ------ doc/schemaspy_hubzilla/tables/profile.html | 731 ----------- doc/schemaspy_hubzilla/tables/profile_check.html | 266 ---- doc/schemaspy_hubzilla/tables/register.html | 334 ------ doc/schemaspy_hubzilla/tables/session.html | 185 --- doc/schemaspy_hubzilla/tables/shares.html | 243 ---- doc/schemaspy_hubzilla/tables/sign.html | 248 ---- doc/schemaspy_hubzilla/tables/site.html | 366 ------ doc/schemaspy_hubzilla/tables/source.html | 263 ---- doc/schemaspy_hubzilla/tables/spam.html | 253 ---- doc/schemaspy_hubzilla/tables/sys_perms.html | 236 ---- doc/schemaspy_hubzilla/tables/term.html | 427 ------- doc/schemaspy_hubzilla/tables/tokens.html | 245 ---- doc/schemaspy_hubzilla/tables/updates.html | 344 ------ doc/schemaspy_hubzilla/tables/verify.html | 385 ------ doc/schemaspy_hubzilla/tables/vote.html | 254 ---- doc/schemaspy_hubzilla/tables/xchan.html | 821 ------------- doc/schemaspy_hubzilla/tables/xchat.html | 260 ---- doc/schemaspy_hubzilla/tables/xconfig.html | 320 ----- doc/schemaspy_hubzilla/tables/xign.html | 281 ----- doc/schemaspy_hubzilla/tables/xlink.html | 299 ----- doc/schemaspy_hubzilla/tables/xperm.html | 191 --- doc/schemaspy_hubzilla/tables/xprof.html | 462 ------- doc/schemaspy_hubzilla/tables/xtag.html | 293 ----- 64 files changed, 23276 deletions(-) delete mode 100644 doc/schemaspy_hubzilla/tables/abook.html delete mode 100644 doc/schemaspy_hubzilla/tables/account.html delete mode 100644 doc/schemaspy_hubzilla/tables/addon.html delete mode 100644 doc/schemaspy_hubzilla/tables/app.html delete mode 100644 doc/schemaspy_hubzilla/tables/attach.html delete mode 100644 doc/schemaspy_hubzilla/tables/auth_codes.html delete mode 100644 doc/schemaspy_hubzilla/tables/cache.html delete mode 100644 doc/schemaspy_hubzilla/tables/channel.html delete mode 100644 doc/schemaspy_hubzilla/tables/chat.html delete mode 100644 doc/schemaspy_hubzilla/tables/chatpresence.html delete mode 100644 doc/schemaspy_hubzilla/tables/chatroom.html delete mode 100644 doc/schemaspy_hubzilla/tables/clients.html delete mode 100644 doc/schemaspy_hubzilla/tables/config.html delete mode 100644 doc/schemaspy_hubzilla/tables/conv.html delete mode 100644 doc/schemaspy_hubzilla/tables/dreport.html delete mode 100644 doc/schemaspy_hubzilla/tables/event.html delete mode 100644 doc/schemaspy_hubzilla/tables/fcontact.html delete mode 100644 doc/schemaspy_hubzilla/tables/ffinder.html delete mode 100644 doc/schemaspy_hubzilla/tables/fserver.html delete mode 100644 doc/schemaspy_hubzilla/tables/fsuggest.html delete mode 100644 doc/schemaspy_hubzilla/tables/group_member.html delete mode 100644 doc/schemaspy_hubzilla/tables/groups.html delete mode 100644 doc/schemaspy_hubzilla/tables/hook.html delete mode 100644 doc/schemaspy_hubzilla/tables/hubloc.html delete mode 100644 doc/schemaspy_hubzilla/tables/issue.html delete mode 100644 doc/schemaspy_hubzilla/tables/item.html delete mode 100644 doc/schemaspy_hubzilla/tables/item_id.html delete mode 100644 doc/schemaspy_hubzilla/tables/likes.html delete mode 100644 doc/schemaspy_hubzilla/tables/mail.html delete mode 100644 doc/schemaspy_hubzilla/tables/manage.html delete mode 100644 doc/schemaspy_hubzilla/tables/menu.html delete mode 100644 doc/schemaspy_hubzilla/tables/menu_item.html delete mode 100644 doc/schemaspy_hubzilla/tables/notify.html delete mode 100644 doc/schemaspy_hubzilla/tables/obj.html delete mode 100644 doc/schemaspy_hubzilla/tables/outq.html delete mode 100644 doc/schemaspy_hubzilla/tables/pconfig.html delete mode 100644 doc/schemaspy_hubzilla/tables/photo.html delete mode 100644 doc/schemaspy_hubzilla/tables/poll.html delete mode 100644 doc/schemaspy_hubzilla/tables/poll_elm.html delete mode 100644 doc/schemaspy_hubzilla/tables/profdef.html delete mode 100644 doc/schemaspy_hubzilla/tables/profext.html delete mode 100644 doc/schemaspy_hubzilla/tables/profile.html delete mode 100644 doc/schemaspy_hubzilla/tables/profile_check.html delete mode 100644 doc/schemaspy_hubzilla/tables/register.html delete mode 100644 doc/schemaspy_hubzilla/tables/session.html delete mode 100644 doc/schemaspy_hubzilla/tables/shares.html delete mode 100644 doc/schemaspy_hubzilla/tables/sign.html delete mode 100644 doc/schemaspy_hubzilla/tables/site.html delete mode 100644 doc/schemaspy_hubzilla/tables/source.html delete mode 100644 doc/schemaspy_hubzilla/tables/spam.html delete mode 100644 doc/schemaspy_hubzilla/tables/sys_perms.html delete mode 100644 doc/schemaspy_hubzilla/tables/term.html delete mode 100644 doc/schemaspy_hubzilla/tables/tokens.html delete mode 100644 doc/schemaspy_hubzilla/tables/updates.html delete mode 100644 doc/schemaspy_hubzilla/tables/verify.html delete mode 100644 doc/schemaspy_hubzilla/tables/vote.html delete mode 100644 doc/schemaspy_hubzilla/tables/xchan.html delete mode 100644 doc/schemaspy_hubzilla/tables/xchat.html delete mode 100644 doc/schemaspy_hubzilla/tables/xconfig.html delete mode 100644 doc/schemaspy_hubzilla/tables/xign.html delete mode 100644 doc/schemaspy_hubzilla/tables/xlink.html delete mode 100644 doc/schemaspy_hubzilla/tables/xperm.html delete mode 100644 doc/schemaspy_hubzilla/tables/xprof.html delete mode 100644 doc/schemaspy_hubzilla/tables/xtag.html (limited to 'doc/schemaspy_hubzilla/tables') diff --git a/doc/schemaspy_hubzilla/tables/abook.html b/doc/schemaspy_hubzilla/tables/abook.html deleted file mode 100644 index e8254d67f..000000000 --- a/doc/schemaspy_hubzilla/tables/abook.html +++ /dev/null @@ -1,554 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
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 685 rows at fr nov 06 17:11 CET 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
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/account.html b/doc/schemaspy_hubzilla/tables/account.html deleted file mode 100644 index 2dcf0990e..000000000 --- a/doc/schemaspy_hubzilla/tables/account.html +++ /dev/null @@ -1,418 +0,0 @@ - - - - - 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 2 rows at fr nov 06 17:11 CET 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/doc/schemaspy_hubzilla/tables/addon.html b/doc/schemaspy_hubzilla/tables/addon.html deleted file mode 100644 index 692b6aa6b..000000000 --- a/doc/schemaspy_hubzilla/tables/addon.html +++ /dev/null @@ -1,258 +0,0 @@ - - - - - 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 20 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
hiddenPerformanceAschidden
installedPerformanceAscinstalled
namePerformanceAscname
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/app.html b/doc/schemaspy_hubzilla/tables/app.html deleted file mode 100644 index 68342c09d..000000000 --- a/doc/schemaspy_hubzilla/tables/app.html +++ /dev/null @@ -1,393 +0,0 @@ - - - - - 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
app_createddatetime190000-00-00 00:00:00
app_editeddatetime190000-00-00 00:00:00
-

Table contained 4 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
app_channelPerformanceAscapp_channel
app_createdPerformanceAscapp_created
app_editedPerformanceAscapp_edited
app_idPerformanceAscapp_id
app_namePerformanceAscapp_name
app_photoPerformanceAscapp_photo
app_pricePerformanceAscapp_price
app_urlPerformanceAscapp_url
app_versionPerformanceAscapp_version
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/attach.html b/doc/schemaspy_hubzilla/tables/attach.html deleted file mode 100644 index 7d93706d9..000000000 --- a/doc/schemaspy_hubzilla/tables/attach.html +++ /dev/null @@ -1,593 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
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 105 rows at fr nov 06 17:11 CET 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 - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/auth_codes.html b/doc/schemaspy_hubzilla/tables/auth_codes.html deleted file mode 100644 index 1c2861388..000000000 --- a/doc/schemaspy_hubzilla/tables/auth_codes.html +++ /dev/null @@ -1,216 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
-
-
-
Close relationships:
- - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/cache.html b/doc/schemaspy_hubzilla/tables/cache.html deleted file mode 100644 index daf6f4517..000000000 --- a/doc/schemaspy_hubzilla/tables/cache.html +++ /dev/null @@ -1,217 +0,0 @@ - - - - - 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 334 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
kPrimary keyAscPRIMARY
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/channel.html b/doc/schemaspy_hubzilla/tables/channel.html deleted file mode 100644 index 8de11aa72..000000000 --- a/doc/schemaspy_hubzilla/tables/channel.html +++ /dev/null @@ -1,1104 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
attach.hash - Defined in XML R
event.event_hash - Defined in XML R
groups.hash - Defined in XML R
hubloc.hubloc_hash - Defined in XML R
notify.hash - Defined in XML R
outq.outq_hash - Defined in XML R
profext.hash - Defined in XML R
register.hash - Defined in XML R
term.parent_hash - Defined in XML R
term.term_hash - Defined in XML R
updates.ud_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
xprof.xprof_hash - Defined in XML R
xtag.xtag_hash - Defined in XML R
-		 - - - - - -
xchan.xchan_hash - Defined in XML R
-
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 12 rows at fr nov 06 17:11 CET 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 - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/chat.html b/doc/schemaspy_hubzilla/tables/chat.html deleted file mode 100644 index 555b76949..000000000 --- a/doc/schemaspy_hubzilla/tables/chat.html +++ /dev/null @@ -1,254 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
chat_textmediumtext16777215
createddatetime190000-00-00 00:00:00
-

Table contained 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
chat_idPrimary keyAscPRIMARY
chat_roomPerformanceAscchat_room
chat_xchanPerformanceAscchat_xchan
createdPerformanceAsccreated
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/chatpresence.html b/doc/schemaspy_hubzilla/tables/chatpresence.html deleted file mode 100644 index 7a7811c98..000000000 --- a/doc/schemaspy_hubzilla/tables/chatpresence.html +++ /dev/null @@ -1,271 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
cp_lastdatetime190000-00-00 00:00:00
cp_statuschar255
cp_clientchar128
-

Table contained 1 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
cp_idPrimary keyAscPRIMARY
cp_lastPerformanceAsccp_last
cp_roomPerformanceAsccp_room
cp_statusPerformanceAsccp_status
cp_xchanPerformanceAsccp_xchan
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/chatroom.html b/doc/schemaspy_hubzilla/tables/chatroom.html deleted file mode 100644 index 359888f56..000000000 --- a/doc/schemaspy_hubzilla/tables/chatroom.html +++ /dev/null @@ -1,286 +0,0 @@ - - - - - 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 2 rows at fr nov 06 17:11 CET 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/doc/schemaspy_hubzilla/tables/clients.html b/doc/schemaspy_hubzilla/tables/clients.html deleted file mode 100644 index e805498cf..000000000 --- a/doc/schemaspy_hubzilla/tables/clients.html +++ /dev/null @@ -1,224 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
client_idPrimary keyAscPRIMARY
-
-
-
Close relationships:
- - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/config.html b/doc/schemaspy_hubzilla/tables/config.html deleted file mode 100644 index eb06c5479..000000000 --- a/doc/schemaspy_hubzilla/tables/config.html +++ /dev/null @@ -1,231 +0,0 @@ - - - - - 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 83 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
cat + kMust be uniqueAsc/Ascaccess
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/conv.html b/doc/schemaspy_hubzilla/tables/conv.html deleted file mode 100644 index ac8f8dc8b..000000000 --- a/doc/schemaspy_hubzilla/tables/conv.html +++ /dev/null @@ -1,270 +0,0 @@ - - - - - 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 15 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
createdPerformanceAsccreated
updatedPerformanceAscupdated
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/dreport.html b/doc/schemaspy_hubzilla/tables/dreport.html deleted file mode 100644 index 1f173a14c..000000000 --- a/doc/schemaspy_hubzilla/tables/dreport.html +++ /dev/null @@ -1,316 +0,0 @@ - - - - - SchemaSpy - Table zot.dreport - - - - - - - -
- -
-
- - - - - -
Table zot.dreportGenerated by
SchemaSpy
- -
-
- - - - -
-		 - - - - - - -
Legend:SourceForge.net
- - - - - - - -
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
-
-
- - -
-  -
- - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
dreport_idint10 √ 
dreport_channelint100
dreport_midchar255
dreport_sitechar255
dreport_recipchar255
dreport_resultchar255
dreport_timedatetime190000-00-00 00:00:00
dreport_xchanchar255 - - - - - -
xchan.xchan_hash - Defined in XML R
-
dreport_queuechar255
-

Table contained 8 579 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
dreport_idPrimary keyAscPRIMARY
dreport_channelPerformanceAscdreport_channel
dreport_midPerformanceAscdreport_mid
dreport_queuePerformanceAscdreport_queue
dreport_sitePerformanceAscdreport_site
dreport_timePerformanceAscdreport_time
dreport_xchanPerformanceAscdreport_xchan
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/event.html b/doc/schemaspy_hubzilla/tables/event.html deleted file mode 100644 index 107e9d2ee..000000000 --- a/doc/schemaspy_hubzilla/tables/event.html +++ /dev/null @@ -1,632 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
event_hashchar255 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
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
event_prioritysmallint50
event_vdatatext65535
-

Table contained 12 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
adjustPerformanceAscadjust
aidPerformanceAscaid
event_hashPerformanceAscevent_hash
event_priorityPerformanceAscevent_priority
event_sequencePerformanceAscevent_sequence
event_statusPerformanceAscevent_status
event_xchanPerformanceAscevent_xchan
finishPerformanceAscfinish
ignorePerformanceAscignore
nofinishPerformanceAscnofinish
startPerformanceAscstart
typePerformanceAsctype
uidPerformanceAscuid
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/fcontact.html b/doc/schemaspy_hubzilla/tables/fcontact.html deleted file mode 100644 index 2adb38a0d..000000000 --- a/doc/schemaspy_hubzilla/tables/fcontact.html +++ /dev/null @@ -1,358 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
addrPerformanceAscaddr
networkPerformanceAscnetwork
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/ffinder.html b/doc/schemaspy_hubzilla/tables/ffinder.html deleted file mode 100644 index 3046d7efd..000000000 --- a/doc/schemaspy_hubzilla/tables/ffinder.html +++ /dev/null @@ -1,232 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
cidPerformanceAsccid
fidPerformanceAscfid
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/fserver.html b/doc/schemaspy_hubzilla/tables/fserver.html deleted file mode 100644 index 76ff02c1f..000000000 --- a/doc/schemaspy_hubzilla/tables/fserver.html +++ /dev/null @@ -1,219 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
posturlPerformanceAscposturl
serverPerformanceAscserver
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/fsuggest.html b/doc/schemaspy_hubzilla/tables/fsuggest.html deleted file mode 100644 index 7c118dbfd..000000000 --- a/doc/schemaspy_hubzilla/tables/fsuggest.html +++ /dev/null @@ -1,262 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/group_member.html b/doc/schemaspy_hubzilla/tables/group_member.html deleted file mode 100644 index 9f78e1b46..000000000 --- a/doc/schemaspy_hubzilla/tables/group_member.html +++ /dev/null @@ -1,298 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
-

Table contained 42 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
gidPerformanceAscgid
uidPerformanceAscuid
xchanPerformanceAscxchan
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/groups.html b/doc/schemaspy_hubzilla/tables/groups.html deleted file mode 100644 index 57503f797..000000000 --- a/doc/schemaspy_hubzilla/tables/groups.html +++ /dev/null @@ -1,340 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
uidint unsigned100
visiblebit00
deletedbit00
namechar255
-

Table contained 10 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
deletedPerformanceAscdeleted
hashPerformanceAschash
uidPerformanceAscuid
visiblePerformanceAscvisible
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/hook.html b/doc/schemaspy_hubzilla/tables/hook.html deleted file mode 100644 index 0ac1f2f14..000000000 --- a/doc/schemaspy_hubzilla/tables/hook.html +++ /dev/null @@ -1,224 +0,0 @@ - - - - - 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 41 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
hookPerformanceAschook
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/hubloc.html b/doc/schemaspy_hubzilla/tables/hubloc.html deleted file mode 100644 index a7328a0db..000000000 --- a/doc/schemaspy_hubzilla/tables/hubloc.html +++ /dev/null @@ -1,642 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
attach.hash - Defined in XML R
event.event_hash - Defined in XML R
groups.hash - Defined in XML R
hubloc.hubloc_hash - Defined in XML R
notify.hash - Defined in XML R
outq.outq_hash - Defined in XML R
profext.hash - Defined in XML R
register.hash - Defined in XML R
term.parent_hash - Defined in XML R
term.term_hash - Defined in XML R
updates.ud_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
xprof.xprof_hash - Defined in XML R
xtag.xtag_hash - Defined in XML R
-		 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
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 2 658 rows at fr nov 06 17:11 CET 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
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/issue.html b/doc/schemaspy_hubzilla/tables/issue.html deleted file mode 100644 index 032e0a6f7..000000000 --- a/doc/schemaspy_hubzilla/tables/issue.html +++ /dev/null @@ -1,242 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 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/doc/schemaspy_hubzilla/tables/item.html b/doc/schemaspy_hubzilla/tables/item.html deleted file mode 100644 index 18b8d402d..000000000 --- a/doc/schemaspy_hubzilla/tables/item.html +++ /dev/null @@ -1,1399 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
author_xchanchar255 - - - - - -
xchan.xchan_hash - Defined in XML R
-
source_xchanchar255 - - - - - -
xchan.xchan_hash - Defined in XML R
-
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 37 583 rows at fr nov 06 17:11 CET 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 - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/item_id.html b/doc/schemaspy_hubzilla/tables/item_id.html deleted file mode 100644 index b420a04b9..000000000 --- a/doc/schemaspy_hubzilla/tables/item_id.html +++ /dev/null @@ -1,249 +0,0 @@ - - - - - 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 194 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
iidPerformanceAsciid
servicePerformanceAscservice
sidPerformanceAscsid
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/likes.html b/doc/schemaspy_hubzilla/tables/likes.html deleted file mode 100644 index 562ca9bec..000000000 --- a/doc/schemaspy_hubzilla/tables/likes.html +++ /dev/null @@ -1,347 +0,0 @@ - - - - - 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
i_midchar255
-

Table contained 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
channel_idPerformanceAscchannel_id
i_midPerformanceAsci_mid
iidPerformanceAsciid
likeePerformanceAsclikee
likerPerformanceAscliker
target_idPerformanceAsctarget_id
target_typePerformanceAsctarget_type
verbPerformanceAscverb
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/mail.html b/doc/schemaspy_hubzilla/tables/mail.html deleted file mode 100644 index 15bd03f82..000000000 --- a/doc/schemaspy_hubzilla/tables/mail.html +++ /dev/null @@ -1,608 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
to_xchanchar255 - - - - - -
xchan.xchan_hash - Defined in XML R
-
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
conv_guidchar255
-

Table contained 39 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
account_idPerformanceAscaccount_id
channel_idPerformanceAscchannel_id
conv_guidPerformanceAscconv_guid
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 - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/manage.html b/doc/schemaspy_hubzilla/tables/manage.html deleted file mode 100644 index 82c18d714..000000000 --- a/doc/schemaspy_hubzilla/tables/manage.html +++ /dev/null @@ -1,278 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
-

Table contained 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
uidPerformanceAscuid
xchanPerformanceAscxchan
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/menu.html b/doc/schemaspy_hubzilla/tables/menu.html deleted file mode 100644 index d4825dc36..000000000 --- a/doc/schemaspy_hubzilla/tables/menu.html +++ /dev/null @@ -1,236 +0,0 @@ - - - - - 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 6 rows at fr nov 06 17:11 CET 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/doc/schemaspy_hubzilla/tables/menu_item.html b/doc/schemaspy_hubzilla/tables/menu_item.html deleted file mode 100644 index 9af5e59a9..000000000 --- a/doc/schemaspy_hubzilla/tables/menu_item.html +++ /dev/null @@ -1,268 +0,0 @@ - - - - - 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 15 rows at fr nov 06 17:11 CET 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/doc/schemaspy_hubzilla/tables/notify.html b/doc/schemaspy_hubzilla/tables/notify.html deleted file mode 100644 index 9635c2f6b..000000000 --- a/doc/schemaspy_hubzilla/tables/notify.html +++ /dev/null @@ -1,522 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
namechar255
urlchar255
photochar255
datedatetime190000-00-00 00:00:00
msgmediumtext16777215
aidint100
uidint100
linkchar255
parentchar255
seenbit00
typeint100
verbchar255
otypechar16
-

Table contained 528 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
datePerformanceAscdate
hashPerformanceAschash
linkPerformanceAsclink
otypePerformanceAscotype
parentPerformanceAscparent
seenPerformanceAscseen
typePerformanceAsctype
uidPerformanceAscuid
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/obj.html b/doc/schemaspy_hubzilla/tables/obj.html deleted file mode 100644 index 57523f456..000000000 --- a/doc/schemaspy_hubzilla/tables/obj.html +++ /dev/null @@ -1,354 +0,0 @@ - - - - - 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
obj_termchar255
obj_urlchar255
obj_imgurlchar255
obj_createddatetime190000-00-00 00:00:00
obj_editeddatetime190000-00-00 00:00:00
-

Table contained 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
obj_idPrimary keyAscPRIMARY
obj_channelPerformanceAscobj_channel
obj_createdPerformanceAscobj_created
obj_editedPerformanceAscobj_edited
obj_imgurlPerformanceAscobj_imgurl
obj_objPerformanceAscobj_obj
obj_pagePerformanceAscobj_page
obj_termPerformanceAscobj_term
obj_typePerformanceAscobj_type
obj_urlPerformanceAscobj_url
obj_verbPerformanceAscobj_verb
-
-
- - diff --git a/doc/schemaspy_hubzilla/tables/outq.html b/doc/schemaspy_hubzilla/tables/outq.html deleted file mode 100644 index e25ffde37..000000000 --- a/doc/schemaspy_hubzilla/tables/outq.html +++ /dev/null @@ -1,411 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
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 660 rows at fr nov 06 17:11 CET 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
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/pconfig.html b/doc/schemaspy_hubzilla/tables/pconfig.html deleted file mode 100644 index e57c49461..000000000 --- a/doc/schemaspy_hubzilla/tables/pconfig.html +++ /dev/null @@ -1,238 +0,0 @@ - - - - - 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 719 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
uid + cat + kMust be uniqueAsc/Asc/Ascaccess
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/photo.html b/doc/schemaspy_hubzilla/tables/photo.html deleted file mode 100644 index d8c2d7a66..000000000 --- a/doc/schemaspy_hubzilla/tables/photo.html +++ /dev/null @@ -1,622 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
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 5 888 rows at fr nov 06 17:11 CET 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 - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/poll.html b/doc/schemaspy_hubzilla/tables/poll.html deleted file mode 100644 index 05e9e9b04..000000000 --- a/doc/schemaspy_hubzilla/tables/poll.html +++ /dev/null @@ -1,202 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
poll_idPrimary keyAscPRIMARY
poll_channelPerformanceAscpoll_channel
poll_flagsPerformanceAscpoll_flags
poll_votesPerformanceAscpoll_votes
-
-
- - diff --git a/doc/schemaspy_hubzilla/tables/poll_elm.html b/doc/schemaspy_hubzilla/tables/poll_elm.html deleted file mode 100644 index ed80ade74..000000000 --- a/doc/schemaspy_hubzilla/tables/poll_elm.html +++ /dev/null @@ -1,196 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
pelm_idPrimary keyAscPRIMARY
pelm_pollPerformanceAscpelm_poll
pelm_resultPerformanceAscpelm_result
-
-
- - diff --git a/doc/schemaspy_hubzilla/tables/profdef.html b/doc/schemaspy_hubzilla/tables/profdef.html deleted file mode 100644 index 4c9f7b391..000000000 --- a/doc/schemaspy_hubzilla/tables/profdef.html +++ /dev/null @@ -1,242 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
field_namePerformanceAscfield_name
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/profext.html b/doc/schemaspy_hubzilla/tables/profext.html deleted file mode 100644 index ee9fac7b1..000000000 --- a/doc/schemaspy_hubzilla/tables/profext.html +++ /dev/null @@ -1,343 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
kchar255 - - - - - -
cache.k - Implied Constraint R
-
vmediumtext16777215
-

Table contained 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
channel_idPerformanceAscchannel_id
hashPerformanceAschash
kPerformanceAsck
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/profile.html b/doc/schemaspy_hubzilla/tables/profile.html deleted file mode 100644 index 7885a436b..000000000 --- a/doc/schemaspy_hubzilla/tables/profile.html +++ /dev/null @@ -1,731 +0,0 @@ - - - - - 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 11 rows at fr nov 06 17:11 CET 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/doc/schemaspy_hubzilla/tables/profile_check.html b/doc/schemaspy_hubzilla/tables/profile_check.html deleted file mode 100644 index 076b4706a..000000000 --- a/doc/schemaspy_hubzilla/tables/profile_check.html +++ /dev/null @@ -1,266 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
cidPerformanceAsccid
dfrn_idPerformanceAscdfrn_id
expirePerformanceAscexpire
secPerformanceAscsec
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/register.html b/doc/schemaspy_hubzilla/tables/register.html deleted file mode 100644 index 96ffac229..000000000 --- a/doc/schemaspy_hubzilla/tables/register.html +++ /dev/null @@ -1,334 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
createddatetime190000-00-00 00:00:00
uidint unsigned100
passwordchar255
languagechar16
-

Table contained 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
createdPerformanceAsccreated
hashPerformanceAschash
uidPerformanceAscuid
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/session.html b/doc/schemaspy_hubzilla/tables/session.html deleted file mode 100644 index 2df9a9904..000000000 --- a/doc/schemaspy_hubzilla/tables/session.html +++ /dev/null @@ -1,185 +0,0 @@ - - - - - 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 71 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
expirePerformanceAscexpire
sidPerformanceAscsid
-
-
- - diff --git a/doc/schemaspy_hubzilla/tables/shares.html b/doc/schemaspy_hubzilla/tables/shares.html deleted file mode 100644 index bd500ebdd..000000000 --- a/doc/schemaspy_hubzilla/tables/shares.html +++ /dev/null @@ -1,243 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
-

Table contained 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
share_idPrimary keyAscPRIMARY
share_targetPerformanceAscshare_target
share_typePerformanceAscshare_type
share_xchanPerformanceAscshare_xchan
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/sign.html b/doc/schemaspy_hubzilla/tables/sign.html deleted file mode 100644 index 294e1f73a..000000000 --- a/doc/schemaspy_hubzilla/tables/sign.html +++ /dev/null @@ -1,248 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
iidPerformanceAsciid
retract_iidPerformanceAscretract_iid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/site.html b/doc/schemaspy_hubzilla/tables/site.html deleted file mode 100644 index dfd8a0c81..000000000 --- a/doc/schemaspy_hubzilla/tables/site.html +++ /dev/null @@ -1,366 +0,0 @@ - - - - - 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
site_typesmallint50
site_projectchar255
-

Table contained 224 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
site_urlPrimary keyAscPRIMARY
site_accessPerformanceAscsite_access
site_deadPerformanceAscsite_dead
site_directoryPerformanceAscsite_directory
site_flagsPerformanceAscsite_flags
site_projectPerformanceAscsite_project
site_pullPerformanceAscsite_pull
site_realmPerformanceAscsite_realm
site_registerPerformanceAscsite_register
site_sellpagePerformanceAscsite_sellpage
site_typePerformanceAscsite_type
site_updatePerformanceAscsite_update
site_validPerformanceAscsite_valid
-
-
- - diff --git a/doc/schemaspy_hubzilla/tables/source.html b/doc/schemaspy_hubzilla/tables/source.html deleted file mode 100644 index a91adcd3b..000000000 --- a/doc/schemaspy_hubzilla/tables/source.html +++ /dev/null @@ -1,263 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
src_xchanchar255 - - - - - -
xchan.xchan_hash - Defined in XML R
-
src_pattmediumtext16777215
-

Table contained 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
src_idPrimary keyAscPRIMARY
src_channel_idPerformanceAscsrc_channel_id
src_channel_xchanPerformanceAscsrc_channel_xchan
src_xchanPerformanceAscsrc_xchan
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/spam.html b/doc/schemaspy_hubzilla/tables/spam.html deleted file mode 100644 index 27e031ff9..000000000 --- a/doc/schemaspy_hubzilla/tables/spam.html +++ /dev/null @@ -1,253 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
hamPerformanceAscham
spamPerformanceAscspam
termPerformanceAscterm
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/sys_perms.html b/doc/schemaspy_hubzilla/tables/sys_perms.html deleted file mode 100644 index 732918a8d..000000000 --- a/doc/schemaspy_hubzilla/tables/sys_perms.html +++ /dev/null @@ -1,236 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/term.html b/doc/schemaspy_hubzilla/tables/term.html deleted file mode 100644 index e0a099a38..000000000 --- a/doc/schemaspy_hubzilla/tables/term.html +++ /dev/null @@ -1,427 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
parent_hashchar255 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
-

Table contained 8 980 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
tidPrimary keyAscPRIMARY
aidPerformanceAscaid
imgurlPerformanceAscimgurl
oidPerformanceAscoid
otypePerformanceAscotype
parent_hashPerformanceAscparent_hash
termPerformanceAscterm
term_hashPerformanceAscterm_hash
typePerformanceAsctype
uidPerformanceAscuid
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/tokens.html b/doc/schemaspy_hubzilla/tables/tokens.html deleted file mode 100644 index d92c675a3..000000000 --- a/doc/schemaspy_hubzilla/tables/tokens.html +++ /dev/null @@ -1,245 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
client_idPerformanceAscclient_id
expiresPerformanceAscexpires
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/updates.html b/doc/schemaspy_hubzilla/tables/updates.html deleted file mode 100644 index da9c47bf7..000000000 --- a/doc/schemaspy_hubzilla/tables/updates.html +++ /dev/null @@ -1,344 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
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 fr nov 06 17:11 CET 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
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/verify.html b/doc/schemaspy_hubzilla/tables/verify.html deleted file mode 100644 index 576236d77..000000000 --- a/doc/schemaspy_hubzilla/tables/verify.html +++ /dev/null @@ -1,385 +0,0 @@ - - - - - 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 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
channelPerformanceAscchannel
createdPerformanceAsccreated
metaPerformanceAscmeta
tokenPerformanceAsctoken
typePerformanceAsctype
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/vote.html b/doc/schemaspy_hubzilla/tables/vote.html deleted file mode 100644 index a2238e96d..000000000 --- a/doc/schemaspy_hubzilla/tables/vote.html +++ /dev/null @@ -1,254 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
-

Table contained 0 rows at fr nov 06 17:11 CET 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
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/xchan.html b/doc/schemaspy_hubzilla/tables/xchan.html deleted file mode 100644 index f9f06261f..000000000 --- a/doc/schemaspy_hubzilla/tables/xchan.html +++ /dev/null @@ -1,821 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
abook.abook_xchan - Defined in XML R
attach.hash - Defined in XML R
channel.channel_hash - Defined in XML R
chat.chat_xchan - Defined in XML R
chatpresence.cp_xchan - Defined in XML R
dreport.dreport_xchan - Defined in XML R
event.event_hash - Defined in XML R
event.event_xchan - Defined in XML R
group_member.xchan - Defined in XML R
groups.hash - Defined in XML R
hubloc.hubloc_hash - Defined in XML R
item.author_xchan - Defined in XML R
item.owner_xchan - Defined in XML R
item.source_xchan - Defined in XML R
mail.from_xchan - Defined in XML R
mail.to_xchan - Defined in XML R
manage.xchan - Defined in XML R
notify.hash - Defined in XML R
outq.outq_hash - Defined in XML R
photo.xchan - Defined in XML R
profext.hash - Defined in XML R
register.hash - Defined in XML R
shares.share_xchan - Defined in XML R
source.src_channel_xchan - Defined in XML R
source.src_xchan - Defined in XML R
term.parent_hash - Defined in XML R
term.term_hash - Defined in XML R
updates.ud_hash - Defined in XML R
vote.vote_xchan - Defined in XML R
xchat.xchat_xchan - Defined in XML R
xconfig.xchan - Defined in XML R
xign.xchan - Defined in XML R
xlink.xlink_xchan - Defined in XML R
xprof.xprof_hash - Defined in XML R
xtag.xtag_hash - Defined in XML R
-		 - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
-
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 2 301 rows at fr nov 06 17:11 CET 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
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/xchat.html b/doc/schemaspy_hubzilla/tables/xchat.html deleted file mode 100644 index fd7336ec0..000000000 --- a/doc/schemaspy_hubzilla/tables/xchat.html +++ /dev/null @@ -1,260 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
xchat_editeddatetime190000-00-00 00:00:00
-

Table contained 9 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
xchat_idPrimary keyAscPRIMARY
xchat_descPerformanceAscxchat_desc
xchat_editedPerformanceAscxchat_edited
xchat_urlPerformanceAscxchat_url
xchat_xchanPerformanceAscxchat_xchan
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/xconfig.html b/doc/schemaspy_hubzilla/tables/xconfig.html deleted file mode 100644 index abbf81619..000000000 --- a/doc/schemaspy_hubzilla/tables/xconfig.html +++ /dev/null @@ -1,320 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
catchar255
kchar255 - - - - - -
cache.k - Implied Constraint R
-
vmediumtext16777215
-

Table contained 8 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
catPerformanceAsccat
kPerformanceAsck
xchanPerformanceAscxchan
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/xign.html b/doc/schemaspy_hubzilla/tables/xign.html deleted file mode 100644 index 58b2fa942..000000000 --- a/doc/schemaspy_hubzilla/tables/xign.html +++ /dev/null @@ -1,281 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
-

Table contained 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
uidPerformanceAscuid
xchanPerformanceAscxchan
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/xlink.html b/doc/schemaspy_hubzilla/tables/xlink.html deleted file mode 100644 index 749a93bb4..000000000 --- a/doc/schemaspy_hubzilla/tables/xlink.html +++ /dev/null @@ -1,299 +0,0 @@ - - - - - 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 - - - - - -
xchan.xchan_hash - Defined in XML R
-
xlink_linkchar255
xlink_ratingint100
xlink_rating_texttext65535
xlink_updateddatetime190000-00-00 00:00:00
xlink_staticbit00
xlink_sigtext65535
-

Table contained 4 105 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
xlink_idPrimary keyAscPRIMARY
xlink_linkPerformanceAscxlink_link
xlink_ratingPerformanceAscxlink_rating
xlink_staticPerformanceAscxlink_static
xlink_updatedPerformanceAscxlink_updated
xlink_xchanPerformanceAscxlink_xchan
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/xperm.html b/doc/schemaspy_hubzilla/tables/xperm.html deleted file mode 100644 index f91d527ad..000000000 --- a/doc/schemaspy_hubzilla/tables/xperm.html +++ /dev/null @@ -1,191 +0,0 @@ - - - - - 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 fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
xp_idPrimary keyAscPRIMARY
xp_channelPerformanceAscxp_channel
xp_clientPerformanceAscxp_client
xp_permPerformanceAscxp_perm
-
-
- - diff --git a/doc/schemaspy_hubzilla/tables/xprof.html b/doc/schemaspy_hubzilla/tables/xprof.html deleted file mode 100644 index 835ba2dd2..000000000 --- a/doc/schemaspy_hubzilla/tables/xprof.html +++ /dev/null @@ -1,462 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
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 fr nov 06 17:11 CET 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
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/doc/schemaspy_hubzilla/tables/xtag.html b/doc/schemaspy_hubzilla/tables/xtag.html deleted file mode 100644 index 1af8fbca5..000000000 --- a/doc/schemaspy_hubzilla/tables/xtag.html +++ /dev/null @@ -1,293 +0,0 @@ - - - - - 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 - - - - - - - - - - - - - -
hubloc.hubloc_hash - Defined in XML R
channel.channel_hash - Defined in XML R
xchan.xchan_hash - Defined in XML R
-
xtag_termchar255
xtag_flagsint100
-

Table contained 0 rows at fr nov 06 17:11 CET 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
xtag_idPrimary keyAscPRIMARY
xtag_flagsPerformanceAscxtag_flags
xtag_hashPerformanceAscxtag_hash
xtag_termPerformanceAscxtag_term
-
-
-
Close relationships - within of separation:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - -- cgit v1.2.3