drop database if exists contactsdb;

    create database contactsdb;



    create table contactsdb.comments (
        id bigint not null auto_increment,
        comment_text text,
        comment_date datetime,
        user_id bigint,
        contact_id bigint,
        created_at datetime,
        updated_at datetime,
        primary key (id)
    );

    create table contactsdb.contacts (
        id bigint not null auto_increment,
        first_name varchar(255),
        last_name varchar(255),
        priority integer,
        phone_nums varchar(255),
        email varchar(255),
        web_page text,
        photo_uri text,
        created_at datetime,
        updated_at datetime,
        primary key (id)
    );

    create table contactsdb.users (
        id bigint not null auto_increment,
        username varchar(255),
        password varchar(255),
        enabled boolean,
        created_at datetime,
        updated_at datetime,
        primary key (id)
    );

    create table contactsdb.authorities (
        username varchar(255) not null,
        authority varchar(255),
        primary key (username)
    );

    alter table contactsdb.comments
        add index FKABDCDF4F35AF774 (contact_id), 
        add constraint FKABDCDF4F35AF774 
        foreign key (contact_id) 
        references contactsdb.contacts (id);

    alter table contactsdb.comments
        add index FKABDCDF421AB4A60 (user_id), 
        add constraint FKABDCDF421AB4A60 
        foreign key (user_id) 
        references contactsdb.users (id);