-- phpMyAdmin SQL Dump
-- version 3.3.2deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 02, 2011 at 09:53 AM
-- Server version: 5.1.41
-- PHP Version: 5.3.2-1ubuntu4.10

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 */;

--
-- Database: `testing_rhinotracks_v1`
--

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

--
-- 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, 0, 'demo@rhinotracks.com.au', '\0', '', '\0', '\0', '\0', 0.00, 1, 1, 0, '', '', '0', '', 0, '', '', '', '', '', '', ''),
(2, 0, 'empty@rhinotracks.com.au', '\0', '', '\0', '\0', '\0', 0.00, 1, 1, 0, '', '', '0', '', 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=1 ;

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


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

--
-- 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 `devices-status`
--

CREATE TABLE IF NOT EXISTS `devices-status` (
  `id` int(11) NOT NULL,
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `alarm` tinyint(1) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

--
-- Table structure for table `errors`
--

CREATE TABLE IF NOT EXISTS `errors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39803 ;

--
-- Dumping data for table `errors`
--


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

--
-- 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`
--


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

--
-- 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=1 ;

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


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

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(10) unsigned NOT NULL,
  `message` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `messages`
--


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

--
-- Table structure for table `resellers`
--

CREATE TABLE IF NOT EXISTS `resellers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `resellers`
--

