File: C:/Users/fred/OneDrive/Desktop/xampp/htdocs/crbase.sql
/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck-st
Target Host: localhost
Target Database: tvicheck-st
Date: 2024/8/29 �W�� 11:19:23
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for crbase
-- ----------------------------
CREATE TABLE `crbase` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sn` varchar(12) DEFAULT NULL,
`name` varchar(12) DEFAULT NULL,
`company` varchar(12) DEFAULT NULL,
`ssid` varchar(30) DEFAULT NULL,
`passbit` tinyint(1) unsigned zerofill DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `crbase` VALUES ('1', 'CM42570001', 'Fred', 'pbn', '[email protected]', '1');