root/trunk/sql/updates/0.6/2821_raidgroups.sql @ 2

Revision 2, 0.8 kB (checked in by yumileroy, 17 years ago)

[svn] * Proper SVN structure

Original author: Neo2003
Date: 2008-10-02 16:23:55-05:00
Line 
1DROP TABLE IF EXISTS `raidgroup`;
2CREATE TABLE `raidgroup` (
3  `leaderGuid` bigint(20) NOT NULL,
4  `lootMethod` int(11) NOT NULL,
5  `looterGuid` bigint(20) NOT NULL,
6  `icon1` bigint(20) NOT NULL,
7  `icon2` bigint(20) NOT NULL,
8  `icon3` bigint(20) NOT NULL,
9  `icon4` bigint(20) NOT NULL,
10  `icon5` bigint(20) NOT NULL,
11  `icon6` bigint(20) NOT NULL,
12  `icon7` bigint(20) NOT NULL,
13  `icon8` bigint(20) NOT NULL,
14  PRIMARY KEY  (`leaderGuid`)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='RaidGroups';
16
17DROP TABLE IF EXISTS `raidgroup_member`;
18CREATE TABLE `raidgroup_member` (
19  `leaderGuid` bigint(20) NOT NULL,
20  `memberGuid` bigint(20) NOT NULL,
21  `assistant` tinyint(1) NOT NULL,
22  `subgroup` smallint(6) NOT NULL,
23  PRIMARY KEY  (`leaderGuid`,`memberGuid`)
24) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='RaidGroups';
Note: See TracBrowser for help on using the browser.