/*
SQLyog Ultimate v12.4.1 (64 bit)
MySQL - 8.0.16 : Database - huas_shopping
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Table structure for table `t_address` */

DROP TABLE IF EXISTS `t_address`;

CREATE TABLE `t_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned DEFAULT NULL,
  `address` varchar(1000) DEFAULT NULL,
  `receiver` varchar(100) DEFAULT NULL,
  `tel` char(11) DEFAULT NULL,
  `isdefault` enum('0','1') DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `t_address` */

/*Table structure for table `t_banner` */

DROP TABLE IF EXISTS `t_banner`;

CREATE TABLE `t_banner` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pic` varchar(200) NOT NULL,
  `order` tinyint(4) DEFAULT NULL,
  `online` enum('0','1') DEFAULT '0' COMMENT '1表示下线',
  `dotime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `pid` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `t_banner` */

insert  into `t_banner`(`id`,`pic`,`order`,`online`,`dotime`,`pid`) values 
(1,'products/banner/banner-01.jpg',1,'0','2022-07-09 14:52:54',12),
(2,'products/banner/banner-02.jpg',2,'0','2022-07-09 14:53:24',16),
(3,'products/banner/banner-03.jpg',3,'0','2022-07-09 14:53:36',20);

/*Table structure for table `t_category` */

DROP TABLE IF EXISTS `t_category`;

CREATE TABLE `t_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) DEFAULT NULL,
  `pcid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `t_category` */

insert  into `t_category`(`id`,`name`,`pcid`) values 
(1,'手机数码',NULL),
(2,'电脑办公',NULL),
(4,'鞋靴箱包',NULL),
(5,'图书音像',NULL);

/*Table structure for table `t_indexproduct` */

DROP TABLE IF EXISTS `t_indexproduct`;

CREATE TABLE `t_indexproduct` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `pdesc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `news` enum('0','1') DEFAULT '0' COMMENT '0 最新图书 1推荐图书',
  `online` enum('0','1') DEFAULT '0' COMMENT '0 上线 1 下线',
  `addtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `order` tinyint(3) unsigned DEFAULT NULL,
  `pimage` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `t_indexproduct` */

insert  into `t_indexproduct`(`id`,`pid`,`name`,`price`,`pdesc`,`news`,`online`,`addtime`,`order`,`pimage`) values 
(1,1,'小米 4c 标准版',1299,'小米 4c 标准版 全网通 白色 移动联通电信4G手机 双卡双待','0','0','2022-07-07 13:56:15',1,'products/1/c_0001.jpg'),
(2,2,'中兴 AXON',2699,'中兴 AXON 天机 mini 压力屏版 B2015 华尔金 移动联通电信4G 双卡双待','0','0','2022-07-07 13:59:39',2,'products/1/c_0002.jpg'),
(3,3,'华为荣耀6',1499,'荣耀 6 (H60-L01) 3GB内存标准版 黑色 移动4G手机','0','0','2022-07-07 13:59:44',3,'products/1/c_0003.jpg'),
(4,4,'联想 P1',1999,'联想 P1 16G 伯爵金 移动联通4G手机充电5分钟，通话3小时！科技源于超越！品质源于沉淀！5000mAh大电池！高端商务佳配！','0','0','2022-07-07 13:59:49',4,'products/1/c_0004.jpg'),
(11,12,'努比亚（nubia）My 布拉格',1799,'努比亚（nubia）My 布拉格 银白 移动联通4G手机 双卡双待【嗨11，下单立减100】金属机身，快速充电！布拉格相机全新体验！','1','0','2022-07-07 14:02:21',1,'products/1/c_0012.jpg'),
(12,13,'华为 麦芒4',2499,'华为 麦芒4 晨曦金 全网通版4G手机 双卡双待金属机身 2.5D弧面屏 指纹解锁 光学防抖！','1','0','2022-07-07 14:03:18',2,'products/1/c_0013.jpg'),
(13,14,'vivo X5M',1799,'vivo X5M 移动4G手机 双卡双待 香槟金【购机送蓝牙耳机+蓝牙自拍杆】5.0英寸大屏显示·八核双卡双待·Hi-Fi移动KTV','1','0','2022-07-07 14:03:58',3,'products/1/c_0014.jpg'),
(14,15,'Apple iPhone 6 (A1586)',4288,'Apple iPhone 6 (A1586) 16GB 金色 移动联通电信4G手机长期省才是真的省！点击购机送费版，月月送话费，月月享优惠，畅享4G网络，就在联通4G！','1','0','2022-07-07 14:04:37',4,'products/1/c_0015.jpg');

/*Table structure for table `t_order` */

DROP TABLE IF EXISTS `t_order`;

CREATE TABLE `t_order` (
  `id` char(32) NOT NULL,
  `account` double(7,2) DEFAULT NULL,
  `qty` int(10) unsigned DEFAULT NULL,
  `dotime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ostate` enum('1','2','3','4') DEFAULT '1',
  `aid` int(11) DEFAULT NULL,
  `uid` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `t_order` */

insert  into `t_order`(`id`,`account`,`qty`,`dotime`,`ostate`,`aid`,`uid`) values 
('14cdb368348e40bda7db14e5e3fa81b8',4199.00,1,'2020-11-25 15:36:38','1',NULL,1001),
('2542ed0afc764c6f8bf444879e31d84e',4199.00,1,'2020-11-25 15:19:15','1',NULL,1001),
('40198b2de1cf4571bd120cca0d96e7f2',1499.00,1,'2020-11-25 15:09:29','1',NULL,1001),
('4e7f98b7443e4d39ba7255c5f4088e83',4499.00,1,'2020-11-25 15:29:57','1',NULL,1001),
('7953746120614532ae55b57f869e2ff3',4199.00,1,'2020-11-25 15:37:16','1',NULL,1001),
('8c0ea7847d934591bf86805c4dce5d3d',4499.00,1,'2020-11-25 15:29:51','1',NULL,1001),
('9af1264fdf314c239409a8b1efc7045f',3699.00,1,'2020-11-25 15:37:58','1',NULL,1001),
('9b39b749ad2844be938b31fc27e7a6cd',1499.00,1,'2020-11-25 15:07:29','1',NULL,1001),
('b301836c1913427b87f494252c21f1fb',80.00,5,'2020-11-17 11:43:36','1',NULL,1001),
('ba8da7f6607b45098c9e40f03b9f092a',4499.00,1,'2020-11-25 15:31:26','1',NULL,1001);

/*Table structure for table `t_orderitem` */

DROP TABLE IF EXISTS `t_orderitem`;

CREATE TABLE `t_orderitem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `oid` char(32) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `pname` varchar(200) DEFAULT NULL,
  `price` double(7,2) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `subtotal` double(7,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `t_orderitem` */

insert  into `t_orderitem`(`id`,`oid`,`pid`,`pname`,`price`,`qty`,`subtotal`) values 
(21,'b301836c1913427b87f494252c21f1fb',1,'测试商品1',10.00,2,20.00),
(22,'b301836c1913427b87f494252c21f1fb',2,'测试商品2',20.00,3,60.00),
(23,'9b39b749ad2844be938b31fc27e7a6cd',3,'华为荣耀6',1499.00,1,1499.00),
(24,'40198b2de1cf4571bd120cca0d96e7f2',3,'华为荣耀6',1499.00,1,1499.00),
(25,'2542ed0afc764c6f8bf444879e31d84e',33,'联想（ThinkPad） 轻薄系列E450C(20EH0001CD)',4199.00,1,4199.00),
(26,'8c0ea7847d934591bf86805c4dce5d3d',34,'联想（Lenovo）小新V3000经典版',4499.00,1,4499.00),
(27,'4e7f98b7443e4d39ba7255c5f4088e83',34,'联想（Lenovo）小新V3000经典版',4499.00,1,4499.00),
(28,'ba8da7f6607b45098c9e40f03b9f092a',34,'联想（Lenovo）小新V3000经典版',4499.00,1,4499.00),
(29,'14cdb368348e40bda7db14e5e3fa81b8',33,'联想（ThinkPad） 轻薄系列E450C(20EH0001CD)',4199.00,1,4199.00),
(30,'7953746120614532ae55b57f869e2ff3',33,'联想（ThinkPad） 轻薄系列E450C(20EH0001CD)',4199.00,1,4199.00),
(31,'9af1264fdf314c239409a8b1efc7045f',35,'华硕（ASUS）经典系列R557LI',3699.00,1,3699.00);

/*Table structure for table `t_product` */

DROP TABLE IF EXISTS `t_product`;

CREATE TABLE `t_product` (
  `id` int(11) NOT NULL,
  `pname` varchar(200) DEFAULT NULL,
  `market_price` double(7,2) DEFAULT '0.00',
  `shop_price` double(7,2) DEFAULT '0.00',
  `pimage` varchar(200) DEFAULT NULL,
  `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pdesc` varchar(400) DEFAULT NULL,
  `pflag` enum('0','1') DEFAULT '0',
  `cid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `t_product` */

insert  into `t_product`(`id`,`pname`,`market_price`,`shop_price`,`pimage`,`add_time`,`pdesc`,`pflag`,`cid`) values 
(1,'小米 4c 标准版',1399.00,1299.00,'products/1/c_0001.jpg','2015-11-02 00:00:00','小米 4c 标准版 全网通 白色 移动联通电信4G手机 双卡双待','0',1),
(2,'中兴 AXON',2899.00,2699.00,'products/1/c_0002.jpg','2015-11-05 00:00:00','中兴 AXON 天机 mini 压力屏版 B2015 华尔金 移动联通电信4G 双卡双待','0',1),
(3,'华为荣耀6',1599.00,1499.00,'products/1/c_0003.jpg','2015-11-02 00:00:00','荣耀 6 (H60-L01) 3GB内存标准版 黑色 移动4G手机','0',1),
(4,'联想 P1',2199.00,1999.00,'products/1/c_0004.jpg','2015-11-02 00:00:00','联想 P1 16G 伯爵金 移动联通4G手机充电5分钟，通话3小时！科技源于超越！品质源于沉淀！5000mAh大电池！高端商务佳配！','0',1),
(5,'摩托罗拉 moto x（x+1）',1799.00,1699.00,'products/1/c_0005.jpg','2015-11-01 00:00:00','摩托罗拉 moto x（x+1）(XT1085) 32GB 天然竹 全网通4G手机11月11天！MOTO X震撼特惠来袭！1699元！带你玩转黑科技！天然材质，原生流畅系统！','0',1),
(6,'魅族 MX5 16GB 银黑色',1899.00,1799.00,'products/1/c_0006.jpg','2015-11-02 00:00:00','魅族 MX5 16GB 银黑色 移动联通双4G手机 双卡双待送原厂钢化膜+保护壳+耳机！5.5英寸大屏幕，3G运行内存，2070万+500万像素摄像头！长期省才是真的省！','0',1),
(7,'三星 Galaxy On7',1499.00,1398.00,'products/1/c_0007.jpg','2015-11-14 00:00:00','三星 Galaxy On7（G6000）昂小七 金色 全网通4G手机 双卡双待新品火爆抢购中！京东尊享千元良机！5.5英寸高清大屏！1300+500W像素！评价赢30元话费券！','0',1),
(8,'NUU NU5',1288.00,1190.00,'products/1/c_0008.jpg','2015-11-02 00:00:00','NUU NU5 16GB 移动联通双4G智能手机 双卡双待 晒单有礼 晨光金香港品牌 2.5D弧度前后钢化玻璃 随机附赠手机套+钢化贴膜 晒单送移动电源+蓝牙耳机','0',1),
(9,'乐视（Letv）乐1pro（X800）',2399.00,2299.00,'products/1/c_0009.jpg','2015-11-02 00:00:00','乐视（Letv）乐1pro（X800）64GB 金色 移动联通4G手机 双卡双待乐视生态UI+5.5英寸2K屏+高通8核处理器+4GB运行内存+64GB存储+1300万摄像头！','0',1),
(10,'华为 Ascend Mate7',2699.00,2599.00,'products/1/c_0010.jpg','2015-11-02 00:00:00','华为 Ascend Mate7 月光银 移动4G手机 双卡双待双通6英寸高清大屏，纤薄机身，智能超八核，按压式指纹识别！!选择下方“移动老用户4G飞享合约”，无需换号，还有话费每月返还！','0',1),
(11,'vivo X5Pro',2399.00,2298.00,'products/1/c_0014.jpg','2015-11-02 00:00:00','移动联通双4G手机 3G运存版 极光白【购机送蓝牙耳机+蓝牙自拍杆】新升级3G运行内存·双2.5D弧面玻璃·眼球识别技术','0',1),
(12,'努比亚（nubia）My 布拉格',1899.00,1799.00,'products/1/c_0013.jpg','2015-11-02 00:00:00','努比亚（nubia）My 布拉格 银白 移动联通4G手机 双卡双待【嗨11，下单立减100】金属机身，快速充电！布拉格相机全新体验！','0',1),
(13,'华为 麦芒4',2599.00,2499.00,'products/1/c_0012.jpg','2015-11-02 00:00:00','华为 麦芒4 晨曦金 全网通版4G手机 双卡双待金属机身 2.5D弧面屏 指纹解锁 光学防抖','0',1),
(14,'vivo X5M',1899.00,1799.00,'products/1/c_0011.jpg','2015-11-02 00:00:00','vivo X5M 移动4G手机 双卡双待 香槟金【购机送蓝牙耳机+蓝牙自拍杆】5.0英寸大屏显示·八核双卡双待·Hi-Fi移动KTV','0',1),
(15,'Apple iPhone 6 (A1586)',4399.00,4288.00,'products/1/c_0015.jpg','2015-11-02 00:00:00','Apple iPhone 6 (A1586) 16GB 金色 移动联通电信4G手机长期省才是真的省！点击购机送费版，月月送话费，月月享优惠，畅享4G网络，就在联通4G！','0',1),
(16,'华为 HUAWEI Mate S 臻享版',4200.00,4087.00,'products/1/c_0016.jpg','2015-11-03 00:00:00','华为 HUAWEI Mate S 臻享版 手机 极昼金 移动联通双4G(高配)满星评价即返30元话费啦；买就送电源+清水套+创意手机支架；优雅弧屏，mate7升级版','0',1),
(17,'索尼(SONY) E6533 Z3+',4099.00,3999.00,'products/1/c_0017.jpg','2015-11-02 00:00:00','索尼(SONY) E6533 Z3+ 双卡双4G手机 防水防尘 涧湖绿索尼z3专业防水 2070万像素 移动联通双4G','0',1),
(18,'HTC One M9+',3599.00,3499.00,'products/1/c_0018.jpg','2015-11-02 00:00:00','HTC One M9+（M9pw） 金银汇 移动联通双4G手机5.2英寸，8核CPU，指纹识别，UltraPixel超像素前置相机+2000万/200万后置双镜头相机！降价特卖，惊喜不断！','0',1),
(19,'HTC Desire 826d 32G 臻珠白',1599.00,1469.00,'products/1/c_0020.jpg','2015-11-02 00:00:00','后置1300万+UltraPixel超像素前置摄像头+【双】前置扬声器+5.5英寸【1080p】大屏！','0',1),
(20,'小米 红米2A 增强版 白色',649.00,549.00,'products/1/c_0019.jpg','2015-11-02 00:00:00','新增至2GB 内存+16GB容量！4G双卡双待，联芯 4 核 1.5GHz 处理器！','0',1),
(21,'魅族 魅蓝note2 16GB 白色',1099.00,999.00,'products/1/c_0021.jpg','2015-11-02 00:00:00','现货速抢，抢完即止！5.5英寸1080P分辨率屏幕，64位八核1.3GHz处理器，1300万像素摄像头，双色温双闪光灯！','0',1),
(22,'三星 Galaxy S5 (G9008W) 闪耀白',2099.00,1999.00,'products/1/c_0022.jpg','2015-11-02 00:00:00','5.1英寸全高清炫丽屏，2.5GHz四核处理器，1600万像素','0',1),
(23,'sonim XP7700 4G手机',1799.00,1699.00,'products/1/c_0023.jpg','2015-11-09 00:00:00','三防智能手机 移动/联通双4G 安全 黑黄色 双4G美国军工IP69 30天长待机 3米防水防摔 北斗','0',1),
(24,'努比亚（nubia）Z9精英版 金色',3988.00,3888.00,'products/1/c_0024.jpg','2015-11-02 00:00:00','移动联通电信4G手机 双卡双待真正的无边框！金色尊贵版！4GB+64GB大内存！','0',1),
(25,'Apple iPhone 6 Plus (A1524) 16GB 金色',5188.00,4988.00,'products/1/c_0025.jpg','2015-11-02 00:00:00','Apple iPhone 6 Plus (A1524) 16GB 金色 移动联通电信4G手机 硬货 硬实力','0',1),
(26,'Apple iPhone 6s (A1700) 64G 玫瑰金色',6388.00,6088.00,'products/1/c_0026.jpg','2015-11-02 00:00:00','Apple iPhone 6 Plus (A1524) 16GB 金色 移动联通电信4G手机 硬货 硬实力','0',1),
(27,'三星 Galaxy Note5（N9200）32G版',5588.00,5388.00,'products/1/c_0027.jpg','2015-11-02 00:00:00','旗舰机型！5.7英寸大屏，4+32G内存！不一样的SPen更优化的浮窗指令！赠无线充电板！','0',1),
(28,'三星 Galaxy S6 Edge+（G9280）32G版 铂光金',5999.00,5888.00,'products/1/c_0028.jpg','2015-11-02 00:00:00','赠移动电源+自拍杆+三星OTG金属U盘+无线充电器+透明保护壳','0',1),
(29,'LG G4（H818）陶瓷白 国际版',3018.00,2978.00,'products/1/c_0029.jpg','2015-11-02 00:00:00','李敏镐代言，F1.8大光圈1600万后置摄像头，5.5英寸2K屏，3G+32G内存，LG年度旗舰机！','0',1),
(30,'微软(Microsoft) Lumia 640 LTE DS (RM-1113)',1099.00,999.00,'products/1/c_0030.jpg','2015-11-02 00:00:00','微软首款双网双卡双4G手机，5.0英寸高清大屏，双网双卡双4G！','0',1),
(31,'宏碁（acer）ATC705-N50 台式电脑',2399.00,2299.00,'products/1/c_0031.jpg','2015-11-02 00:00:00','爆款直降，满千减百，品质宏碁，特惠来袭，何必苦等11.11，早买早便宜！','0',2),
(32,'Apple MacBook Air MJVE2CH/A 13.3英寸',6788.00,6688.00,'products/1/c_0032.jpg','2015-11-02 00:00:00','宽屏笔记本电脑 128GB 闪存','0',2),
(33,'联想（ThinkPad） 轻薄系列E450C(20EH0001CD)',4399.00,4199.00,'products/1/c_0033.jpg','2015-11-02 00:00:00','联想（ThinkPad） 轻薄系列E450C(20EH0001CD)14英寸笔记本电脑(i5-4210U 4G 500G 2G独显 Win8.1)','0',2),
(34,'联想（Lenovo）小新V3000经典版',4599.00,4499.00,'products/1/c_0034.jpg','2015-11-02 00:00:00','14英寸超薄笔记本电脑（i7-5500U 4G 500G+8G SSHD 2G独显 全高清屏）黑色满1000減100，狂减！火力全开，横扫3天！','0',2),
(35,'华硕（ASUS）经典系列R557LI',3799.00,3699.00,'products/1/c_0035.jpg','2015-11-02 00:00:00','15.6英寸笔记本电脑（i5-5200U 4G 7200转500G 2G独显 D刻 蓝牙 Win8.1 黑色）','0',2),
(36,'华硕（ASUS）X450J',4599.00,4399.00,'products/1/c_0036.jpg','2015-11-02 00:00:00','14英寸笔记本电脑 （i5-4200H 4G 1TB GT940M 2G独显 蓝牙4.0 D刻 Win8.1 黑色）','0',2),
(37,'戴尔（DELL）灵越 飞匣3000系列',3399.00,3299.00,'products/1/c_0037.jpg','2015-11-03 00:00:00',' Ins14C-4528B 14英寸笔记本（i5-5200U 4G 500G GT820M 2G独显 Win8）黑','0',2),
(38,'惠普(HP)WASD 暗影精灵',5699.00,5499.00,'products/1/c_0038.jpg','2015-11-02 00:00:00','15.6英寸游戏笔记本电脑(i5-6300HQ 4G 1TB+128G SSD GTX950M 4G独显 Win10)','0',2),
(39,'Apple 配备 Retina 显示屏的 MacBook',11299.00,10288.00,'products/1/c_0039.jpg','2015-11-02 00:00:00','Pro MF840CH/A 13.3英寸宽屏笔记本电脑 256GB 闪存','0',2),
(40,'机械革命（MECHREVO）MR X6S-M',6799.00,6599.00,'products/1/c_0040.jpg','2015-11-02 00:00:00','15.6英寸游戏本(I7-4710MQ 8G 64GSSD+1T GTX960M 2G独显 IPS屏 WIN7)黑色','0',2),
(41,'神舟（HASEE） 战神K660D-i7D2',5699.00,5499.00,'products/1/c_0041.jpg','2015-11-02 00:00:00','15.6英寸游戏本(i7-4710MQ 8G 1TB GTX960M 2G独显 1080P)黑色','0',2),
(42,'微星（MSI）GE62 2QC-264XCN',6199.00,5999.00,'products/1/c_0042.jpg','2015-11-02 00:00:00','15.6英寸游戏笔记本电脑（i5-4210H 8G 1T GTX960MG DDR5 2G 背光键盘）黑色','0',2),
(43,'雷神（ThundeRobot）G150S',5699.00,5499.00,'products/1/c_0043.jpg','2015-11-02 00:00:00','15.6英寸游戏本 ( i7-4710MQ 4G 500G GTX950M 2G独显 包无亮点全高清屏) 金','0',2),
(44,'惠普（HP）轻薄系列 HP',3199.00,3099.00,'products/1/c_0044.jpg','2015-11-02 00:00:00','15-r239TX 15.6英寸笔记本电脑（i5-5200U 4G 500G GT820M 2G独显 win8.1）金属灰','0',2),
(45,'未来人类（Terrans Force）T5',10999.00,9899.00,'products/1/c_0045.jpg','2015-11-02 00:00:00','15.6英寸游戏本（i7-5700HQ 16G 120G固态+1TB GTX970M 3G GDDR5独显）黑','0',2),
(46,'戴尔（DELL）Vostro 3800-R6308 台式电脑',3299.00,3199.00,'products/1/c_0046.jpg','2015-11-02 00:00:00','（i3-4170 4G 500G DVD 三年上门服务 Win7）黑','0',2),
(47,'联想（Lenovo）H3050 台式电脑',5099.00,4899.00,'products/1/c_0047.jpg','2015-11-11 00:00:00','（i5-4460 4G 500G GT720 1G独显 DVD 千兆网卡 Win10）23英寸','0',2),
(48,'Apple iPad mini 2 ME279CH/A',2088.00,1888.00,'products/1/c_0048.jpg','2015-11-02 00:00:00','（配备 Retina 显示屏 7.9英寸 16G WLAN 机型 银色）','0',2),
(49,'小米（MI）7.9英寸平板',1399.00,1299.00,'products/1/c_0049.jpg','2015-11-02 00:00:00','WIFI 64GB（NVIDIA Tegra K1 2.2GHz 2G 64G 2048*1536视网膜屏 800W）白色','0',2),
(50,'Apple iPad Air 2 MGLW2CH/A',2399.00,2299.00,'products/1/c_0050.jpg','2015-11-12 00:00:00','（9.7英寸 16G WLAN 机型 银色）','0',2);

/*Table structure for table `t_user` */

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(200) DEFAULT NULL,
  `pwd` char(32) NOT NULL,
  `dotime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username_Uk` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=1007 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `t_user` */

insert  into `t_user`(`id`,`username`,`pwd`,`dotime`) values 
(1001,'haoren','6c9882bbac1c7093bd25041881277658','2020-10-20 09:13:57'),
(1003,'batman','202cb962ac59075b964b07152d234b70','2022-07-07 15:48:32'),
(1005,'sssf','e10adc3949ba59abbe56e057f20f883e','2022-07-09 09:36:33'),
(1006,'佩奇','e10adc3949ba59abbe56e057f20f883e','2022-07-09 09:40:27');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;