{"push_id":887077174,"size":2,"distinct_size":2,"ref":"refs/heads/master","head":"801f835f246b2b2a38a886920056c149dd6894c0","before":"10ef991c8803db6beae0a3ae19cf83876db8cd1e","commits":[{"sha":"bca001b16dd6aba437aece1bc09e9400ec300d1d","author":{"email":"b7f070ef717289519fe95ae6f12e2e4e131ed4c0@gmail.com","name":"Gilles Caulier"},"message":"Apply patch #95860 to store empty icon (image 0) as a NULL value with SQlite and Mysql Databases\n\ndigiKam treats image zero as a \"not set\" icon value. This\nbreaks referential integrity in the database because image\nzero does not exist. Explicitly convert a value of zero\ninto NULL when stored in the database.\n\nIdeally digiKam should use an explicit null (in QVariant?)\nplaceholder for the no-icon case but currently no database\nstores an image zero by default so the existing practice\nworks.\n\nNote that when reading from the database the toLongLong\nmethod of QVariant returns a zero when called against a\nnull value so this means that no changes are required\nwhen reading null values in from the database.\n\nCCBUGS: 355831","distinct":true,"url":"https://api.github.com/repos/rompe/digikam/commits/bca001b16dd6aba437aece1bc09e9400ec300d1d"},{"sha":"801f835f246b2b2a38a886920056c149dd6894c0","author":{"email":"b7f070ef717289519fe95ae6f12e2e4e131ed4c0@gmail.com","name":"Gilles Caulier"},"message":"apply patch #95861 to remove trigger dependency for MySQL.\n\nAdd full referential integrity to AlbumRoots, Albums, Images and Tags\ntables entries.\nProvide the equivalent behaviour to the triggers using ON DELETE and\nON UPDATE in FOREIGN KEY references.\n\nUse dbaction to perform database specific preparation for migration.\n\nThe MySQL schema has a circular dependency and this must be removed\nbefore any leftover contents of the database are removed prior to the\nmigration. No actions are required for SQLite\n\nReferential integrity in MySQL does not allow the Albums.icon field\nto be set prior to the Images table being populated. Use a fake\nAlbumsExtra table to copy over the icons data.\nNote we use the same procedure for both SQLite and MySQL to ensure\nthat migration is possible between any combination of databases.\n\nCCBUGS: 355831","distinct":true,"url":"https://api.github.com/repos/rompe/digikam/commits/801f835f246b2b2a38a886920056c149dd6894c0"}]}