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

--
-- 資料表結構 `wr_adve-0`
--

CREATE TABLE `wr_adve-0` (
  `AdveId` int(11) NOT NULL,
  `AgentId` int(11) DEFAULT '0' COMMENT '代理ID',
  `FangId` int(11) DEFAULT '0' COMMENT '房东ID',
  `QrcodeId` int(11) NOT NULL COMMENT '二维码ID',
  `RandString` varchar(24) NOT NULL,
  `GoUrl` varchar(200) DEFAULT NULL,
  `Title` varchar(200) NOT NULL,
  `Content` text NOT NULL,
  `addtime` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='广告表';

--
-- 傾印資料表的資料 `wr_adve-0`
--

INSERT INTO `wr_adve-0` (`AdveId`, `AgentId`, `FangId`, `QrcodeId`, `RandString`, `GoUrl`, `Title`, `Content`, `addtime`) VALUES
(2, 0, 2, 3, 'kOpKLDgsI81q', 'https://water.suanok.com/Home/index/dzp/dzpId/1', 'YLB-001', '&lt;p&gt;YLB-001&lt;/p&gt;', 1507057180),
(3, 0, 4, 5, 'algipd1WXoUS', 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', 'YLB-002', '&lt;p&gt;YLB-002&lt;/p&gt;', 1510824371),
(4, 0, 6, 3, 'kOpKLDgsI81q', 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', 'YLB-003', '&lt;p&gt;YLB-003&lt;/p&gt;', 1510903353);
