This repository is source code of the small web project, which is named 'EcoMap'. This website allows you to publish information about ecological issues around Ukraine to dynamic map. Officials of the Ministry of Environment use this website to collect info about problems and contact with citizens, who publish info to this website.
Website's url - ecomap.org

We're assumming that you're using bash & you already have installed such packages:

• apt-get
• sudo apt-get install mysql-server

1. Clone this repository to your local machine
2. Go to 'ecomap/DB/ecomap/' directory
3. Run mysql shell: mysql -u -p
4. Run following command: CREATE DATABASE IF NOT EXISTS ecomap_db; - this command will create database if it's not created yet. Put the name you want instead of 'ecomap_db'
5. Run following command: USE ecomap_db; - this command will set the database you've created earilier as current. Instead of ecomap_db put the name you've chosen earlier
6. Run following command: SOURCE CREATE_DB.sql; - this command will create all tables for database
7. Run following command: SOURCE INSERT_DATA.sql; - this command will populate all data you need for the beginning of work
8. Now you have working Database!