-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.txt
55 lines (46 loc) · 1.73 KB
/
db.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
-- Adminer 4.1.0 MySQL dump
SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
CREATE DATABASE `wishes` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `wishes`;
CREATE TABLE `friends` (
`user_id` int(11) unsigned NOT NULL,
`friend_id` int(11) unsigned NOT NULL,
UNIQUE KEY `user_id_friend_id` (`user_id`,`friend_id`),
KEY `friend_id` (`friend_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `friends_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `friends_ibfk_2` FOREIGN KEY (`friend_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`name` varchar(100) NOT NULL,
`surname` varchar(100) NOT NULL,
`sex` varchar(1) NOT NULL,
`state` varchar(100) NOT NULL,
`language` varchar(100) NOT NULL DEFAULT 'en',
`birthdate` varchar(100) NOT NULL,
`profile_image` varchar(100) NOT NULL DEFAULT '',
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`role` varchar(10) NOT NULL DEFAULT 'user',
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `wishes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL,
`name` varchar(100) NOT NULL,
`price` float NOT NULL DEFAULT '0',
`link` varchar(200) NOT NULL,
`image` varchar(64) NOT NULL,
`position` int(11) NOT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
CONSTRAINT `wishes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 2015-01-20 21:00:30