5 lines
311 B
MySQL
5 lines
311 B
MySQL
|
ALTER TABLE vn.itemConfig ADD monthToDeactivate int(3) DEFAULT 24 NOT NULL;
|
||
|
|
ALTER TABLE vn.item ADD lastUsed datetime DEFAULT CURRENT_TIMESTAMP;
|
||
|
|
CREATE INDEX item_lastUsed_IDX USING BTREE ON vn.item (lastUsed);
|
||
|
|
INSERT INTO bs.nightTask (`order`,`schema`,`procedure`)
|
||
|
|
VALUES (1007,'vn','item_deactivateUnused');
|