1084 lines
48 KiB
SQL
1084 lines
48 KiB
SQL
CREATE TABLE IF NOT EXISTS `#__ehealthportal_payment` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`nonpay_reason` INT(11) NOT NULL DEFAULT 0,
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`payment_amount` VARCHAR(100) NOT NULL DEFAULT '',
|
|
`payment_category` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`payment_type` INT(11) NOT NULL DEFAULT 0,
|
|
`receipt_no` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_general_medical_check_up` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`bmi` FLOAT(7) NULL DEFAULT 0,
|
|
`bp_diastolic_one` INT(7) NOT NULL DEFAULT 0,
|
|
`bp_diastolic_two` INT(7) NOT NULL DEFAULT 0,
|
|
`bp_systolic_one` INT(7) NOT NULL DEFAULT 0,
|
|
`bp_systolic_two` INT(7) NOT NULL DEFAULT 0,
|
|
`chronic_medication` TEXT NOT NULL,
|
|
`complaint` MEDIUMTEXT NOT NULL,
|
|
`diagnosis` INT(11) NOT NULL DEFAULT 0,
|
|
`dispensing` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`height` FLOAT(7) NOT NULL DEFAULT 0,
|
|
`investigations` MEDIUMTEXT NOT NULL,
|
|
`notes` MEDIUMTEXT NOT NULL,
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`pulse` INT(7) NOT NULL DEFAULT 0,
|
|
`reason` MEDIUMTEXT NOT NULL,
|
|
`referral` INT(11) NOT NULL DEFAULT 0,
|
|
`temp_one` FLOAT(7) NOT NULL DEFAULT 0,
|
|
`temp_two` FLOAT(7) NOT NULL DEFAULT 0,
|
|
`weight` FLOAT(7) NOT NULL DEFAULT 0,
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_antenatal_care` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`caesarean_sections` INT(7) NOT NULL DEFAULT 0,
|
|
`foetal_engagement` INT(11) NOT NULL DEFAULT 0,
|
|
`foetal_heart_rate` INT(7) NOT NULL DEFAULT 0,
|
|
`foetal_lie` INT(11) NOT NULL DEFAULT 0,
|
|
`foetal_movements` MEDIUMTEXT NOT NULL,
|
|
`foetal_presentation` INT(11) NOT NULL DEFAULT 0,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`last_menstrual_period` DATE NOT NULL DEFAULT '0000-00-00',
|
|
`live_births` INT(7) NOT NULL DEFAULT 0,
|
|
`miscarriages` INT(7) NOT NULL DEFAULT 0,
|
|
`normal_births` INT(7) NOT NULL DEFAULT 0,
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`pregnancies_excl` INT(7) NOT NULL DEFAULT 0,
|
|
`still_births` INT(7) NOT NULL DEFAULT 0,
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_immunisation` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`immunisation` TEXT NOT NULL,
|
|
`immunisation_up_to_date` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`reason` MEDIUMTEXT NOT NULL,
|
|
`referral` INT(11) NOT NULL DEFAULT 0,
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_vmmc` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`are_you_circumcised` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`info_ben_vmcc` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`interested_in_vmmc` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`partner_circumcised` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`reason` MEDIUMTEXT NOT NULL,
|
|
`referral` INT(11) NOT NULL DEFAULT 0,
|
|
`vmmc_gender` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_prostate_and_testicular_cancer` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`ptc_age` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`ptc_diet` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`ptc_fam_history` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`ptc_overweight` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`ptc_phy_activity` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`ptc_urinate` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`ptc_urine_freq` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`reason` MEDIUMTEXT NOT NULL,
|
|
`referral` INT(11) NOT NULL DEFAULT 0,
|
|
`txt_ptc_age` MEDIUMTEXT NOT NULL,
|
|
`txt_ptc_diet` MEDIUMTEXT NOT NULL,
|
|
`txt_ptc_fam_history` MEDIUMTEXT NOT NULL,
|
|
`txt_ptc_overweight` MEDIUMTEXT NOT NULL,
|
|
`txt_ptc_phy_activity` MEDIUMTEXT NOT NULL,
|
|
`txt_ptc_urinate` MEDIUMTEXT NOT NULL,
|
|
`txt_ptc_urine_freq` MEDIUMTEXT NOT NULL,
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_tuberculosis` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`blood_streaked_sputum` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`date_of_treatment` DATE NOT NULL DEFAULT '0000-00-00',
|
|
`diagnosed_with_disease` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`pain_in_chest` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`persistent_cough` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`reason` MEDIUMTEXT NOT NULL,
|
|
`recurring_night_sweats` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`referral` INT(11) NOT NULL DEFAULT 0,
|
|
`referred_second_sputum` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`shortness_of_breath` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`sputum_collection_one` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`sputum_result_one` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`sputum_result_two` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`tb_exposed` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`tb_fever` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`tb_reason_one` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`tb_reason_two` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`tb_treatment` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`treating_dhc` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`unusual_tiredness` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`weight_loss_wdieting` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_hiv_counseling_and_testing` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`counseling_type` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`eqa` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`final_test_result` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`last_test_date` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`prev_test_result` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`reason` MEDIUMTEXT NOT NULL,
|
|
`referral` INT(11) NOT NULL DEFAULT 0,
|
|
`test_result_one` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`test_result_two` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`testing_reason` INT(11) NOT NULL DEFAULT 0,
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_family_planning` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`diagnosis` INT(11) NOT NULL DEFAULT 0,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_diagnosis` (`diagnosis`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_health_education` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`education_type` VARCHAR(100) NOT NULL DEFAULT '',
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`health_education_topic` INT(11) NOT NULL DEFAULT 0,
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_cervical_cancer` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`cc_periods` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`cc_reason` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`cc_result` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`cc_sex_actve` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`cc_sex_partner` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`cc_smoking` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`cc_v_discharge` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`cc_viginal_bleeding` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`pap_smear_collection` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`reason` MEDIUMTEXT NOT NULL,
|
|
`referral` INT(11) NOT NULL DEFAULT 0,
|
|
`txt_cc_periods` MEDIUMTEXT NOT NULL,
|
|
`txt_cc_sex_actve` MEDIUMTEXT NOT NULL,
|
|
`txt_cc_sex_partner` MEDIUMTEXT NOT NULL,
|
|
`txt_cc_smoking` MEDIUMTEXT NOT NULL,
|
|
`txt_cc_v_discharge` MEDIUMTEXT NOT NULL,
|
|
`txt_cc_viginal_bleeding` MEDIUMTEXT NOT NULL,
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_breast_cancer` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`bc_abnormal_skin` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_age_range` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_breast_shape` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_breastfeeding` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_dimpling` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_family_history` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_history_hrt` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_inward_nipple` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_lump_near_breast` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_nipple_discharge` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_overweight` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_preg_age` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_preg_freq` INT(7) NOT NULL DEFAULT 0,
|
|
`bc_race` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`bc_reg_exercise` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`reason` MEDIUMTEXT NOT NULL,
|
|
`referral` INT(11) NOT NULL DEFAULT 0,
|
|
`txt_bc_abnormal_skin` MEDIUMTEXT NOT NULL,
|
|
`txt_bc_breast_shape` MEDIUMTEXT NOT NULL,
|
|
`txt_bc_dimpling` MEDIUMTEXT NOT NULL,
|
|
`txt_bc_inward_nipple` MEDIUMTEXT NOT NULL,
|
|
`txt_bc_lump_near_breast` MEDIUMTEXT NOT NULL,
|
|
`txt_bc_nipple_discharge` MEDIUMTEXT NOT NULL,
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_test` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`cholesterol_reading` INT(7) NOT NULL DEFAULT 0,
|
|
`glucose_first_reading` INT(7) NOT NULL DEFAULT 0,
|
|
`glucose_second_reading` INT(7) NOT NULL DEFAULT 0,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`haemoglobin_reading` INT(7) NOT NULL DEFAULT 0,
|
|
`hepatitis_first_reading` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`hepatitis_second_reading` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`malaria_first_reading` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`malaria_second_reading` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`patient` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`pregnancy_first_reading` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`pregnancy_second_reading` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`reason` MEDIUMTEXT NOT NULL,
|
|
`referral` INT(11) NOT NULL DEFAULT 0,
|
|
`syphilis_first_reading` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`syphilis_second_reading` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`urine_test_result` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_patient` (`patient`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_foetal_lie` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_immunisation_vaccine_type` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`administration_part` INT(11) NOT NULL DEFAULT 0,
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_foetal_engagement` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_foetal_presentation` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_testing_reason` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_counseling_type` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_health_education_topic` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_immunisation_type` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_strength` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_referral` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_planning_type` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_diagnosis_type` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_nonpay_reason` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_medication` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_payment_type` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_administration_part` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_site` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`site_name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`site_region` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_site_name` (`site_name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_unit` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_name` (`name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_clinic` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
|
|
`alias` CHAR(64) NOT NULL DEFAULT '',
|
|
`clinic_name` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`clinic_type` VARCHAR(255) NOT NULL DEFAULT '',
|
|
`description` TEXT NOT NULL,
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`params` text NULL,
|
|
`published` TINYINT(3) NOT NULL DEFAULT 1,
|
|
`created_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`modified_by` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`checked_out` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`version` INT(10) unsigned NOT NULL DEFAULT 1,
|
|
`hits` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`access` INT(10) unsigned NOT NULL DEFAULT 0,
|
|
`ordering` INT(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_clinic_name` (`clinic_name`),
|
|
KEY `idx_guid` (`guid`),
|
|
KEY `idx_alias` (`alias`),
|
|
KEY `idx_access` (`access`),
|
|
KEY `idx_checkout` (`checked_out`),
|
|
KEY `idx_createdby` (`created_by`),
|
|
KEY `idx_modifiedby` (`modified_by`),
|
|
KEY `idx_state` (`published`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
CREATE TABLE IF NOT EXISTS `#__ehealthportal_user_map` (
|
|
`guid` VARCHAR(36) NOT NULL DEFAULT '',
|
|
`user` int(11) NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`guid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
|
|
|
|
|