Wiki Versions Table Schema (wiki_versions)


Description

Stores wiki page history

wiki_versions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
pageid BIGINT 19 0
wiki_pages.id wikivers_pag2_fk R

Page id

content LONGTEXT 2147483647 null

Not parsed wiki content

contentformat VARCHAR 20 creole

Markup used to write content

version MEDIUMINT 7 0

Wiki page version

timecreated BIGINT 19 0

Page edition timestamp

userid BIGINT 19 0
user.id Implied Constraint R

Edition autor

Table contained -1 rows

wiki_versions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
wikivers_pag_ix Performance Asc pageid

wiki_versions table relationships