File: patch-protected_titles.sql

package info (click to toggle)
mediawiki 1%3A1.19.20%2Bdfsg-0%2Bdeb7u3
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 75,652 kB
  • sloc: php: 844,154; pascal: 6,026; sql: 5,936; perl: 769; python: 745; makefile: 413; sh: 194; xml: 91; ansic: 77
file content (10 lines) | stat: -rw-r--r-- 454 bytes parent folder | download | duplicates (8) 
1
2
3
4
5
6
7
8
9
10
 
CREATE TABLE protected_titles (
  pt_namespace   SMALLINT    NOT NULL,
  pt_title       TEXT        NOT NULL,
  pt_user        INTEGER         NULL  REFERENCES mwuser(user_id) ON DELETE SET NULL,
  pt_reason      TEXT            NULL,
  pt_timestamp   TIMESTAMPTZ NOT NULL,
  pt_expiry      TIMESTAMPTZ     NULL,
  pt_create_perm TEXT        NOT NULL DEFAULT ''
);
CREATE UNIQUE INDEX protected_titles_unique ON protected_titles(pt_namespace, pt_title);