JgXcwVpv

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:52
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-- Структура таблицы `auth_item`
40--
41
42CREATE TABLE IF NOT EXISTS `auth_item` (
43  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
44  `type` smallint(6) NOT NULL,
45  `description` text COLLATE utf8_unicode_ci,
46  `rule_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
47  `data` text COLLATE utf8_unicode_ci,
48  `created_at` int(11) DEFAULT NULL,
49  `updated_at` int(11) DEFAULT NULL,
50  PRIMARY KEY (`name`),
51  KEY `rule_name` (`rule_name`),
52  KEY `idx-auth_item-type` (`type`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
54
55-- --------------------------------------------------------
56
57--
58-- Структура таблицы `auth_item_child`
59--
60
61CREATE TABLE IF NOT EXISTS `auth_item_child` (
62  `parent` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
63  `child` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
64  PRIMARY KEY (`parent`,`child`),
65  KEY `child` (`child`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
67
68-- --------------------------------------------------------
69
70--
71-- Структура таблицы `auth_rule`
72--
73
74CREATE TABLE IF NOT EXISTS `auth_rule` (
75  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
76  `data` text COLLATE utf8_unicode_ci,
77  `created_at` int(11) DEFAULT NULL,
78  `updated_at` int(11) DEFAULT NULL,
79  PRIMARY KEY (`name`)
80) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
81
82--
83-- Ограничения внешнего ключа сохраненных таблиц
84--
85
86--
87-- Ограничения внешнего ключа таблицы `auth_assignment`
88--
89ALTER TABLE `auth_assignment`
90  ADD CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
91
92--
93-- Ограничения внешнего ключа таблицы `auth_item`
94--
95ALTER TABLE `auth_item`
96  ADD CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE;
97
98--
99-- Ограничения внешнего ключа таблицы `auth_item_child`
100--
101ALTER TABLE `auth_item_child`
102  ADD CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
103  ADD CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
104
105/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
106/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
107/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;