Ðîµç³Ø¼à¿Øƽ̨½¨±í³ÌÐò - Á¬½ÓMySQL 8.X Êý¾Ý¿â³õʼ»¯
|
×¢Òâ:1.ÐÂÔöµçÔ´»ú·¿Ê±ÐèÒªÖØÐÂÔËÐÐ
|
|
Linux ÐèÊÖ¶¯´´½¨Õ˺Å
|
CREATE USER 'whyc'@'localhost' IDENTIFIED BY 'Fg001@hdw';
|
GRANT ALL PRIVILEGES ON *.* TO 'whyc'@'localhost';
|
FLUSH PRIVILEGES;
|
|
|
|
V2.04 edit at date 2024-09-09
|
1.ÐÞ¸´±í 'db_battinf.tb_stattion_inf'±íÖÐ×Ö¶Î'together_flag'ĬÈϳõʼ²åÈëȫΪ0=>½«Îª0µÄ×Ö¶ÎÐÞ¸ÄΪµ±Ç°×î´óÖµ
|
2.±í'db_pwrdev_data_rt.tb_pwrdev_acdcdata'ÐÂÔö×Ö¶Î
|
`m17_out_vol` float NOT NULL DEFAULT '0' COMMENT 'Ä£¿é17Êä³öµçѹ',
|
`m18_out_vol` float NOT NULL DEFAULT '0' COMMENT 'Ä£¿é18Êä³öµçѹ',
|
`m19_out_vol` float NOT NULL DEFAULT '0' COMMENT 'Ä£¿é19Êä³öµçѹ',
|
`m20_out_vol` float NOT NULL DEFAULT '0' COMMENT 'Ä£¿é20Êä³öµçѹ',¡¢
|
3.´´½¨`web_site`.`tb_mac_ukey`±í
|
CREATE TABLE `tb_mac_ukey` (
|
`num` int NOT NULL AUTO_INCREMENT,
|
`uname` varchar(64) NOT NULL DEFAULT '0',
|
`ukey_id` varchar(200) NOT NULL DEFAULT '0' COMMENT 'ukeyid',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
|
|
V2.03 edit at date 2024-07-18
|
1.±í 'db_param.tb_app_param'ÐÂÔö²ÎÊý
|
ÀúʷʵʱÊý¾Ý´æ´¢¼ä¸ô(Ãë)->realdata_SaveDataTimeInterval 60 real-time history data save data interval by seconds
|
ÀúʷʵʱÊý¾Ý´æ´¢¼ä¸ô(Ìì)->realdata_SaveDataTimeMax 90 real-time history data save data max time for batttest data count to insert to mysql server
|
|
2.±í'db_battinf.tb_battinf'ÐÂÔö×Ö¶Î
|
`topology_map_type` int(11) NOT NULL DEFAULT '0' COMMENT 'ÍØÆËͼÀàÐÍ',
|
3.ÐÂÔö±í'db_ram_db.tb_dev6159_power_yc'-ͨÐŵçÔ´ºËÈÝÒ»Ìå»úÒ£²âʵʱ״̬±í
|
4.ÐÂÔö±í'db_ram_db.tb_dev6159_power_yx'-ͨÐŵçÔ´ºËÈÝÒ»Ìå»úÒ£ÐÅʵʱ״̬±í
|
|
V2.02 edit at date 2024-04-30
|
1.ÐÂÔöÖÇÄÜĸÁªÉ豸¶ÔÓ¦Ï̼߳Ǽ
|
11029 - ÖÇÄÜĸÁªÍ¨ÐÅÏß³Ì = BMS_ZNBUSBAR_MONITOR
|
2.ÐÂÔöFBS9800»ã¼¯Ä£¿éͨÐŶÔÓ¦Ï̼߳Ǽ
|
11030 - FBS9800ͨÐÅÏß³Ì = BMS_FBS9800_DISPLAY
|
3.ÐÂÔö±í 'db_rab_db.tb_dev_6185_almparam'
|
CREATE TABLE `tb_dev_6185_almparam` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '×ÔÔöÖ÷¼ü',
|
`dev_id` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸id',
|
`op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '²Ù×÷ÃüÁî',
|
`groupvol_high_val` float NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ¸ßãÐÖµ',
|
`groupvol_low_val` float NOT NULL DEFAULT '0' COMMENT '×é¶ËµçѹµÍãÐÖµ',
|
`monvol_high_val` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìåµçѹ¸ßãÐÖµ',
|
`monvol_low_val` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåµçѹµÍãÐÖµ',
|
`montmp_high_val` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåζȸßãÐÖµ',
|
`montmp_low_val` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåζȵÍãÐÖµ',
|
`monres_high_val` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÄÚ×è¸ßãÐÖµ',
|
`monres_low_val` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÄÚ×èµÍãÐÖµ',
|
`moncap_high_val` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÈÝÁ¿¸ßãÐÖµ',
|
`moncap_low_val` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÈÝÁ¿µÍãÐÖµ',
|
PRIMARY KEY (`num`),
|
UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='bts6185Ïà¹ØÉ豸¸æ¾¯ãÐÖµÒ£µ÷±í';
|
|
V2.01 edit at date 2024-04-25
|
1.ÐÂÔö±í'db_ram_db.tb_intelligentbusbar_state'-ÖÇÄÜĸÁªÊµÊ±×´Ì¬±í
|
CREATE TABLE `tb_intelligentbusbar_state` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '×ÔÔöÖ÷¼ü',
|
`dev_id` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸ID',
|
`record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä',
|
`dcdc1_temp` float NOT NULL DEFAULT '0' COMMENT 'DCDC1_ʵʱζÈ',
|
`dcdc2_temp` float NOT NULL DEFAULT '0' COMMENT 'DCDC2ʵʱζÈ',
|
`dcdc1_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1ʵʱÊä³öµçѹ',
|
`dcdc2_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2ʵʱÊä³öµçѹ',
|
`dcdc1_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1ʵʱÊä³öµçÁ÷',
|
`dcdc2_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC2ʵʱÊä³öµçÁ÷',
|
`dcdc1_inputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1ʵʱÊäÈëµçѹ',
|
`dcdc2_inputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2ʵʱÊäÈëµçѹ',
|
`dcdc1_inputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1ʵʱÊäÈëµçÁ÷',
|
`dcdc2_inputcurr` float unsigned NOT NULL DEFAULT '0' COMMENT 'DCDC1ʵʱÊäÈëµçÁ÷',
|
`dcdc1_errcode` int(11) NOT NULL DEFAULT '0' COMMENT 'DCDC1 Òì³£´úÂë-״̬',
|
`dcdc2_errcode` int(11) NOT NULL DEFAULT '0' COMMENT 'DCDC2 Òì³£´úÂë-״̬',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='ÖÇÄÜĸÁªÊµÊ±×´Ì¬±í';
|
2.±í'db_ram_db.tb_fbs9100_setparam'ÐÂÔö×ֶΠ--ÖÇÄÜĸÁª²ÎÊýÐÅÏ¢
|
`dcdc1_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1Êä³öµçѹ',
|
`dcdc2_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2Êä³öµçѹ',
|
`dcdc1_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1Êä³öÏÞÁ÷Öµ',
|
`dcdc2_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC2Êä³öÏÞÁ÷Öµ',
|
`screensaver_time` int(11) NOT NULL DEFAULT '10' COMMENT '½øÈëÆÁÄ»±£»¤Ê±¼ä£¨²»ÄÜСÓÚ10·ÖÖÓ£©',
|
|
V1.99 edit at date 2024-04-19
|
1.±íÐÂÔö×ֶΠ'web_site.tb_badbatt_mon'ÐÂÔö×Ö¶Î
|
`flag` int(11) DEFAULT '4' 1£ºË𻵣¬2£ºÁÓ»¯£¬3£ºÓÅÐãʱ(note 1)£¬4£¬ÎÞ·¨ÅжÏ
|
1.´´½¨±í 'web_site.tb_badld9_mon' - LD9Âäºóµ¥ÌåÐÅÏ¢±í
|
|
|
|
V1.98 edit at date 2024-04-08
|
1.±í'db_pwrdev_inf.tb_pwrapp_acdcinf'ÐÂÔö×Ö¶Î
|
`ModuleSwitchStatus` varchar(45) DEFAULT '68719476735' COMMENT '¸ßƵ¿ª¹Ø¹ñ½»Á÷Ä£¿éÊÇ·ñÆôÓÃ',
|
2.±í'db_ram.db.tb_fbs9100s_stemnode_state'ÐÂÔö×Ö¶Î,ÓÃÓÚ¶¨ÖÆ°æ±¾¸É½Óµã״̬¶ÁÈ¡
|
`mode_state` int(11) NOT NULL DEFAULT '0' COMMENT 'Ä£¿é×Ü״̬',
|
`drynode_commst` int(11) NOT NULL DEFAULT '43690' COMMENT '¸É½ÓµãͨÐÅ״̬(0xAAAA-Õý³£ 0xBBBB-Òì³£)',
|
`k1_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '½Ó´¥Æ÷k1¼ì²â״̬(0xAAAA-Õý³£ 0xBBBB-Òì³£)',
|
`k2_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '½Ó´¥Æ÷k2¼ì²â״̬(0xAAAA-Õý³£ 0xBBBB-Òì³£)',
|
`urgentswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '¼±Í£×´Ì¬(0xAAAA-δ´¥·¢ 0xBBBB-´¥·¢)',
|
`bypassswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT 'ÅÔ·״̬£¨0xAAAA-δ½ÓÈë 0xBBBB-½ÓÈëÅÔ·£©',
|
`k1_st` int(5) NOT NULL DEFAULT '0' COMMENT '×é1½Ó´¥Æ÷k״̬£¨0-¶Ï¿ª 1-±ÕºÏ£©',
|
`k2_st` int(5) NOT NULL DEFAULT '0' COMMENT '×é2½Ó´¥Æ÷k״̬£¨0-¶Ï¿ª 1-±ÕºÏ£©'
|
|
V1.97 edit at date 2024-03-27
|
1.ÐÂÔöÊý¾Ý±í 'web_site.tb_resset_station'
|
CREATE TABLE `tb_resset_station` (
|
`num` int(11) NOT NULL AUTO_INCREMENT,
|
`stationid` varchar(255) NOT NULL DEFAULT '0' COMMENT '»ú·¿id',
|
`last_start_time` datetime NOT NULL DEFAULT '2024-01-01 00:00:00' COMMENT 'ÉÏ´ÎÆô¶¯Ê±¼ä',
|
`time_interval` float NOT NULL DEFAULT '720' COMMENT 'Æô¶¯Ê±¼ä¼ä¸ô',
|
`enable` int(11) NOT NULL DEFAULT '1' COMMENT 'ÊÇ·ñÉúЧ:1ÉúЧ',
|
PRIMARY KEY (`num`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='»ú·¿ÄÚ×è²âÊԼƻ®ÐÅÏ¢±í';
|
2.Êý¾Ý±í 'web_site.tb_resset_station'ÐÂÔö×Ö¶Î
|
`err_count` int(11) NOT NULL DEFAULT '3' COMMENT '·¢ËÍÃüÁî´íÎó¼ÆÊý[ºǫ́ĬÈÏ3´Î]',
|
3.ÐÂÔöÊý¾Ý¿â'db_nj_measurement'
|
4.ÐÂÔöÊý¾Ý¿â±í 'db_nj_measurement.tb_njhome_config'
|
5.ÐÂÔöÊý¾Ý¿â±í 'db_nj_measurement.db_nj_measurement'
|
|
|
V1.96 edit at date 2024-02-21
|
1.´´½¨Êý¾Ý'db_ied_scout'
|
2.´´½¨±í'db_ied_scout.tb_connect_inf'
|
CREATE TABLE `tb_connect_inf` (
|
`num` bigint(20) NOT NULL COMMENT 'Ö÷¼ü',
|
`target_ip` varchar(255) NOT NULL DEFAULT '127.0.0.1' COMMENT 'Ä¿±êIPµØÖ·',
|
`target_port` int(11) NOT NULL DEFAULT '102' COMMENT 'Ä¿µÄ¶Ë¿ÚºÅ',
|
`target_icd` varchar(255) NOT NULL DEFAULT '' COMMENT 'Ä¿µÄÉ豸icdÎļþ·¾¶',
|
`conn_st` int(11) NOT NULL DEFAULT '0' COMMENT 'Á¬½Ó״̬0-ĬÈÏ 1-¿ªÊ¼Á¬½Ó[ƽ̨ÉèÖÃ] 2-Á¬½ÓÖÐ 3-Á¬½Ó³É¹¦ 4-Á¬½Óʧ°Ü',
|
`fail_reasion` int(11) NOT NULL DEFAULT '0' COMMENT 'ʧ°ÜÔÒò£º0-ÎÞ 1-ICDÎļþ²»´æÔÚ 2-ICDÎļþ²»Æ¥Åä',
|
`comm_num` bigint(20) NOT NULL DEFAULT '0' COMMENT 'ͨÐżÆÊý',
|
`error_num` bigint(20) NOT NULL DEFAULT '0' COMMENT 'ͨÐÅ´íÎó¼ÆÊý',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IED_Scout Á¬½ÓÅäÖÃÐÅÏ¢±í';
|
3.´´½¨±í'db_ied_scout.tb_ied_nodestate'
|
CREATE TABLE `tb_ied_nodestate` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '×ÔÔöÖ÷¼ü',
|
`node_path` varchar(255) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '½Úµã·¾¶',
|
`node_name` varchar(255) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '½ÚµãÖÐÎÄÃû³Æ',
|
`node_value` float NOT NULL DEFAULT '0' COMMENT '½ÚµãÖµ',
|
PRIMARY KEY (`num`),
|
UNIQUE KEY `index_node_path` (`node_path`) USING BTREE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IED Scout ʵʱ״̬ÐÅÏ¢±í';
|
4.±í'web_site.tb_interface'ÐÞ¸Ä×ֶ㤶È(½Ó¿ÚÑéÖ¤Â볤¶ÈÀ©Ôö)
|
interface_number varchar(255) => varchar(1024)
|
5.±í'db_app_sys.tb_app_sys'±í×Ö¶ÎȱÉÙ
|
`AppServer_Reinit_BattGroupData_FBO4830_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÖØÐÂFBO4830Ï̼߳ÓÔØ»ú·¿ÐÅÏ¢'
|
|
|
V1.95 edit at date 2024-01-24
|
1.StationId int ->Long
|
2.ÐÞ¸´'db_param.tb_app_param'±íÖÐÎÞ³õʼ»¯²ÎÊýbug
|
|
|
V1.94 edit at date 2024-01-23
|
1.'db_pwrdev_data_rt.tb_pwrdev_acdcdata'ÐÂÔö×Ö¶Î,ÄϾ©²â¿ØµãλȱÉÙ
|
`m17_outCurr` float NOT NULL DEFAULT '0',
|
`is_acdcMod17_off` float NOT NULL DEFAULT '0',
|
`is_acdcMod17_err` float NOT NULL DEFAULT '0',
|
`m18_outCurr` float NOT NULL DEFAULT '0',
|
`is_acdcMod18_off` float NOT NULL DEFAULT '0',
|
`is_acdcMod18_err` float NOT NULL DEFAULT '0',
|
`m19_outCurr` float NOT NULL DEFAULT '0',
|
`is_acdcMod19_off` float NOT NULL DEFAULT '0',
|
`is_acdcMod19_err` float NOT NULL DEFAULT '0',
|
`m20_outCurr` float NOT NULL DEFAULT '0',
|
`is_acdcMod20_off` float NOT NULL DEFAULT '0',
|
`is_acdcMod20_err` float NOT NULL DEFAULT '0',
|
|
V1.93 edit at date 2024-01-13
|
1.Êý¾Ý¿â'db_battinf.tb_battinf'ÐÂÔö×Ö¶Î
|
`sign_type` int(11) NOT NULL DEFAULT '0' COMMENT 'ÑéÇ©¸ñʽ0-³£¹æ 1-Õý³£1ÍÏ2[61850É豸ÓÐЧ]'
|
2.Êý¾Ý¿â'db_battinf.tb_battinf_update_record'ÐÂÔö×Ö¶Î
|
`sign_type` int(11) NOT NULL DEFAULT '0' COMMENT 'ÑéÇ©¸ñʽ0-³£¹æ 1-Õý³£1ÍÏ2[61850É豸ÓÐЧ]'
|
|
|
|
V1.92 edit at date 2024-01-10
|
1.ÐÂÔöÊý¾Ý¿â'db_pwrdev_data_rt.tb_pwrdev_rt_info'
|
CREATE TABLE `tb_pwrdev_rt_info` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`PowerDeviceId` bigint(20) NOT NULL DEFAULT '0',
|
`record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00',
|
`CommTxCount` int(11) NOT NULL DEFAULT '0',
|
`CommSuccessCount` int(11) NOT NULL DEFAULT '0',
|
PRIMARY KEY (`num`),
|
KEY `index_powerdev_id` (`PowerDeviceId`)
|
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
|
2.±í'db_pwrdev_data_rt.tb_pwrdev_acdcdata'ÐÂÔö×Ö¶Î
|
`chargLimitCurr` float NOT NULL DEFAULT '0',
|
`junChargeVol` float NOT NULL DEFAULT '0',
|
`floatChargeVol` float NOT NULL DEFAULT '0',
|
`acVolH_Limit` float NOT NULL DEFAULT '0',
|
`acVolL_Limit` float NOT NULL DEFAULT '0',
|
`dcOutVolH_Limit` float NOT NULL DEFAULT '0',
|
`dcOutVolL_Limit` float NOT NULL DEFAULT '0',
|
`acInUseCount` tinyint(4) NOT NULL DEFAULT '0',
|
|
V1.91 edit at date 2023-11-25
|
1.ÐÂÔöÊý¾Ý¿â'db_upspwrdev_data_history'ÓÃÓÚ´æ´¢UPSÀúÊ·ÊÇʵʱÊý¾Ý¼Ç¼
|
2.ÐÂÔöÊý¾Ý¿â±í'db_pwrdev_data_rt.tb_upspower_sinal'
|
CREATE TABLE `tb_upspower_sinal` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`power_device_id` int(11) NOT NULL DEFAULT '0',
|
`record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¸üÐÂʱ¼ä',
|
`power_supply_state` int(11) NOT NULL DEFAULT '0' COMMENT 'bit0£ºÄæ±ä¹©µç;bit1:ÅÔ·¹©µç',
|
`batt_state` int(11) NOT NULL DEFAULT '0' COMMENT 'bit0:µç³Ø×Ô¼ìÖÐ bit1:µç³Ø¸¡³ä bit2£ºµç³Ø¾ù³ä',
|
`inverter_on` int(11) NOT NULL DEFAULT '0' COMMENT 'Äæ±äÆ÷¿ª»ú',
|
`rectifier_power_supply` int(11) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷¹©µç״̬£ºbit0:Ö÷Äæ±ä¹©µç bit:µç³ØÄæ±ä¹©µç',
|
`dynamo_access` int(11) NOT NULL DEFAULT '0' COMMENT '·¢µç»ú½ÓÈë',
|
`input_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT 'ÊäÈë¿Õ¿ª bit0£ºÊäÈë¿Õ¿ª¶Ï¿ª bit1:ÊäÈë¿Õ¿ª²»Ö§³Ö',
|
`repire_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT 'άÐÞ¿Õ¿ª bit0£º¿Õ¿ª¶Ï¿ª bit1:¿Õ¿ª²»Ö§³Ö',
|
`pass_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT 'ÅÔ·¿Õ¿ª bit0: ÅÔ·¿Õ¿ª¶Ï¿ª bit1£ºÅÔ·¿Õ¿ª²»Ö§³Ö',
|
`output_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT 'Êä³ö¿Õ¿ª bit0:Êä³ö¿Õ¿ª¶Ï¿ª bit1£ºÊä³ö¿Õ¿ª²»Ö§³Ö',
|
`machine_work_mode` int(11) NOT NULL DEFAULT '0' COMMENT 'Õû»ú¹¤×÷ģʽ£ºbit0:Õý³£Ä£Ê½ bit1:±äƵÆ÷ģʽ bit2:ÖÇÄܲ¢»úģʽ bit3:ÖÇÄܲ¢»úÑÝʾģʽ bit4:ECOģʽ bit5:ÖÇÄÜECOģʽ bit6:ÖÇÄÜECOÑÝʾģʽ',
|
`parallelsys_powerstate` int(11) NOT NULL DEFAULT '0' COMMENT '²¢»úϵͳ¹©µç״̬ bit0-ÅÔ·¹©µç bit1-Ö÷·Äæ±ä¹©µç bit2-µç³ØÄæ±ä¹©µç',
|
`model_online` int(11) NOT NULL DEFAULT '0' COMMENT 'Ä£¿éÔÚÏß bit0:Ä£¿é1ÔÚÏß bit1:Ä£¿é2ÔÚÏß bit2£ºÄ£¿é3ÔÚÏß ... bit11:Ä£¿é12ÔÚÏß ',
|
`batt_inswitch_open` int(11) NOT NULL DEFAULT '0' COMMENT 'ÄÚÖõç³Ø¿Õ¿ª¶Ï¿ª',
|
`bcb1_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB1״̬ bit0:BCB1δ½ÓÈë bit1£ºBCB1:±ÕºÏ',
|
`bcb2_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB2״̬ bit0:BCB2δ½ÓÈë bit1£ºBCB2:±ÕºÏ',
|
`bcb3_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB3״̬ bit0:BCB3δ½ÓÈë bit1£ºBCB3:±ÕºÏ',
|
`bcb4_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB4״̬ bit0:BCB4δ½ÓÈë bit1£ºBCB4:±ÕºÏ',
|
`ups_alm1` int(11) NOT NULL DEFAULT '0' COMMENT 'ups¸æ¾¯1 bit0:Äæ±äÆ÷²»Í¬²½ bit1:Ö÷·µçѹÒì³£ bit2:ÕûÁ÷Æ÷Òì³£ bit3:Äæ±äÆ÷Òì³£ bit4:ÅÔ·Òì³£ bit5:µç³ØµçѹµÍÓÚÏÂÏÞ bit6:µç³Øµçѹ¹ý¸ß bit7:µç³Øδ½ÓÈë bit8:µç³ØµçѹµÍÓڸ澯 bit9:µç³Ø½Ó·´ bit10:ParaMonCANͨѶÒì³£ bit11:PowerCANͨѶÒì³£ bit12:ÕûÁ÷DSP³ÌÐò´íÎó bit13:ÕûÁ÷FPGA³ÌÐò´íÎó bit14:Äæ±äDSP³ÌÐò´íÎó bit15:Äæ±äFPGA³ÌÐò´íÎó bit16:ÅÔ·DSP³ÌÐò´íÎó bit17:ÅÔ·FPGA³ÌÐò´íÎó bit18:»ú¼ÜÄÚÀëÉ¢×ÜÏßͨѶÒì³£ bit19:»ú¼Ü¼äÀëÉ¢×ÜÏßͨѶÒì³£ bit20:Ö÷¿ØÄ£¿éÉèÖò»Æ¥Åä bit21:LBSÒì³£ bit22:½ô¼±¹Ø»ú bit23:ÅÔ·¾§Õ¢¹Ü¹ÊÕÏ bit24:ÅÔ·ÏàÐò·´',
|
`ups_alm2` int(11) NOT NULL DEFAULT '0' COMMENT 'ups¸æ¾¯2 bit0ÅÔ·¹ýÁ÷ bit1ÅÔ·Òì³£¹Ø»ú bit2Çл»´ÎÊýÏÞÖÆ bit3ECOÇл»´ÎÊýÏÞÖÆ bit4ParaPowerCanͨѶÒì³£ bit5µç³Ø·ÅµçÏÞÁ÷ bit6·ÅµçÆ÷¹ÊÕÏ bit7³äµçÆ÷¹ÊÕÏ bit8LBSÁ¬½ÓÏßÒì³£ bit9µç³ØÐèά»¤ bit10µç³Ø¹ýΠbit11µç³Ø½ÓµØ¹ÊÕÏ bit12Ö÷·ƵÂÊÒì³£ bit13Ä£¿é¹ýΠbit14´Ó¿ØÄ£¿éÉèÖò»Æ¥Åä bit15½Ó¿ÚÄ£¿éÉèÖò»Æ¥Åä bit16¾ù³ä³¬Ê± bit17¸¨ÖúµçÔ´µôµç bit18Ö÷·ÏàÐò·´ bit19ÕûÁ÷Æ÷ÈíÆô¶¯Ê§°Ü bit20Óû§²Ù×÷´íÎó bit21Êä³öÈÛË¿¶Ï bit22Êä³ö¹ýÔØ bit23ϵͳ¹ýÔØ bit24Êä³ö¹ýÔس¬Ê±',
|
`ups_alm3` int(11) NOT NULL DEFAULT '0' COMMENT 'ups¸æ¾¯3 bit0¸ºÔسå»÷תÅÔ· bit1²¢»ú¾ùÁ÷Òì³£ bit2ĸÏßÒì³£¹Ø»ú bit3ÁÙ»úÇëÇóתÅÔ· bit4Ö±Á÷ĸÏß¹ýѹ bit5MonCANͨѶÒì³£ bit6ÊäÈëȱÁã¹ÊÕÏ bit7Äæ±ä¼ÌµçÆ÷¹ÊÕÏ bit8Ö÷··´¹à bit9ÊäÈëµçÁ÷Òì³£ bit10Êä³öµçѹÒì³£ bit11ÊäÈëµçÁ÷³¬ÏÞ bit12ÅÔ·¹ýΠbit13ÁÚ»úÅÔ·¾§Õ¢¹Ü¹ÊÕÏ bit14²¢»úÁ¬½ÓÏßÒì³£ bit15³äµçÆ÷¹ýΠbit16µç³Ø¶Ë¿Ú¶Ì· bit17µç³Ø·¿»·¾³Òì³£ bit18·çÉÈÒì³£ bit19ÅÔ·ȱÁã¹ÊÕÏ bit20ÅÔ·½Ó¹Ü bit21BCB1 ״̬Òì³£ bit22BCB2 ״̬Òì³£ bit23BCB3 ״̬Òì³£ bit24BCB4 ״̬Òì³£',
|
`ups_alm4` int(11) NOT NULL DEFAULT '0' COMMENT 'ups¸æ¾¯4 bit0ÅÔ·SCR·çÉÈÒì³£ bit1ƽºâµç·¹ÊÕÏ bit2ƽºâµç·¹ýÁ÷ bit3ƽºâµç·¹ýΠbit4ʧȥÈßÓà bit5ÈÝÁ¿¹ýÔØ bit6¹¦ÂÊ°åÉèÖò»Æ¥Åä bit7ÅÔ·ÉèÖò»Æ¥Åä bit8Éϳé·ç·çÉÈÒì³£ bit9ϵͳAÏàÊä³öÈÛË¿¶Ï bit10ϵͳBÏàÊä³öÈÛË¿¶Ï bit11ϵͳCÏàÊä³öÈÛË¿¶Ï bit12ÅÔ·ÎÞЧ bit13ÕûÁ÷Æ÷¹ýÁ÷ bit14ÅÔ·¹ýÁ÷³¬Ê± bit15Êä³öÁãµØ¹ýѹ bit16ÊäÈëÈÛË¿¶Ï bit17ÅÔ·ÈÛË¿¶Ï',
|
`ups_conn_err` int(11) NOT NULL DEFAULT '0' COMMENT 'ÐתÓëUPSͨÐŹÊÕÏ',
|
PRIMARY KEY (`num`),
|
UNIQUE KEY `idx` (`power_device_id`) USING BTREE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='upsµçÔ´Ò£ÐÅʵʱ״̬ÐÅÏ¢±í';
|
|
3.ÐÂÔöÊý¾Ý¿â±í'db_pwrdev_data_rt.tb_upspower_simulate'
|
CREATE TABLE `tb_upspower_simulate` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`power_device_id` int(11) NOT NULL DEFAULT '0',
|
`record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¸üÐÂʱ¼ä',
|
`acin_vola` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊäÈëµçѹ',
|
`acin_volb` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊäÈëµçѹ',
|
`acin_volc` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊäÈëµçѹ',
|
`acout_vola` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³öµçѹ',
|
`acout_volb` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³öµçѹ',
|
`acout_volc` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³öµçѹ',
|
`acout_curra` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³öµçÁ÷',
|
`acout_currb` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³öµçÁ÷',
|
`acout_currc` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³öµçÁ÷',
|
`dcin_vol` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷ÊäÈëµçѹ[µç³Ø×é1µç³Øµçѹ]',
|
`out_freq` float NOT NULL DEFAULT '0' COMMENT 'Êä³öƵÂÊ',
|
`abin_vol` float NOT NULL DEFAULT '0' COMMENT 'ABÏßÊäÈëµçѹ',
|
`bcin_vol` float NOT NULL DEFAULT '0' COMMENT 'BCÏßÊäÈëµçѹ',
|
`cain_vol` float NOT NULL DEFAULT '0' COMMENT 'CAÏßÊäÈëµçѹ',
|
`acin_curra` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊäÈëµçÁ÷',
|
`acin_currb` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊäÈëµçÁ÷',
|
`acin_currc` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊäÈëµçÁ÷',
|
`in_freq` float NOT NULL DEFAULT '0' COMMENT 'ÊäÈëƵÂÊ',
|
`in_powerfactor_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊäÈ빦ÂÊÒòÊý',
|
`in_powerfactor_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊäÈ빦ÂÊÒòÊý',
|
`in_powerfactor_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊäÈ빦ÂÊÒòÊý',
|
`pass_vola` float NOT NULL DEFAULT '0' COMMENT 'AÏàÅÔ·µçѹ',
|
`pass_volb` float NOT NULL DEFAULT '0' COMMENT 'BÏàÅÔ·µçѹ',
|
`pass_volc` float NOT NULL DEFAULT '0' COMMENT 'CÏàÅÔ·µçѹ',
|
`pass_freq` float NOT NULL DEFAULT '0' COMMENT 'ÅÔ·ƵÂÊ',
|
`about_vol` float NOT NULL DEFAULT '0' COMMENT 'ABÏßÊä³öµçѹ',
|
`bcout_vol` float unsigned NOT NULL DEFAULT '0' COMMENT 'BCÏßÊä³öµçѹ',
|
`caout_vol` float NOT NULL DEFAULT '0' COMMENT 'CAÏßÊä³öµçѹ',
|
`abpass_vol` float NOT NULL DEFAULT '0' COMMENT 'ABÏßÅÔ·µçѹ',
|
`bcpass_vol` float NOT NULL DEFAULT '0' COMMENT 'BCÏßÅÔ·µçѹ',
|
`capass_vol` float NOT NULL DEFAULT '0' COMMENT 'CAÏßÅÔ·µçѹ',
|
`out_powerfactor_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³ö¹¦ÂÊÒòÊý',
|
`out_powerfactor_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³ö¹¦ÂÊÒòÊý',
|
`out_powerfactor_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³ö¹¦ÂÊÒòÊý',
|
`out_peakratio_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³ö·åÖµ±È',
|
`out_peakratio_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³ö·åÖµ±È',
|
`out_peakratio_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³ö·åÖµ±È',
|
`out_actpower_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³öÓй¦¹¦ÂÊ',
|
`out_actpower_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³öÓй¦¹¦ÂÊ',
|
`out_actpower_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³öÓй¦¹¦ÂÊ',
|
`out_reapower_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³öÎÞ¹¦¹¦ÂÊ',
|
`out_reapower_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³öÎÞ¹¦¹¦ÂÊ',
|
`out_reapower_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³öÎÞ¹¦¹¦ÂÊ',
|
`out_apppower_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³öÊÓÔÚ¹¦ÂÊ',
|
`out_apppower_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³öÊÓÔÚ¹¦ÂÊ',
|
`out_apppower_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³öÊÓÔÚ¹¦ÂÊ',
|
`out_loadpercent_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³ö¸ºÔذٷֱÈ',
|
`out_loadpercent_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³ö¸ºÔذٷֱÈ',
|
`out_loadpercent_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³ö¸ºÔذٷֱÈ',
|
`sysout_actpower_a` float NOT NULL DEFAULT '0' COMMENT 'ϵͳAÏàÊä³öÓй¦¹¦ÂÊ',
|
`sysout_actpower_b` float NOT NULL DEFAULT '0' COMMENT 'ϵͳBÏàÊä³öÓй¦¹¦ÂÊ',
|
`sysout_actpower_c` float NOT NULL DEFAULT '0' COMMENT 'ϵͳCÏàÊä³öÓй¦¹¦ÂÊ',
|
`sysout_apppower_a` float NOT NULL DEFAULT '0' COMMENT 'ϵͳAÏàÊä³öÊÓÔÚ¹¦ÂÊ',
|
`sysout_apppower_b` float NOT NULL DEFAULT '0' COMMENT 'ϵͳBÏàÊä³öÊÓÔÚ¹¦ÂÊ',
|
`sysout_apppower_c` float NOT NULL DEFAULT '0' COMMENT 'ϵͳCÏàÊä³öÊÓÔÚ¹¦ÂÊ',
|
`sysout_reapower_a` float NOT NULL DEFAULT '0' COMMENT 'ϵͳAÏàÊä³öÎÞ¹¦¹¦ÂÊ',
|
`sysout_reapower_b` float NOT NULL DEFAULT '0' COMMENT 'ϵͳBÏàÊä³öÎÞ¹¦¹¦ÂÊ',
|
`sysout_reapower_c` float NOT NULL DEFAULT '0' COMMENT 'ϵͳCÏàÊä³öÎÞ¹¦¹¦ÂÊ',
|
`dev_envir_temp` float NOT NULL DEFAULT '0' COMMENT 'Õû»ú»·¾³Î¶È',
|
`batt_backup_time` float NOT NULL DEFAULT '0' COMMENT 'µç³Øºó±¸Ê±¼ä',
|
`batt_posivol` float NOT NULL DEFAULT '0' COMMENT 'Õýµç³Øµçѹ',
|
`batt_posicurr` float NOT NULL DEFAULT '0' COMMENT 'Õýµç³ØµçÁ÷',
|
`batt_negavol` float NOT NULL DEFAULT '0' COMMENT '¸ºµç³Øµçѹ',
|
`batt_negacurr` float NOT NULL DEFAULT '0' COMMENT '¸ºµç³ØµçÁ÷',
|
`batt_agecoefficient` float NOT NULL DEFAULT '0' COMMENT 'µç³ØÀÏ»¯ÏµÊý',
|
`batt_temp` float NOT NULL DEFAULT '0' COMMENT 'µç³ØζÈ',
|
`envir_temp` float NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È',
|
PRIMARY KEY (`num`),
|
UNIQUE KEY `idx` (`power_device_id`) USING BTREE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='upsµçÔ´Ò£²âÁ¿ÊµÊ±×´Ì¬±í';
|
|
4.ÐÂÔöÊý¾Ý¿â±í'db_upspwrdev_alarm.tb_upspwrdev_alarm'
|
CREATE TABLE `tb_upspwrdev_alarm` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`record_id` bigint(20) NOT NULL DEFAULT '0',
|
`power_device_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'µçÔ´id',
|
`alm_type` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯id',
|
`alm_level` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯µÈ¼¶',
|
`alm_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00' COMMENT '¸æ¾¯¿ªÊ¼Ê±¼ä',
|
`alm_end_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00' COMMENT '¸æ¾¯½áÊøʱ¼ä',
|
`alm_value` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯Öµ',
|
`alm_is_confirmed` tinyint(1) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÊÇ·ñÈ·ÈÏ',
|
`alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00' COMMENT '¸æ¾¯È·ÈÏʱ¼ä',
|
`alm_cleared_type` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯×´Ì¬0-ʵʱ¸æ¾¯ 1-ÀúÊ·¸æ¾¯ 2-È¡ÏûµÄ¸æ¾¯',
|
PRIMARY KEY (`num`),
|
KEY `index_record_id` (`record_id`),
|
KEY `index_pwrdev_id` (`power_device_id`),
|
KEY `index_alm_type` (`alm_type`),
|
KEY `index_alm_start_time` (`alm_start_time`),
|
KEY `index_alm_cleared_type` (`alm_cleared_type`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='UPSµçԴʵʱ¸æ¾¯±í';
|
|
5.ÐÂÔöÊý¾Ý¿â±í'db_upspwrdev_alarm.tb_upspwrdev_alarm_history'
|
CREATE TABLE `tb_upspwrdev_alarm_history` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`record_id` bigint(20) NOT NULL DEFAULT '0',
|
`power_device_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'µçÔ´id',
|
`alm_type` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯id',
|
`alm_level` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯µÈ¼¶',
|
`alm_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00' COMMENT '¸æ¾¯¿ªÊ¼Ê±¼ä',
|
`alm_end_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00' COMMENT '¸æ¾¯½áÊøʱ¼ä',
|
`alm_value` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯Öµ',
|
`alm_is_confirmed` tinyint(1) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÊÇ·ñÈ·ÈÏ',
|
`alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00' COMMENT '¸æ¾¯È·ÈÏʱ¼ä',
|
`alm_cleared_type` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯×´Ì¬0-ʵʱ¸æ¾¯ 1-ÀúÊ·¸æ¾¯ 2-È¡ÏûµÄ¸æ¾¯',
|
PRIMARY KEY (`num`),
|
KEY `index_record_id` (`record_id`),
|
KEY `index_pwrdev_id` (`power_device_id`),
|
KEY `index_alm_type` (`alm_type`),
|
KEY `index_alm_start_time` (`alm_start_time`),
|
KEY `index_alm_cleared_type` (`alm_cleared_type`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='UPSµçÔ´ÀúÊ·¸æ¾¯±í';
|
|
6.Êý¾Ý¿â±í'web_site.tb_process_survey',ÐÂÔöUPSµçԴͨÐÅÏß³Ì- 11028
|
INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11028', 'BMS_UPS_POWER_MONITOR', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_UPS_POWER_MONITOR', '2', 'v1.100', 'UPSµçԴͨÐÅÏß³Ì', '300');");
|
7.ÐÞ¸ÄĬÈÏÌí¼ÓÕ˺ÅÃÜÂëΪ[superuser,admin,sys_admin,audit_admin] fg001@hdw --- ×îÐÂĬÈÏÓû§ÃÜÂë
|
|
|
V1.90 edit at date 2023-10-31
|
1.±í'db_pwrdev_inf.tb_pwrdev_inf'ÐÂÔöÄÏÍøµçԴʵʱ½çÃæ±êÇ©ÅäÖÃ×Ö¶Î
|
`is_ac_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT 'ÊÇ·ñ°üº¬½»Á÷Åäµç¹ñ[1-°üº¬£¬0-²»°üº¬]',
|
`is_dc_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT 'ÊÇ·ñ°üº¬Ö±Á÷Åäµç¹ñ[1-°üº¬£¬0-²»°üº¬]',
|
`is_highfreq_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT 'ÊÇ·ñ°üº¬¸ßƵÅäµç¹ñ[1-°üº¬£¬0-²»°üº¬]',
|
|
2.'db_ram_db.'
|
|
V1.89 edit at date 2023-10-24
|
1.'db_user.tb_user_inf'±íÐÞ¸Ä'UsnId'³¤¶È varchar(200)->varchar(1000)
|
2.'db_user.tb_user_inf'±íÐÞ¸Ä'upassword'³¤¶È varchar(200)->varchar(1000)
|
3.ÐÞ¸ÄÌí¼ÓĬÈÏÕ˺ŵÄÃÜÂë×Ö·û´® 123456-X9rYw0Za1T7vgFO9cEMghH8f+Uo1Dhc3jAnMPpaKnCXL8nJ5xqueQ7Pldp0GmOr3imulIqxIQjdwZ43trz6s9YDi9lpEDNGVHQAx6hazHQmSnQ04HrPRn6xn9hvYo6BaJQYf+Jw5SmYwRgBWHbIA6atl/czRcDnXV9p7TCtcE8YsrgFYyT07D7/AmjPl1taiJmYnrojmqrQbOY/WE7nvHftjRkJoQcywYOfLY4zy4VOwhD6//Kpzo6klsLTuZgWMP1Wr4BzNB41EyjN68lzRiPhTQN0E8MuXwNSUS2sOODr96r6m9Z15Gg0iuzs60pz3HNXXoreRDjb5qZODprnEau0i94A9vuGaDS+Lr0QFV95ZAnCQ0t0j11QgxnuiBL0UIBNLYexCyTn3T5+cPDPMBC9bsMkCLzWvrapIFcGqrboxzx9g6KUh9jH24Eeckwndqqz5S+I0GeZbEZEAjHqgNSCPMDX0L8+CBvm6atT5kXpy1gls5YDsEDds0bTl9baf
|
4.±í'web_site.tb_process_survey'ÐÂÔö FD-K30NT ͨÐÅÏ̼߳Ǽ 11027 - BMS_FD_K30NT
|
INSERT INTO web_site.tb_process_survey(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11027', 'BMS_FD_K30NT', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_FD_K30NT', '2', 'v1.100', 'FD-K30NTͨÐÅÏß³Ì', '300');"
|
5.ÐÂÔöÊý¾Ý¿â±í'db_battinf.tb_batt_compare'
|
CREATE TABLE `tb_batt_compare` (
|
`num` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü',
|
`battgroupid` int(64) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éId',
|
`compare_inf` varchar(255) NOT NULL DEFAULT '' COMMENT '¶ÔÓ¦¹Øϵ',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='ÌìÒ»µç³§3Dµç³Ø×é¶ÔÕÕ¹Øϵ±í';
|
|
V1.88 edit at date 2023-10-09
|
1.ÐÞ¸´±í `db_app_sys`.`tb_page_param`ÖÐĬÈÏÊý¾Ý²åÈëbugÐÞ¸´
|
2.ÐÂÔö±í'db_ram_db.tb_check_dialog'
|
CREATE TABLE `tb_check_dialog` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`dev_id` int(64) NOT NULL DEFAULT '910000001',
|
`test_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
3.ºǫ́Ï̹߳ÜÀíÖÐÈ«¹¦ÄÜÄæ±ä¼Ù¸ºÔØ61850°æ±¾¼Ç¼
|
sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11026', 'BMS_FBS61852_NIBIAN', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_FBS61852_NIBIAN', '2', 'v1.100', 'È«¹¦ÄÜÄæ±ä¼Ù¸ºÔØͨÐÅÏß³Ì', '300');");
|
|
|
|
V1.87 edit at date 2023-09-09
|
1.±í`db_app_sys`.`tb_page_param` ²åÈëĬÈÏÊý¾Ý
|
INSERT INTO `db_app_sys`.`tb_page_param` (`id`,`param`, `status`, `categoryId`) VALUES (53,'ºËÈݷŵçʱ¼ä¹ýÂË', '2', '14');
|
INSERT INTO `db_app_sys`.`tb_page_param` (`id`,`param`, `status`, `categoryId`) VALUES (54,'ºËÈݳäµçʱ¼ä¹ýÂË', '2', '14');
|
INSERT INTO `db_app_sys`.`tb_page_param` (`id`,`param`, `status`, `categoryId`) VALUES (55,'¼à²â·Åµçʱ¼ä¹ýÂË', '2', '14');
|
INSERT INTO `db_app_sys`.`tb_page_param` (`id`,`param`, `status`, `categoryId`) VALUES (56,'¼à²â³äµçʱ¼ä¹ýÂË', '2', '14');
|
2.±íµç³ØÀúÊ·¸æ¾¯·Ö±íÐÂÔö ×ֶΠ`alm_severity`-'¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'
|
3.±íÉ豸ÀúÊ·¸æ¾¯·Ö±íÐÂÔö ×ֶΠ`alm_severity`-'¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'
|
2.±íµçÔ´ÀúÊ·¸æ¾¯·Ö±íÐÂÔö ×Ö¶Î
|
`alm_severity` -'¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'
|
`alm_trigger` -'¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'
|
|
V1.86 edit at date 2023-08-24
|
1.±í'db_alarm.tb_alarm_manual_clear'ÐÂÔö×Ö¶Î
|
`station_name4` varchar(45) DEFAULT NULL,
|
`file_url` varchar(255) DEFAULT NULL COMMENT 'ÉÏ´«µÄ¶à¸öÎļþ·¾¶,ÓÃ;Æ´½Ó',
|
`main_id` int(11) DEFAULT NULL COMMENT 'ÉóÅúÁ÷³ÌÖ÷±íid',
|
2.±í'web_site.tb_workflow_main'ÐÂÔö×Ö¶Î
|
`process_level` varchar(45) DEFAULT NULL COMMENT 'Á÷³ÌËùÔڲ㼶',
|
|
V1.85 edit at date 2023-08-15
|
1.´´½¨±í'db_alarm.tb_alarm_manual_clear'
|
2.´´½¨±í'web_site.tb_fbs9100_setparam_temp'
|
3.´´½¨±í'db_param.tb_appalm_param',²¢Â¼ÈëËùÓÐ[µçÔ´£¬µç³Ø£¬É豸¸æ¾¯ÊÇ·ñÄÜ×Ô¶¯ÏûʧÅäÖÃ]
|
4.´´½¨±í'db_alarm.tb_battalarm_data_verify'-µç³Ø¸æ¾¯È·Èϱí
|
5.´´½¨±í'db_alarm.tb_devalarm_data_verify'-É豸¸æ¾¯È·Èϱí
|
6.´´½¨±í'db_pwrdev_alarm.tb_pwrdev_alarm_verify'-µçÔ´¸æ¾¯È·Èϱí
|
7.'db_alarm.tb_battalarm_data_verify' µç³Ø¸æ¾¯È·ÈÏ´¦Àí±íÐÂÔö
|
`alm_solekey` int(11) NOT NULL DEFAULT '1' COMMENT 'ʵʱ¸æ¾¯Ö÷¼ü',
|
8.'db_alarm.tb_devalarm_data_verify' É豸¸æ¾¯È·ÈÏ´¦Àí±íÐÂÔö
|
`alm_solekey` int(11) NOT NULL DEFAULT '1' COMMENT 'ʵʱ¸æ¾¯Ö÷¼ü',
|
9.'db_pwrdev_alarm.tb_pwrdev_alarm_verify' µçÔ´¸æ¾¯È·ÈÏ´¦Àí±íÐÂÔö
|
`alm_solekey` int(11) NOT NULL DEFAULT '1' COMMENT 'ʵʱ¸æ¾¯Ö÷¼ü',
|
10.'web_site.tb_fault_upload'ÐÂÔö×Ö¶Î
|
ALTER TABLE `web_site`.`tb_fault_upload`
|
ADD COLUMN `alarm_num` INT NULL COMMENT '¸æ¾¯ÊµÊ±±íµÄid' AFTER `create_time`,
|
ADD COLUMN `alarm_type` INT NULL COMMENT '¸æ¾¯·ÖÀà:1-µç³Ø,2-É豸,3-µçÔ´' AFTER `alarm_num`;
|
ADD COLUMN `main_id` INT NULL AFTER `create_time`;
|
|
V1.84 edit at date 2023-07-27
|
1.ɾ³ýĬÈϵĵçÔ´½»Á÷Í£µç¸æ¾¯²ÎÊý
|
2.ĬÈϲåÈë¹úÍøµçÔ´2·µÄÈýÏà¸æ¾¯²ÎÊý
|
3.½«¹úÍøµçÔ´Ô½»Á÷ÈýÏàµçѹ¸æ¾¯²ÎÊýÇ°ÐÂÔö·Êý
|
|
|
V1.83 edit at date 2023-07-26
|
1.'db_pwrdev_inf.tb_pwrdev_inf'ÐÂÔö×Ö¶ÎÓÃÓÚÅжϵçÔ´¸æ¾¯ÖеĽ»Á÷Í£µç¸æ¾¯
|
`acvol_high_limit` float NOT NULL DEFAULT '200' COMMENT '½»Á÷ÉÏÏÞãÐÖµ',
|
`acvol_low_limit` float NOT NULL DEFAULT '200' COMMENT '½»Á÷ÏÂÏÞãÐÖµ',
|
`dcoutvol_low_limit` float NOT NULL DEFAULT '43.2' COMMENT 'Ö±Á÷Êä³öµçѹÏÂÏÞãÐÖµ',
|
`model` varchar(45) DEFAULT NULL COMMENT 'ÐͺÅ',
|
|
|
V1.82 edit at date 2023-07-24
|
1.'db_param.tb_dev_param'±íÐÂÔö ÉÏÉÏÏ޸澯µÈ¼¶ºÍÏÂÏÂÏ޸澯µÈ¼¶
|
`alm_high_level_upper` int(11) NOT NULL DEFAULT '1' COMMENT 'ÉÏÉÏÏ޸澯µÈ¼¶',
|
`alm_low_level_lower` int(11) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏÂÏ޸澯µÈ¼¶',
|
2.'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'±íÐÂÔöÉÏÉÏÏ޸澯µÈ¼¶ºÍÏÂÏÂÏ޸澯µÈ¼¶
|
`alarm_limitL_lower_level` int(11) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏÂÏ޸澯µÈ¼¶',
|
`alarm_limitH_upper_level` int(11) NOT NULL DEFAULT '1' COMMENT 'ÉÏÉÏÏ޸澯µÈ¼¶',
|
`alarm_limitL_level` int(11) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏ޸澯µÈ¼¶',
|
`alarm_limitH_level` int(11) NOT NULL DEFAULT '1' COMMENT 'ÉÏÏ޸澯µÈ¼¶',
|
|
ÔµçÔ´¸æ¾¯µÈ¼¶×Ö¶Î'alm_level' ÆúÓÃ
|
|
3.'db_battinf.tb_station_inf'±íÐÂÔö±êʶͬһ»ú·¿±êʶ
|
`together_flag` int(11) NOT NULL DEFAULT '0'
|
|
4.ÐÂÔö'db_param.tb_dev_almparam'-É豸¸æ¾¯²ÎÊý±í
|
CREATE TABLE `tb_dev_almparam` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`alm_id` int(11) NOT NULL DEFAULT '119020' COMMENT '¸æ¾¯id',
|
`alm_name` varchar(255) NOT NULL COMMENT '¸æ¾¯Ãû³Æ',
|
`alm_type` int(11) NOT NULL DEFAULT '0' COMMENT 'µ±Ç°¸æ¾¯´¥·¢ÀàÐÍ£»0-booleanÀàÐÍ 1-ãÐÖµÀàÐÍ',
|
`alm_limit_value` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ãÐÖµ',
|
`alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '¸æ¾¯µÈ¼¶',
|
`alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '¸æ¾¯ÑÓ³Ù´¥·¢Ê±³¤[µ¥Î»£ºÃë]',
|
`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]',
|
`alm_en` int(11) NOT NULL DEFAULT '1' COMMENT '¸æ¾¯Ê¹ÄÜ£º0-²»´¥·¢ 1-´¥·¢',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='É豸¸æ¾¯²ÎÊý±í';
|
|
|
|
V1.81 edit at date 2023-07-21
|
1.'db_param.tb_dev_param'±íÐÂÔö'alm_delay_time'-ɽÎ÷ÐÂÔö¸æ¾¯Ñӳٸ澯²ÎÊý£¬ÑÓ³Ùµ±Ç°¸æ¾¯´¥·¢£¬É¸³ý²¨¶¯¸æ¾¯ÒÔ¼°Îó¸æ¾¯
|
`alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '¸æ¾¯ÑÓ³Ùʱ³¤[µ¥Î»£ºÃë]',
|
2.'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'±íÐÂÔö'alm_delay_time'-ɽÎ÷ÐÂÔö¸æ¾¯Ñӳٸ澯²ÎÊý£¬ÑÓ³Ùµ±Ç°¸æ¾¯´¥·¢£¬É¸³ý²¨¶¯¸æ¾¯ÒÔ¼°Îó¸æ¾¯
|
`alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '¸æ¾¯ÑÓ³Ùʱ³¤[µ¥Î»£ºÃë]',
|
|
V1.80 edit at date 2023-07-05
|
1.'db_app_sys.tb_page_param'±íĬÈϲåÈëÊý¾Ý
|
('52', '·ÅµçÓÅ»¯Ê±¼ä', '2', '13','')
|
|
V1.79 edit at date 2023-06-19
|
1.ÐÂÔö'db_battinf.tb_battinf_update_record'-µç³ØÐÅÏ¢¸ü¸Ä¼Ç¼±í
|
CREATE TABLE `tb_battinf_update_record` (
|
`num` int(11) NOT NULL AUTO_INCREMENT,
|
`record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
|
`update_reason` text COMMENT 'µç³ØÐÅÏ¢¸ü¸ÄÔÒò',
|
`update_name` varchar(20) DEFAULT ' ' COMMENT '¸ü¸ÄÈË',
|
`StationId` varchar(20) DEFAULT '0',
|
`StationId_ex` varchar(20) DEFAULT '0',
|
`StationName` varchar(100) DEFAULT ' ',
|
`StationName1` varchar(100) DEFAULT ' ',
|
`StationName2` varchar(100) DEFAULT ' ',
|
`StationName3` varchar(100) DEFAULT ' ',
|
`StationName4` varchar(100) DEFAULT ' ',
|
`StationName5` varchar(100) DEFAULT ' ',
|
`StationName6` varchar(100) DEFAULT ' ',
|
`StationName7` varchar(100) DEFAULT ' ',
|
`StationName8` varchar(100) DEFAULT ' ',
|
`StationName9` varchar(100) DEFAULT ' ',
|
`StationIP` varchar(20) DEFAULT '0',
|
`FBSDeviceId` bigint(11) DEFAULT '0',
|
`FBSDeviceIp` varchar(50) DEFAULT '192.168.0.88',
|
`FBSDeviceIp_WG` varchar(64) DEFAULT '192.168.0.1',
|
`FBSDeviceIp_YM` varchar(64) DEFAULT '255.255.255.0',
|
`FBSDeviceName` varchar(100) DEFAULT '0',
|
`GroupIndexInFBSDevice` int(11) DEFAULT '0',
|
`BattModel` varchar(100) DEFAULT ' ',
|
`BattGroupId` int(11) DEFAULT '0',
|
`BattGroupNum` int(11) DEFAULT '0',
|
`BattGroupName` varchar(100) DEFAULT ' ',
|
`BattGroupName1` varchar(100) DEFAULT ' ',
|
`BattGroupName2` varchar(100) DEFAULT ' ',
|
`BattGroupName3` varchar(100) DEFAULT ' ',
|
`BattGroupName4` varchar(100) DEFAULT ' ',
|
`BattGroupName5` varchar(100) DEFAULT ' ',
|
`BattGroupName6` varchar(100) DEFAULT ' ',
|
`FloatVolLevel` float DEFAULT '1.12',
|
`OfflineVolLevel` float DEFAULT '1.06',
|
`BattFloatCurrent` float DEFAULT '0',
|
`DeviceId` varchar(20) DEFAULT '0',
|
`DeviceName` varchar(100) DEFAULT '0',
|
`MonCount` int(11) DEFAULT '0',
|
`MonCapStd` float DEFAULT '0',
|
`MonVolStd` float DEFAULT '0',
|
`MonResStd` float DEFAULT '0',
|
`MonSerStd` float DEFAULT '0',
|
`MonTmpStd` float DEFAULT '0',
|
`MonVolLowToAvg` float DEFAULT '0',
|
`MonNum` int(11) DEFAULT '0',
|
`BattProducer` varchar(45) DEFAULT '0',
|
`BattProductDate` date DEFAULT '2006-07-06',
|
`BattInUseDate` date DEFAULT '2006-07-06',
|
`BattGuarantDayCount` int(11) DEFAULT '1095',
|
`SignalId` varchar(20) DEFAULT '0',
|
`CInterFaceId` int(11) DEFAULT '0',
|
`SignalName` varchar(50) DEFAULT '0',
|
`Load_curr` float DEFAULT '15',
|
`DisCurrMax` float DEFAULT '0',
|
`station_phone` varchar(32) DEFAULT '',
|
`station_install` tinyint(1) DEFAULT '0',
|
`install_user` varchar(64) DEFAULT '',
|
`charge_curr_max` float DEFAULT '20',
|
`Vol_grade` float DEFAULT '0',
|
`Manufacturers` varchar(64) DEFAULT '',
|
`Assetequipment` varchar(64) DEFAULT '',
|
`Deviceclasspath` varchar(64) DEFAULT '',
|
`DeviceOperationDepartment` varchar(64) DEFAULT '',
|
`PropertyRightUnit` varchar(64) DEFAULT '',
|
`PropertyAttribute` varchar(64) DEFAULT '',
|
`FactoryNumber` varchar(64) DEFAULT '',
|
`OperationTeam` varchar(64) DEFAULT '',
|
`DeviceIdentityCode` varchar(64) DEFAULT '',
|
`ProjectType` varchar(64) DEFAULT '',
|
`BatteryApplicationType` varchar(64) DEFAULT '',
|
`SingleRatedVoltage` float DEFAULT '0',
|
`RemoteMonitor` varchar(64) DEFAULT '',
|
`BatttIndependentPlaced` varchar(64) DEFAULT '',
|
`JunChargeVoltageValue` float DEFAULT '0',
|
`PublicKeyX` varchar(200) DEFAULT '',
|
`PublicKeyY` varchar(200) DEFAULT '',
|
`KeyID` varchar(200) DEFAULT '',
|
`SerialNumber` varchar(200) DEFAULT '',
|
`sort_id` int(3) DEFAULT '0',
|
`video_url` varchar(200) DEFAULT NULL,
|
`charge_type` int(11) DEFAULT '1' COMMENT '³ä·Åµç״̬£º1:ÏÞÁ÷³äµç£»2£»Äæ±ä³äµç',
|
`buscouple_state` int(11) DEFAULT '0' COMMENT 'ĸÁª×´Ì¬£º0£ºÎÞĸÁª£»1:ÓÐĸÁª',
|
`tmp_id` int(11) DEFAULT '0',
|
`price_factor` float DEFAULT '1' COMMENT 'µç¼ÛϵÊý',
|
`smps_brand` varchar(50) DEFAULT NULL COMMENT '¿ª¹ØµçÔ´Æ·ÅÆ',
|
`smps_model` varchar(50) DEFAULT NULL COMMENT '¿ª¹ØµçÔ´ÐͺÅ',
|
`PackCount` int(11) DEFAULT '1' COMMENT '﮵ç³Ø°üÊýÁ¿',
|
`dev_num` varchar(255) NOT NULL DEFAULT '0' COMMENT 'É豸±àºÅ[a059ÓÃÓÚ±êʶÉ豸]',
|
`mId` bigint(20) DEFAULT '0' COMMENT '¶þάÂëÐÅÏ¢±êʶλ',
|
`cellShowType` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³ØÀàÐÍ[0£ºÇ¦Ëá 1£ºï®µç]',
|
`NomCapWH` float NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿[KWH]',
|
`NomCapAH` float NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿AH',
|
`LoadCurrFromDis` float NOT NULL DEFAULT '0' COMMENT '¸ºÔصçÁ÷-[À´Ô´ºËÈݷŵçÊý¾Ý]',
|
`NodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '½ÚµãÕ¾±êʶ:0:²»ÊǽڵãÕ¾[ĬÈÏ] 1:½ÚµãÕ¾',
|
`StationType` varchar(255) DEFAULT NULL COMMENT 'Õ¾µãÀàÐÍ[ÀýÈç110V/22V]',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='µç³ØÐÅÏ¢¸ü¸Ä¼Ç¼±í';
|
|
|
|
|
V1.78 edit at date 2023-06-14
|
1.'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx' ÐÂÔö×ֶαêʶÉÏÉÏÏÞÒÔ¼°ÏÂÏÂÏÞʹÄÜ
|
`alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÉÏÉÏÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]',
|
`alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏÂÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]',
|
|
2.'db_param.tb_dev_param'ÐÂÔöÉÏÉÏÏÞºÍÉÏÉÏÏÞãÐÖµÏà¹Ø²ÎÊý
|
`alm_high_coe_upper` float NOT NULL DEFAULT '3.2' COMMENT 'ÉÏÉÏÏ޸澯ϵÊýÖµ',
|
`alm_high_coe_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÉÏÉÏÏÞʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]',
|
`alm_low_coe_lower` float NOT NULL DEFAULT '0' COMMENT 'ÏÂÏÂÏ޸澯ϵÊýÖµ',
|
`alm_low_coe_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'ÏÂÏÂÏÞãÐֵʹÄÜ[0-²»ÆôÓà 1-ÆôÓÃ]',
|
|
3.'db_alarm.tb_battalarm_data'ÐÂÔö¸æ¾¯ÖØÒªµÈ¼¶
|
`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'
|
|
4.'db_alarm.tb_battalarm_data_history'ÐÂÔö¸æ¾¯ÖØÒªµÈ¼¶
|
`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]',
|
|
5.'db_alarm.tb_devalarm_data'ÐÂÔö¸æ¾¯ÖØÒªµÈ¼¶
|
`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'
|
|
6.'db_alarm.tb_devalarm_data_history'ÐÂÔö¸æ¾¯ÖØÒªµÈ¼¶
|
`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]'
|
|
V1.77 edit at date 2023-06-09
|
1.ÐÞ¸´´´½¨±í'db_alarm.tb_alarm_relation'³õʼ»¯±íÖÐ×ֶδíÎóbug
|
sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.Tb_Alarm_Relation_Table
|
+ " CHANGE alm_ponit alm_point varchar(255) DEFAULT '' COMMENT '¸æ¾¯µã';");
|
2.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx ÐÂÔö×Ö¶Î
|
`alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '¸æ¾¯ÉÏÉÏÏÞãÐÖµ',
|
`alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÏÂÏÂÏÞãÐÖµ',
|
|
3.db_pwrdev_alarm.tb_pwrdev_alarm ÐÂÔö×Ö¶Î
|
`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]',
|
|
4.db_pwrdev_alarm.tb_pwrdev_alarm_history ÐÂÔö×Ö¶Î
|
`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÖØÒªµÈ¼¶[0:ÖØÒª£»1:½ô¼±]',
|
|
|
V1.76 edit at date 2023-05-31
|
1.ÐÞ¸´'db_user.tb_user_log'±íÐÂÔö2ÁÐÎÞ·¨Ìí¼Ó,ÔËÐÐʱĬÈÏɾ³ý30Ìì֮ǰµÄ²Ù×÷ÈÕÖ¾
|
2.±í 'db_batt_testdata.tb_batttestdata_inf'ÐÂÔö×Ö¶Î
|
`test_datatype` int(11) NOT NULL DEFAULT '0' COMMENT 'ɽÎ÷61850¼à²â·ÅµçÊý¾Ý±êʶ¡¾0£º¼à²â·Åµç£»1Í£µç·Åµç¡¿'
|
|
V1.75 edit at date 2023-05-25
|
1.db_user.tb_user_log ÐÂÔö×Ö¶ÎÓÃÓÚFBC300ƽ̨ÖÐÓ¢ÎÄÈÕÖ¾ÃèÊö
|
`uOprateMsgEnUs` text,
|
`operation_detail_enUs` text,
|
2.ÐÞ¸´Ä³Ð©»ùÕ¾µÚÒ»´Î¼Ç¼µÄ³ä·ÅµçÎÞ·¨ÏÔʾbug
|
|
V1.74 edit at date 2023-05-19
|
1.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx ÐÂÔöµçÔ´¸æ¾¯Ê¹ÄÜ
|
`alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '¸æ¾¯À´Ô´Êǵãλʱ¸æ¾¯Ê¹ÄÜ[0:²»ÆôÓã»1£ºÆôÓÃ]'
|
2.³õʼĬÈϼÈëËùÓлú·¿µÄ ËùÓеĵçÔ´¸æ¾¯²ÎÊý
|
|
V1.73 edit at date 2023-05-16
|
1.ɾ³ýÏ̼߳à¿ØÖÐƽ̨Ï̵߳ļǼ,±ÜÃâƽ̨Ïß³ÌÒ»Ö±ÖØÆô
|
2.±í'web_site.tb_fault_upload'
|
×·¼Ó×ֶΠ`station_id` int(11) DEFAULT NULL
|
ɾ³ý×Ö¶Î`station_name`
|
|
V1.72 edit at date 2023-05-12
|
1.ÐÂÔö±í'web_site.tb_fault_upload' ---¹ÊÕÏÒþ»¼ÉÏ´«±í
|
CREATE TABLE `tb_fault_upload` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`station_name` varchar(500) DEFAULT NULL,
|
`type` int(11) DEFAULT NULL,
|
`description` varchar(500) DEFAULT NULL,
|
`upload_user_id` int(11) DEFAULT NULL,
|
`confirm_user_id` int(11) DEFAULT NULL,
|
`confirm_description` varchar(500) DEFAULT NULL,
|
`confirm_time` datetime DEFAULT NULL,
|
`status` tinyint(4) DEFAULT NULL COMMENT '0:´ýÈ·ÈÏ,1È·ÈÏÊôʵ,-1È·Èϲ»Êôʵ',
|
`create_time` datetime DEFAULT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='¹ÊÕÏÒþ»¼ÉÏ´«±í,ÓÃÓÚ¹ÊÕÏÒþ»¼¿¼ºË';
|
|
|
V1.71 edit at date 2023-05-04
|
1.±í 'db_ram_db.tb_fbs9100_sysparam' ÐÂÔö×ֶΠÅäÍøµçÔ´ÐÂÔöϵͳ²ÎÊý
|
`auto_captestperiod` int(11) NOT NULL DEFAULT '0' COMMENT '×Ô¶¯ºËÈÝÖÜÆÚ£¬µ¥Î»£ºÌì(7~999)',
|
`loaderpowerdown_peroid` int(11) NOT NULL DEFAULT '1' COMMENT '¸ºÔØ×Ô¶¯¶ÏµçÖÜÆÚ µ¥Î»£ºÌì(1~999)',
|
`loaderpowerdown_time` int(11) NOT NULL DEFAULT '0' COMMENT '¸ºÔضϵçʱ¼ä µ¥Î»£ºÃë(5~30)',
|
`boost_dcdc_bakvol` float NOT NULL DEFAULT '0' COMMENT 'ÉýѹDCDC£¬ºó±¸µçѹ(0.1V 30.0~56.0)',
|
`boost_dcdc_bakcurr` float NOT NULL DEFAULT '0' COMMENT 'ÉýѹDCDC£¬ºó±¸µçÁ÷',
|
2.±í 'db_ram_db.tb_fbs9100_battparam' ÐÂÔö×ֶΠÅäÍøµçÔ´ÐÂÔöµç³Ø²ÎÊý
|
`juncharge_vol` float NOT NULL DEFAULT '0' COMMENT '¾ù³äµçѹ',
|
3.±í'db_app_sys.tb_page_param' ÐÂÔö5Ìõ³õʼ»¯Êý¾Ý
|
"('47', '·Åµçʱ³¤, '10', '12','')" +
|
"('48', '×ó±ß¹æ¶¨·Åµçʱ³¤', '10', '12','')" +
|
"('49', '×ó±ß¹æ¶¨Ê±¼ä´ÎÊý', '10', '12','')" +
|
"('50', 'Óұ߹涨ʱ¼äʱ³¤', '1', '12','')" +
|
"('51', 'Óұ߹涨ʱ¼ä´ÎÊý', '1', '12','')" +
|
|
V1.70 edit at date 2023-04-18
|
1.±í'db_ram_db.tb_thread_util'±íÐÂÔöÊý¾Ý£¬ÓÃÓÚ¿ØÖƸºÔصçÁ÷¸üÐÂÏß³ÌÊÖ¶¯¸üÐÂ
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.ThreadUtil_Table + " VALUES ('4', '2019004', '¸ºÔصçÁ÷¸üÐÂÏß³Ì', '2019-01-08 10:44:28', '0', '')"); //Ìí¼Ó¸üиºÔصçÁ÷¸üÐÂÏß³Ì
|
|
2.±í'db_app_sys.tb_page_param'ĬÈϲåÈë¹ú¼Ê»¯Êý¾ÝÒÔ¼°²åÈëĬÈÏÊý¾Ý
|
`paramEnUs` varchar(255) DEFAULT '' COMMENT '¾ßÌå²ÎÊý¹ú¼Ê»¯Ó¢ÎÄ',
|
|
3.±í'db_app_sys.tb_menu'ĬÈϲåÈë¹ú¼Ê»¯Êý¾ÝÒÔ¼°²åÈëĬÈÏÊý¾Ý
|
`lableEnUs` varchar(255) DEFAULT '' COMMENT '¹ú¼Ê»¯Ó¢ÎÄÁÐ',
|
|
4.Ð޸ıí'db_app_sys.tb_page_param' ±íÁÐ 'param'
|
ALTER TABLE db_app_sys.tb_page_param MODIFY COLUMN param varchar(255);
|
|
V1.69 edit at date 2023-04-18
|
1.±í'db_ram_db.tb_fbs9140_topology_state' ÐÂÔöϵͳ±êʶ
|
`sys_flag` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸ϵͳÐͺÅ0:48Vϵͳ 1£º220Vϵͳ'
|
2.±í`web_site`.`tb_battdischarge_plan_temp` ×ֶθüÐÂ
|
ALTER TABLE `web_site`.`tb_battdischarge_plan_temp`
|
DROP COLUMN `approve_reason`,
|
DROP COLUMN `approve_time`,
|
DROP COLUMN `approve_status`,
|
DROP COLUMN `approve_user_id`
|
ADD `main_id` INT(11) NULL DEFAULT NULL COMMENT 'ÉóºË¹¤µ¥Ö÷±íid' ;
|
3.±í'db_user.tb_user_inf'±í×Ö¶Î'uSex'ÐÞ¸Ä×ֶκ¬Ò壬0-ÄÐ 1-Å®
|
ÔËÐкóÖ÷¶¯¸üÐÂÊý¾Ý¿âÖеÄÐÔ±ð×Ö¶Î
|
|
V1.68 edit at date 2023-04-14
|
1.±í'db_ram_db.tb_fbs9140_topology_state'ÐÂÔö×Ö¶Î
|
`total_vol` float NOT NULL DEFAULT '0' COMMENT '×ܵçѹ',
|
`total_curr` float NOT NULL DEFAULT '0' COMMENT '×ܵçÁ÷',
|
2.ÐÂÔö±í'db_ram_db.tb_fbs9149_setparam' - ²¢ÁªBTS9×é²ÎÊý±í
|
CREATE TABLE `tb_fbs9149_setparam` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`dev_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'É豸Id',
|
`op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT 'ÃüÁî×Ö¶Î',
|
`test_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔÀàÐÍ',
|
`groupnum` int(11) NOT NULL DEFAULT '0' COMMENT '×éºÅ0-×é1 1-×é2 2-×é3 3-×é4...',
|
`paramtype` int(11) NOT NULL DEFAULT '0' COMMENT '²ÎÊýÀàÐÍ£¬0-ʵʱºËÈݲÎÊý 1-¼Æ»®ºËÈݲÎÊý 2-»î»¯²ÎÊý 3-³äµç²ÎÊý',
|
`battauto` int(11) NOT NULL DEFAULT '0' COMMENT '0-×Ô¶¯ 1-ÊÖ¶¯ µç³Ø¹ÜÀí·½Ê½',
|
`timerchargeable` int(11) NOT NULL DEFAULT '0' COMMENT '0-¿ªÆô 1-¹Ø±Õ ¶¨Ê±¾ù³ä¹¦ÄÜ',
|
`battnominalcap` int(11) NOT NULL DEFAULT '0' COMMENT '50-200Ah µç³Ø±ê³ÆÈÝÁ¿ ',
|
`battfloatvol` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø¸¡³äµçѹ',
|
`battchargevol` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø¾ù³äµçѹ',
|
`battchargecurr1` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø³äµçÏÞÁ÷',
|
`battchargecurr2` float NOT NULL DEFAULT '0' COMMENT '¸¡³äת¾ù³äµçÁ÷',
|
`battchargecurr3` float NOT NULL DEFAULT '0' COMMENT '¾ù³äת¸¡³äµçÁ÷',
|
`tailcurrchargetime` int(11) NOT NULL DEFAULT '0' COMMENT '0-5H βµçÁ÷³äµçʱ¼ä',
|
`timerchargeperiod` int(11) NOT NULL DEFAULT '0' COMMENT '30-180Ìì ¶¨Ê±¾ù³äÖÜÆÚ',
|
`maxchargetimehour` int(11) NOT NULL DEFAULT '0' COMMENT '×¾ù³äʱ¼ä',
|
`tempcompensatedable` int(11) NOT NULL DEFAULT '0' COMMENT '0-¿ªÆô 1-¹Ø±Õ ζȲ¹³¥¿ª¹Ø',
|
`batthightemp` int(11) NOT NULL DEFAULT '0' COMMENT '20-80¡æ µç³Ø¹ýεã',
|
`battlowtemp` int(11) NOT NULL DEFAULT '0' COMMENT '-40-10¡æ µç³ØǷεã',
|
`compensatedtemp` int(11) NOT NULL DEFAULT '0' COMMENT '10-40¡æ β¹ÖÐÐĵã',
|
`tempcompensatedcoe` int(11) NOT NULL DEFAULT '0' COMMENT '0-50mV/¡æ β¹ÏµÊý',
|
`battdischargelowvol` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø·ÅµçÖÕÖ¹µçѹ',
|
`mondischargelowvol` float NOT NULL DEFAULT '0' COMMENT 'µ¥½Ú·ÅµçÖÕÖ¹µçѹ',
|
`localremoteset` int(11) NOT NULL DEFAULT '0' COMMENT '±¾µØÔ¶³ÌÉèÖà 0-Ô¶³Ì 1-±¾µØ',
|
`battchrgctrl` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø³äµç¿ØÖÆ 0-¿ªÆô 1-¹Ø±Õ ',
|
`battdisctrl` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø·Åµç¿ØÖÆ 0-¿ªÆô 1-¹Ø±Õ ',
|
`herongcurr` float NOT NULL DEFAULT '0' COMMENT 'ºËÈÝÏÞÁ÷ 0.1C-0.5C ',
|
`herongtimehour` int(11) NOT NULL DEFAULT '0' COMMENT 'ºËÈÝʱÏÞ',
|
`monvollow` float NOT NULL DEFAULT '0' COMMENT 'ÄÚ²¿µ¥ÌåÏÂÏÞÖµ[1.6-13.6]',
|
PRIMARY KEY (`num`),
|
KEY `index_dev_id` (`dev_id`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='²¢ÁªµçÔ´9×é²ÎÊý±í';
|
|
|
|
V1.67 edit at date 2023-04-10
|
1.ÐÂÔö´´½¨Êý¾Ý¿â`db_pwrdev_data_history` - ÄÏÍøÀúʷʵʱÊý¾Ý¿â
|
2.ÐÂÔö´´½¨Êý¾Ý¿â`db_pwrdev_data_history_gw` - ¹úÍøÀúʷʵʱÊý¾Ý¿â
|
3.Êý¾Ý¿âÐÂÔö±í'web_site.tb_holidays'
|
CREATE TABLE `tb_holidays` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`day` date DEFAULT NULL COMMENT 'ÈÕÆÚ',
|
`year` int(11) DEFAULT NULL COMMENT 'Äê¶È',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
|
4.Êý¾Ý¿âÐÂÔö±í'web_site.tb_workflow_link' --- ¹¤×÷Á÷½Úµã±í
|
CREATE TABLE `tb_workflow_link` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`main_id` int(11) DEFAULT NULL,
|
`parent_id` int(11) DEFAULT NULL COMMENT 'Éϼ¶id',
|
`process_level` varchar(45) DEFAULT NULL COMMENT 'µ±Ç°´¦Àí²ã¼¶',
|
`process_level_name` varchar(45) DEFAULT NULL COMMENT '´¦Àí²ã¼¶Ãû³Æ˵Ã÷',
|
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'µ±Ç°½ÚµãÉú³Éʱ¼ä',
|
`deal_user_id` int(11) DEFAULT NULL COMMENT 'µ±Ç°½Úµã´¦ÀíÈË',
|
`deal_type` int(11) DEFAULT NULL COMMENT '¹¤µ¥´¦ÀíÀàÐÍ\n0:¹¤µ¥ÅÉ·¢\n1:תÅÉ(ÏòϲãÅÉ·¢ÈÎÎñ)\n2:Òƽ»(ÈÎÎñÒƽ»µ½Í¬¼¶´¦Àí)\n3:·ÖÅÉ(ͬ¼¶ÅÉ·¢¸ø¶àÈË)\n4:²µ»Ø',
|
`deal_desc` varchar(45) DEFAULT NULL COMMENT '´¦ÀíÃèÊö',
|
`deal_file_name` varchar(45) DEFAULT NULL COMMENT '´¦Àí¸½¼þÃû³Æ',
|
`deal_file_url` varchar(45) DEFAULT NULL COMMENT '´¦Àí¸½¼þµØÖ·',
|
`deal_pic_name` varchar(45) DEFAULT NULL COMMENT '´¦ÀíͼƬÃû³Æ',
|
`deal_pic_url` varchar(45) DEFAULT NULL COMMENT '´¦ÀíͼƬµØÖ·',
|
`status` int(11) DEFAULT NULL COMMENT 'µ±Ç°½Úµã״̬\n0:´ý´¦Àí\n1:½Óµ¥(±¸ÓÃ)\n2:´¦ÀíÖÐ\n3:´ý»Ø¸´\n4:´¦Àí»Ø¸´\n5:Íê³É\n6:´ýÉóÅú',
|
`deal_role_id` int(11) DEFAULT NULL COMMENT 'µ±Ç°´¦Àí½ÇÉ«',
|
`deal_and_close` int(11) DEFAULT NULL COMMENT '´¦ÀíÍêÄÜ·ñ¹éµµ(0:²»ÄÜ,1:ÄÜ)',
|
`deal_reject_reason` varchar(45) DEFAULT NULL COMMENT '²µ»ØÔÒò',
|
`deal_task_num` int(11) DEFAULT NULL COMMENT '×ÓÈÎÎñÊý',
|
`deal_task_reply_num` int(11) DEFAULT NULL COMMENT '×ÓÈÎÎñ»Ø¸´Êý',
|
`deal_reason` varchar(45) DEFAULT NULL COMMENT '´¦Àí½¨Òé',
|
`required_finish_time` datetime DEFAULT NULL COMMENT 'ÐèÇóÍê³Éʱ¼ä',
|
`deal_time` datetime DEFAULT NULL COMMENT '´¦Àíʱ¼ä',
|
`reply_content` varchar(45) DEFAULT NULL COMMENT 'ÉóÅú»Ø¸´ÄÚÈÝ',
|
`reply_time` datetime DEFAULT NULL COMMENT 'ÉóÅú»Ø¸´Ê±¼ä',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COMMENT='¹¤×÷Á÷½Úµã±í';
|
|
5.Êý¾Ý¿âÐÂÔö±í'web_site.tb_workflow_main' -- ¹¤×÷Á÷Ö÷±í
|
CREATE TABLE `tb_workflow_main` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`order_id` varchar(45) DEFAULT NULL COMMENT '¹¤µ¥id,¹æ·¶WF-1-20211101-00001',
|
`title` varchar(45) DEFAULT NULL COMMENT '±êÌâ',
|
`task_desc` varchar(555) DEFAULT NULL COMMENT 'ÈÎÎñÃèÊö',
|
`create_user_id` int(11) DEFAULT NULL COMMENT '´´½¨ÈË',
|
`create_time` datetime DEFAULT NULL COMMENT '´´½¨Ê±¼ä',
|
`plan_begin_time` datetime DEFAULT NULL COMMENT 'ÈÎÎñ¼Æ»®¿ªÊ¼Ê±¼ä',
|
`plan_end_time` datetime DEFAULT NULL COMMENT 'ÈÎÎñ¼Æ»®½áÊøʱ¼ä',
|
`begin_time` datetime DEFAULT NULL COMMENT '¿ªÊ¼´¦Àíʱ¼ä',
|
`end_time` datetime DEFAULT NULL COMMENT '¹éµµÊ±¼ä',
|
`task_level` int(11) DEFAULT NULL COMMENT 'ÈÎÎñ¼¶±ð',
|
`is_in_time` tinyint(4) DEFAULT NULL COMMENT 'ÊÇ·ñ¼°Ê±',
|
`alarm_order_id` int(11) DEFAULT NULL COMMENT '¸æ¾¯¹¤µ¥id',
|
`status` tinyint(4) DEFAULT NULL COMMENT '¹¤µ¥×´Ì¬ 0:×Ô¶¯Åɵ¥,2:È˹¤Åɵ¥,3:¹¤µ¥T1´¦ÀíÖÐ,4:¹¤µ¥T2´¦ÀíÖÐ,5:¹éµµ',
|
`file_name` varchar(45) DEFAULT NULL COMMENT '¸½¼þÃû³Æ',
|
`file_url` varchar(45) DEFAULT NULL COMMENT '¸½¼þµØÖ·',
|
`pic_name` varchar(45) DEFAULT NULL COMMENT 'ͼƬÃû³Æ',
|
`pic_url` varchar(45) DEFAULT NULL COMMENT 'ͼƬµØÖ·',
|
`end_reason` varchar(45) DEFAULT NULL COMMENT '¹éµµÒâ¼û',
|
`is_auto` tinyint(4) DEFAULT NULL COMMENT 'ÊÇ·ñ×Ô¶¯Åɵ¥',
|
`type` int(11) DEFAULT NULL COMMENT '¹¤×÷Á÷ÀàÐÍ:1:¸æ¾¯,2:ÆÕͨ',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COMMENT='¹¤×÷Á÷Ö÷±í';
|
|
V1.66 edit at date 2023-04-07
|
1. `db_pwrdev_inf`.`tb_pwrdev_inf` ±íÐÂÔö×Ö¶Î
|
ALTER TABLE `db_pwrdev_inf`.`tb_pwrdev_inf`
|
ADD COLUMN `exception_cause` VARCHAR(45) NULL COMMENT 'Òì³£ÔÒò' AFTER `mId`,
|
ADD COLUMN `exception_cause_analysis` VARCHAR(255) NULL COMMENT 'Òì³£ÔÒò·ÖÎö' AFTER `exception_cause`;
|
ADD COLUMN `route_num` tinyint(4) DEFAULT '1' COMMENT '½»Á÷ABC¼¸Â·ÉèÖÃ',
|
V1.65 edit at date 2023-04-04
|
1.db_ram_db.tb_fbs9100_state±íÀ©Õ¹°æ±¾ºÅ³¤¶È£¬FBS300°æ±¾ºÅ³¬³öÔ±¾³¤¶È£¬À©Õ¹É豸°æ±¾ºÅ×Ö¶Î
|
`dev_version` varchar(255) NOT NULL DEFAULT '',
|
2.ºǫ́Ï̹߳ÜÀíÐÂÔö FBC4831Ïß³Ì - ProcessId = 11025
|
sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11025', 'BMS_BATT_FBC_4831NT', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_BATT_FBC_4831NT', '2', 'v1.100', 'FBC4831ͨÐÅÏß³Ì', '300');");
|
3.´´½¨²¢ÁªBTSÍØÆË״̬ÐÅÏ¢±í 'db_ram_db.tb_fbs9140_topology_state'
|
CREATE TABLE `tb_fbs9140_topology_state` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü',
|
`dev_id` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸id',
|
`record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä',
|
`grouptotalnum` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é×ÜÊý',
|
`montotalnum` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå×ÜÊý',
|
`onlinevol` float NOT NULL DEFAULT '0' COMMENT 'ÔÚÏßµçѹ',
|
`accurrrindex` int(11) NOT NULL DEFAULT '0' COMMENT 'µ±Ç°ACÊäÈëË÷Òý[0-#1 1-#2]',
|
`acua_1` float NOT NULL DEFAULT '0' COMMENT '#1½»Á÷AÏàµçѹ',
|
`acub_1` float NOT NULL DEFAULT '0' COMMENT '#1½»Á÷BÏàµçѹ',
|
`acuc_1` float NOT NULL DEFAULT '0' COMMENT '#1½»Á÷CÏàµçѹ',
|
`acia_1` float NOT NULL DEFAULT '0' COMMENT '#1½»Á÷AÏàµçÁ÷',
|
`acib_1` float NOT NULL DEFAULT '0' COMMENT '#1½»Á÷BÏàµçÁ÷',
|
`acic_1` float NOT NULL DEFAULT '0' COMMENT '#1½»Á÷CÏàµçÁ÷',
|
`acua_2` float NOT NULL DEFAULT '0' COMMENT '#2½»Á÷AÏàµçѹ',
|
`acub_2` float NOT NULL DEFAULT '0' COMMENT '#2½»Á÷BÏàµçѹ',
|
`acuc_2` float NOT NULL DEFAULT '0' COMMENT '#2½»Á÷CÏàµçѹ',
|
`acia_2` float NOT NULL DEFAULT '0' COMMENT '#2½»Á÷AÏàµçÁ÷',
|
`acib_2` float NOT NULL DEFAULT '0' COMMENT '#2½»Á÷BÏàµçÁ÷',
|
`acic_2` float NOT NULL DEFAULT '0' COMMENT '#2½»Á÷CÏàµçÁ÷',
|
`mod_enable1` int(11) NOT NULL DEFAULT '0' COMMENT '×é1Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`batt_state1` int(11) NOT NULL DEFAULT '0' COMMENT '×é1µç³Ø״̬[0:¸¡³ä 1£º¾ù³ä 2£º¹©µç 3£ººËÈÝ 4£ºÎ²³ä]',
|
`mod_outvol1` float NOT NULL DEFAULT '0' COMMENT '×é1Êä³öµçѹ',
|
`mod_outcurr1` float NOT NULL DEFAULT '0' COMMENT '×é1Êä³öµçÁ÷',
|
`mod_enable2` int(11) NOT NULL DEFAULT '0' COMMENT '×é2Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`batt_state2` int(11) NOT NULL DEFAULT '0' COMMENT '×é2µç³Ø״̬[0:¸¡³ä 1£º¾ù³ä 2£º¹©µç 3£ººËÈÝ 4£ºÎ²³ä]',
|
`mod_outvol2` float NOT NULL DEFAULT '0' COMMENT '×é2Êä³öµçѹ',
|
`mod_outcurr2` float NOT NULL DEFAULT '0' COMMENT '×é2Êä³öµçÁ÷',
|
`mod_enable3` int(11) NOT NULL DEFAULT '0' COMMENT '×é3Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`batt_state3` int(11) NOT NULL DEFAULT '0' COMMENT '×é3µç³Ø״̬[0:¸¡³ä 1£º¾ù³ä 2£º¹©µç 3£ººËÈÝ 4£ºÎ²³ä]',
|
`mod_outvol3` float NOT NULL DEFAULT '0' COMMENT '×é3Êä³öµçѹ',
|
`mod_outcurr3` float NOT NULL DEFAULT '0' COMMENT '×é3Êä³öµçÁ÷',
|
`mod_enable4` int(11) NOT NULL DEFAULT '0' COMMENT '×é4Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`batt_state4` int(11) NOT NULL DEFAULT '0' COMMENT '×é4µç³Ø״̬[0:¸¡³ä 1£º¾ù³ä 2£º¹©µç 3£ººËÈÝ 4£ºÎ²³ä]',
|
`mod_outvol4` float NOT NULL DEFAULT '0' COMMENT '×é4Êä³öµçѹ',
|
`mod_outcurr4` float NOT NULL DEFAULT '0' COMMENT '×é4Êä³öµçÁ÷',
|
`mod_enable5` int(11) NOT NULL DEFAULT '0' COMMENT '×é5Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`batt_state5` int(11) NOT NULL DEFAULT '0' COMMENT '×é5Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`mod_outvol5` float NOT NULL DEFAULT '0' COMMENT '×é5Êä³öµçѹ',
|
`mod_outcurr5` float NOT NULL DEFAULT '0' COMMENT '×é5Êä³öµçÁ÷',
|
`mod_enable6` int(11) NOT NULL DEFAULT '0' COMMENT '×é6Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`batt_state6` int(11) NOT NULL DEFAULT '0' COMMENT '×é6µç³Ø״̬[0:¸¡³ä 1£º¾ù³ä 2£º¹©µç 3£ººËÈÝ 4£ºÎ²³ä]',
|
`mod_outvol6` float NOT NULL DEFAULT '0' COMMENT '×é6Êä³öµçѹ',
|
`mod_outcurr6` float NOT NULL DEFAULT '0' COMMENT '×é6Êä³öµçÁ÷',
|
`mod_enable7` int(11) NOT NULL DEFAULT '0' COMMENT '×é7Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`batt_state7` int(11) NOT NULL DEFAULT '0' COMMENT '×é7µç³Ø״̬[0:¸¡³ä 1£º¾ù³ä 2£º¹©µç 3£ººËÈÝ 4£ºÎ²³ä]',
|
`mod_outVol7` float NOT NULL DEFAULT '0' COMMENT '×é7Êä³öµçѹ',
|
`mod_outcurr7` float NOT NULL DEFAULT '0' COMMENT '×é7Êä³öµçÁ÷',
|
`mod_enable8` int(11) NOT NULL DEFAULT '0' COMMENT '×é8Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`batt_state8` int(11) NOT NULL DEFAULT '0' COMMENT '×é8µç³Ø״̬[0:¸¡³ä 1£º¾ù³ä 2£º¹©µç 3£ººËÈÝ 4£ºÎ²³ä]',
|
`mod_outvol8` float NOT NULL DEFAULT '0' COMMENT '×é8Êä³öµçѹ',
|
`mod_outcurr8` float NOT NULL DEFAULT '0' COMMENT '×é8Êä³öµçÁ÷',
|
`mod_enable9` int(11) NOT NULL DEFAULT '0' COMMENT '×é9Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`batt_state9` int(11) NOT NULL DEFAULT '0' COMMENT '×é9µç³Ø״̬[0:¸¡³ä 1£º¾ù³ä 2£º¹©µç 3£ººËÈÝ 4£ºÎ²³ä]',
|
`mod_outvol9` float NOT NULL DEFAULT '0' COMMENT '×é9Êä³öµçѹ',
|
`mod_outcurr9` float NOT NULL DEFAULT '0' COMMENT '×é9Êä³öµçÁ÷',
|
`mod_enable10` int(11) NOT NULL DEFAULT '0' COMMENT '×é10Ä£¿éʹÄÜ״̬[0-¶Ï¿ª 1-±ÕºÏ]',
|
`batt_state10` int(11) NOT NULL DEFAULT '0' COMMENT '×é10µç³Ø״̬[0:¸¡³ä 1£º¾ù³ä 2£º¹©µç 3£ººËÈÝ 4£ºÎ²³ä]',
|
`mod_outvol10` float NOT NULL DEFAULT '0' COMMENT '×é10Êä³öµçѹ',
|
`mod_outcurr10` float NOT NULL DEFAULT '0' COMMENT '×é10Êä³öµçÁ÷',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='²¢ÁªBTSÍØÆË״̬ÐÅÏ¢';
|
|
|
V1.64 edit at date 2023-04-01
|
1.db_app_sys.tb_menuÐÂÔö
|
`lableEnUs` varchar(255) DEFAULT '' COMMENT '¹ú¼Ê»¯Ó¢ÎÄÁÐ'
|
2.db_app_sys.tb_page_paramÐÂÔö
|
`paramEnUs` varchar(255) DEFAULT '' COMMENT '¾ßÌå²ÎÊý¹ú¼Ê»¯Ó¢ÎÄ'
|
3.db_app_sys.tb_page_param_userÐÂÔö
|
`lableEnUs` varchar(255) DEFAULT NULL COMMENT '±êÇ©¹ú¼Ê»¯Ó¢ÎÄ'
|
4.db_app_sys.tb_page_param2
|
`lableEnUs` varchar(255) DEFAULT '' COMMENT '±êÇ©¹ú¼Ê»¯Ó¢ÎÄÃû'
|
|
V1.63 edit at date 2023-03-28
|
1.ÐÂÔöɽÎ÷µçÔ´µçÔ´¸æ¾¯²ÎÊýÖØÔØỊ̈߳¬ÓÃÓÚ¼ÓÔصçÔ´¸æ¾¯²ÎÊý
|
2.±í'wei_site.tb_battdischarge_plan_temp'ÐÂÔö×Ö¶Î
|
`approve_reason` varchar(255) DEFAULT NULL COMMENT 'ÉóºËÔÒò'
|
3.ÐÂÔö·Åµç¼Æ»®ÈÕÖ¾±í 'wei_site.tb_battdischarge_plan_log'
|
CREATE TABLE `tb_battdischarge_plan_log` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`plan_id` int(11) DEFAULT NULL COMMENT '·Åµç¼Æ»®±íÖ÷¼ünum',
|
`type` tinyint(4) DEFAULT NULL COMMENT '1-È¡Ïû¼Æ»®,2-Æô¶¯¼Æ»®,3-Ð޸ķŵç²ÎÊý,4-Ð޸ķŵ翪ʼʱ¼ä',
|
`reason` varchar(255) DEFAULT NULL COMMENT '¸üÐÂÔÒò',
|
`msg` varchar(255) DEFAULT NULL COMMENT '±ä¸üÇ°ºó±ä»¯ÃèÊö',
|
`user_id` int(11) DEFAULT NULL,
|
`create_time` datetime DEFAULT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='·Åµç¼Æ»®ÈÕÖ¾±í';
|
|
V1.62 edit at date 2023-03-22
|
1.´´½¨É½Î÷µçÔ´¸æ¾¯²ÎÊý±í'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'£¬²¢Â¼ÈëËùÓеçÔ´É豸¸æ¾¯²ÎÊý
|
CREATE TABLE `tb_pwrdev_alarm_param_forsx` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü',
|
`PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT 'µçÔ´id',
|
`alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯id',
|
`alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '¸æ¾¯µÈ¼¶',
|
`alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÉÏÏÞãÐÖµ',
|
`alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'ÉÏÏ޸澯ʹÄÜ',
|
`alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÏÂÏÞãÐÖµ',
|
`alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÏÂÏÞʹÄÜ',
|
`alarm_source` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯Êý¾ÝÀ´Ô´[0-É豸¸æ¾¯µãλÅжϣ»1-µ±Ç°ãÐÖµÅжÏ]',
|
`alarm_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'µ±Ç°¸æ¾¯ÃèÊö',
|
`alarm_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-ÉÏÏÂÏÞÓÐЧ 1-ÉÏÏÞÓÐЧ 2-ÏÂÏÞÓÐЧ',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=utf8 COMMENT='ɽÎ÷µçÔ´¸æ¾¯²ÎÊý±í';
|
2.±í'db_pwrdev_alarm.tb_pwrdev_alarm'±íÐÂÔö×ֶΠÓÃÓÚ±êʶµ±Ç°¸æ¾¯À´Ô´
|
`alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'
|
3.±í'db_pwrdev_alarm.tb_pwrdev_alarm_history'±íÐÂÔö×ֶΠÓÃÓÚ±êʶµ±Ç°¸æ¾¯À´Ô´
|
`alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'
|
|
|
V1.61 edit at date 2023-03-17
|
1.'web_site.tb_battdischarge_plan'±íÐÂÔö×Ö¶Î'nodeStation'
|
`nodeStation` int(11) NOT NULL DEFAULT '0' COMMENT 'Õ¾µãÀàÐÍ[½ÚµãÕ¾±êʶ:0:²»ÊǽڵãÕ¾[ĬÈÏ];1:½ÚµãÕ¾]'
|
2.'web_site.tb_battdischarge_plan'±íÐÂÔö×Ö¶Î'baoji_group_id'
|
`baoji_group_id` int(11) NOT NULL DEFAULT '0' COMMENT '°ü»ú×éid'
|
3.'web_site.tb_battdischarge_plan'±íÐÂÔö×Ö¶Î'create_time'
|
`create_time` datetime DEFAULT NULL COMMENT '´´½¨Ê±¼ä'
|
4.´´½¨·Åµç¼Æ»®ÁÙʱ±í 'web_site.tb_battdischarge_plan_temp'
|
CREATE TABLE `tb_battdischarge_plan_temp` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`station_id` varchar(20) DEFAULT NULL COMMENT '»ú·¿id',
|
`station_name` varchar(100) DEFAULT NULL COMMENT '»ú·¿Ãû³Æ',
|
`batt_group_id` int(11) DEFAULT NULL COMMENT '°ü»ú×éid',
|
`batt_group_name` varchar(100) DEFAULT NULL COMMENT 'µç³Ø×éÃû³Æ',
|
`group_id` bigint(20) DEFAULT NULL COMMENT '°à×éid,Óë°ü»ú×éÒ»ÖÂ',
|
`group_name` varchar(200) DEFAULT NULL COMMENT '°à×éÃû³Æ,Óë°ü»ú×éÒ»ÖÂ',
|
`node_station` tinyint(1) DEFAULT NULL COMMENT 'ÊÇ·ñ½ÚµãÕ¾',
|
`mon_cap_std` float DEFAULT NULL COMMENT '±ê³ÆÈÝÁ¿',
|
`mon_vol_std` float DEFAULT NULL COMMENT '±ê³Æµ¥Ìåµçѹ',
|
`cap_percent` float DEFAULT NULL COMMENT '·ÅµçÈÝÁ¿°Ù·Ö±È',
|
`discharge_start_time` datetime DEFAULT NULL COMMENT '·Åµç¿ªÊ¼Ê±¼ä',
|
`create_time` datetime DEFAULT NULL COMMENT '´´½¨Ê±¼ä',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='·Åµç¼Æ»®ÁÙʱ±í';
|
|
|
V1.60 edit at date 2023-03-16
|
1.'db_user.tb_user_battgroup_baojigroup'ÐÂÔö×Ö¶Î'discharge_plan_flag' -- ÓÃÓÚ±êʶ·Åµç¼Æ»®ÊÇ·ñÆôÓÃ
|
ALTER TABLE `db_user`.`tb_user_battgroup_baojigroup` ADD COLUMN `discharge_plan_flag` TINYINT(1) UNSIGNED NULL DEFAULT 0 COMMENT '·Åµç¼Æ»®±êʶ:0²»²ÎÓë·Åµç¼Æ»®,1²ÎÓë·Åµç¼Æ»®' AFTER `baoji_group_name`;
|
2.'db_ram_db.tb_li9130_bms_state' ÐÂÔö×ֶΠ'reserved1' - Ô¤Áô[²©Ç¿-ÎÞ£»ÍØ°î-¾ùºâζÈ]
|
ALTER TABLE `db_ram_db`.`tb_li9130_bms_state` ADD COLUMN `reserved1` float NOT NULL DEFAULT '0' COMMENT 'Ô¤Áô[²©Ç¿-ÎÞ£»ÍØ°î-¾ùºâζÈ]';
|
|
V1.59 edit at date 2023-03-08
|
1.¸ù¾Ýµç³ØÐÅÏ¢ÅäÖÃÖеÄÊý¾Ý£¬½«Î´Â¼Èë»ú·¿×ܱíµÄ»ú·¿£¬Â¼Èë»ú·¿×ܱí
|
2.¸ù¾ÝµçÔ´ÐÅÏ¢ÅäÖÃÖеÄÊý¾Ý£¬½«Î´Â¼Èë»ú·¿×ܱíµÄ»ú·¿£¬Â¼Èë»ú·¿×ܱí
|
3.´´½¨²Ëµ¥ÅäÖñí `db_app_sys`.`tb_menu_user`
|
CREATE TABLE `tb_menu_user` (
|
`num` int(11) NOT NULL AUTO_INCREMENT COMMENT '×ÔÔö³¤Ö÷¼ü',
|
`id` int(11) DEFAULT NULL COMMENT '²Ëµ¥id',
|
`label` varchar(255) DEFAULT NULL COMMENT 'ÖÐÎÄÃû³Æ',
|
`name` varchar(255) DEFAULT NULL COMMENT 'Ãû³Æ',
|
`src` varchar(255) DEFAULT NULL COMMENT '·¾¶',
|
`icon` varchar(100) DEFAULT NULL COMMENT 'ͼ±ê',
|
`closable` tinyint(4) DEFAULT NULL COMMENT 'ÊÇ·ñ¿É¹Ø±Õ',
|
`enableduse` tinyint(4) DEFAULT NULL COMMENT 'ÊÇ·ñÆôÓÃ',
|
`permitName` varchar(255) DEFAULT NULL COMMENT 'ȨÏÞ',
|
`level` tinyint(4) DEFAULT NULL COMMENT '²Ëµ¥µÈ¼¶',
|
`ord` tinyint(4) DEFAULT NULL COMMENT 'ÅÅÐò',
|
`menuId` int(11) DEFAULT NULL COMMENT 'Éϼ¶²Ëµ¥id',
|
`userId` int(11) DEFAULT NULL COMMENT 'Óû§id',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
V1.58 edit at date 2023-03-07
|
1.ÐÂÔö´´½¨»ú·¿×ܱí
|
CREATE TABLE `tb_station_inf` (
|
`num` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü',
|
`stationId` varchar(255) NOT NULL DEFAULT '0' COMMENT '»ú·¿Id',
|
`stationName1` varchar(255) NOT NULL DEFAULT '' COMMENT 'Ê¡',
|
`stationName2` varchar(255) NOT NULL DEFAULT '' COMMENT 'ÊÐ',
|
`stationName3` varchar(255) NOT NULL DEFAULT '' COMMENT '»ú·¿Ãû³Æ[¼òд]',
|
`stationName4` varchar(255) NOT NULL DEFAULT '' COMMENT 'É豸Ãû³Æ',
|
`stationName5` varchar(255) NOT NULL DEFAULT '' COMMENT 'ÇøÏØ',
|
`stationName` varchar(255) NOT NULL DEFAULT '' COMMENT '»ú·¿Ãû³Æ[Æ´½ÓºóµÄ]',
|
`deviceType` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸ÀàÐÍ',
|
`nodeStation` int(11) NOT NULL DEFAULT '0' COMMENT 'Õ¾µãÀàÐÍ[½ÚµãÕ¾±êʶ:0:²»ÊǽڵãÕ¾[ĬÈÏ];1:½ÚµãÕ¾]',
|
`stationType` varchar(255) NOT NULL DEFAULT '' COMMENT 'Õ¾µãµçѹµÈ¼¶[£¨35kv/110kv/220kv ×Ö·û´®ÀàÐÍ£©]',
|
`stationLongitude` double NOT NULL DEFAULT '0' COMMENT '¾¶È',
|
`stationLatitude` double NOT NULL DEFAULT '0' COMMENT 'γ¶È',
|
`stationAddr` varchar(255) NOT NULL DEFAULT '' COMMENT '»ú·¿ÏêϸµØÖ·',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8 COMMENT='»ú·¿×ÜÕ¾±í = µç³ØÐÅÏ¢±í + µçÔ´ÐÅÏ¢±í ';
|
|
|
V1.57 edit at date 2023-03-03
|
1.Ï̼߳à¿Ø±íÖÐÐÂÔöwebƽ̨¼à¿ØÏ̼߳Ǽ£¬ÓÃÓÚ¼à¿Øƽ̨·þÎñµÄÔËÐÐ״̬£¬±£Ö¤Æ½Ì¨·þÎñ²»Í£Ö¹
|
sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11024', 'WEB_PLATFORM_SERVER', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'WEB_PLATFORM_SERVER', '1', 'v1.100', 'Ðîµç³ØWEBƽ̨·þÎñ', '300');");
|
|
V1.56 edit at date 2023-02-25
|
1.ϵͳ±í'db_app_sys.tb_app_sys'±íÐÂÔö×Ö¶ÎÓÃÓÚÔËÐÐbuildºóµÄÖØÔصç³ØÐÅÏ¢
|
`AppServer_Reinit_BattGroupData_FBO4815_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÖØÐÂFBO4815Ï̼߳ÓÔØ»ú·¿ÐÅÏ¢',
|
2.ºǫ́Ï̼߳à¿Ø±íÖÐÐÂÔöÒ»ÐÐÊý¾ÝÓÃÓÚ¼à¿ØFBO4815ͨÐÅÏ̵߳ÄÔËÐÐ×´¿ö
|
//FBO4815ͨÐÅÏß³Ì
|
res = sql.sqlMysqlQuery("SELECT ProcessName FROM "+ Sql_Mysql.ProcessSurvey_Table + " WHERE ProcessId = 11023");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11023', 'BMS_BATT_FBO_4815NT', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_BATT_FBO_4815NT', '2', 'v1.100', 'FBO4815ͨÐÅÏß³Ì', '300');");
|
}
|
|
V1.55 edit at date 2023-02-23
|
1.µç³ØÐÅÏ¢±íÐÂÔö×ֶΠ'db_battinf.tb_battinf'±íÐÂÔö×Ö¶Î
|
`NodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '½ÚµãÕ¾±êʶ:0:²»ÊǽڵãÕ¾[ĬÈÏ] 1:½ÚµãÕ¾',
|
`StationType` varchar(255) DEFAULT NULL COMMENT 'Õ¾µãÀàÐÍ[ÀýÈç110V/22V]',
|
|
V1.54 edit at date 2023-02-21
|
1.µç²ÙºËÈÝÐÅÏ¢±íÐÂÔö×ֶΠ'db_ram_db.tb_dev_60870_inverter_info'±íÐÂÔö×Ö¶Î
|
`standState` int(11) NOT NULL DEFAULT '0' COMMENT '¾²ÖÃ״̬[0:ÎÞ£»1£º¾²ÖÃ]',
|
`standNum` int(11) NOT NULL DEFAULT '1' COMMENT '¾²ÖÃ×éºÅ[1:×é1;2-×é2]',
|
`standTime` int(11) NOT NULL DEFAULT '0' COMMENT '¾²ÖÃʱ¼ä(Ãë)[µ¹¼Æʱ]',
|
|
V1.53 edit at date 2023-02-15
|
1.'db_battinf.tb_a059_station_inf' ÐÂÔö×Ö¶ÎÓÃÓÚ±êʶµ¼ÈëµÄ»ú·¿ÐÅÏ¢
|
`station_type` int(11) NOT NULL DEFAULT '0' COMMENT '»ú·¿ÀàÐÍ[0:³ä·ÅµçÒ»Ìå»ú£»1:FBO4830]'
|
2.'db_ram_db.tb_li9130_bms_state' ÐÂÔö×Ö¶ÎÓÃÓÚFBO4830Òòµ¥ÌåζÈÊýÄ¿²»¶¨,ÐÂÔö×Ö·û´®mon_tmps
|
`mon_tmps` varchar(256) NOT NULL DEFAULT '' COMMENT 'µ¥ÌåζÈÆ´½Ó×Ö·û´®',
|
3.Ï̼߳à¿ØÖÐÌí¼Óµç²ÙºËÈÝ»ú·¿ÐÅÏ¢
|
BMS_BATT_60870_MONITOR---------11022
|
|
|
|
V1.52 edit at date 2023-02-09
|
1.'db_battinf'.'tb_battinf'ÐÂÔö×Ö¶Î
|
`LoadCurrFromDis` float NOT NULL DEFAULT '0' COMMENT '¸ºÔصçÁ÷-[À´Ô´ºËÈݷŵçÊý¾Ý]
|
|
|
V1.51 edit at date 2023-01-31
|
1.'db_ram_db.tb_fbs9100_state' ÐÂÔö×Ö¶Î
|
`fbo4830_stopstr` varchar(255) NOT NULL DEFAULT '' COMMENT 'FBO4830µ±Ç°×´Ì¬Îı¾ÏÔʾ'
|
|
V1.50 edit at date 2023-01-13
|
1.'web_site.tb_alarm_voice_set'--¸æ¾¯ÓïÒôÉèÖÃ±íµ¥¶ÀÅжÏÈçÏÂÊý¾Ý±í×Ö¶ÎÊÇ·ñ´æÔÚ²¢´´½¨
|
`user_id` int(11) DEFAULT NULL,
|
`status` int(11) DEFAULT NULL COMMENT '1:ÓÐЧ\n0:ÎÞЧ\n',
|
`next_timestamp` bigint(20) DEFAULT NULL COMMENT 'Ï´β¥·ÅµÄʱ¼ä´Á',
|
2.н¨±í'db_pwrdev_alarm.tb_pwrdev_alarm_config'
|
CREATE TABLE `tb_pwrdev_alarm_config` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`SMS_CommPort` varchar(10) NOT NULL DEFAULT ' ',
|
`SMS_CommPort_ReInit` tinyint(1) NOT NULL DEFAULT '0',
|
`Beeper_CommPort` varchar(10) NOT NULL DEFAULT ' ',
|
`Beeper_CommPort_ReInit` tinyint(1) NOT NULL DEFAULT '0',
|
`SMS_Alarm_Text` varchar(100) NOT NULL DEFAULT ' ',
|
`SMS_Alarm_EN` tinyint(1) NOT NULL DEFAULT '0',
|
`Beeper_Alarm_EN` tinyint(1) NOT NULL DEFAULT '0',
|
`Beeper_Sound_OFF` tinyint(1) NOT NULL DEFAULT '0',
|
`AlarmDevIP` varchar(30) NOT NULL DEFAULT '192.168.10.223',
|
`SMS_Alarm_ipPort` int(11) NOT NULL DEFAULT '26',
|
`Beeper_Alarm_ipPort` int(11) NOT NULL DEFAULT '27',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
|
3.н¨±í'db_pwrdev_alarm.tb_pwrdev_time_adj_alarm'
|
CREATE TABLE `tb_pwrdev_time_adj_alarm` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`PowerDeviceId` bigint(20) NOT NULL DEFAULT '0',
|
`alarm_typeId` int(11) NOT NULL DEFAULT '0',
|
`detect_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00',
|
`record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00',
|
PRIMARY KEY (`num`),
|
KEY `index_powerdev_id` (`PowerDeviceId`)
|
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
|
4.н¨±í'db_pwrdev_alarm.tb_pwrdev_time_out_alarm'
|
CREATE TABLE `tb_pwrdev_time_out_alarm` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`PowerDeviceId` bigint(20) NOT NULL DEFAULT '0',
|
`alarm_typeId` int(11) NOT NULL DEFAULT '0',
|
`alarm_index` int(11) NOT NULL DEFAULT '0',
|
`timeout_tag` int(11) NOT NULL DEFAULT '0',
|
`read_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00',
|
`system_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00',
|
`resume_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00',
|
PRIMARY KEY (`num`),
|
KEY `index_powerdev_id` (`PowerDeviceId`)
|
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
|
|
V1.49 edit at date 2023-01-13
|
1.'db_ram_db.tb_fbs9100_state' ÐÂÔö×Ö¶Î
|
`fbo4830_is_online` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'FBO4830ÔÚÀëÏß״̬£º0:ÀëÏߣ»1£ºÔÚÏß',
|
2.ÐÂÔöÊý¾Ý±í'web_site.tb_alarm_voice_set'--¸æ¾¯ÓïÒôÉèÖÃ
|
CREATE TABLE `tb_alarm_voice_set` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`batt_group_id` int(11) DEFAULT NULL COMMENT '°üº¬µç³Ø×éid,É豸',
|
`device_id` bigint(20) DEFAULT NULL,
|
`power_device_id` bigint(20) DEFAULT NULL,
|
`alarm_type` int(11) DEFAULT NULL,
|
`next_time_interval` int(11) DEFAULT NULL COMMENT 'Ï´β¥±¨¼ä¸ôʱ¼ä,µ¥Î»/·ÖÖÓ',
|
`user_id` int(11) DEFAULT NULL,
|
`status` int(11) DEFAULT NULL COMMENT '1:ÓÐЧ\0:ÎÞЧ',
|
`next_timestamp` bigint(20) DEFAULT NULL COMMENT 'Ï´β¥·ÅµÄʱ¼ä´Á',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='¸æ¾¯ÓïÒôÉèÖÃ';
|
|
|
V1.48 edit at date 2022-12-15
|
º¼ÖÝ﮵çBTS
|
1.db_ram_db.tb_batt_rtstate ÐÂÔö×Ö¶Î
|
`dev_testPower` float NOT NULL DEFAULT '0' COMMENT 'É豸ÏûºÄµçÄÜ[wh]ÓÃÓÚÓõçÁ¿Í³¼Æ'
|
|
2.db_ram_db.tb_fbs9100_state ÐÂÔö×Ö¶Î
|
`elec_comb_acttive_energy` float NOT NULL DEFAULT '0' COMMENT 'µç±í×éºÏÓ馵çÄÜ¡¾kWh¡¿',
|
`elec_posi_acttive_energy` float NOT NULL DEFAULT '0' COMMENT 'µç±íÕýÏòÓ馵çÄÜ¡¾kWh¡¿',
|
`elec_rever_acttive_energy` float NOT NULL DEFAULT '0' COMMENT 'µç±í·´ÏòÓ馵çÄÜ¡¾kWh¡¿',
|
`elec_active_power` float NOT NULL DEFAULT '0' COMMENT 'µç±íÓй¦¹¦ÂÊ¡¾W¡¿',
|
`elec_vol` float NOT NULL DEFAULT '0' COMMENT 'µç±í²âÁ¿µçѹ[V]',
|
`elec_curr` float NOT NULL DEFAULT '0' COMMENT 'µç±í²âÁ¿µçÁ÷[A]'
|
`load_vol_fromhjq` float NOT NULL DEFAULT '0' COMMENT '¸ºÔصçѹ£¨V£©-»ã¼¯Æ÷',
|
`load_curr_fromhjq` float NOT NULL DEFAULT '0' COMMENT '¸ºÔصçÁ÷£¨A£©-»ã¼¯Æ÷',
|
`dev_power` float NOT NULL DEFAULT '0' COMMENT 'É豸¹¦ÂÊ(KW)',
|
|
3.web_site.tb_peak_statistics ÐÂÔö×Ö¶Î
|
`electric_fromelec` float NOT NULL DEFAULT '0' COMMENT 'µçÄܱíչʾµÄÓõçÁ¿'
|
|
4.web_site.tb_process_survey ÐÂÔöÏß³ÌÊý¾Ý - FBO4830NTͨÐÅÏß³Ì - 11021
|
|
5.db_app_sys.tb_app_sys ÐÂÔö×Ö¶Î
|
`AppServer_Reinit_BattGroupData_FBO4830_EN` tinyint(1) NOT NULL DEFAULT '0',
|
|
|
|
V1.389 edit at date 2017-1-3
|
1£º½â¾öFBSϵÁÐʵʱÊý¾Ý¿â²»¸üÐÂÊý¾ÝµÄÎÊÌ⣬BattData_RT_ArrayÀàÖÐ
|
rtdata.al_MonVol_RtOld.add(data)ÐÞÕýΪrtdata.al_MonVol_RtOld.add(data.clone())¡£2017-1-3
|
£¨Ó°Ï췶Χ£ºFBSϵÁа汾£©
|
|
V1.388 edit at date 2016-12-27
|
1£ºBattData_RT_ArrayÀàÖеÄinitBattDataRT_Inf_FromSQL()ÖÐÔö¼Órtdata.al_MonVol.size()²»´óÓÚrtdata.MonCountµÄÏÞÖÆ¡£2016-12-27
|
£¨Ó°Ï췶Χ£ºCMCC°æ±¾£©
|
|
V1.387 edit at date 2016-11-02
|
1: ½«tb_app_sys±íÖеÄAppServer_VersionµÄ°æ±¾×îµÍÉ趨ΪV1.388,ÒÔ±ãV1.087ÒÔÉϵĿͻ§¶Ëʶ±ð·þÎñÆ÷¶ËµÄ°æ±¾,²¢×÷³öÌáʾ¡£
|
2: ½«tb_batttestdata_inf±íÖеÄÌí¼Óupload_data_ext£¨Çø·Ö.FBO»ò.IDCÊý¾Ý£©Óëupload_client_type£¨
|
Çø·ÖÉÏ´«µÄ¿Í»§¶Ë£ºBS_CLI,CS_CLI,CS_SVR£©×ֶΡ£2016-11-02
|
3: ½«tb_battresdata_inf±íÖеÄÌí¼Óupload_client_type£¨Çø·ÖÉÏ´«µÄ¿Í»§¶Ë£ºBS_CLI,CS_CLI,CS_SVR£©×ֶΡ£2016-11-02
|
|
V1.386 edit at date 2016-10-26
|
1: ÐÞ¸´Í¨¹ýÊÖ»úÉÏ´«.FBOÊý¾Ýʱ, ·Åµç¿ªÊ¼ÈÕÆÚʱ¼äÔ·ݴíÎóµÄÎÊÌ⣬½âÎöµÄÔ·ݱÈʵ¼ÊµÄ¶àÒ»¸öÔ¡££¨Ó°Ï췶Χ£ºÈ«ÏµÁа汾£©- 2016-10-26
|
|
V1.385 edit at date 2016-10-15
|
1£ºFBS9600/9600SÖ§³ÖTCP-ModBusÐÒé,´Ëʱ·þÎñÆ÷µç³Ø×éÅäÖÃÐÅÏ¢ÖеÄFBS9600/9600SµÄÉ豸ID±ØÐëÉèÖÃΪ9610xxxx¡£
|
,ËäȻʹÓÃTCP-ModBusÐÒé,µ«Êý¾Ý°üÖÐĩβÈÔȻЯ´øModBusµÄCRC16УÑé¡££¨Ó°Ï췶Χ£ºFBS9600/9600SϵÁУ© - 2016-10-15
|
2£ºÐÞ¸´¶ÁÈ¡FBS9100µ¥ÌåÄÚ×èÊý¾Ýʱ±¶ÂÊ´íÎóµÄÎÊÌâ,ÓÉ֮ǰµÄ0.001¸ÄΪ0.01¡££¨Ó°Ï췶Χ£ºFBS9600/9600SϵÁУ© - 2016-10-18
|
3£ºÐÞ¸´FBR-5000CTµÄÊý¾ÝºÍÃÜÌص絼ÒÇÊý¾ÝµÄÊÖ»úAPPÉÏ´«Ê±·þÎñÆ÷¶Ë¶ÔÊý¾ÝµÄУ¶ÔÉóºËÎÊÌâ,ÓÉδÉóºË¸ÄΪÉóºË¡£
|
|
V1.384 edit at date 2016-10-14
|
1£ºÖ§³ÖÄÚ×è¼ÆFBR-5000CTµÄÊý¾ÝºÍÃÜÌص絼ÒÇÊý¾ÝµÄÊÖ»úAPPÉÏ´«¡££¨Ó°Ï췶Χ£ºFBS9600£© - 2016-10-14
|
|
V1.383 edit at date 2016-10-10
|
1£º¸Ã°æ±¾ÒÔÉϵÄFBSϵÁеÄÔÚÏß¼à²âÊý¾Ý±£´æµÄ×îС¼ä¸ô»Ö¸´Îª10·ÖÖÓ¡££¨Ó°Ï췶Χ£ºFBS9600£© - 2016-10-10
|
|
V1.382 edit at date 2016-10-10
|
1£º¶ÔÓÚFBO°æ±¾£¬ÊµÊ±µç³ØÊý¾ÝÖ»½¨±í£¬²»¸úÐÂÊý¾Ý£¬±ÜÃâ·þÎñÆ÷¿ÕÅÜÀ˷ѵçÄÜ¡££¨Ó°Ï췶Χ£ºFBOϵÁУ© - 2016-10-10
|
2£ºÐÞ¸´µç³Ø×éÐÅϢΪ¿Õʱ£¬ÊµÊ±ÄÚ´æ±íÊý¾Ý²åÈëÓï¾ä´íÎóµÄÎÊÌ⣬´Ëʱ²»½øÐÐÄÚ´æ±í½¨±íÓëÊý¾Ý²åÈë²Ù×÷¡££¨Ó°Ï췶Χ£ºÈ«ÏµÁУ© - 2016-10-10
|
3: ¸Ã°æ±¾µÄFBSϵÁеÄÔÚÏß¼à²âÊý¾Ý±£´æµÄ×îС¼ä¸ôΪ1·ÖÖÓ£¬ÎªÌØÊâ²âÊÔ°æ±¾¡££¨Ó°Ï췶Χ£ºFBS9600£© - 2016-10-10
|
|
V1.380 edit at date 2016-08-23
|
1£ºÐÞ¸´FBS9600ͨÐŹÊÕϸ澯ÑÓʱʱ¼äΪ10ÃëÖÓ£¬Í¨Ðųö´íÖØÊÔ´ÎÊýΪ10´Î¡££¨Ó°Ï췶Χ£ºFBS9600£© - 2016-08-23
|
|
V1.379 edit at date 2016-08-02
|
1£º±ä¸üÐéÄâ¼Ù¸ºÔØÖ§³ÖÅжϡ±ÀÕ¢·Åµç¡°Ó롱·ÇÀÕ¢·Åµç¡°µÄÇø·Ö£¬ÐèÅäÌ×V1.076ÒÔÉϵĿͻ§¶Ë¡££¨Ó°Ï췶Χ£ºÈ«ÏµÁа汾£© - 2016-08-01
|
2£ºÐÞ¸´FBS9600ͨÐÅ°üÀïCRC16¸ßµÍ×Ö½Ú˳ÐòµÄÎÊÌ⣬´ËÇ°ÓÉÓÚÓÃÒÔÌ«ÍøͨÐŶøδʹÓÃCRC16УÑé¡££¨Ó°Ï췶Χ£ºFBS9600£© - 2016-08-01
|
|
V1.378 edit at date 2016-07-13
|
1£ºÌí¼Ó×÷Òµ±ä¸ü¹ÜÀíÊý¾Ý¿â±í¡££¨Ó°Ï췶Χ£ºBMP7100£© - 2016-06-23
|
|
V1.377 edit at date 2016-06-23
|
1£ºÐÞ¸´bpm7100Ä£¿éͨÐŹÊÕϵÄÉ豸¸æ¾¯¹¤×÷²»Õý³£µÄÎÊÌâ¡££¨Ó°Ï췶Χ£ºBMP7100£© - 2016-06-23
|
|
V1.376 edit at date 2016-05-19
|
1£ºÖ§³Öbpm7100Ä£¿éͨÐŹÊÕÏÊý¾Ý×Ô¶¯ÇåÁã,ÅäÖÃÎļþÖÐ"bpm7100_commerr_dataclear_en"Ñ¡Ïî¾ö¶¨ÊÇ·ñÆôÓøù¦ÄÜ¡££¨Ó°Ï췶Χ£ºBMP7100£© - 2016-06-16
|
2£º½«¸æ¾¯µÄ·§Öµ±È½ÏÓɾø¶ÔÖµ¸ÄΪÕý³£Öµ¡££¨Ó°Ï췶Χ£ºÈ«ÏµÁа汾 - 2016-06-16£©
|
|
V1.375 edit at date 2016-05-19
|
1£º·þÎñÆ÷״̬±íÖÐÔö¼ÓÊý¾Ý¿âÁ¬½ÓÊýÁ¿²éѯ
|
2£ºÊý¾Ý¿âÔö¼Ó×Ô¶¯È«±¸·Ý¹¦ÄÜ,±¸·Ýʱ¼ä¼ä¸ôÔÚÅäÖÃÎļþÖÐÉèÖÃ,×îб¸·Ýʱ¼äÔÚdb_app_sys.tb_app_sysÖвéѯ¡££¨Ó°Ï췶Χ£ºÈ«ÏµÁа汾£©
|
|
V1.374 edit at date 2016-05-19
|
1£º·þÎñÆ÷״̬±íÖÐÔö¼Ó·þÎñÆ÷¶ËËùÔÚÅÌ·ûµÄÓ²ÅÌ´æ´¢ÈÝÁ¿²éѯºÍÊý¾Ý¿âÁ¬½ÓÊýÁ¿²éѯ
|
|
V1.373 edit at date 2016-05-19
|
1: µç³Ø²âÊÔÊý¾ÝÔö¼Ó×é¶Ëζȣ¬Ã»ÓиıäÊý¾Ý±í½á¹¹,Ö»ÊÇÔö¼ÓÒ»±ÊÊý¾Ý²åÈ룬mon_num=100010,mon_vol=×é¶Ëζȡ££¨Ó°Ï췶Χ£ºBMP7100£© - 2016-05-19
|
2£º·þÎñÆ÷¶ËʵʱÊý¾Ý¿â±íÊý¾ÝÖУ¬Ôö¼Ó×é¶Ëζȡ££¨Ó°Ï췶Χ£ºÈ«ÏµÁа汾£© - 2016-05-19¡£
|
|
V1.372 edit at date 2016-05-17
|
1: Ôö¼ÓFBS9600ºÍBPM7100 socketͨÐųö´í¶à´ÎÖØÊÔ¹¦ÄÜ£¬ÒÔÔö¼ÓͨÐÅ¿É¿¿ÐÔ¡££¨Ó°Ï췶Χ£ºFBS9600ºÍBMP7100£© - 2016-05-17¡£
|
|
V1.371 edit at date 2016-05-10
|
1: ÐÞ¸ÄBMP7100µÄÊý¾Ý¼à²â¼Ç¼Âß¼£¬È¡Ïûµçѹ±ä»¯·§Öµ±£´æ¹¦ÄÜ¡££¨Ó°Ï췶Χ£ºBMP7100£© - 2016-05-10¡£
|
|
V1.37 edit at date 2016-04-24
|
1: ¡°BattDataTestPro_Thread¡±Ê¹ÓÃTimer Task¶¨Ê±Ö´ÐÐÏà¹ØÈÎÎñ£¨Ó°Ï췶Χ£ºÈ«ÏµÁа汾£©¡£
|
2: µç³Øʵʱ״̬ºÍÊý¾ÝʹÓÃÊý¾Ý¿âÄÚ´æ±í£¨Ó°Ï췶Χ£ºÈ«ÏµÁа汾£©¡£
|
3: Ôö¼ÓÉ豸ͨÐŹÊÕϸ澯£¨Ó°Ï췶Χ£ºÈ«ÏµÁа汾£¬FBO°æ±¾³ýÍ⣩- 2016-04-26¡£
|
4£ºµç³Ø¸æ¾¯Êý¾Ý±íÓëÉ豸¸æ¾¯Êý¾Ý±íµÄ×ÔÔö×Ö¶ÎnumÀàÐ͸ÄΪBIGINTÀàÐÍ£¬±ÜÃâ¸Ã×Ö¶ÎÒòµ½´ï×î´óÖµ¶øÔì³Éinsert²Ù×÷³ö´í¡£
|
|
V1.36 edit at date 2016-04-23
|
1: class "BattStatData" add a member "recordNum_BPM7100" witch type is int,
|
"recordNum_BPM7100" is used by function "check_If_Bpm7100_DataNeedStore()" in class "BattData_RT"
|
and is used by function "bpm7100_init(byte batt_state)" int class "BattStatData",
|
"recordNum_BPM7100" is used to determine if data_record_count is upto "mTestDataRecordCountMax"
|
and then pause inser data to mysql db.£¨Ó°Ï췶Χ£ºBpm7100°æ±¾£©
|
|
V1.36 edit at date 2016-04-18
|
1: class "BattData_RT" add a function "check_If_Bpm7100_DataNeedStore()" for BPM_7100 monitor only,
|
It's called in class thread function "run()" in class "BattDataTestPro_Thread".
|
2: class "BattStatData" add a boolean type member "bpm7100_runState", It's used to determine wether
|
the BPM_7100 system is in "monitor" state witch will work data process and save data into mysql db,
|
like dischage and charge test.£¨Ó°Ï췶Χ£ºBpm7100°æ±¾£©
|
|
V1.36 edit at date 2016-04-16
|
1: Êý¾Ý±íTB_BattInfÔö¼ÓÁË»ú·¿Ãû³Æ¡¢µç³Ø×éÃû¡¢»ú·¿ID¡¢µç³Ø×éIDË÷Òý£¬²âÊÔÊý¾ÝÔö¼ÓÁ˵ç³Ø×éID¡¢²âÊÔÈÕÆÚË÷Òý
|
£¨Ó°Ï췶Χ£ºÈ«ÏµÁа汾£©¡£
|
|
V1.37 edit at date 2019-01-08
|
1.ÔÚweb_siteÊý¾Ý¿âÏÂн¨Ḭ̈߳ïÖú±íÓÃÓÚÊÖ¶¯Æô¶¯Ä³Ð©Ïß³Ì
|
|
V1.38 edit at date 2019-01-08
|
1.ÐÞ¸´ÁËÎÞÂÛÊÇ·ñÖؽ¨±í¶¼ÐèÒªÖؽ¨ db_ram_db.tb_server_state ±í£¬ ---¡·ÐÞ¸´Ç°ÆÚÊý¾Ý¿â±í¸ñʽbug MEMORY -> InnoDB
|
|
V1.39 edit at date 2019-07-15
|
1.ÔÚweb_siteÊý¾Ý¿âÖÐÌí¼ÓÁËtb_batt_discharge±íÓÃÓÚ´æ·Å»ú·¿·ÅµçºÚÃûµ¥±í
|
|
V1.40 edit at date 2019-07-30
|
1.ÔÚdb_app_sys.tb_app_sys±íÖÐÌí¼ÓAppServer_Reinit_BattGroupData_LD9_EN×Ö¶ÎÓÃÓÚ9¶ÈÉ豸ÖØÔØÉ豸Êý¾Ý
|
|
V1.41 edit at date 2019-08-13
|
1.ÔÚÔËÐгÌÐòʱ¼ì²â»ú·¿×´Ì¬±íÖеĻú·¿idºÍÉ豸idµÄ¶ÔÓ¦¹Øϵ²¢ÇÒ½øÐÐÐÞ¸´
|
|
V1.42 edit at date 2019-08-30
|
1.ÔÚ¡¯db_ram_db¡®Êý¾Ý¿âÖд´½¨¡®tb_61850_jhstate¡¯±í£¬ÓÃÓÚ´æ´¢61850¾ùºâ¹©µç²ÎÊýÐÅÏ¢
|
|
V1.43 edit at date 2019-09-24
|
1.ÔÚ'db_ram_db'Êý¾Ý¿âÖеıí'tb_fbs9100_setparam'±íÖÐÌí¼Ó61850ÖеÄÔÚÏßѹµÍºÍÀëÏßÐøº½ÖÜÆÚÖµ
|
2.ÔÚ'db_battinf'Êý¾Ý¿âÖеıí'tb_battinf'ÖÐÌí¼Ó×Ͼ§ÄDZߵĵç³Ø×éÐÅÏ¢ÁÐ
|
|
V1.44 edit at date 2019-12-01
|
1.ÔÚ'web_site'Êý¾Ý¿âÖеıí'tb_battmap_information'±íÖÐÌí¼ÓstationName3×Ö¶ÎÓÃÓÚÅжÏ
|
|
V1.45 edit at date 2019-12-01
|
1.³ÌÐòÔËÐнáÊøºóÖØÆô¸æ¾¯Ïß³Ì(ÐÞ¸ÄÏ̼߳à¿ØÖеÄÔËÐÐ״̬)
|
2.Óû§±íÖÐÌí¼ÓÈý¸ö×Ö¶ÎÓÃÓÚUKEYÅжÏ
|
3.µç³Ø×éÐÅÏ¢ÖÐÒ²Ìí¼ÓÁË4¸öUKEY×Ö¶ÎÓû§UKEYУÑé
|
4.»ú·¿µç³Ø×é¸ü»»¼Ç¼²éѯÖÐÌí¼ÓGroupIndexInFBSDevice×Ö¶ÎÓÃÓÚ±êʶ¸ü»»µÄÄÄÒ»×éµç³Ø
|
|
V1.46 edit at date 2020-06-10
|
1.ÐÞ¸´Òòdb_ram_db.tb_fbs9100_state±íÖÐdev_version×ֶιý¶Ìbug
|
|
V1.47 edit at date 2020-06-10
|
1.ÐÞ¸´Òòµç³Ø×éid²»´æÔÚÔÚµç³Ø·Åµç²âÊÔÖмǼÓû§Ìí¼Ó¹ý·ÅµçµÄ¼Ç¼»ú·¿²»´æÔÚ£¬ÎÞ·¨É¾³ýbug
|
|
V1.48 edit at date 2020-06-10
|
1.ÔÚdb_ram_db.tb_fbs9100_state±íÖÐÌí¼Ó"dev_conresist1"×Ö¶ÎÓÃÓÚÏÔʾ×é2½Ó´¥Æ÷µ¼Í¨×迹
|
|
V1.49 edit at date 2020-08-01
|
1.ÔÚweb_siteÊý¾Ý¿âÖÐн¨tb_dev_restart_plan±íÓÃÓÚÉ豸ÖØÆô¼Æ»®²Ù×÷
|
2.ÔÚÏ̼߳à¿Ø¹ÜÀí±íÖÐÌí¼Ó6¶ÈͨѶÏ̵߳ķþÎñÐÅÏ¢
|
|
V1.50 edit at date 2020-10-16
|
1.ÔÚdb_ram_db.tb_batt_rtdata±íÖÐÌí¼Ó'mon_LY_vol'×Ö¶ÎÓÃÓÚ±íʾµ¥Ìå©ҺµçѹÐÅÏ¢¡£
|
2.ÔÚdb_ram_db.tb_fbs9100s_fod_param±íÖÐÌí¼ÓµÚ5¸öÄ£¿éµÄ³ýÁò²ÎÊý×Ö¶ÎÐÅÏ¢
|
3.ÔÚdb_ram_db.tb_fbs9100s_fod_state±íÖÐÌí¼Ó'BattGroupId'×ֶβ¢ÉèÖóÉΨһË÷Òý
|
|
V1.51 edit at date 2020-10-18
|
1.ÔÚdb_ram_db¿âÖÐÌí¼ÓÄæ±äÐÅÏ¢±í'tb_fbs9100s_nibian_state'µÄ´´½¨
|
|
V1.52 edit at date 2021-01-13
|
1.Ìí¼ÓµçÔ´ÐÅÏ¢¿âµÄ´´½¨Óï¾ä
|
2.Ìí¼Ó¾øÔµ×°Ö㬳äµç»úµÄ´´½¨Óï¾ä
|
|
V1.53 edit at date 2021-03-08
|
1.ÔÚÏ̼߳à¿Ø¹ÜÀí±íÖÐĬÈÏÌí¼ÓͨÐŵçԴͨѶ³ÌÐòÏ̼߳Ǽ
|
|
V1.54 edit at date 2021-04-22
|
1.Ìí¼ÓÓû§±íµÄ½¨±íÓï¾äÒÔ¼°µ¥±íÖÐÎÞÊý¾ÝʱÌí¼ÓĬÈÏÕ˺Å([admin:admin][superuser:1])
|
2.Ìí¼ÓȨÏÞ±íµÄ½¨±íÓï¾ä£¬Ä¬ÈÏÌí¼Ó³¬¼¶¹ÜÀíԱȨÏÞ×éÆÕͨȨÏÞ×é
|
3.Ìí¼ÓÓû§È¨ÏÞ×éµÄ½¨±íÓï¾ä£¬Ä¬Èϸø³õʼÓû§Ìí¼ÓȨÏÞ
|
4.Ìí¼Óƽ̨ע²áÐÅÏ¢±íÒÔ¼°¶ÔÓ¦×ֶθñʽÐÞ¸Ä×Ö¶Î
|
5.Ìí¼ÓÓû§Êý¾Ý¿âÖеıíµÄ½¨±íÓï¾ä
|
6.Ìí¼Óµç³Ø×éÐÅÏ¢ÅäÖñíÖеÄÀ©Õ¹×ֶεÄÌí¼Ó
|
[Õë¶Ôlinuxϵͳ°²×°Æ½Ì¨Ê±ÖØÒªµÄ±íδ´´½¨Ìí¼Ó]
|
|
V1.55 edit at date 2021-05-07
|
1.'db_pwrdev_data_rt`.`tb_pwrdev_acdcdata' ±íÖÐÐÂÔöÎÂʪ¶È´«¸ÐÆ÷Ïà¹Ø×Ö¶Î
|
2.ÐÂÔö`db_ram_db`.`tb_lithium_data`±íÓÃÓÚ¸üÐÂ﮵ç³ØʵʱÊý¾Ý
|
|
V1.56 edit at date 2021-06-08
|
1.ÐÂÔöÓû§µÇ½ÏÞÖƱí'db_user.tb_user_limit'
|
2.Óû§±íÐÂÔö'login_type'[µÇ½״̬]×Ö¶Î
|
3.ÐÂÔöÄϾ©ËͼìÐîµç³Ø¸æ¾¯±í'db_ram_db.tb_batt_rtalarm'ºÍ'db_ram_db.tb_batt_rsalarm'±íµÄ½¨±íÓï¾ä
|
|
V1.57 edit at date 2021-06-21
|
1.ÐÂÔöͨѶµçÔ´¶ÔÓ¦µÄÊý¾Ý±í:'tb_pwrapp_stainf','tb_pwrapp_dcinf','tb_pwrapp_acinf','tb_pwrapp_acdcinf','tb_display_config'±í
|
2.tb_pwrdev_inf±íÐÂÔö'runCompany'×Ö¶Î
|
2.'web_site.tb_process_survey'ÐÂÔöÄÏÍøͨÐŵçÔ´¼à¿ØÏß³Ì'BMS_POWER_MONITOR'Êý¾Ý
|
|
V1.58 edit at date 2021-06-24
|
1.ÐÂÔö"`db_app_sys`.`tb_menu`"±í´´½¨,Óû§fgƽ̨µ¼º½ÅäÖÃ
|
|
V1.59 edit at date 2021-07-02
|
1.н¨'db_user.`tb_user_log`'Êý¾Ý¿â±í
|
|
V1.60 edit at date 2021-07-08
|
1.н¨'db_ram_db.`tb_fbs9100s_buscouple_state`'-->'ĸÁª¿ª¹Ø״̬±í'Êý¾Ý¿â±í
|
1.н¨'db_ram_db.`tb_fbs9100s_stemnode_state`'-->'¸É½Óµã״̬±í'Êý¾Ý¿â±í
|
|
V1.61 edit at date 2021-07-12
|
1.Ï̼߳à¿Ø±íÐÂÔöÏ̼߳Ǽ"ProcessId:11017",'BMS_BATT_LOADUPDATE','Ðîµç³Ø¸ºÔظüÐÂÏß³Ì'---ĬÈÏÆô¶¯
|
|
V1.62 edit at date 2021-07-20
|
1.±í'db_ram_db.tb_fbs9100_setparam'ÐÂÔöFGCD_A059É豸Ïà¹ØµÄ²ÎÊýÁÐ×Ö¶Î
|
2.ÐÞ¸´'db_ram_db.tb_bts_gprs_state'±íÖгõʼ»¯×ֶδíÎóbug
|
|
V1.63 edit at date 2021-07-27
|
1.±í'db_ram_db.tb_fbs9100_setparam'ÐÂÔöÒ»Ìå»úºãÁ÷²ÎÊý×Ö¶Î
|
|
V1.64 edit at date 2021-08-09
|
1.±í'db_ram_db.tb_fbs9100_setparam'ÐÞ¸ÄÒ»Ìå»ú²ÎÊý³äµç¹ýÎÂ'CharHighTmp' int --->float
|
|
V1.65 edit at date 2021-08-10
|
1.ÐÂÔöĬÈÏÏ̼߳à¿ØÖÐÐÂÔö"³ä·ÅµçÒ»Ìå»úͨѶÏß³Ì" ------------->·þÎñÃû³Æ£º"BMS_BATT_FGCD_A059" Ïß³ÌID:"11018"
|
|
V1.66 edit at date 2021-08-10
|
1.Ð޸ijä·ÅµçÒ»Ìå»úζȷ§ÖµÄ¬ÈÏֵΪ45
|
2.db_app_sys.tb_app_sysÐÂÔöÁÐ'AppServer_Reinit_BattGroupData_A059_EN'ÓÃÓÚͨѶ³ÌÐòÐÂÔö»ú·¿Ê±Êý¾Ý¶¯Ì¬Â¼Èë
|
|
V1.67 edit at date 2021-08-17
|
1.db_battinf.tb_battinf±íÐÂÔöÊÓƵÁ´½ÓµØÖ·×Ö¶Î'video_url'
|
2.db_battinf.tb_battinf±íÐÂÔöÄæ±ä³ä·Åµç״̬'charge_type'ºÍĸÁª×´Ì¬'buscouple_state'
|
3.ÐÂÔöÊý¾Ý¿âdb_fbo_testdata,ÓÃÓÚ´æ·Å´Ó³ä·ÅµçÒ»Ìå»úµ¼ÈëµÄÀúÊ·Êý¾ÝÎļþ
|
4.ÔÚÊý¾Ý¿â'db_fbo_testdata'ÖÐÐÂÔö±í'tb_fbotestdata_inf'ÓÃÓÚ´æ·ÅÀúÊ·Êý¾Ýµ¼Èë¼Ç¼
|
5.ÐÂÔö'db_ram_db.tb_fgcd_filedownload'±íÓÃÓÚ³ä·ÅµçÒ»Ìå»úÀúÊ·Êý¾ÝÔ¶³Ìµ¼Èë
|
|
V1.68 edit at date 2021-08-24
|
1.db_battinf.tb_battinf±íÐÂÔö'uRole'×Ö¶Î'¸æ¾¯½ÇÉ«£º0-¹ÜÀíÔ±¡¢1-ά»¤×鳤¡¢2-ά»¤×éÔ±'
|
|
V1.69 edit at date 2021-08-30
|
1.db_ram_db.tb_fbs9100_sysparam ÐÂÔö'JunHeng_Enabled'-¾ùºâÆôÓÃ״̬,'JunHeng_StVol'-¾ùºâÍ£Ö¹µçѹ·§Öµ,'JunHeng_StCurr'-¾ùºâÍ£Ö¹µçÁ÷·§Öµ
|
|
V1.70 edit at date 2021-8-31
|
1£º½â¾öAPPºÍƽ̨½çÃæ¸æ¾¯Åɵ¥¹¦ÄÜ£¬db_alarmÊý¾Ý¿âÖÐ`tb_battalarm_data`£¬`tb_devalarm_data`
|
Êý¾Ý¿âÖоùÌí¼ÓÁ½¸ö×Ö¶Îwork_flag,msg_flag(¡®tinyint¡¯)
|
|
|
V1.71 edit at date 2021-9-6
|
1£ºdb_user¿âн¨±ítb_user_work¡¢tb_work_alarm,db_alarmÊý¾Ý¿âÖÐн¨±í`tb_alarm_message`,ÐÞ¸Ä`db_ram_db`.`tb_fbs9100_sysparam`±í
|
JunHeng_Enabled×Ö¶ÎÀàÐÍΪfloat
|
|
|
V1.72 edit at date 2021-9-14
|
Ò»¡¢Ë«ÏòDCDC¹¤×÷²ÎÊý
|
op_cmd ×ֶοØÖƺ¬Ò壺
|
public static final int CMD_GetLiDCDCParam=0x8B; //¶Áȡ﮵çDCDC²ÎÊý
|
public static final int CMD_GetLiDCDCParam_Ack = 0x8D; //¶Áȡ﮵çDCDC²ÎÊý³É¹¦
|
public static final int CMD_SetLiDCDCParam =0x8C; //ÉèÖÃ﮵çDCDC²ÎÊý
|
public static final int CMD_SetLiDCDCParam_Ack = 0x8E; //ÉèÖÃ﮵çDCDC²ÎÊý³É¹¦
|
dev_type¶ÁÈ¡ºÍÉèÖÃʱµÄº¬Òå·Ö±ðΪ[Õâ2ÖÖÀàÐͲÎÊý×ֶκ¬ÒåÒ»ÖÂ]
|
0------------>ÉèÖûò¶Áȡ﮵çBTSË«ÏòDCDC¹¤×÷²ÎÊý
|
1------------>ÉèÖûò¶ÁȡǦËáBTSË«ÏòDCDC¹¤×÷²ÎÊý
|
Êý¾Ý¿â±í£ºdb_ram_db.tb_li9130_dcdc_param
|
¶þ¡¢ Ë«ÏòDCDCÄÚ²¿Êý¾Ý
|
op_cmd ×ֶοØÖƺ¬Ò壺
|
public static final int CMD_GetSXDCDCData = 0x8F; //¶ÁÈ¡Ë«ÏòDCDCÄÚ²¿Êý¾Ý
|
public static final int CMD_GetSXDCDCData_Ack = 0x92; //¶ÁÈ¡Ë«ÏòDCDCÄÚ²¿Êý¾Ý³É¹¦
|
ÿ´Î·µ»Ø4ÐÐÊý¾ÝÄ¿Ç°×î¶àÓÐ4¸öDCDCÄ£¿é
|
Èý¡¢ï®µç³ØBMSÄ£ÄâÁ¿
|
op_cmd ×ֶοØÖƺ¬Ò壺
|
public static final int CMD_GetLiBMSData= 0x95; //¶Áȡ﮵ç³ØBMSÄ£ÄâÁ¿
|
public static final int CMD_GetLiBMSData_Ack = 0x93; //¶Áȡ﮵ç³ØBMSÄ£ÄâÁ¿³É¹¦
|
ÿ´Î·µ»Ø4ÐÐÊý¾ÝÄ¿Ç°×î¶àÓÐ4¸öBMSÄ£ÄâÁ¿
|
Êý¾Ý¿â±í£ºdb_ram_db.tb_li9130_bms_state
|
ËÄ¡¢ï®µç³ØBMS¸æ¾¯Á¿
|
op_cmd ×ֶοØÖƺ¬Ò壺
|
public static final int CMD_GetLiBMSState =0x96; //¶Áȡ﮵ç³ØBMS¸æ¾¯Á¿
|
public static final int CMD_GetLiBMSState_Ack= 0x94; //¶Áȡ﮵ç³ØBMS¸æ¾¯Á¿³É¹¦
|
ÿ´Î·µ»Ø4ÐÐÊý¾ÝÄ¿Ç°×î¶àÓÐ4¸öBMSÄ£Äâ¸æ¾¯Á¿
|
Êý¾Ý¿â±í£ºdb_ram_db.tb_li9130_bms_alm
|
|
V1.73 edit at date 2021-9-24
|
1£ºdb_ram_db¿âн¨±ítb_li9130_setparam_plan
|
|
V1.74 edit at date 2021-09-27
|
1.ÐÂÔö'db_dev_history'É豸ÀúʷʵʱÊý¾Ý¿â±í´´½¨
|
|
V1.75 edit at date 2021-09-27
|
1.ÐÂÔö`web_site`.`tb_eletmp` Ä£°å±í´´½¨
|
|
V1.76 edit at date 2021-09-29
|
1.ÐÂÔö`db_app_sys`¿âн¨±í`tb_application`,`tb_application_config`,`tb_dashboard_chart_type`,
|
`tb_dashboard_module`,`tb_dashboard_module_chart`
|
|
V1.77 edit at date 2021-09-30
|
1.ÐÂÔö alter table db_battinf.tb_battinf ADD COLUMN tmp_id int(11) DEFAULT 0 ×Ö¶Î
|
|
V1.78 edit at date 2021-10-04
|
1.Ï̼߳à¿Ø±í'web_site.tb_process_survey'ÖÐÐÂÔöÏû·åÌî¹È¼Æ»®Ïß³Ì '11019' ----> 'BMS_PEAK_SUPPRESSION_PLAN'
|
2.µ±Ç°³ÌÐòÔËÐкóÐ޸ĸ澯Ï̺߳ÍÏû·åÌî¹ÈỊ̈߳¬ÈÃÏ̼߳à¿ØÖØÆôÕâ2¸öÏß³Ì
|
|
V1.79 edit at date 2021-10-09
|
1.ÐÂÔö'web_site.tb_peak_statistics'±íµÄ´´½¨Óï¾ä
|
|
|
V1.80 edit at date 2021-10-11
|
1.ÐÂÔö'db_pwrdev_alarm.tb_pwrdev_alarm' Êý¾Ý¿âÖоùÌí¼ÓÁ½¸ö×ֶΠalm_index ¡¢alm_source ---ËͼìÌí¼ÓרÓÃ×Ö¶Î
|
|
|
V1.81 edit at date 2021-10-11
|
1.ÐÂÔö'db_pwrdev_alarm.db_dev_history' Êý¾Ý¿âÖоùÌí¼ÓÁ½¸ö×ֶΠalm_index ¡¢alm_source ---ËͼìÌí¼ÓרÓÃ×Ö¶Î
|
2.'web_site.tb_peak_statistics'±íÐÂÔö'sum_price'-'µç¼Ûͳ'¼Æ×Ö¶Î
|
|
V1.82 edit at date 2021-10-14
|
1.ÐÂÔö'db_pwrdev_alarm.tb_pwrdev_alarm_param'±íµÄ´´½¨Óï¾ä
|
|
|
V1.83 edit at date 2021-10-15
|
1.ÐÂÔö'db_ram_db.tb_bts_gprs_state'±íÐÂÔö'op_cmd'
|
|
V1.84 edit at date 2021-10-18
|
1.ÐÂÔö'db_app_sys.tb_page_param_user'±íµÄ´´½¨Óï¾ä
|
|
V1.85 edit at date 2021-10-21
|
1.ÐÂÔö'db_battinf.tb_battscrap'¡¢tb_battspare¡¢tb_battspare_record ±íµÄ´´½¨Óï¾ä
|
|
V1.86 edit at date 2021-10-25
|
1£ºÐÞ¸Ä`db_ram_db`.`tb_li9130_bms_state`±í env_temp¡¢mos_temp¡¢current¡¢sum_vol Ëĸö×ֶΣ¨Ôint£©ÀàÐÍΪfloat
|
|
V1.87 edit at date 2021-10-26
|
1£ºÐÂÔö'web_site.tb_weather_city2' ±íµÄ´´½¨Óï¾ä£¬,²¢³õʼ»¯Êý¾Ý
|
|
V1.88 edit at date 2021-10-29
|
1£ºÐÂÔö`db_user`.`tb_user_log` ±íÏÂ×ֶΠoperation_detail
|
|
V1.89 edit at date 2021-11-03
|
1:ÐÂÔö'db_ram_db'.'tb_fbs9100_battparam'ÐÂÔö×Ö¶Î
|
`BattGroupCountSum` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é×ÜÊý(ǦËá+﮵磬ֻ¶Á)',
|
`LiBattGroupCount` int(11) NOT NULL DEFAULT '0' COMMENT '﮵ç×éÊý',
|
`LiEachGroupBattCount` int(11) NOT NULL DEFAULT '0' COMMENT '﮵ç½ÚÊý',
|
V1.90 edit at date 2021-11-8
|
1£ºÐÞ¸Ä`db_battinf`.`tb_battinf` ±íÏÂ×ֶΠȥµô NOT NULLÊôÐÔ
|
|
V1.91 edit at date 2021-11-11
|
1£ºÐÂÔö`db_battinf`.`tb_battinf` ±íÏÂ×ֶΠprice_factor
|
|
V1.92 edit at date 2021-11-11
|
1£ºÐÂÔö`db_app_sys`.`tb_page_param_user` ±íÏÂ×Ö¶Îtype
|
|
V1.93 edit at date 2021-11-13
|
1£ºÐÂÔö`db_ram_db`.`tb_batt_rtstate` ±íÏÂ×Ö¶Îdev_temperature ¡¢dev_humidity
|
|
V1.94 edit at date 2021-11-27
|
1£ºÐÂÔö`web_site`.`tb_3d_station` Ä£°å±í´´½¨
|
|
V1.95 edit at date 2021-12-6
|
1£ºÐÂÔö`db_app_sys`.`tb_page_param2` Ä£°å±í´´½¨²¢³õʼ»¯Êý¾Ý,db_user.tb_user_inf±íÏÂÌí¼Ó×Ö¶Î
|
|
V1.96 edit at date 2021-12-8
|
1£ºÐÞ¸Ä`db_user`.`tb_user_inf` ±íÏÂ×ֶΠ¸ü¸Ä×Ö¶Îold_password Ϊ password_default tinyint(1) DEFAULT '1'
|
|
V1.97 edit at date 2021-12-9
|
1£ºÐÞ¸Ä`db_user`.`tb_user_inf` ±íÏÂ×ֶΠȥµô×Ö¶Îold_password ,ÐÂÔö×Ö¶Î`lock_time` datetime DEFAULT NULL COMMENT 'Õ˺ÅËø¶¨Ê±¼ä'
|
|
V1.98 edit at date 2021-12-10
|
1£ºÐÞ¸Ä`db_battinf`.`tb_battinf` ±íϼì²âÐÂÔö×Ö¶Îsort_id
|
|
V1.99 edit at date 2021-12-13
|
1£ºÐÂÔö`db_app_sys`.`tb_menu_approve` Ä£°å±í´´½¨
|
|
V2.01 edit at date 2021-12-13
|
1£ºÐÞ¸Ä `db_app_sys`.`tb_page_param2`±íÏÂ×ֶΠcategory¸ÄΪcategoryId
|
|
V2.02 edit at date 2021-12-16
|
1£ºÐÞ¸Ä `db_app_sys`.`tb_page_param`±í Ìí¼Ó³õʼ»¯Êý¾Ý
|
|
V2.03 edit at date 2021-12-17
|
1£ºÐÞ¸Ä `db_app_sys`.`tb_page_param`±í ºÍ`db_app_sys`.`tb_page_param2` ¼ì²âÊý¾ÝÍêÕûÐÔ²¢³õʼ»¯Êý¾Ý
|
|
V2.04 edit at date 2021-12-21
|
1£ºÐÞ¸Ä `db_app_sys`.`tb_page_param`±í ¼ì²âÊý¾ÝÍêÕûÐÔ²¢³õʼ»¯Êý¾Ý,Ôö¼ÓÒ»ÌõÊý¾Ý '21', '¾ùºâ¿ØÖƲÎÊýÉèÖà ', '1', '2'
|
|
V2.05 edit at date 2022-1-7
|
1£ºÐÂÔö `db_ram_db`.`tb_ess3100_sysstate`ºÍ`tb_ess3100_sysstate`;ÐÞ¸Ä tb_ld9_updatestatue±íÌí¼Ó×ֶΠ²¢³õʼ»¯Êý¾Ý;
|
|
V2.06 edit at date 2022-1-11
|
1£ºÐÞ¸Ä `db_app_sys`.`tb_page_param2`±í Ôö¼ÓÒ»Ìõ³õʼ»¯Êý¾Ý
|
|
V2.07 edit at date 2022-1-23
|
1£ºÐÞ¸Ä `db_ram_db`.`tb_fbs9100_state`±í ÐÂÔö×ֶΠ`a059_group_vol1`¡¢`a059_group_vol2`¡¢`a059_group_curr1` ¡¢`a059_group_curr2`
|
|
V2.08 edit at date 2022-1-25
|
1£ºÐÞ¸Ä`db_ram_db`.`tb_batt_rtstate`±íÐÂÔö×Ö¶Î'a059_num'±êʶµ±Ç°µç³Ø×éµÄµ¥ÌåÊý¾ÝÀ´Ô´
|
|
V2.09 edit at date 2022-2-18
|
1£ºÐÞ¸Ä`db_ram_db`.`tb_batt_rtdata`±íÐÂÔö×Ö¶Î
|
`mon_test_cap` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå²âÊÔÈÝÁ¿',
|
`mon_dis_timelong` int(11) NOT NULL DEFAULT '0' COMMENT '·Åµç¿É³ÖÐøʱ³¤',
|
`mon_rest_cap` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊ£ÓàÈÝÁ¿',
|
|
|
V2.10 edit at date 2022-2-23
|
1£ºÐÞ¸Ä`db_ram_db`.`tb_batt_rtdata`±íÐÂÔö×Ö¶Î
|
`mon_state` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå״̬'
|
|
V2.11 edit at date 2022-2-23
|
1.±í `db_user`.`tb_user_inf` ÐÂÔö×Ö¶Î
|
ADD COLUMN `visit_time` VARCHAR(17) NULL DEFAULT '00:00:01~23:59:59' COMMENT 'ÔÊÐí·ÃÎÊʱ¼äÇø¼ä' AFTER `lock_time`,
|
ADD COLUMN `visit_ip` VARCHAR(255) NULL DEFAULT '*' COMMENT 'ÔÊÐí·ÃÎÊip' AFTER `visit_time`;
|
|
V2.12 edit at date 2022-3-1
|
1.±í `db_user`.`tb_user_log` ÐÂÔöÐÞ¸Ä×Ö¶Î
|
CHANGE `operation_detail` `operation_detail` text COMMENT '²Ù×÷µÄ¾ßÌåÊý¾Ý'
|
ADD COLUMN `read_flag` TINYINT(1) NULL DEFAULT 1 COMMENT 'ÊÇ·ñÒÑÔĶÁ,´Ë¹¦ÄÜÕë¶ÔÒì³£ÐÅÏ¢' AFTER `operation_detail`;
|
|
2.±í `db_user`.`tb_user_inf` ĬÈϲåÈëĬÈÏÕ˺Š['δµÇ¼µÄÓû§Õ˺Å','sys_admin','audit_admin']
|
INSERT INTO `tb_user_inf`(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(0,'δµÇ¼µÄÓû§Õ˺Å','δµÇ¼µÄÓû§Õ˺Å','','','',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');
|
INSERT INTO `tb_user_inf`(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(1,'sys123456', 'sys_admin','','ĬÈÏ°à×é','61b3151941bb43fad57005524d1a967c',1,0,1,1,'2022-02-14 16:02:01',null,'2021-12-14 16:16:04','00:00:00~23:59:59','*');
|
INSERT INTO `tb_user_inf`(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(2,'audit123456', 'audit_admin','','ĬÈÏ°à×é','2abdaafa43d93077a514146476ed59db',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');
|
|
3.¸øĬÈÏ´´½¨ÏµÍ³¹ÜÀíÔ±ºÍÉó¼Æ¹ÜÀíԱȨÏÞ×é²¢ÇÒΪϵͳ¹ÜÀíÔ±ºÍÉó¼Æ¹ÜÀíԱĬÈÏ·ÖÅäÖ¸¶¨µÄȨÏÞ
|
|
V2.13 edit at date 2022-3-3
|
1.Ð޸ıí `db_user`.`tb_user_inf`±í×ֶΠ'uSnId' ³¤¶È varchar(50)->varchar(200)
|
2.Ð޸ıí `db_user`.`tb_user_inf`±í×ֶΠ'upassword' ³¤¶È varchar(64)->varchar(200)
|
3.ÐÞ¸´Ìí¼ÓĬÈÏÕ˺ÅÊÇbugÐÞ¸´
|
|
V2.14 edit at date 2022-03-15
|
1.ĬÈÏ´´½¨ÒµÎñÅäÖÃÔ±,ÒµÎñ¹ÜÀíÔ±ºÍÒµÎñÉó¼ÆԱȨÏÞ×é
|
|
V2.15 edit at date 2022-03-24
|
1.Ð޸ıí`db_ram_db`.`tb_fbs9100_state`±íÐÂÔö×Ö¶Î---ÓÃÓÚÅжÏÇл»Ïä״ֵ̬
|
`dev_pos_states` varchar(30) NOT NULL DEFAULT '0,0,0,0' COMMENT 'Çл»Ïä½Ó´¥Æ÷Õý¼«¿ª¹Ø״̬[0ûͨÐÅÉÏ£»1£»Õý³££»2£»Òì³£]',
|
`dev_neg_states` varchar(30) NOT NULL DEFAULT '0,0,0,0' COMMENT 'Çл»Ïä½Ó´¥Æ÷¸º¼«¿ª¹Ø״̬[0ûͨÐÅÉÏ£»1£»Õý³££»2£»Òì³£]',
|
|
V2.16 edit at date 2022-03-30
|
1.Ð޸ıí`db_ram_db`.`tb_li9130_bms_alm`±íÐÂÔö×Ö¶Î-->ÓÃÓÚн®ï®µçBTSÊÊÓÃÓÚ¶à×é﮵ç³Ø°üÇé¿ö
|
`group_num` int(11) NOT NULL DEFAULT '0' COMMENT '×éºÅ:0-×é1£»1-×é2'
|
2.Ð޸ıí`db_ram_db`.`tb_li9130_bms_state`±íÐÂÔö×Ö¶Î-->ÓÃÓÚн®ï®µçBTSÊÊÓÃÓÚ¶à×é﮵ç³Ø°üÇé¿ö
|
`group_num` int(11) NOT NULL DEFAULT '0' COMMENT '×éºÅ:0-×é1£»1-×é2'
|
|
V2.17 edit at date 2022-04-08
|
1.Ð޸ıí`db_ram_db`.`tb_li9130_bms_alm`±íÐÂÔö×Ö¶Î-->ÓÃÓÚн®ï®µçBTS°üÐÒéÀ©Õ¹
|
`sys_tmp_code` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳζÈʼþ´úÂë'
|
|
V2.18-19 edit at date 2022-04-09
|
1.Ð޸ıí`db_battinf`.`tb_battinf`±íÐÂÔö×Ö¶Î-->ÓÃÓÚ±êʶµ±Ç°Ð½®ï®µçBTS°üµÄÊýÁ¿
|
`PackCount` int DEFAULT '1' COMMENT '﮵ç³Ø°üÊýÁ¿'
|
2.ÐÞ¸´±í`db_ram_db`.`tb_batt_rtdata`ºÍ`db_ram_db`.`tb_batt_rtalarm`±íÖиù¾Ýµ¥ÌåÊýÄ¿ = ﮵ç³Ø°üÊý*µ¥ÌåÊýÄ¿ ³õʼ»¯µ¥ÌåÊý¾Ý
|
|
V2.20 edit at date 2022-04-18
|
1.ĬÈϲåÈë±í`db_app_sys`.`tb_page_param`ÖÐÃÜÂë¹æÔòºÍÀúÊ·Êý¾ÝµÄÍÕ·åÏÔʾʹÄÜÒÔ¼°ÏÔʾÁ£¶È
|
insert id = INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('42', 'ÃÜÂëÉèÖùæÔò-λÊý', '8', '10')
|
insert id = INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('43', 'ÃÜÂëÉèÖùæÔò-·ûºÅÀàÐÍ', '4', '10')
|
insert id = INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('44', 'ÀúÊ·Êý¾ÝµÄÍÕ·å¹øµ×¹¦ÄÜ¿ªÆô', '1', '11')
|
insert id = INSERT INTO `db_app_sys`.`tb_page_param` VALUES ('45', 'ÀúÊ·Êý¾ÝµÄÊý¾ÝÏÔʾÁ£¶È', '5', '11')
|
|
V2.21 edit at date 2022-04-23
|
1.¼ì²â±í'web_site'.'tb_3d_station'ÖÐÐÂÔö×ֶΣ¬Ã»Óоʹ´½¨,ÐÞ¸´ÔçÆÚ±íÖÐȱʧ×Ö¶Î
|
`stationName` varchar(255) DEFAULT NULL,
|
`battGroupName` varchar(255) DEFAULT NULL,
|
`pictureUrl` varchar(255) DEFAULT NULL,
|
|
V2.22 edit at date 2022-04-24
|
1.ĬÈÏ´´½¨`db_ram_db`.`tb_batt_gtstate`----ɽÎ÷´¢ÄÜÉ豸ÐÅÏ¢±í
|
|
V2.23 edit at date 2022-04-26
|
1.ĬÈÏ´´½¨`db_battinf`.`tb_a059_station_inf`-----A059Ò»Ìå»ú»ú·¿ÅäÖÃÐÅÏ¢±í
|
2.ÅäÖÃÐÅÏ¢±í'db_app_sys'.'tb_app_sys'±íÖÐÐÂÔö×ֶΠ--------- ÓÃÓÚ±êʶ³ä·ÅµçÒ»Ìå»úÊÇ·ñÖØмÓÔصç³Ø×éÐÅÏ¢ [
|
AppServer_Reinit_BattGroupData_A059_EN` tinyint(1) NOT NULL DEFAULT '0'
|
]
|
|
V2.24 edit at date 2022-05-10
|
1.½ûÓÃÊý¾Ý¿â±íɾ³ý¹¦ÄÜ£¬±ÜÃâÖØÐÂɾ³ýÊý¾Ý¿â±í
|
2.ÐÞ¸´²åÈëBTSÍ£µç»ú·¿ÐÅϢʱ´íÎóbug
|
3.ÐÞ¸Ä`db_user`.`tb_user_log`ÖеÄ'uOprateMsg'×ֶθñʽΪ
|
`uOprateMsg` text NOT NULL,
|
|
V2.25 edit at date 2022-05-12
|
1.`db_ram_db`.`tb_fbs9100s_dfu_state`±íÐÂÔö×Ö¶ÎÍ£Ö¹ÔÒò
|
`error_code` int(11) NOT NULL DEFAULT '0' COMMENT '´íÎó´úÂë[0:ÎÞ£»1:ÎļþδÕÒµ½£»2:²ÎÊý´íÎó£»3:Îļþ·¢Ëͳ¬Ê±;4£ºÔ¶³ÌÍ£Ö¹]'
|
2.`db_battinf`.`tb_battinf`±í×Ö¶Î'dev_num'
|
`dev_num` varchar(255) NOT NULL DEFAULT '' ==>`dev_num` varchar(255) NOT NULL DEFAULT '0'
|
|
V1.26 edit at date 2022-05-19
|
1.ÐÞ¸´'db_batt_testdata'Êý¾Ý¿âÖÖ±í²»³õʼ»¯bug
|
2.ÐÞ¸ÄÌí¼ÓĬÈÏÕ˺Åʱ²åÈëÒì³£bug
|
|
|
V1.27 edit at date 2022-06-08
|
1.'db_pwrdev_data_rt.tb_pwrdev_acdcdata'±íÐÂÔö×Ö¶Î,ÐÞ¸´fg2.0µçÔ´ÐÅÏ¢ÏÔʾbug
|
`acIn2_currA` float NOT NULL DEFAULT '0',
|
`acIn2_currB` float NOT NULL DEFAULT '0',
|
`acIn2_currC` float NOT NULL DEFAULT '0',
|
|
V1.28 edit at date 2022-06-10 ------ ²¢ÁªBTSÐèÒªÐÂÔö²ÎÊý 914000000 + x
|
1.'db_ram_db.tb_fbs9100_setparam'±íÐÂÔö×Ö¶Î
|
`ChargeVolt` float NOT NULL DEFAULT '0' COMMENT '³äµçµçѹ(V)',
|
|
2.'db_ram_db.tb_fbs9100_sysparam'
|
`StandyVolt` float NOT NULL DEFAULT '0' COMMENT 'ºó±¸µçѹ(V)'
|
|
V1.29 edit at date 2022-06-12
|
1.³É¶¼Ê¯»¯Æ½Ì¨ÊµÊ±¼à²âÒ³ÃæÐÂÔö²Î¿¼Ïß¹¦ÄÜÐÂÔö±í `db_battinf`.`tb_battinf_guides`
|
CREATE TABLE `tb_battinf_guides` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`batt_group_id` int(11) DEFAULT NULL COMMENT 'µç³Ø×éid',
|
`mon_vol` float DEFAULT NULL,
|
`mon_temp` float DEFAULT NULL COMMENT 'µ¥ÌåζÈ',
|
`mon_res` float DEFAULT NULL COMMENT 'µ¥ÌåÄÚ×è',
|
`leak_vol` float DEFAULT NULL COMMENT '©Һµçѹ',
|
`curr` float DEFAULT NULL COMMENT '¾ùºâµçÁ÷',
|
`mon_conn_res` float DEFAULT NULL COMMENT 'Á´½ÓÌõ×èÖµ',
|
`mon_conduct` float DEFAULT NULL COMMENT 'µ¥Ìåµçµ¼',
|
PRIMARY KEY (`id`),
|
UNIQUE KEY `batt_group_id_UNIQUE` (`batt_group_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='µç³Ø×é¸÷²ÎÊý²Î¿¼Ïß';
|
|
V1.30 edit at date 2022-06-13
|
1.ÐÞ¸´ÐÂÀÏƽ̨Éý¼¶Ê±Õ˺ÅÃÜÂ볤¶È²»¹»bug
|
2.ÐÞ¸´Óû§±íÎÞÓû§Ê±£¬Ä¬ÈϲåÈëµÄsuperuser,adminÕ˺ÅÏÔʾעÏú
|
3.ÐÞ¸´²åÈëÕ˺Åsys_adminΪËø¶¨×´Ì¬
|
|
V1.31 edit at date 2022-06-16
|
1.ÐÂÔö³õʼ»¯´´½¨±í`web_site`.`tb_map_outline`"±í[Ê×Ò³ÂÖÀªÍ¼±í]
|
CREATE TABLE `tb_map_outline` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`province` varchar(15) DEFAULT NULL,
|
`city` varchar(255) DEFAULT NULL,
|
`distinct` varchar(255) DEFAULT NULL,
|
`name` varchar(255) DEFAULT NULL,
|
`status` tinyint(1) DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
|
2.ÐÂÔö³õʼ»¯´´½¨±í`db_battinf`.`tb_battmon_standardcurve`±í[±ê×¼ÇúÏß±í]
|
CREATE TABLE `tb_battmon_standardcurve` (
|
`num` int(11) NOT NULL AUTO_INCREMENT,
|
`monvolstd` float NOT NULL DEFAULT '0',
|
`moncapstd` float NOT NULL DEFAULT '0',
|
`battproducer` varchar(64) NOT NULL DEFAULT '',
|
`battmodel` varchar(64) NOT NULL DEFAULT '',
|
`note` varchar(64) NOT NULL DEFAULT '',
|
PRIMARY KEY (`num`)
|
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
|
|
|
V1.32 edit at date 2022-06-16
|
1.³ä·ÅµçÒ»Ìå»úÐÂÔö²ÎÊý×Ö¶Î'db_ram_db.tb_fbs9100_setparam'±íÐÂÔö×Ö¶Î
|
`C_ProtectVol1` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷±£»¤µçѹ1',
|
`C_ProtectVol2` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷±£»¤µçѹ2',
|
`C_ProtectVol3` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷±£»¤µçѹ3',
|
`C_mon_uppervol1` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷µ¥ÌåÉÏÏÞ1',
|
`C_mon_uppervol2` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷µ¥ÌåÉÏÏÞ2',
|
`C_mon_uppervol3` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷µ¥ÌåÉÏÏÞ3',
|
`C_mon_uppernum1` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷ÉÏÏÞ¸öÊý1',
|
`C_mon_uppernum2` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷ÉÏÏÞ¸öÊý2',
|
`C_mon_uppernum3` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷ÉÏÏÞ¸öÊý3',
|
`HV_charge_num` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ×ܽ׶ÎÊý[1~3]',
|
`HV_charge_Vol1` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î1³äµçµçѹ',
|
`HV_charge_Vol2` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î2³äµçµçѹ',
|
`HV_charge_Vol3` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î3³äµçµçѹ',
|
`HV_time1` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î1³äµçʱ¼ä',
|
`HV_time2` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î2³äµçʱ¼ä',
|
`HV_time3` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î3³äµçʱ¼ä',
|
`HV_ProtectCurr1` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î1±£»¤µçÁ÷',
|
`HV_ProtectCurr2` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î2±£»¤µçÁ÷',
|
`HV_ProtectCurr3` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î3±£»¤µçÁ÷',
|
`HV_mon_uppervol1` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î1µ¥ÌåÉÏÏÞ',
|
`HV_mon_uppervol2` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î2µ¥ÌåÉÏÏÞ',
|
`HV_mon_uppervol3` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î3µ¥ÌåÉÏÏÞ',
|
`HV_mon_uppernum1` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î1ÉÏÏÞ¸öÊý',
|
`HV_mon_uppernum2` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î2ÉÏÏÞ¸öÊý',
|
`HV_mon_uppernum3` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î3ÉÏÏÞ¸öÊý',
|
|
2.Ð޸ıí'db_ram_db.tb_fbs9100s_dfu_state'±íÖÐ×ֶθñʽ
|
CHANGE `sysVersion_new` `sysVersion_new` varchar(128) NOT NULL DEFAULT '0'
|
CHANGE `sysVersion_dev` `sysVersion_dev` varchar(128) NOT NULL DEFAULT '0'
|
|
V1.33 edit at date 2022-06-21
|
1.'db_ld9_testdata.tb_ld9testdata_*'±íÖвåÈë×Ö¶Î,ÐÞ¸´ÀÏLD9ͨÐųÌÐò¼Ç¼µÄÀúÊ·Êý¾Ýfg2.0ÎÞ·¨ÏÔʾ
|
`mon_cap` float NOT NULL DEFAULT '0' COMMENT 'ʵ¼ÊÈÝÁ¿',
|
`mon_rest_cap` float NOT NULL DEFAULT '0' COMMENT 'Ê£ÓàÈÝÁ¿',
|
|
V1.34 edit at date 2022-06-30
|
1.ÐÞ¸´Ö®Ç°Ä¬ÈÏÌí¼ÓµÄsuperuserÕ˺ÅΪÁÙʱÕ˺Åbug
|
2.'db_battinf.tb_battinf'ºÍ'db_pwrdev_inf.tb_pwrdev_inf'±íÐÂÔö¹ØÁª×ֶΠ'¶þάÂëÐÅÏ¢±êʶλ'ÈçÏÂ
|
`mId` bigint(20) DEFAULT '0' COMMENT '¶þάÂëÐÅÏ¢±êʶλ'
|
|
V1.35 edit at date 2022-07-05
|
1.±í'db_ram_db.tb_fbs9100_state'±íÐÂÔö×Ö¶Î
|
`a059_onlineSaveVol` float NOT NULL DEFAULT '0' COMMENT '³ä·ÅµçÒ»Ìå»úÇл»µç³Ø×é±£»¤µçѹ',
|
|
V1.36 edit at date 2022-07-13
|
1.ÐÂÔö'db_dev_testparam'·Åµç²ÎÊý¼Ç¼Êý¾Ý¿â-----------------ÿ´Î¼Ç¼³ä·ÅµçÊý¾Ý±ã»á¼Ç¼µ±Ç°µÄ³ä·Åµç²ÎÊý
|
CREATE TABLE `tb_batt_testparam_10000001` (
|
`num` bigint(20) NOT NULL AUTO_INCREMENT,
|
`record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '²ÎÊý¸üÐÂʱ¼ä',
|
`BattGroupId` int(11) NOT NULL DEFAULT '1' COMMENT 'µç³Ø×éID',
|
`test_record_count` int(11) NOT NULL DEFAULT '1' COMMENT 'µç³Ø×é·Åµç´ÎÊý¶ÔÓ¦db_batt_testdata.tb_batttestdata_inf',
|
`op_cmd` int(11) NOT NULL DEFAULT '0',
|
`TestCmd` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔÀàÐÍ',
|
`HourRate` int(11) NOT NULL DEFAULT '0' COMMENT '·ÅµçСʱÂÊ',
|
`DisCurr` float NOT NULL DEFAULT '0' COMMENT '·ÅµçµçÁ÷(A)',
|
`DisCap` float NOT NULL DEFAULT '0' COMMENT '·ÅµçÈÝÁ¿(AH)',
|
`DisTime` int(11) NOT NULL DEFAULT '0' COMMENT '·Åµçʱ³¤(·ÖÖÓ)',
|
`GroupVol_LOW` float NOT NULL DEFAULT '0' COMMENT '×é¶ËÏÂÏÞ(V)',
|
`MonomerVol_LOW` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÏÂÏÞ(V)',
|
`MonomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÏÂÏÞÊýÁ¿',
|
`BattGroupNum` int(11) NOT NULL DEFAULT '0' COMMENT '×éºÅ',
|
`OnlineVolLowAction` int(11) NOT NULL DEFAULT '0' COMMENT 'ÔÚÏßµçѹµÍ´¦Àí',
|
`DCVolHighLimit` float NOT NULL DEFAULT '0' COMMENT 'ÉýѹÉÏÏÞ(V)',
|
`ChargeCurrSet` float NOT NULL DEFAULT '0' COMMENT '³äµçµçÁ÷(V)',
|
`MonomerTmp_High` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåζÈÉÏÏÞ(¡æ)',
|
`AutoTestStartVol` float NOT NULL DEFAULT '0',
|
`OnLineVol_Low` float NOT NULL DEFAULT '0' COMMENT 'ÔÚÏßµçѹµÍ·§Öµ',
|
`OffLineYH_Cycle` int(11) NOT NULL DEFAULT '0' COMMENT 'ÀëÏßÑø»¤ÖÜÆÚ',
|
`OffLineYHstarttime` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT 'Ñø»¤¼Æ»®¿ªÊ¼Ê±¼ä',
|
`OffLineYHTimes` int(11) NOT NULL DEFAULT '1' COMMENT 'ÀëÏßÑø»¤Ö´ÐдÎÊý',
|
`OffLineYHOnceCycle` int(11) NOT NULL DEFAULT '1' COMMENT 'ÀëÏßÑø»¤Ã¿´ÎÖ´ÐÐÖÜÆÚ',
|
`MonCount` int(11) NOT NULL DEFAULT '0' COMMENT 'ÿ×éµ¥ÌåÊý',
|
`MonVol` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìåµçѹ',
|
`DisPower` float NOT NULL DEFAULT '0' COMMENT 'Ô¤·Å¹¦ÂÊ£¨0.1kw£©',
|
`DisPreRes` float(11,0) NOT NULL DEFAULT '0' COMMENT '·Åµç×èÖµ(m¦¸)',
|
`CharCap` int(11) NOT NULL DEFAULT '0' COMMENT '³äµçÈÝÁ¿(AH)',
|
`CharTimeLong` int(11) NOT NULL DEFAULT '0' COMMENT '³äµçʱ³¤(min)',
|
`FloatCharTimeLong` int(11) NOT NULL DEFAULT '0' COMMENT '¸¡³äʱ³¤',
|
`CharSotpCurr` float NOT NULL DEFAULT '0' COMMENT '½ØÖ¹µçÁ÷(0.1A)',
|
`MonVolHightLimit` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÉÏÏÞ(0.01V)',
|
`MonVolHightLimitCount` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÉÏÏÞÊýÁ¿',
|
`CharHighTmp` float(11,0) NOT NULL DEFAULT '45' COMMENT '³äµç¹ýÎÂ',
|
`DisWaitTime` int(11) NOT NULL DEFAULT '0' COMMENT '·ÅÍê¾²ÖÃ(0-500·ÖÖÓ)',
|
`CharWaitTime` int(11) NOT NULL DEFAULT '0' COMMENT '³äÍê¾²ÖÃ(0-500·ÖÖÓ)',
|
`FlowOver_Count` int(11) NOT NULL DEFAULT '1' COMMENT 'ºãÁ÷×ܽ׶ÎÊý[1-3]',
|
`FlowOver_CharCurr_1` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷1½×¶Î³äµçµçÁ÷',
|
`FlowOver_CharCurr_2` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷2½×¶Î³äµçµçÁ÷',
|
`FlowOver_CharCurr_3` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷3½×¶Î³äµçµçÁ÷',
|
`FlowOver_CharTime_1` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷1½×¶Î³äµçʱ³¤',
|
`FlowOver_CharTime_2` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷2½×¶Î³äµçʱ³¤',
|
`FlowOver_CharTime_3` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷3½×¶Î³äµçʱ³¤',
|
`ChargeVolt` float NOT NULL DEFAULT '0' COMMENT '³äµçµçѹ(V)',
|
`C_ProtectVol1` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷±£»¤µçѹ1',
|
`C_ProtectVol2` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷±£»¤µçѹ2',
|
`C_ProtectVol3` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷±£»¤µçѹ3',
|
`C_mon_uppervol1` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷µ¥ÌåÉÏÏÞ1',
|
`C_mon_uppervol2` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷µ¥ÌåÉÏÏÞ2',
|
`C_mon_uppervol3` float NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷µ¥ÌåÉÏÏÞ3',
|
`C_mon_uppernum1` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷ÉÏÏÞ¸öÊý1',
|
`C_mon_uppernum2` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷ÉÏÏÞ¸öÊý2',
|
`C_mon_uppernum3` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãÁ÷ÉÏÏÞ¸öÊý3',
|
`HV_charge_num` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ×ܽ׶ÎÊý[1~3]',
|
`HV_charge_Vol1` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î1³äµçµçѹ',
|
`HV_charge_Vol2` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î2³äµçµçѹ',
|
`HV_charge_Vol3` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î3³äµçµçѹ',
|
`HV_time1` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î1³äµçʱ¼ä',
|
`HV_time2` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î2³äµçʱ¼ä',
|
`HV_time3` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î3³äµçʱ¼ä',
|
`HV_ProtectCurr1` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î1±£»¤µçÁ÷',
|
`HV_ProtectCurr2` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î2±£»¤µçÁ÷',
|
`HV_ProtectCurr3` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î3±£»¤µçÁ÷',
|
`HV_mon_uppervol1` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î1µ¥ÌåÉÏÏÞ',
|
`HV_mon_uppervol2` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î2µ¥ÌåÉÏÏÞ',
|
`HV_mon_uppervol3` float NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î3µ¥ÌåÉÏÏÞ',
|
`HV_mon_uppernum1` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î1ÉÏÏÞ¸öÊý',
|
`HV_mon_uppernum2` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î2ÉÏÏÞ¸öÊý',
|
`HV_mon_uppernum3` int(11) NOT NULL DEFAULT '0' COMMENT 'ºãѹ½×¶Î3ÉÏÏÞ¸öÊý',
|
PRIMARY KEY (`num`)
|
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
|
|
V1.37 edit at date 2022-08-09
|
1.ĬÈÏ´´½¨'db_pwrdev_data_rt.tb_pwrdev_event'±íÓÃÓڼǼɽÎ÷61850É豸µÄ½»Á÷ÊäÈë1/2µÄ״̬Çл»¼Ç¼
|
|
V1.38 edit at date 2022-08-15
|
1.±í'db_ram_db.tb_fbs9100_state'±íÐÂÔö×ֶΠ-- ³ä·ÅµçÒ»Ìå»úÐÂÔöÊеçÖжÏÅжÏ
|
`a059_acvolLowFlag` int(11) NOT NULL DEFAULT '0' COMMENT 'ÊеçÖжÏ״̬(0£ºÕý³££»1£ºÊеçÖжÏ)'
|
|
V1.39 edit at date 2022-08-15
|
1.±í'db_ram_db.tb_fbs9100_state'±íÐÂÔö×ֶΠ-- ³ä·ÅµçÒ»Ìå»úÐÂÔö»ØÇÐ×é¶Ëµçѹ¸ßµÍ·¶Î§
|
`a059_switchVolMin` float NOT NULL DEFAULT '0' COMMENT '»ØÇÐ×é¶Ëµçѹ·¶Î§µÍ',
|
`a059_switchVolMax` float NOT NULL DEFAULT '0' COMMENT '»ØÇÐ×é¶Ëµçѹ·¶Î§¸ß',
|
|
V1.40 edit at date 2022-08-23
|
1.±í'db_ram_db.tb_fbs9100_sysparam'±íÐÂÔö×ֶβ¢ÁªµçԴϵͳ²ÎÊý
|
`floatChargeVolt` float NOT NULL DEFAULT '0' COMMENT '¸¡³äµçѹ[²¢ÁªµçÔ´]',
|
`disChargeVolt` float NOT NULL DEFAULT '0' COMMENT 'ºó±¸·Åµçµçѹ[²¢ÁªµçÔ´]',
|
`dischargeVoltLimit` float NOT NULL DEFAULT '0' COMMENT '·ÅµçµçѹÏÂÏÞ[²¢ÁªµçÔ´]',
|
`monomerLowVolt` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÏÂÏÞ[²¢ÁªµçÔ´]',
|
`monomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÏÂÏÞ¸öÊý[²¢ÁªµçÔ´]',
|
`autoEQChargeStartimeTime` int(11) NOT NULL DEFAULT '0' COMMENT '×Ô¶¯Æô¶¯¾ù³äÖÜÆÚ(Ìì)[²¢ÁªµçÔ´]',
|
`autoEQChargetTime` int(11) NOT NULL DEFAULT '0' COMMENT '¾ù³äʱ³¤[²¢ÁªµçÔ´]',
|
|
V1.41 edit at date 2022-09-20
|
1.ÐÂÔö±í'db_ram_db.tb_dev_61851_state'--Ô¶³ÌÖØÆô×°ÖÃ״̬ÐÅÏ¢±í
|
2.±í'db_ram_db.tb_fbs9100_sysparam'ÐÂÔöÔ¶³ÌÖØÆô×°ÖòÎÊý×Ö¶Î
|
`dev_addr` int(11) NOT NULL DEFAULT '0' COMMENT '61851_É豸µØÖ·',
|
`tempH_Env` float NOT NULL DEFAULT '0' COMMENT '61851_»·¾³Î¶ȸßãÐÖµ',
|
`tempH_JCQ` float NOT NULL DEFAULT '0' COMMENT '61851_½Ó´¥Æ÷ζȸßãÐÖµ',
|
`currH_ZL` float NOT NULL DEFAULT '0' COMMENT '61851_֧·µçÁ÷¸ßãÐÖµ',
|
`km1_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_¿ØÖÆKM1¿ª¹Ø[1±ÕºÏ£»0£º¶Ï¿ª]',
|
`km2_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_¿ØÖÆKM2¿ª¹Ø[1±ÕºÏ£»0£º¶Ï¿ª]',
|
`km3_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_¿ØÖÆKM3¿ª¹Ø[1±ÕºÏ£»0£º¶Ï¿ª]',
|
|
3.±í'db_app_sys.tb_app_sys'ÐÂÔö×Ö¶Î
|
`AppServer_Reinit_BattGroupData_61851_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ô¶³ÌÖØÆô×°ÖÃÖØмÓÔØ»ú·¿ÐÅÏ¢'
|
|
V1.42 edit at date 2022-10-09
|
1.±í'db_ram_db.tb_ld9_setparam'±íÐÂÔö×ֶΠ----------¡· ´ø¾ùºâ°æ±¾LD9²ÎÊýÐÂÔö×Ö¶Î
|
`param_testtime` int(11) NOT NULL DEFAULT '0' COMMENT '·Åµçʱ¼ä(·ÖÖÓ)[0-5940]',
|
`param_mon_vol` float NOT NULL DEFAULT '0' COMMENT '±ê³Æµ¥Ìåµçѹ',
|
`param_jh_vol` float NOT NULL DEFAULT '0' COMMENT '¾ùºâµçѹƫÒÆ',
|
`param_jhtest_interval` int(11) NOT NULL DEFAULT '0' COMMENT '¾ùºâ²âÊÔ¼ä¸ô(·ÖÖÓ)[1-120]',
|
|
V1.43 edit at date 2022-10-19
|
1.±í'web_site.tb_process_survey'³õʼ¼ÈëʱÌí¼ÓÔ¶³ÌÖØÆô×°ÖÃÏ̼߳Èë
|
sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11020', 'BMS_REMOTE_RESTART_DEVICE', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_REMOTE_RESTART_DEVICE', '2', 'v1.100', 'Ô¶³ÌÖØÆô×°ÖÃͨÐÅÏß³Ì', '300');");
|
|
V1.44 edit at date 2022-10-27
|
1.ÐÂÔöµç²Ù¿ª¹Ø±í'db_ram_db.tb_dev_60870_inverter_info'ºÍ'db_ram_db.tb_dev_60870_inverter_state'
|
1.ÐÂÔöÈý·½½Ó¿ÚÅäÖñí'web_site.tb_interface'
|
|
V1.45 edit at date 2022-11-04
|
1.ÐÂÔöµç²Ù¿ª¹Ø±í'db_ram_db.tb_fbs9100_setparam'±íÐÂÔö×Ö¶Î
|
`MonCapStd` int(11) NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿' ----- µç²Ù¿ª¹ØÐÂÔö²ÎÊý±ê³ÆÈÝÁ¿
|
|
V1.46 edit at date 2022-12-03
|
1.ÐÂÔöµç²Ù¿ª¹Ø±í'db_ram_db.tb_dev_60870_inverter_info'±íÐÂÔö×Ö¶Î
|
`battRealCap1` float NOT NULL DEFAULT '0' COMMENT '×é1Ô¤¹Àʵ¼ÊÈÝÁ¿',
|
`battRealCap2` float NOT NULL DEFAULT '0' COMMENT '×é2Ô¤¹Àʵ¼ÊÈÝÁ¿',
|
`atresia` int(11) NOT NULL DEFAULT '0' COMMENT '±ÕËø״̬¡¾1£º±ÕËø£»0£ºÎ´±ÕËø¡¿',
|
`emergencyStop` int(11) NOT NULL DEFAULT '0' COMMENT '½ô¼±Í£Ö¹',
|
`poweroff` int(11) NOT NULL DEFAULT '0' COMMENT '»ú·¿Í£µç±êʶ',
|
|
V1.47 edit at date 2022-12-06
|
1.ÐÂÔöµç²Ù¿ª¹Ø±í'db_ram_db.tb_fbs9100_setparam'±íÐÂÔöFBO-4830NTÉ豸²ÎÊý×Ö¶Î
|
`OnlineTestFlag` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔÀàÐÍ£º0£ºÀëÏß 1£ºÔÚÏß',
|
`BattGroupCount` int(11) NOT NULL DEFAULT '1' COMMENT 'µç³Ø×é×éÊý',
|
`SOCLow` float NOT NULL DEFAULT '0' COMMENT 'µç³Øsoc[Ê£ÓàÈÝÁ¿]ÏÂÏÞ(%)',
|
`SOCHigh` float NOT NULL DEFAULT '0' COMMENT 'µç³Øsoc[Ê£ÓàÈÝÁ¿]ÉÏÏÞ(%)',
|
`CellDiffVolHigh` float NOT NULL DEFAULT '0' COMMENT 'ѹ²îÉÏÏÞ(mV)',
|
2.ÐÂÔö¸æ¾¯ÏêÇé±í'db_alarm.tb_alarm_detail'--¸æ¾¯ÏêÇé
|
CREATE TABLE `tb_alarm_detail` (
|
`id` bigint(19) NOT NULL AUTO_INCREMENT,
|
`alm_id` varchar(15) DEFAULT NULL COMMENT '¸æ¾¯id',
|
`alm_reason` text COMMENT '¸æ¾¯ÔÒò',
|
`alm_advice` varchar(255) DEFAULT NULL COMMENT '¸æ¾¯½¨Òé',
|
`alm_type` int(5) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯À´Ô´£º0µçÔ´£¬1É豸£¬2µç³Ø',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='¸æ¾¯ÏêÇé';
|
|
3.ÐÂÔö¸æ¾¯ÏêÇé±í'db_alarm.tb_alarm_relation'--¸æ¾¯¶ÔÓ¦¹Øϵ
|
CREATE TABLE `tb_alarm_detail` (
|
`id` bigint(19) NOT NULL AUTO_INCREMENT,
|
`alm_id` varchar(15) DEFAULT NULL COMMENT '¸æ¾¯id',
|
`alm_name` varchar(15) DEFAULT NULL COMMENT '¸æ¾¯Ãû³Æ',
|
`alm_type` int(5) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯À´Ô´£º0µçÔ´£¬1É豸£¬2µç³Ø',
|
`alm_point` varchar(15) DEFAULT '' COMMENT '¸æ¾¯µã',
|
`highorlow` int(5) DEFAULT '0' COMMENT '¸ßµÍ¸æ¾¯0ĬÈÏ1µÍ2¸ß',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COMMENT='¸æ¾¯¶ÔÓ¦¹Øϵ';
|
|
4.ÐÂÔöµç³ØÐÅÏ¢±í'db_battinf.tb_battinf'ÐÂÔö×Ö¶Î
|
`cellShowType` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³ØÀàÐÍ[0£ºÇ¦Ëá 1£ºï®µç]'
|
|
|
|
|
|
