11663180c38787533f0070868e186627c3fda33e
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