Index: trunk/phase3/maintenance/postgres/tables.sql |
— | — | @@ -87,7 +87,7 @@ |
88 | 88 | rev_page INTEGER NULL REFERENCES page (page_id) ON DELETE CASCADE, |
89 | 89 | rev_text_id INTEGER NULL, -- FK |
90 | 90 | rev_comment TEXT, |
91 | | - rev_user INTEGER NOT NULL REFERENCES mwuser(user_id), |
| 91 | + rev_user INTEGER NOT NULL REFERENCES mwuser(user_id) ON DELETE RESTRICT, |
92 | 92 | rev_user_text TEXT NOT NULL, |
93 | 93 | rev_timestamp TIMESTAMPTZ NOT NULL, |
94 | 94 | rev_minor_edit CHAR NOT NULL DEFAULT '0', |