PCexDYLa

1-- phpMyAdmin SQL Dump
2-- version 4.0.10.10
3-- http://www.phpmyadmin.net
4--
5-- Хост: 127.0.0.1:3306
6-- Время создания: Ноя 07 2016 г., 16:44
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-- База данных: `zaedu`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Структура таблицы `auth_assignment`
27--
28
29CREATE TABLE IF NOT EXISTS `auth_assignment` (
30  `item_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
31  `user_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
32  `created_at` int(11) DEFAULT NULL,
33  PRIMARY KEY (`item_name`,`user_id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
35
36--
37-- Ограничения внешнего ключа сохраненных таблиц
38--
39
40--
41-- Ограничения внешнего ключа таблицы `auth_assignment`
42--
43ALTER TABLE `auth_assignment`
44  ADD CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
45
46/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
47/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
48/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
49
50-- phpMyAdmin SQL Dump
51-- version 4.0.10.10
52-- http://www.phpmyadmin.net
53--
54-- Хост: 127.0.0.1:3306
55-- Время создания: Ноя 07 2016 г., 16:45
56-- Версия сервера: 5.5.45
57-- Версия PHP: 5.5.28
58
59SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
60SET time_zone = "+00:00";
61
62
63/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
64/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
65/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
66/*!40101 SET NAMES utf8 */;
67
68--
69-- База данных: `zaedu`
70--
71
72-- --------------------------------------------------------
73
74--
75-- Структура таблицы `auth_item`
76--
77
78CREATE TABLE IF NOT EXISTS `auth_item` (
79  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
80  `type` smallint(6) NOT NULL,
81  `description` text COLLATE utf8_unicode_ci,
82  `rule_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
83  `data` text COLLATE utf8_unicode_ci,
84  `created_at` int(11) DEFAULT NULL,
85  `updated_at` int(11) DEFAULT NULL,
86  PRIMARY KEY (`name`),
87  KEY `rule_name` (`rule_name`),
88  KEY `idx-auth_item-type` (`type`)
89) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
90
91--
92-- Ограничения внешнего ключа сохраненных таблиц
93--
94
95--
96-- Ограничения внешнего ключа таблицы `auth_item`
97--
98ALTER TABLE `auth_item`
99  ADD CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE;
100
101/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
102/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
103/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
104
105-- phpMyAdmin SQL Dump
106-- version 4.0.10.10
107-- http://www.phpmyadmin.net
108--
109-- Хост: 127.0.0.1:3306
110-- Время создания: Ноя 07 2016 г., 16:46
111-- Версия сервера: 5.5.45
112-- Версия PHP: 5.5.28
113
114SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
115SET time_zone = "+00:00";
116
117
118/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
119/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
120/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
121/*!40101 SET NAMES utf8 */;
122
123--
124-- База данных: `zaedu`
125--
126
127-- --------------------------------------------------------
128
129--
130-- Структура таблицы `auth_item_child`
131--
132
133CREATE TABLE IF NOT EXISTS `auth_item_child` (
134  `parent` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
135  `child` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
136  PRIMARY KEY (`parent`,`child`),
137  KEY `child` (`child`)
138) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
139
140--
141-- Ограничения внешнего ключа сохраненных таблиц
142--
143
144--
145-- Ограничения внешнего ключа таблицы `auth_item_child`
146--
147ALTER TABLE `auth_item_child`
148  ADD CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
149  ADD CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
150
151/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
152/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
153/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
154
155-- phpMyAdmin SQL Dump
156-- version 4.0.10.10
157-- http://www.phpmyadmin.net
158--
159-- Хост: 127.0.0.1:3306
160-- Время создания: Ноя 07 2016 г., 16:46
161-- Версия сервера: 5.5.45
162-- Версия PHP: 5.5.28
163
164SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
165SET time_zone = "+00:00";
166
167
168/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
169/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
170/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
171/*!40101 SET NAMES utf8 */;
172
173--
174-- База данных: `zaedu`
175--
176
177-- --------------------------------------------------------
178
179--
180-- Структура таблицы `auth_rule`
181--
182
183CREATE TABLE IF NOT EXISTS `auth_rule` (
184  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
185  `data` text COLLATE utf8_unicode_ci,
186  `created_at` int(11) DEFAULT NULL,
187  `updated_at` int(11) DEFAULT NULL,
188  PRIMARY KEY (`name`)
189) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
190
191/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
192/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
193/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;