database/migrations/2016_12_16_215523_create_studies_table.php 1 location
|
@@ 18-25 (lines=8) @@
|
| 15 |
|
*/ |
| 16 |
|
public function up() |
| 17 |
|
{ |
| 18 |
|
Schema::create('studies', function (Blueprint $table) { |
| 19 |
|
$table->increments('id'); |
| 20 |
|
$table->string('name'); |
| 21 |
|
$table->integer('law_id')->unsigned(); |
| 22 |
|
$table->string('state')->nullable(); |
| 23 |
|
$table->integer('replaces_study_id')->unsigned()->nullable(); |
| 24 |
|
$table->timestamps(); |
| 25 |
|
}); |
| 26 |
|
} |
| 27 |
|
/** |
| 28 |
|
* Reverse the migrations. |
database/migrations/2016_12_16_221258_create_departaments_table.php 1 location
|
@@ 19-25 (lines=7) @@
|
| 16 |
|
*/ |
| 17 |
|
public function up() |
| 18 |
|
{ |
| 19 |
|
Schema::create('departments', function (Blueprint $table) { |
| 20 |
|
$table->increments('id'); |
| 21 |
|
$table->string('name'); |
| 22 |
|
$table->integer('parent')->unsigned()->nullable(); |
| 23 |
|
$table->integer('location_id')->unsigned(); |
| 24 |
|
$table->timestamps(); |
| 25 |
|
}); |
| 26 |
|
Schema::create('department_family', function (Blueprint $table) { |
| 27 |
|
$table->integer('department_id')->unsigned(); |
| 28 |
|
$table->integer('family_id')->unsigned(); |