yii2

1
/**
2
 * Database schema required by \yii\i18n\DbMessageSource.
3
 *
4
 * @author Dmitry Naumenko <d.naumenko.a@gmail.com>
5
 * @link https://www.yiiframework.com/
6
 * @copyright 2008 Yii Software LLC
7
 * @license https://www.yiiframework.com/license/
8
 * @since 2.0.7
9
 */
10

11

12
drop table if exists `source_message`;
13
drop table if exists `message`;
14

15
CREATE TABLE `source_message`
16
(
17
   `id`          integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
18
   `category`    varchar(255),
19
   `message`     text
20
);
21

22
CREATE TABLE `message`
23
(
24
   `id`          integer NOT NULL,
25
   `language`    varchar(16) NOT NULL,
26
   `translation` text
27
);
28

29
ALTER TABLE `message` ADD CONSTRAINT `pk_message_id_language` PRIMARY KEY (`id`, `language`);
30
ALTER TABLE `message` ADD CONSTRAINT `fk_message_source_message` FOREIGN KEY (`id`) REFERENCES `source_message` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE;
31

32
CREATE INDEX idx_message_language ON message (language);
33
CREATE INDEX idx_source_message_category ON source_message (category);
34