
-- Update methods 

insert or ignore into methods (guid) values ('016A71ED-A64C-4A27-82F9-30E5F516CFF6');
update methods set
 pos = 7,
 Name = 'Заряд с десульфатацией',
 Currency = 6,
 Voltage = 12,
 Capacity = 60,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 86400
where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6';
insert or ignore into stages (guid) values ('D5E80902-5BAA-4075-BF6F-20A30E1EE408');
insert or ignore into stages (guid) values ('E3698617-9999-4B82-87B2-12E8F1FCABFB');
insert or ignore into stages (guid) values ('CB1C39FD-D586-4D2B-8A4D-41DF2697DB50');
insert or ignore into stages (guid) values ('57255A64-128D-4E5E-825D-7EE6177363F7');
insert or ignore into stages (guid) values ('CF158143-9BD8-46F7-864A-5621DBAA1D51');
update stages set
 pos = 1,
 idMethod = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 StageType = 0,
 CurrencyCharge = 1,
 VoltageCharge = 1.2,
 CurrencyDischarge = NULL,
 VoltageDischarge = NULL,
 ChargeTime = NULL,
 DischargeTime = NULL,
 EndType = 1,
 EndCurrency = 0.34,
 EndVoltage = NULL,
 EndDeltaVoltage = NULL,
 EndTemperature = NULL,
 EndCapacity = NULL,
 EndDuration = 60
where guid = 'D5E80902-5BAA-4075-BF6F-20A30E1EE408';
update stages set
 pos = 2,
 idMethod = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 StageType = 0,
 CurrencyCharge = 1,
 VoltageCharge = 1.2,
 CurrencyDischarge = NULL,
 VoltageDischarge = NULL,
 ChargeTime = NULL,
 DischargeTime = NULL,
 EndType = 4,
 EndCurrency = NULL,
 EndVoltage = 0.85,
 EndDeltaVoltage = NULL,
 EndTemperature = NULL,
 EndCapacity = NULL,
 EndDuration = NULL
where guid = 'E3698617-9999-4B82-87B2-12E8F1FCABFB';
update stages set
 pos = 4,
 idMethod = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 StageType = 2,
 CurrencyCharge = 1,
 VoltageCharge = 1.23333333333333,
 CurrencyDischarge = 0.1,
 VoltageDischarge = 0.9,
 ChargeTime = 4,
 DischargeTime = 2,
 EndType = 3,
 EndCurrency = 0.333333333333333,
 EndVoltage = NULL,
 EndDeltaVoltage = NULL,
 EndTemperature = NULL,
 EndCapacity = NULL,
 EndDuration = 72000
where guid = 'CB1C39FD-D586-4D2B-8A4D-41DF2697DB50';
update stages set
 pos = 5,
 idMethod = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 StageType = 2,
 CurrencyCharge = 0.333333333333333,
 VoltageCharge = 1.33333333333333,
 CurrencyDischarge = 0,
 VoltageDischarge = NULL,
 ChargeTime = 6,
 DischargeTime = 2,
 EndType = 1,
 EndCurrency = NULL,
 EndVoltage = NULL,
 EndDeltaVoltage = NULL,
 EndTemperature = NULL,
 EndCapacity = NULL,
 EndDuration = 7200
where guid = '57255A64-128D-4E5E-825D-7EE6177363F7';
update stages set
 pos = 3,
 idMethod = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 StageType = 0,
 CurrencyCharge = 1,
 VoltageCharge = 1.23333333333333,
 CurrencyDischarge = NULL,
 VoltageDischarge = NULL,
 ChargeTime = NULL,
 DischargeTime = NULL,
 EndType = 1,
 EndCurrency = NULL,
 EndVoltage = NULL,
 EndDeltaVoltage = NULL,
 EndTemperature = NULL,
 EndCapacity = NULL,
 EndDuration = 60
where guid = 'CF158143-9BD8-46F7-864A-5621DBAA1D51';

-- Update modeles link 

insert or ignore into akbmethods (guid) values ('208CB384-7D69-4990-8EF6-29C1E34D8F3F');
insert or ignore into akbmethods (guid) values ('9920E7F2-4A32-4823-9D7E-FADBA1CAA55D');
insert or ignore into akbmethods (guid) values ('1B37B1B8-8F2A-4EB6-A771-E1C3F2E84DFB');
insert or ignore into akbmethods (guid) values ('215BD15E-DB23-4DC9-8D5C-7B10CCF6207E');
insert or ignore into akbmethods (guid) values ('3282C750-115F-4925-BE7D-9AA2CAA0E5C6');
insert or ignore into akbmethods (guid) values ('65CE5989-CAEB-4019-848E-F6955E539057');
insert or ignore into akbmethods (guid) values ('363A2F74-51A8-4A02-8462-CB4478601C31');
insert or ignore into akbmethods (guid) values ('DFFD1743-0298-4B7D-8A43-C6C82B64A68A');
insert or ignore into akbmethods (guid) values ('9745B927-04BF-4733-9BE1-012CC55122FB');
insert or ignore into akbmethods (guid) values ('348F3EB2-1AFB-44DC-BBCC-2C6433F6710D');
insert or ignore into akbmethods (guid) values ('34FEF99D-979C-47A4-B47D-F4ED15C0F9F1');
insert or ignore into akbmethods (guid) values ('5F201AE8-B4CF-4BC2-B20C-75756C3E792C');
insert or ignore into akbmethods (guid) values ('3E9F754C-DFE0-46CD-9F6A-2125EA0B3D57');
insert or ignore into akbmethods (guid) values ('32CD5100-C2BB-4A2A-BBCA-D5A5D91BF22F');
insert or ignore into akbmethods (guid) values ('45B595C9-0F4E-4A99-BB7B-518C48D56A44');
insert or ignore into akbmethods (guid) values ('6F1633EF-538A-4FDB-98D0-1675985242E6');
insert or ignore into akbmethods (guid) values ('653624FF-735A-4F11-96B7-0C0D6F87444E');
insert or ignore into akbmethods (guid) values ('362F83B9-BD24-44CE-AE0D-F858129A5E73');
insert or ignore into akbmethods (guid) values ('D8758A25-B347-4ED5-9ECE-85E6DA31A12C');
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = 'A4897A9E-7C85-4562-A8FD-B54DF2E87E4C'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = NULL,
 CapacityProcent = NULL,
 CycleCount = 1,
 Duration = 36000
where guid = '208CB384-7D69-4990-8EF6-29C1E34D8F3F';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '823A61CC-B6DC-4CBE-966F-2BC684E6BF71'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 6,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '9920E7F2-4A32-4823-9D7E-FADBA1CAA55D';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '020CCCFD-BE9F-460E-9DE9-B0C636D03D36'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 5.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '1B37B1B8-8F2A-4EB6-A771-E1C3F2E84DFB';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '7728AD2F-9419-4870-A296-95C4ABEFEADF'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 0,
 Currency = NULL,
 CapacityProcent = NULL,
 CycleCount = 1,
 Duration = 36000
where guid = '215BD15E-DB23-4DC9-8D5C-7B10CCF6207E';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '8B42143B-6EDC-446D-91AD-AC17CBC63CF2'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 5.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '3282C750-115F-4925-BE7D-9AA2CAA0E5C6';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = 'E1D74D16-72AB-4CF3-BB48-3A41FAA9F89A'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 5.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '65CE5989-CAEB-4019-848E-F6955E539057';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = 'FF208478-848C-4E56-AE96-0A65B515B21C'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 8.3,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '363A2F74-51A8-4A02-8462-CB4478601C31';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '0D6EC51B-A1AA-47CF-9C18-8081396A2CD6'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 4.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = 'DFFD1743-0298-4B7D-8A43-C6C82B64A68A';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '933F94D8-10F4-4180-8F47-AE5900B597FB'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 5.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '9745B927-04BF-4733-9BE1-012CC55122FB';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '1F861990-5346-48E6-A51A-A617D8E233C9'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 0,
 Currency = 0,
 CapacityProcent = 0,
 CycleCount = 1,
 Duration = 36000
where guid = '348F3EB2-1AFB-44DC-BBCC-2C6433F6710D';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '5D9BD83E-7F81-4080-8E66-AD0A9676D45D'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 4,
 CapacityProcent = 14.2857142857143,
 CycleCount = 1,
 Duration = 36000
where guid = '34FEF99D-979C-47A4-B47D-F4ED15C0F9F1';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '3E6D37BC-1A57-483D-BC1A-121774B0C6CD'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 0,
 Currency = 0,
 CapacityProcent = 0,
 CycleCount = 1,
 Duration = 36000
where guid = '5F201AE8-B4CF-4BC2-B20C-75756C3E792C';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '270F14EE-EA99-4CD8-A3D7-42F349094B10'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 5.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '3E9F754C-DFE0-46CD-9F6A-2125EA0B3D57';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '46B25B98-58C0-4531-93B7-8898EBB14F40'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 5.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '32CD5100-C2BB-4A2A-BBCA-D5A5D91BF22F';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '8635105F-7548-4B02-A2C1-4B1F7955C443'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 0,
 Currency = 0,
 CapacityProcent = 0,
 CycleCount = 1,
 Duration = 36000
where guid = '45B595C9-0F4E-4A99-BB7B-518C48D56A44';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = 'DCC8D4E4-465F-448E-9C87-27E634F6AB88'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 5.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '6F1633EF-538A-4FDB-98D0-1675985242E6';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '23C4B8DF-7944-48D8-8945-0AD30DF63129'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 5.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '653624FF-735A-4F11-96B7-0C0D6F87444E';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '4A7D8983-8E99-4B9A-A8CF-87ED1B50BC1B'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 5.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = '362F83B9-BD24-44CE-AE0D-F858129A5E73';
update akbmethods set
 id_akbmodel = (select id from akbmodeles where guid = '0150677D-C158-4D53-9482-3C25D36BA14B'),
 id_methods = (select id from methods where guid = '016A71ED-A64C-4A27-82F9-30E5F516CFF6'),
 used = 1,
 Currency = 5.5,
 CapacityProcent = 10,
 CycleCount = 1,
 Duration = 36000
where guid = 'D8758A25-B347-4ED5-9ECE-85E6DA31A12C';

