8sYUYP0p

1CREATE TABLE IF NOT EXISTS 10010101000035 (
2    `npl_medprod` VARCHAR(255),
3    `npl_medprod_xmlns_xsi` VARCHAR(255) CHARACTER SET utf8,
4    `npl_medprod_xmlns_npl` VARCHAR(255) CHARACTER SET utf8,
5    `npl_medprod_xsi_schemaLocation` VARCHAR(255) CHARACTER SET utf8,
6    `npl_medprod_xmlns_mpa` VARCHAR(255) CHARACTER SET utf8,
7    `npl_medprod_mpa_nplid` VARCHAR(255),
8    `npl_medprod_npl_names` VARCHAR(255),
9    `npl_medprod_npl_names_mpa_medprodname` VARCHAR(255),
10    `npl_medprod_npl_names_mpa_medprodname_v` VARCHAR(255) CHARACTER SET utf8,
11    `npl_medprod_npl_names_mpa_medprodnamelegal` VARCHAR(255),
12    `npl_medprod_npl_names_mpa_medprodnamelegal_v` VARCHAR(255) CHARACTER SET utf8,
13    `npl_medprod_mpa_strength_text` VARCHAR(255),
14    `npl_medprod_mpa_strength_text_mpa_v` VARCHAR(255) CHARACTER SET utf8,
15    `npl_medprod_mpa_pharmaceutical_form_lx` VARCHAR(255),
16    `npl_medprod_mpa_pharmaceutical_form_lx_lexicon` VARCHAR(255) CHARACTER SET utf8,
17    `npl_medprod_mpa_pharmaceutical_form_lx_v` VARCHAR(255) CHARACTER SET utf8,
18    `npl_medprod_mpa_productclass_lx` VARCHAR(255),
19    `npl_medprod_mpa_productclass_lx_lexicon` VARCHAR(255) CHARACTER SET utf8,
20    `npl_medprod_mpa_productclass_lx_v` VARCHAR(255) CHARACTER SET utf8,
21    `npl_medprod_mpa_prescription_lx` VARCHAR(255),
22    `npl_medprod_mpa_prescription_lx_lexicon` VARCHAR(255) CHARACTER SET utf8,
23    `npl_medprod_mpa_prescription_lx_v` VARCHAR(255),
24    `npl_medprod_npl_classifications` VARCHAR(255),
25    `npl_medprod_npl_classifications_mpa_atc_code_lx` VARCHAR(255),
26    `npl_medprod_npl_classifications_mpa_atc_code_lx_v` VARCHAR(255) CHARACTER SET utf8,
27    `medprod_npl_classifications_mpa_controlled_medicinal_product_lx` VARCHAR(255),
28    `npl_classifications_mpa_controlled_medicinal_product_lx_lexicon` VARCHAR(255) CHARACTER SET utf8,
29    `npl_classifications_mpa_controlled_medicinal_product_lx_v` VARCHAR(255) CHARACTER SET utf8,
30    `npl_medprod_npl_classifications_mpa_narcotic_class_lx` VARCHAR(255),
31    `npl_medprod_npl_classifications_mpa_narcotic_class_lx_lexicon` VARCHAR(255) CHARACTER SET utf8,
32    `npl_medprod_npl_classifications_mpa_narcotic_class_lx_v` VARCHAR(255),
33    `npl_medprod_npl_flags` VARCHAR(255),
34    `npl_medprod_npl_flags_mpa_salesstopped` VARCHAR(255),
35    `npl_medprod_npl_flags_mpa_salesstopped_lexicon` VARCHAR(255) CHARACTER SET utf8,
36    `npl_medprod_npl_flags_mpa_salesstopped_v` VARCHAR(255) CHARACTER SET utf8,
37    `npl_medprod_npl_withdrawal_periods` VARCHAR(255),
38    `npl_medprod_npl_organizations` VARCHAR(255),
39    `npl_medprod_npl_organizations_mpa_organization` VARCHAR(255),
40    `medprod_npl_organizations_mpa_organization_mpa_organization_lx` VARCHAR(255),
41    `medprod_npl_organizations_mpa_organization_mpa_organization_lx_v` VARCHAR(255) CHARACTER SET utf8,
42    `npl_organizations_mpa_organization_mpa_organization_role_lx` VARCHAR(255),
43    `organizations_mpa_organization_mpa_organization_role_lx_lexicon` VARCHAR(255) CHARACTER SET utf8,
44    `npl_organizations_mpa_organization_mpa_organization_role_lx_v` VARCHAR(255) CHARACTER SET utf8,
45    `npl_medprod_npl_pharmaceutical_products` VARCHAR(255),
46    `medprod_npl_pharmaceutical_products_npl_pharmaceutical_product` VARCHAR(255),
47    `npl_pharmaceutical_products_npl_pharmaceutical_product_id` VARCHAR(255) CHARACTER SET utf8,
48    `products_npl_pharmaceutical_product_mpa_comp_ref_quantity_lx` VARCHAR(255),
49    `npl_pharmaceutical_product_mpa_comp_ref_quantity_lx_lexicon` VARCHAR(255) CHARACTER SET utf8,
50    `products_npl_pharmaceutical_product_mpa_comp_ref_quantity_lx_v` VARCHAR(255) CHARACTER SET utf8,
51    `products_npl_pharmaceutical_product_npl_composition` VARCHAR(255),
52    `npl_pharmaceutical_product_npl_composition_npl_ingredient` VARCHAR(255),
53    `npl_pharmaceutical_product_npl_composition_npl_ingredient_id` VARCHAR(255) CHARACTER SET utf8,
54    `product_npl_composition_npl_ingredient_mpa_ingredient_role_lx` VARCHAR(255),
55    `npl_composition_npl_ingredient_mpa_ingredient_role_lx_lexicon` VARCHAR(255) CHARACTER SET utf8,
56    `product_npl_composition_npl_ingredient_mpa_ingredient_role_lx_v` VARCHAR(255) CHARACTER SET utf8,
57    `product_npl_composition_npl_ingredient_mpa_quantity_unit_alt_lx` VARCHAR(255),
58    `npl_composition_npl_ingredient_mpa_quantity_unit_alt_lx_lexicon` VARCHAR(255) CHARACTER SET utf8,
59    `npl_composition_npl_ingredient_mpa_quantity_unit_alt_lx_v` VARCHAR(255) CHARACTER SET utf8,
60    `product_npl_composition_npl_ingredient_mpa_substance_lx` VARCHAR(255),
61    `product_npl_composition_npl_ingredient_mpa_substance_lx_v` VARCHAR(255) CHARACTER SET utf8,
62    `npl_medprod_npl_packages` VARCHAR(255),
63    `npl_medprod_npl_packages_npl_package` VARCHAR(255),
64    `npl_medprod_npl_packages_npl_package_mpa_nplpackid` VARCHAR(255),
65    `npl_medprod_npl_packages_npl_package_mpa_pack_text` VARCHAR(255),
66    `npl_medprod_npl_packages_npl_package_mpa_pack_text_mpa_v` VARCHAR(255) CHARACTER SET utf8,
67    `npl_medprod_npl_packages_npl_package_npl_prescription` VARCHAR(255),
68    `npl_medprod_npl_packages_npl_package_npl_prescription_mpa_otc` VARCHAR(255),
69    `npl_packages_npl_package_npl_prescription_mpa_otc_lexicon` VARCHAR(255) CHARACTER SET utf8,
70    `npl_medprod_npl_packages_npl_package_npl_prescription_mpa_otc_v` VARCHAR(255) 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');