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/Version100Date20211106192148.php
History View file @ ebb629d
1 1 
new file mode 100644
... ... 
@@ -0,0 +1,219 @@
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 Version100Date20211106192148 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 
+				'default' => '',
58 
+			]);
59 
+			$table->addColumn('telapi_key', Types::STRING, [
60 
+				'notnull' => true,
61 
+				'length' => 512,
62 
+			]);
63 
+			$table->addColumn('tel_pub_key', Types::STRING, [
64 
+				'notnull' => true,
65 
+				'length' => 512,
66 
+			]);
67 
+			$table->addColumn('telapi_url_rec', Types::STRING, [
68 
+				'notnull' => true,
69 
+				'length' => 512,
70 
+			]);
71 
+			$table->addColumn('telapi_url', Types::STRING, [
72 
+				'notnull' => true,
73 
+				'length' => 512,
74 
+			]);
75 
+			$table->addColumn('messaging_profile_id', Types::STRING, [
76 
+				'notnull' => true,
77 
+				'length' => 512,
78 
+			]);
79 
+			$table->addColumn('nexapi_key', Types::STRING, [
80 
+				'notnull' => true,
81 
+				'length' => 512,
82 
+			]);
83 
+			$table->addColumn('nexapi_secret', Types::STRING, [
84 
+				'notnull' => true,
85 
+				'length' => 512,
86 
+			]);
87 
+			$table->addColumn('nexapi_url_rec', Types::STRING, [
88 
+				'notnull' => true,
89 
+				'length' => 512,
90 
+			]);
91 
+			$table->addColumn('nexapi_url', Types::STRING, [
92 
+				'notnull' => true,
93 
+				'length' => 512,
94 
+			]);
95 
+			$table->addColumn('tel_sender_name', Types::STRING, [
96 
+				'notnull' => false,
97 
+				'length' => 48,
98 
+				'default' => '',
99 
+			]);
100 
+			$table->addColumn('nex_sender_name', Types::STRING, [
101 
+				'notnull' => false,
102 
+				'length' => 48,
103 
+				'default' => '',
104 
+			]);
105 
+			$table->addColumn('messagesperpage', Types::INTEGER, [
106 
+				'notnull' => false,
107 
+				'length' => 11,
108 
+                                'unsigned' => true,
109 
+			]);
110 
+			$table->addColumn('get_notify', Types::SMALLINT, [
111 
+				'notnull' => false,
112 
+				'length' => 1,
113 
+			]);
114 
+			$table->addColumn('notification_email', Types::STRING, [
115 
+				'notnull' => false,
116 
+				'length' => 512,
117 
+				'default' => '',
118 
+			]);
119 
+			$table->addColumn('getsmsinemail', Types::SMALLINT, [
120 
+				'notnull' => false,
121 
+				'length' => 1,
122 
+			]);
123 
+                        $table->setPrimaryKey(['id']);
124 
+                        $table->addUniqueIndex(['id']);
125 
+		}
126 
+
127 
+		if (!$schema->hasTable('sms_relent_received')) {
128 
+			$table = $schema->createTable('sms_relent_received');
129 
+			$table->addColumn('id', Types::BIGINT, [
130 
+				'autoincrement' => true,
131 
+				'notnull' => true,
132 
+                                'length' => 11,
133 
+                                'unsigned' => true,
134 
+			]);
135 
+			$table->addColumn('user_id', Types::STRING, [
136 
+				'notnull' => true,
137 
+				'length' => 64,
138 
+			]);
139 
+			$table->addColumn('message_id', Types::STRING, [
140 
+				'notnull' => true,
141 
+				'length' => 512,
142 
+			]);
143 
+			$table->addColumn('date', Types::DATETIME, [
144 
+				'notnull' => true,
145 
+			]);
146 
+			$table->addColumn('from', Types::STRING, [
147 
+				'notnull' => true,
148 
+				'length' => 128,
149 
+			]);
150 
+			$table->addColumn('to', Types::STRING, [
151 
+				'notnull' => true,
152 
+				'length' => 128,
153 
+			]);
154 
+			$table->addColumn('message', Types::TEXT, [
155 
+				'notnull' => false,
156 
+				'default' => '',
157 
+			]);
158 
+                        $table->setPrimaryKey(['id']);
159 
+                        $table->addUniqueIndex(['id']);
160 
+		}
161 
+
162 
+		if (!$schema->hasTable('sms_relent_sent')) {
163 
+			$table = $schema->createTable('sms_relent_sent');
164 
+			$table->addColumn('id', Types::BIGINT, [
165 
+				'autoincrement' => true,
166 
+				'notnull' => true,
167 
+                                'length' => 11,
168 
+                                'unsigned' => true,
169 
+			]);
170 
+			$table->addColumn('user_id', Types::STRING, [
171 
+				'notnull' => true,
172 
+				'length' => 64,
173 
+			]);
174 
+			$table->addColumn('message_id', Types::STRING, [
175 
+				'notnull' => true,
176 
+				'length' => 512,
177 
+			]);
178 
+			$table->addColumn('date', Types::DATETIME, [
179 
+				'notnull' => true,
180 
+			]);
181 
+			$table->addColumn('from', Types::STRING, [
182 
+				'notnull' => true,
183 
+				'length' => 128,
184 
+			]);
185 
+			$table->addColumn('to', Types::STRING, [
186 
+				'notnull' => true,
187 
+				'length' => 128,
188 
+			]);
189 
+			$table->addColumn('network ', Types::STRING, [
190 
+				'notnull' => false,
191 
+				'length' => 64,
192 
+				'default' => '',
193 
+			]);
194 
+			$table->addColumn('price', Types::STRING, [
195 
+				'notnull' => false,
196 
+				'length' => 64,
197 
+				'default' => '',
198 
+			]);
199 
+			$table->addColumn('status', Types::STRING, [
200 
+				'notnull' => false,
201 
+				'length' => 512,
202 
+				'default' => '',
203 
+			]);
204 
+			$table->addColumn('deliveryreceipt', Types::STRING, [
205 
+				'notnull' => false,
206 
+				'length' => 64,
207 
+				'default' => '',
208 
+			]);
209 
+			$table->addColumn('message', Types::TEXT, [
210 
+				'notnull' => false,
211 
+                                'default' => '',
212 
+			]);
213 
+                        $table->setPrimaryKey(['id']);
214 
+                        $table->addUniqueIndex(['id']);
215 
+		}
216 
+
217 
+		return $schema;
218 
+	}
219 
+}
0 220 
\ No newline at end of file
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/Version100Date20211106192148.php
History View file @ 32dc2a9
1 1 
deleted file mode 100644
... ... 
@@ -1,238 +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 OCP\DB\ISchemaWrapper;
31 
-use OCP\Migration\IOutput;
32 
-use OCP\Migration\SimpleMigrationStep;
33 
-
34 
-
35 
-class Version100Date20211106192148 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) {
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 
-				'default' => '',
58 
-			]);
59 
-			$table->addColumn('telapi_key', Types::STRING, [
60 
-				'notnull' => true,
61 
-				'length' => 1024,
62 
-				'default' => '',
63 
-			]);
64 
-			$table->addColumn('tel_pub_key', Types::STRING, [
65 
-				'notnull' => true,
66 
-				'length' => 1024,
67 
-				'default' => '',
68 
-			]);
69 
-			$table->addColumn('telapi_url_rec', Types::STRING, [
70 
-				'notnull' => true,
71 
-				'length' => 1024,
72 
-				'default' => '',
73 
-			]);
74 
-			$table->addColumn('telapi_url', Types::STRING, [
75 
-				'notnull' => true,
76 
-				'length' => 1024,
77 
-				'default' => '',
78 
-			]);
79 
-			$table->addColumn('messaging_profile_id', Types::STRING, [
80 
-				'notnull' => true,
81 
-				'length' => 1024,
82 
-				'default' => '',
83 
-			]);
84 
-			$table->addColumn('nexapi_key', Types::STRING, [
85 
-				'notnull' => true,
86 
-				'length' => 1024,
87 
-				'default' => '',
88 
-			]);
89 
-			$table->addColumn('nexapi_secret', Types::STRING, [
90 
-				'notnull' => true,
91 
-				'length' => 1024,
92 
-				'default' => '',
93 
-			]);
94 
-			$table->addColumn('nexapi_url_rec', Types::STRING, [
95 
-				'notnull' => true,
96 
-				'length' => 1024,
97 
-				'default' => '',
98 
-			]);
99 
-			$table->addColumn('nexapi_url', Types::STRING, [
100 
-				'notnull' => true,
101 
-				'length' => 1024,
102 
-				'default' => '',
103 
-			]);
104 
-			$table->addColumn('tel_sender_name', Types::STRING, [
105 
-				'notnull' => false,
106 
-				'length' => 1024,
107 
-				'default' => '',
108 
-			]);
109 
-			$table->addColumn('nex_sender_name', Types::STRING, [
110 
-				'notnull' => false,
111 
-				'length' => 1024,
112 
-				'default' => '',
113 
-			]);
114 
-			$table->addColumn('messagesperpage', Types::INTEGER, [
115 
-				'notnull' => false,
116 
-				'length' => 11,
117 
-                                'unsigned' => true,
118 
-			]);
119 
-			$table->addColumn('get_notify', Types::SMALLINT, [
120 
-				'notnull' => false,
121 
-				'length' => 1,
122 
-			]);
123 
-			$table->addColumn('notification_email', Types::STRING, [
124 
-				'notnull' => false,
125 
-				'length' => 1024,
126 
-				'default' => '',
127 
-			]);
128 
-			$table->addColumn('getsmsinemail', Types::SMALLINT, [
129 
-				'notnull' => false,
130 
-				'length' => 1,
131 
-			]);
132 
-                        $table->setPrimaryKey(['id']);
133 
-                        $table->addUniqueIndex(['id']);
134 
-		}
135 
-
136 
-		if (!$schema->hasTable('sms_relent_received')) {
137 
-			$table = $schema->createTable('sms_relent_received');
138 
-			$table->addColumn('id', Types::BIGINT, [
139 
-				'autoincrement' => true,
140 
-				'notnull' => true,
141 
-                                'length' => 11,
142 
-                                'unsigned' => true,
143 
-			]);
144 
-			$table->addColumn('user_id', Types::STRING, [
145 
-				'notnull' => true,
146 
-				'length' => 64,
147 
-				'default' => '',
148 
-			]);
149 
-			$table->addColumn('message_id', Types::STRING, [
150 
-				'notnull' => true,
151 
-				'length' => 1024,
152 
-				'default' => '',
153 
-			]);
154 
-			$table->addColumn('date', Types::DATETIME, [
155 
-				'notnull' => true,
156 
-			]);
157 
-			$table->addColumn('from', Types::STRING, [
158 
-				'notnull' => true,
159 
-				'length' => 128,
160 
-				'default' => '',
161 
-			]);
162 
-			$table->addColumn('to', Types::STRING, [
163 
-				'notnull' => true,
164 
-				'length' => 128,
165 
-				'default' => '',
166 
-			]);
167 
-			$table->addColumn('message', Types::STRING, [
168 
-				'notnull' => true,
169 
-				'length' => 8192,
170 
-				'default' => '',
171 
-			]);
172 
-                        $table->setPrimaryKey(['id']);
173 
-                        $table->addUniqueIndex(['id']);
174 
-		}
175 
-
176 
-		if (!$schema->hasTable('sms_relent_sent')) {
177 
-			$table = $schema->createTable('sms_relent_sent');
178 
-			$table->addColumn('id', Types::BIGINT, [
179 
-				'autoincrement' => true,
180 
-				'notnull' => true,
181 
-                                'length' => 11,
182 
-                                'unsigned' => true,
183 
-			]);
184 
-			$table->addColumn('user_id', Types::STRING, [
185 
-				'notnull' => true,
186 
-				'length' => 64,
187 
-				'default' => '',
188 
-			]);
189 
-			$table->addColumn('message_id', Types::STRING, [
190 
-				'notnull' => true,
191 
-				'length' => 1024,
192 
-				'default' => '',
193 
-			]);
194 
-			$table->addColumn('date', Types::DATETIME, [
195 
-				'notnull' => true,
196 
-			]);
197 
-			$table->addColumn('from', Types::STRING, [
198 
-				'notnull' => true,
199 
-				'length' => 128,
200 
-				'default' => '',
201 
-			]);
202 
-			$table->addColumn('to', Types::STRING, [
203 
-				'notnull' => true,
204 
-				'length' => 128,
205 
-				'default' => '',
206 
-			]);
207 
-			$table->addColumn('network ', Types::STRING, [
208 
-				'notnull' => false,
209 
-				'length' => 64,
210 
-				'default' => '',
211 
-			]);
212 
-			$table->addColumn('price', Types::STRING, [
213 
-				'notnull' => false,
214 
-				'length' => 64,
215 
-				'default' => '',
216 
-			]);
217 
-			$table->addColumn('status', Types::STRING, [
218 
-				'notnull' => false,
219 
-				'length' => 1024,
220 
-				'default' => '',
221 
-			]);
222 
-			$table->addColumn('deliveryreceipt', Types::STRING, [
223 
-				'notnull' => false,
224 
-				'length' => 64,
225 
-				'default' => '',
226 
-			]);
227 
-			$table->addColumn('message', Types::STRING, [
228 
-				'notnull' => true,
229 
-				'length' => 8192,
230 
-				'default' => '',
231 
-			]);
232 
-                        $table->setPrimaryKey(['id']);
233 
-                        $table->addUniqueIndex(['id']);
234 
-		}
235 
-
236 
-		return $schema;
237 
-	}
238 
-}
239 0 
\ No newline at end of file
Browse code

Created repository.

DoubleBastionAdmin authored on 01/03/2022 23:47:00
Showing 1 changed files
lib/Migration/Version100Date20211106192148.php
History View file @ a92694d
1 1 
new file mode 100644
... ... 
@@ -0,0 +1,238 @@
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 Version100Date20211106192148 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) {
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 
+				'default' => '',
58 
+			]);
59 
+			$table->addColumn('telapi_key', Types::STRING, [
60 
+				'notnull' => true,
61 
+				'length' => 1024,
62 
+				'default' => '',
63 
+			]);
64 
+			$table->addColumn('tel_pub_key', Types::STRING, [
65 
+				'notnull' => true,
66 
+				'length' => 1024,
67 
+				'default' => '',
68 
+			]);
69 
+			$table->addColumn('telapi_url_rec', Types::STRING, [
70 
+				'notnull' => true,
71 
+				'length' => 1024,
72 
+				'default' => '',
73 
+			]);
74 
+			$table->addColumn('telapi_url', Types::STRING, [
75 
+				'notnull' => true,
76 
+				'length' => 1024,
77 
+				'default' => '',
78 
+			]);
79 
+			$table->addColumn('messaging_profile_id', Types::STRING, [
80 
+				'notnull' => true,
81 
+				'length' => 1024,
82 
+				'default' => '',
83 
+			]);
84 
+			$table->addColumn('nexapi_key', Types::STRING, [
85 
+				'notnull' => true,
86 
+				'length' => 1024,
87 
+				'default' => '',
88 
+			]);
89 
+			$table->addColumn('nexapi_secret', Types::STRING, [
90 
+				'notnull' => true,
91 
+				'length' => 1024,
92 
+				'default' => '',
93 
+			]);
94 
+			$table->addColumn('nexapi_url_rec', Types::STRING, [
95 
+				'notnull' => true,
96 
+				'length' => 1024,
97 
+				'default' => '',
98 
+			]);
99 
+			$table->addColumn('nexapi_url', Types::STRING, [
100 
+				'notnull' => true,
101 
+				'length' => 1024,
102 
+				'default' => '',
103 
+			]);
104 
+			$table->addColumn('tel_sender_name', Types::STRING, [
105 
+				'notnull' => false,
106 
+				'length' => 1024,
107 
+				'default' => '',
108 
+			]);
109 
+			$table->addColumn('nex_sender_name', Types::STRING, [
110 
+				'notnull' => false,
111 
+				'length' => 1024,
112 
+				'default' => '',
113 
+			]);
114 
+			$table->addColumn('messagesperpage', Types::INTEGER, [
115 
+				'notnull' => false,
116 
+				'length' => 11,
117 
+                                'unsigned' => true,
118 
+			]);
119 
+			$table->addColumn('get_notify', Types::SMALLINT, [
120 
+				'notnull' => false,
121 
+				'length' => 1,
122 
+			]);
123 
+			$table->addColumn('notification_email', Types::STRING, [
124 
+				'notnull' => false,
125 
+				'length' => 1024,
126 
+				'default' => '',
127 
+			]);
128 
+			$table->addColumn('getsmsinemail', Types::SMALLINT, [
129 
+				'notnull' => false,
130 
+				'length' => 1,
131 
+			]);
132 
+                        $table->setPrimaryKey(['id']);
133 
+                        $table->addUniqueIndex(['id']);
134 
+		}
135 
+
136 
+		if (!$schema->hasTable('sms_relent_received')) {
137 
+			$table = $schema->createTable('sms_relent_received');
138 
+			$table->addColumn('id', Types::BIGINT, [
139 
+				'autoincrement' => true,
140 
+				'notnull' => true,
141 
+                                'length' => 11,
142 
+                                'unsigned' => true,
143 
+			]);
144 
+			$table->addColumn('user_id', Types::STRING, [
145 
+				'notnull' => true,
146 
+				'length' => 64,
147 
+				'default' => '',
148 
+			]);
149 
+			$table->addColumn('message_id', Types::STRING, [
150 
+				'notnull' => true,
151 
+				'length' => 1024,
152 
+				'default' => '',
153 
+			]);
154 
+			$table->addColumn('date', Types::DATETIME, [
155 
+				'notnull' => true,
156 
+			]);
157 
+			$table->addColumn('from', Types::STRING, [
158 
+				'notnull' => true,
159 
+				'length' => 128,
160 
+				'default' => '',
161 
+			]);
162 
+			$table->addColumn('to', Types::STRING, [
163 
+				'notnull' => true,
164 
+				'length' => 128,
165 
+				'default' => '',
166 
+			]);
167 
+			$table->addColumn('message', Types::STRING, [
168 
+				'notnull' => true,
169 
+				'length' => 8192,
170 
+				'default' => '',
171 
+			]);
172 
+                        $table->setPrimaryKey(['id']);
173 
+                        $table->addUniqueIndex(['id']);
174 
+		}
175 
+
176 
+		if (!$schema->hasTable('sms_relent_sent')) {
177 
+			$table = $schema->createTable('sms_relent_sent');
178 
+			$table->addColumn('id', Types::BIGINT, [
179 
+				'autoincrement' => true,
180 
+				'notnull' => true,
181 
+                                'length' => 11,
182 
+                                'unsigned' => true,
183 
+			]);
184 
+			$table->addColumn('user_id', Types::STRING, [
185 
+				'notnull' => true,
186 
+				'length' => 64,
187 
+				'default' => '',
188 
+			]);
189 
+			$table->addColumn('message_id', Types::STRING, [
190 
+				'notnull' => true,
191 
+				'length' => 1024,
192 
+				'default' => '',
193 
+			]);
194 
+			$table->addColumn('date', Types::DATETIME, [
195 
+				'notnull' => true,
196 
+			]);
197 
+			$table->addColumn('from', Types::STRING, [
198 
+				'notnull' => true,
199 
+				'length' => 128,
200 
+				'default' => '',
201 
+			]);
202 
+			$table->addColumn('to', Types::STRING, [
203 
+				'notnull' => true,
204 
+				'length' => 128,
205 
+				'default' => '',
206 
+			]);
207 
+			$table->addColumn('network ', Types::STRING, [
208 
+				'notnull' => false,
209 
+				'length' => 64,
210 
+				'default' => '',
211 
+			]);
212 
+			$table->addColumn('price', Types::STRING, [
213 
+				'notnull' => false,
214 
+				'length' => 64,
215 
+				'default' => '',
216 
+			]);
217 
+			$table->addColumn('status', Types::STRING, [
218 
+				'notnull' => false,
219 
+				'length' => 1024,
220 
+				'default' => '',
221 
+			]);
222 
+			$table->addColumn('deliveryreceipt', Types::STRING, [
223 
+				'notnull' => false,
224 
+				'length' => 64,
225 
+				'default' => '',
226 
+			]);
227 
+			$table->addColumn('message', Types::STRING, [
228 
+				'notnull' => true,
229 
+				'length' => 8192,
230 
+				'default' => '',
231 
+			]);
232 
+                        $table->setPrimaryKey(['id']);
233 
+                        $table->addUniqueIndex(['id']);
234 
+		}
235 
+
236 
+		return $schema;
237 
+	}
238 
+}
0 239 
\ No newline at end of file