2 -- patch-categorylinks-better-collation.sql
5 -- Track category inclusions *used inline*
6 -- This tracks a single level of category membership
7 -- (folksonomic tagging, really).
9 CREATE TABLE categorylinks (
10 cl_from BIGINT NOT NULL DEFAULT 0,
11 -- REFERENCES page(page_id) ON DELETE CASCADE,
12 cl_to VARCHAR(255) NOT NULL,
13 -- cl_sortkey has to be at least 86 wide
14 -- in order to be compatible with the old MySQL schema from MW 1.10
15 --cl_sortkey VARCHAR(86),
16 cl_sortkey VARCHAR(230) FOR BIT DATA NOT NULL ,
17 cl_sortkey_prefix VARCHAR(255) FOR BIT DATA NOT NULL ,
18 cl_timestamp TIMESTAMP(3) NOT NULL,
19 cl_collation VARCHAR(32) FOR BIT DATA NOT NULL ,
20 cl_type VARCHAR(6) FOR BIT DATA NOT NULL