[Help] How i could create a table in navicat?

[Belzebul]

Hello guys,

 

i want to insernt a sql buffer but there isnt a table with name "buff_templates". What can i do?

 

 

Thank you.

[down]

save it as .sql and execute in DB

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for buff_templates
-- ----------------------------
CREATE TABLE `buff_templates` (
  `id` int(11) unsigned NOT NULL,
  `name` varchar(35) NOT NULL DEFAULT '',
  `skill_id` int(10) unsigned NOT NULL,
  `skill_name` varchar(35) DEFAULT NULL,
  `skill_level` int(10) unsigned NOT NULL DEFAULT '1',
  `skill_force` int(1) NOT NULL DEFAULT '1',
  `skill_order` int(10) unsigned NOT NULL,
  `char_min_level` int(10) unsigned NOT NULL DEFAULT '0',
  `char_max_level` int(10) unsigned NOT NULL DEFAULT '0',
  `char_race` int(1) unsigned NOT NULL DEFAULT '0',
  `char_class` int(1) NOT NULL DEFAULT '0',
  `char_faction` int(10) unsigned NOT NULL DEFAULT '0',
  `price_adena` int(10) unsigned NOT NULL DEFAULT '0',
  `price_points` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`,`name`,`skill_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------

[Belzebul]

thanks a lot dude.

problem solved ;)