24th Aug,
alter table candidate_qualification modify column passing_year date;
alter table candidate_jobseeker add column intflag int(11);

23rd Aug,
alter table payroll_employee_master add column status1 varchar(11);

CREATE TABLE `final_requirement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `candidateid` int(11) NOT NULL,
  `status` varchar(100) NOT NULL,
  `note` varchar(255) NOT NULL,
  `cr_status` varchar(100) DEFAULT NULL,
  `cr_note` varchar(100) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(25) DEFAULT NULL,
  `status1` varchar(25) DEFAULT NULL,
  `acc_status` varchar(100) DEFAULT NULL,
  `acc_note` varchar(100) DEFAULT NULL,
  `intflag` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
);


CREATE TABLE `selection_procedure` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `candidateid` int(11) NOT NULL,
  `status` varchar(100) NOT NULL,
  `note` varchar(255) NOT NULL,
  `cr_status` varchar(100) DEFAULT NULL,
  `cr_note` varchar(100) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(25) DEFAULT NULL,
  `status1` varchar(25) DEFAULT NULL,
  `acc_status` varchar(100) DEFAULT NULL,
  `acc_note` varchar(100) DEFAULT NULL,
  `intflag` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
)


10th August
CREATE TABLE `interview` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `candidateid` int(11) NOT NULL,
  `status` varchar(100) NOT NULL,
  `note` varchar(255) NOT NULL,
  `cr_status` varchar(100) DEFAULT NULL,
  `cr_note` varchar(100) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(25) DEFAULT NULL,
  `status1` varchar(25) DEFAULT NULL,
  `acc_status` varchar(100) DEFAULT NULL,
  `acc_note` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
4th august 
CREATE TABLE `screening` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `candidateid` int(11) NOT NULL,
  `status` varchar(100) NOT NULL,
  `note` varchar(255) NOT NULL,
  `cr_status` varchar(100) DEFAULT NULL,
  `cr_note` varchar(100) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(25) DEFAULT NULL,
  `status1` varchar(25) DEFAULT NULL,
  `acc_status` varchar(100) DEFAULT NULL,
  `acc_note` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
)

22nd july
alter table candidate_qualification add column linenum int(11); 

21st april
alter table candidate_work_experience add column line_num int(11);
alter table candidate_jobseeker add column candidate_type varchar(255);
alter table candidate_work_experience modify column presentemployer varchar(100);

payroll_categories
payroll_employee_master
employee_leave
payroll_loans
payroll_monthly_salary
payroll_attendance_master
payroll_leave
payroll_rules
holidays_list
user -> users
employee
project -> table has been altered
project_notes -> added table
tasknotes added table
tasks
time_spent_in_task
time_spent_in_office
payroll_attendance_daily