db.sql

CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
    "MigrationId" character varying(150) NOT NULL,
    "ProductVersion" character varying(32) NOT NULL,
    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
);

START TRANSACTION;

CREATE TABLE "Tours" (
    "Id" uuid NOT NULL,
    "Name" character varying(200) NOT NULL,
    "Description" character varying(500) NOT NULL,
    "From" character varying(100) NOT NULL,
    "To" character varying(100) NOT NULL,
    "ImagePath" character varying(10000),
    "RouteInformation" character varying(30000),
    "Distance" numeric(18,2),
    "EstimatedTime" double precision,
    "TransportType" character varying(50) NOT NULL,
    CONSTRAINT "PK_Tours" PRIMARY KEY ("Id")
);

CREATE TABLE "TourLogs" (
    "Id" uuid NOT NULL,
    "DateTime" timestamp with time zone NOT NULL,
    "Comment" character varying(500) NOT NULL,
    "Difficulty" double precision,
    "TotalDistance" numeric(18,2),
    "TotalTime" double precision,
    "Rating" double precision,
    "TourPersistenceId" uuid NOT NULL,
    CONSTRAINT "PK_TourLogs" PRIMARY KEY ("Id"),
    CONSTRAINT "FK_TourLogs_Tours_TourPersistenceId" FOREIGN KEY ("TourPersistenceId") REFERENCES "Tours" ("Id") ON DELETE CASCADE
);

CREATE INDEX "IX_TourLogs_TourPersistenceId" ON "TourLogs" ("TourPersistenceId");

INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
VALUES ('20240628212405_Initial', '8.0.5');

COMMIT;