Ph5z8nEU

1Build started...
2Build succeeded.
3CREATE TABLE IF NOT EXISTS `__EFMigrationsHistory` (
4    `MigrationId` varchar(95) NOT NULL,
5    `ProductVersion` varchar(32) NOT NULL,
6    CONSTRAINT `PK___EFMigrationsHistory` PRIMARY KEY (`MigrationId`)
7);
8
9CREATE TABLE `AspNetRoles` (
10    `Id` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
11    `Name` varchar(256) CHARACTER SET utf8mb4 NULL,
12    `NormalizedName` varchar(256) CHARACTER SET utf8mb4 NULL,
13    `ConcurrencyStamp` longtext CHARACTER SET utf8mb4 NULL,
14    CONSTRAINT `PK_AspNetRoles` PRIMARY KEY (`Id`)
15);
16
17CREATE TABLE `AspNetUsers` (
18    `Id` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
19    `UserName` varchar(256) CHARACTER SET utf8mb4 NULL,
20    `NormalizedUserName` varchar(256) CHARACTER SET utf8mb4 NULL,
21    `Email` varchar(256) CHARACTER SET utf8mb4 NULL,
22    `NormalizedEmail` varchar(256) CHARACTER SET utf8mb4 NULL,
23    `EmailConfirmed` tinyint(1) NOT NULL,
24    `PasswordHash` longtext CHARACTER SET utf8mb4 NULL,
25    `SecurityStamp` longtext CHARACTER SET utf8mb4 NULL,
26    `ConcurrencyStamp` longtext CHARACTER SET utf8mb4 NULL,
27    `PhoneNumber` longtext CHARACTER SET utf8mb4 NULL,
28    `PhoneNumberConfirmed` tinyint(1) NOT NULL,
29    `TwoFactorEnabled` tinyint(1) NOT NULL,
30    `LockoutEnd` datetime(6) NULL,
31    `LockoutEnabled` tinyint(1) NOT NULL,
32    `AccessFailedCount` int NOT NULL,
33    `DropboxToken` longtext CHARACTER SET utf8mb4 NULL,
34    CONSTRAINT `PK_AspNetUsers` PRIMARY KEY (`Id`)
35);
36
37CREATE TABLE `AspNetRoleClaims` (
38    `Id` int NOT NULL,
39    `RoleId` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
40    `ClaimType` longtext CHARACTER SET utf8mb4 NULL,
41    `ClaimValue` longtext CHARACTER SET utf8mb4 NULL,
42    CONSTRAINT `PK_AspNetRoleClaims` PRIMARY KEY (`Id`),
43    CONSTRAINT `FK_AspNetRoleClaims_AspNetRoles_RoleId` FOREIGN KEY (`RoleId`) REFERENCES `AspNetRoles` (`Id`) ON DELETE CASCADE
44);
45
46CREATE TABLE `AspNetUserClaims` (
47    `Id` int NOT NULL,
48    `UserId` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
49    `ClaimType` longtext CHARACTER SET utf8mb4 NULL,
50    `ClaimValue` longtext CHARACTER SET utf8mb4 NULL,
51    CONSTRAINT `PK_AspNetUserClaims` PRIMARY KEY (`Id`),
52    CONSTRAINT `FK_AspNetUserClaims_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE CASCADE
53);
54
55CREATE TABLE `AspNetUserLogins` (
56    `LoginProvider` varchar(128) CHARACTER SET utf8mb4 NOT NULL,
57    `ProviderKey` varchar(128) CHARACTER SET utf8mb4 NOT NULL,
58    `ProviderDisplayName` longtext CHARACTER SET utf8mb4 NULL,
59    `UserId` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
60    CONSTRAINT `PK_AspNetUserLogins` PRIMARY KEY (`LoginProvider`, `ProviderKey`),
61    CONSTRAINT `FK_AspNetUserLogins_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE CASCADE
62);
63
64CREATE TABLE `AspNetUserRoles` (
65    `UserId` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
66    `RoleId` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
67    CONSTRAINT `PK_AspNetUserRoles` PRIMARY KEY (`UserId`, `RoleId`),
68    CONSTRAINT `FK_AspNetUserRoles_AspNetRoles_RoleId` FOREIGN KEY (`RoleId`) REFERENCES `AspNetRoles` (`Id`) ON DELETE CASCADE,
69    CONSTRAINT `FK_AspNetUserRoles_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE CASCADE
70);
71
72CREATE TABLE `AspNetUserTokens` (
73    `UserId` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
74    `LoginProvider` varchar(128) CHARACTER SET utf8mb4 NOT NULL,
75    `Name` varchar(128) CHARACTER SET utf8mb4 NOT NULL,
76    `Value` longtext CHARACTER SET utf8mb4 NULL,
77    CONSTRAINT `PK_AspNetUserTokens` PRIMARY KEY (`UserId`, `LoginProvider`, `Name`),
78    CONSTRAINT `FK_AspNetUserTokens_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE CASCADE
79);
80
81CREATE INDEX `IX_AspNetRoleClaims_RoleId` ON `AspNetRoleClaims` (`RoleId`);
82
83CREATE UNIQUE INDEX `RoleNameIndex` ON `AspNetRoles` (`NormalizedName`);
84
85CREATE INDEX `IX_AspNetUserClaims_UserId` ON `AspNetUserClaims` (`UserId`);
86
87CREATE INDEX `IX_AspNetUserLogins_UserId` ON `AspNetUserLogins` (`UserId`);
88
89CREATE INDEX `IX_AspNetUserRoles_RoleId` ON `AspNetUserRoles` (`RoleId`);
90
91CREATE INDEX `EmailIndex` ON `AspNetUsers` (`NormalizedEmail`);
92
93CREATE UNIQUE INDEX `UserNameIndex` ON `AspNetUsers` (`NormalizedUserName`);
94
95INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
96VALUES ('00000000000000_CreateIdentitySchema', '3.1.4');
97
98ALTER TABLE `AspNetUsers` ADD `ConnectState` varchar(32) CHARACTER SET utf8mb4 NULL;
99
100INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
101VALUES ('20180617173538_ConnectStateAdded', '3.1.4');
102
103ALTER TABLE `AspNetUsers` ADD `CreationDate` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000';
104
105ALTER TABLE `AspNetUsers` ADD `LastLogin` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000';
106
107CREATE TABLE `Devices` (
108    `ID` int NOT NULL,
109    `Name` longtext CHARACTER SET utf8mb4 NULL,
110    `SerialNumber` longtext CHARACTER SET utf8mb4 NULL,
111    `CreationDate` datetime(6) NOT NULL,
112    `UserId` varchar(255) CHARACTER SET utf8mb4 NULL,
113    CONSTRAINT `PK_Devices` PRIMARY KEY (`ID`),
114    CONSTRAINT `FK_Devices_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE RESTRICT
115);
116
117CREATE INDEX `IX_Devices_UserId` ON `Devices` (`UserId`);
118
119INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
120VALUES ('20180619230915_UserCreationDateAndDeviceModel', '3.1.4');
121
122ALTER TABLE `Devices` RENAME COLUMN `ID` TO `Id`;
123
124ALTER TABLE `Devices` MODIFY COLUMN `SerialNumber` varchar(255) CHARACTER SET utf8mb4 NOT NULL;
125
126ALTER TABLE `Devices` ADD `Apperture` longtext CHARACTER SET utf8mb4 NULL;
127
128ALTER TABLE `Devices` ADD `FocusMode` longtext CHARACTER SET utf8mb4 NULL;
129
130ALTER TABLE `Devices` ADD `ISO` longtext CHARACTER SET utf8mb4 NULL;
131
132CREATE UNIQUE INDEX `IX_Devices_SerialNumber` ON `Devices` (`SerialNumber`);
133
134INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
135VALUES ('20180630224507_DeviceSettingsAttributesAdded', '3.1.4');
136
137ALTER TABLE `Devices` ADD `DropboxConnectState` varchar(32) CHARACTER SET utf8mb4 NULL;
138
139ALTER TABLE `Devices` ADD `DropboxPassword` longtext CHARACTER SET utf8mb4 NULL;
140
141ALTER TABLE `Devices` ADD `DropboxToken` longtext CHARACTER SET utf8mb4 NULL;
142
143ALTER TABLE `Devices` ADD `DropboxUsername` longtext CHARACTER SET utf8mb4 NULL;
144
145INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
146VALUES ('20181008223649_DropboxCredentialsOnDevices', '3.1.4');
147
148ALTER TABLE `Devices` DROP COLUMN `DropboxPassword`;
149
150ALTER TABLE `Devices` DROP COLUMN `DropboxUsername`;
151
152INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
153VALUES ('20181010083715_DropboxUsernameAndPasswordRemovedFromDeviceModel', '3.1.4');
154
155CREATE TABLE `Positions` (
156    `Id` int NOT NULL,
157    `Latitude` double NOT NULL,
158    `Longitude` double NOT NULL,
159    `Altitude` double NOT NULL,
160    `Serial` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
161    `Timestamp` bigint NOT NULL,
162    CONSTRAINT `PK_Positions` PRIMARY KEY (`Id`),
163    CONSTRAINT `FK_Positions_Devices_Serial` FOREIGN KEY (`Serial`) REFERENCES `Devices` (`SerialNumber`) ON DELETE CASCADE
164);
165
166CREATE INDEX `IX_Positions_Serial` ON `Positions` (`Serial`);
167
168INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
169VALUES ('20190819153133_DronePosition', '3.1.4');
170
171CREATE TABLE `DroneBatteryLevels` (
172    `Id` int NOT NULL,
173    `BatteryLevelPercent` double NOT NULL,
174    `Serial` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
175    `Timestamp` bigint NOT NULL,
176    CONSTRAINT `PK_DroneBatteryLevels` PRIMARY KEY (`Id`),
177    CONSTRAINT `FK_DroneBatteryLevels_Devices_Serial` FOREIGN KEY (`Serial`) REFERENCES `Devices` (`SerialNumber`) ON DELETE CASCADE
178);
179
180CREATE INDEX `IX_DroneBatteryLevels_Serial` ON `DroneBatteryLevels` (`Serial`);
181
182INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
183VALUES ('20190819153134_DroneBatteryLevels', '3.1.4');
184
185CREATE TABLE `DroneRadioSignals` (
186    `Id` int NOT NULL,
187    `SignalQuality` float NULL,
188    `RSSI` float NULL,
189    `Serial` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
190    `Timestamp` bigint NOT NULL,
191    CONSTRAINT `PK_DroneRadioSignals` PRIMARY KEY (`Id`),
192    CONSTRAINT `FK_DroneRadioSignals_Devices_Serial` FOREIGN KEY (`Serial`) REFERENCES `Devices` (`SerialNumber`) ON DELETE CASCADE
193);
194
195CREATE INDEX `IX_DroneRadioSignals_Serial` ON `DroneRadioSignals` (`Serial`);
196
197INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
198VALUES ('20190819153135_DroneRadioSignals', '3.1.4');
199
200CREATE TABLE `DroneFlyingStates` (
201    `Id` int NOT NULL,
202    `State` int NOT NULL,
203    `Serial` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
204    `Timestamp` bigint NOT NULL,
205    CONSTRAINT `PK_DroneFlyingStates` PRIMARY KEY (`Id`),
206    CONSTRAINT `FK_DroneFlyingStates_Devices_Serial` FOREIGN KEY (`Serial`) REFERENCES `Devices` (`SerialNumber`) ON DELETE CASCADE
207);
208
209CREATE INDEX `IX_DroneFlyingStates_Serial` ON `DroneFlyingStates` (`Serial`);
210
211INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
212VALUES ('20190928153428_DroneFlyingStates', '3.1.4');
213
214ALTER TABLE `Devices` ADD `LiveVideoFMTProfile` longtext CHARACTER SET utf8mb4 NULL;
215
216ALTER TABLE `Devices` ADD `LiveVideoPt` int NOT NULL DEFAULT 0;
217
218ALTER TABLE `Devices` ADD `LiveVideoRTPMap` longtext CHARACTER SET utf8mb4 NULL;
219
220ALTER TABLE `Devices` ADD `LiveVideoRTPUrl` longtext CHARACTER SET utf8mb4 NULL;
221
222ALTER TABLE `Devices` ADD `LiveVideoSecret` longtext CHARACTER SET utf8mb4 NULL;
223
224INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
225VALUES ('20191014161816_DeviceLiveVideoData', '3.1.4');
226
227CREATE TABLE `Logs` (
228    `Id` int NOT NULL,
229    `Message` longtext CHARACTER SET utf8mb4 NOT NULL,
230    `Level` longtext CHARACTER SET utf8mb4 NOT NULL,
231    `Timestamp` datetime(6) NOT NULL,
232    `EventId` longtext CHARACTER SET utf8mb4 NULL,
233    `Exception` longtext CHARACTER SET utf8mb4 NULL,
234    `SourceContext` varchar(100) CHARACTER SET utf8mb4 NOT NULL,
235    CONSTRAINT `PK_Logs` PRIMARY KEY (`Id`)
236);
237
238INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
239VALUES ('20191023135129_LogEntry', '3.1.4');
240
241CREATE TABLE `DroneReplies` (
242    `Id` int NOT NULL,
243    `ActionName` longtext CHARACTER SET utf8mb4 NULL,
244    `Result` tinyint(1) NOT NULL,
245    `Serial` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
246    `Timestamp` bigint NOT NULL,
247    CONSTRAINT `PK_DroneReplies` PRIMARY KEY (`Id`),
248    CONSTRAINT `FK_DroneReplies_Devices_Serial` FOREIGN KEY (`Serial`) REFERENCES `Devices` (`SerialNumber`) ON DELETE CASCADE
249);
250
251CREATE TABLE `DroneVideoStatesResults` (
252    `Id` int NOT NULL,
253    `State` int NOT NULL,
254    `HumanMessage` longtext CHARACTER SET utf8mb4 NULL,
255    `RtpUrl` longtext CHARACTER SET utf8mb4 NULL,
256    `Serial` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
257    `Timestamp` bigint NOT NULL,
258    CONSTRAINT `PK_DroneVideoStatesResults` PRIMARY KEY (`Id`),
259    CONSTRAINT `FK_DroneVideoStatesResults_Devices_Serial` FOREIGN KEY (`Serial`) REFERENCES `Devices` (`SerialNumber`) ON DELETE CASCADE
260);
261
262CREATE INDEX `IX_DroneReplies_Serial` ON `DroneReplies` (`Serial`);
263
264CREATE INDEX `IX_DroneVideoStatesResults_Serial` ON `DroneVideoStatesResults` (`Serial`);
265
266INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
267VALUES ('20191127185742_DroneReplyAndDroneVideoStateResult', '3.1.4');
268
269ALTER TABLE `Positions` MODIFY COLUMN `Serial` varchar(256) CHARACTER SET utf8mb4 NOT NULL;
270
271ALTER TABLE `DroneVideoStatesResults` MODIFY COLUMN `Serial` varchar(256) CHARACTER SET utf8mb4 NOT NULL;
272
273ALTER TABLE `DroneReplies` MODIFY COLUMN `Serial` varchar(256) CHARACTER SET utf8mb4 NOT NULL;
274
275ALTER TABLE `DroneRadioSignals` MODIFY COLUMN `Serial` varchar(256) CHARACTER SET utf8mb4 NOT NULL;
276
277ALTER TABLE `DroneFlyingStates` MODIFY COLUMN `Serial` varchar(256) CHARACTER SET utf8mb4 NOT NULL;
278
279ALTER TABLE `DroneBatteryLevels` MODIFY COLUMN `Serial` varchar(256) CHARACTER SET utf8mb4 NOT NULL;
280
281ALTER TABLE `Devices` MODIFY COLUMN `SerialNumber` varchar(256) CHARACTER SET utf8mb4 NOT NULL;
282
283INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
284VALUES ('20191206194818_MySQLAlignment', '3.1.4');
285
286ALTER TABLE `Devices` DROP FOREIGN KEY `FK_Devices_AspNetUsers_UserId`;
287
288ALTER TABLE `Devices` DROP INDEX `IX_Devices_UserId`;
289
290ALTER TABLE `Devices` DROP COLUMN `UserId`;
291
292CREATE TABLE `UserDevices` (
293    `DeviceId` int NOT NULL,
294    `DroHubUserId` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
295    CONSTRAINT `PK_UserDevices` PRIMARY KEY (`DeviceId`, `DroHubUserId`),
296    CONSTRAINT `FK_UserDevices_Devices_DeviceId` FOREIGN KEY (`DeviceId`) REFERENCES `Devices` (`Id`) ON DELETE CASCADE,
297    CONSTRAINT `FK_UserDevices_AspNetUsers_DroHubUserId` FOREIGN KEY (`DroHubUserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE CASCADE
298);
299
300CREATE INDEX `IX_UserDevices_DroHubUserId` ON `UserDevices` (`DroHubUserId`);
301
302INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
303VALUES ('20191206200939_ManyUsersToManyDevices', '3.1.4');
304
305SET foreign_key_checks = 0
306
307ALTER TABLE `Devices` MODIFY COLUMN `Id` int NOT NULL AUTO_INCREMENT;
308
309ALTER TABLE Devices MODIFY COLUMN Id int auto_increment
310
311SET foreign_key_checks = 1
312
313INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
314VALUES ('20191207181551_MySQLIncrementingID', '3.1.4');
315
316ALTER TABLE `Devices` MODIFY COLUMN `Name` longtext CHARACTER SET utf8mb4 NOT NULL;
317
318INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
319VALUES ('20191213193554_DeviceNameMandatory', '3.1.4');
320
321SET foreign_key_checks = 0
322
323ALTER TABLE `Positions` MODIFY COLUMN `Id` int NOT NULL AUTO_INCREMENT;
324
325ALTER TABLE Positions MODIFY COLUMN Id int auto_increment
326
327ALTER TABLE `DroneVideoStatesResults` MODIFY COLUMN `Id` int NOT NULL AUTO_INCREMENT;
328
329ALTER TABLE DroneVideoStatesResults MODIFY COLUMN Id int auto_increment
330
331ALTER TABLE `DroneReplies` MODIFY COLUMN `Id` int NOT NULL AUTO_INCREMENT;
332
333ALTER TABLE DroneReplies MODIFY COLUMN Id int auto_increment
334
335ALTER TABLE `DroneRadioSignals` MODIFY COLUMN `Id` int NOT NULL AUTO_INCREMENT;
336
337ALTER TABLE DroneRadioSignals MODIFY COLUMN Id int auto_increment
338
339ALTER TABLE `DroneFlyingStates` MODIFY COLUMN `Id` int NOT NULL AUTO_INCREMENT;
340
341ALTER TABLE DroneFlyingStates MODIFY COLUMN Id int auto_increment
342
343ALTER TABLE `DroneBatteryLevels` MODIFY COLUMN `Id` int NOT NULL AUTO_INCREMENT;
344
345ALTER TABLE DroneBatteryLevels MODIFY COLUMN Id int auto_increment
346
347SET foreign_key_checks = 1
348
349INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
350VALUES ('20191213194222_MySQLIncrementingIDForRemainingTablesUps', '3.1.4');
351
352ALTER TABLE `DroneVideoStatesResults` DROP COLUMN `HumanMessage`;
353
354ALTER TABLE `DroneVideoStatesResults` DROP COLUMN `RtpUrl`;
355
356ALTER TABLE `Devices` DROP COLUMN `LiveVideoFMTProfile`;
357
358ALTER TABLE `Devices` DROP COLUMN `LiveVideoPt`;
359
360ALTER TABLE `Devices` DROP COLUMN `LiveVideoRTPMap`;
361
362ALTER TABLE `Devices` DROP COLUMN `LiveVideoRTPUrl`;
363
364INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
365VALUES ('20200210175433_LiveMigration', '3.1.4');
366
367SET foreign_key_checks = 0
368
369ALTER TABLE `AspNetUserClaims` MODIFY COLUMN `Id` int NOT NULL AUTO_INCREMENT;
370
371ALTER TABLE AspNetUserClaims MODIFY COLUMN Id int auto_increment
372
373SET foreign_key_checks = 1
374
375INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
376VALUES ('20200310175433_MySQLIncrementingIDForAspNetUserClaims', '3.1.4');
377
378ALTER TABLE `AspNetUsers` ADD `SubscriptionOrganizationName` varchar(255) CHARACTER SET utf8mb4 NULL;
379
380CREATE TABLE `Subscriptions` (
381    `OrganizationName` varchar(255) CHARACTER SET utf8mb4 NOT NULL,
382    `AllowedUserCount` int NOT NULL,
383    `AllowedFlightTime` time(6) NOT NULL,
384    CONSTRAINT `PK_Subscriptions` PRIMARY KEY (`OrganizationName`)
385);
386
387CREATE INDEX `IX_AspNetUsers_SubscriptionOrganizationName` ON `AspNetUsers` (`SubscriptionOrganizationName`);
388
389ALTER TABLE `AspNetUsers` ADD CONSTRAINT `FK_AspNetUsers_Subscriptions_SubscriptionOrganizationName` FOREIGN KEY (`SubscriptionOrganizationName`) REFERENCES `Subscriptions` (`OrganizationName`) ON DELETE RESTRICT;
390
391INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
392VALUES ('20200320190723_SubscriptionTable', '3.1.4');
393
394ALTER TABLE `AspNetUsers` ADD `BaseActingType` longtext CHARACTER SET utf8mb4 NULL;
395
396INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
397VALUES ('20200321175744_AddBaseActingTypeToDroHubUser', '3.1.4');
398
399ALTER TABLE `Devices` DROP COLUMN `DropboxConnectState`;
400
401ALTER TABLE `Devices` DROP COLUMN `DropboxToken`;
402
403INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
404VALUES ('20200322162317_RemoveDropboxData', '3.1.4');
405
406DROP TABLE `UserDevices`;
407
408ALTER TABLE `Devices` ADD `SubscriptionOrganizationName` varchar(255) CHARACTER SET utf8mb4 NULL;
409
410CREATE INDEX `IX_Devices_SubscriptionOrganizationName` ON `Devices` (`SubscriptionOrganizationName`);
411
412ALTER TABLE `Devices` ADD CONSTRAINT `FK_Devices_Subscriptions_SubscriptionOrganizationName` FOREIGN KEY (`SubscriptionOrganizationName`) REFERENCES `Subscriptions` (`OrganizationName`) ON DELETE RESTRICT;
413
414INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
415VALUES ('20200322162510_RemoveUserDeviceTable', '3.1.4');
416
417ALTER TABLE `Subscriptions` MODIFY COLUMN `AllowedFlightTime` bigint NOT NULL;
418
419INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
420VALUES ('20200418165223_SubscriptionTimeSpanTicksBigint', '3.1.4');
421
422ALTER TABLE `DroneBatteryLevels` DROP FOREIGN KEY `FK_DroneBatteryLevels_Devices_Serial`;
423
424ALTER TABLE `DroneFlyingStates` DROP FOREIGN KEY `FK_DroneFlyingStates_Devices_Serial`;
425
426ALTER TABLE `DroneRadioSignals` DROP FOREIGN KEY `FK_DroneRadioSignals_Devices_Serial`;
427
428ALTER TABLE `DroneReplies` DROP FOREIGN KEY `FK_DroneReplies_Devices_Serial`;
429
430ALTER TABLE `DroneVideoStatesResults` DROP FOREIGN KEY `FK_DroneVideoStatesResults_Devices_Serial`;
431
432ALTER TABLE `Positions` DROP FOREIGN KEY `FK_Positions_Devices_Serial`;
433
434ALTER TABLE `Devices` DROP KEY `AK_Devices_SerialNumber`;
435
436ALTER TABLE `Devices` DROP COLUMN `LiveVideoSecret`;
437
438ALTER TABLE `Positions` MODIFY COLUMN `Serial` varchar(255) CHARACTER SET utf8mb4 NULL;
439
440ALTER TABLE `Positions` ADD `ConnectionId` bigint NOT NULL DEFAULT 0;
441
442ALTER TABLE `DroneVideoStatesResults` MODIFY COLUMN `Serial` varchar(255) CHARACTER SET utf8mb4 NULL;
443
444ALTER TABLE `DroneVideoStatesResults` ADD `ConnectionId` bigint NOT NULL DEFAULT 0;
445
446ALTER TABLE `DroneReplies` MODIFY COLUMN `Serial` varchar(255) CHARACTER SET utf8mb4 NULL;
447
448ALTER TABLE `DroneReplies` ADD `ConnectionId` bigint NOT NULL DEFAULT 0;
449
450ALTER TABLE `DroneRadioSignals` MODIFY COLUMN `Serial` varchar(255) CHARACTER SET utf8mb4 NULL;
451
452ALTER TABLE `DroneRadioSignals` ADD `ConnectionId` bigint NOT NULL DEFAULT 0;
453
454ALTER TABLE `DroneFlyingStates` MODIFY COLUMN `Serial` varchar(255) CHARACTER SET utf8mb4 NULL;
455
456ALTER TABLE `DroneFlyingStates` ADD `ConnectionId` bigint NOT NULL DEFAULT 0;
457
458ALTER TABLE `DroneBatteryLevels` MODIFY COLUMN `Serial` varchar(255) CHARACTER SET utf8mb4 NULL;
459
460ALTER TABLE `DroneBatteryLevels` ADD `ConnectionId` bigint NOT NULL DEFAULT 0;
461
462CREATE TABLE `DeviceConnectionSessions` (
463    `Id` bigint NOT NULL AUTO_INCREMENT,
464    `StartTime` datetime(6) NOT NULL,
465    `EndTime` datetime(6) NOT NULL,
466    `DeviceId1` int NULL,
467    `LiveVideoSecret` longtext CHARACTER SET utf8mb4 NULL,
468    `SubscriptionOrganizationName` varchar(255) CHARACTER SET utf8mb4 NULL,
469    CONSTRAINT `PK_DeviceConnectionSessions` PRIMARY KEY (`Id`),
470    CONSTRAINT `FK_DeviceConnectionSessions_Devices_DeviceId1` FOREIGN KEY (`DeviceId1`) REFERENCES `Devices` (`Id`) ON DELETE RESTRICT,
471    CONSTRAINT `FK_DeviceConnectionSessions_Subscriptions_SubscriptionOrganizat~` FOREIGN KEY (`SubscriptionOrganizationName`) REFERENCES `Subscriptions` (`OrganizationName`) ON DELETE RESTRICT
472);
473
474CREATE INDEX `IX_Positions_ConnectionId` ON `Positions` (`ConnectionId`);
475
476CREATE INDEX `IX_DroneVideoStatesResults_ConnectionId` ON `DroneVideoStatesResults` (`ConnectionId`);
477
478CREATE INDEX `IX_DroneReplies_ConnectionId` ON `DroneReplies` (`ConnectionId`);
479
480CREATE INDEX `IX_DroneRadioSignals_ConnectionId` ON `DroneRadioSignals` (`ConnectionId`);
481
482CREATE INDEX `IX_DroneFlyingStates_ConnectionId` ON `DroneFlyingStates` (`ConnectionId`);
483
484CREATE INDEX `IX_DroneBatteryLevels_ConnectionId` ON `DroneBatteryLevels` (`ConnectionId`);
485
486CREATE INDEX `IX_DeviceConnectionSessions_DeviceId1` ON `DeviceConnectionSessions` (`DeviceId1`);
487
488CREATE INDEX `IX_DeviceConnectionSessions_SubscriptionOrganizationName` ON `DeviceConnectionSessions` (`SubscriptionOrganizationName`);
489
490ALTER TABLE `DroneBatteryLevels` ADD CONSTRAINT `FK_DroneBatteryLevels_DeviceConnectionSessions_ConnectionId` FOREIGN KEY (`ConnectionId`) REFERENCES `DeviceConnectionSessions` (`Id`) ON DELETE CASCADE;
491
492ALTER TABLE `DroneFlyingStates` ADD CONSTRAINT `FK_DroneFlyingStates_DeviceConnectionSessions_ConnectionId` FOREIGN KEY (`ConnectionId`) REFERENCES `DeviceConnectionSessions` (`Id`) ON DELETE CASCADE;
493
494ALTER TABLE `DroneRadioSignals` ADD CONSTRAINT `FK_DroneRadioSignals_DeviceConnectionSessions_ConnectionId` FOREIGN KEY (`ConnectionId`) REFERENCES `DeviceConnectionSessions` (`Id`) ON DELETE CASCADE;
495
496ALTER TABLE `DroneReplies` ADD CONSTRAINT `FK_DroneReplies_DeviceConnectionSessions_ConnectionId` FOREIGN KEY (`ConnectionId`) REFERENCES `DeviceConnectionSessions` (`Id`) ON DELETE CASCADE;
497
498ALTER TABLE `DroneVideoStatesResults` ADD CONSTRAINT `FK_DroneVideoStatesResults_DeviceConnectionSessions_ConnectionId` FOREIGN KEY (`ConnectionId`) REFERENCES `DeviceConnectionSessions` (`Id`) ON DELETE CASCADE;
499
500ALTER TABLE `Positions` ADD CONSTRAINT `FK_Positions_DeviceConnectionSessions_ConnectionId` FOREIGN KEY (`ConnectionId`) REFERENCES `DeviceConnectionSessions` (`Id`) ON DELETE CASCADE;
501
502INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
503VALUES ('20200528133715_DeviceConnections', '3.1.4');