Title: How Generate table under database
Last modified: August 31, 2016

---

# How Generate table under database

 *  [wpdebug](https://wordpress.org/support/users/wpdebug/)
 * (@wpdebug)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/how-generate-table-under-database/)
 * i made plugin which auto generate database if not exist. same way i want to generate
   table under generated database. For Example
    - I generate database with codes like ABCD
    - Now next i want generate DEF table under ABCD database
 * I try these codes
 *     ```
       function plugin_name_activation() {
       	require_once( ABSPATH . '/wp-admin/includes/upgrade.php' );
       	global $wpdb;
       	$db_table_name = $wpdb->prefix . 'table_name';
       	if( $wpdb->get_var( "SHOW TABLES LIKE '$db_table_name'" ) != $db_table_name ) {
       		if ( ! empty( $wpdb->charset ) )
       			$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
       		if ( ! empty( $wpdb->collate ) )
       			$charset_collate .= " COLLATE $wpdb->collate";
   
       		$sql = "CREATE TABLE " . $db_table_name . " (
       			<code>id</code> bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
       			<code>type</code> varchar(100) NOT NULL DEFAULT '',
       			<code>extra</code> longtext NOT NULL,
       			<code>date_time</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
       			PRIMARY KEY (<code>id</code>)
       		) $charset_collate;";
       		dbDelta( $sql );
       	}
       }
       register_activation_hook(__FILE__, 'plugin_name_activation');
       ```
   
 * [http://web-profile.com.ua/wordpress/dev/create-table-on-plugin-activation/](http://web-profile.com.ua/wordpress/dev/create-table-on-plugin-activation/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Moderator [Jan Dembowski](https://wordpress.org/support/users/jdembowski/)
 * (@jdembowski)
 * Forum Moderator and Brute Squad
 * [10 years, 4 months ago](https://wordpress.org/support/topic/how-generate-table-under-database/#post-6905222)
 * Formatting fixed.
 * Please wrap `<li>...</li>` with either `<ol>` or `<ul>` or it breaks the formatting
   here.
 *  Thread Starter [wpdebug](https://wordpress.org/support/users/wpdebug/)
 * (@wpdebug)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/how-generate-table-under-database/#post-6905228)
 * Thanks [@jan](https://wordpress.org/support/users/jan/) for reply, Sorry I’m 
   Newbie here

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘How Generate table under database’ is closed to new replies.

## Tags

 * [plugin develop](https://wordpress.org/support/topic-tag/plugin-develop/)
 * [wpdb](https://wordpress.org/support/topic-tag/wpdb/)

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 2 replies
 * 2 participants
 * Last reply from: [wpdebug](https://wordpress.org/support/users/wpdebug/)
 * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/how-generate-table-under-database/#post-6905228)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics