Blog External Table Schema (blog_external)


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 10 null
userid bigint 10 null 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 10 null
timefetched bigint 10 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