35 lines
1.0 KiB
MySQL
35 lines
1.0 KiB
MySQL
|
ALTER TABLE `vn`.`commissionConfig` ADD executionDay SMALLINT NULL;
|
||
|
|
ALTER TABLE `vn`.`commissionConfig` ADD salesPersonWithPlusNewClient INT NULL;
|
||
|
|
ALTER TABLE `vn`.`commissionConfig` ADD maxPlusNewClient INT NULL;
|
||
|
|
ALTER TABLE `vn`.`commissionConfig` ADD plusDifference INT NULL;
|
||
|
|
ALTER TABLE `vn`.`commissionConfig` ADD maxScoreNewClient INT NULL;
|
||
|
|
ALTER TABLE `vn`.`commissionConfig` ADD scoreDifference INT NULL;
|
||
|
|
|
||
|
|
UPDATE `vn`.`commissionConfig`
|
||
|
|
SET plusDifference=5,executionDay=5,scoreDifference=1,maxScoreNewClient=100,maxPlusNewClient=100,salesPersonWithPlusNewClient=20
|
||
|
|
WHERE rate=0.0080;
|
||
|
|
|
||
|
|
UPDATE `vn`.`department`
|
||
|
|
SET workerFk=4661
|
||
|
|
WHERE id=96;
|
||
|
|
UPDATE `vn`.`department`
|
||
|
|
SET workerFk=4667
|
||
|
|
WHERE id=95;
|
||
|
|
UPDATE `vn`.`department`
|
||
|
|
SET workerFk=3810
|
||
|
|
WHERE id=115;
|
||
|
|
UPDATE `vn`.`department`
|
||
|
|
SET workerFk=7102
|
||
|
|
WHERE id=123;
|
||
|
|
UPDATE `vn`.`department`
|
||
|
|
SET workerFk=3797
|
||
|
|
WHERE id=94;
|
||
|
|
UPDATE `vn`.`department`
|
||
|
|
SET workerFk=4250
|
||
|
|
WHERE id=80;
|
||
|
|
UPDATE `vn`.`department`
|
||
|
|
SET workerFk=1118
|
||
|
|
WHERE id=125;
|
||
|
|
UPDATE `vn`.`department`
|
||
|
|
SET workerFk=1203
|
||
|
|
WHERE id=92;
|