Please Help. It was a daft mistake :)

server
sql

#1

Just starting to learn all about this sort of thing
I must of deleted one of my tables but how do i get it back?
The error I got is
/* SQL Error (1146): Table ‘essentialmode.items’ doesn’t exist */


#2

You dont unless you had a backup i think. Also this isnt supposed to be posted here.


#3

Just make a new items table. You can get the structure for the items table from their github:

CREATE TABLE `items` (

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `limit` int(11) NOT NULL DEFAULT '-1',
  `rare` int(11) NOT NULL DEFAULT '0',
  `can_remove` int(11) NOT NULL DEFAULT '1',

  PRIMARY KEY (`id`)
);