><\/span>prefix . 'my_analysis';<\/td>\n <\/tr>\n \n <\/td>\n | \n<\/td>\n <\/tr>\n |
\n <\/td>\n | \$sql = "CREATE TABLE \$table_name (<\/td>\n <\/tr>\n |
\n <\/td>\n | id mediumint(9) NOT NULL AUTO_INCREMENT,<\/td>\n <\/tr>\n |
\n <\/td>\n | time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,<\/td>\n <\/tr>\n |
\n <\/td>\n | views smallint(5) NOT NULL,<\/td>\n <\/tr>\n |
\n <\/td>\n | clicks smallint(5) NOT NULL,<\/td>\n <\/tr>\n |
\n <\/td>\n | UNIQUE KEY id (id)<\/td>\n <\/tr>\n |
\n <\/td>\n | ) \$charset_collate;";<\/td>\n <\/tr>\n |
\n <\/td>\n | \n<\/td>\n <\/tr>\n |
\n <\/td>\n | require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );<\/td>\n <\/tr>\n |
\n <\/td>\n | dbDelta( \$sql );<\/td>\n <\/tr>\n |
\n <\/td>\n | <\/td>\n <\/tr>\n |
\n <\/td>\n | if ( version_compare( \$version, '2.0' ) <<\/span> 0<\/span> )<\/span> {<\/span><\/td>\n <\/tr>\n \n <\/td>\n | \$sql<\/span> = "CREATE TABLE \$table_name (<\/span><\/td>\n <\/tr>\n \n <\/td>\n | id mediumint(9) NOT NULL AUTO_INCREMENT,<\/span><\/td>\n <\/tr>\n \n <\/td>\n | time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,<\/span><\/td>\n <\/tr>\n \n <\/td>\n | views smallint(5) NOT NULL,<\/span><\/td>\n <\/tr>\n \n <\/td>\n | clicks smallint(5) NOT NULL,<\/span><\/td>\n <\/tr>\n \n <\/td>\n | blog_id smallint(5) NOT NULL,<\/span><\/td>\n <\/tr>\n \n <\/td>\n | UNIQUE KEY id (id)<\/span><\/td>\n <\/tr>\n \n <\/td>\n | ) \$charset_collate;<\/span>";<\/span><\/td>\n <\/tr>\n \n <\/td>\n | dbDelta(<\/span> \$sql<\/span> );<\/span><\/td>\n <\/tr>\n \n <\/td>\n | <\/td>\n <\/tr>\n | \n <\/td>\n | update_option(<\/span> 'my_plugin_version', '2.0' );<\/td>\n <\/tr>\n \n <\/td>\n | <\/td>\n <\/tr>\n | \n <\/td>\n | }<\/td>\n <\/tr>\n | \n <\/td>\n | \n<\/td>\n <\/tr>\n | \n <\/td>\n | <\/td>\n <\/tr>\n | \n <\/td>\n | }<\/td>\n <\/tr>\n <\/table>\n<\/div>\n\n\n <\/div>\n\n <\/div>\n<\/div>\n\n <\/div>\n | | | | | | | | | | | |