Guest User

Untitled

a guest
Oct 21st, 2017
399
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.50 KB | None | 0 0
  1. mysql> use drupal;
  2. Reading table information for completion of table and column names
  3. You can turn off this feature to get a quicker startup with -A
  4.  
  5. Database changed
  6. mysql> describe contribution_tracking;
  7. +-----------------+---------------------+------+-----+---------+----------------+
  8. | Field | Type | Null | Key | Default | Extra |
  9. +-----------------+---------------------+------+-----+---------+----------------+
  10. | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
  11. | contribution_id | int(10) unsigned | YES | UNI | NULL | |
  12. | note | text | YES | | NULL | |
  13. | referrer | varchar(4096) | YES | | NULL | |
  14. | anonymous | tinyint(1) unsigned | NO | | NULL | |
  15. | utm_source | varchar(128) | YES | MUL | NULL | |
  16. | utm_medium | varchar(128) | YES | MUL | NULL | |
  17. | utm_campaign | varchar(128) | YES | MUL | NULL | |
  18. | optout | tinyint(1) unsigned | NO | | NULL | |
  19. | language | varchar(8) | YES | | NULL | |
  20. | ts | char(14) | YES | MUL | NULL | |
  21. | owa_session | varbinary(255) | YES | | NULL | |
  22. | owa_ref | int(11) | YES | | NULL | |
  23. +-----------------+---------------------+------+-----+---------+----------------+
  24. 13 rows in set (0.00 sec)
  25.  
  26. mysql> show indexes from contribution_tracking;
  27. +-----------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
  28. | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
  29. +-----------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
  30. | contribution_tracking | 0 | PRIMARY | 1 | id | A | 5431210 | NULL | NULL | | BTREE | |
  31. | contribution_tracking | 0 | contribution_id | 1 | contribution_id | A | 5431210 | NULL | NULL | YES | BTREE | |
  32. | contribution_tracking | 1 | ts | 1 | ts | A | 5431210 | NULL | NULL | YES | BTREE | |
  33. | contribution_tracking | 1 | utm_source_id | 1 | utm_source | A | 8381 | NULL | NULL | YES | BTREE | |
  34. | contribution_tracking | 1 | utm_medium_id | 1 | utm_medium | A | 17 | NULL | NULL | YES | BTREE | |
  35. | contribution_tracking | 1 | utm_campaign_id | 1 | utm_campaign | A | 17 | NULL | NULL | YES | BTREE | |
  36. | contribution_tracking | 1 | utm_campsign_id | 1 | utm_campaign | A | 17 | NULL | NULL | YES | BTREE | |
  37. +-----------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+
  38. 7 rows in set (0.57 sec)
Add Comment
Please, Sign In to add comment