1: <?php
 2: 
 3: use Illuminate\Database\Schema\Blueprint;
 4: use Illuminate\Database\Migrations\Migration;
 5: 
 6: class CreateUserGroupPermissionsTable extends Migration {
 7: 
 8:     /**
 9:      * Run the migrations.
10:      *
11:      * @access   public
12:      * @return   void
13:      */
14:     public function up()
15:     {
16:         if (!Schema::hasTable('_db_usergroup_permissions'))
17:         {
18:             Schema::create('_db_usergroup_permissions', function ($table)
19:                     {
20:                         $table->increments('id')->unique();
21:                         $table->integer('usergroup_id')->unsigned();
22:                         $table->integer('table_id')->unsigned();
23:                         $table->integer('action_id')->unsigned();
24:                         $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
25:                         $table->timestamp('updated_at')->default('0000-00-00 00:00:00');
26: 
27:                         /*
28:                           $table->foreign('usergroup_id')->references('id')->on('usergroups')->onDelete('cascade');
29:                           $table->foreign('table_id')->references('id')->on('_db_tables')->onDelete('cascade');
30:                           $table->foreign('action_id')->references('id')->on('_db_actions')->onDelete('cascade');
31:                          */
32:                     });
33:         }
34:     }
35: 
36:     /**
37:      * Reverse the migrations.
38:      *
39:      * @access   public
40:      * @return   void
41:      */
42:     public function down()
43:     {
44:         Schema::dropIfExists('_db_usergroup_permissions');
45:     }
46: 
47: }
48: