Advertisement
rdgorodrigo

Untitled

Oct 26th, 2020
2,122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.63 KB | None | 0 0
  1. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  2. SET AUTOCOMMIT = 0;
  3. START TRANSACTION;
  4. SET time_zone = "+00:00";
  5.  
  6. --
  7. -- Table structure for table `sc_user_scores`
  8. --
  9.  
  10. CREATE TABLE `sc_user_scores` (
  11.   `row_id` INT(11) NOT NULL,
  12.   `user_id` INT(11) NOT NULL,
  13.   `user_score` INT(11) NOT NULL
  14. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  15.  
  16. --
  17. -- Indexes for table `sc_user_scores`
  18. --
  19. ALTER TABLE `sc_user_scores`
  20.   ADD PRIMARY KEY (`row_id`),
  21.   ADD UNIQUE KEY `user_id` (`user_id`);
  22.  
  23. --
  24. -- AUTO_INCREMENT for table `sc_user_scores`
  25. --
  26. ALTER TABLE `sc_user_scores`
  27.   MODIFY `row_id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
  28. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement