| Server IP : 65.109.86.83 / Your IP : 216.73.217.84 Web Server : nginx/1.14.1 System : Linux libra 4.18.0-553.51.1.el8_10.x86_64 #1 SMP Wed Apr 30 20:24:04 UTC 2025 x86_64 User : root ( 0) PHP Version : 8.3.31 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,parse_ini_file,show_source MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/html/wp-content/plugins/thrive-leads/database/migrations/ |
Upload File : |
<?php
/* Creates tables for storing contact data */
defined( 'TVE_LEADS_DB_UPGRADE' ) or exit();
global $wpdb;
$contact_table = tve_leads_table_name( 'contacts' );
$sql = "CREATE TABLE IF NOT EXISTS {$contact_table}(
`id` INT( 11 ) AUTO_INCREMENT,
`log_id` INT( 11 ),
`name` VARCHAR( 255 ) NULL,
`email` VARCHAR( 255 ) NULL,
`date` DATETIME NULL,
`custom_fields` TEXT,
PRIMARY KEY( `id` )
) CHARACTER SET utf8 COLLATE utf8_general_ci;";
$wpdb->query( $sql );
$manager_table = tve_leads_table_name( 'contact_download' );
$sql = "CREATE TABLE IF NOT EXISTS {$manager_table}(
`id` INT( 11 ) AUTO_INCREMENT,
`type` VARCHAR( 255 ),
`download_link` VARCHAR( 255 ) NULL,
`date` DATETIME NULL,
`status` VARCHAR( 64 ) ,
PRIMARY KEY( `id` )
) CHARACTER SET utf8 COLLATE utf8_general_ci;";
$wpdb->query( $sql );