1 CREATE TABLE redirect (
2 rd_from
BIGINT NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
3 --REFERENCES page(page_id) ON DELETE CASCADE,
4 rd_namespace
SMALLINT NOT NULL DEFAULT 0,
5 rd_title
VARCHAR(255) NOT NULL DEFAULT '',
6 rd_interwiki
varchar(32),
7 rd_fragment
VARCHAR(255)