Skip to content
Snippets Groups Projects

membership history

Merged membership history
enh-membership-status into main
1 unresolved thread
Merged poka requested to merge enh-membership-status into main
1 unresolved thread
Compare
and
12 files
+ 243
− 100
Compare changes
  • Side-by-side
  • Inline
Files
12
db/migrations/1705641339864-Data.js → db/migrations/1705877992505-Data.js
+ 22
− 14
module.exports = class Data1705641339864 {
name = 'Data1705641339864'
module.exports = class Data1705877992505 {
name = 'Data1705877992505'
async up(db) {
await db.query(`CREATE TABLE "event" ("id" character varying NOT NULL, "index" integer NOT NULL, "phase" text NOT NULL, "pallet" text NOT NULL, "name" text NOT NULL, "args" jsonb, "args_str" text array, "block_id" character varying, "extrinsic_id" character varying, "call_id" character varying, CONSTRAINT "PK_30c2f3bbaf6d34a55f8ae6e4614" PRIMARY KEY ("id"))`)
@@ -54,19 +54,21 @@ module.exports = class Data1705641339864 {
await db.query(`CREATE INDEX "IDX_af577baa612d86d98a1ae58343" ON "change_owner_key" ("identity_id") `)
await db.query(`CREATE INDEX "IDX_e09547f07faef3256f7f0381e9" ON "change_owner_key" ("previous_id") `)
await db.query(`CREATE INDEX "IDX_9a9f8cdcae54d8b4375d70fe8b" ON "change_owner_key" ("next_id") `)
await db.query(`CREATE TABLE "identity" ("id" character varying NOT NULL, "index" integer NOT NULL, "name" text NOT NULL, "status" character varying(11) NOT NULL, "account_id" character varying, CONSTRAINT "REL_bafa9e6c71c3f69cef6602a809" UNIQUE ("account_id"), CONSTRAINT "PK_ff16a44186b286d5e626178f726" PRIMARY KEY ("id"))`)
await db.query(`CREATE TABLE "identity" ("id" character varying NOT NULL, "index" integer NOT NULL, "name" text NOT NULL, "status" character varying(11) NOT NULL, "smith_status" character varying(8), "account_id" character varying, CONSTRAINT "REL_bafa9e6c71c3f69cef6602a809" UNIQUE ("account_id"), CONSTRAINT "PK_ff16a44186b286d5e626178f726" PRIMARY KEY ("id"))`)
await db.query(`CREATE UNIQUE INDEX "IDX_6f883c7979ea8dff46327f67cc" ON "identity" ("index") `)
await db.query(`CREATE UNIQUE INDEX "IDX_bafa9e6c71c3f69cef6602a809" ON "identity" ("account_id") `)
await db.query(`CREATE INDEX "IDX_883ba5be237fba47f2a2f39145" ON "identity" ("name") `)
await db.query(`CREATE INDEX "IDX_ee232f862b258f533e70bbb24d" ON "identity" ("status") `)
await db.query(`CREATE TABLE "account" ("id" character varying NOT NULL, "linked_identity_id" character varying, CONSTRAINT "PK_54115ee388cdb6d86bb4bf5b2ea" PRIMARY KEY ("id"))`)
await db.query(`CREATE INDEX "IDX_73d14d249a6dcf9abe42eaa657" ON "account" ("linked_identity_id") `)
await db.query(`CREATE TABLE "membership" ("id" character varying NOT NULL, "expire_on" integer NOT NULL, "identity_id" character varying, CONSTRAINT "REL_efc905420f5f6bfded16c4eb97" UNIQUE ("identity_id"), CONSTRAINT "PK_83c1afebef3059472e7c37e8de8" PRIMARY KEY ("id"))`)
await db.query(`CREATE TABLE "membership_creation" ("id" character varying NOT NULL, "block_number" integer NOT NULL, "membership_id" character varying, CONSTRAINT "REL_e5d3930684fbf95b33e3c0b0a2" UNIQUE ("membership_id"), CONSTRAINT "PK_83b52baf73acff2c5fee412c759" PRIMARY KEY ("id"))`)
await db.query(`CREATE UNIQUE INDEX "IDX_e5d3930684fbf95b33e3c0b0a2" ON "membership_creation" ("membership_id") `)
await db.query(`CREATE TABLE "membership_renewal" ("id" character varying NOT NULL, "block_number" integer NOT NULL, "membership_id" character varying, CONSTRAINT "REL_5014c63f1d833f455417f80e82" UNIQUE ("membership_id"), CONSTRAINT "PK_dba26e0ad129ff43927cb431857" PRIMARY KEY ("id"))`)
await db.query(`CREATE UNIQUE INDEX "IDX_5014c63f1d833f455417f80e82" ON "membership_renewal" ("membership_id") `)
await db.query(`CREATE TABLE "membership_removal" ("id" character varying NOT NULL, "block_number" integer NOT NULL, "membership_id" character varying, CONSTRAINT "REL_8437e2d6c78482e62d19e92272" UNIQUE ("membership_id"), CONSTRAINT "PK_9b9bf7018f5d8e6061050805499" PRIMARY KEY ("id"))`)
await db.query(`CREATE UNIQUE INDEX "IDX_8437e2d6c78482e62d19e92272" ON "membership_removal" ("membership_id") `)
await db.query(`CREATE TABLE "membership" ("id" character varying NOT NULL, "active" boolean NOT NULL, "created_on" integer NOT NULL, "expire_on" integer NOT NULL, "identity_id" character varying, CONSTRAINT "REL_efc905420f5f6bfded16c4eb97" UNIQUE ("identity_id"), CONSTRAINT "PK_83c1afebef3059472e7c37e8de8" PRIMARY KEY ("id"))`)
await db.query(`CREATE UNIQUE INDEX "IDX_efc905420f5f6bfded16c4eb97" ON "membership" ("identity_id") `)
await db.query(`CREATE INDEX "IDX_a3f3d8dc21447800f72c0a27b2" ON "membership" ("expire_on") `)
await db.query(`CREATE TABLE "smith_membership" ("id" character varying NOT NULL, "status" character varying(8) NOT NULL, "identity_id" character varying, CONSTRAINT "REL_8645aa09a4cfa921be42f1bdc1" UNIQUE ("identity_id"), CONSTRAINT "PK_ec71fc36eab1a7cb666eb11f60a" PRIMARY KEY ("id"))`)
await db.query(`CREATE UNIQUE INDEX "IDX_8645aa09a4cfa921be42f1bdc1" ON "smith_membership" ("identity_id") `)
await db.query(`CREATE INDEX "IDX_553a87a08bf4e7909831e6b03b" ON "smith_membership" ("status") `)
await db.query(`ALTER TABLE "event" ADD CONSTRAINT "FK_2b0d35d675c4f99751855c45021" FOREIGN KEY ("block_id") REFERENCES "block"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "event" ADD CONSTRAINT "FK_129efedcb305c80256db2d57a59" FOREIGN KEY ("extrinsic_id") REFERENCES "extrinsic"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "event" ADD CONSTRAINT "FK_83cf1bd59aa4521ed882fa51452" FOREIGN KEY ("call_id") REFERENCES "call"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
@@ -89,8 +91,10 @@ module.exports = class Data1705641339864 {
await db.query(`ALTER TABLE "change_owner_key" ADD CONSTRAINT "FK_9a9f8cdcae54d8b4375d70fe8be" FOREIGN KEY ("next_id") REFERENCES "account"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "identity" ADD CONSTRAINT "FK_bafa9e6c71c3f69cef6602a8095" FOREIGN KEY ("account_id") REFERENCES "account"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "account" ADD CONSTRAINT "FK_73d14d249a6dcf9abe42eaa6573" FOREIGN KEY ("linked_identity_id") REFERENCES "identity"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "membership_creation" ADD CONSTRAINT "FK_e5d3930684fbf95b33e3c0b0a27" FOREIGN KEY ("membership_id") REFERENCES "membership"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "membership_renewal" ADD CONSTRAINT "FK_5014c63f1d833f455417f80e825" FOREIGN KEY ("membership_id") REFERENCES "membership"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "membership_removal" ADD CONSTRAINT "FK_8437e2d6c78482e62d19e922720" FOREIGN KEY ("membership_id") REFERENCES "membership"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "membership" ADD CONSTRAINT "FK_efc905420f5f6bfded16c4eb978" FOREIGN KEY ("identity_id") REFERENCES "identity"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "smith_membership" ADD CONSTRAINT "FK_8645aa09a4cfa921be42f1bdc1b" FOREIGN KEY ("identity_id") REFERENCES "identity"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
}
async down(db) {
@@ -153,12 +157,14 @@ module.exports = class Data1705641339864 {
await db.query(`DROP INDEX "public"."IDX_ee232f862b258f533e70bbb24d"`)
await db.query(`DROP TABLE "account"`)
await db.query(`DROP INDEX "public"."IDX_73d14d249a6dcf9abe42eaa657"`)
await db.query(`DROP TABLE "membership_creation"`)
await db.query(`DROP INDEX "public"."IDX_e5d3930684fbf95b33e3c0b0a2"`)
await db.query(`DROP TABLE "membership_renewal"`)
await db.query(`DROP INDEX "public"."IDX_5014c63f1d833f455417f80e82"`)
await db.query(`DROP TABLE "membership_removal"`)
await db.query(`DROP INDEX "public"."IDX_8437e2d6c78482e62d19e92272"`)
await db.query(`DROP TABLE "membership"`)
await db.query(`DROP INDEX "public"."IDX_efc905420f5f6bfded16c4eb97"`)
await db.query(`DROP INDEX "public"."IDX_a3f3d8dc21447800f72c0a27b2"`)
await db.query(`DROP TABLE "smith_membership"`)
await db.query(`DROP INDEX "public"."IDX_8645aa09a4cfa921be42f1bdc1"`)
await db.query(`DROP INDEX "public"."IDX_553a87a08bf4e7909831e6b03b"`)
await db.query(`ALTER TABLE "event" DROP CONSTRAINT "FK_2b0d35d675c4f99751855c45021"`)
await db.query(`ALTER TABLE "event" DROP CONSTRAINT "FK_129efedcb305c80256db2d57a59"`)
await db.query(`ALTER TABLE "event" DROP CONSTRAINT "FK_83cf1bd59aa4521ed882fa51452"`)
@@ -181,7 +187,9 @@ module.exports = class Data1705641339864 {
await db.query(`ALTER TABLE "change_owner_key" DROP CONSTRAINT "FK_9a9f8cdcae54d8b4375d70fe8be"`)
await db.query(`ALTER TABLE "identity" DROP CONSTRAINT "FK_bafa9e6c71c3f69cef6602a8095"`)
await db.query(`ALTER TABLE "account" DROP CONSTRAINT "FK_73d14d249a6dcf9abe42eaa6573"`)
await db.query(`ALTER TABLE "membership_creation" DROP CONSTRAINT "FK_e5d3930684fbf95b33e3c0b0a27"`)
await db.query(`ALTER TABLE "membership_renewal" DROP CONSTRAINT "FK_5014c63f1d833f455417f80e825"`)
await db.query(`ALTER TABLE "membership_removal" DROP CONSTRAINT "FK_8437e2d6c78482e62d19e922720"`)
await db.query(`ALTER TABLE "membership" DROP CONSTRAINT "FK_efc905420f5f6bfded16c4eb978"`)
await db.query(`ALTER TABLE "smith_membership" DROP CONSTRAINT "FK_8645aa09a4cfa921be42f1bdc1b"`)
}
}