Advertisement
Guest User

Untitled

a guest
Dec 16th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. $pdo->query('CREATE TABLE `users` (
  2. `id_user` int(11) NOT NULL,
  3. `full_name` varchar(50) COLLATE utf8_polish_ci NOT NULL,
  4. `login` varchar(50) COLLATE utf8_polish_ci NOT NULL,
  5. `password` varchar(50) COLLATE utf8_polish_ci NOT NULL,
  6. `register_a` date NOT NULL,
  7. `is_admin` tinyint(1) NOT NULL,
  8. `added_at` date NOT NULL,
  9. `modified_at` date NOT NULL
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;');
  11.  
  12. $pdo->query('CREATE TABLE `posts` (
  13. `id_post` int(11) NOT NULL,
  14. `id_user` int(11) NOT NULL,
  15. `name` varchar(50) COLLATE utf8_polish_ci NOT NULL,
  16. `content` varchar(50) COLLATE utf8_polish_ci NOT NULL,
  17. `added_at` date NOT NULL,
  18. `modified_at` date NOT NULL
  19. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;');
  20.  
  21. $pdo->query('CREATE TABLE `komments` (
  22. `id_komment` int(11) NOT NULL,
  23. `id_post` int(11) NOT NULL,
  24. `content` varchar(50) COLLATE utf8_polish_ci NOT NULL,
  25. `added_at` date NOT NULL,
  26. `modified` date NOT NULL
  27. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement