schema.sql

-- =============================================================
-- Section 5 — Modifying Data
-- =============================================================
-- A small e-commerce `product` table you'll UPDATE and DELETE
-- against. Different domain from the previous sections so you
-- see schema variety.
-- =============================================================

DROP SCHEMA IF EXISTS sqlf_modifying CASCADE;
CREATE SCHEMA sqlf_modifying;
SET search_path TO sqlf_modifying;

CREATE TABLE product (
    id            INTEGER,
    name          VARCHAR(100)   NOT NULL,
    category      VARCHAR(50)    NOT NULL,
    price         NUMERIC(10, 2) NOT NULL,
    stock         INTEGER        NOT NULL,
    is_active     BOOLEAN        NOT NULL,
    last_restocked DATE
);