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