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 SEQUENCE source_message_seq;
16

17
CREATE TABLE "source_message"
18
(
19
   "id"         integer NOT NULL PRIMARY KEY DEFAULT nextval('source_message_seq'),
20
   "category"   varchar(255),
21
   "message"    text
22
);
23

24
CREATE TABLE "message"
25
(
26
   "id"          integer NOT NULL,
27
   "language"    varchar(16) NOT NULL,
28
   "translation" text
29
);
30

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

34
CREATE INDEX "idx_message_language" ON "message" USING btree (language);
35
ALTER TABLE "message" CLUSTER ON "idx_message_language";
36

37
CREATE INDEX "idx_source_message_category" ON "source_message" USING btree (category);
38
ALTER TABLE "source_message" CLUSTER ON "idx_source_message_category";
39