易购后台管理系统的数据库文件ego

-- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: 2021-04-08 06:52:52 -- 服务器版本： 10.1.19-MariaDB -- PHP Version: 5.6.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 utf8mb4 */; -- -- Database: `ego` -- -- -------------------------------------------------------- -- -- 表的结构 `category` -- CREATE TABLE `category` ( `id` int(11) DEFAULT NULL, `name` text, `cid` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `category` -- INSERT INTO `category` (`id`, `name`, `cid`) VALUES (1, '家用电器', 1001), (1, '手机/运营商/数码', 1002), (1, '电脑/办公', 1003), (1, '家具/家居', 1004), (1001, '电视', 100001), (1001, '空调', 10002), (1001, '洗衣机', 10003), (1001, '冰箱', 10004), (1002, '手机通讯', 10001), (1002, '运营商', 10002), (1002, '摄影', 10003), (1002, '摄像', 10004), (1003, '电脑整机', 10001), (1003, '电脑配件', 10002), (1003, '外设产品', 10003), (1003, '游戏设备', 10004), (1004, '厨具', 10001), (1004, '家纺', 10002), (1004, '灯具', 10003), (1004, '家具', 10004), (100001, '超薄点视', 100004), (100001, '全面屏点视', 100005); -- -------------------------------------------------------- -- -- 表的结构 `content` -- CREATE TABLE `content` ( `id` int(11) DEFAULT NULL, `name` text NOT NULL, `pid` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `content` -- INSERT INTO `content` (`id`, `name`, `pid`) VALUES (1001, 'banner广告', 10001), (1003, '电子产品广告', 10003), (19412, '刚刚赚了很多钱', 89602), (1004, '京东618', 90410), (90410, '电脑', 56320), (1, '广告分类', 1001), (10001, '侧边广告', 8020), (10001, 'bbb', 1529), (10001, 'cc', 474), (10002, 'bbb', 9196), (10001, 'nnn', 280), (10002, '冲冲冲', 2999), (1001, '2021京东618', 100); -- -------------------------------------------------------- -- -- 表的结构 `contentinfo` -- CREATE TABLE `contentinfo` ( `id` int(11) NOT NULL, `pid` int(11) NOT NULL, `name` text NOT NULL, `url` text NOT NULL, `image` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `contentinfo` -- INSERT INTO `contentinfo` (`id`, `pid`, `name`, `url`, `image`) VALUES (1, 10001, 'OPPO Watch', 'https://pro.jd.com/mall/active/tG3nBBhghqhfM69HoJw9ZoDaT7d/index.html?extension_id=eyJhZCI6IiIsImNoIjoiIiwic2hvcCI6IiIsInNrdSI6IiIsInRzIjoiIiwidW5pcWlkIjoie1wiY2xpY2tfaWRcIjpcIjg5YzRjMTUyLWUwZjktNGQ0OC05NDI4LTJhODQ4NWJjNTc1N1wiLFwibWF0ZXJpYWxfaWRcIjpcIjE4NTAxMDcyMjlcIixcInBvc19pZFwiOlwiNDI3MlwiLFwic2lkXCI6XCJmODcwZmM2MS1jYjc3LTQwN2UtOTM1ZC1jYzhlZTc0MTYyZTdcIn0ifQ==&jd_pop=89c4c152-e0f9-4d48-9428-2a8485bc5757&abt=1', '//img14.360buyimg.com/pop/s1180x940_jfs/t1/110562/14/10737/42247/5e81bb76E6fffa006/b3f703f750bd37ea.jpg.webp'), (3, 90410, '椅子', 'https://channel-m.jd.com/pc/psp/10979325649?imup=CgwKBnd3dGxpdRIAGAASEAjR7azzKBDmZhoAIJpNKAEYsRsgACoUaWwsdWEseGdiLGdhLGNpYSxiYWEyAmlsOioKCWpkX2hiZHl5MRDnYRgCIJL50ty1x-S1dyjCo6Q3MMGjpDc4E0CAgCA&extension_id=eyJhZCI6IiIsImNoIjoiIiwic2hvcCI6IiIsInNrdSI6IiIsInRzIjoiIiwidW5pcWlkIjoie1wiY2xpY2tfaWRcIjpcIjJiNmEyNjE5LWE4MmItNGMyNi1iYzYwLWI3ZGE1NzljOWRkZVwiLFwibWF0ZXJpYWxfaWRcIjpcIjg2MDUxMzIyOTY2NTg2NjQ1OTRcIixcInBvc19pZFwiOlwiMzUwNVwiLFwic2lkXCI6XCJmN2Y5ODM2ZS0yZTViLTQyMTUtYWNiMi04NDdmZmI2N2U2ZDdcIn0ifQ==&jd_pop=2b6a2619-a82b-4c26-bc60-b7da579c9dde&abt=0', 'https://img12.360buyimg.com/pop/s1180x940_jfs/t1/117573/18/9029/83238/5ed7c92aE789977c2/b11a288a7284cdfe.jpg.webp'), (5, 10002, 'fggh', 'dffg', 'dfdf'), (6, 10002, 'hhh', 'hh', 'hh'), (7, 10002, 'hhh', 'hh', 'hhh'), (8, 10002, 'hhh', 'hh', 'hh'), (9, 10002, 'aaa', 'aa', 'aaa'), (11, 10001, '轮播图', 'http://www.baidu.com', 'http://www.baidu.com/banner.jpg'), (12, 10001, '轮播图', 'http://www.baidu.com', 'http://www.baidu.com/banner.jpg'), (13, 10001, 'hjh', '6666', '666'); -- -------------------------------------------------------- -- -- 表的结构 `params` -- CREATE TABLE `params` ( `id` int(11) NOT NULL, `itemCatId` text NOT NULL, `paramData` text NOT NULL, `specsName` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `params` -- INSERT INTO `params` (`id`, `itemCatId`, `paramData`, `specsName`) VALUES (10027, '10003', '[{"value":"","title":"外观","children":[{"value":"","title":"体重"}]}]', '外设产品'), (10031, '10002', '[{"value":"","title":"基本参数","children":[{"value":"","title":"外观"},{"value":"","title":"重量"},{"value":"","title":"生产时期"}]},{"value":"","title":"形状","children":[{"value":"","title":"耗电量"}]}]', '空调'), (10032, '10003', '[{"value":"","title":"基本信息","children":[{"value":"","title":"体重"}]}]', '外设产品'), (10033, '1004', '[{"value":"","title":"材料","children":[{"value":"","title":"纯棉"},{"value":"","title":"蕾丝"}]}]', '家具/家居'), (10036, '10004', '[{"value":"","title":"多少度","children":[]}]', '摄像'), (10037, '1004', '[{"value":"","title":"方法","children":[{"value":"","title":"热"}]}]', '家具/家居'), (10044, '1003', '[{"value":"","title":"基本信息","children":[{"value":"","title":"外观"}]},{"value":"","title":"特殊配置","children":[{"value":"","title":"内存"}]}]', '电脑/办公'), (10045, '1001', '[{"value":"","title":"dsds","children":[{"value":"","title":"dff"}]}]', '家用电器'), (10046, '1002', '[{"value":"","title":"基本信息","children":[{"value":"","title":"参数"}]}]', '手机/运营商/数码'), (10047, '1003', '[{"value":"","title":"过分过分过分","children":[{"value":"","title":"55人"}]}]', '电脑/办公'), (10049, '1002', '[{"value":"","title":"配置参数","children":[{"value":"","title":"外观"}]}]', '手机/运营商/数码'), (10051, '1001', '[{"value":"","title":"配置","children":[{"value":"","title":"111"}]}]', '家用电器'), (10052, '10004', '[{"value":"","title":"配置","children":[{"value":"","title":"111"}]}]', '摄像'), (10053, '1004', '[{"value":"","title":"家具","children":[{"value":"","title":"床"}]}]', '家具/家居'), (10059, '10004', '[{"value":"","name":"基本信息","children":[{"value":"","name":"材料组成"},{"value":"","name":"使用寿命"}]}]', '冰箱'), (10060, '10001', '[{"value":"","title":"手机配置","children":[{"value":"","title":"尺寸"},{"value":"","title":"像素"},{"value":"","title":"内存"}]}]', '手机通讯'), (10061, '1001', '[{"value":"","title":"外观","children":[{"value":"","title":"高度"},{"value":"","title":"重量"}]}]', '家用电器'), (10062, '10004', '[{"value":"","title":"66","children":[{"value":"","title":"666"}]}]', '冰箱'); -- -------------------------------------------------------- -- -- 表的结构 `project` -- CREATE TABLE `project` ( `id` int(11) NOT NULL, `title` text NOT NULL, `image` text NOT NULL, `sellPoint` text NOT NULL, `price` text NOT NULL, `cid` text NOT NULL, `category` text, `num` text NOT NULL, `barcode` text NOT NULL, `status` text NOT NULL, `created` text NOT NULL, `updated` text NOT NULL, `descs` text NOT NULL, `paramsInfo` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `project` -- INSERT INTO `project` (`id`, `title`, `image`, `sellPoint`, `price`, `cid`, `category`, `num`, `barcode`, `status`, `created`, `updated`, `descs`, `paramsInfo`) VALUES (10015, '三体-刘慈欣', '', '未来科幻', '99', '', NULL, '999', '', '', '', '', '<p>这是大刘的得意之作，连奥巴马都喜欢看！</p>', NULL), (10028, '梦里花落知多少', '2.jpg', '小时代！！！', '11', '10001', NULL, '11', '', '', '', '', '<p>还不错，但是要看书籍，不要看电影</p>