Changeset 34 for trunk/SQL

Timestamp:

Jan 10, 2019, 10:51:57 PM (6 years ago)

Author:

chronos

Message:

• Added: Generate robots.txt file and disallow all pages with ? symbol.
• Added: Sitemap.xml file for robots.

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`;
 
+UPDATE `MeetItem` SET `Age`=0 WHERE `Age`="";
 ALTER TABLE `MeetItem` CHANGE `Age` `Age` INT NULL DEFAULT NULL;
 UPDATE `MeetItem` SET `Age`=NULL WHERE `Age`=0;
+UPDATE `MeetItem` SET `Height`=0 WHERE `Height`="";
 ALTER TABLE `MeetItem` CHANGE `Height` `Height` INT NULL DEFAULT NULL;
 UPDATE `MeetItem` SET `Height`=NULL WHERE `Height`=0;
+UPDATE `MeetItem` SET `Weight`=0 WHERE `Weight`="";
 ALTER TABLE `MeetItem` CHANGE `Weight` `Weight` INT NULL DEFAULT NULL;
 UPDATE `MeetItem` SET `Weight`=NULL WHERE `Weight`=0;