VqNTLJcV

1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u1
3-- http://www.phpmyadmin.net
4--
5-- Хост: localhost
6-- Время создания: Сен 17 2016 г., 13:06
7-- Версия сервера: 5.5.49-0+deb8u1-log
8-- Версия PHP: 5.6.22-0+deb8u1
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-- База данных: `v34_vip`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Структура таблицы `vip_keys`
27--
28
29CREATE TABLE IF NOT EXISTS `vip_keys` (
30  `key` varchar(64) NOT NULL,
31  `group` varchar(64) NOT NULL,
32  `time` int(10) unsigned NOT NULL,
33  `created` int(10) unsigned NOT NULL,
34  `lifetime` int(10) unsigned NOT NULL
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36
37-- --------------------------------------------------------
38
39--
40-- Структура таблицы `vip_keys_block_players`
41--
42
43CREATE TABLE IF NOT EXISTS `vip_keys_block_players` (
44  `auth` varchar(24) NOT NULL,
45  `end` int(11) NOT NULL
46) ENGINE=MyISAM DEFAULT CHARSET=utf8;
47
48-- --------------------------------------------------------
49
50--
51-- Структура таблицы `vip_overrides`
52--
53
54CREATE TABLE IF NOT EXISTS `vip_overrides` (
55  `user_id` int(10) unsigned NOT NULL,
56  `server_id` int(10) unsigned NOT NULL,
57  `group` varchar(64) DEFAULT NULL,
58  `expires` int(10) unsigned NOT NULL DEFAULT '0'
59) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60
61-- --------------------------------------------------------
62
63--
64-- Структура таблицы `vip_users`
65--
66
67CREATE TABLE IF NOT EXISTS `vip_users` (
68`id` int(10) unsigned NOT NULL,
69  `auth` varchar(64) DEFAULT NULL,
70  `name` varchar(64) NOT NULL DEFAULT 'unknown',
71  `auth_type` tinyint(2) unsigned NOT NULL DEFAULT '0',
72  `pass_key` varchar(64) DEFAULT NULL,
73  `password` varchar(64) DEFAULT NULL
74) ENGINE=InnoDB AUTO_INCREMENT=658 DEFAULT CHARSET=utf8;
75
76--
77-- Индексы сохранённых таблиц
78--
79
80--
81-- Индексы таблицы `vip_keys`
82--
83ALTER TABLE `vip_keys`
84 ADD PRIMARY KEY (`key`);
85
86--
87-- Индексы таблицы `vip_keys_block_players`
88--
89ALTER TABLE `vip_keys_block_players`
90 ADD PRIMARY KEY (`auth`);
91
92--
93-- Индексы таблицы `vip_overrides`
94--
95ALTER TABLE `vip_overrides`
96 ADD PRIMARY KEY (`user_id`,`server_id`), ADD UNIQUE KEY `user_id` (`user_id`,`server_id`);
97
98--
99-- Индексы таблицы `vip_users`
100--
101ALTER TABLE `vip_users`
102 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `auth` (`auth`), ADD UNIQUE KEY `auth_id` (`auth`);
103
104--
105-- AUTO_INCREMENT для сохранённых таблиц
106--
107
108--
109-- AUTO_INCREMENT для таблицы `vip_users`
110--
111ALTER TABLE `vip_users`
112MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=658;
113--
114-- Ограничения внешнего ключа сохраненных таблиц
115--
116
117--
118-- Ограничения внешнего ключа таблицы `vip_overrides`
119--
120ALTER TABLE `vip_overrides`
121ADD CONSTRAINT `vip_overrides_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `vip_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
122
123/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
124/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
125/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;