-
Notifications
You must be signed in to change notification settings - Fork 0
Creating a Mysql LIMS Database
If you want to use the LIMS plugin with a MySQL database, you will need the the following database creation script.
Version 11.0 (Current):
https://raw.githubusercontent.com/biocodellc/biocode-lims/develop/doc/labbench_11.0_mysql.sql
If you have been using the previous version of the plugin with a MySQL database, you may need to upgrade it. If the plugin tells you that your database version is out of date, then you can upgrade it with the following database upgrade scripts.
The scripts must be executed in order. Start at the version which mentions your current database version. For example if you are running version 9, then you only need to run upgrade_9_mysql.sql. If you need help, please contact support@mooreabiocode.org.
http://assets.geneious.com/plugins/biocode/upgrade_9.1_mysql.sql
http://assets.geneious.com/plugins/biocode/upgrade_9_mysql.sql
http://assets.geneious.com/plugins/biocode/upgrade_8_mysql.sql
If you have been using either the 2.9.x beta or the 2.99.x beta versions then you may have already been using the latest schema and can set the correct version number by running: http://assets.geneious.com/plugins/biocode/upgrade_9.2_sqlite.sql
If you have problems or are unsure, please contact support@mooreabiocode.org