db - oracle.sql

来自「SQL Server 2005 对Native XML Web 服务的支持」· SQL 代码 · 共 40 行

DROP SEQUENCE seqItem;
CREATE SEQUENCE seqItem MINVALUE 1 MAXVALUE 1000000000 CYCLE;

DROP SEQUENCE seqReport;
CREATE SEQUENCE seqReport MINVALUE 1 MAXVALUE 1000000000 CYCLE;

DROP TABLE Item;
DROP TABLE Report;
DROP TABLE NextID;

CREATE TABLE Report (
  ID         INTEGER PRIMARY KEY,
  RVersion   VARCHAR2(255),
  RHost      VARCHAR2(255),
  RUser      VARCHAR2(255),
  RLocation  VARCHAR2(255),
  RDateTime  VARCHAR2(16),
  RComplete  NUMBER(1) NOT NULL
);

CREATE TABLE Item (
  ID         INTEGER PRIMARY KEY,
  IPage      VARCHAR2(100),
  IDevice    VARCHAR2(255),
  IGroup     VARCHAR2(255),
  IField     VARCHAR2(255),
  IValue     VARCHAR2(255),
  IIcon      INTEGER,
  IID        INTEGER,
  ReportID   INTEGER REFERENCES Report(ID)
);

CREATE TABLE NextID (
  TableName  VARCHAR2(6) PRIMARY KEY,
  NextID     INTEGER NOT NULL
);

INSERT INTO NextID (TableName, NextID) VALUES ('Item', 1);
INSERT INTO NextID (TableName, NextID) VALUES ('Report', 1);