AstroCom-API/migrations/005_gen_dailyAnalytics_table.sql

6 lines
181 B
SQL

CREATE TABLE IF NOT EXISTS dailyAnalytics (
id INTEGER PRIMARY KEY AUTO_INCREMENT,
tag VARCHAR(255) NOT NULL,
count INTEGER NOT NULL DEFAULT 0,
tag_date VARCHAR(255) NOT NULL
);