-- Allows administrators to create named Masonic Orders with their own
-- salutations and rank lists. Run once on an existing installation.

CREATE TABLE custom_orders (
  order_key VARCHAR(40) PRIMARY KEY,
  order_name VARCHAR(150) NOT NULL,
  member_noun VARCHAR(50) NOT NULL DEFAULT 'Member',
  salutations TEXT NULL,
  active TINYINT(1) NOT NULL DEFAULT 1,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY uq_custom_order_name (order_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;