CREATE TABLE CMVFS ( CMFNAM char (255), CMDTYP int , CMMODD int, CMWHOM char (50) NULL, CMDATA CLOB NULL ); ALTER TABLE CMVFS ADD ( PRIMARY KEY (CMFNAM) ); CREATE TABLE CMCHAB ( CMUSERID char (50) NULL , CMABID char (50) NULL , CMABPF int NULL , CMABTX CLOB NULL ); ALTER TABLE CMCHAB ADD ( PRIMARY KEY (CMUSERID,CMABID) ); CREATE TABLE CMSTAT ( CMSTRT int, CMENDT int, CMDATA CLOB NULL ); ALTER TABLE CMSTAT ADD ( PRIMARY KEY (CMSTRT) ); CREATE TABLE CMPOLL ( CMNAME char (100) , CMBYNM char (100) NULL , CMSUBJ char (255) NULL , CMDESC CLOB NULL , CMOPTN CLOB NULL , CMFLAG int NULL , CMQUAL char (255) NULL , CMRESL CLOB NULL, CMEXPI int NULL ); ALTER TABLE CMPOLL ADD ( PRIMARY KEY (CMNAME) ); CREATE TABLE CMCHAR ( CMCHID char (50), CMUSERID char (50), CMPASS char (50) NULL , CMCLAS char (200) NULL , CMSTRE int NULL , CMRACE char (50) NULL , CMDEXT int NULL , CMCONS int NULL , CMGEND char (50) NULL , CMWISD int NULL , CMINTE int NULL , CMCHAR int NULL , CMHITP int NULL , CMLEVL char (50) NULL , CMMANA int NULL , CMMOVE int NULL , CMDESC CLOB NULL , CMALIG int NULL , CMEXPE int NULL , CMEXLV int NULL , CMWORS char (50) NULL , CMPRAC int NULL , CMTRAI int NULL , CMAGEH int NULL , CMGOLD int NULL , CMWIMP int NULL , CMQUES int NULL , CMROID char (100) NULL , CMDATE char (50) NULL , CMCHAN int NULL , CMATTA int NULL , CMAMOR int NULL , CMDAMG int NULL , CMBTMP int NULL , CMLEIG char (50) NULL , CMHEIT int NULL , CMWEIT int NULL , CMPRPT char (250) NULL, CMCOLR char (100) NULL, CMLSIP char (100) NULL, CMEMAL char (255) NULL, CMPFIL CLOB NULL, CMSAVE char (150) NULL, CMMXML CLOB NULL ); ALTER TABLE CMCHAR ADD ( PRIMARY KEY (CMUSERID) ); CREATE TABLE CMCHFO ( CMUSERID char (50) NULL , CMFONM int NULL , CMFOID char (50) NULL , CMFOTX CLOB NULL , CMFOLV int NULL , CMFOAB int NULL ); ALTER TABLE CMCHFO ADD ( PRIMARY KEY (CMUSERID,CMFONM) ); CREATE TABLE CMCHCL ( CMUSERID char (50) NULL , CMCLAN char (100) NULL , CMCLRO int NULL, CMCLSTS char (100) NULL ); ALTER TABLE CMCHCL ADD ( PRIMARY KEY (CMUSERID,CMCLAN) ); CREATE TABLE CMCHIT ( CMUSERID char (50) NULL , CMITNM char (100) NULL , CMITID char (50) NULL , CMITTX CLOB NULL , CMITLO char (100) NULL , CMITWO int NULL , CMITUR int NULL , CMITLV int NULL , CMITAB int NULL , CMHEIT int NULL ); ALTER TABLE CMCHIT ADD ( PRIMARY KEY (CMUSERID,CMITNM) ); CREATE TABLE CMROCH ( CMROID char (50) NULL , CMCHNM char (100) NULL , CMCHID char (50) NULL , CMCHTX CLOB NULL , CMCHLV int NULL , CMCHAB int NULL , CMCHRE int NULL , CMCHRI char (100) NULL ); ALTER TABLE CMROCH ADD ( PRIMARY KEY (CMROID,CMCHNM) ); CREATE TABLE CMROEX ( CMROID char (50) NULL , CMDIRE int NULL , CMEXID char (50) NULL , CMEXTX CLOB NULL , CMNRID char (50) NULL ); ALTER TABLE CMROEX ADD ( PRIMARY KEY (CMROID,CMDIRE) ); CREATE TABLE CMROIT ( CMROID char (50) NULL , CMITNM char (100) NULL , CMITID char (50) NULL , CMITLO char (100) NULL , CMITTX CLOB NULL , CMITRE int NULL , CMITUR int NULL , CMITLV int NULL , CMITAB int NULL , CMHEIT int NULL ); ALTER TABLE CMROIT ADD ( PRIMARY KEY (CMROID,CMITNM) ); CREATE TABLE CMROOM ( CMROID char (50) NULL , CMLOID char (50) NULL , CMAREA char (50) NULL , CMDESC1 char (255) NULL , CMDESC2 CLOB NULL , CMROTX CLOB NULL ); ALTER TABLE CMROOM ADD ( PRIMARY KEY (CMROID) ); CREATE TABLE CMQUESTS ( CMQUESID char (50) NULL , CMQUTYPE char (50) NULL , CMQFLAGS int NULL , CMQSCRPT CLOB NULL , CMQWINNS CLOB NULL ); ALTER TABLE CMQUESTS ADD ( PRIMARY KEY (CMQUESID) ); CREATE TABLE CMAREA ( CMAREA char (50) , CMTYPE char (50) , CMCLIM int NULL , CMSUBS char (100) NULL , CMDESC CLOB NULL , CMROTX CLOB NULL , CMTECH int NULL ); ALTER TABLE CMAREA ADD ( PRIMARY KEY (CMAREA) ); CREATE TABLE CMJRNL ( CMJKEY char (75) , CMJRNL char (50) NULL , CMFROM char (50) NULL , CMDATE char (50) NULL , CMTONM char (50) NULL , CMSUBJ char (100) NULL , CMPART char (75) NULL , CMATTR int NULL, CMDATA char (255) NULL , CMUPTM number(20) NULL, CMIMGP char (50) NULL, CMVIEW int NULL, CMREPL int NULL, CMMSGT CLOB NULL ); ALTER TABLE CMJRNL ADD ( PRIMARY KEY (CMJKEY) ); CREATE INDEX CMJRNLNAME on CMJRNL (CMJRNL); CREATE INDEX CMJRNLCMPART on CMJRNL (CMPART); CREATE INDEX CMJRNLCMTONM on CMJRNL (CMTONM); CREATE INDEX CMJRNLCMUPTM on CMJRNL (CMUPTM); CREATE TABLE CMCLAN ( CMCLID char (100) , CMTYPE int , CMDESC CLOB NULL , CMACPT char (255) NULL , CMPOLI CLOB NULL , CMRCLL char (50) NULL , CMDNAT char (50) NULL , CMSTAT int NULL , CMMORG char (50) NULL , CMTROP int NULL ); ALTER TABLE CMCLAN ADD ( PRIMARY KEY (CMCLID) ); CREATE TABLE CMPDAT ( CMPLID char (100) , CMSECT char (100) , CMPKEY char (100) , CMPDAT CLOB NULL ); ALTER TABLE CMPDAT ADD ( PRIMARY KEY (CMPLID,CMSECT,CMPKEY) ); CREATE TABLE CMGRAC ( CMRCID char (50) , CMRDAT CLOB NULL ); ALTER TABLE CMGRAC ADD ( PRIMARY KEY (CMRCID) ); CREATE TABLE CMCCAC ( CMCCID char (50) , CMCDAT CLOB NULL ); ALTER TABLE CMCCAC ADD ( PRIMARY KEY (CMCCID) ); CREATE TABLE CMGAAC ( CMGAID char (50) , CMGAAT CLOB NULL , CMGACL char (50) NULL ); ALTER TABLE CMGAAC ADD ( PRIMARY KEY (CMGAID) ); CREATE TABLE CMACCT ( CMANAM char (50), CMPASS char (50), CMCHRS CLOB NULL, CMAXML CLOB NULL ); ALTER TABLE CMACCT ADD ( PRIMARY KEY (CMANAM) ); CREATE TABLE CMBKLG ( CMNAME char (50), CMINDX int, CMDATE number(20) NULL, CMDATA CLOB NULL ); ALTER TABLE CMBKLG ADD ( PRIMARY KEY (CMNAME,CMINDX) ); CREATE TABLE CMCLIT ( CMCLID char (100) , CMITNM char (100) , CMITID char (50) NULL , CMITTX CLOB NULL , CMITLO char (100) NULL , CMITWO int NULL , CMITUR int NULL , CMITLV int NULL , CMITAB int NULL , CMHEIT int NULL ); ALTER TABLE CMCLIT ADD ( PRIMARY KEY (CMCLID,CMITNM) );