· 7 years ago · Nov 19, 2018, 09:52 AM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8
9--
10-- База данных: `test`
11--
12
13-- --------------------------------------------------------
14
15--
16-- Структура таблицы `myiplog`
17--
18
19CREATE TABLE IF NOT EXISTS `myiplog` (
20 `id` int(11) NOT NULL AUTO_INCREMENT,
21 `user_login` varchar(100) DEFAULT NULL,
22 `ip` tinytext,
23 `date` varchar(500) DEFAULT NULL,
24 `user_agent` varchar(500) DEFAULT NULL,
25 PRIMARY KEY (`id`)
26) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=358 ;
27
28--
29-- Дамп данных таблицы `myiplog`
30--
31
32INSERT INTO `myiplog` (`id`, `user_login`, `ip`, `date`, `user_agent`) VALUES
33(1, '1', '127.0.0.1', '26.07.12 21:02:36', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.57 Safari/536.11'),
34(2, '1', '127.0.0.1', '26.07.12 21:02:46', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.57 Safari/536.11'),
35(3, '1', '127.0.0.1', '26.07.12 21:23:23', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.57 Safari/536.11'),
36(4, '1', '127.0.0.1', '27.07.12 01:02:49', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.57 Safari/536.11'),
37(5, '1', '127.0.0.1', '27.07.12 01:29:47', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.57 Safari/536.11'),
38(6, '1', '127.0.0.1', '27.07.12 02:18:55', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.57 Safari/536.11'),
39(7, '1', '127.0.0.1', '27.07.12 02:35:37', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.57 Safari/536.11'),
40(8, '1', '127.0.0.1', '27.07.12 03:02:03', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.57 Safari/536.11'),
41(9, '1', '127.0.0.1', '27.07.12 09:18:38', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.57 Safari/536.11'),
42INSERT INTO `myiplog` (`id`, `user_login`, `ip`, `date`, `user_agent`) VALUES
43(338, '1', '127.0.0.1', '09.09.12 20:17:58', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1'),
44(339, '1', '127.0.0.1', '09.09.12 21:48:53', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1'),
45(340, '1', '127.0.0.1', '09.09.12 22:44:19', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1'),
46(341, '1', '127.0.0.1', '09.09.12 23:23:16', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1'),
47(342, '3', '127.0.0.1', '09.09.12 23:24:07', 'Mozilla/5.0 (Windows NT 6.1; rv:11.0) Gecko/20100101 Firefox/11.0'),