· 8 years ago · Jul 28, 2018, 06:02 PM
1CREATE TABLE IF NOT EXISTS dle_glc_check (ip varchar(40) NOT NULL, click_button_date datetime NOT NULL, UNIQUE KEY `ip` (`ip`))
2CREATE TABLE IF NOT EXISTS dle_glc_stats ( id int(11) NOT NULL AUTO_INCREMENT, date date NOT NULL, time time NOT NULL, ip varchar(40) NOT NULL, lang varchar(2) NOT NULL, useragent varchar(500) NOT NULL, refer varchar(255) NOT NULL, PRIMARY KEY (id), KEY `ip` (`ip`), KEY `date` (`date`))
3CREATE TABLE IF NOT EXISTS dle_glc_suspects ( id int(11) NOT NULL AUTO_INCREMENT, spent_time int(5) NOT NULL, date date NOT NULL, time time NOT NULL, ip varchar(40) NOT NULL, lang varchar(2) NOT NULL, useragent varchar(500) NOT NULL, refer varchar(255) NOT NULL, PRIMARY KEY (id), KEY `ip` (`ip`), KEY `date` (`date`))