-- EventShotCalculation: working table for ACL/Ladies Friendlies shot calculations.
-- Used by event-acl-createshots.php (truncated each run).
-- See Plesk/drop-unused-tables.sql: "DO NOT REMOVE"
--
-- Run against the same database as the app (e.g. el_paraiso on dev/prod).

USE `el_paraiso`;

CREATE TABLE IF NOT EXISTS `EventShotCalculation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guest` tinyint(1) DEFAULT 0,
  `UserId` int(11) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `handicap` decimal(5,2) DEFAULT NULL,
  `flight` int(11) DEFAULT NULL,
  `place` int(11) DEFAULT NULL COMMENT 'tee/place',
  `slope` decimal(8,2) DEFAULT NULL,
  `shots` int(11) DEFAULT NULL,
  `comment` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
