DROP TABLE `client`;

DELETE FROM `group` WHERE `Id` = 9;

DELETE FROM `group_item` WHERE `Group` = 9;

ALTER TABLE `group` ADD `LuaMPQFolder` VARCHAR( 255 ) NOT NULL ;

UPDATE `group` SET `LuaMPQFolder` = 'Interface/FrameXML' WHERE `group`.`Id` =14 LIMIT 1 ;

UPDATE `group` SET `LuaMPQFolder` = 'Interface/GlueXML' WHERE `group`.`Id` =15 LIMIT 1 ;

ALTER TABLE `group_item` ADD `Visible` BOOL NOT NULL DEFAULT '1' AFTER `Column` 

INSERT INTO `group_item` (
`Id` ,
`Group` ,
`Name` ,
`Column` ,
`Visible` ,
`MangosColumn` ,
`AddonFileName` ,
`DBCColumnIndex`
)
VALUES (
NULL , '14', 'Zkratka', 'ShortCut', '0', '', '', '0'
), (
NULL , '15', 'Zkratka', 'ShortCut', '0', '', '', '0'
);

UPDATE global_strings SET global_strings.ShortCut = (SELECT ShortCut FROM (SELECT T2.ShortCut, T2.entry FROM global_strings AS T2 WHERE T2.Language = 0) AS T3 WHERE T3.entry = global_strings.entry )
WHERE global_strings.Language <> 0;

DELETE FROM global_strings WHERE ((SELECT ID FROM (SELECT ID, entry FROM global_strings AS T2 WHERE T2.Language=0) AS T3 WHERE T3.entry = global_strings.entry) IS NULL) AND Language <> 0;

UPDATE glue_strings SET glue_strings.ShortCut = (SELECT ShortCut FROM (SELECT T2.ShortCut, T2.entry FROM glue_strings AS T2 WHERE T2.Language = 0) AS T3 WHERE T3.entry = glue_strings.entry )
WHERE glue_strings.Language <> 0;

INSERT INTO `group_item` (
`Id` ,
`Group` ,
`Name` ,
`Column` ,
`Visible` ,
`MangosColumn` ,
`AddonFileName` ,
`DBCColumnIndex`
)
VALUES (
NULL , '8', 'Name', 'Name', '0', 'name', '', '0'
);

ALTER TABLE `mangos_command` ADD `Name` VARCHAR( 255 ) NOT NULL ;

ALTER TABLE `mangos_command` ADD INDEX ( `Name` ) ;

UPDATE mangos_command SET mangos_command.Name = (SELECT Name FROM (SELECT T2.Name, T2.entry FROM mangos_command AS T2 WHERE T2.Language = 0) AS T3 WHERE T3.entry = mangos_command.entry )
WHERE mangos_command.Language <> 0;

