API tools faq
paste
PoisonCode

www.saladesituacion.gob.pa

PoisonCode
Dec 23rd, 2015
203
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 59.62 KB | None | 0 0
raw download clone embed print report
  1. (_____ \ (_) / _____) | |
  2. _____) )__ _ ___ ___ ____ | / ___ _ | | ____
  3. | ____/ _ \| |/___)/ _ \| _ \| | / _ \ / || |/ _ )
  4. | | | |_| | |___ | |_| | | | | \____| |_| ( (_| ( (/ /
  5. |_| \___/|_(___/ \___/|_| |_|\______)___/ \____|\____)
  6.  
  7. | __ \ / ____| (_) |
  8. | |__) | (___ ___ ___ _ _ _ __ _| |_ _ _
  9. | ___/ \___ \ / _ \/ __| | | | '__| | __| | | |
  10. | | ____) | __/ (__| |_| | | | | |_| |_| |
  11. |_| |_____/ \___|\___|\__,_|_| |_|\__|\__, |
  12. __/ |
  13. |___/
  14.  
  15. -- phpMyAdmin SQL Dump
  16. -- version 2.11.1
  17. -- http://www.phpmyadmin.net
  18. --
  19. -- Host: localhost
  20. -- Generation Time: Feb 21, 2008 at 11:12 AM
  21. -- Server version: 3.23.32
  22. -- PHP Version: 5.2.4
  23.  
  24.  
  25. --
  26. -- Database: `test_influenza`
  27. --
  28.  
  29. -- --------------------------------------------------------
  30.  
  31. --
  32. -- Table structure for table `antesvacunales`
  33. --
  34.  
  35. CREATE TABLE IF NOT EXISTS `antesvacunales` (
  36. `NUM_ID` int(11) NOT NULL auto_increment,
  37. `VACUNA_ANTIINFLUENZA` tinyint(1) NOT NULL,
  38. `NUMERO_DE_DOSIS` varchar(1) NOT NULL,
  39. `FECHA_ULTIMA_DOSIS` date NOT NULL,
  40. `VAC_HAEM_INFLUENZA` tinyint(1) NOT NULL,
  41. `NUMERO_DOSIS_VAC_HAEM` varchar(2) NOT NULL,
  42. `FECHA_ULT_DOSIS_VAC_HAEM` date NOT NULL,
  43. `VAC_NEUMO_HEPTAVALENTE` tinyint(1) NOT NULL,
  44. `NUMERO_DOSIS_VAC_NEUMHEPTA` varchar(1) NOT NULL,
  45. `FECHA_ULT_DOSIS_VAC_NEUM_HEPTA` date NOT NULL,
  46. `VACUNA_NEUMO_23_VALENTE` tinyint(1) NOT NULL,
  47. `NUMERO_DOSIS_VAC_NEUMO_23_VALENTE` varchar(1) NOT NULL,
  48. `FECHA_ULT_DOSIS_VAC_NEUMO_23_VALENTE` date NOT NULL,
  49. `VACUNA_ANTIMENINGOCOCICA` tinyint(1) NOT NULL,
  50. `NUMERO_DOSIS_VACUNA_ANTIMENINGOCOCICA` varchar(2) NOT NULL,
  51. `FECHA_ULT_DOSIS_VAC_ANTIMENINGOCOCICA` date NOT NULL,
  52. `NOMBRE_VACUNA_ANTIMENINGOCOCO` varchar(25) NOT NULL,
  53. `TIPO_EVENTO_EN_ESTUDIO` varchar(15) NOT NULL,
  54. PRIMARY KEY (`NUM_ID`)
  55. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
  56.  
  57. --
  58. -- RELATIONS FOR TABLE `antesvacunales`:
  59. -- `NUM_ID`
  60. -- `basic_information` -> `NUM_ID`
  61. --
  62.  
  63. --
  64. -- Dumping data for table `antesvacunales`
  65. --
  66.  
  67. INSERT INTO `antesvacunales` (`NUM_ID`, `VACUNA_ANTIINFLUENZA`, `NUMERO_DE_DOSIS`, `FECHA_ULTIMA_DOSIS`, `VAC_HAEM_INFLUENZA`, `NUMERO_DOSIS_VAC_HAEM`, `FECHA_ULT_DOSIS_VAC_HAEM`, `VAC_NEUMO_HEPTAVALENTE`, `NUMERO_DOSIS_VAC_NEUMHEPTA`, `FECHA_ULT_DOSIS_VAC_NEUM_HEPTA`, `VACUNA_NEUMO_23_VALENTE`, `NUMERO_DOSIS_VAC_NEUMO_23_VALENTE`, `FECHA_ULT_DOSIS_VAC_NEUMO_23_VALENTE`, `VACUNA_ANTIMENINGOCOCICA`, `NUMERO_DOSIS_VACUNA_ANTIMENINGOCOCICA`, `FECHA_ULT_DOSIS_VAC_ANTIMENINGOCOCICA`, `NOMBRE_VACUNA_ANTIMENINGOCOCO`, `TIPO_EVENTO_EN_ESTUDIO`) VALUES
  68. (3, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  69. (2, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  70. (1, 1, '1', '2007-05-10', 0, '0', '0000-00-00', 0, '0', '0000-00-00', 0, '0', '0000-00-00', 0, '0', '0000-00-00', '', 'Sindrome Gripal'),
  71. (4, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  72. (5, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  73. (6, 0, '0', '0000-00-00', 0, '0', '0000-00-00', 0, '0', '0000-00-00', 0, '0', '0000-00-00', 0, '0', '0000-00-00', '', 'Sindrome Gripal'),
  74. (7, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  75. (8, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  76. (9, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  77. (10, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  78. (11, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  79. (12, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  80. (13, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  81. (14, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  82. (15, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  83. (16, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  84. (17, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  85. (18, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  86. (19, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  87. (20, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  88. (21, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  89. (22, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', ''),
  90. (23, 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', 0, '', '0000-00-00', '', '');
  91.  
  92. -- --------------------------------------------------------
  93.  
  94. --
  95. -- Table structure for table `basic_information`
  96. --
  97.  
  98. CREATE TABLE IF NOT EXISTS `basic_information` (
  99. `NUM_ID` int(11) NOT NULL auto_increment,
  100. `NOMBRE` varchar(25) NOT NULL,
  101. `APELLIDO` varchar(25) NOT NULL,
  102. `CEDULA` varchar(15) NOT NULL,
  103. `NUMERO_HC_SS` varchar(15) NOT NULL,
  104. `SS` tinyint(1) NOT NULL,
  105. `EDAD` int(11) NOT NULL,
  106. `GRUPO_EDAD` varchar(8) NOT NULL,
  107. `SEXO` varchar(20) NOT NULL,
  108. `PROVINCIA` varchar(20) NOT NULL,
  109. `CODIGO_PROVINCIA` varchar(2) NOT NULL,
  110. `REGION` varchar(3) NOT NULL,
  111. `DISTRITO` varchar(25) NOT NULL,
  112. `CODIGO_DISTRITO` varchar(6) NOT NULL,
  113. `CORREGIMIENTO` varchar(25) NOT NULL,
  114. `CODIGO_REGIMIENTO` varchar(8) NOT NULL,
  115. `LOCALIDAD` text NOT NULL,
  116. `TIPO_DE_PACIENTE` varchar(15) NOT NULL,
  117. `INSTALACION` varchar(25) NOT NULL,
  118. `OTRA_INSTALACION` varchar(25) NOT NULL,
  119. PRIMARY KEY (`NUM_ID`),
  120. UNIQUE KEY `CEDULA` (`CEDULA`)
  121. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
  122.  
  123. --
  124. -- Dumping data for table `basic_information`
  125. --
  126.  
  127. INSERT INTO `basic_information` (`NUM_ID`, `NOMBRE`, `APELLIDO`, `CEDULA`, `NUMERO_HC_SS`, `SS`, `EDAD`, `GRUPO_EDAD`, `SEXO`, `PROVINCIA`, `CODIGO_PROVINCIA`, `REGION`, `DISTRITO`, `CODIGO_DISTRITO`, `CORREGIMIENTO`, `CODIGO_REGIMIENTO`, `LOCALIDAD`, `TIPO_DE_PACIENTE`, `INSTALACION`, `OTRA_INSTALACION`) VALUES
  128. (1, 'test', 'test', '1-987-1578', '15131412', 1, 26, '25-34', '0', 'PANAMA', '5', 'BDT', 'PANAMA', '0101', 'PANAMA ', '010101', 'das jhgu hgjyt jhgt 986', 'Hospitalizado', '3', ''),
  129. (2, '', '', '47262308', '', 1, 0, '1 ano', '0', '', '', 'BDT', '', '', '', '', '', ' ', '', ''),
  130. (3, '', '', '4-726-308', '', 1, 25, '25-34', '1', 'Chiricana', '04', 'BDT', 'bugaba', '0404', '', '', '', 'Ambulatorio', '5', ''),
  131. (4, 'Esmeralda', 'Mosquera', '5-11-627', '', 0, 43, '35-49', '1', 'PANAMA', '8', 'BDT', 'PANAMA', '', 'CURUNDU', '080805', 'CURUNDU, SANTANA', ' ', '3', ''),
  132. (5, '', '', '', '', 1, 0, '1 ano', '0', '', '', 'BDT', '', '', '', '', '', ' ', '', ''),
  133. (6, 'Gilberto', 'De leon', '6-73-784', '125-3785', 1, 36, '35-49', '0', 'panama', '08', 'MET', 'panama', '0808', 'PANAMA ', '080807', 'Bella vista edificio imperial piso 2', 'Ambulatorio', '1', ''),
  134. (7, 'Melanie', 'Lopez', '8-1054-1982', '', 0, 6, '1 ano', '1', 'panama', '8', 'MET', 'arraijan', '', 'el tecal', '', 'Vista Alegre Calle 15 Casa m-305', 'Hospitalizado', '2', ''),
  135. (8, 'Edgar', 'Rodriguez', '0-00-0000', '', 0, 6, '1 ano', '0', 'PANAMA', '8', 'BDT', 'TOCUMEN', '', 'CABUYA', '', '', 'Ambulatorio', '13', ''),
  136. (9, 'Leuris', 'Mendoza', '8-1030-131', '', 0, 2, '1-4', '1', '', '', 'BDT', '', '', '', '', 'CUBILLA, Sector #3-#337', 'Hospitalizado', '2', ''),
  137. (10, 'abdiel', 'loaiza', '8-1004-1779', '', 0, 4, '1-4', '0', 'panama', '8', 'MET', 'panama', '0808', 'juan diaz', '080812', 'juan diaz. altos de las acacias; calle 18. casa 14-15.', 'Ambulatorio', '2', ''),
  138. (11, 'jeremias', 'ortega', '8-253488', '', 0, 46, '35-49', '0', 'panama', '8', 'MET', 'chilibre', '0808', 'chilibre', '080815', 'chilibre, calle 8, casa 853', 'Ambulatorio', '', ''),
  139. (12, 'cristobalina', 'santos', '8-744-623', '', 0, 26, '25-34', '1', 'panama', '8', 'BDT', 'arraijan', '', '', '', 'arraijan, calle 4, casa 88', 'Ambulatorio', '', ''),
  140. (13, 'diego', 'lasso', '8-1030-2426', '', 0, 29, '1 ano', '0', 'panama', '', 'BDT', '', '', 'parque le--febre', '080810', 'calle primera, casa 360', 'Ambulatorio', '2', ''),
  141. (14, 'Test2', 'Test2', '1-454-2312', '125-7889', 1, 26, '25-34', '0', 'PANAMA', '8', 'MET', 'PANAMA', '0808', 'Bella Vista', '080807', 'La contruccion', 'Ambulatorio', '1', ''),
  142. (15, 'Test3', 'tasee', '1-912-3123', '123-1231', 1, 30, '25-34', '0', 'PANAMA', '8', 'MET', 'PANAMA', '0808', 'Las Tablas', '080803', 'Als askjd alksjdljk', 'Ambulatorio', '5', ''),
  143. (16, 'dasd', 'asdas', '1-981-4879', '', 0, 20, '20-24', '1', '', '', 'DAR', '', '', '', '', 'dasdasd', 'Hospitalizado', '14', ''),
  144. (17, 'ksia', 'disha', '5-897-1487', '578-4879', 1, 30, '25-34', '0', 'PANAMA', '8', 'MET', 'PANAMA', '0808', 'Test', '010805', 'djhd dasjkda djkhasdjh', 'Hospitalizado', '5', ''),
  145. (18, 'uyuyuy', 'ssad', '1-898-4577', '121-7897', 1, 30, '25-34', '0', 'PANAMA', '8', 'MET', 'PANAMA', '0808', 'lkajsd', '018777', 'sdlkasjd asldkj sasdklj ', 'Hospitalizado', '5', ''),
  146. (19, 'yair', 'diaz', '8-1059-1589', '', 0, 2, '1 ano', '0', 'panama', '', 'BDT', 'panama', '', 'calidonia', '', 'Ave. Perú, calle 32. Edificio 3209, 2do. piso apto 5.', 'Hospitalizado', '1', ''),
  147. (20, 'dasd', 'asdasd', '1-98-7545', '', 1, 0, '1 ano', '0', '', '', 'BDT', '', '', '', '', '', ' ', '', ''),
  148. (21, 'grismalao', 'santos', '8-106016', '', 0, 2, '1 ano', '0', 'agua dulce', '', 'COC', '', '', '', '', 'agua dulce, cocle', 'Hospitalizado', '1', ''),
  149. (22, 'test4', 'test4', '1-478-4578', '', 0, 26, '25-34', '0', 'PANAMA', '8', 'BDT', 'PANAMA', '0808', 'BELLA VISTA', '041302', 'dsa dasd dasd asdq 1sd', 'Hospitalizado', '14', ''),
  150. (23, 'anet', 'montenegro', '8-1036-506', '', 0, 1, '1 ano', '1', '', '', 'MET', '', '', '', '', 'valle san isidro, casa 177', 'Ambulatorio', '2', '');
  151.  
  152. -- --------------------------------------------------------
  153.  
  154. --
  155. -- Table structure for table `corregimiento`
  156. --
  157.  
  158. CREATE TABLE IF NOT EXISTS `corregimiento` (
  159. `CODIGO_REGIMIENTO` varchar(7) NOT NULL,
  160. `CORREGIMIENTO` varchar(20) NOT NULL,
  161. UNIQUE KEY `CODIGO_REGIMIENTO` (`CODIGO_REGIMIENTO`)
  162. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  163.  
  164. --
  165. -- Dumping data for table `corregimiento`
  166. --
  167.  
  168. INSERT INTO `corregimiento` (`CODIGO_REGIMIENTO`, `CORREGIMIENTO`) VALUES
  169. ('010101', 'BOCAS DEL TORO'),
  170. ('010102', 'BASTIMENTOS'),
  171. ('010103', 'CAUCHERO'),
  172. ('010104', 'PUNTA LAUREL'),
  173. ('010105', 'TIERRA OSCURA'),
  174. ('010201', 'CHANGUINOLA'),
  175. ('010202', 'ALMIRANTE'),
  176. ('010203', 'GUABITO'),
  177. ('010204', 'TERIBE'),
  178. ('010205', 'VALLE DEL RISCO'),
  179. ('010206', 'EL EMPALME'),
  180. ('010207', 'LAS TABLAS'),
  181. ('010301', 'CHIRIQUI GRANDE'),
  182. ('010302', 'MIRAMAR'),
  183. ('010303', 'PUNTA PEÑA'),
  184. ('010304', 'PUNTA ROBALO'),
  185. ('010305', 'RAMBALA'),
  186. ('020101', 'AGUADULCE'),
  187. ('020102', 'EL CRISTO'),
  188. ('020103', 'EL ROBLE'),
  189. ('020104', 'POCRI'),
  190. ('020105', 'BARRIOS UNIDOS'),
  191. ('020201', 'ANTON'),
  192. ('020202', 'CABUYA'),
  193. ('020203', 'EL CHIRU'),
  194. ('020204', 'EL RETIRO'),
  195. ('020205', 'EL VALLE'),
  196. ('020206', 'JUAN DIAZ'),
  197. ('020207', 'RIO HATO'),
  198. ('020208', 'SAN JUAN DE DIOS'),
  199. ('020209', 'SANTA RITA'),
  200. ('020210', 'CABALLERO'),
  201. ('020301', 'LA PINTADA'),
  202. ('020302', 'EL HARINO'),
  203. ('020303', 'EL POTRERO'),
  204. ('020304', 'LLANO GRANDE'),
  205. ('020305', 'PIEDRAS GORDAS'),
  206. ('020306', 'LAS TOMAS'),
  207. ('020401', 'NATA'),
  208. ('020402', 'CAPELLANIA'),
  209. ('020403', 'EL CAÑO'),
  210. ('020404', 'CUZMAN'),
  211. ('020405', 'LAS HUACAS'),
  212. ('020406', 'TOZA'),
  213. ('020501', 'OLA'),
  214. ('020502', 'EL COPE'),
  215. ('020503', 'EL PARMAR'),
  216. ('020504', 'EL PICACHO'),
  217. ('020505', 'LA PAVA'),
  218. ('020601', 'PENONOME'),
  219. ('020602', 'CAÑAVERAL'),
  220. ('020603', 'COCLE'),
  221. ('020604', 'CHIGUIRI ARRIBA'),
  222. ('020605', 'EL COCO'),
  223. ('020606', 'PAJONAL'),
  224. ('020607', 'RIO GRANDE'),
  225. ('020608', 'RIO INDIO'),
  226. ('020609', 'TOABRE'),
  227. ('020610', 'TURU'),
  228. ('030101', 'BARRIO NORTE'),
  229. ('030102', 'BARRIO SUR'),
  230. ('030103', 'BUENA VISTA'),
  231. ('030104', 'CATIVA'),
  232. ('030105', 'CIRICITO'),
  233. ('030106', 'CRISTOBAL'),
  234. ('030107', 'ESCOBAL'),
  235. ('030108', 'LIMON'),
  236. ('030109', 'NUEVA PROVIDENCIA'),
  237. ('030110', 'PUERTO LIMON'),
  238. ('030111', 'SABANITAS'),
  239. ('030112', 'SALAMANCA'),
  240. ('030113', 'SAN JUAN'),
  241. ('030114', 'SANTA ROSA'),
  242. ('030201', 'NUEVO CHARGRES'),
  243. ('030202', 'ACHIOTE'),
  244. ('030203', 'EL GUABO'),
  245. ('030204', 'LA ENCANTADA'),
  246. ('030205', 'PALMAS BELLAS'),
  247. ('030206', 'PIÑA'),
  248. ('030207', 'SALUD'),
  249. ('030301', 'MIGUEL DE LA BORDA'),
  250. ('030302', 'COCLE DEL NORTE'),
  251. ('030303', 'EL GUASIMO'),
  252. ('030304', 'GOBEA'),
  253. ('030305', 'RIO INDIO'),
  254. ('030306', 'SAN JOSE DEL GENERAL'),
  255. ('030401', 'PORTOBELO'),
  256. ('030402', 'CACIQUE'),
  257. ('030403', 'GARROTE'),
  258. ('030404', 'ISLA GRANDE'),
  259. ('030405', 'MARIA CHIQUITA'),
  260. ('030501', 'PALENQUE'),
  261. ('030502', 'CUANGO'),
  262. ('030503', 'MIRAMAR'),
  263. ('030504', 'NOMBRE DE DIOS'),
  264. ('030505', 'PALMIRA'),
  265. ('030506', 'PLAYA CHIQUITA'),
  266. ('030507', 'SANTA ISABEL'),
  267. ('030508', 'VIENTO FRIO'),
  268. ('040101', 'ALANJE'),
  269. ('040102', 'DIVALA'),
  270. ('040103', 'EL TEJAR'),
  271. ('040104', 'GUARUMAL'),
  272. ('040105', 'PALO GRANDE'),
  273. ('040106', 'QUEREVALO'),
  274. ('040107', 'SANTO TOMAS'),
  275. ('040108', 'CANTA GALLO'),
  276. ('040109', 'NUEVO MEXICO'),
  277. ('040201', 'PUERTO ALMUELLES'),
  278. ('040203', 'LIMONES'),
  279. ('040204', 'BACO'),
  280. ('040205', 'RODOLFO AGUILAR DELG'),
  281. ('040301', 'BOQUERON'),
  282. ('040302', 'BAGALA'),
  283. ('040303', 'CORDILLERA'),
  284. ('040304', 'GUABAL'),
  285. ('040305', 'GUYABAL'),
  286. ('040306', 'PARAISO'),
  287. ('040307', 'PEDREGAL'),
  288. ('040308', 'TIJERAS'),
  289. ('040401', 'BAJO BOQUETE'),
  290. ('040402', 'CALDERA'),
  291. ('040403', 'PALMIRA'),
  292. ('040404', 'ALTO BOQUETE'),
  293. ('040405', 'JARAMILLO'),
  294. ('040406', 'LOS NARANJOS'),
  295. ('040501', 'LA CONCEPCION'),
  296. ('040502', 'ASERRIO DE GARICHE'),
  297. ('040503', 'BUGABA'),
  298. ('040504', 'CERRO PUNTA'),
  299. ('040505', 'GOMEZ'),
  300. ('040506', 'LA ESTRELLA'),
  301. ('040507', 'SAN ANDRES'),
  302. ('040508', 'SANTA MARIA'),
  303. ('040509', 'SANTA ROSA'),
  304. ('040510', 'SANTO DOMINGO'),
  305. ('040511', 'SORTOVA'),
  306. ('040512', 'VOLCAN'),
  307. ('040513', 'EL BONGO'),
  308. ('040601', 'DAVID'),
  309. ('040602', 'BIJAGUAL'),
  310. ('040603', 'COCHEA'),
  311. ('040604', 'CHIRIQUI'),
  312. ('040605', 'GUACA'),
  313. ('040606', 'LAS TOMAS'),
  314. ('040607', 'PEDREGAL'),
  315. ('040608', 'SAN CARLOS'),
  316. ('040609', 'SAN PABLO NUEVO'),
  317. ('040610', 'SAN PABLO VIEJO'),
  318. ('040701', 'DOLEGA'),
  319. ('040702', 'DOS RIOS'),
  320. ('040703', 'LOS ANASTACIOS'),
  321. ('040704', 'POTRERILLOS'),
  322. ('040705', 'POTRERILLOS ABAJO'),
  323. ('040706', 'ROVIRA'),
  324. ('040707', 'TINAJAS'),
  325. ('040708', 'LOS ALGARROBOS'),
  326. ('040801', 'GUALACA'),
  327. ('040802', 'HORNITO'),
  328. ('040803', 'LOS ANGELES'),
  329. ('040804', 'PAJA DE SOMBRERO'),
  330. ('040805', 'RINCON'),
  331. ('040901', 'REMEDIOS'),
  332. ('040902', 'EL NANCITO'),
  333. ('040903', 'EL PORVENIR'),
  334. ('040904', 'EL PUERTO'),
  335. ('040905', 'SANTA LUCIA'),
  336. ('041001', 'RIO SERENO'),
  337. ('041002', 'BREÑON'),
  338. ('041003', 'CAÑAS GORGAS'),
  339. ('041004', 'MONTE LIRIO'),
  340. ('041005', 'PLAZA CAIZAN'),
  341. ('041006', 'SANTA CRUZ'),
  342. ('041007', 'DOMINICAL'),
  343. ('041008', 'SANTA CLARA'),
  344. ('041101', 'LAS LAJAS'),
  345. ('041102', 'JUAY'),
  346. ('041103', 'LAJAS ADENTRO'),
  347. ('041104', 'SAN FELIX'),
  348. ('041105', 'SANTA CRUZ'),
  349. ('041201', 'HORCONCITOS'),
  350. ('041202', 'BOCA CHICA'),
  351. ('041203', 'BOCA DEL MONTE'),
  352. ('041204', 'SAN JUAN'),
  353. ('041205', 'SAN LORENZO'),
  354. ('041301', 'TOLE'),
  355. ('041302', 'BELLA VISTA'),
  356. ('041303', 'CERRO VIEJO'),
  357. ('041304', 'EL CRISTO'),
  358. ('041305', 'JUSTO FIDEL PALACIOS'),
  359. ('041306', 'LAJAS DE TOLE'),
  360. ('041307', 'POTERO DE CAÑA'),
  361. ('041308', 'QUEBRADA DE PIEDRA'),
  362. ('041309', 'VELADERO'),
  363. ('050101', 'LA PALMA'),
  364. ('050102', 'GAMOGANTI'),
  365. ('050103', 'CHEPIGANA'),
  366. ('050104', 'GARACHINE'),
  367. ('050105', 'JAQUE'),
  368. ('050106', 'PUERTO PIÑA'),
  369. ('050107', 'RIO CONGO'),
  370. ('050108', 'RIO IGLESIAS'),
  371. ('050109', 'SAMBU'),
  372. ('050110', 'SETEGANTI'),
  373. ('050111', 'TAIMATI'),
  374. ('050112', 'TUCUTI'),
  375. ('050113', 'AGUA FRIA'),
  376. ('050114', 'CUCUNATI'),
  377. ('050115', 'RIO CONGO ARRIBA');
  378.  
  379. -- --------------------------------------------------------
  380.  
  381. --
  382. -- Table structure for table `distrito`
  383. --
  384.  
  385. CREATE TABLE IF NOT EXISTS `distrito` (
  386. `CODIGO_DISTRITO` varchar(4) NOT NULL,
  387. `DISTRITO` varchar(15) NOT NULL,
  388. UNIQUE KEY `CODIGO_DISTRITO` (`CODIGO_DISTRITO`)
  389. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  390.  
  391. --
  392. -- Dumping data for table `distrito`
  393. --
  394.  
  395. INSERT INTO `distrito` (`CODIGO_DISTRITO`, `DISTRITO`) VALUES
  396. ('0101', 'BOCAS DEL TORO'),
  397. ('0102', 'CHANGUINOL'),
  398. ('0103', 'CHIRIQUI GR'),
  399. ('0201', 'AGUADULCE'),
  400. ('0202', 'ANTON'),
  401. ('0203', 'LA PINTADA'),
  402. ('0204', 'NATA'),
  403. ('0205', 'OLA'),
  404. ('0206', 'PENONOME'),
  405. ('0301', 'COLON'),
  406. ('0302', 'CHARGES'),
  407. ('0303', 'DONOSO'),
  408. ('0304', 'PORTOBELO'),
  409. ('0305', 'SANTA ISABE'),
  410. ('0401', 'ALANJE'),
  411. ('0402', 'BARU'),
  412. ('0403', 'BOQUERON'),
  413. ('0404', 'BOQUETE'),
  414. ('0405', 'BUGABA'),
  415. ('0406', 'DAVID'),
  416. ('0407', 'DOLEGA'),
  417. ('0408', 'GUALACA'),
  418. ('0409', 'REMEDIOS'),
  419. ('0410', 'RANACIMIENT'),
  420. ('0411', 'SAN FELIX'),
  421. ('0412', 'SAN LORENZ'),
  422. ('0413', 'TOLE'),
  423. ('0501', 'CHEPIGANA'),
  424. ('0502', 'PINOGANA'),
  425. ('0601', 'CHITRE'),
  426. ('0602', 'LA MINAS'),
  427. ('0603', 'LOS POZOS'),
  428. ('0604', 'OCU'),
  429. ('0605', 'PARITA'),
  430. ('0607', 'SANTA MARIA'),
  431. ('0701', 'GUARARE'),
  432. ('0702', 'LAS TABLAS'),
  433. ('0703', 'LOS SANTOS'),
  434. ('0704', 'MACARCAS'),
  435. ('0705', 'PEDASI'),
  436. ('0706', 'POCRI'),
  437. ('0707', 'TONOSI'),
  438. ('0801', 'ARRAIJAN'),
  439. ('0802', 'BALBOA'),
  440. ('0803', 'CAPIRA'),
  441. ('0804', 'CHAME'),
  442. ('0805', 'CHEPO'),
  443. ('0806', 'CHIMAN'),
  444. ('0807', 'LA CHORRER'),
  445. ('0808', 'PANAMA'),
  446. ('0809', 'SAN CARLOS'),
  447. ('0810', 'SAN MIGUELI'),
  448. ('0811', 'TABOGA'),
  449. ('0901', 'ATALAYA'),
  450. ('0902', 'CALOBRE'),
  451. ('0903', 'CANAZAS'),
  452. ('0904', 'LA MESA'),
  453. ('0905', 'LAS PALMAS'),
  454. ('0906', 'MONTIJO'),
  455. ('0907', 'RIO DE JESU'),
  456. ('0908', 'SAN FRANCIS'),
  457. ('0909', 'SANTA FE'),
  458. ('0910', 'SANTIAGO'),
  459. ('0911', 'SONA'),
  460. ('0912', 'MARIATO'),
  461. ('1000', 'KUNA YALA'),
  462. ('1100', 'COMARCA EM'),
  463. ('1201', 'BESIKO'),
  464. ('1202', 'MIRONO'),
  465. ('1203', 'MUNA'),
  466. ('1204', 'NOLE DUIMA'),
  467. ('1205', 'NURUM'),
  468. ('1206', 'KANKINTU'),
  469. ('1207', 'KUSAPIN');
  470.  
  471. -- --------------------------------------------------------
  472.  
  473. --
  474. -- Table structure for table `gripal`
  475. --
  476.  
  477. CREATE TABLE IF NOT EXISTS `gripal` (
  478. `NUM_ID` int(11) NOT NULL auto_increment,
  479. `FIS_GRIPE` date NOT NULL,
  480. `GRIPE_SEMEPI` varchar(2) NOT NULL,
  481. `GRIPE_72HS` tinyint(1) NOT NULL,
  482. `GRIPE_Diag_Clinico` varchar(25) NOT NULL,
  483. `GRIPE_FIEBRE` tinyint(1) NOT NULL,
  484. `GRIPE_TOS` tinyint(1) NOT NULL,
  485. `GRIPE_RINORREA` tinyint(1) NOT NULL,
  486. `GRIPE_DOLOR_GARGANTA` tinyint(1) NOT NULL,
  487. `GRIPE_OTRO_HALLAZGO` tinyint(1) NOT NULL,
  488. `GRIPE_NOMBRE_OTRO_HALLAZGO` varchar(25) NOT NULL,
  489. `GRIPE_ANTIBIOTICO_ULTIMA_SEMANA` tinyint(1) NOT NULL,
  490. `GRIPE_RIESGO_PROFESIONAL` varchar(8) NOT NULL,
  491. `GRIPE_TIPO_DE_RIESGO_PROFESIONAL` varchar(25) NOT NULL,
  492. `GRIPE_OTRO_RIESGO_PROFESIONAL` varchar(25) NOT NULL,
  493. `GRIPE_HISTORIA_VIAJE_15_DIAS_ANTES` tinyint(1) NOT NULL,
  494. `LUGAR_DONDE_VIAJO` varchar(25) NOT NULL,
  495. PRIMARY KEY (`NUM_ID`)
  496. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
  497.  
  498. --
  499. -- RELATIONS FOR TABLE `gripal`:
  500. -- `NUM_ID`
  501. -- `basic_information` -> `NUM_ID`
  502. --
  503.  
  504. --
  505. -- Dumping data for table `gripal`
  506. --
  507.  
  508. INSERT INTO `gripal` (`NUM_ID`, `FIS_GRIPE`, `GRIPE_SEMEPI`, `GRIPE_72HS`, `GRIPE_Diag_Clinico`, `GRIPE_FIEBRE`, `GRIPE_TOS`, `GRIPE_RINORREA`, `GRIPE_DOLOR_GARGANTA`, `GRIPE_OTRO_HALLAZGO`, `GRIPE_NOMBRE_OTRO_HALLAZGO`, `GRIPE_ANTIBIOTICO_ULTIMA_SEMANA`, `GRIPE_RIESGO_PROFESIONAL`, `GRIPE_TIPO_DE_RIESGO_PROFESIONAL`, `GRIPE_OTRO_RIESGO_PROFESIONAL`, `GRIPE_HISTORIA_VIAJE_15_DIAS_ANTES`, `LUGAR_DONDE_VIAJO`) VALUES
  509. (3, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  510. (2, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  511. (1, '2008-01-13', '20', 1, 'Tests', 1, 1, 1, 1, 1, 'dasdas', 1, 'das', 'T_SALUD', 'dasda', 1, 'Seoul'),
  512. (4, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  513. (5, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  514. (6, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  515. (7, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  516. (8, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  517. (9, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  518. (10, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  519. (11, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  520. (12, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  521. (13, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  522. (14, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  523. (15, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  524. (16, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  525. (17, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  526. (18, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  527. (19, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  528. (20, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  529. (21, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  530. (22, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, ''),
  531. (23, '0000-00-00', '', 0, '', 0, 0, 0, 0, 0, '', 0, '', '', '', 0, '');
  532.  
  533. -- --------------------------------------------------------
  534.  
  535. --
  536. -- Table structure for table `hisopado`
  537. --
  538.  
  539. CREATE TABLE IF NOT EXISTS `hisopado` (
  540. `NUM_ID` int(11) NOT NULL auto_increment,
  541. `HISOPADO_DE_UNA_FOSA_NASAL_FARINGE` tinyint(1) NOT NULL,
  542. `HISOPADO_FARINGE_FECHA_DE_TOMA` date NOT NULL,
  543. `HISOPADO_DE_LAS_DOS_FOSAS_NASALES` tinyint(1) NOT NULL,
  544. `FECHA_DE_TOMA_HISOPDA_DOS_FOSAS_NASALES` date NOT NULL,
  545. `HISOPADO_DE_LA_FARINGE` tinyint(1) NOT NULL,
  546. `HISOPADO_DE_LA_FARINGE_FECHA_DE_TOMA` date NOT NULL,
  547. `SANGRE_N1` varchar(15) NOT NULL,
  548. `FECHA_DE_TOMA_SANGRE_N1` date NOT NULL,
  549. `SANGRE_N2` varchar(15) NOT NULL,
  550. `FECHA_DE_TOMA_SANGRE_N2` date NOT NULL,
  551. `LIQUIDO_PLEURAL` varchar(15) NOT NULL,
  552. `LIQUIDO_PLEURAL_FECHA_DE_TOMA` date NOT NULL,
  553. `TEJIDO_N1` tinyint(1) NOT NULL,
  554. `FECHA_DE_TOMA_TEJIDO_N1` date NOT NULL,
  555. `TEJIDO_N2` tinyint(1) NOT NULL,
  556. `FECHA_DE_TOMA_TEJIDO_N2` date NOT NULL,
  557. `NOMBRE_DEL_MEDICO` varchar(25) NOT NULL,
  558. `FECHA_NOMBRE_DEL_MEDICO` date NOT NULL,
  559. PRIMARY KEY (`NUM_ID`)
  560. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
  561.  
  562. --
  563. -- RELATIONS FOR TABLE `hisopado`:
  564. -- `NUM_ID`
  565. -- `basic_information` -> `NUM_ID`
  566. --
  567.  
  568. --
  569. -- Dumping data for table `hisopado`
  570. --
  571.  
  572. INSERT INTO `hisopado` (`NUM_ID`, `HISOPADO_DE_UNA_FOSA_NASAL_FARINGE`, `HISOPADO_FARINGE_FECHA_DE_TOMA`, `HISOPADO_DE_LAS_DOS_FOSAS_NASALES`, `FECHA_DE_TOMA_HISOPDA_DOS_FOSAS_NASALES`, `HISOPADO_DE_LA_FARINGE`, `HISOPADO_DE_LA_FARINGE_FECHA_DE_TOMA`, `SANGRE_N1`, `FECHA_DE_TOMA_SANGRE_N1`, `SANGRE_N2`, `FECHA_DE_TOMA_SANGRE_N2`, `LIQUIDO_PLEURAL`, `LIQUIDO_PLEURAL_FECHA_DE_TOMA`, `TEJIDO_N1`, `FECHA_DE_TOMA_TEJIDO_N1`, `TEJIDO_N2`, `FECHA_DE_TOMA_TEJIDO_N2`, `NOMBRE_DEL_MEDICO`, `FECHA_NOMBRE_DEL_MEDICO`) VALUES
  573. (3, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  574. (4, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  575. (2, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  576. (1, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  577. (5, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  578. (6, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  579. (7, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  580. (8, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  581. (9, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  582. (10, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  583. (11, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  584. (12, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  585. (13, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  586. (14, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  587. (15, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  588. (16, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  589. (17, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  590. (18, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  591. (19, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  592. (20, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  593. (21, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  594. (22, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00'),
  595. (23, 0, '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00', '', '0000-00-00', '', '0000-00-00', 0, '0000-00-00', 0, '0000-00-00', '', '0000-00-00');
  596.  
  597. -- --------------------------------------------------------
  598.  
  599. --
  600. -- Table structure for table `icges`
  601. --
  602.  
  603. CREATE TABLE IF NOT EXISTS `icges` (
  604. `NUM_ID` int(11) NOT NULL auto_increment,
  605. `ICGES_TIPO_HISOPADO` varchar(15) NOT NULL,
  606. `ICGES_FECHA_DE_RECIBO` date NOT NULL,
  607. `ICGES_NUM_MUESTRA` varchar(25) NOT NULL,
  608. `ICGES_PRES_CELULAS` smallint(6) NOT NULL,
  609. `ICGES_PRIMERA_IF` varchar(15) NOT NULL,
  610. `ICGES_PRIMERA_FECHA` date NOT NULL,
  611. `ICGES_CULTIVO` varchar(5) NOT NULL,
  612. `ICGES_HA1` varchar(25) NOT NULL,
  613. `ICGES_SEGUNDA_IF` varchar(25) NOT NULL,
  614. `ICGES_CUAL_CEPA` varchar(25) NOT NULL,
  615. `ICGES_CUAL_CEPA_FECHA` date NOT NULL,
  616. `ICGES_RTP_PCR` tinyint(1) NOT NULL,
  617. `ICGES_VIRUS_IDENTIFICADO` varchar(15) NOT NULL,
  618. `ICGES_VIRUS_IDENTIFICADO_CUAL` varchar(25) NOT NULL,
  619. `ICGES_VIRUS_IDENTIFICADO_FECHA` date NOT NULL,
  620. `ICGES_NUM_SANGRE` varchar(15) NOT NULL,
  621. `ICGES_FECHA_RECIBO_SANG1` date NOT NULL,
  622. `ICGES_NUM_MUESTRA_SANG1` varchar(15) NOT NULL,
  623. `ICGES_NUM_MUESTRA_SANG2` varchar(15) NOT NULL,
  624. `ICGES_FECHA_RECIBO_SANG2` date NOT NULL,
  625. `ICGES_INHIBICION_DE_HA` varchar(25) NOT NULL,
  626. `ICGES_INHIBICION_DE_HA_FECHA` date NOT NULL,
  627. `ICGES_RESUL_PCR_SANG2` varchar(25) NOT NULL,
  628. `ICGES_RESULA_PCR_SANG2_CUAL` varchar(25) NOT NULL,
  629. `ICGES_RESULA_PCR_SANG2_FECHA` date NOT NULL,
  630. `ICGES_TIP_DE_INFLUENZA` varchar(25) NOT NULL,
  631. `ICGES_RTP_PCR_2` tinyint(1) NOT NULL,
  632. `ICGES_TIPO_TEJ1` varchar(25) NOT NULL,
  633. `ICGES_TIPO_TEJ1_FECHA` date NOT NULL,
  634. `ICGES_NUM_MUESTRA_TEJ1` varchar(25) NOT NULL,
  635. `ICGES_PCR_TEJ_NUM1` tinyint(1) NOT NULL,
  636. `ICGES_VIRUS_IDENTIFICADO_TEJ1` varchar(25) NOT NULL,
  637. `ICGES_VIRUS_TEJ1_CUAL` varchar(25) NOT NULL,
  638. `ICGES_VIRUS_TEJ1_FECHA` date NOT NULL,
  639. `ICGES_VIRUS_CULTIVO_TEJ1` tinyint(1) NOT NULL,
  640. `ICGES_RESUL_CUTIVO_TEJ1` varchar(25) NOT NULL,
  641. `ICGES_RESUL_CULTIVO_TEJ1_CUAL` varchar(25) NOT NULL,
  642. `ICGES_RESUL_CULTIVO_TEJ1_FECHA` date NOT NULL,
  643. `ICGES_TIPO_TEJ2` varchar(25) NOT NULL,
  644. `ICGES_FECHA_RECIBO_TEJ2` date NOT NULL,
  645. `ICGES_NUM_MUESTRA_TEJ2` varchar(25) NOT NULL,
  646. `ICGES_PCR_TEJ2` tinyint(1) NOT NULL,
  647. `ICGES_VIRUS_IDENTIFICADO_FEJ2` varchar(25) NOT NULL,
  648. `ICGES_VIRUS_CUAL_TEJ2` varchar(25) NOT NULL,
  649. `ICGES_VIRUS_FECHA_TEJ2` date NOT NULL,
  650. `ICGES_VIRUS_CULTIVO_TEJ2` tinyint(1) NOT NULL,
  651. `ICGES_CULTIVO_TEJ2_FECHA` date NOT NULL,
  652. `ICGES_RESUL_CULTIVO_TEJ2` varchar(25) NOT NULL,
  653. `ICGES_RESUL_CULTIVO_TEJ2_CUAL` varchar(25) NOT NULL,
  654. `ICGES_RESUL_CULTIVO_TEJ2_FECHA` date NOT NULL,
  655. PRIMARY KEY (`NUM_ID`)
  656. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
  657.  
  658. --
  659. -- RELATIONS FOR TABLE `icges`:
  660. -- `NUM_ID`
  661. -- `basic_information` -> `NUM_ID`
  662. --
  663.  
  664. --
  665. -- Dumping data for table `icges`
  666. --
  667.  
  668. INSERT INTO `icges` (`NUM_ID`, `ICGES_TIPO_HISOPADO`, `ICGES_FECHA_DE_RECIBO`, `ICGES_NUM_MUESTRA`, `ICGES_PRES_CELULAS`, `ICGES_PRIMERA_IF`, `ICGES_PRIMERA_FECHA`, `ICGES_CULTIVO`, `ICGES_HA1`, `ICGES_SEGUNDA_IF`, `ICGES_CUAL_CEPA`, `ICGES_CUAL_CEPA_FECHA`, `ICGES_RTP_PCR`, `ICGES_VIRUS_IDENTIFICADO`, `ICGES_VIRUS_IDENTIFICADO_CUAL`, `ICGES_VIRUS_IDENTIFICADO_FECHA`, `ICGES_NUM_SANGRE`, `ICGES_FECHA_RECIBO_SANG1`, `ICGES_NUM_MUESTRA_SANG1`, `ICGES_NUM_MUESTRA_SANG2`, `ICGES_FECHA_RECIBO_SANG2`, `ICGES_INHIBICION_DE_HA`, `ICGES_INHIBICION_DE_HA_FECHA`, `ICGES_RESUL_PCR_SANG2`, `ICGES_RESULA_PCR_SANG2_CUAL`, `ICGES_RESULA_PCR_SANG2_FECHA`, `ICGES_TIP_DE_INFLUENZA`, `ICGES_RTP_PCR_2`, `ICGES_TIPO_TEJ1`, `ICGES_TIPO_TEJ1_FECHA`, `ICGES_NUM_MUESTRA_TEJ1`, `ICGES_PCR_TEJ_NUM1`, `ICGES_VIRUS_IDENTIFICADO_TEJ1`, `ICGES_VIRUS_TEJ1_CUAL`, `ICGES_VIRUS_TEJ1_FECHA`, `ICGES_VIRUS_CULTIVO_TEJ1`, `ICGES_RESUL_CUTIVO_TEJ1`, `ICGES_RESUL_CULTIVO_TEJ1_CUAL`, `ICGES_RESUL_CULTIVO_TEJ1_FECHA`, `ICGES_TIPO_TEJ2`, `ICGES_FECHA_RECIBO_TEJ2`, `ICGES_NUM_MUESTRA_TEJ2`, `ICGES_PCR_TEJ2`, `ICGES_VIRUS_IDENTIFICADO_FEJ2`, `ICGES_VIRUS_CUAL_TEJ2`, `ICGES_VIRUS_FECHA_TEJ2`, `ICGES_VIRUS_CULTIVO_TEJ2`, `ICGES_CULTIVO_TEJ2_FECHA`, `ICGES_RESUL_CULTIVO_TEJ2`, `ICGES_RESUL_CULTIVO_TEJ2_CUAL`, `ICGES_RESUL_CULTIVO_TEJ2_FECHA`) VALUES
  669. (2, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  670. (3, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  671. (4, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  672. (5, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  673. (6, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  674. (7, '', '2008-01-30', '301119', 1, 'NEGATIVO', '2008-01-31', 'NEG', '0', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  675. (1, 'NSF', '0000-00-00', '', 2, 'INFLUENZA B', '0000-00-00', 'NEG', '0', 'INFLUENZA B', '', '0000-00-00', 0, 'INFLUENZA A', '', '0000-00-00', 'SANGRE 1', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', 'INFLUENZA A', '', '0000-00-00', 'INFLU A', 1, '', '0000-00-00', '', 0, 'OTRO', '', '0000-00-00', 0, 'OTRO', '', '0000-00-00', '', '0000-00-00', '', 0, 'VSR', '', '0000-00-00', 0, '0000-00-00', 'PARAINFLUENZA 2', '', '0000-00-00'),
  676. (8, 'FARINGEO', '2008-01-30', '301118', 1, '', '0000-00-00', 'NEG', '0', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', 'INFLU B', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  677. (9, 'NASAL', '2008-01-28', '301117', 0, '', '0000-00-00', 'NEG', '0', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', 'INFLU B', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  678. (10, 'NASAL', '2008-01-25', '301116', 1, '', '2008-01-25', 'NEG', '0', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  679. (11, 'NASAL', '2008-01-22', '301115', 1, '', '0000-00-00', 'NEG', '0', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  680. (12, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  681. (13, 'NASAL', '2008-01-18', '301111', 1, '', '0000-00-00', 'NEG', '0', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  682. (14, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  683. (15, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  684. (16, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  685. (17, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  686. (18, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  687. (19, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  688. (20, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  689. (21, 'NASAL', '2008-01-14', '301108', 1, '', '0000-00-00', 'NEG', '0', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  690. (22, '', '0000-00-00', '', 0, '', '0000-00-00', '', '', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00'),
  691. (23, '', '2008-01-10', '301103', 1, '', '0000-00-00', 'NEG', '0', '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '0000-00-00', '', 0, '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '', '', '0000-00-00', '', '0000-00-00', '', 0, '', '', '0000-00-00', 0, '0000-00-00', '', '', '0000-00-00');
  692.  
  693. -- --------------------------------------------------------
  694.  
  695. --
  696. -- Table structure for table `lab_loc_bac_ant`
  697. --
  698.  
  699. CREATE TABLE IF NOT EXISTS `lab_loc_bac_ant` (
  700. `NUM_ID` int(11) NOT NULL,
  701. `GRAM_LIQ_PLEURAL` varchar(10) NOT NULL,
  702. `GRAM_MORFOLOGIA` varchar(25) NOT NULL,
  703. `GRAM_FECHA` date NOT NULL,
  704. `NEUM_BACT_CULTIVO_LIQ_PLEURAL` text NOT NULL,
  705. `CULT_LIQ_PLEU_OTRO_AGENTE` varchar(20) NOT NULL,
  706. `NEUM_BACT_FECHA_CULT_LIQ_PLEURAL` date NOT NULL,
  707. `NEUM_BACT_OTRA_PBA_LIQ_PLEURAL` tinyint(1) NOT NULL,
  708. `Neum_Bact_Otra_Pba_Liq_Pleur` varchar(25) NOT NULL,
  709. `Neum_Bact_Fecha_Otra_Pba_Liq_Pleu` date NOT NULL,
  710. `NEUM_BACT_RESUL_HEMOCULTIVO` text NOT NULL,
  711. `Neum_Bact_HemoCult_Otro_Micr` varchar(25) NOT NULL,
  712. `Neum_Bact_Fecha_Hemoc_Otro_Micr` date NOT NULL,
  713. `NombreDelTM` varchar(20) NOT NULL,
  714. `Neum_Bact_Fecha_Resul_Final` date NOT NULL,
  715. `LAB_LOC_PENICILINA` varchar(2) NOT NULL,
  716. `LAB_LOC_CEFTRIAXONA` varchar(2) NOT NULL,
  717. `LAB_LOC_TRIMETROPIN` varchar(2) NOT NULL,
  718. `LAB_LOC_CLORANFENICOL` varchar(2) NOT NULL,
  719. `LAB_LOC_ERITROMICINA` varchar(2) NOT NULL,
  720. `LAB_LOC_VANCOMICINA` varchar(2) NOT NULL,
  721. `LAB_LOC_OFLOXACILINA` varchar(2) NOT NULL,
  722. `LAB_LOC_CLINDAMICINA` varchar(2) NOT NULL,
  723. `LAB_LOC_OXACILINA` varchar(2) NOT NULL,
  724. `LAB_LOC_AMPICILINA` varchar(2) NOT NULL,
  725. `LAB_LOC_OTRO_ANTIB` varchar(2) NOT NULL,
  726. `Describir` varchar(25) NOT NULL,
  727. `LAB_LOC_OTRO2_ANTIBIOTICO` varchar(2) NOT NULL,
  728. `LAB_LOC_OTROS_ANTIB_DESCR` varchar(25) NOT NULL,
  729. `Lab_Loc_TM_Antibiograma` varchar(25) NOT NULL,
  730. `Lab_Loc_Fecha_Antibiograma` date NOT NULL,
  731. PRIMARY KEY (`NUM_ID`)
  732. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  733.  
  734. --
  735. -- RELATIONS FOR TABLE `lab_loc_bac_ant`:
  736. -- `NUM_ID`
  737. -- `basic_information` -> `NUM_ID`
  738. --
  739.  
  740. --
  741. -- Dumping data for table `lab_loc_bac_ant`
  742. --
  743.  
  744. INSERT INTO `lab_loc_bac_ant` (`NUM_ID`, `GRAM_LIQ_PLEURAL`, `GRAM_MORFOLOGIA`, `GRAM_FECHA`, `NEUM_BACT_CULTIVO_LIQ_PLEURAL`, `CULT_LIQ_PLEU_OTRO_AGENTE`, `NEUM_BACT_FECHA_CULT_LIQ_PLEURAL`, `NEUM_BACT_OTRA_PBA_LIQ_PLEURAL`, `Neum_Bact_Otra_Pba_Liq_Pleur`, `Neum_Bact_Fecha_Otra_Pba_Liq_Pleu`, `NEUM_BACT_RESUL_HEMOCULTIVO`, `Neum_Bact_HemoCult_Otro_Micr`, `Neum_Bact_Fecha_Hemoc_Otro_Micr`, `NombreDelTM`, `Neum_Bact_Fecha_Resul_Final`, `LAB_LOC_PENICILINA`, `LAB_LOC_CEFTRIAXONA`, `LAB_LOC_TRIMETROPIN`, `LAB_LOC_CLORANFENICOL`, `LAB_LOC_ERITROMICINA`, `LAB_LOC_VANCOMICINA`, `LAB_LOC_OFLOXACILINA`, `LAB_LOC_CLINDAMICINA`, `LAB_LOC_OXACILINA`, `LAB_LOC_AMPICILINA`, `LAB_LOC_OTRO_ANTIB`, `Describir`, `LAB_LOC_OTRO2_ANTIBIOTICO`, `LAB_LOC_OTROS_ANTIB_DESCR`, `Lab_Loc_TM_Antibiograma`, `Lab_Loc_Fecha_Antibiograma`) VALUES
  745. (2, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  746. (3, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  747. (1, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  748. (4, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  749. (5, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  750. (6, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  751. (7, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  752. (8, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  753. (9, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  754. (10, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  755. (11, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  756. (12, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  757. (13, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  758. (14, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  759. (15, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  760. (16, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  761. (17, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  762. (18, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  763. (19, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  764. (20, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  765. (21, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  766. (22, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00'),
  767. (23, '', '', '0000-00-00', '', '', '0000-00-00', 0, '', '0000-00-00', '', '', '0000-00-00', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00');
  768.  
  769. -- --------------------------------------------------------
  770.  
  771. --
  772. -- Table structure for table `lab_loc_hisopado`
  773. --
  774.  
  775. CREATE TABLE IF NOT EXISTS `lab_loc_hisopado` (
  776. `NUM_ID` int(11) NOT NULL auto_increment,
  777. `Lab_Loc_GRIPE_NV_Fecha_Rec_Muestra` date NOT NULL,
  778. `Lab_Loc_N_Caso_Gripe_NV` int(11) NOT NULL,
  779. `Lab_Loc_PRESENCIA_CELULAS` tinyint(4) NOT NULL,
  780. `Lab_Loc_IF_PARA_ANTIGENOS_VIRALES` varchar(15) NOT NULL,
  781. `Lab_Loc_ANTIGENO_VIRAL` varchar(25) NOT NULL,
  782. `Lab_Loc_NOMBRE_DEL_TM_Pb` varchar(25) NOT NULL,
  783. `Lab_Loc_Fecha_Inf_G` date NOT NULL,
  784. PRIMARY KEY (`NUM_ID`)
  785. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
  786.  
  787. --
  788. -- RELATIONS FOR TABLE `lab_loc_hisopado`:
  789. -- `NUM_ID`
  790. -- `basic_information` -> `NUM_ID`
  791. --
  792.  
  793. --
  794. -- Dumping data for table `lab_loc_hisopado`
  795. --
  796.  
  797. INSERT INTO `lab_loc_hisopado` (`NUM_ID`, `Lab_Loc_GRIPE_NV_Fecha_Rec_Muestra`, `Lab_Loc_N_Caso_Gripe_NV`, `Lab_Loc_PRESENCIA_CELULAS`, `Lab_Loc_IF_PARA_ANTIGENOS_VIRALES`, `Lab_Loc_ANTIGENO_VIRAL`, `Lab_Loc_NOMBRE_DEL_TM_Pb`, `Lab_Loc_Fecha_Inf_G`) VALUES
  798. (3, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  799. (2, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  800. (1, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  801. (4, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  802. (5, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  803. (6, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  804. (7, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  805. (8, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  806. (9, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  807. (10, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  808. (11, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  809. (12, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  810. (13, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  811. (14, '2008-02-05', 1, 1, 'POS', 'INFLUENZA B', 'Tests', '2008-02-05'),
  812. (15, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  813. (16, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  814. (17, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  815. (18, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  816. (19, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  817. (20, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  818. (21, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  819. (22, '0000-00-00', 0, 0, '', '', '', '0000-00-00'),
  820. (23, '0000-00-00', 0, 0, '', '', '', '0000-00-00');
  821.  
  822. -- --------------------------------------------------------
  823.  
  824. --
  825. -- Table structure for table `lcrsp`
  826. --
  827.  
  828. CREATE TABLE IF NOT EXISTS `lcrsp` (
  829. `NUM_ID` int(11) NOT NULL auto_increment,
  830. `LCRSP_SEROTIPO` varchar(15) NOT NULL,
  831. `LCRSP_TM` varchar(20) NOT NULL,
  832. `LCRSP_Fecha_Serotipo` date NOT NULL,
  833. `LCRSP_PENICILINA` varchar(2) NOT NULL,
  834. `LCRSP_CEFTRIAXONA` varchar(2) NOT NULL,
  835. `LCRSP_TRIMETROPIN` varchar(2) NOT NULL,
  836. `LCRSP_CLORANFENICOL` varchar(2) NOT NULL,
  837. `LCRSP_ERITROMICINA` varchar(2) NOT NULL,
  838. `LCRSP_VANCOMICINA` varchar(2) NOT NULL,
  839. `LCRSP_OFLOXACILINA` varchar(2) NOT NULL,
  840. `LCRSP_CLINDAMICINA` tinyint(1) NOT NULL,
  841. `LCRSP_Oxacilina_Spn` tinyint(1) NOT NULL,
  842. `LCRSP_Ampicilina_Hib` tinyint(1) NOT NULL,
  843. `LCRSP_BETALACTAMASA` varchar(8) NOT NULL,
  844. `LCRSP_OTRO_ANTIBIOTICO` varchar(2) NOT NULL,
  845. `LCRSP_DESCRIBIR` varchar(25) NOT NULL,
  846. `LCRSP_Neum_Bact_Resul_Final` varchar(25) NOT NULL,
  847. `LCRSP_Nombre_TM` varchar(25) NOT NULL,
  848. `LCRSP_FECHA` date NOT NULL,
  849. PRIMARY KEY (`NUM_ID`)
  850. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
  851.  
  852. --
  853. -- RELATIONS FOR TABLE `lcrsp`:
  854. -- `NUM_ID`
  855. -- `basic_information` -> `NUM_ID`
  856. --
  857.  
  858. --
  859. -- Dumping data for table `lcrsp`
  860. --
  861.  
  862. INSERT INTO `lcrsp` (`NUM_ID`, `LCRSP_SEROTIPO`, `LCRSP_TM`, `LCRSP_Fecha_Serotipo`, `LCRSP_PENICILINA`, `LCRSP_CEFTRIAXONA`, `LCRSP_TRIMETROPIN`, `LCRSP_CLORANFENICOL`, `LCRSP_ERITROMICINA`, `LCRSP_VANCOMICINA`, `LCRSP_OFLOXACILINA`, `LCRSP_CLINDAMICINA`, `LCRSP_Oxacilina_Spn`, `LCRSP_Ampicilina_Hib`, `LCRSP_BETALACTAMASA`, `LCRSP_OTRO_ANTIBIOTICO`, `LCRSP_DESCRIBIR`, `LCRSP_Neum_Bact_Resul_Final`, `LCRSP_Nombre_TM`, `LCRSP_FECHA`) VALUES
  863. (2, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  864. (1, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  865. (3, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  866. (4, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  867. (5, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  868. (6, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  869. (7, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  870. (8, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  871. (9, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  872. (10, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  873. (11, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  874. (12, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  875. (13, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  876. (14, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  877. (15, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  878. (16, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  879. (17, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  880. (18, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  881. (19, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  882. (20, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  883. (21, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  884. (22, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00'),
  885. (23, '', '', '0000-00-00', '', '', '', '', '', '', '', 0, 0, 0, '', '', '', '', '', '0000-00-00');
  886.  
  887. -- --------------------------------------------------------
  888.  
  889. --
  890. -- Table structure for table `neumonia`
  891. --
  892.  
  893. CREATE TABLE IF NOT EXISTS `neumonia` (
  894. `NUM_ID` int(11) NOT NULL auto_increment,
  895. `NEUMONIA_FIS` date NOT NULL,
  896. `NEUMONIA_SEMEPI` varchar(2) NOT NULL,
  897. `NEUMONIA_FECHA_HOSPITALIZ` date NOT NULL,
  898. `NEUMONIA_FECHA_DIAG` date NOT NULL,
  899. `NEUMONIA_CASO_CAPTADO_EN` varchar(25) NOT NULL,
  900. `NEUMONIA_DIAGNOSTICO_DE_INGRESO` varchar(20) NOT NULL,
  901. `NEUMONIA_RIESGO_PROFESIONAL` varchar(8) NOT NULL,
  902. `NEUMONIA_TIPO_DE_RIESGO` varchar(10) NOT NULL,
  903. `NEUMONIA_OTRO_RIESGO_PROFESIONAL` varchar(25) NOT NULL,
  904. `NEUMONIA_HISTORIA_VIAJE_15_DIAS_ANTES` tinyint(1) NOT NULL,
  905. `NEUMONIA_LUGAR_DONDE_VIAJO` varchar(20) NOT NULL,
  906. `NEUMONIA_PORTADOR_ENF_CRONICA` tinyint(1) NOT NULL,
  907. `NEUMONIA_TIPO_DE_ENFERMEDAD` varchar(25) NOT NULL,
  908. `NEUMONIA_ANTIBIOTICO_ULTIMA_SEMANA` tinyint(1) NOT NULL,
  909. `NEUMONIA_NOMBRE_ANTIBIOTICO` varchar(20) NOT NULL,
  910. `NEUMONIA_VIA_DE_ADMINISTRACION` text NOT NULL,
  911. `NEUMONIA_FECHA_DE_PRIMERA_DOSIS` date NOT NULL,
  912. `NEUMONIA_FECHA_DE_ULTIMA_DOSIS` date NOT NULL,
  913. `NEUMONIA_RESULTADO_DE_RADIOGRAFIA` varchar(30) NOT NULL,
  914. `NEUMONIA_DESCRIBIR_OTRO_RESULTADO_DE_RX` varchar(30) NOT NULL,
  915. `NEUMONIA_CLASIFICACION_FINAL` varchar(30) NOT NULL,
  916. `NEUMONIA_AGENTE_CAUSAL` varchar(25) NOT NULL,
  917. `NEUMONIA_AGENTE_CAUSAL_CODIGO` varchar(15) NOT NULL,
  918. `NEUMONIA_CONDICION_DE_EGRESO` varchar(10) NOT NULL,
  919. `NEUMONIA_CONDICION_FECHA` date NOT NULL,
  920. PRIMARY KEY (`NUM_ID`)
  921. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
  922.  
  923. --
  924. -- RELATIONS FOR TABLE `neumonia`:
  925. -- `NUM_ID`
  926. -- `basic_information` -> `NUM_ID`
  927. --
  928.  
  929. --
  930. -- Dumping data for table `neumonia`
  931. --
  932.  
  933. INSERT INTO `neumonia` (`NUM_ID`, `NEUMONIA_FIS`, `NEUMONIA_SEMEPI`, `NEUMONIA_FECHA_HOSPITALIZ`, `NEUMONIA_FECHA_DIAG`, `NEUMONIA_CASO_CAPTADO_EN`, `NEUMONIA_DIAGNOSTICO_DE_INGRESO`, `NEUMONIA_RIESGO_PROFESIONAL`, `NEUMONIA_TIPO_DE_RIESGO`, `NEUMONIA_OTRO_RIESGO_PROFESIONAL`, `NEUMONIA_HISTORIA_VIAJE_15_DIAS_ANTES`, `NEUMONIA_LUGAR_DONDE_VIAJO`, `NEUMONIA_PORTADOR_ENF_CRONICA`, `NEUMONIA_TIPO_DE_ENFERMEDAD`, `NEUMONIA_ANTIBIOTICO_ULTIMA_SEMANA`, `NEUMONIA_NOMBRE_ANTIBIOTICO`, `NEUMONIA_VIA_DE_ADMINISTRACION`, `NEUMONIA_FECHA_DE_PRIMERA_DOSIS`, `NEUMONIA_FECHA_DE_ULTIMA_DOSIS`, `NEUMONIA_RESULTADO_DE_RADIOGRAFIA`, `NEUMONIA_DESCRIBIR_OTRO_RESULTADO_DE_RX`, `NEUMONIA_CLASIFICACION_FINAL`, `NEUMONIA_AGENTE_CAUSAL`, `NEUMONIA_AGENTE_CAUSAL_CODIGO`, `NEUMONIA_CONDICION_DE_EGRESO`, `NEUMONIA_CONDICION_FECHA`) VALUES
  934. (2, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  935. (3, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  936. (4, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  937. (1, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  938. (5, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  939. (6, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  940. (7, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  941. (8, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  942. (9, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  943. (10, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  944. (11, '0000-00-00', '0', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, 'DIABETES MELLITUS', 0, '', 'ORAL', '0000-00-00', '0000-00-00', 'CONDENSACION', '', '', '', '', '', '0000-00-00'),
  945. (12, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  946. (13, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  947. (14, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  948. (15, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  949. (16, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  950. (17, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  951. (18, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  952. (19, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  953. (20, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  954. (21, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  955. (22, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00'),
  956. (23, '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', 0, '', 0, '', 0, '', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '0000-00-00');
  957.  
  958. -- --------------------------------------------------------
  959.  
  960. --
  961. -- Table structure for table `provincia`
  962. --
  963.  
  964. CREATE TABLE IF NOT EXISTS `provincia` (
  965. `CODIGO_PROVINCIA` tinyint(4) NOT NULL,
  966. `PROVINCIA` varchar(15) NOT NULL,
  967. PRIMARY KEY (`CODIGO_PROVINCIA`)
  968. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  969.  
  970. --
  971. -- Dumping data for table `provincia`
  972. --
  973.  
  974. INSERT INTO `provincia` (`CODIGO_PROVINCIA`, `PROVINCIA`) VALUES
  975. (1, 'BOCAS DEL TORO'),
  976. (2, 'COCOLE'),
  977. (3, 'COLON'),
  978. (4, 'CHIRIQUI'),
  979. (5, 'DARIEN'),
  980. (6, 'HERRERA'),
  981. (7, 'LOS SANTOS'),
  982. (8, 'PANAMA'),
  983. (9, 'VERAGUAS'),
  984. (10, 'KUNA YALA'),
  985. (11, 'NGOBLE BUG');
  986.  
  987. -- --------------------------------------------------------
  988.  
  989. --
  990. -- Table structure for table `user`
  991. --
  992.  
  993. CREATE TABLE IF NOT EXISTS `user` (
  994. `userid` varchar(12) NOT NULL,
  995. `passwd` varchar(15) NOT NULL,
  996. `permission` smallint(6) NOT NULL,
  997. PRIMARY KEY (`userid`)
  998. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  999.  
  1000. --
  1001. -- Dumping data for table `user`
  1002. --
  1003.  
  1004. INSERT INTO `user` (`userid`, `passwd`, `permission`) VALUES
  1005. ('test', 'test12', 9),
  1006. ('Admin', 'test11', 1),
  1007. ('hosp_latin', 'test13', 5),
  1008. ('mellissa', 'melli', 2),
  1009. ('Gilberto', 'gilberto', 2);
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!