Advertisement
Guest User

Untitled

a guest
Dec 29th, 2017
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. CREATE TABLE categories (
  2. `category_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  3. `category_position` INT(11) NOT NULL,
  4. `category_title` VARCHAR(150) NOT NULL,
  5. );
  6.  
  7. CREATE TABLE categories_classic (
  8. `category_classic_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  9. `category_classic_category_position` INT(11) NOT NULL,
  10. `category_classic_position` INT(11) NOT NULL
  11. );
  12.  
  13. CREATE TABLE categories_modern (
  14. `category_modern_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  15. `category_modern_category_position` INT(11) NOT NULL,
  16. `category_modern_position` INT(11) NOT NULL
  17. );
  18.  
  19. CREATE TABLE forums (
  20. `forum_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  21. `forum_category_classic_position` INT(11) NOT NULL,
  22. `forum_category_modern_position` INT(11) NOT NULL,
  23. `forum_position` INT(11) NOT NULL,
  24. `forum_image` VARCHAR(150) NOT NULL,
  25. `forum_title` VARCHAR(150) NOT NULL,
  26. `forum_description` VARCHAR(255) NOT NULL
  27. );
  28.  
  29. CREATE TABLE topics (
  30. `topic_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  31. `topic_forum_id` INT(11) NOT NULL,
  32. `topic_position` INT(11) NOT NULL,
  33. `topic_title` VARCHAR(150) NOT NULL,
  34. `topic_description` VARCHAR(255) NOT NULL
  35. );
  36.  
  37. CREATE TABLE posts (
  38. `post_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  39. `post_topic_id` INT(11) NOT NULL,
  40. `post_position` INT(11) NOT NULL,
  41. `post_title` VARCHAR(150) NOT NULL,
  42. `post_description` VARCHAR(255) NOT NULL
  43. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement