Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/clinic.corals.io/database/releases/v1.1.0/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

create table `notifications`
(
    `id`         bigint unsigned not null auto_increment primary key,
    `title`      varchar(255) null,
    `type`       varchar(255) null,
    `read_at`    timestamp null,
    `user_id`    bigint unsigned null,
    `created_at` timestamp null,
    `updated_at` timestamp null
) default character set utf8mb4 collate 'utf8mb4_unicode_ci';
alter table `notifications`
    add constraint `notifications_user_id_foreign` foreign key (`user_id`) references `users` (`id`) on delete cascade on update cascade;

alter table `users`
    add `email_notification` tinyint(1) not null default '1';