sync, rooms, events, etc

1 files changed, 5 insertions, 3 deletions

diff --git a/bin/db-migrate b/bin/db-migrate
index 784aadc..c166fcd 100755
--- a/bin/db-migrate
+++ b/bin/db-migrate
@@ -15,7 +15,7 @@ $migrations = scandir($migrationsPath, SCANDIR_SORT_ASCENDING);
 
 $appliedMigrations = [];
 try {
-  Database::getInstance()->query("select name from migrations")->fetchAll();
+  $appliedMigrations = array_column(Database::getInstance()->query("select name from migrations")->fetchAll(), "name");
 } catch (\PDOException $exception) {
   echo "migrations table doesn't exist yet.";
 }
@@ -25,12 +25,14 @@ foreach ($migrations as $migration) {
     continue;
   }
 
-  if (in_array($migration, $appliedMigrations)) {
+  $migrationName = basename($migration, ".php");
+
+  if (in_array($migrationName, $appliedMigrations)) {
     continue;
   }
 
   $path = "$migrationsPath/$migration";
   include $path;
 
-  Database::getInstance()->query("insert into migrations (name) values (:name)", ["name" => $migration]);
+  Database::getInstance()->query("insert into migrations (name) values (:name)", ["name" => $migrationName]);
 }