wp php sql create column

sql-create-column.php

<?php 


      // $code = 11;
      // $department = 2;
      // $subdivision = 3; 
      // $address =4;
      // $title =5 ;
      // $full_title = 6;
      // $short_title =7 ;
      // $position = 9;
      // $phone = 10;
      // $time = 10;
function create_db_table() {
	global $wpdb;
	$table_name = $wpdb->get_blog_prefix() . 'test01';

	if( !$wpdb->query(  $wpdb->prepare("SHOW TABLES LIKE '%s'", $table_name )  )  ){

		require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
		$charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate}";

		$sql = "CREATE TABLE {$table_name} (
		id  bigint(20) unsigned NOT NULL auto_increment,
		code varchar(255) NOT NULL default '',
		department text default NULL,
		subdivision text default NULL,
		address text default NULL,
		title text default NULL,
		full_title text default NULL,
		short_title text default NULL,
		position text default NULL,
		phone text default NULL,
		`time` text default NULL,
		coordin text default NULL,

		PRIMARY KEY  (id)
		)
		{$charset_collate};";

		dbDelta($sql);
	}

}

// ALTER TABLE Employees ADD COLUMN middle_name CHAR(10) NULL AFTER first_name;
// $table_name = $wpdb->get_blog_prefix()  . 'comments';
// $new_column = 'new_price';
// $wpdb->query("ALTER TABLE $table_name ADD COLUMN $new_column varchar(255) NULL");





function xdp_create_db_table_products() {
	global $wpdb;
	$table_name = $wpdb->get_blog_prefix() . 'all_xls_products';

	if( !$wpdb->query(  $wpdb->prepare("SHOW TABLES LIKE '%s'", $table_name )  )  ){

		require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
		$charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate}";

		$sql = "CREATE TABLE {$table_name} (
		id  bigint(20) unsigned NOT NULL auto_increment,
		article varchar(255) NOT NULL default '',
		name text NOT NULL default '',
		rub_price float(24) default NULL,
		usd_price float(24) default NULL,

		PRIMARY KEY  (id)
		)
		{$charset_collate};";

		dbDelta($sql);
	}

}