user-access-manager / src / Setup / Update / DatabaseUpdate6.php

DatabaseUpdate6.php in User Access Manager 2.2.8, at src/Setup/Update/DatabaseUpdate6.php

81 lines 2.3 KB

Raw Download Zip

1	<?php
2	/**
3	* DatabaseUpdate6.php
4	*
5	* The DatabaseUpdate6 class file.
6	*
7	* PHP versions 5
8	*
9	* @author Alexander Schneider <alexanderschneider85@gmail.com>
10	* @copyright 2008-2017 Alexander Schneider
11	* @license http://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2
12	* @version SVN: $id$
13	* @link http://wordpress.org/extend/plugins/user-access-manager/
14	*/
15
16	declare(strict_types=1);
17
18	namespace UserAccessManager\Setup\Update;
19
20	use UserAccessManager\Setup\Database\DatabaseUpdate;
21	use UserAccessManager\UserGroup\UserGroup;
22
23	/**
24	* Class DatabaseUpdate6
25	*
26	* @package UserAccessManager\Setup\Update
27	*/
28	class DatabaseUpdate6 extends DatabaseUpdate
29	{
30	/**
31	* Returns the version.
32	* @return string
33	*/
34	public function getVersion(): string
35	{
36	return '1.6.1';
37	}
38
39	/**
40	* Executes the update.
41	* @return bool
42	*/
43	public function update(): bool
44	{
45	$dbAccessGroupToObject = $this->database->getUserGroupToObjectTable();
46
47	$dbGroupTypeColumn = $this->database->getVariable(
48	"SHOW COLUMNS FROM {$dbAccessGroupToObject}
49	LIKE 'group_type'"
50	);
51
52	if ($dbGroupTypeColumn !== 'group_type') {
53	$alterQuery = "ALTER TABLE {$dbAccessGroupToObject}
54	ADD group_type VARCHAR(32) NOT NULL AFTER group_id,
55	ADD from_date DATETIME NULL DEFAULT NULL,
56	ADD to_date DATETIME NULL DEFAULT NULL,
57	MODIFY group_id VARCHAR(32) NOT NULL,
58	MODIFY object_id VARCHAR(32) NOT NULL,
59	MODIFY object_type VARCHAR(32) NOT NULL,
60	DROP PRIMARY KEY,
61	ADD PRIMARY KEY (object_id, object_type, group_id, group_type)";
62	} else {
63	$alterQuery = "ALTER TABLE {$dbAccessGroupToObject}
64	MODIFY group_type VARCHAR(32) NOT NULL,
65	MODIFY group_id VARCHAR(32) NOT NULL,
66	MODIFY object_id VARCHAR(32) NOT NULL,
67	MODIFY object_type VARCHAR(32) NOT NULL";
68	}
69
70	$success = $this->database->query($alterQuery) !== false;
71
72	$update = $this->database->update(
73	$dbAccessGroupToObject,
74	['group_type' => UserGroup::USER_GROUP_TYPE],
75	['group_type' => '']
76	);
77
78	return $success && $update !== false;
79	}
80	}
81