From 20dcf37976ee269adcb2c004c5f612d8509b7f11 Mon Sep 17 00:00:00 2001 From: redmatrix Date: Tue, 15 Dec 2015 17:42:49 -0800 Subject: issue #221 --- hubzilla_er/tables/abook.html | 502 ------------- hubzilla_er/tables/account.html | 417 ----------- hubzilla_er/tables/addon.html | 255 ------- hubzilla_er/tables/app.html | 356 --------- hubzilla_er/tables/attach.html | 513 ------------- hubzilla_er/tables/auth_codes.html | 216 ------ hubzilla_er/tables/cache.html | 215 ------ hubzilla_er/tables/channel.html | 924 ----------------------- hubzilla_er/tables/chat.html | 202 ----- hubzilla_er/tables/chatpresence.html | 219 ------ hubzilla_er/tables/chatroom.html | 286 ------- hubzilla_er/tables/clients.html | 224 ------ hubzilla_er/tables/config.html | 231 ------ hubzilla_er/tables/conv.html | 270 ------- hubzilla_er/tables/event.html | 507 ------------- hubzilla_er/tables/fcontact.html | 358 --------- hubzilla_er/tables/ffinder.html | 232 ------ hubzilla_er/tables/fserver.html | 216 ------ hubzilla_er/tables/fsuggest.html | 259 ------- hubzilla_er/tables/group_member.html | 232 ------ hubzilla_er/tables/groups.html | 260 ------- hubzilla_er/tables/hook.html | 221 ------ hubzilla_er/tables/hubloc.html | 433 ----------- hubzilla_er/tables/issue.html | 242 ------ hubzilla_er/tables/item.html | 1315 --------------------------------- hubzilla_er/tables/item_id.html | 249 ------- hubzilla_er/tables/likes.html | 321 -------- hubzilla_er/tables/mail.html | 517 ------------- hubzilla_er/tables/manage.html | 205 ----- hubzilla_er/tables/menu.html | 236 ------ hubzilla_er/tables/menu_item.html | 268 ------- hubzilla_er/tables/notify.html | 434 ----------- hubzilla_er/tables/obj.html | 269 ------- hubzilla_er/tables/outq.html | 309 -------- hubzilla_er/tables/pconfig.html | 235 ------ hubzilla_er/tables/photo.html | 556 -------------- hubzilla_er/tables/poll.html | 202 ----- hubzilla_er/tables/poll_elm.html | 196 ----- hubzilla_er/tables/profdef.html | 242 ------ hubzilla_er/tables/profext.html | 264 ------- hubzilla_er/tables/profile.html | 728 ------------------ hubzilla_er/tables/profile_check.html | 266 ------- hubzilla_er/tables/register.html | 254 ------- hubzilla_er/tables/session.html | 185 ----- hubzilla_er/tables/shares.html | 191 ----- hubzilla_er/tables/sign.html | 248 ------- hubzilla_er/tables/site.html | 332 --------- hubzilla_er/tables/source.html | 202 ----- hubzilla_er/tables/spam.html | 250 ------- hubzilla_er/tables/sys_perms.html | 236 ------ hubzilla_er/tables/term.html | 304 -------- hubzilla_er/tables/tokens.html | 245 ------ hubzilla_er/tables/updates.html | 242 ------ hubzilla_er/tables/verify.html | 383 ---------- hubzilla_er/tables/vote.html | 202 ----- hubzilla_er/tables/xchan.html | 511 ------------- hubzilla_er/tables/xchat.html | 208 ------ hubzilla_er/tables/xconfig.html | 254 ------- hubzilla_er/tables/xign.html | 215 ------ hubzilla_er/tables/xlink.html | 247 ------- hubzilla_er/tables/xperm.html | 191 ----- hubzilla_er/tables/xprof.html | 360 --------- hubzilla_er/tables/xtag.html | 191 ----- 63 files changed, 20053 deletions(-) delete mode 100644 hubzilla_er/tables/abook.html delete mode 100644 hubzilla_er/tables/account.html delete mode 100644 hubzilla_er/tables/addon.html delete mode 100644 hubzilla_er/tables/app.html delete mode 100644 hubzilla_er/tables/attach.html delete mode 100644 hubzilla_er/tables/auth_codes.html delete mode 100644 hubzilla_er/tables/cache.html delete mode 100644 hubzilla_er/tables/channel.html delete mode 100644 hubzilla_er/tables/chat.html delete mode 100644 hubzilla_er/tables/chatpresence.html delete mode 100644 hubzilla_er/tables/chatroom.html delete mode 100644 hubzilla_er/tables/clients.html delete mode 100644 hubzilla_er/tables/config.html delete mode 100644 hubzilla_er/tables/conv.html delete mode 100644 hubzilla_er/tables/event.html delete mode 100644 hubzilla_er/tables/fcontact.html delete mode 100644 hubzilla_er/tables/ffinder.html delete mode 100644 hubzilla_er/tables/fserver.html delete mode 100644 hubzilla_er/tables/fsuggest.html delete mode 100644 hubzilla_er/tables/group_member.html delete mode 100644 hubzilla_er/tables/groups.html delete mode 100644 hubzilla_er/tables/hook.html delete mode 100644 hubzilla_er/tables/hubloc.html delete mode 100644 hubzilla_er/tables/issue.html delete mode 100644 hubzilla_er/tables/item.html delete mode 100644 hubzilla_er/tables/item_id.html delete mode 100644 hubzilla_er/tables/likes.html delete mode 100644 hubzilla_er/tables/mail.html delete mode 100644 hubzilla_er/tables/manage.html delete mode 100644 hubzilla_er/tables/menu.html delete mode 100644 hubzilla_er/tables/menu_item.html delete mode 100644 hubzilla_er/tables/notify.html delete mode 100644 hubzilla_er/tables/obj.html delete mode 100644 hubzilla_er/tables/outq.html delete mode 100644 hubzilla_er/tables/pconfig.html delete mode 100644 hubzilla_er/tables/photo.html delete mode 100644 hubzilla_er/tables/poll.html delete mode 100644 hubzilla_er/tables/poll_elm.html delete mode 100644 hubzilla_er/tables/profdef.html delete mode 100644 hubzilla_er/tables/profext.html delete mode 100644 hubzilla_er/tables/profile.html delete mode 100644 hubzilla_er/tables/profile_check.html delete mode 100644 hubzilla_er/tables/register.html delete mode 100644 hubzilla_er/tables/session.html delete mode 100644 hubzilla_er/tables/shares.html delete mode 100644 hubzilla_er/tables/sign.html delete mode 100644 hubzilla_er/tables/site.html delete mode 100644 hubzilla_er/tables/source.html delete mode 100644 hubzilla_er/tables/spam.html delete mode 100644 hubzilla_er/tables/sys_perms.html delete mode 100644 hubzilla_er/tables/term.html delete mode 100644 hubzilla_er/tables/tokens.html delete mode 100644 hubzilla_er/tables/updates.html delete mode 100644 hubzilla_er/tables/verify.html delete mode 100644 hubzilla_er/tables/vote.html delete mode 100644 hubzilla_er/tables/xchan.html delete mode 100644 hubzilla_er/tables/xchat.html delete mode 100644 hubzilla_er/tables/xconfig.html delete mode 100644 hubzilla_er/tables/xign.html delete mode 100644 hubzilla_er/tables/xlink.html delete mode 100644 hubzilla_er/tables/xperm.html delete mode 100644 hubzilla_er/tables/xprof.html delete mode 100644 hubzilla_er/tables/xtag.html (limited to 'hubzilla_er/tables') diff --git a/hubzilla_er/tables/abook.html b/hubzilla_er/tables/abook.html deleted file mode 100644 index 7e103df6f..000000000 --- a/hubzilla_er/tables/abook.html +++ /dev/null @@ -1,502 +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
abook_my_permsint100
abook_their_permsint100
abook_closenesstinyint unsigned399
abook_createddatetime190000-00-00 00:00:00
abook_updateddatetime190000-00-00 00:00:00
abook_connecteddatetime190000-00-00 00:00:00
abook_dobdatetime190000-00-00 00:00:00
abook_flagsint100
abook_blockedtinyint30
abook_ignoredtinyint30
abook_hiddentinyint30
abook_archivedtinyint30
abook_pendingtinyint30
abook_unconnectedtinyint30
abook_selftinyint30
abook_feedtinyint30
abook_profilechar64
abook_incltext65535
abook_excltext65535
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
abook_idPrimary keyAscPRIMARY
abook_accountPerformanceAscabook_account
abook_archivedPerformanceAscabook_archived
abook_blockedPerformanceAscabook_blocked
abook_channelPerformanceAscabook_channel
abook_closenessPerformanceAscabook_closeness
abook_connectedPerformanceAscabook_connected
abook_createdPerformanceAscabook_created
abook_dobPerformanceAscabook_dob
abook_feedPerformanceAscabook_feed
abook_flagsPerformanceAscabook_flags
abook_hiddenPerformanceAscabook_hidden
abook_ignoredPerformanceAscabook_ignored
abook_my_permsPerformanceAscabook_my_perms
abook_pendingPerformanceAscabook_pending
abook_profilePerformanceAscabook_profile
abook_selfPerformanceAscabook_self
abook_their_permsPerformanceAscabook_their_perms
abook_unconnectedPerformanceAscabook_unconnected
abook_updatedPerformanceAscabook_updated
abook_xchanPerformanceAscabook_xchan
-
-
- - diff --git a/hubzilla_er/tables/account.html b/hubzilla_er/tables/account.html deleted file mode 100644 index cd2e46eb1..000000000 --- a/hubzilla_er/tables/account.html +++ /dev/null @@ -1,417 +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 1 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
account_idPrimary keyAscPRIMARY
account_default_channelPerformanceAscaccount_default_channel
account_emailPerformanceAscaccount_email
account_expiresPerformanceAscaccount_expires
account_externalPerformanceAscaccount_external
account_flagsPerformanceAscaccount_flags
account_lastlogPerformanceAscaccount_lastlog
account_levelPerformanceAscaccount_level
account_parentPerformanceAscaccount_parent
account_password_changedPerformanceAscaccount_password_changed
account_rolesPerformanceAscaccount_roles
account_service_classPerformanceAscaccount_service_class
-
-
-
Close relationships:
- - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/addon.html b/hubzilla_er/tables/addon.html deleted file mode 100644 index 512eac7d1..000000000 --- a/hubzilla_er/tables/addon.html +++ /dev/null @@ -1,255 +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 0 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
hiddenPerformanceAschidden
installedPerformanceAscinstalled
namePerformanceAscname
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/app.html b/hubzilla_er/tables/app.html deleted file mode 100644 index 0189a9224..000000000 --- a/hubzilla_er/tables/app.html +++ /dev/null @@ -1,356 +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
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
app_channelPerformanceAscapp_channel
app_idPerformanceAscapp_id
app_namePerformanceAscapp_name
app_photoPerformanceAscapp_photo
app_pricePerformanceAscapp_price
app_urlPerformanceAscapp_url
app_versionPerformanceAscapp_version
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/attach.html b/hubzilla_er/tables/attach.html deleted file mode 100644 index ea0353d38..000000000 --- a/hubzilla_er/tables/attach.html +++ /dev/null @@ -1,513 +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
creatorchar128
filenamechar255
filetypechar64
filesizeint unsigned100
revisionint unsigned100
folderchar64
flagsint unsigned100
is_dirbit00
is_photobit00
os_storagebit00
os_pathmediumtext16777215
display_pathmediumtext16777215
datalongblob2147483647
createddatetime190000-00-00 00:00:00
editeddatetime190000-00-00 00:00:00
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
createdPerformanceAsccreated
creatorPerformanceAsccreator
editedPerformanceAscedited
filenamePerformanceAscfilename
filesizePerformanceAscfilesize
filetypePerformanceAscfiletype
flagsPerformanceAscflags
folderPerformanceAscfolder
hashPerformanceAschash
is_dirPerformanceAscis_dir
is_photoPerformanceAscis_photo
os_storagePerformanceAscos_storage
revisionPerformanceAscrevision
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/auth_codes.html b/hubzilla_er/tables/auth_codes.html deleted file mode 100644 index 842fb3c15..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
-
-
-
Close relationships:
- - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/cache.html b/hubzilla_er/tables/cache.html deleted file mode 100644 index e6238f822..000000000 --- a/hubzilla_er/tables/cache.html +++ /dev/null @@ -1,215 +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 21 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
kPrimary keyAscPRIMARY
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/channel.html b/hubzilla_er/tables/channel.html deleted file mode 100644 index 1222058de..000000000 --- a/hubzilla_er/tables/channel.html +++ /dev/null @@ -1,924 +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
channel_timezonechar128UTC
channel_locationchar255
channel_themechar255
channel_startpagechar255
channel_pubkeytext65535
channel_prvkeytext65535
channel_notifyflagsint unsigned1065535
channel_pageflagsint unsigned100
channel_dirdatedatetime190000-00-00 00:00:00
channel_lastpostdatetime190000-00-00 00:00:00
channel_deleteddatetime190000-00-00 00:00:00
channel_max_anon_mailint unsigned1010
channel_max_friend_reqint unsigned1010
channel_expire_daysint100
channel_passwd_resetchar255
channel_default_groupchar255
channel_allow_cidmediumtext16777215
channel_allow_gidmediumtext16777215
channel_deny_cidmediumtext16777215
channel_deny_gidmediumtext16777215
channel_r_streamint unsigned100
channel_r_profileint unsigned100
channel_r_photosint unsigned100
channel_r_abookint unsigned100
channel_w_streamint unsigned100
channel_w_wallint unsigned100
channel_w_tagwallint unsigned100
channel_w_commentint unsigned100
channel_w_mailint unsigned100
channel_w_photosint unsigned100
channel_w_chatint unsigned100
channel_a_delegateint unsigned100
channel_r_storageint unsigned100
channel_w_storageint unsigned100
channel_r_pagesint unsigned100
channel_w_pagesint unsigned100
channel_a_republishint unsigned100
channel_w_likeint unsigned100
channel_removedbit00
channel_systembit00
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
channel_idPrimary keyAscPRIMARY
channel_a_delegatePerformanceAscchannel_a_delegate
channel_a_republishPerformanceAscchannel_a_republish
channel_account_idPerformanceAscchannel_account_id
channel_addressMust be uniqueAscchannel_address_unique
channel_default_groupPerformanceAscchannel_default_gid
channel_deletedPerformanceAscchannel_deleted
channel_dirdatePerformanceAscchannel_dirdate
channel_expire_daysPerformanceAscchannel_expire_days
channel_guidPerformanceAscchannel_guid
channel_hashPerformanceAscchannel_hash
channel_lastpostPerformanceAscchannel_lastpost
channel_locationPerformanceAscchannel_location
channel_max_anon_mailPerformanceAscchannel_max_anon_mail
channel_max_friend_reqPerformanceAscchannel_max_friend_req
channel_namePerformanceAscchannel_name
channel_notifyflagsPerformanceAscchannel_notifyflags
channel_pageflagsPerformanceAscchannel_pageflags
channel_primaryPerformanceAscchannel_primary
channel_r_abookPerformanceAscchannel_r_abook
channel_r_pagesPerformanceAscchannel_r_pages
channel_r_photosPerformanceAscchannel_r_photos
channel_r_profilePerformanceAscchannel_r_profile
channel_r_storagePerformanceAscchannel_r_storage
channel_r_streamPerformanceAscchannel_r_stream
channel_removedPerformanceAscchannel_removed
channel_systemPerformanceAscchannel_system
channel_themePerformanceAscchannel_theme
channel_timezonePerformanceAscchannel_timezone
channel_w_chatPerformanceAscchannel_w_chat
channel_w_commentPerformanceAscchannel_w_comment
channel_w_likePerformanceAscchannel_w_like
channel_w_mailPerformanceAscchannel_w_mail
channel_w_pagesPerformanceAscchannel_w_pages
channel_w_photosPerformanceAscchannel_w_photos
channel_w_storagePerformanceAscchannel_w_storage
channel_w_streamPerformanceAscchannel_w_stream
channel_w_tagwallPerformanceAscchannel_w_tagwall
channel_w_wallPerformanceAscchannel_w_wall
-
-
-
Close relationships:
- - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/chat.html b/hubzilla_er/tables/chat.html deleted file mode 100644 index fb914f215..000000000 --- a/hubzilla_er/tables/chat.html +++ /dev/null @@ -1,202 +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
chat_textmediumtext16777215
createddatetime190000-00-00 00:00:00
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
chat_idPrimary keyAscPRIMARY
chat_roomPerformanceAscchat_room
chat_xchanPerformanceAscchat_xchan
createdPerformanceAsccreated
-
-
- - diff --git a/hubzilla_er/tables/chatpresence.html b/hubzilla_er/tables/chatpresence.html deleted file mode 100644 index 9b6c8c7f0..000000000 --- a/hubzilla_er/tables/chatpresence.html +++ /dev/null @@ -1,219 +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
cp_lastdatetime190000-00-00 00:00:00
cp_statuschar255
cp_clientchar128
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
cp_idPrimary keyAscPRIMARY
cp_lastPerformanceAsccp_last
cp_roomPerformanceAsccp_room
cp_statusPerformanceAsccp_status
cp_xchanPerformanceAsccp_xchan
-
-
- - diff --git a/hubzilla_er/tables/chatroom.html b/hubzilla_er/tables/chatroom.html deleted file mode 100644 index cb7db7985..000000000 --- a/hubzilla_er/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 0 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
cr_idPrimary keyAscPRIMARY
cr_aidPerformanceAsccr_aid
cr_createdPerformanceAsccr_created
cr_editedPerformanceAsccr_edited
cr_expirePerformanceAsccr_expire
cr_namePerformanceAsccr_name
cr_uidPerformanceAsccr_uid
-
-
- - diff --git a/hubzilla_er/tables/clients.html b/hubzilla_er/tables/clients.html deleted file mode 100644 index 81d48f281..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
client_idPrimary keyAscPRIMARY
-
-
-
Close relationships:
- - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/config.html b/hubzilla_er/tables/config.html deleted file mode 100644 index 62536d7ce..000000000 --- a/hubzilla_er/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 52 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
cat + kMust be uniqueAsc/Ascaccess
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/conv.html b/hubzilla_er/tables/conv.html deleted file mode 100644 index bf3cda01f..000000000 --- a/hubzilla_er/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 0 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
createdPerformanceAsccreated
updatedPerformanceAscupdated
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/event.html b/hubzilla_er/tables/event.html deleted file mode 100644 index da92cb295..000000000 --- a/hubzilla_er/tables/event.html +++ /dev/null @@ -1,507 +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
event_hashchar255
createddatetime190000-00-00 00:00:00
editeddatetime190000-00-00 00:00:00
startdatetime190000-00-00 00:00:00
finishdatetime190000-00-00 00:00:00
summarytext65535
descriptiontext65535
locationtext65535
typechar255
nofinishbit00
adjustbit01
ignorebit00
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
event_statuschar255
event_status_datedatetime190000-00-00 00:00:00
event_percentsmallint50
event_repeattext65535
event_sequencesmallint50
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
adjustPerformanceAscadjust
aidPerformanceAscaid
event_hashPerformanceAscevent_hash
event_sequencePerformanceAscevent_sequence
event_statusPerformanceAscevent_status
event_xchanPerformanceAscevent_xchan
finishPerformanceAscfinish
ignorePerformanceAscignore
nofinishPerformanceAscnofinish
startPerformanceAscstart
typePerformanceAsctype
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/fcontact.html b/hubzilla_er/tables/fcontact.html deleted file mode 100644 index 10af48116..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
addrPerformanceAscaddr
networkPerformanceAscnetwork
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/ffinder.html b/hubzilla_er/tables/ffinder.html deleted file mode 100644 index 8c6a09711..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
cidPerformanceAsccid
fidPerformanceAscfid
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/fserver.html b/hubzilla_er/tables/fserver.html deleted file mode 100644 index 0becc814d..000000000 --- a/hubzilla_er/tables/fserver.html +++ /dev/null @@ -1,216 +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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
posturlPerformanceAscposturl
serverPerformanceAscserver
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/fsuggest.html b/hubzilla_er/tables/fsuggest.html deleted file mode 100644 index 7f0b446e5..000000000 --- a/hubzilla_er/tables/fsuggest.html +++ /dev/null @@ -1,259 +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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/group_member.html b/hubzilla_er/tables/group_member.html deleted file mode 100644 index f66faa853..000000000 --- a/hubzilla_er/tables/group_member.html +++ /dev/null @@ -1,232 +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
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
gidPerformanceAscgid
uidPerformanceAscuid
xchanPerformanceAscxchan
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/groups.html b/hubzilla_er/tables/groups.html deleted file mode 100644 index 5e0b4163f..000000000 --- a/hubzilla_er/tables/groups.html +++ /dev/null @@ -1,260 +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
uidint unsigned100
visiblebit00
deletedbit00
namechar255
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
deletedPerformanceAscdeleted
hashPerformanceAschash
uidPerformanceAscuid
visiblePerformanceAscvisible
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/hook.html b/hubzilla_er/tables/hook.html deleted file mode 100644 index 08d9b1aa7..000000000 --- a/hubzilla_er/tables/hook.html +++ /dev/null @@ -1,221 +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 0 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
hookPerformanceAschook
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/hubloc.html b/hubzilla_er/tables/hubloc.html deleted file mode 100644 index 06c3e388b..000000000 --- a/hubzilla_er/tables/hubloc.html +++ /dev/null @@ -1,433 +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
hubloc_addrchar255
hubloc_networkchar32
hubloc_flagsint unsigned100
hubloc_statusint unsigned100
hubloc_urlchar255
hubloc_url_sigtext65535
hubloc_hostchar255
hubloc_callbackchar255
hubloc_connectchar255
hubloc_sitekeytext65535
hubloc_updateddatetime190000-00-00 00:00:00
hubloc_connecteddatetime190000-00-00 00:00:00
hubloc_primarybit00
hubloc_orphancheckbit00
hubloc_errorbit00
hubloc_deletedbit00
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
hubloc_idPrimary keyAscPRIMARY
hubloc_addrPerformanceAschubloc_addr
hubloc_connectPerformanceAschubloc_connect
hubloc_connectedPerformanceAschubloc_connected
hubloc_deletedPerformanceAschubloc_deleted
hubloc_errorPerformanceAschubloc_error
hubloc_flagsPerformanceAschubloc_flags
hubloc_guidPerformanceAschubloc_guid
hubloc_hostPerformanceAschubloc_host
hubloc_networkPerformanceAschubloc_network
hubloc_orphancheckPerformanceAschubloc_orphancheck
hubloc_primaryPerformanceAschubloc_primary
hubloc_statusPerformanceAschubloc_status
hubloc_updatedPerformanceAschubloc_updated
hubloc_urlPerformanceAschubloc_url
-
-
- - diff --git a/hubzilla_er/tables/issue.html b/hubzilla_er/tables/issue.html deleted file mode 100644 index f4befe07f..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
issue_idPrimary keyAscPRIMARY
issue_assignedPerformanceAscissue_assigned
issue_componentPerformanceAscissue_component
issue_createdPerformanceAscissue_created
issue_priorityPerformanceAscissue_priority
issue_statusPerformanceAscissue_status
issue_updatedPerformanceAscissue_updated
-
-
- - diff --git a/hubzilla_er/tables/item.html b/hubzilla_er/tables/item.html deleted file mode 100644 index 8f2684aa5..000000000 --- a/hubzilla_er/tables/item.html +++ /dev/null @@ -1,1315 +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
author_xchanchar255
source_xchanchar255
mimetypechar255
titletext65535
bodymediumtext16777215
htmlmediumtext16777215
appchar255
langchar64
revisionint unsigned100
verbchar255
obj_typechar255
objecttext65535
tgt_typechar255
targettext65535
layout_midchar255
postoptstext65535
routetext65535
llinkchar255
plinkchar255
resource_idchar255
resource_typechar16
attachmediumtext16777215
sigtext65535
diaspora_metamediumtext16777215
locationchar255
coordchar255
public_policychar255
comment_policychar255
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
item_restrictint100
item_flagsint100
item_privatebit00
item_originbit00
item_unseenbit00
item_starredbit00
item_uplinkbit00
item_consensusbit00
item_wallbit00
item_thread_topbit00
item_notshownbit00
item_nsfwbit00
item_relaybit00
item_mentionsmebit00
item_nocommentbit00
item_obscuredbit00
item_verifiedbit00
item_retainedbit00
item_rssbit00
item_deletedbit00
item_typeint100
item_hiddenbit00
item_unpublishedbit00
item_delayedbit00
item_pending_removebit00
item_blockedbit00
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
allow_cidPerformanceAscallow_cid
allow_gidPerformanceAscallow_gid
author_xchanPerformanceAscauthor_xchan
bodyPerformanceAscbody
changedPerformanceAscchanged
comment_policyPerformanceAsccomment_policy
commentedPerformanceAsccommented
comments_closedPerformanceAsccomments_closed
createdPerformanceAsccreated
deny_cidPerformanceAscdeny_cid
deny_gidPerformanceAscdeny_gid
editedPerformanceAscedited
expiresPerformanceAscexpires
item_blockedPerformanceAscitem_blocked
item_consensusPerformanceAscitem_consensus
item_delayedPerformanceAscitem_delayed
item_deletedPerformanceAscitem_deleted
item_flagsPerformanceAscitem_flags
item_hiddenPerformanceAscitem_hidden
item_mentionsmePerformanceAscitem_mentionsme
item_nocommentPerformanceAscitem_nocomment
item_notshownPerformanceAscitem_notshown
item_nsfwPerformanceAscitem_nsfw
item_obscuredPerformanceAscitem_obscured
item_originPerformanceAscitem_origin
item_pending_removePerformanceAscitem_pending_remove
item_privatePerformanceAscitem_private
item_relayPerformanceAscitem_relay
item_restrictPerformanceAscitem_restrict
item_retainedPerformanceAscitem_retained
item_rssPerformanceAscitem_rss
item_starredPerformanceAscitem_starred
item_thread_topPerformanceAscitem_thread_top
item_typePerformanceAscitem_type
item_unpublishedPerformanceAscitem_unpublished
item_unseenPerformanceAscitem_unseen
item_uplinkPerformanceAscitem_uplink
item_verifiedPerformanceAscitem_verified
item_wallPerformanceAscitem_wall
layout_midPerformanceAsclayout_mid
llinkPerformanceAscllink
midPerformanceAscmid
mimetypePerformanceAscmimetype
owner_xchanPerformanceAscowner_xchan
parentPerformanceAscparent
parent_midPerformanceAscparent_mid
public_policyPerformanceAscpublic_policy
receivedPerformanceAscreceived
resource_typePerformanceAscresource_type
revisionPerformanceAscrevision
titlePerformanceAsctitle
uidPerformanceAscuid
uid + commentedPerformanceAsc/Ascuid_commented
uid + createdPerformanceAsc/Ascuid_created
mid + uidPerformanceAsc/Ascuid_mid
verbPerformanceAscverb
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/item_id.html b/hubzilla_er/tables/item_id.html deleted file mode 100644 index ec66e3999..000000000 --- a/hubzilla_er/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 1 rows at on aug 19 21:08 CEST 2015

-

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

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
channel_idPerformanceAscchannel_id
iidPerformanceAsciid
likeePerformanceAsclikee
likerPerformanceAscliker
target_idPerformanceAsctarget_id
target_typePerformanceAsctarget_type
verbPerformanceAscverb
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/mail.html b/hubzilla_er/tables/mail.html deleted file mode 100644 index 96056d5ce..000000000 --- a/hubzilla_er/tables/mail.html +++ /dev/null @@ -1,517 +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
to_xchanchar255
account_idint unsigned100 - - - - - -
account.account_id - Implied Constraint R
-
channel_idint unsigned100 - - - - - -
channel.channel_id - Implied Constraint R
-
titletext65535
bodymediumtext16777215
sigtext65535
attachmediumtext16777215
midchar255
parent_midchar255
mail_deletedtinyint30
mail_repliedtinyint30
mail_isreplytinyint30
mail_seentinyint30
mail_recalledtinyint30
mail_obscuredsmallint50
createddatetime190000-00-00 00:00:00
expiresdatetime190000-00-00 00:00:00
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
account_idPerformanceAscaccount_id
channel_idPerformanceAscchannel_id
convidPerformanceAscconvid
createdPerformanceAsccreated
expiresPerformanceAscexpires
from_xchanPerformanceAscfrom_xchan
mail_deletedPerformanceAscmail_deleted
mail_flagsPerformanceAscmail_flags
mail_isreplyPerformanceAscmail_isreply
mail_obscuredPerformanceAscmail_obscured
mail_recalledPerformanceAscmail_recalled
mail_repliedPerformanceAscmail_replied
mail_seenPerformanceAscmail_seen
midPerformanceAscmid
parent_midPerformanceAscparent_mid
to_xchanPerformanceAscto_xchan
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/manage.html b/hubzilla_er/tables/manage.html deleted file mode 100644 index 0275c18c2..000000000 --- a/hubzilla_er/tables/manage.html +++ /dev/null @@ -1,205 +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
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
uidPerformanceAscuid
xchanPerformanceAscxchan
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/menu.html b/hubzilla_er/tables/menu.html deleted file mode 100644 index e165beb4d..000000000 --- a/hubzilla_er/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 1 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
menu_idPrimary keyAscPRIMARY
menu_channel_idPerformanceAscmenu_channel_id
menu_createdPerformanceAscmenu_created
menu_editedPerformanceAscmenu_edited
menu_flagsPerformanceAscmenu_flags
menu_namePerformanceAscmenu_name
-
-
- - diff --git a/hubzilla_er/tables/menu_item.html b/hubzilla_er/tables/menu_item.html deleted file mode 100644 index 92e2eacc9..000000000 --- a/hubzilla_er/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 1 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
mitem_idPrimary keyAscPRIMARY
mitem_channel_idPerformanceAscmitem_channel_id
mitem_flagsPerformanceAscmitem_flags
mitem_menu_idPerformanceAscmitem_menu_id
-
-
- - diff --git a/hubzilla_er/tables/notify.html b/hubzilla_er/tables/notify.html deleted file mode 100644 index 2eec3e2ce..000000000 --- a/hubzilla_er/tables/notify.html +++ /dev/null @@ -1,434 +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
namechar255
urlchar255
photochar255
datedatetime190000-00-00 00:00:00
msgmediumtext16777215
aidint100
uidint100
linkchar255
parentchar255
seenbit00
typeint100
verbchar255
otypechar16
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
datePerformanceAscdate
hashPerformanceAschash
linkPerformanceAsclink
otypePerformanceAscotype
parentPerformanceAscparent
seenPerformanceAscseen
typePerformanceAsctype
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/obj.html b/hubzilla_er/tables/obj.html deleted file mode 100644 index 97f010598..000000000 --- a/hubzilla_er/tables/obj.html +++ /dev/null @@ -1,269 +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
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
obj_idPrimary keyAscPRIMARY
obj_channelPerformanceAscobj_channel
obj_objPerformanceAscobj_obj
obj_pagePerformanceAscobj_page
obj_typePerformanceAscobj_type
obj_verbPerformanceAscobj_verb
-
-
- - diff --git a/hubzilla_er/tables/outq.html b/hubzilla_er/tables/outq.html deleted file mode 100644 index ceca68f09..000000000 --- a/hubzilla_er/tables/outq.html +++ /dev/null @@ -1,309 +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
outq_accountint unsigned100
outq_channelint unsigned100
outq_driverchar32
outq_posturlchar255
outq_asyncbit00
outq_deliveredbit00
outq_createddatetime190000-00-00 00:00:00
outq_updateddatetime190000-00-00 00:00:00
outq_notifymediumtext16777215
outq_msgmediumtext16777215
outq_prioritysmallint50
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
outq_hashPrimary keyAscPRIMARY
outq_accountPerformanceAscoutq_account
outq_asyncPerformanceAscoutq_async
outq_channelPerformanceAscoutq_channel
outq_createdPerformanceAscoutq_created
outq_deliveredPerformanceAscoutq_delivered
outq_posturlPerformanceAscoutq_hub
outq_priorityPerformanceAscoutq_priority
outq_updatedPerformanceAscoutq_updated
-
-
- - diff --git a/hubzilla_er/tables/pconfig.html b/hubzilla_er/tables/pconfig.html deleted file mode 100644 index 3a4eb4fc6..000000000 --- a/hubzilla_er/tables/pconfig.html +++ /dev/null @@ -1,235 +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 232 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
uid + cat + kMust be uniqueAsc/Asc/Ascaccess
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/photo.html b/hubzilla_er/tables/photo.html deleted file mode 100644 index 0bc69e071..000000000 --- a/hubzilla_er/tables/photo.html +++ /dev/null @@ -1,556 +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
resource_idchar255
createddatetime190000-00-00 00:00:00
editeddatetime190000-00-00 00:00:00
titlechar255
descriptiontext65535
albumchar255
filenamechar255
typechar128image/jpeg
heightsmallint50
widthsmallint50
sizeint unsigned100
datamediumblob16777215
scaletinyint30
photo_usagesmallint50
profilebit00
is_nsfwbit00
os_storagebit00
os_pathmediumtext16777215
display_pathmediumtext16777215
photo_flagsint unsigned100
allow_cidmediumtext16777215
allow_gidmediumtext16777215
deny_cidmediumtext16777215
deny_gidmediumtext16777215
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
albumPerformanceAscalbum
is_nsfwPerformanceAscis_nsfw
os_storagePerformanceAscos_storage
photo_flagsPerformanceAscphoto_flags
photo_usagePerformanceAscphoto_usage
profilePerformanceAscprofile
resource_idPerformanceAscresource_id
scalePerformanceAscscale
sizePerformanceAscsize
typePerformanceAsctype
uidPerformanceAscuid
xchanPerformanceAscxchan
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/poll.html b/hubzilla_er/tables/poll.html deleted file mode 100644 index 7ad9eea73..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
poll_idPrimary keyAscPRIMARY
poll_channelPerformanceAscpoll_channel
poll_flagsPerformanceAscpoll_flags
poll_votesPerformanceAscpoll_votes
-
-
- - diff --git a/hubzilla_er/tables/poll_elm.html b/hubzilla_er/tables/poll_elm.html deleted file mode 100644 index cb6b95fbe..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
pelm_idPrimary keyAscPRIMARY
pelm_pollPerformanceAscpelm_poll
pelm_resultPerformanceAscpelm_result
-
-
- - diff --git a/hubzilla_er/tables/profdef.html b/hubzilla_er/tables/profdef.html deleted file mode 100644 index 2734deed0..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
field_namePerformanceAscfield_name
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/profext.html b/hubzilla_er/tables/profext.html deleted file mode 100644 index 36472fcf9..000000000 --- a/hubzilla_er/tables/profext.html +++ /dev/null @@ -1,264 +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
kchar255 - - - - - -
cache.k - Implied Constraint R
-
vmediumtext16777215
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
channel_idPerformanceAscchannel_id
hashPerformanceAschash
kPerformanceAsck
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/profile.html b/hubzilla_er/tables/profile.html deleted file mode 100644 index e439f0e0b..000000000 --- a/hubzilla_er/tables/profile.html +++ /dev/null @@ -1,728 +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 4 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
aidPerformanceAscaid
country_namePerformanceAsccountry_name
genderPerformanceAscgender
profile_guid + uidMust be uniqueAsc/Ascguid
hide_friendsPerformanceAschide_friends
hometownPerformanceAschometown
is_defaultPerformanceAscis_default
localityPerformanceAsclocality
maritalPerformanceAscmarital
postal_codePerformanceAscpostal_code
profile_guidPerformanceAscprofile_guid
publishPerformanceAscpublish
sexualPerformanceAscsexual
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/profile_check.html b/hubzilla_er/tables/profile_check.html deleted file mode 100644 index 72ef92044..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
cidPerformanceAsccid
dfrn_idPerformanceAscdfrn_id
expirePerformanceAscexpire
secPerformanceAscsec
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/register.html b/hubzilla_er/tables/register.html deleted file mode 100644 index 42a6ec3ed..000000000 --- a/hubzilla_er/tables/register.html +++ /dev/null @@ -1,254 +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
createddatetime190000-00-00 00:00:00
uidint unsigned100
passwordchar255
languagechar16
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
createdPerformanceAsccreated
hashPerformanceAschash
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/session.html b/hubzilla_er/tables/session.html deleted file mode 100644 index 452d1b776..000000000 --- a/hubzilla_er/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 23 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
expirePerformanceAscexpire
sidPerformanceAscsid
-
-
- - diff --git a/hubzilla_er/tables/shares.html b/hubzilla_er/tables/shares.html deleted file mode 100644 index e370e5c9a..000000000 --- a/hubzilla_er/tables/shares.html +++ /dev/null @@ -1,191 +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
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
share_idPrimary keyAscPRIMARY
share_targetPerformanceAscshare_target
share_typePerformanceAscshare_type
share_xchanPerformanceAscshare_xchan
-
-
- - diff --git a/hubzilla_er/tables/sign.html b/hubzilla_er/tables/sign.html deleted file mode 100644 index 3ab4d8d31..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

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

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
site_urlPrimary keyAscPRIMARY
site_accessPerformanceAscsite_access
site_deadPerformanceAscsite_dead
site_directoryPerformanceAscsite_directory
site_flagsPerformanceAscsite_flags
site_pullPerformanceAscsite_pull
site_realmPerformanceAscsite_realm
site_registerPerformanceAscsite_register
site_sellpagePerformanceAscsite_sellpage
site_updatePerformanceAscsite_update
site_validPerformanceAscsite_valid
-
-
- - diff --git a/hubzilla_er/tables/source.html b/hubzilla_er/tables/source.html deleted file mode 100644 index ac58a2798..000000000 --- a/hubzilla_er/tables/source.html +++ /dev/null @@ -1,202 +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
src_xchanchar255
src_pattmediumtext16777215
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
src_idPrimary keyAscPRIMARY
src_channel_idPerformanceAscsrc_channel_id
src_channel_xchanPerformanceAscsrc_channel_xchan
src_xchanPerformanceAscsrc_xchan
-
-
- - diff --git a/hubzilla_er/tables/spam.html b/hubzilla_er/tables/spam.html deleted file mode 100644 index 9996c49cd..000000000 --- a/hubzilla_er/tables/spam.html +++ /dev/null @@ -1,250 +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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
hamPerformanceAscham
spamPerformanceAscspam
termPerformanceAscterm
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/sys_perms.html b/hubzilla_er/tables/sys_perms.html deleted file mode 100644 index 672b98166..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/term.html b/hubzilla_er/tables/term.html deleted file mode 100644 index 5f1039d06..000000000 --- a/hubzilla_er/tables/term.html +++ /dev/null @@ -1,304 +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
parent_hashchar255
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
tidPrimary keyAscPRIMARY
aidPerformanceAscaid
imgurlPerformanceAscimgurl
oidPerformanceAscoid
otypePerformanceAscotype
parent_hashPerformanceAscparent_hash
termPerformanceAscterm
term_hashPerformanceAscterm_hash
typePerformanceAsctype
uidPerformanceAscuid
-
-
- - diff --git a/hubzilla_er/tables/tokens.html b/hubzilla_er/tables/tokens.html deleted file mode 100644 index 0217c4f11..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
client_idPerformanceAscclient_id
expiresPerformanceAscexpires
uidPerformanceAscuid
-
-
-
Close relationships:
- - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/updates.html b/hubzilla_er/tables/updates.html deleted file mode 100644 index 78d0b01ad..000000000 --- a/hubzilla_er/tables/updates.html +++ /dev/null @@ -1,242 +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
ud_guidchar255
ud_datedatetime190000-00-00 00:00:00
ud_lastdatetime190000-00-00 00:00:00
ud_flagsint100
ud_addrchar255
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
ud_idPrimary keyAscPRIMARY
ud_addrPerformanceAscud_addr
ud_datePerformanceAscud_date
ud_flagsPerformanceAscud_flags
ud_guidPerformanceAscud_guid
ud_hashPerformanceAscud_hash
ud_lastPerformanceAscud_last
-
-
- - diff --git a/hubzilla_er/tables/verify.html b/hubzilla_er/tables/verify.html deleted file mode 100644 index e01eb4f62..000000000 --- a/hubzilla_er/tables/verify.html +++ /dev/null @@ -1,383 +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 1 rows at on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
channelPerformanceAscchannel
createdPerformanceAsccreated
metaPerformanceAscmeta
tokenPerformanceAsctoken
typePerformanceAsctype
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/vote.html b/hubzilla_er/tables/vote.html deleted file mode 100644 index 641c39857..000000000 --- a/hubzilla_er/tables/vote.html +++ /dev/null @@ -1,202 +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
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
vote_idPrimary keyAscPRIMARY
vote_elementPerformanceAscvote_element
vote_pollPerformanceAscvote_poll
vote_poll + vote_element + vote_xchanMust be uniqueAsc/Asc/Ascvote_vote
-
-
- - diff --git a/hubzilla_er/tables/xchan.html b/hubzilla_er/tables/xchan.html deleted file mode 100644 index 97be20010..000000000 --- a/hubzilla_er/tables/xchan.html +++ /dev/null @@ -1,511 +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
xchan_guidchar255
xchan_guid_sigtext65535
xchan_pubkeytext65535
xchan_photo_mimetypechar32image/jpeg
xchan_photo_lchar255
xchan_photo_mchar255
xchan_photo_schar255
xchan_addrchar255
xchan_urlchar255
xchan_connurlchar255
xchan_followchar255
xchan_connpagechar255
xchan_namechar255
xchan_networkchar255
xchan_instance_urlchar255
xchan_flagsint unsigned100
xchan_photo_datedatetime190000-00-00 00:00:00
xchan_name_datedatetime190000-00-00 00:00:00
xchan_hiddenbit00
xchan_orphanbit00
xchan_censoredbit00
xchan_selfcensoredbit00
xchan_systembit00
xchan_pubforumbit00
xchan_deletedbit00
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
xchan_hashPrimary keyAscPRIMARY
xchan_addrPerformanceAscxchan_addr
xchan_censoredPerformanceAscxchan_censored
xchan_connurlPerformanceAscxchan_connurl
xchan_deletedPerformanceAscxchan_deleted
xchan_flagsPerformanceAscxchan_flags
xchan_followPerformanceAscxchan_follow
xchan_guidPerformanceAscxchan_guid
xchan_hiddenPerformanceAscxchan_hidden
xchan_instance_urlPerformanceAscxchan_instance_url
xchan_namePerformanceAscxchan_name
xchan_networkPerformanceAscxchan_network
xchan_orphanPerformanceAscxchan_orphan
xchan_pubforumPerformanceAscxchan_pubforum
xchan_selfcensoredPerformanceAscxchan_selfcensored
xchan_systemPerformanceAscxchan_system
xchan_urlPerformanceAscxchan_url
-
-
- - diff --git a/hubzilla_er/tables/xchat.html b/hubzilla_er/tables/xchat.html deleted file mode 100644 index 707f80199..000000000 --- a/hubzilla_er/tables/xchat.html +++ /dev/null @@ -1,208 +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
xchat_editeddatetime190000-00-00 00:00:00
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
xchat_idPrimary keyAscPRIMARY
xchat_descPerformanceAscxchat_desc
xchat_editedPerformanceAscxchat_edited
xchat_urlPerformanceAscxchat_url
xchat_xchanPerformanceAscxchat_xchan
-
-
- - diff --git a/hubzilla_er/tables/xconfig.html b/hubzilla_er/tables/xconfig.html deleted file mode 100644 index c3e3c453a..000000000 --- a/hubzilla_er/tables/xconfig.html +++ /dev/null @@ -1,254 +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
catchar255
kchar255 - - - - - -
cache.k - Implied Constraint R
-
vmediumtext16777215
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
catPerformanceAsccat
kPerformanceAsck
xchanPerformanceAscxchan
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/xign.html b/hubzilla_er/tables/xign.html deleted file mode 100644 index a8d430c34..000000000 --- a/hubzilla_er/tables/xign.html +++ /dev/null @@ -1,215 +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
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
idPrimary keyAscPRIMARY
uidPerformanceAscuid
xchanPerformanceAscxchan
-
-
-
Close relationships:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-
- - diff --git a/hubzilla_er/tables/xlink.html b/hubzilla_er/tables/xlink.html deleted file mode 100644 index 8b4c81ad7..000000000 --- a/hubzilla_er/tables/xlink.html +++ /dev/null @@ -1,247 +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
xlink_linkchar255
xlink_ratingint100
xlink_rating_texttext65535
xlink_updateddatetime190000-00-00 00:00:00
xlink_staticbit00
xlink_sigtext65535
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
xlink_idPrimary keyAscPRIMARY
xlink_linkPerformanceAscxlink_link
xlink_ratingPerformanceAscxlink_rating
xlink_staticPerformanceAscxlink_static
xlink_updatedPerformanceAscxlink_updated
xlink_xchanPerformanceAscxlink_xchan
-
-
- - diff --git a/hubzilla_er/tables/xperm.html b/hubzilla_er/tables/xperm.html deleted file mode 100644 index 466a84bfa..000000000 --- a/hubzilla_er/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 on aug 19 21:08 CEST 2015

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
xp_idPrimary keyAscPRIMARY
xp_channelPerformanceAscxp_channel
xp_clientPerformanceAscxp_client
xp_permPerformanceAscxp_perm
-
-
- - diff --git a/hubzilla_er/tables/xprof.html b/hubzilla_er/tables/xprof.html deleted file mode 100644 index c5d7695fb..000000000 --- a/hubzilla_er/tables/xprof.html +++ /dev/null @@ -1,360 +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
xprof_agetinyint unsigned30
xprof_descchar255
xprof_dobchar12
xprof_genderchar255
xprof_maritalchar255
xprof_sexualchar255
xprof_localechar255
xprof_regionchar255
xprof_postcodechar32
xprof_countrychar255
xprof_keywordstext65535
xprof_abouttext65535
xprof_homepagechar255
xprof_hometownchar255
-

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

-

-
-Indexes: -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Column(s)TypeSortConstraint Name
xprof_hashPrimary keyAscPRIMARY
xprof_agePerformanceAscxprof_age
xprof_countryPerformanceAscxprof_country
xprof_descPerformanceAscxprof_desc
xprof_dobPerformanceAscxprof_dob
xprof_genderPerformanceAscxprof_gender
xprof_hometownPerformanceAscxprof_hometown
xprof_localePerformanceAscxprof_locale
xprof_maritalPerformanceAscxprof_marital
xprof_postcodePerformanceAscxprof_postcode
xprof_regionPerformanceAscxprof_region
xprof_sexualPerformanceAscxprof_sexual
-
-
- - diff --git a/hubzilla_er/tables/xtag.html b/hubzilla_er/tables/xtag.html deleted file mode 100644 index bdd04c26e..000000000 --- a/hubzilla_er/tables/xtag.html +++ /dev/null @@ -1,191 +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
xtag_termchar255
xtag_flagsint100
-

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

-

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