Differential D18781 Diff 51045 autotests/server/dbtest_data/dbinit_sqlite_incremental

Changeset View

Standalone View

View Options

autotests/server/dbtest_data/dbinit_sqlite_incremental

Show First 20 Lines • Show All 152 Lines • ▼ Show 20 Line(s)
153ALTER TABLE CollectionMimeTypeRelation ADD COLUMN Collection_id BIGINT NOT NULL 153​ALTER TABLE CollectionMimeTypeRelation ADD COLUMN Collection_id BIGINT NOT NULL
154 154​
155ALTER TABLE CollectionMimeTypeRelation ADD COLUMN MimeType_id BIGINT NOT NULL 155​ALTER TABLE CollectionMimeTypeRelation ADD COLUMN MimeType_id BIGINT NOT NULL
156 156​
157ALTER TABLE CollectionPimItemRelation ADD COLUMN Collection_id BIGINT NOT NULL 157​ALTER TABLE CollectionPimItemRelation ADD COLUMN Collection_id BIGINT NOT NULL
158 158​
159ALTER TABLE CollectionPimItemRelation ADD COLUMN PimItem_id BIGINT NOT NULL 159​ALTER TABLE CollectionPimItemRelation ADD COLUMN PimItem_id BIGINT NOT NULL
160 160​
161PRAGMA foreign_key_check=OFF 161​PRAGMA defer_foreign_keys=ON
162 162​
163BEGIN TRANSACTION 163​BEGIN TRANSACTION
164 164​
165ALTER TABLE PimItemTable RENAME TO PimItemTable_old 165​ALTER TABLE PimItemTable RENAME TO PimItemTable_old
166 166​
167CREATE TABLE PimItemTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 167​CREATE TABLE PimItemTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
168 rev INTEGER NOT NULL DEFAULT 0, 168​ rev INTEGER NOT NULL DEFAULT 0,
169 remoteId TEXT, 169​ remoteId TEXT,
Show All 9 Lines
179 CONSTRAINT PimItemTablemimeTypeId_MimeTypeid_fk FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED) 179​ CONSTRAINT PimItemTablemimeTypeId_MimeTypeid_fk FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED)
180 180​
181INSERT INTO PimItemTable SELECT * FROM PimItemTable_old 181​INSERT INTO PimItemTable SELECT * FROM PimItemTable_old
182 182​
183DROP TABLE PimItemTable_old 183​DROP TABLE PimItemTable_old
184 184​
185COMMIT 185​COMMIT
186 186​
187PRAGMA foreign_key_check=ON 187​PRAGMA defer_foreign_keys=OFF
188 188​
189PRAGMA foreign_key_check=OFF 189​PRAGMA defer_foreign_keys=ON
190 190​
191BEGIN TRANSACTION 191​BEGIN TRANSACTION
192 192​
193ALTER TABLE CollectionAttributeTable RENAME TO CollectionAttributeTable_old 193​ALTER TABLE CollectionAttributeTable RENAME TO CollectionAttributeTable_old
194 194​
195CREATE TABLE CollectionAttributeTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 195​CREATE TABLE CollectionAttributeTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
196 collectionId BIGINT NOT NULL, 196​ collectionId BIGINT NOT NULL,
197 type LONGBLOB NOT NULL, 197​ type LONGBLOB NOT NULL,
198 value LONGBLOB, 198​ value LONGBLOB,
199 CONSTRAINT CollectionAttributeTablecollectionId_Collectionid_fk FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 199​ CONSTRAINT CollectionAttributeTablecollectionId_Collectionid_fk FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
200 200​
201INSERT INTO CollectionAttributeTable SELECT * FROM CollectionAttributeTable_old 201​INSERT INTO CollectionAttributeTable SELECT * FROM CollectionAttributeTable_old
202 202​
203DROP TABLE CollectionAttributeTable_old 203​DROP TABLE CollectionAttributeTable_old
204 204​
205COMMIT 205​COMMIT
206 206​
207PRAGMA foreign_key_check=ON 207​PRAGMA defer_foreign_keys=OFF
208 208​
209PRAGMA foreign_key_check=OFF 209​PRAGMA defer_foreign_keys=ON
210 210​
211BEGIN TRANSACTION 211​BEGIN TRANSACTION
212 212​
213ALTER TABLE CollectionTable RENAME TO CollectionTable_old 213​ALTER TABLE CollectionTable RENAME TO CollectionTable_old
214 214​
215CREATE TABLE CollectionTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 215​CREATE TABLE CollectionTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
216 remoteId TEXT, 216​ remoteId TEXT,
217 remoteRevision TEXT, 217​ remoteRevision TEXT,
Show All 18 Lines
236 CONSTRAINT CollectionTableresourceId_Resourceid_fk FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 236​ CONSTRAINT CollectionTableresourceId_Resourceid_fk FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
237 237​
238INSERT INTO CollectionTable SELECT * FROM CollectionTable_old 238​INSERT INTO CollectionTable SELECT * FROM CollectionTable_old
239 239​
240DROP TABLE CollectionTable_old 240​DROP TABLE CollectionTable_old
241 241​
242COMMIT 242​COMMIT
243 243​
244PRAGMA foreign_key_check=ON 244​PRAGMA defer_foreign_keys=OFF
245 245​
246PRAGMA foreign_key_check=OFF 246​PRAGMA defer_foreign_keys=ON
247 247​
248BEGIN TRANSACTION 248​BEGIN TRANSACTION
249 249​
250ALTER TABLE CollectionTable RENAME TO CollectionTable_old 250​ALTER TABLE CollectionTable RENAME TO CollectionTable_old
251 251​
252CREATE TABLE CollectionTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 252​CREATE TABLE CollectionTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
253 remoteId TEXT, 253​ remoteId TEXT,
254 remoteRevision TEXT, 254​ remoteRevision TEXT,
Show All 18 Lines
273 CONSTRAINT CollectionTableresourceId_Resourceid_fk FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 273​ CONSTRAINT CollectionTableresourceId_Resourceid_fk FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
274 274​
275INSERT INTO CollectionTable SELECT * FROM CollectionTable_old 275​INSERT INTO CollectionTable SELECT * FROM CollectionTable_old
276 276​
277DROP TABLE CollectionTable_old 277​DROP TABLE CollectionTable_old
278 278​
279COMMIT 279​COMMIT
280 280​
281PRAGMA foreign_key_check=ON 281​PRAGMA defer_foreign_keys=OFF
282 282​
283PRAGMA foreign_key_check=OFF 283​PRAGMA defer_foreign_keys=ON
284 284​
285BEGIN TRANSACTION 285​BEGIN TRANSACTION
286 286​
287ALTER TABLE PimItemTable RENAME TO PimItemTable_old 287​ALTER TABLE PimItemTable RENAME TO PimItemTable_old
288 288​
289CREATE TABLE PimItemTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 289​CREATE TABLE PimItemTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
290 rev INTEGER NOT NULL DEFAULT 0, 290​ rev INTEGER NOT NULL DEFAULT 0,
291 remoteId TEXT, 291​ remoteId TEXT,
Show All 9 Lines
301 CONSTRAINT PimItemTablemimeTypeId_MimeTypeid_fk FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED) 301​ CONSTRAINT PimItemTablemimeTypeId_MimeTypeid_fk FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED)
302 302​
303INSERT INTO PimItemTable SELECT * FROM PimItemTable_old 303​INSERT INTO PimItemTable SELECT * FROM PimItemTable_old
304 304​
305DROP TABLE PimItemTable_old 305​DROP TABLE PimItemTable_old
306 306​
307COMMIT 307​COMMIT
308 308​
309PRAGMA foreign_key_check=ON 309​PRAGMA defer_foreign_keys=OFF
310 310​
311PRAGMA foreign_key_check=OFF 311​PRAGMA defer_foreign_keys=ON
312 312​
313BEGIN TRANSACTION 313​BEGIN TRANSACTION
314 314​
315ALTER TABLE PimItemTable RENAME TO PimItemTable_old 315​ALTER TABLE PimItemTable RENAME TO PimItemTable_old
316 316​
317CREATE TABLE PimItemTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 317​CREATE TABLE PimItemTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
318 rev INTEGER NOT NULL DEFAULT 0, 318​ rev INTEGER NOT NULL DEFAULT 0,
319 remoteId TEXT, 319​ remoteId TEXT,
Show All 9 Lines
329 CONSTRAINT PimItemTablemimeTypeId_MimeTypeid_fk FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED) 329​ CONSTRAINT PimItemTablemimeTypeId_MimeTypeid_fk FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED)
330 330​
331INSERT INTO PimItemTable SELECT * FROM PimItemTable_old 331​INSERT INTO PimItemTable SELECT * FROM PimItemTable_old
332 332​
333DROP TABLE PimItemTable_old 333​DROP TABLE PimItemTable_old
334 334​
335COMMIT 335​COMMIT
336 336​
337PRAGMA foreign_key_check=ON 337​PRAGMA defer_foreign_keys=OFF
338 338​
339PRAGMA foreign_key_check=OFF 339​PRAGMA defer_foreign_keys=ON
340 340​
341BEGIN TRANSACTION 341​BEGIN TRANSACTION
342 342​
343ALTER TABLE PartTable RENAME TO PartTable_old 343​ALTER TABLE PartTable RENAME TO PartTable_old
344 344​
345CREATE TABLE PartTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 345​CREATE TABLE PartTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
346 pimItemId BIGINT NOT NULL, 346​ pimItemId BIGINT NOT NULL,
347 partTypeId BIGINT NOT NULL, 347​ partTypeId BIGINT NOT NULL,
348 data LONGBLOB, 348​ data LONGBLOB,
349 datasize BIGINT NOT NULL, 349​ datasize BIGINT NOT NULL,
350 version INTEGER DEFAULT 0, 350​ version INTEGER DEFAULT 0,
351 storage TINYINT DEFAULT 0, 351​ storage TINYINT DEFAULT 0,
352 CONSTRAINT PartTablepimItemId_PimItemid_fk FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 352​ CONSTRAINT PartTablepimItemId_PimItemid_fk FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
353 CONSTRAINT PartTablepartTypeId_PartTypeid_fk FOREIGN KEY (partTypeId) REFERENCES PartTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 353​ CONSTRAINT PartTablepartTypeId_PartTypeid_fk FOREIGN KEY (partTypeId) REFERENCES PartTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
354 354​
355 355​
356INSERT INTO PartTable SELECT * FROM PartTable_old 356​INSERT INTO PartTable SELECT * FROM PartTable_old
357 357​
358DROP TABLE PartTable_old 358​DROP TABLE PartTable_old
359 359​
360COMMIT 360​COMMIT
361 361​
362PRAGMA foreign_key_check=ON 362​PRAGMA defer_foreign_keys=OFF
363 363​
364PRAGMA foreign_key_check=OFF 364​PRAGMA defer_foreign_keys=ON
365 365​
366BEGIN TRANSACTION 366​BEGIN TRANSACTION
367 367​
368ALTER TABLE PartTable RENAME TO PartTable_old 368​ALTER TABLE PartTable RENAME TO PartTable_old
369 369​
370CREATE TABLE PartTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 370​CREATE TABLE PartTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
371 pimItemId BIGINT NOT NULL, 371​ pimItemId BIGINT NOT NULL,
372 partTypeId BIGINT NOT NULL, 372​ partTypeId BIGINT NOT NULL,
373 data LONGBLOB, 373​ data LONGBLOB,
374 datasize BIGINT NOT NULL, 374​ datasize BIGINT NOT NULL,
375 version INTEGER DEFAULT 0, 375​ version INTEGER DEFAULT 0,
376 storage TINYINT DEFAULT 0, 376​ storage TINYINT DEFAULT 0,
377 CONSTRAINT PartTablepimItemId_PimItemid_fk FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 377​ CONSTRAINT PartTablepimItemId_PimItemid_fk FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
378 CONSTRAINT PartTablepartTypeId_PartTypeid_fk FOREIGN KEY (partTypeId) REFERENCES PartTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 378​ CONSTRAINT PartTablepartTypeId_PartTypeid_fk FOREIGN KEY (partTypeId) REFERENCES PartTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
379 379​
380 380​
381INSERT INTO PartTable SELECT * FROM PartTable_old 381​INSERT INTO PartTable SELECT * FROM PartTable_old
382 382​
383DROP TABLE PartTable_old 383​DROP TABLE PartTable_old
384 384​
385COMMIT 385​COMMIT
386 386​
387PRAGMA foreign_key_check=ON 387​PRAGMA defer_foreign_keys=OFF
388 388​
389PRAGMA foreign_key_check=OFF 389​PRAGMA defer_foreign_keys=ON
390 390​
391BEGIN TRANSACTION 391​BEGIN TRANSACTION
392 392​
393ALTER TABLE CollectionAttributeTable RENAME TO CollectionAttributeTable_old 393​ALTER TABLE CollectionAttributeTable RENAME TO CollectionAttributeTable_old
394 394​
395CREATE TABLE CollectionAttributeTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 395​CREATE TABLE CollectionAttributeTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
396 collectionId BIGINT NOT NULL, 396​ collectionId BIGINT NOT NULL,
397 type LONGBLOB NOT NULL, 397​ type LONGBLOB NOT NULL,
398 value LONGBLOB, 398​ value LONGBLOB,
399 CONSTRAINT CollectionAttributeTablecollectionId_Collectionid_fk FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 399​ CONSTRAINT CollectionAttributeTablecollectionId_Collectionid_fk FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
400 400​
401INSERT INTO CollectionAttributeTable SELECT * FROM CollectionAttributeTable_old 401​INSERT INTO CollectionAttributeTable SELECT * FROM CollectionAttributeTable_old
402 402​
403DROP TABLE CollectionAttributeTable_old 403​DROP TABLE CollectionAttributeTable_old
404 404​
405COMMIT 405​COMMIT
406 406​
407PRAGMA foreign_key_check=ON 407​PRAGMA defer_foreign_keys=OFF
408 408​
409PRAGMA foreign_key_check=OFF 409​PRAGMA defer_foreign_keys=ON
410 410​
411BEGIN TRANSACTION 411​BEGIN TRANSACTION
412 412​
413ALTER TABLE TagTable RENAME TO TagTable_old 413​ALTER TABLE TagTable RENAME TO TagTable_old
414 414​
415CREATE TABLE TagTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 415​CREATE TABLE TagTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
416 gid TEXT NOT NULL, 416​ gid TEXT NOT NULL,
417 parentId BIGINT, 417​ parentId BIGINT,
418 typeId BIGINT DEFAULT 1, 418​ typeId BIGINT DEFAULT 1,
419 CONSTRAINT TagTableparentId_Tagid_fk FOREIGN KEY (parentId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 419​ CONSTRAINT TagTableparentId_Tagid_fk FOREIGN KEY (parentId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
420 CONSTRAINT TagTabletypeId_TagTypeid_fk FOREIGN KEY (typeId) REFERENCES TagTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED) 420​ CONSTRAINT TagTabletypeId_TagTypeid_fk FOREIGN KEY (typeId) REFERENCES TagTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED)
421 421​
422INSERT INTO TagTable SELECT * FROM TagTable_old 422​INSERT INTO TagTable SELECT * FROM TagTable_old
423 423​
424DROP TABLE TagTable_old 424​DROP TABLE TagTable_old
425 425​
426COMMIT 426​COMMIT
427 427​
428PRAGMA foreign_key_check=ON 428​PRAGMA defer_foreign_keys=OFF
429 429​
430PRAGMA foreign_key_check=OFF 430​PRAGMA defer_foreign_keys=ON
431 431​
432BEGIN TRANSACTION 432​BEGIN TRANSACTION
433 433​
434ALTER TABLE TagTable RENAME TO TagTable_old 434​ALTER TABLE TagTable RENAME TO TagTable_old
435 435​
436CREATE TABLE TagTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 436​CREATE TABLE TagTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
437 gid TEXT NOT NULL, 437​ gid TEXT NOT NULL,
438 parentId BIGINT, 438​ parentId BIGINT,
439 typeId BIGINT DEFAULT 1, 439​ typeId BIGINT DEFAULT 1,
440 CONSTRAINT TagTableparentId_Tagid_fk FOREIGN KEY (parentId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 440​ CONSTRAINT TagTableparentId_Tagid_fk FOREIGN KEY (parentId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
441 CONSTRAINT TagTabletypeId_TagTypeid_fk FOREIGN KEY (typeId) REFERENCES TagTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED) 441​ CONSTRAINT TagTabletypeId_TagTypeid_fk FOREIGN KEY (typeId) REFERENCES TagTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED)
442 442​
443INSERT INTO TagTable SELECT * FROM TagTable_old 443​INSERT INTO TagTable SELECT * FROM TagTable_old
444 444​
445DROP TABLE TagTable_old 445​DROP TABLE TagTable_old
446 446​
447COMMIT 447​COMMIT
448 448​
449PRAGMA foreign_key_check=ON 449​PRAGMA defer_foreign_keys=OFF
450 450​
451PRAGMA foreign_key_check=OFF 451​PRAGMA defer_foreign_keys=ON
452 452​
453BEGIN TRANSACTION 453​BEGIN TRANSACTION
454 454​
455ALTER TABLE TagAttributeTable RENAME TO TagAttributeTable_old 455​ALTER TABLE TagAttributeTable RENAME TO TagAttributeTable_old
456 456​
457 457​
458CREATE TABLE TagAttributeTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 458​CREATE TABLE TagAttributeTable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
459 tagId BIGINT NOT NULL, 459​ tagId BIGINT NOT NULL,
460 type LONGBLOB NOT NULL, 460​ type LONGBLOB NOT NULL,
461 value LONGBLOB, 461​ value LONGBLOB,
462 CONSTRAINT TagAttributeTabletagId_Tagid_fk FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 462​ CONSTRAINT TagAttributeTabletagId_Tagid_fk FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
463 463​
464INSERT INTO TagAttributeTable SELECT * FROM TagAttributeTable_old 464​INSERT INTO TagAttributeTable SELECT * FROM TagAttributeTable_old
465 465​
466DROP TABLE TagAttributeTable_old 466​DROP TABLE TagAttributeTable_old
467 467​
468COMMIT 468​COMMIT
469 469​
470PRAGMA foreign_key_check=ON 470​PRAGMA defer_foreign_keys=OFF
471 471​
472PRAGMA foreign_key_check=OFF 472​PRAGMA defer_foreign_keys=ON
473 473​
474BEGIN TRANSACTION 474​BEGIN TRANSACTION
475 475​
476ALTER TABLE TagRemoteIdResourceRelationTable RENAME TO TagRemoteIdResourceRelationTable_old 476​ALTER TABLE TagRemoteIdResourceRelationTable RENAME TO TagRemoteIdResourceRelationTable_old
477 477​
478CREATE TABLE TagRemoteIdResourceRelationTable (tagId BIGINT NOT NULL, 478​CREATE TABLE TagRemoteIdResourceRelationTable (tagId BIGINT NOT NULL,
479 resourceId BIGINT NOT NULL, 479​ resourceId BIGINT NOT NULL,
480 remoteId TEXT NOT NULL, 480​ remoteId TEXT NOT NULL,
481 CONSTRAINT TagRemoteIdResourceRelationTabletagId_Tagid_fk FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 481​ CONSTRAINT TagRemoteIdResourceRelationTabletagId_Tagid_fk FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
482 CONSTRAINT TagRemoteIdResourceRelationTableresourceId_Resourceid_fk FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 482​ CONSTRAINT TagRemoteIdResourceRelationTableresourceId_Resourceid_fk FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
483 483​
484INSERT INTO TagRemoteIdResourceRelationTable SELECT * FROM TagRemoteIdResourceRelationTable_old 484​INSERT INTO TagRemoteIdResourceRelationTable SELECT * FROM TagRemoteIdResourceRelationTable_old
485 485​
486DROP TABLE TagRemoteIdResourceRelationTable_old 486​DROP TABLE TagRemoteIdResourceRelationTable_old
487 487​
488COMMIT 488​COMMIT
489 489​
490PRAGMA foreign_key_check=ON 490​PRAGMA defer_foreign_keys=OFF
491 491​
492PRAGMA foreign_key_check=OFF 492​PRAGMA defer_foreign_keys=ON
493 493​
494BEGIN TRANSACTION 494​BEGIN TRANSACTION
495 495​
496ALTER TABLE TagRemoteIdResourceRelationTable RENAME TO TagRemoteIdResourceRelationTable_old 496​ALTER TABLE TagRemoteIdResourceRelationTable RENAME TO TagRemoteIdResourceRelationTable_old
497 497​
498CREATE TABLE TagRemoteIdResourceRelationTable (tagId BIGINT NOT NULL, 498​CREATE TABLE TagRemoteIdResourceRelationTable (tagId BIGINT NOT NULL,
499 resourceId BIGINT NOT NULL, 499​ resourceId BIGINT NOT NULL,
500 remoteId TEXT NOT NULL, 500​ remoteId TEXT NOT NULL,
501 CONSTRAINT TagRemoteIdResourceRelationTabletagId_Tagid_fk FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 501​ CONSTRAINT TagRemoteIdResourceRelationTabletagId_Tagid_fk FOREIGN KEY (tagId) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
502 CONSTRAINT TagRemoteIdResourceRelationTableresourceId_Resourceid_fk FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 502​ CONSTRAINT TagRemoteIdResourceRelationTableresourceId_Resourceid_fk FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
503 503​
504INSERT INTO TagRemoteIdResourceRelationTable SELECT * FROM TagRemoteIdResourceRelationTable_old 504​INSERT INTO TagRemoteIdResourceRelationTable SELECT * FROM TagRemoteIdResourceRelationTable_old
505 505​
506DROP TABLE TagRemoteIdResourceRelationTable_old 506​DROP TABLE TagRemoteIdResourceRelationTable_old
507 507​
508COMMIT 508​COMMIT
509 509​
510PRAGMA foreign_key_check=ON 510​PRAGMA defer_foreign_keys=OFF
511 511​
512PRAGMA foreign_key_check=OFF 512​PRAGMA defer_foreign_keys=ON
513 513​
514BEGIN TRANSACTION 514​BEGIN TRANSACTION
515 515​
516ALTER TABLE RelationTable RENAME TO RelationTable_old 516​ALTER TABLE RelationTable RENAME TO RelationTable_old
517 517​
518CREATE TABLE RelationTable (leftId BIGINT NOT NULL, 518​CREATE TABLE RelationTable (leftId BIGINT NOT NULL,
519 rightId BIGINT NOT NULL, 519​ rightId BIGINT NOT NULL,
520 typeId BIGINT DEFAULT 1, 520​ typeId BIGINT DEFAULT 1,
521 remoteId TEXT, 521​ remoteId TEXT,
522 CONSTRAINT RelationTableleftId_PimItemid_fk FOREIGN KEY (leftId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 522​ CONSTRAINT RelationTableleftId_PimItemid_fk FOREIGN KEY (leftId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
523 CONSTRAINT RelationTablerightId_PimItemid_fk FOREIGN KEY (rightId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE 523​ CONSTRAINT RelationTablerightId_PimItemid_fk FOREIGN KEY (rightId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
524 DEFERRABLE INITIALLY DEFERRED, 524​ DEFERRABLE INITIALLY DEFERRED,
525 CONSTRAINT RelationTabletypeId_RelationTypeid_fk FOREIGN KEY (typeId) REFERENCES RelationTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED) 525​ CONSTRAINT RelationTabletypeId_RelationTypeid_fk FOREIGN KEY (typeId) REFERENCES RelationTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED)
526 526​
527 527​
528INSERT INTO RelationTable SELECT * FROM RelationTable_old 528​INSERT INTO RelationTable SELECT * FROM RelationTable_old
529 529​
530DROP TABLE RelationTable_old 530​DROP TABLE RelationTable_old
531 531​
532COMMIT 532​COMMIT
533 533​
534PRAGMA foreign_key_check=ON 534​PRAGMA defer_foreign_keys=OFF
535 535​
536PRAGMA foreign_key_check=OFF 536​PRAGMA defer_foreign_keys=ON
537 537​
538BEGIN TRANSACTION 538​BEGIN TRANSACTION
539 539​
540ALTER TABLE RelationTable RENAME TO RelationTable_old 540​ALTER TABLE RelationTable RENAME TO RelationTable_old
541 541​
542CREATE TABLE RelationTable (leftId BIGINT NOT NULL, 542​CREATE TABLE RelationTable (leftId BIGINT NOT NULL,
543 rightId BIGINT NOT NULL, 543​ rightId BIGINT NOT NULL,
544 typeId BIGINT DEFAULT 1, 544​ typeId BIGINT DEFAULT 1,
545 remoteId TEXT, 545​ remoteId TEXT,
546 CONSTRAINT RelationTableleftId_PimItemid_fk FOREIGN KEY (leftId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 546​ CONSTRAINT RelationTableleftId_PimItemid_fk FOREIGN KEY (leftId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
547 CONSTRAINT RelationTablerightId_PimItemid_fk FOREIGN KEY (rightId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE 547​ CONSTRAINT RelationTablerightId_PimItemid_fk FOREIGN KEY (rightId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
548 DEFERRABLE INITIALLY DEFERRED, 548​ DEFERRABLE INITIALLY DEFERRED,
549 CONSTRAINT RelationTabletypeId_RelationTypeid_fk FOREIGN KEY (typeId) REFERENCES RelationTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED) 549​ CONSTRAINT RelationTabletypeId_RelationTypeid_fk FOREIGN KEY (typeId) REFERENCES RelationTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED)
550 550​
551 551​
552INSERT INTO RelationTable SELECT * FROM RelationTable_old 552​INSERT INTO RelationTable SELECT * FROM RelationTable_old
553 553​
554DROP TABLE RelationTable_old 554​DROP TABLE RelationTable_old
555 555​
556COMMIT 556​COMMIT
557 557​
558PRAGMA foreign_key_check=ON 558​PRAGMA defer_foreign_keys=OFF
559 559​
560PRAGMA foreign_key_check=OFF 560​PRAGMA defer_foreign_keys=ON
561 561​
562BEGIN TRANSACTION 562​BEGIN TRANSACTION
563 563​
564ALTER TABLE RelationTable RENAME TO RelationTable_old 564​ALTER TABLE RelationTable RENAME TO RelationTable_old
565 565​
566CREATE TABLE RelationTable (leftId BIGINT NOT NULL, 566​CREATE TABLE RelationTable (leftId BIGINT NOT NULL,
567 rightId BIGINT NOT NULL, 567​ rightId BIGINT NOT NULL,
568 typeId BIGINT DEFAULT 1, 568​ typeId BIGINT DEFAULT 1,
569 remoteId TEXT, 569​ remoteId TEXT,
570 CONSTRAINT RelationTableleftId_PimItemid_fk FOREIGN KEY (leftId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 570​ CONSTRAINT RelationTableleftId_PimItemid_fk FOREIGN KEY (leftId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
571 CONSTRAINT RelationTablerightId_PimItemid_fk FOREIGN KEY (rightId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE 571​ CONSTRAINT RelationTablerightId_PimItemid_fk FOREIGN KEY (rightId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE
572 DEFERRABLE INITIALLY DEFERRED, 572​ DEFERRABLE INITIALLY DEFERRED,
573 CONSTRAINT RelationTabletypeId_RelationTypeid_fk FOREIGN KEY (typeId) REFERENCES RelationTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED) 573​ CONSTRAINT RelationTabletypeId_RelationTypeid_fk FOREIGN KEY (typeId) REFERENCES RelationTypeTable(id) ON UPDATE CASCADE ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED)
574 574​
575 575​
576INSERT INTO RelationTable SELECT * FROM RelationTable_old 576​INSERT INTO RelationTable SELECT * FROM RelationTable_old
577 577​
578DROP TABLE RelationTable_old 578​DROP TABLE RelationTable_old
579 579​
580COMMIT 580​COMMIT
581 581​
582PRAGMA foreign_key_check=ON 582​PRAGMA defer_foreign_keys=OFF
583 583​
584PRAGMA foreign_key_check=OFF 584​PRAGMA defer_foreign_keys=ON
585 585​
586BEGIN TRANSACTION 586​BEGIN TRANSACTION
587 587​
588ALTER TABLE PimItemFlagRelation RENAME TO PimItemFlagRelation_old 588​ALTER TABLE PimItemFlagRelation RENAME TO PimItemFlagRelation_old
589 589​
590CREATE TABLE PimItemFlagRelation (PimItem_id BIGINT NOT NULL, 590​CREATE TABLE PimItemFlagRelation (PimItem_id BIGINT NOT NULL,
591 Flag_id BIGINT NOT NULL, 591​ Flag_id BIGINT NOT NULL,
592 PRIMARY KEY (PimItem_id, Flag_id), 592​ PRIMARY KEY (PimItem_id, Flag_id),
593 CONSTRAINT PimItemFlagRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 593​ CONSTRAINT PimItemFlagRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
594 CONSTRAINT PimItemFlagRelationFlag_id_Flagid_fk FOREIGN KEY (Flag_id) REFERENCES FlagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 594​ CONSTRAINT PimItemFlagRelationFlag_id_Flagid_fk FOREIGN KEY (Flag_id) REFERENCES FlagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
595 595​
596 596​
597INSERT INTO PimItemFlagRelation SELECT * FROM PimItemFlagRelation_old 597​INSERT INTO PimItemFlagRelation SELECT * FROM PimItemFlagRelation_old
598 598​
599DROP TABLE PimItemFlagRelation_old 599​DROP TABLE PimItemFlagRelation_old
600 600​
601COMMIT 601​COMMIT
602 602​
603PRAGMA foreign_key_check=ON 603​PRAGMA defer_foreign_keys=OFF
604 604​
605 605​
606PRAGMA foreign_key_check=OFF 606​PRAGMA defer_foreign_keys=ON
607 607​
608BEGIN TRANSACTION 608​BEGIN TRANSACTION
609 609​
610ALTER TABLE PimItemFlagRelation RENAME TO PimItemFlagRelation_old 610​ALTER TABLE PimItemFlagRelation RENAME TO PimItemFlagRelation_old
611 611​
612CREATE TABLE PimItemFlagRelation (PimItem_id BIGINT NOT NULL, 612​CREATE TABLE PimItemFlagRelation (PimItem_id BIGINT NOT NULL,
613 Flag_id BIGINT NOT NULL, 613​ Flag_id BIGINT NOT NULL,
614 PRIMARY KEY (PimItem_id, Flag_id), 614​ PRIMARY KEY (PimItem_id, Flag_id),
615 CONSTRAINT PimItemFlagRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 615​ CONSTRAINT PimItemFlagRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
616 CONSTRAINT PimItemFlagRelationFlag_id_Flagid_fk FOREIGN KEY (Flag_id) REFERENCES FlagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 616​ CONSTRAINT PimItemFlagRelationFlag_id_Flagid_fk FOREIGN KEY (Flag_id) REFERENCES FlagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
617 617​
618 618​
619INSERT INTO PimItemFlagRelation SELECT * FROM PimItemFlagRelation_old 619​INSERT INTO PimItemFlagRelation SELECT * FROM PimItemFlagRelation_old
620 620​
621DROP TABLE PimItemFlagRelation_old 621​DROP TABLE PimItemFlagRelation_old
622 622​
623COMMIT 623​COMMIT
624 624​
625PRAGMA foreign_key_check=ON 625​PRAGMA defer_foreign_keys=OFF
626 626​
627PRAGMA foreign_key_check=OFF 627​PRAGMA defer_foreign_keys=ON
628 628​
629BEGIN TRANSACTION 629​BEGIN TRANSACTION
630 630​
631ALTER TABLE PimItemTagRelation RENAME TO PimItemTagRelation_old 631​ALTER TABLE PimItemTagRelation RENAME TO PimItemTagRelation_old
632 632​
633CREATE TABLE PimItemTagRelation (PimItem_id BIGINT NOT NULL, 633​CREATE TABLE PimItemTagRelation (PimItem_id BIGINT NOT NULL,
634 Tag_id BIGINT NOT NULL, 634​ Tag_id BIGINT NOT NULL,
635 PRIMARY KEY (PimItem_id, Tag_id), 635​ PRIMARY KEY (PimItem_id, Tag_id),
636 CONSTRAINT PimItemTagRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 636​ CONSTRAINT PimItemTagRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
637 CONSTRAINT PimItemTagRelationTag_id_Tagid_fk FOREIGN KEY (Tag_id) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 637​ CONSTRAINT PimItemTagRelationTag_id_Tagid_fk FOREIGN KEY (Tag_id) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
638 638​
639INSERT INTO PimItemTagRelation SELECT * FROM PimItemTagRelation_old 639​INSERT INTO PimItemTagRelation SELECT * FROM PimItemTagRelation_old
640 640​
641DROP TABLE PimItemTagRelation_old 641​DROP TABLE PimItemTagRelation_old
642 642​
643COMMIT 643​COMMIT
644 644​
645PRAGMA foreign_key_check=ON 645​PRAGMA defer_foreign_keys=OFF
646 646​
647PRAGMA foreign_key_check=OFF 647​PRAGMA defer_foreign_keys=ON
648 648​
649BEGIN TRANSACTION 649​BEGIN TRANSACTION
650 650​
651ALTER TABLE PimItemTagRelation RENAME TO PimItemTagRelation_old 651​ALTER TABLE PimItemTagRelation RENAME TO PimItemTagRelation_old
652 652​
653CREATE TABLE PimItemTagRelation (PimItem_id BIGINT NOT NULL, 653​CREATE TABLE PimItemTagRelation (PimItem_id BIGINT NOT NULL,
654 Tag_id BIGINT NOT NULL, 654​ Tag_id BIGINT NOT NULL,
655 PRIMARY KEY (PimItem_id, Tag_id), 655​ PRIMARY KEY (PimItem_id, Tag_id),
656 CONSTRAINT PimItemTagRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 656​ CONSTRAINT PimItemTagRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
657 CONSTRAINT PimItemTagRelationTag_id_Tagid_fk FOREIGN KEY (Tag_id) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 657​ CONSTRAINT PimItemTagRelationTag_id_Tagid_fk FOREIGN KEY (Tag_id) REFERENCES TagTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
658 658​
659INSERT INTO PimItemTagRelation SELECT * FROM PimItemTagRelation_old 659​INSERT INTO PimItemTagRelation SELECT * FROM PimItemTagRelation_old
660 660​
661DROP TABLE PimItemTagRelation_old 661​DROP TABLE PimItemTagRelation_old
662 662​
663COMMIT 663​COMMIT
664 664​
665PRAGMA foreign_key_check=ON 665​PRAGMA defer_foreign_keys=OFF
666 666​
667PRAGMA foreign_key_check=OFF 667​PRAGMA defer_foreign_keys=ON
668 668​
669BEGIN TRANSACTION 669​BEGIN TRANSACTION
670 670​
671ALTER TABLE CollectionMimeTypeRelation RENAME TO CollectionMimeTypeRelation_old 671​ALTER TABLE CollectionMimeTypeRelation RENAME TO CollectionMimeTypeRelation_old
672 672​
673CREATE TABLE CollectionMimeTypeRelation (Collection_id BIGINT NOT NULL, 673​CREATE TABLE CollectionMimeTypeRelation (Collection_id BIGINT NOT NULL,
674 MimeType_id BIGINT NOT NULL, 674​ MimeType_id BIGINT NOT NULL,
675 PRIMARY KEY (Collection_id, MimeType_id), 675​ PRIMARY KEY (Collection_id, MimeType_id),
676 CONSTRAINT CollectionMimeTypeRelationCollection_id_Collectionid_fk FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 676​ CONSTRAINT CollectionMimeTypeRelationCollection_id_Collectionid_fk FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
677 CONSTRAINT CollectionMimeTypeRelationMimeType_id_MimeTypeid_fk FOREIGN KEY (MimeType_id) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 677​ CONSTRAINT CollectionMimeTypeRelationMimeType_id_MimeTypeid_fk FOREIGN KEY (MimeType_id) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
678 678​
679INSERT INTO CollectionMimeTypeRelation SELECT * FROM CollectionMimeTypeRelation_old 679​INSERT INTO CollectionMimeTypeRelation SELECT * FROM CollectionMimeTypeRelation_old
680 680​
681DROP TABLE CollectionMimeTypeRelation_old 681​DROP TABLE CollectionMimeTypeRelation_old
682 682​
683COMMIT 683​COMMIT
684 684​
685PRAGMA foreign_key_check=ON 685​PRAGMA defer_foreign_keys=OFF
686 686​
687PRAGMA foreign_key_check=OFF 687​PRAGMA defer_foreign_keys=ON
688 688​
689BEGIN TRANSACTION 689​BEGIN TRANSACTION
690 690​
691ALTER TABLE CollectionMimeTypeRelation RENAME TO CollectionMimeTypeRelation_old 691​ALTER TABLE CollectionMimeTypeRelation RENAME TO CollectionMimeTypeRelation_old
692 692​
693CREATE TABLE CollectionMimeTypeRelation (Collection_id BIGINT NOT NULL, 693​CREATE TABLE CollectionMimeTypeRelation (Collection_id BIGINT NOT NULL,
694 MimeType_id BIGINT NOT NULL, 694​ MimeType_id BIGINT NOT NULL,
695 PRIMARY KEY (Collection_id, MimeType_id), 695​ PRIMARY KEY (Collection_id, MimeType_id),
696 CONSTRAINT CollectionMimeTypeRelationCollection_id_Collectionid_fk FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 696​ CONSTRAINT CollectionMimeTypeRelationCollection_id_Collectionid_fk FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
697 CONSTRAINT CollectionMimeTypeRelationMimeType_id_MimeTypeid_fk FOREIGN KEY (MimeType_id) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 697​ CONSTRAINT CollectionMimeTypeRelationMimeType_id_MimeTypeid_fk FOREIGN KEY (MimeType_id) REFERENCES MimeTypeTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
698 698​
699INSERT INTO CollectionMimeTypeRelation SELECT * FROM CollectionMimeTypeRelation_old 699​INSERT INTO CollectionMimeTypeRelation SELECT * FROM CollectionMimeTypeRelation_old
700 700​
701DROP TABLE CollectionMimeTypeRelation_old 701​DROP TABLE CollectionMimeTypeRelation_old
702 702​
703COMMIT 703​COMMIT
704 704​
705PRAGMA foreign_key_check=ON 705​PRAGMA defer_foreign_keys=OFF
706 706​
707PRAGMA foreign_key_check=OFF 707​PRAGMA defer_foreign_keys=ON
708 708​
709BEGIN TRANSACTION 709​BEGIN TRANSACTION
710 710​
711ALTER TABLE CollectionPimItemRelation RENAME TO CollectionPimItemRelation_old 711​ALTER TABLE CollectionPimItemRelation RENAME TO CollectionPimItemRelation_old
712 712​
713CREATE TABLE CollectionPimItemRelation (Collection_id BIGINT NOT NULL, 713​CREATE TABLE CollectionPimItemRelation (Collection_id BIGINT NOT NULL,
714 PimItem_id BIGINT NOT NULL, 714​ PimItem_id BIGINT NOT NULL,
715 PRIMARY KEY (Collection_id, PimItem_id), 715​ PRIMARY KEY (Collection_id, PimItem_id),
716 CONSTRAINT CollectionPimItemRelationCollection_id_Collectionid_fk FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 716​ CONSTRAINT CollectionPimItemRelationCollection_id_Collectionid_fk FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
717 CONSTRAINT CollectionPimItemRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 717​ CONSTRAINT CollectionPimItemRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
718 718​
719INSERT INTO CollectionPimItemRelation SELECT * FROM CollectionPimItemRelation_old 719​INSERT INTO CollectionPimItemRelation SELECT * FROM CollectionPimItemRelation_old
720 720​
721DROP TABLE CollectionPimItemRelation_old 721​DROP TABLE CollectionPimItemRelation_old
722 722​
723COMMIT 723​COMMIT
724 724​
725PRAGMA foreign_key_check=ON 725​PRAGMA defer_foreign_keys=OFF
726 726​
727PRAGMA foreign_key_check=OFF 727​PRAGMA defer_foreign_keys=ON
728 728​
729BEGIN TRANSACTION 729​BEGIN TRANSACTION
730 730​
731ALTER TABLE CollectionPimItemRelation RENAME TO CollectionPimItemRelation_old 731​ALTER TABLE CollectionPimItemRelation RENAME TO CollectionPimItemRelation_old
732 732​
733CREATE TABLE CollectionPimItemRelation (Collection_id BIGINT NOT NULL, 733​CREATE TABLE CollectionPimItemRelation (Collection_id BIGINT NOT NULL,
734 PimItem_id BIGINT NOT NULL, 734​ PimItem_id BIGINT NOT NULL,
735 PRIMARY KEY (Collection_id, PimItem_id), 735​ PRIMARY KEY (Collection_id, PimItem_id),
736 CONSTRAINT CollectionPimItemRelationCollection_id_Collectionid_fk FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 736​ CONSTRAINT CollectionPimItemRelationCollection_id_Collectionid_fk FOREIGN KEY (Collection_id) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
737 CONSTRAINT CollectionPimItemRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED) 737​ CONSTRAINT CollectionPimItemRelationPimItem_id_PimItemid_fk FOREIGN KEY (PimItem_id) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED)
738 738​
739INSERT INTO CollectionPimItemRelation SELECT * FROM CollectionPimItemRelation_old 739​INSERT INTO CollectionPimItemRelation SELECT * FROM CollectionPimItemRelation_old
740 740​
741DROP TABLE CollectionPimItemRelation_old 741​DROP TABLE CollectionPimItemRelation_old
742 742​
743COMMIT 743​COMMIT
744 744​
745PRAGMA foreign_key_check=ON 745​PRAGMA defer_foreign_keys=OFF