alter table test_fees add delete_status int
alter table test_accounting add student enum('yes','no')
alter table test_upload_document add working_hour int,add file_size int, add No_of_files int;
CREATE TABLE IF NOT EXISTS `test_emi` (
`id` int NOT NULL AUTO_INCREMENT,
`loan_id` int DEFAULT NULL,
`month` varchar(100) DEFAULT NULL,
`emi_number` int DEFAULT NULL,
`status` varchar(50) DEFAULT NULL,
`updated_date` varchar(100) DEFAULT NULL,
`created_date` varchar(100) DEFAULT NULL,
`salary_id` varchar(100) DEFAULT NULL,
`interest` varchar(100) DEFAULT NULL,
`emi_amount` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,delete_status int,
PRIMARY KEY (`id`)
)
ALTER TABLE test_laon ADD COLUMN created_date varchar(100),updated_date(100);
ALTER TABLE test_advance_salary ADD COLUMN created_date varchar(100),updated_date(100),salary_id int;
create table sms.test_student_verification (id int not null auto_increment , student_id int , random_id varchar(50),status enum('used','not used'),primary key(id));
CREATE TABLE `test_work_description` (
  `id` int NOT NULL AUTO_INCREMENT,
  `work_description` text,
  `teacher_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `create_date` varchar(50) DEFAULT NULL,
  `delete` varchar(50) DEFAULT NULL,
  `class_id` int DEFAULT NULL,
  `section_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;