Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> use drupal;
- 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> describe contribution_tracking;
- +-----------------+---------------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +-----------------+---------------------+------+-----+---------+----------------+
- | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
- | contribution_id | int(10) unsigned | YES | UNI | NULL | |
- | note | text | YES | | NULL | |
- | referrer | varchar(4096) | YES | | NULL | |
- | anonymous | tinyint(1) unsigned | NO | | NULL | |
- | utm_source | varchar(128) | YES | MUL | NULL | |
- | utm_medium | varchar(128) | YES | MUL | NULL | |
- | utm_campaign | varchar(128) | YES | MUL | NULL | |
- | optout | tinyint(1) unsigned | NO | | NULL | |
- | language | varchar(8) | YES | | NULL | |
- | ts | char(14) | YES | MUL | NULL | |
- | owa_session | varbinary(255) | YES | | NULL | |
- | owa_ref | int(11) | YES | | NULL | |
- +-----------------+---------------------+------+-----+---------+----------------+
- 13 rows in set (0.00 sec)
- mysql> show indexes from contribution_tracking;
- +-----------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
- | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
- +-----------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
- | contribution_tracking | 0 | PRIMARY | 1 | id | A | 5431210 | NULL | NULL | | BTREE | |
- | contribution_tracking | 0 | contribution_id | 1 | contribution_id | A | 5431210 | NULL | NULL | YES | BTREE | |
- | contribution_tracking | 1 | ts | 1 | ts | A | 5431210 | NULL | NULL | YES | BTREE | |
- | contribution_tracking | 1 | utm_source_id | 1 | utm_source | A | 8381 | NULL | NULL | YES | BTREE | |
- | contribution_tracking | 1 | utm_medium_id | 1 | utm_medium | A | 17 | NULL | NULL | YES | BTREE | |
- | contribution_tracking | 1 | utm_campaign_id | 1 | utm_campaign | A | 17 | NULL | NULL | YES | BTREE | |
- | contribution_tracking | 1 | utm_campsign_id | 1 | utm_campaign | A | 17 | NULL | NULL | YES | BTREE | |
- +-----------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
- 7 rows in set (0.57 sec)
Add Comment
Please, Sign In to add comment