text: DROP DATABASE IF EXISTS HackathonDb;
  create Database HackathonDb;
  use HackathonDb;
  create table IF NOT EXISTS User(
    id int UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
    phone_number varchar(15),
    user_name varchar(35),
    INDEX(phone_number)
  );
  
  create table IF NOT EXISTS Provider(
    id int UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
    display_name varchar(50)
  );
  
  create table IF NOT EXISTS ProviderContent(
    id int UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
    provider_id int UNSIGNED NOT NULL,
    content varchar(350),
    title VARCHAR(30),
    date_created DATETIME,
    FOREIGN KEY (provider_id) REFERENCES User(id),
    INDEX(provider_id),
    INDEX(title)
  );
  
  create table IF NOT EXISTS UserProviderRelationTable(
    provider_id int UNSIGNED PRIMARY KEY NOT NULL,
    user_id int UNSIGNED NOT NULL,
    INDEX(user_id),
    FOREIGN KEY (provider_id) REFERENCES Provider(id),
    FOREIGN KEY (user_id) REFERENCES User(id)
  );
  
  create table IF NOT EXISTS ChatRoom(
    id int UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
    title varchar(30)
  );
  
  create table IF NOT EXISTS UserChatRoomRelationTable(
    chatroom_id int UNSIGNED PRIMARY KEY NOT NULL,
    user_id int UNSIGNED NOT NULL,
    INDEX (user_id),
    FOREIGN KEY (chatroom_id) REFERENCES ChatRoom(id),
    FOREIGN KEY (user_id) REFERENCES User(id)
  );