fluent-cart / database / Migrations / AttributeTermsMigrator.php

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

29 lines 833 B

Raw Download Zip

1	<?php
2
3	namespace FluentCart\Database\Migrations;
4
5	use FluentCart\Framework\Database\Schema;
6
7	class AttributeTermsMigrator extends Migrator
8	{
9
10	public static string $tableName = 'fct_atts_terms';
11
12	public static function getSqlSchema(): string
13	{
14	$indexPrefix = static::getDbPrefix() . 'fct_attt_';
15	return "`id` BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
16	`group_id` BIGINT(20) UNSIGNED,
17	`serial` INT(11) UNSIGNED,
18	`title` VARCHAR(192) NOT NULL,
19	`slug` VARCHAR(192) NOT NULL,
20	`description` longtext NULL,
21	`settings` longtext NULL,
22	`created_at` DATETIME NULL,
23	`updated_at` DATETIME NULL,
24	INDEX `{$indexPrefix}_group_id_idx` (`group_id` ASC)";
25	}
26	}
27
28
29