← All changes | back/Helpers/Update/Patchv10.php +0 -100 10.0.1 → 11.1.1 View file →

		@@ -1,100 +1,0 @@
1		-<?php
2		-
3		-namespace AcyMailing\Helpers\Update;
4		-
5		-trait Patchv10
6		-{
7		- private function updateFor1000()
8		- {
9		- if ($this->isPreviousVersionAtLeast('10.0.0')) {
10		- return;
11		- }
12		-
13		- $this->updateQuery('ALTER TABLE #__acym_queue ADD COLUMN `params` TEXT NULL');
14		-
15		- $scenarioTable = 'CREATE TABLE IF NOT EXISTS `#__acym_scenario` (
16		- `id` INT NOT NULL AUTO_INCREMENT,
17		- `trigger` VARCHAR(255) NOT NULL,
18		- `name` VARCHAR(255) NOT NULL,
19		- `active` TINYINT(1) NOT NULL DEFAULT 0,
20		- `trigger_params` TEXT NULL,
21		- `trigger_once` TINYINT(1) NOT NULL DEFAULT 0,
22		- PRIMARY KEY (`id`)
23		-)
24		- ENGINE = InnoDB;';
25		-
26		- $scenarioStepTable = 'CREATE TABLE IF NOT EXISTS `#__acym_scenario_step` (
27		- `id` VARCHAR(30) NOT NULL,
28		- `previous_id` VARCHAR(30) NULL,
29		- `type` VARCHAR(30) NOT NULL,
30		- `params` TEXT NULL,
31		- `scenario_id` INT NOT NULL,
32		- `condition_valid` TINYINT(1) NULL,
33		- PRIMARY KEY (`id`),
34		- CONSTRAINT `#__fk_acym_scenario_step1`
35		- FOREIGN KEY (`scenario_id`)
36		- REFERENCES `#__acym_scenario`(`id`)
37		- ON DELETE NO ACTION
38		- ON UPDATE NO ACTION
39		-)
40		- ENGINE = InnoDB;';
41		-
42		- $scenarioProcessTable = 'CREATE TABLE IF NOT EXISTS `#__acym_scenario_process` (
43		- `id` INT NOT NULL AUTO_INCREMENT,
44		- `scenario_id` INT NOT NULL,
45		- `user_id` INT NOT NULL,
46		- `start_at` DATETIME NOT NULL,
47		- `end_at` DATETIME NULL,
48		- PRIMARY KEY (`id`),
49		- CONSTRAINT `#__fk_acym_scenario_process1`
50		- FOREIGN KEY (`scenario_id`)
51		- REFERENCES `#__acym_scenario`(`id`)
52		- ON DELETE NO ACTION
53		- ON UPDATE NO ACTION,
54		- CONSTRAINT `#__fk_acym_scenario_process2`
55		- FOREIGN KEY (`user_id`)
56		- REFERENCES `#__acym_user`(`id`)
57		- ON DELETE NO ACTION
58		- ON UPDATE NO ACTION
59		-)
60		- ENGINE = InnoDB;';
61		-
62		- $scenarioQueueTable = 'CREATE TABLE IF NOT EXISTS `#__acym_scenario_queue` (
63		- `id` INT NOT NULL AUTO_INCREMENT,
64		- `scenario_process_id` INT NOT NULL,
65		- `step_id` VARCHAR(30) NOT NULL,
66		- `execution_date` DATETIME NOT NULL,
67		- PRIMARY KEY (`id`),
68		- CONSTRAINT `#__fk_acym_scenario_queue1`
69		- FOREIGN KEY (`scenario_process_id`)
70		- REFERENCES `#__acym_scenario_process`(`id`)
71		- ON DELETE NO ACTION
72		- ON UPDATE NO ACTION
73		-)
74		- ENGINE = InnoDB;';
75		-
76		- $scenarioHistoryLineTable = 'CREATE TABLE IF NOT EXISTS `#__acym_scenario_history_line` (
77		- `id` INT NOT NULL AUTO_INCREMENT,
78		- `scenario_process_id` INT NOT NULL,
79		- `date` DATETIME NOT NULL,
80		- `type` VARCHAR(10) NOT NULL,
81		- `params` TEXT NULL,
82		- `result` TEXT NULL,
83		- `log` TEXT NULL,
84		- `scenario_step_id` VARCHAR(40) NULL,
85		- PRIMARY KEY (`id`),
86		- CONSTRAINT `#__fk_acym_scenario_history_line1`
87		- FOREIGN KEY (`scenario_process_id`)
88		- REFERENCES `#__acym_scenario_process`(`id`)
89		- ON DELETE NO ACTION
90		- ON UPDATE NO ACTION
91		-)
92		- ENGINE = InnoDB;';
93		-
94		- $this->updateQuery($scenarioTable);
95		- $this->updateQuery($scenarioStepTable);
96		- $this->updateQuery($scenarioProcessTable);
97		- $this->updateQuery($scenarioQueueTable);
98		- $this->updateQuery($scenarioHistoryLineTable);
99		- }
100		-}