fluentform / app / Databases / Migrations / FormSubmissionDetails.php

FormSubmissionDetails.php in Fluent Forms – Customizable Contact Forms, Survey, Quiz, & Conversational Form Builder 3.6.40, at app/Databases/Migrations/FormSubmissionDetails.php

34 lines 935 B

Raw Download Zip

1	<?php
2
3	namespace FluentForm\App\Databases\Migrations;
4
5	class FormSubmissionDetails
6	{
7	/**
8	* Migrate the table.
9	*
10	* @return void
11	*/
12	public static function migrate()
13	{
14	global $wpdb;
15
16	$charsetCollate = $wpdb->get_charset_collate();
17	$table = $wpdb->prefix . 'fluentform_entry_details';
18	if ($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) {
19	$sql = "CREATE TABLE $table (
20	`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
21	`form_id` BIGINT(20) UNSIGNED NULL,
22	`submission_id` BIGINT(20) UNSIGNED NULL,
23	`field_name` VARCHAR(255) NULL,
24	`sub_field_name` VARCHAR(255) NULL,
25	`field_value` LONGTEXT NULL,
26	PRIMARY KEY (`id`)) $charsetCollate;";
27	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
28	dbDelta($sql);
29	}
30
31	update_option('fluentform_entry_details_migrated', 'yes', 'no');
32
33	}
34	}