mol1122 / rideshare

rideShare

USAGE:

    To use this application you must first create the following database , grant permission and create the tables described below:
    
    1 - Create a database called rideshare
        create database rideshare; 
        use rideshare;
    
    2 - Give permission to main admin user
        
        grant all on rideshare.* to dbuser@localhost identified by "goodbyeWorld";
    
    3- Create the tables:
        
        create table users (
                                name varchar(50),
                                email varchar(100) primary key,
                                username varchar(60),
                                password varchar(60),
                                phone int,
                                address varchar(100),
                                avatar blob,
                                isdriver varchar(3),
                                carmodel varchar(30),
                                drivingexp int
                            );
        
        create table drivers (
                                id int primary key AUTO_INCREMENT,
                                email varchar(100),
                                origin varchar(100),
                                latitude_o double,
                                longitude_o double,
                                destination varchar(100),
                                latitude_d double,
                                longitude_d double,
                                start_time datetime,
                                end_time datetime,
                                size int
                            );
                                
        create table riders(
                                id int primary key AUTO_INCREMENT,
                                email varchar(100),
                                origin varchar(100),
                                destination varchar(100),
                                start_time datetime,driver int
                            );