CREATE TABLE sklad (
id int(10) unsigned NOT NULL auto_increment,
maker varchar(30) NOT NULL default '',
number varchar(30) NOT NULL default '',
description varchar(255) default NULL,
quantity varchar(30) NOT NULL default '',
price_opt double NOT NULL default '0',
price_opt2 double NOT NULL default '0',
price_rozn double NOT NULL default '0',
days varchar(10) default '',
price_group_id int(10) unsigned NOT NULL default '0',
provider_id int(11) NOT NULL default '0',
store_id bigint(20) NOT NULL default '-1',
PRIMARY KEY (id),
KEY number (number),
KEY provider_id (provider_id),
KEY store_id (store_id)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;