Code:
CREATE TABLE `groups` (
`group_id` int(30) NOT NULL,
`group_type` tinyint(2) NOT NULL,
`subgroup_count` tinyint(2) NOT NULL,
`loot_method` tinyint(2) NOT NULL,
`loot_threshold` tinyint(2) NOT NULL,
`group1member1` int(50) NOT NULL,
`group1member2` int(50) NOT NULL,
`group1member3` int(50) NOT NULL,
`group1member4` int(50) NOT NULL,
`group1member5` int(50) NOT NULL,
`group2member1` int(50) NOT NULL,
`group2member2` int(50) NOT NULL,
`group2member3` int(50) NOT NULL,
`group2member4` int(50) NOT NULL,
`group2member5` int(50) NOT NULL,
`group3member1` int(50) NOT NULL,
`group3member2` int(50) NOT NULL,
`group3member3` int(50) NOT NULL,
`group3member4` int(50) NOT NULL,
`group3member5` int(50) NOT NULL,
`group4member1` int(50) NOT NULL,
`group4member2` int(50) NOT NULL,
`group4member3` int(50) NOT NULL,
`group4member4` int(50) NOT NULL,
`group4member5` int(50) NOT NULL,
`group5member1` int(50) NOT NULL,
`group5member2` int(50) NOT NULL,
`group5member3` int(50) NOT NULL,
`group5member4` int(50) NOT NULL,
`group5member5` int(50) NOT NULL,
`group6member1` int(50) NOT NULL,
`group6member2` int(50) NOT NULL,
`group6member3` int(50) NOT NULL,
`group6member4` int(50) NOT NULL,
`group6member5` int(50) NOT NULL,
`group7member1` int(50) NOT NULL,
`group7member2` int(50) NOT NULL,
`group7member3` int(50) NOT NULL,
`group7member4` int(50) NOT NULL,
`group7member5` int(50) NOT NULL,
`group8member1` int(50) NOT NULL,
`group8member2` int(50) NOT NULL,
`group8member3` int(50) NOT NULL,
`group8member4` int(50) NOT NULL,
`group8member5` int(50) NOT NULL,
`timestamp` int(30) NOT NULL,
PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;