Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on May 12th, 2011  |  syntax: PHP  |  size: 34.72 KB  |  views: 27  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1.  
  2. (default) 122 queries took 19 ms
  3. Nr      Query   Error   Affected        Num. rows       Took (ms)
  4. 1       SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 27           1       1       0
  5. 2       SELECT `PlanDetail`.`id`, `PlanDetail`.`created`, `PlanDetail`.`modified`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_detail_note_id`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`benefits_schedule_wysiwyg`, `PlanDetail`.`benefits_description_wysiwyg`, `PlanDetail`.`exclusions_wysiwyg`, `PlanDetail`.`provider_network_url`, `PlanDetail`.`application_url`, `PlanDetail`.`vision_wysiwyg` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`company_id` = (27)           1       1       1
  6. 3       SELECT `Applicant`.`id`, `Applicant`.`company_id`, `Applicant`.`name`, `Applicant`.`amount` FROM `applicants` AS `Applicant` WHERE `Applicant`.`company_id` = (27)              0       0       0
  7. 4       SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 3            1       1       0
  8. 5       SELECT `PlanDetail`.`id`, `PlanDetail`.`created`, `PlanDetail`.`modified`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_detail_note_id`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`benefits_schedule_wysiwyg`, `PlanDetail`.`benefits_description_wysiwyg`, `PlanDetail`.`exclusions_wysiwyg`, `PlanDetail`.`provider_network_url`, `PlanDetail`.`application_url`, `PlanDetail`.`vision_wysiwyg` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`company_id` = (3)            3       3       1
  9. 6       SELECT `Applicant`.`id`, `Applicant`.`company_id`, `Applicant`.`name`, `Applicant`.`amount` FROM `applicants` AS `Applicant` WHERE `Applicant`.`company_id` = (3)               0       0       0
  10. 7       SELECT COUNT(*) AS `count` FROM `plans` AS `Plan` inner JOIN plans_zips AS `PZips` ON (`Plan`.`id` = `PZips`.`plan_id`) inner JOIN zips AS `Zips` ON (`Zips`.`id` = `PZips`.`zip_id`) LEFT JOIN `plan_details` AS `PlanDetail` ON (`Plan`.`plan_detail_id` = `PlanDetail`.`id`) LEFT JOIN `ages` AS `Age` ON (`Plan`.`age_id` = `Age`.`id`) LEFT JOIN `applicants` AS `Applicant` ON (`Plan`.`applicant_id` = `Applicant`.`id`) WHERE ((((18 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (NOT (`PlanDetail`.`company_id` IN (27, 3))))) OR (((22 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (`PlanDetail`.`company_id` = 27))) OR (((22 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (`PlanDetail`.`company_id` = 3))))               1       1       0
  11. 8       SELECT `Plan`.`id`, `Plan`.`created`, `Plan`.`modified`, `Plan`.`plan_detail_id`, `Plan`.`monthly_cost`, `Plan`.`dental_cost`, `Plan`.`age_id`, `Plan`.`applicant_id`, `Plan`.`state_id`, `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id`, `Age`.`id`, `Age`.`name`, `Applicant`.`id`, `Applicant`.`name` FROM `plans` AS `Plan` inner JOIN plans_zips AS `PZips` ON (`Plan`.`id` = `PZips`.`plan_id`) inner JOIN zips AS `Zips` ON (`Zips`.`id` = `PZips`.`zip_id`) LEFT JOIN `plan_details` AS `PlanDetail` ON (`Plan`.`plan_detail_id` = `PlanDetail`.`id`) LEFT JOIN `ages` AS `Age` ON (`Plan`.`age_id` = `Age`.`id`) LEFT JOIN `applicants` AS `Applicant` ON (`Plan`.`applicant_id` = `Applicant`.`id`) WHERE ((((18 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (NOT (`PlanDetail`.`company_id` IN (27, 3))))) OR (((22 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (`PlanDetail`.`company_id` = 27))) OR (((22 BETWEEN `Age`.`Min_Age` AND `Age`.`Max_age`) AND (`Zips`.`title` = '97378') AND (`Applicant`.`amount` IN ('as', '2')) AND (`PlanDetail`.`company_id` = 3)))) ORDER BY `monthly_cost` ASC LIMIT 100             22      22      1
  12. 9       SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 54            1       1       0
  13. 10      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 21           1       1       0
  14. 11      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1           1       1       0
  15. 12      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 88            1       1       0
  16. 13      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 4            1       1       0
  17. 14      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1           1       1       0
  18. 15      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 48            1       1       0
  19. 16      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20           1       1       0
  20. 17      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1           1       1       0
  21. 18      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 42            1       1       0
  22. 19      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20           1       1       0
  23. 20      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  24. 21      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 55            1       1       0
  25. 22      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 21           1       1       0
  26. 23      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1           1       1       0
  27. 24      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 82            1       1       0
  28. 25      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 18           1       1       1
  29. 26      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  30. 27      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 80            1       1       0
  31. 28      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 18           1       1       0
  32. 29      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  33. 30      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 50            1       1       0
  34. 31      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20           1       1       0
  35. 32      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1           1       1       0
  36. 33      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 56            1       1       0
  37. 34      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 21           1       1       0
  38. 35      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1           1       1       0
  39. 36      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 86            1       1       0
  40. 37      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 4            1       1       0
  41. 38      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  42. 39      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 65            1       1       0
  43. 40      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 16           1       1       0
  44. 41      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 4           1       1       0
  45. 42      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 87            1       1       0
  46. 43      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 4            1       1       0
  47. 44      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  48. 45      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 52            1       1       0
  49. 46      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20           1       1       0
  50. 47      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1           1       1       0
  51. 48      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 78            1       1       0
  52. 49      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 18           1       1       0
  53. 50      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  54. 51      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 44            1       1       0
  55. 52      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20           1       1       0
  56. 53      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  57. 54      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 94            1       1       0
  58. 55      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 27           1       1       0
  59. 56      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1           1       1       0
  60. 57      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 84            1       1       0
  61. 58      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 4            1       1       0
  62. 59      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  63. 60      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 85            1       1       0
  64. 61      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 4            1       1       0
  65. 62      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  66. 63      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 46            1       1       0
  67. 64      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 20           1       1       0
  68. 65      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  69. 66      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 61            1       1       0
  70. 67      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 3            1       1       0
  71. 68      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1           1       1       0
  72. 69      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 62            1       1       0
  73. 70      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 3            1       1       0
  74. 71      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 1           1       1       0
  75. 72      SELECT `PlanDetail`.`id`, `PlanDetail`.`effective_date`, `PlanDetail`.`expiration_date`, `PlanDetail`.`active`, `PlanDetail`.`name`, `PlanDetail`.`plan_type_id`, `PlanDetail`.`max_benefit`, `PlanDetail`.`deductible`, `PlanDetail`.`preventive`, `PlanDetail`.`basic`, `PlanDetail`.`major`, `PlanDetail`.`ortho`, `PlanDetail`.`application_url`, `PlanDetail`.`company_id`, `PlanDetail`.`plan_detail_note_id` FROM `plan_details` AS `PlanDetail` WHERE `PlanDetail`.`id` = 60            1       1       0
  76. 73      SELECT `Company`.`id`, `Company`.`name`, `Company`.`company_logo_url` FROM `companies` AS `Company` WHERE `Company`.`id` = 3            1       1       0
  77. 74      SELECT `PlanType`.`id`, `PlanType`.`name`, `PlanType`.`description` FROM `plan_types` AS `PlanType` WHERE `PlanType`.`id` = 2           1       1       0
  78. 75      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  79. 76      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  80. 77      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16              1       1       0
  81. 78      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16              1       1       0
  82. 79      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  83. 80      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  84. 81      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  85. 82      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16              1       1       0
  86. 83      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  87. 84      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  88. 85      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16              1       1       0
  89. 86      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  90. 87      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16              1       1       0
  91. 88      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  92. 89      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16              1       1       0
  93. 90      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 4               1       1       0
  94. 91      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  95. 92      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 14              1       1       0
  96. 93      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 16              1       1       0
  97. 94      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 18              1       1       0
  98. 95      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 18              1       1       0
  99. 96      SELECT `Age`.`id`, `Age`.`name` FROM `ages` AS `Age` WHERE `Age`.`id` = 18              1       1       0
  100. 97      SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  101. 98      SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  102. 99      SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  103. 100     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  104. 101     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  105. 102     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2         1       1       0
  106. 103     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2         1       1       0
  107. 104     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  108. 105     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  109. 106     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  110. 107     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2         1       1       0
  111. 108     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  112. 109     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  113. 110     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2         1       1       0
  114. 111     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  115. 112     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2         1       1       0
  116. 113     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  117. 114     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  118. 115     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 27                1       1       0
  119. 116     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2         1       1       0
  120. 117     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2         1       1       0
  121. 118     SELECT `Applicant`.`id`, `Applicant`.`name` FROM `applicants` AS `Applicant` WHERE `Applicant`.`id` = 2         1       1       0
  122. 119     SELECT `Zip`.`id`, `Zip`.`title`, `PlansZip`.`id`, `PlansZip`.`plan_id`, `PlansZip`.`zip_id` FROM `zips` AS `Zip` JOIN `plans_zips` AS `PlansZip` ON (`PlansZip`.`plan_id` IN (254, 775, 138, 116, 261, 506, 502, 240, 269, 763, 842, 769, 247, 498, 124, 859, 751, 757, 131, 317, 333, 301) AND `PlansZip`.`zip_id` = `Zip`.`id`) ORDER BY `Zip`.`title` ASC           9585    9585    13
  123. 120     SELECT `PlanDetail`.`id`, `PlanDetail`.`name` FROM `plan_details` AS `PlanDetail` LEFT JOIN `companies` AS `Company` ON (`PlanDetail`.`company_id` = `Company`.`id`) LEFT JOIN `plan_types` AS `PlanType` ON (`PlanDetail`.`plan_type_id` = `PlanType`.`id`) LEFT JOIN `plan_detail_notes` AS `PlanDetailNote` ON (`PlanDetail`.`plan_detail_note_id` = `PlanDetailNote`.`id`) WHERE 1 = 1 GROUP BY `PlanDetail`.`name` ORDER BY `PlanDetail`.`name` ASC                28      28      0
  124. 121     SELECT `Plan`.`id`, `Plan`.`created`, `Plan`.`modified`, `Plan`.`plan_detail_id`, `Plan`.`monthly_cost`, `Plan`.`dental_cost`, `Plan`.`age_id`, `Plan`.`applicant_id`, `Plan`.`state_id` FROM `plans` AS `Plan` WHERE `Plan`.`plan_detail_id` IN (54, 84, 85, 86, 87, 55, 63, 94, 78, 68, 65, 76, 74, 75, 77, 88, 61, 62, 80, 60, 56, 44, 50, 82, 46, 52, 42, 48)               604     604     1
  125. 122     SELECT `Definition`.`id`, `Definition`.`term`, `Definition`.`definition`, `DefinitionsPlanDetail`.`id`, `DefinitionsPlanDetail`.`definition_id`, `DefinitionsPlanDetail`.`plan_detail_id` FROM `definitions` AS `Definition` JOIN `definitions_plan_details` AS `DefinitionsPlanDetail` ON (`DefinitionsPlanDetail`.`plan_detail_id` IN (54, 84, 85, 86, 87, 55, 63, 94, 78, 68, 65, 76, 74, 75, 77, 88, 61, 62, 80, 60, 56, 44, 50, 82, 46, 52, 42, 48) AND `DefinitionsPlanDetail`.`definition_id` = `Definition`.`id`)
  126.  
  127.  
  128. ================================================================================
  129.  
  130. -- phpMyAdmin SQL Dump
  131. -- version 2.8.2.4
  132. -- http://www.phpmyadmin.net
  133. --
  134. -- Host: localhost:3306
  135. -- Generation Time: May 12, 2011 at 08:56 PM
  136. -- Server version: 5.0.51
  137. -- PHP Version: 5.2.6
  138. --
  139. -- Database: `db_1`
  140. --
  141.  
  142. -- --------------------------------------------------------
  143.  
  144. --
  145. -- Table structure for table `acos`
  146. --
  147.  
  148. CREATE TABLE `acos` (
  149.   `id` int(10) NOT NULL auto_increment,
  150.   `parent_id` int(10) default NULL,
  151.   `model` varchar(255) default NULL,
  152.   `foreign_key` int(10) default NULL,
  153.   `alias` varchar(255) default NULL,
  154.   `lft` int(10) default NULL,
  155.   `rght` int(10) default NULL,
  156.   PRIMARY KEY  (`id`)
  157. ) ENGINE=MyISAM AUTO_INCREMENT=175 DEFAULT CHARSET=latin1 AUTO_INCREMENT=175 ;
  158.  
  159. -- --------------------------------------------------------
  160.  
  161. --
  162. -- Table structure for table `ages`
  163. --
  164.  
  165. CREATE TABLE `ages` (
  166.   `id` int(11) NOT NULL auto_increment,
  167.   `min_age` text NOT NULL,
  168.   `max_age` text NOT NULL,
  169.   `name` varchar(100) NOT NULL,
  170.   PRIMARY KEY  (`id`)
  171. ) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;
  172.  
  173. -- --------------------------------------------------------
  174.  
  175. --
  176. -- Table structure for table `applicants`
  177. --
  178.  
  179. CREATE TABLE `applicants` (
  180.   `id` int(11) NOT NULL auto_increment,
  181.   `company_id` int(11) NOT NULL,
  182.   `name` varchar(100) NOT NULL,
  183.   `amount` text NOT NULL,
  184.   PRIMARY KEY  (`id`)
  185. ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
  186.  
  187. -- --------------------------------------------------------
  188.  
  189. --
  190. -- Table structure for table `aros`
  191. --
  192.  
  193. CREATE TABLE `aros` (
  194.   `id` int(10) NOT NULL auto_increment,
  195.   `parent_id` int(10) default NULL,
  196.   `model` varchar(255) default NULL,
  197.   `foreign_key` int(10) default NULL,
  198.   `alias` varchar(255) default NULL,
  199.   `lft` int(10) default NULL,
  200.   `rght` int(10) default NULL,
  201.   PRIMARY KEY  (`id`)
  202. ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
  203.  
  204. -- --------------------------------------------------------
  205.  
  206. --
  207. -- Table structure for table `aros_acos`
  208. --
  209.  
  210. CREATE TABLE `aros_acos` (
  211.   `id` int(10) NOT NULL auto_increment,
  212.   `aro_id` int(10) NOT NULL,
  213.   `aco_id` int(10) NOT NULL,
  214.   `_create` varchar(2) NOT NULL default '0',
  215.   `_read` varchar(2) NOT NULL default '0',
  216.   `_update` varchar(2) NOT NULL default '0',
  217.   `_delete` varchar(2) NOT NULL default '0',
  218.   PRIMARY KEY  (`id`),
  219.   UNIQUE KEY `ARO_ACO_KEY` (`aro_id`,`aco_id`)
  220. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  221.  
  222. -- --------------------------------------------------------
  223.  
  224. --
  225. -- Table structure for table `companies`
  226. --
  227.  
  228. CREATE TABLE `companies` (
  229.   `id` int(11) NOT NULL auto_increment,
  230.   `name` varchar(100) NOT NULL,
  231.   `company_logo_url` text NOT NULL,
  232.   PRIMARY KEY  (`id`)
  233. ) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
  234.  
  235. -- --------------------------------------------------------
  236.  
  237. --
  238. -- Table structure for table `definitions`
  239. --
  240.  
  241. CREATE TABLE `definitions` (
  242.   `id` int(11) NOT NULL auto_increment,
  243.   `term` varchar(50) NOT NULL,
  244.   `definition` text NOT NULL,
  245.   PRIMARY KEY  (`id`)
  246. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  247.  
  248. -- --------------------------------------------------------
  249.  
  250. --
  251. -- Table structure for table `definitions_plan_details`
  252. --
  253.  
  254. CREATE TABLE `definitions_plan_details` (
  255.   `id` int(11) NOT NULL auto_increment,
  256.   `definition_id` int(11) NOT NULL,
  257.   `plan_detail_id` int(11) NOT NULL,
  258.   PRIMARY KEY  (`id`)
  259. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  260.  
  261. -- --------------------------------------------------------
  262.  
  263. --
  264. -- Table structure for table `groups`
  265. --
  266.  
  267. CREATE TABLE `groups` (
  268.   `id` int(11) NOT NULL auto_increment,
  269.   `name` varchar(100) NOT NULL,
  270.   `created` datetime default NULL,
  271.   `modified` datetime default NULL,
  272.   PRIMARY KEY  (`id`)
  273. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  274.  
  275. -- --------------------------------------------------------
  276.  
  277. --
  278. -- Table structure for table `plan_detail_notes`
  279. --
  280.  
  281. CREATE TABLE `plan_detail_notes` (
  282.   `id` int(11) NOT NULL auto_increment,
  283.   `name` varchar(255) collate utf8_unicode_ci NOT NULL,
  284.   PRIMARY KEY  (`id`)
  285. ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;
  286.  
  287. -- --------------------------------------------------------
  288.  
  289. --
  290. -- Table structure for table `plan_details`
  291. --
  292.  
  293. CREATE TABLE `plan_details` (
  294.   `id` int(11) NOT NULL auto_increment,
  295.   `created` datetime default NULL,
  296.   `modified` datetime default NULL,
  297.   `effective_date` datetime NOT NULL,
  298.   `expiration_date` datetime NOT NULL,
  299.   `active` tinyint(1) NOT NULL,
  300.   `name` varchar(100) NOT NULL,
  301.   `plan_detail_note_id` int(11) default NULL,
  302.   `company_id` int(11) NOT NULL,
  303.   `plan_type_id` int(11) NOT NULL,
  304.   `max_benefit` decimal(18,2) NOT NULL,
  305.   `deductible` varchar(25) NOT NULL,
  306.   `preventive` varchar(25) NOT NULL,
  307.   `basic` varchar(25) NOT NULL,
  308.   `major` varchar(25) NOT NULL,
  309.   `ortho` text NOT NULL,
  310.   `benefits_schedule_wysiwyg` text NOT NULL,
  311.   `benefits_description_wysiwyg` text NOT NULL,
  312.   `exclusions_wysiwyg` text NOT NULL,
  313.   `provider_network_url` text NOT NULL,
  314.   `application_url` text NOT NULL,
  315.   `vision_wysiwyg` text NOT NULL,
  316.   PRIMARY KEY  (`id`)
  317. ) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=latin1 AUTO_INCREMENT=95 ;
  318.  
  319. -- --------------------------------------------------------
  320.  
  321. --
  322. -- Table structure for table `plan_types`
  323. --
  324.  
  325. CREATE TABLE `plan_types` (
  326.   `id` int(11) NOT NULL auto_increment,
  327.   `name` varchar(50) NOT NULL,
  328.   `description` text NOT NULL,
  329.   PRIMARY KEY  (`id`)
  330. ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
  331.  
  332. -- --------------------------------------------------------
  333.  
  334. --
  335. -- Table structure for table `plans`
  336. --
  337.  
  338. CREATE TABLE `plans` (
  339.   `id` int(11) NOT NULL auto_increment,
  340.   `created` datetime default NULL,
  341.   `modified` datetime default NULL,
  342.   `plan_detail_id` int(11) NOT NULL,
  343.   `monthly_cost` decimal(18,2) NOT NULL,
  344.   `dental_cost` decimal(18,2) NOT NULL default '0.00',
  345.   `age_id` int(11) NOT NULL,
  346.   `applicant_id` int(11) NOT NULL,
  347.   `state_id` int(11) NOT NULL,
  348.   PRIMARY KEY  (`id`)
  349. ) ENGINE=MyISAM AUTO_INCREMENT=898 DEFAULT CHARSET=latin1 AUTO_INCREMENT=898 ;
  350.  
  351. -- --------------------------------------------------------
  352.  
  353. --
  354. -- Table structure for table `plans_zips`
  355. --
  356.  
  357. CREATE TABLE `plans_zips` (
  358.   `id` int(11) NOT NULL auto_increment,
  359.   `plan_id` int(11) NOT NULL,
  360.   `zip_id` int(11) NOT NULL,
  361.   PRIMARY KEY  (`id`),
  362.   KEY `plan_id` (`plan_id`,`zip_id`)
  363. ) ENGINE=MyISAM AUTO_INCREMENT=330800 DEFAULT CHARSET=latin1 AUTO_INCREMENT=330800 ;
  364.  
  365. -- --------------------------------------------------------
  366.  
  367. --
  368. -- Table structure for table `states`
  369. --
  370.  
  371. CREATE TABLE `states` (
  372.   `id` int(11) NOT NULL auto_increment,
  373.   `name` varchar(75) NOT NULL,
  374.   PRIMARY KEY  (`id`)
  375. ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
  376.  
  377. -- --------------------------------------------------------
  378.  
  379. --
  380. -- Table structure for table `users`
  381. --
  382.  
  383. CREATE TABLE `users` (
  384.   `id` int(11) NOT NULL auto_increment,
  385.   `username` varchar(50) NOT NULL,
  386.   `password` char(40) NOT NULL,
  387.   `name` varchar(50) NOT NULL,
  388.   `email` varchar(255) NOT NULL,
  389.   `group_id` int(11) NOT NULL,
  390.   `created` datetime default NULL,
  391.   `modified` datetime default NULL,
  392.   PRIMARY KEY  (`id`),
  393.   UNIQUE KEY `username` (`username`)
  394. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  395.  
  396. -- --------------------------------------------------------
  397.  
  398. --
  399. -- Table structure for table `zips`
  400. --
  401.  
  402. CREATE TABLE `zips` (
  403.   `id` int(11) NOT NULL auto_increment,
  404.   `state_id` int(2) NOT NULL,
  405.   `title` varchar(100) NOT NULL,
  406.   PRIMARY KEY  (`id`)
  407. ) ENGINE=MyISAM AUTO_INCREMENT=1374 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1374 ;