/*
Navicat MySQL Data Transfer

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

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

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


-- ----------------------------
-- Table structure for company
-- ----------------------------
CREATE TABLE `company` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) NOT NULL,
  `email` varchar(70) NOT NULL,
  `hash` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `no_of_user` varchar(100) NOT NULL,
  `database_name` varchar(255) NOT NULL,
  `first_access` tinyint(1) NOT NULL,
  `active_date` date NOT NULL,
  `expire_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES ('1', 'Resvervoir Link Sdn Bhd', '', '', '0', '', '', '0', '0000-00-00', '0000-00-00');
INSERT INTO `company` VALUES ('2', 'Linx Solutions Sdn Bhd', '', '', '0', '', '', '0', '0000-00-00', '0000-00-00');
INSERT INTO `company` VALUES ('3', 'Amsito Oilwell Services (M) Sdn. Bhd.', '', '', '0', '', '', '0', '0000-00-00', '0000-00-00');
INSERT INTO `company` VALUES ('6', 'LinxSystem Testing Sdn Bhd', 'safordemo@yahoo.com', '', '1', 'nZ7HtMlv4FSKPmw2NDsXgmJU3/Z9mZ1jhsZUVdzmJjk=', 'linxclaims_company_1', '0', '2018-01-03', '2019-01-03');
INSERT INTO `company` VALUES ('7', 'Softworld Software Sdn Bhd', 'admin@softworld.com.my', '', '1', 'nZ7HtMlv4FSKPmw2NDsXgmJU3/Z9mZ1jhsZUVdzmJjk=', 'linxclaims_softworld', '0', '2020-10-14', '2022-10-14');
INSERT INTO `company` VALUES ('8', 'Saga Sinarmas', 'admin@sagasinarmas.com', '', '1', 'jBRXjvbdPQSVAuSUuzPrvgqLJeObndFMQ5TNhAXzCRE=', 'linxclaims_company_8', '0', '2018-06-22', '2023-06-22');
