HEX
Server: Apache/2.4.46 (Win64) OpenSSL/1.1.1j PHP/8.4.25
System: Windows NT DESKTOP-4TAV2RJ 10.0 build 19045 (Windows 10) AMD64
User: fred (0)
PHP: 8.4.25
Disabled: NONE
Upload Files
File: C:/xampp/htdocs/ctmember.SQL
/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck-st
Target Host: localhost
Target Database: tvicheck-st
Date: 2024/1/29 �U�� 11:05:26
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for ctmember
-- ----------------------------
CREATE TABLE `ctmember` (
  `id` int(4) NOT NULL,
  `company` varchar(255) COLLATE utf8_bin NOT NULL,
  `passbit` tinyint(1) NOT NULL,
  `rdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ldate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `contact` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ltool` varchar(5) COLLATE utf8_bin DEFAULT NULL,
  `CTcount` int(6) DEFAULT '1',
  `denCounter` int(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `ctmember` VALUES ('1', 'ecolor', '1', '2016-10-01 23:02:12', '2024-01-25 12:56:10', 'Fred', 'DP6', '1721', '58');
INSERT INTO `ctmember` VALUES ('2', 'sser', '1', '2016-10-02 01:19:28', '2022-10-04 15:49:21', null, 'CT21', '16', '44');
INSERT INTO `ctmember` VALUES ('3', 'crony', '1', '2016-10-02 01:20:00', '2023-11-01 15:25:43', null, 'CT23', '811', '50');
INSERT INTO `ctmember` VALUES ('4', 'pbndemo', '1', '2016-10-02 01:20:28', '2024-01-27 17:47:57', null, 'DP', '1154', '498');
INSERT INTO `ctmember` VALUES ('5', 'koncep', '1', '2016-10-02 01:21:12', '2022-06-29 16:07:30', null, 'CT21', '3', '50');
INSERT INTO `ctmember` VALUES ('6', 'AKIMIA', '1', '2016-10-02 01:21:42', '2022-08-04 14:14:42', null, 'CT21', '13', '50');
INSERT INTO `ctmember` VALUES ('7', 'cymtek', '1', '2016-10-02 01:22:02', '2023-10-11 17:12:24', null, 'CT23', '167', '50');
INSERT INTO `ctmember` VALUES ('8', 'RedBlue', '1', '2016-11-08 06:19:08', '2024-01-24 11:28:25', null, 'DP6', '2210', '50');