127_0_0_1.sql

-- phpMyAdmin SQL Dump
-- version 4.7.9
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 2018-07-12 04:22:37
-- 服务器版本： 10.1.31-MariaDB
-- PHP Version: 7.2.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `shoppingonline`
--
CREATE DATABASE IF NOT EXISTS `shoppingonline` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `shoppingonline`;

-- --------------------------------------------------------

--
-- 表的结构 `address`
--

CREATE TABLE `address` (
  `a_id` int(11) NOT NULL,
  `c_id` varchar(40) NOT NULL,
  `province` int(11) NOT NULL,
  `city` int(11) NOT NULL,
  `street` varchar(50) NOT NULL,
  `postcode` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `phone` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `address`
--

INSERT INTO `address` (`a_id`, `c_id`, `province`, `city`, `street`, `postcode`, `name`, `phone`) VALUES
(2, '239bb9b0-cc62-424b-8188-f5f1b29ab268', 9, 98, '新城大街5088号', 134000, '小明', 8888888),
(3, '239bb9b0-cc62-424b-8188-f5f1b29ab268', 9, 98, '南三环与幸福街交汇处', 134000, '小红', 6666666),
(4, '78caf48a-c229-4740-8caf-a70f69ecbb62', 1, 35, '海淀区 三义庙北里', 12313, '小刚', 12313);

-- --------------------------------------------------------

--
-- 表的结构 `cart`
--

CREATE TABLE `cart` (
  `c_id` varchar(40) NOT NULL,
  `g_id` int(11) NOT NULL,
  `num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `cart`
--

INSERT INTO `cart` (`c_id`, `g_id`, `num`) VALUES
('239bb9b0-cc62-424b-8188-f5f1b29ab268', 14, 1);

-- --------------------------------------------------------

--
-- 表的结构 `customer`
--

CREATE TABLE `customer` (
  `c_id` varchar(40) NOT NULL,
  `account` varchar(40) NOT NULL,
  `password` varchar(40) NOT NULL,
  `photo` varchar(40) NOT NULL,
  `spend` int(11) NOT NULL,
  `type` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `customer`
--

INSERT INTO `customer` (`c_id`, `account`, `password`, `photo`, `spend`, `type`) VALUES
('239bb9b0-cc62-424b-8188-f5f1b29ab268', 'aaa', 'aaa', '7c45e9fe-021d-43f1-a0c2-be4ada066456.jpg', 6283, 1),
('46d2fe93-d6fb-4d29-8622-2db0523bdda8', 'qqq', 'qqq', '4d1e9e82-2137-4abe-9bc3-e204233622f3.jpg', 10, 1),
('78caf48a-c229-4740-8caf-a70f69ecbb62', 'user', 'user', '720a9bb3-9b1a-45d3-b11f-7f27e6f6c611.jpg', 2433, 1);

-- --------------------------------------------------------

--
-- 表的结构 `employee`
--

CREATE TABLE `employee` (
  `e_id` varchar(50) NOT NULL,
  `name` varchar(20) NOT NULL,
  `account` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `idcard` varchar(20) NOT NULL,
  `photo` varchar(50) NOT NULL,
  `ren` varchar(10) DEFAULT '0',
  `lei` varchar(10) DEFAULT '0',
  `huo` varchar(10) DEFAULT '0',
  `xin` varchar(10) DEFAULT '0',
  `type` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `employee`
--

INSERT INTO `employee` (`e_id`, `name`, `account`, `password`, `idcard`, `photo`, `ren`, `lei`, `huo`, `xin`, `type`) VALUES
('1672b65e-f176-46df-881e-ebf70c13e503', 'admin', 'admin', 'admin', 'xxx', '4a8dcd10-4755-464f-be02-0526209da9e6.jpg', '1', '1', '1', '1', -1),
('310d201d-ad0b-4ccf-b22d-05a8e0e91b49', '啦啦啦', 'aaa', 'aaa', '啦啦啦', '8df3eb9e-825e-4e54-ba1a-eb4afae48054.jpg', '1', '1', '0', '0', 1),
('4caa8d9f-87eb-4b3c-842a-3932bee7101a', '大大', 'qqq', 'qqq', '大事啊', 'bd78462e-2bbe-4fa7-bc20-00881e9bcf2d.jpg', '1', '0', '0', '0', 0),
('b93d5acc-6423-43fb-aa85-6bee6f33ef68', '于海洋', '于海洋', '123456', '231', '07ad3f46-eb66-4207-86bb-90aa1d897b65.jpg', '0', '1', '1', '1', 1);

-- --------------------------------------------------------

--
-- 表的结构 `firstclass`
--

CREATE TABLE `firstclass` (
  `f_id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `firstclass`
--

INSERT INTO `firstclass` (`f_id`, `name`) VALUES
(1, '女装男装'),
(2, '鞋类箱包'),
(3, '母婴用品'),
(4, '护肤彩妆'),
(5, '汇吃美食'),
(6, '珠宝配饰'),
(7, '家装建材'),
(8, '家居家纺'),
(9, '百货市场'),
(10, '汽车用品'),
(11, '手机数码'),
(12, '家电办公'),
(13, '生活服务'),
(14, '运动户外'),
(15, '花鸟文娱'),
(16, '农资采购');

-- --------------------------------------------------------

--
-- 表的结构 `goods`
--

CREATE TABLE `goods` (
  `g_id` int(11) NOT NULL,
  `s_id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `brand` varchar(50) NOT NULL,
  `model` varchar(50) NOT NULL,
  `introduction` varchar(100) NOT NULL,
  `photo1` varchar(50) NOT NULL,
  `photo2` varchar(50) NOT NULL,
  `photo3` varchar(50) DEFAULT ' ',
  `stock` int(11) NOT NULL,
  `selnum` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `promotion` int(11) NOT NULL,
  `type` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `goods`
--

INSERT INTO `goods` (`g_id`, `s_id`, `title`, `brand`, `model`, `introduction`, `photo1`, `photo2`, `photo3`, `stock`, `selnum`, `price`, `promotion`, `type`) VALUES
(1, 1, '小粉衣服', '美邦', '666', '这是一件简单的小粉衣', 'pr.jpg', 'pr1.jpg', '', 10, 2, 69, 59, 1),
(2, 1, '小黑裤子', '安踏', '666', '这是一件简单的小黑裤', 'pr2.jpg', 'pr3.jpg', '', 10, 1, 79, 59, 1),
(3, 1, 'lv新款包 巴黎时装周同款', 'lv', 'one\'s', '正品A货 便宜实惠', 'pr4.jpg', 'pr5.jpg', '', 1, 0, 1000, 666, 1),
(4, 1, '卡西欧时尚腕表', '卡西欧', 'el', '大品牌', 'pr6.jpg', 'pr7.jpg', '', 2, 0, 20, 0, 1),
(5, 1, '耐克运动鞋', '耐克', 'aire', '好好好好', 'pr10.jpg', 'pr11.jpg', '', 5, 0, 60, 0, 1),
(6, 1, '鸿星尔克大凉鞋', '鸿星尔克', '凉鞋', 'NO.1', 'pr12.jpg', 'pr13.jpg', '', 5, 0, 33, 0, 1),
(7, 1, '浪琴女士休闲表', '浪琴', '表', '表带500 赠机芯', 'pr14.jpg', 'pr15.jpg', '', 5, 8, 500, 0, 1),
(8, 1, '阿迪小黑衣服', '阿迪', '啊', '破衣服没几个钱', 'pr8.jpg', 'pr9.jpg', '', 6, 23, 10, 5, 1),
(9, 1, '阿玛尼乡村风大牛仔衬衫子', '阿玛尼', '啊啊', '穿出自信', 'pr16.jpg', 'pr17.jpg', '', 2, 7, 35, 0, 1),
(10, 1, '纪梵希小花裙', '纪梵希', 'smart', '好品质', 'pr18.jpg', 'pr19.jpg', '', 2, 4, 1, 0, 1),
(11, 1, '彪马屎黄拉风跑鞋', '彪马', '屎黄风', '穿出你自己的味道', 'pr20.jpg', 'pr21.jpg', '', 1, 1, 99, 0, 1),
(12, 1, '天梭女士潮表', '天梭', '2016', '66666', 'pr22.jpg', 'pr23.jpg', '', 1, 0, 40, 0, 1),
(13, 1, '匹克头层牛皮男士凉鞋', '匹克', '牛', '6666 ', 'pr24.jpg', 'pr25.jpg', '', 4, 0, 70, 0, 1),
(14, 1, '杰克琼斯牛仔裤', '杰克琼斯', '2015', '好', 'pr26.jpg', 'pr27.jpg', '', 5, 0, 30, 0, 1),
(15, 1, '暴龙男士太阳镜', '暴龙', '太阳镜', '不解释', 'pr28.jpg', 'pr29.jpg', '', 6, 0, 150, 0, 1),
(16, 1, '施华洛世奇天然南非水钻表', '施华洛世奇', '表', '正品行货', 'si.jpg', 'si1.jpg', 'si2.jpg', 1, 2, 999, 0, 1),
(18, 2, '未完全', '而我却', '而我却', '驱蚊器', 'ca5e6319-56b8-4f48-b89d-0bf99e9db4c7.jpg', '5b51ce7f-0d7e-4cc0-ab8c-a9583430446b.jpg', '', 32, 0, 32, 22, 1),
(19, 2, '太热太热', '太热太热', '太热太热', '的撒的撒', 'd98c3125-50cc-4eb7-a629-19191a71a8a2.jpg', '0f10b0b9-5a4f-4cb6-8db5-30cadf81ecd8.jpg', '34954c08-6b1b-4ffa-ba8f-252702e46941.jpg', 321, 0, 66, 0, 1),
(191, 1, '测试', '电视剧啊开大了', '啥的复健科拉丝机', '额外企鹅无群二', '111eff13-1006-4cc0-bf86-a1a9c5e2e13b.jpg', '6a4526b8-0d3c-4d26-9f30-45ac0cd539cc.jpg', 'e6cb07e9-e576-48a6-bfee-ea0c07cad231.jpg', 321, 0, 21111, 0, 1);

-- --------------------------------------------------------

--
-- 表的结构 `indent`
--

CREATE TABLE `indent` (
  `i_id` varchar(40) NOT NULL,
  `c_id` varchar(40) NOT NULL,
  `a_id` varchar(10) NOT NULL,
  `g_id` int(11) NOT NULL,
  `num` int(11) NOT NULL,
  `date` varchar(20) NOT NULL,
  `evaluation` int(11) NOT NULL,
  `comment` varchar(100) NOT NULL,
  `type` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `indent`
--

INSERT INTO `indent` (`i_id`, `c_id`, `a_id`, `g_id`, `num`, `date`, `evaluation`, `comment`, `type`) VALUES
('8f64bde1-73ac-4aae-98e7-482968c1f4af', '78caf48a-c229-4740-8caf-a70f69ecbb62', '4', 12, 1, '2018-07-11 15:50:26', 1, '6666', 3),
('8f64bde1-73ac-4aae-98e7-482968c1f4af', '78caf48a-c229-4740-8caf-a70f69ecbb62', '4', 14, 1, '2018-07-11 15:50:26', 0, '', 1),
('8f64bde1-73ac-4aae-98e7-482968c1f4af', '78caf48a-c229-4740-8caf-a70f69ecbb62', '4', 15, 1, '2018-07-11 15:50:26', 0, '', 1),
('8f64bde1-73ac-4aae-98e7-482968c1f4af', '78caf48a-c229-4740-8caf-a70f69ecbb62', '4', 16, 2, '2018-07-11 15:50:26', 0, '', 1),
('46701307-0554-48a0-9b98-89d7bd04d743', '239bb9b0-cc62-424b-8188-f5f1b29ab268', '3', 11, 1, '2018-07-11 17:49:46', 0, '', 1);

-- --------------------------------------------------------

--
-- 表的结构 `indexjsp`
--

CREATE TABLE `indexjsp` (
  `top1` int(11) NOT NULL,
  `top2` int(11) NOT NULL,
  `top3` int(11) NOT NULL,
  `mid1` int(11) NOT NULL,
  `mid2` int(11) NOT NULL,
  `mid3` int(11) NOT NULL,
  `mid4` int(11) NOT NULL,
  `woman1` int(11) NOT NULL,
  `woman2` int(11) NOT NULL,
  `woman3` int(11) NOT NULL,
  `man1` int(11) NOT NULL,
  `man2` int(11) NOT NULL,
  `man3` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `indexjsp`
--

INSERT INTO `indexjsp` (`top1`, `top2`, `top3`, `mid1`, `mid2`, `mid3`, `mid4`, `woman1`, `woman2`, `woman3`, `man1`, `man2`, `man3`) VALUES
(8, 9, 10, 11, 12, 13, 14, 1, 2, 3, 4, 5, 7);

-- --------------------------------------------------------

--
-- 表的结构 `place`
--

CREATE TABLE `place` (
  `p_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `province` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `place`
--

INSERT INTO `place` (`p_id`, `name`, `province`) VALUES
(1, '北京市', 0),
(2, '天津市', 0),
(3, '上海市', 0),
(4, '重庆市', 0),
(5, '河北省', 0),
(6, '山西省', 0),
(7, '台湾省', 0),
(8, '辽宁省', 0),
(9, '吉林省', 0),
(10, '黑龙江省', 0),
(11, '江苏省', 0),
(12, '浙江省', 0),
(13, '安徽省', 0),
(14, '福建省', 0),
(15, '江西省', 0),
(16, '山东省', 0),
(17, '河南省', 0),
(18, '湖北省', 0),
(19, '湖南省', 0),
(20, '广东省', 0),
(21, '甘肃省', 0),
(22, '四川省', 0),
(23, '贵州省', 0),
(24, '海南省', 0),
(25, '云南省', 0),
(26, '青海省', 0),
(27, '陕西省', 0),
(28, '广西壮族自治区', 0),
(29, '西藏自治区', 0),
(30, '宁夏回族自治区', 0),
(31, '新疆维吾尔自治区', 0),
(32, '内蒙古自治区', 0),
(33, '澳门特别行政区', 0),
(34, '香港特别行政区', 0),
(35, '北京市', 1),
(36, '天津市', 2),
(37, '上海市', 3),
(38, '重庆市', 4),
(39, '石家庄市', 5),
(40, '唐山市', 5),
(41, '秦皇岛市', 5),
(42, '邯郸市', 5),
(43, '邢台市', 5),
(44, '保定市', 5),
(45, '张家口市', 5),
(46, '承德市', 5),
(47, '沧州市', 5),
(48, '廊坊市', 5),
(49, '衡水市', 5),
(50, '太原市', 6),
(51, '大同市', 6),
(52, '阳泉市', 6),
(53, '长治市', 6),
(54, '晋城市', 6),
(55, '朔州市', 6),
(56, '晋中市', 6),
(57, '运城市', 6),
(58, '忻州市', 6),
(59, '临汾市', 6),
(60, '吕梁市', 6),
(61, '台北市', 7),
(62, '高雄市', 7),
(63, '基隆市', 7),
(64, '台中市', 7),
(65, '台南市', 7),
(66, '新竹市', 7),
(67, '嘉义市', 7),
(68, '台北县', 7),
(69, '宜兰县', 7),
(70, '桃园县', 7),
(71, '新竹县', 7),
(72, '苗栗县', 7),
(73, '台中县', 7),
(74, '彰化县', 7),
(75, '南投县', 7),
(76, '云林县', 7),
(77, '嘉义县', 7),
(78, '台南县', 7),
(79, '高雄县', 7),
(80, '屏东县', 7),
(81, '澎湖县', 7),
(82, '台东县', 7),
(83, '花莲县', 7),
(84, '沈阳市', 8),
(85, '大连市', 8),
(86, '鞍山市', 8),
(87, '抚顺市', 8),
(88, '本溪市', 8),
(89, '丹东市', 8),
(90, '锦州市', 8),
(91, '营口市', 8),
(92, '阜新市', 8),
(93, '辽阳市', 8),
(94, '盘锦市', 8),
(95, '铁岭市', 8),
(96, '朝阳市', 8),
(97, '葫芦岛市', 8),
(98, '长春市', 9),
(99, '吉林市', 9),
(100, '四平市', 9),
(101, '辽源市', 9),
(102, '通化市', 9),
(103, '白山市', 9),
(104, '松原市', 9),
(105, '白城市', 9),
(106, '延边朝鲜族自治州', 9),
(107, '哈尔滨市', 10),
(108, '齐齐哈尔市', 10),
(109, '鹤岗市', 10),
(110, '双鸭山市', 10),
(111, '鸡西市', 10),
(112, '大庆市', 10),
(113, '伊春市', 10),
(114, '牡丹江市', 10),
(115, '佳木斯市', 10),
(116, '七台河市', 10),
(117, '黑河市', 10),
(118, '绥化市', 10),
(119, '大兴安岭地区', 10),
(120, '南京市', 11),
(121, '无锡市', 11),
(122, '徐州市', 11),
(123, '常州市', 11),
(124, '苏州市', 11),
(125, '南通市', 11),
(126, '连云港市', 11),
(127, '淮安市', 11),
(128, '盐城市', 11),
(129, '扬州市', 11),
(130, '镇江市', 11),
(131, '泰州市', 11),
(132, '宿迁市', 11),
(133, '杭州市', 12),
(134, '宁波市', 12),
(135, '温州市', 12),
(136, '嘉兴市', 12),
(137, '湖州市', 12),
(138, '绍兴市', 12),
(139, '金华市', 12),
(140, '衢州市', 12),
(141, '舟山市', 12),
(142, '台州市', 12),
(143, '丽水市', 12),
(144, '合肥市', 13),
(145, '芜湖市', 13),
(146, '蚌埠市', 13),
(147, '淮南市', 13),
(148, '马鞍山市', 13),
(149, '淮北市', 13),
(150, '铜陵市', 13),
(151, '安庆市', 13),
(152, '黄山市', 13),
(153, '滁州市', 13),
(154, '阜阳市', 13),
(155, '宿州市', 13),
(156, '巢湖市', 13),
(157, '六安市', 13),
(158, '亳州市', 13),
(159, '池州市', 13),
(160, '宣城市', 13),
(161, '福州市', 14),
(162, '厦门市', 14),
(163, '莆田市', 14),
(164, '三明市', 14),
(165, '泉州市', 14),
(166, '漳州市', 14),
(167, '南平市', 14),
(168, '龙岩市', 14),
(169, '宁德市', 14),
(170, '南昌市', 15),
(171, '景德镇市', 15),
(172, '萍乡市', 15),
(173, '九江市', 15),
(174, '新余市', 15),
(175, '鹰潭市', 15),
(176, '赣州市', 15),
(177, '吉安市', 15),
(178, '宜春市', 15),
(179, '抚州市', 15),
(180, '上饶市', 15),
(181, '济南市', 16),
(182, '青岛市', 16),
(183, '淄博市', 16),
(184, '枣庄市', 16),
(185, '东营市', 16),
(186, '烟台市', 16),
(187, '潍坊市', 16),
(188, '济宁市', 16),
(189, '泰安市', 16),
(190, '威海市', 16),
(191, '日照市', 16),
(192, '莱芜市', 16),
(193, '临沂市', 16),
(194, '德州市', 16),
(195, '聊城市', 16),
(196, '滨州市', 16),
(197, '菏泽市', 16),
(198, '郑州市', 17),
(199, '开封市', 17),
(200, '洛阳市', 17),
(201, '平顶山市', 17),
(202, '安阳市', 17),
(203, '鹤壁市', 17),
(204, '新乡市', 17),
(205, '焦作市', 17),
(206, '濮阳市', 17),
(207, '许昌市', 17),
(208, '漯河市', 17),
(209, '三门峡市', 17),
(210, '南阳市', 17),
(211, '商丘市', 17),
(212, '信阳市', 17),
(213, '周口市', 17),
(214, '驻马店市', 17),
(215, '济源市', 17),
(216, '武汉市', 18),
(217, '黄石市', 18),
(218, '十堰市', 18),
(219, '荆州市', 18),
(220, '宜昌市', 18),
(221, '襄樊市', 18),
(222, '鄂州市', 18),
(223, '荆门市', 18),
(224, '孝感市', 18),
(225, '黄冈市', 18),
(226, '咸宁市', 18),
(227, '随州市', 18),
(228, '仙桃市', 18),
(229, '天门市', 18),
(230, '潜江市', 18),
(231, '神农架林区', 18),
(232, '恩施土家族苗族自治州', 18),
(233, '长沙市', 19),
(234, '株洲市', 19),
(235, '湘潭市', 19),
(236, '衡阳市', 19),
(237, '邵阳市', 19),
(238, '岳阳市', 19),
(239, '常德市', 19),
(240, '张家界市', 19),
(241, '益阳市', 19),
(242, '郴州市', 19),
(243, '永州市', 19),
(244, '怀化市', 19),
(245, '娄底市', 19),
(246, '湘西土家族苗族自治州', 19),
(247, '广州市', 20),
(248, '深圳市', 20),
(249, '珠海市', 20),
(250, '汕头市', 20),
(251, '韶关市', 20),
(252, '佛山市', 20),
(253, '江门市', 20),
(254, '湛江市', 20),
(255, '茂名市', 20),
(256, '肇庆市', 20),
(257, '惠州市', 20),
(258, '梅州市', 20),
(259, '汕尾市', 20),
(260, '河源市', 20),
(261, '阳江市', 20),
(262, '清远市', 20),
(263, '东莞市', 20),
(264, '中山市', 20),
(265, '潮州市', 20),
(266, '揭阳市', 20),
(267, '云浮市', 20),
(268, '兰州市', 21),
(269, '金昌市', 21),
(270, '白银市', 21),
(271, '天水市', 21),
(272, '嘉峪关市', 21),
(273, '武威市', 21),
(274, '张掖市', 21),
(275, '平凉市', 21),
(276, '酒泉市', 21),
(277, '庆阳市', 21),
(278, '定西市', 21),
(279, '陇南市', 21),
(280, '临夏回族自治州', 21),
(281, '甘南藏族自治州', 21),
(282, '成都市', 22),
(283, '自贡市', 22),
(284, '攀枝花市', 22),
(285, '泸州市', 22),
(286, '德阳市', 22),
(287, '绵阳市', 22),
(288, '广元市', 22),
(289, '遂宁市', 22),
(290, '内江市', 22),
(291, '乐山市', 22),
(292, '南充市', 22),
(293, '眉山市', 22),
(294, '宜宾市', 22),
(295, '广安市', 22),
(296, '达州市', 22),
(297, '雅安市', 22),
(298, '巴中市', 22),
(299, '资阳市', 22),
(300, '阿坝藏族羌族自治州', 22),
(301, '甘孜藏族自治州', 22),
(302, '凉山彝族自治州', 22),
(303, '贵阳市', 23),
(304, '六盘水市', 23),
(305, '遵义市', 23),
(306, '安顺市', 23),
(307, '铜仁地区', 23),
(308, '毕节地区', 23),
(309, '黔西南布依族苗族自治州', 23),
(310, '黔东南苗族侗族自治州', 23),
(311, '黔南布依族苗族自治州', 23),
(312, '海口市', 24),
(313, '三亚市', 24),
(314, '五指山市', 24),
(315, '琼海市', 24),
(316, '儋州市', 24),
(317, '文昌市', 24),
(318, '万宁市', 24),
(319, '东方市', 24),
(320, '澄迈县', 24),
(321, '定安县', 24),
(322, '屯昌县', 24),
(323, '临高县', 24),
(324, '白沙黎族自治县', 24),
(325, '昌江黎族自治县', 24),
(326, '乐东黎族自治县', 24),
(327, '陵水黎族自治县', 24),
(328, '保亭黎族苗族自治县', 24),
(329, '琼中黎族苗族自治县', 24),
(330, '昆明市', 25),
(331, '曲靖市', 25),
(332, '玉溪市', 25),
(333, '保山市', 25),
(334, '昭通市', 25),
(335, '丽江市', 25),
(336, '思茅市', 25),
(337, '临沧市', 25),
(338, '文山壮族苗族自治州', 25),
(339, '红河哈尼族彝族自治州', 25),
(340, '西双版纳傣族自治州', 25),
(341, '楚雄彝族自治州', 25),
(342, '大理白族自治州', 25),
(343, '德宏傣族景颇族自治州', 25),
(344, '怒江傈傈族自治州', 25),
(345, '迪庆藏族自治州', 25),
(346, '西宁市', 26),
(347, '海东地区', 26),
(348, '海北藏族自治州', 26),
(349, '黄南藏族自治州', 26),
(350, '海南藏族自治州', 26),
(351, '果洛藏族自治州', 26),
(352, '玉树藏族自治州', 26),
(353, '海西蒙古族藏族自治州', 26),
(354, '西安市', 27),
(355, '铜川市', 27),
(356, '宝鸡市', 27),
(357, '咸阳市', 27),
(358, '渭南市', 27),
(359, '延安市', 27),
(360, '汉中市', 27),
(361, '榆林市', 27),
(362, '安康市', 27),
(363, '商洛市', 27),
(364, '南宁市', 28),
(365, '柳州市', 28),
(366, '桂林市', 28),
(367, '梧州市', 28),
(368, '北海市', 28),
(369, '防城港市', 28),
(370, '钦州市', 28),
(371, '贵港市', 28),
(372, '玉林市', 28),
(373, '百色市', 28),
(374, '贺州市', 28),
(375, '河池市', 28),
(376, '来宾市', 28),
(377, '崇左市', 28),
(378, '拉萨市', 29),
(379, '那曲地区', 29),
(380, '昌都地区', 29),
(381, '山南地区', 29),
(382, '日喀则地区', 29),
(383, '阿里地区', 29),
(384, '林芝地区', 29),
(385, '银川市', 30),
(386, '石嘴山市', 30),
(387, '吴忠市', 30),
(388, '固原市', 30),
(389, '中卫市', 30),
(390, '乌鲁木齐市', 31),
(391, '克拉玛依市', 31),
(392, '石河子市　', 31),
(393, '阿拉尔市', 31),
(394, '图木舒克市', 31),
(395, '五家渠市', 31),
(396, '吐鲁番市', 31),
(397, '阿克苏市', 31),
(398, '喀什市', 31),
(399, '哈密市', 31),
(400, '和田市', 31),
(401, '阿图什市', 31),
(402, '库尔勒市', 31),
(403, '昌吉市　', 31),
(404, '阜康市', 31),
(405, '米泉市', 31),
(406, '博乐市', 31),
(407, '伊宁市', 31),
(408, '奎屯市', 31),
(409, '塔城市', 31),
(410, '乌苏市', 31),
(411, '阿勒泰市', 31),
(412, '呼和浩特市', 32),
(413, '包头市', 32),
(414, '乌海市', 32),
(415, '赤峰市', 32),
(416, '通辽市', 32),
(417, '鄂尔多斯市', 32),
(418, '呼伦贝尔市', 32),
(419, '巴彦淖尔市', 32),
(420, '乌兰察布市', 32),
(421, '锡林郭勒盟', 32),
(422, '兴安盟', 32),
(423, '阿拉善盟', 32),
(424, '澳门特别行政区', 33),
(425, '香港特别行政区', 34);

-- --------------------------------------------------------

--
-- 表的结构 `secondclass`
--

CREATE TABLE `secondclass` (
  `s_id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `f_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `secondclass`
--

INSERT INTO `secondclass` (`s_id`, `name`, `f_id`) VALUES
(1, '潮流女装', 1),
(2, '时尚男装', 1),
(3, '性感内衣', 1),
(4, '羽绒服', 1),
(5, '秋外套', 1),
(6, '文胸', 1),
(7, '呢外套', 1),
(8, '衬衫', 1),
(9, 'T恤', 1),
(10, '家居服', 1),
(11, '毛衣', 1),
(13, '休闲裤', 1),
(14, '牛仔裤', 1),
(15, '内裤', 1),
(16, '外套上衣', 1),
(17, '袜类', 1),
(18, '女鞋', 2),
(19, '潮流女包', 2),
(20, '帽子', 2),
(21, '单鞋', 2),
(22, '精品男包', 2),
(23, '腰带', 2),
(24, '运动风鞋', 2),
(25, '双肩包', 2),
(26, '围巾', 2),
(27, '男鞋', 2),
(28, '旅行箱', 2),
(29, '手套', 2),
(30, '休闲男鞋', 2),
(31, '其他', 2),
(33, '啧啧啧啧啧啧啧啧啧', 17),
(34, '啦啦啦啦啦啦', 2),
(0, '未分类', NULL),
(35, '帐篷', 14),
(36, '睡袋', 14),
(37, '登山杖', 14);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;