X5rLTh4C

1CREATE TABLE IF NOT EXISTS 10010101000035 (
2    `npl_medprod` INT,
3    `npl_medprod_xmlns_xsi` VARCHAR(41) CHARACTER SET utf8,
4    `npl_medprod_xmlns_npl` VARCHAR(27) CHARACTER SET utf8,
5    `npl_medprod_xsi_schemaLocation` VARCHAR(58) CHARACTER SET utf8,
6    `npl_medprod_xmlns_mpa` VARCHAR(22) CHARACTER SET utf8,
7    `npl_medprod_mpa_nplid` INT,
8    `npl_medprod_npl_names` INT,
9    `npl_medprod_npl_names_mpa_medprodname` INT,
10    `npl_medprod_npl_names_mpa_medprodname_v` VARCHAR(9) CHARACTER SET utf8,
11    `npl_medprod_npl_names_mpa_medprodnamelegal` INT,
12    `npl_medprod_npl_names_mpa_medprodnamelegal_v` VARCHAR(9) CHARACTER SET utf8,
13    `npl_medprod_mpa_strength_text` INT,
14    `npl_medprod_mpa_strength_text_mpa_v` VARCHAR(8) CHARACTER SET utf8,
15    `npl_medprod_mpa_pharmaceutical_form_lx` INT,
16    `npl_medprod_mpa_pharmaceutical_form_lx_lexicon` VARCHAR(22) CHARACTER SET utf8,
17    `npl_medprod_mpa_pharmaceutical_form_lx_v` VARCHAR(6) CHARACTER SET utf8,
18    `npl_medprod_mpa_productclass_lx` INT,
19    `npl_medprod_mpa_productclass_lx_lexicon` VARCHAR(15) CHARACTER SET utf8,
20    `npl_medprod_mpa_productclass_lx_v` VARCHAR(3) CHARACTER SET utf8,
21    `npl_medprod_mpa_prescription_lx` INT,
22    `npl_medprod_mpa_prescription_lx_lexicon` VARCHAR(15) CHARACTER SET utf8,
23    `npl_medprod_mpa_prescription_lx_v` INT,
24    `npl_medprod_npl_classifications` INT,
25    `npl_medprod_npl_classifications_mpa_atc_code_lx` INT,
26    `npl_medprod_npl_classifications_mpa_atc_code_lx_v` VARCHAR(7) CHARACTER SET utf8,
27    `medprod_npl_classifications_mpa_controlled_medicinal_product_lx` INT,
28    `npl_classifications_mpa_controlled_medicinal_product_lx_lexicon` VARCHAR(8) CHARACTER SET utf8,
29    `npl_classifications_mpa_controlled_medicinal_product_lx_v` VARCHAR(1) CHARACTER SET utf8,
30    `npl_medprod_npl_classifications_mpa_narcotic_class_lx` INT,
31    `npl_medprod_npl_classifications_mpa_narcotic_class_lx_lexicon` VARCHAR(26) CHARACTER SET utf8,
32    `npl_medprod_npl_classifications_mpa_narcotic_class_lx_v` INT,
33    `npl_medprod_npl_flags` INT,
34    `npl_medprod_npl_flags_mpa_salesstopped` INT,
35    `npl_medprod_npl_flags_mpa_salesstopped_lexicon` VARCHAR(8) CHARACTER SET utf8,
36    `npl_medprod_npl_flags_mpa_salesstopped_v` VARCHAR(1) CHARACTER SET utf8,
37    `npl_medprod_npl_withdrawal_periods` INT,
38    `npl_medprod_npl_organizations` INT,
39    `npl_medprod_npl_organizations_mpa_organization` INT,
40    `medprod_npl_organizations_mpa_organization_mpa_organization_lx` INT,
41    `medprod_npl_organizations_mpa_organization_mpa_organization_lx_v` VARCHAR(18) CHARACTER SET utf8,
42    `npl_organizations_mpa_organization_mpa_organization_role_lx` INT,
43    `organizations_mpa_organization_mpa_organization_role_lx_lexicon` VARCHAR(20) CHARACTER SET utf8,
44    `npl_organizations_mpa_organization_mpa_organization_role_lx_v` VARCHAR(3) CHARACTER SET utf8,
45    `npl_medprod_npl_pharmaceutical_products` INT,
46    `medprod_npl_pharmaceutical_products_npl_pharmaceutical_product` INT,
47    `npl_pharmaceutical_products_npl_pharmaceutical_product_id` VARCHAR(18) CHARACTER SET utf8,
48    `products_npl_pharmaceutical_product_mpa_comp_ref_quantity_lx` INT,
49    `npl_pharmaceutical_product_mpa_comp_ref_quantity_lx_lexicon` VARCHAR(20) CHARACTER SET utf8,
50    `products_npl_pharmaceutical_product_mpa_comp_ref_quantity_lx_v` VARCHAR(3) CHARACTER SET utf8,
51    `products_npl_pharmaceutical_product_npl_composition` INT,
52    `npl_pharmaceutical_product_npl_composition_npl_ingredient` INT,
53    `npl_pharmaceutical_product_npl_composition_npl_ingredient_id` VARCHAR(18) CHARACTER SET utf8,
54    `product_npl_composition_npl_ingredient_mpa_ingredient_role_lx` INT,
55    `npl_composition_npl_ingredient_mpa_ingredient_role_lx_lexicon` VARCHAR(18) CHARACTER SET utf8,
56    `product_npl_composition_npl_ingredient_mpa_ingredient_role_lx_v` VARCHAR(4) CHARACTER SET utf8,
57    `product_npl_composition_npl_ingredient_mpa_quantity_unit_alt_lx` INT,
58    `npl_composition_npl_ingredient_mpa_quantity_unit_alt_lx_lexicon` VARCHAR(20) CHARACTER SET utf8,
59    `npl_composition_npl_ingredient_mpa_quantity_unit_alt_lx_v` VARCHAR(2) CHARACTER SET utf8,
60    `product_npl_composition_npl_ingredient_mpa_substance_lx` INT,
61    `product_npl_composition_npl_ingredient_mpa_substance_lx_v` VARCHAR(18) CHARACTER SET utf8,
62    `npl_medprod_npl_packages` INT,
63    `npl_medprod_npl_packages_npl_package` INT,
64    `npl_medprod_npl_packages_npl_package_mpa_nplpackid` INT,
65    `npl_medprod_npl_packages_npl_package_mpa_pack_text` INT,
66    `npl_medprod_npl_packages_npl_package_mpa_pack_text_mpa_v` VARCHAR(17) CHARACTER SET utf8,
67    `npl_medprod_npl_packages_npl_package_npl_prescription` INT,
68    `npl_medprod_npl_packages_npl_package_npl_prescription_mpa_otc` INT,
69    `npl_packages_npl_package_npl_prescription_mpa_otc_lexicon` VARCHAR(8) CHARACTER SET utf8,
70    `npl_medprod_npl_packages_npl_package_npl_prescription_mpa_otc_v` VARCHAR(1) CHARACTER SET utf8
71);
72INSERT INTO 10010101000035 VALUES
73    (NULL,'http://www.w3.org/2001/XMLSchema-instance','urn:schemas-npl:instance:10','urn:schemas-npl:instance:10 ../schemas/npl-schema_10.0.xsd','urn:schemas-npl:mpa:10',10010101000035,NULL,NULL,'Nifehexal',NULL,'Nifehexal',NULL,'20 mg/ml',NULL,'pharmaceutical-form-lx','ORDRSO',NULL,'productclass-lx','LIC',NULL,'prescription-lx',1,NULL,NULL,'C08CA05',NULL,'yesno-lx','N',NULL,'narcotic-classification-lx',0,NULL,NULL,'yesno-lx','N',NULL,NULL,NULL,NULL,'ID1H2FVVK1W99B9JMS',NULL,'organization-role-lx','MAH',NULL,NULL,'IDBP5L3EBPTRAXSRV0',NULL,'comp-ref-quantity-lx','FGE',NULL,NULL,'IDBP5L3HBPTTRRSRV0',NULL,'ingredient-role-lx','ACTI',NULL,'quantity-unit-alt-lx','EQ',NULL,'IDE4POEOUADS5VERT1',NULL,NULL,20131219100060,NULL,'Licensförpackning',NULL,NULL,'yesno-lx','N');