Ниже приведён полный DDL-скрипт для создания таблицы models. Это справочный листинг схемы, используемой для хранения модели и связанных расчётных параметров.
CREATE TABLE `models` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name_id` int(11) NOT NULL,
`bar_id` int(11) DEFAULT NULL,
`Alg` smallint(6) DEFAULT NULL,
`alt_old` smallint(6) DEFAULT NULL,
`alt` smallint(6) DEFAULT NULL,
`_points` varchar(64) DEFAULT NULL,
`G1` varchar(32) DEFAULT NULL,
`v` varchar(20) DEFAULT NULL,
`_2` smallint(6) DEFAULT NULL,
`_3` smallint(6) DEFAULT NULL,
`t1` smallint(6) DEFAULT NULL,
`t2` smallint(6) DEFAULT NULL,
`t2'` smallint(6) DEFAULT NULL,
`t3` smallint(6) DEFAULT NULL,
`t3-` smallint(6) DEFAULT NULL,
`t3'` smallint(6) DEFAULT NULL,
`t3'мп` smallint(6) DEFAULT NULL,
`t3'мп5'` smallint(6) DEFAULT NULL,
`t4` smallint(6) DEFAULT NULL,
`t5` smallint(6) DEFAULT NULL,
`t5'` smallint(6) DEFAULT NULL,
`t5"` smallint(6) DEFAULT NULL,
`t3"` smallint(6) DEFAULT NULL,
`A2Prev` smallint(6) DEFAULT NULL,
`AUX` varchar(32) DEFAULT NULL,
`AimsBlock5'` varchar(32) DEFAULT NULL,
`AUX5'` varchar(32) DEFAULT NULL,
`SP` varchar(32) DEFAULT NULL,
`_CT` varchar(32) DEFAULT NULL,
`_cross_point` varchar(64) DEFAULT NULL,
`calcP6` varchar(32) DEFAULT NULL,
`calcP6t` varchar(32) DEFAULT NULL,
`auxP6` varchar(32) DEFAULT NULL,
`auxP6t` varchar(32) DEFAULT NULL,
`auxP6'` varchar(32) DEFAULT NULL,
`auxP6't` varchar(32) DEFAULT NULL,
`calcP6"` varchar(32) DEFAULT NULL,
`calcP6"t` varchar(32) DEFAULT NULL,
`PREVdata` varchar(32) DEFAULT NULL,
`E1` varchar(32) DEFAULT NULL,
`t1p` smallint(6) DEFAULT NULL,
`t2p` smallint(6) DEFAULT NULL,
`t3p` smallint(6) DEFAULT NULL,
`t4p` smallint(6) DEFAULT NULL,
`confirmT1p` smallint(6) DEFAULT NULL,
`E3` varchar(32) DEFAULT NULL,
`G3` varchar(32) DEFAULT NULL,
`E4` varchar(32) DEFAULT NULL,
`conf_t4` smallint(6) DEFAULT NULL,
`E6` varchar(32) DEFAULT NULL,
`_cross_point2` varchar(64) DEFAULT NULL,
`SPc` varchar(20) DEFAULT NULL,
`EAMP3` varchar(32) DEFAULT NULL,
`auxP3` varchar(32) DEFAULT NULL,
`P3` varchar(32) DEFAULT NULL,
`Par25prcnt` varchar(32) DEFAULT NULL,
`lvl32'to2'6` varchar(32) DEFAULT NULL,
`lvl32'to2'6aux` varchar(32) DEFAULT NULL,
`lvl34to46` varchar(32) DEFAULT NULL,
`lvl34to46aux` varchar(32) DEFAULT NULL,
`ll2'5to56` varchar(32) DEFAULT NULL,
`ll2'5to56aux` varchar(20) DEFAULT NULL,
`EAM5"` varchar(32) DEFAULT NULL,
`abs5` varchar(32) DEFAULT NULL,
`draw_flag` smallint(6) DEFAULT NULL,
`_cross_p23` varchar(32) DEFAULT NULL,
`ll2'3#5` varchar(32) DEFAULT NULL,
`ll2'3#56` varchar(32) DEFAULT NULL,
`lvl3#2'6` varchar(32) DEFAULT NULL,
`lvl3#46` varchar(32) DEFAULT NULL,
`ll2'3#56aux` varchar(32) DEFAULT NULL,
`lvl23#45` varchar(32) DEFAULT NULL,
`lvl23to45` varchar(32) DEFAULT NULL,
`lvl45to25` varchar(32) DEFAULT NULL,
`ParE` varchar(20) DEFAULT NULL,
`fixed_at` smallint(6) DEFAULT NULL,
`max_bar` smallint(6) DEFAULT NULL,
`G1_sd` smallint(6) DEFAULT NULL,
`bad` tinyint(4) DEFAULT NULL,
`P6Context` varchar(32) DEFAULT NULL,
`P6"Context` varchar(32) DEFAULT NULL,
`auxP6Context` varchar(32) DEFAULT NULL,
`auxP6'Context` varchar(32) DEFAULT NULL,
`CountPrevs` varchar(32) DEFAULT NULL,
`Clst_I` smallint(6) DEFAULT NULL,
`Clst_II` smallint(6) DEFAULT NULL,
`Clst_A` smallint(6) DEFAULT NULL,
`Clst_I_E` smallint(6) DEFAULT NULL,
`Clst_II_E` smallint(6) DEFAULT NULL,
`Clst_A_E` smallint(6) DEFAULT NULL,
`Clst_I"` smallint(6) DEFAULT NULL,
`Clst_II"` smallint(6) DEFAULT NULL,
`Clst_A"` smallint(6) DEFAULT NULL,
`Clst_I_E"` smallint(6) DEFAULT NULL,
`Clst_II_E"` smallint(6) DEFAULT NULL,
`Clst_A_E"` smallint(6) DEFAULT NULL,
`Clst_I_AuxP6` smallint(6) DEFAULT NULL,
`Clst_II_AuxP6` smallint(6) DEFAULT NULL,
`Clst_A_AuxP6` smallint(6) DEFAULT NULL,
`Clst_I_E_AuxP6` smallint(6) DEFAULT NULL,
`Clst_II_E_AuxP6` smallint(6) DEFAULT NULL,
`Clst_A_E_AuxP6` smallint(6) DEFAULT NULL,
`Clst_I_AuxP6'` smallint(6) DEFAULT NULL,
`Clst_II_AuxP6'` smallint(6) DEFAULT NULL,
`Clst_A_AuxP6'` smallint(6) DEFAULT NULL,
`Clst_I_E_AuxP6'` smallint(6) DEFAULT NULL,
`Clst_II_E_AuxP6'` smallint(6) DEFAULT NULL,
`Clst_A_E_AuxP6'` smallint(6) DEFAULT NULL,
`_ll25apprP6` varchar(32) DEFAULT NULL,
`_ll25apprP6"` varchar(32) DEFAULT NULL,
`_ll25apprAuxP6` varchar(32) DEFAULT NULL,
`_ll25apprAuxP6'` varchar(32) DEFAULT NULL,
`TLexs13'` enum('clear','cls','exs') DEFAULT NULL,
`TLexs3'4` enum('clear','cls','exs') DEFAULT NULL,
`ALexs12'` enum('clear','cls','exs') DEFAULT NULL,
`ALexs2'4` enum('clear','cls','exs') DEFAULT NULL,
`auxTLexs` enum('clear','cls','exs') DEFAULT NULL,
`auxALexs` enum('clear','cls','exs') DEFAULT NULL,
`ContextClstI` smallint(6) DEFAULT NULL,
`ContextClstII` smallint(6) DEFAULT NULL,
`ContextClstI_E` smallint(6) DEFAULT NULL,
`ContextClstII_E` smallint(6) DEFAULT NULL,
`ContextClstI"` smallint(6) DEFAULT NULL,
`ContextClstII"` smallint(6) DEFAULT NULL,
`ContextClstI_E"` smallint(6) DEFAULT NULL,
`ContextClstII_E"` smallint(6) DEFAULT NULL,
`ContextClstI_AuxP6` smallint(6) DEFAULT NULL,
`ContextClstII_AuxP6` smallint(6) DEFAULT NULL,
`ContextClstI_E_AuxP6` smallint(6) DEFAULT NULL,
`ContextClstII_E_AuxP6` smallint(6) DEFAULT NULL,
`ContextClstI_AuxP6'` smallint(6) DEFAULT NULL,
`ContextClstII_AuxP6'` smallint(6) DEFAULT NULL,
`ContextClstI_E_AuxP6'` smallint(6) DEFAULT NULL,
`ContextClstII_E_AuxP6'` smallint(6) DEFAULT NULL,
`PrevType` varchar(32) DEFAULT NULL,
`PrevG3` varchar(32) DEFAULT NULL,
`PrevSPc` varchar(20) DEFAULT NULL,
`PrevSP` varchar(32) DEFAULT NULL,
`P6ContextOfP6` varchar(32) DEFAULT NULL,
`P6ContextOfAuxP6` varchar(32) DEFAULT NULL,
`auxP6ContextOfP6` varchar(32) DEFAULT NULL,
`auxP6ContextOfAuxP6` varchar(32) DEFAULT NULL,
`auxP6'ContextOfP6` varchar(32) DEFAULT NULL,
`auxP6'ContextOfAuxP6` varchar(32) DEFAULT NULL,
`TLSpeedEAM` varchar(32) DEFAULT NULL,
`SpeedEAM` varchar(32) DEFAULT NULL,
`TLSpeedEAM5"` varchar(32) DEFAULT NULL,
`SpeedEAM5"` varchar(32) DEFAULT NULL,
`TLSpeedAux` varchar(32) DEFAULT NULL,
`SpeedAux` varchar(32) DEFAULT NULL,
`TLSpeedAux5'` varchar(32) DEFAULT NULL,
`SpeedAux5'` varchar(32) DEFAULT NULL,
`TLSpeedMain` varchar(32) DEFAULT NULL,
`SpeedMain` varchar(32) DEFAULT NULL,
`MainSize` varchar(32) DEFAULT NULL,
`MainSizeT` varchar(16) DEFAULT NULL,
`AuxSize` varchar(32) DEFAULT NULL,
`AuxSizeT` varchar(16) DEFAULT NULL,
`AuxSize'` varchar(32) DEFAULT NULL,
`AuxSizeT'` varchar(16) DEFAULT NULL,
`EAMSize` varchar(32) DEFAULT NULL,
`EAMSizeT` varchar(16) DEFAULT NULL,
`EAMSize"` varchar(32) DEFAULT NULL,
`EAMSizeT"` varchar(16) DEFAULT NULL,
`pips` varchar(32) DEFAULT NULL,
`_llapprP6` float DEFAULT NULL,
`_llapprP6"` float DEFAULT NULL,
`_llapprAuxP6` float DEFAULT NULL,
`_llapprAuxP6'` float DEFAULT NULL,
`_ll4apprP6` float DEFAULT NULL,
`_ll4apprP6"` float DEFAULT NULL,
`_ll4apprAuxP6` float DEFAULT NULL,
`_ll4apprAuxP6'` float DEFAULT NULL,
`_lvlapprP6` float DEFAULT NULL,
`_lvlapprP6"` float DEFAULT NULL,
`_lvlapprAuxP6` float DEFAULT NULL,
`_lvlapprAuxP6'` float DEFAULT NULL,
`_llapprP6ba` tinyint(4) DEFAULT NULL,
`_llapprP6"ba` tinyint(4) DEFAULT NULL,
`_llapprAuxP6ba` tinyint(4) DEFAULT NULL,
`_llapprAuxP6'ba` tinyint(4) DEFAULT NULL,
`_lvlapprP6half` float DEFAULT NULL,
`_lvlapprP6"half` float DEFAULT NULL,
`_lvlapprAuxP6half` float DEFAULT NULL,
`_lvlapprAuxP6'half` float DEFAULT NULL,
`_llapprP6halfba` tinyint(4) DEFAULT NULL,
`_llapprP6"halfba` tinyint(4) DEFAULT NULL,
`_llapprAuxP6halfba` tinyint(4) DEFAULT NULL,
`_llapprAuxP6'halfba` tinyint(4) DEFAULT NULL,
`_lvlapprP6halfba` float DEFAULT NULL,
`_lvlapprP6"halfba` float DEFAULT NULL,
`_lvlapprAuxP6halfba` float DEFAULT NULL,
`_lvlapprAuxP6'halfba` float DEFAULT NULL,
`p5lvlP6` float DEFAULT NULL,
`p4lvlP6` float DEFAULT NULL,
`p3_lvlP6` float DEFAULT NULL,
`p2_lvlP6` float DEFAULT NULL,
`p1lvlP6` float DEFAULT NULL,
`p5llP6` float DEFAULT NULL,
`p4llP6` float DEFAULT NULL,
`p3_llP6` float DEFAULT NULL,
`p2_llP6` float DEFAULT NULL,
`p1llP6` float DEFAULT NULL,
`p5lvlAuxP6` float DEFAULT NULL,
`p4lvlAuxP6` float DEFAULT NULL,
`p3_lvlAuxP6` float DEFAULT NULL,
`p2_lvlAuxP6` float DEFAULT NULL,
`p1lvlAuxP6` float DEFAULT NULL,
`p5llAuxP6` float DEFAULT NULL,
`p4llAuxP6` float DEFAULT NULL,
`p3_llAuxP6` float DEFAULT NULL,
`p2_llAuxP6` float DEFAULT NULL,
`p1llAuxP6` float DEFAULT NULL,
`p5'lvlAuxP6'` float DEFAULT NULL,
`p4lvlAuxP6'` float DEFAULT NULL,
`p3_lvlAuxP6'` float DEFAULT NULL,
`p2_lvlAuxP6'` float DEFAULT NULL,
`p1lvlAuxP6'` float DEFAULT NULL,
`p5'llAuxP6'` float DEFAULT NULL,
`p4llAuxP6'` float DEFAULT NULL,
`p3_llAuxP6'` float DEFAULT NULL,
`p2_llAuxP6'` float DEFAULT NULL,
`p1llAuxP6'` float DEFAULT NULL,
`p5"lvlP6"` float DEFAULT NULL,
`p4lvlP6"` float DEFAULT NULL,
`p3_lvlP6"` float DEFAULT NULL,
`p2_lvlP6"` float DEFAULT NULL,
`p1lvlP6"` float DEFAULT NULL,
`p5"llP6"` float DEFAULT NULL,
`p4llP6"` float DEFAULT NULL,
`p3_llP6"` float DEFAULT NULL,
`p2_llP6"` float DEFAULT NULL,
`p1llP6"` float DEFAULT NULL,
`pst_apprP6bmp` float DEFAULT NULL,
`pst_apprP6"bmp` float DEFAULT NULL,
`pst_apprAuxP6bmp` float DEFAULT NULL,
`pst_apprAuxP6'bmp` float DEFAULT NULL,
`pst_P6bmp` float DEFAULT NULL,
`pst_P6"bmp` float DEFAULT NULL,
`pst_AuxP6bmp` float DEFAULT NULL,
`pst_AuxP6'bmp` float DEFAULT NULL,
`pst_P4_P6bmp` float DEFAULT NULL,
`pst_P4_P6"bmp` float DEFAULT NULL,
`pst_P4_AuxP6bmp` float DEFAULT NULL,
`pst_P4_AuxP6'bmp` float DEFAULT NULL,
`pstex_conf_RP6` smallint(6) DEFAULT NULL,
`pstex_conf_RP6"` smallint(6) DEFAULT NULL,
`pstex_conf_RAuxP6` smallint(6) DEFAULT NULL,
`pstex_conf_RAuxP6'` smallint(6) DEFAULT NULL,
`pstex_RP6bmp` smallint(6) DEFAULT NULL,
`pstex_RP6"bmp` smallint(6) DEFAULT NULL,
`pstex_RAuxP6bmp` smallint(6) DEFAULT NULL,
`pstex_RAuxP6'bmp` smallint(6) DEFAULT NULL,
`llconf_t4P6` float DEFAULT NULL,
`llconf_t4P6"` float DEFAULT NULL,
`llconf_t4AuxP6` float DEFAULT NULL,
`llconf_t4AuxP6'` float DEFAULT NULL,
`p4xPreapP6` tinyint(4) DEFAULT NULL,
`p4xPreapP6"` tinyint(4) DEFAULT NULL,
`p4xPreapAuxP6` tinyint(4) DEFAULT NULL,
`p4xPreapAuxP6'` tinyint(4) DEFAULT NULL,
`_c4preapALP6` tinyint(4) DEFAULT NULL,
`_c4preapALP6"` tinyint(4) DEFAULT NULL,
`_c4preapALAuxP6` tinyint(4) DEFAULT NULL,
`_c4preapALAuxP6'` tinyint(4) DEFAULT NULL,
`_llc4preapALP6` smallint(6) DEFAULT NULL,
`_llc4preapALP6"` smallint(6) DEFAULT NULL,
`_llc4preapALAuxP6` smallint(6) DEFAULT NULL,
`_llc4preapALAuxP6'` smallint(6) DEFAULT NULL,
`_lvlconf4ALP6` float DEFAULT NULL,
`_lvlconf4ALP6"` float DEFAULT NULL,
`_lvlconf4ALAuxP6` float DEFAULT NULL,
`_lvlconf4ALAuxP6'` float DEFAULT NULL,
`_llALapP6` smallint(6) DEFAULT NULL,
`_llALapP6"` smallint(6) DEFAULT NULL,
`_llALapAuxP6` smallint(6) DEFAULT NULL,
`_llALapAuxP6'` smallint(6) DEFAULT NULL,
`_lvlALapP6` float DEFAULT NULL,
`_lvlALapP6"` float DEFAULT NULL,
`_lvlALapAuxP6` float DEFAULT NULL,
`_lvlALapAuxP6'` float DEFAULT NULL,
`_llALP6` smallint(6) DEFAULT NULL,
`_llALP6"` smallint(6) DEFAULT NULL,
`_llALAuxP6` smallint(6) DEFAULT NULL,
`_llALAuxP6'` smallint(6) DEFAULT NULL,
`_lvlALP6` float DEFAULT NULL,
`_lvlALP6"` float DEFAULT NULL,
`_lvlALAuxP6` float DEFAULT NULL,
`_lvlALAuxP6'` float DEFAULT NULL,
`_ALcorP6` tinyint(4) DEFAULT NULL,
`_ALcorP6"` tinyint(4) DEFAULT NULL,
`_ALcorAuxP6` tinyint(4) DEFAULT NULL,
`_ALcorAuxP6'` tinyint(4) DEFAULT NULL,
`_llALcorsizeP6` smallint(6) DEFAULT NULL,
`_llALcorsizeP6"` smallint(6) DEFAULT NULL,
`_llALcorsizeAuxP6` smallint(6) DEFAULT NULL,
`_llALcorsizeAuxP6'` smallint(6) DEFAULT NULL,
`_lvlALcorsizeP6` float DEFAULT NULL,
`_lvlALcorsizeP6"` float DEFAULT NULL,
`_lvlALcorsizeAuxP6` float DEFAULT NULL,
`_lvlALcorsizeAuxP6'` float DEFAULT NULL,
`_llALcordistP6` smallint(6) DEFAULT NULL,
`_llALcordistP6"` smallint(6) DEFAULT NULL,
`_llALcordistAuxP6` smallint(6) DEFAULT NULL,
`_llALcordistAuxP6'` smallint(6) DEFAULT NULL,
`_lvlALcordistP6` float DEFAULT NULL,
`_lvlALcordistP6"` float DEFAULT NULL,
`_lvlALcordistAuxP6` float DEFAULT NULL,
`_lvlALcordistAuxP6'` float DEFAULT NULL,
`_llALcorposP6` smallint(6) DEFAULT NULL,
`_llALcorposP6"` smallint(6) DEFAULT NULL,
`_llALcorposAuxP6` smallint(6) DEFAULT NULL,
`_llALcorposAuxP6'` smallint(6) DEFAULT NULL,
`_lvlALcorposP6` float DEFAULT NULL,
`_lvlALcorposP6"` float DEFAULT NULL,
`_lvlALcorposAuxP6` float DEFAULT NULL,
`_lvlALcorposAuxP6'` float DEFAULT NULL,
`_P6proto` tinyint(4) DEFAULT NULL,
`_P6"proto` tinyint(4) DEFAULT NULL,
`_AuxP6proto` tinyint(4) DEFAULT NULL,
`_AuxP6'proto` tinyint(4) DEFAULT NULL,
`_llprotosizeP6` float DEFAULT NULL,
`_llprotosizeP6"` float DEFAULT NULL,
`_llprotosizeAuxP6` float DEFAULT NULL,
`_llprotosizeAuxP6'` float DEFAULT NULL,
`_lvlprotosizeP6` float DEFAULT NULL,
`_lvlprotosizeP6"` float DEFAULT NULL,
`_lvlprotosizeAuxP6` float DEFAULT NULL,
`_lvlprotosizeAuxP6'` float DEFAULT NULL,
`_llprotoposP6` float DEFAULT NULL,
`_llprotoposP6"` float DEFAULT NULL,
`_llprotoposAuxP6` float DEFAULT NULL,
`_llprotoposAuxP6'` float DEFAULT NULL,
`_lvlprotoposP6` float DEFAULT NULL,
`_lvlprotoposP6"` float DEFAULT NULL,
`_lvlprotoposAuxP6` float DEFAULT NULL,
`_lvlprotoposAuxP6'` float DEFAULT NULL,
`pst_llRP6pos` float DEFAULT NULL,
`pst_llRP6"pos` float DEFAULT NULL,
`pst_llRAuxP6pos` float DEFAULT NULL,
`pst_llRAuxP6'pos` float DEFAULT NULL,
`pst_llRP6prfll` float DEFAULT NULL,
`pst_llRP6"prfll` float DEFAULT NULL,
`pst_llRAuxP6prfll` float DEFAULT NULL,
`pst_llRAuxP6'prfll` float DEFAULT NULL,
`pst_lvlRP6prfll` float DEFAULT NULL,
`pst_lvlRP6"prfll` float DEFAULT NULL,
`pst_lvlRAuxP6prfll` float DEFAULT NULL,
`pst_lvlRAuxP6'prfll` float DEFAULT NULL,
`pst_conf_RP6` float DEFAULT NULL,
`pst_conf_RP6"` float DEFAULT NULL,
`pst_conf_RAuxP6` float DEFAULT NULL,
`pst_conf_RAuxP6'` float DEFAULT NULL,
`pst_lead_RP6` float DEFAULT NULL,
`pst_lead_RP6"` float DEFAULT NULL,
`pst_lead_RAuxP6` float DEFAULT NULL,
`pst_lead_RAuxP6'` float DEFAULT NULL,
`pst_leadsize_RP6` float DEFAULT NULL,
`pst_leadsize_RP6"` float DEFAULT NULL,
`pst_leadsize_RAuxP6` float DEFAULT NULL,
`pst_leadsize_RAuxP6'` float DEFAULT NULL,
`pst_RP6fall` float DEFAULT NULL,
`pst_RP6"fall` float DEFAULT NULL,
`pst_RAuxP6fall` float DEFAULT NULL,
`pst_RRAuxP6'fall` float DEFAULT NULL,
`pst_RP6fallsize` float DEFAULT NULL,
`pst_RP6"fallsize` float DEFAULT NULL,
`pst_RAuxP6fallsize` float DEFAULT NULL,
`pst_RRAuxP6'fallsize` float DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `points` (`name_id`,`Alg`,`_points`,`bar_id`),
KEY `bar_id` (`bar_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;