Guest Posted May 15, 2003 Posted May 15, 2003 SOMEHOW MINE GOT DELETED HOW DO I CREATE A NEW ONE ? PLEASE HELP
networkdad Posted May 15, 2003 Posted May 15, 2003 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.