-- tally.sql: create submissions table
CREATE TABLE `tally_submissions` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `member_id` VARCHAR(100) NOT NULL,
  `inventory_item` VARCHAR(255) NOT NULL,
  `quantity` INT NOT NULL,
  `denomination` DECIMAL(20,2) NOT NULL,
  `total_value` DECIMAL(20,2) NOT NULL,
  `submitted_at` DATETIME NOT NULL,
  INDEX (`member_id`),
  INDEX (`submitted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;