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 PRIMARY KEY,
18
	"category"    varchar(255),
19
	"message"     clob
20
);
21
CREATE SEQUENCE "source_message_SEQ";
22

23
CREATE TABLE "message"
24
(
25
	"id"          integer NOT NULL,
26
	"language"    varchar(16) NOT NULL,
27
	"translation" clob,
28
	primary key ("id", "language"),
29
	foreign key ("id") references "source_message" ("id") on delete cascade
30
);
31

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