CREATE DATABASE  IF NOT EXISTS `2223_js183_safety` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `2223_js183_safety`;
--
-- Host: localhost    Database: 2223_js183_safety
-- ------------------------------------------------------


--
-- Table structure for table `calib`
--

CREATE TABLE `calib` (
  `tb_id` varchar(50) DEFAULT NULL,
  `ect_ohms_multiplier` decimal(10,5) DEFAULT NULL,
  `ect_ohms_offset` decimal(10,5) DEFAULT NULL,
  `ect_current_multiplier` decimal(10,5) DEFAULT NULL,
  `ect_current_offset` varchar(45) DEFAULT NULL,
  `hvt_kv_multiplier` decimal(10,5) DEFAULT NULL,
  `hvt_kv_offset` decimal(10,5) DEFAULT NULL,
  `hvt_ma_multiplier` decimal(10,5) DEFAULT NULL,
  `hvt_ma_offset` decimal(10,5) DEFAULT NULL,
  `it_mohms_multiplier` decimal(10,5) DEFAULT NULL,
  `it_mohms_offset` decimal(10,5) DEFAULT NULL,
  `lct_ma_multiplier` decimal(10,5) DEFAULT NULL,
  `lct_ma_offset` decimal(10,5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `calib`
--

INSERT INTO `calib` VALUES ('1',1.00000,0.00000,1.01000,'0.00000000000000000e+00',1.00000,0.00000,1.00100,0.00000,1.00000,0.00000,1.00000,0.00000);

--
-- Table structure for table `port_settings`
--

CREATE TABLE `port_settings` (
  `com_port` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `port_settings`
--


--
-- Table structure for table `report_col`
--

CREATE TABLE `report_col` (
  `modelno` varchar(50) DEFAULT NULL,
  `indexx` int(11) DEFAULT NULL,
  `col_index` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `report_col`
--

INSERT INTO `report_col` VALUES ('All',0,0),('All',1,1),('All',2,2),('All',3,3),('All',4,4),('All',5,5);

--
-- Table structure for table `serialnosettings`
--

CREATE TABLE `serialnosettings` (
  `model_no` varchar(45) DEFAULT NULL,
  `Character_Set_1` varchar(45) DEFAULT NULL,
  `Character_Set_2` varchar(45) DEFAULT NULL,
  `Character_Set_3` varchar(45) DEFAULT NULL,
  `Character_Set_4` varchar(45) DEFAULT NULL,
  `Character_Set_5` varchar(45) DEFAULT NULL,
  `no_of_digit` varchar(45) DEFAULT NULL,
  `Selection_string` varchar(100) DEFAULT NULL,
  `starting_serial_no` varchar(45) DEFAULT NULL,
  `ScanBarcode` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `serialnosettings`
--

INSERT INTO `serialnosettings` VALUES ('Model1','a','b','c','','','4.000000','Character_Set_1,Character_Set_2,Character_Set_3,Serial_Number','10.000000','false');

--
-- Table structure for table `settings_barcode`
--

CREATE TABLE `settings_barcode` (
  `tb_id` varchar(50) DEFAULT NULL,
  `top_margin` int(11) DEFAULT NULL,
  `left_margin` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings_barcode`
--


--
-- Table structure for table `settings_master`
--

CREATE TABLE `settings_master` (
  `model_no` varchar(100) DEFAULT NULL,
  `set_ect` varchar(100) DEFAULT NULL,
  `set_hv_kv` varchar(100) DEFAULT NULL,
  `set_hv_ma` varchar(100) DEFAULT NULL,
  `set_ir_mohms` varchar(100) DEFAULT NULL,
  `set_lct_ma` varchar(100) DEFAULT NULL,
  `wattage_lower` varchar(100) DEFAULT NULL,
  `wattage_upper` varchar(100) DEFAULT NULL,
  `set_ect_time` varchar(100) DEFAULT NULL,
  `set_hv_time` varchar(100) DEFAULT NULL,
  `set_ir_time` varchar(100) DEFAULT NULL,
  `set_lct_time` varchar(100) DEFAULT NULL,
  `generate_or_scan` varchar(100) DEFAULT NULL,
  `no_of_prints` varchar(100) DEFAULT NULL,
  `print_type` varchar(45) DEFAULT NULL,
  `set_ect2` varchar(45) DEFAULT NULL,
  `set_ect_time2` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings_master`
--

INSERT INTO `settings_master` VALUES ('Model1','0.080','1.000','2','1','10.00 mA','0.000','0.000','2','2','2','2','0','0','0','0.800','3.000');

--
-- Table structure for table `settings_vendor`
--

CREATE TABLE `settings_vendor` (
  `vendor_code` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings_vendor`
--


--
-- Table structure for table `test_result`
--

CREATE TABLE `test_result` (
  `model_no` varchar(1000) NOT NULL,
  `serial_no` varchar(1000) NOT NULL,
  `date_time` datetime NOT NULL,
  `operator` varchar(1000) NOT NULL,
  `set_ect_ohms` varchar(50) DEFAULT NULL,
  `set_ect_time` varchar(20) DEFAULT NULL,
  `read_ect_ohms` varchar(50) DEFAULT NULL,
  `read_ect_current` varchar(45) DEFAULT NULL,
  `ect_result` varchar(4) DEFAULT NULL,
  `set_ect_ohms2` varchar(50) DEFAULT NULL,
  `set_ect_time2` varchar(20) DEFAULT NULL,
  `read_ect_ohms2` varchar(50) DEFAULT NULL,
  `read_ect_current2` varchar(45) DEFAULT NULL,
  `ect_result2` varchar(4) DEFAULT NULL,
  `set_hv_kv` varchar(50) DEFAULT NULL,
  `set_hv_ma` varchar(50) DEFAULT NULL,
  `set_hv_time` varchar(20) DEFAULT NULL,
  `read_hv_kv` varchar(50) DEFAULT NULL,
  `read_hv_ma` varchar(45) DEFAULT NULL,
  `hv_result` varchar(4) DEFAULT NULL,
  `set_ir_mohms` varchar(50) DEFAULT NULL,
  `set_ir_time` varchar(20) DEFAULT NULL,
  `read_ir_mohms` varchar(50) DEFAULT NULL,
  `ir_result` varchar(4) DEFAULT NULL,
  `set_lct_ma` varchar(50) DEFAULT NULL,
  `set_lct_time` varchar(20) DEFAULT NULL,
  `read_lct_ln_lowvtg_ma` varchar(50) DEFAULT NULL,
  `read_lct_ln_vtg_v` varchar(45) DEFAULT NULL,
  `lct_ln_lowvtg_result` varchar(4) DEFAULT NULL,
  `read_lct_nl_ma` varchar(50) DEFAULT NULL,
  `read_lct_nl_vtg_v` varchar(45) DEFAULT NULL,
  `lct_nl_result` varchar(4) DEFAULT NULL,
  `performance_result` varchar(45) DEFAULT NULL,
  `set_wattage_lower` varchar(50) DEFAULT NULL,
  `set_wattage_upper` varchar(50) DEFAULT NULL,
  `read_voltage` varchar(50) DEFAULT NULL,
  `read_current` varchar(50) DEFAULT NULL,
  `read_wattage` varchar(50) DEFAULT NULL,
  `result` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `test_result`
--

INSERT INTO `test_result` VALUES ('Model1','N.A.','2022-11-26 15:12:27','scr','0.080 Ohms','3 Sec','-',NULL,'-','0.500 Ohms','3 Sec','-',NULL,'-','1.000 kV','2 mA','3 Sec','-','-','-','1 MOhms','3 Sec','-','-','10.000 mA','3 Sec','-','-','-','-','-','-','-','0 kW','0 kW','-','-','-','Stop'),('Model1','N.A.','2022-11-26 15:12:49','scr','0.080 Ohms','3 Sec','-',NULL,'-','0.500 Ohms','3 Sec','-',NULL,'-','1.000 kV','2 mA','3 Sec','-','-','-','1 MOhms','3 Sec','-','-','10.000 mA','3 Sec','-','-','-','-','-','-','-','0 kW','0 kW','-','-','-','Stop'),('Model1','N.A.','2022-11-26 15:29:14','scr','0.080 Ohms','3 Sec','0.134 Ohms',NULL,'Pass','> LIMIT','3 Sec','-',NULL,'Fail','1.000 kV','2 mA','3 Sec','-','-','-','1 MOhms','3 Sec','-','-','10.000 mA','3 Sec','-','-','-','-','-','-','-','0 kW','0 kW','-','-','-','Fail'),('Model1','N.A.','2022-11-26 15:29:58','scr','0.080 Ohms','3 Sec','0.400 Ohms',NULL,'Fail','0.500 Ohms','3 Sec','-',NULL,'-','1.000 kV','2 mA','3 Sec','-','-','-','1 MOhms','3 Sec','-','-','10.000 mA','3 Sec','-','-','-','-','-','-','-','0 kW','0 kW','-','-','-','Fail'),('Model1','abc0004','2022-11-26 15:31:19','scr','0.080 Ohms','3 Sec','0.138 Ohms',NULL,'Pass','0.071 Ohms','3 Sec','-',NULL,'Pass','1.000 kV','2 mA','3 Sec','0.000 kV','< 2 mA','Pass','1 MOhms','3 Sec','> LIMIT','Pass','10.000 mA','3 Sec','0.011 mA','0.0 V','Pass','0.064 mA','0.0 V','Pass','-','0 kW','0 kW','-','0.000 A','0.00 kW','Pass'),('Model1','abc0005','2022-11-26 16:16:19','scr','0.080 Ohms','3 Sec','0.136 Ohms',NULL,'Pass','0.067 Ohms','3 Sec','-',NULL,'Pass','1.000 kV','2 mA','3 Sec','0.000 kV','< 2 mA','Pass','1 MOhms','3 Sec','-','-','10.000 mA','3 Sec','-','-','-','-','-','-','-','0 kW','0 kW','-','-','-','Pass'),('Model1','abc0006','2022-11-26 16:19:15','scr','0.080 Ohms','3 Sec','0.135 Ohms',NULL,'Pass','0.070 Ohms','3 Sec','-',NULL,'Pass','1.000 kV','2 mA','3 Sec','0.000 kV','< 2 mA','Pass','1 MOhms','3 Sec','> LIMIT','Pass','10.000 mA','3 Sec','-','-','-','-','-','-','-','0 kW','0 kW','-','-','-','Pass'),('Model1','abc0007','2022-11-26 16:44:20','scr','0.080 Ohms','2 Sec','0.089 Ohms',NULL,'Pass','0.069 Ohms','3 Sec','-',NULL,'Pass','1.000 kV','5 mA','2 Sec','0.989 kV','< 5 mA','Pass','2 MOhms','2 Sec','> LIMIT','Pass','10.000 mA','2 Sec','-','-','-','-','-','-','-','0 kW','0 kW','-','-','-','Pass'),('Model1','abc0008','2022-11-26 16:45:01','scr','0.080 Ohms','2 Sec','< LIMIT',NULL,'Pass','0.069 Ohms','3 Sec','-',NULL,'Pass','1.000 kV','5 mA','2 Sec','1.003 kV','< 5 mA','Pass','2 MOhms','2 Sec','> LIMIT','Pass','10.000 mA','2 Sec','-','-','-','-','-','-','-','0 kW','0 kW','-','-','-','Pass'),('Model1','abc0009','2022-11-26 16:50:44','scr','0.080 Ohms','2 Sec','0.119 Ohms',NULL,'Pass','0.800 Ohms','3 Sec','0.066 Ohms',NULL,'Pass','1.000 kV','5 mA','2 Sec','0.974 kV','< 5 mA','Pass','2 MOhms','2 Sec','> LIMIT','Pass','10.000 mA','2 Sec','-','-','-','-','-','-','-','0 kW','0 kW','-','-','-','Pass');


