Scripts » statistics script.sql
| 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 |
);
|