ME2Nm5js

1
2--
3-- Структура таблицы `chat_cache`
4--
5
6CREATE TABLE IF NOT EXISTS `chat_cache` (
7  `user_id` int(11) NOT NULL,
8  `cache` varchar(100) NOT NULL,
9  PRIMARY KEY (`user_id`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11
12-- --------------------------------------------------------
13
14--
15-- Структура таблицы `chat_logs`
16--
17
18CREATE TABLE IF NOT EXISTS `chat_logs` (
19  `room_id` int(10) unsigned NOT NULL,
20  `user_id` int(10) unsigned DEFAULT NULL,
21  `text` text,
22  `created` datetime DEFAULT NULL,
23  KEY `fk_chat_logroom` (`room_id`),
24  KEY `fk_chatlog_user` (`user_id`)
25) ENGINE=InnoDB DEFAULT CHARSET=utf8;
26
27-- --------------------------------------------------------
28
29--
30-- Структура таблицы `chat_rooms`
31--
32
33CREATE TABLE IF NOT EXISTS `chat_rooms` (
34  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
35  `cache` varchar(100) NOT NULL,
36  `type` tinyint(1) NOT NULL COMMENT '0 - private, 1 - conference',
37  `title` varchar(50) DEFAULT NULL,
38  PRIMARY KEY (`id`),
39  KEY `chat_cache` (`cache`)
40) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=157 ;
41
42-- --------------------------------------------------------
43
44--
45-- Структура таблицы `chat_users`
46--
47
48CREATE TABLE IF NOT EXISTS `chat_users` (
49  `room_id` int(10) unsigned NOT NULL,
50  `user_id` int(10) unsigned NOT NULL,
51  UNIQUE KEY `chat_users_uq` (`room_id`,`user_id`),
52  KEY `fk_chat_userroom` (`room_id`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8;
54
55--
56-- Ограничения внешнего ключа сохраненных таблиц
57--
58
59--
60-- Ограничения внешнего ключа таблицы `chat_logs`
61--
62ALTER TABLE `chat_logs`
63  ADD CONSTRAINT `fk_chat_logroom` FOREIGN KEY (`room_id`) REFERENCES `chat_rooms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
64
65--
66-- Ограничения внешнего ключа таблицы `chat_users`
67--
68ALTER TABLE `chat_users`
69  ADD CONSTRAINT `fk_chat_userroom` FOREIGN KEY (`room_id`) REFERENCES `chat_rooms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;