I'm working whit a Web application (.net) and we have user that have folder, the folder are used for saving document (folder and document are only row in tables).
We have functionality that will allow you to choose the order by (ex: insert date, type, ...).
Now we want to add the possibility to make manual order by.
First I was thinking about adding a column in the document table "iOrderBy_id", but I'm concern about the complexity of the modification made to the order by. Example if user want to add a new document in the middle. Can I avoid to have to update every document?
Any suggestion will be appreciated,