fluent-cart / database / Migrations / MetaMigrator.php

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

55 lines 1.5 KB

Raw Download Zip

1	<?php
2
3	namespace FluentCart\Database\Migrations;
4
5
6	use FluentCart\Framework\Database\Schema;
7
8	class MetaMigrator extends Migrator
9	{
10	public static string $tableName = 'fct_meta';
11
12	public static function getSqlSchema(): string
13	{
14	$indexPrefix = static::getDbPrefix() . 'fct_mt_';
15	return "`id` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
16	`object_type` VARCHAR(50) NOT NULL,
17	`object_id` BIGINT NULL,
18	`meta_key` VARCHAR(192) NOT NULL,
19	`meta_value` LONGTEXT NULL,
20	`created_at` DATETIME NULL,
21	`updated_at` DATETIME NULL,
22	INDEX `{$indexPrefix}_mt_idx` (`object_type` ASC),
23	INDEX `{$indexPrefix}_mto_id_idx` (`object_id` ASC)";
24	}
25
26
27	public static function migrated()
28	{
29	static::renameKeyToMetaKey();
30	static::renameValueToMetaValue();
31	}
32
33	public static function renameKeyToMetaKey()
34	{
35	// "ALTER TABLE %i CHANGE `key` `meta_key` VARCHAR(192)"
36	static::renameColumnIfExists('key', 'meta_key', 'VARCHAR(192)');
37	}
38
39	public static function renameValueToMetaValue()
40	{
41	// "ALTER TABLE %i CHANGE `value` `meta_value` LONGTEXT"
42	static::renameColumnIfExists('value', 'meta_value', 'LONGTEXT');
43	}
44
45	public static function dropTable()
46	{
47
48	if(defined('FLUENTCART_PRESERVER_DEV_META')) {
49	return;
50	}
51
52	Schema::dropTableIfExists(static::getTableName(false));
53	}
54	}
55