ECshop小京东 - 快速删除商品分类
解决方案：执行SQL语句快速清空表:(PC后台管理 => 数据库管理 => SQL查询 => 提交下面语句即可)
+ Z: G9 z5 s; F6 d; M5 _i( E
* 切记,商品一级分类不要删除, 在原有的一级分类上面修改成自己的分类, 这样首页广告位置才不会错乱.
% s3 W% C5 @1 S% s* d3 \0 ~1 I
1.保留原有一级商品分类sql语句DROP TABLE IF EXISTS `ecs_category`;
' X2 H8 M9 m& s1 A; s( O- W- S& a" nCREATE TABLE `ecs_category` (
: A7 @3 S6 Y& o) ^# P0 O`cat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,8 U8 \3 s$ L! [9 [0 q* [; O
`cat_name` varchar(90) NOT NULL DEFAULT '',: I, {7 {L9 X1 b
`keywords` varchar(255) NOT NULL DEFAULT '',; m% K& a; c8 r! g! j9 G# t7 X
`cat_desc` varchar(255) NOT NULL DEFAULT '',
1 m+ u8 n' T! s4 K* L# i0 Z`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',/ Z4 W0 H$ ~k# [% d6 v
`sort_order` tinyint(1) unsigned NOT NULL DEFAULT '50',
1 k0 A- i2 k0 D# c$ ~1 Y) X6 d`template_file` varchar(50) NOT NULL DEFAULT '',
+ s- @: K- `, P5 X/ T`measure_unit` varchar(15) NOT NULL DEFAULT '',
( G) ]- r, N# v! F& j7 E6 ^. A& q`show_in_nav` tinyint(1) NOT NULL DEFAULT '0',
8 I+ ^) O9 tl7 r; Q9 Q! I9 @$ y`style` varchar(150) NOT NULL,
7 L. g# L0 Z0 J0 {1 X+ _`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1',
! }9 ?) i8 z! C6 }8 y4 Q`grade` tinyint(4) NOT NULL DEFAULT '0',7 Z7 N" L. z4 _6 d7 O: \* k
`filter_attr` varchar(255) NOT NULL DEFAULT '0',
5 C4 |7 }0 d+ |& Y; _`category_index` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ ~% ~% ~! m) q& N# l`category_index_dwt` tinyint(1) NOT NULL DEFAULT '0',
5 t* M* _9 q( C2 H. ?`index_dwt_file` varchar(150) DEFAULT NULL,
& I5 \; D) T5 [* ^`show_in_index` tinyint(1) unsigned NOT NULL DEFAULT '0',
4 J: g, X4 S4 C0 L' w! d`cat_index_rightad` varchar(255) NOT NULL,' v8 {+ I3 @# E
`cat_adimg_1` varchar(255) NOT NULL,
* z) i9 U4 M7 X/ b+ M$ U`cat_adurl_1` varchar(255) NOT NULL,4 n+ Fs5 K9 Y3 d& |
`cat_adimg_2` varchar(255) NOT NULL,
# P% o+ S, u* k/ X7 g& z`cat_adurl_2` varchar(255) NOT NULL,
8 L. c/ i* X7 Q9 @& ?: _- |* C: m5 j2 f`cat_nameimg` varchar(255) NOT NULL,
% ^; u3 T1 {1 `6 x- T7 Z, G3 W* T`brand_qq` varchar(255) NOT NULL DEFAULT '',
$ I/ jK/ y8 a' b# i`attr_wwwecshop68com` varchar(255) NOT NULL DEFAULT '',
) p" B: d1 ?w$ j5 F& F& x$ p`path_name` varchar(100) NOT NULL DEFAULT '',
6 l5 P# F: t( R. K. d1 ^: @`is_virtual` int(11) NOT NULL DEFAULT '0',7 O% {6 t1 J5 b3 r* z
`type_img` varchar(100) NOT NULL COMMENT '微信商城分类图标',
$ {. [( _2 ?$ D' DPRIMARY KEY (`cat_id`),
9 `! S0 a3 H# S5 I7 iKEY `parent_id` (`parent_id`)1 V) L# Z/ \) r8 ]
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;! t1 Q4 E+ |, y
7 H( a3 ?- `! C. S-- ----------------------------
% a( N$ l% V0 ]0 ?! d6 v-- Records of ecs_category( r) I$ E# g" q' ^+ ]1 N
-- ----------------------------' A3 r8 W5 @0 e1 w, c* M$ h
INSERT INTO `ecs_category` VALUES ('1', '食品生鲜', '', '', '0', '1', '', '', '1', 'category_index.css', '1', '5', '', '1', '0', '', '1', '', '', '', '', '', '', '', '', '', '0', '');+ Y1 B) e1 S* ]
INSERT INTO `ecs_category` VALUES ('2', '服装服饰', '', '', '0', '2', '', '', '0', 'category_index1.css', '1', '5', '', '1', '1', 'category_index1.dwt', '1', '', '', '', '', '', '', '', '', '', '0', '');1 r1 I- W$ Z! D
INSERT INTO `ecs_category` VALUES ('3', '个护化妆', '', '', '0', '3', '', '', '0', '', '1', '5', '', '0', '0', '', '0', '', '', '', '', '', '', '', '', '', '0', '');
4 Ip) ^4 A, mINSERT INTO `ecs_category` VALUES ('4', '手机数码', '', '', '0', '4', '', '', '0', '', '1', '8', '1,3,2,9,14', '0', '0', '', '0', '', '', '', '', '', '', '', '', '', '0', '');5 t' K0 b4 w8 _4 _) z! j. I" j
INSERT INTO `ecs_category` VALUES ('5', '家用电器', '', '', '0', '5', '', '', '0', '', '1', '5', '', '0', '0', '', '0', '', '', '', '', '', '', '', '', '', '0', '');) o& M2 N8 G& F1 @1 }
INSERT INTO `ecs_category` VALUES ('6', '家纺家居', '', '', '0', '6', '', '', '0', '', '1', '5', '', '0', '0', '', '0', '', '', '', '', '', '', '', '', '', '0', '');4 T! I0 [* M( H- n8 f
INSERT INTO `ecs_category` VALUES ('7', '酒类饮料', '', '', '0', '7', '', '', '0', '', '1', '5', '', '0', '0', '', '0', '', '', '', '', '', '', '', '', '', '0', '');
( c( M& W* k5 ?INSERT INTO `ecs_category` VALUES ('8', '母婴用品', '', '', '0', '8', '', '', '0', '', '1', '5', '', '0', '0', '', '0', '', '', '', '', '', '', '', '', '', '0', '');删除所有商品分类sql语句& DROP TABLE IF EXISTS `ecs_category`;
8 F' d4 S9 r7 T; Z* HCREATE TABLE `ecs_category` (
$ F" T* e) q" X9 f5 U5 x`cat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
8 {6 {' I4 N/ Q`cat_name` varchar(90) NOT NULL DEFAULT '',
* f% Y: e7 C: G2 _`keywords` varchar(255) NOT NULL DEFAULT '',9 U" _" n, f1 [
`cat_desc` varchar(255) NOT NULL DEFAULT '',- b, j! M. ?% E4 g
`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0'," b9 N4 i- u: d$ g6 w~
`sort_order` tinyint(1) unsigned NOT NULL DEFAULT '50',
0 x: U( E5 w) }( @/ v+ G`template_file` varchar(50) NOT NULL DEFAULT '',9 m/ r2 G: N4 m# B9 W% i* Z
`measure_unit` varchar(15) NOT NULL DEFAULT '',
0 [1 O2 N6 V: G) ?( H% x`show_in_nav` tinyint(1) NOT NULL DEFAULT '0',# U+ O6 S5 @4 I; h0 E; }- \) mq
`style` varchar(150) NOT NULL,
" N! G7 Y' H: N5 ryJ`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1',
; x( l7 x( p- p% b" ^`grade` tinyint(4) NOT NULL DEFAULT '0',1 \0 Z/ _( u4 x8 LWT8 g
`filter_attr` varchar(255) NOT NULL DEFAULT '0',
8 M& T: S& V9 Y$ b+ _+ P' _9 H`category_index` tinyint(1) unsigned NOT NULL DEFAULT '0',
1 b0 ]' s9 p6 Y. A. e- ?. E`category_index_dwt` tinyint(1) NOT NULL DEFAULT '0',
% k! I: J7 h- F$ ]0 n" k! O`index_dwt_file` varchar(150) DEFAULT NULL,
! x- a8 p. R@( j`show_in_index` tinyint(1) unsigned NOT NULL DEFAULT '0',
1 PA+ ?( ^1 \+ k+ _: E7 e`cat_index_rightad` varchar(255) NOT NULL,' ?% ^3 D3 @7 L% ~
`cat_adimg_1` varchar(255) NOT NULL,0 t1 w% o1 d. m6 V1 g" l% L0 o' \
`cat_adurl_1` varchar(255) NOT NULL,
) h$ h/ j* L3 Z0 B`cat_adimg_2` varchar(255) NOT NULL,* G4 T8 VD6 {. I1 ~) `$ m3 v. N
`cat_adurl_2` varchar(255) NOT NULL,$ V, S3 e& W8 e1 x
`cat_nameimg` varchar(255) NOT NULL,
2 G; B# B6 I1 z5 |' l) UT8 T8 j`brand_qq` varchar(255) NOT NULL DEFAULT '',
~8 b^, o2 M& n0 ?! w5 Z* |`attr_wwwecshop68com` varchar(255) NOT NULL DEFAULT '',
, [5 @" C( d4 t`path_name` varchar(100) NOT NULL DEFAULT '',
. e; ?3 u- b) [`is_virtual` int(11) NOT NULL DEFAULT '0',
1 c( C' T+ r5 j8 p/ N. m`type_img` varchar(100) NOT NULL COMMENT '微信商城分类图标',
2 O( D4 d; U5 Y9 X2 PPRIMARY KEY (`cat_id`),$ H4 ~. T$ z, z1 ~; N' Z4 B/ ^
KEY `parent_id` (`parent_id`)! L7 C. R8 R- F, M% ^' J8 \
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
q,
页:
[1]