API tools faq
paste
RoniElBombardero

Multi Dump www.edseek.org #RoniBombardero

RoniElBombardero
Jan 5th, 2014
80
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.86 KB | None | 0 0
raw download clone embed print report
  1. DROP TABLE IF EXISTS `counties`;
  2. CREATE TABLE `counties` (
  3. `county_ID` tinyint(5) NOT NULL auto_increment,
  4. `County` varchar(60) default NULL,
  5. PRIMARY KEY (`county_ID`),
  6. UNIQUE KEY `county_ID` (`county_ID`)
  7. ) TYPE=MyISAM;
  8.  
  9. INSERT INTO `counties` (`county_ID`,`County`) VALUES ('1','Bond');
  10. INSERT INTO `counties` (`county_ID`,`County`) VALUES ('2','Fayette');
  11. INSERT INTO `counties` (`county_ID`,`County`) VALUES ('3','Effingham');
  12.  
  13. DROP TABLE IF EXISTS `mandated_units`;
  14. CREATE TABLE `mandated_units` (
  15. `Record_ID` int(11) NOT NULL auto_increment,
  16. `School_ID` int(11) default NULL,
  17. `abduction_education` text,
  18. `School_Name` varchar(100) default NULL,
  19. `american_patriotism_government` text,
  20. `anabolic_steroids` text,
  21. `black_history` text,
  22. `career_education` text,
  23. `character_education` text,
  24. `conservation_of_natural_resources` text,
  25. `consumer_education` text,
  26. `drug_and_substance_abuse_education` text,
  27. `holocaust_genocide_education` text,
  28. `media_library_services` text,
  29. `safety_education` text,
  30. `sex_education` text,
  31. `us_history` text,
  32. `us_and_illinois_constitutions` text,
  33. `violence_prevention_and_conflict_resolution` text,
  34. `women_in_history` text,
  35. `health` text,
  36. `cancer_instruction` text,
  37. `language_arts` text,
  38. `reading_and_communications` text,
  39. `science` text,
  40. `mathematics` text,
  41. `social_studies` text,
  42. `music` text,
  43. `art` text,
  44. `foreign_language` text,
  45. `sexual_assault_awareness` text,
  46. `internet_safety_instruction` text,
  47. `congressional_medal_of_honor_video` text,
  48. `disabilities_history_and_rights` text,
  49. `mexican_american_deportation_during_depression` text,
  50. PRIMARY KEY (`Record_ID`),
  51. UNIQUE KEY `Record_ID` (`Record_ID`)
  52. ) TYPE=MyISAM;
  53.  
  54.  
  55. DROP TABLE IF EXISTS `schools`;
  56. CREATE TABLE `schools` (
  57. `School_ID` int(11) NOT NULL auto_increment,
  58. `School_Name` varchar(100) NOT NULL default '',
  59. `District` varchar(100) NOT NULL default '',
  60. `username` varchar(60) NOT NULL default '0',
  61. `password` varchar(60) NOT NULL default '0',
  62. `security` tinyint(3) default NULL,
  63. `County` varchar(50) default NULL,
  64. PRIMARY KEY (`School_ID`)
  65. ) TYPE=MyISAM;
  66.  
  67. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('11','Mulberry Grove Grade School','Unit 1','mulberry1','mulberry1','1','Bond');
  68. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('12','Mulberry Grove Jr/Sr High School','Unit 1','mulberry2','mulberry2','1','Bond');
  69. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('21','Bond County Grade School','Unit 2','bondcounty1','bondcounty1','1','Bond');
  70. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('22','Sorento Grade School','Unit 2','sorento','sorento','1','Bond');
  71. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('23','Pocahontas Grade School','Unit 2','pocahontas','pocahontas','1','Bond');
  72. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('24','Greenville Jr. High','Unit 2','greenville','greenville','1','Bond');
  73. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('25','Bond County High School','Unit 2','bondcounty2','bondcounty2','1','Bond');
  74. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('31','Brownstown Elementary School','Unit 201','0','0','1','Fayette');
  75. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('32','Brownstown Jr/Sr High School','Unit 201','0','0','1','Fayette');
  76. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('41','St. Elmo Elementary School','Unit 202','0','0','1','Fayette');
  77. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('42','St. Elmo Jr/Sr High School','Unit 202','0','0','1','Fayette');
  78. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('51','Jefferson Primary School','Unit 203','0','0','1','Fayette');
  79. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('52','Vandalia Elementary School','Unit 203','0','0','1','Fayette');
  80. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('53','Vandalia Jr High School','Unit 203','0','0','1','Fayette');
  81. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('54','Okaw Area Vocational Center','Unit 203','0','0','1','Fayette');
  82. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('55','Vandalia High School','Unit 203','0','0','1','Fayette');
  83. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('61','Ramsey Grade School','Unit 204','0','0','1','Fayette');
  84. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('62','Ramsey High School','Unit 204','0','0','1','Fayette');
  85. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('71','Altamont Grade School','Unit 10','altamont1','altamont1','1','Effingham');
  86. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('72','Altamont High School','Unit 10','altamont2','altamont2','1','Effingham');
  87. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('81','Beecher City Grade School','Unit 20','beechercity1','beechercity1','1','Effingham');
  88. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('82','Shumway Grade School','Unit 20','shumway','shumway','1','Effingham');
  89. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('83','Beecher City High School','Unit 20','beechercity2','beechercity2','1','Effingham');
  90. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('91','Dieterich Grade School','Unit 30','dieterich1','dieterich1','1','Effingham');
  91. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('92','Dieterich High School','Unit 30','dieterich2','dieterich2','1','Effingham');
  92. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('101','Early Learning Center','Unit 40','elc','elc','1','Effingham');
  93. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('102','West Side School','Unit 40','westside','westside','1','Effingham');
  94. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('103','South Side School','Unit 40','southside','southside','1','Effingham');
  95. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('104','Edgewood Grade School','Unit 40','edgewood','edgewood','1','Effingham');
  96. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('105','Central School','Unit 40','central','central','1','Effingham');
  97. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('106','Effingham Jr High School','Unit 40','effingham1','effingham1','1','Effingham');
  98. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('107','Effingham High School','Unit 40','effingham2','effingham2','1','Effingham');
  99. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('111','Teutopolis Grade School','Unit 50','teutopolis1','teutopolis1','1','Effingham');
  100. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('112','Teutopolis Jr High School','Unit 50','teutopolis2','teutopolis2','1','Effingham');
  101. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('113','Teutopolis High School','Unit 50','teutopolis3','teutopolis3','1','Effingham');
  102. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('121','St. Anthony Grade School','Parochial','0','0','1','Effingham');
  103. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('122','St. Anthony High School','Parochial','0','0','1','Effingham');
  104. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('123','Sacred Heart Grade School','Parochial','0','0','1','Effingham');
  105. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('124','Altamont Lutheran Grade School','Parochial','0','0','1','Effingham');
  106. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('125','St. Peter Lutheran Grade School','Parochial','0','0','1','Fayette');
  107. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('126','Vandalia Christian Academy','Parochial','0','0','1','Fayette');
  108. INSERT INTO `schools` (`School_ID`,`School_Name`,`District`,`username`,`password`,`security`,`County`) VALUES ('127','ROE','ROE','admin','admin','2','Fayette');
Add Comment
Please, Sign In to add comment
Public Pastes
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!