master

分支 (1)

管理

管理

master

miaoui.com
/
miaoui_db.sql

/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : miaoui_db

Target Server Type    : MYSQL
Target Server Version : 50717
File Encoding         : 65001

Date: 2019-03-15 14:55:00
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for book_item
-- ----------------------------
DROP TABLE IF EXISTS `book_item`;
CREATE TABLE `book_item` (
  `bid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL,
  `description` varchar(255) NOT NULL,
  `author` varchar(45) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_date` datetime NOT NULL,
  `chinese_name` varchar(45) NOT NULL,
  `whole_name` varchar(45) NOT NULL,
  `english_name` varchar(45) NOT NULL,
  `category_id` int(11) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `publish_date` date NOT NULL,
  `content` text NOT NULL,
  PRIMARY KEY (`bid`),
  UNIQUE KEY `uid_UNIQUE` (`bid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of book_item
-- ----------------------------

-- ----------------------------
-- Table structure for software_item
-- ----------------------------
DROP TABLE IF EXISTS `software_item`;
CREATE TABLE `software_item` (
  `sid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(45) NOT NULL,
  `description` varchar(255) NOT NULL,
  `author` varchar(45) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_date` datetime NOT NULL,
  `chinese_name` varchar(45) NOT NULL,
  `whole_name` varchar(45) NOT NULL,
  `english_name` varchar(45) NOT NULL,
  `category_id` int(11) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `publish_date` date NOT NULL,
  `content` text NOT NULL,
  PRIMARY KEY (`sid`),
  UNIQUE KEY `uid_UNIQUE` (`sid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of software_item
-- ----------------------------
INSERT INTO `software_item` VALUES ('1', 'Photoshop', '•当阅读跟踪 - Canary Mail在您的电子邮件阅读时立即通知您。\n\n•电子邮件暂停 - 立即声明收件箱，并在方便的时候处理电子邮件。\n\n•统一收件箱 - Canary Mail功能统一的收件箱，并支持Gmail，Yahoo !, Outlook，FastMail和通用IMAP。\n\n•完全本地 - 您的电子邮件是加密的，本地安全地存储在您的Mac上，而不是在线服务器上。\n\n•Gmail标签和过滤器 - Canary支持Gmail用户喜爱的标签和社交/促销电子邮件隔离。\n\n•附件浏览器 - 快速查找，', '', '2017-12-06 00:00:00', '2018-01-19 15:44:53', 'Photoshop CS6 ', '', '', '1', 'https://www.baidu.com/img/bd_logo1.png', '', '2017-01-10', '');
INSERT INTO `software_item` VALUES ('2', 'Dreamweaver CS6', 'Where does it come from?\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in', '', '2017-11-15 00:00:00', '2018-01-12 13:34:44', 'Dreamweaver CS6', '', '', '2', 'https://www.baidu.com/img/bd_logo1.png', '', '2017-01-10', '');
INSERT INTO `software_item` VALUES ('3', 'Flash CS4', 'egr', 'Adobe', '2017-12-13 00:00:00', '2018-01-12 13:35:13', 'Flash CS4', '', '', '3', 'https://www.baidu.com/img/bd_logo1.png', '', '2017-01-10', '');
INSERT INTO `software_item` VALUES ('4', 'Muse', '必需。规定输出日期字符串的格式。可使用下列字符：\n\nd - 一个月中的第几天（从 01 到 31）\nD - 星期几的文本表示（用三个字母表示）\nj - 一个月中的第几天，不带前导零（1 到 31）\nl（\'L\' 的小写形式）- 星期几的完整的文本表示\nN - 星期几的 ISO-8601 数字格式表示（1表示Monday[星期一]，7表示Sunday[星期日]）\nS - 一个月中的第几天的英语序数后缀（2 个字符：st、nd、rd 或 th。与 j 搭配使用）\nw - 星期几的数字表示（0 表示 Sunday', '', '2017-12-04 00:00:00', '2018-02-14 11:58:01', 'Notepad++', '', '', '3', '//img3.uiimage.com/b0b6c543279454c1b989685cbdd02f45.jpg', '', '2017-01-10', '<p><br/></p><p><br/></p><p style=\"text-align: left;\"><img src=\"http://img3.uiimage.com/b0b6c543279454c1b989685cbdd02f45.jpg\" _src=\"http://img3.uiimage.com/b0b6c543279454c1b989685cbdd02f45.jpg\"/></p><p><br/></p><p><br/></p><p><br/></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\"><span style=\"font-size:16px\">一、用户旅程地图是什么？</span></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">用户旅程地图是以视觉化呈现用户为达成某一目标所历经过程的工具，通过创建历程图，能够更好地理解目标用户在特定时间里的感受、想法和行为，认识到这个过程的演变过程，寻找用户的痛点，通过讲故事（Storytelling）的方式描述用户的体验过程，采用视觉化（Visualization）的方式将信息高效简单明了的呈现出来，便于记忆与团队分享。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\"><img src=\"http://i.chanpin100.com/151727429312093897\" style=\"box-sizing: border-box; vertical-align: middle; border: 0px; margin: 40px auto; max-width: 100%; display: block;\"/></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">每一张旅程地图都会因场景不同而各不相同，但一般而言，它们都包括了“Lens”（用户视角），体验的流程，机会点洞察三大区块。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">Zone&nbsp;A：Lens区域包括</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">（1）用户的人物画像（“who”）以及产品的使用场景（“what”）</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">（2）为旅程地图提供基本的人物情境设定</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">Zone&nbsp;B：是旅程地图的核心部分，包括用户体验历程的各个阶段划分</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">（3）用户的行为</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">（4）想法</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">（5）感受</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">（6）根据用户调研反馈填写</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">Zone&nbsp;C：此区域会因各项目商业目标的不同而不同：</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">（7）未来的机会点</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">（8）企业内部主导权分配</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">以教育培训类产品为例，见下图，用户从一个陌生人，到进入产品浏览课程，发起在线咨询，预约听课，购买课程就是该产品的用户旅程。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\"><img src=\"http://i.chanpin100.com/151727430288258035\" style=\"box-sizing: border-box; vertical-align: middle; border: 0px; margin: 40px auto; max-width: 100%; display: block;\"/></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\"><span style=\"box-sizing: border-box; font-weight: 700;\">二、为什么需要创建用户旅程地图？</span></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">用户旅程地图是一个强大的工具，如果你是产品经理，它会帮你理解用户的使用场景，清晰地了解用户来源以及他们试图达到怎样的目的；如果你是内容运营，它将帮你理解用户遇到的问题以及他们的感受，并且可以提供给管理者用户体验的全景图：看到用户是如何在销售漏斗中流动的，进而提升用户体验。此外，用户旅程地图还可以呈现出用户服务的提升是如何改变消费体验的，洞察到用户体验中的断层和痛点，比如：设备间的断层，这发生在用户在不同的设备间切换时；来自部门之间的断层，用户可能会感觉受挫；市场推广中的断层（例如：从社会化媒体跳转到网站体验可能会更好些）。</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">值得强调的是，因为手机、社会化媒体和网络正在改变用户行为，因此企业需要更加聚焦用户需求，深入研究以用户为中心的旅程地图，那么，我们该从何处着手呢？</p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\"><span style=\"box-sizing: border-box; font-weight: 700;\">三、如何研究用户旅程？</span></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 20px; word-break: break-all; word-wrap: break-word; color: rgb(51, 51, 51); line-height: 30px; font-family: &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft Yahei&quot;, arial, 宋体, &quot;Helvetica Neue&quot;, Helvetica, STHeiTi, sans-serif; white-space: normal;\">创建用户旅程地图的过程必须始于了解用户旅程，以在线英语教育类产品为例，随着知识商业化的到来，其中最核心的企业能力是获取付费用户，以及服务付费用户的能力。付费的流量和免费的流量完全不一样，付费流量是一种基于场景和服务的流量，本质是在帮用户解决一个问题，而不是将内容在用户面前刷一次脸就行，你需要进一步影响人心，说服用户为什么现在应该给你付钱，买你的解决方案。因此只有那些具有竞争力的知识产品和付费模式才能在行业服务产业链中进一步渗透。</p><p><br/></p>');
INSERT INTO `software_item` VALUES ('5', 'Sketch', 'erge', '', '2017-05-24 00:00:00', '2018-02-14 12:08:55', 'Sketch', '', '', '1', 'https://www.baidu.com/img/bd_logo1.png', '', '2017-01-10', '');
INSERT INTO `software_item` VALUES ('6', 'Premire', '四渡赤水', '', '2017-06-28 00:00:00', '0000-00-00 00:00:00', 'Notepad++', '', '', '1', 'https://www.baidu.com/img/bd_logo1.png', '', '2017-01-10', '');
INSERT INTO `software_item` VALUES ('7', 'Effect', '从', '', '2017-12-12 00:00:00', '0000-00-00 00:00:00', 'Notepad++', '', '', '1', 'https://www.baidu.com/img/bd_logo1.png', '', '2017-01-10', '');
INSERT INTO `software_item` VALUES ('8', 'Photoshop', '•当阅读跟踪 - Canary Mail在您的电子邮件阅读时立即通知您。\n\n•电子邮件暂停 - 立即声明收件箱，并在方便的时候处理电子邮件。\n\n•统一收件箱 - Canary Mail功能统一的收件箱，并支持Gmail，Yahoo !, Outlook，FastMail和通用IMAP。\n\n•完全本地 - 您的电子邮件是加密的，本地安全地存储在您的Mac上，而不是在线服务器上。\n\n•Gmail标签和过滤器 - Canary支持Gmail用户喜爱的标签和社交/促销电子邮件隔离。\n\n•附件浏览器 - 快速查找，', '', '2017-12-12 00:00:00', '2018-01-12 13:32:59', 'Photoshop CS6 ', '', '', '2', 'https://www.baidu.com/img/bd_logo1.png', '', '2017-01-10', '');
INSERT INTO `software_item` VALUES ('9', 'Axure', 'Layui 是一款采用自身模块规范编写的情怀型前端UI框架，遵循原生HTML/CSS/JS的书写与组织形式，门槛极低，拿来即用。其外在极简，却又不失饱满的内在，体积轻盈，组件丰盈，从核心代码到API的每一处细节都经过精心雕琢，非常适合界面的快速开发。网址：http://www.layui.com/\n本 LayUI Axure组件库，参照LayUI最新的组件，高度还原组件样式，包括按钮、输入框、下拉框、导航栏、分页、进度条、导航、单选框、多选框、文本等多种常用的控件，对大部分的hover、选中、下拉等交互效', '', '2017-12-05 00:00:00', '2018-01-12 05:29:56', 'Axure', '', '', '2', 'https://www.baidu.com/img/bd_logo1.png', '', '2017-01-10', '');
INSERT INTO `software_item` VALUES ('10', 'Action Script', 'ActionScript（简称AS）是由Macromedia（现已被Adobe收购）为其Flash产品开发的 ，最初是一种简单的脚本语言，现在最新版本ActionScript3.0，是一种完全的面向对象的编程语言，功能强大，类库丰富，语法类似JavaScript，多用于Flash互动性、娱乐性、实用性开发，网页制作和RIA（丰富互联网程序）开发。', '', '2017-12-05 00:00:00', '2018-01-19 16:26:22', 'as', '', '', '4', 'https://www.baidu.com/img/bd_logo1.png', '', '2017-01-10', '');
INSERT INTO `software_item` VALUES ('11', 'test', 'sdfs', '', '2018-01-17 20:38:31', '0000-00-00 00:00:00', 'tste', '', '', '1', 'http://www.w3csky.com/logo.png', '', '0000-00-00', '');
INSERT INTO `software_item` VALUES ('12', 'wedf', 'sdfs', '', '2018-01-17 20:39:28', '0000-00-00 00:00:00', 'sdfs', '', '', '1', 'http://www.w3csky.com/logo.png', '', '0000-00-00', '');
INSERT INTO `software_item` VALUES ('13', 'sdsd', 'sdfs', '', '2018-01-17 20:54:54', '2018-02-15 17:27:33', 'sdfs', '', '', '1', 'http://www.w3csky.com/logo.png', '', '0000-00-00', '');
INSERT INTO `software_item` VALUES ('14', 'Test', 'sfsfds', '', '2018-02-15 17:14:46', '2018-02-24 17:38:21', 'test', '', '', '1', '//img3.uiimage.com/77ce6c70525be0fcb55db5805903af2d.jpg', '', '0000-00-00', '<p>\n    <img src=\"http://img1.uiimage.com/1ce8dc1996ae05f6feddc1cd74b4a00a.jpg\" _src=\"http://img1.uiimage.com/1ce8dc1996ae05f6feddc1cd74b4a00a.jpg\"/>\n</p>\n<p>\n    ssfdss\n</p>');
INSERT INTO `software_item` VALUES ('15', 'Test', 'sfsfds', '', '2018-02-15 17:16:13', '0000-00-00 00:00:00', 'test', 'wew', 'werw', '1', '//img3.uiimage.com/77ce6c70525be0fcb55db5805903af2d.jpg', '', '0000-00-00', '<p>ssfdss</p>');
INSERT INTO `software_item` VALUES ('16', 'Test', 'sfsfds', '', '2018-02-15 17:17:36', '0000-00-00 00:00:00', 'test', 'wew', 'werw', '1', '//img3.uiimage.com/77ce6c70525be0fcb55db5805903af2d.jpg', 'sdsa', '0000-00-00', '<p>ssfdss</p>');
INSERT INTO `software_item` VALUES ('17', 'Test', 'sfsfds', '', '2018-02-15 17:19:45', '0000-00-00 00:00:00', 'test', 'wew', 'werw', '1', '//img3.uiimage.com/77ce6c70525be0fcb55db5805903af2d.jpg', 'sdsa', '0000-00-00', '<p>ssfdss</p>');
INSERT INTO `software_item` VALUES ('18', 'Test', 'sfsfds', 'dscs', '2018-02-15 17:21:30', '0000-00-00 00:00:00', 'test', 'wew', 'werw', '1', '//img3.uiimage.com/77ce6c70525be0fcb55db5805903af2d.jpg', 'sdsa', '0000-00-00', '<p>ssfdss</p>');
INSERT INTO `software_item` VALUES ('19', 'Test', 'sfsfds', 'dscs', '2018-02-15 17:26:12', '0000-00-00 00:00:00', 'test', 'wew', 'werw', '2', '//img3.uiimage.com/77ce6c70525be0fcb55db5805903af2d.jpg', 'sdsa', '0000-00-00', '<p>ssfdss</p>');
INSERT INTO `software_item` VALUES ('20', 'SId', 'werwe', 'rwerw', '2018-02-15 17:45:09', '2018-02-15 17:56:13', 'wer', 'dsada', 'asdadasd', '0', '//img4.uiimage.com/8c001be0ee3624690e69e78277d4587d.jpg', '', '0000-00-00', '');

-- ----------------------------
-- Table structure for software_item_tag_releation
-- ----------------------------
DROP TABLE IF EXISTS `software_item_tag_releation`;
CREATE TABLE `software_item_tag_releation` (
  `pid` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  PRIMARY KEY (`pid`,`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of software_item_tag_releation
-- ----------------------------

-- ----------------------------
-- Table structure for software_tag
-- ----------------------------
DROP TABLE IF EXISTS `software_tag`;
CREATE TABLE `software_tag` (
  `tid` int(11) NOT NULL,
  `tag_name` varchar(255) NOT NULL,
  `sid` int(11) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of software_tag
-- ----------------------------
INSERT INTO `software_tag` VALUES ('1', 'Photoshop', '1');
INSERT INTO `software_tag` VALUES ('2', 'Sketch', '1');