tp5购物商场

-- phpMyAdmin SQL Dump -- version phpStudy 2014 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2018 �?06 �?05 �?00:34 -- 服务器版本: 5.5.53 -- PHP 版本: 5.6.27 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 */; -- -- 数据库: `electronics` -- -- -------------------------------------------------------- -- -- 表的结构 `admin` -- CREATE TABLE IF NOT EXISTS `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(32) NOT NULL DEFAULT '', `password` varchar(32) NOT NULL, `create_time` int(11) NOT NULL DEFAULT '0', `update_time` int(11) NOT NULL DEFAULT '0', `last_login_time` int(11) NOT NULL DEFAULT '0', `status` tinyint(1) DEFAULT '0', `code` int(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; -- -- 转存表中的数据 `admin` -- INSERT INTO `admin` (`id`, `username`, `password`, `create_time`, `update_time`, `last_login_time`, `status`, `code`) VALUES (1, 'admin', 'd84964cfa4c20945679e97b3a9779aa2', 0, 1495108805, 1495108805, 1, 1252), (3, 'ada', 'e2a6a938237fa344a1a9754bdebf4ae3', 1527407429, 1527407429, 0, 1, 5040), (4, 'ada', '629e98b985c78632b27b3d4ecd205feb', 1527409731, 1527409731, 0, 1, 9589), (5, '123', '7fcfa5b51bf2130eecd22a2938e29050', 1527409801, 1527409801, 0, 1, 2237); -- -------------------------------------------------------- -- -- 表的结构 `area` -- CREATE TABLE IF NOT EXISTS `area` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `city_id` int(11) unsigned NOT NULL DEFAULT '0', `parent_id` int(10) unsigned NOT NULL DEFAULT '0', `listorder` int(8) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '0', `create_time` int(11) unsigned NOT NULL DEFAULT '0', `update_time` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), KEY `city_id` (`city_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的结构 `bis` -- CREATE TABLE IF NOT EXISTS `bis` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `email` varchar(50) NOT NULL DEFAULT '', `logo` varchar(255) NOT NULL DEFAULT '', `licence_logo` varchar(255) NOT NULL DEFAULT '', `description` text NOT NULL, `city_id` int(11) unsigned NOT NULL DEFAULT '0', `city_path` varchar(50) NOT NULL DEFAULT '', `bank_info` varchar(50) NOT NULL DEFAULT '', `money` decimal(20,2) NOT NULL DEFAULT '0.00', `bank_name` varchar(50) NOT NULL DEFAULT '', `bank_user` varchar(50) NOT NULL DEFAULT '', `faren` varchar(20) NOT NULL DEFAULT '', `faren_tel` varchar(20) NOT NULL DEFAULT '', `listorder` int(8) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '0', `create_time` int(11) unsigned NOT NULL DEFAULT '0', `update_time` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `city_id` (`city_id`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ; -- -- 转存表中的数据 `bis` -- INSERT INTO `bis` (`id`, `name`, `email`, `logo`, `licence_logo`, `description`, `city_id`, `city_path`, `bank_info`, `money`, `bank_name`, `bank_user`, `faren`, `faren_tel`, `listorder`, `status`, `create_time`, `update_time`) VALUES (60, '吕程达', '304368809@qq.com', '/upload\\20180315\\6a2faa6e895a879b255f627a3a9a2cb5.jpg', '/upload\\20180315\\bc2f46536bc6a7118b9bd2c53695b4f9.jpg', '<p>帅哥</p>', 2, '2,21', '2334', '0.00', '工行', '流程', '法人', '123', 0, 1, 1521119199, 1521204439), (61, '帅哥', '304368809@qq.com', '/upload\\20180318\\7995e79caa0d48852e5ac515eda22a97.jpg', '/upload\\20180318\\41f9d8c31dfa607f6f9c074bdd11c83f.jpg', '<p>22</p>', 2, '2,24', '尼', '0.00', '吕', '吕', '吕', '123', 0, 1, 1521337722, 1521337754), (62, '刘德华', '304368809@qq.com', '/upload\\20180326\\e1168e8d6b90842050eb23d65c91633c.jpg', '/upload\\20180326\\c952c155e7e57b694bc2785d72d5183a.jpg', '<p>222</p>', 1, '1,11', '111', '0.00', '工行', '流程', '1111', '111', 0, 1, 1522070483, 1522070591), (63, '&lt;script&gt;alert()&lt;/script&gt;', '304368809@qq.com', '/upload\\20180402\\311799206b018aafff5c5f8ae4e1a163.jpg', '/upload\\20180402\\aa1a35e86ef3d3144968d26fa1d8ee7b.jpg', '<p>1</p>', 8, '8,81', '1', '0.00', '1', '2', '3223', '4', 0, 1, 1522678611, 1523354216), (64, '&lt;', '', '', '', '', 0, '0', '', '0.00', '', '', '', '', 0, 2, 1522678721, 1522679196), (65, '&lt;script&gt;alert(''niahao'')&lt;/script&gt;', '304368809@qq.com', '/upload\\20180402\\f287f8bf3ba887a70b787401cc8360ce.jpg', '/upload\\20180402\\2d83f1dce30afce30a2156b93cd5ebd9.jpg', '<p>22</p>', 2, '2,22', '11', '0.00', '11', '1', '1111', '12', 0, 2, 1522678805, 1523354136), (66, 'ada', '304368809@qq.com', '/upload\\20180402\\8ad7609b969dbb9e31c5b46fb5cc9284.jpg', '/upload\\20180402\\3aef90ab10e8e9f05e7bd1d81349a03e.jpg', '<p>333</p>', 2, '2,24', '33', '0.00', '11', '11', '22', '22', 0, 0, 1522679791, 1522679791), (68, 'just-dance', '304368809@qq.com', '/upload\\20180410\\c1b97861895b25656a979570a8504cec.jpg', '/upload\\20180410\\0695b77f0b7bf9062e73cb7fcdc61b14.jpg', '&lt;p&gt;11&lt;/p&gt;', 8, '8,81', '111', '0.00', '11', '22', '22', '33', 0, 0, 1523346795, 1523346795); -- -------------------------------------------------------- -- -- 表的结构 `bis_account` -- CREATE TABLE IF NOT EXISTS `bis_account` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL DEFAULT '', `password` char(32) NOT NULL DEFAULT '', `code` varchar(10) NOT NULL DEFAULT '', `bis_id` int(11) unsigned NOT NULL DEFAULT '0', `last_login_ip` varchar(20) NOT NULL DEFAULT '', `last_login_time` int(11) unsigned NOT NULL DEFAULT '0', `is_main` tinyint(1) unsigned NOT NULL DEFAULT '0', `listorder` int(8) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '0', `create_time` int(11) unsigned NOT NULL DEFAULT '0', `update_time` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `bis_id` (`bis_id`), KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ; -- -- 转存表中的数据 `bis_account` -- INSERT INTO `bis_account` (`id`, `username`, `password`, `code`, `bis_id`, `last_login_ip`, `last_login_time`, `is_main`, `listorder`, `status`, `create_time`, `update_time`) VALUES (42, 'ada', '6dc73de224a4b42edac684ad5e05c821', '5360', 60, '', 0, 1, 0, 1, 1521119199, 1521204440), (43, 'root', '806353568ecb4f92a19b7083070bfdfd', '8737', 61, '', 1527412112, 1, 0, 1, 1521337722, 1527412112), (44, 'qqq', '44ff79c220d70abffa934797192bcfee', '4107', 62, '', 1522070615, 1, 0, 1, 1522070483, 1522070615), (45, '周杰伦', '76872bcd9d6e7fd160e3f7adefa6423e', '979', 63, '', 0, 1, 0, 1, 1522678611, 1523354216), (46, 'dssd343', '00405e1f0cecc1e50854a2705f148448', '9135', 64, '', 0, 1, 0, 2, 1522678721, 1522679196), (47, '无聊', '02180771a9b609a26dcea07f272e141f', '951', 65, '', 0, 1, 0, 2, 1522678805, 1523354136), (48, 'z''z''z', '4cf3ba5ef2fc0fe77d742df2e001128e', '1562', 66, '', 0, 1, 0, 0, 1522679791, 1522679791), (49, '304368809@qq.com', 'b56580014bda84dff4853c2b70ca55c7', '4356', 67, '', 0, 1, 0, 0, 1523346421, 1523346421), (50, '233fff', 'b337711281d32493f658dc88793caaa6', '8288', 68, '', 0, 1, 0, 0, 1523346795, 1523346795); -- -------------------------------------------------------- -- -- 表的结构 `bis_location` -- CREATE TABLE IF NOT EXISTS `bis_location` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `logo` varchar(255) NOT NULL DEFAULT '', `address` varchar(255) NOT NULL DEFAULT '', `tel` varchar(20) NOT NULL DEFAULT '', `contact` varchar(20)