INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `DBCColumns`, `WowheadName`, `LuaFileName`, `LuaMPQFolder`) VALUES (NULL, 'Možnosti NPC', 'npc_option', 'mangos', 'npc_option', 'id', '', '', '', '', '');

INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `Visible`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES (NULL, '16', 'Text možnosti', 'OptionText', '1', 'option_text', '', '0');

CREATE TABLE IF NOT EXISTS `npc_option` (
  `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,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` ( `Language` ),
  KEY `Complete` ( `Complete` )
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

ALTER TABLE `npc_option` ADD `OptionText` TEXT NOT NULL ;


INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `DBCColumns`, `WowheadName`, `LuaFileName`, `LuaMPQFolder`) VALUES (NULL, 'Doprava', 'transports', 'mangos', 'transports', 'entry', '', '', '', '', '');

INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `Visible`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES (NULL, '17', 'Jméno', 'Name', '1', 'name', '', '0');

CREATE TABLE IF NOT EXISTS `transports` (
  `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,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` ( `Language` ),
  KEY `Complete` ( `Complete` )
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

ALTER TABLE `transports` ADD `Name` TEXT NOT NULL ;


INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `DBCColumns`, `WowheadName`, `LuaFileName`, `LuaMPQFolder`) VALUES (NULL, 'Krčmy', 'areatrigger_tavern', 'mangos', 'areatrigger_tavern', 'id', '', '', '', '', '');

INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `Visible`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES (NULL, '18', 'Jméno', 'Name', '1', 'name', '', '0');

CREATE TABLE IF NOT EXISTS `areatrigger_tavern` (
  `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,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` ( `Language` ),
  KEY `Complete` ( `Complete` )
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

ALTER TABLE `areatrigger_tavern` ADD `Name` TEXT NOT NULL ;


INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `DBCColumns`, `WowheadName`, `LuaFileName`, `LuaMPQFolder`) VALUES (NULL, 'Teleporty', 'areatrigger_teleport', 'mangos', 'areatrigger_teleport', 'id', '', '', '', '', '');

INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `Visible`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES (NULL, '19', 'Jméno', 'Name', '1', 'name', '', '0');

CREATE TABLE IF NOT EXISTS `areatrigger_teleport` (
  `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,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` ( `Language` ),
  KEY `Complete` ( `Complete` )
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

ALTER TABLE `areatrigger_teleport` ADD `Name` TEXT NOT NULL ;
