· 7 years ago · Feb 16, 2019, 11:46 PM
1CREATE TABLE IF NOT EXISTS `%s` (\
2 `%s` int(10) unsigned NOT NULL AUTO_INCREMENT, \
3 `%s` varchar(16) NOT NULL, \
4 `%s` smallint(1) unsigned NOT NULL, \
5 `%s` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, \
6 PRIMARY KEY (`%s`), \
7 KEY `%s` (`%s`)\
8 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;