{"id":18395174,"date":"2025-04-02T09:02:59","date_gmt":"2025-04-02T09:02:59","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-versioning-2\/"},"modified":"2025-04-02T09:02:59","modified_gmt":"2025-04-02T09:02:59","slug":"database-versioning-2","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-versioning-2\/","title":{"rendered":"Database Versioning"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">It&#8217;s been two years and you have not sorted out your database versioning issues&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Change this code:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>function gravitecnet_abandoned_cart_table(){<br \/>\tif( class_exists( 'woocommerce' ) ){<br \/>\t\tglobal $wpdb;<br \/>\t\t$charset_collate = $wpdb-&gt;get_charset_collate();<br \/>\t\t$query = \"CREATE TABLE IF NOT EXISTS \" . $wpdb-&gt;prefix . \"gravitecnet_abandoned_cart (<br \/>\t\t\t\t<code>id<\/code> int(10) unsigned NOT NULL AUTO_INCREMENT,<br \/>\t\t\t\t<code>date_time<\/code> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,<br \/>\t\t\t\t<code>regID<\/code> varchar(500) CHARACTER SET latin1 DEFAULT NULL,<br \/>\t\t\t\t<code>prod_count<\/code> TINYINT(4) DEFAULT NULL,<br \/>\t\t\t\t<code>prod_id<\/code> BIGINT(20)  DEFAULT NULL,<br \/>\t\t\t\t<code>cart_total<\/code> varchar(20) CHARACTER SET latin1 DEFAULT NULL,<br \/>\t\t\t\tPRIMARY KEY  (<code>id<\/code>),<br \/>\t\t\t\tUNIQUE(<code>regID<\/code>)<br \/>\t\t\t\t) $charset_collate; \";<br \/>\t\t\t\t<br \/>\t\trequire_once( ABSPATH . 'wp-admin\/includes\/upgrade.php' );<br \/>\t\tdbDelta( $query );<br \/>\t}\t<br \/>}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">to<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>global $gravitecnet_db_version;<br \/>$gravitecnet_db_version = 1;<br \/><br \/>function gravitecnet_abandoned_cart_table(){<br \/>\tglobal $gravitecnet_db_version;<br \/><br \/>\tif( class_exists( 'woocommerce' ) ){<br \/>\t\t$installed_ver = get_option( 'gravitecnet_db_version' );<br \/>\t\tif ( $installed_ver != $gravitecnet_db_version ) {<br \/>\t\t\tglobal $wpdb;<br \/>\t\t\t$charset_collate = $wpdb-&gt;get_charset_collate();<br \/>\t\t\t$query = \"CREATE TABLE IF NOT EXISTS \" . $wpdb-&gt;prefix . \"gravitecnet_abandoned_cart (<br \/>\t\t\t\t\t<code>id<\/code> int(10) unsigned NOT NULL AUTO_INCREMENT,<br \/>\t\t\t\t\t<code>date_time<\/code> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,<br \/>\t\t\t\t\t<code>regID<\/code> varchar(500) CHARACTER SET latin1 DEFAULT NULL,<br \/>\t\t\t\t\t<code>prod_count<\/code> TINYINT(4) DEFAULT NULL,<br \/>\t\t\t\t\t<code>prod_id<\/code> BIGINT(20)  DEFAULT NULL,<br \/>\t\t\t\t\t<code>cart_total<\/code> varchar(20) CHARACTER SET latin1 DEFAULT NULL,<br \/>\t\t\t\t\tPRIMARY KEY  (<code>id<\/code>),<br \/>\t\t\t\t\tUNIQUE(<code>regID<\/code>)<br \/>\t\t\t\t\t) $charset_collate; \";<br \/><br \/>\t\t\trequire_once( ABSPATH . 'wp-admin\/includes\/upgrade.php' );<br \/>\t\t\tdbDelta( $query );<br \/><br \/>\t\t\tupdate_option( 'gravitecnet_db_version', $gravitecnet_db_version );<br \/>\t\t}<br \/>\t}\t<br \/>}<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-18395174","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18395174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18395174\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18395174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}