ikan Uploader :
Directory : /www/wwwroot/jdih.dprd.mukomukokab.go.id/vendor/yiisoft/yii2/i18n/migrations/
Upload File : |
| Current File : /www/wwwroot/jdih.dprd.mukomukokab.go.id/vendor/yiisoft/yii2/i18n/migrations/schema-pgsql.sql |
/**
* Database schema required by \yii\i18n\DbMessageSource.
*
* @author Dmitry Naumenko <d.naumenko.a@gmail.com>
* @link https://www.yiiframework.com/
* @copyright 2008 Yii Software LLC
* @license https://www.yiiframework.com/license/
* @since 2.0.7
*/
drop table if exists "source_message";
drop table if exists "message";
CREATE SEQUENCE source_message_seq;
CREATE TABLE "source_message"
(
"id" integer NOT NULL PRIMARY KEY DEFAULT nextval('source_message_seq'),
"category" varchar(255),
"message" text
);
CREATE TABLE "message"
(
"id" integer NOT NULL,
"language" varchar(16) NOT NULL,
"translation" text
);
ALTER TABLE "message" ADD CONSTRAINT "pk_message_id_language" PRIMARY KEY ("id", "language");
ALTER TABLE "message" ADD CONSTRAINT "fk_message_source_message" FOREIGN KEY ("id") REFERENCES "source_message" ("id") ON UPDATE RESTRICT ON DELETE CASCADE;
CREATE INDEX "idx_message_language" ON "message" USING btree (language);
ALTER TABLE "message" CLUSTER ON "idx_message_language";
CREATE INDEX "idx_source_message_category" ON "source_message" USING btree (category);
ALTER TABLE "source_message" CLUSTER ON "idx_source_message_category";
Kontol Shell Bypass