create_table.sql

来自「使用短信猫可以实现短信的群发」· SQL 代码 · 共 86 行

/*==============================================================*/
/* DBMS name:      ORACLE Version 9i2                           */
/* Created on:     2008-1-17 14:52:00                           */
/*==============================================================*/


alter table PHONENUMBER
   drop constraint FK_P_ORDERS;

alter table SENDLOG
   drop constraint FK_U_ORDERS;

drop table ORDERS cascade constraints;

drop table PHONENUMBER cascade constraints;

drop table RECEIVEDLOG cascade constraints;

drop table SENDLOG cascade constraints;

drop table USERS cascade constraints;

/*==============================================================*/
/* Table: ORDERS                                                */
/*==============================================================*/
create table ORDERS  (
   ID                   INT                             not null,
   ORDERSTART           DATE,
   ORDEREND             DATE,
   CONTENT              VARCHAR2(140),
   constraint PK_ORDERS primary key (ID)
)
  tablespace SMS;

/*==============================================================*/
/* Table: PHONENUMBER                                           */
/*==============================================================*/
create table PHONENUMBER  (
   ID                   INT                             not null,
   ORDERID              INT,
   PNUMBER             VARCHAR2(30),
   constraint PK_PHONENUMBER primary key (ID)
)
  tablespace SMS;

/*==============================================================*/
/* Table: RECEIVEDLOG                                           */
/*==============================================================*/
create table RECEIVEDLOG  (
   ID                   INT                             not null,
   PEERNUMBER           VARCHAR2(24),
   REPLYCONTENT         VARCHAR2(140),
   REPLYTIME            DATE,
   constraint PK_RECEIVEDLOG primary key (ID)
)
  tablespace SMS;

/*==============================================================*/
/* Table: SENDLOG                                               */
/*==============================================================*/
create table SENDLOG  (
   ID                   INT                             not null,
   ORDERID              INT                             not null,
   SENDTIME             DATE,
   STATE                INT,
   PNUMBER             VARCHAR2(30),
   constraint PK_SENDLOG primary key (ID)
)
  tablespace SMS;

/*==============================================================*/
/* Table: USERS                                                 */
/*==============================================================*/
create table USERS  (
   ID                   INT                             not null,
   USERNAME             VARCHAR2(20),
   PASSWD               VARCHAR2(20),
   AUTHORITY            INT,
   CREATETIME           DATE,
   constraint PK_USERS primary key (ID)
)
  tablespace SMS;