Console

[Kevin Cerda]

how can i create these 2 on my sql??

[21/7/2020 13:20:11] mysql_real_query(): SELECT * FROM z_ots_guildcomunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'baiakalfa.z_ots_guildcomunication' doesn't exist (1146)

[21/7/2020 13:20:11] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'baiakalfa.z_ots_comunication' doesn't exist (1146)

 

[Addams]

Try pasting this query into your database.

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=230 ;