/* Origin (console): artisan migrate
   Query 1 - 2023-03-16 18:53:14 [5.95ms] */
select * from information_schema.tables where table_schema = 'train_rta' and table_name = 'migrations' and table_type = 'BASE TABLE';
/*==================================================*/
/* Origin (console): artisan migrate
   Query 2 - 2023-03-16 18:53:14 [0.39ms] */
select * from information_schema.tables where table_schema = 'train_rta' and table_name = 'migrations' and table_type = 'BASE TABLE';
/*==================================================*/
/* Origin (console): artisan migrate
   Query 3 - 2023-03-16 18:53:14 [1.14ms] */
select `migration` from `migrations` order by `batch` asc, `migration` asc;
/*==================================================*/
/* Origin (console): artisan migrate
   Query 4 - 2023-03-16 18:53:14 [0.2ms] */
select `migration` from `migrations` order by `batch` asc, `migration` asc;
/*==================================================*/
/* Origin (console): artisan migrate
   Query 5 - 2023-03-16 18:53:14 [0.34ms] */
select max(`batch`) as aggregate from `migrations`;
/*==================================================*/
/* Origin (console): artisan migrate
   Query 6 - 2023-03-16 18:53:14 [24.34ms] */
create table `branches` (`id` bigint unsigned not null auto_increment primary key, `district_id` bigint unsigned not null, `name` varchar(191) not null, `manager` varchar(191) null, `physical_location` varchar(191) null, `x_cordinate` varchar(191) null, `y_cordinate` varchar(191) null, `created_by` int unsigned not null, `updated_by` int unsigned null, `deleted_by` int unsigned null, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8 collate 'utf8_unicode_ci';
/*==================================================*/
/* Origin (console): artisan migrate
   Query 7 - 2023-03-16 18:53:14 [42.41ms] */
alter table `branches` add constraint `branches_district_id_foreign` foreign key (`district_id`) references `district` (`id`);
/*==================================================*/
/* Origin (console): artisan migrate
   Query 8 - 2023-03-16 18:53:14 [12.87ms] */
alter table `branches` add unique `branches_name_unique`(`name`);
/*==================================================*/
/* Origin (console): artisan migrate
   Query 9 - 2023-03-16 18:53:14 [3.2ms] */
insert into `migrations` (`migration`, `batch`) values ('2014_09_19_111452_create_branches_table', 2);
/*==================================================*/
