xwGeXrWR

1-- phpMyAdmin SQL Dump
2-- version 4.0.10.10
3-- http://www.phpmyadmin.net
4--
5-- Хост: 127.0.0.1:3306
6-- Время создания: Сен 02 2016 г., 22:57
7-- Версия сервера: 5.5.45
8-- Версия PHP: 5.5.28
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- База данных: `job`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Структура таблицы `messages`
27--
28
29CREATE TABLE IF NOT EXISTS `messages` (
30  `id` bigint(20) NOT NULL AUTO_INCREMENT,
31  `uid` bigint(20) NOT NULL,
32  `uid_to` bigint(20) NOT NULL,
33  `text` text NOT NULL,
34  `time` int(12) NOT NULL,
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
37
38-- --------------------------------------------------------
39
40--
41-- Структура таблицы `users`
42--
43
44CREATE TABLE IF NOT EXISTS `users` (
45  `id` bigint(20) NOT NULL AUTO_INCREMENT,
46  `nickname` varchar(64) NOT NULL,
47  `avatar` text NOT NULL,
48  `password` varchar(128) NOT NULL,
49  `lastonline` int(12) NOT NULL,
50  `longtitude` int(12) NOT NULL,
51  `latitude` int(12) NOT NULL,
52  PRIMARY KEY (`id`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
54
55/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
56/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
57/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;