ecmall发布商品全流程sql语句

   4 QueryINSERT INTO ecm_uploaded_file(store_id,file_type,file_size,file_name,file_path,belong,item_id,add_time) VALUES('4986','image/jpeg','60912','2.jpg','data/files/store_4986/goods_135/201310191542155858.jpg','2','0','1382197335')
   4 Query INSERT INTO ecm_goods_image(goods_id,image_url,thumbnail,sort_order,file_id) VALUES('0','data/files/store_4986/goods_135/201310191542155858.jpg','data/files/store_4986/goods_135/small_201310191542155858.jpg','255','93')
   9 Query INSERT INTO ecm_goods(mk_price,goods_name,description,cate_id,cate_name,brand,if_show,last_update,recommended,tags,spec_qty,type,closed,add_time,store_id,cate_id_1,cate_id_2,cate_id_3,cate_id_4) VALUES('85','包邮13韩版partysu秋季新款女装拼色露肩镂空麻花性感针织衫毛衣','des','1210','女装/女士精品时尚淘宝女装','','1','1382197413','1','','0','material','0','1382197413','4986','21','1210','0','0')
   9 Query INSERT INTO ecm_goods_statistics(goods_id) VALUES('257072')
   9 Query INSERT INTO ecm_goods_spec(price,stock,sku,spec_id,goods_id) VALUES('65','0','','','257072')