EPM, Project Server 2003, Project Server 2007, MOSS 2007, Portfolio Server2007
Updated with Infrastructure update Information (July 15th, 2008)
You have decided to migrate to the SP1 of EPM 2007 and/or MOSS 2007.
During the upgrade (done by the configuration wizard), the databases are upgraded also.
If you want to check the schema version of the databases, you can use this query in any of your farm database:
SELECT * FROM Versions
The very last version that maps to the GUID {00000000-0000-0000-0000-000000000000} with the highest ID should equal the current version of the product
Here is a table showing the different database versions
(Thanks Brian http://blogs.msdn.com/brismith)
Updated with Infrastructure Update Information
WSS: http://support.microsoft.com/kb/95165
Office Server http://support.microsoft.com/kb/951297
12.0.0.4518
3.0.7.0
3.0.10.0
12.0.0.6219
12.0.0.6318
12.0.4518.1016
12.0.1.0
12.0.6219.1000
12.0.6318.5000
12.0.38.0
12.1.503.0
3.0.149.0
3.1.3.0
3.1.5.0
12.0.6218.1000
12.1.104.0
12.1.153.0
12.1.106.0
12.1.162.0
12.1.102.0
12.1.151.0
If you attach a RTM content database or if you provision a new project server site with four RTM databases on a SP1 installation, the RTM databases are upgraded to SP1 during the provisioning.
You may have less lines in your databases, if they were created after applying the SP1 a Rollup or the infrastructure update.