CREATE TABLE CMVFS ( CMFNAM char (255), CMDTYP int , CMMODD bigint, CMWHOM char (50) NULL, CMDATA text NULL ); ALTER TABLE CMVFS ADD ( PRIMARY KEY (CMFNAM) ); CREATE TABLE CMCHAB ( CMUSERID char (50) NULL , CMABID char (50) NULL , CMABPF int NULL , CMABTX text NULL ); ALTER TABLE CMCHAB ADD ( PRIMARY KEY (CMUSERID,CMABID) ); CREATE TABLE CMSTAT ( CMSTRT bigint NULL , CMENDT bigint NULL , CMDATA text NULL ); ALTER TABLE CMSTAT ADD ( PRIMARY KEY (CMSTRT) ); CREATE TABLE CMPOLL ( CMNAME char (100) , CMBYNM char (100) NULL , CMSUBJ char (255) NULL , CMDESC text NULL , CMOPTN text NULL , CMFLAG bigint NULL , CMQUAL char (255) NULL , CMRESL text NULL, CMEXPI bigint 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 text NULL, CMSAVE char (150) NULL, CMMXML text NULL ); ALTER TABLE CMCHAR ADD ( PRIMARY KEY (CMUSERID) ); CREATE TABLE CMCHFO ( CMUSERID char (50) NULL , CMFONM int NULL , CMFOID char (50) NULL , CMFOTX text 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 text 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 text 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 text 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 text 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 text NULL , CMROTX text NULL ); ALTER TABLE CMROOM ADD ( PRIMARY KEY (CMROID) ); CREATE TABLE CMQUESTS ( CMQUESID char (50) NULL , CMQUTYPE char (50) NULL , CMQSCRPT text NULL , CMQWINNS text 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 text NULL , CMROTX text NULL , CMTECH int NULL ); ALTER TABLE CMAREA ADD ( PRIMARY KEY (CMAREA) ); CREATE TABLE CMJRNL ( CMJKEY char (255) , CMJRNL char (50) NULL , CMFROM char (50) NULL , CMDATE char (50) NULL , CMTONM char (50) NULL , CMSUBJ char (255) NULL , CMMSGT text NULL ); ALTER TABLE CMJRNL ADD ( PRIMARY KEY (CMJKEY) ); CREATE TABLE CMCLAN ( CMCLID char (100) , CMTYPE int , CMDESC text NULL , CMACPT char (255) NULL , CMPOLI text 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 text NULL ); ALTER TABLE CMPDAT ADD ( PRIMARY KEY (CMPLID,CMSECT,CMPKEY) ); CREATE TABLE CMGRAC ( CMRCID char (50) , CMRDAT text NULL ); ALTER TABLE CMGRAC ADD ( PRIMARY KEY (CMRCID) ); CREATE TABLE CMCCAC ( CMCCID char (50) , CMCDAT text NULL ); ALTER TABLE CMCCAC ADD ( PRIMARY KEY (CMCCID) ); CREATE TABLE CMGAAC ( CMGAID char (50) , CMGAAT text NULL ); ALTER TABLE CMGAAC ADD ( PRIMARY KEY (CMGAID) );
