Draft: remove useless event field to udHistory and forgotten logs

Close #12 (closed)

Le champs event n'est plus nécessaire étant donné qu'on défini le timestamp en champ root. Il s'avère que la récupération de l'event augmente significativement le temps de réponse du serveur:

• Avec le champ event pour udHistory (~440ms):

• Sans le champ event pour udHistory (~350ms):

Soit environ 20% de temps de réaction en plus avec le champ event (à la louche il faudrait tester sur un bien plus grand nombre d'itération).

db/migrations/1708131095244-Data.js

-module.exports = class Data1707778036778 {
-    name = 'Data1707778036778'
+module.exports = class Data1708131095244 {
+    name = 'Data1708131095244'
 
     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"))`)
@@ -56,9 +56,8 @@ module.exports = class Data1707778036778 {
         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 "ud_history" ("id" character varying NOT NULL, "amount" integer NOT NULL, "block_number" integer NOT NULL, "timestamp" TIMESTAMP WITH TIME ZONE NOT NULL, "identity_id" character varying, "event_id" character varying, CONSTRAINT "PK_29dc558594261d7b2845876b6e1" PRIMARY KEY ("id"))`)
+        await db.query(`CREATE TABLE "ud_history" ("id" character varying NOT NULL, "amount" integer NOT NULL, "block_number" integer NOT NULL, "timestamp" TIMESTAMP WITH TIME ZONE NOT NULL, "identity_id" character varying, CONSTRAINT "PK_29dc558594261d7b2845876b6e1" PRIMARY KEY ("id"))`)
         await db.query(`CREATE INDEX "IDX_a481d5b96ba0e6d8237dc733a3" ON "ud_history" ("identity_id") `)
-        await db.query(`CREATE INDEX "IDX_1d3d855a004682536eeed8797a" ON "ud_history" ("event_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") `)
@@ -93,7 +92,6 @@ module.exports = class Data1707778036778 {
         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 "ud_history" ADD CONSTRAINT "FK_a481d5b96ba0e6d8237dc733a31" FOREIGN KEY ("identity_id") REFERENCES "identity"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`)
-        await db.query(`ALTER TABLE "ud_history" ADD CONSTRAINT "FK_1d3d855a004682536eeed8797a1" FOREIGN KEY ("event_id") REFERENCES "event"("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`)
@@ -158,7 +156,6 @@ module.exports = class Data1707778036778 {
         await db.query(`DROP INDEX "public"."IDX_9a9f8cdcae54d8b4375d70fe8b"`)
         await db.query(`DROP TABLE "ud_history"`)
         await db.query(`DROP INDEX "public"."IDX_a481d5b96ba0e6d8237dc733a3"`)
-        await db.query(`DROP INDEX "public"."IDX_1d3d855a004682536eeed8797a"`)
         await db.query(`DROP TABLE "identity"`)
         await db.query(`DROP INDEX "public"."IDX_6f883c7979ea8dff46327f67cc"`)
         await db.query(`DROP INDEX "public"."IDX_bafa9e6c71c3f69cef6602a809"`)
@@ -193,7 +190,6 @@ module.exports = class Data1707778036778 {
         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 "ud_history" DROP CONSTRAINT "FK_a481d5b96ba0e6d8237dc733a31"`)
-        await db.query(`ALTER TABLE "ud_history" DROP CONSTRAINT "FK_1d3d855a004682536eeed8797a1"`)
         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"`)