8 lines
287 B
MySQL
8 lines
287 B
MySQL
|
CREATE INDEX greuge_shipped_IDX USING BTREE ON `vn`.`greuge` (shipped);
|
||
|
|
|
||
|
|
INSERT INTO `bs`.`nightTask` (`order`,`schema`,`procedure`)
|
||
|
|
VALUES (1006,'vn','greuge_add');
|
||
|
|
|
||
|
|
ALTER TABLE `vn`.`greugeConfig` ADD yearsToDelete INT NULL;
|
||
|
|
UPDATE `vn`.`greugeConfig` SET yearsToDelete=5 WHERE id=1;
|