PageRenderTime 54ms CodeModel.GetById 30ms RepoModel.GetById 0ms app.codeStats 0ms

/upgrade-scripts/fix-events.php

https://bitbucket.org/MelFlynn/observium
PHP | 20 lines | 15 code | 5 blank | 0 comment | 2 complexity | bc2e03f4ac01212f5899d41a35cb761c MD5 | raw file
Possible License(s): GPL-3.0, MIT
  1. <?php
  2. mysql_query("ALTER TABLE `eventlog` DROP `id`");
  3. mysql_query("ALTER TABLE `eventlog` ADD `event_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST");
  4. $s = "SELECT * FROM eventlog";
  5. $q = mysql_query($s);
  6. while ($event = mysql_fetch_assoc($q))
  7. {
  8. if ($event['interface'])
  9. {
  10. mysql_query("UPDATE `eventlog` SET `interface` = NULL, `type` = 'interface', `reference` = '".$event['interface']."' WHERE `event_id` = '".$event['event_id']."'");
  11. }
  12. $i++;
  13. }
  14. mysql_query("ALTER TABLE `eventlog` DROP `interface`");
  15. ?>