· 7 years ago · Feb 25, 2019, 10:32 AM
1-- Adminer 4.7.0 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `dialogs`;
9CREATE TABLE `dialogs` (
10 `id` int(12) NOT NULL AUTO_INCREMENT,
11 `name` char(100) NOT NULL,
12 `avatar` char(100) NOT NULL,
13 `last_time` int(12) NOT NULL,
14 `author_id` int(12) NOT NULL,
15 `contact_id` int(12) NOT NULL,
16 PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18
19
20DROP TABLE IF EXISTS `dialog_users`;
21CREATE TABLE `dialog_users` (
22 `id` int(12) NOT NULL AUTO_INCREMENT,
23 `access` int(1) NOT NULL,
24 `user_id` int(12) NOT NULL,
25 `dialog_id` int(12) NOT NULL,
26 `date_add` int(12) NOT NULL,
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB DEFAULT CHARSET=latin1;
29
30
31DROP TABLE IF EXISTS `messages`;
32CREATE TABLE `messages` (
33 `id` int(12) NOT NULL AUTO_INCREMENT,
34 `read` int(1) NOT NULL,
35 `time` int(12) NOT NULL,
36 `user_id` int(12) NOT NULL,
37 `dialog_id` int(12) NOT NULL,
38 `message` tinytext NOT NULL,
39 PRIMARY KEY (`id`)
40) ENGINE=MyISAM DEFAULT CHARSET=utf8;
41
42
43DROP TABLE IF EXISTS `user`;
44CREATE TABLE `user` (
45 `id` int(1) NOT NULL AUTO_INCREMENT,
46 `login` varchar(20) NOT NULL,
47 `number` varchar(25) NOT NULL,
48 `token` varchar(60) NOT NULL,
49 `password` varchar(30) NOT NULL,
50 `name` varchar(20) NOT NULL,
51 `last_name` varchar(30) NOT NULL,
52 `avatar` varchar(100) NOT NULL,
53 `fon_avatar` varchar(100) NOT NULL,
54 `country` varchar(40) NOT NULL,
55 `city` varchar(40) NOT NULL,
56 `date_reg` int(12) NOT NULL,
57 `date_last` int(20) NOT NULL,
58 `online` int(12) NOT NULL,
59 `access` int(1) NOT NULL,
60 `email` varchar(50) NOT NULL,
61 `status` varchar(60) NOT NULL,
62 `gender` int(1) NOT NULL,
63 `money` decimal(11,2) NOT NULL DEFAULT '0.00',
64 `vip` int(1) NOT NULL,
65 `age` int(3) NOT NULL,
66 `cache_file` varchar(100) NOT NULL,
67 PRIMARY KEY (`id`)
68) ENGINE=MyISAM DEFAULT CHARSET=utf8;
69
70
71-- 2019-02-25 10:28:24