create table messagesentbackup(
sn int NOT NULL AUTO_INCREMENT,
transid varchar(30) NOT NULL DEFAULT '',
username varchar(60) NOT NULL DEFAULT '',
phonenumber varchar(20) NOT NULL DEFAULT '',
sender varchar(20) NOT NULL DEFAULT '',
message varchar(1530) NOT NULL DEFAULT '',
messageID varchar(70) NOT NULL DEFAULT '',
status varchar(50) NOT NULL DEFAULT '',
result varchar(10) NOT NULL DEFAULT '',
failurereason varchar(70) NOT NULL DEFAULT '',
statuscode varchar(10) NOT NULL DEFAULT '',
failurecode varchar(10) NOT NULL DEFAULT '',
sentcode varchar(10) NOT NULL DEFAULT '',
billcode varchar(10) NOT NULL DEFAULT '',
amtcharged varchar(10) NOT NULL DEFAULT '',
mcount int NOT NULL DEFAULT 0,
route varchar(10) NOT NULL DEFAULT '',
MCCMNC varchar(10) NOT NULL DEFAULT '',
messtype varchar(10) NOT NULL DEFAULT '',
track varchar(1) not null default "",
domain varchar(30) NOT NULL DEFAULT '',
dateused datetime NOT NULL DEFAULT '2014/10/18 00:00:00',
Primary key (sn )
)ENGINE=InnoDB;


create table MessageStatusbackup(
sn int NOT NULL AUTO_INCREMENT,
username varchar(60) NOT NULL DEFAULT '',
MessageID varchar(80) NOT NULL DEFAULT '',
MessageState varchar(10) NOT NULL DEFAULT '',
NetworkError varchar(10) NOT NULL DEFAULT '',
status varchar(1) NOT NULL DEFAULT '',
datesent datetime NOT NULL DEFAULT '2014/10/18 00:00:00',
Primary key (sn )
)ENGINE=InnoDB;




                                                                                                                                        insert into messagesentbackup (username, transid, track, statuscode, status, sentcode,sender,route, result, phonenumber, messtype, messageID, message, mcount,MCCMNC,failurereason, failurecode, domain, dateused,billcode, amtcharged 
) select username, transid, track, statuscode, status, sentcode,sender,route, result, phonenumber, messtype, messageID, message, mcount,MCCMNC,failurereason, failurecode, domain, dateused,billcode, amtcharged 
 from messagesent where sn =41;




DELIMITER //
CREATE PROCEDURE BackupMessagesent(

IN serial  varchar(100))

BEGIN
   insert into messagesentbackup (username, transid, track, 

statuscode, status, sentcode,sender,route, result, phonenumber, 

messtype, messageID, message, mcount,MCCMNC,failurereason, 

failurecode, domain, dateused,billcode, amtcharged 
) select 

username, transid, track, statuscode, status, 

sentcode,sender,route, result, phonenumber, messtype, messageID, 

message, mcount,MCCMNC,failurereason, failurecode, domain, 

dateused,billcode, amtcharged 
 from messagesent where sn =serial;

 
END//
DELIMITER ;







DELIMITER //
CREATE PROCEDURE DeleteMessagesent(

IN serial  varchar(100))

BEGIN
   DELETE from messagesent where sn = serial;
 
END//
DELIMITER ;


INSERT INTO messagestatusbackup  (username,MessageID,MessageState,NetworkError, status,datesent) 
 select username,MessageID,MessageState,NetworkError, status,datesent from messagestatus where sn = 32;









DELIMITER //
CREATE PROCEDURE BackupMessagestatus(

IN serial  varchar(100))

BEGIN
   
INSERT INTO messagestatusbackup  (username,MessageID,MessageState,NetworkError, status,datesent) 
 select username,MessageID,MessageState,NetworkError, status,datesent from messagestatus where sn =serial;

 
END//
DELIMITER ;







DELIMITER //
CREATE PROCEDURE DeleteMessagestatus(

IN serial  varchar(100))

BEGIN
   DELETE from messagestatus where sn = serial;
 
END//
DELIMITER ;