Windows Missing SQL Query.

[Klaien]

Hi,

I'm not a pro in sql things, so I ask you guys to help, When I'm running my server (Crying Damson 0.3.6PL1 (compiled to 8.54-8.57)) I get this Error all the time:

mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'theforgottenserver.z_ots_comunication' doesn't exist (1146)

So my question is, How to add the z_ots_comunication thing in SQL?
What lines to add in the mysql.sql or in PHPmyadmin?

I'll rep++ you if you can help me out.

 

[bolero]

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1993 ;

 

[Klaien]

thanks =D