kalskeborec.cz

// Registrace
// Pridan timestamp registrace. Vic let, vic ruznych ucastniku, doh!
// Chip ID a ID by se nejak dalo spojit?
// je potreba expandovat timestamps na okruhy
  - tstamp start (pevny cas, e.g. 9:00)
  - tstamp prvni okruh (u samostatnych okruhu je tohle jediny)
  - tstamp start druhy okruh (user samostatne pipne). Diff => depo 1
  - tstamp finish druhy okruh
  - tstamp start treti okruh. Zas Diff = depo 2
  - tstamp finish treti okruh (finish cile)

DB
-----------------FIELD-|-TYPE----------------------------|-METHOD--------------
Cas registrace, tstamp | INT                             | AUTO
ID                     | INT                             | AUTO
chip_ID                | INT (HEX)                       | MANUAL
Jmeno                  | VARCHAR(50)                     | MANUAL
Prijmeni               | VARCHAR(50)                     | MANUAL
Email                  | VARCHAR(50)                     | MANUAL
Telefon                | VARCHAR(15)                     | MANUAL
Nick                   | VARCHAR(20)                     | MANUAL
Zavod                  | INT                             | MANUAL (dropdown)
Cas                    | ?                               | ADMIN
t_start                | INT                             | MANUAL
t_lap1                 | INT                             | AUTO -> ESP32?
t_start2               | INT                             | AUTO -> ESP32
t_lap2                 | INT                             | AUTO -> ESP32
t_start3               | INT                             | AUTO -> ESP32
t_lap3                 | INT                             | AUTO -> ESP32
Tracklog               | TEXT / BASE64ENC? / url saved   | LATER DATE
EMAIL_CHECK            | TEXT                            | AUTO (check against link in email)
CONFIRMED              | BOOL                            | AUTO at time of confirm above
PAID                   | BOOL                            | AUTO / ADMIN

ZAVODY (s odkazem na budoucnost jsou separe)
-------------------------------------------
ID         | INT
NAZEV      | VARCHAR(20)
DELKA      | INT
PREVYSENI  | INT
ROCNIK     | INT

// Reg flow
-------------------------------------------------------------------------------
Web popup
  -> vyplneni registracnich udaju
  -> vygenerovani linku pro overeni stavu (MD5 z jmena + mailu) + QR kod pro platbu
    - string se tvori z 'Nicku + emailu' ale vesmes muzem generovat cokoliv nahodne
  -> zaslani emailu s informacema
  -> kazdy registrovany si muze overit stav skrz MD5 link (delal se jen z mailu, ale)
  -> admin rozhrani pro editaci udaju? Phpmyadmin to natvrdo zvlada tez

check payment (cron?) -> manualne, API pro banku je psycho


Puvodni tabulky
---------------------------------------------------------------
CREATE TABLE `RACES` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(20) NOT NULL,
  `LENGTH` int(11) NOT NULL,
  `CLIMB` int(11) NOT NULL,
  `YEAR` int(11) NOT NULL,
  `GPX` text NOT NULL,
  `LINK` varchar(100) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci

CREATE TABLE `REGISTERED` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(50) NOT NULL,
  `SURNAME` varchar(50) NOT NULL,
  `EMAIL` varchar(50) NOT NULL,
  `PHONE` varchar(15) NOT NULL,
  `NICK` varchar(20) NOT NULL,
  `RACE` int(11) NOT NULL,
  `TIME` time NOT NULL,
  `TRACKLOG` mediumtext NOT NULL,
  `EMAIL_CHECK` text NOT NULL,
  `CONFIRMED` tinyint(1) NOT NULL,
  `PAID` tinyint(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci