Pharmadex 2 database built on MySQL Community Server database engine.

Core tools:

• MySQL Community Server - An open source relation database management software https://dev.mysql.com/downloads/mysql/
• MySQL Workbench - a unified visual tool for database architects https://www.mysql.com/products/workbench/

Files:

• DumpPdx2.zip - an initial database
• pdx2.mwb - actual model of the database allows database structure synchronization https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html
• database_cleanup.sql - script to remove unused pdx1 tables from the database
• DBSyncFromTheModelDoesntWorks.docx read this if the synchronization from the model is failed