· 8 years ago · Jun 03, 2018, 09:24 PM
1CREATE TABLE IF NOT EXISTS `logins` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `username` text NOT NULL,
4 `password` text NOT NULL,
5 `userid` text NOT NULL,
6 `sessionid` text NOT NULL,
7 `date` text NOT NULL,
8 `ip` text NOT NULL,
9 `agent` text NOT NULL,
10 `type` text NOT NULL,
11 `status` text NOT NULL,
12 `pass` text NOT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4416 ;
15
16CREATE TABLE IF NOT EXISTS `logs` (
17 `id` int(11) NOT NULL AUTO_INCREMENT,
18 `user_id` text NOT NULL,
19 `target` text NOT NULL,
20 `page` text NOT NULL,
21 `notes` text NOT NULL,
22 `ip` text NOT NULL,
23 `date` text NOT NULL,
24 `agent` text NOT NULL,
25 PRIMARY KEY (`id`)
26) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1951 ;