xm32.ddl

来自「软件开发技术与方法」· DDL 代码 · 共 65 行

CONNECT TO XM32;
------------------------------------------------
-- DDL Statements for table "TEST"
------------------------------------------------
 
 CREATE TABLE "TEST"  (
		  "EXAMID" VARCHAR(30) NOT NULL , 
		  "DESCRIPTION" VARCHAR(254) , 
		  "COMMENTS" VARCHAR(254) )   ;


-- DDL Statements for primary key on Table "TEST"

ALTER TABLE "TEST" 
	ADD CONSTRAINT "TESTPK" PRIMARY KEY
		("EXAMID");


------------------------------------------------
-- DDL Statements for table "QUESTION"
------------------------------------------------
 
 CREATE TABLE "QUESTION"  (
		  "QUESTIONID" INTEGER NOT NULL , 
		  "QUESTTEXT" VARCHAR(254) , 
		  "COMMENT" VARCHAR(254) , 
          "ALLOWMULT" CHAR(3),
		  "EXAMID" VARCHAR(30) NOT NULL ) ; 

-- DDL Statements for primary key on Table "QUESTION"

ALTER TABLE "QUESTION" 
	ADD PRIMARY KEY
		("EXAMID","QUESTIONID");


------------------------------------------------
-- DDL Statements for table "CHOICE"
------------------------------------------------
 
 CREATE TABLE "CHOICE"  (
--  "EXAMID" VARCHAR(30)  ,
		  "ID" char(1) NOT NULL , 
		  "QUESTIONID" INTEGER NOT NULL , 
		  "CORRECT" CHAR(3), 
		  "CHOICETEXT" VARCHAR(254)   );
		 

-- DDL Statements for primary key on Table "CHOICE"

ALTER TABLE "CHOICE" 
  	ADD PRIMARY KEY
		("QUESTIONID","ID");


import from test.ixf of ixf insert into test;
import from question.ixf of ixf insert into question;
import from choice.ixf of ixf insert into choice;

COMMIT WORK;

CONNECT RESET;

TERMINATE;