ALTER TABLE `group` ADD `DBCFileName` VARCHAR( 255 ) NOT NULL ;
ALTER TABLE `group` ADD `DBCColumns` TEXT NOT NULL ;
ALTER TABLE `group_item` ADD `DBCColumnIndex` INT NOT NULL ;

CREATE TABLE IF NOT EXISTS `spell` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `Vote` float NOT NULL,
  `CountVote` int(11) NOT NULL,
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `admin_check` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` ( `Language` ),
  KEY `Complete` ( `Complete` )
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `spell_vote` (
  `ID` int(11) NOT NULL auto_increment,
  `TextId` int(11) NOT NULL,
  `IDuser` int(11) NOT NULL,
  `vote` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `IDquest` (`TextId`),
  KEY `IDuser` (`IDuser`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gametips` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `Vote` float NOT NULL,
  `CountVote` int(11) NOT NULL,
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `admin_check` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` ( `Language` ),
  KEY `Complete` ( `Complete` )
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gametips_vote` (
  `ID` int(11) NOT NULL auto_increment,
  `TextId` int(11) NOT NULL,
  `IDuser` int(11) NOT NULL,
  `vote` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `IDquest` (`TextId`),
  KEY `IDuser` (`IDuser`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

ALTER TABLE `gametips` ADD `Text` TEXT NOT NULL AFTER `entry`;

ALTER TABLE `spell` ADD `Name` TEXT NOT NULL AFTER `entry` ,
ADD `Rank` TEXT NOT NULL AFTER `Name` ,
ADD `ToolTip` TEXT NOT NULL AFTER `Name` ,
ADD `Description` TEXT NOT NULL AFTER `Name` ;

INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `DBCColumns`) VALUES
(12, 'Herní tipy', 'gametips', '', '', '', 'GameTips', 'usuuuuuuuuuuuuuuuu'),
(13, 'Kouzla', 'spell', '', '', '', 'Spell', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu');


INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES
(42, 12, 'Text', 'Text', '', '', 1),
(43, 13, 'Název', 'Name', '', '', 139),
(46, 13, 'Popis', 'Description', '', '', 173),
(44, 13, 'Hodnost', 'Rank', '', '', 156),
(45, 13, 'Popisek', 'ToolTip', '', '', 190);


