CREATE TABLE if not exists hr ( serial text , dt text , Standby text --0 0-1 P04 , OutputConfigId text --1 0-3 P01 , ChargeConfigId text --2 0-2 P14 , ACInModelId text --8 0-2 P03 , OutputVoltTypeId text --9 0-6 P08 , MaxChargeCurr num --34 A P02 , BulkChargeVolt num --35 0.1V P19 , FloatChargeVolt num --36 0.1V P20 , BatLowToUtiVolt num --37 0.1V P12 , ACChargeCurr num --38 0.1V P11 , BatteryTypeId text --39 0-4 P05 , Uti2BatVolt num --95 0.1V P13 , PRIMARY KEY(serial, dt) )
insert into hr values( 'UKDGBMF010', '2025-07-07 16:59:06' ,1 ,'1' ,'1' ,'1' ,'6' ,49 ,28.2 ,27.6 ,25.6 ,2 ,2 ,27.6 ) Array ( [0] => 0001 [1] => 0001 [2] => 0001 [3] => 0000 [4] => 0000 [5] => 0000 [6] => 0000 [7] => 0000 [8] => 0001 [9] => 3530 [10] => 322e [11] => 3130 [12] => 3030 [13] => 322e [14] => 3037 [15] => 0000 [16] => ffff [17] => 0000 [18] => 0006 [19] => 0001 [20] => 0001 [21] => 0001 [22] => 0001 [23] => 554b [24] => 4447 [25] => 424d [26] => 4630 [27] => 3130 [28] => 0000 [29] => 0000 [30] => 0001 [31] => 0100 [32] => 0000 [33] => 0000 [34] => 0031 [35] => 011a [36] => 0114 [37] => 0100 [38] => 0002 [39] => 0002 [40] => 0000 [41] => 0000 [42] => 0000 [43] => 4e25 [44] => 0000 [45] => 07e9 [46] => 0007 [47] => 0007 [48] => 0003 [49] => 0028 [50] => 0025 [51] => 0000 [52] => 0000 [53] => 0000 [54] => 0000 [55] => 0000 [56] => 0000 [57] => 0000 [58] => 0000 [59] => 0000 [60] => 0000 [61] => 0000 [62] => 0000 [63] => 0000 [64] => 0000 [65] => 0000 [66] => 0000 [67] => 0000 [68] => 0000 [69] => 0000 [70] => 0000 [71] => 0000 [72] => 0000 [73] => 0000 [74] => 0000 [75] => 0000 [76] => 0000 [77] => 7530 [78] => 0000 [79] => 7530 [80] => 15e3 [81] => 0000 [82] => 00e6 [83] => 0000 [84] => 04b0 [85] => 0258 [86] => 01e0 [87] => 0258 [88] => 012c [89] => 04b0 [90] => 0258 [91] => 0bb8 [92] => 0003 [93] => 0002 [94] => 00e6 [95] => 0114 [96] => 0001 [97] => 0000 [98] => 0000 [99] => 0000 [100] => 0000 [101] => 0000 [102] => 0000 [103] => 0000 [104] => 0001 [105] => ffff [106] => 0002 [107] => 0001 [108] => 0000 [109] => 0002 [110] => 0000 [111] => 0000 [112] => 0000 [113] => 0000 [114] => 0000 [115] => 0000 [116] => 0000 [117] => 0000 [118] => 0000 [119] => 01d6 [120] => 0000 [121] => 0424 [122] => 0000 [123] => 0000 [124] => 0000 [125] => 0000 [126] => 0ab3 [127] => 0064 [128] => 098f [129] => 0000 [130] => 0000 [131] => 04b0 [132] => 1770 [133] => 0000 [134] => 0171 [135] => 017a [136] => 0023 [137] => 0000 [138] => 0000 [139] => 0000 [140] => 0000 [141] => 0000 [142] => 0000 [143] => 0008 [144] => 000f [145] => 0000 [146] => 0000 [147] => 0000 [148] => 0000 [149] => 0000 )