SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Table structure for table `accounts`
--

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `status` int(11) NOT NULL DEFAULT '0',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `admin` binary(1) NOT NULL DEFAULT '0',
  `password` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `demo` binary(1) NOT NULL DEFAULT '0',
  `suspended` binary(1) NOT NULL DEFAULT '0',
  `chargeable` binary(1) NOT NULL DEFAULT '0',
  `balance` double(16,2) NOT NULL DEFAULT '0.00',
  `reseller` int(11) NOT NULL DEFAULT '1',
  `agreement_required` tinyint(1) NOT NULL DEFAULT '1',
  `agreement_received` tinyint(1) NOT NULL DEFAULT '0',
  `contact_person` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `contact_phone` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `auto_show_streetview` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `timezone_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `timezone` int(11) NOT NULL DEFAULT '0',
  `billing_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `billing_address_street_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `billing_address_street_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `billing_address_locality` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `billing_address_region` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `billing_address_postcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `billing_address_country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `status`, `email`, `admin`, `password`, `demo`, `suspended`, `chargeable`, `balance`, `reseller`, `agreement_required`, `agreement_received`, `contact_person`, `contact_phone`, `auto_show_streetview`, `timezone_code`, `timezone`, `billing_name`, `billing_address_street_1`, `billing_address_street_2`, `billing_address_locality`, `billing_address_region`, `billing_address_postcode`, `billing_address_country`) VALUES
(1, 1, 'demo@rhinotracks.com.au', '\0', '89e495e7941cf9e40e6980d14a16bf023ccd4c91', '\0', '\0', '\0', 0.00, 1, 1, 0, '', '', '0', 'Australia/Sydney', 0, '', '', '', '', '', '', ''),
(2, 1, 'empty@rhinotracks.com.au', '\0', '', '\0', '\0', '\0', 0.00, 1, 1, 0, '', '', '0', 'Australia/Sydney', 0, '', '', '', '', '', '', '');

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

--
-- Table structure for table `account_notes`
--

CREATE TABLE IF NOT EXISTS `account_notes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) unsigned NOT NULL,
  `datetime_created` datetime NOT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `note` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `account_notes`
--

INSERT INTO `account_notes` (`id`, `account_id`, `datetime_created`, `author`, `note`) VALUES
(1, 1, '2011-03-18 01:29:06', 'Rowan Parker', 'Only one device registered, but never used. Have sent email to customer asking if they need assistance setting up unit. No paperwork found. Disabling account.'),
(2, 2, '2011-03-18 01:34:44', 'Rowan Parker', 'Unit currently being used, no signed agreement found. Have asked Tracey to chase with the customer - OZSNOW.'),
(3, 1, '2011-03-18 01:35:29', 'Rowan Parker', 'Account currently has 3 units. All reporting data. No signed agreement found. Have asked Tammy (entered the order) to contact the customer about paperwork.'),
(4, 1, '2011-03-18 01:36:31', 'Rowan Parker', 'Account has 2 registered units. Neither have any recorded history. Disabling account.'),
(5, 1, '2011-03-18 04:42:05', 'Rowan Parker', 'Sent Jon an email regarding his RhinoTracks units. We have not received paperwork back regarding the SIM cards.');

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

--
-- Table structure for table `devices`
--

CREATE TABLE IF NOT EXISTS `devices` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `imei` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `date_expiry` date NOT NULL,
  `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Undefined',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `account` int(10) unsigned NOT NULL DEFAULT '0',
  `phone` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `sim_pin` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `model` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `imei` (`imei`),
  KEY `account` (`account`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `devices`
--

INSERT INTO `devices` (`id`, `imei`, `date_expiry`, `name`, `status`, `account`, `phone`, `sim_pin`, `model`) VALUES
(1, '358244011868066', '0000-00-00', 'Demo 1', 0, 1, '', '', ''),
(2, '358244015405535', '0000-00-00', 'Demo 2', 0, 0, '', '', ''),
(3, '354779033802159', '0000-00-00', 'Terri', 0, 1, '', '', ''),
(4, '354779033806564', '0000-00-00', 'Hilux', 0, 1, '', '', '');

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

--
-- Table structure for table `locations`
--

CREATE TABLE IF NOT EXISTS `locations` (
  `device` mediumint(8) unsigned NOT NULL,
  `time` bigint(20) unsigned NOT NULL DEFAULT '0',
  `lat` float(8,4) NOT NULL DEFAULT '0.0000',
  `lon` float(8,4) NOT NULL DEFAULT '0.0000',
  `kmph` float(10,4) unsigned NOT NULL DEFAULT '0.0000',
  KEY `device` (`device`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`device`, `time`, `lat`, `lon`, `kmph`) VALUES
(1, 1310605609, -17.8145, 146.0907, 0.0000),
(1, 1310605629, -17.8145, 146.0908, 0.0000),
(1, 1310605649, -17.8145, 146.0908, 0.0000),
(1, 1310605669, -17.8145, 146.0907, 3.0000),
(1, 1310605689, -17.8145, 146.0908, 0.0000),
(1, 1310605729, -17.8144, 146.0908, 54.2300);

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

--
-- Table structure for table `logs`
--

CREATE TABLE IF NOT EXISTS `logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `datetime_created` datetime NOT NULL,
  `class` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `class` (`class`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=31 ;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`id`, `datetime_created`, `class`, `message`) VALUES
(1, '2011-05-10 00:28:34', 'SERVER', 'YOKO: 2.77 km converts to 1.4956803455724 knots'),
(2, '2011-05-10 00:28:53', 'SERVER', 'YOKO: 13.39 km converts to 7.2300215982721 knots'),
(3, '2011-05-10 00:29:19', 'SERVER', 'YOKO: 0.26 km converts to 0.14038876889849 knots'),
(4, '2011-05-10 00:29:30', 'SERVER', 'YOKO: 0.26 km converts to 0.14038876889849 knots'),
(5, '2011-05-10 00:29:37', 'SERVER', 'YOKO: 1.39 km converts to 0.75053995680346 knots'),
(6, '2011-05-10 00:29:40', 'SERVER', 'YOKO: 0.26 km converts to 0.14038876889849 knots'),
(7, '2011-05-10 00:29:46', 'SERVER', 'YOKO: 0.26 km converts to 0.14038876889849 knots'),
(8, '2011-05-10 00:29:54', 'SERVER', 'GOPASS: Malformed No#222\nIMEI Code: 358244016760417'),
(9, '2011-05-10 00:29:54', 'SERVER', 'GOPASS could not process: No#222\nIMEI Code: 358244016760417'),
(10, '2011-05-10 00:29:58', 'SERVER', 'YOKO: 0.94 km converts to 0.50755939524838 knots'),
(11, '2011-05-10 00:30:01', 'SERVER', 'YOKO: 0.26 km converts to 0.14038876889849 knots'),
(12, '2011-05-10 00:30:07', 'SERVER', 'YOKO: 0.26 km converts to 0.14038876889849 knots'),
(13, '2011-05-10 00:30:16', 'SERVER', 'YOKO: 1.30 km converts to 0.70194384449244 knots'),
(14, '2011-05-10 00:30:22', 'SERVER', 'YOKO: 0.26 km converts to 0.14038876889849 knots'),
(15, '2011-05-10 00:30:27', 'SERVER', 'YOKO: 0.37 km converts to 0.19978401727862 knots'),
(16, '2011-05-10 00:30:28', 'SERVER', 'YOKO: 0.26 km converts to 0.14038876889849 knots'),
(17, '2011-05-10 00:30:37', 'SERVER', 'YOKO: 1.82 km converts to 0.98272138228942 knots'),
(18, '2011-05-10 00:30:43', 'SERVER', 'YOKO: 0.09 km converts to 0.048596112311015 knots'),
(19, '2011-05-10 00:30:45', 'SERVER', 'YOKO: 0.15 km converts to 0.080993520518359 knots'),
(20, '2011-05-10 00:30:51', 'SERVER', 'YOKO: 0.37 km converts to 0.19978401727862 knots'),
(21, '2011-05-10 00:30:58', 'SERVER', 'YOKO: 4.77 km converts to 2.5755939524838 knots'),
(22, '2011-05-10 00:31:04', 'SERVER', 'YOKO: 0.09 km converts to 0.048596112311015 knots'),
(23, '2011-05-10 00:31:19', 'SERVER', 'YOKO: 1.77 km converts to 0.95572354211663 knots'),
(24, '2011-05-10 00:31:25', 'SERVER', 'YOKO: 0.09 km converts to 0.048596112311015 knots'),
(25, '2011-05-10 00:31:40', 'SERVER', 'YOKO: 1.18 km converts to 0.63714902807775 knots'),
(26, '2011-05-10 00:31:42', 'SERVER', 'YOKO: 0.00 km converts to 0 knots'),
(27, '2011-05-10 00:31:47', 'SERVER', 'YOKO: 0.09 km converts to 0.048596112311015 knots'),
(28, '2011-05-10 00:31:48', 'SERVER', 'YOKO: 0.37 km converts to 0.19978401727862 knots'),
(29, '2011-05-10 00:31:57', 'SERVER', 'YOKO: 0.37 km converts to 0.19978401727862 knots'),
(30, '2011-05-10 00:32:01', 'SERVER', 'YOKO: 0.86 km converts to 0.46436285097192 knots');
