mirror of
https://gitee.com/fasiondog/hikyuu.git
synced 2024-11-29 18:39:10 +08:00
12 lines
475 B
MySQL
12 lines
475 B
MySQL
|
BEGIN TRANSACTION;
|
||
|
|
ALTER TABLE `Market` ADD `openTime1` INTEGER;
|
||
|
|
ALTER TABLE `Market` ADD `closeTime1` INTEGER;
|
||
|
|
ALTER TABLE `Market` ADD `openTime2` INTEGER;
|
||
|
|
ALTER TABLE `Market` ADD `closeTime2` INTEGER;
|
||
|
|
|
||
|
|
UPDATE `Market` SET `openTime1`=930, `closeTime1`=1130, `openTime2`=1300, `closeTime2`=1500 WHERE `marketid`=1;
|
||
|
|
UPDATE `Market` SET `openTime1`=930, `closeTime1`=1130, `openTime2`=1300, `closeTime2`=1500 WHERE `marketid`=2;
|
||
|
|
|
||
|
|
UPDATE `version` set `version` = 4;
|
||
|
|
COMMIT;
|