fluentform / app / Databases / Migrations / FormMeta.php

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

42 lines 1008 B

Raw Download Zip

1	<?php
2
3	namespace FluentForm\App\Databases\Migrations;
4
5	class FormMeta
6	{
7
8	/**
9	* Migrate the table.
10	*
11	* @return void
12	*/
13	public static function migrate()
14	{
15	global $wpdb;
16
17	$charsetCollate = $wpdb->get_charset_collate();
18
19	$table = $wpdb->prefix.'fluentform_form_meta';
20
21	$formTable = $wpdb->prefix.'fluentform_forms';
22
23	if ($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) {
24	$sql = "CREATE TABLE $table (
25	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
26	`form_id` INT UNSIGNED NULL,
27	`meta_key` VARCHAR(255) NOT NULL,
28	`value` LONGTEXT NULL,
29	PRIMARY KEY (`id`),
30	INDEX `fluent_form_id_idx` (`form_id` ASC),
31	CONSTRAINT `fk_fluent_form_meta_form_id`
32	FOREIGN KEY (`form_id`)
33	REFERENCES $formTable (`id`)
34	ON DELETE CASCADE
35	ON UPDATE CASCADE) $charsetCollate;";
36
37	require_once(ABSPATH.'wp-admin/includes/upgrade.php');
38
39	dbDelta($sql);
40	}
41	}
42	}