Changeset 41 for trunk/SQL

Timestamp:

Sep 14, 2020, 12:22:36 PM (4 years ago)

Author:

chronos

Message:

• Modified: Translate prefix multipliers.
• Modified: Improve length, duration and speed calculation in detailed and daily tables.
• Added: Allow to define lap length na money per Km for each year.

File:

• trunk/SQL/Upgrade.txt (modified) (1 diff)

trunk/SQL/Upgrade.txt

@@ -15 +15 @@
   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');