← All changes | src/Setup/Update/DatabaseUpdate6.php +41 -14 trunk → 2.2.21 View file →

		@@ -1,44 +1,71 @@
1	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	+ */
2	15
3	16	declare(strict_types=1);
4	17
5	18	namespace UserAccessManager\Setup\Update;
6	19
	20	+use UserAccessManager\Setup\Database\DatabaseUpdate;
7	21	use UserAccessManager\UserGroup\UserGroup;
8	22
	23	+/**
	24	+ * Class DatabaseUpdate6
	25	+ *
	26	+ * @package UserAccessManager\Setup\Update
	27	+ */
9	28	class DatabaseUpdate6 extends DatabaseUpdate
10	29	{
	30	+ /**
	31	+ * Returns the version.
	32	+ * @return string
	33	+ */
11	34	public function getVersion(): string
12	35	{
13	36	return '1.6.1';
14	37	}
15	38
	39	+ /**
	40	+ * Executes the update.
	41	+ * @return bool
	42	+ */
16	43	public function update(): bool
17	44	{
18	45	$dbAccessGroupToObject = $this->database->getUserGroupToObjectTable();
19	46
20	47	$dbGroupTypeColumn = $this->database->getVariable(
21		- "SHOW COLUMNS FROM `{$dbAccessGroupToObject}`
	48	+ "SHOW COLUMNS FROM {$dbAccessGroupToObject}
22	49	LIKE 'group_type'"
23	50	);
24	51
25	52	if ($dbGroupTypeColumn !== 'group_type') {
26		- $alterQuery = "ALTER TABLE `{$dbAccessGroupToObject}`
27		- ADD `group_type` VARCHAR(32) NOT NULL AFTER `group_id`,
28		- ADD `from_date` DATETIME NULL DEFAULT NULL,
29		- ADD `to_date` DATETIME NULL DEFAULT NULL,
30		- MODIFY `group_id` VARCHAR(32) NOT NULL,
31		- MODIFY `object_id` VARCHAR(32) NOT NULL,
32		- MODIFY `object_type` VARCHAR(32) NOT NULL,
	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,
33	60	DROP PRIMARY KEY,
34		- ADD PRIMARY KEY (`object_id`, `object_type`, `group_id`, `group_type`)";
	61	+ ADD PRIMARY KEY (object_id, object_type, group_id, group_type)";
35	62	} else {
36		- $alterQuery = "ALTER TABLE `{$dbAccessGroupToObject}`
37		- MODIFY `group_type` VARCHAR(32) NOT NULL,
38		- MODIFY `group_id` VARCHAR(32) NOT NULL,
39		- MODIFY `object_id` VARCHAR(32) NOT NULL,
40		- MODIFY `object_type` VARCHAR(32) NOT NULL";
	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";
41	68	}
42	69
43	70	$success = $this->database->query($alterQuery) !== false;
44	71