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 ( CMUSERID char (50) NULL , 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 char (255) 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, CMCLAN char (100) NULL, CMCLRO integer 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 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 , 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 (50) , CMJRNL char (50) NULL , CMFROM char (50) NULL , CMDATE char (50) NULL , CMTONM char (50) NULL , CMSUBJ char (100) NULL , CMMSGT CLOB NULL ); ALTER TABLE CMJRNL ADD ( PRIMARY KEY (CMJKEY) ); 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 ); ALTER TABLE CMGAAC ADD ( PRIMARY KEY (CMGAID) );
