get_charset_collate(); $table_fbv = $wpdb->prefix.'fbv'; //type == 0: folder //type == 1: collection if ($wpdb->get_var("show tables like '$table_fbv'") != $table_fbv) { $sql = 'CREATE TABLE '.$table_fbv.' ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(250) NOT NULL, `parent` int(11) NOT NULL DEFAULT 0, `type` int(2) NOT NULL DEFAULT 0, `ord` int(11) NULL DEFAULT 0, `created_by` int(11) NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY `id` (id)) ' . 'ENGINE = InnoDB '.$charset_collate.';'; require_once ABSPATH.'wp-admin/includes/upgrade.php'; dbDelta($sql); } $table = $wpdb->prefix.'fbv_attachment_folder'; //type == 0: folder //type == 1: collection if ($wpdb->get_var("show tables like '$table'") != $table) { $sql = 'CREATE TABLE '.$table.' ( `folder_id` int(11) unsigned NOT NULL, `attachment_id` bigint(20) unsigned NOT NULL, UNIQUE( `folder_id`, `attachment_id`) ) ' . 'ENGINE = InnoDB '.$charset_collate.';'; require_once ABSPATH.'wp-admin/includes/upgrade.php'; dbDelta($sql); //$wpdb->query("ALTER TABLE `".$table."` ADD CONSTRAINT `".$table."_ibfk_1` FOREIGN KEY (`folder_id`) REFERENCES `".$table_fbv."` (`id`) ON DELETE CASCADE;"); } $first_time_active = get_option('fbv_first_time_active'); $fbv_review = get_option('fbv_review'); if ($first_time_active === false) { update_option('fbv_is_new_user', 1); update_option('fbv_first_time_active', 1); if ($fbv_review !== false) return; update_option('fbv_review', time() + 3*60*60*24); //After 3 days show } $current_version = get_option('fbv_version'); if ( version_compare(NJFB_VERSION, $current_version, '>') ) { update_option('fbv_version', NJFB_VERSION); if ($fbv_review !== false) return; update_option('fbv_review', time() + 3*60*60*24); //After 3 days show } FilebirdSchedule::registerShedule(); } /** Plugin deactivate hook */ public static function deactivate() { FilebirdSchedule::clearSchedule(); } }