

	,      
	----------------------------------------------


root@linux:~> mysql -u webmaster -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2554 to server version: 3.23.52-Max-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use webcount;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> explain counters;
+-----------------+------------------+------+-----+---------+-------+
| Field           | Type             | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------+-------+
| counter_id      | int(10) unsigned |      |     | 0       |       |
| ip_info         | varchar(255)     | YES  |     | NULL    |       |
| date            | datetime         | YES  |     | NULL    |       |
| p1remotehost    | varchar(255)     | YES  |     | NULL    |       |
| p1httpuseragent | varchar(255)     | YES  |     | NULL    |       |
| p1httprefer     | varchar(255)     | YES  |     | NULL    |       |
| p1language      | varchar(255)     | YES  |     | NULL    |       |
| p1httpxforward  | varchar(255)     | YES  |     | NULL    |       |
| p1httpvia       | varchar(255)     | YES  |     | NULL    |       |
| forw2dns        | varchar(255)     | YES  |     | NULL    |       |
| namecountry     | varchar(100)     | YES  |     | NULL    |       |
+-----------------+------------------+------+-----+---------+-------+
11 rows in set (0.00 sec)

mysql> explain counters_value;
+------------+---------------------+------+-----+---------+-------+
| Field      | Type                | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+-------+
| counter_id | int(10) unsigned    |      | PRI | 0       |       |
| value      | bigint(20) unsigned |      |     | 0       |       |
+------------+---------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> explain country_info;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| ip_from       | double      | YES  |     | NULL    |       |
| ip_to         | double      | YES  |     | NULL    |       |
| country_code2 | char(2)     | YES  |     | NULL    |       |
| country_code3 | char(3)     | YES  |     | NULL    |       |
| country_name  | varchar(50) | YES  |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)



   country_info     
  http://ip-to-country.directi.com/

:   ,   ODBC (Mysql ODBC driver 3.51)
   win2000, .. Mysql ODBC driver 3.51   
Windows 2003 Server.   Access.
 Linux-     3306.
