API tools faq
paste
Advertisement
YeiZeta

synergica.co by yei zeta

YeiZeta
Nov 1st, 2012
249
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.26 KB | None | 0 0
raw download clone embed print report
  1. By Yei zeta
  2. ------------------------------------------------------------
  3. ADMIN REPORTES: -
  4. -
  5. CDLA_RPRESENTANTE:admin_reportes -
  6. CLIENTE CODIGO:admin_reportes -
  7. REPRESENTANTE_CLAVE:0 -
  8. CODIGO_TIPO:*89E2272A715519ED9C426AEE8C8085A55430DF4B -
  9. NOMBRE:admin -
  10. APELLIDO:REPORTES -
  11. ------------------------------------------------------------------------------------------------------------
  12. CREATE TABLE IF NOT EXISTS `medicos` (
  13. `NMRO_RGSTRO` varchar(20) NOT NULL DEFAULT '',
  14. `CDGO_MDCO` varchar(20) DEFAULT NULL,
  15. `CEDULA` varchar(20) DEFAULT NULL,
  16. `NMBRE` varchar(250) DEFAULT NULL,
  17. `PRMER_APLLDO` varchar(250) DEFAULT NULL,
  18. `SGNDO_APLLDO` varchar(250) DEFAULT NULL,
  19. `DRCCION_RSDNCIA` varchar(250) DEFAULT NULL,
  20. `TLFNO_RSDNCIA` varchar(250) DEFAULT NULL,
  21. `CLLAR` varchar(250) DEFAULT NULL,
  22. `FCHA_NCMNTO` datetime DEFAULT NULL,
  23. `ESTDO_CVIL` char(3) DEFAULT NULL,
  24. `DRCCION_CNSLTRIO` varchar(250) DEFAULT NULL,
  25. `TLFNO_CSLTRIO` varchar(250) DEFAULT NULL,
  26. `EMAIL` varchar(250) DEFAULT NULL,
  27. `CDGO_NGCIO` varchar(4) DEFAULT NULL,
  28. `CDGO_CDAD` varchar(4) DEFAULT NULL,
  29. `CDGO_CDAD_RSDNCIA` varchar(4) DEFAULT NULL,
  30. `ESTDO_MDCO` char(3) DEFAULT NULL,
  31. `CDGO_CDAD_CED` varchar(4) DEFAULT NULL,
  32. `SEXO` char(3) DEFAULT NULL,
  33. `CDGO_ATENCION` varchar(4) DEFAULT NULL,
  34. `CDGO_ATENCION2` varchar(4) DEFAULT NULL,
  35. `CLIENTE_CODIGO` int(11) NOT NULL DEFAULT '0',
  36. `SECRETARIA` varchar(250) DEFAULT NULL,
  37. `ASOCIACIONES` varchar(250) DEFAULT NULL,
  38. `FECHA_ACT` varchar(20) DEFAULT '2007-02-01',
  39. `TIPO` varchar(4) NOT NULL DEFAULT 'M',
  40. `NUM_CIRUGIA` int(11) DEFAULT '0',
  41. PRIMARY KEY (`NMRO_RGSTRO`,`CLIENTE_CODIGO`),
  42. KEY `CDGO_NGCIO` (`CDGO_NGCIO`),
  43. KEY `CDGO_CDAD` (`CDGO_CDAD`),
  44. KEY `CDGO_CDAD_RSDNCIA` (`CDGO_CDAD_RSDNCIA`),
  45. KEY `CDGO_CDAD_CED` (`CDGO_CDAD_CED`)
  46. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  47.  
  48. --
  49. -- Volcar la base de datos para la tabla `medicos`
  50. --
  51.  
  52. INSERT INTO `medicos` (`NMRO_RGSTRO`, `CDGO_MDCO`, `CEDULA`, `NMBRE`, `PRMER_APLLDO`, `SGNDO_APLLDO`, `DRCCION_RSDNCIA`, `TLFNO_RSDNCIA`, `CLLAR`, `FCHA_NCMNTO`, `ESTDO_CVIL`, `DRCCION_CNSLTRIO`, `TLFNO_CSLTRIO`, `EMAIL`, `CDGO_NGCIO`, `CDGO_CDAD`, `CDGO_CDAD_RSDNCIA`, `ESTDO_MDCO`, `CDGO_CDAD_CED`, `SEXO`, `CDGO_ATENCION`, `CDGO_ATENCION2`, `CLIENTE_CODIGO`, `SECRETARIA`, `ASOCIACIONES`, `FECHA_ACT`, `TIPO`, `NUM_CIRUGIA`) VALUES
  53. ('12001', '12001', '12001', 'EDGAR', 'AFANADOR', 'ACUÑA', 'Trav. 22 no.100-24-H.Militar ', '2575791', '', '0000-00-00 00:00:00', '', '', '', '', '002', '', '4', 'AC', '', '', '', '', 0, '', '', '2011-12-12', 'M', 0),
  54. ('12002', NULL, '12002', 'BERNARDO', 'AGUILERA', 'BOHORQUEZ', 'Cra. 38A No.5A-100 706 Torre A ', '5584340-8922354 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  55. ('12003', NULL, '12003', 'ENRIQUE', 'ANTOLINEZ', 'VICTOR', 'Clínica San Jose LINICA SAN JOSE 5 PISO- CONS.502B ', '5833892', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  56. ('12004', NULL, '12004', 'OSCAR', 'APONTE', 'PUENTES', 'Cra 16 No 84 -74 ', '6919272', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-12-13', 'M', 0),
  57. ('12005', NULL, '12005', 'CESAR', 'ARANGO', 'PILONIETA', 'Av. 13 No.104-12 Cons 206 ', '6201015', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  58. ('12006', NULL, '12006', 'WILLIAM', 'ARBELAEZ', 'ARBELAEZ', 'Cr. 21 N.132-45 Cons 3 ', '2583221', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  59. ('12007', NULL, '12007', 'JORGE', 'ARISTIZABAL', 'ARISTIZABAL', 'Cll 163 A # 13 B 60 ', '6672727', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  60. ('12008', NULL, '12008', 'ANTONIO', 'BECERRA', 'GOMEZ', 'Cra 13 # 49 - 40 Cons 430 ', '3434600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  61. ('12009', NULL, '12009', 'CARLOS', 'BERMUDEZ', 'BERMUDEZ', 'cra 52 67a-71 ', '3102553146', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  62. ('12010', NULL, '12010', 'JACINTO', 'BOLAÑOS', 'REBOLLEDO', 'Cra. 35 No.17-41 (201) ', '7238464', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  63. ('12011', NULL, '12011', 'JULIO', 'BRAVO', 'ARDILA', 'CRA 16 No 84 A 09 ', '2575791', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  64. ('12012', NULL, '12012', 'GERMAN', 'BUITRAGO', '.', 'Clinica Remedios Cons. 601 ', '5584340-8922354 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  65. ('12013', NULL, '12013', 'REEMBERTO IGNACIO', 'BURGOS', 'DE LA ESPRIELLA', 'Trav. 22 No.47B-51Sur ', '5833892', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  66. ('12014', NULL, '12014', 'MIGUEL ANTONIO', 'CABANA', 'HERRERA', 'Clinica Versalles ', '6919272', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  67. ('12015', NULL, '12015', 'SUSY', 'MANOTAS', 'CHAR', 'Av. 9 No. 117-20 (815) ', '6201015', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-12-13', 'M', 0),
  68. ('12016', NULL, '12016', 'LILIAN', 'GONZALES', 'GOMEZCACERES', 'Cr. 21 N.132-45 Cons 3 ', '2583221', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  69. ('12017', NULL, '12017', 'GERMAN', 'CARRILLO', 'ARANGO', 'Cll 163 A # 13 B 60 ', '6672727', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  70. ('12018', NULL, '12018', 'ANDREA', 'CASALLAS', '.', 'Cra 13 # 49 - 40 Cons 430 ', '3434600', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  71. ('12019', NULL, '12019', 'ROSA', 'CATIBLANCO', '.', 'cra 52 67a-71 ', '3102553146', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  72. ('12020', NULL, '12020', 'EDGAR ORLANDO', 'CLAVIJO', 'CRUZ', 'cra 52 67a-71 ', '7238464', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  73. ('3456888', '3456888', '3456888', 'FELIX', 'MALDONADO', 'ARANA', 'Calle 127 Autopista', '2345678', '314 55555', '0000-00-00 00:00:00', '', '', '', '', '', '', '4', 'AC', '', '', '', '', 0, '', '', '2011-12-11', 'M', 0),
  74. ('12022', NULL, '12022', 'EDGAR', 'BRAVO', 'ARISTIZABAL', 'Av. 13 No.104-12 Cons 206 ', '7238464', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-12-13', 'M', 0),
  75. ('12023', NULL, '12023', 'BERNARDO', 'BUITRAGO', 'GOMEZ', 'Cr. 21 N.132-45 Cons 3 ', '2575791', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  76. ('12024', NULL, '12024', 'ENRIQUE', 'BURGOS', 'BERMUDEZ', 'Cll 163 A # 13 B 60 ', '5584340-8922354 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  77. ('12025', NULL, '12025', 'OSCAR', 'CABANA', 'REBOLLEDO', 'Cra 13 # 49 - 40 Cons 430 ', '5833892', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-12-13', 'M', 0),
  78. ('12026', NULL, '12026', 'CESAR', 'CALIXTO', 'ARDILA', 'cra 52 67a-71 ', '6919272', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  79. ('12027', NULL, '12027', 'WILLIAM', 'CARDONA', 'BALLESTEROS', 'Cra. 35 No.17-41 (201) ', '6201015', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  80. ('12028', NULL, '12028', 'JORGE', 'CARRILLO', 'CUARTAS', 'CRA 16 No 84 A 09 ', '5833892', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  81. ('12029', NULL, '12029', 'ANTONIO', 'CASALLAS', 'ARANGO', 'Clinica Remedios Cons. 601 ', '6919272', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  82. ('12030', NULL, '12030', 'CARLOS', 'CATIBLANCO', '.', '', '6201015', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5', 'AC', NULL, NULL, NULL, NULL, 0, '', '', '2011-05-26', 'M', 0),
  83. ('34566667', '34566667', '34566667', 'Cesar', 'Alvarez', '.', 'Av 68 Con Esperanza', '2345678', '', '0000-00-00 00:00:00', '', '', '', '', '', '', '4', 'AC', '', 'M', '004', '', 0, '', '', '2011-12-02', 'M', 0),
  84. ('72239761', '72239761', '72239761', 'ANTONIO', 'MASS', 'OROZCO', 'KRA 41G # 47-40', '3622781', '3006729185', '1978-10-26 00:00:00', 'SO', '', '', '',
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!