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

--
-- 資料表結構 `wr_mach_1`
--

CREATE TABLE `wr_mach_1` (
  `MachId` int(11) NOT NULL,
  `ActUrl` varchar(200) DEFAULT NULL COMMENT '活动URL',
  `MachName` varchar(50) NOT NULL COMMENT '机器名称',
  `MachNum` varchar(24) NOT NULL COMMENT '机器编号',
  `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 COMMENT '随机码',
  `BankStock` bigint(20) NOT NULL DEFAULT '0' COMMENT '水箱存量毫升',
  `ValveStat` varchar(2) NOT NULL COMMENT '阀狀態 o:开 f:关 i:开机 e:故障',
  `ValveTime` int(11) DEFAULT NULL COMMENT '阀狀態时间',
  `CntRatIn` decimal(4,1) NOT NULL,
  `CntRatOut` decimal(4,1) NOT NULL,
  `TdsIn` int(11) NOT NULL COMMENT '自來水TDS',
  `TdsOut` int(11) NOT NULL COMMENT '淨水TDS',
  `TdsTime` int(11) NOT NULL COMMENT 'TDS更新时间',
  `curOpenid` varchar(32) NOT NULL COMMENT '当前用户',
  `scanTime` int(11) NOT NULL COMMENT '扫码时间',
  `UnitPrice` float(4,2) NOT NULL DEFAULT '0.40' COMMENT '机器水单价'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机器表';

--
-- 傾印資料表的資料 `wr_mach_1`
--

INSERT INTO `wr_mach_1` (`MachId`, `ActUrl`, `MachName`, `MachNum`, `AgentId`, `FangId`, `QrcodeId`, `RandString`, `BankStock`, `ValveStat`, `ValveTime`, `CntRatIn`, `CntRatOut`, `TdsIn`, `TdsOut`, `TdsTime`, `curOpenid`, `scanTime`, `UnitPrice`) VALUES
(1, 'https://water.suanok.com/Home/index/dzp/dzpId/1', '粵S-01-0068', 'R769000001', 0, 2, 1, 'LQO5poYk9F8h', 6500, 'f', 1514340144, '24.0', '7.5', 3, 1, 1514305807, '', 0, 0.40),
(2, 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', '粵S-02-0057', 'R769000002', 0, 4, 4, '1g313bkjJTcn', 6500, 'i', 1514293779, '24.0', '7.5', 24, 0, 1514222248, '', 0, 0.40),
(3, 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', '粵S-02-0046', 'R769000003', 0, 6, 6, 'T4eqXpV8vYrC', -4491, 'i', 1514341568, '24.0', '7.5', 0, 5, 1514342056, '', 0, 0.40),
(4, 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', '粵S-04-0047', 'R769000004', 0, 6, 7, 'uOp6x1LrArtE', 6500, 'e', 1514222518, '38.0', '11.0', 18, 0, 1514212238, '', 0, 0.40),
(5, 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', '粵S-05-0048', 'R769000005', 0, 5, 8, 'XbZlsCySg0Ca', 0, 'e', 1514082234, '38.0', '11.0', 0, 0, 0, 'oSbDwvysrOXM7TnATwcxcLX2YFHo', 1514342925, 0.40);
