2AnRpYL0

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