MySQL Data model

DROP TABLE IF EXISTS ' sh_category '; CREATE TABLE ' sh_category ' (' id ' int (one) not NULL auto_increment, ' FID ' int (one) ' NOT null COMMENT ' parent class ', ' logo ' varchar (  255) default null COMMENT ' icon ', ' name ' varchar (a) NOT null, ' sort ' int (one-by-one) not null DEFAULT ' 0 ' COMMENT ' sort ', ' status ' tinyint (4) Not NULL DEFAULT ' 1 ' COMMENT ' Display state ', PRIMARY key (' ID '), key ' ParentID ' (' fid ', ' status ') USING BTREE) ENGINE =myisam auto_increment=440 DEFAULT Charset=utf8;--------------------------------Records of sh_category------------- -----------------insert INTO ' sh_category ' values (' 47 ', ' 0 ', ' ', ' food tobacco wine ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 48 ') , ' 0 ', ', ' mobile digital ', ' 2 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 49 ', ' 0 ', ' ', ' sports outdoors ', ' 8 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 50 ', ' 0 ', ' ', ' shoes and bags ', ' 7 ', ' 1 '); insert INTO ' sh_category ' values (' 51 ', ' 0 ', ', ' Beauty clean ', ' 6 ', ' 1 '); insert INTO ' s H_category ' VALUES (' 52 ', ' 0 ', ' ', ' ' jewellery ', ' + ', ' 1 '); INSERT into ' sh_category ' values (' 53 ', ' 0 ', ', ' medical care ', ' 11 '), ' 1 '); insert INTO ' sh_category ' values (' 54 ', ' 0 ', ' ', ' household appliances ', ' 1 ', ' 1 '); insert INTO ' sh_category ' values (' 55 ', ' 0 ', ', ' Home-wear ', ' 4 ', ' 1 '); insert INTO ' sh_category ' values (' 56 ', ' 0 ', ' ', ' Travel ticket ', ' ' 1 '); insert INTO ' sh_category ' values (' 335 ', ' 0 ', ', ' apparel underwear ', ' 5 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 340 ', ' 0 ', null, ' mother and child Toys ', ' 9 ', ' 1 '); insert INTO ' sh_cat Egory ' VALUES (' 396 ', ' n ', ' null ', ' Emerald ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 397 ', ' n ', ' null ', ' Silver ', ' 0 ', ' 1 '); INS ERT into ' sh_category ' values (' 398 ', ' ' ', null, ' Crystal agate ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 399 ', ' ' n ', NULL, ' Platinum ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' n ', ' n ', null, ' Pearl ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 401 ', ' (') ', ' null ', ' sneaker bag ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 403 ', ' $ ', ' null, ' sportswear ', ' 0 ', ' 1 '); insert INTO ' Sh_ca Tegory ' values (' 404 ', ' i ', ' null ', ' fitness training ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 405 ', ' in ', ' null ', ' cycling supplies ', ' 0 ', ' 1 ') ) INSERT into ' Sh_categoRy ' VALUES (' 406 ', ' i ', ' null ', ' Sporting Goods ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' the ' 341 ', ' a ', ' the ' 0 ', ' 1 ');  Nsert into ' sh_category ' values (' 357 ', ' si ', null, ' health care ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 353 ', ' n ', NULL,  ' Milk dairy ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 349 ', ' n ', null, ' Casual food ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 347 ', ' n ', null, ' Cigarettes wine ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 346 ', ' n ', null, ' Poultry egg ', ' 0 ', ' 1 '); INSERT into ' Sh_category ' values (' 345 ', ' n ', null, ' pork and Mutton ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 343 ', ' n ', null, ' seafood ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 341 ', ' 0 ', NULL, ' Computer Office ', ' 3 ', ' 1 '); insert INTO ' sh_category ' values (' 352 ', ' 47 ', NULL, ' cereals and oils ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 351 ', ' n ', null, ' tea ', ' 0 ', ' 1 '); insert INTO ' sh_category '  VALUES (' n ', ' n ', NULL, ' local specialties ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 356 ', ' si ', ' null ', ' Life Appliances ', ' 0 ', ' 1 '); insert Into ' sh_category ' VALUES (' 354 ', ' si ', null, ' Everyone electricity ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 355 ', ' si ', ' null ', ' kitchen Appliances ', ' 0 ', ' 1 '); INSERT into ' Sh_category ' VALUES (' 358 ', ' si ', ' null ', ' hardware ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 359 ', ' 341 ', NULL, ' Computer machine ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 372 ', ' n ', null, ' cookware ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 371 ', ' 48 '  , NULL, ' mobile phone product ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 370 ', ' P ', ' null ', ' phone accessory ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 369 ', ' (') ', ' null ', ' digital product ', ' 0 ', ' 1 '); INSERT into ' sh_category ' VALUES (' 366 ', ' $ ', ' null, ' e-education ', ' 0 ', ' 1 '); inser T into ' sh_category ' values (' 368 ', ' n ', ' null ', ' digital accessory ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 367 ', ' $ ', null, ' AV Entertainment ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 365 ', ' 341 ', null, ' stationery supplies ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 364 ', ' 341 ', NULL, ' office equipment ', ' 0 ', ' 1 '), insert INTO ' sh_category ' VALUES (' 363 ', ' 341 ', NULL, ' network product ', ' 0 ', ' 1 '); INSERT INTO ' Sh_category ' VALUES (' 361 ', ' 341 ', NULL, ' peripheral ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 362 ', ' 341 ', NULL, ' Game device ', ' 0 ', ' 1 '); insert INTO ' Sh_c Ategory ' VALUES (' 382 ', ' Wuyi ', null, ' facial skincare ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 377 ', ' 335 ', null, ' Ladies ', ' 0 ', ' 1 ') Insert INTO ' sh_category ' values (' 388 ', ' ' ', ' null, ' fashion shoes ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 387 ', ' Wuyi ', Nu ll, ' pet life ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 386 ', ' Wuyi ', null, ' cleaning supplies ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VAL UES (' 385 ', ' Wuyi ', NULL, ' oral care ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 384 ', ' Wuyi ', null, ' body care ', ' 0 ', ' 1 '); Insert in To ' sh_category ' values (' 383 ', ' Wuyi ', NULL, ' shampoo hair ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 381 ', ' 335 ', NULL, ' Children's shoes ')  , ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 380 ', ' 335 ', NULL, ' accessories ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 379 ', ' 335 ', NULL, ' underwear ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 378 ', ' 335 ', NULL, ' menswear ', ' 0 ', ' 1 '); insert INTO ' Sh_catego Ry ' VALUES (' 376 ', ' 55 ', NULL, ' Daily Necessities ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 375 ', ' in ', ' null ', ' home furnishings ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 374 ', ' n ', null, ' luminaire ', ' 0 ', ' 1 '), insert INTO ' sh_category ' VALUES (' 373 ', ' ' n ', ' null, ' furniture ', ' 0 ', ' 1 '); Insert INT  O ' sh_category ' values (' 420 ', ' "", "null, ' local life ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 414 ', ' 340 ', NULL, ' feeding supplies ',  ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 409 ', ' $ ', null, ' fishing supplies ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 394 ', ' n ', null, ' Gold ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 423 ', ' "", "null, ' Ticket train car ticket ', ' 0 ', ' 1 '); insert INTO ' sh_cat Egory ' VALUES (' 422 ', ' ' + ', ' null ', ' education Training ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 421 ', ' a ', ' "null, ' Show ticket ', ' 0 ', ' 1 ') Insert INTO ' sh_category ' values (' 419 ', ' 340 ', NULL, ' instrument ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 418 ', ' 340 ', nul L, ' toys ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 417 ', ' 340 ', NULL, ' stroller crib ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUE S (' 416 ', ' 340 ', NULL, 'Mom zone ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 415 ', ' 340 ', NULL, ' toiletries ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values  (' 413 ', ' 340 ', NULL, ' diaper wipes ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 412 ', ' 340 ', NULL, ' Nutrient supplement ', ' 0 ', ' 1 '); INSERT into ' Sh_category ' VALUES (' 411 ', ' 340 ', NULL, ' powdered milk ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 410 ', ' $ ', null, ' swimming supplies ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 408 ', ' a ', ' null, ' outdoor equipment ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 407 ', ' 4  9 ', NULL, ' Outdoor footwear ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 395 ', ' n ', ' null, ' diamond ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 393 ', ' n ', null, ' sock belt ', ' 0 ', ' 1 '), INSERT into ' sh_category ' VALUES (' 392 ', ' ' n ', ' null, ' function bags ', ' 0 ', ' 1 '); inser T into ' sh_category ' values (' 391 ', ' ' n ', NULL, ' Boutique man Pack ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 390 ', ' n ', null, ' trend Female bag ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 389 ', ' ' n ', ' null ', ' popular men's Shoes ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 4 ', ' 334 ', null, ' literary ',' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 429 ', ' ' n ', ' null, ' adult ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 428 ', ' Sh_category ', NULL, ' nourishing regimen ', ' 0 ', ' 1 '); insert INTO ' VALUES ' (' 427 ', ' n ', ' null ', ' nutrition Health ', ' 0 ', ' 1 '); insert INTO ' Sh_categ Ory ' VALUES (' 426 ', ' n ', ' null ', ' Western medicine ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 425 ', ' "'", ' null, ' Travel Service ', ' 0 ', ' 1 '); Nsert into ' sh_category ' values (' 424 ', ' n ', ' null, ' hotel ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 439 ', ' 334 ', NULL, ' Technology ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 438 ', ' 334 ', NULL, ' life ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 4 Notoginseng ', ' 334 ', NULL, ' Humanities ', ' 0 ', ' 1 '); insert INTO ' sh_category ' VALUES (' 436 ', ' 334 ', NULL, ' administered ', ' 0 ', ' 1 '); insert INTO ' sh_ Category ' Values ' (' 434 ', ' 334 ', NULL, ' education ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 433 ', ' 334 ', null, ' children ', ' 0 ', ' 1 ') Insert INTO ' sh_category ' values (' 432 ', ' 334 ', NULL, ' audio ', ' 0 ', ' 1 '); insert INTO ' sh_category ' values (' 431 ', ' ', nul L, ' care Protector ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 430 ', ' n ', NULL, ' Health device ', ' 0 ', ' 1 '); INSERT into ' sh_category ' values (' 334 ', ' 0 ', './tpl/s Tore/common/mall/img/category/14559579543206256c827c2892cf.png ', ' book Audio ', ' 1 ', ' + '); INSERT into ' sh_category ' VALUES (' 342 ', ' n ', null, ' Fruit fresh ', ' 0 ', ' 1 '); INSERT into ' sh_category ' VALUES (' 339 ', ' 0 ', NULL, ' General merchandise ', ' 14 ', ' 1 ');

　　

MySQL Data model