Install Reviews Table

yzc_install_reviews_table.php

<?php
/**
 * Install Reviews Table
 * Ps: Once the reviews table added just remove this snippet.
 */
function yzc_install_reviews_table() {

    global $wpdb;


    // Set Variables
    $sql = array();
    $reviews_table = $wpdb->prefix . 'youzify_reviews';
    $charset_collate = $wpdb->get_charset_collate();
    
	$sql[] = "CREATE TABLE $reviews_table (
		id BIGINT(20) NOT NULL AUTO_INCREMENT,
		reviewer int(11) NOT NULL,
		reviewed int(11) NOT NULL,
		rating DECIMAL(2,1) NOT NULL,
		review LONGTEXT NOT NULL,
		options LONGTEXT NOT NULL,
	 	time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
		PRIMARY KEY (id)
	) $charset_collate;";

	// Include Files.
	require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );

	// Build Tables.
	dbDelta( $sql );
}

add_action( 'init', 'yzc_install_reviews_table' );