/magstudentportal/trunk

==__  __==========_____=========================================================

 |  \/  |   /\   / ____|

 | \  / |  /  \ | |  __

 | |\/| | / /\ \| | |_ |

 | |  | |/ ____ \ |__| |

 |_|__|_/_/    \_\_____|            _     _____           _        _ 

  / ____| |           | |          | |   |  __ \         | |      | |

 | (___ | |_ _   _  __| | ___ _ __ | |_  | |__) |__  _ __| |_ __ _| |

  \___ \| __| | | |/ _` |/ _ \ '_ \| __| |  ___/ _ \| '__| __/ _` | |

  ____) | |_| |_| | (_| |  __/ | | | |_  | |  | (_) | |  | || (_| | |

 |_____/ \__|\__,_|\__,_|\___|_| |_|\__| |_|   \___/|_|   \__\__,_|_|

================================================================================

Mahmood & Amir & Gustav Student Portal

================================================================================

Authors:

Gustav Hartvigsson

INDEX --------------------------------------------------------------------------

* General Information

* Setup

* Initialising Database

General Information ------------------------------------------------------------

TODO

Setup --------------------------------------------------------------------------

TODO

Initialising Database ----------------------------------------------------------

  Here follows a description of how to initialise the database in different

different database engines/managers/thingies.

  The .sql files are located in ./src/main/resources/

Initialising Database: PostreSQL -----------------------------------------------

  In postgres you need to start psql from the terminal:

$ psql -U <username> -a -f ./src/main/resources/create_db.sql

  If the your database username is "postgres", you should use that. press enter

and enter the password fot the database user.

  you should be something like this if it has been created correctly:

---------- snip ----------

Password for user postgres:

/*

  This should be used to create the database.

  How to do this depends on the DB.

*/

CREATE DATABASE mag_studentportal

      ENCODING = 'UTF8'

      CONNECTION LIMIT = -1;

CREATE DATABASE

---------- end snip ----------

  Now that you have created the database you need to initialise the tables, to

do this you need to run the following:

$ psql -U <username> -d mag_studentportal \

  -a -f ./src/main/resources/create_tables.sql

  That should run without any errors.

  Congratulations! The database is now initialised!

Initialising Database: MariaDB/MySql -------------------------------------------

TODO