Advertisement
miguelmartins1987

MediaWiki's Oracle missing table?

Mar 26th, 2019
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.44 KB | None | 0 0
  1. CREATE TABLE bot_passwords (
  2.   bp_user NUMBER NOT NULL,
  3.   bp_app_id varchar2(32) NOT NULL,
  4.   bp_password varchar2(255) NOT NULL,
  5.   bp_token varchar2(255) NOT NULL,
  6.   bp_restrictions varchar2(255) NOT NULL,
  7.   bp_grants varchar2(255) NOT NULL
  8. );
  9.  
  10. ALTER TABLE bot_passwords ADD CONSTRAINT bot_passwords_pk PRIMARY KEY(bp_user, bp_app_id);
  11. ALTER TABLE bot_passwords ADD CONSTRAINT bot_passwords_fk FOREIGN KEY(bp_user) REFERENCES MWUSER(user_id);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement