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

Database RTM SP1 Infrastructure Update
July 15th, 2008
SharePoint Config DB

12.0.0.4518

3.0.7.0

3.0.10.0

12.0.0.4518

12.0.0.6219

3.0.7.0

3.0.10.0

12.0.0.4518

12.0.0.6219

12.0.0.6318

3.0.7.0

3.0.10.0

SharedServices DB

12.0.4518.1016

12.0.1.0

12.0.4518.1016

12.0.6219.1000

12.0.1.0

12.0.4518.1016

12.0.6219.1000

12.0.6318.5000

12.0.38.0

12.1.503.0

WSS Content DBs

12.0.0.4518

3.0.149.0

12.0.0.4518

12.0.0.6219

3.1.3.0

12.0.0.4518

12.0.0.6219

12.0.0.6318

3.1.5.0

Archive 12.0.57.0

12.0.4518.1016

12.0.6218.1000

12.1.104.0

12.0.4518.1016

12.0.6218.1000

12.0.6318.5000

12.1.153.0

Draft 12.0.58.0

12.0.4518.1016

12.0.6218.1000

12.1.104.0

12.0.4518.1016

12.0.6218.1000

12.0.6318.5000

12.1.153.0

Published 12.0.64.0

12.0.4518.1016

12.0.6218.1000

12.1.106.0

12.0.4518.1016

12.0.6218.1000

12.0.6318.5000

12.1.162.0

Reporting 12.0.52.0

12.0.4518.1016

12.0.6218.1000

12.1.102.0

12.0.4518.1016

12.0.6218.1000

12.0.6318.5000

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.