
alter table proctor_details add column modifydate datetime;

alter table setup add column trans_seqit2 double precision;

alter table proctors add column insertdate datetime;
alter table proctor_details add column insertdate datetime;
update proctors set insertdate='2017-12-31 9:30';
update proctor_details set insertdate='2017-12-31 9:30';
alter table proctor_details add column detailseq2 varchar(15);
alter table proctor_details add column detailapproved2 boolean;
alter table setup add column trans_seq2 double precision;

1-change year on setup to be 2018
2-create user 9999 