source: trunk/SQL/Upgrade.txt

-- 15

ALTER TABLE `Runner` ADD `Year` INT NOT NULL AFTER `ChipNumber`;
ALTER TABLE `Team` ADD `Year` INT NOT NULL AFTER `IsFamily`;
CREATE TABLE `Import` (
  `Id` int(11) NOT NULL,
  `Time` datetime NOT NULL,
  `Hash` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
  `ItemCount` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

ALTER TABLE `Import` ADD PRIMARY KEY (`Id`);

ALTER TABLE `Import`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

-- 41

CREATE TABLE `Year` (
  `Id` int(11) NOT NULL,
  `Year` int(11) NOT NULL,
  `MoneyKm` int(11) NOT NULL,
  `LapLength` DECIMAL(10,1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `Year` ADD PRIMARY KEY (`Id`);

ALTER TABLE `Year`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

INSERT INTO `Year` (`Id`, `Year`, `MoneyKm`, `LapLength`) VALUES
(1, 2018, 30, '1.5'),
(2, 2019, 30, '1.5'),
(3, 2020, 10, '0.0');

-- 45

ALTER TABLE `Runner` ADD `Hidden` INT NOT NULL DEFAULT '0' AFTER `Year`; 
ALTER TABLE `Team` ADD `Hidden` INT NOT NULL DEFAULT '0' AFTER `Year`;