Make the upgrade sub safe for reinstalls.

perlDreamer · perlDreamer · commit 3832e130dc65 · 2011-10-06T14:51:35.000-07:00
diff --git a/docs/upgrades/upgrade_7.10.23-7.10.24.pl b/docs/upgrades/upgrade_7.10.23-7.10.24.pl
@@ -43,7 +43,7 @@ sub addPALastLogTable {
     print "\tAdd a table to keep track of additional Passive Analytics data... " unless $quiet;
     # and here's our code
     $session->db->write(<<EOSQL);
-CREATE TABLE `PA_lastLog` (
+CREATE TABLE IF NOT EXISTS `PA_lastLog` (
 `userId` char(22) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `assetId` char(22) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `sessionId` char(22) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
