· 8 years ago · Jul 15, 2018, 04:32 AM
1CREATE TABLE `NGMP_OLTP`.`MT_Routing_Info` (
2 `Message_Id` varchar(70) CHARACTER SET latin1 NOT NULL,
3 `Route_Id` int(10) DEFAULT NULL,
4 `Spf_Short_Code` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
5 `Network_Search_Option` smallint(5) DEFAULT NULL,
6 `Priority` int(10) DEFAULT NULL,
7 `Charge_Code` varchar(64) CHARACTER SET latin1 DEFAULT NULL,
8 `Barred` varchar(1) CHARACTER SET latin1 DEFAULT NULL,
9 `Dynamic_Spoofing` varchar(1) CHARACTER SET latin1 DEFAULT NULL,
10 `AV_Required` varchar(1) CHARACTER SET latin1 DEFAULT NULL,
11 `AV_Status` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
12 `Price_Point` int(10) DEFAULT NULL,
13 `NW_Connector_Id` int(10) DEFAULT NULL,
14 `Sent_Time` datetime DEFAULT NULL,
15 `Operator_Id` int(10) DEFAULT NULL,
16 `Short_Code` varchar(15) CHARACTER SET utf8 DEFAULT NULL,
17 `Service_Id` int(10) DEFAULT NULL,
18 `SMPP_BIND_ID` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
19 `Frgtotal` int(11) DEFAULT '0',
20 PRIMARY KEY (`Message_Id`),
21 KEY `IX_MT_Routing_Info` (`Message_Id`)
22) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
23
24DELIMITER $$
25DROP PROCEDURE IF EXISTS `NGMP_OLTP`.`usp_UpdateMTRouting_Info` $$
26CREATE DEFINER=`root`@`localhost` PROCEDURE `usp_UpdateMTRouting_Info`(
27 msgid varchar(50),
28 senttime varchar(30),
29 routeid varchar(32),
30 operid varchar(32),
31 scode nvarchar(15),
32 spfsc varchar(32),
33 nwopt varchar(16),
34 prty varchar(32),
35 ccode varchar(64),
36 barred varchar(1),
37 dynspf varchar(1),
38 svcid varchar(32),
39 prpt varchar(32),
40 avreqd varchar(1),
41 avstat varchar(20),
42 nwconid varchar(32),
43 tsstr varchar(2000),
44 isfinalstr varchar(200),
45 idstr varchar(200) ,
46 bindid varchar(100)
47
48)
49BEGIN
50 if routeid = '' then set routeid = null; end if;
51 if operid = '' then set operid = null; end if;
52 if nwopt = '' then set nwopt = null; end if;
53 if prty = '' then set prty = null; end if;
54 if svcid = '' then set svcid = null; end if;
55 if prpt = '' then set prpt = null; end if;
56 if nwconid = '' then set nwconid = null; end if;
57 if bindid = '' then set bindid = null; end if;
58 UPDATE MT_Routing_Info SET
59 Route_Id = routeid,
60 Spf_Short_Code = spfsc,
61 Network_Search_Option = nwopt,
62 Priority = prty,
63 Charge_Code = ccode,
64 Barred = barred,
65 Dynamic_Spoofing = dynspf,
66 AV_Required = avreqd,
67 AV_Status = avstat,
68 Price_Point = prpt,
69 NW_Connector_Id = nwconid,
70 Sent_Time=senttime,
71 Operator_Id = operid,
72 Short_Code = scode,
73 Service_Id = svcid,
74 SMPP_BIND_ID=bindid
75 WHERE Message_Id = msgid;
76 Call usp_SaveMsgProcStatus (msgid, tsstr, ',', isfinalstr, ',', idstr, ',');
77 END $$
78 DELIMITER ;
79
80Type Name Status
81 ndbcluster connection cluster_node_id=5, connected_host=10.5.20.46,
82 connected_port=1186, number_of_data_nodes=2, number_of_ready_data_nodes=2, connect_count=0
83 ndbcluster NdbTransaction created=2, free=2, sizeof=224
84 ndbcluster NdbOperation created=4, free=4, sizeof=756
85 ndbcluster NdbIndexScanOperation created=0, free=0, sizeof=888
86 ndbcluster NdbIndexOperation created=0, free=0, sizeof=760
87 ndbcluster NdbRecAttr created=0, free=0, sizeof=64
88 ndbcluster NdbApiSignal created=16, free=16, sizeof=136
89 ndbcluster NdbLabel created=0, free=0, sizeof=196
90 ndbcluster NdbBranch created=0, free=0, sizeof=24
91 ndbcluster NdbSubroutine created=0, free=0, sizeof=68
92 ndbcluster NdbCall created=0, free=0, sizeof=16
93 ndbcluster NdbBlob created=0, free=0, sizeof=344
94 ndbcluster NdbReceiver created=0, free=0, sizeof=92
95 ndbcluster NdbLockHandle created=0, free=0, sizeof=32
96 ndbcluster binlog latest_epoch=1412576088948745, latest_trans_epoch=1412541729210383, latest_received_binlog_epoch=0, latest_handled_binlog_epoch=0, latest_applied_binlog_epoch=0