Every hard part of a migration, generated and verifiable.

CREATE TABLE orders (
  id            BIGINT AUTO_INCREMENT PRIMARY KEY,
  customer_id   BIGINT NOT NULL,
  status        ENUM('open','paid','shipped','void')
                  NOT NULL DEFAULT 'open',
  total_cents   INT UNSIGNED NOT NULL,
  metadata      JSON,
  is_gift       TINYINT(1) NOT NULL DEFAULT 0,
  placed_at     DATETIME NOT NULL
                  DEFAULT CURRENT_TIMESTAMP,
  KEY idx_cust  (customer_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TYPE order_status AS ENUM
  ('open','paid','shipped','void');

CREATE TABLE orders (
  id            BIGINT GENERATED ALWAYS AS IDENTITY
                  PRIMARY KEY,
  customer_id   BIGINT NOT NULL
                  REFERENCES customers (id),
  status        order_status NOT NULL DEFAULT 'open',
  total_cents   BIGINT NOT NULL CHECK (total_cents >= 0),
  metadata      JSONB,
  is_gift       BOOLEAN NOT NULL DEFAULT false,
  placed_at     TIMESTAMPTZ NOT NULL DEFAULT now()
);

CREATE INDEX idx_orders_cust ON orders (customer_id);