1 | <?php |
||
8 | class CreatePlansTable extends Migration |
||
9 | { |
||
10 | /** |
||
11 | * Run the migrations. |
||
12 | * |
||
13 | * @return void |
||
14 | */ |
||
15 | public function up(): void |
||
45 | |||
46 | /** |
||
47 | * Reverse the migrations. |
||
48 | * |
||
49 | * @return void |
||
50 | */ |
||
51 | public function down(): void |
||
55 | |||
56 | /** |
||
57 | * Get jsonable column data type. |
||
58 | * |
||
59 | * @return string |
||
60 | */ |
||
61 | protected function jsonable(): string |
||
62 | { |
||
63 | $driverName = DB::connection()->getPdo()->getAttribute(PDO::ATTR_DRIVER_NAME); |
||
64 | $dbVersion = DB::connection()->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION); |
||
65 | $isOldVersion = version_compare($dbVersion, '5.7.8', 'lt'); |
||
66 | |||
67 | return $driverName === 'mysql' && $isOldVersion ? 'text' : 'json'; |
||
68 | } |
||
69 | } |
||
70 |