Changeset 31 for trunk/SQL/Update.php

Timestamp:

Dec 30, 2018, 7:37:55 PM (5 years ago)

Author:

chronos

Message:

• Modified: Store date of meet items including time. For items without specified time, just use current time (time of import).

File:

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

trunk/SQL/Update.php

@@ -7 +7 @@
 ALTER TABLE `MeetItem` CHANGE `Weight` `Weight` INT NULL DEFAULT NULL;
 UPDATE `MeetItem` SET `Weight`=NULL WHERE `Weight`=0;
+
+ALTER TABLE `MeetItem` CHANGE `Date` `Time` DATETIME NOT NULL;