搭建短信服务器

ORCL172 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.51.172)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RDPCS) ) )

create table MSG_FAILEDBOX ( ID NUMBER not null, OriginMsgID NUMBER not null, ExpressLevel NUMBER default 2 not null , Sender VARCHAR2(100), Receiver VARCHAR2(200) not null, MsgType NUMBER not null, MsgTitle VARCHAR2(500), MMSContentLocation VARCHAR2(500), SendTime DATE default SYSDATE not null, CommPort NUMBER not null, ActualSendTime DATE not null, FailedReason VARCHAR2(500) ); alter table MSG_FAILEDBOX add constraint MSG_FAILEDBOX_PK11075707620945 primary key (ID) using index pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); create table MSG_INBOX ( ID NUMBER not null, Sender VARCHAR2(100) not null, MsgType NUMBER not null, MsgTitle VARCHAR2(500), MMSUrl VARCHAR2(200), MMSContentLocation VARCHAR2(4000), MsgArrivedTime DATE not null, MMSDownloadedTime DATE, MMSDownloadedState NUMBER default 0 not null , CommPort NUMBER not null ); alter table MSG_INBOX add constraint MSG_INBOX_PK21075710238559 primary key (ID) using index pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); create table MSG_OUTBOX ( MsgID NUMBER not null, ExpressLevel NUMBER default 2 not null , Sender VARCHAR2(100), Receiver VARCHAR2(200) not null, MsgType NUMBER default 1 not null , MsgTitle VARCHAR2(500), MMSContentLocation VARCHAR2(500), SendTime DATE default SYSDATE not null, CommPort NUMBER default 0 not null ); alter table MSG_OUTBOX add constraint MSG_OUTBOX_PK21075710226041 primary key (MsgID) using index pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); create table MSG_SENTBOX ( ID NUMBER not null, OriginMsgID NUMBER not null, ExpressLevel NUMBER not null, Sender VARCHAR2(100), Receiver VARCHAR2(200) not null, MsgType NUMBER not null, MsgTitle VARCHAR2(500), MMSContentLocation VARCHAR2(500), SendTime DATE not null, CommPort NUMBER not null, ActualSendTime DATE not null, ReceiveMMSTime DATE, MMSMessageID VARCHAR2(200) ); alter table MSG_SENTBOX add constraint MSG_SENTBOX_PK21075710226041 primary key (ID) using index pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); create sequence MSG_FAILEDBOX_ID_SEQ minvalue 1 maxvalue 999999999 start with 81 increment by 1 cache 20; create sequence MSG_INBOX_ID_SEQ minvalue 1 maxvalue 999999999 start with 81 increment by 1 cache 20; create sequence MSG_OUTBOX_ID_SEQ minvalue 1 maxvalue 999999999 start with 141 increment by 1 cache 20; create sequence MSG_SENTBOX_ID_SEQ minvalue 1 maxvalue 999999999 start with 81 increment by 1 cache 20; CREATE OR REPLACE TRIGGER "SET_MSG_FAILEDBOX_ID" BEFORE INSERT ON "MSG_FAILEDBOX" FOR EACH ROW DECLARE NEXT_MSG_FAILEDBOX_ID NUMBER; BEGIN SELECT MSG_FAILEDBOX_ID_SEQ.NEXTVAL INTO NEXT_MSG_FAILEDBOX_ID FROM DUAL; :NEW.ID := NEXT_MSG_FAILEDBOX_ID; END; / CREATE OR REPLACE TRIGGER "SET_MSG_INBOX_ID" BEFORE INSERT ON "MSG_INBOX" FOR EACH ROW DECLARE NEXT_MSG_INBOX_ID NUMBER; BEGIN SELECT MSG_OUTBOX_ID_SEQ.NEXTVAL INTO NEXT_MSG_INBOX_ID FROM DUAL; :NEW.ID := NEXT_MSG_INBOX_ID; END; / CREATE OR REPLACE TRIGGER "SET_MSG_OUTBOX_ID" BEFORE INSERT ON "MSG_OUTBOX" FOR EACH ROW DECLARE NEXT_MSG_OUTBOX_ID NUMBER; BEGIN SELECT MSG_OUTBOX_ID_SEQ.NEXTVAL INTO NEXT_MSG_OUTBOX_ID FROM DUAL; :NEW.MsgID := NEXT_MSG_OUTBOX_ID; END; / CREATE OR REPLACE TRIGGER "SET_MSG_SENTBOX_ID" BEFORE INSERT ON "MSG_SENTBOX" FOR EACH ROW DECLARE NEXT_MSG_SENTBOX_ID NUMBER; BEGIN SELECT MSG_SENTBOX_ID_SEQ.NEXTVAL INTO NEXT_MSG_SENTBOX_ID FROM DUAL; :NEW.ID := NEXT_MSG_SENTBOX_ID; END; / commit;