title: Can't Create New Wordpress Database Table
body: <p>could someone please help me figure out why wordpress doesn't create the "my_notes" table when I activate my plugin.</p>
  
  <pre><code>&lt;?php
  /* NOTES */
  function dashboard_my_notes()
  {
      global $wpdb;
      require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
      $table_name = $wpdb-&gt;prefix . 'my_notes';
      $sql = "CREATE TABLE IF NOT EXISTS $table_name(
              id int(10) unsigned NOT NULL AUTO_INCREMENT,
              date_notes DATE NOT NULL DEFAULT CURRENT_DATE,
              status LONGTEXT NOT NULL,
              notes varchar(9999) COLLATE utf8_unicode_ci NOT NULL,
                PRIMARY KEY (id)
              );";
      dbDelta($sql);
  }
  add_action( 'plugins_loaded', 'dashboard_my_notes' );
  </code></pre>