Projet

Général

Profil

Scripts » statistics script.sql

Issam Abdelhafidh, 29/11/2023 15:59

 
1
CREATE TABLE IF NOT EXISTS statistics (
2
    id INT AUTO_INCREMENT PRIMARY KEY,
3
    typeId VARCHAR(255) NOT NULL,
4
    type ENUM('visitor', 'learningBlocksLikes', 'learningBlocksViews', 'circularChallengesLikes', 'circularChallengesViews') DEFAULT 'visitor',
5
    date DATE NOT NULL,
6
    count INT NOT NULL
7
);
(9-9/12)