Fixed migration

1 files changed, 21 insertions, 12 deletions

diff --git a/database/migrations/create_scorm_tables.php.stub b/database/migrations/create_scorm_tables.php.stub
index 319434c..c246365 100644
--- a/database/migrations/create_scorm_tables.php.stub
+++ b/database/migrations/create_scorm_tables.php.stub
@@ -22,7 +22,6 @@ class CreateScormTables extends Migration
         // scorm_model
         Schema::create($tableNames['scorm_table'], function (Blueprint $table) {
             $table->bigIncrements('id');
-            $table->morphs('resource');
             $table->string('version');
             $table->string('hash_name');
             $table->string('origin_file')->nullable();
@@ -35,9 +34,9 @@ class CreateScormTables extends Migration
         // scorm_sco_model
         Schema::create($tableNames['scorm_sco_table'], function (Blueprint $table) use ($tableNames) {
             $table->bigIncrements('id');
-            $table->bigInteger('scorm_id');
+            $table->bigInteger('scorm_id')->unsigned();
             $table->string('uuid');
-            $table->bigInteger('sco_parent_id')->nullable();
+            $table->bigInteger('sco_parent_id')->unsigned()->nullable();
             $table->string('entry_url')->nullable();
             $table->string('identifier');
             $table->string('title');
@@ -59,8 +58,8 @@ class CreateScormTables extends Migration
         // scorm_sco_tracking_model
         Schema::create($tableNames['scorm_sco_tracking_table'], function (Blueprint $table) use ($tableNames) {
             $table->bigIncrements('id');
-            $table->bigInteger('user_id');
-            $table->bigInteger('sco_id');
+            $table->bigInteger('user_id')->unsigned();
+            $table->bigInteger('sco_id')->unsigned();
             $table->string('uuid');
             $table->double('progression');
             $table->integer('score_raw')->nullable();
@@ -97,16 +96,26 @@ class CreateScormTables extends Migration
      */
     public function down()
     {
-        $tableNames = config('permission.table_names');
+        $tableNames = config('scorm_sco_tracking_table');
 
         if (empty($tableNames)) {
-            throw new \Exception('Error: config/permission.php not found and defaults could not be merged. Please publish the package configuration before proceeding, or drop the tables manually.');
+            throw new \Exception('Error: Table not found.');
         }
 
-        Schema::drop($tableNames['role_has_permissions']);
-        Schema::drop($tableNames['model_has_roles']);
-        Schema::drop($tableNames['model_has_permissions']);
-        Schema::drop($tableNames['roles']);
-        Schema::drop($tableNames['permissions']);
+        $tableNames = config('scorm_sco_table');
+
+        if (empty($tableNames)) {
+            throw new \Exception('Error: Table not found.');
+        }
+
+        $tableNames = config('scorm_table');
+
+        if (empty($tableNames)) {
+            throw new \Exception('Error: Table not found.');
+        }
+
+        Schema::drop($tableNames['scorm_sco_tracking_table']);
+        Schema::drop($tableNames['scorm_sco_table']);
+        Schema::drop($tableNames['scorm_table']);
     }
 }