r_permission_user.sql 526 B

1234567891011121314151617181920212223
  1. -- --------------------------------------------------------
  2. --
  3. -- Table structure for table `r_permission_user`
  4. --
  5. -- Creation: Aug 27, 2015 at 04:22 PM
  6. --
  7. DROP TABLE IF EXISTS `r_permission_user`;
  8. CREATE TABLE IF NOT EXISTS `r_permission_user` (
  9. `per_id` int(10) NOT NULL,
  10. `u_id` int(10) NOT NULL
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  12. --
  13. -- RELATIONS FOR TABLE `r_permission_user`:
  14. --
  15. --
  16. -- Indexes for table `r_permission_user`
  17. --
  18. ALTER TABLE `r_permission_user`
  19. ADD PRIMARY KEY (`per_id`,`u_id`);