fluent-cart / database / Migrations / ShippingZonesMigrator.php

ShippingZonesMigrator.php in FluentCart A New Era of eCommerce – Faster, Lighter, and Simpler 1.6.4, at database/Migrations/ShippingZonesMigrator.php

36 lines 1.4 KB

Raw Download Zip

1	<?php
2
3	namespace FluentCart\Database\Migrations;
4
5
6	class ShippingZonesMigrator extends Migrator
7	{
8	public static string $tableName = 'fct_shipping_zones';
9
10	public static function getSqlSchema(): string
11	{
12	$indexPrefix = static::getDbPrefix() . 'fct_sz_';
13	return "`id` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT," .
14	"`shipping_class_id` BIGINT UNSIGNED NULL," .
15	"`name` VARCHAR(192) NOT NULL," .
16	"`region` VARCHAR(192) NOT NULL," .
17	"`meta` JSON DEFAULT NULL," .
18	"`order` INT UNSIGNED NOT NULL DEFAULT 0," .
19	"`created_at` DATETIME NULL," .
20	"`updated_at` DATETIME NULL," .
21	"INDEX `{$indexPrefix}_order_idx` (`order` ASC)," .
22	"INDEX `{$indexPrefix}_class_id_idx` (`shipping_class_id` ASC)";
23	}
24
25	public static function migrated()
26	{
27	// Keep legacy column shape self-healing on every migrate run
28	static::renameColumnIfExists('regions', 'region', 'VARCHAR(192) NOT NULL');
29
30	// Ensure shipping_class_id exists on upgrades (fresh installs get it from getSqlSchema)
31	static::addColumnIfNotExists('shipping_class_id', 'BIGINT UNSIGNED NULL', 'id');
32	static::addIndexIfNotExists(static::getDbPrefix() . 'fct_sz__class_id_idx', 'shipping_class_id');
33	static::addColumnIfNotExists('meta', 'JSON DEFAULT NULL', 'region');
34	}
35	}
36