11 lines
1.4 KiB
SQL
11 lines
1.4 KiB
SQL
UPDATE `wf_versionedb` SET `versione`='20171011' WHERE 1;
|
|
ALTER TABLE `wf_storico` CHANGE `peso` `peso` DECIMAL(11,2) NOT NULL DEFAULT '0';
|
|
ALTER TABLE `wf_storico` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT;
|
|
ALTER TABLE `wf_storico` DROP `calcisemicirc`;
|
|
ALTER TABLE `wf_storico` ADD `calcisx` INT UNSIGNED NULL AFTER `cingolo`, ADD `calcidx` INT UNSIGNED NULL AFTER `calcisx`;
|
|
ALTER TABLE `wf_storico` CHANGE `palla` `pallaav` INT(11) NOT NULL DEFAULT '0';
|
|
ALTER TABLE `wf_storico` ADD `pallaind` INT NOT NULL DEFAULT '0' AFTER `pallaav`;
|
|
ALTER TABLE `wf_storico` CHANGE `peso` `peso` DECIMAL(11,2) UNSIGNED NOT NULL DEFAULT '0.00', CHANGE `altezza` `altezza` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `cooper` `cooper` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `sargeant` `sargeant` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `slungo` `slungo` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `pallaav` `pallaav` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `pallaind` `pallaind` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `mobart` `mobart` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `calcisx` `calcisx` INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE `calcidx` `calcidx` INT(10) UNSIGNED NOT NULL DEFAULT '0';
|
|
ALTER TABLE `wf_storico` CHANGE `peso` `peso` DECIMAL(11,1) UNSIGNED NOT NULL DEFAULT '0.0';
|
|
ALTER TABLE `wf_storico` CHANGE `data` `data` DATE NULL DEFAULT NULL;
|