DROP TABLE IF EXISTS `web_shop`;CREATE TABLE `web_shop`(`id` int unsigned auto_increment key,`pName` varchar(50) not null unique,`pSn` varchar(50) not null,`pNum` int unsigned default 1,`pPrice` decimal(10,2) not null,`pDesc` text,`pImg` varchar(50) not null,`pubTime` int unsigned not null,`isHot` tinynt(1) default 0,`cId` smallint unsigned not null,`pCommen` text,`pSold` char(7),`pBrand` char(20) not null);