API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 12th, 2011
112
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 34.72 KB | None | 0 0
raw download clone embed print report
  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 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!