diff options
Diffstat (limited to 'maintenance/oracle/tables.sql')
| -rw-r--r-- | maintenance/oracle/tables.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql index 9f875aed5095..3722120519db 100644 --- a/maintenance/oracle/tables.sql +++ b/maintenance/oracle/tables.sql @@ -272,7 +272,8 @@ CREATE TABLE &mw_prefix.ipblocks ( ipb_range_end VARCHAR2(255), ipb_deleted CHAR(1) DEFAULT '0' NOT NULL, ipb_block_email CHAR(1) DEFAULT '0' NOT NULL, - ipb_allow_usertalk CHAR(1) DEFAULT '0' NOT NULL + ipb_allow_usertalk CHAR(1) DEFAULT '0' NOT NULL, + ipb_parent_block_id NUMBER DEFAULT NULL ); ALTER TABLE &mw_prefix.ipblocks ADD CONSTRAINT &mw_prefix.ipblocks_pk PRIMARY KEY (ipb_id); ALTER TABLE &mw_prefix.ipblocks ADD CONSTRAINT &mw_prefix.ipblocks_fk1 FOREIGN KEY (ipb_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; |