| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/New folder/New folder/software/Services/MessageStatusCPP/MessageStatusCPP/Release/ |
Upload File : |
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 ;