9SgVcVLT

1global $wpdb;
2
3	$table_name = $wpdb->prefix."<table_name>";
4    
5    // check if exists or not
6	if ($wpdb->get_var("SHOW TABLES LIKE '".$table_name."'") != $table_name) {
7		$charset_collate = $wpdb->get_charset_collate();
8		$sql = "CREATE TABLE $table_name (
9		id INTEGER(9) NOT NULL AUTO_INCREMENT,
10		user_id INTEGER(9) NOT NULL,
11		name VARCHAR(255),
12		email VARCHAR(255),
13		phone VARCHAR(255),
14		position VARCHAR(255),
15		department VARCHAR(255),
16		user_status VARCHAR(255),
17		PRIMARY KEY (id)) $charset_collate;";
18
19		require_once(ABSPATH.'wp-admin/includes/upgrade.php');
20		dbDelta($sql);
21	}