
* Adds a new storage location for these tick types. * Reverts some of the tick_total variable assignments. * Adjusts sc_start to account for 64 bit tick values. Thanks to @eppc0330!
6 lines
253 B
SQL
6 lines
253 B
SQL
ALTER TABLE `sc_data` ADD COLUMN `tick_total` BIGINT(20) NOT NULL AFTER `tick`;
|
|
UPDATE `sc_data` SET `tick_total` = `tick`;
|
|
|
|
ALTER TABLE `sc_data` ADD COLUMN `tick_time` BIGINT(20) NOT NULL AFTER `tick_total`;
|
|
UPDATE `sc_data` SET `tick_time` = `tick`;
|