stau.space / aecc-db
AECC database project.
fork atom
aecc-db / lib / sql / activity.sql
at master 253 B view raw
1CREATE TABLE IF NOT EXISTS activity ( 2 a_id INT NOT NULL AUTO_INCREMENT, 3 title VARCHAR(80) NOT NULL, 4 description VARCHAR(80) NOT NULL, 5 date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 6 7 PRIMARY KEY (a_id), 8 FULLTEXT (title, description) 9);