1234567891011 |
- 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);
|