fangsoft_testcenter-oracle9i.sql

来自「纯JAVA代码的考试系统」· SQL 代码 · 共 19 行

DROP TABLE "TEST" CASCADE CONSTRAINTS;
--drop sequence -
DROP SEQUENCE "SEQ_TEST" ;
--create table--
CREATE TABLE "TEST"
  ("TT_ID" INTEGER NOT NULL,
   "TT_NAME" VARCHAR2(80) NOT NULL,
   "TT_NUMQUESTION" INTEGER NOT NULL,
   "TT_TIMELIMITMIN" INTEGER NOT NULL,
   "TT_DESCRIPTION" VARCHAR2(255) NULL,
   "TT_SCORE" INTEGER NULL,
   "TT_TYPE" VARCHAR2(255) NULL);

ALTER TABLE "TEST"
  ADD CONSTRAINT "PK_TEST" PRIMARY KEY ("TT_ID");

--create sequence--
CREATE SEQUENCE "SEQ_TEST" INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE CACHE 10 ;
commit;