ablocks / includes / database / create-form-table.php

create-form-table.php in aBlocks – Gutenberg Blocks, User Dashboard Builder, Popup Builder, Form Builder & Animation Builder 2.9.1, at includes/database/create-form-table.php

56 lines 1.9 KB

Raw Download Zip

1	<?php
2	namespace ABlocks\Database;
3
4	if ( ! defined( 'ABSPATH' ) ) {
5	exit;
6	}
7
8	class CreateFormTable {
9	public static function up( $prefix, $charset_collate ) {
10	$table_entries = $prefix . ABLOCKS_PLUGIN_SLUG . '_form_entries';
11	$table_meta = $prefix . ABLOCKS_PLUGIN_SLUG . '_form_meta';
12
13	$sql_entries = "CREATE TABLE $table_entries (
14	id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
15	form_type VARCHAR(50) NOT NULL,
16
17	post_id VARCHAR(100) NULL, -- for post id
18	ip VARCHAR(100) NULL, -- for user ip
19	is_in_trash VARCHAR(20) DEFAULT 'no',
20	user_agent VARCHAR(250) NULL, -- for user browser agent
21
22	block_id VARCHAR(100) NOT NULL,
23	user_email VARCHAR(100) NOT NULL,
24	status VARCHAR(50) DEFAULT 'unread',
25	is_email_verified VARCHAR(20) DEFAULT 'no',
26	expire INT(20) NULL,
27	email_verification_token VARCHAR(100) NOT NULL,
28	created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
29	updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
30	PRIMARY KEY (id)
31	) $charset_collate;";
32
33	// SQL to create the custom_form_meta table
34	$sql_meta = "CREATE TABLE $table_meta (
35	meta_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
36	entry_id BIGINT(20) UNSIGNED NOT NULL,
37	meta_key VARCHAR(255) NOT NULL,
38	meta_value TEXT NOT NULL,
39	PRIMARY KEY (meta_id),
40	FOREIGN KEY (entry_id) REFERENCES $table_entries(id) ON DELETE CASCADE ON UPDATE CASCADE
41	) $charset_collate;";
42
43	dbDelta( $sql_entries );
44	dbDelta( $sql_meta );
45	}
46	public static function down( $prefix ) {
47	global $wpdb;
48
49	$table_entries = $prefix . ABLOCKS_PLUGIN_SLUG . '_form_entries';
50	$table_meta = $prefix . ABLOCKS_PLUGIN_SLUG . '_form_meta';
51
52	$sql = "DROP TABLE IF EXISTS $table_meta, $table_entries;";
53	$wpdb->query( $sql );
54	}
55	}
56