Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 12:28 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `poll_log` PROCEDURE ANALYSE();
Rows: 7
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.poll_log.log_id | 1 | 2 | 1 | 1 | 0 | 0 | 1.5000 | 0.5000 | ENUM('1','2') NOT NULL |
puroparty.poll_log.poll_id | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.poll_log.option_id | 1 | 1 | 1 | 1 | 0 | 0 | 1.0000 | 0.0000 | ENUM('1') NOT NULL |
puroparty.poll_log.timestamp | 1219379155 | 1219385419 | 10 | 10 | 0 | 0 | 1219382287.0000 | 3131.9974 | ENUM('1219379155','1219385419') NOT NULL |
puroparty.poll_log.ip_addr | 99.148.247.245 | 99.148.247.245 | 14 | 14 | 0 | 0 | 14.0000 | NULL | ENUM('99.148.247.245') NOT NULL |
puroparty.poll_log.host | adsl-99-148-247-245.dsl.hstntx.sbcglobal.net | adsl-99-148-247-245.dsl.hstntx.sbcglobal.net | 44 | 44 | 0 | 0 | 44.0000 | NULL | ENUM('adsl-99-148-247-245.dsl.hstntx.sbcglobal.net') NOT NULL |
puroparty.poll_log.agent | Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648) | Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648) | 136 | 136 | 0 | 0 | 136.0000 | NULL | ENUM('Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648)') NOT NULL |