Guest User

Untitled

a guest
Apr 22nd, 2018
200
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.10 KB | None | 0 0
  1. Database changed
  2. mysql> describe testing2;
  3. +-------------+-------------+------+-----+---------------------+----------------+
  4. | Field | Type | Null | Key | Default | Extra |
  5. +-------------+-------------+------+-----+---------------------+----------------+
  6. | id | int(8) | NO | PRI | NULL | auto_increment |
  7. | phone | varchar(15) | YES | MUL | NULL | |
  8. | title | varchar(5) | YES | | NULL | |
  9. | name | varchar(40) | YES | | NULL | |
  10. | address | varchar(40) | YES | | NULL | |
  11. | city | varchar(20) | YES | | NULL | |
  12. | state | varchar(15) | YES | | NULL | |
  13. | zip | varchar(10) | YES | | NULL | |
  14. | oc | varchar(40) | YES | | NULL | |
  15. | paidamt | varchar(10) | YES | | NULL | |
  16. | paiddate | varchar(10) | YES | | NULL | |
  17. | comments | varchar(60) | YES | | NULL | |
  18. | countynum | varchar(5) | YES | | NULL | |
  19. | tzl | int(8) | YES | | NULL | |
  20. | tzh | int(8) | YES | | NULL | |
  21. | attempts | int(8) | YES | MUL | NULL | |
  22. | pickups | int(8) | YES | MUL | NULL | |
  23. | abandons | int(8) | YES | | NULL | |
  24. | disposition | int(8) | YES | MUL | NULL | |
  25. | agent | varchar(10) | YES | | NULL | |
  26. | closerdispo | int(8) | YES | | NULL | |
  27. | closer | varchar(10) | YES | | NULL | |
  28. | subdispo | varchar(10) | YES | | | |
  29. | lastupdated | timestamp | NO | | 0000-00-00 00:00:00 | |
  30. | cb_datetime | timestamp | NO | | 0000-00-00 00:00:00 | |
  31. | wdayl | int(8) | YES | | NULL | |
  32. | wdayh | int(8) | YES | | NULL | |
  33. | satl | int(8) | YES | | NULL | |
  34. | sath | int(8) | YES | | NULL | |
  35. | sunl | int(8) | YES | | NULL | |
  36. | sunh | int(8) | YES | | NULL | |
  37. | holl | int(8) | YES | | NULL | |
  38. | holh | int(8) | YES | | NULL | |
  39. +-------------+-------------+------+-----+---------------------+----------------+
  40. 33 rows in set (0.00 sec)
Add Comment
Please, Sign In to add comment