 CREATE TABLE IF NOT EXISTS `wms_log` (
   `wms_id` int(11) NOT NULL AUTO_INCREMENT,
   `water_level` decimal(10,0) NOT NULL,
-  `turbidity` decimal(10,0) NOT NULL,
+  `turbidity` varchar(255) NOT NULL,
   `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`wms_id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=93 ;
 
 --
 -- Dumping data for table `wms_log`
 --
 
 INSERT INTO `wms_log` (`wms_id`, `water_level`, `turbidity`, `time`) VALUES
-(9, '39', '86', '2014-02-14 17:53:53'),
-(10, '39', '100', '2014-02-14 17:53:55'),
-(11, '39', '91', '2014-02-14 17:54:16'),
-(12, '38', '100', '2014-02-14 17:54:17'),
-(13, '39', '69', '2014-02-14 17:54:24'),
-(14, '39', '98', '2014-02-14 17:54:25'),
-(15, '39', '100', '2014-02-14 17:54:26'),
-(16, '39', '89', '2014-02-14 17:57:11'),
-(17, '39', '100', '2014-02-14 17:57:12'),
-(18, '39', '91', '2014-02-14 17:57:19'),
-(19, '39', '100', '2014-02-14 17:57:27'),
-(20, '39', '84', '2014-02-14 18:02:31'),
-(32, '156', '67', '2014-02-14 18:07:05'),
-(33, '38', '95', '2014-02-14 18:07:06'),
-(34, '39', '77', '2014-02-14 18:07:08'),
-(35, '-301', '73', '2014-02-14 18:07:09'),
-(36, '167', '78', '2014-02-14 18:07:11'),
-(37, '193', '84', '2014-02-14 18:07:12'),
-(38, '197', '87', '2014-02-14 18:07:13'),
-(39, '198', '81', '2014-02-14 18:07:14'),
-(40, '39', '98', '2014-02-14 18:07:15'),
-(41, '217', '97', '2014-02-14 18:07:57'),
-(42, '39', '93', '2014-02-14 18:07:58'),
-(43, '224', '0', '2014-02-14 18:07:59'),
-(44, '39', '86', '2014-02-14 18:08:01'),
-(45, '39', '95', '2014-02-14 18:08:02'),
-(46, '39', '88', '2014-02-14 18:08:03'),
-(47, '39', '63', '2014-02-14 18:08:04'),
-(48, '38', '93', '2014-02-14 18:08:05'),
-(49, '38', '73', '2014-02-14 18:08:06'),
-(50, '38', '80', '2014-02-14 18:08:07'),
-(51, '38', '93', '2014-02-14 18:08:08'),
-(52, '38', '97', '2014-02-14 18:08:09'),
-(53, '39', '92', '2014-02-14 18:08:19'),
-(54, '39', '9', '2014-02-14 18:08:20'),
-(55, '38', '40', '2014-02-14 18:08:21'),
-(56, '39', '96', '2014-02-14 18:08:22'),
-(57, '38', '100', '2014-02-14 18:08:25');
+(7, '200', 'Sedang', '2014-03-12 05:33:10'),
+(8, '200', 'Jernih', '2014-03-12 05:33:16'),
+(9, '250', 'Keruh', '2014-03-12 05:41:47'),
+(10, '18', 'Jernih', '2014-03-12 06:46:07'),
+(11, '17', 'Keruh', '2014-03-12 06:46:08'),
+(12, '250', 'Jernih', '2014-03-12 07:07:16'),
+(13, '171', 'Keruh', '2014-03-12 07:07:21'),
+(14, '194', 'Jernih', '2014-03-12 07:31:33'),
+(15, '197', 'Keruh', '2014-03-12 07:32:28'),
+(16, '197', 'Jernih', '2014-03-12 07:33:14'),
+(17, '191', 'Keruh', '2014-03-12 07:34:19'),
+(18, '195', 'Sedang', '2014-03-13 06:10:15'),
+(19, '195', 'Jernih', '2014-03-13 06:10:17'),
+(20, '197', 'Keruh', '2014-03-13 06:10:38'),
+(21, '54', 'Jernih', '2014-03-13 06:16:26'),
+(22, '40', 'Keruh', '2014-03-13 06:16:52'),
+(23, '104', 'Jernih', '2014-03-13 06:18:08'),
+(24, '198', 'Keruh', '2014-03-13 06:18:44'),
+(25, '198', 'Jernih', '2014-03-13 06:19:40'),
+(26, '198', 'Keruh', '2014-03-13 06:19:43'),
+(27, '198', 'Jernih', '2014-03-13 06:19:45'),
+(28, '198', 'Keruh', '2014-03-13 06:19:50'),
+(29, '-910', 'Jernih', '2014-03-13 06:37:25'),
+(30, '-32', 'Keruh', '2014-03-13 06:37:30'),
+(31, '-910', 'Jernih', '2014-03-13 06:37:35'),
+(32, '196', 'Keruh', '2014-03-13 06:37:47'),
+(33, '-33', 'Jernih', '2014-03-13 06:37:59'),
+(34, '198', 'Keruh', '2014-03-13 06:38:37'),
+(35, '193', 'Jernih', '2014-03-13 06:42:42'),
+(36, '193', 'Keruh', '2014-03-13 06:42:45'),
+(37, '29', 'Jernih', '2014-03-13 06:45:41'),
+(38, '111', 'Keruh', '2014-03-13 06:45:59'),
+(39, '100', 'Jernih', '2014-03-13 06:46:09'),
+(40, '92', 'Sedang', '2014-03-13 06:46:20'),
+(41, '82', 'Jernih', '2014-03-13 06:46:23'),
+(42, '75', 'Keruh', '2014-03-13 06:46:28'),
+(43, '67', 'Jernih', '2014-03-13 06:46:34'),
+(44, '9', 'Sedang', '2014-03-13 06:47:31'),
+(45, '-20', 'Keruh', '2014-03-13 06:47:36'),
+(46, '12', 'Jernih', '2014-03-13 06:47:50'),
+(47, '197', 'Sedang', '2014-03-13 06:48:09'),
+(48, '197', 'Keruh', '2014-03-13 06:48:11'),
+(49, '197', 'Jernih', '2014-03-13 06:48:16'),
+(50, '-10', 'Keruh', '2014-03-13 06:48:21'),
+(51, '44', 'Jernih', '2014-03-13 06:48:25'),
+(52, '35', 'Sedang', '2014-03-13 06:48:30'),
+(53, '38', 'Jernih', '2014-03-13 06:48:32'),
+(54, '25', 'Keruh', '2014-03-13 06:48:37'),
+(55, '32', 'Jernih', '2014-03-13 06:50:14'),
+(56, '-33', 'Keruh', '2014-03-13 06:50:56'),
+(57, '87', 'Jernih', '2014-03-13 06:51:02'),
+(58, '1', 'Keruh', '2014-03-13 06:51:26'),
+(59, '22', 'Jernih', '2014-03-13 06:51:30'),
+(60, '38', 'Keruh', '2014-03-13 06:51:33'),
+(61, '35', 'Jernih', '2014-03-13 06:51:42'),
+(62, '61', 'Keruh', '2014-03-13 06:51:47'),
+(63, '46', 'Jernih', '2014-03-13 06:51:49'),
+(64, '43', 'Keruh', '2014-03-13 06:51:52'),
+(65, '58', 'Jernih', '2014-03-13 06:51:54'),
+(66, '34', 'Keruh', '2014-03-13 06:52:32'),
+(67, '38', 'Jernih', '2014-03-13 06:52:37'),
+(68, '-16', 'Keruh', '2014-03-13 06:53:43'),
+(69, '91', 'Jernih', '2014-03-13 06:54:26'),
+(70, '184', 'Keruh', '2014-03-13 06:55:23'),
+(71, '39', 'Jernih', '2014-03-13 06:57:28'),
+(72, '18', 'Keruh', '2014-03-13 06:57:47'),
+(73, '41', 'Jernih', '2014-03-13 06:57:49'),
+(74, '150', 'Keruh', '2014-03-13 07:03:51'),
+(75, '-18', 'Jernih', '2014-03-13 07:05:13'),
+(76, '-79', 'Keruh', '2014-03-13 07:05:27'),
+(77, '-79', 'Jernih', '2014-03-13 07:05:39'),
+(78, '146', 'Keruh', '2014-03-13 07:05:42'),
+(79, '143', 'Jernih', '2014-03-13 07:05:55'),
+(80, '146', 'Keruh', '2014-03-13 07:06:18'),
+(81, '-63', 'Jernih', '2014-03-13 07:06:39'),
+(82, '52', 'Keruh', '2014-03-13 07:06:56'),
+(83, '47', 'Jernih', '2014-03-13 07:07:01'),
+(84, '45', 'Keruh', '2014-03-13 07:07:03'),
+(85, '144', 'Jernih', '2014-03-13 07:07:29'),
+(86, '-47', 'Keruh', '2014-03-13 07:07:55'),
+(87, '63', 'Jernih', '2014-03-13 07:08:21'),
+(88, '54', 'Keruh', '2014-03-13 07:08:38'),
+(89, '-67', 'Jernih', '2014-03-13 07:09:11'),
+(90, '-56', 'Keruh', '2014-03-13 07:09:25'),
+(91, '-80', 'Jernih', '2014-03-13 07:10:09'),
+(92, '34', 'Keruh', '2014-03-13 07:10:29');
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;


INSERT INTO `dcs_user` (`user_id`, `name`, `password`) VALUES
('001', 'Dimas', '1234'),
('002', 'admin', '123');

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


  `smoke` decimal(10,0) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`scs_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

