testq.sql

SMS gateway. SMS protocol for CHINA mobile, unicom, lingtong. Using mysql to exchange message.

INSERT INTO MO_Queue
  (Id, SrcNode, SrcRecvTime, SrcMsgId, DestNode, ScheduleTime, Result, RelayTimes, Total_Length, Sequence_Id, Msg_Id, Dest_Id, Service_Id, TP_pid, TP_udhi, Msg_Fmt, Src_terminal_Id, Registered_Delivery, Msg_Length, Msg_Content, Reserved)
VALUES
  (27, "101", "20031020094744", -4962135455477979478, 638805, "20031020 195044", -2, 0, 88, 1067161322, -4962135455477979478, "638805", "0000", 0, 0, 0, "13535326253", 0, 7, "testing", "        ");

INSERT INTO MO_Queue
  (Id, SrcNode, SrcRecvTime, SrcMsgId, DestNode, ScheduleTime, Result, RelayTimes, Total_Length, Sequence_Id, Msg_Id, Dest_Id, Service_Id, TP_pid, TP_udhi, Msg_Fmt, Src_terminal_Id, Registered_Delivery, Msg_Length, Msg_Content, Reserved)
VALUES
  (27, "101", "20031020094744", -4962135455477979478, 638806, "20031020 195044", -2, 0, 88, 1067161322, -4962135455477979478, "638806", "0000", 0, 0, 0, "13535326253", 0, 7, "testing", "        ");

INSERT INTO MO_Queue
  (Id, SrcNode, SrcRecvTime, SrcMsgId, DestNode, ScheduleTime, Result, RelayTimes, Total_Length, Sequence_Id, Msg_Id, Dest_Id, Service_Id, TP_pid, TP_udhi, Msg_Fmt, Src_terminal_Id, Registered_Delivery, Msg_Length, Msg_Content, Reserved)
VALUES
  (27, "101", "20031020094744", -4962135455477979478, 638807, "20031020 195044", -2, 0, 88, 1067161322, -4962135455477979478, "638807", "0000", 0, 0, 0, "13535326253", 0, 7, "testing", "        ");


INSERT INTO MT_Queue
  (Id, SrcNode, SrcRecvTime, MsgID_Echo, DestNode, ScheduleTime, Result, RelayTimes, Protocol, Total_Length, Sequence_Id, Pk_total, Pk_number, Registered_Delivery, Msg_level, Service_Id, Fee_UserType, Fee_terminal_Id, Tp_pId, Tp_udhi, Msg_Fmt, Msg_src, FeeType, FeeCode, Valid_Time, At_Time, Src_Id, DestUsr_tl, Dest_terminal_Id, Msg_Length, Msg_Content, Reserved, MsgType, FixedFee)
VALUES
  (6, "638805", "20031023150625", 1066822188, 101, "20031023 151027", -1, 1, 0, 240, 1423, 1, 1, 1, 0, "MFXX", 2, "", 1, 0, 15, "900028", "03", "000800", "", "", "638805", 1, "13535326253", 7, "testing", "        ", 0, "");

INSERT INTO MT_Queue
  (Id, SrcNode, SrcRecvTime, MsgID_Echo, DestNode, ScheduleTime, Result, RelayTimes, Protocol, Total_Length, Sequence_Id, Pk_total, Pk_number, Registered_Delivery, Msg_level, Service_Id, Fee_UserType, Fee_terminal_Id, Tp_pId, Tp_udhi, Msg_Fmt, Msg_src, FeeType, FeeCode, Valid_Time, At_Time, Src_Id, DestUsr_tl, Dest_terminal_Id, Msg_Length, Msg_Content, Reserved, MsgType, FixedFee)
VALUES
  (7, "638806", "20031023150625", 1066822188, 101, "20031023 151027", -1, 1, 0, 240, 1423, 1, 1, 1, 0, "MFXX", 2, "", 1, 0, 15, "900028", "03", "000800", "", "", "638806", 1, "13535326253", 7, "testing", "        ", 0, "");

INSERT INTO MT_Queue
  (Id, SrcNode, SrcRecvTime, MsgID_Echo, DestNode, ScheduleTime, Result, RelayTimes, Protocol, Total_Length, Sequence_Id, Pk_total, Pk_number, Registered_Delivery, Msg_level, Service_Id, Fee_UserType, Fee_terminal_Id, Tp_pId, Tp_udhi, Msg_Fmt, Msg_src, FeeType, FeeCode, Valid_Time, At_Time, Src_Id, DestUsr_tl, Dest_terminal_Id, Msg_Length, Msg_Content, Reserved, MsgType, FixedFee)
VALUES
  (8, "638807", "20031023150625", 1066822188, 101, "20031023 151027", -1, 1, 0, 240, 1423, 1, 1, 1, 0, "MFXX", 2, "", 1, 0, 15, "900028", "03", "000800", "", "", "638807", 1, "13535326253", 7, "testing", "        ", 0, "");