/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : linxclaims_company_4

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

Date: 2024-04-24 15:48:11
*/


-- ----------------------------
-- Table structure for approval_report
-- ----------------------------
CREATE TABLE `approval_report` (
  `approval_id` int(15) NOT NULL AUTO_INCREMENT,
  `approval1_id` int(15) NOT NULL,
  `approval2_id` int(15) NOT NULL,
  `approval3_id` int(15) NOT NULL,
  `user_id` int(15) DEFAULT NULL,
  `report_reff` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `approved_amount` varchar(255) NOT NULL,
  PRIMARY KEY (`approval_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of approval_report
-- ----------------------------

-- ----------------------------
-- Table structure for approve_by
-- ----------------------------
CREATE TABLE `approve_by` (
  `approver_id` int(15) NOT NULL AUTO_INCREMENT,
  `user_id` int(15) NOT NULL,
  `approval_1` int(15) NOT NULL,
  `approval_2` int(15) NOT NULL,
  `approval_3` int(15) NOT NULL,
  `approver_type` varchar(255) NOT NULL,
  PRIMARY KEY (`approver_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of approve_by
-- ----------------------------
INSERT INTO `approve_by` VALUES ('1', '1', '0', '0', '0', 'EITHER');
INSERT INTO `approve_by` VALUES ('2', '2', '0', '2', '0', 'BOTH');
INSERT INTO `approve_by` VALUES ('4', '5', '2', '0', '0', 'EITHER');
INSERT INTO `approve_by` VALUES ('7', '5', '2', '0', '0', 'EITHER');
INSERT INTO `approve_by` VALUES ('16', '5', '2', '0', '0', 'LEVEL');
INSERT INTO `approve_by` VALUES ('26', '15', '2', '0', '0', 'BOTH');
INSERT INTO `approve_by` VALUES ('30', '19', '2', '0', '0', 'BOTH');
INSERT INTO `approve_by` VALUES ('31', '20', '2', '0', '0', 'BOTH');
INSERT INTO `approve_by` VALUES ('32', '21', '2', '0', '0', 'BOTH');

-- ----------------------------
-- Table structure for category
-- ----------------------------
CREATE TABLE `category` (
  `CategoryId` int(5) NOT NULL AUTO_INCREMENT,
  `CategoryName` varchar(255) NOT NULL,
  `account_code` varchar(255) NOT NULL,
  PRIMARY KEY (`CategoryId`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', 'Travelling and Accommodation', '');
INSERT INTO `category` VALUES ('2', 'Business Entertainment', '');
INSERT INTO `category` VALUES ('3', 'Insurance', '');
INSERT INTO `category` VALUES ('4', 'Telephone, Fax and Internet', '');
INSERT INTO `category` VALUES ('5', 'Medical', '');
INSERT INTO `category` VALUES ('6', 'Meal Allowance', '');
INSERT INTO `category` VALUES ('8', 'Rental', '');
INSERT INTO `category` VALUES ('9', 'Staff Welfare', '');
INSERT INTO `category` VALUES ('10', 'Office Sundries', '');
INSERT INTO `category` VALUES ('11', 'Motor Vehicle Expenses (Road Tax, Repair & Maintenance, Fuel)', '');
INSERT INTO `category` VALUES ('12', 'Parking, Toll and Mileage', '');
INSERT INTO `category` VALUES ('13', 'Printing and Stationeries', '');
INSERT INTO `category` VALUES ('14', 'Donations & Gifts', '');
INSERT INTO `category` VALUES ('15', 'Professional Membership Subscription', '');
INSERT INTO `category` VALUES ('16', 'Postage & Courier', '');
INSERT INTO `category` VALUES ('17', 'Club Subscription', '');
INSERT INTO `category` VALUES ('18', 'ICT Subscription', '');
INSERT INTO `category` VALUES ('19', 'Astro Subscription', '');
INSERT INTO `category` VALUES ('20', 'Rates and Assessment', '');
INSERT INTO `category` VALUES ('21', 'Cleaning and Housekeeping For Office/Staff House', '');
INSERT INTO `category` VALUES ('22', 'License Fees', '');
INSERT INTO `category` VALUES ('23', 'Seminar and Training Fees', '');
INSERT INTO `category` VALUES ('24', 'Utilities', '');
INSERT INTO `category` VALUES ('25', 'Advertisement and Promotion', '');
INSERT INTO `category` VALUES ('26', 'Filing and Searching Fees', '');
INSERT INTO `category` VALUES ('27', 'Newspaper and Magazine', '');
INSERT INTO `category` VALUES ('28', 'Small Asset', '');
INSERT INTO `category` VALUES ('31', 'Other', '');

-- ----------------------------
-- Table structure for categorycount
-- ----------------------------
CREATE TABLE `categorycount` (
  `category_count_id` int(15) NOT NULL AUTO_INCREMENT,
  `CategoryId` int(15) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `categoryno` varchar(255) NOT NULL,
  `UserId` int(15) DEFAULT NULL,
  PRIMARY KEY (`category_count_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of categorycount
-- ----------------------------
INSERT INTO `categorycount` VALUES ('1', '12', '350.00', 'CATEGORY-012018-00002', null);
INSERT INTO `categorycount` VALUES ('2', '18', '66.67', 'CATEGORY-012018-00003', null);
INSERT INTO `categorycount` VALUES ('3', '10', '250.15', 'CATEGORY-012018-00004', null);
INSERT INTO `categorycount` VALUES ('15', '25', '18500', 'CATEGORY-032024-00016', '2');
INSERT INTO `categorycount` VALUES ('16', '25', '16500', 'CATEGORY-032024-00017', '2');
INSERT INTO `categorycount` VALUES ('17', '25', '10000', 'CATEGORY-032024-00018', '2');
INSERT INTO `categorycount` VALUES ('18', '22', '20.00', 'CATEGORY-032024-00019', '2');
INSERT INTO `categorycount` VALUES ('19', '6', '224.08', 'CATEGORY-032024-00020', '2');
INSERT INTO `categorycount` VALUES ('20', '13', '67.00', 'CATEGORY-032024-00021', '2');
INSERT INTO `categorycount` VALUES ('21', '31', '276.00', 'CATEGORY-032024-00022', '2');
INSERT INTO `categorycount` VALUES ('22', '31', '1496.68', 'CATEGORY-032024-00023', '2');
INSERT INTO `categorycount` VALUES ('23', '11', '122.80', 'CATEGORY-032024-00024', '2');
INSERT INTO `categorycount` VALUES ('24', '11', '106.97', 'CATEGORY-032024-00025', '2');
INSERT INTO `categorycount` VALUES ('25', '13', '4.50', 'CATEGORY-032024-00026', '2');
INSERT INTO `categorycount` VALUES ('26', '31', '47.40', 'CATEGORY-032024-00027', '2');
INSERT INTO `categorycount` VALUES ('27', '22', '37.50', 'CATEGORY-032024-00028', '2');
INSERT INTO `categorycount` VALUES ('28', '31', '974.00', 'CATEGORY-032024-00029', '2');
INSERT INTO `categorycount` VALUES ('29', '31', '110.80', 'CATEGORY-032024-00030', '2');
INSERT INTO `categorycount` VALUES ('30', '31', '61.19', 'CATEGORY-032024-00031', '2');
INSERT INTO `categorycount` VALUES ('31', '31', '208.00', 'CATEGORY-032024-00032', '2');
INSERT INTO `categorycount` VALUES ('32', '11', '110.13', 'CATEGORY-032024-00033', '2');
INSERT INTO `categorycount` VALUES ('33', '11', '73.01', 'CATEGORY-032024-00034', '2');
INSERT INTO `categorycount` VALUES ('34', '31', '270.00', 'CATEGORY-032024-00035', '2');
INSERT INTO `categorycount` VALUES ('35', '5', '402.00', 'CATEGORY-032024-00036', '2');
INSERT INTO `categorycount` VALUES ('36', '31', '120.00', 'CATEGORY-032024-00037', '2');
INSERT INTO `categorycount` VALUES ('37', '4', '119.00', 'CATEGORY-032024-00038', '2');
INSERT INTO `categorycount` VALUES ('38', '4', '40.00', 'CATEGORY-032024-00039', '2');
INSERT INTO `categorycount` VALUES ('39', '31', '209.55', 'CATEGORY-032024-00040', '2');
INSERT INTO `categorycount` VALUES ('40', '31', '9.20', 'CATEGORY-032024-00041', '2');
INSERT INTO `categorycount` VALUES ('41', '25', '19.50', 'CATEGORY-032024-00042', '2');
INSERT INTO `categorycount` VALUES ('42', '25', '124.00', 'CATEGORY-032024-00043', '2');
INSERT INTO `categorycount` VALUES ('43', '31', '46.05', 'CATEGORY-032024-00044', '2');
INSERT INTO `categorycount` VALUES ('44', '31', '30.94', 'CATEGORY-032024-00045', '2');
INSERT INTO `categorycount` VALUES ('45', '31', '20.06', 'CATEGORY-032024-00046', '2');
INSERT INTO `categorycount` VALUES ('46', '31', '30.45', 'CATEGORY-032024-00047', '2');
INSERT INTO `categorycount` VALUES ('47', '31', '33.30', 'CATEGORY-032024-00048', '2');
INSERT INTO `categorycount` VALUES ('48', '25', '0', 'CATEGORY-032024-00049', '2');
INSERT INTO `categorycount` VALUES ('49', '25', '0', 'CATEGORY-032024-00050', '2');

-- ----------------------------
-- Table structure for company_setting
-- ----------------------------
CREATE TABLE `company_setting` (
  `company_id` int(15) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) NOT NULL,
  `registration_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `zip_code` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `phone_no` varchar(255) NOT NULL,
  `bill_image` blob NOT NULL,
  `bill_image_type` varchar(255) NOT NULL,
  `bank_detail` varchar(255) NOT NULL,
  `project_code` varchar(255) NOT NULL,
  `Currency` varchar(255) NOT NULL,
  PRIMARY KEY (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of company_setting
-- ----------------------------
INSERT INTO `company_setting` VALUES ('1', 'Softworld Software Sdn Bhd', '', 'fj.reena96@gmail.com', 'JALAN SONG THIAN CHEOK', 'KUCHING', 'SARAWAK', '93100', 'MALAYSIA', '082507070', '', '../include/upload/companylogo/757293.jpg', '', '', 'MYR');

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

-- ----------------------------
-- Records of currency
-- ----------------------------
INSERT INTO `currency` VALUES ('1', 'United Arab Emirates dirham', 'AED');
INSERT INTO `currency` VALUES ('2', 'Afghani', 'AFN');
INSERT INTO `currency` VALUES ('3', 'Lek', 'ALL');
INSERT INTO `currency` VALUES ('4', 'Armenian Dram', 'AMD');
INSERT INTO `currency` VALUES ('5', 'Netherlands Antillian Guilder', 'ANG');
INSERT INTO `currency` VALUES ('6', 'Kwanza', 'AOA');
INSERT INTO `currency` VALUES ('7', 'Argentine Peso', 'ARS');
INSERT INTO `currency` VALUES ('8', 'Australian Dollar', 'AUD');
INSERT INTO `currency` VALUES ('9', 'Aruban Guilder', 'AWG');
INSERT INTO `currency` VALUES ('10', 'Azerbaijanian Manat', 'AZN');
INSERT INTO `currency` VALUES ('11', 'Convertible Marks', 'BAM');
INSERT INTO `currency` VALUES ('12', 'Barbados Dollar', 'BBD');
INSERT INTO `currency` VALUES ('13', 'Bangladeshi Taka', 'BDT');
INSERT INTO `currency` VALUES ('14', 'Bulgarian Lev', 'BGN');
INSERT INTO `currency` VALUES ('15', 'Bahraini Dinar', 'BHD');
INSERT INTO `currency` VALUES ('16', 'Burundian Franc', 'BIF');
INSERT INTO `currency` VALUES ('17', 'Bermudian Dollar (customarily known as Bermuda Dollar)', 'BMD');
INSERT INTO `currency` VALUES ('18', 'Brunei Dollar', 'BND');
INSERT INTO `currency` VALUES ('19', 'Boliviano', 'BOB');
INSERT INTO `currency` VALUES ('20', 'Bolivian Mvdol (Funds code)', 'BOV');
INSERT INTO `currency` VALUES ('21', 'Brazilian Real', 'BRL');
INSERT INTO `currency` VALUES ('22', 'Bahamian Dollar', 'BSD');
INSERT INTO `currency` VALUES ('23', 'Ngultrum', 'BTN');
INSERT INTO `currency` VALUES ('24', 'Pula', 'BWP');
INSERT INTO `currency` VALUES ('25', 'Belarussian Ruble', 'BYR');
INSERT INTO `currency` VALUES ('26', 'Belize Dollar', 'BZD');
INSERT INTO `currency` VALUES ('27', 'Canadian Dollar', 'CAD');
INSERT INTO `currency` VALUES ('28', 'Franc Congolais', 'CDF');
INSERT INTO `currency` VALUES ('29', 'WIR Euro (complementary currency)', 'CHE');
INSERT INTO `currency` VALUES ('30', 'Swiss Franc', 'CHF');
INSERT INTO `currency` VALUES ('31', 'WIR Franc (complementary currency)', 'CHW');
INSERT INTO `currency` VALUES ('32', 'Unidades de formento (Funds code)', 'CLF');
INSERT INTO `currency` VALUES ('33', 'Chilean Peso', 'CLP');
INSERT INTO `currency` VALUES ('34', 'Yuan Renminbi', 'CNY');
INSERT INTO `currency` VALUES ('35', 'Colombian Peso', 'COP');
INSERT INTO `currency` VALUES ('36', 'Unidad de Valor Real', 'COU');
INSERT INTO `currency` VALUES ('37', 'Costa Rican Colon', 'CRC');
INSERT INTO `currency` VALUES ('38', 'Cuban Peso', 'CUP');
INSERT INTO `currency` VALUES ('39', 'Cape Verde Escudo', 'CVE');
INSERT INTO `currency` VALUES ('40', 'Cyprus Pound', 'CYP');
INSERT INTO `currency` VALUES ('41', 'Czech Koruna', 'CZK');
INSERT INTO `currency` VALUES ('42', 'Djibouti Franc', 'DJF');
INSERT INTO `currency` VALUES ('43', 'Danish Krone', 'DKK');
INSERT INTO `currency` VALUES ('44', 'Dominican Peso', 'DOP');
INSERT INTO `currency` VALUES ('45', 'Algerian Dinar', 'DZD');
INSERT INTO `currency` VALUES ('46', 'Kroon', 'EEK');
INSERT INTO `currency` VALUES ('47', 'Egyptian Pound', 'EGP');
INSERT INTO `currency` VALUES ('48', 'Nakfa', 'ERN');
INSERT INTO `currency` VALUES ('49', 'Ethiopian Birr', 'ETB');
INSERT INTO `currency` VALUES ('50', 'Euro', 'EUR');
INSERT INTO `currency` VALUES ('51', 'Fiji Dollar', 'FJD');
INSERT INTO `currency` VALUES ('52', 'Falkland Islands Pound', 'FKP');
INSERT INTO `currency` VALUES ('53', 'Pound Sterling', 'GBP');
INSERT INTO `currency` VALUES ('54', 'Lari', 'GEL');
INSERT INTO `currency` VALUES ('55', 'Cedi', 'GHS');
INSERT INTO `currency` VALUES ('56', 'Gibraltar pound', 'GIP');
INSERT INTO `currency` VALUES ('57', 'Dalasi', 'GMD');
INSERT INTO `currency` VALUES ('58', 'Guinea Franc', 'GNF');
INSERT INTO `currency` VALUES ('59', 'Quetzal', 'GTQ');
INSERT INTO `currency` VALUES ('60', 'Guyana Dollar', 'GYD');
INSERT INTO `currency` VALUES ('61', 'Hong Kong Dollar', 'HKD');
INSERT INTO `currency` VALUES ('62', 'Lempira', 'HNL');
INSERT INTO `currency` VALUES ('63', 'Croatian Kuna', 'HRK');
INSERT INTO `currency` VALUES ('64', 'Haiti Gourde', 'HTG');
INSERT INTO `currency` VALUES ('65', 'Forint', 'HUF');
INSERT INTO `currency` VALUES ('66', 'Rupiah', 'IDR');
INSERT INTO `currency` VALUES ('67', 'New Israeli Shekel', 'ILS');
INSERT INTO `currency` VALUES ('68', 'Indian Rupee', 'INR');
INSERT INTO `currency` VALUES ('69', 'Iraqi Dinar', 'IQD');
INSERT INTO `currency` VALUES ('70', 'Iranian Rial', 'IRR');
INSERT INTO `currency` VALUES ('71', 'Iceland Krona', 'ISK');
INSERT INTO `currency` VALUES ('72', 'Jamaican Dollar', 'JMD');
INSERT INTO `currency` VALUES ('73', 'Jordanian Dinar', 'JOD');
INSERT INTO `currency` VALUES ('74', 'Japanese yen', 'JPY');
INSERT INTO `currency` VALUES ('75', 'Kenyan Shilling', 'KES');
INSERT INTO `currency` VALUES ('76', 'Som', 'KGS');
INSERT INTO `currency` VALUES ('77', 'Riel', 'KHR');
INSERT INTO `currency` VALUES ('78', 'Comoro Franc', 'KMF');
INSERT INTO `currency` VALUES ('79', 'North Korean Won', 'KPW');
INSERT INTO `currency` VALUES ('80', 'South Korean Won', 'KRW');
INSERT INTO `currency` VALUES ('81', 'Kuwaiti Dinar', 'KWD');
INSERT INTO `currency` VALUES ('82', 'Cayman Islands Dollar', 'KYD');
INSERT INTO `currency` VALUES ('83', 'Tenge', 'KZT');
INSERT INTO `currency` VALUES ('84', 'Kip', 'LAK');
INSERT INTO `currency` VALUES ('85', 'Lebanese Pound', 'LBP');
INSERT INTO `currency` VALUES ('86', 'Sri Lanka Rupee', 'LKR');
INSERT INTO `currency` VALUES ('87', 'Liberian Dollar', 'LRD');
INSERT INTO `currency` VALUES ('88', 'Loti', 'LSL');
INSERT INTO `currency` VALUES ('89', 'Lithuanian Litas', 'LTL');
INSERT INTO `currency` VALUES ('90', 'Latvian Lats', 'LVL');
INSERT INTO `currency` VALUES ('91', 'Libyan Dinar', 'LYD');
INSERT INTO `currency` VALUES ('92', 'Moroccan Dirham', 'MAD');
INSERT INTO `currency` VALUES ('93', 'Moldovan Leu', 'MDL');
INSERT INTO `currency` VALUES ('94', 'Malagasy Ariary', 'MGA');
INSERT INTO `currency` VALUES ('95', 'Denar', 'MKD');
INSERT INTO `currency` VALUES ('96', 'Kyat', 'MMK');
INSERT INTO `currency` VALUES ('97', 'Tugrik', 'MNT');
INSERT INTO `currency` VALUES ('98', 'Pataca', 'MOP');
INSERT INTO `currency` VALUES ('99', 'Ouguiya', 'MRO');
INSERT INTO `currency` VALUES ('100', 'Maltese Lira', 'MTL');
INSERT INTO `currency` VALUES ('101', 'Mauritius Rupee', 'MUR');
INSERT INTO `currency` VALUES ('102', 'Rufiyaa', 'MVR');
INSERT INTO `currency` VALUES ('103', 'Kwacha', 'MWK');
INSERT INTO `currency` VALUES ('104', 'Mexican Peso', 'MXN');
INSERT INTO `currency` VALUES ('105', 'Mexican Unidad de Inversion (UDI) (Funds code)', 'MXV');
INSERT INTO `currency` VALUES ('106', 'Malaysian Ringgit', 'MYR');
INSERT INTO `currency` VALUES ('107', 'Metical', 'MZN');
INSERT INTO `currency` VALUES ('108', 'Namibian Dollar', 'NAD');
INSERT INTO `currency` VALUES ('109', 'Naira', 'NGN');
INSERT INTO `currency` VALUES ('110', 'Cordoba Oro', 'NIO');
INSERT INTO `currency` VALUES ('111', 'Norwegian Krone', 'NOK');
INSERT INTO `currency` VALUES ('112', 'Nepalese Rupee', 'NPR');
INSERT INTO `currency` VALUES ('113', 'New Zealand Dollar', 'NZD');
INSERT INTO `currency` VALUES ('114', 'Rial Omani', 'OMR');
INSERT INTO `currency` VALUES ('115', 'Balboa', 'PAB');
INSERT INTO `currency` VALUES ('116', 'Nuevo Sol', 'PEN');
INSERT INTO `currency` VALUES ('117', 'Kina', 'PGK');
INSERT INTO `currency` VALUES ('118', 'Philippine Peso', 'PHP');
INSERT INTO `currency` VALUES ('119', 'Pakistan Rupee', 'PKR');
INSERT INTO `currency` VALUES ('120', 'Zloty', 'PLN');
INSERT INTO `currency` VALUES ('121', 'Guarani', 'PYG');
INSERT INTO `currency` VALUES ('122', 'Qatari Rial', 'QAR');
INSERT INTO `currency` VALUES ('123', 'Romanian New Leu', 'RON');
INSERT INTO `currency` VALUES ('124', 'Serbian Dinar', 'RSD');
INSERT INTO `currency` VALUES ('125', 'Russian Ruble', 'RUB');
INSERT INTO `currency` VALUES ('126', 'Rwanda Franc', 'RWF');
INSERT INTO `currency` VALUES ('127', 'Saudi Riyal', 'SAR');
INSERT INTO `currency` VALUES ('128', 'Solomon Islands Dollar', 'SBD');
INSERT INTO `currency` VALUES ('129', 'Seychelles Rupee', 'SCR');
INSERT INTO `currency` VALUES ('130', 'Sudanese Pound', 'SDG');
INSERT INTO `currency` VALUES ('131', 'Swedish Krona', 'SEK');
INSERT INTO `currency` VALUES ('132', 'Singapore Dollar', 'SGD');
INSERT INTO `currency` VALUES ('133', 'Saint Helena Pound', 'SHP');
INSERT INTO `currency` VALUES ('134', 'Slovak Koruna', 'SKK');
INSERT INTO `currency` VALUES ('135', 'Leone', 'SLL');
INSERT INTO `currency` VALUES ('136', 'Somali Shilling', 'SOS');
INSERT INTO `currency` VALUES ('137', 'Surinam Dollar', 'SRD');
INSERT INTO `currency` VALUES ('138', 'Dobra', 'STD');
INSERT INTO `currency` VALUES ('139', 'Syrian Pound', 'SYP');
INSERT INTO `currency` VALUES ('140', 'Lilangeni', 'SZL');
INSERT INTO `currency` VALUES ('141', 'Baht', 'THB');
INSERT INTO `currency` VALUES ('142', 'Somoni', 'TJS');
INSERT INTO `currency` VALUES ('143', 'Manat', 'TMM');
INSERT INTO `currency` VALUES ('144', 'Tunisian Dinar', 'TND');
INSERT INTO `currency` VALUES ('145', 'New Turkish Lira', 'TRY');
INSERT INTO `currency` VALUES ('146', 'Trinidad and Tobago Dollar', 'TTD');
INSERT INTO `currency` VALUES ('147', 'New Taiwan Dollar', 'TWD');
INSERT INTO `currency` VALUES ('148', 'Tanzanian Shilling', 'TZS');
INSERT INTO `currency` VALUES ('149', 'Hryvnia', 'UAH');
INSERT INTO `currency` VALUES ('150', 'Uganda Shilling', 'UGX');
INSERT INTO `currency` VALUES ('151', 'US Dollar', 'USD');
INSERT INTO `currency` VALUES ('152', 'Peso Uruguayo', 'UYU');
INSERT INTO `currency` VALUES ('153', 'Uzbekistan Som', 'UZS');
INSERT INTO `currency` VALUES ('154', 'Venezuelan bolívar', 'VEB');
INSERT INTO `currency` VALUES ('155', 'Vietnamese đồng', 'VND');
INSERT INTO `currency` VALUES ('156', 'Vatu', 'VUV');
INSERT INTO `currency` VALUES ('157', 'Samoan Tala', 'WST');
INSERT INTO `currency` VALUES ('158', 'CFA Franc BEAC', 'XAF');
INSERT INTO `currency` VALUES ('159', 'Silver (one Troy ounce)', 'XAG');
INSERT INTO `currency` VALUES ('160', 'Gold (one Troy ounce)', 'XAU');
INSERT INTO `currency` VALUES ('161', 'European Composite Unit (EURCO) (Bonds market unit)', 'XBA');
INSERT INTO `currency` VALUES ('162', 'European Monetary Unit (E.M.U.-6) (Bonds market unit)', 'XBB');
INSERT INTO `currency` VALUES ('163', 'European Unit of Account 9 (E.U.A.-9) (Bonds market unit)', 'XBC');
INSERT INTO `currency` VALUES ('164', 'European Unit of Account 17 (E.U.A.-17) (Bonds market unit)', 'XBD');
INSERT INTO `currency` VALUES ('165', 'East Caribbean Dollar', 'XCD');
INSERT INTO `currency` VALUES ('166', 'Special Drawing Rights', 'XDR');
INSERT INTO `currency` VALUES ('167', 'Gold franc (special settlement currency)', 'XFO');
INSERT INTO `currency` VALUES ('168', 'UIC franc (special settlement currency)', 'XFU');
INSERT INTO `currency` VALUES ('169', 'CFA Franc BCEAO', 'XOF');
INSERT INTO `currency` VALUES ('170', 'Palladium (one Troy ounce)', 'XPD');
INSERT INTO `currency` VALUES ('171', 'CFP franc', 'XPF');
INSERT INTO `currency` VALUES ('172', 'Platinum (one Troy ounce)', 'XPT');
INSERT INTO `currency` VALUES ('173', 'Code reserved for testing purposes', 'XTS');
INSERT INTO `currency` VALUES ('174', 'No currency', 'XXX');
INSERT INTO `currency` VALUES ('175', 'Yemeni Rial', 'YER');
INSERT INTO `currency` VALUES ('176', 'South African Rand', 'ZAR');
INSERT INTO `currency` VALUES ('177', 'Kwacha', 'ZMK');
INSERT INTO `currency` VALUES ('178', 'Zimbabwe Dollar', 'ZWD');

-- ----------------------------
-- Table structure for distance_term
-- ----------------------------
CREATE TABLE `distance_term` (
  `distanceId` int(5) NOT NULL AUTO_INCREMENT,
  `distance_name` varchar(255) NOT NULL,
  `distance_charge` varchar(255) NOT NULL,
  PRIMARY KEY (`distanceId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of distance_term
-- ----------------------------
INSERT INTO `distance_term` VALUES ('2', 'km', '0.5');

-- ----------------------------
-- Table structure for prefix
-- ----------------------------
CREATE TABLE `prefix` (
  `prefix_id` int(15) NOT NULL AUTO_INCREMENT,
  `prefix` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `running_number` varchar(255) NOT NULL,
  PRIMARY KEY (`prefix_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of prefix
-- ----------------------------
INSERT INTO `prefix` VALUES ('1', 'REPORT', 'Report', 'REPORT', '11');
INSERT INTO `prefix` VALUES ('2', 'TRAVEL', 'Travel', 'TRAVEL', '2');
INSERT INTO `prefix` VALUES ('3', 'BANKPREFIX', 'BankPrefix', 'BANKPREFIX', '1');
INSERT INTO `prefix` VALUES ('4', 'CATEGORY', 'Category', 'CATEGORY', '50');

-- ----------------------------
-- Table structure for record
-- ----------------------------
CREATE TABLE `record` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `UserId` int(5) DEFAULT NULL,
  `CategoryId` int(5) NOT NULL,
  `travel_record` varchar(255) NOT NULL,
  `merchant` varchar(255) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `start_date` date DEFAULT NULL,
  `claim_amount` varchar(255) NOT NULL,
  `gst` varchar(255) NOT NULL,
  `total_amount` varchar(255) NOT NULL,
  `claim_report` varchar(255) NOT NULL,
  `bill_image` blob NOT NULL,
  `bill_image_type` varchar(255) NOT NULL,
  `distance` int(255) NOT NULL,
  `docno` varchar(255) NOT NULL,
  `tag` varchar(255) NOT NULL,
  `distance_charge` varchar(255) NOT NULL,
  `hours` varchar(255) NOT NULL,
  `priceperhour` varchar(255) NOT NULL,
  `origin` varchar(255) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `category_no` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of record
-- ----------------------------

-- ----------------------------
-- Table structure for record_traveling
-- ----------------------------
CREATE TABLE `record_traveling` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `UserId` int(5) DEFAULT NULL,
  `CategoryId` int(5) NOT NULL,
  `expense_id` int(15) NOT NULL,
  `merchant` varchar(255) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `start_date` date DEFAULT NULL,
  `claim_amount` varchar(255) NOT NULL,
  `gst` varchar(255) NOT NULL,
  `total_amount` varchar(255) NOT NULL,
  `claim_report` varchar(255) NOT NULL,
  `bill_image` blob NOT NULL,
  `bill_image_type` varchar(255) NOT NULL,
  `distance` int(255) NOT NULL,
  `docno` varchar(255) NOT NULL,
  `tag` varchar(255) NOT NULL,
  `distance_charge` varchar(255) NOT NULL,
  `hours` varchar(255) NOT NULL,
  `priceperhour` varchar(255) NOT NULL,
  `airline` varchar(255) NOT NULL,
  `origin` varchar(255) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `place` varchar(255) NOT NULL,
  `datefrom` date NOT NULL,
  `dateto` date NOT NULL,
  `daily_rate` varchar(255) NOT NULL,
  `num_of_day` varchar(255) NOT NULL,
  `category_no` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of record_traveling
-- ----------------------------

-- ----------------------------
-- Table structure for report
-- ----------------------------
CREATE TABLE `report` (
  `reportid` int(5) NOT NULL AUTO_INCREMENT,
  `reportname` varchar(255) NOT NULL,
  `expense_travel_id` int(15) NOT NULL,
  `report_ref` varchar(255) NOT NULL,
  `travel_record` varchar(255) NOT NULL,
  `UserId` int(5) DEFAULT NULL,
  `CategoryId` int(5) NOT NULL,
  `merchant` varchar(255) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `date_from` date NOT NULL,
  `date_to` date NOT NULL,
  `tax_code` varchar(255) NOT NULL,
  `tax_inclusive` varchar(255) NOT NULL,
  `claim_amount` varchar(255) NOT NULL,
  `gst` varchar(255) NOT NULL,
  `tax_amount` varchar(255) NOT NULL,
  `amt_include_gst` varchar(255) NOT NULL,
  `total_amount` varchar(255) NOT NULL,
  `bill_image` blob NOT NULL,
  `bill_image_type` varchar(255) NOT NULL,
  `place` varchar(225) NOT NULL,
  `airline` varchar(225) NOT NULL,
  `origin` varchar(255) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `distance` int(255) NOT NULL,
  `docno` varchar(255) NOT NULL,
  `tag` varchar(255) NOT NULL,
  `distance_charge` varchar(255) NOT NULL,
  `daily_rate` varchar(225) NOT NULL,
  `num_days` int(15) NOT NULL,
  `email_from` varchar(255) NOT NULL,
  `email_to` varchar(255) NOT NULL,
  `approval_1` int(15) NOT NULL,
  `approval_2` int(15) NOT NULL,
  `approval_3` int(15) NOT NULL,
  `claim_status` varchar(255) NOT NULL,
  `gl_code` varchar(255) NOT NULL,
  `merchant_gst_no` varchar(255) NOT NULL,
  `project_code` varchar(255) NOT NULL,
  PRIMARY KEY (`reportid`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of report
-- ----------------------------
INSERT INTO `report` VALUES ('6', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '11', 'petronas', 'fuel', '2024-03-13', '0000-00-00', '0000-00-00', '', '', '73.01', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd11741-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('7', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '31', 'seafood shangri-la (S) sdn bhd', 'Grocery', '2024-03-12', '0000-00-00', '0000-00-00', '', '', '208.00', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd87958-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('8', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '31', 'proliguest resources sdn bhd', 'Grocery', '2024-03-10', '0000-00-00', '0000-00-00', '', '', '110.80', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd62779-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('9', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '31', 'proliguest resources sdn bhd', 'Grocery', '2024-03-10', '0000-00-00', '0000-00-00', '', '', '61.19', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd56449-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('10', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '31', 'totem electronic', 'Seagate Ironwolf Hard Disk ', '2024-03-05', '0000-00-00', '0000-00-00', '', '', '276.00', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd10419-CCI25032024_0002.jpg', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('11', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '31', 'all it hypermarket sdn bhd', 'Synology (DS224 + NAS)', '2024-03-05', '0000-00-00', '0000-00-00', '', '', '1496.68', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd864780.jpg', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('12', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '31', 'mirrolex solutions llc', 'SystemX Work Deposit', '2024-03-05', '0000-00-00', '0000-00-00', '', '', '974.00', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd81964-', '', '', '', '', '0', '0001', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('13', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '11', 'petronas', 'fuel', '2024-03-03', '0000-00-00', '0000-00-00', '', '', '110.13', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd72183-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('14', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '13', 'bornas marketing s/b', 'Photocopy', '2024-02-29', '0000-00-00', '0000-00-00', '', '', '4.50', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd15178-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('15', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '22', 'lembaga hasil dalam negeri', 'Renew Trade License Linx Solution', '2024-02-29', '0000-00-00', '0000-00-00', '', '', '37.50', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd7143-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('16', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '11', 'petronas', 'fuel', '2024-02-25', '0000-00-00', '0000-00-00', '', '', '106.97', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd25378-', '', '', '', '', '0', '71a980', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('17', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '6', 'grabfood', 'Staff firewell Lunch Treat', '2024-02-23', '0000-00-00', '0000-00-00', '', '', '224.08', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd71419-CCI25032024.jpg', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('18', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '13', 'flexxo trading sdn bhd', 'Flexxo - A4 Paper & Stamp', '2024-02-22', '0000-00-00', '0000-00-00', '', '', '67.00', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd38968-CCI25032024_0001.jpg', '', '', '', '', '0', '65071', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('19', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '11', 'petronas', 'fuel', '2024-02-18', '0000-00-00', '0000-00-00', '', '', '122.80', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd10973-', '', '', '', '', '0', 'fac839', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('20', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', '0', 'REPORT-032024-00009', '', '2', '31', 'eco shop s/b', 'grocery', '2024-02-18', '0000-00-00', '0000-00-00', '', '', '47.40', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd94447-', '', '', '', '', '0', '38440240218111235', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('21', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '31', 'CENTRAL COLDSTORAGE', 'Grocery', '2024-03-13', '0000-00-00', '0000-00-00', '', '', '46.05', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd35720-', '', '', '', '', '0', '10692095', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('22', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '31', 'WENNI.MY', 'Sportlight Bulb', '2024-03-13', '0000-00-00', '0000-00-00', '', '', '30.94', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd61985-', '', '', '', '', '0', '240206U4UWVPBY', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('23', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '31', 'SHOPEE', 'Charging Usb Cable', '2024-03-13', '0000-00-00', '0000-00-00', '', '', '20.06', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd69979-WhatsApp Image 2024-03-27 at 09.42.53.jpeg', '', '', '', '', '0', '24031302AXRTE0', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('24', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '31', 'CHOICE OFFICIAL SHOP', 'Charging Usb Cable', '2024-03-13', '0000-00-00', '0000-00-00', '', '', '30.45', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd5054-WhatsApp Image 2024-03-27 at 09.42.52 (1).jpeg', '', '', '', '', '0', '24031302EH3XRS', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('25', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '31', 'LED SHOP MALAYSIA', 'Led Strip Connector', '2024-03-13', '0000-00-00', '0000-00-00', '', '', '33.30', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd2663-WhatsApp Image 2024-03-27 at 09.42.52.jpeg', '', '', '', '', '0', '24031305TFCD9E', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('26', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '5', 'ANIMAL CENTRAL VETERINARY', 'Medical Fee Cat', '2024-03-10', '0000-00-00', '0000-00-00', '', '', '124.00', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd35283-', '', '', '', '', '0', 'INV-47673', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('27', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '31', 'EVERWIN CENTRE SDN BHD', 'Grocery', '2024-03-09', '0000-00-00', '0000-00-00', '', '', '19.50', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd36988-', '', '', '', '', '0', 'EKE2403090061066', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('28', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '31', 'kim super save (summer) sdn bhd', 'Green Packet ', '2024-03-03', '0000-00-00', '0000-00-00', '', '', '9.20', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd45128-', '', '', '', '', '0', 'mms04-1062348', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('29', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '5', 'DR ZAWAMI ANIMAL CLINIC', 'Tabby Medical Checkup', '2024-03-01', '0000-00-00', '0000-00-00', '', '', '402.00', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd22550-', '', '', '', '', '0', 'INV-64847', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('30', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '31', 'cuckoo', 'Water Purifier ', '2024-03-01', '0000-00-00', '0000-00-00', '', '', '120.00', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd50580-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('31', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '4', 'celcom', 'Internet Bill', '2024-03-01', '0000-00-00', '0000-00-00', '', '', '119.00', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd91740-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('32', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '4', 'celcom', 'Phone Bill', '2024-03-01', '0000-00-00', '0000-00-00', '', '', '40.00', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd84278-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('33', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '31', 'RAYMOND HO', 'Claim Refund Customer Payment (Jaydon)', '2024-02-29', '0000-00-00', '0000-00-00', '', '', '270.00', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd79091-', '', '', '', '', '0', '', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');
INSERT INTO `report` VALUES ('34', 'March\\\'24 Claims Raymond Ho (Linxpet)', '0', 'REPORT-032024-00011', '', '2', '31', 'the animal kingdom sdn bhd', 'Cat Food', '2024-02-28', '0000-00-00', '0000-00-00', '', '', '209.55', '', '', '', '', '', '../include/upload/expenses/Softworld Software Sdn Bhd94762-', '', '', '', '', '0', 'hq02177989', '', '', '', '0', 'raymond@softworld.com.my', '', '0', '2', '0', '', '', '', '');

-- ----------------------------
-- Table structure for report_s
-- ----------------------------
CREATE TABLE `report_s` (
  `report_sid` int(5) NOT NULL AUTO_INCREMENT,
  `approval1_id` int(15) NOT NULL,
  `approval2_id` int(15) NOT NULL,
  `approval3_id` int(15) NOT NULL,
  `report_name` varchar(255) NOT NULL,
  `report_ref` varchar(255) NOT NULL,
  `total_claim` varchar(255) NOT NULL,
  `email_from` varchar(255) NOT NULL,
  `email_to` varchar(255) NOT NULL,
  `submit_Date` date NOT NULL,
  `status` varchar(255) NOT NULL,
  `export_date` date NOT NULL,
  PRIMARY KEY (`report_sid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of report_s
-- ----------------------------
INSERT INTO `report_s` VALUES ('3', '2', '0', '0', 'tetetet', 'REPORT-032024-00006', '33000', 'raymond@softworld.com.my', '', '2024-03-13', 'APPROVED', '0000-00-00');
INSERT INTO `report_s` VALUES ('5', '0', '2', '0', 'testing2', 'REPORT-032024-00008', '10000.00', 'raymond@softworld.com.my', '', '2024-03-15', 'APPROVED', '0000-00-00');
INSERT INTO `report_s` VALUES ('6', '0', '2', '0', 'MARCH 2024 CLAIMS RAYMOND HO (SOFTWORLD)', 'REPORT-032024-00009', '3920.06', 'raymond@softworld.com.my', '', '2024-03-26', 'APPROVED', '0000-00-00');
INSERT INTO `report_s` VALUES ('7', '0', '2', '0', 'March\\\'24 Claims Raymond Ho (Linxpet)', 'REPORT-032024-00011', '1474.05', 'raymond@softworld.com.my', '', '2024-03-27', 'APPROVED', '0000-00-00');

-- ----------------------------
-- Table structure for traveling
-- ----------------------------
CREATE TABLE `traveling` (
  `travel_id` int(5) NOT NULL AUTO_INCREMENT,
  `report_ref` varchar(255) NOT NULL,
  `travel_record_id` varchar(255) NOT NULL,
  `travel_title` varchar(255) NOT NULL,
  `travel_mode` varchar(255) NOT NULL,
  `travel_purpose` varchar(255) NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `time_from` varchar(255) NOT NULL,
  `time_to` varchar(255) NOT NULL,
  `total_claim` varchar(255) NOT NULL,
  PRIMARY KEY (`travel_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of traveling
-- ----------------------------
INSERT INTO `traveling` VALUES ('1', 'REPORT-032024-00006', 'TRAVEL-032024-00002', 'tetet', '', '', '1970-01-01', '1970-01-01', '', '', '');
