@@ 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 |