Guest User

Untitled

a guest
Jul 17th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `rkmonline`.`requests` (
  2. `ctrc_id` VARCHAR(45) NOT NULL ,
  3. `status` TINYINT(1) NOT NULL DEFAULT 0 ,
  4. `user_id` INT UNSIGNED NOT NULL ,
  5. INDEX `fk_requests_users1` (`user_id` ASC) ,
  6. INDEX `PRIMARY` (`ctrc_id` ASC, `user_id` ASC) ,
  7. CONSTRAINT `fk_requests_users1`
  8. FOREIGN KEY (`user_id` )
  9. REFERENCES `rkmonline`.`users` (`id` )
  10. ON DELETE NO ACTION
  11. ON UPDATE NO ACTION)
  12. ENGINE = InnoDB
Add Comment
Please, Sign In to add comment