stable

Clone or download

Read-only

Introduce the data structure to share document manager item ID between tables

The goal of this contribution is to have a way to reserve item ID for documents being uploaded. This approach is obviously flawed and in an ideal world we should not have to do that but in the current situation it seems to be safest solution to not have ghost documents. Also, since Tuleap still suports version of MySQL predating MySQL 5.6, we can not use FULLTEXT indexes with the InnoDB engine. As a result we can not enforce a constraint to be sure the item_id of the plugin_docman_item table has been reserved. To ease the migration process, since the table plugin_docman_new_document_upload is not used at all in production environnements, the table is completly dropped and recreated from scratch. This is part of story #12612: upload document via REST route Change-Id: I922f9f404c69b1b16e09d28ca722265b4a3aa991

Modified Files

Name
D plugins/docman/db/feed.sql +0 −83 Go to diff View file
D plugins/docman/db/feed_lite.sql +0 −58 Go to diff View file
D plugins/docman/db/feed_max.sql +0 −5526 Go to diff View file
M plugins/docman/db/install.sql +11 −4 Go to diff View file
A plugins/docman/db/mysql/updates/2018/20181221_share_docman_item_id_between_tables.php +69 −0 Go to diff View file
M plugins/docman/db/uninstall.sql +1 −2 Go to diff View file
M plugins/docman/include/Docman_ItemDao.class.php +19 −27 Go to diff View file