EQ2 Emulator?

saweb · #11 07-25-2007, 02:55 AM

I quickly made a DB, that looks alot like the structure found in the EQ2 config files.

-MYsql queries.

Code:

/*
MySQL Data Transfer
Source Host: 127.0.0.1
Source Database: runtimevdl
Target Host: 127.0.0.1
Target Database: runtimevdl
Date: 7/25/2007 4:44:20 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for bugtype
-- ----------------------------
CREATE TABLE `bugtype` (
  `name` varchar(128) NOT NULL,
  `display_name` text NOT NULL,
  `description` text NOT NULL,
  `aSubTypes` float(44,0) NOT NULL,
  `aBugTypes` float(44,0) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for collision_data
-- ----------------------------
CREATE TABLE `collision_data` (
  `Entry` int(11) NOT NULL,
  `scriptName` varchar(11) NOT NULL,
  `sourceName` varchar(11) NOT NULL,
  `meshName` varchar(11) NOT NULL,
  `fRadius` float(11,0) NOT NULL,
  `minBBox` float(11,0) NOT NULL,
  `maxBBox` float(11,0) NOT NULL,
  `initialOffset` float(11,0) NOT NULL,
  `aMaterialDefs` float(11,0) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for continent_definitions
-- ----------------------------
CREATE TABLE `continent_definitions` (
  `Entry` int(11) NOT NULL,
  `directory` int(11) NOT NULL,
  `bBoxMin` float(11,0) NOT NULL,
  `bBoxMax` float(11,0) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for event_date
-- ----------------------------
CREATE TABLE `event_date` (
  `Event` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `month` int(11) NOT NULL,
  `day` int(11) NOT NULL,
  `hour` int(11) NOT NULL,
  `minute` int(11) NOT NULL,
  `second` int(11) NOT NULL,
  PRIMARY KEY  (`Event`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for helptopicstructure
-- ----------------------------
CREATE TABLE `helptopicstructure` (
  `Entry` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `topic_name` text NOT NULL,
  `topic_file` text NOT NULL,
  `aSubTopics` float(44,0) NOT NULL,
  `aTopics` float(44,0) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for keywordlist
-- ----------------------------
CREATE TABLE `keywordlist` (
  `Entry` tinyint(11) NOT NULL,
  `aKeywords` varchar(255) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for mount
-- ----------------------------
CREATE TABLE `mount` (
  `Entry` int(11) NOT NULL,
  `sDDFieldExclusions` text NOT NULL,
  `bAdjustPitch` enum('false','true') NOT NULL,
  `bAdjustHeading` enum('false','true') NOT NULL,
  `fSpeed` float NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for position
-- ----------------------------
CREATE TABLE `position` (
  `Entry` int(11) NOT NULL,
  `loc` varchar(16) NOT NULL,
  `heading` float(6,0) NOT NULL,
  `pitch` float(6,0) NOT NULL,
  `roll` float(6,0) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for recipefilter
-- ----------------------------
CREATE TABLE `recipefilter` (
  `name` varchar(255) NOT NULL,
  `filterItems` float NOT NULL,
  `selected` float NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for spellcast
-- ----------------------------
CREATE TABLE `spellcast` (
  `Entry` int(11) NOT NULL,
  `Event` varchar(125) NOT NULL,
  `fEventTime` float NOT NULL,
  `state` varchar(255) NOT NULL,
  `iRepeatCount` int(125) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for world_definitions
-- ----------------------------
CREATE TABLE `world_definitions` (
  `Entry` int(11) NOT NULL,
  `WorldDef` varchar(11) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for zonesettingsboatfields
-- ----------------------------
CREATE TABLE `zonesettingsboatfields` (
  `Entry` int(11) NOT NULL,
  `bLoadOcean` enum('false','true') NOT NULL,
  `bRockBoat` enum('false','true') NOT NULL,
  `sOceanName` varchar(255) NOT NULL,
  `fBoatSpeed` float(11,0) default '-1',
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for zonesettingssoundfields
-- ----------------------------
CREATE TABLE `zonesettingssoundfields` (
  `Entry` tinyint(11) NOT NULL,
  `soundRoom` varchar(255) NOT NULL default 'generic',
  `music` varchar(255) NOT NULL,
  `ambientSoundData` varchar(255) NOT NULL,
  PRIMARY KEY  (`Entry`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------