Alter users table
-
Hello,
I have create plugin that if we activated it, it will add new column on users table.
the code :
global $PWTW_db_version; $PWTW_db_version = '1.0'; function PWTW_install() { global $wpdb; global $PWTW_db_version; $table_name = $wpdb->prefix . 'users'; $sql = "ALTER TABLE $table_name ADD COLUMN <code>user_credits</code> int(20) NOT NULL AFTER <code>display_name</code>;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql ); add_option( 'PWTW_db_version', $PWTW_db_version ); } $installed_ver = get_option( "PWTW_db_version" ); if ( $installed_ver != $PWTW_db_version ) { $table_name = $wpdb->prefix . 'users'; $sql = "ALTER TABLE $table_name ADD COLUMN <code>user_credits</code> int(20) NOT NULL AFTER <code>display_name</code>;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql ); update_option( "PWTW_db_version", $PWTW_db_version ); } function PWTW_update_db_check() { global $PWTW_db_version; if ( get_site_option( 'PWTW_db_version' ) != $PWTW_db_version ) { PWTW_install(); } } register_activation_hook( __FILE__, 'PWTW_install' ); add_action( 'plugins_loaded', 'PWTW_update_db_check' );
i try to Active the plugin, but it not create new column in users table.
does anyone can light me up?
thank you
- The topic ‘Alter users table’ is closed to new replies.