Reputation: 91
How can I find out the current version of the civicrm database schema?
Upvotes: 0
Views: 967
Reputation: 705
Look in the civicrm_domain table for the column version - that'll tell you what version the database is in. (It's updated as one of the last steps in the upgrade process.)
SELECT version FROM civicrm_domain
If you have multiple CiviCRM domains running from the same data set, you'll see multiple entries, but for 99% of organizations, there'll just be the one result.
Meanwhile, if you want to see the codebase version (hopefully they're the same), it's in your civicrm directory in the file civicrm-version.php and displayed at the bottom of each page in the back end of CiviCRM.
Upvotes: 6