referrer table
Fields
Schema summary
DESCRIBE referrer;
6.0
+---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | referrer_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | page_id | int(10) unsigned | NO | MUL | 0 | | | referrer | varchar(2083) | NO | | NULL | | | referrer_time | datetime | YES | MUL | NULL | | | ip | varchar(45) | NO | | NULL | | | user_agent | varchar(150) | NO | | NULL | | +---------------+------------------+------+-----+---------+----------------+
Indices
SHOW INDEX IN referrer;
+----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | wacko_referrer | 0 | PRIMARY | 1 | referrer_id | A | 0 | NULL | NULL | | BTREE | | | | wacko_referrer | 1 | idx_page_id | 1 | page_id | A | 0 | NULL | NULL | | BTREE | | | | wacko_referrer | 1 | idx_referrer_time | 1 | referrer_time | A | 0 | NULL | NULL | YES | BTREE | | | +----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+