The database for the behavioral analysis project for the zoo, by Project Group B, 2019
- Documentation can be found at https://project-group-b.github.io/behavioral_analysis_db/
- Download the MySql Server and MySql Workbench: https://dev.mysql.com/downloads/installer/
- Follow the instructions and use default options to set everything up
- Open workbench and login to your localhost
- On the left side, click Administration -> Management -> Data/Import Restore
- Download the file folder from here
- In server create an empty schema that matches the name
"behavioral_analysis_db" - Choose "import from dump folder" and browse to where you downloaded this
- Ensure running SQL 8.0.x or higher. Older versions, especially the default 5.x.x do not have support for some table features/character sets and will not work with this project.
- Import the SQL from the repository into your MySQL instance.
- Ensure SQL connections between the MySQL host machine the back end host machine are allowed on port 3306.
- Insert a default user to associate not yet approved entries with.
INSERT INTO user (User_Name,User_Pass,User_Status,User_Department,User_FirstName,User_LastName);UPDATE `behavioral_analysis_db`.`user` SET `User_Pass` = sha2('User_Pass',256) WHERE (`User_Id` = '0');