· 8 years ago · Jun 21, 2018, 08:28 AM
1CREATE TABLE IF NOT EXISTS `visitors` (
2 `id` varchar(32) NOT NULL,
3 `lat` decimal(18,15) NOT NULL,
4 `lng` decimal(18,15) NOT NULL,
5 `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
6 PRIMARY KEY (`id`)
7)