sms.sql

来自「usb-com for sms 自己开发的类 可以借鉴下」· SQL 代码 · 共 55 行

/*==============================================================*/
/* Database name:  sms                                          */
/* DBMS name:      Microsoft SQL Server 2000                    */
/* Created on:     2004-11-8 17:12:43                           */
/*==============================================================*/


if exists (select 1
            from  sysobjects
           where  id = object_id('SMS')
            and   type = 'U')
   drop table SMS
go


if exists (select 1
            from  sysobjects
           where  id = object_id('SMSRecv')
            and   type = 'U')
   drop table SMSRecv
go


/*==============================================================*/
/* Table: SMS                                                   */
/*==============================================================*/
create table SMS (
   SysNo                int                  identity,
   CellNumber           nvarchar(13)         not null,
   SMSContent           nvarchar(70)         not null,
   Priority             int                  not null default 0,
   RetryCount           int                  not null default 0,
   CreateTime           datetime             not null default getdate(),
   HandleTime           datetime             null,
   Status               int                  not null default 0,
   constraint PK_SMS primary key  (SysNo)
)
go


/*==============================================================*/
/* Table: SMSRecv                                               */
/*==============================================================*/
create table SMSRecv (
   SysNo                int                  identity,
   CellNumber           nvarchar(13)         not null,
   SMSContent           nvarchar(70)         not null,
   SendTime             datetime             not null,
   HandleTime           datetime             not null default getdate(),
   constraint PK_SMSRECV primary key  (SysNo)
)
go