QYuXJTz9

1CREATE DATABASE IF NOT EXISTS `camagru` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
2USE `camagru`;
3CREATE TABLE `data` (
4  `id` int(11) NOT NULL,
5  `login` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
6  `picture` text COLLATE utf8_unicode_ci NOT NULL,
7  `likes` int(11) DEFAULT '0',
8  `liker` text COLLATE utf8_unicode_ci,
9  `comments` text COLLATE utf8_unicode_ci
10) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
11
12CREATE TABLE `user_db` (
13  `id` int(11) NOT NULL,
14  `login` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
15  `password` binary(64) NOT NULL COMMENT 'sha-256',
16  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
17  `creation_date` date DEFAULT NULL,
18  `cle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
19  `valid` tinyint(1) DEFAULT NULL
20) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
21ALTER TABLE `data`
22  ADD PRIMARY KEY (`id`);
23ALTER TABLE `user_db`
24  ADD PRIMARY KEY (`id`);
25ALTER TABLE `data`
26  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
27ALTER TABLE `user_db`
28  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;