CREATE TABLE IF NOT EXISTS customer_shipping_methods (
  customer_id BIGINT UNSIGNED NOT NULL,
  template_id VARCHAR(80) NOT NULL,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (customer_id, template_id),
  CONSTRAINT fk_customer_shipping_customer
    FOREIGN KEY (customer_id) REFERENCES customers(id) ON DELETE CASCADE
);
