/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : memodise

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2024-07-24 08:45:00
*/


-- ----------------------------
-- Table structure for mt_account
-- ----------------------------
CREATE TABLE `mt_account` (
  `mf_acc_id` int(11) NOT NULL DEFAULT 0,
  `mf_db_id` int(11) NOT NULL DEFAULT 0,
  `mf_role_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`mf_acc_id`,`mf_db_id`,`mf_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_account
-- ----------------------------

-- ----------------------------
-- Table structure for mt_account_role
-- ----------------------------
CREATE TABLE `mt_account_role` (
  `acc_id` int(11) DEFAULT NULL,
  `memorial_id` int(11) DEFAULT NULL,
  `active` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Table structure for mt_album
-- ----------------------------
CREATE TABLE `mt_album` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_album_title` varchar(255) DEFAULT NULL,
  `mf_desc` varchar(255) DEFAULT NULL,
  `mf_location` varchar(255) DEFAULT NULL,
  `mf_create_by` int(255) DEFAULT NULL,
  `mf_create_date` date DEFAULT NULL,
  `mf_create_time` time DEFAULT NULL,
  `memorial_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_album
-- ----------------------------
INSERT INTO `mt_album` VALUES ('1', 'Stan Lee Cameo', 'His cameo in the superhero movies', '', '2', '2023-07-06', '16:29:33', '2');

-- ----------------------------
-- Table structure for mt_bg_image
-- ----------------------------
CREATE TABLE `mt_bg_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bg_image` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `img_order` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_bg_image
-- ----------------------------
INSERT INTO `mt_bg_image` VALUES ('1', 'oldwoman.jpg', '1', '1');
INSERT INTO `mt_bg_image` VALUES ('2', 'stevejob.jpg', '1', '2');
INSERT INTO `mt_bg_image` VALUES ('3', 'oldwoman.jpg', '2', '');
INSERT INTO `mt_bg_image` VALUES ('4', 'stevejob.jpg', '2', '');

-- ----------------------------
-- Table structure for mt_card_type
-- ----------------------------
CREATE TABLE `mt_card_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `card_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_card_type
-- ----------------------------

-- ----------------------------
-- Table structure for mt_cemetary
-- ----------------------------
CREATE TABLE `mt_cemetary` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_maplink` varchar(255) DEFAULT NULL,
  `mf_img1` varchar(255) DEFAULT NULL,
  `mf_img2` varchar(255) DEFAULT NULL,
  `mf_img3` varchar(255) DEFAULT NULL,
  `mf_date` date DEFAULT NULL,
  `mf_time` time DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_cemetary
-- ----------------------------

-- ----------------------------
-- Table structure for mt_cemetary_image
-- ----------------------------
CREATE TABLE `mt_cemetary_image` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `image_name` varchar(255) DEFAULT NULL,
  `image_size` varchar(255) DEFAULT NULL,
  `image_type` varchar(255) DEFAULT NULL,
  `memorial_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_cemetary_image
-- ----------------------------
INSERT INTO `mt_cemetary_image` VALUES ('1', '0Screenshot (10).png', '1149053', 'image/png', '5');
INSERT INTO `mt_cemetary_image` VALUES ('2', '0Screenshot (10).png', '1149053', 'image/png', '5');
INSERT INTO `mt_cemetary_image` VALUES ('3', '0Screenshot (2).png', '1486608', 'image/png', '11');
INSERT INTO `mt_cemetary_image` VALUES ('4', '0Screenshot (2).png', '1486608', 'image/png', '11');
INSERT INTO `mt_cemetary_image` VALUES ('5', '0Screenshot (2).png', '1486608', 'image/png', '11');
INSERT INTO `mt_cemetary_image` VALUES ('6', '0Screenshot (2).png', '1486608', 'image/png', '11');
INSERT INTO `mt_cemetary_image` VALUES ('7', '1Screenshot (3).png', '881406', 'image/png', '11');
INSERT INTO `mt_cemetary_image` VALUES ('8', '2Screenshot (4).png', '767038', 'image/png', '11');
INSERT INTO `mt_cemetary_image` VALUES ('9', '0Screenshot (10).png', '1149053', 'image/png', '10');
INSERT INTO `mt_cemetary_image` VALUES ('10', '1Screenshot (11).png', '948795', 'image/png', '10');
INSERT INTO `mt_cemetary_image` VALUES ('11', '2Screenshot (12).png', '509096', 'image/png', '10');
INSERT INTO `mt_cemetary_image` VALUES ('21', '011115602_912459438797625_7641669635096384455_n.jpg', '20082', 'image/jpeg', '20');
INSERT INTO `mt_cemetary_image` VALUES ('22', '111167812_912459422130960_3244468772747535386_n.jpg', '20909', 'image/jpeg', '20');
INSERT INTO `mt_cemetary_image` VALUES ('23', '2x720.jpg', '233556', 'image/jpeg', '20');
INSERT INTO `mt_cemetary_image` VALUES ('24', '049a5c698-031f-497e-b250-cc6014a2d54c.jpg', '105498', 'image/jpeg', '27');
INSERT INTO `mt_cemetary_image` VALUES ('25', '12023-09-11.jpg', '110345', 'image/jpeg', '27');
INSERT INTO `mt_cemetary_image` VALUES ('26', '2IMG20230812103250.jpg', '112532', 'image/jpeg', '27');

-- ----------------------------
-- Table structure for mt_ewallet
-- ----------------------------
CREATE TABLE `mt_ewallet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ewallet_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_ewallet
-- ----------------------------

-- ----------------------------
-- Table structure for mt_feature
-- ----------------------------
CREATE TABLE `mt_feature` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `feature_plan` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `picture_max_uploads` varchar(255) DEFAULT NULL,
  `video_max_uploads` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_feature
-- ----------------------------
INSERT INTO `mt_feature` VALUES ('1', 'free', '1', '5', '3');
INSERT INTO `mt_feature` VALUES ('2', 'annual', '2', 'unlimited', 'unlimited');
INSERT INTO `mt_feature` VALUES ('3', 'lifetime', '3', 'unlimited', 'unlimited');

-- ----------------------------
-- Table structure for mt_feedback
-- ----------------------------
CREATE TABLE `mt_feedback` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `memorial_name` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `type_inquiry` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_feedback
-- ----------------------------

-- ----------------------------
-- Table structure for mt_file
-- ----------------------------
CREATE TABLE `mt_file` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_path` varchar(255) DEFAULT NULL,
  `mf_size` double DEFAULT NULL,
  `mf_description` varchar(255) DEFAULT NULL,
  `mf_name` varchar(255) DEFAULT NULL,
  `mf_file_type_id` int(11) DEFAULT NULL,
  `mf_album_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_file
-- ----------------------------

-- ----------------------------
-- Table structure for mt_file_type
-- ----------------------------
CREATE TABLE `mt_file_type` (
  `mf_id` int(11) NOT NULL,
  `mf_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_file_type
-- ----------------------------

-- ----------------------------
-- Table structure for mt_image
-- ----------------------------
CREATE TABLE `mt_image` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `image_name` varchar(255) DEFAULT NULL,
  `image_size` varchar(255) DEFAULT NULL,
  `image_type` varchar(255) DEFAULT NULL,
  `image_desc` varchar(255) DEFAULT NULL,
  `create_by` int(255) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `create_time` time DEFAULT NULL,
  `album` varchar(255) DEFAULT NULL,
  `album_name` varchar(255) DEFAULT NULL,
  `image_tmp` varchar(255) DEFAULT NULL,
  `background_img` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `memorial_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_image
-- ----------------------------
INSERT INTO `mt_image` VALUES ('25', '0Screenshot (2).png', '1486608', 'image/png', null, '3', '2024-04-01', '15:01:06', '', null, null, null, '3', '5');
INSERT INTO `mt_image` VALUES ('26', '0Screenshot (12).png', '509096', 'image/png', null, '3', '2024-04-01', '15:16:06', '', null, null, null, '3', '5');
INSERT INTO `mt_image` VALUES ('28', '0Screenshot (12).png', '509096', 'image/png', '', '3', '2024-04-01', '15:23:58', null, null, null, null, '1', '5');

-- ----------------------------
-- Table structure for mt_incident
-- ----------------------------
CREATE TABLE `mt_incident` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `victim` text DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `no_victim` varchar(255) DEFAULT NULL,
  `reference_link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_incident
-- ----------------------------

-- ----------------------------
-- Table structure for mt_incident_comment
-- ----------------------------
CREATE TABLE `mt_incident_comment` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `incident_id` int(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_incident_comment
-- ----------------------------

-- ----------------------------
-- Table structure for mt_incident_pic
-- ----------------------------
CREATE TABLE `mt_incident_pic` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `incident_id` int(11) DEFAULT NULL,
  `picture` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_incident_pic
-- ----------------------------

-- ----------------------------
-- Table structure for mt_incident_submission
-- ----------------------------
CREATE TABLE `mt_incident_submission` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `date_of_incident` date DEFAULT NULL,
  `casualty` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `reference_website` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_incident_submission
-- ----------------------------
INSERT INTO `mt_incident_submission` VALUES ('1', 'Car Accident', '2024-04-15', '1 death, 2 injuries', 'Highway XYZ', 'https://example.com/news/article1');
INSERT INTO `mt_incident_submission` VALUES ('2', 'Fire Incident', '2024-04-14', 'No casualties reported', '123 Main Street', 'https://example.com/news/article2');
INSERT INTO `mt_incident_submission` VALUES ('3', 'Robbery', '2024-04-13', 'No casualties reported', '456 Elm Street', 'https://example.com/news/article3');

-- ----------------------------
-- Table structure for mt_incident_sub_pic
-- ----------------------------
CREATE TABLE `mt_incident_sub_pic` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `incident_pic` varchar(255) DEFAULT NULL,
  `incident_sub_id` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_incident_sub_pic
-- ----------------------------
INSERT INTO `mt_incident_sub_pic` VALUES ('1', 'incident1_picture1.jpg', '1');
INSERT INTO `mt_incident_sub_pic` VALUES ('2', 'incident1_picture1.jpg', '2');
INSERT INTO `mt_incident_sub_pic` VALUES ('3', 'incident1_picture2.jpg', '3');
INSERT INTO `mt_incident_sub_pic` VALUES ('4', 'incident2_picture1.jpg', '4');

-- ----------------------------
-- Table structure for mt_likes
-- ----------------------------
CREATE TABLE `mt_likes` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_acc_id` int(11) DEFAULT NULL,
  `mf_ip` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_likes
-- ----------------------------

-- ----------------------------
-- Table structure for mt_love_giving
-- ----------------------------
CREATE TABLE `mt_love_giving` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `account_name` varchar(255) DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_number` varchar(255) DEFAULT NULL,
  `bank_branch` varchar(255) DEFAULT NULL,
  `branch_code` varchar(255) DEFAULT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `create_time` time DEFAULT NULL,
  `memorial_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_love_giving
-- ----------------------------

-- ----------------------------
-- Table structure for mt_members
-- ----------------------------
CREATE TABLE `mt_members` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_type_id` int(11) DEFAULT NULL,
  `mf_fullname` varchar(255) DEFAULT NULL,
  `mf_image` varchar(255) DEFAULT NULL,
  `mf_relationship_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_members
-- ----------------------------

-- ----------------------------
-- Table structure for mt_member_relationship
-- ----------------------------
CREATE TABLE `mt_member_relationship` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_description` varchar(255) DEFAULT NULL,
  `mf_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_member_relationship
-- ----------------------------

-- ----------------------------
-- Table structure for mt_member_type
-- ----------------------------
CREATE TABLE `mt_member_type` (
  `mf_id` int(11) NOT NULL,
  `mf_description` varchar(255) DEFAULT NULL,
  `mf_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_member_type
-- ----------------------------

-- ----------------------------
-- Table structure for mt_memorial
-- ----------------------------
CREATE TABLE `mt_memorial` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `code_no` varchar(255) DEFAULT NULL,
  `url_name` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `memorial_name` varchar(255) DEFAULT NULL,
  `register_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_memorial_dtl
-- ----------------------------

-- ----------------------------
-- Table structure for mt_music
-- ----------------------------
CREATE TABLE `mt_music` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `music_name` varchar(255) DEFAULT NULL,
  `memorial_id` int(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_music
-- ----------------------------

-- ----------------------------
-- Table structure for mt_obituary
-- ----------------------------
CREATE TABLE `mt_obituary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_id` int(11) DEFAULT NULL,
  `code_no` varchar(255) DEFAULT '',
  `md_content` text DEFAULT NULL,
  `mf_img` varchar(255) DEFAULT NULL,
  `mf_fullname` varchar(255) DEFAULT NULL,
  `mf_born` varchar(255) DEFAULT '',
  `mf_pass_date` varchar(255) DEFAULT '',
  `mf_born_location` varchar(255) DEFAULT NULL,
  `mf_pass_location` varchar(255) DEFAULT NULL,
  `mf_quote` varchar(255) DEFAULT NULL,
  `mf_wake_dtl_til` varchar(255) DEFAULT NULL,
  `mf_wake_dtl_add` varchar(255) DEFAULT NULL,
  `mf_cortehe_on` varchar(255) DEFAULT NULL,
  `mf_location_funeral` varchar(255) DEFAULT NULL,
  `mf_further_dtl` varchar(255) DEFAULT '',
  `mf_further_dtl2` varchar(255) DEFAULT '',
  `mf_theme` varchar(255) DEFAULT NULL,
  `create_by` varchar(255) NOT NULL,
  `create_date` date DEFAULT NULL,
  `create_time` time DEFAULT NULL,
  `memorial_id` int(255) DEFAULT NULL,
  `pdf_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_obituary
-- ----------------------------
INSERT INTO `mt_obituary` VALUES ('1', '13', '365010581205', 'ds', '22540141_1904917789529229_5251812242222007701_n.jpg', 'Nik Abdul Aziz Nik Mat', '1931-01-10 00:00', '2015-02-12 00:00', 'Kampung Pulau Melaka, Kota Bharu', 'Kampung Pulau Melaka, Kota Bharu', '', '', '', '2024-06-19 12:00', '548 Jalan Long Sulaiman, 16150 Kota Bharu, Kelantan, Malaysia', '', '', 'd1', '13', '2024-06-24', '11:14:02', '20', 'Obituary - Nik Abdul Aziz Nik Mat (24062024111404).pdf');

-- ----------------------------
-- Table structure for mt_outside_system
-- ----------------------------
CREATE TABLE `mt_outside_system` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_outside_system
-- ----------------------------

-- ----------------------------
-- Table structure for mt_payment_method
-- ----------------------------
CREATE TABLE `mt_payment_method` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_method` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_payment_method
-- ----------------------------

-- ----------------------------
-- Table structure for mt_premium
-- ----------------------------
CREATE TABLE `mt_premium` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_premium
-- ----------------------------

-- ----------------------------
-- Table structure for mt_profession
-- ----------------------------
CREATE TABLE `mt_profession` (
  `job_id` int(11) NOT NULL AUTO_INCREMENT,
  `profession` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_profession
-- ----------------------------
INSERT INTO `mt_profession` VALUES ('1', 'Teacher');
INSERT INTO `mt_profession` VALUES ('2', 'Accountant');
INSERT INTO `mt_profession` VALUES ('3', 'Engineer');
INSERT INTO `mt_profession` VALUES ('4', 'Technician');
INSERT INTO `mt_profession` VALUES ('5', 'Physician');
INSERT INTO `mt_profession` VALUES ('6', 'Veterinarian');
INSERT INTO `mt_profession` VALUES ('7', 'Lawyer');
INSERT INTO `mt_profession` VALUES ('8', 'Surveyor');
INSERT INTO `mt_profession` VALUES ('9', 'Psychologist');
INSERT INTO `mt_profession` VALUES ('10', 'Pharmacist');
INSERT INTO `mt_profession` VALUES ('11', 'Dietitian');
INSERT INTO `mt_profession` VALUES ('12', 'Designer');
INSERT INTO `mt_profession` VALUES ('13', 'Midwife');
INSERT INTO `mt_profession` VALUES ('14', 'Scientist');
INSERT INTO `mt_profession` VALUES ('15', 'Software Developer');
INSERT INTO `mt_profession` VALUES ('16', 'Physiotherapist');
INSERT INTO `mt_profession` VALUES ('17', 'Architect');
INSERT INTO `mt_profession` VALUES ('18', 'Actuary');
INSERT INTO `mt_profession` VALUES ('19', 'Librarian');
INSERT INTO `mt_profession` VALUES ('20', 'Dentist');
INSERT INTO `mt_profession` VALUES ('21', 'Consultant');
INSERT INTO `mt_profession` VALUES ('22', 'Health Professional');
INSERT INTO `mt_profession` VALUES ('23', 'Secretary');
INSERT INTO `mt_profession` VALUES ('24', 'Surgeon');
INSERT INTO `mt_profession` VALUES ('25', 'Mechanic');
INSERT INTO `mt_profession` VALUES ('26', 'Medical Laboratory Scientist');
INSERT INTO `mt_profession` VALUES ('27', 'Statistician');
INSERT INTO `mt_profession` VALUES ('28', 'Electrician');
INSERT INTO `mt_profession` VALUES ('29', 'Judge');
INSERT INTO `mt_profession` VALUES ('30', 'Artist');
INSERT INTO `mt_profession` VALUES ('31', 'Hairdresser');
INSERT INTO `mt_profession` VALUES ('32', 'Broker');
INSERT INTO `mt_profession` VALUES ('33', 'Radiographer');
INSERT INTO `mt_profession` VALUES ('34', 'Police Officer');
INSERT INTO `mt_profession` VALUES ('35', 'Butcher');
INSERT INTO `mt_profession` VALUES ('36', 'Labourer');
INSERT INTO `mt_profession` VALUES ('37', 'Dental Hygienist');
INSERT INTO `mt_profession` VALUES ('38', 'Chef');
INSERT INTO `mt_profession` VALUES ('39', 'Firefighter');
INSERT INTO `mt_profession` VALUES ('40', 'Actor');
INSERT INTO `mt_profession` VALUES ('41', 'Plumber');
INSERT INTO `mt_profession` VALUES ('42', 'Optician');
INSERT INTO `mt_profession` VALUES ('43', 'Journalist');
INSERT INTO `mt_profession` VALUES ('44', 'Aviator');
INSERT INTO `mt_profession` VALUES ('45', 'Technologist');
INSERT INTO `mt_profession` VALUES ('46', 'Musician');
INSERT INTO `mt_profession` VALUES ('47', 'Cleaner');
INSERT INTO `mt_profession` VALUES ('48', 'Tailor');
INSERT INTO `mt_profession` VALUES ('49', 'Tradesman');
INSERT INTO `mt_profession` VALUES ('50', 'Politician');
INSERT INTO `mt_profession` VALUES ('51', 'No Profession');
INSERT INTO `mt_profession` VALUES ('52', 'Scholar');
INSERT INTO `mt_profession` VALUES ('53', 'Sultan');

-- ----------------------------
-- Table structure for mt_profile
-- ----------------------------
CREATE TABLE `mt_profile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acc_id` int(11) DEFAULT NULL,
  `code_no` varchar(255) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `career` varchar(255) DEFAULT NULL,
  `born` varchar(255) DEFAULT '',
  `pass_date` varchar(255) DEFAULT '',
  `pass_location` varchar(255) DEFAULT NULL,
  `profile_pic` varchar(255) DEFAULT NULL,
  `cause_death` varchar(255) DEFAULT NULL,
  `place_birth` varchar(255) DEFAULT NULL,
  `last_modified_date` datetime DEFAULT NULL,
  `quote` varchar(255) DEFAULT '',
  `expression` varchar(255) DEFAULT NULL,
  `music` varchar(255) DEFAULT NULL,
  `theme` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `postal_code` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `lat` varchar(255) DEFAULT NULL,
  `lon` varchar(255) DEFAULT NULL,
  `privacy` varchar(255) DEFAULT NULL,
  `file_name_quote` varchar(255) DEFAULT '',
  `file_name_expression` varchar(255) DEFAULT '',
  `memorial_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_profile
-- ----------------------------

-- ----------------------------
-- Table structure for mt_public_prayer
-- ----------------------------
CREATE TABLE `mt_public_prayer` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `message` text DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_public_prayer
-- ----------------------------

-- ----------------------------
-- Table structure for mt_receipt
-- ----------------------------
CREATE TABLE `mt_receipt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_no` int(11) DEFAULT NULL,
  `payment_date` datetime DEFAULT NULL,
  `member_no` int(11) DEFAULT NULL,
  `invoice_no` int(11) DEFAULT NULL,
  `total_amount` varchar(255) DEFAULT NULL,
  `payment_method_id` int(11) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `actual_date` datetime DEFAULT NULL,
  `card_type_id` int(11) DEFAULT NULL,
  `ewallet_type_id` int(11) DEFAULT NULL,
  `total_amount_round` varchar(255) DEFAULT NULL,
  `rounding_change` varchar(255) DEFAULT NULL,
  `payment_received` varchar(255) DEFAULT NULL,
  `cash_change` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_receipt
-- ----------------------------

-- ----------------------------
-- Table structure for mt_role
-- ----------------------------
CREATE TABLE `mt_role` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_name` varchar(255) DEFAULT NULL,
  `mf_description` varchar(255) DEFAULT NULL,
  `mf_edit` tinyint(1) DEFAULT NULL,
  `mf_view` tinyint(1) DEFAULT NULL,
  `mf_delete` tinyint(1) DEFAULT NULL,
  `mf_add` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_role
-- ----------------------------

-- ----------------------------
-- Table structure for mt_subscription
-- ----------------------------
CREATE TABLE `mt_subscription` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `feature_plan_id` varchar(255) DEFAULT '',
  `upload_count` varchar(255) DEFAULT '',
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_subscription
-- ----------------------------
INSERT INTO `mt_subscription` VALUES ('1', '13', '1', null, '0000-00-00 00:00:00', null);

-- ----------------------------
-- Table structure for mt_suggestion
-- ----------------------------
CREATE TABLE `mt_suggestion` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `suggestion` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_suggestion
-- ----------------------------

-- ----------------------------
-- Table structure for mt_template
-- ----------------------------
CREATE TABLE `mt_template` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_path` varchar(255) DEFAULT NULL,
  `mf_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_template
-- ----------------------------

-- ----------------------------
-- Table structure for mt_testimonial
-- ----------------------------
CREATE TABLE `mt_testimonial` (
  `mf_id` int(255) NOT NULL AUTO_INCREMENT,
  `mf_description` text DEFAULT NULL,
  `mf_creator_id` int(255) DEFAULT NULL,
  `mf_date` datetime DEFAULT NULL,
  `mf_link` varchar(255) DEFAULT NULL,
  `mf_icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_testimonial
-- ----------------------------
INSERT INTO `mt_testimonial` VALUES ('1', 'This website is so great', '13', '2024-05-07 15:34:20', null, '1');
INSERT INTO `mt_testimonial` VALUES ('2', 'This website has help me to appreciate my grandfather more.', '13', '2024-05-07 11:34:48', null, '7');
INSERT INTO `mt_testimonial` VALUES ('3', 'This website has a lot of potential. Ganbate', '13', '2024-05-07 15:35:15', null, '1');
INSERT INTO `mt_testimonial` VALUES ('4', 'This website can add a bit more feature in order to make it flawless. always aim to improve good luck.', '13', '2024-05-07 15:35:52', null, '1');
INSERT INTO `mt_testimonial` VALUES ('5', 'Great website not gonna lie', '13', '2024-05-16 09:06:27', null, '6');

-- ----------------------------
-- Table structure for mt_testimonial_like
-- ----------------------------
CREATE TABLE `mt_testimonial_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `testimonial_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `like` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_testimonial_like
-- ----------------------------
INSERT INTO `mt_testimonial_like` VALUES ('1', '1', '13', '1');
INSERT INTO `mt_testimonial_like` VALUES ('2', '2', '13', '1');
INSERT INTO `mt_testimonial_like` VALUES ('3', '3', '13', '0');
INSERT INTO `mt_testimonial_like` VALUES ('4', '4', '13', '0');
INSERT INTO `mt_testimonial_like` VALUES ('5', '5', '13', '0');

-- ----------------------------
-- Table structure for mt_theme
-- ----------------------------
CREATE TABLE `mt_theme` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_path` varchar(255) DEFAULT NULL,
  `mf_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_theme
-- ----------------------------

-- ----------------------------
-- Table structure for mt_tribute
-- ----------------------------
CREATE TABLE `mt_tribute` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `mf_description` varchar(1000) DEFAULT NULL,
  `mf_icon` varchar(255) DEFAULT NULL,
  `mf_creator` varchar(255) DEFAULT NULL,
  `mf_date` date DEFAULT NULL,
  `mf_time` time DEFAULT NULL,
  `memorial_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_tribute
-- ----------------------------
INSERT INTO `mt_tribute` VALUES ('1', 'rest in peace', '4', 'raymond', '2023-07-06', '10:23:09', '2');
INSERT INTO `mt_tribute` VALUES ('2', 'Rest in peace Coco', '1', 'Sya', '2023-07-11', '10:42:15', '3');
INSERT INTO `mt_tribute` VALUES ('3', 'Coco, God will be with you in heaven. R.I.P', '4', 'Ray', '2023-11-17', '10:01:02', '3');
INSERT INTO `mt_tribute` VALUES ('4', 'get welll soon', '7', 'syed', '2024-04-02', '10:07:20', '5');
INSERT INTO `mt_tribute` VALUES ('5', 'sdfsdfsf', '1', 'dd', '2024-04-02', '10:07:30', '5');
INSERT INTO `mt_tribute` VALUES ('6', 'U are a great person No one can replace u.', '7', 'Syed', '2024-04-08', '12:05:46', '10');
INSERT INTO `mt_tribute` VALUES ('7', 'Okay your death will always be remembered', '1', 'Arif', '2024-04-08', '12:06:36', '10');
INSERT INTO `mt_tribute` VALUES ('8', 'You are a great person.', '6', 'Azri', '2024-04-08', '12:06:56', '10');
INSERT INTO `mt_tribute` VALUES ('9', 'The peace be with you', '7', 'Syed', '2024-05-03', '15:41:17', '20');
INSERT INTO `mt_tribute` VALUES ('10', 'Innalillahi wa innailayhi rajiun\r\n', '6', 'Syed Arif', '2024-05-06', '09:48:34', '20');
INSERT INTO `mt_tribute` VALUES ('11', 'Semoga arwah ditempatkan bersama-sama orang yang beriman', '7', 'Azri', '2024-05-06', '11:07:56', '20');
INSERT INTO `mt_tribute` VALUES ('12', 'Takziah', '1', 'Arif', '2024-05-06', '14:38:05', '20');
INSERT INTO `mt_tribute` VALUES ('13', 'Semoga dicucuri rahmat', '1', 'Fira', '2024-05-06', '14:38:32', '20');

-- ----------------------------
-- Table structure for mt_victim
-- ----------------------------
CREATE TABLE `mt_victim` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `victim_name` varchar(255) DEFAULT NULL,
  `incident_id` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_victim
-- ----------------------------

-- ----------------------------
-- Table structure for mt_video
-- ----------------------------
CREATE TABLE `mt_video` (
  `id` int(25) NOT NULL AUTO_INCREMENT,
  `video_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `video_title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `video_type` varchar(255) DEFAULT NULL,
  `memorial_id` varchar(255) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `status` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_video
-- ----------------------------

-- ----------------------------
-- Table structure for mt_visits
-- ----------------------------
CREATE TABLE `mt_visits` (
  `mf_id` int(11) NOT NULL AUTO_INCREMENT,
  `mf_acc_id` int(11) DEFAULT NULL,
  `mf_ip` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`mf_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of mt_visits
-- ----------------------------
