<?php
namespace App;
class Config
{
    /**
     * 0. Central DB
     */
    const DB_HOST = 'localhost';
    const DB_NAME = 'hindu';
    const DB_USER = 'hindu';
    const DB_PASSWORD = 'hindu';

    /**
     * 1. Database for Hindu College - Main Campus (Unaided)
     */
    const DB_HOST1 = 'localhost';
    const DB_NAME1 = 'hinduengg_hindu_main_unaided';
    const DB_USER1 = 'hinduengg_hindu_main_unaided';
    const DB_PASSWORD1 = 'hindu_main_unaided';

    /**
     * 2. Database for Hindu College (UG & PG Courses)- Amaravathi Road Campus
     */
    const DB_HOST2 = 'localhost';
    const DB_NAME2 = 'hinduengg_hindu_amaravathi_pg';
    const DB_USER2 = 'hinduengg_hindu_amaravathi_pg';
    const DB_PASSWORD2 = 'hindu_amaravathi_pg';

    /**
     * 3. Database for Hindu College of Engineering & Technology- Amaravathi Road Campus
     */
    const DB_HOST3 = 'localhost';
    const DB_NAME3 = 'hinduengg_hindu_engg';
    const DB_USER3 = 'hinduengg_hindu_engg';
    const DB_PASSWORD3 = 'hindu_engg!';

    /**
     * 4. Database for Hindu College of Engineering & Technology - MCA 
     */
    const DB_HOST4 = 'localhost';
    const DB_NAME4 = 'hinduengg_hindu_mca';
    const DB_USER4 = 'hinduengg_hindu_mca';
    const DB_PASSWORD4 = 'hindu_mca';

    /**
     * 5. Database for Hindu College of Management
     */
    const DB_HOST5 = 'localhost';
    const DB_NAME5 = 'hinduengg_hindu_management';
    const DB_USER5 = 'hinduengg_hindu_management';
    const DB_PASSWORD5 = 'hindu_management';
    
    /**
     * 6. Database for Hindu College of Management
     */
    const DB_HOST6 = 'localhost';
    const DB_NAME6 = 'hinduengg_hindu_mcom';
    const DB_USER6 = 'hinduengg_hindu_mcom';
    const DB_PASSWORD6 = 'hindu_mcom';
    
    const SHOW_ERRORS = true;
}

    /* CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
    GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
    FLUSH PRIVILEGES;
    */
    /* alter table user_master convert to character set utf8 collate utf8_general_ci;*/

    /** Common Table alterrations - must needed
     * ALTER TABLE `user_master` ADD `fname` INT NOT NULL AFTER `name`;
     * ALTER TABLE `user_master` ADD `lateral` VARCHAR(1) NOT NULL AFTER `fk_dept_id`;
     * ALTER TABLE `user_master` ADD `add_by` VARCHAR(22) NOT NULL AFTER `v_email`, ADD `add_date` VARCHAR(30) NOT NULL AFTER `add_by`;
     */