56,675
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE IF NOT EXISTS `hy_workrest` (
`wr_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '',
`wr_comid` int(4) NOT NULL,
`wr_driver_tel` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '',
`wr_status` int(1) NOT NULL DEFAULT '0' COMMENT '',
`wr_getuptime` datetime NOT NULL COMMENT '',
`getup_lat` decimal(11,8) NOT NULL COMMENT '',
`getup_lon` decimal(11,8) NOT NULL COMMENT '',
`getup_acc` decimal(11,3) NOT NULL COMMENT '',
`wr_meters` int(7) NOT NULL COMMENT '',
`wr_cost` int(10) NOT NULL COMMENT '',
`wr_alcohol` int(11) NOT NULL DEFAULT '2' COMMENT '',
`alcohol_time` datetime NOT NULL,
`alcohol_lat` decimal(11,8) NOT NULL COMMENT '',
`alcohol_lon` decimal(11,8) NOT NULL COMMENT '',
`alcohol_acc` decimal(11,3) NOT NULL COMMENT '',
`wr_starting` datetime NOT NULL COMMENT '',
`wr_statusstart` int(1) NOT NULL DEFAULT '0',
`wr_starting_lat` decimal(11,8) NOT NULL COMMENT '',
`wr_starting_lon` decimal(11,8) NOT NULL COMMENT '',
`wr_starting_acc` decimal(11,3) NOT NULL COMMENT '',
`wr_reach` datetime NOT NULL COMMENT '',
`wr_statusreach` int(1) NOT NULL,
`wr_reach_lat` decimal(11,8) NOT NULL COMMENT '',
`wr_reach_lon` decimal(11,8) NOT NULL COMMENT '',
`wr_reach_acc` decimal(11,3) NOT NULL COMMENT '',
`wr_closing` datetime NOT NULL COMMENT '',
`wr_statusclose` int(1) NOT NULL DEFAULT '0',
`wr_closing_lat` decimal(11,8) NOT NULL COMMENT '',
`wr_closing_lon` decimal(11,8) NOT NULL COMMENT '',
`wr_closing_acc` decimal(11,3) NOT NULL COMMENT '',
`wr_endclosing` datetime NOT NULL COMMENT '',
`wr_statusendclose` int(1) NOT NULL DEFAULT '0',
`wr_endclosing_lat` decimal(11,8) NOT NULL COMMENT '',
`wr_endclosing_lon` decimal(11,8) NOT NULL COMMENT '',
`wr_endclosing_acc` decimal(11,3) NOT NULL COMMENT '',
`wr_cheduled_actual` int(11) NOT NULL DEFAULT '0' COMMENT '',
`wr_cheduled_actual_lat` decimal(11,8) NOT NULL COMMENT '',
`wr_cheduled_actual_lon` decimal(11,8) NOT NULL COMMENT '',
`wr_cheduled_actual_acc` decimal(11,3) NOT NULL COMMENT '',
`wr_onfirm` int(1) NOT NULL DEFAULT '0' COMMENT '',
`wr_scheexec` date NOT NULL COMMENT '',
`wr_createday` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`wr_telposttime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`wr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=184 ;
--
-- テーブルのデータをダンプしています `hy_workrest`
--
INSERT INTO `hy_workrest` (`wr_id`, `wr_comid`, `wr_driver_tel`, `wr_status`, `wr_getuptime`, `getup_lat`, `getup_lon`, `getup_acc`, `wr_meters`, `wr_cost`, `wr_alcohol`, `alcohol_time`, `alcohol_lat`, `alcohol_lon`, `alcohol_acc`, `wr_starting`, `wr_statusstart`, `wr_starting_lat`, `wr_starting_lon`, `wr_starting_acc`, `wr_reach`, `wr_statusreach`, `wr_reach_lat`, `wr_reach_lon`, `wr_reach_acc`, `wr_closing`, `wr_statusclose`, `wr_closing_lat`, `wr_closing_lon`, `wr_closing_acc`, `wr_endclosing`, `wr_statusendclose`, `wr_endclosing_lat`, `wr_endclosing_lon`, `wr_endclosing_acc`, `wr_cheduled_actual`, `wr_cheduled_actual_lat`, `wr_cheduled_actual_lon`, `wr_cheduled_actual_acc`, `wr_onfirm`, `wr_scheexec`, `wr_createday`, `wr_telposttime`) VALUES
(165, 1, '09012345679', 0, '2012-09-09 01:09:09', '0.00000000', '0.00000000', '0.000', 0, 0, 1, '2012-09-09 01:09:09', '0.00000000', '0.00000000', '0.000', '2012-09-09 01:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-09 01:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-09 15:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-09 15:09:09', 0, '0.00000000', '0.00000000', '0.000', 0, '0.00000000', '0.00000000', '0.000', 0, '2012-09-09', '2012-12-13 11:07:52', '0000-00-00 00:00:00'),
(164, 1, '09012345679', 3, '2010-09-10 01:09:09', '0.00000000', '0.00000000', '0.000', 0, 0, 0, '2010-09-10 01:09:09', '0.00000000', '0.00000000', '0.000', '2010-09-10 01:09:09', 2, '35.10000000', '136.60000000', '136.600', '2010-09-10 01:09:09', 3, '35.10000000', '136.61000000', '0.000', '2010-09-10 04:09:09', 1, '35.10000000', '136.68000000', '0.000', '2010-09-10 04:09:09', 3, '35.10000000', '136.69000000', '0.000', 1, '0.00000000', '0.00000000', '0.000', 0, '2012-09-09', '2012-12-13 11:12:48', '0000-00-00 00:00:00'),
(174, 1, '09012345678', 0, '2012-09-09 01:09:09', '0.00000000', '0.00000000', '0.000', 0, 0, 1, '2012-09-09 01:09:09', '0.00000000', '0.00000000', '0.000', '2012-09-09 01:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-09 01:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-09 15:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-09 15:09:09', 0, '0.00000000', '0.00000000', '0.000', 0, '0.00000000', '0.00000000', '0.000', 0, '2012-09-09', '2012-12-13 11:07:52', '0000-00-00 00:00:00'),
(175, 1, '09012345678', 3, '2010-09-10 01:09:09', '0.00000000', '0.00000000', '0.000', 0, 0, 0, '2010-09-10 01:09:09', '0.00000000', '0.00000000', '0.000', '2010-09-10 01:09:09', 2, '35.10000000', '136.60000000', '136.600', '2010-09-10 01:09:09', 3, '35.10000000', '136.61000000', '0.000', '2010-09-10 10:09:09', 1, '35.10000000', '136.68000000', '0.000', '2010-09-10 10:09:09', 3, '35.10000000', '136.69000000', '0.000', 1, '0.00000000', '0.00000000', '0.000', 0, '2012-09-09', '2012-12-13 11:12:48', '0000-00-00 00:00:00'),
(183, 1, '09012312312', 3, '2010-09-08 01:09:09', '0.00000000', '0.00000000', '0.000', 0, 0, 0, '2010-09-08 01:09:09', '0.00000000', '0.00000000', '0.000', '2010-09-08 01:09:09', 2, '35.10000000', '136.60000000', '136.600', '2010-09-08 01:09:09', 3, '35.10000000', '136.61000000', '0.000', '2010-09-08 05:09:09', 1, '35.10000000', '136.68000000', '0.000', '2010-09-08 05:09:09', 3, '35.10000000', '136.69000000', '0.000', 0, '0.00000000', '0.00000000', '0.000', 0, '2012-09-09', '2012-12-13 11:12:48', '0000-00-00 00:00:00'),
(182, 1, '09012312312', 0, '2012-09-09 01:09:09', '0.00000000', '0.00000000', '0.000', 0, 0, 1, '2012-09-09 01:09:09', '0.00000000', '0.00000000', '0.000', '2012-09-09 01:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-09 01:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-09 06:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-09 06:09:09', 1, '0.00000000', '0.00000000', '0.000', 1, '0.00000000', '0.00000000', '0.000', 0, '2012-09-09', '2012-12-13 11:07:52', '0000-00-00 00:00:00'),
(181, 1, '09012312312', 3, '2010-09-10 01:09:09', '0.00000000', '0.00000000', '0.000', 0, 0, 0, '2010-09-10 01:09:09', '0.00000000', '0.00000000', '0.000', '2010-09-10 01:09:09', 2, '35.10000000', '136.60000000', '136.600', '2010-09-10 01:09:09', 3, '35.10000000', '136.61000000', '0.000', '2010-09-10 07:09:09', 1, '35.10000000', '136.68000000', '0.000', '2010-09-10 07:09:09', 3, '35.10000000', '136.69000000', '0.000', 1, '0.00000000', '0.00000000', '0.000', 0, '2012-09-09', '2012-12-13 11:12:48', '0000-00-00 00:00:00'),
(180, 1, '09012312312', 0, '2012-09-11 01:09:09', '0.00000000', '0.00000000', '0.000', 0, 0, 1, '2012-09-11 01:09:09', '0.00000000', '0.00000000', '0.000', '2012-09-11 01:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-11 01:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-11 08:09:09', 0, '0.00000000', '0.00000000', '0.000', '2012-09-11 08:09:09', 0, '0.00000000', '0.00000000', '0.000', 1, '0.00000000', '0.00000000', '0.000', 0, '2012-09-09', '2012-12-13 11:07:52', '0000-00-00 00:00:00');