<?php
register_activation_hook(__FILE__, 'plugin_install');
function plugin_install() {
	require_once( ABSPATH . '/wp-admin/includes/upgrade.php' );
	global $wpdb;
	$table = $wpdb->prefix . 'teable_name';
	if( $wpdb->get_var( "SHOW TABLES LIKE '$table'" ) != $table ) {
		if ( ! empty( $wpdb->charset ) )
			$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
		if ( ! empty( $wpdb->collate ) )
			$charset_collate .= " COLLATE $wpdb->collate";
 
		$sql = "CREATE TABLE " . $table . " (
			`post_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
			`date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
			`desc` varchar(100) NOT NULL DEFAULT '',
			UNIQUE KEY (post_id)
		) $charset_collate;";
		dbDelta( $sql );
	}
}
?>