insert_data.sql

来自「通过串口连接短信猫进行短信的群发、单发、接收；管理群发订单、用户账户等」· SQL 代码 · 共 20 行

delete from T_ReceivedLog ;
delete from T_SendLog ;
delete from T_PhoneNumber ;
delete from T_Users ;
delete from T_Orders ;

commit;

insert into T_Users(UserID,UserName,UserPassword,UserAuthority,UserCreateTime) 
values (TUserID_SEQ.Nextval, 'admin', '123', 0,SYSDATE);

COMMIT;

insert into T_Users(UserID,UserName,UserPassword,UserAuthority,UserCreateTime) 
values (TUserID_SEQ.Nextval, 'test', 'test', 1,SYSDATE);

COMMIT;