Dropping all tables 318ms DONE INFO Preparing database. Creating migration table 11ms DONE INFO Running migrations. 2013_08_27_182409_create_company_categories_table 33ms DONE 2013_09_27_181843_create_companies_table 58ms DONE 2013_09_28_143000_create_users_table 249ms DONE 2013_09_28_143001_create_affiliates_table 216ms DONE 2013_09_28_143001_create_folders_table 185ms DONE 2013_09_28_143001_create_organizations_table 135ms DONE 2013_09_28_143002_create_files_table 186ms DONE 2013_09_28_143003_create_contacts_table 309ms DONE 2013_09_28_143100_create_area_structures_table 91ms DONE 2013_09_28_143200_create_areas_table 139ms DONE 2013_11_28_151854_create_lead_sources_table 184ms DONE 2014_10_12_100000_create_password_reset_tokens_table 6ms DONE 2016_06_01_000001_create_oauth_auth_codes_table 28ms DONE 2016_06_01_000002_create_oauth_access_tokens_table 28ms DONE 2016_06_01_000003_create_oauth_refresh_tokens_table 31ms DONE 2016_06_01_000004_create_oauth_clients_table 43ms DONE 2016_06_01_000005_create_oauth_personal_access_clients_table 6ms DONE 2019_08_19_000000_create_failed_jobs_table 31ms DONE 2019_12_14_000001_create_personal_access_tokens_table 38ms DONE 2024_11_27_184323_create_countries_table 7ms DONE 2024_11_27_184400_create_campaigns_table 260ms DONE 2024_11_27_184449_create_customers_table 312ms DONE 2024_11_27_184558_create_designations_table 189ms DONE 2024_11_27_185255_create_designation_logs_table 220ms DONE 2024_11_27_191301_create_divisions_table 55ms DONE 2024_11_27_191321_create_districts_table 49ms DONE 2024_11_27_191403_create_upazilas_table 44ms DONE 2024_11_27_191420_create_unions_table 40ms DONE 2024_11_27_191501_create_villages_table 7ms DONE 2024_11_29_023201_create_user_reportings_table 207ms DONE 2024_12_02_134150_create_product_units_table 177ms DONE 2024_12_03_135550_create_vat_settings_table 162ms DONE 2024_12_03_145550_create_category_types_table 185ms DONE 2024_12_03_145550_create_measurment_units_table 207ms DONE 2024_12_04_124816_create_product_categories_table 340ms DONE 2024_12_04_124816_create_product_sub_categories_table 366ms DONE 2024_12_04_125211_create_products_table 510ms DONE 2024_12_04_133507_create_product_images_table 172ms DONE 2024_12_04_133540_create_product_videos_table 158ms DONE 2025_01_30_174720_create_lead_categories_table 166ms DONE 2025_01_30_174737_create_leads_table 581ms DONE 2025_01_30_175258_create_followups_table 278ms DONE 2025_01_30_175328_create_lead_products_table 441ms DONE 2025_02_11_143511_create_sales_table 689ms DONE 2025_02_11_161112_create_general_settings_table 46ms DONE 2025_11_27_174649_create_lead_contacts_table 260ms DONE 2025_11_28_024822_create_contact_addresses_table 130ms DONE 2025_11_28_104609_create_sales_products_table 533ms DONE 2025_12_03_163647_create_opinions_table 148ms DONE 2025_12_06_123032_create_sales_users_table 199ms DONE 2025_12_18_041956_create_banks_table 217ms DONE 2025_12_19_174901_create_accounts_table 248ms DONE 2025_12_20_042033_create_payment_reasons_table 161ms DONE 2025_12_20_051046_create_sales_payment_schedules_table 203ms DONE 2025_12_20_051119_create_transactions_table 217ms DONE 2025_12_20_051429_create_sales_payments_table 312ms DONE 2025_12_27_031858_create_permissions_table 24ms DONE 2025_12_27_031906_create_designation_permissions_table 80ms DONE 2026_01_03_183431_create_user_salaries_table 1ms FAIL Illuminate\Database\QueryException SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'after `effective_date`, `is_active` tinyint(1) not null default '1' comment '...' at line 1 (Connection: mysql, SQL: create table `user_salaries` (`id` bigint unsigned not null auto_increment primary key, `uuid` char(36) not null, `company_id` bigint unsigned not null, `user_id` bigint unsigned not null, `gross_salary` decimal(12, 2) not null default '0', `effective_date` date not null comment 'When this salary starts', `end_date` date null comment 'When this salary ends (NULL means current)' after `effective_date`, `is_active` tinyint(1) not null default '1' comment 'Only one active salary per user at a time', `increment_reason` varchar(255) null comment 'Initial, Annual Increment, Promotion, etc.', `created_by` bigint unsigned null, `updated_by` bigint unsigned null, `deleted_by` bigint unsigned null, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') at vendor\laravel\framework\src\Illuminate\Database\Connection.php:829 825Ôûò $this->getName(), $query, $this->prepareBindings($bindings), $e 826Ôûò ); 827Ôûò } 828Ôûò Ô×£ 829Ôûò throw new QueryException( 830Ôûò $this->getName(), $query, $this->prepareBindings($bindings), $e 831Ôûò ); 832Ôûò } 833Ôûò } 1 vendor\laravel\framework\src\Illuminate\Database\Connection.php:581 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'after `effective_date`, `is_active` tinyint(1) not null default '1' comment '...' at line 1") 2 vendor\laravel\framework\src\Illuminate\Database\Connection.php:581 PDO::prepare("create table `user_salaries` (`id` bigint unsigned not null auto_increment primary key, `uuid` char(36) not null, `company_id` bigint unsigned not null, `user_id` bigint unsigned not null, `gross_salary` decimal(12, 2) not null default '0', `effective_date` date not null comment 'When this salary starts', `end_date` date null comment 'When this salary ends (NULL means current)' after `effective_date`, `is_active` tinyint(1) not null default '1' comment 'Only one active salary per user at a time', `increment_reason` varchar(255) null comment 'Initial, Annual Increment, Promotion, etc.', `created_by` bigint unsigned null, `updated_by` bigint unsigned null, `deleted_by` bigint unsigned null, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci'")