INSERT INTO `group` (
`Id` ,
`Name` ,
`TablePrefix` ,
`MangosDatabase` ,
`MangosTable` ,
`MangosTableIndex` ,
`DBCFileName` ,
`WowheadName` ,
`LuaFileName` ,
`LuaMPQFolder` ,
`LastImport` ,
`LastVersion`
)
VALUES (
NULL , 'Úspěchy', 'achievement', '', '', '', 'Achievement', 'achievement', '', '', '', ''
);


INSERT INTO .`group` (
`Id` ,
`Name` ,
`TablePrefix` ,
`MangosDatabase` ,
`MangosTable` ,
`MangosTableIndex` ,
`DBCFileName` ,
`WowheadName` ,
`LuaFileName` ,
`LuaMPQFolder` ,
`LastImport` ,
`LastVersion`
)
VALUES (
NULL , 'Kategorie úspěchů', 'achievement_category', '', '', '', 'Achievement_Category', '', '', '', '', ''
);

INSERT INTO `group` (
`Id` ,
`Name` ,
`TablePrefix` ,
`MangosDatabase` ,
`MangosTable` ,
`MangosTableIndex` ,
`DBCFileName` ,
`WowheadName` ,
`LuaFileName` ,
`LuaMPQFolder` ,
`LastImport` ,
`LastVersion`
)
VALUES (
NULL , 'Kritéria úspěchů', 'achievement_criteria', '', '', '', 'Achievement_Criteria', '', '', '', '', ''
);


INSERT INTO `group_item` (
`Id` ,
`Group` ,
`Name` ,
`Column` ,
`Visible` ,
`MangosColumn` ,
`AddonFileName`
)
VALUES (
NULL , '20', 'Název', 'Name', '1', '', ''
);


INSERT INTO `group_item` (
`Id` ,
`Group` ,
`Name` ,
`Column` ,
`Visible` ,
`MangosColumn` ,
`AddonFileName`
)
VALUES (
NULL , '20', 'Popis', 'Description', '1', '', ''
);

INSERT INTO `group_item` (
`Id` ,
`Group` ,
`Name` ,
`Column` ,
`Visible` ,
`MangosColumn` ,
`AddonFileName`
)
VALUES (
NULL , '20', 'Odměna', 'Reward', '1', '', ''
);

INSERT INTO `group_item` (
`Id` ,
`Group` ,
`Name` ,
`Column` ,
`Visible` ,
`MangosColumn` ,
`AddonFileName`
)
VALUES (
NULL , '21', 'Název', 'Name', '1', '', ''
);

INSERT INTO `group_item` (
`Id` ,
`Group` ,
`Name` ,
`Column` ,
`Visible` ,
`MangosColumn` ,
`AddonFileName`
)
VALUES (
NULL , '22', 'Kritérium', 'Text', '1', '', ''
);

CREATE TABLE IF NOT EXISTS `achievement` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `Name` text NOT NULL,
  `Description` text NOT NULL,
  `Reward` text NOT NULL,
  `VersionStart` int(11) NOT NULL default '8606',
  `VersionEnd` int(11) NOT NULL default '8606',
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `achievement_category` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `Name` text NOT NULL,
  `VersionStart` int(11) NOT NULL default '8606',
  `VersionEnd` int(11) NOT NULL default '8606',
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `achievement_criteria` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `Text` text NOT NULL,
  `VersionStart` int(11) NOT NULL default '8606',
  `VersionEnd` int(11) NOT NULL default '8606',
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


ALTER TABLE `wow_client_version` ADD `DBCColumns_Achievement` TEXT NOT NULL ,
ADD `DBCColumns_Achievement_Category` TEXT NOT NULL ,
ADD `DBCColumns_Achievement_Criteria` TEXT NOT NULL ,
ADD `Achievement_Name` INT NOT NULL ,
ADD `Achievement_Description` INT NOT NULL ,
ADD `Achievement_Reward` INT NOT NULL ,
ADD `Achievement_Category_Name` INT NOT NULL ,
ADD `Achievement_Criteria_Text` INT NOT NULL ;

UPDATE `wow_client_version` SET `DBCColumns_Achievement` = 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu',
`DBCColumns_Achievement_Category` = 'uusuuuuuuuuuuuuuuuuu',
`DBCColumns_Achievement_Criteria` = 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu',
`Achievement_Name` = '4',
`Achievement_Description` = '21',
`Achievement_Reward` = '43',
`Achievement_Category_Name` = '2',
`Achievement_Criteria_Text` = '9' WHERE `wow_client_version`.`BuildNumber` =9947 LIMIT 1 ;
