DtXGaK4U

1e-- Adminer 3.4.0 MySQL dump
2
3SET NAMES utf8;
4SET foreign_key_checks = 0;
5SET time_zone = 'SYSTEM';
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `friends`;
9CREATE TABLE `friends` (
10  `id` int(11) NOT NULL AUTO_INCREMENT,
11  `user_id` int(11) NOT NULL,
12  `friend_id` int(11) NOT NULL,
13  `pending_friends` int(11) NOT NULL,
14  PRIMARY KEY (`id`)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8;
16
17
18DROP TABLE IF EXISTS `tweets`;
19CREATE TABLE `tweets` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `text` text NOT NULL,
22  `user_id` int(11) NOT NULL,
23  `date` text NOT NULL,
24  PRIMARY KEY (`id`)
25) ENGINE=MyISAM DEFAULT CHARSET=utf8;
26
27
28DROP TABLE IF EXISTS `users`;
29CREATE TABLE `users` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `surname` text NOT NULL,
32  `email` text NOT NULL,
33  `pass` text NOT NULL,
34  `name` text NOT NULL,
35  `picture` text NOT NULL,
36  `gender` text NOT NULL,
37  `birthday_day` int(11) NOT NULL,
38  `birthday_month` int(11) NOT NULL,
39  `birthday_year` int(11) NOT NULL,
40  `country` text NOT NULL,
41  `nickname` text NOT NULL,
42  `about_me` text NOT NULL,
43  `skills` text NOT NULL,
44  PRIMARY KEY (`id`)
45) ENGINE=MyISAM DEFAULT CHARSET=utf8;
46
47
48-- 2012-08-10 16:16:58