fixed view of migration

githubjeka · githubjeka · commit b2caec356df1 · 2015-05-20T11:03:09.000+03:00
diff --git a/scripts/steps/step-001.1.md b/scripts/steps/step-001.1.md
@@ -88,7 +88,7 @@ class m150513_054155_create_asto_tables extends Migration
                 'name' => Schema::TYPE_STRING . ' NOT NULL',
                 'star_id' => Schema::TYPE_INTEGER . ' NOT NULL',
                 'FOREIGN KEY(star_id) REFERENCES '
-                . $this->db->quoteTableName('{{%star}}') . '(id)'
+                . $this->db->quoteTableName('{{%star}}') . '(id) ON UPDATE CASCADE ON DELETE CASCADE'
             ],
             $tableOptions
         );
@@ -100,7 +100,7 @@ class m150513_054155_create_asto_tables extends Migration
                 'name' => Schema::TYPE_STRING . ' NOT NULL',
                 'planet_id' => Schema::TYPE_INTEGER . ' NOT NULL',
                 'FOREIGN KEY(planet_id) REFERENCES '
-                . $this->db->quoteTableName('{{%planet}}') . '(id)'
+                . $this->db->quoteTableName('{{%planet}}') . '(id) ON UPDATE CASCADE ON DELETE CASCADE'
             ],
             $tableOptions
         );
