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

-- Table: beers
CREATE TABLE "bird__craftbeer"."beers" (
    "id" BIGINT NOT NULL,
    "brewery_id" BIGINT NOT NULL,
    "abv" DOUBLE PRECISION,
    "ibu" DOUBLE PRECISION,
    "name" TEXT NOT NULL,
    "style" TEXT,
    "ounces" DOUBLE PRECISION NOT NULL,
    CONSTRAINT "beers_pkey" PRIMARY KEY ("id")
);

-- Table: breweries
CREATE TABLE "bird__craftbeer"."breweries" (
    "id" BIGINT NOT NULL,
    "name" TEXT,
    "city" TEXT,
    "state" TEXT,
    CONSTRAINT "breweries_pkey" PRIMARY KEY ("id")
);

-- Indexes
CREATE INDEX "brewery_id" ON "bird__craftbeer"."beers" ("brewery_id");
