Zugg Software :: View topic - What is the format of the CMUD mapper file?

Newbie Joined: 17 Mar 2016 Posts: 2

Is there a spec that describes the format of the CMUD mapper file? I would like to export it and import into a different database type so I can use with a web interface.

Sorcerer Joined: 15 Apr 2011 Posts: 809

It's a standard SQLite 3 format. If you mean documentation on the structure of the actual tables, that doesn't exist as far as I know, but if you poke around it's all pretty self-explanatory from what I remember.

Newbie Joined: 17 Mar 2016 Posts: 2

I found the table specs in case anyone else is looking for them:

CREATE TABLE IconTbl ([IconId] INTEGER PRIMARY KEY,[Bitmap] BLOB,[Filename] VARCHAR(255),[UID1] INTEGER DEFAULT 0,[UID2] INTEGER DEFAULT 0,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE ZoneTbl ([ZoneId] INTEGER PRIMARY KEY,[Name] VARCHAR(80),[ZoneFile] VARCHAR(80),[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP,[Script] TEXT,[Desc] TEXT,[X] INTEGER DEFAULT 0,[Y] INTEGER DEFAULT 0,[Z] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[MinX] INTEGER DEFAULT 0,[MinY] INTEGER DEFAULT 0,[MinZ] INTEGER DEFAULT 0,[MaxX] INTEGER DEFAULT 0,[MaxY] INTEGER DEFAULT 0,[MaxZ] INTEGER DEFAULT 0,[Background] VARCHAR(80),[XScale] INTEGER DEFAULT 0,[YScale] INTEGER DEFAULT 0,[XOffset] INTEGER DEFAULT 0,[YOffset] INTEGER DEFAULT 0,[Divisor] INTEGER DEFAULT 1,[Multiplier] INTEGER DEFAULT 1,[DefSize] INTEGER DEFAULT 0,[DefSizeY] INTEGER DEFAULT 0,[Res] INTEGER DEFAULT 0,[Color] INTEGER DEFAULT 536870911,[GridXInc] INTEGER DEFAULT 120,[GridYInc] INTEGER DEFAULT 120,[GridXOff] INTEGER DEFAULT 0,[GridYOff] INTEGER DEFAULT 0,[GridCol] INTEGER DEFAULT 0,[Flags] INTEGER DEFAULT 0,[Parent] INTEGER DEFAULT -1)
CREATE TABLE MetaTbl ([MetaId] INTEGER PRIMARY KEY,[X] INTEGER DEFAULT 0,[Y] INTEGER DEFAULT 0,[Z] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[Label] VARCHAR(255),[DrawData] BLOB,[HasData] BOOLEAN DEFAULT False,[Ref] INTEGER DEFAULT 0,[UID1] INTEGER DEFAULT 0,[UID2] INTEGER DEFAULT 0,[IconID] INTEGER DEFAULT -1,[ZoneID] INTEGER DEFAULT -1,[Color] INTEGER DEFAULT 536870911,[Flags] INTEGER DEFAULT 0,[ParentID] INTEGER DEFAULT -1,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE KindTbl ([KindId] INTEGER PRIMARY KEY,[Name] VARCHAR(80),[Desc] VARCHAR(255),[IconID] INTEGER DEFAULT -1,[Color] INTEGER DEFAULT 536870911,[MetaID] INTEGER DEFAULT -1,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[Ref] INTEGER DEFAULT 0,[Flags] INTEGER DEFAULT 0,[Script] TEXT,[UserID] INTEGER DEFAULT 0,[StyleID] INTEGER DEFAULT 0,[ParentID] INTEGER DEFAULT -1,[DrawDef] BOOLEAN DEFAULT True,[Pen] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE ObjectTbl ([ObjId] INTEGER PRIMARY KEY,[Name] VARCHAR(255),[IDName] VARCHAR(255),[Hint] VARCHAR(255),[Desc] TEXT,[KindID] INTEGER DEFAULT 0,[IconID] INTEGER DEFAULT -1,[RefNum] INTEGER DEFAULT 0,[fKey] INTEGER DEFAULT 0,[X] INTEGER DEFAULT 0,[Y] INTEGER DEFAULT 0,[Z] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[ExitX] INTEGER DEFAULT 0,[ExitY] INTEGER DEFAULT 0,[ExitZ] INTEGER DEFAULT 0,[Cost] INTEGER DEFAULT 0,[Color] INTEGER DEFAULT 536870911,[MetaID] INTEGER DEFAULT -1,[StyleID] INTEGER DEFAULT 0,[LabelDir] INTEGER DEFAULT 11,[Enabled] BOOLEAN DEFAULT True,[Script] TEXT,[Param] VARCHAR(80),[UserStr] VARCHAR(255),[UserInt] INTEGER DEFAULT 0,[Content] TEXT,[Flags] INTEGER DEFAULT 0,[Deleted] BOOLEAN DEFAULT False,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP,[DateAdded] TIMESTAMP,[ServerID] INTEGER DEFAULT -1,[ZoneID] INTEGER DEFAULT 1)
CREATE TABLE ExitKindTbl ([ExitKindId] INTEGER PRIMARY KEY,[Name] VARCHAR(80),[Desc] VARCHAR(255),[Script] TEXT,[Style] INTEGER DEFAULT 0,[Color] INTEGER DEFAULT 536870911,[InnerWidth] INTEGER DEFAULT 0,[InnerColor] INTEGER DEFAULT 536870911,[FillColor] INTEGER DEFAULT 536870911,[DoorColor] INTEGER DEFAULT 536870911,[Flags] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[MetaID] INTEGER DEFAULT -1,[IconID] INTEGER DEFAULT -1,[UserID] INTEGER DEFAULT 0,[ParentID] INTEGER DEFAULT -1,[DrawDef] BOOLEAN DEFAULT True,[Modified] TIMESTAMP)
CREATE TABLE NoteTbl ([NoteId] INTEGER PRIMARY KEY,[ObjID] INTEGER DEFAULT -1,[Note] TEXT,[Category] INTEGER DEFAULT 0,[Flags] INTEGER DEFAULT 0,[UserID] INTEGER DEFAULT 0,[Deleted] BOOLEAN DEFAULT False,[Modified] TIMESTAMP)
CREATE TABLE StyleTbl ([StyleId] INTEGER PRIMARY KEY,[Name] VARCHAR(80),[ParentID] INTEGER DEFAULT -1,[FontName] VARCHAR(80),[FontSize] INTEGER DEFAULT 10,[FontStyle] INTEGER DEFAULT 0,[Color] INTEGER DEFAULT 536870911,[Color2] INTEGER DEFAULT 536870911,[Flags] INTEGER DEFAULT 0,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE ExitTbl ([ExitId] INTEGER PRIMARY KEY,[ExitIdTo] INTEGER DEFAULT -1,[FromID] INTEGER DEFAULT -1,[ToID] INTEGER DEFAULT -1,[ExitKindID] INTEGER DEFAULT 0,[Name] VARCHAR(80),[Param] VARCHAR(80),[Label] VARCHAR(80),[X0] INTEGER DEFAULT 0,[Y0] INTEGER DEFAULT 0,[Z0] INTEGER DEFAULT 0,[X1] INTEGER DEFAULT 0,[Y1] INTEGER DEFAULT 0,[Z1] INTEGER DEFAULT 0,[Distance] INTEGER DEFAULT 0,[Script] TEXT,[Color] INTEGER DEFAULT 536870911,[MetaID] INTEGER DEFAULT -1,[DrawRev] BOOLEAN DEFAULT False,[DirType] INTEGER DEFAULT 0,[DirToType] INTEGER DEFAULT 0,[Tested] BOOLEAN DEFAULT True,[Flags] INTEGER DEFAULT 0,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE FavTbl ([FavId] INTEGER PRIMARY KEY,[Name] VARCHAR(80),[KindID] INTEGER DEFAULT -1,[ParentID] INTEGER DEFAULT -1,[ObjID] INTEGER DEFAULT -1)
CREATE TABLE DrawTbl ([DrawId] INTEGER PRIMARY KEY,[X] INTEGER DEFAULT 0,[Y] INTEGER DEFAULT 0,[Z] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[Name] VARCHAR(255),[Hint] VARCHAR(255),[MetaID] INTEGER DEFAULT -1,[StyleID] INTEGER DEFAULT 0,[ZoneID] INTEGER DEFAULT -1,[Flags] INTEGER DEFAULT 0,[UserID] INTEGER DEFAULT 0,[Modified] TIMESTAMP)
CREATE TABLE VersTbl ([VersId] INTEGER PRIMARY KEY,[VersNum] INTEGER DEFAULT 0,[IconID] INTEGER DEFAULT 1,[MetaID] INTEGER DEFAULT 1,[DrawID] INTEGER DEFAULT 1,[KindID] INTEGER DEFAULT 1,[FavID] INTEGER DEFAULT 1,[ZoneID] INTEGER DEFAULT 1,[ObjID] INTEGER DEFAULT 1,[ExitKindID] INTEGER DEFAULT 1,[NoteID] INTEGER DEFAULT 1,[StyleID] INTEGER DEFAULT 1,[ExitID] INTEGER DEFAULT 1,[PortalID] INTEGER DEFAULT 1,[DirID] INTEGER DEFAULT 1)
CREATE TABLE DirTbl ([DirId] INTEGER PRIMARY KEY,[DirName] VARCHAR(80),[DirRef] INTEGER DEFAULT 0,[RevId] INTEGER DEFAULT 0,[Dx] INTEGER DEFAULT 0,[Dy] INTEGER DEFAULT 0,[Dz] INTEGER DEFAULT 0)
CREATE TABLE PortalTbl ([PortalId] INTEGER PRIMARY KEY,[ToID] INTEGER DEFAULT 0,[Cost] INTEGER DEFAULT 0,[ZoneID] INTEGER DEFAULT -1,[Name] VARCHAR(255),[Flags] INTEGER DEFAULT 0,[Enable] BOOLEAN DEFAULT True,[Modified] TIMESTAMP)