Thread: Raids
View Single Post
  #21  
Old 09-18-2008, 12:46 PM
Rocker8956
Hill Giant
 
Join Date: Sep 2007
Posts: 117
Default

KLS,
Is this the database structure you plan on using for raids? (atleast for a while)
Code:
CREATE TABLE `raid_members` (
  `raidid` int(4) NOT NULL,
  `charid` int(4) NOT NULL,
  `groupid` int(4) NOT NULL,
  `_class` int(4) NOT NULL,
  `level` int(4) NOT NULL,
  `name` varchar(64) NOT NULL,
  `isgroupleader` tinyint(1) NOT NULL,
  `israidleader` tinyint(1) NOT NULL,
  `islooter` tinyint(1) NOT NULL,  
  PRIMARY KEY (`raidid`, `charid`)
)
ENGINE = InnoDB;

CREATE TABLE `raid_details` (
  `raidid` int(4) NOT NULL,
  `loottype` int(4) NOT NULL,
  `locked` tinyint(1) NOT NULL,    
  PRIMARY KEY (`raidid`)
)
ENGINE = InnoDB;
I am asking because I am getting ready to write the quest function for handing out instance flags to a raid. I will really only be using the raidid and charid field. I just want to be certain I write code that works with your implementation of raids.

Thank you
Reply With Quote