Changeset 25 for trunk/SQL

Timestamp:

Dec 26, 2018, 11:13:00 PM (6 years ago)

Author:

chronos

Message:

• Modified: Keep Age, Height and Weight values in database as int type.

File:

• trunk/SQL/Update.php (modified) (1 diff)

trunk/SQL/Update.php

@@ -1 +1 @@
 ALTER TABLE `MeetItem` ADD `Link` VARCHAR(255) NOT NULL AFTER `Location`;
 
+ALTER TABLE `MeetItem` CHANGE `Age` `Age` INT NULL DEFAULT NULL;
+UPDATE `MeetItem` SET `Age`=NULL WHERE `Age`=0;
+ALTER TABLE `MeetItem` CHANGE `Height` `Height` INT NULL DEFAULT NULL;
+UPDATE `MeetItem` SET `Height`=NULL WHERE `Height`=0;
+ALTER TABLE `MeetItem` CHANGE `Weight` `Weight` INT NULL DEFAULT NULL;
+UPDATE `MeetItem` SET `Weight`=NULL WHERE `Weight`=0;