/*
Navicat MySQL Data Transfer

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

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

Date: 2024-04-24 15:49:01
*/


-- ----------------------------
-- Table structure for doc_numbering
-- ----------------------------
CREATE TABLE `doc_numbering` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doc_name` varchar(255) DEFAULT NULL,
  `prefix` varchar(255) DEFAULT NULL,
  `next_num` varchar(255) DEFAULT NULL,
  `digit_num` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of doc_numbering
-- ----------------------------
INSERT INTO `doc_numbering` VALUES ('1', 'Customization Request', 'LL', '1', '5');

-- ----------------------------
-- Table structure for feedback
-- ----------------------------
CREATE TABLE `feedback` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `db_company_name` varchar(255) DEFAULT NULL,
  `user_id` int(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `datetime` varchar(255) DEFAULT NULL,
  `feedback` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of feedback
-- ----------------------------

-- ----------------------------
-- Table structure for linxleave_access
-- ----------------------------
CREATE TABLE `linxleave_access` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `db_id` int(255) DEFAULT NULL,
  `increment` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of linxleave_access
-- ----------------------------
INSERT INTO `linxleave_access` VALUES ('1', '1', '0');
INSERT INTO `linxleave_access` VALUES ('2', '2', '1');
INSERT INTO `linxleave_access` VALUES ('3', '3', '1');

-- ----------------------------
-- Table structure for payment
-- ----------------------------
CREATE TABLE `payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `payment_status` varchar(20) DEFAULT NULL,
  `payment_amount` float(10,2) DEFAULT NULL,
  `payment_currency` varchar(20) DEFAULT NULL,
  `txn_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- ----------------------------
-- Records of payment
-- ----------------------------

-- ----------------------------
-- Table structure for payments
-- ----------------------------
CREATE TABLE `payments` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `txnid` varchar(20) DEFAULT NULL,
  `payment_amount` decimal(7,2) DEFAULT NULL,
  `currency_code` varchar(10) DEFAULT NULL,
  `payment_status` varchar(25) DEFAULT NULL,
  `itemid` varchar(25) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `no_of_user` varchar(100) DEFAULT NULL,
  `addon_user` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `createdtime` datetime DEFAULT NULL,
  `res` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- ----------------------------
-- Records of payments
-- ----------------------------

-- ----------------------------
-- Table structure for pricing
-- ----------------------------
CREATE TABLE `pricing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package` varchar(255) DEFAULT NULL,
  `total_user` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of pricing
-- ----------------------------
INSERT INTO `pricing` VALUES ('1', 'CLAIMS5', '5', 'MYR', '0');
INSERT INTO `pricing` VALUES ('2', 'CLAIMS20', '20', 'MYR', '90');
INSERT INTO `pricing` VALUES ('3', 'CLAIMS35', '35', 'MYR', '154');
INSERT INTO `pricing` VALUES ('4', 'CLAIMS50', '50', 'MYR', '215');
INSERT INTO `pricing` VALUES ('5', 'CLAIMS75', '75', 'MYR', '315');
INSERT INTO `pricing` VALUES ('6', 'CLAIMS100', '100', 'MYR', '410');
INSERT INTO `pricing` VALUES ('7', 'CLAIMSPLUS', '', 'MYR', '0');
INSERT INTO `pricing` VALUES ('8', 'CLAIMSADDED', '', 'MYR ', '5');

-- ----------------------------
-- Table structure for products
-- ----------------------------
CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `price` float(10,2) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of products
-- ----------------------------

-- ----------------------------
-- Table structure for register
-- ----------------------------
CREATE TABLE `register` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reg_running_no` varchar(255) DEFAULT NULL,
  `reg_companyname` varchar(255) DEFAULT NULL,
  `reg_fullname` varchar(255) DEFAULT NULL,
  `reg_totaluser` varchar(255) DEFAULT NULL,
  `reg_email` varchar(255) DEFAULT NULL,
  `reg_contactno` varchar(255) DEFAULT NULL,
  `reg_customize` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of register
-- ----------------------------

-- ----------------------------
-- Table structure for website
-- ----------------------------
CREATE TABLE `website` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) DEFAULT NULL,
  `email_approver` varchar(255) DEFAULT NULL,
  `name_approver` varchar(255) DEFAULT NULL,
  `email_applicant` varchar(255) DEFAULT NULL,
  `name_applicant` varchar(255) DEFAULT NULL,
  `application_date` varchar(255) DEFAULT NULL,
  `leave_type` varchar(255) DEFAULT NULL,
  `leave_date` varchar(50) DEFAULT NULL,
  `total_days` int(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of website
-- ----------------------------
INSERT INTO `website` VALUES ('1', 'TEST', 'zaidatulzanariah@yahoo.com', 'TEST', 'zaidatulzanariah@yahoo.com', 'TEST', '2018-01-23', 'ANNUAL LEAVE', '18/01/2018-FULL,', '1', 'TEST');
INSERT INTO `website` VALUES ('2', 'TEST', 'aafordemo@yahoo.com', 'TEST 2 ', 'safordemo@yahoo.com', 'TEST', '2018-01-25', 'ANNUAL LEAVE', '26/01/2018-FULL,29/01/2018-FULL,30/01/2018-FULL,', '3', 'TEST');
