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