| @@ 16-43 (lines=28) @@ | ||
| 13 | use Illuminate\Database\Schema\Blueprint; |
|
| 14 | use Illuminate\Database\Migrations\Migration; |
|
| 15 | ||
| 16 | class CreateEventCategoriesTable extends Migration |
|
| 17 | { |
|
| 18 | /** |
|
| 19 | * Run the migrations. |
|
| 20 | * |
|
| 21 | * @return void |
|
| 22 | */ |
|
| 23 | public function up() |
|
| 24 | { |
|
| 25 | Schema::create('event_categories', function (Blueprint $table) { |
|
| 26 | $table->bigIncrements('id'); |
|
| 27 | $table->integer('category')->nullable(); |
|
| 28 | $table->integer('slug')->nullable(); |
|
| 29 | ||
| 30 | $table->timestamps(); |
|
| 31 | }); |
|
| 32 | } |
|
| 33 | ||
| 34 | /** |
|
| 35 | * Reverse the migrations. |
|
| 36 | * |
|
| 37 | * @return void |
|
| 38 | */ |
|
| 39 | public function down() |
|
| 40 | { |
|
| 41 | Schema::dropIfExists('event_categories'); |
|
| 42 | } |
|
| 43 | } |
|
| 44 | ||
| @@ 16-43 (lines=28) @@ | ||
| 13 | use Illuminate\Database\Schema\Blueprint; |
|
| 14 | use Illuminate\Database\Migrations\Migration; |
|
| 15 | ||
| 16 | class CreateTicketStatusesTable extends Migration |
|
| 17 | { |
|
| 18 | /** |
|
| 19 | * Run the migrations. |
|
| 20 | * |
|
| 21 | * @return void |
|
| 22 | */ |
|
| 23 | public function up() |
|
| 24 | { |
|
| 25 | Schema::create('ticket_statuses', function (Blueprint $table) { |
|
| 26 | $table->bigIncrements('id'); |
|
| 27 | $table->string('status'); |
|
| 28 | $table->string('slug')->nullable(); |
|
| 29 | $table->text('description')->nullable(); |
|
| 30 | $table->timestamps(); |
|
| 31 | }); |
|
| 32 | } |
|
| 33 | ||
| 34 | /** |
|
| 35 | * Reverse the migrations. |
|
| 36 | * |
|
| 37 | * @return void |
|
| 38 | */ |
|
| 39 | public function down() |
|
| 40 | { |
|
| 41 | Schema::dropIfExists('ticket_statuses'); |
|
| 42 | } |
|
| 43 | } |
|
| 44 | ||
| @@ 16-43 (lines=28) @@ | ||
| 13 | use Illuminate\Database\Schema\Blueprint; |
|
| 14 | use Illuminate\Database\Migrations\Migration; |
|
| 15 | ||
| 16 | class CreateTimezonesTable extends Migration |
|
| 17 | { |
|
| 18 | /** |
|
| 19 | * Run the migrations. |
|
| 20 | * |
|
| 21 | * @return void |
|
| 22 | */ |
|
| 23 | public function up() |
|
| 24 | { |
|
| 25 | Schema::create('timezones', function (Blueprint $table) { |
|
| 26 | $table->bigIncrements('id'); |
|
| 27 | $table->string('location')->nullable(); |
|
| 28 | $table->string('timezone'); |
|
| 29 | $table->string('gmt')->nullable(); |
|
| 30 | $table->timestamps(); |
|
| 31 | }); |
|
| 32 | } |
|
| 33 | ||
| 34 | /** |
|
| 35 | * Reverse the migrations. |
|
| 36 | * |
|
| 37 | * @return void |
|
| 38 | */ |
|
| 39 | public function down() |
|
| 40 | { |
|
| 41 | Schema::dropIfExists('timezones'); |
|
| 42 | } |
|
| 43 | } |
|
| 44 | ||