Pets MySQL Error [PLUS R2] Missing table

[K Camp]

Does someone has the table for me? I can't find it.

Error in query: SELECT * FROM pets WHERE room_id = 14MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'hotel.pets' doesn't exist   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)   at Database_Manager.Database.Session_Details.QueryAdapter.getTable() in C:\Users\Administrator\Desktop\TempEMU\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 144 

[MentaL]

[TheWulles]

Please run this in your database:

CREATE TABLE IF NOT EXISTS `pets` (  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,  `room_id` int(10) unsigned NOT NULL DEFAULT '0',  `user_id` int(10) unsigned NOT NULL DEFAULT '0',  `name` varchar(100) NOT NULL,  `x` int(11) NOT NULL DEFAULT '0',  `y` int(11) NOT NULL DEFAULT '0',  `z` int(11) NOT NULL DEFAULT '0',  `rotation` int(11) NOT NULL DEFAULT '0',  `walk_mode` enum('stand','freeroam','specified_range') NOT NULL DEFAULT 'freeroam',  `min_x` int(11) NOT NULL DEFAULT '0',  `min_y` int(11) NOT NULL DEFAULT '0',  `max_x` int(11) NOT NULL DEFAULT '0',  `max_y` int(11) NOT NULL DEFAULT '0',  PRIMARY KEY (`id`),  KEY `room_id` (`room_id`),  KEY `user_id` (`user_id`)) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5404 ;