Estou com os seguintes erros em minha distro , sei que é relacionado a criação das tables no mysql , porém não sei as Query para criar , quem puder me ajudar.

 

 

mysql_real_query(): SELECT * FROM `dtt_players`; - MYSQL ERROR: Table 'forgottenserver.dtt_players' doesn't exist (1146)

 

 mysql_real_query(): INSERT INTO `lottery` (`name`, `item`, `world_id`, `item_name`, `date`) VALUES ('Vinnyziin', '2345', '0', '1 Premium Points', '06/02/2018 - 16:00:02'); - MYSQL ERROR: Table 'forgottenserver.lottery' doesn't exist (1146)

 

 

[6/2/2018 17:3:0] [Error - GlobalEvent Interface] 
[6/2/2018 17:3:0] In a timer event called from: 
[6/2/2018 17:3:0] data/globalevents/scripts/events/DesertWAR.lua:onTime
[6/2/2018 17:3:0] Description: 
[6/2/2018 17:3:0] (luaDoRemoveItem) Item not found

 

 

 

[6/2/2018 17:0:0] [Error - GlobalEvent Interface] 
[6/2/2018 17:0:0] data/globalevents/scripts/events/DTT.lua:onTime
[6/2/2018 17:0:0] Description: 
[6/2/2018 17:0:0] (luaDoRemoveItem) Item not found

 

 

 

[6/2/2018 16:50:4] [Error - TalkAction Interface] 
[6/2/2018 16:50:4] data/talkactions/scripts/createitem.lua:onSay
[6/2/2018 16:50:4] Description: 
[6/2/2018 16:50:4] (luaDoCreateItemEx) Item not found

 

 

[6/2/2018 14:28:26] [Warning - Houses::loadFromXml] House entry not set for:  (268435813)

 

 

[6/2/2018 14:27:58] >>> Loading globalscripts... [Error - LuaInterface::loadFile] data/globalevents/scripts/MensagensProgramadas.lua:1: unexpected symbol near 'char(127)'
[6/2/2018 14:27:59] [Error - Event::checkScript] Cannot load script (data/globalevents/scripts/MensagensProgramadas.lua)
[6/2/2018 14:27:59] data/globalevents/scripts/MensagensProgramadas.lua:1: unexpected symbol near 'char(127)'
[6/2/2018 14:27:59] (done).

 

 

AGRADEÇO A QUEM PUDER ME AJUDAR COM ESSES ERROS, DOU REP POR 1 SEMANA !!!

CREATE TABLE `lottery` (
   `id` int(11) NOT NULL auto_increment,
   `name` varchar(255) NOT NULL,
   `item` varchar(255) NOT NULL,
   `world_id` tinyint(2) unsigned NOT NULL default '0',
   `item_name` varchar(255) NOT NULL,
   `date` varchar(256) NOT NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;