· 7 years ago · Nov 22, 2018, 09:00 AM
1CREATE TABLE IF NOT EXISTS blog (
2 id INT(11) NOT NULL AUTO_INCREMENT,
3 title VARCHAR(4096) COLLATE utf8_unicode_ci NOT NULL,
4 author INT(11) NOT NULL,
5 is_deleted TINYINT(1) NOT NULL,
6 time_created DATETIME(6) NOT NULL,
7 PRIMARY KEY (id),
8 UNIQUE KEY title (title),
9 CONSTRAINT author_id_key FOREIGN KEY (author) REFERENCES users (id)
10) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;