====== Database Version Reservation ======

AllPeers performs semi-automatic update of the database schema. When a new schema is created or changed it will be updated when new version is installed. Additionally there is a mechanism how to execute arbitrary SQL commands during upgrade see [[src>database/src/apDatabaseAutomaticUpdater.cpp]].

:!: At the moment there is no downgrade possibility, if you upgrade your database to a higher version, you will not be able to use it with older client. Backup your database!

You can check the version of your database schema by using [[chrome://allpeers/content/storageinspector/storageinspector.xul|Storage Inspector]] ((Bookmark this link to be able to click on it)). Select the "pragma user_version" SQL command from the drop down list.

Whenever you plan to make a change to database schema you have to reserve a schema version here and change it in [[src>database/src/apDatabaseService.cpp]] when preparing a patch.

^ Release ^ Bug ^ Version ^ Description ^
| 0.75 | [[bug>3864]] | 761 | Remove index on OriginMimeType |
| 0.75 | [[bug>3869]] | 760 | Missing index on Message_Metadata.Progress |
| 0.75 | [[bug>3752]] | 759 | UEA password attempts limitation - server part |
| 0.75 | [[bug>3741]] | 758 | Upgrade Auto-download settings |
| 0.75 | [[bug>3409]] | 757 | Progress information must be stored in File's metadata |
| 0.75 | [[bug>3610]] | 756 | Download view have to be based on information from database |
| 0.75 | [[bug>3605]] | 755 | Disable comments |
| 0.75 | [[bug>3602]] | 753 | One file torrents should not be in folder on disk |
| 0.75 | [[bug>3409]] | 752 | Store validity in File's metadata |
| 0.75 | [[bug>3535]] | 751 | Remove PathInfix |
| 0.75 | [[bug>3453]] | 750 | Increase version number for upgrades from 0.70 to 0.75 |
| 0.70 | [[bug>3602]] | 722 | One file torrents should not be in folder on disk |
| 0.70 | <del>[[bug>3252]]</del> | 721 | Opening My Torrent view is very slow with big torrents; caching info in stats and torrent |
| 0.70 | <del>[[bug>3250]]</del> | 720 | Fix empty ReceiveStatus for imported torrents |
| 0.75 | <del>[[bug>932]]</del> | <del>719</del> | Basic implementation of comments |
| 0.70 | <del>[[bug>3128]]</del> | 718 | Remove duplicates from _Source_PeerCommonName |
| 0.70 | <del>[[bug>2963]]</del> | 717 | Optimize album/torrent view with better file validation |
| 0.70 | <del>[[bug>3080]]</del> | 716 | Missing index on TorrentInfoHash |
| 0.70 | <del>[[bug>2967]]</del> | 715 | Duplicate emails and common names in database |
| 0.70 | <del>[[bug>2944]]</del> | 714 | TorrentInfo orphans left in the database (join with old files) |
| 0.70 | <del>[[bug>2217]]</del> | 713 | DataProtocolInfo is gone and implemented as independent |
| 0.70 | [[bug>2917]] | 712 | Fix re-creation of Torrent table ([[bug>2818]]) |
| 0.70 | <del>[[bug>2818]]</del> | 711 | Torrent is derived from List |
| 0.70 | <del>[[bug>2779]]</del> | 710 | New metadata for file, autodownload related |
| 0.70 | <del>[[bug>2847]]</del> | 709 | New property "URL" and metadata "Status" and "ErrorMsg" in torrent |
| 0.70 | <del>[[bug>2561]]</del> | 708 | Check presence in order by last seen peer metadata |
| 0.70 | <del>[[bug>2792]]</del> | 707 | Add autodownload metadata for PeerList |
| 0.70 | <del>[[bug>512]]</del> | 705 | Add peer metadata for Autodownload |
| 0.60 | <del>[[bug>2544]]</del> | 655 | Add missing indexes for multiply occurring properties |
| 0.60 | <del>[[bug>2294]]</del> | 654 | Add indexes to the external storage related schemas |
| 0.60 | <del>[[bug>1025]]</del> | 653 | Improve experience of "Share by Email" by using external storage |
| 0.60 | <del>[[bug>2253]]</del> | 652 | "Left" renamed to "BytesLeft" in bitTorrentStats.rng |
| 0.60 | <del>[[bug>2164]]</del> | 651 | Add session ID to chat events |
| 0.60 | <del>[[bug>1795]]</del> | 650 | New schemas for external torrents |
| 0.56 | <del>[[bug>2207]]</del> | 616 | Remove old HTTP sources |
| 0.56 | <del>[[bug>2177]]</del> | 615 | Cleanup wrong ReceivingStatus and IsLocal information |
| 0.56 | <del>[[bug>2112]]</del> | 614 | Convert dates in wrong format again |
| 0.56 | <del>[[bug>2056]]</del> | <del>613</del> | <del>Cleanup wrong ReceivingStatus and IsLocal information</del> |
| 0.56 | <del>[[bug>2028]]</del> | 612 | Add profile copy number to avoid resource id conflicts |
| 0.56 | <del>[[bug>2041]]</del> | 611 | Chat takes some time to let you use it |
| 0.56 | <del>[[bug>1558]]</del> | 610 | Reset sweetspot OwenerId from Peer resources |
| 0.56 | <del>[[bug>1905]]</del> | 609 | Multiply occurring properties can have duplicate values |
| 0.56 | <del>[[bug>1953]]</del> | 608 | Source resources have wrong parent ID |
| 0.56 | <del>[[bug>1947]]</del> | 607 | Convert server side tables |
| 0.56 | <del>[[bug>1907]]</del> | 606 | Reduce number of RelationStatus values |
| 0.56 | <del>[[bug>1916]]</del> | <del>605</del> | <del>Convert dates in wrong format</del> |
| 0.56 | <del>[[bug>1876]]</del> | 604 | Too few indexes |
| 0.56 | <del>[[bug>1876]]</del> | 603 | Too many indexes |
| 0.56 | <del>[[bug>1875]]</del> | 602 | Fixed metadata tables |
| 0.56 | <del>[[bug>1297]]</del> | 601 | RDF overhaul |
| 0.56 | <del>[[bug>1349]]</del> | 600 | Add server side indexes |
| 0.56 | <del>[[bug>40]]</del> | 548 | Slow Firefox start |
| 0.54 | <del>[[bug>1375]]</del> | 547 | Regenerate Owner ID  |
| 0.54 | <del>[[bug>1266]]</del> | 546 | Chat related changes  |
| 0.54 | <del>[[bug>1184]]</del> | 545 | Owner ID conversion  |