init_db.sql

use munguars_db;

drop table if exists Users;
drop table if exists Events;
drop table if exists CreatedBy;

create table Users(
    stuid int not null auto_increment,
    name varchar(50) not null,
    email  varchar(50) not null unique,
    hashed_pwd varchar(100) not null,
    primary key(stuid),
    index(email)
);

create table Events(
    eid int not null auto_increment,
    title varchar(100) not null,
    descrip varchar (250) not null,
    time datetime not null,
    location varchar(50),
    primary key(eid)
);
create table CreatedBy(
    eid int not null,
    stuid int not null,
    primary key (eid, stuid),
    foreign key (eid) references Events(eid) 
        on update cascade
        on delete cascade,
    foreign key (stuid) references Users(stuid)
        on update cascade
        on delete cascade
);