ALTER TABLE `evaluation_batches` 
ADD COLUMN `userType` VARCHAR(45) NOT NULL AFTER `semID`;

ALTER TABLE batches ADD COLUMN tcIssueDate varchar(50) DEFAULT NULL;

/** stthomas **/

select * from batches where batchID = 164;

if batchName = "TCISSUED"

delete from batches where batchID = 164;



/** vimala ***/

select * from batches where batchID = 65;

if batchName = "TCISSUED"

delete from batches where batchID = 65;




/** dgmmes **/

select * from batches where batchID = 10;

if batchName = "TCISSUED"

delete from batches where batchID = 10;





/** stjosephs ****/

select * from batches where batchID = 75;

if batchName = "TCISSUED"

delete from batches where batchID = 75;


