fluent-cart / database / Migrations / LabelRelationshipsMigrator.php

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

28 lines 806 B

Raw Download Zip

1	<?php
2
3	namespace FluentCart\Database\Migrations;
4
5
6	use FluentCart\Framework\Database\Schema;
7
8	class LabelRelationshipsMigrator extends Migrator
9	{
10
11	public static string $tableName = 'fct_label_relationships';
12
13
14	public static function getSqlSchema(): string
15	{
16	$indexPrefix = static::getDbPrefix() . 'fct_labr_';
17	return "`id` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
18	`label_id` BIGINT(20) NOT NULL,
19	`labelable_id` BIGINT(20) NOT NULL,
20	`labelable_type` VARCHAR(192) NOT NULL,
21	`created_at` DATETIME NULL,
22	`updated_at` DATETIME NULL,
23
24	INDEX `{$indexPrefix}_label_id_idx` (`label_id` ASC),
25	INDEX `{$indexPrefix}_labelable_id_idx` (`labelable_id` ASC)";
26	}
27	}
28