CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    nickname VARCHAR(50) NOT NULL,
    password VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    account_creationDate DATE,
    language VARCHAR(3)
);

CREATE TABLE routines (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(15),
    exercises VARCHAR(1000),
    series VARCHAR(1000),
    repeticiones VARCHAR(1000),
    type VARCHAR(1000),
    diaAsignado INT
);

CREATE TABLE exercisesWeights (
    id INT AUTO_INCREMENT PRIMARY KEY,
    idExercise INT,
    idUser INT,
    weight DECIMAL(5,2)
);

CREATE TABLE calendarChecks (
    id INT AUTO_INCREMENT PRIMARY KEY,
    date DATE,
    idUser INT,
    log VARCHAR(1000)
);
