Blog External Table Schema (blog_external)


Description

External blog links used for RSS copying of blog entries to Moodle user blogs

blog_external table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 null
user.id blogexte_use2_fk R
name VARCHAR 255
description LONGTEXT 2147483647 null
url LONGTEXT 2147483647 null
filtertags VARCHAR 255 null

Comma-separated list of tags that will be used to filter which entries are copied over from the external blog. They refer to existing tags in the external blog.

failedlastsync BIT 1 0

Whether or not the last sync failed for some reason

timemodified BIGINT 19 null
timefetched BIGINT 19 0

Table contained -1 rows

blog_external table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
blogexte_use_ix Performance Asc userid

blog_external table relationships