fluentform / app / Databases / Migrations / FormLogs.php

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

40 lines 997 B

Raw Download Zip

1	<?php
2
3	namespace FluentForm\App\Databases\Migrations;
4
5	class FormLogs
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_logs';
20
21	if ($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) {
22	$sql = "CREATE TABLE $table (
23	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
24	`parent_source_id` INT UNSIGNED NULL,
25	`source_type` VARCHAR(255) NULL,
26	`source_id` INT UNSIGNED NULL,
27	`component` VARCHAR(255) NULL,
28	`status` CHAR(30) NULL,
29	`title` VARCHAR(255) NOT NULL,
30	`description` LONGTEXT NULL,
31	`created_at` TIMESTAMP NULL,
32	PRIMARY KEY (`id`) ) $charsetCollate;";
33	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
34	dbDelta($sql);
35	}
36
37	update_option('fluentform_db_fluentform_logs_added', true, 'no');
38
39	}
40	}