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

--
-- 資料表結構 `wr_mach`
--

CREATE TABLE `wr_mach` (
  `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`
--

INSERT INTO `wr_mach` (`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', -5496, 'f', 1516841635, '24.0', '7.5', 2778, 2500, 1531709333, 'oSbDwv5F80DZ-0OwmtvQyd1pwrtU', 1533634769, 0.40),
(2, 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', '粵S-02-0057', 'R769000002', 0, 4, 4, '1g313bkjJTcn', -2222, 'i', 1530855710, '24.0', '7.5', 15, 0, 1516811409, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', 1539055129, 0.40),
(3, 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', '粵S-02-0046', 'R769000003', 0, 6, 6, 'T4eqXpV8vYrC', -480, 'e', 1536826846, '24.0', '7.5', 0, 5, 1514353813, '', 0, 0.40),
(4, 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', '粵S-04-0047', 'R769000004', 0, 6, 7, 'uOp6x1LrArtE', -23270, 'i', 1560476353, '38.0', '11.0', 0, 0, 1531821075, '', 0, 0.40),
(5, 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', '粵S-05-0048', 'R769000005', 0, 7, 8, 'XbZlsCySg0Ca', -8945, 'i', 1560691171, '24.0', '11.0', 20, 11, 1560691172, '', 0, 0.40),
(10, 'https://water.suanok.com/Home/index/getOpenid/act/newuserpay/', '啤酒-test', 'R769000006', 0, 5, 26, 'l5tarsC5uRCP', 0, 'f', 1524285053, '0.0', '0.0', 0, 0, 0, 'oSbDwvwik5m9V2rEXTiI5lCcSA58', 1527254559, 0.40),
(11, '', 'JM-0001', 'R769000007', 0, 0, 27, 'u0zExDQd6XGb', 0, 'i', 1530855615, '0.0', '0.0', 0, 0, 0, '', 0, 0.40),
(12, '', 'JM-0002', 'R769000008', 0, 0, 28, 'bDpzAg9Z4DkL', 0, 'i', 1530856959, '0.0', '0.0', 0, 0, 0, '', 0, 0.40);
