Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 4th, 2012  |  syntax: None  |  size: 57.14 KB  |  hits: 31  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.2.0.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generato il: 30 mar, 2011 at 03:25 PM
  7. -- Versione MySQL: 5.1.37
  8. -- Versione PHP: 5.2.10
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Database: `ccv3`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Struttura della tabella `corsi`
  20. --
  21.  
  22. CREATE TABLE `corsi` (
  23.   `id_corso` int(11) NOT NULL AUTO_INCREMENT,
  24.   `data_creazione` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  25.   `duration` varchar(30) DEFAULT NULL,
  26.   `fk_group` int(11) DEFAULT NULL,
  27.   `location` varchar(512) DEFAULT NULL,
  28.   PRIMARY KEY (`id_corso`)
  29. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;
  30.  
  31. --
  32. -- Dump dei dati per la tabella `corsi`
  33. --
  34.  
  35. INSERT INTO `corsi` VALUES(1, '2011-03-30 10:11:12', '1', 1, NULL);
  36. INSERT INTO `corsi` VALUES(2, '2011-03-30 10:13:21', '1', 1, NULL);
  37. INSERT INTO `corsi` VALUES(3, '2011-03-30 10:13:21', '0,5', 1, NULL);
  38. INSERT INTO `corsi` VALUES(4, '2011-03-30 10:13:21', '1', 1, NULL);
  39. INSERT INTO `corsi` VALUES(5, '2011-03-30 10:13:21', '1', 1, NULL);
  40. INSERT INTO `corsi` VALUES(6, '2011-03-30 10:13:21', '0,5', 1, NULL);
  41. INSERT INTO `corsi` VALUES(7, '2011-03-30 10:13:21', '1', 1, NULL);
  42. INSERT INTO `corsi` VALUES(8, '2011-03-30 10:13:21', '3', 1, NULL);
  43. INSERT INTO `corsi` VALUES(9, '2011-03-30 10:13:21', '0,5', 1, NULL);
  44. INSERT INTO `corsi` VALUES(10, '2011-03-30 10:13:21', '1', 1, NULL);
  45. INSERT INTO `corsi` VALUES(11, '2011-03-30 10:13:21', '1', 1, NULL);
  46. INSERT INTO `corsi` VALUES(12, '2011-03-30 10:13:21', '1', 1, NULL);
  47. INSERT INTO `corsi` VALUES(13, '2011-03-30 10:13:21', 'NA', 1, NULL);
  48. INSERT INTO `corsi` VALUES(14, '2011-03-30 10:13:21', '2', 1, NULL);
  49. INSERT INTO `corsi` VALUES(15, '2011-03-30 10:13:21', '2', 1, NULL);
  50. INSERT INTO `corsi` VALUES(16, '2011-03-30 10:13:21', '3', 1, NULL);
  51. INSERT INTO `corsi` VALUES(17, '2011-03-30 10:13:21', '2', 1, NULL);
  52. INSERT INTO `corsi` VALUES(18, '2011-03-30 10:13:21', 'V', 1, NULL);
  53. INSERT INTO `corsi` VALUES(19, '2011-03-30 10:15:42', '1', 2, NULL);
  54. INSERT INTO `corsi` VALUES(20, '2011-03-30 10:15:42', '1', 2, NULL);
  55. INSERT INTO `corsi` VALUES(21, '2011-03-30 10:15:42', '0,5', 2, NULL);
  56. INSERT INTO `corsi` VALUES(22, '2011-03-30 10:15:42', '1', 2, NULL);
  57. INSERT INTO `corsi` VALUES(23, '2011-03-30 10:15:42', '3', 2, NULL);
  58. INSERT INTO `corsi` VALUES(24, '2011-03-30 10:15:42', '0,5', 2, NULL);
  59. INSERT INTO `corsi` VALUES(25, '2011-03-30 10:15:42', '1', 2, NULL);
  60. INSERT INTO `corsi` VALUES(26, '2011-03-30 10:15:42', '1', 2, NULL);
  61. INSERT INTO `corsi` VALUES(27, '2011-03-30 10:15:42', '1', 2, NULL);
  62. INSERT INTO `corsi` VALUES(28, '2011-03-30 10:15:42', 'NA', 2, NULL);
  63. INSERT INTO `corsi` VALUES(29, '2011-03-30 10:15:42', '3', 2, NULL);
  64. INSERT INTO `corsi` VALUES(30, '2011-03-30 10:15:42', '2', 2, NULL);
  65. INSERT INTO `corsi` VALUES(31, '2011-03-30 10:15:42', '2', 2, NULL);
  66. INSERT INTO `corsi` VALUES(32, '2011-03-30 10:15:42', '2', 2, NULL);
  67. INSERT INTO `corsi` VALUES(33, '2011-03-30 10:15:42', 'V', 2, NULL);
  68.  
  69. -- --------------------------------------------------------
  70.  
  71. --
  72. -- Struttura della tabella `corsi_translation`
  73. --
  74.  
  75. CREATE TABLE `corsi_translation` (
  76.   `fk_corso` int(11) NOT NULL,
  77.   `fk_lingua` int(11) NOT NULL,
  78.   `title` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  79.   `description` text CHARACTER SET latin1
  80. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  81.  
  82. --
  83. -- Dump dei dati per la tabella `corsi_translation`
  84. --
  85.  
  86. INSERT INTO `corsi_translation` VALUES(1, 1, 'The Role Of The Account Manager', NULL);
  87. INSERT INTO `corsi_translation` VALUES(2, 1, 'The Local Healthcare Environment', NULL);
  88. INSERT INTO `corsi_translation` VALUES(3, 1, 'Local Health Economy Planning & Data Analysis', NULL);
  89. INSERT INTO `corsi_translation` VALUES(4, 1, 'Customers', NULL);
  90. INSERT INTO `corsi_translation` VALUES(5, 1, 'Customer Value Propositions & Compliance', NULL);
  91. INSERT INTO `corsi_translation` VALUES(6, 1, 'Market Research And Customer Insight', NULL);
  92. INSERT INTO `corsi_translation` VALUES(7, 1, 'Customer Activity Cycle And Patient Pathways', NULL);
  93. INSERT INTO `corsi_translation` VALUES(8, 1, 'Brand Training', NULL);
  94. INSERT INTO `corsi_translation` VALUES(9, 1, 'Cross Functional Working', NULL);
  95. INSERT INTO `corsi_translation` VALUES(10, 1, 'Shared Agenda', NULL);
  96. INSERT INTO `corsi_translation` VALUES(11, 1, 'Selling To Customers ', NULL);
  97. INSERT INTO `corsi_translation` VALUES(12, 1, 'Customer Selling Day', NULL);
  98. INSERT INTO `corsi_translation` VALUES(13, 1, 'Wellards', NULL);
  99. INSERT INTO `corsi_translation` VALUES(14, 1, 'Module 1 - Professional Account Management', NULL);
  100. INSERT INTO `corsi_translation` VALUES(15, 1, 'Module 2 - Local Health Economy Planning And Insight', NULL);
  101. INSERT INTO `corsi_translation` VALUES(16, 1, 'Module 3 - Negotiation Skills', NULL);
  102. INSERT INTO `corsi_translation` VALUES(17, 1, 'Innovation For Account Managers', NULL);
  103. INSERT INTO `corsi_translation` VALUES(18, 1, 'Learning & development Curriculum', NULL);
  104. INSERT INTO `corsi_translation` VALUES(19, 1, 'The Role Of The Network Manager', NULL);
  105. INSERT INTO `corsi_translation` VALUES(20, 1, 'The Local Healthcare Environment', NULL);
  106. INSERT INTO `corsi_translation` VALUES(21, 1, 'Local Health Economy Planning & Data Analysis', NULL);
  107. INSERT INTO `corsi_translation` VALUES(22, 1, 'Customers', NULL);
  108. INSERT INTO `corsi_translation` VALUES(23, 1, 'Brand Training', NULL);
  109. INSERT INTO `corsi_translation` VALUES(24, 1, 'Cross Functional Working', NULL);
  110. INSERT INTO `corsi_translation` VALUES(25, 1, 'Formulary Training', NULL);
  111. INSERT INTO `corsi_translation` VALUES(26, 1, 'Shared Agenda', NULL);
  112. INSERT INTO `corsi_translation` VALUES(27, 1, 'Selling To Customers ', NULL);
  113. INSERT INTO `corsi_translation` VALUES(28, 1, 'Customer Selling Day', NULL);
  114. INSERT INTO `corsi_translation` VALUES(29, 1, 'Wellards', NULL);
  115. INSERT INTO `corsi_translation` VALUES(30, 1, 'Project Management Level 1', NULL);
  116. INSERT INTO `corsi_translation` VALUES(31, 1, 'Project Management Level 2', NULL);
  117. INSERT INTO `corsi_translation` VALUES(32, 1, 'Project Management Level 3', NULL);
  118. INSERT INTO `corsi_translation` VALUES(33, 1, 'Innovation For Network Managers', NULL);
  119. INSERT INTO `corsi_translation` VALUES(34, 1, 'Learning & development Curriculum', NULL);
  120. INSERT INTO `corsi_translation` VALUES(1, 2, 'Rôle de l’Account manager/CROS', NULL);
  121. INSERT INTO `corsi_translation` VALUES(2, 2, 'Environnement de soins de santé local', NULL);
  122. INSERT INTO `corsi_translation` VALUES(3, 2, 'Planification et analyse des données de l’économie de santé locale', NULL);
  123. INSERT INTO `corsi_translation` VALUES(4, 2, 'Clients', NULL);
  124. INSERT INTO `corsi_translation` VALUES(5, 2, 'Propositions de valeur aux clients et conformité', NULL);
  125. INSERT INTO `corsi_translation` VALUES(6, 2, 'Étude de marché et perspective du client', NULL);
  126. INSERT INTO `corsi_translation` VALUES(7, 2, 'Cycle d’activité du client et le parcours patients', NULL);
  127. INSERT INTO `corsi_translation` VALUES(8, 2, 'Formation sur les produits', NULL);
  128. INSERT INTO `corsi_translation` VALUES(9, 2, 'Travail pluridisciplinaire', NULL);
  129. INSERT INTO `corsi_translation` VALUES(10, 2, 'Ordre du jour partagé', NULL);
  130. INSERT INTO `corsi_translation` VALUES(11, 2, 'Vendre aux clients', NULL);
  131. INSERT INTO `corsi_translation` VALUES(12, 2, 'Un jour dans la vente au client', NULL);
  132. INSERT INTO `corsi_translation` VALUES(13, 2, 'Wellards', NULL);
  133. INSERT INTO `corsi_translation` VALUES(14, 2, 'Module 1 - Account Management professionnel', NULL);
  134. INSERT INTO `corsi_translation` VALUES(15, 2, 'Module 2 - Planification de l’économie de santé locale et perspective', NULL);
  135. INSERT INTO `corsi_translation` VALUES(16, 2, 'Module 3 - Compétences de négociation', NULL);
  136. INSERT INTO `corsi_translation` VALUES(17, 2, 'Innovation pour les Account Managers/CROS', NULL);
  137. INSERT INTO `corsi_translation` VALUES(18, 2, 'Programme d’apprentissage et de développement', NULL);
  138. INSERT INTO `corsi_translation` VALUES(19, 2, 'Rôle du network manager', NULL);
  139. INSERT INTO `corsi_translation` VALUES(20, 2, 'Environnement de soins de santé local', NULL);
  140. INSERT INTO `corsi_translation` VALUES(21, 2, 'Planification et analyse des données de l’économie de santé locale', NULL);
  141. INSERT INTO `corsi_translation` VALUES(22, 2, 'Clients', NULL);
  142. INSERT INTO `corsi_translation` VALUES(23, 2, 'Formation sur les produits', NULL);
  143. INSERT INTO `corsi_translation` VALUES(24, 2, 'Travail pluridisciplinaire', NULL);
  144. INSERT INTO `corsi_translation` VALUES(25, 2, 'Formation sur les formulaires/médicaments référencés', NULL);
  145. INSERT INTO `corsi_translation` VALUES(26, 2, 'Ordre du jour partagé', NULL);
  146. INSERT INTO `corsi_translation` VALUES(27, 2, 'Vendre aux clients', NULL);
  147. INSERT INTO `corsi_translation` VALUES(28, 2, 'Un jour dans la vente au client', NULL);
  148. INSERT INTO `corsi_translation` VALUES(29, 2, 'Wellards', NULL);
  149. INSERT INTO `corsi_translation` VALUES(30, 2, 'Gestion de projet Niveau 1', NULL);
  150. INSERT INTO `corsi_translation` VALUES(31, 2, 'Gestion de projet Niveau 2', NULL);
  151. INSERT INTO `corsi_translation` VALUES(32, 2, 'Gestion de projet Niveau 3', NULL);
  152. INSERT INTO `corsi_translation` VALUES(33, 2, 'Innovation pour les network managers.', NULL);
  153. INSERT INTO `corsi_translation` VALUES(34, 2, 'Programme d’apprentissage et de développement', NULL);
  154. INSERT INTO `corsi_translation` VALUES(1, 3, 'Il ruolo dell’Account Manager', NULL);
  155. INSERT INTO `corsi_translation` VALUES(2, 3, 'L’ambiente sanitario locale', NULL);
  156. INSERT INTO `corsi_translation` VALUES(3, 3, 'Preparazione di piani finanziari per strutture sanitarie locali e analisi dei dati', NULL);
  157. INSERT INTO `corsi_translation` VALUES(4, 3, 'Customers', NULL);
  158. INSERT INTO `corsi_translation` VALUES(5, 3, 'Customer Value Propositions & Compliance', NULL);
  159. INSERT INTO `corsi_translation` VALUES(6, 3, 'Ricerche di mercato e analisi dei clienti', NULL);
  160. INSERT INTO `corsi_translation` VALUES(7, 3, 'Ciclo delle attività dei clienti e iter dei pazienti', NULL);
  161. INSERT INTO `corsi_translation` VALUES(8, 3, 'Corsi sui prodotti', NULL);
  162. INSERT INTO `corsi_translation` VALUES(9, 3, 'Cross Functional Working', NULL);
  163. INSERT INTO `corsi_translation` VALUES(10, 3, 'Identificazione e definizione di un programma comune', NULL);
  164. INSERT INTO `corsi_translation` VALUES(11, 3, 'Selling To Customers ', NULL);
  165. INSERT INTO `corsi_translation` VALUES(12, 3, 'Customer Selling Day', NULL);
  166. INSERT INTO `corsi_translation` VALUES(13, 3, 'Wellards', NULL);
  167. INSERT INTO `corsi_translation` VALUES(14, 3, 'Modulo 1 - La professionalità dell’Account Management', NULL);
  168. INSERT INTO `corsi_translation` VALUES(15, 3, 'Modulo 2 - Preparazione di piani finanziari per le strutture sanitarie locali e analisi', NULL);
  169. INSERT INTO `corsi_translation` VALUES(16, 3, 'Modulo 3 - Tecniche di negoziazione', NULL);
  170. INSERT INTO `corsi_translation` VALUES(17, 3, 'Creatività e innovazione per gli Account Manager', NULL);
  171. INSERT INTO `corsi_translation` VALUES(18, 3, 'Learning & development Curriculum', NULL);
  172. INSERT INTO `corsi_translation` VALUES(19, 3, 'Il ruolo del Network Manager', NULL);
  173. INSERT INTO `corsi_translation` VALUES(20, 3, 'L’ambiente sanitario locale', NULL);
  174. INSERT INTO `corsi_translation` VALUES(21, 3, 'Preparazione di piani finanziari per strutture sanitarie locali e analisi dei dati', NULL);
  175. INSERT INTO `corsi_translation` VALUES(22, 3, 'I customer del network management', NULL);
  176. INSERT INTO `corsi_translation` VALUES(23, 3, 'Corsi sui prodotti', NULL);
  177. INSERT INTO `corsi_translation` VALUES(24, 3, 'Cross Functional Working', NULL);
  178. INSERT INTO `corsi_translation` VALUES(25, 3, 'Formulary Training', NULL);
  179. INSERT INTO `corsi_translation` VALUES(26, 3, 'Identificazione e definizione di un programma comune', NULL);
  180. INSERT INTO `corsi_translation` VALUES(27, 3, 'Selling To Customers ', NULL);
  181. INSERT INTO `corsi_translation` VALUES(28, 3, 'Customer Selling Day', NULL);
  182. INSERT INTO `corsi_translation` VALUES(29, 3, 'Wellards', NULL);
  183. INSERT INTO `corsi_translation` VALUES(30, 3, 'Project Management - Livello 1', NULL);
  184. INSERT INTO `corsi_translation` VALUES(31, 3, 'Project Management - Livello 2', NULL);
  185. INSERT INTO `corsi_translation` VALUES(32, 3, 'Project Management - Livello 3', NULL);
  186. INSERT INTO `corsi_translation` VALUES(33, 3, 'Creatività e innovazione per i Network Manager', NULL);
  187. INSERT INTO `corsi_translation` VALUES(34, 3, 'Learning & development Curriculum', NULL);
  188. INSERT INTO `corsi_translation` VALUES(1, 4, 'Die Rolle des Account Managers', NULL);
  189. INSERT INTO `corsi_translation` VALUES(2, 4, 'Das lokale Gesundheitsumfeld', NULL);
  190. INSERT INTO `corsi_translation` VALUES(3, 4, 'Lokale Gesundheitsökonomieplanung und Datenanalyse', NULL);
  191. INSERT INTO `corsi_translation` VALUES(4, 4, 'Kunden', NULL);
  192. INSERT INTO `corsi_translation` VALUES(5, 4, 'Kundenwertversprechen und Customer-Compliance', NULL);
  193. INSERT INTO `corsi_translation` VALUES(6, 4, 'Marktforschung und Kundenverständnis', NULL);
  194. INSERT INTO `corsi_translation` VALUES(7, 4, 'Kundenaktivitätszyklus und Patientenpfade', NULL);
  195. INSERT INTO `corsi_translation` VALUES(8, 4, 'Markenschulung', NULL);
  196. INSERT INTO `corsi_translation` VALUES(9, 4, 'Funktionsübergreifende Arbeit', NULL);
  197. INSERT INTO `corsi_translation` VALUES(10, 4, 'Gemeinsame Agenda', NULL);
  198. INSERT INTO `corsi_translation` VALUES(11, 4, 'Verkauf an Kunden', NULL);
  199. INSERT INTO `corsi_translation` VALUES(12, 4, 'Kundenverkaufstag', NULL);
  200. INSERT INTO `corsi_translation` VALUES(13, 4, 'Wellards', NULL);
  201. INSERT INTO `corsi_translation` VALUES(14, 4, 'Modul 1 - Professionelles Account Management', NULL);
  202. INSERT INTO `corsi_translation` VALUES(15, 4, 'Modul 2 - Die Lokale Gesundheitsökonomieplanung und wie sie funktioniert', NULL);
  203. INSERT INTO `corsi_translation` VALUES(16, 4, 'Modul 3 - Verhandlungsstrategien', NULL);
  204. INSERT INTO `corsi_translation` VALUES(17, 4, 'Innovation für Account Manager', NULL);
  205. INSERT INTO `corsi_translation` VALUES(18, 4, 'Lehr- und Fortbildungsplan', NULL);
  206. INSERT INTO `corsi_translation` VALUES(19, 4, 'Die Funktion des Network Managers', NULL);
  207. INSERT INTO `corsi_translation` VALUES(20, 4, 'Das lokale Gesundheitsumfeld', NULL);
  208. INSERT INTO `corsi_translation` VALUES(21, 4, 'Lokale Gesundheitsökonomieplanung und Datenanalyse', NULL);
  209. INSERT INTO `corsi_translation` VALUES(22, 4, 'Kunden', NULL);
  210. INSERT INTO `corsi_translation` VALUES(23, 4, 'Markenschulung', NULL);
  211. INSERT INTO `corsi_translation` VALUES(24, 4, 'Funktionsübergreifende Arbeit', NULL);
  212. INSERT INTO `corsi_translation` VALUES(25, 4, 'Positivlistenschulung', NULL);
  213. INSERT INTO `corsi_translation` VALUES(26, 4, 'Gemeinsame Agenda', NULL);
  214. INSERT INTO `corsi_translation` VALUES(27, 4, 'Verkauf an Kunden', NULL);
  215. INSERT INTO `corsi_translation` VALUES(28, 4, 'Kundenverkaufstag', NULL);
  216. INSERT INTO `corsi_translation` VALUES(29, 4, 'Wellards', NULL);
  217. INSERT INTO `corsi_translation` VALUES(30, 4, 'Projektmanagement Stufe 1', NULL);
  218. INSERT INTO `corsi_translation` VALUES(31, 4, 'Projektmanagement Stufe 2', NULL);
  219. INSERT INTO `corsi_translation` VALUES(32, 4, 'Projektmanagement Stufe 3', NULL);
  220. INSERT INTO `corsi_translation` VALUES(33, 4, 'Innovation für Network Manager', NULL);
  221. INSERT INTO `corsi_translation` VALUES(34, 4, 'Lehr- und Fortbildungsplan', NULL);
  222. INSERT INTO `corsi_translation` VALUES(1, 5, 'De rol van de Account Manager', NULL);
  223. INSERT INTO `corsi_translation` VALUES(2, 5, 'De plaatselijke gezondheidszorg ', NULL);
  224. INSERT INTO `corsi_translation` VALUES(3, 5, 'Plaatselijke Gezondheidseconomie Planning & Data-analyse', NULL);
  225. INSERT INTO `corsi_translation` VALUES(4, 5, 'Klanten', NULL);
  226. INSERT INTO `corsi_translation` VALUES(5, 5, 'Waardepropositie Klanten & Naleving', NULL);
  227. INSERT INTO `corsi_translation` VALUES(6, 5, 'Marktonderzoek en Klantinzicht', NULL);
  228. INSERT INTO `corsi_translation` VALUES(7, 5, 'Activiteitencyclus Klanten en Patiënttraject', NULL);
  229. INSERT INTO `corsi_translation` VALUES(8, 5, 'Producttraining', NULL);
  230. INSERT INTO `corsi_translation` VALUES(9, 5, 'Cross Functional Working', NULL);
  231. INSERT INTO `corsi_translation` VALUES(10, 5, 'Gemeenschappelijke Agenda', NULL);
  232. INSERT INTO `corsi_translation` VALUES(11, 5, 'Verkopen aan de Klant', NULL);
  233. INSERT INTO `corsi_translation` VALUES(12, 5, 'Verkoopdag Klant', NULL);
  234. INSERT INTO `corsi_translation` VALUES(13, 5, 'Wellards', NULL);
  235. INSERT INTO `corsi_translation` VALUES(14, 5, 'Module 1 - Professioneel Account Management', NULL);
  236. INSERT INTO `corsi_translation` VALUES(15, 5, 'Module 2 – Plaatselijke Gezondheidseconomie Planning en Inzicht', NULL);
  237. INSERT INTO `corsi_translation` VALUES(16, 5, 'Module 3 - Onderhandelingsvaardigheden', NULL);
  238. INSERT INTO `corsi_translation` VALUES(17, 5, 'Innovatie voor Account Managers', NULL);
  239. INSERT INTO `corsi_translation` VALUES(18, 5, 'Leer- & Ontwikkelingsplan', NULL);
  240. INSERT INTO `corsi_translation` VALUES(19, 5, 'De rol van de Network Manager', NULL);
  241. INSERT INTO `corsi_translation` VALUES(20, 5, 'De plaatselijke gezondheidszorg ', NULL);
  242. INSERT INTO `corsi_translation` VALUES(21, 5, 'Plaatselijke Gezondheidseconomie Planning & Data-analyse', NULL);
  243. INSERT INTO `corsi_translation` VALUES(22, 5, 'Klanten', NULL);
  244. INSERT INTO `corsi_translation` VALUES(23, 5, 'Producttraining', NULL);
  245. INSERT INTO `corsi_translation` VALUES(24, 5, 'Cross Functional Working', NULL);
  246. INSERT INTO `corsi_translation` VALUES(25, 5, 'Opleiding Formules', NULL);
  247. INSERT INTO `corsi_translation` VALUES(26, 5, 'Gemeenschappelijke Agenda', NULL);
  248. INSERT INTO `corsi_translation` VALUES(27, 5, 'Verkopen aan de Klant', NULL);
  249. INSERT INTO `corsi_translation` VALUES(28, 5, 'Verkoopdag Klant', NULL);
  250. INSERT INTO `corsi_translation` VALUES(29, 5, 'Wellards', NULL);
  251. INSERT INTO `corsi_translation` VALUES(30, 5, 'Projectmanagement Niveau 1', NULL);
  252. INSERT INTO `corsi_translation` VALUES(31, 5, 'Projectmanagement Niveau 2', NULL);
  253. INSERT INTO `corsi_translation` VALUES(32, 5, 'Projectmanagement Niveau 3', NULL);
  254. INSERT INTO `corsi_translation` VALUES(33, 5, 'Innovatie voor Network Managers', NULL);
  255. INSERT INTO `corsi_translation` VALUES(34, 5, 'Leer- & Ontwikkelingsplan', NULL);
  256. INSERT INTO `corsi_translation` VALUES(1, 6, 'La función del Director de Cuentas', NULL);
  257. INSERT INTO `corsi_translation` VALUES(2, 6, 'La situación del sistema de atención sanitaria local ', NULL);
  258. INSERT INTO `corsi_translation` VALUES(3, 6, 'Análisis de datos y planificación de la economía del sistema de atención sanitaria local', NULL);
  259. INSERT INTO `corsi_translation` VALUES(4, 6, 'Clientes', NULL);
  260. INSERT INTO `corsi_translation` VALUES(5, 6, 'El valor de los clientes: propuestas y cumplimiento', NULL);
  261. INSERT INTO `corsi_translation` VALUES(6, 6, 'Estudio de mercado y conocimiento de los clientes', NULL);
  262. INSERT INTO `corsi_translation` VALUES(7, 6, 'Ciclo de actividad de los clientes y rutas de los pacientes', NULL);
  263. INSERT INTO `corsi_translation` VALUES(8, 6, 'Formación sobre la marca', NULL);
  264. INSERT INTO `corsi_translation` VALUES(9, 6, 'Trabajo multifuncional', NULL);
  265. INSERT INTO `corsi_translation` VALUES(10, 6, 'Plan común', NULL);
  266. INSERT INTO `corsi_translation` VALUES(11, 6, 'Venta a clientes', NULL);
  267. INSERT INTO `corsi_translation` VALUES(12, 6, 'Un Día de venta a clientes', NULL);
  268. INSERT INTO `corsi_translation` VALUES(13, 6, 'Wellards', NULL);
  269. INSERT INTO `corsi_translation` VALUES(14, 6, 'Módulo 1 - Account Management Profesional', NULL);
  270. INSERT INTO `corsi_translation` VALUES(15, 6, 'Módulo 2 – Planes y perspectivas de la economía del sistema de atención sanitaria local', '');
  271. INSERT INTO `corsi_translation` VALUES(16, 6, 'Módulo 3 – Técnicas de negociación', NULL);
  272. INSERT INTO `corsi_translation` VALUES(17, 6, 'Innovación para Account Managers', NULL);
  273. INSERT INTO `corsi_translation` VALUES(18, 6, 'Programa de aprendizaje y desarrollo', NULL);
  274. INSERT INTO `corsi_translation` VALUES(19, 6, 'La función del Network Manager', NULL);
  275. INSERT INTO `corsi_translation` VALUES(20, 6, 'La situación del sistema de atención sanitaria local ', NULL);
  276. INSERT INTO `corsi_translation` VALUES(21, 6, 'Análisis de datos y planificación de la economía del sistema de atención sanitaria local', NULL);
  277. INSERT INTO `corsi_translation` VALUES(22, 6, 'Clientes', NULL);
  278. INSERT INTO `corsi_translation` VALUES(23, 6, 'Formación sobre la marca', NULL);
  279. INSERT INTO `corsi_translation` VALUES(24, 6, 'Trabajo multifuncional', NULL);
  280. INSERT INTO `corsi_translation` VALUES(25, 6, 'Formación sobre el vademécum', NULL);
  281. INSERT INTO `corsi_translation` VALUES(26, 6, 'Plan común', NULL);
  282. INSERT INTO `corsi_translation` VALUES(27, 6, 'Venta a clientes ', NULL);
  283. INSERT INTO `corsi_translation` VALUES(28, 6, 'Un Día de venta a clientes', NULL);
  284. INSERT INTO `corsi_translation` VALUES(29, 6, 'Wellards', NULL);
  285. INSERT INTO `corsi_translation` VALUES(30, 6, 'Nivel 1 de gestión de proyectos', NULL);
  286. INSERT INTO `corsi_translation` VALUES(31, 6, 'Nivel 2 de gestión de proyectos', NULL);
  287. INSERT INTO `corsi_translation` VALUES(32, 6, 'Nivel 3 de gestión de proyectos', NULL);
  288. INSERT INTO `corsi_translation` VALUES(33, 6, 'Innovación para Network Managers', NULL);
  289. INSERT INTO `corsi_translation` VALUES(34, 6, 'Programa de aprendizaje y desarrollo', NULL);
  290. INSERT INTO `corsi_translation` VALUES(1, 7, 'A Função do Account Manager', NULL);
  291. INSERT INTO `corsi_translation` VALUES(2, 7, 'O Ambiente de Serviços de Saúde Locais', NULL);
  292. INSERT INTO `corsi_translation` VALUES(3, 7, 'Planeamento e Análise de Dados da Economia de Saúde Local', NULL);
  293. INSERT INTO `corsi_translation` VALUES(4, 7, 'Clientes', NULL);
  294. INSERT INTO `corsi_translation` VALUES(5, 7, 'Proposições e Conformidade de Valor para o Cliente', NULL);
  295. INSERT INTO `corsi_translation` VALUES(6, 7, 'Pesquisa de Mercado e Customer Insight', NULL);
  296. INSERT INTO `corsi_translation` VALUES(7, 7, 'Ciclo de Actividade do Cliente e Percursos do Doente', NULL);
  297. INSERT INTO `corsi_translation` VALUES(8, 7, 'Brand Training', '');
  298. INSERT INTO `corsi_translation` VALUES(9, 7, 'Cross Functional Working', NULL);
  299. INSERT INTO `corsi_translation` VALUES(10, 7, 'Agenda Comun', NULL);
  300. INSERT INTO `corsi_translation` VALUES(11, 7, 'Vender a Clientes ', NULL);
  301. INSERT INTO `corsi_translation` VALUES(12, 7, 'Customer Selling ', NULL);
  302. INSERT INTO `corsi_translation` VALUES(13, 7, 'Wellards', NULL);
  303. INSERT INTO `corsi_translation` VALUES(14, 7, 'Module 1 - Account Management Profissional', NULL);
  304. INSERT INTO `corsi_translation` VALUES(15, 7, 'Module 2 - Planeamento e Percepção da Economia ', NULL);
  305. INSERT INTO `corsi_translation` VALUES(16, 7, 'Module 3 - Técnicas de Negociação', NULL);
  306. INSERT INTO `corsi_translation` VALUES(17, 7, 'Inovação para Account Managers', NULL);
  307. INSERT INTO `corsi_translation` VALUES(18, 7, 'Currículo de Aprendizagem e Desenvolvimento', NULL);
  308. INSERT INTO `corsi_translation` VALUES(19, 7, 'A Função do Network Manager', NULL);
  309. INSERT INTO `corsi_translation` VALUES(20, 7, 'O Ambiente de Serviços de Saúde Locais', NULL);
  310. INSERT INTO `corsi_translation` VALUES(21, 7, 'Planeamento e Análise de Dados da Economia de Saúde Local', NULL);
  311. INSERT INTO `corsi_translation` VALUES(22, 7, 'Clientes', NULL);
  312. INSERT INTO `corsi_translation` VALUES(23, 7, 'Brand Training', '');
  313. INSERT INTO `corsi_translation` VALUES(24, 7, 'Cross Functional Working', NULL);
  314. INSERT INTO `corsi_translation` VALUES(25, 7, 'Formação de Formulários', NULL);
  315. INSERT INTO `corsi_translation` VALUES(26, 7, 'Agenda Comun', '');
  316. INSERT INTO `corsi_translation` VALUES(27, 7, 'Vender a Clientes ', NULL);
  317. INSERT INTO `corsi_translation` VALUES(28, 7, 'Customer Selling ', NULL);
  318. INSERT INTO `corsi_translation` VALUES(29, 7, 'Wellards', '');
  319. INSERT INTO `corsi_translation` VALUES(30, 7, 'Nível 1 de Gestão de Projectos', NULL);
  320. INSERT INTO `corsi_translation` VALUES(31, 7, 'Nível 2 de Gestão de Projectos', NULL);
  321. INSERT INTO `corsi_translation` VALUES(32, 7, 'Nível 3 de Gestão de Projectos', NULL);
  322. INSERT INTO `corsi_translation` VALUES(33, 7, 'Inovação para Network Managers', NULL);
  323. INSERT INTO `corsi_translation` VALUES(34, 7, 'Currículo de Aprendizagem e Desenvolvimento', NULL);
  324. INSERT INTO `corsi_translation` VALUES(1, 8, 'Ο Ρόλος του Account Manager', NULL);
  325. INSERT INTO `corsi_translation` VALUES(2, 8, 'Το Περιβάλλον Τοπικής Υγειονομικής Περίθαλψης', NULL);
  326. INSERT INTO `corsi_translation` VALUES(3, 8, 'Σχεδιασμός Τοπικής Οικονομίας της Υγείας & Ανάλυση Δεδομένων', NULL);
  327. INSERT INTO `corsi_translation` VALUES(4, 8, 'Πελάτες', NULL);
  328. INSERT INTO `corsi_translation` VALUES(5, 8, 'Προτάσεις Αξίας Πελατών & Συμμόρφωση', NULL);
  329. INSERT INTO `corsi_translation` VALUES(6, 8, 'Έρευνα Αγοράς και Κατανόηση Πελατών', NULL);
  330. INSERT INTO `corsi_translation` VALUES(7, 8, 'Κύκλος Δραστηριοτήτων Πελατών και Πορείες Ασθενών', NULL);
  331. INSERT INTO `corsi_translation` VALUES(8, 8, 'Brand Training', NULL);
  332. INSERT INTO `corsi_translation` VALUES(9, 8, 'Διατμηματική Εργασία', NULL);
  333. INSERT INTO `corsi_translation` VALUES(10, 8, 'Προσδιορισμός Κοινών Στόχων - Αναγκών', NULL);
  334. INSERT INTO `corsi_translation` VALUES(11, 8, 'Πώληση σε Πελάτες', NULL);
  335. INSERT INTO `corsi_translation` VALUES(12, 8, 'Customer Selling Day', NULL);
  336. INSERT INTO `corsi_translation` VALUES(13, 8, 'Wellards', NULL);
  337. INSERT INTO `corsi_translation` VALUES(14, 8, 'Ενότητα 1 - Επαγγελματικό Account Management', NULL);
  338. INSERT INTO `corsi_translation` VALUES(15, 8, 'Ενότητα 2 - Σχεδιασμός Τοπικής Οικονομίας της Υγείας και Βαθιά Κατανόηση', NULL);
  339. INSERT INTO `corsi_translation` VALUES(16, 8, 'Ενότητα 3 - Δεξιότητες Διαπραγματεύσεων', NULL);
  340. INSERT INTO `corsi_translation` VALUES(17, 8, 'Καινοτομία για τους Account Managers', NULL);
  341. INSERT INTO `corsi_translation` VALUES(18, 8, 'Διδακτέα Ύλη Μάθησης και Ανάπτυξης', NULL);
  342. INSERT INTO `corsi_translation` VALUES(19, 8, 'Ο Ρόλος του Network Manager', NULL);
  343. INSERT INTO `corsi_translation` VALUES(20, 8, 'Το Περιβάλλον Τοπικής Υγειονομικής Περίθαλψης', NULL);
  344. INSERT INTO `corsi_translation` VALUES(21, 8, 'Σχεδιασμός Τοπικής Οικονομίας της Υγείας και Ανάλυση Δεδομένων', NULL);
  345. INSERT INTO `corsi_translation` VALUES(22, 8, 'Πελάτες', NULL);
  346. INSERT INTO `corsi_translation` VALUES(23, 8, 'Brand Training', NULL);
  347. INSERT INTO `corsi_translation` VALUES(24, 8, 'Διατμηματική Εργασία', NULL);
  348. INSERT INTO `corsi_translation` VALUES(25, 8, 'Εκπαίδευση σχετικά με τα Συνταγολόγια', NULL);
  349. INSERT INTO `corsi_translation` VALUES(26, 8, 'Προσδιορισμός Κοινών Στόχων - Αναγκών', NULL);
  350. INSERT INTO `corsi_translation` VALUES(27, 8, 'Πώληση σε Πελάτες', '');
  351. INSERT INTO `corsi_translation` VALUES(28, 8, 'Customer Selling Day', NULL);
  352. INSERT INTO `corsi_translation` VALUES(29, 8, 'Wellards', NULL);
  353. INSERT INTO `corsi_translation` VALUES(30, 8, 'Project Management Επίπεδο 1', NULL);
  354. INSERT INTO `corsi_translation` VALUES(31, 8, 'Project Management Επίπεδο 2', NULL);
  355. INSERT INTO `corsi_translation` VALUES(32, 8, 'Project Management Επίπεδο 3', NULL);
  356. INSERT INTO `corsi_translation` VALUES(33, 8, 'Καινοτομία για Network Managers', NULL);
  357. INSERT INTO `corsi_translation` VALUES(34, 8, 'Διδακτέα Ύλη Μάθησης και Ανάπτυξης', NULL);
  358.  
  359. -- --------------------------------------------------------
  360.  
  361. --
  362. -- Struttura della tabella `countries`
  363. --
  364.  
  365. CREATE TABLE `countries` (
  366.   `id_country` int(11) NOT NULL AUTO_INCREMENT,
  367.   `name` varchar(50) NOT NULL,
  368.   PRIMARY KEY (`id_country`)
  369. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
  370.  
  371. --
  372. -- Dump dei dati per la tabella `countries`
  373. --
  374.  
  375. INSERT INTO `countries` VALUES(1, 'Austria');
  376. INSERT INTO `countries` VALUES(2, 'Belgium');
  377. INSERT INTO `countries` VALUES(3, 'Bulgaria');
  378. INSERT INTO `countries` VALUES(4, 'Cyprus');
  379. INSERT INTO `countries` VALUES(5, 'Czech Republic');
  380. INSERT INTO `countries` VALUES(6, 'Denmark');
  381. INSERT INTO `countries` VALUES(7, 'Estonia');
  382. INSERT INTO `countries` VALUES(8, 'Finland');
  383. INSERT INTO `countries` VALUES(9, 'France');
  384. INSERT INTO `countries` VALUES(10, 'Germany');
  385. INSERT INTO `countries` VALUES(11, 'Greece');
  386. INSERT INTO `countries` VALUES(12, 'Hungary');
  387. INSERT INTO `countries` VALUES(13, 'Ireland');
  388. INSERT INTO `countries` VALUES(14, 'Italy');
  389. INSERT INTO `countries` VALUES(15, 'Latvia');
  390. INSERT INTO `countries` VALUES(16, 'Lithuania');
  391. INSERT INTO `countries` VALUES(17, 'Luxembourg');
  392. INSERT INTO `countries` VALUES(18, 'Malta');
  393. INSERT INTO `countries` VALUES(19, 'Netherlands');
  394. INSERT INTO `countries` VALUES(20, 'Poland');
  395. INSERT INTO `countries` VALUES(21, 'Portugal');
  396. INSERT INTO `countries` VALUES(22, 'Romania');
  397. INSERT INTO `countries` VALUES(23, 'Slovakia');
  398. INSERT INTO `countries` VALUES(24, 'Slovenia');
  399. INSERT INTO `countries` VALUES(25, 'Spain');
  400. INSERT INTO `countries` VALUES(26, 'Sweden');
  401. INSERT INTO `countries` VALUES(27, 'United Kingdom');
  402. INSERT INTO `countries` VALUES(28, 'Benelux');
  403. INSERT INTO `countries` VALUES(29, 'Switzerland');
  404. INSERT INTO `countries` VALUES(30, 'Norway');
  405.  
  406. -- --------------------------------------------------------
  407.  
  408. --
  409. -- Struttura della tabella `groups`
  410. --
  411.  
  412. CREATE TABLE `groups` (
  413.   `id_group` int(11) NOT NULL AUTO_INCREMENT,
  414.   `group_name` varchar(40) NOT NULL,
  415.   PRIMARY KEY (`id_group`)
  416. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
  417.  
  418. --
  419. -- Dump dei dati per la tabella `groups`
  420. --
  421.  
  422. INSERT INTO `groups` VALUES(1, 'root');
  423. INSERT INTO `groups` VALUES(2, 'manager');
  424. INSERT INTO `groups` VALUES(3, 'trainer');
  425. INSERT INTO `groups` VALUES(4, 'isf');
  426. INSERT INTO `groups` VALUES(5, 'maintrainer');
  427.  
  428. -- --------------------------------------------------------
  429.  
  430. --
  431. -- Struttura della tabella `isf`
  432. --
  433.  
  434. CREATE TABLE `isf` (
  435.   `id_isf` int(11) NOT NULL AUTO_INCREMENT,
  436.   `nome` varchar(250) NOT NULL,
  437.   `cognome` varchar(250) NOT NULL,
  438.   `fk_country` int(11) NOT NULL,
  439.   PRIMARY KEY (`id_isf`),
  440.   KEY `fk_country` (`fk_country`)
  441. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  442.  
  443. --
  444. -- Dump dei dati per la tabella `isf`
  445. --
  446.  
  447.  
  448. -- --------------------------------------------------------
  449.  
  450. --
  451. -- Struttura della tabella `lingue`
  452. --
  453.  
  454. CREATE TABLE `lingue` (
  455.   `id_lingua` int(11) NOT NULL AUTO_INCREMENT,
  456.   `lingua` varchar(40) NOT NULL,
  457.   PRIMARY KEY (`id_lingua`)
  458. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
  459.  
  460. --
  461. -- Dump dei dati per la tabella `lingue`
  462. --
  463.  
  464. INSERT INTO `lingue` VALUES(1, 'English');
  465. INSERT INTO `lingue` VALUES(2, 'Francese');
  466. INSERT INTO `lingue` VALUES(3, 'Italiano');
  467. INSERT INTO `lingue` VALUES(4, 'Tedesco');
  468. INSERT INTO `lingue` VALUES(5, 'Olandese');
  469. INSERT INTO `lingue` VALUES(6, 'Spagnolo');
  470. INSERT INTO `lingue` VALUES(7, 'Portoghese');
  471. INSERT INTO `lingue` VALUES(8, 'Greco');
  472.  
  473. -- --------------------------------------------------------
  474.  
  475. --
  476. -- Struttura della tabella `management`
  477. --
  478.  
  479. CREATE TABLE `management` (
  480.   `id_management` int(11) NOT NULL AUTO_INCREMENT,
  481.   `fk_user` int(11) NOT NULL,
  482.   `fk_country` int(11) NOT NULL,
  483.   `fk_language` int(11) NOT NULL,
  484.   `fk_corso` int(11) NOT NULL,
  485.   `fk_manager` int(11) DEFAULT NULL,
  486.   `english` int(11) NOT NULL DEFAULT '0',
  487.   PRIMARY KEY (`id_management`),
  488.   KEY `fk_corso` (`fk_corso`),
  489.   KEY `fk_language` (`fk_language`),
  490.   KEY `fk_country` (`fk_country`),
  491.   KEY `fk_user` (`fk_user`),
  492.   KEY `fk_manager` (`fk_manager`)
  493. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  494.  
  495. --
  496. -- Dump dei dati per la tabella `management`
  497. --
  498.  
  499.  
  500. -- --------------------------------------------------------
  501.  
  502. --
  503. -- Struttura della tabella `manager_groups`
  504. --
  505.  
  506. CREATE TABLE `manager_groups` (
  507.   `id_group` int(11) NOT NULL AUTO_INCREMENT,
  508.   `m_group` varchar(100) NOT NULL,
  509.   PRIMARY KEY (`id_group`)
  510. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  511.  
  512. --
  513. -- Dump dei dati per la tabella `manager_groups`
  514. --
  515.  
  516. INSERT INTO `manager_groups` VALUES(1, 'Account');
  517. INSERT INTO `manager_groups` VALUES(2, 'Network');
  518.  
  519. -- --------------------------------------------------------
  520.  
  521. --
  522. -- Struttura della tabella `managing_group`
  523. --
  524.  
  525. CREATE TABLE `managing_group` (
  526.   `fk_user` int(11) NOT NULL,
  527.   `fk_group` int(11) NOT NULL,
  528.   KEY `fk_user` (`fk_user`),
  529.   KEY `fk_group` (`fk_group`)
  530. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  531.  
  532. --
  533. -- Dump dei dati per la tabella `managing_group`
  534. --
  535.  
  536. INSERT INTO `managing_group` VALUES(1, 1);
  537. INSERT INTO `managing_group` VALUES(1, 2);
  538. INSERT INTO `managing_group` VALUES(2, 1);
  539. INSERT INTO `managing_group` VALUES(2, 2);
  540. INSERT INTO `managing_group` VALUES(3, 1);
  541. INSERT INTO `managing_group` VALUES(3, 2);
  542. INSERT INTO `managing_group` VALUES(4, 1);
  543. INSERT INTO `managing_group` VALUES(4, 2);
  544. INSERT INTO `managing_group` VALUES(5, 2);
  545. INSERT INTO `managing_group` VALUES(5, 2);
  546. INSERT INTO `managing_group` VALUES(8, 1);
  547. INSERT INTO `managing_group` VALUES(8, 2);
  548. INSERT INTO `managing_group` VALUES(8, 1);
  549. INSERT INTO `managing_group` VALUES(8, 2);
  550. INSERT INTO `managing_group` VALUES(10, 1);
  551. INSERT INTO `managing_group` VALUES(10, 2);
  552. INSERT INTO `managing_group` VALUES(11, 1);
  553. INSERT INTO `managing_group` VALUES(11, 2);
  554. INSERT INTO `managing_group` VALUES(12, 1);
  555. INSERT INTO `managing_group` VALUES(12, 2);
  556. INSERT INTO `managing_group` VALUES(13, 1);
  557. INSERT INTO `managing_group` VALUES(13, 2);
  558. INSERT INTO `managing_group` VALUES(14, 1);
  559. INSERT INTO `managing_group` VALUES(14, 2);
  560. INSERT INTO `managing_group` VALUES(15, 1);
  561. INSERT INTO `managing_group` VALUES(15, 2);
  562. INSERT INTO `managing_group` VALUES(16, 1);
  563. INSERT INTO `managing_group` VALUES(16, 2);
  564. INSERT INTO `managing_group` VALUES(17, 1);
  565. INSERT INTO `managing_group` VALUES(17, 2);
  566. INSERT INTO `managing_group` VALUES(18, 1);
  567. INSERT INTO `managing_group` VALUES(18, 2);
  568. INSERT INTO `managing_group` VALUES(19, 1);
  569. INSERT INTO `managing_group` VALUES(19, 2);
  570. INSERT INTO `managing_group` VALUES(20, 1);
  571. INSERT INTO `managing_group` VALUES(20, 2);
  572. INSERT INTO `managing_group` VALUES(21, 1);
  573. INSERT INTO `managing_group` VALUES(22, 1);
  574. INSERT INTO `managing_group` VALUES(23, 1);
  575. INSERT INTO `managing_group` VALUES(24, 1);
  576. INSERT INTO `managing_group` VALUES(25, 1);
  577. INSERT INTO `managing_group` VALUES(26, 1);
  578. INSERT INTO `managing_group` VALUES(27, 1);
  579. INSERT INTO `managing_group` VALUES(28, 1);
  580. INSERT INTO `managing_group` VALUES(28, 1);
  581. INSERT INTO `managing_group` VALUES(29, 1);
  582. INSERT INTO `managing_group` VALUES(30, 1);
  583. INSERT INTO `managing_group` VALUES(31, 1);
  584. INSERT INTO `managing_group` VALUES(32, 1);
  585. INSERT INTO `managing_group` VALUES(33, 1);
  586. INSERT INTO `managing_group` VALUES(34, 1);
  587. INSERT INTO `managing_group` VALUES(35, 1);
  588. INSERT INTO `managing_group` VALUES(36, 1);
  589. INSERT INTO `managing_group` VALUES(37, 1);
  590. INSERT INTO `managing_group` VALUES(38, 1);
  591. INSERT INTO `managing_group` VALUES(39, 1);
  592. INSERT INTO `managing_group` VALUES(40, 1);
  593. INSERT INTO `managing_group` VALUES(41, 1);
  594. INSERT INTO `managing_group` VALUES(42, 1);
  595. INSERT INTO `managing_group` VALUES(43, 1);
  596. INSERT INTO `managing_group` VALUES(44, 1);
  597. INSERT INTO `managing_group` VALUES(45, 2);
  598. INSERT INTO `managing_group` VALUES(46, 2);
  599. INSERT INTO `managing_group` VALUES(47, 2);
  600. INSERT INTO `managing_group` VALUES(22, 2);
  601. INSERT INTO `managing_group` VALUES(23, 2);
  602. INSERT INTO `managing_group` VALUES(24, 2);
  603. INSERT INTO `managing_group` VALUES(25, 2);
  604. INSERT INTO `managing_group` VALUES(26, 2);
  605. INSERT INTO `managing_group` VALUES(51, 2);
  606. INSERT INTO `managing_group` VALUES(52, 2);
  607. INSERT INTO `managing_group` VALUES(53, 2);
  608. INSERT INTO `managing_group` VALUES(54, 2);
  609. INSERT INTO `managing_group` VALUES(55, 2);
  610. INSERT INTO `managing_group` VALUES(57, 2);
  611. INSERT INTO `managing_group` VALUES(58, 2);
  612. INSERT INTO `managing_group` VALUES(59, 2);
  613. INSERT INTO `managing_group` VALUES(60, 2);
  614. INSERT INTO `managing_group` VALUES(61, 2);
  615. INSERT INTO `managing_group` VALUES(62, 2);
  616. INSERT INTO `managing_group` VALUES(63, 2);
  617. INSERT INTO `managing_group` VALUES(64, 2);
  618.  
  619. -- --------------------------------------------------------
  620.  
  621. --
  622. -- Struttura della tabella `nationality`
  623. --
  624.  
  625. CREATE TABLE `nationality` (
  626.   `fk_user` int(11) NOT NULL,
  627.   `fk_country` int(11) NOT NULL,
  628.   KEY `fk_user` (`fk_user`),
  629.   KEY `fk_country` (`fk_country`)
  630. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  631.  
  632. --
  633. -- Dump dei dati per la tabella `nationality`
  634. --
  635.  
  636. INSERT INTO `nationality` VALUES(1, 26);
  637. INSERT INTO `nationality` VALUES(1, 8);
  638. INSERT INTO `nationality` VALUES(1, 30);
  639. INSERT INTO `nationality` VALUES(1, 6);
  640. INSERT INTO `nationality` VALUES(2, 27);
  641. INSERT INTO `nationality` VALUES(2, 13);
  642. INSERT INTO `nationality` VALUES(3, 27);
  643. INSERT INTO `nationality` VALUES(3, 13);
  644. INSERT INTO `nationality` VALUES(4, 13);
  645. INSERT INTO `nationality` VALUES(4, 27);
  646. INSERT INTO `nationality` VALUES(5, 2);
  647. INSERT INTO `nationality` VALUES(5, 19);
  648. INSERT INTO `nationality` VALUES(8, 21);
  649. INSERT INTO `nationality` VALUES(10, 25);
  650. INSERT INTO `nationality` VALUES(11, 9);
  651. INSERT INTO `nationality` VALUES(12, 9);
  652. INSERT INTO `nationality` VALUES(13, 14);
  653. INSERT INTO `nationality` VALUES(14, 14);
  654. INSERT INTO `nationality` VALUES(15, 10);
  655. INSERT INTO `nationality` VALUES(16, 10);
  656. INSERT INTO `nationality` VALUES(17, 11);
  657. INSERT INTO `nationality` VALUES(18, 25);
  658. INSERT INTO `nationality` VALUES(19, 29);
  659. INSERT INTO `nationality` VALUES(19, 1);
  660. INSERT INTO `nationality` VALUES(20, 1);
  661. INSERT INTO `nationality` VALUES(20, 2);
  662. INSERT INTO `nationality` VALUES(20, 6);
  663. INSERT INTO `nationality` VALUES(20, 8);
  664. INSERT INTO `nationality` VALUES(20, 9);
  665. INSERT INTO `nationality` VALUES(20, 10);
  666. INSERT INTO `nationality` VALUES(20, 11);
  667. INSERT INTO `nationality` VALUES(20, 13);
  668. INSERT INTO `nationality` VALUES(20, 14);
  669. INSERT INTO `nationality` VALUES(20, 19);
  670. INSERT INTO `nationality` VALUES(20, 30);
  671. INSERT INTO `nationality` VALUES(20, 21);
  672. INSERT INTO `nationality` VALUES(20, 25);
  673. INSERT INTO `nationality` VALUES(20, 26);
  674. INSERT INTO `nationality` VALUES(20, 29);
  675. INSERT INTO `nationality` VALUES(20, 27);
  676. INSERT INTO `nationality` VALUES(21, 8);
  677. INSERT INTO `nationality` VALUES(22, 26);
  678. INSERT INTO `nationality` VALUES(23, 26);
  679. INSERT INTO `nationality` VALUES(24, 26);
  680. INSERT INTO `nationality` VALUES(25, 26);
  681. INSERT INTO `nationality` VALUES(26, 26);
  682. INSERT INTO `nationality` VALUES(27, 26);
  683. INSERT INTO `nationality` VALUES(28, 13);
  684. INSERT INTO `nationality` VALUES(29, 1);
  685. INSERT INTO `nationality` VALUES(30, 10);
  686. INSERT INTO `nationality` VALUES(31, 9);
  687. INSERT INTO `nationality` VALUES(32, 14);
  688. INSERT INTO `nationality` VALUES(33, 14);
  689. INSERT INTO `nationality` VALUES(34, 14);
  690. INSERT INTO `nationality` VALUES(35, 14);
  691. INSERT INTO `nationality` VALUES(36, 27);
  692. INSERT INTO `nationality` VALUES(37, 27);
  693. INSERT INTO `nationality` VALUES(38, 27);
  694. INSERT INTO `nationality` VALUES(39, 27);
  695. INSERT INTO `nationality` VALUES(40, 27);
  696. INSERT INTO `nationality` VALUES(41, 27);
  697. INSERT INTO `nationality` VALUES(42, 27);
  698. INSERT INTO `nationality` VALUES(43, 27);
  699. INSERT INTO `nationality` VALUES(44, 27);
  700. INSERT INTO `nationality` VALUES(45, 19);
  701. INSERT INTO `nationality` VALUES(46, 19);
  702. INSERT INTO `nationality` VALUES(47, 26);
  703. INSERT INTO `nationality` VALUES(50, 1);
  704. INSERT INTO `nationality` VALUES(51, 29);
  705. INSERT INTO `nationality` VALUES(52, 10);
  706. INSERT INTO `nationality` VALUES(53, 19);
  707. INSERT INTO `nationality` VALUES(54, 19);
  708. INSERT INTO `nationality` VALUES(55, 19);
  709. INSERT INTO `nationality` VALUES(57, 27);
  710. INSERT INTO `nationality` VALUES(58, 27);
  711. INSERT INTO `nationality` VALUES(59, 27);
  712. INSERT INTO `nationality` VALUES(60, 27);
  713. INSERT INTO `nationality` VALUES(61, 27);
  714. INSERT INTO `nationality` VALUES(62, 27);
  715. INSERT INTO `nationality` VALUES(63, 27);
  716. INSERT INTO `nationality` VALUES(64, 11);
  717.  
  718. -- --------------------------------------------------------
  719.  
  720. --
  721. -- Struttura della tabella `speaking`
  722. --
  723.  
  724. CREATE TABLE `speaking` (
  725.   `fk_user` int(11) NOT NULL,
  726.   `fk_lingua` int(11) NOT NULL,
  727.   KEY `fk_user` (`fk_user`),
  728.   KEY `fk_lingua` (`fk_lingua`)
  729. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  730.  
  731. --
  732. -- Dump dei dati per la tabella `speaking`
  733. --
  734.  
  735. INSERT INTO `speaking` VALUES(1, 1);
  736. INSERT INTO `speaking` VALUES(2, 1);
  737. INSERT INTO `speaking` VALUES(3, 1);
  738. INSERT INTO `speaking` VALUES(4, 1);
  739. INSERT INTO `speaking` VALUES(5, 1);
  740. INSERT INTO `speaking` VALUES(8, 1);
  741. INSERT INTO `speaking` VALUES(10, 1);
  742. INSERT INTO `speaking` VALUES(11, 1);
  743. INSERT INTO `speaking` VALUES(12, 1);
  744. INSERT INTO `speaking` VALUES(13, 1);
  745. INSERT INTO `speaking` VALUES(14, 1);
  746. INSERT INTO `speaking` VALUES(15, 1);
  747. INSERT INTO `speaking` VALUES(16, 1);
  748. INSERT INTO `speaking` VALUES(17, 1);
  749. INSERT INTO `speaking` VALUES(18, 1);
  750. INSERT INTO `speaking` VALUES(19, 1);
  751. INSERT INTO `speaking` VALUES(20, 1);
  752. INSERT INTO `speaking` VALUES(21, 1);
  753. INSERT INTO `speaking` VALUES(22, 1);
  754. INSERT INTO `speaking` VALUES(23, 1);
  755. INSERT INTO `speaking` VALUES(24, 1);
  756. INSERT INTO `speaking` VALUES(25, 1);
  757. INSERT INTO `speaking` VALUES(26, 1);
  758. INSERT INTO `speaking` VALUES(27, 1);
  759. INSERT INTO `speaking` VALUES(28, 1);
  760. INSERT INTO `speaking` VALUES(29, 4);
  761. INSERT INTO `speaking` VALUES(30, 4);
  762. INSERT INTO `speaking` VALUES(31, 2);
  763. INSERT INTO `speaking` VALUES(32, 3);
  764. INSERT INTO `speaking` VALUES(33, 3);
  765. INSERT INTO `speaking` VALUES(34, 3);
  766. INSERT INTO `speaking` VALUES(35, 3);
  767. INSERT INTO `speaking` VALUES(36, 1);
  768. INSERT INTO `speaking` VALUES(37, 1);
  769. INSERT INTO `speaking` VALUES(38, 1);
  770. INSERT INTO `speaking` VALUES(39, 1);
  771. INSERT INTO `speaking` VALUES(40, 1);
  772. INSERT INTO `speaking` VALUES(41, 1);
  773. INSERT INTO `speaking` VALUES(42, 1);
  774. INSERT INTO `speaking` VALUES(43, 1);
  775. INSERT INTO `speaking` VALUES(44, 1);
  776. INSERT INTO `speaking` VALUES(45, 5);
  777. INSERT INTO `speaking` VALUES(46, 5);
  778. INSERT INTO `speaking` VALUES(47, 1);
  779. INSERT INTO `speaking` VALUES(47, 1);
  780. INSERT INTO `speaking` VALUES(50, 4);
  781. INSERT INTO `speaking` VALUES(51, 4);
  782. INSERT INTO `speaking` VALUES(52, 4);
  783. INSERT INTO `speaking` VALUES(52, 4);
  784. INSERT INTO `speaking` VALUES(53, 5);
  785. INSERT INTO `speaking` VALUES(54, 5);
  786. INSERT INTO `speaking` VALUES(55, 5);
  787. INSERT INTO `speaking` VALUES(57, 1);
  788. INSERT INTO `speaking` VALUES(58, 1);
  789. INSERT INTO `speaking` VALUES(59, 1);
  790. INSERT INTO `speaking` VALUES(60, 1);
  791. INSERT INTO `speaking` VALUES(61, 1);
  792. INSERT INTO `speaking` VALUES(62, 1);
  793. INSERT INTO `speaking` VALUES(63, 1);
  794. INSERT INTO `speaking` VALUES(64, 8);
  795.  
  796. -- --------------------------------------------------------
  797.  
  798. --
  799. -- Struttura della tabella `users`
  800. --
  801.  
  802. CREATE TABLE `users` (
  803.   `id_user` int(11) NOT NULL AUTO_INCREMENT,
  804.   `code` varchar(512) NOT NULL,
  805.   `nome` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  806.   `cognome` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  807.   `email` varchar(255) NOT NULL,
  808.   `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  809.   `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  810.   `active` int(3) NOT NULL,
  811.   `code_account` varchar(512) NOT NULL,
  812.   `blocked_reason` text NOT NULL,
  813.   `fk_group` int(4) NOT NULL DEFAULT '3',
  814.   `choosen_country` int(11) NOT NULL,
  815.   PRIMARY KEY (`id_user`),
  816.   UNIQUE KEY `username_2` (`username`),
  817.   UNIQUE KEY `email` (`email`),
  818.   UNIQUE KEY `code` (`code`),
  819.   KEY `username` (`username`),
  820.   KEY `fk_group` (`fk_group`)
  821. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=65 ;
  822.  
  823. --
  824. -- Dump dei dati per la tabella `users`
  825. --
  826.  
  827. INSERT INTO `users` VALUES(1, 'gfidhhgiufdhiugf', 'Helene', 'Arrhult', 'Helene.Arrhult@pfizer.com', 'Helene.Arrhult@pfizer.com', '525dc8514aa8b19bb813c19c5aee7eb54e0090e6', 1, 't56jhjhgt', '', 3, 1);
  828. INSERT INTO `users` VALUES(2, '235423552', 'Tobin ', 'Grice', 'Tobin.Grice@pfizer.com', 'Tobin.Grice@pfizer.com', '1f060b0bd9e1adfaf2d4d57cae9bf7b6cdb73a3a', 1, '2453435', '', 3, 1);
  829. INSERT INTO `users` VALUES(3, '5524235', 'Michelle ', 'Groove', 'Michelle.D.Groves@pfizer.com', 'Michelle.D.Groves@pfizer.com', 'b9953bc1359bbd3be6aeb968bb14512ebae982db', 1, '453453634', '', 3, 1);
  830. INSERT INTO `users` VALUES(4, '32342342', 'Lorraine ', 'Hoodless', 'Lorraine.Hoodless@Pfizer.com', 'Lorraine.Hoodless@Pfizer.com', 'ad9ad12a00faf545bd124d9d8fbb07a392feb300', 1, '475075940', '', 3, 1);
  831. INSERT INTO `users` VALUES(5, '457524572', 'Ariane ', 'Jacobs', 'Ariane.Jacobs@pfizer.com', 'Ariane.Jacobs@pfizer.com', '4d37de3c17ff0e50f634ef7cedc03928cf3bc45d', 1, '4142424254242', '', 3, 1);
  832. INSERT INTO `users` VALUES(8, '2342734923741qa', 'Angela ', 'Pinto', 'Angela.B.Pinto@Pfizer.com', 'Angela.B.Pinto@Pfizer.com', '17f65e07180ffcf60bd3ad82c6bddf0e926af2f2', 1, '542750729571', '', 3, 1);
  833. INSERT INTO `users` VALUES(10, '3424241279auq', 'Raquel ', 'Guzman', 'raquel.guzman@pfizer.com', 'raquel.guzman@pfizer.com', '86e42aaa6ac47b0542d6d74930da4de4b66a19db', 1, 'hddh8818181', '', 3, 1);
  834. INSERT INTO `users` VALUES(11, 'ghidh283268326', 'Gilles ', 'Devaux', 'Gilles.Devaux@pfizer.com', 'Gilles.Devaux@pfizer.com', 'fbe9302c51fa0fe19ddeb3c827d30d46ed565fed', 1, '4324982797', '', 3, 1);
  835. INSERT INTO `users` VALUES(12, '124141fffff', 'Lionel ', 'Garcia', 'Lionel.Garcia@pfizer.com', 'Lionel.Garcia@pfizer.com', '4afc2773a1f12f70e60f07e5f8ea62c96929ffa5', 1, 'y97f97f9qy9', '', 3, 1);
  836. INSERT INTO `users` VALUES(13, 'afafiuahfa777a', 'Giorgio ', 'Mancadori', 'Giorgio.Mancadori@Pfizer.com', 'Giorgio.Mancadori@Pfizer.com', '14a6dde0b97aca6551eda51a20798fdee9bcfce8', 1, '5555gg33ss22', '', 3, 1);
  837. INSERT INTO `users` VALUES(14, '3424ggg22111', 'Enrico ', 'Vivalda', 'Enrico.Vivalda@Pfizer.com', 'Enrico.Vivalda@Pfizer.com', '2fc2a7d8322d7afdce25ddfc9e38a49d061e43ab', 1, '372974294792479', '', 3, 1);
  838. INSERT INTO `users` VALUES(15, '13488f8f8f8', 'Dennis ', 'Bosselmann', 'Dennis.Bosselmann@Pfizer.com', 'Dennis.Bosselmann@Pfizer.com', '616146932e3f7ec008af8bc09095efffb4da4c70', 1, '12419791hfihfihfih11', '', 3, 1);
  839. INSERT INTO `users` VALUES(16, '3473947394739', 'Harald ', 'Volz', 'Harald.Volz@Pfizer.com', 'Harald.Volz@Pfizer.com', '0f6459a45a7a66d6f56c34a3fa8beb68d284d7ed', 1, '35734747271', '', 3, 1);
  840. INSERT INTO `users` VALUES(17, '32478shshs', 'Athanasia ', 'Korda', 'Athanasia.korda@Pfizer.com', 'Athanasia.korda@Pfizer.com', '3e22146e23bf37a52ea69ca888259b1d9b515884', 1, '791e99u9f9y97927', '', 3, 1);
  841. INSERT INTO `users` VALUES(18, '68267802678021a', 'Antonio', 'Bernabeu', 'anton.bernabeu@pfizer.com', 'anton.bernabeu@pfizer.com', '4d34a9ff5d80b9928f8c36e4426cde8cdb6a90dc', 1, '4377fu7auf77fy9', '', 3, 1);
  842. INSERT INTO `users` VALUES(19, '4237592759yff', 'Anja', 'Kaufmann', 'anja.j.kaufmann@pfizer.com', 'anja.j.kaufmann@pfizer.com', '0f6459a45a7a66d6f56c34a3fa8beb68d284d7ed', 1, '3477f77f7f7f7f7', '', 3, 1);
  843. INSERT INTO `users` VALUES(20, 'asfuaosd27372', 'Susie', 'Rixon', 'susie.rixon@pfizer.com', 'susie.rixon@pfizer.com', '32e14553ede98db715eb298287042a86662b294e', 1, '347247hjsh', '', 5, 1);
  844. INSERT INTO `users` VALUES(21, '3439179179171aaww', 'Tero ', 'Ylitalo', 'Tero.ylitalo@pfizer.com', 'Tero.ylitalo@pfizer.com', '7ca9c5dd530b1853c301961e8564508a75881dd4', 1, '57389379999999qa', '', 2, 1);
  845. INSERT INTO `users` VALUES(22, '3427047214714792174', 'Ola ', 'Sandborgh', 'Ola.sandborgh@pfizer.com', 'Ola.sandborgh@pfizer.com', '2cfca7be3a38cf7a175e7ce011a0779269262208', 1, '2345702502ufwj8208', '', 2, 1);
  846. INSERT INTO `users` VALUES(23, '124689346384638', 'Dick ', 'Westerlund', 'Dick.westerlund@pfizer.com', 'Dick.westerlund@pfizer.com', 'f1d7d73661fa0a5022e8ac51fb3d91df57112c43', 1, '752895792u347937', '', 2, 1);
  847. INSERT INTO `users` VALUES(24, '23y272h2h2828282828', 'Henrik', 'Rommedahl', 'Henrik.rommedahl@pfizer.com', 'Henrik.rommedahl@pfizer.com', 'd7b28dfdd4a01b3a8843dd67cb710db30fbdcc24', 1, '138101801801u2u', '', 2, 1);
  848. INSERT INTO `users` VALUES(25, 'asdhuia6777', 'Kim', 'Persson', 'Kim.persson@pfizer.com', 'Kim.persson@pfizer.com', '5c117654175fe13bb12f56d2c255b3f77f500542', 1, '741749719471h', '', 2, 1);
  849. INSERT INTO `users` VALUES(26, '3722723rhfi', 'Dusko ', 'Stojanovic', 'Dusko.stojanovic@pfizer.com', 'Dusko.stojanovic@pfizer.com', 'f95b28a00e400ede955ae3039809fc08af6bb6ff', 1, '3722723rhfi', '', 2, 1);
  850. INSERT INTO `users` VALUES(27, 'ahuip2y8972983729729', 'Magnus', 'Forss', 'magnus.forss@pfizer.com', 'magnus.forss@pfizer.com', 'b71dc499b5c25e3bfa3f9e748e6a95c0871e6787', 1, '0285082502hoho', '', 2, 1);
  851. INSERT INTO `users` VALUES(28, '2347234y892h', 'Ciaran ', 'McGreal', 'Ciaran.McGreal@Pfizer.com', 'Ciaran.McGreal@Pfizer.com', 'e87dce4ca96fefc439c156a17ea094b72114aa71', 1, '35727252h9h2y2', '', 2, 1);
  852. INSERT INTO `users` VALUES(29, 'q72389273927392j', 'Macher', 'Stefan', 'macher.stefan@pfizer.com', 'macher.stefan@pfizer.com', '0c6f06f3a7d0f8c7b4de03100f955fdd93adf7b7', 1, '347349hfhfhfy9292', '', 2, 1);
  853. INSERT INTO `users` VALUES(30, 'asd2e141414141h11u', 'Claus', 'Roeder', 'claus.roeder@pfizer.com', 'claus.roeder@pfizer.com', 'ac70a80b289062b588cc7ad531d93093017fe067', 1, '471294729472947298472', '', 2, 1);
  854. INSERT INTO `users` VALUES(31, '27402402402840284028', 'Pierre Yves ', 'Deydier', 'Pierre-yves.deydier@pfizer.com', 'Pierre-yves.deydier@pfizer.com', 'f037a960d64f42be7efc1bb7e4652099fd35990f', 1, '34724927849274927', '', 2, 1);
  855. INSERT INTO `users` VALUES(32, '1238710810810', 'Agostino', 'Grisoni', 'Agostino.grisoni@pfizer.com', 'Agostino.grisoni@pfizer.com', '3ae3a4da395e284cffed6245fc11f61cd38d2023', 1, '417490140180', '', 2, 1);
  856. INSERT INTO `users` VALUES(33, '123131231231231312', 'Stefano', 'Orselli', 'Stefano.orselli@pfizer.com', 'Stefano.orselli@pfizer.com', 'ba8074100d1fe69c3f7e7bfee1f3468815472cf0', 1, '12312313123211331', '', 2, 1);
  857. INSERT INTO `users` VALUES(34, '1239ihfiahy99u99u9u9u', 'Michele', 'Simeoni', 'Michele.simeoni@pfizer.com', 'Michele.simeoni@pfizer.com', '3c9a4843720a5c122c9f5888e131a6c893e369b2', 1, '323728974947924729u9h', '', 2, 1);
  858. INSERT INTO `users` VALUES(35, '217272h82he9h', 'Antonio', 'Greco', 'Antoniocarmelo.greco@pfizer.com', 'Antoniocarmelo.greco@pfizer.com', '4b39433bfd049cce73c0998682c7af55314bb025', 1, '217272h82he9h', '', 2, 1);
  859. INSERT INTO `users` VALUES(36, '1y1hfhf99901', 'Steven ', 'Ball', 'Stephen.Ball@Pfizer.com', 'Stephen.Ball@Pfizer.com', 'd7136bdab8efc66aa08553ebf5d9e0bd9965d3ff', 1, '284082402u04j', '', 2, 1);
  860. INSERT INTO `users` VALUES(37, '12y91y91y91y91y9y9y1', 'Nicky ', 'Beardmore', 'Nicky.Beardmore@pfizer.com', 'Nicky.Beardmore@pfizer.com', '305c9682b0f34f38633bd551fee8afba4eb3ef91', 1, '4u1094u1094u104uy1', '', 2, 1);
  861. INSERT INTO `users` VALUES(38, 'asda23242415151515', 'Karen ', 'Davies', 'Karen.D.Davies@Pfizer.com', 'Karen.D.Davies@Pfizer.com', 'fe52526d6b2fa9a6041ae4e935878cd28b64f796', 1, '2481048018108401', '', 2, 1);
  862. INSERT INTO `users` VALUES(39, '1717111919191h1h19h91', 'Susan ', 'Donaldson', 'Susan.Donaldson@Pfizer.com', 'Susan.Donaldson@Pfizer.com', '9afd0bf59b7df3cef02dd0e450f36d9049b43aa7', 1, '4184184018401401u40j', '', 2, 1);
  863. INSERT INTO `users` VALUES(40, '12371037104u104u1041', 'Stephen ', 'Fensome       ', 'Stephen.Fensome@Pfizer.com', 'Stephen.Fensome@Pfizer.com', '53a6a9268245459e3832f2e9590392dedec3e4a7', 1, '27025002025u02j502j0j', '', 2, 1);
  864. INSERT INTO `users` VALUES(41, '234283582528528951010', 'Alexis ', 'Moss', 'Alexis.Moss@Pfizer.com', 'Alexis.Moss@Pfizer.com', 'b10dd3650ac6f2916fbbff34f06028cd57183040', 1, '51020u205u205u205820', '', 2, 1);
  865. INSERT INTO `users` VALUES(42, '838382j1j2j901', 'Richard ', 'Price                 ', 'Richard.H.Price@Pfizer.com', 'Richard.H.Price@Pfizer.com', '4c155bd1efb7541cb274d651ce9c5cf5973a8a59', 1, '234792ur9u9fu2975', '', 2, 1);
  866. INSERT INTO `users` VALUES(43, '12134h4h4h4h4', 'Steve ', 'Skyrme                ', 'Stephen.Skyrme@pfizer.com', 'Stephen.Skyrme@pfizer.com', 'a8a9659ea76c7c8d420f2635cc8de0b4b7cc8678', 1, 'q8f19hhhhahoahfoh', '', 2, 1);
  867. INSERT INTO `users` VALUES(44, '1919191uyfhfhfy', 'Simon ', 'Whitehad            ', 'Simon.Whitehead@pfizer.com', 'Simon.Whitehead@pfizer.com', 'c3209d781693b7c682bbc43dada616496bae40b1', 1, '3239293u2932u9j', '', 2, 1);
  868. INSERT INTO `users` VALUES(45, '142717147194719', 'Marina ', 'Kievit', 'Marina.kievit@pfizer.com', 'Marina.kievit@pfizer.com', '686177ef10fb5b0cb956f33af9c808daa528ea1b', 1, '284024082048080', '', 2, 1);
  869. INSERT INTO `users` VALUES(46, '48108048018108109', 'Johan ', 'van Doornen', 'Johan.VanDoornen@pfizer.com', 'Johan.VanDoornen@pfizer.com', '48cf3bbec12a819c48d1b7320c5f131dcc305fcb', 1, '48108048018108109', '', 2, 1);
  870. INSERT INTO `users` VALUES(47, 'asd72893719797979792379172979', 'Lena', 'Helin', 'Lena.helin@pfizer.com', 'Lena.helin@pfizer.com', 'afa7bf208e20eb5f4d7a6f3effff11862eacbc56', 1, '248041947197194719471974197', '', 2, 1);
  871. INSERT INTO `users` VALUES(50, '12314141414141224', 'Florian', 'Modler', 'florian.modler@pfizer.com', 'florian.modler@pfizer.com', '9b1250eaf14f603a385532acfd449c8e5ffa5fc5', 1, '1479104714714710', '', 2, 1);
  872. INSERT INTO `users` VALUES(51, '23417gfhf09', 'Ralph', 'Studer', 'ralph.studer@pfizer.com', 'ralph.studer@pfizer.com', '99f3ee0e68c8f4b97e43e7c9c66bf61282092f96', 1, '427427427fy9f9y1', '', 2, 1);
  873. INSERT INTO `users` VALUES(52, 'guuhuhuhuhudah2793729731', 'Oliver', 'Karpf', 'oliver.karpf@pfizer.com ', 'oliver.karpf@pfizer.com ', '69d5c903cb6ee9ca8c4c4c6930b76a623b375d39', 1, '247234092302492uh', '', 2, 1);
  874. INSERT INTO `users` VALUES(53, '24829048204820f0j2f0j2f02jf0', 'Mariet ', 'ten Haaf', 'Mariet.tenhaaf@pfizer.com', 'Mariet.tenhaaf@pfizer.com', '66ffd84eacb48464f8ab8399f581cd10a8bb497f', 1, '24829048204820f0j2f0j2f02jf0', '', 2, 1);
  875. INSERT INTO `users` VALUES(54, 'asfy89y9y9h9h9h', 'Saskia ', 'Bootsma', 'Saskia.bootsma@pfizer.com', 'Saskia.bootsma@pfizer.com', '6460d1a779f7f488fed4430c9ffa9b309767daca', 1, 'ugu0uyy3y9y9yh', '', 2, 1);
  876. INSERT INTO `users` VALUES(55, 'ad6868ha66f6fhfhfh', 'Arno ', 'Vonk', 'Arno.vonk@pfizer.com', 'Arno.vonk@pfizer.com', '9616f11e2927ed20496cfe9d074f7bd06962bf34', 1, '5727y2h8yt9t2yy9', '', 2, 1);
  877. INSERT INTO `users` VALUES(57, '22222jhsyfayf9ajhf9aj9yh', 'Paul', 'Bobin', 'Paul.k.bobin@pfizer.com', 'Paul.k.bobin@pfizer.com', '6cc6a64b5c03716f33e27a8bf9e0098b8f6881b9', 1, '3478205295u295y92h9', '', 2, 1);
  878. INSERT INTO `users` VALUES(58, '882ijk283hfh9hh', 'Bob', 'Spencer', 'Bob.g.spencer@pfizer.com', 'Bob.g.spencer@pfizer.com', '90ec544ba6587aed6d158852f709b1fdb30cef97', 1, '567fytf8rf9gt9gg666', '', 2, 1);
  879. INSERT INTO `users` VALUES(59, 'aasafay79y9h93h9y2u29j9h', 'Paul', 'Newson', 'Paul.newson@pfizer.com', 'Paul.newson@pfizer.com', '94f38467ab8c8f89fba2fab837abbc0de18ed8cd', 1, '45y8925y295h295h295h925', '', 2, 1);
  880. INSERT INTO `users` VALUES(60, 'asdasdasdasd2222', 'Tom', 'Jeffers', 'Tom.Jeffers@pfizer.com', 'Tom.Jeffers@pfizer.com', 'c66407f3ca2976517458ebd10dee85d528035e0f', 1, 'fh7h57457575j9fj9wjf', '', 2, 1);
  881. INSERT INTO `users` VALUES(61, 'asdad8888d888d888', 'Sarah', 'Sunderland', 'Sarah.E.Sunderland@pfizer.com', 'Sarah.E.Sunderland@pfizer.com', 'f902f09c48aac5fdbdc389271d704daa', 1, '25u025u205u205h295yj', '', 2, 1);
  882. INSERT INTO `users` VALUES(62, '23424888jjjf0', 'Alex', 'Davies', 'Alex.J.Davies@pfizer.com', 'Alex.J.Davies@pfizer.com', '0a532cdeb553715da0fe5daa27bb98944ba30dd5', 1, '35385jjjg9g9g9', '', 2, 1);
  883. INSERT INTO `users` VALUES(63, '111118883883883hggg', 'John ', 'Walker   ', 'John.F.Walker@Pfizer.com', 'John.F.Walker@Pfizer.com', 'cf3540d334f8ccdef2badde9fa2458488e5aa63c', 1, '4532y9292h5923h592h59', '', 2, 1);
  884. INSERT INTO `users` VALUES(64, '28189181y91y19y18h18h', 'Apostolos ', 'Pittas', 'Apostolos.pittas@pfizer.com', 'Apostolos.pittas@pfizer.com', 'a2e0505d076633871b25e1c3fdadc73d22caa6cf', 1, 'uofa9yf9ahf8agf8ga8ga8fg', '', 2, 1);
  885.  
  886. --
  887. -- Limiti per le tabelle scaricate
  888. --
  889.  
  890. --
  891. -- Limiti per la tabella `isf`
  892. --
  893. ALTER TABLE `isf`
  894.   ADD CONSTRAINT `isf_ibfk_1` FOREIGN KEY (`fk_country`) REFERENCES `countries` (`id_country`) ON DELETE CASCADE ON UPDATE CASCADE;
  895.  
  896. --
  897. -- Limiti per la tabella `management`
  898. --
  899. ALTER TABLE `management`
  900.   ADD CONSTRAINT `management_ibfk_2` FOREIGN KEY (`fk_country`) REFERENCES `countries` (`id_country`),
  901.   ADD CONSTRAINT `management_ibfk_3` FOREIGN KEY (`fk_language`) REFERENCES `lingue` (`id_lingua`),
  902.   ADD CONSTRAINT `management_ibfk_4` FOREIGN KEY (`fk_corso`) REFERENCES `corsi` (`id_corso`),
  903.   ADD CONSTRAINT `management_ibfk_5` FOREIGN KEY (`fk_user`) REFERENCES `isf` (`id_isf`),
  904.   ADD CONSTRAINT `management_ibfk_6` FOREIGN KEY (`fk_manager`) REFERENCES `users` (`id_user`);
  905.  
  906. --
  907. -- Limiti per la tabella `nationality`
  908. --
  909. ALTER TABLE `nationality`
  910.   ADD CONSTRAINT `nationality_ibfk_1` FOREIGN KEY (`fk_user`) REFERENCES `users` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE,
  911.   ADD CONSTRAINT `nationality_ibfk_2` FOREIGN KEY (`fk_country`) REFERENCES `countries` (`id_country`) ON DELETE CASCADE ON UPDATE CASCADE;
  912.  
  913. --
  914. -- Limiti per la tabella `speaking`
  915. --
  916. ALTER TABLE `speaking`
  917.   ADD CONSTRAINT `speaking_ibfk_1` FOREIGN KEY (`fk_user`) REFERENCES `users` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE,
  918.   ADD CONSTRAINT `speaking_ibfk_2` FOREIGN KEY (`fk_lingua`) REFERENCES `lingue` (`id_lingua`) ON DELETE CASCADE ON UPDATE CASCADE;
  919.  
  920. --
  921. -- Limiti per la tabella `users`
  922. --
  923. ALTER TABLE `users`
  924.   ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`fk_group`) REFERENCES `groups` (`id_group`) ON DELETE CASCADE ON UPDATE CASCADE;
create a new version of this paste RAW Paste Data