fluent-cart / database / Migrations / ProductDownloadsMigrator.php

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

31 lines 998 B

Raw Download Zip

1	<?php
2
3	namespace FluentCart\Database\Migrations;
4
5	use FluentCart\Framework\Database\Schema;
6
7	class ProductDownloadsMigrator extends Migrator
8	{
9
10	public static string $tableName = "fct_product_downloads";
11
12	public static function getSqlSchema(): string
13	{
14	return "`id` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
15	`post_id` BIGINT(20) UNSIGNED NOT NULL,
16	`product_variation_id` longtext NOT NULL,
17	`download_identifier` VARCHAR(100) NOT NULL UNIQUE,
18	`title` VARCHAR(192) NULL,
19	`type` VARCHAR(100) NULL,
20	`driver` VARCHAR(100) NULL DEFAULT 'local',
21	`file_name` VARCHAR(192) NULL,
22	`file_path` TEXT NULL,
23	`file_url` TEXT NULL,
24	`file_size` TEXT NULL,
25	`settings` TEXT NULL,
26	`serial` INT NULL,
27	`created_at` DATETIME NULL,
28	`updated_at` DATETIME NULL";
29	}
30	}
31