Advertisement
artur99

Untitled

Jun 26th, 2017
169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. CREATE TABLE `laptops` (
  2. `id` int(11) NOT NULL,
  3. `text1` text NOT NULL,
  4. `text2` text NOT NULL,
  5. `text3` text NOT NULL,
  6. `text4` text NOT NULL,
  7. `text5` text NOT NULL,
  8. `text6` text NOT NULL,
  9. `text7` text NOT NULL,
  10. `text8` text NOT NULL,
  11. `text9` text NOT NULL,
  12. `text10` text NOT NULL
  13. );
  14. ALTER TABLE `laptops` ADD PRIMARY KEY (`id`);
  15. ALTER TABLE `laptops` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  16.  
  17. CREATE TABLE `monitors` (
  18. `id` int(11) NOT NULL,
  19. `text1` text NOT NULL,
  20. `text2` text NOT NULL,
  21. `text3` text NOT NULL,
  22. `text4` text NOT NULL,
  23. `text5` text NOT NULL,
  24. `text6` text NOT NULL,
  25. `text7` text NOT NULL,
  26. `text8` text NOT NULL,
  27. `text9` text NOT NULL,
  28. `text10` text NOT NULL
  29. );
  30. ALTER TABLE `monitors` ADD PRIMARY KEY (`id`);
  31. ALTER TABLE `monitors` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement