-- Schema: bird__music_tracker
CREATE SCHEMA IF NOT EXISTS "bird__music_tracker";

-- Table: tags
CREATE TABLE "bird__music_tracker"."tags" (
    "index" BIGINT NOT NULL,
    "id" BIGINT,
    "tag" TEXT,
    CONSTRAINT "tags_pk" PRIMARY KEY ("index")
);

-- Table: torrents
CREATE TABLE "bird__music_tracker"."torrents" (
    "groupName" TEXT,
    "totalSnatched" BIGINT,
    "artist" TEXT,
    "groupYear" BIGINT,
    "releaseType" TEXT,
    "groupId" BIGINT,
    "id" BIGINT NOT NULL,
    CONSTRAINT "torrents_pk" PRIMARY KEY ("id")
);

-- Indexes
CREATE INDEX "ix_tags_index" ON "bird__music_tracker"."tags" ("index");
