init_data.sql

使用短信猫可以实现短信的群发

/*
功能：初始化用户表
2008 1.18 jxx
*/
DELETE SENDLOG;
DELETE PHONENUMBER;
DELETE RECEIVEDLOG;
DELETE ORDERS;
DELETE USERS;

/*
插入订单
*/
insert into ORDERS (ID, ORDERSTART, ORDEREND, CONTENT)
values (ORDERSEQ.NEXTVAL, to_date('27-02-2008 19:15:04', 'dd-mm-yyyy hh24:mi:ss'), to_date('28-02-2008 19:57:12', 'dd-mm-yyyy hh24:mi:ss'), 'test');
commit;

/*
插入电话号码
*/
insert into PHONENUMBER (ID, ORDERID, PNUMBER)
values (PNUMBERSEQ.NEXTVAL, 1, '8613959124953');
insert into PHONENUMBER (ID, ORDERID, PNUMBER)
values (PNUMBERSEQ.NEXTVAL, 1, '8615980275884');
commit;

/*
插入接收日志
*/

insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'FDSF FDSFDS' || chr(13) || '' || chr(10) || 'FDSFDS', to_date('27-02-2008 18:45:56', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', '432432432432432', to_date('27-02-2008 18:48:06', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'fdsfdsfds', to_date('27-02-2008 19:01:45', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'fdsfdsfdsds', to_date('27-02-2008 19:17:32', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'rewrewrew', to_date('27-02-2008 19:17:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'rere', to_date('27-02-2008 19:17:39', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'w', to_date('27-02-2008 19:18:01', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'rere', to_date('27-02-2008 19:17:41', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'sfdsfd', to_date('27-02-2008 19:25:12', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'fdsfdsfds', to_date('27-02-2008 20:04:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'fdsfdsfds', to_date('27-02-2008 20:09:44', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'aaaaaaaaaaaa', to_date('27-02-2008 22:42:15', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', 'test', to_date('27-02-2008 22:44:23', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', '22222222222222222', to_date('27-02-2008 22:45:37', 'dd-mm-yyyy hh24:mi:ss'));
insert into RECEIVEDLOG (ID, PEERNUMBER, REPLYCONTENT, REPLYTIME)
values (RECEIVEDSEQ.NEXTVAL, '1252013950480297', '33333333333333', to_date('27-02-2008 22:45:40', 'dd-mm-yyyy hh24:mi:ss'));
commit;

/*
插入发送日志
*/

insert into SENDLOG (ID, ORDERID, SENDTIME, STATE, PNUMBER)
values (SENDSEQ.NEXTVAL, 1, to_date('27-02-2008 19:15:04', 'dd-mm-yyyy hh24:mi:ss'), 1, '8613959124953');
insert into SENDLOG (ID, ORDERID, SENDTIME, STATE, PNUMBER)
values (SENDSEQ.NEXTVAL, 1, to_date('27-02-2008 19:15:44', 'dd-mm-yyyy hh24:mi:ss'), 1, '8615980275884');

commit;

/*
插入用户
*/

insert into USERS (ID, USERNAME, PASSWD, AUTHORITY, CREATETIME)
values (SEQ.NEXTVAL, 'admin', '123', 0, to_date('27-02-2008 19:02:00', 'dd-mm-yyyy hh24:mi:ss'));
insert into USERS (ID, USERNAME, PASSWD, AUTHORITY, CREATETIME)
values (SEQ.NEXTVAL, 'test', 'test', 1, to_date('27-02-2008 19:31:00', 'dd-mm-yyyy hh24:mi:ss'));
commit;