Advertisement
Guest User

Untitled

a guest
Jun 2nd, 2016
343
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.51 KB | None | 0 0
  1. CREATE TABLE `users` (
  2.  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  3.  `username` varchar(255) NOT NULL,
  4.  PRIMARY KEY (`user_id`)
  5. );
  6.  
  7.  
  8. CREATE TABLE `forum_users` (
  9.  `id` int(11) NOT NULL AUTO_INCREMENT,
  10.  `user_id` int(11) NOT NULL,
  11.  `forum_username` varchar(255) NOT NULL,
  12.  PRIMARY KEY (`id`)
  13. );
  14.  
  15.  
  16. INSERT INTO users
  17.     (user_id,username)
  18. VALUES
  19.     (23,'mycoolname666'),
  20.     (36,'killername');
  21.  
  22.    
  23. INSERT INTO forum_users
  24.     (id,user_id,forum_username)
  25. VALUES
  26.     (1,23,'randomname123'),
  27.     (2,36,'namethatisrandom');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement