API tools faq
paste
AnonCyberHack

Asis | AnonSpectrumItalianSquad

AnonCyberHack
Jun 8th, 2013
2,629
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 59.57 KB | None | 0 0
raw download clone embed print report
  1. Target: wikispaces.com
  2.  
  3. Hacker: AnonCyberHack
  4.  
  5. Crew: AnonSpectrumItalianSquad | Asis
  6.  
  7. -----------------------------
  8. INSERT ALL
  9. INTO user(user_id, email, password) VALUES (1, '[email protected]', 'kMZXfdpZk7WYhMvfsXI5CFBHq6qIkQ2aVL7KA1XH')
  10. INTO user(user_id, email, password) VALUES (2, '[email protected]', 'qYFdp6gBiTRKe2Wg1CuJ8iY5vQXR0dYtid839Lf7')
  11. INTO user(user_id, email, password) VALUES (3, '[email protected]', 'Ex5B5scGfzbqetRfbPn0ggFly3beiUWaEdj4QLQ9')
  12. INTO user(user_id, email, password) VALUES (4, '[email protected]', 'sAQHUa9KZKgrp3INcJjkqHPIavnme2YMY40zTBi0')
  13. INTO user(user_id, email, password) VALUES (5, '[email protected]', 'SxHmwE1Ci67M7avIoeb2gcnH3nJaLjutL8lLjW9s')
  14. INTO user(user_id, email, password) VALUES (6, '[email protected]', 'IT1Y6T4q9BoGWCoYUBF5I4Br7fqrJQE17S6BthRL')
  15. INTO user(user_id, email, password) VALUES (7, '[email protected]', 'oP8nEYVA4YYZ9OX78C4bMzpkmxpQbAIhBcYtfoyR')
  16. INTO user(user_id, email, password) VALUES (8, '[email protected]', 'Ui5H3pwYYDQS5XWy4bwO1phz8I8tx1TQ1ftNYr5D')
  17. INTO user(user_id, email, password) VALUES (9, '[email protected]', 'Dxnji6YioxEYgy6nqSZl8h8SXL4SZvpPlbCaxgTk')
  18. INTO user(user_id, email, password) VALUES (10, '[email protected]', 'FRIngUwm5iHPh90unYMhi1jNDnuATixruGnXafNL')
  19. INTO user(user_id, email, password) VALUES (11, '[email protected]', 'MO3myLrXQk2ILfG7Z7KhaDW6dk7EZM5yl372VK3X')
  20. INTO user(user_id, email, password) VALUES (12, '[email protected]', 'wQjgEUbnd0Q2h64g7iSlbc7MCH73EzwLjcFUsy7h')
  21. INTO user(user_id, email, password) VALUES (13, '[email protected]', 'HjFEKYWBeejnyAd1MP6BlTOs9PLK9hBwrmjXoYOh')
  22. INTO user(user_id, email, password) VALUES (14, '[email protected]', 'P1cXSTlAajxRC6PQFfMhCtkRtrxhOzMs73QqWZbX')
  23. INTO user(user_id, email, password) VALUES (15, '[email protected]', 'cjX4tNqJb93rlN7vpFSAgEJWr7NXZLtg2c8pQHVO')
  24. SELECT 1 FROM DUAL;
  25.  
  26.  
  27. INSERT ALL
  28. INTO admin(user_id, firstname, lastname) VALUES (1, 'Edward', 'Arciga')
  29. INTO admin(user_id, firstname, lastname) VALUES (2, 'Analyn', 'Dela Pena')
  30. INTO admin(user_id, firstname, lastname) VALUES (3, 'Carolyn', 'Ambrocio')
  31. INTO admin(user_id, firstname, lastname) VALUES (4, 'Gibraltar', 'Principe')
  32. INTO admin(user_id, firstname, lastname) VALUES (5, 'Jigi', 'Casamayor')
  33. SELECT 1 FROM DUAL;
  34.  
  35.  
  36. INSERT ALL
  37. INTO applicant(user_id, firstname, lastname, mi, birthdate) VALUES (6, 'Catherine', 'Camba', 'R', '1977-01-12')
  38. INTO applicant(user_id, firstname, lastname, mi, birthdate) VALUES (7, 'Edna', 'Gotico', 'B', '1980-08-08')
  39. INTO applicant(user_id, firstname, lastname, mi, birthdate) VALUES (8, 'Elaine', 'Domingo', 'I', '1981-01-09')
  40. INTO applicant(user_id, firstname, lastname, mi, birthdate) VALUES (9, 'Joselito', 'Aranda', 'Q', '1984-10-09')
  41. INTO applicant(user_id, firstname, lastname, mi, birthdate) VALUES (10, 'John', 'Jamila', 'F', '1985-05-23')
  42. SELECT 1 FROM DUAL;
  43.  
  44.  
  45. INSERT ALL
  46. INTO employer(user_id, company_name, description) VALUES (11, 'IBM', 'International Business Machines (IBM) is a United States multinational technology and consulting firm headquartered in Armonk, New York. Founded in 1911, IBM manufactures and sells computer hardware and software, and it offers infrastructure, hosting and consulting services in areas ranging from mainframe computers to nanotechnology.')
  47. INTO employer(user_id, company_name, description) VALUES (12, 'HP', 'Hewlett-Packard Company, commonly referred to as HP, is an American multinational information technology corporation headquartered in Palo Alto, California, USA. The company was founded in a one-car garage in Palo Alto by Bill Hewlett and Dave Packard, and is now one of the worlds largest information technology companies, operating in nearly every country. HP specializes in developing and manufacturing computing, data storage, and networking hardware, designing software and delivering services. Major product lines include personal computing devices, enterprise servers, related storage devices, as well as a diverse range of printers and other imaging products. HP markets its products to households, small- to medium-sized businesses and enterprises directly as well as via online distribution, consumer-electronics and office-supply retailers, software partners and major technology vendors.')
  48. INTO employer(user_id, company_name, description) VALUES (13, 'O&B', 'Orange & Bronze Software Labs is the 1st Philippine-based SpringSource partner with a team of seasoned software engineers and architects who have been using Spring, and its derivative technologies Appfuse and Grails, since its early versions. We have a long history of building successful, robust and high-performance enterprise applications on Spring, AppFuse and Grails. We are fanatical about enterprise design best practices and Agile software development. We have a large and growing number of highly-discriminating yet extremely happy clients who will endorse our expertise, professionalism and commitment. Our location in the Philippines allows us to provide our expertise at an affordable cost. Orange & Bronze is the official sponsor of the Philippine Groovy Users Group and the Philippine Java Users Group.')
  49. INTO employer(user_id, company_name, description) VALUES (14, 'Loreal', 'The L'Or�al Group is the world's largest cosmetics and beauty company. With its registered office in Paris and head office in the Paris suburb of Clichy, Hauts-de-Seine, France, it has developed activities in the field of cosmetics. Concentrating on hair colour, skin care, sun protection, make-up, perfumes and hair care, the company is active in the dermatological and pharmaceutical fields and is the top nanotechnology patent-holder in the United States.')
  50. INTO employer(user_id, company_name, description) VALUES (15, 'Accenture', 'Accenture plc is a global management consulting, technology consulting and technology outsourcing company. Previously incorporated in the USA, then in Bermuda, since 1 September 2009 the company has been incorporated in Ireland with its global headquarters there in Dublin. It is the largest consulting firm in the world, as well as being a global player within the technology consulting industry. Accenture is a Fortune Global 500 company. As of 2010, the company had more than 200,000 employees in more than 200 locations in over 120 countries. Accentures current clients include 96 of the Fortune Global 100 and more than three quarters of the Fortune Global 500.')
  51. SELECT 1 FROM DUAL;
  52.  
  53.  
  54. INSERT ALL
  55. INTO message(msg_id, sender_id, recipient_id, sent_date, subject, body, is_read) VALUES (1, 5, 3, '2011-01-12 10:42:50.15', 'Test Message', 'Just a test.', 'Y')
  56. INTO message(msg_id, sender_id, recipient_id, sent_date, subject, body, is_read) VALUES (2, 1, 9, '2011-01-13 12:23:31.12', 'Test Message', 'Just a test.', 'N')
  57. INTO message(msg_id, sender_id, recipient_id, sent_date, subject, body, is_read) VALUES (3, 4, 6, '2011-01-14 17:39:20.19', 'Test Message', 'Just a test.', 'Y')
  58. INTO message(msg_id, sender_id, recipient_id, sent_date, subject, body, is_read) VALUES (4, 2, 7, '2011-01-15 22:12:35.11', 'Test Message', 'Just a test.', 'Y')
  59. INTO message(msg_id, sender_id, recipient_id, sent_date, subject, body, is_read) VALUES (5, 8, 13, '2011-01-16 19:27:43.18', 'Test Message', 'Just a test.', 'N')
  60. SELECT 1 FROM DUAL;
  61.  
  62.  
  63. INSERT ALL
  64. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (1, '(63)908-2059924', '(63)(02)432-1156', '', '1411-B Sevilla Street Tondo', 6)
  65. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (2, '(63)908-2059923', '(63)(02)403-8619', '', '11 B.P. Mariano Street, Ususan', 203)
  66. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (3, '(63)927-5012363', '(63)(02)508-3945', '', '#21-I South Street Don Enrique Village, Novaliches', 31)
  67. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (4, '(63)920-4140319', '(63)(02)974-9004', '', '516 Cayabyab Street, Bisig ng Kabataan, Sangandaan', 204)
  68. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (5, '(63)919-2247397', '(63)(02)661-1531', '', 'Block 5, Lot 18, Nova Romania Phase 2, Bignay', 201)
  69. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (6, '(63)919-3240072', '(63)(02)2059923', '', '3420 B P. Del Rosario Street, Barrio Obrero, Tondo', 6)
  70. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (7, '(63)929-8905982', '(63)(02)5536067', '', 'Block 6, Lot 22, El Toro Drive, Woodrow Hills Subdivision, Barangay Dalig', 202)
  71. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (8, '(63)917-6012673', '(63)(02)8600319', '', '2351 Antipolo Street, Guadalupe Nuevo', 32)
  72. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (9, '(63)939-3093757', '(63)(02)2059345', '', 'Unit 10 Santiago Compd. 62 J. Santiago Street, Libo I, Malanday', 201)
  73. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (10, '(63)907-3018680', '(63)(02)5012363', '', 'D112 Citihomes Apartments, 130 St. Francis Street', 205)
  74. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (11, '(63)923-5536067', '(63)(02)3018680', 'http://www.ibm.com/ph/en/', '018 Robina Road Brgy. Nagkaisang Nayon, Novaliches', 31)
  75. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (12, '(63)919-2322408', '(63)(02)5017854', 'http://welcome.hp.com/country/ph/en/solutions.html', '013 E. Sabellano St. Quiot Pardo', 34)
  76. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (13, '(63)919-3263072', '(63)(02)2059532', 'http://www.orangeandbronze.com/', '110 Arthur Lake Street', 206)
  77. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (14, '(63)920-8600319', '(63)(02)8495324', 'http://www.loreal.com/_en/_ww/index.aspx?', '7052 Avocado St. Comembo', 32)
  78. INTO contact_info(user_id, landline, mobile, website, address, city_id) VALUES (15, '(63)908-2059546', '(63)(02)9430245', 'http://www.accenture.com/Countries/Philippines/default.htm', 'Block 70 Lot 3 Criselda Cecilio Street, BF Resort Village', 207)
  79. SELECT 1 FROM DUAL;
  80.  
  81.  
  82. INSERT ALL
  83. INTO city (city_id, city_name, country_id) VALUES (1, 'Tokyo', 121)
  84. INTO city (city_id, city_name, country_id) VALUES (2, 'Jakarta', 112)
  85. INTO city (city_id, city_name, country_id) VALUES (3, 'Seoul', 213)
  86. INTO city (city_id, city_name, country_id) VALUES (4, 'Delhi', 111)
  87. INTO city (city_id, city_name, country_id) VALUES (5, 'Mumbai', 111)
  88. INTO city (city_id, city_name, country_id) VALUES (6, 'Manila', 185)
  89. INTO city (city_id, city_name, country_id) VALUES (7, 'Shanghai', 49)
  90. INTO city (city_id, city_name, country_id) VALUES (8, 'Osaka', 121)
  91. INTO city (city_id, city_name, country_id) VALUES (9, 'Kolkata', 111)
  92. INTO city (city_id, city_name, country_id) VALUES (10, 'Karachi', 178)
  93. INTO city (city_id, city_name, country_id) VALUES (11, 'Guangzhou', 49)
  94. INTO city (city_id, city_name, country_id) VALUES (12, 'Thimpu', 28)
  95. INTO city (city_id, city_name, country_id) VALUES (13, 'Dhaka', 20)
  96. INTO city (city_id, city_name, country_id) VALUES (14, 'Tehran', 113)
  97. INTO city (city_id, city_name, country_id) VALUES (15, 'Beijing', 49)
  98. INTO city (city_id, city_name, country_id) VALUES (16, 'Bangkok', 228)
  99. INTO city (city_id, city_name, country_id) VALUES (17, 'Nagoya', 121)
  100. INTO city (city_id, city_name, country_id) VALUES (18, 'Hong Kong', 108)
  101. INTO city (city_id, city_name, country_id) VALUES (19, 'Yangoon', 39)
  102. INTO city (city_id, city_name, country_id) VALUES (20, 'Taipei', 225)
  103. INTO city (city_id, city_name, country_id) VALUES (21, 'Lahore', 178)
  104. INTO city (city_id, city_name, country_id) VALUES (22, 'Damascus', 224)
  105. INTO city (city_id, city_name, country_id) VALUES (23, 'Tbilisi', 89)
  106. INTO city (city_id, city_name, country_id) VALUES (24, 'Kuala Lumpur', 145)
  107. INTO city (city_id, city_name, country_id) VALUES (25, 'Hanoi', 249)
  108. INTO city (city_id, city_name, country_id) VALUES (26, 'Bangalore', 111)
  109. INTO city (city_id, city_name, country_id) VALUES (27, 'Vientiane', 132)
  110. INTO city (city_id, city_name, country_id) VALUES (28, 'Ho Chi Minh City', 249)
  111. INTO city (city_id, city_name, country_id) VALUES (29, 'Muscat', 177)
  112. INTO city (city_id, city_name, country_id) VALUES (30, 'Doha', 190)
  113. INTO city (city_id, city_name, country_id) VALUES (31, 'Quezon City', 185)
  114. INTO city (city_id, city_name, country_id) VALUES (32, 'Makati City', 185)
  115. INTO city (city_id, city_name, country_id) VALUES (33, 'Davao City', 185)
  116. INTO city (city_id, city_name, country_id) VALUES (34, 'Cebu City', 185)
  117. INTO city (city_id, city_name, country_id) VALUES (35, 'Sydney', 15)
  118. INTO city (city_id, city_name, country_id) VALUES (36, 'Auckland', 169)
  119. INTO city (city_id, city_name, country_id) VALUES (37, 'Brisbane', 15)
  120. INTO city (city_id, city_name, country_id) VALUES (38, 'Beirut', 134)
  121. INTO city (city_id, city_name, country_id) VALUES (39, 'Istanbul', 236)
  122. INTO city (city_id, city_name, country_id) VALUES (40, 'Singapore City', 208)
  123. INTO city (city_id, city_name, country_id) VALUES (41, 'Jeddah', 203)
  124. INTO city (city_id, city_name, country_id) VALUES (42, 'Riyadg', 203)
  125. INTO city (city_id, city_name, country_id) VALUES (43, 'Tel Aviv', 117)
  126. INTO city (city_id, city_name, country_id) VALUES (44, 'Bahgdad', 114)
  127. INTO city (city_id, city_name, country_id) VALUES (45, 'Yokohama', 121)
  128. INTO city (city_id, city_name, country_id) VALUES (46, 'Akita', 121)
  129. INTO city (city_id, city_name, country_id) VALUES (47, 'Manama', 19)
  130. INTO city (city_id, city_name, country_id) VALUES (48, 'Phnom Penh', 41)
  131. INTO city (city_id, city_name, country_id) VALUES (49, 'Phuket', 228)
  132. INTO city (city_id, city_name, country_id) VALUES (50, 'Sanaa', 255)
  133. INTO city (city_id, city_name, country_id) VALUES (51, 'Mexico City', 154)
  134. INTO city (city_id, city_name, country_id) VALUES (52, 'Sao Paulo', 33)
  135. INTO city (city_id, city_name, country_id) VALUES (53, 'New York City', 244)
  136. INTO city (city_id, city_name, country_id) VALUES (54, 'Buenos Aires', 11)
  137. INTO city (city_id, city_name, country_id) VALUES (55, 'Los Angeles', 244)
  138. INTO city (city_id, city_name, country_id) VALUES (56, 'Rio de Janeiro', 33)
  139. INTO city (city_id, city_name, country_id) VALUES (57, 'Chicago', 244)
  140. INTO city (city_id, city_name, country_id) VALUES (58, 'Bogota', 53)
  141. INTO city (city_id, city_name, country_id) VALUES (59, 'Lima', 184)
  142. INTO city (city_id, city_name, country_id) VALUES (60, 'Arequipa', 184)
  143. INTO city (city_id, city_name, country_id) VALUES (61, 'Paramaribo', 219)
  144. INTO city (city_id, city_name, country_id) VALUES (62, 'Santiago', 48)
  145. INTO city (city_id, city_name, country_id) VALUES (63, 'Soledad', 53)
  146. INTO city (city_id, city_name, country_id) VALUES (64, 'Toronto', 43)
  147. INTO city (city_id, city_name, country_id) VALUES (65, 'Asuncion', 183)
  148. INTO city (city_id, city_name, country_id) VALUES (66, 'Miami', 244)
  149. INTO city (city_id, city_name, country_id) VALUES (67, 'Nassau', 18)
  150. INTO city (city_id, city_name, country_id) VALUES (68, 'El Bosque', 48)
  151. INTO city (city_id, city_name, country_id) VALUES (69, 'Port-au-Prince', 104)
  152. INTO city (city_id, city_name, country_id) VALUES (70, 'Kingston', 119)
  153. INTO city (city_id, city_name, country_id) VALUES (71, 'Portmore', 199)
  154. INTO city (city_id, city_name, country_id) VALUES (72, 'Guadalajara', 154)
  155. INTO city (city_id, city_name, country_id) VALUES (73, 'Caracas', 248)
  156. INTO city (city_id, city_name, country_id) VALUES (74, 'Cottica', 219)
  157. INTO city (city_id, city_name, country_id) VALUES (75, 'San Juan', 189)
  158. INTO city (city_id, city_name, country_id) VALUES (76, 'Concepcion', 48)
  159. INTO city (city_id, city_name, country_id) VALUES (77, 'Montreal', 43)
  160. INTO city (city_id, city_name, country_id) VALUES (78, 'Monterrey', 154)
  161. INTO city (city_id, city_name, country_id) VALUES (79, 'Recife', 33)
  162. INTO city (city_id, city_name, country_id) VALUES (80, 'Valencia', 248)
  163. INTO city (city_id, city_name, country_id) VALUES (81, 'Brasilia', 33)
  164. INTO city (city_id, city_name, country_id) VALUES (82, 'Medellin', 53)
  165. INTO city (city_id, city_name, country_id) VALUES (83, 'Tegucigalpa', 107)
  166. INTO city (city_id, city_name, country_id) VALUES (84, 'Quito', 70)
  167. INTO city (city_id, city_name, country_id) VALUES (85, 'Santo Domingo', 69)
  168. INTO city (city_id, city_name, country_id) VALUES (86, 'Cuenca', 70)
  169. INTO city (city_id, city_name, country_id) VALUES (87, 'Curitiba', 33)
  170. INTO city (city_id, city_name, country_id) VALUES (88, 'Choloma', 107)
  171. INTO city (city_id, city_name, country_id) VALUES (89, 'Guatemala City', 99)
  172. INTO city (city_id, city_name, country_id) VALUES (90, 'Rosario', 11)
  173. INTO city (city_id, city_name, country_id) VALUES (91, 'Tampa', 244)
  174. INTO city (city_id, city_name, country_id) VALUES (92, 'Cali', 53)
  175. INTO city (city_id, city_name, country_id) VALUES (93, 'Mendoza', 11)
  176. INTO city (city_id, city_name, country_id) VALUES (94, 'Guayaquil', 70)
  177. INTO city (city_id, city_name, country_id) VALUES (95, 'San Juan', 189)
  178. INTO city (city_id, city_name, country_id) VALUES (96, 'Montevideo', 245)
  179. INTO city (city_id, city_name, country_id) VALUES (97, 'Havana', 62)
  180. INTO city (city_id, city_name, country_id) VALUES (98, 'Puebla', 154)
  181. INTO city (city_id, city_name, country_id) VALUES (99, 'San Jose', 59)
  182. INTO city (city_id, city_name, country_id) VALUES (100, 'Vancouver', 43)
  183. INTO city (city_id, city_name, country_id) VALUES (101, 'Cairo', 71)
  184. INTO city (city_id, city_name, country_id) VALUES (102, 'Lagos', 172)
  185. INTO city (city_id, city_name, country_id) VALUES (103, 'Kinshasa', 55)
  186. INTO city (city_id, city_name, country_id) VALUES (104, 'Johannesburg', 213)
  187. INTO city (city_id, city_name, country_id) VALUES (105, 'Khartoum-Umm Durman', 218)
  188. INTO city (city_id, city_name, country_id) VALUES (106, 'Alexandria', 71)
  189. INTO city (city_id, city_name, country_id) VALUES (107, 'Abidjan', 60)
  190. INTO city (city_id, city_name, country_id) VALUES (108, 'Casablanca', 160)
  191. INTO city (city_id, city_name, country_id) VALUES (109, 'Cape Town', 213)
  192. INTO city (city_id, city_name, country_id) VALUES (110, 'Durban', 213)
  193. INTO city (city_id, city_name, country_id) VALUES (111, 'Accra', 91)
  194. INTO city (city_id, city_name, country_id) VALUES (112, 'Nairobi', 126)
  195. INTO city (city_id, city_name, country_id) VALUES (113, 'Kano', 172)
  196. INTO city (city_id, city_name, country_id) VALUES (114, 'Ibadan', 172)
  197. INTO city (city_id, city_name, country_id) VALUES (115, 'Dar es Salaam', 227)
  198. INTO city (city_id, city_name, country_id) VALUES (116, 'Algiers', 4)
  199. INTO city (city_id, city_name, country_id) VALUES (117, 'Addis Ababa', 76)
  200. INTO city (city_id, city_name, country_id) VALUES (118, 'Luanda', 7)
  201. INTO city (city_id, city_name, country_id) VALUES (119, 'Dakar', 204)
  202. INTO city (city_id, city_name, country_id) VALUES (120, 'Pretoria', 213)
  203. INTO city (city_id, city_name, country_id) VALUES (121, 'Tunis', 235)
  204. INTO city (city_id, city_name, country_id) VALUES (122, 'Harare', 257)
  205. INTO city (city_id, city_name, country_id) VALUES (123, 'Douala', 42)
  206. INTO city (city_id, city_name, country_id) VALUES (124, 'Abuja', 172)
  207. INTO city (city_id, city_name, country_id) VALUES (125, 'Kampala', 240)
  208. INTO city (city_id, city_name, country_id) VALUES (126, 'Bamako', 147)
  209. INTO city (city_id, city_name, country_id) VALUES (127, 'Maputo', 161)
  210. INTO city (city_id, city_name, country_id) VALUES (128, 'Rabat', 160)
  211. INTO city (city_id, city_name, country_id) VALUES (129, 'Antananarivo', 143)
  212. INTO city (city_id, city_name, country_id) VALUES (130, 'Lusaka', 256)
  213. INTO city (city_id, city_name, country_id) VALUES (131, 'Yaounde', 42)
  214. INTO city (city_id, city_name, country_id) VALUES (132, 'Ouagadougou', 38)
  215. INTO city (city_id, city_name, country_id) VALUES (133, 'Conakry', 101)
  216. INTO city (city_id, city_name, country_id) VALUES (134, 'Kaduna', 172)
  217. INTO city (city_id, city_name, country_id) VALUES (135, 'Kumasi', 91)
  218. INTO city (city_id, city_name, country_id) VALUES (136, 'Lubumbashi', 55)
  219. INTO city (city_id, city_name, country_id) VALUES (137, 'Monrovia', 136)
  220. INTO city (city_id, city_name, country_id) VALUES (138, 'Mogadishu', 212)
  221. INTO city (city_id, city_name, country_id) VALUES (139, 'Brazzaville', 56)
  222. INTO city (city_id, city_name, country_id) VALUES (140, 'Oran', 4)
  223. INTO city (city_id, city_name, country_id) VALUES (141, 'Benin', 172)
  224. INTO city (city_id, city_name, country_id) VALUES (142, 'Tripoli', 137)
  225. INTO city (city_id, city_name, country_id) VALUES (143, 'Freetown', 207)
  226. INTO city (city_id, city_name, country_id) VALUES (144, 'Cotonou', 26)
  227. INTO city (city_id, city_name, country_id) VALUES (145, 'Vereeniging', 213)
  228. INTO city (city_id, city_name, country_id) VALUES (146, 'Fes', 160)
  229. INTO city (city_id, city_name, country_id) VALUES (147, 'Maiduguri', 172)
  230. INTO city (city_id, city_name, country_id) VALUES (148, 'Huambo', 7)
  231. INTO city (city_id, city_name, country_id) VALUES (149, 'Ogbomosho', 172)
  232. INTO city (city_id, city_name, country_id) VALUES (150, 'Ndjamena', 47)
  233. INTO city (city_id, city_name, country_id) VALUES (151, 'London', 243)
  234. INTO city (city_id, city_name, country_id) VALUES (152, 'Berlin', 90)
  235. INTO city (city_id, city_name, country_id) VALUES (153, 'Madrid', 215)
  236. INTO city (city_id, city_name, country_id) VALUES (154, 'Rome', 118)
  237. INTO city (city_id, city_name, country_id) VALUES (155, 'Paris', 82)
  238. INTO city (city_id, city_name, country_id) VALUES (156, 'Bucharest', 192)
  239. INTO city (city_id, city_name, country_id) VALUES (157, 'Warsaw', 187)
  240. INTO city (city_id, city_name, country_id) VALUES (158, 'Hamburg', 90)
  241. INTO city (city_id, city_name, country_id) VALUES (159, 'Budapest', 109)
  242. INTO city (city_id, city_name, country_id) VALUES (160, 'Vienna', 16)
  243. INTO city (city_id, city_name, country_id) VALUES (161, 'Waterford', 115)
  244. INTO city (city_id, city_name, country_id) VALUES (162, 'Sofia', 37)
  245. INTO city (city_id, city_name, country_id) VALUES (163, 'Munich', 90)
  246. INTO city (city_id, city_name, country_id) VALUES (164, 'Prague', 64)
  247. INTO city (city_id, city_name, country_id) VALUES (165, 'Milan', 118)
  248. INTO city (city_id, city_name, country_id) VALUES (166, 'Copenhagen', 65)
  249. INTO city (city_id, city_name, country_id) VALUES (167, 'Brussels', 24)
  250. INTO city (city_id, city_name, country_id) VALUES (168, 'Zurich', 223)
  251. INTO city (city_id, city_name, country_id) VALUES (169, 'Naples', 118)
  252. INTO city (city_id, city_name, country_id) VALUES (170, 'Cologne', 90)
  253. INTO city (city_id, city_name, country_id) VALUES (171, 'Geneva', 223)
  254. INTO city (city_id, city_name, country_id) VALUES (172, 'Valencia', 215)
  255. INTO city (city_id, city_name, country_id) VALUES (173, 'Marseille', 82)
  256. INTO city (city_id, city_name, country_id) VALUES (174, 'Stockholm', 222)
  257. INTO city (city_id, city_name, country_id) VALUES (175, 'Krakow', 187)
  258. INTO city (city_id, city_name, country_id) VALUES (176, 'Lodz', 187)
  259. INTO city (city_id, city_name, country_id) VALUES (177, 'Amsterdam', 166)
  260. INTO city (city_id, city_name, country_id) VALUES (178, 'Riga', 133)
  261. INTO city (city_id, city_name, country_id) VALUES (179, 'Athens', 94)
  262. INTO city (city_id, city_name, country_id) VALUES (180, 'Seville', 215)
  263. INTO city (city_id, city_name, country_id) VALUES (181, 'Palermo', 118)
  264. INTO city (city_id, city_name, country_id) VALUES (182, 'Wroclaw', 187)
  265. INTO city (city_id, city_name, country_id) VALUES (183, 'Zaragoza', 215)
  266. INTO city (city_id, city_name, country_id) VALUES (184, 'Luxembourg', 140)
  267. INTO city (city_id, city_name, country_id) VALUES (185, 'Oslo', 176)
  268. INTO city (city_id, city_name, country_id) VALUES (186, 'Glasgow', 243)
  269. INTO city (city_id, city_name, country_id) VALUES (187, 'Nicosia', 63)
  270. INTO city (city_id, city_name, country_id) VALUES (188, 'Helsinki', 81)
  271. INTO city (city_id, city_name, country_id) VALUES (189, 'Vilnius', 139)
  272. INTO city (city_id, city_name, country_id) VALUES (190, 'Rotterdam', 166)
  273. INTO city (city_id, city_name, country_id) VALUES (191, 'Salzburg', 16)
  274. INTO city (city_id, city_name, country_id) VALUES (192, 'Hanover', 90)
  275. INTO city (city_id, city_name, country_id) VALUES (193, 'Lisbon', 188)
  276. INTO city (city_id, city_name, country_id) VALUES (194, 'Gothenburg', 222)
  277. INTO city (city_id, city_name, country_id) VALUES (195, 'Dublin', 115)
  278. INTO city (city_id, city_name, country_id) VALUES (196, 'Brno', 64)
  279. INTO city (city_id, city_name, country_id) VALUES (197, 'Plovdiv', 37)
  280. INTO city (city_id, city_name, country_id) VALUES (198, 'Tallinn', 75)
  281. INTO city (city_id, city_name, country_id) VALUES (199, 'Graz', 16)
  282. INTO city (city_id, city_name, country_id) VALUES (200, 'Burgas', 37)
  283. INTO city (city_id, city_name, country_id) VALUES (201, 'Valenzuela City', 185)
  284. INTO city (city_id, city_name, country_id) VALUES (202, 'Antipolo City', 185)
  285. INTO city (city_id, city_name, country_id) VALUES (203, 'Taguig City', 185)
  286. INTO city (city_id, city_name, country_id) VALUES (204, 'Caloocan City', 185)
  287. INTO city (city_id, city_name, country_id) VALUES (205, 'Mandaluyong City', 185)
  288. INTO city (city_id, city_name, country_id) VALUES (206, 'San Juan City', 185)
  289. INTO city (city_id, city_name, country_id) VALUES (207, 'Las Pinas City', 185)
  290. SELECT 1 FROM DUAL;
  291.  
  292.  
  293. INSERT ALL
  294. INTO country (country_id, country_name) VALUES (1, 'Afghanistan')
  295. INTO country (country_id, country_name) VALUES (2, 'Akrotiri')
  296. INTO country (country_id, country_name) VALUES (3, 'Albania')
  297. INTO country (country_id, country_name) VALUES (4, 'Algeria')
  298. INTO country (country_id, country_name) VALUES (5, 'American Samoa')
  299. INTO country (country_id, country_name) VALUES (6, 'Andorra')
  300. INTO country (country_id, country_name) VALUES (7, 'Angola')
  301. INTO country (country_id, country_name) VALUES (8, 'Anguilla')
  302. INTO country (country_id, country_name) VALUES (9, 'Antarctica')
  303. INTO country (country_id, country_name) VALUES (10, 'Antigua and Barbuda')
  304. INTO country (country_id, country_name) VALUES (11, 'Argentina')
  305. INTO country (country_id, country_name) VALUES (12, 'Armenia')
  306. INTO country (country_id, country_name) VALUES (13, 'Aruba')
  307. INTO country (country_id, country_name) VALUES (14, 'Ashmore and Cartier Islands')
  308. INTO country (country_id, country_name) VALUES (15, 'Australia')
  309. INTO country (country_id, country_name) VALUES (16, 'Austria')
  310. INTO country (country_id, country_name) VALUES (17, 'Azerbaijan')
  311. INTO country (country_id, country_name) VALUES (18, 'Bahamas, The')
  312. INTO country (country_id, country_name) VALUES (19, 'Bahrain')
  313. INTO country (country_id, country_name) VALUES (20, 'Bangladesh')
  314. INTO country (country_id, country_name) VALUES (21, 'Barbados')
  315. INTO country (country_id, country_name) VALUES (22, 'Bassas da India')
  316. INTO country (country_id, country_name) VALUES (23, 'Belarus')
  317. INTO country (country_id, country_name) VALUES (24, 'Belgium')
  318. INTO country (country_id, country_name) VALUES (25, 'Belize')
  319. INTO country (country_id, country_name) VALUES (26, 'Benin')
  320. INTO country (country_id, country_name) VALUES (27, 'Bermuda')
  321. INTO country (country_id, country_name) VALUES (28, 'Bhutan')
  322. INTO country (country_id, country_name) VALUES (29, 'Bolivia')
  323. INTO country (country_id, country_name) VALUES (30, 'Bosnia and Herzegovina')
  324. INTO country (country_id, country_name) VALUES (31, 'Botswana')
  325. INTO country (country_id, country_name) VALUES (32, 'Bouvet Island')
  326. INTO country (country_id, country_name) VALUES (33, 'Brazil')
  327. INTO country (country_id, country_name) VALUES (34, 'British Indian Ocean Territory')
  328. INTO country (country_id, country_name) VALUES (35, 'British Virgin Islands')
  329. INTO country (country_id, country_name) VALUES (36, 'Brunei')
  330. INTO country (country_id, country_name) VALUES (37, 'Bulgaria')
  331. INTO country (country_id, country_name) VALUES (38, 'Burkina Faso')
  332. INTO country (country_id, country_name) VALUES (39, 'Burma')
  333. INTO country (country_id, country_name) VALUES (40, 'Burundi')
  334. INTO country (country_id, country_name) VALUES (41, 'Cambodia')
  335. INTO country (country_id, country_name) VALUES (42, 'Cameroon')
  336. INTO country (country_id, country_name) VALUES (43, 'Canada')
  337. INTO country (country_id, country_name) VALUES (44, 'Cape Verde')
  338. INTO country (country_id, country_name) VALUES (45, 'Cayman Islands')
  339. INTO country (country_id, country_name) VALUES (46, 'Central African Republic')
  340. INTO country (country_id, country_name) VALUES (47, 'Chad')
  341. INTO country (country_id, country_name) VALUES (48, 'Chile')
  342. INTO country (country_id, country_name) VALUES (49, 'China')
  343. INTO country (country_id, country_name) VALUES (50, 'Christmas Island')
  344. INTO country (country_id, country_name) VALUES (51, 'Clipperton Island')
  345. INTO country (country_id, country_name) VALUES (52, 'Cocos (Keeling) Islands')
  346. INTO country (country_id, country_name) VALUES (53, 'Colombia')
  347. INTO country (country_id, country_name) VALUES (54, 'Comoros')
  348. INTO country (country_id, country_name) VALUES (55, 'Congo, Democratic Republic of the')
  349. INTO country (country_id, country_name) VALUES (56, 'Congo, Republic of the')
  350. INTO country (country_id, country_name) VALUES (57, 'Cook Islands')
  351. INTO country (country_id, country_name) VALUES (58, 'Coral Sea Islands')
  352. INTO country (country_id, country_name) VALUES (59, 'Costa Rica')
  353. INTO country (country_id, country_name) VALUES (60, 'Cote d Ivoire')
  354. INTO country (country_id, country_name) VALUES (61, 'Croatia')
  355. INTO country (country_id, country_name) VALUES (62, 'Cuba')
  356. INTO country (country_id, country_name) VALUES (63, 'Cyprus')
  357. INTO country (country_id, country_name) VALUES (64, 'Czech Republic')
  358. INTO country (country_id, country_name) VALUES (65, 'Denmark')
  359. INTO country (country_id, country_name) VALUES (66, 'Dhekelia')
  360. INTO country (country_id, country_name) VALUES (67, 'Djibouti')
  361. INTO country (country_id, country_name) VALUES (68, 'Dominica')
  362. INTO country (country_id, country_name) VALUES (69, 'Dominican Republic')
  363. INTO country (country_id, country_name) VALUES (70, 'Ecuador')
  364. INTO country (country_id, country_name) VALUES (71, 'Egypt')
  365. INTO country (country_id, country_name) VALUES (72, 'El Salvador')
  366. INTO country (country_id, country_name) VALUES (73, 'Equatorial Guinea')
  367. INTO country (country_id, country_name) VALUES (74, 'Eritrea')
  368. INTO country (country_id, country_name) VALUES (75, 'Estonia')
  369. INTO country (country_id, country_name) VALUES (76, 'Ethiopia')
  370. INTO country (country_id, country_name) VALUES (77, 'Europa Island')
  371. INTO country (country_id, country_name) VALUES (78, 'Falkland Islands (Islas Malvinas)')
  372. INTO country (country_id, country_name) VALUES (79, 'Faroe Islands')
  373. INTO country (country_id, country_name) VALUES (80, 'Fiji')
  374. INTO country (country_id, country_name) VALUES (81, 'Finland')
  375. INTO country (country_id, country_name) VALUES (82, 'France')
  376. INTO country (country_id, country_name) VALUES (83, 'French Guiana')
  377. INTO country (country_id, country_name) VALUES (84, 'French Polynesia')
  378. INTO country (country_id, country_name) VALUES (85, 'French Southern and Antarctic Lands')
  379. INTO country (country_id, country_name) VALUES (86, 'Gabon')
  380. INTO country (country_id, country_name) VALUES (87, 'Gambia, The')
  381. INTO country (country_id, country_name) VALUES (88, 'Gaza Strip')
  382. INTO country (country_id, country_name) VALUES (89, 'Georgia')
  383. INTO country (country_id, country_name) VALUES (90, 'Germany')
  384. INTO country (country_id, country_name) VALUES (91, 'Ghana')
  385. INTO country (country_id, country_name) VALUES (92, 'Gibraltar')
  386. INTO country (country_id, country_name) VALUES (93, 'Glorioso Islands')
  387. INTO country (country_id, country_name) VALUES (94, 'Greece')
  388. INTO country (country_id, country_name) VALUES (95, 'Greenland')
  389. INTO country (country_id, country_name) VALUES (96, 'Grenada')
  390. INTO country (country_id, country_name) VALUES (97, 'Guadeloupe')
  391. INTO country (country_id, country_name) VALUES (98, 'Guam')
  392. INTO country (country_id, country_name) VALUES (99, 'Guatemala')
  393. INTO country (country_id, country_name) VALUES (100, 'Guernsey')
  394. INTO country (country_id, country_name) VALUES (101, 'Guinea')
  395. INTO country (country_id, country_name) VALUES (102, 'Guinea-Bissau')
  396. INTO country (country_id, country_name) VALUES (103, 'Guyana')
  397. INTO country (country_id, country_name) VALUES (104, 'Haiti')
  398. INTO country (country_id, country_name) VALUES (105, 'Heard Island and McDonald Islands')
  399. INTO country (country_id, country_name) VALUES (106, 'Holy See (Vatican City)')
  400. INTO country (country_id, country_name) VALUES (107, 'Honduras')
  401. INTO country (country_id, country_name) VALUES (108, 'Hong Kong')
  402. INTO country (country_id, country_name) VALUES (109, 'Hungary')
  403. INTO country (country_id, country_name) VALUES (110, 'Iceland')
  404. INTO country (country_id, country_name) VALUES (111, 'India')
  405. INTO country (country_id, country_name) VALUES (112, 'Indonesia')
  406. INTO country (country_id, country_name) VALUES (113, 'Iran')
  407. INTO country (country_id, country_name) VALUES (114, 'Iraq')
  408. INTO country (country_id, country_name) VALUES (115, 'Ireland')
  409. INTO country (country_id, country_name) VALUES (116, 'Isle of Man')
  410. INTO country (country_id, country_name) VALUES (117, 'Israel')
  411. INTO country (country_id, country_name) VALUES (118, 'Italy')
  412. INTO country (country_id, country_name) VALUES (119, 'Jamaica')
  413. INTO country (country_id, country_name) VALUES (120, 'Jan Mayen')
  414. INTO country (country_id, country_name) VALUES (121, 'Japan')
  415. INTO country (country_id, country_name) VALUES (122, 'Jersey')
  416. INTO country (country_id, country_name) VALUES (123, 'Jordan')
  417. INTO country (country_id, country_name) VALUES (124, 'Juan de Nova Island')
  418. INTO country (country_id, country_name) VALUES (125, 'Kazakhstan')
  419. INTO country (country_id, country_name) VALUES (126, 'Kenya')
  420. INTO country (country_id, country_name) VALUES (127, 'Kiribati')
  421. INTO country (country_id, country_name) VALUES (128, 'Korea, North')
  422. INTO country (country_id, country_name) VALUES (129, 'Korea, South')
  423. INTO country (country_id, country_name) VALUES (130, 'Kuwait')
  424. INTO country (country_id, country_name) VALUES (131, 'Kyrgyzstan')
  425. INTO country (country_id, country_name) VALUES (132, 'Laos')
  426. INTO country (country_id, country_name) VALUES (133, 'Latvia')
  427. INTO country (country_id, country_name) VALUES (134, 'Lebanon')
  428. INTO country (country_id, country_name) VALUES (135, 'Lesotho')
  429. INTO country (country_id, country_name) VALUES (136, 'Liberia')
  430. INTO country (country_id, country_name) VALUES (137, 'Libya')
  431. INTO country (country_id, country_name) VALUES (138, 'Liechtenstein')
  432. INTO country (country_id, country_name) VALUES (139, 'Lithuania')
  433. INTO country (country_id, country_name) VALUES (140, 'Luxembourg')
  434. INTO country (country_id, country_name) VALUES (141, 'Macau')
  435. INTO country (country_id, country_name) VALUES (142, 'Macedonia')
  436. INTO country (country_id, country_name) VALUES (143, 'Madagascar')
  437. INTO country (country_id, country_name) VALUES (144, 'Malawi')
  438. INTO country (country_id, country_name) VALUES (145, 'Malaysia')
  439. INTO country (country_id, country_name) VALUES (146, 'Maldives')
  440. INTO country (country_id, country_name) VALUES (147, 'Mali')
  441. INTO country (country_id, country_name) VALUES (148, 'Malta')
  442. INTO country (country_id, country_name) VALUES (149, 'Marshall Islands')
  443. INTO country (country_id, country_name) VALUES (150, 'Martinique')
  444. INTO country (country_id, country_name) VALUES (151, 'Mauritania')
  445. INTO country (country_id, country_name) VALUES (152, 'Mauritius')
  446. INTO country (country_id, country_name) VALUES (153, 'Mayotte')
  447. INTO country (country_id, country_name) VALUES (154, 'Mexico')
  448. INTO country (country_id, country_name) VALUES (155, 'Micronesia, Federated States of')
  449. INTO country (country_id, country_name) VALUES (156, 'Moldova')
  450. INTO country (country_id, country_name) VALUES (157, 'Monaco')
  451. INTO country (country_id, country_name) VALUES (158, 'Mongolia')
  452. INTO country (country_id, country_name) VALUES (159, 'Montserrat')
  453. INTO country (country_id, country_name) VALUES (160, 'Morocco')
  454. INTO country (country_id, country_name) VALUES (161, 'Mozambique')
  455. INTO country (country_id, country_name) VALUES (162, 'Namibia')
  456. INTO country (country_id, country_name) VALUES (163, 'Nauru')
  457. INTO country (country_id, country_name) VALUES (164, 'Navassa Island')
  458. INTO country (country_id, country_name) VALUES (165, 'Nepal')
  459. INTO country (country_id, country_name) VALUES (166, 'Netherlands')
  460. INTO country (country_id, country_name) VALUES (167, 'Netherlands Antilles')
  461. INTO country (country_id, country_name) VALUES (168, 'New Caledonia')
  462. INTO country (country_id, country_name) VALUES (169, 'New Zealand')
  463. INTO country (country_id, country_name) VALUES (170, 'Nicaragua')
  464. INTO country (country_id, country_name) VALUES (171, 'Niger')
  465. INTO country (country_id, country_name) VALUES (172, 'Nigeria')
  466. INTO country (country_id, country_name) VALUES (173, 'Niue')
  467. INTO country (country_id, country_name) VALUES (174, 'Norfolk Island')
  468. INTO country (country_id, country_name) VALUES (175, 'Northern Mariana Islands')
  469. INTO country (country_id, country_name) VALUES (176, 'Norway')
  470. INTO country (country_id, country_name) VALUES (177, 'Oman')
  471. INTO country (country_id, country_name) VALUES (178, 'Pakistan')
  472. INTO country (country_id, country_name) VALUES (179, 'Palau')
  473. INTO country (country_id, country_name) VALUES (180, 'Panama')
  474. INTO country (country_id, country_name) VALUES (181, 'Papua New Guinea')
  475. INTO country (country_id, country_name) VALUES (182, 'Paracel Islands')
  476. INTO country (country_id, country_name) VALUES (183, 'Paraguay')
  477. INTO country (country_id, country_name) VALUES (184, 'Peru')
  478. INTO country (country_id, country_name) VALUES (185, 'Philippines')
  479. INTO country (country_id, country_name) VALUES (186, 'Pitcairn Islands')
  480. INTO country (country_id, country_name) VALUES (187, 'Poland')
  481. INTO country (country_id, country_name) VALUES (188, 'Portugal')
  482. INTO country (country_id, country_name) VALUES (189, 'Puerto Rico')
  483. INTO country (country_id, country_name) VALUES (190, 'Qatar')
  484. INTO country (country_id, country_name) VALUES (191, 'Reunion')
  485. INTO country (country_id, country_name) VALUES (192, 'Romania')
  486. INTO country (country_id, country_name) VALUES (193, 'Russia')
  487. INTO country (country_id, country_name) VALUES (194, 'Rwanda')
  488. INTO country (country_id, country_name) VALUES (195, 'Saint Helena')
  489. INTO country (country_id, country_name) VALUES (196, 'Saint Kitts and Nevis')
  490. INTO country (country_id, country_name) VALUES (197, 'Saint Lucia')
  491. INTO country (country_id, country_name) VALUES (198, 'Saint Pierre and Miquelon')
  492. INTO country (country_id, country_name) VALUES (199, 'Saint Vincent and the Grenadines')
  493. INTO country (country_id, country_name) VALUES (200, 'Samoa')
  494. INTO country (country_id, country_name) VALUES (201, 'San Marino')
  495. INTO country (country_id, country_name) VALUES (202, 'Sao Tome and Principe')
  496. INTO country (country_id, country_name) VALUES (203, 'Saudi Arabia')
  497. INTO country (country_id, country_name) VALUES (204, 'Senegal')
  498. INTO country (country_id, country_name) VALUES (205, 'Serbia and Montenegro')
  499. INTO country (country_id, country_name) VALUES (206, 'Seychelles')
  500. INTO country (country_id, country_name) VALUES (207, 'Sierra Leone')
  501. INTO country (country_id, country_name) VALUES (208, 'Singapore')
  502. INTO country (country_id, country_name) VALUES (209, 'Slovakia')
  503. INTO country (country_id, country_name) VALUES (210, 'Slovenia')
  504. INTO country (country_id, country_name) VALUES (211, 'Solomon Islands')
  505. INTO country (country_id, country_name) VALUES (212, 'Somalia')
  506. INTO country (country_id, country_name) VALUES (213, 'South Africa')
  507. INTO country (country_id, country_name) VALUES (214, 'South Georgia and the South Sandwich Islands')
  508. INTO country (country_id, country_name) VALUES (215, 'Spain')
  509. INTO country (country_id, country_name) VALUES (216, 'Spratly Islands')
  510. INTO country (country_id, country_name) VALUES (217, 'Sri Lanka')
  511. INTO country (country_id, country_name) VALUES (218, 'Sudan')
  512. INTO country (country_id, country_name) VALUES (219, 'Suriname')
  513. INTO country (country_id, country_name) VALUES (220, 'Svalbard')
  514. INTO country (country_id, country_name) VALUES (221, 'Swaziland')
  515. INTO country (country_id, country_name) VALUES (222, 'Sweden')
  516. INTO country (country_id, country_name) VALUES (223, 'Switzerland')
  517. INTO country (country_id, country_name) VALUES (224, 'Syria')
  518. INTO country (country_id, country_name) VALUES (225, 'Taiwan')
  519. INTO country (country_id, country_name) VALUES (226, 'Tajikistan')
  520. INTO country (country_id, country_name) VALUES (227, 'Tanzania')
  521. INTO country (country_id, country_name) VALUES (228, 'Thailand')
  522. INTO country (country_id, country_name) VALUES (229, 'Timor-Leste')
  523. INTO country (country_id, country_name) VALUES (230, 'Togo')
  524. INTO country (country_id, country_name) VALUES (231, 'Tokelau')
  525. INTO country (country_id, country_name) VALUES (232, 'Tonga')
  526. INTO country (country_id, country_name) VALUES (233, 'Trinidad and Tobago')
  527. INTO country (country_id, country_name) VALUES (234, 'Tromelin Island')
  528. INTO country (country_id, country_name) VALUES (235, 'Tunisia')
  529. INTO country (country_id, country_name) VALUES (236, 'Turkey')
  530. INTO country (country_id, country_name) VALUES (237, 'Turkmenistan')
  531. INTO country (country_id, country_name) VALUES (238, 'Turks and Caicos Islands')
  532. INTO country (country_id, country_name) VALUES (239, 'Tuvalu')
  533. INTO country (country_id, country_name) VALUES (240, 'Uganda')
  534. INTO country (country_id, country_name) VALUES (241, 'Ukraine')
  535. INTO country (country_id, country_name) VALUES (242, 'United Arab Emirates')
  536. INTO country (country_id, country_name) VALUES (243, 'United Kingdom')
  537. INTO country (country_id, country_name) VALUES (244, 'United States')
  538. INTO country (country_id, country_name) VALUES (245, 'Uruguay')
  539. INTO country (country_id, country_name) VALUES (246, 'Uzbekistan')
  540. INTO country (country_id, country_name) VALUES (247, 'Vanuatu')
  541. INTO country (country_id, country_name) VALUES (248, 'Venezuela')
  542. INTO country (country_id, country_name) VALUES (249, 'Vietnam')
  543. INTO country (country_id, country_name) VALUES (250, 'Virgin Islands')
  544. INTO country (country_id, country_name) VALUES (251, 'Wake Island')
  545. INTO country (country_id, country_name) VALUES (252, 'Wallis and Futuna')
  546. INTO country (country_id, country_name) VALUES (253, 'West Bank')
  547. INTO country (country_id, country_name) VALUES (254, 'Western Sahara')
  548. INTO country (country_id, country_name) VALUES (255, 'Yemen')
  549. INTO country (country_id, country_name) VALUES (256, 'Zambia')
  550. INTO country (country_id, country_name) VALUES (257, 'Zimbabwe')
  551. SELECT 1 FROM DUAL;
  552.  
  553.  
  554. INSERT ALL
  555. INTO job_type(id, type) VALUES (1, 'Full Time')
  556. INTO job_type(id, type) VALUES (2, 'Part Time')
  557. INTO job_type(id, type) VALUES (3, 'Internship')
  558. INTO job_type(id, type) VALUES (4, 'Volunteer')
  559. INTO job_type(id, type) VALUES (5, 'Contractual')
  560. INTO job_type(id, type) VALUES (6, 'Commission')
  561. SELECT 1 FROM DUAL;
  562.  
  563.  
  564. INSERT ALL
  565. INTO job_industry(id, industry) VALUES (1, 'Accounting & Finance')
  566. INTO job_industry(id, industry) VALUES (2, 'Administrative')
  567. INTO job_industry(id, industry) VALUES (3, 'Architecture & Construction')
  568. INTO job_industry(id, industry) VALUES (4, 'Art & Design')
  569. INTO job_industry(id, industry) VALUES (5, 'Education & Training')
  570. INTO job_industry(id, industry) VALUES (6, 'Engineering')
  571. INTO job_industry(id, industry) VALUES (7, 'General Employment')
  572. INTO job_industry(id, industry) VALUES (8, 'Healthcare')
  573. INTO job_industry(id, industry) VALUES (9, 'Hospitality & Travel')
  574. INTO job_industry(id, industry) VALUES (10, 'Information Technology')
  575. INTO job_industry(id, industry) VALUES (11, 'Manufacturing')
  576. INTO job_industry(id, industry) VALUES (12, 'Media & Journalism')
  577. INTO job_industry(id, industry) VALUES (13, 'Professional Service')
  578. INTO job_industry(id, industry) VALUES (14, 'Sales & Marketing')
  579. INTO job_industry(id, industry) VALUES (15, 'Science & Research')
  580. SELECT 1 FROM DUAL;
  581.  
  582.  
  583. INSERT ALL
  584. INTO job_category(id, category, industry_id) VALUES (1, 'General Accounting', 1)
  585. INTO job_category(id, category, industry_id) VALUES (2, 'Banking & Finance', 1)
  586. INTO job_category(id, category, industry_id) VALUES (3, 'Audit & Taxation', 1)
  587. INTO job_category(id, category, industry_id) VALUES (4, 'Investment', 1)
  588. INTO job_category(id, category, industry_id) VALUES (5, 'Clerical/Secretarial', 2)
  589. INTO job_category(id, category, industry_id) VALUES (6, 'Human Resources', 2)
  590. INTO job_category(id, category, industry_id) VALUES (7, 'Management', 2)
  591. INTO job_category(id, category, industry_id) VALUES (8, 'Property & Real Estate', 3)
  592. INTO job_category(id, category, industry_id) VALUES (9, 'Architecture', 3)
  593. INTO job_category(id, category, industry_id) VALUES (10, 'Interior Design', 3)
  594. INTO job_category(id, category, industry_id) VALUES (11, 'Civil/Construction', 3)
  595. INTO job_category(id, category, industry_id) VALUES (12, 'Creative Design', 4)
  596. INTO job_category(id, category, industry_id) VALUES (13, 'Advertising', 4)
  597. INTO job_category(id, category, industry_id) VALUES (14, 'Entertainment', 4)
  598. INTO job_category(id, category, industry_id) VALUES (15, 'Education', 5)
  599. INTO job_category(id, category, industry_id) VALUES (16, 'Training & Development', 5)
  600. INTO job_category(id, category, industry_id) VALUES (17, 'Mechanical', 6)
  601. INTO job_category(id, category, industry_id) VALUES (18, 'Electrical & Electronics', 6)
  602. INTO job_category(id, category, industry_id) VALUES (19, 'Industrial & Operations', 6)
  603. INTO job_category(id, category, industry_id) VALUES (20, 'Chemical', 6)
  604. INTO job_category(id, category, industry_id) VALUES (21, 'Environmental & Energy', 6)
  605. INTO job_category(id, category, industry_id) VALUES (22, 'Oil & Gas', 6)
  606. INTO job_category(id, category, industry_id) VALUES (23, 'Nursing', 8)
  607. INTO job_category(id, category, industry_id) VALUES (24, 'Diagnosis & Surgery', 8)
  608. INTO job_category(id, category, industry_id) VALUES (25, 'Pharmacy', 8)
  609. INTO job_category(id, category, industry_id) VALUES (26, 'Diet & Nutrition', 8)
  610. INTO job_category(id, category, industry_id) VALUES (27, 'Food & Beverage', 9)
  611. INTO job_category(id, category, industry_id) VALUES (28, 'Hotel & Restaurant', 9)
  612. INTO job_category(id, category, industry_id) VALUES (29, 'Tourism', 9)
  613. INTO job_category(id, category, industry_id) VALUES (30, 'Software Engineering', 10)
  614. INTO job_category(id, category, industry_id) VALUES (31, 'Telecommunications', 10)
  615. INTO job_category(id, category, industry_id) VALUES (32, 'Internet & New Media', 10)
  616. INTO job_category(id, category, industry_id) VALUES (33, 'Hardware', 10)
  617. INTO job_category(id, category, industry_id) VALUES (34, 'Purchasing & Inventory', 11)
  618. INTO job_category(id, category, industry_id) VALUES (35, 'Maintenance', 11)
  619. INTO job_category(id, category, industry_id) VALUES (36, 'Quality Control', 11)
  620. INTO job_category(id, category, industry_id) VALUES (37, 'Process Control', 11)
  621. INTO job_category(id, category, industry_id) VALUES (38, 'Journalism & Publishing', 12)
  622. INTO job_category(id, category, industry_id) VALUES (39, 'Public Relations', 12)
  623. INTO job_category(id, category, industry_id) VALUES (40, 'Customer Service', 13)
  624. INTO job_category(id, category, industry_id) VALUES (41, 'Logistics & Supply Chain', 13)
  625. INTO job_category(id, category, industry_id) VALUES (42, 'Law/Paralegal Services', 13)
  626. INTO job_category(id, category, industry_id) VALUES (43, 'Social Services', 13)
  627. INTO job_category(id, category, industry_id) VALUES (44, 'Security', 13)
  628. INTO job_category(id, category, industry_id) VALUES (45, 'Marketing', 14)
  629. INTO job_category(id, category, industry_id) VALUES (46, 'Mechandising', 14)
  630. INTO job_category(id, category, industry_id) VALUES (47, 'Retail/General', 14)
  631. INTO job_category(id, category, industry_id) VALUES (48, 'Corporate Sales', 14)
  632. INTO job_category(id, category, industry_id) VALUES (49, 'Biology & Biotechnology', 15)
  633. INTO job_category(id, category, industry_id) VALUES (50, 'Chemistry', 15)
  634. INTO job_category(id, category, industry_id) VALUES (51, 'Physics', 15)
  635. INTO job_category(id, category, industry_id) VALUES (52, 'Geology', 15)
  636. INTO job_category(id, category, industry_id) VALUES (53, 'Math & Statistics', 15)
  637. INTO job_category(id, category, industry_id) VALUES (54, 'Agriculture', 15)
  638. INTO job_category(id, category, industry_id) VALUES (55, 'Food Technology', 15)
  639. SELECT 1 FROM DUAL;
  640.  
  641.  
  642. INSERT ALL
  643. INTO post_duration(duration, cost) VALUES (24, 0.00)
  644. INTO post_duration(duration, cost) VALUES (72, 5.00)
  645. INTO post_duration(duration, cost) VALUES (168, 10.00)
  646. INTO post_duration(duration, cost) VALUES (336, 15.00)
  647. SELECT 1 FROM DUAL;
  648.  
  649.  
  650. INSERT ALL
  651. INTO job(job_id, employer_id, type, category, post_date, duration, title, city_id, details, compensation) VALUES (1, 11, 1, 6, '2011-01-19', 72, "HR Administrator, Night Shift (BPD-0374603 Subcontractor Coordinator)", "Responsibilities:
  652.  
  653. * To Perform identified administrative tasks and processes across the full spectrum of end-to-end process for a defined set of clients.
  654. * To Work with other team members and offshore Subject Matter Experts to maintain Reports, Records and Database.
  655. * To Collate requests from the clients and to provide accurate and timely updates.
  656. * To Resolve issues arising and be involved with process improvement initiatives.
  657.  
  658.  
  659.  
  660. Requirements:
  661.  
  662. * Candidate must possess at least a Bachelor's or College Degree , any field.
  663. * At least 1 year(s) of working experience in the related field is required for this position.
  664. * Preferably 1-4 Yrs Experienced Employees specializing in Human Resources or equivalent.
  665. * Full-Time positions available.
  666. ", 30000, 32)
  667. INTO job(job_id, employer_id, type, category, post_date, duration, title, city_id, details, compensation) VALUES (2, 12, 1, 2, '2011-01-19', 72, "Supervisor , Finance II", "Responsibilities:
  668.  
  669. � Provides standard-level financial support that is typically transactional for a business.
  670. � Performs data extraction and puts it in a useful format for more senior individual contributors.
  671. � Handles business issues of basic complexity on a routine basis.
  672. � Develops an understanding of HP-s financial processes and a working knowledge of the business.
  673. � Ability to influence a particular cost center within a business.
  674.  
  675.  
  676. Requirements:Education and Experience Required:
  677.  
  678. � First level university degree with a focus in business or economics recommended or equivalent experience.
  679. � Typically 0+ years of experience as a financial analyst.
  680.  
  681. Knowledge and Skills Required:
  682.  
  683. � Basic understanding of accounting processes.
  684. � Basic analytical skills.
  685. � Good business application skills (e.g., Microsoft Excel).
  686. � Good communication skills.
  687. � Good teamwork skills.
  688.  
  689. Critical Competencies to Drive Business Results:
  690.  
  691. Accounting Processes and Systems (Business Financial Analyst)
  692. Applies an understanding of United States (US) Generally Accepted Accounting Principles (GAAP), HP finance and administrative processes, systems, policies and procedures to maximize efficiency and effectiveness
  693.  
  694. Tool and Technology Application (Financial Analyst)
  695. Leverages available tools and technology to improve financial systems effectiveness
  696.  
  697. Process Excellence (Analyst)
  698. Understands and effectively applies process knowledge to drive operational excellence
  699.  
  700. Business and Financial Controls
  701. Demonstrates the ability to leverage company business and financial data and systems to ensure quality of transactions
  702.  
  703. Financial Analysis and Reporting (Financial Analyst)
  704. Uses key financial indicators and measures to optimize the financial decision-making of the company
  705.  
  706. Risk Identification (Analyst)
  707. Accurately identifies and resolves sources of financial systems risks", 38000, 6)
  708. INTO job(job_id, employer_id, type, category, post_date, duration, title, city_id, details, compensation) VALUES (3, 13, 1, 7, '2011-01-19', 336, "Junior Sales Executive or Sales Trainee", "Qualifications
  709.  
  710. * Has the inclination to pursue a career in sales.
  711. * Graduate of any four-year course (possible to waive this if candidate has exceptional experience or other advantage)
  712. * Excellent command of the English language.
  713. * Strong interpersonal and communication skills.
  714.  
  715. Job Description
  716.  
  717. * Sell the company�s products and services to new and existing clients.
  718. * Prepare action plans to meet revenue objectives.
  719. * Resolve client or business partner issues.
  720. * Establish contacts in new accounts
  721. * Identify sales prospects and contact these and other accounts as assigned.
  722. * Prepare presentations, proposals and sales contracts.
  723. * Establish and maintain current client and potential client relationships.
  724. * Identify and resolve client concerns.
  725. * Prepare a variety of status reports, including activity, closings, follow-up, and adherence to goals.
  726. * Participate in marketing events such as seminars, trade shows, and telemarketing events.
  727. * Follow-up for collection of payment.
  728. ", 20000, 32)
  729. INTO job(job_id, employer_id, type, category, post_date, duration, title, city_id, details, compensation) VALUES (4, 15, 1, 30, '2011-01-19', 336, "C/C++ Team Lead / Managers (will be train / retool for Siebel)", "Requirements:
  730. At least 4 years rel�e�vant expe�ri�ence in C/C++ cod�ing and 3 years Supervisory / Managerial Experience
  731. Abil�ity to develop/maintain appli�ca�tions and write com�plex codes in C/C++.
  732. Work well in a team environment
  733. Be self-starter with excellent communication and problem solving skills
  734. Excel�lent Pro�gram�ming, Log�i�cal & Prob�lem solv�ing skills.
  735.  
  736.  
  737. ONLY HIGHLY QUALIFIED CANDIDATES WILL BE CONTACTED
  738.  
  739.  
  740. Build your career as you gain exposure in a truly global company.
  741. Apply at Accenture now!", 40000, 6)
  742. SELECT 1 FROM DUAL;
  743.  
  744.  
  745. INSERT ALL
  746. INTO job_application(job_id, user_id, application_date) VALUES (2, 7, '2011-01-25')
  747. INTO job_application(job_id, user_id, application_date) VALUES (4, 8, '2011-01-27')
  748. INTO job_application(job_id, user_id, application_date) VALUES (3, 6, '2011-01-23')
  749. INTO job_application(job_id, user_id, application_date) VALUES (1, 9, '2011-01-24')
  750. INTO job_application(job_id, user_id, application_date) VALUES (4, 10, '2011-01-22')
  751. SELECT 1 FROM DUAL;
  752.  
  753.  
  754. INSERT ALL
  755. INTO information(info_id, user_id) VALUES (1, 8)
  756. INTO information(info_id, user_id) VALUES (2, 8)
  757. INTO information(info_id, user_id) VALUES (3, 8)
  758. INTO information(info_id, user_id) VALUES (4, 8)
  759. INTO information(info_id, user_id) VALUES (5, 8)
  760. INTO information(info_id, user_id) VALUES (6, 8)
  761. INTO information(info_id, user_id) VALUES (7, 10)
  762. INTO information(info_id, user_id) VALUES (8, 10)
  763. INTO information(info_id, user_id) VALUES (9, 10)
  764. INTO information(info_id, user_id) VALUES (10, 9)
  765. INTO information(info_id, user_id) VALUES (11, 9)
  766. INTO information(info_id, user_id) VALUES (12, 9)
  767. INTO information(info_id, user_id) VALUES (13, 8)
  768. SELECT 1 FROM DUAL;
  769.  
  770. INSERT ALL
  771. INTO info_detail(info_id, ordinality, detail) VALUES (1, 1, '')
  772. INTO info_detail(info_id, ordinality, detail) VALUES (2, 2, '')
  773. INTO info_detail(info_id, ordinality, detail) VALUES (3, 3, '')
  774. INTO info_detail(info_id, ordinality, detail) VALUES (4, 4, '')
  775. INTO info_detail(info_id, ordinality, detail) VALUES (5, 6, '')
  776. INTO info_detail(info_id, ordinality, detail) VALUES (6, 7, '')
  777. INTO info_detail(info_id, ordinality, detail) VALUES (7, 1, '')
  778. INTO info_detail(info_id, ordinality, detail) VALUES (8, 2, '')
  779. INTO info_detail(info_id, ordinality, detail) VALUES (9, 3, '')
  780. INTO info_detail(info_id, ordinality, detail) VALUES (10, 1, '')
  781. INTO info_detail(info_id, ordinality, detail) VALUES (11, 2, '')
  782. INTO info_detail(info_id, ordinality, detail) VALUES (12, 3, '')
  783. INTO info_detail(info_id, ordinality, detail) VALUES (13, 5, '')
  784. SELECT 1 FROM DUAL;
  785.  
  786. INSERT ALL
  787. INTO skill(info_id, skill_name, proficiency) VALUES (1, 'C/C++ Programming', 8)
  788. INTO skill(info_id, skill_name, proficiency) VALUES (2, 'Java Programming', 8)
  789. INTO skill(info_id, skill_name, proficiency) VALUES (3, 'PHP Web Programming', 9)
  790. INTO skill(info_id, skill_name, proficiency) VALUES (7, 'C++ Programming', 8)
  791. INTO skill(info_id, skill_name, proficiency) VALUES (8, 'C# Programming', 8)
  792. SELECT 1 FROM DUAL;
  793.  
  794. INSERT ALL
  795. INTO education(info_id, degree, institution, location, start_date, end_date) VALUES (4, 'BS Computer Science', 'University of the Philippines, Diliman', 'Diliman, Quezon City, Philippines', '1997-06-01', '2001-04-01')
  796. INTO education(info_id, degree, institution, location, start_date, end_date) VALUES (9, 'BS Information Technology', 'Informatics Computer Institute', 'Diliman, Quezon City, Philippines', '2001-06-05', '2005-04-15')
  797. INTO education(info_id, degree, institution, location, start_date, end_date) VALUES (10, 'BS Psychology', 'University of the Philippines, Diliman', 'Diliman, Quezon City, Philippines', '2001-06-05', '2005-04-15')
  798. INTO education(info_id, degree, institution, location, start_date, end_date) VALUES (11, 'MS Psychology', 'University of the Philippines, Diliman', 'Diliman, Quezon City, Philippines', '2005-06-10', '2007-04-20')
  799. INTO education(info_id, degree, institution, location, start_date, end_date) VALUES (13, 'MS Computer Science', 'University of the Philippines, Diliman', 'Diliman, Quezon City, Philippines', '2001-06-08', '2003-04-20')
  800. SELECT 1 FROM DUAL;
  801.  
  802. INSERT ALL
  803. INTO experience(info_id, position, organization, location, start_date, end_date) VALUES (5, 'C++ Software Engineer', 'Pointwest Technologies Corp.', 'Makati City, Philippines', '2003-05-15', '2006-03-20')
  804. INTO experience(info_id, position, organization, location, start_date, end_date) VALUES (6, 'C++ Senior Software Engineer', 'Canon Philippines', 'Makati City, Philippines', '2006-04-10', '2011-01-16')
  805. INTO experience(info_id, position, organization, location, start_date, end_date) VALUES (10, 'C++ Game Developer', 'Gameloft Philippines', 'Makati City, Philippines', '2005-05-20', '2011-01-10')
  806. SELECT 1 FROM DUAL;
Advertisement
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!