Deleted table accidently

[Guest]

I deleted orders_products table by mistake. I had the fields written down and tried to reenter them, but nothing is showing when I do the search, does anyone know how to fix this. Help please

[♥mdtaylorlrim]

Run this sql...

 

 

CREATE TABLE `orders_products` (
 `orders_products_id` int(11) NOT NULL auto_increment,
 `orders_id` int(11) NOT NULL default '0',
 `products_id` int(11) NOT NULL default '0',
 `products_model` varchar(12) default NULL,
 `products_name` varchar(64) NOT NULL,
 `products_price` decimal(15,4) NOT NULL default '0.0000',
 `final_price` decimal(15,4) NOT NULL default '0.0000',
 `products_tax` decimal(7,4) NOT NULL default '0.0000',
 `products_quantity` int(2) NOT NULL default '0',
 PRIMARY KEY  (`orders_products_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

You may need to use a different number for auto_increment

[chooch]

For future remember to use your store admin/tools and then back up.

 

You should back up your database every so often in case of hardware failure and you should always back up your database before adding/removing tables. If something goes wrong then at least you can revert to the previous database and your store can operate as before.