patch-redirect.sql 252 B

12345678
  1. CREATE TABLE redirect (
  2. rd_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE,
  3. rd_namespace SMALLINT NOT NULL,
  4. rd_title TEXT NOT NULL
  5. );
  6. CREATE INDEX redirect_ns_title ON redirect (rd_namespace,rd_title,rd_from);