CREATE DATABASE IF NOT EXISTS test;
use test;
DROP TABLE IF EXISTS CCB_CI_SER;
CREATE TABLE CCB_CI_SER ( `HDDSNENDDATE` varchar(26) DEFAULT NULL, `HDDSN` char(12) DEFAULT '12345678', `ENDDATE` bigint(14) DEFAULT '0', `PROCID` smallint(4) DEFAULT '0', `DRIVEMODEL` char(4) DEFAULT 'AAAA', `PFCODE` varchar(4) DEFAULT '', `TESTCODE` char(8) DEFAULT '', `TESTCODEC` char(7) DEFAULT '', `TESTCODESuff` char(1) DEFAULT NULL, `MFGID` char(6) DEFAULT '', `MFGID_1` char(1) DEFAULT '', `MFGID_2` char(1) DEFAULT '', `MFGID_3` char(1) DEFAULT '', `MFGID_4` char(1) DEFAULT '', `MFGID_5` char(1) DEFAULT '', `HDDTRIAL` char(4) DEFAULT '', `AETYPE` varchar(14) DEFAULT '', `HDCTYPE` varchar(24) DEFAULT '', `CMDNAME` varchar(8) DEFAULT '', `QUALIFIER` varchar(8) DEFAULT 'N/A', `LHD` smallint(2) DEFAULT '0', `MCSBVer` smallint(3) DEFAULT NULL, `PHD` smallint(2) DEFAULT NULL, `SubQualifier` varchar(16) DEFAULT NULL, `BAND` int(3) DEFAULT '0', `Cylinder` bigint(20) DEFAULT NULL, `NumRead` bigint(20) DEFAULT NULL, `NumError` bigint(20) DEFAULT NULL, `SER` float DEFAULT NULL, `Offset` smallint(6) DEFAULT NULL, `Sigma` bigint(20) DEFAULT NULL, `Range` bigint(20) DEFAULT NULL, `Average` float DEFAULT NULL, `AvePerBand` float DEFAULT NULL, `MaxPerBand` float DEFAULT NULL, `MinPerBand` float DEFAULT NULL, `StdPerBand` float DEFAULT NULL, `RngPerBand` float DEFAULT NULL, `AtiNthWorstLocationPercentX100` int(11) DEFAULT NULL, `AtiDeltaWorstLocationPercentX100` int(11) DEFAULT NULL, `RawModulationStats0_Average` float DEFAULT NULL, `RawModulationStats0_Max` float DEFAULT NULL, `RawModulationStats0_Min` float DEFAULT NULL, `RawModulationStats0_Std` float DEFAULT NULL, `RawModulationStats0_Skew` float DEFAULT NULL, `RawModulationStats0_Kurt` float DEFAULT NULL, `RawModulationStats1_Average` float DEFAULT NULL, `RawModulationStats1_Max` float DEFAULT NULL, `RawModulationStats1_Min` float DEFAULT NULL, `RawModulationStats1_Std` float DEFAULT NULL, `RawModulationStats1_Skew` float DEFAULT NULL, `RawModulationStats1_Kurt` float DEFAULT NULL, `RawModulationStats2_Average` float DEFAULT NULL, `RawModulationStats2_Max` float DEFAULT NULL, `RawModulationStats2_Min` float DEFAULT NULL, `RawModulationStats2_Std` float DEFAULT NULL, `RawModulationStats2_Skew` float DEFAULT NULL, `RawModulationStats2_Kurt` float DEFAULT NULL, `Remove1stHarmonicStats0_Average` float DEFAULT NULL, `Remove1stHarmonicStats0_Max` float DEFAULT NULL, `Remove1stHarmonicStats0_Min` float DEFAULT NULL, `Remove1stHarmonicStats0_Std` float DEFAULT NULL, `Remove1stHarmonicStats0_Skew` float DEFAULT NULL, `Remove1stHarmonicStats0_Kurt` float DEFAULT NULL, `Remove1stHarmonicStats1_Average` float DEFAULT NULL, `Remove1stHarmonicStats1_Max` float DEFAULT NULL, `Remove1stHarmonicStats1_Min` float DEFAULT NULL, `Remove1stHarmonicStats1_Std` float DEFAULT NULL, `Remove1stHarmonicStats1_Skew` float DEFAULT NULL, `Remove1stHarmonicStats1_Kurt` float DEFAULT NULL, `Remove1stHarmonicStats2_Average` float DEFAULT NULL, `Remove1stHarmonicStats2_Max` float DEFAULT NULL, `Remove1stHarmonicStats2_Min` float DEFAULT NULL, `Remove1stHarmonicStats2_Std` float DEFAULT NULL, `Remove1stHarmonicStats2_Skew` float DEFAULT NULL, `Remove1stHarmonicStats2_Kurt` float DEFAULT NULL, `FirstHarmonicMagnitude_0` int(11) DEFAULT NULL, `FirstHarmonicMagnitude_1` int(11) DEFAULT NULL )ENGINE=ColumnStore;
