Page Table Schema (page)


Description

Each record is one page and its config data

page table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
wiki_locks.pageid Implied Constraint R
wiki_synonyms.pageid Implied Constraint R
course BIGINT 19 0
name VARCHAR 255
intro LONGTEXT 2147483647 null
introformat SMALLINT 5 0
content LONGTEXT 2147483647 null
contentformat SMALLINT 5 0
legacyfiles SMALLINT 5 0
legacyfileslast BIGINT 19 null
display SMALLINT 5 0
displayoptions LONGTEXT 2147483647 null
revision BIGINT 19 0

incremented when after each file changes, solves browser caching issues

timemodified BIGINT 19 0

Table contained -1 rows

page table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
page_cou_ix Performance Asc course

page table relationships