API tools faq
paste
Guest User

Untitled

a guest
Nov 24th, 2016
58
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.58 KB | None | 0 0
raw download clone embed print report
  1.  
  2. --Schools
  3. INSERT INTO Schools VALUES('mission lol', 'Sakkara', 'English', 01111111,'some info', 'ababa@gmail.com', 'my vision is clear', 12, 'International','Maadi')
  4. INSERT INTO Schools VALUES('mission haha', 'Bakkara', 'London', 01111112,'some more info', 'abaaba@gmail.com', 'my vision is set', 120, 'National','Maadi1')
  5. INSERT INTO Schools VALUES('mission xD', 'Dakkara', 'German', 01111113,'even more info', 'abaaaba@gmail.com', 'my vision is ready', 1200, 'International','Maadi2')
  6. INSERT INTO Schools VALUES('mission rofl', 'Rakkara', 'Bligish', 01111114,'a ton of info', 'abaaaaba@gmail.com', 'my vision is bad', 12000, 'National','Maadi3')
  7. INSERT INTO Schools VALUES('mission lmao', 'Chakkara', 'Shingel', 01111115,'extreme info', 'abaaaaaba@gmail.com', 'my vision is super', 120000, 'International','Maadi4')
  8. INSERT INTO Schools VALUES('mission roflolmaoxD', 'Sakura', 'Sharara', 01111116,'suicidal info', 'ababaaaaaa@gmail.com', 'my vision is 20/20', 1200000, 'National','Maadi5')
  9.  
  10. --Employees
  11. INSERT INTO Employees VALUES('7amada2', 'xD123', 'abo7omos@tara.com', 123.12, '2012-12-12', 'male', 'Abo', 'Sabalask', '7amada', 'share3 7amada el 7amood', 1)
  12. INSERT INTO Employees VALUES('7ambozo', 'xD123', 'shebshebs@glara.com', 124.12, '2013-12-12', 'female', 'Om', 'Sabalask', '7alawa', 'share3 salawa el salool', 2)
  13. INSERT INTO Employees VALUES('7ozombol', 'xD123', 'trablos@gara.com', 125.12, '2014-12-12', 'male', 'O5t', 'Sabalask', '7ashaba', 'share3 kababa el kabkoob', 3)
  14. INSERT INTO Employees VALUES('2obro2', 'xD123', 'kiki@tota.com', 126.12, '2015-12-12', 'male', 'A5o', 'Sabalask', '7akawy', 'share3 zbala el zabool', 4)
  15. INSERT INTO Employees VALUES('ashasha', 'xD123', 'kleb@asara.com', 127.12, '2016-12-12', 'male', 'Anto', 'Sabalask', 'balawy', 'share3 trella el tarool', 5)
  16. INSERT INTO Employees VALUES('shemshem', 'xD123', 'titotata@abara.com', 128.12, '2017-12-12', 'female', 'Aso', 'Sabalask', 'mohamed', 'zahra2 el ma3ady', 6)
  17. INSERT INTO Employees VALUES('7amada3', 'xD123', 'abo7omosaya@marara.com', 123.12, '2012-12-12', 'female', 'Abo', 'Sabalask', '7amada', 'share3 7amada el 7amood', 1)
  18. INSERT INTO Employees VALUES('7amboz2', 'xD123', 'shebshebsaya@zhe2t.com', 124.12, '2013-12-12', 'female', 'Om', 'Sabalask', '7alawa', 'share3 salawa el salool', 2)
  19. INSERT INTO Employees VALUES('7ozombo4', 'xD123', 'trablosobo@kfayaaa.com', 125.12, '2014-12-12', 'male', 'O5t', 'Sabalask', '7ashaba', 'share3 kababa el kabkoob', 3)
  20. INSERT INTO Employees VALUES('2obro22', 'xD123', 'kikiki@plsstop.com', 126.12, '2015-12-12', 'malish', 'male', 'Sabalask', '7akawy', 'share3 zbala el zabool', 4)
  21. INSERT INTO Employees VALUES('ashashaasas', 'xD123', 'klabeb@getthisoverwith.com', 127.12, '2016-12-12', 'male', 'Anto', 'Sabalask', 'balawy', 'share3 trella el tarool', 5)
  22. INSERT INTO Employees VALUES('shemshemshamshem', 'xD123', 'tatitotata@nah.com', 128.12, '2017-12-12', 'femal', 'Aso', 'Sabalask', 'mohamed', 'zahra2 el ma3ady', 6)
  23.  
  24. --Supervisors
  25. INSERT INTO Supervisors VALUES(1)
  26. INSERT INTO Supervisors VALUES(2)
  27. INSERT INTO Supervisors VALUES(3)
  28. INSERT INTO Supervisors VALUES(4)
  29. INSERT INTO Supervisors VALUES(5)
  30. INSERT INTO Supervisors VALUES(6)
  31.  
  32.  
  33. --Teachers
  34. INSERT INTO Teachers VALUES(7, 5, 1)
  35. INSERT INTO Teachers VALUES(8, 2, 2)
  36. INSERT INTO Teachers VALUES(9, 10, 3)
  37. INSERT INTO Teachers VALUES(10, 10, 4)
  38. INSERT INTO Teachers VALUES(11, 10, 5)
  39. INSERT INTO Teachers VALUES(12, 10, 6)
  40.  
  41. --Levels
  42. INSERT INTO Levels VALUES('Elementary', 1)
  43. INSERT INTO Levels VALUES('Elementary', 2)
  44. INSERT INTO Levels VALUES('Middle', 3)
  45. INSERT INTO Levels VALUES('Middle', 4)
  46. INSERT INTO Levels VALUES('High', 5)
  47. INSERT INTO Levels VALUES('High', 6)
  48.  
  49. --Courses
  50. INSERT INTO Courses VALUES(101, 'CSEN', 1, 'course 7elw', 'Elementary', 7)
  51. INSERT INTO Courses VALUES(101, 'CSEN', 1, 'course 7elw', 'Elementary', 8)
  52. INSERT INTO Courses VALUES(102, 'DMET', 1, 'course ta3ban', 'Elementary', 7)
  53. INSERT INTO Courses VALUES(102, 'DMET', 1, 'course ta3ban', 'Elementary', 8)
  54.  
  55. INSERT INTO Courses VALUES(103, 'MATH', 5, 'course 5ashab', 'Middle', 9)
  56. INSERT INTO Courses VALUES(103, 'MATH', 5, 'course 5ashab', 'Middle', 10)
  57. INSERT INTO Courses VALUES(201, 'CSEN', 5, 'course arnab', 'Middle', 9)
  58. INSERT INTO Courses VALUES(201, 'CSEN', 5, 'course arnab', 'Middle', 10)
  59.  
  60. INSERT INTO Courses VALUES(202, 'DMET', 9, 'course dabdoob', 'High', 11)
  61. INSERT INTO Courses VALUES(202, 'DMET', 9, 'course dabdoob', 'High', 12)
  62. INSERT INTO Courses VALUES(203, 'MATH', 9, 'course alwan', 'High', 11)
  63. INSERT INTO Courses VALUES(203, 'MATH', 9, 'course alwan', 'High', 12)
  64.  
  65.  
  66. --Elementary Schools
  67. INSERT INTO Elementary_Schools VALUES(1, 'shwayet 7agat', 'Elementary')
  68. INSERT INTO Elementary_Schools VALUES(2, '7agat tanya', 'Elementary')
  69.  
  70. --Middle Schools
  71. INSERT INTO Middle_Schools VALUES(3, 'Middle')
  72. INSERT INTO Middle_Schools VALUES(4, 'Middle')
  73.  
  74. --High Schools
  75. INSERT INTO High_Schools VALUES(5, 'High')
  76. INSERT INTO High_Schools VALUES(6, 'High')
  77.  
  78. --Clubs
  79. INSERT INTO Clubs VALUES(1,'Rawshana Club', 'Netrawshen 3ala b3d')
  80. INSERT INTO Clubs VALUES(1,'Latm Club', 'Noltom 3ala b3d')
  81. INSERT INTO Clubs VALUES(2,'Faty Club', 'Nefty 3ala b3d')
  82. INSERT INTO Clubs VALUES(2,'Akl Club', 'Bnakol b3d')
  83. INSERT INTO Clubs VALUES(3,'Cruise Club', 'Cruising 3ala b3d')
  84. INSERT INTO Clubs VALUES(3,'Cursing Club', 'Beneshtem b3d')
  85. INSERT INTO Clubs VALUES(4,'Shawerma Club', 'Benshawrem 3ala b3d')
  86. INSERT INTO Clubs VALUES(4,'Football Club', 'Benfatbal 3ala b3d')
  87. INSERT INTO Clubs VALUES(5,'Chair Club', 'Bno3od 3ala b3d')
  88. INSERT INTO Clubs VALUES(5,'Estefzaz Club', 'Bnestafez b3d')
  89. INSERT INTO Clubs VALUES(6,'Karate Club', 'Benkarrate 3ala b3d')
  90. INSERT INTO Clubs VALUES(6,'Club Club', 'Benedrab b3d')
  91.  
  92. --Students
  93. INSERT INTO Students VALUES(123, 'WadRewesh1', 420, '1', 1, 'Elementary')
  94. INSERT INTO Students VALUES(124, 'WadRewesh2', 420, '2', 1, 'Elementary')
  95. INSERT INTO Students VALUES(125, 'WadRewesh3', 420, '3', 2, 'Elementary')
  96. INSERT INTO Students VALUES(126, 'WadRewesh4', 420, '4', 2, 'Elementary')
  97. INSERT INTO Students VALUES(127, 'WadRewesh5', 420, '7', 3, 'Middle')
  98. INSERT INTO Students VALUES(128, 'WadRewesh6', 420, '8', 3, 'Middle')
  99. INSERT INTO Students VALUES(129, 'WadRewesh7', 420, '9', 4, 'Middle')
  100. INSERT INTO Students VALUES(133, 'WadRewesh8', 420, '7', 4, 'Middle')
  101. INSERT INTO Students VALUES(143, 'WadRewesh9', 420, '10', 5, 'High')
  102. INSERT INTO Students VALUES(153, 'WadRewesh10', 420, '11', 5, 'High')
  103. INSERT INTO Students VALUES(163, 'WadRewesh11', 420, '12', 6, 'High')
  104. INSERT INTO Students VALUES(173, 'WadRewesh12', 420, '11', 6, 'High')
  105.  
  106. --Club_Joined_By_student
  107. INSERT INTO Club_Joined_By_student VALUES(123, 1, 1)
  108. INSERT INTO Club_Joined_By_student VALUES(124, 1, 2)
  109. INSERT INTO Club_Joined_By_student VALUES(125, 2, 3)
  110. INSERT INTO Club_Joined_By_student VALUES(126, 2, 4)
  111. INSERT INTO Club_Joined_By_student VALUES(127, 3, 5)
  112. INSERT INTO Club_Joined_By_student VALUES(128, 3, 6)
  113. INSERT INTO Club_Joined_By_student VALUES(129, 4, 7)
  114. INSERT INTO Club_Joined_By_student VALUES(133, 4, 8)
  115. INSERT INTO Club_Joined_By_student VALUES(143, 5, 9)
  116. INSERT INTO Club_Joined_By_student VALUES(153, 5, 10)
  117. INSERT INTO Club_Joined_By_student VALUES(163, 6, 11)
  118. INSERT INTO Club_Joined_By_student VALUES(173, 6, 12)
  119.  
  120. --Prequisite Courses
  121. INSERT INTO Prerequisite_Courses VALUES(101, 'dat course')
  122. INSERT INTO Prerequisite_Courses VALUES(102, 'dis course')
  123. INSERT INTO Prerequisite_Courses VALUES(103, 'dem courses')
  124. INSERT INTO Prerequisite_Courses VALUES(201, 'drat course')
  125. INSERT INTO Prerequisite_Courses VALUES(202, 'dabat course')
  126. INSERT INTO Prerequisite_Courses VALUES(203, 'dab course')
  127.  
  128. --Assignments
  129. INSERT INTO Assignments VALUES('12-12-2012', '11-11-2011', 'course stuff', 101, 7)
  130. INSERT INTO Assignments VALUES('12-12-2012', '11-11-2011', 'more course stuff', 102, 8)
  131. INSERT INTO Assignments VALUES('12-12-2012', '11-11-2011', 'morer course stuff', 103, 9)
  132. INSERT INTO Assignments VALUES('12-12-2012', '11-11-2011', 'most course stuff', 201, 10)
  133. INSERT INTO Assignments VALUES('12-12-2012', '11-11-2011', 'assignment with course stuff', 202, 11)
  134. INSERT INTO Assignments VALUES('12-12-2012', '11-11-2011', 'crazy course stuff', 203, 12)
  135.  
  136. --Teacher_Assign_Grade_Assignment
  137. INSERT INTO Teacher_Assign_Grade_Assignment VALUES(2, 10)
  138. INSERT INTO Teacher_Assign_Grade_Assignment VALUES(3, 100)
  139. INSERT INTO Teacher_Assign_Grade_Assignment VALUES(4, 1000)
  140. INSERT INTO Teacher_Assign_Grade_Assignment VALUES(5, 10000)
  141. INSERT INTO Teacher_Assign_Grade_Assignment VALUES(6, 100000)
  142. INSERT INTO Teacher_Assign_Grade_Assignment VALUES(7, 1000000)
  143. INSERT INTO Teacher_Assign_Grade_Assignment VALUES(8, 10000000)
  144.  
  145. --Assignment_is_Solved_by_Student
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!