/*
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 company
-- ----------------------------
CREATE TABLE `company` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(70) DEFAULT NULL,
  `email` varchar(70) DEFAULT NULL,
  `hash` varchar(255) DEFAULT NULL,
  `active` tinyint(1) DEFAULT 0,
  `no_of_user` varchar(100) DEFAULT NULL,
  `addon_user` varchar(255) DEFAULT NULL,
  `subdomain` varchar(50) DEFAULT NULL,
  `database_name` varchar(50) DEFAULT NULL,
  `first_access` tinyint(1) DEFAULT NULL,
  `active_date` date DEFAULT NULL,
  `expire_date` date DEFAULT NULL,
  `ip_address` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES ('1', 'LinxSystem Testing Sdn Bhd', 'linxleave@linx.com.my', '', '1', 'WZEwG1YbhvSvxID+7fT9TmVBNiO+TfGL7/NJmuL9P60=', '', '', 'linxleave_company_1', '0', '2017-07-12', '2100-01-12', '');
INSERT INTO `company` VALUES ('2', 'SOFTWORLD SOFTWARE SDN BHD', 'fj.reena96@gmail.com', '013a006f03dbc5392effeb8f18fda755', '1', 'f3cf1dd759ca1ee5572bdf0612fbbab8', null, null, 'linxleave_company_2', null, '2018-01-24', '2100-01-24', null);
INSERT INTO `company` VALUES ('3', 'LINX DEMO', 'aafordemo@linxleave.com', '9ad6aaed513b73148b7d49f70afcfb32', '1', 'pqUa83cisct/Jh/9vRKJcD1ZffKbrtyPX/2gO8XVysY=', null, null, 'linxleave_company_3', null, '2018-01-24', '2019-01-24', null);
INSERT INTO `company` VALUES ('4', 'KIM HIN TRADING BERHAD', 'jobs@softworld.com.my', '934815ad542a4a7c5e8a2dfa04fea9f5', '1', 'pqUa83cisct/Jh/9vRKJcD1ZffKbrtyPX/2gO8XVysY=', null, null, 'linxleave_company_4', null, '2018-02-22', '2019-02-22', null);
INSERT INTO `company` VALUES ('5', 'Kim Hin Industry Berhad', 'jasmine@softworld.com.my', '6a10bbd480e4c5573d8f3af73ae0454b', '1', 'pqUa83cisct/Jh/9vRKJcD1ZffKbrtyPX/2gO8XVysY=', null, null, 'linxleave_company_5', null, '2018-03-07', '2019-03-07', null);
INSERT INTO `company` VALUES ('6', 'REGAS', 'safordemo@yahoo.com', '92fb0c6d1758261f10d052e6e2c1123c', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, '', null, '2018-04-25', '2019-04-25', null);
INSERT INTO `company` VALUES ('7', 'Ivan Chung Kah Yong', 'ivanchungkahyong1215@gmail.com', 'a64c94baaf368e1840a1324e839230de', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('8', 'BUMICHUNG LOGISTIC SDN BHD', 'zaidatulzanariah@softworld.com.my', '00ec53c4682d36f5c4359f4ae7bd7ba1', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_8', null, '2018-05-23', '2019-05-23', null);
INSERT INTO `company` VALUES ('9', 'DemoCompany', 'demo@linxleave.com', '217eedd1ba8c592db97d0dbe54c7adfc', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_9', null, '2018-06-22', '2019-06-22', null);
INSERT INTO `company` VALUES ('10', 'AL Corp', 'alexanderlimkh@gmail.com', '217eedd1ba8c592db97d0dbe54c7adfc', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_10', null, '2018-07-02', '2019-07-02', null);
INSERT INTO `company` VALUES ('11', 'TITANIUM', 'raamah@titanium.com.my', '217eedd1ba8c592db97d0dbe54c7adfc', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_11', null, '2018-07-13', '2019-07-02', null);
INSERT INTO `company` VALUES ('12', 'info23', 'info23@cantatic.com', 'c9f0f895fb98ab9159f51fd0297e236d', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('13', 'linxleave.com', 'linxleave.com@domstates.su', '6c9882bbac1c7093bd25041881277658', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('14', 'softworld', 'dilah@softworld.com.my', 'f0e52b27a7a5d6a1a87373dffa53dbe5', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('15', 'linxleave.com', 'linxleave.com@domstat.su', '11b921ef080f7736089c757404650e40', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('16', 'Stamm, Ratke and Nikolaus', 'kevincurtis999@gmail.com', '1a5b1e4daae265b790965a275b53ae50', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('18', 'Douglas - Schuppe', 'greteldz25@hotmail.com', '84117275be999ff55a987b9381e01f96', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('19', 'Heller - Boyle', 'reachlover101@gmail.com', '556f391937dfd4398cbac35e050a2177', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('20', 'Casper - Lesch', 'robtkd13@gmail.com', '58d4d1e7b1e97b258c9ed0b37e02d087', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('21', 'Lueilwitz, Predovic and Brown', 'chipcooper2001@yahoo.com', '846c260d715e5b854ffad5f70a516c88', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('22', 'Petroseal Engineering Sdn Bhd', 'nurlianamadihah019@gmail.com', '98dce83da57b0395e163467c9dae521b', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_22', null, '2019-12-31', '2020-12-31', null);
INSERT INTO `company` VALUES ('23', 'Softworld Software Sdn Bhd', 'admin@softworld.com.my', '8b6dd7db9af49e67306feb59a8bdc52c', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_23', null, '2020-01-03', '2021-01-03', null);
INSERT INTO `company` VALUES ('24', 'Swaniawski, Steuber and Medhurst', 's', '98f13708210194c475687be6106a3b84', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('25', 'Torphy LLC', 'matt@gcgx.org', '4f6ffe13a5d75b2d6a3923922b3922e5', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('26', 'Boyer - Littel', 'shamarsmith1982@yahoo.com', '670e8a43b246801ca1eaca97b3e19189', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('27', 'Waelchi - Tillman', 'bearbasin@hotmail.com', 'a532400ed62e772b9dc0b86f46e583ff', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('28', 'Lynch - Fay', 'linking3@cox.net', 'bc6dc48b743dc5d013b1abaebd2faed2', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('29', 'soft', 'fun.9609@gmail.com', '5737034557ef5b8c02c0e46513b98f90', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_29', null, '2020-01-29', '2021-01-29', null);
INSERT INTO `company` VALUES ('30', 'Softworld', 'chesterchen29@gmail.com', '1afa34a7f984eeabdbb0a7d494132ee5', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_30', null, '2020-01-29', '2021-01-29', null);
INSERT INTO `company` VALUES ('31', 'softworld software sdn bhd', 'yagamisung@gmail.com', '01882513d5fa7c329e940dda99b12147', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_31', null, '2020-01-29', '2021-01-29', null);
INSERT INTO `company` VALUES ('32', 'Swaniawski, Nitzsche and Harvey', 'asherrill74@aol.com', '632cee946db83e7a52ce5e8d6f0fed35', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('33', 'Murray - Bartell', 'jon.ingleton@tudor-rose.co.uk', '2dea61eed4bceec564a00115c4d21334', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('34', 'Maggio Inc', 'media@ctpboston.com', 'fccb3cdc9acc14a6e70a12f74560c026', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('35', 'Wolf LLC', 'casey3011@gmail.com', 'df877f3865752637daa540ea9cbc474f', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('36', 'Hudson - Schuppe', 'abhishek_27@hotmail.com', 'c75b6f114c23a4d7ea11331e7c00e73c', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('37', 'Buckridge - Rutherford', 'jennifer.allan4@googlemail.com', 'b5b41fac0361d157d9673ecb926af5ae', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('38', 'Kertzmann LLC', 'tymalmills@hotmail.com', 'a02ffd91ece5e7efeb46db8f10a74059', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('39', 'Haley Inc', 'fuller.flin@yahoo.com', '31839b036f63806cba3f47b93af8ccb5', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('40', 'Bednar, Yundt and McKenzie', 'sundog74@cox.net', '43ec517d68b6edd3015b3edc9a11367b', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('41', 'Koch, Parisian and Littel', 'stephanie.casertano@colart.com', '2e65f2f2fdaf6c699b223c61b1b5ab89', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('42', 'Lang, Moore and Boyer', 'jheidkamp@live.com', '430c3626b879b4005d41b8a46172e0c0', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('43', 'Beier Inc', 'kristinfrazier57@yahoo.com', 'b56a18e0eacdf51aa2a5306b0f533204', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('44', 'Monahan LLC', 'nkprives@gmail.com', 'cf004fdc76fa1a4f25f62e0eb5261ca3', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('45', 'Armstrong and Sons', 'milaarni@yahoo.com', '5dd9db5e033da9c6fb5ba83c7a7ebea9', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('46', 'Rogahn - Schimmel', 'thelma.vidar@gmail.com', '3ad7c2ebb96fcba7cda0cf54a2e802f5', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('47', 'Barton, Goyette and Klein', 'jlcook89@gmail.com', 'b2eb7349035754953b57a32e2841bda5', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('48', 'Kuhic LLC', 'erinrenee@verizon.net', '41f1f19176d383480afa65d325c06ed0', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('49', 'Rodriguez Inc', 'mmsilvidi@comcast.net', '0777d5c17d4066b82ab86dff8a46af6f', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('50', 'Von Group', 'abotanov@kcm.org', 'c203d8a151612acf12457e4d67635a95', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('51', 'Stracke, Stroman and Mitchell', 'carlessf@udmercy.edu', '698d51a19d8a121ce581499d7b701668', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('52', 'Schimmel Group', 'yungkhan@gmail.com', 'b7ee6f5f9aa5cd17ca1aea43ce848496', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('53', 'Marquardt - Hettinger', 'reimroctx@hotmail.com', '9ab0d88431732957a618d4a469a0d4c3', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('54', 'Wehner, Bernhard and Greenfelder', 'czelus@hotmail.com', '839ab46820b524afda05122893c2fe8e', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('55', 'Bernhard LLC', 'info@orienthonest.com', 'a8e864d04c95572d1aece099af852d0a', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('56', 'Padberg, Tromp and Reynolds', 'vikes32@hotmail.com', '0d3180d672e08b4c5312dcdafdf6ef36', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('57', 'Kuvalis LLC', 'cheryll@bowersfp.com', '9de6d14fff9806d4bcd1ef555be766cd', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('58', 'Hintz and Sons', 'eamon@healingsolutions.com', 'b6f0479ae87d244975439c6124592772', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('59', 'Abshire - Schiller', 'sydney.thompson@okstate.edu', 'df6d2338b2b8fce1ec2f6dda0a630eb0', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('60', 'Streich - Simonis', 'fisher_shauna@yahoo.com', '185e65bc40581880c4f2c82958de8cfe', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('61', 'Block, Batz and Jacobs', 'cpatkins@aol.com', 'cbb6a3b884f4f88b3a8e3d44c636cbd8', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('62', 'McKenzie Group', 'clayps@gmail.com', '9e3cfc48eccf81a0d57663e129aef3cb', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('63', 'Bernier Group', 'daddybyrd@ameritech.net', '24681928425f5a9133504de568f5f6df', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('64', 'Hammes, Sauer and O\'Keefe', 'hawkinss@abroms.com', 'a64c94baaf368e1840a1324e839230de', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('65', 'Carroll - Doyle', 'kmdailly@yahoo.co.uk', 'eb6fdc36b281b7d5eabf33396c2683a2', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('66', 'Prohaska - Purdy', 'cbuchanan10@hotmail.co.uk', 'bc6dc48b743dc5d013b1abaebd2faed2', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('67', 'Quigley Inc', 'ryan.monroe@worldnet.att.net', 'e0c641195b27425bb056ac56f8953d24', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('68', 'Goodwin - Osinski', 'sora0120@gmail.com', '4b0250793549726d5c1ea3906726ebfe', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('69', 'Kris - Huel', 'charnell.alderete@gmail.com', 'c4ca4238a0b923820dcc509a6f75849b', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('70', 'Rodriguez LLC', 'beckyzheng2012@gmail.com', 'c86a7ee3d8ef0b551ed58e354a836f2b', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('71', 'petroseal engineering sdn bhd ', 'nurhidayah@petroseal.com.my', '4f6ffe13a5d75b2d6a3923922b3922e5', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('72', 'Yundt - Boyle', 'udo.wolff1@gmx.net', '1905aedab9bf2477edc068a355bba31a', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('73', 'Miller Inc', 'ericlosw@yahoo.com', '4b6538a44a1dfdc2b83477cd76dee98e', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('74', 'Kerluke - Streich', 'hammer_niklas@freenet.de', 'c9f0f895fb98ab9159f51fd0297e236d', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('75', 'Feeney, Ullrich and Gerhold', 'shoudijk1979@hotmail.com', '48ab2f9b45957ab574cf005eb8a76760', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('76', 'PETROSEAL ENGINEERING SDB.BHD', 'raja.muhammad@petroseal.com.my', '9b72e31dac81715466cd580a448cf823', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_76', null, '2020-07-23', '2021-07-23', null);
INSERT INTO `company` VALUES ('77', 'Bins and Sons', 'projectboardcoop@gmail.com', 'c0f168ce8900fa56e57789e2a2f2c9d0', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('78', 'Kihn - Ward', 'office@nawrockiarchitect.com', 'f0adc8838f4bdedde4ec2cfad0515589', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('79', 'Softworld software sdn bhd', 'niza@softworld.com.my', '1afa34a7f984eeabdbb0a7d494132ee5', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('80', 'Bahringer Inc', '7209825569@messaging.sprintpcs.com', '7380ad8a673226ae47fce7bff88e9c33', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('81', 'Mueller - Schoen', 'iloveyouu059@gmail.com', '5b69b9cb83065d403869739ae7f0995e', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('82', 'O\'Conner Inc', 'david.biggs@motorolasolutions.com', 'f61d6947467ccd3aa5af24db320235dd', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('83', 'Brown - Goldner', 'poochonsrule@gmail.com', '59b90e1005a220e2ebc542eb9d950b1e', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('84', 'Cronin LLC', 'jjohneevans@aol.com', '36660e59856b4de58a219bcf4e27eba3', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('85', 'Klocko - Deckow', 'bern0808@aol.com', '7f5d04d189dfb634e6a85bb9d9adf21e', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('86', 'Schowalter Inc', 'g.dols@ubaz.com', '210f760a89db30aa72ca258a3483cc7f', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('87', 'Pollich, Swift and Huels', 'rbroadbent95@hotmail.com', '5dd9db5e033da9c6fb5ba83c7a7ebea9', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('88', 'Ortiz LLC', 'foredjm@aol.com', 'a733fa9b25f33689e2adbe72199f0e62', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('89', 'Schroeder - Sanford', 'bmclendon@slb.com', 'f85454e8279be180185cac7d243c5eb3', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('90', 'Prosacco, Jacobson and Reinger', 'leannhilton@hotmail.com', 'e7f8a7fb0b77bcb3b283af5be021448f', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('91', 'Rippin Inc', 'bbuchheit@hotmail.com', 'c15da1f2b5e5ed6e6837a3802f0d1593', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('92', 'Witting - Steuber', 'tradecrypto219@gmail.com', 'f387624df552cea2f369918c5e1e12bc', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('93', 'Walsh - Kovacek', 'leannhilton@hiltonmgmt.com', '3ef815416f775098fe977004015c6193', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('94', 'Rowe - Beier', 'teamgroup9130@gmail.com', '89f0fd5c927d466d6ec9a21b9ac34ffa', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('95', 'ABC SDN BHD', 's', '44f683a84163b3523afe57c2e008bc8c', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_95', null, '2020-11-06', '2021-11-06', null);
INSERT INTO `company` VALUES ('96', 'Fully-configurable multi-state task-force', 'sharon10@huber.net', '9461cce28ebe3e76fb4b931c35a169b0', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('97', 'Wayne Enterprise Sdn Bhd', 'nickwingchun@gmail.com', '5f93f983524def3dca464469d2cf9f3e', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_97', null, '2021-03-08', '2022-03-08', null);
INSERT INTO `company` VALUES ('98', 'Reservoir Link', 'mohd.azlan@reservoirlink.com', '05049e90fa4f5039a8cadc6acbb4b2cc', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('99', 'Softworld software company', 'Henry991999@hotmail.com', 'cdc0d6e63aa8e41c89689f54970bb35f', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('100', 'linxleave.com', 'linxleave.com@buycodeshop.com', '233509073ed3432027d48b1a83f5fbd2', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('101', 'Softworld Software Sdn Bhd', 'annatasiayii0712@gmail.com', '9be40cee5b0eee1462c82c6964087ff9', '1', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('102', 'Reservoir Link Solutions', 'risitharavathy@reservoirlink.com', '8eefcfdf5990e441f0fb6f3fad709e21', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_102', null, '2022-05-22', '2023-05-22', null);
INSERT INTO `company` VALUES ('103', 'GOOGLE', null, null, '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('104', 'GOOGLE', null, null, '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('105', 'Saga Sinarmas', 'admin@sagasinarmas.com', '217eedd1ba8c592db97d0dbe54c7adfc', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', null, null, 'linxleave_company_105', null, '2018-06-22', '2023-06-30', null);
INSERT INTO `company` VALUES ('106', 'Lea', 'itsupport5@leagroup.com.my', 'f340f1b1f65b6df5b5e3f94d95b11daf', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('107', 'Lea Holding', 'itlawrence5@gmail.com', 'cbb6a3b884f4f88b3a8e3d44c636cbd8', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('108', 'CKS TRANSPORT & FORWARDING SDN BHD ( Liyaa)', 'lehmeit@gmail.com', '077e29b11be80ab57e1a2ecabb7da330', '0', null, null, null, null, null, null, null, null);
INSERT INTO `company` VALUES ('109', 'LINXPET COMPANY', 'linxpet@gmail.com', '872488f88d1b2db54d55bc8bba2fad1b', '0', null, null, null, 'linxleave_company_2', null, '2024-01-05', '2100-01-24', null);

-- ----------------------------
-- 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');
