fluent-boards / database / Migrations / NotificationUserMigrator.php

NotificationUserMigrator.php in FluentBoards – Project Management, Task Management, Goal Tracking, Kanban Board, and, Team Collaboration 1.22, at database/Migrations/NotificationUserMigrator.php

36 lines 1.1 KB

Raw Download Zip

1	<?php
2
3	namespace FluentBoards\Database\Migrations;
4
5	class NotificationUserMigrator
6	{
7	/**
8	* Task Activities Table.
9	*
10	* @param bool $isForced
11	* @return void
12	*/
13	public static function migrate($isForced = true)
14	{
15	global $wpdb;
16
17	$charsetCollate = $wpdb->get_charset_collate();
18	$table = $wpdb->prefix . 'fbs_notification_users';
19
20	if ($wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $table)) != $table \|\| $isForced) {
21	$sql = "CREATE TABLE $table (
22	`id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
23	`notification_id` INT UNSIGNED NULL,
24	`user_id` BIGINT UNSIGNED NOT NULL,
25	`marked_read_at` TIMESTAMP NULL,
26	`created_at` TIMESTAMP NULL,
27	`updated_at` TIMESTAMP NULL,
28	KEY `notification_id` (`notification_id`),
29	KEY `user_id` (`user_id`)
30	) $charsetCollate;";
31	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
32	dbDelta($sql);
33	}
34	}
35	}
36