+ cl_timestamp timestamp NOT NULL,
+
+ -- Stores $wgCollationVersion at the time cl_sortkey was generated. This can
+ -- be used to install new collation versions, tracking which rows are not yet
+ -- updated. 0 means no collation, this is a legacy row that needs to be
+ -- updated by updateCollation.php. In the future, it might be possible to
+ -- specify different collations per category.
+ cl_collation tinyint NOT NULL default 0,
+
+ -- Stores whether cl_from is a category, file, or other page, so we can
+ -- paginate the three categories separately. This never has to be updated
+ -- after the page is created, since none of these page types can be moved to
+ -- any other.
+ cl_type ENUM('page', 'subcat', 'file') NOT NULL default 'page'