Skip to content
Snippets Groups Projects

add ref to blockchain event in cert and membership events

Merged add ref to blockchain event in cert and membership events
add-genesis-event into main
Merged poka requested to merge add-genesis-event into main
Compare
and
15 files
+ 303
− 241
Compare changes
  • Side-by-side
  • Inline
Files
15
db/migrations/1707320532523-Data.js → db/migrations/1707734171133-Data.js
+ 23
− 23
module.exports = class Data1707320532523 {
name = 'Data1707320532523'
module.exports = class Data1707734171133 {
name = 'Data1707734171133'
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"))`)
@@ -38,30 +38,30 @@ module.exports = class Data1707320532523 {
await db.query(`CREATE INDEX "IDX_76bdfed1a7eb27c6d8ecbb7349" ON "transfer" ("from_id") `)
await db.query(`CREATE INDEX "IDX_0751309c66e97eac9ef1149362" ON "transfer" ("to_id") `)
await db.query(`CREATE INDEX "IDX_f4007436c1b546ede08a4fd7ab" ON "transfer" ("amount") `)
await db.query(`CREATE TABLE "cert_creation" ("id" character varying NOT NULL, "block_number" integer NOT NULL, "cert_id" character varying, CONSTRAINT "PK_d415e4bd4dfc9963bb69620d8fc" PRIMARY KEY ("id"))`)
await db.query(`CREATE INDEX "IDX_6d1fc166dc4bd9394775c3603a" ON "cert_creation" ("cert_id") `)
await db.query(`CREATE TABLE "cert_renewal" ("id" character varying NOT NULL, "block_number" integer NOT NULL, "cert_id" character varying, CONSTRAINT "PK_2b8c3fc001515715892efe4fe3b" PRIMARY KEY ("id"))`)
await db.query(`CREATE INDEX "IDX_f1596a2147377881d3bd73dc18" ON "cert_renewal" ("cert_id") `)
await db.query(`CREATE TABLE "cert_removal" ("id" character varying NOT NULL, "block_number" integer NOT NULL, "cert_id" character varying, CONSTRAINT "PK_2b3e8cf035b04205a4b1f6a0acf" PRIMARY KEY ("id"))`)
await db.query(`CREATE INDEX "IDX_2efb6397676a3b82bde7631ed0" ON "cert_removal" ("cert_id") `)
await db.query(`CREATE TABLE "cert" ("id" character varying NOT NULL, "active" boolean NOT NULL, "created_on" integer NOT NULL, "expire_on" integer NOT NULL, "issuer_id" character varying, "receiver_id" character varying, CONSTRAINT "PK_6a0ce80cc860598b4f16c00998c" PRIMARY KEY ("id"))`)
await db.query(`CREATE TABLE "cert_event" ("id" character varying NOT NULL, "block_number" integer NOT NULL, "event_type" character varying(8) NOT NULL, "cert_id" character varying, "event_id" character varying, CONSTRAINT "PK_cb04492d319a579bebcd3aeed21" PRIMARY KEY ("id"))`)
await db.query(`CREATE INDEX "IDX_d2bc74ffa9c2571da03670f2c8" ON "cert_event" ("cert_id") `)
await db.query(`CREATE INDEX "IDX_411c2bb1469a8a96762ceb00ae" ON "cert_event" ("event_id") `)
await db.query(`CREATE INDEX "IDX_53154146094ec7b030dbc31388" ON "cert_event" ("block_number") `)
await db.query(`CREATE TABLE "cert" ("id" character varying NOT NULL, "is_active" boolean NOT NULL, "created_on" integer NOT NULL, "expire_on" integer NOT NULL, "issuer_id" character varying, "receiver_id" character varying, CONSTRAINT "PK_6a0ce80cc860598b4f16c00998c" PRIMARY KEY ("id"))`)
await db.query(`CREATE INDEX "IDX_70592e488b2e75cd8a2fa79826" ON "cert" ("issuer_id") `)
await db.query(`CREATE INDEX "IDX_262e29ab91c8ebc727cc518f2f" ON "cert" ("receiver_id") `)
await db.query(`CREATE TABLE "smith_cert" ("id" character varying NOT NULL, "created_on" integer NOT NULL, "issuer_id" character varying, "receiver_id" character varying, CONSTRAINT "PK_ae2ef36c9f6d40348c86230fd35" PRIMARY KEY ("id"))`)
await db.query(`CREATE INDEX "IDX_ae67cbd087fcea0e1ec2f70cd0" ON "smith_cert" ("issuer_id") `)
await db.query(`CREATE INDEX "IDX_5e414c1d12af16165881a16b63" ON "smith_cert" ("receiver_id") `)
await db.query(`CREATE TABLE "membership_event" ("id" character varying NOT NULL, "event_type" character varying(8) NOT NULL, "identity_id" character varying, "event_id" character varying, CONSTRAINT "PK_a5bbbf1d51331d1ff4e6419c48e" PRIMARY KEY ("id"))`)
await db.query(`CREATE TABLE "membership_event" ("id" character varying NOT NULL, "event_type" character varying(8) NOT NULL, "block_number" integer NOT NULL, "identity_id" character varying, "event_id" character varying, CONSTRAINT "PK_a5bbbf1d51331d1ff4e6419c48e" PRIMARY KEY ("id"))`)
await db.query(`CREATE INDEX "IDX_fbbd75d84ab6cc2aafeaf37a03" ON "membership_event" ("identity_id") `)
await db.query(`CREATE INDEX "IDX_cebe39c6f75881fb55dbe13741" ON "membership_event" ("event_id") `)
await db.query(`CREATE INDEX "IDX_ee64fbb3478fcf66c0098609df" ON "membership_event" ("block_number") `)
await db.query(`CREATE TABLE "change_owner_key" ("id" character varying NOT NULL, "block_number" integer NOT NULL, "identity_id" character varying, "previous_id" character varying, "next_id" character varying, CONSTRAINT "PK_bc0eb6d98434c5b8b2250752395" PRIMARY KEY ("id"))`)
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, "smith_status" character varying(8), "membership_active" boolean NOT NULL, "membership_expire_on" integer, "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, "created_on" integer NOT NULL, "last_change_on" integer NOT NULL, "smith_status" character varying(8), "is_member" boolean NOT NULL, "expire_on" integer NOT NULL, "account_id" character varying, "created_in_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 INDEX "IDX_666fdfaf3a12c96e95ab0a0b31" ON "identity" ("created_in_id") `)
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(`ALTER TABLE "event" ADD CONSTRAINT "FK_2b0d35d675c4f99751855c45021" FOREIGN KEY ("block_id") REFERENCES "block"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
@@ -74,9 +74,8 @@ module.exports = class Data1707320532523 {
await db.query(`ALTER TABLE "extrinsic" ADD CONSTRAINT "FK_824d47cc4b2cda726405aa507ca" FOREIGN KEY ("call_id") REFERENCES "call"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "transfer" ADD CONSTRAINT "FK_76bdfed1a7eb27c6d8ecbb73496" FOREIGN KEY ("from_id") REFERENCES "account"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "transfer" ADD CONSTRAINT "FK_0751309c66e97eac9ef11493623" FOREIGN KEY ("to_id") REFERENCES "account"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "cert_creation" ADD CONSTRAINT "FK_6d1fc166dc4bd9394775c3603a6" FOREIGN KEY ("cert_id") REFERENCES "cert"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "cert_renewal" ADD CONSTRAINT "FK_f1596a2147377881d3bd73dc182" FOREIGN KEY ("cert_id") REFERENCES "cert"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "cert_removal" ADD CONSTRAINT "FK_2efb6397676a3b82bde7631ed03" FOREIGN KEY ("cert_id") REFERENCES "cert"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "cert_event" ADD CONSTRAINT "FK_d2bc74ffa9c2571da03670f2c8e" FOREIGN KEY ("cert_id") REFERENCES "cert"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "cert_event" ADD CONSTRAINT "FK_411c2bb1469a8a96762ceb00ae6" FOREIGN KEY ("event_id") REFERENCES "event"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "cert" ADD CONSTRAINT "FK_70592e488b2e75cd8a2fa798261" FOREIGN KEY ("issuer_id") REFERENCES "identity"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "cert" ADD CONSTRAINT "FK_262e29ab91c8ebc727cc518f2fb" FOREIGN KEY ("receiver_id") REFERENCES "identity"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
await db.query(`ALTER TABLE "smith_cert" ADD CONSTRAINT "FK_ae67cbd087fcea0e1ec2f70cd04" FOREIGN KEY ("issuer_id") REFERENCES "identity"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
@@ -87,6 +86,7 @@ module.exports = class Data1707320532523 {
await db.query(`ALTER TABLE "change_owner_key" ADD CONSTRAINT "FK_e09547f07faef3256f7f0381e9d" FOREIGN KEY ("previous_id") REFERENCES "account"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
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 "identity" ADD CONSTRAINT "FK_666fdfaf3a12c96e95ab0a0b31c" FOREIGN KEY ("created_in_id") REFERENCES "event"("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`)
}
@@ -127,12 +127,10 @@ module.exports = class Data1707320532523 {
await db.query(`DROP INDEX "public"."IDX_76bdfed1a7eb27c6d8ecbb7349"`)
await db.query(`DROP INDEX "public"."IDX_0751309c66e97eac9ef1149362"`)
await db.query(`DROP INDEX "public"."IDX_f4007436c1b546ede08a4fd7ab"`)
await db.query(`DROP TABLE "cert_creation"`)
await db.query(`DROP INDEX "public"."IDX_6d1fc166dc4bd9394775c3603a"`)
await db.query(`DROP TABLE "cert_renewal"`)
await db.query(`DROP INDEX "public"."IDX_f1596a2147377881d3bd73dc18"`)
await db.query(`DROP TABLE "cert_removal"`)
await db.query(`DROP INDEX "public"."IDX_2efb6397676a3b82bde7631ed0"`)
await db.query(`DROP TABLE "cert_event"`)
await db.query(`DROP INDEX "public"."IDX_d2bc74ffa9c2571da03670f2c8"`)
await db.query(`DROP INDEX "public"."IDX_411c2bb1469a8a96762ceb00ae"`)
await db.query(`DROP INDEX "public"."IDX_53154146094ec7b030dbc31388"`)
await db.query(`DROP TABLE "cert"`)
await db.query(`DROP INDEX "public"."IDX_70592e488b2e75cd8a2fa79826"`)
await db.query(`DROP INDEX "public"."IDX_262e29ab91c8ebc727cc518f2f"`)
@@ -142,6 +140,7 @@ module.exports = class Data1707320532523 {
await db.query(`DROP TABLE "membership_event"`)
await db.query(`DROP INDEX "public"."IDX_fbbd75d84ab6cc2aafeaf37a03"`)
await db.query(`DROP INDEX "public"."IDX_cebe39c6f75881fb55dbe13741"`)
await db.query(`DROP INDEX "public"."IDX_ee64fbb3478fcf66c0098609df"`)
await db.query(`DROP TABLE "change_owner_key"`)
await db.query(`DROP INDEX "public"."IDX_af577baa612d86d98a1ae58343"`)
await db.query(`DROP INDEX "public"."IDX_e09547f07faef3256f7f0381e9"`)
@@ -151,6 +150,7 @@ module.exports = class Data1707320532523 {
await db.query(`DROP INDEX "public"."IDX_bafa9e6c71c3f69cef6602a809"`)
await db.query(`DROP INDEX "public"."IDX_883ba5be237fba47f2a2f39145"`)
await db.query(`DROP INDEX "public"."IDX_ee232f862b258f533e70bbb24d"`)
await db.query(`DROP INDEX "public"."IDX_666fdfaf3a12c96e95ab0a0b31"`)
await db.query(`DROP TABLE "account"`)
await db.query(`DROP INDEX "public"."IDX_73d14d249a6dcf9abe42eaa657"`)
await db.query(`ALTER TABLE "event" DROP CONSTRAINT "FK_2b0d35d675c4f99751855c45021"`)
@@ -163,9 +163,8 @@ module.exports = class Data1707320532523 {
await db.query(`ALTER TABLE "extrinsic" DROP CONSTRAINT "FK_824d47cc4b2cda726405aa507ca"`)
await db.query(`ALTER TABLE "transfer" DROP CONSTRAINT "FK_76bdfed1a7eb27c6d8ecbb73496"`)
await db.query(`ALTER TABLE "transfer" DROP CONSTRAINT "FK_0751309c66e97eac9ef11493623"`)
await db.query(`ALTER TABLE "cert_creation" DROP CONSTRAINT "FK_6d1fc166dc4bd9394775c3603a6"`)
await db.query(`ALTER TABLE "cert_renewal" DROP CONSTRAINT "FK_f1596a2147377881d3bd73dc182"`)
await db.query(`ALTER TABLE "cert_removal" DROP CONSTRAINT "FK_2efb6397676a3b82bde7631ed03"`)
await db.query(`ALTER TABLE "cert_event" DROP CONSTRAINT "FK_d2bc74ffa9c2571da03670f2c8e"`)
await db.query(`ALTER TABLE "cert_event" DROP CONSTRAINT "FK_411c2bb1469a8a96762ceb00ae6"`)
await db.query(`ALTER TABLE "cert" DROP CONSTRAINT "FK_70592e488b2e75cd8a2fa798261"`)
await db.query(`ALTER TABLE "cert" DROP CONSTRAINT "FK_262e29ab91c8ebc727cc518f2fb"`)
await db.query(`ALTER TABLE "smith_cert" DROP CONSTRAINT "FK_ae67cbd087fcea0e1ec2f70cd04"`)
@@ -176,6 +175,7 @@ module.exports = class Data1707320532523 {
await db.query(`ALTER TABLE "change_owner_key" DROP CONSTRAINT "FK_e09547f07faef3256f7f0381e9d"`)
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 "identity" DROP CONSTRAINT "FK_666fdfaf3a12c96e95ab0a0b31c"`)
await db.query(`ALTER TABLE "account" DROP CONSTRAINT "FK_73d14d249a6dcf9abe42eaa6573"`)
}
}