log.txt

> url-shortner-nest@0.0.1 migration:run
> npm run typeorm migration:run -- -d ./src/config/typeorm.ts


> url-shortner-nest@0.0.1 typeorm
> ts-node ./node_modules/typeorm/cli migration:run -d ./src/config/typeorm.ts

query: SELECT * FROM current_schema()
query: SELECT version();
query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'public' AND "table_name" = 'migrations'
query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
0 migrations are already loaded in the database.
2 migrations were found in the source code.
2 migrations are new migrations must be executed.
query: START TRANSACTION
query: CREATE TABLE "auth_entity" ("id" SERIAL NOT NULL, "name" character varying NOT NULL, "username" character varying NOT NULL, "password" character varying NOT NULL, "createAt" TIMESTAMP NOT NULL DEFAULT now(), "updateAt" TIMESTAMP NOT NULL DEFAULT now(), CONSTRAINT "UQ_57db63611b67e91ee24e71cfde2" UNIQUE ("username"), CONSTRAINT "PK_d3d458da474344a6982aec36b5b" PRIMARY KEY ("id"))
query: CREATE TABLE "analytics_entity" ("id" SERIAL NOT NULL, "clickedAtTimeStamp" TIMESTAMP NOT NULL, "userAgent" text NOT NULL, "referralSource" text NOT NULL, "createdAt" TIMESTAMP NOT NULL DEFAULT now(), "urlId" integer, CONSTRAINT "PK_8bdebe7e29915e204f0015f6094" PRIMARY KEY ("id"))
query: CREATE TABLE "url_entity" ("id" SERIAL NOT NULL, "longUrl" text NOT NULL, "shortUrl" text NOT NULL, "createAt" TIMESTAMP NOT NULL DEFAULT now(), "expiresAt" TIMESTAMP NOT NULL, "userId" integer, CONSTRAINT "PK_0ec3eb469ff2aed091ff9b2545e" PRIMARY KEY ("id"))
query: ALTER TABLE "analytics_entity" ADD CONSTRAINT "FK_62bf9eb6b0e4db3838da321b827" FOREIGN KEY ("urlId") REFERENCES "url_entity"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
query: ALTER TABLE "url_entity" ADD CONSTRAINT "FK_a07f9a4be25fdb0a2a43a63d3cf" FOREIGN KEY ("userId") REFERENCES "auth_entity"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
query: INSERT INTO "migrations"("timestamp", "name") VALUES ($1, $2) -- PARAMETERS: [1710658342107,"Migrations1710658342107"]
Migration Migrations1710658342107 has been  executed successfully.
query: ALTER TABLE "url_entity" RENAME COLUMN "createAt" TO "createdAt"
query: ALTER TABLE "auth_entity" DROP COLUMN "createAt"
query: ALTER TABLE "auth_entity" DROP COLUMN "updateAt"
query: ALTER TABLE "auth_entity" ADD "createdAt" TIMESTAMP NOT NULL DEFAULT now()
query: ALTER TABLE "auth_entity" ADD "updatedAt" TIMESTAMP NOT NULL DEFAULT now()
query: INSERT INTO "migrations"("timestamp", "name") VALUES ($1, $2) -- PARAMETERS: [1710775141011,"Migrations1710775141011"]
Migration Migrations1710775141011 has been  executed successfully.
query: COMMIT
\\