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 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 Storage Inspector 1). 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 database/src/apDatabaseService.cpp when preparing a patch.

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