function jal_install() {
global $jal_db_version;
$sql = "CREATE TABLE IF NOT EXISTS WP_AWESOME_TABLES (
id mediumint(9) NOT NULL AUTO_INCREMENT,
PRIMARY KEY id (id)
);";
require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
dbDelta( $sql );
add_option( "jal_db_version", $jal_db_version );
}
register_activation_hook( _____FILE_____, 'jal_install' );
You have to hook the function. After activate the plugin table will created.
Related Posts:
- How to define composite keys with dbDelta()
- Why does dbDelta() not catch MysqlErrors?
- Is altering a default WordPress database table update safe?
- What causes the “max_user_connections” warning on WordPress frontend?
- Error establishing a database connection – with Debug Data
- SQL Error wp_commentmeta – incorrect table definition
- Error establishing database connection – high traffic?
- Trouble Migrating all data blog from WordPress.com to WordPress.org
- Unable to set a default serialized array using dbdelta()
- How to fix database error duplicate entry
- I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
- Hang Up Followed By Can’t select database
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- MySQL SELECT increment counter
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Using wpdb to connect to a separate database
- WordPress (MyISAM) database is slow, should I switch to InnoDB?
- Detecting errors generated by $wpdb->get_results()
- WordPress Database lost auto increment
- wpdb->insert multiple record at once
- Restoring WordPress posts from database only
- Slow wp_term_relationships query
- How to use “TRUNCATE TABLE” MySQL statement?
- Fatal error: Call to undefined function dbDelta()
- Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
- When importing database, it shows error
- WordPress for a very large website
- What are conventions about the schema of the $table_prefix
- Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
- Is deleting orphaned wp_options entries safe?
- How to solve slow WordPress site caused by attachment_metadata
- Strange Deadlock database error for the query “Delete From wp_options”
- Delete all post meta except featured image
- WordPress showing install screen after max_questions error
- WooCommerce – Query for ordered products
- Large database causes slow load
- Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
- Database slowdown after update to 3.4.1
- Query WordPress database by registered date and role
- Tons of Twitter rows in my database
- How to insert data into MySQL database from the form created in WordPress site
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Why are no posts showing despite my apparently correct DB restoration?
- Select Multiple meta_value from WP DB; Single Query
- Which is more efficient? Using usermeta, or creating a new MySQL table?
- Is it possible to split database tables using HyperDB?
- What happens if I overwrite the current wp_options table with a backup from a week ago?
- WordPress database error – Error in SQL syntax – I can’t identify any error?
- CRUD operations using WordPress database API
- $wpdb doesn’t like to store arrays
- Handling large N data in WordPress
- How to Mirror WordPress database from Remote server to Local server
- Is MariaDB’s Aria storage engine suitable for WordPress?
- Catalina an MAMP Database Conenction Error
- Slow queries constantly getting stuck on WordPress database of ~100,000 posts
- A MySQL DB within a MySQL DB
- How do I query wp_options for expired transient pairs with MySQL commands?
- Is there a way to recover the table wp_term_relationships?
- WordPress running SQL query to update database from form
- Migration: Copying database content to a different server
- What do these phpMyAdmin errors mean on my WordPress databaes?
- How do I convert a MySQL database from utf8mb4 to utf8 encoding?
- Query multiple tables at once?
- Moving to another server database connection error [closed]
- Remove empty rows from the database
- Custom WordPress Table wpdb
- Why this query is not showing any result on wordpresss home page?
- Best practice to limit results in get_row()?
- Global__r connection timed out
- Trouble running $wpdb->query() with last_insert_id
- how to encyrpt DB_PASSWORD in wp-config
- Moving WordPress site to new domain – database import [duplicate]
- How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
- How can I find user role in Mysql?
- SQL database import #1046 error
- How to import products in host instead of database on wordpress?
- I would like some help wth an SQL query to link posts with categories
- Featured image from custom to WordPress database
- error establishing a database connection 3
- WordPress Database Query works in phpMyAdmin but not in the code
- “wordpress error in establishing database connection” and missing tables
- next comment id number wordpress
- Delete all users meta that named: user_avatar
- Merging development site with live site
- The MySQL Connection could not be established., before it was joomla but i have change it into worpress
- spambot registering without providing email or password, bypassing registration process
- Possible to restore wordpress database from mysql56 and sqlite files?
- Missing latest posts and options after DB migration via phpMyAdmin
- live site do not update after importing sql database
- Widgets with *internal* links do not display after database migration
- How do i get value from wp_postmeta?
- Restoring .sql backup results in “Error establishing a database connection”
- “MySQL server has gone away” since update to 3.8
- featured image not showing up with mysql_connect
- MySQL Database User: Which Privileges are needed?
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- SQL query : Select a thumbnail for a media
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- How to find fresh (last modified) and sql backup?
- Uploading to WordPress Database