#====MIGRAGE ALL DB===1

php artisan migrate [only one file of table creation][Modules\Sman\Database\Migrations\2022_08_28_050342386432_create_sman_smen_table.php]

ALTER TABLE `sman__smen` CHANGE `id` `id` BIGINT(16) UNSIGNED NOT NULL AUTO_INCREMENT;

php artisan migrate [Modules\Sman\Database\Migrations\2022_08_28_050342657826_create_sman_sman_translations_table.php]

ALTER TABLE `sman__sman_translations` CHANGE `sman_id` `sman_id` BIGINT(16) UNSIGNED NOT NULL;



CREATE TABLE IF NOT EXISTS `sman__categories` (
  `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



CREATE TABLE IF NOT EXISTS `sman__category_translations` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category_id` bigint(16) UNSIGNED NOT NULL,
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sman__category_translations_category_id_locale_unique` (`category_id`,`locale`),
  KEY `sman__category_translations_locale_index` (`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


#======2

ALTER TABLE `user_tokens` CHANGE `user_id` `user_id` BIGINT(16) UNSIGNED NOT NULL;

#======3

ALTER TABLE `sman__categories` CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `sman__categories` ADD `name` VARCHAR(50) NULL DEFAULT NULL AFTER `id`;

CREATE TABLE IF NOT EXISTS `category_sman` (
  `user_id` bigint(16) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


ALTER TABLE `sman__category_translations` ADD `title` VARCHAR(50) NULL DEFAULT NULL AFTER `id`;

#====MIGRAGE ALL DB===4

copy 4 tables of country_mst, state_mst, location_mst, district_mst

#====MIGRAGE ALL DB===5 -- from here

ALTER TABLE `sman__smen_395005` CHANGE `completed_at` `completed_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE `sman__smen_395005` CHANGE `completed_at` `completed_at` TIMESTAMP NULL DEFAULT NULL;
#====MIGRAGE ALL DB===6