<!-- \enraf-nonius\backup-scripts-certitool\  -->
<?php declare(strict_types=1);
session_start();
require "mainnavbar.php";
require "general.php";

//: add comment fields for table and column
global $slocation, $un, $pw, $db, $sn, $port, $dsn;
$dsn = "mysql:host=$sn;dbname=$db;charset=$charset";
$create_db = 0;
$create_table = 1;
$create_users = 1;
$create_revision_history = 0;
$create_compliance_reference = 0;
$create_td_tools_items = 1;
$create_projects = 1; //
$create_docs = 1;
$create_doc_items = 1;
$create_user_groups = 1;
$create_products = 0;  //dte?
$create_references = 0;
$create_problem_log = 0; //d?
$create_reference_standards = 0;
$create_doc = 1; //delete
$create_paragraph = 0;//doc index
$create_index = 0;
$create_pmp_requirements = 0;
$create_reference_items = 1;
$create_delphi = 1;
$create_view_items_delphi = 1;

$create_td_tools = 1;
$create_risk_mitigation =1;
$create_td_tools_category = 0;
$create_revisions_doc = 1;
$create_reference_item = 1;
$create_pd_items = 0;
$create_pexs_requirements =0;
$create_subject_risk = 0;
$create_rmf_characteristics = 0;
$create_source_risk = 0;
$create_tree_view_items = 0;
$create_item_doc = 0;

$create_usability = 1;
$create_translations = 1;
$create_critical_components = 0;
$create_rmf_risk_mitigation = 0;
$create_tests = 1;

$populate_view_items_delphi = 1;
$populate_tests = 1;
$populate_revision_history = 0;
$populate_compliance_reference = 0;
$populate_problem_log = 0;
$populate_risk_mitigation = 0;
$populate_index = 0;
$populate_characteristics = 1;
$populate_doc = 1;
$populate_doc_items = 1;
$populate_paragraph = 1;
$populate_td_tools = 0;
$populate_pexs_requirements = 0;
$populate_revision_docs = 1;
$populate_usability = 0;
$populate_reference_items = 0;
$populate_td_tools_category = 0;
$populate_pmp_requirements = 0;
$populate_pd_items = 1;
$populate_reference_item = 0;
$populate_td_tools_items = 1;
$populate_reference_standards = 0;
$populate_item_doc = 0;
$populate_revisions_doc = 0;
$populate_translations = 1;
$populate_critical_components = 1;
$populate_rmf_risk_mitigation = 1;
$populate_subject_risk = 0;
$populate_source_risk = 0;
$populate_user_groups = 1;
$populate_references = 0;
$populate_rmf_risk_mitigations = 0;
$populate_users = 0;
$populate_products = 1;
$populate_projects = 1;
$populate_docs = 0;
$populate_rmf_characteristics = 0;
$populate_tree_view_items = 0;
$populate_delphi = 1;
$create_all = 0;//db+tables+data
$create_db = 0;
$create_all_tables = 1;
$populate_all_tables = 1;
$create_populate_all_tables = 0;


    $arrTables = array(
        array ($create_tests, "tests", "CREATE TABLE `tests` 
    (`id-test` int auto_increment primary key,
    `test_1char` char(100),
    `test_2varchar` varchar(1000),
    `test_3blob` blob,
    `tag_link_object_o` char(12),
    `tag_link_object_c` char(12),
    `link_object` char(200))
    "),
        array ($create_products, "products", "CREATE TABLE `products`
    (`id-product` int auto_increment primary key,
    product_code char(100) not null,
    product_name char(100),
    product_description varchar(500) null)
    "),
        array ($create_projects, "projects", "CREATE TABLE `projects`
    (`id-project` int auto_increment primary key,
    project_code char(100) not null,
    project_name char(100),
    project_directory char(200),
    project_description varchar(500) null,
    project_ddmf_location char(100),
    project_year char(10),
    project_td_tools_profile char(50),
    project_date_created char (15))
    "),
        array ($create_users, "users", "CREATE TABLE `users`
    (`id-user` int auto_increment primary key,
    `user_email` char(100),
    `user_name` char(100),
    `user_password` char(30))"),
        array ($create_td_tools_category, "td_tools_category", "CREATE TABLE `td_tools_category`
    (`id-td_tools_category` int auto_increment primary key,
    `category_code` char(50) not null,
    `category_description` char(200))"),
        array ($create_references, "references", "CREATE TABLE `references`
    (`id-reference` int auto_increment primary key,
    `id_reference_2` char(100))"),
        array ($create_reference_standards, "reference_standards", "CREATE TABLE `reference_standards`
    (`id-reference_standard` int auto_increment primary key,
    `id-reference_standard_2` char(100),
    `reference_standard_question` varchar(500))"),
        array ($create_user_groups, "user_groups", "CREATE TABLE `user_groups`
    (`id-user_group` int auto_increment primary key,
    product_code char(100) not null,
    product_name char(100),
    product_description varchar(500) null)"),
        array ($create_item_doc, "item_doc", "CREATE TABLE `item_doc`
    (`id-item_doc` int auto_increment primary key,
    `id-doc` int,
    `id-item` int)
    "),
        array ($create_docs, "docs", "CREATE TABLE `docs`
    (`id-doc` int auto_increment primary key,
    `name_doc` char(100),
    `frm_php` char(100),
    `id2-doc` char(100),
    `title` char(100),
    `td_tools` int null,
    `id-project` int null,
    `id-user` int)
    "),
        array ($create_tree_view_items, "tree_view_items", "CREATE TABLE `tree_view_items`
    (`id_tree_view_item` int auto_increment primary key, 
    `index_number` char(100))"),
        array ($create_reference_item, "reference_item", "CREATE TABLE `reference_item`
    (`id-reference_item` int auto_increment primary key,
    `id-reference` int,
    `question` varchar(300) not null,
    `consideration` varchar(300),
    `applicable` char(5),
    `section_hazard` char(20))"),
        array($create_index, "indexm", "CREATE TABLE `indexm`
    (`id-index` int auto_increment primary key,
    `req_name` char(50),
    `req_index` char(30))"),
        array ($create_revisions_doc, "revision_docs", "CREATE TABLE `revision_docs`
    (`id-revision_doc` int auto_increment primary key,
    `id-doc` int,
    `revision_follow_up_number` char(100),
    revision_date char(10),
    log_user int,
    description varchar(300),
    author char(30),
    media_file blob null)"),
        array ($create_translations, "translations", "CREATE TABLE `translations`
    (`id-translation` int auto_increment primary key,
    `id-project` int,
    `keyword` varchar(300),
    `translation_text` varchar(500)
    )"),
        array ($create_subject_risk, "subject_risks", "CREATE TABLE `subject_risks`
    (`id-subject_risk` int auto_increment primary key)"),
        array ($create_rmf_characteristics, "rmf_characteristics", "CREATE TABLE `rmf_characteristics`
    (`id-rmf_characteristics` int auto_increment primary key,
    `id-project` int)"),
        array ($create_source_risk, "source_risks", "CREATE TABLE `source_risks`
    (`id-source_risk` int auto_increment primary key)"),
        array ($create_critical_components, "critical_components", "CREATE TABLE `critical_components`
    (`id-critical_component` int auto_increment primary key,
    `component` varchar(300),
    `interchangeable` int,
    `manufacturer_trademark` char(100),
    `type_model_no` char(100),
    `technical_data` varchar(500),
    `standard` char(50),
    `marks_certificates_conformity` varchar(500))"),
        array ($create_reference_items, "reference_items", "CREATE TABLE `reference_items`
    (`id-reference_item` int auto_increment primary key,
    `id-reference` int,
    `question` varchar(300) not null,
    `consideration` varchar(300),
    `applicable` char(5),
    `section_hazard` char(20))"),
        array ($create_td_tools, "td_tools", "CREATE TABLE `td_tools`
    (`id-td_tool` int auto_increment primary key,
    `td_category` char(80),
    `td_source` char(80))"),
        array ($create_paragraph, "paragraphs", "CREATE TABLE `paragraphs`
    (`id-paragraph` int auto_increment primary key,
    `id1_paragraph` char(20),
    `paragraph_title` char(30))"),
        array ($create_rmf_risk_mitigation, "rmf_risk_mitigations", "CREATE TABLE `rmf_risk_mitigations`
    (`id-risk_mitigation` int auto_increment primary key,
    `id-project` int,
    `applicable` int,
    `essential_performance_cause_remark` char(100),
    `addressed_to_professional_user` char(10),
    `addressed_to_patient` char(10),
    `addressed_to_3rd_person` char(10),
    `risk_estimation_severity` char(100),
    `risk_estimation_probability` char(100),
    `risk_evaluation` char(100),
    `risk_control_option` char(100),
    `risk_control_measure_or_optional_remark` varchar(500),
    `risk_estimation_severity_after_risk_reduction` char(100),
    `risk_estimation_probability_after_risk_reduction` char(100),
    `risk_evaluation_after_risk_reduction` char(100),
    `residual_risk` char(100),
    `verified_and_validated` char(100),
    `evidence_traceability` char(100)
    )"),
        array ($create_pexs_requirements, "pexs_requirements", "CREATE TABLE `pexs_requirements`
    (`id-pexs_req` int auto_increment primary key,
    `id-project` int)"),
        array ($create_td_tools_items, "td_tools_items", "CREATE TABLE `td_tools_items`
    (`id-td_tools_item` int auto_increment primary key,
    `id-revision_doc` int)"),
        array ($create_problem_log, "problem_log", "CREATE TABLE `problem_log`
    (`id-problem_log` int auto_increment primary key)"),
        array ($create_usability, "usability", "CREATE TABLE `usability`
    (`id-usability` int auto_increment primary key)"),
        array ($create_compliance_reference, "compliance_references", "CREATE TABLE `compliance_references`
    (`id-compliance_reference` int auto_increment primary key,
    `id-2` int,
    `date_in` char(10),
    `id-project` int,
    `standard` char(100),
    `clause_text` char(100),
    `id-reference` varchar(500),
    `id-risk_mitigation` int)"),
        array ($create_pmp_requirements, "pmp_requirements", "CREATE TABLE `pmp_requirements`
    (`id-pmp_requirement` int auto_increment primary key,
    `reg_date` char(10),
    `reg_by` int,
    `id-project` char(50),
    `id2-pmp_requirement` int,
    `requirement_subject` varchar(100),
    `requirement` varchar(100),
    `pass_fail` int,
    `id-pro` int,
    `id-doc` int,
    `pmp_requirement_comment` varchar(100))"),
        array ($create_pd_items, "pd_items", "CREATE TABLE `pd_items`
    (`id-pd_items` int auto_increment primary key,
    `id-pj` int,
    `id-project` int,
    `id-pd` int)"),
        array ($create_doc, "doc", "CREATE TABLE `doc`
    (`id-doc` int auto_increment primary key,
    `id2-doc` char(100),
    `id-project` int)"),
        array ($create_doc_items, "doc_items", "CREATE TABLE `doc_items`
    (`id-doc_item` int auto_increment primary key,
    `chronnr` int,
    `id-item` int,
    `id-td_tools_category` int,
    `index_number` char(30),
    `item_title` char(50),
    `item_text` blob null,
    `item_blob` blob null)")
    );
    //TEST DATA:

    $arrPopTables = array(
        array ($populate_critical_components, "INSERT INTO critical_components(
    `component`,
    `interchangeable`,
    `manufacturer_trademark`,
    `type_model_no`,
    `technical_data`,
    `standard`,
    `marks_certificates_conformity`) VALUES
    ('Power Cord Cable as  MAINS CONNECTOR', 1, 'Well shin', 'WS-002A-R', '10A – 250 V (10A or higher)', 'EN 60320 / C13', 'VDE, KEMA, OVE, CEBEC, SEMCO, DEMCO, NEMCO')"),
        array ($populate_doc, "INSERT INTO doc(
    `id2-doc`,
    `id-project`) VALUES
    ('010-ppp-ppp-42 PMP-tdtools', 1),
    ('011-ppp-ppp-41 DDP-tdtools', 1),
    ('012-ppp-ppp-41 DDV-tdtools', 1),
    ('016-ppp-ppp-41 PMS-tdtools', 1),
    ('017-ppp-ppp-40P0 DVP-tdtools', 1),
    ('018-ppp-ppp-40P0 DVR-tdtools', 1),
    ('020-ppp-ppp-40 MDF MDR-tdtools', 1),
    ('023-ppp-ppp-40 DTP-tdtools', 1),
    ('024-ppp-ppp-40 DTV-tdtools', 1),
    ('026-ppp-ppp-41 ER-tdtools', 1),
    ('027-ppp-ppp-40 ER Add Asia-tdtools', 1),
    ('075-ppp-ppp-44 FTF-tdtools', 1),
    ('105-aaaaaaa-40 Revision History Log-tdtools', 1),
    ('190-aaaaaaa-40 Printing specification-tdtools', 1),
    ('EN109-aaaaaaa-40 BKL-tdtools', 1),
    ('EN109-aaaaaaa-40 IFU-tdtools', 1),
    ('010 PMP', 1),
    ('021 TRF', 1),
    ('025 RMF', 1),
    ('026 ER', 1),
    ('025 RMF', 3),
    ('026 ER', 3),
    ('049 FORMS', 3)"),
    array ($populate_translations, "INSERT INTO translations (`keyword`, `translation_text`)
    VALUES
    ('deviceName', ''),
    ('deviceIdentification', ''),
    ('productDescription', ''),
    ('projectNr', ''),
    ('intendedUser', '')"),
        array ($populate_item_doc, "INSERT INTO item_doc (`id-doc`, `id-item`)
    VALUES
    (1, 11),
    (1, 12),
    (1, 13),
    (1, 14),
    (1, 15),
    (1, 16),
    (1, 17),
    (1, 18),
    (1, 19),
    (1, 20),
    (1, 21),
    (17, 22),
    (17, 23),
    (17, 24),
    (17, 25),
    (17, 26),
    (17, 27),
    (17, 28),
    (17, 29),
    (17, 30),
    (17, 31),
    (17, 32),
    (17, 33),
    (5, 34),
    (5, 35),
    (5, 36),
    (5, 37),
    (5, 38),
    (5, 39),
    (5, 40),
    (5, 41),
    (5, 42),
    (5, 43),
    (5, 44)"),
        array ($populate_users, "INSERT INTO users (`user_email`, `user_name`, `user_password`)
    VALUES
    ('test001@enraf-nonius.nl', 'test001test001', 'no'),
    ('x1.@enraf-nonius.nl', 'mlo', '-'),
    ('x2@enraf-nonius.n', 'ama', '-'),
    ('x3@enraf-nonius.nl', 'lbe', '-'),
    ('x5@enraf-nonius.nl', 'llu', '-')
    "),
        array ($populate_projects, "INSERT INTO projects(project_code,
    project_name,
    project_year,
    project_date_created,
    project_directory) VALUES
    ('400-280', 'Endomed 484', '2017', '2019-10-25', 'fill in dir'),
    ('550-470', 'Endomed 888', '2003', '2019-10-26', 'fill in dir'),
    ('400-268', 'Curapuls 670', '2017', '2019-10-27', 'fill in dir'),
    ('999-999', 'TEST_EWI 999', '2019', '2019-10-28', 'fill in dir')
    "),
        array ($populate_tree_view_items, "INSERT INTO tree_view_items (`index_number`)
    VALUES
    ('1'), 
    ('1.1.'),
    ('1.1.1.'),
    ('1.1.2.'),
    ('1.1.3.'),
    ('1.2.'), 
    ('1.2.1.'), 
    ('1.2.2.'), 
    ('1.2.3.'),
    ('2'),
    ('2.1.'),
    ('2.2.'),
    ('2.2.1.'),
    ('2.2.3.'),
    ('2.2.3.1.'),
    ('2.2.3.2.'),
    ('2.2.3.3.'),
    ('2.2.3.4.'),
    ('3'),
    ('3.1'),
    ('3.2.'),
    ('4'),
    ('5'),
    ('6'),
    ('7'),
    ('8'),
    ('9'),
    ('10'),
    ('11')
    "),
        array ($populate_tests, "INSERT INTO tests(
    `test_1char`, 
    `test_2varchar`, 
    `test_3blob`, 
    `tag_link_object_o`,
    `tag_link_object_c`,
    `link_object`) VALUES
    ('picpng', '3', '4', '<a href=', '-', 'http://---------------------------------/var/www/html/media/ENRAF-NONIUS-design.png'),
    ('xlsx', '3', '4', '<a href=', '-', 'http://--------------------------------/var/www/html/media/excel.xlsx'),
    ('tekst', 'ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', '4', '< p', '-' , '--')
    "),
        array ($populate_rmf_risk_mitigations, "INSERT INTO rmf_risk_mitigations(
    `id-project`,
    `applicable`,
    `essential_performance_cause_remark`,
    `addressed_to_professional_user`,
    `addressed_to_patient`,
    `addressed_to_3rd_person`,
    `risk_estimation_severity`,
    `risk_estimation_probability`,
    `risk_evaluation`,
    `risk_control_option`,
    `risk_control_measure_or_optional_remark`,
    `risk_estimation_severity_after_risk_reduction`,
    `risk_estimation_probability_after_risk_reduction`,
    `risk_evaluation_after_risk_reduction`,
    `residual_risk`,
    `verified_and_validated`,
    `evidence_traceability`) VALUES
    (2,
    1,
    'The unit can be identified wrong which can lead to unacceptable risk.',
    'Y',
    'N',
    'Y',
    'critical',
    'occasional',
    'YN',
    'Information for safety',
    'The device shall be identified with a reference label. The packaging of the device shall be identified with a packaging label. The reference and packaging labels shall be designed according to the 60601-1.',
    'critical',
    'remote',
    'Y/N',
    'Y/N',
    'P',
    '162-1498960-xx Ref Label/')"),
        array ($populate_doc_items, "INSERT INTO doc_items (
    `chronnr`,
    `id-item`,
    `index_number`,
    `id-td_tools_category`,
    `item_title`,
    `item_text`,
    `item_blob`) VALUES
    (1, 999, 'empty', '11', 'Info', 'Blue text is for your convenience to help you use this document. Remove all blue information you no longer need', 'blob test'),
    (987, 999, 'empty', '11', 'General note', 'test', 'blob test'),
    (3, 999, 'empty', '11', 'Foreword', 'etst', 'blob test'),
    (4, 9999, '1.', '11', 'Introduction', 'test', 'blob test'),
    (5, 9999, '1.1', '11', 'Risk Management Proces', '', 'blob test'),
    (6, 999, '2', '11', 'Risk Management Plan', '', 'blob test'),
    (7, 999, '3',  '11', 'Compliance References', '', 'blob test'),
    (8, 999, '100', '11', 'Risk Management Information', 'preface', 'blob test'),
    (9, 999, '101', '11', 'Preface', 'preface', 'blob test'),
    (10, 999, '102', '11', 'Preface', 'preface', 'blob test'),
    (11, 11, '103', '1', 'General note', 'GREEN accentuated text refers to another document in the DDMF. BLUE accentuated text refers to a standard, directive or other similar document.', 'blob'),
    (12, 12, '1.', '1', 'Marketing aspects', 'Marketing aspects', ''),
    (13, 13, '1.1', '1', 'Product Motivation PM', 'The paragraphs in this section will describe why we are going develop this product. They will show where the idea for starting this project came from and it will motivate why we think it is a good idea start this development.', 'blob'),
    (14, 14, '1.1.1', '1', 'History', 'History', ''),
    (15, 15, '1.1.2', '1', 'Market Information', 'Market information', ''),
    (16, 16, '1.1.3', '1', 'Post Market Information', 'Define if any information is relevant in defining critical components, critical production processes for the product to be developed (e.g. cable quality, connector quality, process of the gueing of crystals on US treatmentheads). This information should be processed in the RMF of the product to be.', ''),
    (17, 17, '1.1.3.1', '1', 'Review of reports on quality', 'Review of reports on quality', ''),
    (18, 18, '1.1.3.2', '1', 'Input for conclusion', 'NOTE Tables are in Dutch, because they came from an automated system', ''),
    (19, 19, '1.1.3.3', '1', 'Conclusion of Analysis of Report on Quality', '2 -- Conclusion of Analysis of Report on Quality', ''),
    (20, 20, '0000', '1', 'Marketing aspects', '', 'blob test2'),
    (21, 21, '0000', '1', 'Project aspects (PA)', '', ''),
    (22, 22, '1', '17', 'Scope', 'This Software Development Verification is related to ', ''),
    (23, 23, '2', '17', 'References', 'This document refers to .', ''),
    (24, 24, '2.1.', '17', 'Digital Device Master File (DDMF)', 'Many technical documents are produced during development of a Medical Device.The coding of the documents can be found in : EN004-06 - PROCEDURE CODERING VAN DOCUMENTEN. References made in documents with in the DDMF to other documents in the DDMF are made with version xx on the end of the document number. Since these documents are always under revision in the Digital Device Master File the latest version can be found in there. ', 'blob test2'),
    (25, 25, '2.2.', '17', 'Applied Standards', 'Used standards in this document refer to the applied standard list in the Essential Requirements document 026-ppp-ppp-xx ER.', ''),
    (26, 26, '2.3.', '17', 'Digital Device Master File (DDMF)', '', 'blob test2'),
    (27, 27, '2.4.', '17', 'Digital Device Master File (DDMF)', 'On release of the set of Technical Documentation (TD) it is needed to specify a list of documents with the latest versions on that specific release date. This list is documented with form : “EN112-01-01 - Document Revisie Status ‘yyyymmdd’ ‘set’”This form is added to the Technical Documentation.', 'blob test2'),
    (28, 29, '3', '17', 'Digital Device Master File (DDMF)', '', ''),
    (29, 30, '3.1', '17', 'Project start', '', ''),
    (30, 31, '3.1.1', '17', 'PEMS Requirement capture', '', ''),
    (31,32, '3.1.2.', '17', 'PEMS Architectural design', '', ''),
    (32, 33, '3.1.3.', '17', 'PESS integration and verification', '', ''),
    (33, 34, '3.1.4.', '17', 'PEMS integration and verification', '', ''), 
    (34, 35, '1.', '5','Scopt','',''),
    (35, 36, '2.', '5','References','',''),
    (36, 37, '2.1', '5','Digital Device Master File (DDMF)','',''),
    (37, 38, '2.1', '5','test','test',''),
    (38, 39, '2.3', '5','test','test','test'),
    (39, 40, '3.', '5','test','',''),
    (40, 41, '3.1', '5','test','',''),
    (41, 42, '3.2', '5','test','',''),
    (42, 43, '3.3', '5','test','',''),
    (43, 44, '4.', '5','test','',''),
    (44, 45, '4.1', '5','test','','')
    "),
        array ($populate_products, "INSERT INTO products(`product_code`, `product_name`) VALUES
    ('Pls670', 'Pulsar670'),
    ('EDM', 'Endomed'),
    ('MOTOMED', 'Motomed'),
    ('TEST', 'ewi_test'),
    ('EDP811', 'Endopuls811')"),
        array ($populate_td_tools, "INSERT INTO td_tools(`td_category`)VALUES
    ('010-ppp-ppp-42  PMP'),
    ('011-ppp-ppp-41 DDP'),
    ('012-ppp-ppp-41 DDV'),
    ('016-ppp-ppp-41 PMS'),
    ('017-ppp-ppp-40P0 DVP'),
    ('018-ppp-ppp-40P0 DVR'),
    ('020-ppp-ppp-40 MDF MDR'),
    ('023-ppp-ppp-40 DTP'),
    ('024-ppp-ppp-40 DTV'),
    ('026-ppp-ppp-41 ER-tdtools'),
    ('027-ppp-ppp-40 ER Add Asia-tdtools'),
    ('027-ppp-ppp-40 ER Add Australia'),
    ('027-ppp-ppp-40 ER Add EIFU'),
    ('027-ppp-ppp-40 ER Add Canada'),
    ('031-ppp-ppp-42 SDP'),
    ('038-ppp-ppp-42 SDV'),
    ('041-ppp-ppp-40 UEF'),
    ('045-000-000-41 CER therapy'),
    ('047-ppp-ppp-40 BER'),
    ('073-ppp-ppp-41 BTF'),
    ('074-ppp-ppp-44 STF'),
    ('075-ppp-ppp-44 FTF'),
    ('105-aaaaaaa-40 Revision History Log'),
    ('190-aaaaaaa-40 Printing specification'),
    ('EN109-aaaaaaa-40 BKL'),
    ('EN109-aaaaaaa-40 IFU')"),
        array ($populate_td_tools_category, "INSERT INTO td_tools_category(`category_code`)VALUES
    ('010-ppp-ppp-42  PMP'),
    ('011-ppp-ppp-41 DDP'),
    ('012-ppp-ppp-41 DDV'),
    ('016-ppp-ppp-41 PMS'),
    ('017-ppp-ppp-40P0 DVP'),
    ('018-ppp-ppp-40P0 DVR'),
    ('020-ppp-ppp-40 MDF MDR'),
    ('023-ppp-ppp-40 DTP'),
    ('024-ppp-ppp-40 DTV'),
    ('024-ERR-ppp-40 DTV'),
    ('026-ppp-ppp-41 ER-tdtools'),
    ('027-ppp-ppp-40 ER Add Asia-tdtools'),
    ('027-ppp-ppp-40 ER Add Australia'),
    ('027-ppp-ppp-40 ER Add EIFU'),
    ('027-ppp-ppp-40 ER Add Canada'),
    ('031-ppp-ppp-42 SDP'),
    ('038-ppp-ppp-42 SDV'),
    ('041-ppp-ppp-40 UEF'),
    ('045-000-000-41 CER therapy'),
    ('047-ppp-ppp-40 BER'),
    ('073-ppp-ppp-41 BTF'),
    ('074-ppp-ppp-44 STF'),
    ('075-ppp-ppp-44 FTF'),
    ('105-aaaaaaa-40 Revision History Log'),
    ('190-aaaaaaa-40 Printing specification'),
    ('EN109-aaaaaaa-40 BKL'),
    ('EN109-aaaaaaa-40 IFU')"),
        array ($populate_revision_docs, "INSERT INTO revision_docs(
    `id-doc`,
    `revision_follow_up_number`,
    `revision_date`,
    `log_user`,
    `description`,
    `author`) VALUES
    (1, '010-ppp-ppp-40', '2019-02-12', '2', '2019-08-19 ewi t', 'auteur@enraf-test'),
    (1, '017-ppp-ppp-40 1', '2019-02-12', '2', '2019-08-19 ewi t', 'auteur@enraf-test'),
    (1, '017-ppp-ppp-40 2', '2019-02-12', '2', '2019-08-19 ewi t', 'auteur@enraf-test'),
    (1, '017-ppp-ppp-40 3', '2019-02-12', '2', '2019-08-19 ewi t', 'auteur@enraf-test'),
    (1, '017-ppp-ppp-40 4', '2019-02-12', '2', '2019-08-19 ewi t', 'auteur@enraf-test'),
    (17, '038-ppp-ppp-28', '2019-03-23', '3', '2019-08-19 ewi tdit is een testomschrijving', 'auteur@enraf-test'),
    (17, '038-ppp-ppp-29', '2019-02-13', '3', 'dit is een testomschrijving', 'auteur@enraf-test'),
    (1, '010-ppp-ppp-41', '2016-09-19', '1', 'First TD Tool Release', 'Employee1'),
    (1, '010-ppp-ppp-42', '2016-10-10', '1', 'Added chapter 4.9.1.1', 'Employee2'),
    (1, '010-ppp-ppp-43', '2017-06-16', '1', 'Specified P1.1.3', 'Employee2'),
    (17, '038-ppp-ppp-30', '2016-06-02', '2', 'dit is een testomschrijving', 'auteur@enraf-test'),
    (17, '038-ppp-ppp-31', '2019-07-02', '3', '2019-08-19 ewi t dit is een testomschrijving', 'auteur@enraf-test')"),
        array ($populate_docs, "INSERT INTO docs(
    `id2-doc`,
    `title`,
    `td_tools`,
    `frm_php`,
    `id-project`,
    `name_doc`,
    `id-user`)
    VALUES
    ('010-ppp-ppp-42 PMP', 'Project Master Plan', 1, 'qa_td_tools.php', null, '010-ppp-ppp-42 PMP.docx', 3),
    ('011-ppp-ppp-41 DDP', 'Device Development Plan', 1, 'qa_td_tools.php', null, '011-ppp-ppp-41 DDP.docx', 3),
    ('012-ppp-ppp-41 DDV', 'Device Development Verification', 1, 'qa_td_tools.php', null, '012-ppp-ppp-41 DDV.docx', 5),
    ('016-ppp-ppp-41 PMS', 'Post Market Surveillance', 1, 'td_tools_post_market_surveillance.php', null, '016-ppp-ppp-41 PMS.docx',3),
    ('017-ppp-ppp-40P0 DVP', 'Device Validation Plan', 1, 'qa_td_tools.php', null, '017-ppp-ppp-40P0 DVP.docx',3),
    ('018-ppp-ppp-40P0 DVR', 'Device Validation Report', 1, 'td_tools_.php.php', null, '018-ppp-ppp-40P0 DVR.docx',5),
    ('020-ppp-ppp-40 MDF MDR-tdtools', 'Medical Device File', 1, 'td_tools_.php', null, '020-ppp-ppp-40 MDF MDR-tdtools.docx',5),
    ('023-ppp-ppp-40 DTP', 'Device Test Plan', 1, 'td_tools_.php', null, '023-ppp-ppp-40 DTP.docx', 5),
    ('024-ppp-ppp-40 DTV', 'Device Test Verification', 1, 'td_tools_.php', null, '024-ppp-ppp-40 DTV.docx', 5),
    ('025-ppp-ppp-44  RMF', 'Risk Management File', 1, 'td_tools_.php', null, '025-ppp-ppp-44  RMF.docx', 5),
    ('026-ppp-ppp-41 ER', 'Essential Requirements', 1, 'td_tools_.php', null, '026-ppp-ppp-41 ER.docx', 5),
    ('027-ppp-ppp-40 ER Add Asia', 'Essential Principals, add Asia', 1, 'td_tools_.php', null, '027-ppp-ppp-40 ER Add Asia.docx', 5),
    ('027-ppp-ppp-40 ER Add Asia', 'Essential Principals, add Australia', 1, 'td_tools_.php', null, '027-ppp-ppp-40 ER Add Asia.docx', 5),
    ('027-ppp-ppp-40 ER Add Asia', 'Essential Principals, add EIFU', 1, 'td_tools_.php', null, '027-ppp-ppp-40 ER Add Asia.docx', 5),
    ('027-ppp-ppp-40 ER Add Asia', 'Essential Principals, add CANADA', 1, 'td_tools_.php', null, '027-ppp-ppp-40 ER Add Asia.docx', 5),
    ('031-ppp-ppp-42 SDP', 'Essential Principals, add CANADA', 1, 'qa_td_tools.php', null, '031-ppp-ppp-42 SDP.docx', 3),
    ('038-ppp-ppp-42 SDV', 'Software Development Verification SDV', 1, 'qa_td_tools.php', null, '038-ppp-ppp-42 SDV.docx', 3),
    ('073-ppp-ppp-40 BTS', 'Bench Test Form', 1, 'qa_td_tools.php', null, '073-ppp-ppp-40 BTS.docx', 3),
    ('074-ppp-ppp-40 STF', 'Stress Test Form', 1, 'qa_td_tools.php', null, '074-ppp-ppp-40 STF.docx', 3),
    ('075-ppp-ppp-44 FTF-tdtools', 'Field Test Form', 1, 'qa_td_tools.php', null, '075-ppp-ppp-44 FTF-tdtools.docx', 3),
    ('105-aaaaaaa-40 Revision History Log-tdtools', 'description missing', 1, 'qa_td_tools.php', null, '105-aaaaaaa-40 Revision History Log-tdtools.docx', 3),
    ('190-aaaaaaa-40 Printing specification-tdtools', 'description missing', 1, 'qa_td_tools.php', null, '190-aaaaaaa-40 Printing specification-tdtools.docx', 3),
    ('EN109-aaaaaaa-40 BKL-tdtools', 'description missing', 1, 'qa_td_tools.php', null, 'EN109-aaaaaaa-40 BKL-tdtools.docx', 3),
    ('EN109-aaaaaaa-40 IFU-tdtools', 'description missing', 1, 'qa_td_tools.php', null, 'EN109-aaaaaaa-40 IFU-tdtools.docx', 3),
    ('024-ppp-ppp-40 DTV', 'description missing', 1, 'qa_td_tools.php', null, '024-ppp-ppp-40 DTV.docx', 5),
    ('010 PMP', '', null, '', 1, '1.docx', 5),
    ('021 TRF', '', null, '', 1, '2.docx', 5),
    ('025 RMF', '', null, '', 1, '3.docx', 5),
    ('026 ER', '', null, '', 1, '4.docx', 5),
    ('042 FORMS', '', null, '', 1, '5.docx', 5),
    ('015 PMP', '', null, '', 2, '6.docx', 5),
    ('020 TRF', '', null, '', 2, '7.docx', 5),
    ('022 RMF', '', null, '', 2, '8.docx', 5),
    ('024 ER',  '',null, '', 2, '9.docx', 5),
    ('047 FORMS', '', null, '', 2, '10.docx', 5),
    ('019 PMP', '', null, '', 3, '11.docx', 5),
    ('024 TRF', '', null, '', 3, '12.docx', 5),
    ('025-ppp-ppp-44  RMF', '', null, '', 3, '13.docx', 5),
    ('026 ER', '', null, '', 3, '14.docx', 5),
    ('049 FORMS', '', null, '', 3, '15.docx', 5)
    "),
        array ($populate_pmp_requirements, "INSERT INTO pmp_requirements (
    `id-project`, `reg_date`, `reg_by`, `id2-pmp_requirement`, `requirement_subject`, `requirement`, `pass_fail`, `pmp_requirement_comment`) VALUES
    (1, '2019-08-08', 3, '001', 'User Interface', 'The device is operated using a touch screen', '0', 'test no notes'),
    (1, '2019-08-08', 3, '002', 'Standard accessories (commercial term)', 'These articles will be shipped with the device', '0', 'test no notes'),
    (1, '2019-08-08', 3, '003', 'Standard accessories (commercial term)', '3444290 Mains cable 230V-EUR', '0', 'test no notes'),
    (1, '2019-08-08', 3, '004', 'Standard accessories (commercial term)', '3444211 Patient cable 2-core & 2 mm male plugs - black, with colour clips', '0', 'test no notes')
    "),
        array ($populate_compliance_reference, "INSERT INTO compliance_references (
    `id-2`,
    `date_in`,
    `id-project`,
    `standard`,
    `clause_text`,
    `id-reference`,
    `id-risk_mitigation`) VALUES
    (1, '2018-11-05', 3, 'test standard text', 'test clause txt', 2, 1),
    (2, '2018-11-05', 3, '14971', '3.1 Risk management process', '025-400-268-43 RMF Chapter 2.7.1 Risk Analysis Process', 1),
    (3, '2018-11-05', 3, '14971', '3.1 Risk management process', '025-400-268-43 RMF Chapter 2.7.6 Risk Evaluation', 1),
    (4, '2018-11-05', 2, '14971', '3.1 Risk management process', '025-400-268-43 RMF Chapter 2.7.8 Risk control option analysis', 1),
    (5, '2018-11-05', 2, '14971', '3.2 Management responsibilities', '025-400-268-43 RMF Chapter 2.9 Production and post-production information', 1),
    (6, '2018-11-05', 1, '14971', '3.2 Management responsibilities', '025-400-268-43 RMF Chapter 1.3 ==Title of paragraph', 1),
    (7, '2018-11-05', 1, '60601-1', '4.2.1 a) Introduction to RISK MANAGEMENT', '<DocNr>-<Project-number>-XX P2.7 <Title of 2.7>', 1),
    (8, '2018-11-05', 3, '60601-1', '4.2.1 a) Introduction to RISK MANAGEMENT', '025-<project-number>-XX P3.2.1.1', 3)
                    "),
        array ($populate_reference_standards, "INSERT INTO reference_standards (
                    `id-reference_standard_2`,
                    `reference_standard_question`) VALUES
                    ('14971 C.2.1', 'What is the intended use/intended purpose and how is the medical device to be used?'),
                    ('14971 C2.1.1', 'What role is the medical device intended to play in:'),
                    ('[tryREF: 14971-P4.2]', 'test'),
                    ('REF: 14971', 'test'),
                    ('REF: 14971-Annex C', 'test'),
                    ('[REF: 14971-P4.3]', 'test'),
                    ('testREF: 62366 Annex E', 'test')
                    "),
        array ($populate_reference_items, "INSERT INTO reference_items (
                    `id-reference`,
                    `question`,
                    `consideration`,
                    `applicable`,
                    `section_hazard`) VALUES
                    (1, 'header=yes', 'Factors to consider for intended user:', 'test', 'test'),
                    (1, 'header=no', 'Mental ability', 'Y', 'S 4.5.2 & S 4.5.3'),
                    (1, 'header=no', 'Physical abilities', 'test', 'test'),
                    (1, 'header=no', 'Skill and Training', 'Y', 'S 4.5.1'),
                    (1, 'test question', 'test consideration', 'testY', 'test section hazard')
                    "),
        array ($populate_paragraph, "INSERT INTO paragraphs (
                    `id1_paragraph`,
                    `paragraph_title`) VALUES
                    ('0', 'Preface'),
                    ('1', 'Eerste Hoofdstuk'),
                    ('1.1.', 'en de eerste paragraph'),
                    ('2', 'tweede hoofdstuk'),
                    ('2.1.', 'enz.enz.'),
                    ('2.2.', 'enz.enz.'),
                    ('2.2.2', 'enz.enz.'),
                    ('2.2.3.', 'enz.enz.')
                    ")
    );

                    echo '<hr /><h4>View tables, sql stms:</h4>';
                    foreach($arrTables as $x => $x_value) {        //echo "<br /> Tabel naam: " . $arrTables[$x][0] . " <br />SQL statement: " . $arrTables[$x][1];
                        if (($arrTables[$x][0]==1) || ($create_all_tables == 1)){            //echo '<br /> ===>97create table: ' . $arrTables[$x][1];
                            fnc_create_table(($arrTables[$x][1]), ($arrTables[$x][2]));
                        }
                    }
                    foreach($arrPopTables as $y => $y_value){
                        if (($arrPopTables[$y][0]==1) ||$populate_all_tables == 1){
                            fnc_populate_table($arrPopTables[$y][1]);
                        }
                    }
                    function fnc_populate_table($sql){
                        global $un, $pw, $dsn;
                        try {
                            $conn = new PDO('mysql:' . $dsn, $un, $pw);
                            $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                            $conn->exec($sql);
                        }catch(PDOException $e)
                        {
                            echo "<br />Connection failed: " . $e->getMessage();
                        }
                    }
                    function fnc_create_table($create_table, $sql){
                        global $un, $pw, $dsn;
                        try {
                            $conn = new PDO('mysql:' . $dsn, $un, $pw);
                            $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                            tableExists($conn, $create_table);
                            $conn->exec($sql);
                        }catch(PDOException $e)
                        {
                            echo "<br />Connection failed: " . $e->getMessage();
                        }
                    }
                    function tableExists(PDO $pdo, $tableName) {
                        $mrSql = "SHOW TABLES LIKE :table_name";
                        $mrStmt = $pdo->prepare($mrSql);
                        $mrStmt->bindParam(":table_name", $tableName, PDO::PARAM_STR);
                        $sqlResult = $mrStmt->execute();
                        if ($sqlResult) {
                            $row = $mrStmt->fetch(PDO::FETCH_NUM);
                            if ($row[0]) {
                                $sql_drop = "DROP TABLE ". $tableName;
                                $stm_drop = $pdo->prepare($sql_drop);
                                $sql_result_drop = $stm_drop->execute();
                                return $sql_result_drop;
                            } else {
                                return false;
                            }
                        } else {
                            echo("err: ".var_export($pdo->errorInfo(), true));
                            return false;
                        }
                    }
                    $conn = null;