· 7 years ago · Nov 12, 2018, 03:28 PM
1CREATE TABLE IF NOT EXISTS medicamentos (
2 `cod` VARCHAR(213) CHARACTER SET utf8,
3 `nome` VARCHAR(163) CHARACTER SET utf8,
4 `formaBase` VARCHAR(497) CHARACTER SET utf8,
5 `dosePrincipioAtivo` VARCHAR(111) CHARACTER SET utf8,
6 ` ` VARCHAR(120) CHARACTER SET utf8,
7 ` ` VARCHAR(149) CHARACTER SET utf8,
8 ` ` VARCHAR(32) CHARACTER SET utf8,
9 ` ` VARCHAR(7) CHARACTER SET utf8,
10 `via` VARCHAR(7) CHARACTER SET utf8,
11 ` ` VARCHAR(23) CHARACTER SET utf8,
12 `pvp` VARCHAR(32) CHARACTER SET utf8,
13 `laboratorio` VARCHAR(5) CHARACTER SET utf8
14);
15INSERT INTO medicamentos VALUES
16 ('650004','DEPAKINE 500 mg COMPRIMIDOS GASTRORRESISTENTES, 20 comprimidos','VALPROICO ACIDO','500','ORAL','4,09','SANOFI AVENTIS, S.A'),
17 ('650005','DEPAKINE 500 mg COMPRIMIDOS GASTRORRESISTENTES, 100 comprimidos','VALPROICO ACIDO','500','ORAL','15,19','SANOFI AVENTIS, S.A'),
18 ('650006','DEPAKINE 200 mg COMPRIMIDOS GASTRORRESISTENTES, 40 comprimidos','VALPROICO ACIDO','200','ORAL','3,75','SANOFI AVENTIS, S.A'),
19 ('650007','DEPAKINE 200 mg COMPRIMIDOS GASTRORRESISTENTES, 100 comprimidos','VALPROICO ACIDO','200','ORAL','7,01','SANOFI AVENTIS, S.A'),
20 ('650095','TRANDATE 200 mg COMPRIMIDOS RECUBIERTOS, 30 comprimidos','LABETALOL','200','ORAL','5,09','KERN PHARMA, S.L.'),
21 ('650097','DOLVIRAN COMPRIMIDOS, 20 comprimidos','CODEINA | ACETILSALICILICO ACIDO | CAFEINA','9.6 | 400 | 50','ORAL','1,76','KERN PHARMA, S.L.'),
22 ('650098','DOLVIRAN SUPOSITORIOS, 10 supositorios','CODEINA | ACETILSALICILICO ACIDO | CAFEINA','9.6 | 400 | 50','RECTAL','1,86','KERN PHARMA, S.L.'),
23 ('650099','NOCTAMID 1 mg COMPRIMIDOS, 30 comprimidos','LORMETAZEPAM','1','ORAL','2,01','TEOFARMA, S.R.L'),
24 ('650100','NOCTAMID 2 mg COMPRIMIDOS, 20 comprimidos','LORMETAZEPAM','2','ORAL','2,31','TEOFARMA, S.R.L'),
25 ('650104','ROMILAR 15 mg/ml GOTAS ORALES EN SOLUCION, 1 frasco de 20 ml','DEXTROMETORFANO','15','ORAL','5,06','BAYER HISPANIA, S.L'),
26 ('650115','ALGI-MABO AMPOLLAS, 6 ampollas de 5 ml','METAMIZOL','2000','INTRAMUSCULAR | INTRAVENOSA','2,06','MABO-FARMA, S.A.'),
27 ('650120','RESINSODIO POLVO PARA SUSPENSION ORAL, 1 frasco de 400 g','POLIESTIRENO SULFONATO','997.5','ORAL','29,72','RUBIO, S.A.'),
28 ('650163','ATACAND 32 mg COMPRIMIDOS, 28 comprimidos','CANDESARTAN','32','ORAL','20,97','ASTRAZENECA FARMACEUTICA SPAIN, S.A'),
29 ('650166','CITALOPRAM FARMALIDER 10 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 28 comprimidos','CITALOPRAM','10','ORAL','2,56','FARMALIDER S.A.'),
30 ('650179','INSPRA 50 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 30 comprimidos','EPLERENONA','50','ORAL','53,34','PFIZER GEP, S.L.'),
31 ('650181','INSPRA 25 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 30 comprimidos','EPLERENONA','25','ORAL','26,68','PFIZER GEP, S.L.'),
32 ('650195','ARTEOPTIC 2% COLIRIO DE LIBERACION PROLONGADA, 1 frasco de 3 ml','CARTEOLOL','20','OFTALMICA','2,50','BAUSCH AND LOMB, S.A'),
33 ('650196','HIDRATHEA 9 mg/ml COLIRIO EN SOLUCION, 1 frasco de 10 ml','SODIO','9','OFTALMICA','5,98','THEA S.A.'),
34 ('650216','PUREGON 900 UI/1,08 ml SOLUCION INYECTABLE, 1 cartucho de 1,08 ml','FOLITROPINA BETA','900','SUBCUTANEA','359,05','MERCK SHARP AND DOHME DE ESPAÑA'),
35 ('650221','KARVEZIDE 150 mg/12,5 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 28 comprimidos','IRBESARTAN | HIDROCLOROTIAZIDA','150 | 12.5','ORAL','9,65','SANOFI AVENTIS',' S.A'),
36 ('650222','KARVEZIDE 300 mg/12,5 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 28 comprimidos','IRBESARTAN | HIDROCLOROTIAZIDA','300 | 12.5','ORAL','19,29','SANOFI AVENTIS',' S.A'),
37 ('650234','POMADA ANTIBIOTICA LIADE, 1 tubo de 30 g','NEOMICINA | BACITRACINA | POLIMIXINA B','4 | 200 | 0.4','USO CUTANEO','3,12','DESMA LABORATORIO FARMACEUTICO, S.L.'),
38 ('650242','POMADA ANTIBIOTICA LIADE, 1 tubo de 15 g','NEOMICINA | BACITRACINA | POLIMIXINA B','4 | 200 | 0.4','USO CUTANEO','1,92','DESMA LABORATORIO FARMACEUTICO, S.L.'),
39 ('650248','ARTEOPTIC 1% COLIRIO DE LIBERACION PROLONGADA, 1 frasco de 3 ml','CARTEOLOL','10','OFTALMICA','2,50','BAUSCH AND LOMB, S.A'),
40 ('650256','CLARITROMICINA SANDOZ 25 mg/ml GRANULADO PARA SUSPENSION ORAL , 1 frasco de 100 ml','CLARITROMICINA','125','ORAL','4,95','SANDOZ FARMACEUTICA, S.A'),
41 ('650283','HALOPERIDOL ESTEVE 2 mg/ml SOLUCION ORAL, 1 frasco de 30 ml','HALOPERIDOL','2','ORAL','2,50','PENSA PHARMA, S.A.U'),
42 ('650304','CITALVIR 10 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 28 comprimidos','CITALOPRAM','10','ORAL','2,56','ABABOR PHARMACEUTICALS, S.L.'),
43 ('650327','IMIGRAN NEO 50 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 4 comprimidos','SUMATRIPTAN','50','ORAL','12','27','GLAXOSMITHKLINE, S.A.'),
44 ('650352','TOBREXAN 3 mg/ml COLIRIO EN SOLUCION, 1 frasco de 4 ml','TOBRAMICINA','3','OFTALMICA','2','50','NOVARTIS FARMACEUTICA, S.A.'','),
45 ('650381','BLOPRESS 32 mg COMPRIMIDOS, 28 comprimidos','CANDESARTAN','32','ORAL','20,97','TAKEDA FARMACEUTICA ESPAÑA, S.A'),
46 ('650383','BOSPORON RAPID 8 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 30 comprimidos','LORNOXICAM','8','ORAL','6,78','TAKEDA FARMACEUTICA ESPAÑA, S.A'),
47 ('650389','CO-DIOVAN FORTE 160 mg/25 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 28 comprimidos','VALSARTAN | HIDROCLOROTIAZIDA','160 | 25','ORAL','11,99','NOVARTIS FARMACEUTICA S.A.'),
48 ('650392','REGULATEN PLUS 600 mg/12','5 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 28 comprimidos','EPROSARTAN | HIDROCLOROTIAZIDA','600 | 12.5','ORAL','24,82','MYLAN PHARMACEUTICALS',' S.L'),
49 ('650393','OMEPRAZOL SANDOZ FARMACEUTICA 40 MG CAPSULAS DURAS GASTRORRESISTENTES, 28 cápsulas (blister)','OMEPRAZOL','40','ORAL','4,15','SANDOZ FARMACEUTICA',' S.A'),
50 ('650417','IBUPROFENO VIR 600 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 40 comprimidos','IBUPROFENO','600','ORAL','1,97','INDUSTRIA QUIMICA Y FARMACEUTICA VIR, S.A.'),
51 ('650428','KEPPRA 100 mg/ml SOLUCION ORAL, 1 frasco de 300 ml con jeringa oral de 10 ml','LEVETIRACETAM','100','ORAL','56,64','UCB PHARMA S.A.'),
52 ('650431','TESTIM 50 mg GEL transdermico, 30 tubos unidosis de 5 g','TESTOSTERONA','50','TRANSDERMICA','52,92','FERRING S.A.U'),
53 ('650471','CITALOPRAM VIR 10 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 14 comprimidos','CITALOPRAM','10','ORAL','2,50','INDUSTRIA QUIMICA Y FARMACEUTICA VIR, S.A.'),
54 ('650472','CITALOPRAM VIR 10 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 28 comprimidos','CITALOPRAM','10','ORAL','2,56','INDUSTRIA QUIMICA Y FARMACEUTICA VIR, S.A.'),
55 ('650498','XERISTAR 60 mg CAPSULAS DURAS GASTRORRESISTENTES, 28 cápsulas','DULOXETINA','60','ORAL','29,72','DOCTOR ESTEVE S.A.'','),
56 ('650543','NAVIXEN PLUS 600 mg/12,5 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 28 comprimidos','EPROSARTAN | HIDROCLOROTIAZIDA','600 | 12.5','ORAL','24,82','MYLAN PHARMACEUTICALS, S.L'),
57 ('650545','INEGY 10 mg/20 mg COMPRIMIDOS, 28 comprimidos','SIMVASTATINA | EZETIMIBA','20 | 10','ORAL','54,53','MERCK SHARP AND DOHME DE ESPAÑA'),
58 ('650576','OMPRANYT 20 mg CAPSULAS DURAS GASTRORRESISTENTES, 28 cápsulas','OMEPRAZOL','20','ORAL','2,42','LABORATORIOS BIAL, S.A.'),
59 ('650578','ULCERAL 20 mg CAPSULAS DURAS GASTRORRESISTENTES , 28 cápsulas','OMEPRAZOL','20','ORAL','2,42','TEDEC MEIJI FARMA S.A.'','),
60 ('650588','XAGRID 0,5 mg CAPSULAS DURAS, 100 cápsulas','ANAGRELIDA','0.5','ORAL','486,27','SHIRE PHARMACEUTICALS IBERICA S.L.'),
61 ('650590','XERISTAR 30 mg CAPSULAS DURAS GASTRORRESISTENTES, 28 cápsulas','DULOXETINA','30','ORAL','14,86','DOCTOR ESTEVE S.A.'','),
62 ('650591','ARIXTRA 5 mg/0,4 ml SOL INY EN JERINGA PRECARGADA, 10 jeringas precargadas de 0,4 ml','FONDAPARINUX','5','SUBCUTANEA','197,90','ASPEN PHARMA TRADING LTD'),
63 ('650592','ARIXTRA 7,5 mg/0,6 ml SOL INY EN JERINGA PRECARGADA, 10 jeringas precargadas de 0,6 ml','FONDAPARINUX','7.5','SUBCUTANEA','223,42','ASPEN PHARMA TRADING LTD'),
64 ('650612','LACTISONA 10 mg/ml EMULSION CUTANEA, 1 frasco de 60 ml, HIDROCORTISONA','10','USO CUTANEO','3,92','STIEFEL FARMA, S.A'),
65 ('650613','LACTISONA 25 mg/ml EMULSION CUTANEA, 1 frasco de 60 ml','HIDROCORTISONA','25','USO CUTANEO','9,79','STIEFEL FARMA, S.A'),
66 ('650622','AFLUON 1 mg/ml SOLUCIÓN PARA PULVERIZACIÓN NASAL, 1 frasco de 20 ml','AZELASTINA','1','NASAL','14,16','MEDA PHARMA, S.L'),
67 ('650641','FUTURAN PLUS 600 mg/12','5 mg COMPRIMIDOS RECUBIERTOS CON PELICULA, 28 comprimidos','EPROSARTAN | HIDROCLOROTIAZIDA','600 | 12.5','ORAL','24','82','MYLAN PHARMACEUTICALS',' S.L');