Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HOW DO I RECREATE A PROUCTS TABLE


Guest

Recommended Posts

Posted

SOMEHOW MINE GOT DELETED HOW DO I CREATE A NEW ONE ? PLEASE HELP

Posted

Run this bit of code from phpMyAdmin, or whatever you feel most comfortable with..

 

CREATE TABLE products (

 products_id int(11) NOT NULL auto_increment,

 products_quantity int(4) NOT NULL default '0',

 products_model varchar(12) default NULL,

 products_image varchar(64) default NULL,

 products_price decimal(15,4) NOT NULL default '0.0000',

 products_date_added datetime NOT NULL default '0000-00-00 00:00:00',

 products_last_modified datetime default NULL,

 products_date_available datetime default NULL,

 products_weight decimal(5,2) NOT NULL default '0.00',

 products_status tinyint(1) NOT NULL default '0',

 products_tax_class_id int(11) NOT NULL default '0',

 manufacturers_id int(11) default NULL,

 products_ordered int(11) NOT NULL default '0',

 products_netweight longtext,

 PRIMARY KEY  (products_id),

 KEY idx_products_date_added (products_date_added)

) TYPE=MyISAM;

 

Note, this will only recreate the products table, and is based on a snapshot from 3/31/2003

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...