Browse code

added appinfo/info.xml appinfo/signature.json CHANGELOG.txt img/sms_relentless.svg img/sms_relentless_dark.svg img/sms_relentless_grey.svg lib/Migration/Version100Date20211106192148.php lib/Migration/Version106Date20220813144231.php lib/Migration/Version108Date20220823132408.php lib/Migration/Version114Date20221202011625.php

DoubleBastionAdmin authored on 01/12/2022 21:42:31
Showing 1 changed files
lib/Migration/Version108Date20220823132408.php
History View file @ ebb629d
1 1 
new file mode 100644
... ... 
@@ -0,0 +1,289 @@
1 
+<?php
2 
+/**
3 
+ * @copyright 2021 Double Bastion LLC <www.doublebastion.com>
4 
+ *
5 
+ * @author Double Bastion LLC
6 
+ *
7 
+ * @license GNU AGPL version 3 or any later version
8 
+ *
9 
+ * This program is free software; you can redistribute it and/or
10 
+ * modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE
11 
+ * License as published by the Free Software Foundation; either
12 
+ * version 3 of the License, or any later version.
13 
+ *
14 
+ * This program is distributed in the hope that it will be useful,
15 
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17 
+ * GNU AFFERO GENERAL PUBLIC LICENSE for more details.
18 
+ *
19 
+ * You should have received a copy of the GNU Affero General Public
20 
+ * License along with this program.  If not, see <http://www.gnu.org/licenses/>.
21 
+ *
22 
+ */
23 
+
24 
+declare(strict_types=1);
25 
+
26 
+namespace OCA\SMSRelentless\Migration;
27 
+
28 
+use Closure;
29 
+use OCP\DB\Types;
30 
+use OCP\DB\ISchemaWrapper;
31 
+use OCP\Migration\IOutput;
32 
+use OCP\Migration\SimpleMigrationStep;
33 
+
34 
+
35 
+class Version108Date20220823132408 extends SimpleMigrationStep {
36 
+	/**
37 
+	 * @param IOutput $output
38 
+	 * @param Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper`
39 
+	 * @param array $options
40 
+	 * @return null|ISchemaWrapper
41 
+	 */
42 
+	public function changeSchema(IOutput $output, Closure $schemaClosure, array $options): ?ISchemaWrapper {
43 
+		/** @var ISchemaWrapper $schema */
44 
+		$schema = $schemaClosure();
45 
+
46 
+		if (!$schema->hasTable('sms_relent_settings')) {
47 
+			$table = $schema->createTable('sms_relent_settings');
48 
+			$table->addColumn('id', Types::BIGINT, [
49 
+				'autoincrement' => true,
50 
+				'notnull' => true,
51 
+                                'length' => 11,
52 
+                                'unsigned' => true,
53 
+			]);
54 
+			$table->addColumn('user_id', Types::STRING, [
55 
+				'notnull' => true,
56 
+				'length' => 128,
57 
+			]);
58 
+			$table->addColumn('telapi_key', Types::STRING, [
59 
+				'notnull' => true,
60 
+				'length' => 512,
61 
+			]);
62 
+			$table->addColumn('tel_pub_key', Types::STRING, [
63 
+				'notnull' => true,
64 
+				'length' => 512,
65 
+			]);
66 
+			$table->addColumn('telapi_url_rec', Types::STRING, [
67 
+				'notnull' => true,
68 
+				'length' => 512,
69 
+			]);
70 
+			$table->addColumn('telapi_url', Types::STRING, [
71 
+				'notnull' => true,
72 
+				'length' => 512,
73 
+			]);
74 
+			$table->addColumn('messaging_profile_id', Types::STRING, [
75 
+				'notnull' => true,
76 
+				'length' => 512,
77 
+			]);
78 
+			$table->addColumn('nexapi_key', Types::STRING, [
79 
+				'notnull' => true,
80 
+				'length' => 512,
81 
+			]);
82 
+			$table->addColumn('nexapi_secret', Types::STRING, [
83 
+				'notnull' => true,
84 
+				'length' => 512,
85 
+			]);
86 
+			$table->addColumn('nexapi_url_rec', Types::STRING, [
87 
+				'notnull' => true,
88 
+				'length' => 512,
89 
+			]);
90 
+			$table->addColumn('nexapi_url', Types::STRING, [
91 
+				'notnull' => true,
92 
+				'length' => 512,
93 
+			]);
94 
+			$table->addColumn('twilapi_key', Types::STRING, [
95 
+				'notnull' => true,
96 
+				'length' => 512,
97 
+			]);
98 
+			$table->addColumn('twilapi_secret', Types::STRING, [
99 
+				'notnull' => true,
100 
+				'length' => 512,
101 
+			]);
102 
+			$table->addColumn('twilapi_url_rec', Types::STRING, [
103 
+				'notnull' => true,
104 
+				'length' => 512,
105 
+			]);
106 
+			$table->addColumn('twilapi_url', Types::STRING, [
107 
+				'notnull' => true,
108 
+				'length' => 512,
109 
+			]);
110 
+			$table->addColumn('flowapi_key', Types::STRING, [
111 
+				'notnull' => true,
112 
+				'length' => 512,
113 
+			]);
114 
+			$table->addColumn('flowapi_secret', Types::STRING, [
115 
+				'notnull' => true,
116 
+				'length' => 512,
117 
+			]);
118 
+			$table->addColumn('flowapi_url_rec', Types::STRING, [
119 
+				'notnull' => true,
120 
+				'length' => 512,
121 
+			]);
122 
+			$table->addColumn('flowapi_url', Types::STRING, [
123 
+				'notnull' => true,
124 
+				'length' => 512,
125 
+			]);
126 
+			$table->addColumn('tel_sender_name', Types::STRING, [
127 
+				'notnull' => false,
128 
+				'length' => 48,
129 
+				'default' => '',
130 
+			]);
131 
+			$table->addColumn('nex_sender_name', Types::STRING, [
132 
+				'notnull' => false,
133 
+				'length' => 48,
134 
+				'default' => '',
135 
+			]);
136 
+			$table->addColumn('twil_sender_name', Types::STRING, [
137 
+				'notnull' => false,
138 
+				'length' => 48,
139 
+				'default' => '',
140 
+			]);
141 
+			$table->addColumn('flow_sender_name', Types::STRING, [
142 
+				'notnull' => false,
143 
+				'length' => 48,
144 
+				'default' => '',
145 
+			]);
146 
+			$table->addColumn('messagesperpage', Types::INTEGER, [
147 
+				'notnull' => false,
148 
+				'length' => 11,
149 
+                                'unsigned' => true,
150 
+			]);
151 
+			$table->addColumn('get_notify', Types::SMALLINT, [
152 
+				'notnull' => false,
153 
+				'length' => 1,
154 
+			]);
155 
+			$table->addColumn('notification_email', Types::STRING, [
156 
+				'notnull' => false,
157 
+				'length' => 512,
158 
+				'default' => '',
159 
+			]);
160 
+			$table->addColumn('getsmsinemail', Types::SMALLINT, [
161 
+				'notnull' => false,
162 
+				'length' => 1,
163 
+			]);
164 
+                        $table->setPrimaryKey(['id']);
165 
+                        $table->addUniqueIndex(['id']);
166 
+
167 
+		} else {
168 
+
169 
+                        $table = $schema->getTable('sms_relent_settings');
170 
+
171 
+			$table->addColumn('flowapi_key', Types::STRING, [
172 
+				'notnull' => true,
173 
+				'length' => 512,
174 
+			]);
175 
+			$table->addColumn('flowapi_secret', Types::STRING, [
176 
+				'notnull' => true,
177 
+				'length' => 512,
178 
+			]);
179 
+			$table->addColumn('flowapi_url_rec', Types::STRING, [
180 
+				'notnull' => true,
181 
+				'length' => 512,
182 
+			]);
183 
+			$table->addColumn('flowapi_url', Types::STRING, [
184 
+				'notnull' => true,
185 
+				'length' => 512,
186 
+			]);
187 
+			$table->addColumn('flow_sender_name', Types::STRING, [
188 
+				'notnull' => false,
189 
+				'length' => 48,
190 
+				'default' => '',
191 
+			]);
192 
+
193 
+                }
194 
+
195 
+		if (!$schema->hasTable('sms_relent_received')) {
196 
+			$table = $schema->createTable('sms_relent_received');
197 
+			$table->addColumn('id', Types::BIGINT, [
198 
+				'autoincrement' => true,
199 
+				'notnull' => true,
200 
+                                'length' => 11,
201 
+                                'unsigned' => true,
202 
+			]);
203 
+			$table->addColumn('user_id', Types::STRING, [
204 
+				'notnull' => true,
205 
+				'length' => 64,
206 
+			]);
207 
+			$table->addColumn('message_id', Types::STRING, [
208 
+				'notnull' => true,
209 
+				'length' => 512,
210 
+			]);
211 
+			$table->addColumn('date', Types::DATETIME, [
212 
+				'notnull' => true,
213 
+			]);
214 
+			$table->addColumn('from', Types::STRING, [
215 
+				'notnull' => true,
216 
+				'length' => 128,
217 
+			]);
218 
+			$table->addColumn('to', Types::STRING, [
219 
+				'notnull' => true,
220 
+				'length' => 128,
221 
+			]);
222 
+			$table->addColumn('message', Types::TEXT, [
223 
+				'notnull' => false,
224 
+				'default' => '',
225 
+			]);
226 
+                        $table->setPrimaryKey(['id']);
227 
+                        $table->addUniqueIndex(['id']);
228 
+
229 
+		}
230 
+
231 
+		if (!$schema->hasTable('sms_relent_sent')) {
232 
+			$table = $schema->createTable('sms_relent_sent');
233 
+			$table->addColumn('id', Types::BIGINT, [
234 
+				'autoincrement' => true,
235 
+				'notnull' => true,
236 
+                                'length' => 11,
237 
+                                'unsigned' => true,
238 
+			]);
239 
+			$table->addColumn('user_id', Types::STRING, [
240 
+				'notnull' => true,
241 
+				'length' => 64,
242 
+			]);
243 
+			$table->addColumn('message_id', Types::STRING, [
244 
+				'notnull' => true,
245 
+				'length' => 512,
246 
+			]);
247 
+			$table->addColumn('date', Types::DATETIME, [
248 
+				'notnull' => true,
249 
+			]);
250 
+			$table->addColumn('from', Types::STRING, [
251 
+				'notnull' => true,
252 
+				'length' => 128,
253 
+			]);
254 
+			$table->addColumn('to', Types::STRING, [
255 
+				'notnull' => true,
256 
+				'length' => 128,
257 
+			]);
258 
+			$table->addColumn('network ', Types::STRING, [
259 
+				'notnull' => false,
260 
+				'length' => 64,
261 
+				'default' => '',
262 
+			]);
263 
+			$table->addColumn('price', Types::STRING, [
264 
+				'notnull' => false,
265 
+				'length' => 64,
266 
+				'default' => '',
267 
+			]);
268 
+			$table->addColumn('status', Types::STRING, [
269 
+				'notnull' => false,
270 
+				'length' => 512,
271 
+				'default' => '',
272 
+			]);
273 
+			$table->addColumn('deliveryreceipt', Types::STRING, [
274 
+				'notnull' => false,
275 
+				'length' => 64,
276 
+				'default' => '',
277 
+			]);
278 
+			$table->addColumn('message', Types::TEXT, [
279 
+				'notnull' => false,
280 
+                                'default' => '',
281 
+			]);
282 
+                        $table->setPrimaryKey(['id']);
283 
+                        $table->addUniqueIndex(['id']);
284 
+
285 
+		}
286 
+
287 
+		return $schema;
288 
+	}
289 
+}
Browse code

removed appinfo/info.xml appinfo/signature.json CHANGELOG.txt img/sms_relentless.svg img/sms_relentless_dark.svg img/sms_relentless_grey.svg lib/Migration/Version100Date20211106192148.php lib/Migration/Version105Date20220509201842.php lib/Migration/Version106Date20220813144231.php lib/Migration/Version108Date20220823132408.php lib/Migration/Version113Date20221201044315.php

DoubleBastionAdmin authored on 01/12/2022 21:35:11
Showing 1 changed files
lib/Migration/Version108Date20220823132408.php
History View file @ 32dc2a9
1 1 
deleted file mode 100644
... ... 
@@ -1,290 +0,0 @@
1 
-<?php
2 
-/**
3 
- * @copyright 2021 Double Bastion LLC <www.doublebastion.com>
4 
- *
5 
- * @author Double Bastion LLC
6 
- *
7 
- * @license GNU AGPL version 3 or any later version
8 
- *
9 
- * This program is free software; you can redistribute it and/or
10 
- * modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE
11 
- * License as published by the Free Software Foundation; either
12 
- * version 3 of the License, or any later version.
13 
- *
14 
- * This program is distributed in the hope that it will be useful,
15 
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17 
- * GNU AFFERO GENERAL PUBLIC LICENSE for more details.
18 
- *
19 
- * You should have received a copy of the GNU Affero General Public
20 
- * License along with this program.  If not, see <http://www.gnu.org/licenses/>.
21 
- *
22 
- */
23 
-
24 
-declare(strict_types=1);
25 
-
26 
-namespace OCA\SMSRelentless\Migration;
27 
-
28 
-use Closure;
29 
-use OCP\DB\Types;
30 
-use Doctrine\DBAL\Types\Type;
31 
-use OCP\DB\ISchemaWrapper;
32 
-use OCP\Migration\IOutput;
33 
-use OCP\Migration\SimpleMigrationStep;
34 
-
35 
-
36 
-class Version108Date20220823132408 extends SimpleMigrationStep {
37 
-	/**
38 
-	 * @param IOutput $output
39 
-	 * @param \Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper`
40 
-	 * @param array $options
41 
-	 * @return null|ISchemaWrapper
42 
-	 */
43 
-	public function changeSchema(IOutput $output, \Closure $schemaClosure, array $options) {
44 
-		/** @var ISchemaWrapper $schema */
45 
-		$schema = $schemaClosure();
46 
-
47 
-		if (!$schema->hasTable('sms_relent_settings')) {
48 
-			$table = $schema->createTable('sms_relent_settings');
49 
-			$table->addColumn('id', 'bigint', [
50 
-				'autoincrement' => true,
51 
-				'notnull' => true,
52 
-                                'length' => 11,
53 
-                                'unsigned' => true,
54 
-			]);
55 
-			$table->addColumn('user_id', 'string', [
56 
-				'notnull' => true,
57 
-				'length' => 128,
58 
-			]);
59 
-			$table->addColumn('telapi_key', 'string', [
60 
-				'notnull' => true,
61 
-				'length' => 512,
62 
-			]);
63 
-			$table->addColumn('tel_pub_key', 'string', [
64 
-				'notnull' => true,
65 
-				'length' => 512,
66 
-			]);
67 
-			$table->addColumn('telapi_url_rec', 'string', [
68 
-				'notnull' => true,
69 
-				'length' => 512,
70 
-			]);
71 
-			$table->addColumn('telapi_url', 'string', [
72 
-				'notnull' => true,
73 
-				'length' => 512,
74 
-			]);
75 
-			$table->addColumn('messaging_profile_id', 'string', [
76 
-				'notnull' => true,
77 
-				'length' => 512,
78 
-			]);
79 
-			$table->addColumn('nexapi_key', 'string', [
80 
-				'notnull' => true,
81 
-				'length' => 512,
82 
-			]);
83 
-			$table->addColumn('nexapi_secret', 'string', [
84 
-				'notnull' => true,
85 
-				'length' => 512,
86 
-			]);
87 
-			$table->addColumn('nexapi_url_rec', 'string', [
88 
-				'notnull' => true,
89 
-				'length' => 512,
90 
-			]);
91 
-			$table->addColumn('nexapi_url', 'string', [
92 
-				'notnull' => true,
93 
-				'length' => 512,
94 
-			]);
95 
-			$table->addColumn('twilapi_key', 'string', [
96 
-				'notnull' => true,
97 
-				'length' => 512,
98 
-			]);
99 
-			$table->addColumn('twilapi_secret', 'string', [
100 
-				'notnull' => true,
101 
-				'length' => 512,
102 
-			]);
103 
-			$table->addColumn('twilapi_url_rec', 'string', [
104 
-				'notnull' => true,
105 
-				'length' => 512,
106 
-			]);
107 
-			$table->addColumn('twilapi_url', 'string', [
108 
-				'notnull' => true,
109 
-				'length' => 512,
110 
-			]);
111 
-			$table->addColumn('flowapi_key', 'string', [
112 
-				'notnull' => true,
113 
-				'length' => 512,
114 
-			]);
115 
-			$table->addColumn('flowapi_secret', 'string', [
116 
-				'notnull' => true,
117 
-				'length' => 512,
118 
-			]);
119 
-			$table->addColumn('flowapi_url_rec', 'string', [
120 
-				'notnull' => true,
121 
-				'length' => 512,
122 
-			]);
123 
-			$table->addColumn('flowapi_url', 'string', [
124 
-				'notnull' => true,
125 
-				'length' => 512,
126 
-			]);
127 
-			$table->addColumn('tel_sender_name', 'string', [
128 
-				'notnull' => false,
129 
-				'length' => 48,
130 
-				'default' => '',
131 
-			]);
132 
-			$table->addColumn('nex_sender_name', 'string', [
133 
-				'notnull' => false,
134 
-				'length' => 48,
135 
-				'default' => '',
136 
-			]);
137 
-			$table->addColumn('twil_sender_name', 'string', [
138 
-				'notnull' => false,
139 
-				'length' => 48,
140 
-				'default' => '',
141 
-			]);
142 
-			$table->addColumn('flow_sender_name', 'string', [
143 
-				'notnull' => false,
144 
-				'length' => 48,
145 
-				'default' => '',
146 
-			]);
147 
-			$table->addColumn('messagesperpage', 'integer', [
148 
-				'notnull' => false,
149 
-				'length' => 11,
150 
-                                'unsigned' => true,
151 
-			]);
152 
-			$table->addColumn('get_notify', 'smallint', [
153 
-				'notnull' => false,
154 
-				'length' => 1,
155 
-			]);
156 
-			$table->addColumn('notification_email', 'string', [
157 
-				'notnull' => false,
158 
-				'length' => 512,
159 
-				'default' => '',
160 
-			]);
161 
-			$table->addColumn('getsmsinemail', 'smallint', [
162 
-				'notnull' => false,
163 
-				'length' => 1,
164 
-			]);
165 
-                        $table->setPrimaryKey(['id']);
166 
-                        $table->addUniqueIndex(['id']);
167 
-
168 
-		} else {
169 
-
170 
-                        $table = $schema->getTable('sms_relent_settings');
171 
-
172 
-			$table->addColumn('flowapi_key', 'string', [
173 
-				'notnull' => true,
174 
-				'length' => 512,
175 
-			]);
176 
-			$table->addColumn('flowapi_secret', 'string', [
177 
-				'notnull' => true,
178 
-				'length' => 512,
179 
-			]);
180 
-			$table->addColumn('flowapi_url_rec', 'string', [
181 
-				'notnull' => true,
182 
-				'length' => 512,
183 
-			]);
184 
-			$table->addColumn('flowapi_url', 'string', [
185 
-				'notnull' => true,
186 
-				'length' => 512,
187 
-			]);
188 
-			$table->addColumn('flow_sender_name', 'string', [
189 
-				'notnull' => false,
190 
-				'length' => 48,
191 
-				'default' => '',
192 
-			]);
193 
-
194 
-                }
195 
-
196 
-		if (!$schema->hasTable('sms_relent_received')) {
197 
-			$table = $schema->createTable('sms_relent_received');
198 
-			$table->addColumn('id', 'bigint', [
199 
-				'autoincrement' => true,
200 
-				'notnull' => true,
201 
-                                'length' => 11,
202 
-                                'unsigned' => true,
203 
-			]);
204 
-			$table->addColumn('user_id', 'string', [
205 
-				'notnull' => true,
206 
-				'length' => 64,
207 
-			]);
208 
-			$table->addColumn('message_id', 'string', [
209 
-				'notnull' => true,
210 
-				'length' => 512,
211 
-			]);
212 
-			$table->addColumn('date', 'datetime', [
213 
-				'notnull' => true,
214 
-			]);
215 
-			$table->addColumn('from', 'string', [
216 
-				'notnull' => true,
217 
-				'length' => 128,
218 
-			]);
219 
-			$table->addColumn('to', 'string', [
220 
-				'notnull' => true,
221 
-				'length' => 128,
222 
-			]);
223 
-			$table->addColumn('message', 'text', [
224 
-				'notnull' => false,
225 
-				'default' => '',
226 
-			]);
227 
-                        $table->setPrimaryKey(['id']);
228 
-                        $table->addUniqueIndex(['id']);
229 
-
230 
-		}
231 
-
232 
-		if (!$schema->hasTable('sms_relent_sent')) {
233 
-			$table = $schema->createTable('sms_relent_sent');
234 
-			$table->addColumn('id', 'bigint', [
235 
-				'autoincrement' => true,
236 
-				'notnull' => true,
237 
-                                'length' => 11,
238 
-                                'unsigned' => true,
239 
-			]);
240 
-			$table->addColumn('user_id', 'string', [
241 
-				'notnull' => true,
242 
-				'length' => 64,
243 
-			]);
244 
-			$table->addColumn('message_id', 'string', [
245 
-				'notnull' => true,
246 
-				'length' => 512,
247 
-			]);
248 
-			$table->addColumn('date', 'datetime', [
249 
-				'notnull' => true,
250 
-			]);
251 
-			$table->addColumn('from', 'string', [
252 
-				'notnull' => true,
253 
-				'length' => 128,
254 
-			]);
255 
-			$table->addColumn('to', 'string', [
256 
-				'notnull' => true,
257 
-				'length' => 128,
258 
-			]);
259 
-			$table->addColumn('network ', 'string', [
260 
-				'notnull' => false,
261 
-				'length' => 64,
262 
-				'default' => '',
263 
-			]);
264 
-			$table->addColumn('price', 'string', [
265 
-				'notnull' => false,
266 
-				'length' => 64,
267 
-				'default' => '',
268 
-			]);
269 
-			$table->addColumn('status', 'string', [
270 
-				'notnull' => false,
271 
-				'length' => 512,
272 
-				'default' => '',
273 
-			]);
274 
-			$table->addColumn('deliveryreceipt', 'string', [
275 
-				'notnull' => false,
276 
-				'length' => 64,
277 
-				'default' => '',
278 
-			]);
279 
-			$table->addColumn('message', 'text', [
280 
-				'notnull' => false,
281 
-                                'default' => '',
282 
-			]);
283 
-                        $table->setPrimaryKey(['id']);
284 
-                        $table->addUniqueIndex(['id']);
285 
-
286 
-		}
287 
-
288 
-		return $schema;
289 
-	}
290 
-}
Browse code

added README.md CHANGELOG.txt appinfo/info.xml appinfo/signature.json js/settings.js lib/AppInfo/Application.php lib/Controller/SmsrelentlessController.php lib/Controller/AuthorApiController.php lib/Migration/Version108Date20220823132408.php providers/Twilio

DoubleBastionAdmin authored on 23/08/2022 10:48:04
Showing 1 changed files
lib/Migration/Version108Date20220823132408.php
History View file @ 2abb2f4
1 1 
new file mode 100644
... ... 
@@ -0,0 +1,290 @@
1 
+<?php
2 
+/**
3 
+ * @copyright 2021 Double Bastion LLC <www.doublebastion.com>
4 
+ *
5 
+ * @author Double Bastion LLC
6 
+ *
7 
+ * @license GNU AGPL version 3 or any later version
8 
+ *
9 
+ * This program is free software; you can redistribute it and/or
10 
+ * modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE
11 
+ * License as published by the Free Software Foundation; either
12 
+ * version 3 of the License, or any later version.
13 
+ *
14 
+ * This program is distributed in the hope that it will be useful,
15 
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17 
+ * GNU AFFERO GENERAL PUBLIC LICENSE for more details.
18 
+ *
19 
+ * You should have received a copy of the GNU Affero General Public
20 
+ * License along with this program.  If not, see <http://www.gnu.org/licenses/>.
21 
+ *
22 
+ */
23 
+
24 
+declare(strict_types=1);
25 
+
26 
+namespace OCA\SMSRelentless\Migration;
27 
+
28 
+use Closure;
29 
+use OCP\DB\Types;
30 
+use Doctrine\DBAL\Types\Type;
31 
+use OCP\DB\ISchemaWrapper;
32 
+use OCP\Migration\IOutput;
33 
+use OCP\Migration\SimpleMigrationStep;
34 
+
35 
+
36 
+class Version108Date20220823132408 extends SimpleMigrationStep {
37 
+	/**
38 
+	 * @param IOutput $output
39 
+	 * @param \Closure $schemaClosure The `\Closure` returns a `ISchemaWrapper`
40 
+	 * @param array $options
41 
+	 * @return null|ISchemaWrapper
42 
+	 */
43 
+	public function changeSchema(IOutput $output, \Closure $schemaClosure, array $options) {
44 
+		/** @var ISchemaWrapper $schema */
45 
+		$schema = $schemaClosure();
46 
+
47 
+		if (!$schema->hasTable('sms_relent_settings')) {
48 
+			$table = $schema->createTable('sms_relent_settings');
49 
+			$table->addColumn('id', 'bigint', [
50 
+				'autoincrement' => true,
51 
+				'notnull' => true,
52 
+                                'length' => 11,
53 
+                                'unsigned' => true,
54 
+			]);
55 
+			$table->addColumn('user_id', 'string', [
56 
+				'notnull' => true,
57 
+				'length' => 128,
58 
+			]);
59 
+			$table->addColumn('telapi_key', 'string', [
60 
+				'notnull' => true,
61 
+				'length' => 512,
62 
+			]);
63 
+			$table->addColumn('tel_pub_key', 'string', [
64 
+				'notnull' => true,
65 
+				'length' => 512,
66 
+			]);
67 
+			$table->addColumn('telapi_url_rec', 'string', [
68 
+				'notnull' => true,
69 
+				'length' => 512,
70 
+			]);
71 
+			$table->addColumn('telapi_url', 'string', [
72 
+				'notnull' => true,
73 
+				'length' => 512,
74 
+			]);
75 
+			$table->addColumn('messaging_profile_id', 'string', [
76 
+				'notnull' => true,
77 
+				'length' => 512,
78 
+			]);
79 
+			$table->addColumn('nexapi_key', 'string', [
80 
+				'notnull' => true,
81 
+				'length' => 512,
82 
+			]);
83 
+			$table->addColumn('nexapi_secret', 'string', [
84 
+				'notnull' => true,
85 
+				'length' => 512,
86 
+			]);
87 
+			$table->addColumn('nexapi_url_rec', 'string', [
88 
+				'notnull' => true,
89 
+				'length' => 512,
90 
+			]);
91 
+			$table->addColumn('nexapi_url', 'string', [
92 
+				'notnull' => true,
93 
+				'length' => 512,
94 
+			]);
95 
+			$table->addColumn('twilapi_key', 'string', [
96 
+				'notnull' => true,
97 
+				'length' => 512,
98 
+			]);
99 
+			$table->addColumn('twilapi_secret', 'string', [
100 
+				'notnull' => true,
101 
+				'length' => 512,
102 
+			]);
103 
+			$table->addColumn('twilapi_url_rec', 'string', [
104 
+				'notnull' => true,
105 
+				'length' => 512,
106 
+			]);
107 
+			$table->addColumn('twilapi_url', 'string', [
108 
+				'notnull' => true,
109 
+				'length' => 512,
110 
+			]);
111 
+			$table->addColumn('flowapi_key', 'string', [
112 
+				'notnull' => true,
113 
+				'length' => 512,
114 
+			]);
115 
+			$table->addColumn('flowapi_secret', 'string', [
116 
+				'notnull' => true,
117 
+				'length' => 512,
118 
+			]);
119 
+			$table->addColumn('flowapi_url_rec', 'string', [
120 
+				'notnull' => true,
121 
+				'length' => 512,
122 
+			]);
123 
+			$table->addColumn('flowapi_url', 'string', [
124 
+				'notnull' => true,
125 
+				'length' => 512,
126 
+			]);
127 
+			$table->addColumn('tel_sender_name', 'string', [
128 
+				'notnull' => false,
129 
+				'length' => 48,
130 
+				'default' => '',
131 
+			]);
132 
+			$table->addColumn('nex_sender_name', 'string', [
133 
+				'notnull' => false,
134 
+				'length' => 48,
135 
+				'default' => '',
136 
+			]);
137 
+			$table->addColumn('twil_sender_name', 'string', [
138 
+				'notnull' => false,
139 
+				'length' => 48,
140 
+				'default' => '',
141 
+			]);
142 
+			$table->addColumn('flow_sender_name', 'string', [
143 
+				'notnull' => false,
144 
+				'length' => 48,
145 
+				'default' => '',
146 
+			]);
147 
+			$table->addColumn('messagesperpage', 'integer', [
148 
+				'notnull' => false,
149 
+				'length' => 11,
150 
+                                'unsigned' => true,
151 
+			]);
152 
+			$table->addColumn('get_notify', 'smallint', [
153 
+				'notnull' => false,
154 
+				'length' => 1,
155 
+			]);
156 
+			$table->addColumn('notification_email', 'string', [
157 
+				'notnull' => false,
158 
+				'length' => 512,
159 
+				'default' => '',
160 
+			]);
161 
+			$table->addColumn('getsmsinemail', 'smallint', [
162 
+				'notnull' => false,
163 
+				'length' => 1,
164 
+			]);
165 
+                        $table->setPrimaryKey(['id']);
166 
+                        $table->addUniqueIndex(['id']);
167 
+
168 
+		} else {
169 
+
170 
+                        $table = $schema->getTable('sms_relent_settings');
171 
+
172 
+			$table->addColumn('flowapi_key', 'string', [
173 
+				'notnull' => true,
174 
+				'length' => 512,
175 
+			]);
176 
+			$table->addColumn('flowapi_secret', 'string', [
177 
+				'notnull' => true,
178 
+				'length' => 512,
179 
+			]);
180 
+			$table->addColumn('flowapi_url_rec', 'string', [
181 
+				'notnull' => true,
182 
+				'length' => 512,
183 
+			]);
184 
+			$table->addColumn('flowapi_url', 'string', [
185 
+				'notnull' => true,
186 
+				'length' => 512,
187 
+			]);
188 
+			$table->addColumn('flow_sender_name', 'string', [
189 
+				'notnull' => false,
190 
+				'length' => 48,
191 
+				'default' => '',
192 
+			]);
193 
+
194 
+                }
195 
+
196 
+		if (!$schema->hasTable('sms_relent_received')) {
197 
+			$table = $schema->createTable('sms_relent_received');
198 
+			$table->addColumn('id', 'bigint', [
199 
+				'autoincrement' => true,
200 
+				'notnull' => true,
201 
+                                'length' => 11,
202 
+                                'unsigned' => true,
203 
+			]);
204 
+			$table->addColumn('user_id', 'string', [
205 
+				'notnull' => true,
206 
+				'length' => 64,
207 
+			]);
208 
+			$table->addColumn('message_id', 'string', [
209 
+				'notnull' => true,
210 
+				'length' => 512,
211 
+			]);
212 
+			$table->addColumn('date', 'datetime', [
213 
+				'notnull' => true,
214 
+			]);
215 
+			$table->addColumn('from', 'string', [
216 
+				'notnull' => true,
217 
+				'length' => 128,
218 
+			]);
219 
+			$table->addColumn('to', 'string', [
220 
+				'notnull' => true,
221 
+				'length' => 128,
222 
+			]);
223 
+			$table->addColumn('message', 'text', [
224 
+				'notnull' => false,
225 
+				'default' => '',
226 
+			]);
227 
+                        $table->setPrimaryKey(['id']);
228 
+                        $table->addUniqueIndex(['id']);
229 
+
230 
+		}
231 
+
232 
+		if (!$schema->hasTable('sms_relent_sent')) {
233 
+			$table = $schema->createTable('sms_relent_sent');
234 
+			$table->addColumn('id', 'bigint', [
235 
+				'autoincrement' => true,
236 
+				'notnull' => true,
237 
+                                'length' => 11,
238 
+                                'unsigned' => true,
239 
+			]);
240 
+			$table->addColumn('user_id', 'string', [
241 
+				'notnull' => true,
242 
+				'length' => 64,
243 
+			]);
244 
+			$table->addColumn('message_id', 'string', [
245 
+				'notnull' => true,
246 
+				'length' => 512,
247 
+			]);
248 
+			$table->addColumn('date', 'datetime', [
249 
+				'notnull' => true,
250 
+			]);
251 
+			$table->addColumn('from', 'string', [
252 
+				'notnull' => true,
253 
+				'length' => 128,
254 
+			]);
255 
+			$table->addColumn('to', 'string', [
256 
+				'notnull' => true,
257 
+				'length' => 128,
258 
+			]);
259 
+			$table->addColumn('network ', 'string', [
260 
+				'notnull' => false,
261 
+				'length' => 64,
262 
+				'default' => '',
263 
+			]);
264 
+			$table->addColumn('price', 'string', [
265 
+				'notnull' => false,
266 
+				'length' => 64,
267 
+				'default' => '',
268 
+			]);
269 
+			$table->addColumn('status', 'string', [
270 
+				'notnull' => false,
271 
+				'length' => 512,
272 
+				'default' => '',
273 
+			]);
274 
+			$table->addColumn('deliveryreceipt', 'string', [
275 
+				'notnull' => false,
276 
+				'length' => 64,
277 
+				'default' => '',
278 
+			]);
279 
+			$table->addColumn('message', 'text', [
280 
+				'notnull' => false,
281 
+                                'default' => '',
282 
+			]);
283 
+                        $table->setPrimaryKey(['id']);
284 
+                        $table->addUniqueIndex(['id']);
285 
+
286 
+		}
287 
+
288 
+		return $schema;
289 
+	}
290 
+}