-- phpMyAdmin SQL Dump
-- version phpStudy 2014
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2021 年 01 月 07 日 11:39
-- 服务器版本: 5.5.36
-- PHP 版本: 5.3.28
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- 数据库: `shopmall`
--
-- --------------------------------------------------------
--
-- 表的结构 `danhao`
--
CREATE TABLE IF NOT EXISTS `danhao` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`danhao` varchar(255) NOT NULL,
`userid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- 转存表中的数据 `danhao`
--
INSERT INTO `danhao` (`id`, `danhao`, `userid`) VALUES
(1, 'WJS1583679762307', 67),
(2, 'WJS1583680095798', 67),
(3, 'WJS1583680368573', 67),
(4, 'WJS1583680681366', 67),
(5, 'WJS1583680772292', 67),
(6, 'WJS1583682561422', 67),
(7, 'WJS1583682693012', 67),
(8, 'WJS1583684830782', 67),
(11, 'WJS1589305975041', 70),
(12, 'WJS1589306246383', 70),
(13, 'WJS1589306362015', 70);
-- --------------------------------------------------------
--
-- 表的结构 `good`
--
CREATE TABLE IF NOT EXISTS `good` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`image` varchar(255) NOT NULL,
`image2` varchar(255) NOT NULL,
`image3` varchar(255) NOT NULL,
`price` varchar(255) NOT NULL,
`sales` varchar(10000) NOT NULL,
`content` mediumtext NOT NULL,
`recommend` varchar(255) NOT NULL DEFAULT 'false',
`type` varchar(255) NOT NULL,
`click_num` varchar(255) NOT NULL,
`good_number` varchar(255) NOT NULL,
`sell_number` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=61 ;
--
-- 转存表中的数据 `good`
--
INSERT INTO `good` (`id`, `title`, `image`, `image2`, `image3`, `price`, `sales`, `content`, `recommend`, `type`, `click_num`, `good_number`, `sell_number`) VALUES
(21, '中秋猫粮', 'maoliang3.png', 'maoliang4.png', 'maoliang3.png', '1000', '180', '"`\n <div style="width:100%">\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fcbu01.alicdn.com%2Fimg%2Fibank%2F2018%2F603%2F427%2F9098724306_1627570303.jpg&refer=http%3A%2F%2Fcbu01.alicdn.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430296&t=eb974510e3763c22aaa1e6059ec94440" />\n \n <img style="width:100%;display:block;" src="https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=2762922753,2383069970&fm=26&gp=0.jpg" />\n\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fcbu01.alicdn.com%2Fimg%2Fibank%2F2018%2F906%2F303%2F9121303609_1627570303.jpg&refer=http%3A%2F%2Fcbu01.alicdn.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430370&t=9e355c717e111bb02bc97a421f2bdc7e" />\n </div>\n `"', 'true', '中秋猫粮', '200', '300', '108'),
(22, '深海三文鱼猫粮', 'maoliang4.png', 'maoliang3.png', 'maoliang4.png', '500', '230', '"`\n <div style="width:100%">\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fcbu01.alicdn.com%2Fimg%2Fibank%2F2018%2F603%2F427%2F9098724306_1627570303.jpg&refer=http%3A%2F%2Fcbu01.alicdn.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430296&t=eb974510e3763c22aaa1e6059ec94440" />\n \n <img style="width:100%;display:block;" src="https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=2762922753,2383069970&fm=26&gp=0.jpg" />\n\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fcbu01.alicdn.com%2Fimg%2Fibank%2F2018%2F906%2F303%2F9121303609_1627570303.jpg&refer=http%3A%2F%2Fcbu01.alicdn.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430370&t=9e355c717e111bb02bc97a421f2bdc7e" />\n </div>\n `"', 'true', '深海三文鱼猫粮', '150', '2000', '107'),
(23, '补钙狗粮', 'gouliang1.png', 'gouliang2.png', 'gouliang3.png', '500', '230', '`\n <div style="width:100%">\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fcbu01.alicdn.com%2Fimg%2Fibank%2F2018%2F281%2F629%2F8783926182_1152126311.jpg&refer=http%3A%2F%2Fcbu01.alicdn.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430732&t=fe842923a98b866aa9b8e181bf803ba1" />\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fpic.tuxiawang.com%2Fproduction%2F20180724%2F12703740-1.jpg%21%2Fwatermark%2Furl%2FL3BhdGgvdHV4aWEucG5n%2Falign%2Fcenter%2Frepeat%2Ftrue&refer=http%3A%2F%2Fpic.tuxiawang.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430732&t=85d41da31f5196350c52bc960fa42db2" />\n <img style="width:100%;display:block;" src="https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=2762922753,2383069970&fm=26&gp=0.jpg" />\n <img style="width:100%;display:block;" src="https://ss2.bdstatic.com/70cFvnSh_Q1YnxGkpoWK1HF6hhy/it/u=302591946,151114982&fm=15&gp=0.jpg" />\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fpic202.nipic.com%2Ffile%2F20190109%2F27496608_193924821088_2.jpg&refer=http%3A%2F%2Fpic202.nipic.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430732&t=b3ef2d9f63a950c1705f252b5edd67b9" />\n </div>\n `', 'true', '补钙狗粮', '150', '2000', '107'),
(24, 'petmate耐咬宠物玩具', 'gouwanju.png', 'gouwanju2.png', 'gouwanju3.png', '500', '230', '`\r\n <div style="width:100%">\r\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fcbu01.alicdn.com%2Fimg%2Fibank%2F2017%2F080%2F304%2F4068403080_2115326736.jpg&refer=http%3A%2F%2Fcbu01.alicdn.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430973&t=dd4c6cec4d936e7d7faf483687c8f13d" />\r\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fpic.tuxiawang.com%2Fproduction%2F20180724%2F12703740-1.jpg%21%2Fwatermark%2Furl%2FL3BhdGgvdHV4aWEucG5n%2Falign%2Fcenter%2Frepeat%2Ftrue&refer=http%3A%2F%2Fpic.tuxiawang.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430732&t=85d41da31f5196350c52bc960fa42db2" />\r\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fpic.90sjimg.com%2Fdesign%2F01%2F19%2F29%2F90%2Fd50b545286984f36022ddeba3a4aa2bf.jpg%21%2Ffw%2F282%2Fquality%2F90%2Funsharp%2Ftrue%2Fcompress%2Ftrue%2Fcanvas%2F282x425a0a0%2Fcvscolor%2FFFFFFFFF&refer=http%3A%2F%2Fpic.90sjimg.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430973&t=f01b9d2902fc98684ecf23a4e90dc7f5" />\r\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fcbu01.alicdn.com%2Fimg%2Fibank%2F2018%2F394%2F999%2F9132999493_832634200.jpg&refer=http%3A%2F%2Fcbu01.alicdn.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612430973&t=49e5f34394cdcc6e82fb87d8fd9978d5" />\r\n \r\n </div>\r\n `', 'true', 'petmate耐咬宠物玩具', '150', '2000', '107'),
(25, '刻字防丢狗狗项圈', 'xiangquan1.png', 'xiangquan2.png', 'xiangquan3.png', '500', '230', '`\n <div style="width:100%">\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fcbu01.alicdn.com%2Fimg%2Fibank%2F2019%2F547%2F150%2F10726051745_1144967204.jpg&refer=http%3A%2F%2Fcbu01.alicdn.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1612431194&t=e5bcb09af94628d2d985a910e1c7b614" />\n <img style="width:100%;display:block;" src="https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fcbu01.alicdn.com%2Fimg%2Fibank%2F2016%2F456%2F502%2F3248205654_681406500.jpg&ref
