text: -- MySQL dump 10.13  Distrib 5.5.31, for debian-linux-gnu (i686)
  --
  -- Host: localhost    Database: oms
  -- ------------------------------------------------------
  -- Server version	5.5.31-0ubuntu0.12.04.2
  
  /*!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 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `addresses`
  --
  
  DROP TABLE IF EXISTS `addresses`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `addresses` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `customer_id` int(10) NOT NULL,
    `name` varchar(20) DEFAULT NULL,
    `forename` varchar(40) DEFAULT NULL,
    `surname` varchar(30) DEFAULT NULL,
    `company` varchar(40) DEFAULT NULL,
    `address` varchar(40) DEFAULT NULL,
    `address2` varchar(40) DEFAULT NULL,
    `city` varchar(40) DEFAULT NULL,
    `postcode` varchar(9) DEFAULT NULL,
    `country_id` int(10) unsigned DEFAULT NULL,
    `county` varchar(40) DEFAULT NULL,
    `created_at` datetime DEFAULT '0000-00-00 00:00:00',
    `updated_at` datetime DEFAULT '0000-00-00 00:00:00',
    `deleted_at` datetime DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `addresses`
  --
  
  LOCK TABLES `addresses` WRITE;
  /*!40000 ALTER TABLE `addresses` DISABLE KEYS */;
  /*!40000 ALTER TABLE `addresses` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `customer_types`
  --
  
  DROP TABLE IF EXISTS `customer_types`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `customer_types` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(20) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `customer_types`
  --
  
  LOCK TABLES `customer_types` WRITE;
  /*!40000 ALTER TABLE `customer_types` DISABLE KEYS */;
  INSERT INTO `customer_types` VALUES (1,'casual',NULL,NULL),(2,'trade',NULL,NULL);
  /*!40000 ALTER TABLE `customer_types` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `customers`
  --
  
  DROP TABLE IF EXISTS `customers`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `customers` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `forename` varchar(30) NOT NULL,
    `surname` varchar(30) DEFAULT NULL,
    `email` varchar(120) DEFAULT NULL,
    `password` varchar(100) NOT NULL,
    `company` varchar(40) DEFAULT NULL,
    `customer_type_id` int(10) unsigned DEFAULT '1',
    `last_login` datetime DEFAULT NULL,
    `opt_in` tinyint(4) DEFAULT '1',
    `shipping_address_id` int(11) DEFAULT NULL,
    `billing_address_id` int(11) DEFAULT NULL,
    `remember_token` varchar(100) DEFAULT NULL,
    `created_at` datetime DEFAULT '0000-00-00 00:00:00',
    `updated_at` datetime DEFAULT '0000-00-00 00:00:00',
    `deleted_at` datetime DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `customers`
  --
  
  LOCK TABLES `customers` WRITE;
  /*!40000 ALTER TABLE `customers` DISABLE KEYS */;
  INSERT INTO `customers` VALUES (1,'job','Brown','job1@jobbrown.com','2eda8ad1632af052b0c74d6fcab6058b3a79cf25',NULL,1,NULL,0,NULL,NULL,NULL,'2015-02-16 13:23:26','2015-02-16 16:11:02',NULL),(2,'Job','Brown','job@jobbrown.com','2eda8ad1632af052b0c74d6fcab6058b3a79cf25',NULL,0,'2015-02-16 13:48:24',1,NULL,NULL,NULL,'2015-02-16 13:31:03','2015-02-16 13:48:24',NULL),(3,'Michael','Middleton','michael@interiorgoodsdirect.com','2eda8ad1632af052b0c74d6fcab6058b3a79cf25',NULL,0,'2015-02-16 13:52:09',1,NULL,NULL,NULL,'2015-02-16 13:51:26','2015-02-16 13:52:09',NULL);
  /*!40000 ALTER TABLE `customers` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `migrations`
  --
  
  DROP TABLE IF EXISTS `migrations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `migrations` (
    `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `migrations`
  --
  
  LOCK TABLES `migrations` WRITE;
  /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  INSERT INTO `migrations` VALUES ('2014_10_12_000000_create_users_table',1),('2014_10_12_100000_create_password_resets_table',1),('2014_01_15_090136_create_states',2),('2014_01_15_090147_create_countries',2);
  /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `order_item_fields`
  --
  
  DROP TABLE IF EXISTS `order_item_fields`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `order_item_fields` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `order_item_id` int(11) DEFAULT NULL,
    `field_id` int(11) DEFAULT NULL,
    `field_name` varchar(200) DEFAULT NULL,
    `field_value` varchar(255) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `order_item_fields`
  --
  
  LOCK TABLES `order_item_fields` WRITE;
  /*!40000 ALTER TABLE `order_item_fields` DISABLE KEYS */;
  INSERT INTO `order_item_fields` VALUES (1,1,1,'width','100','2015-03-01 18:56:50','2015-03-01 18:56:50'),(2,1,2,'drop','100','2015-03-01 18:56:50','2015-03-01 18:56:50'),(3,1,4,'room','room name','2015-03-01 18:56:50','2015-03-01 18:56:50'),(4,2,1,'width','100','2015-03-01 18:57:01','2015-03-01 18:57:01'),(5,2,2,'drop','100','2015-03-01 18:57:01','2015-03-01 18:57:01'),(6,2,4,'room','room name','2015-03-01 18:57:01','2015-03-01 18:57:01'),(7,3,1,'width','100','2015-03-01 18:58:42','2015-03-01 18:58:42'),(8,3,2,'drop','100','2015-03-01 18:58:42','2015-03-01 18:58:42'),(9,3,4,'room','room name','2015-03-01 18:58:42','2015-03-01 18:58:42'),(10,4,1,'width','100','2015-03-01 19:00:34','2015-03-01 19:00:34'),(11,4,2,'drop','100','2015-03-01 19:00:34','2015-03-01 19:00:34'),(12,4,4,'room','room name','2015-03-01 19:00:34','2015-03-01 19:00:34'),(13,5,1,'width','100','2015-03-01 19:01:56','2015-03-01 19:01:56'),(14,5,2,'drop','100','2015-03-01 19:01:56','2015-03-01 19:01:56'),(15,5,4,'room','room name','2015-03-01 19:01:56','2015-03-01 19:01:56'),(16,6,1,'width','100','2015-03-01 19:02:46','2015-03-01 19:02:46'),(17,6,2,'drop','100','2015-03-01 19:02:46','2015-03-01 19:02:46'),(18,6,4,'room','My Room','2015-03-01 19:02:46','2015-03-01 19:02:46'),(19,7,1,'width','100','2015-03-01 19:04:41','2015-03-01 19:04:41'),(20,7,2,'drop','100','2015-03-01 19:04:41','2015-03-01 19:04:41'),(21,7,4,'room','My Room','2015-03-01 19:04:41','2015-03-01 19:04:41'),(22,8,1,'width','100','2015-03-01 19:07:19','2015-03-01 19:07:19'),(23,8,2,'drop','100','2015-03-01 19:07:19','2015-03-01 19:07:19'),(24,8,4,'room','room name','2015-03-01 19:07:19','2015-03-01 19:07:19'),(25,9,1,'width','100','2015-03-01 19:07:30','2015-03-01 19:07:30'),(26,9,2,'drop','100','2015-03-01 19:07:30','2015-03-01 19:07:30'),(27,9,4,'room','my name','2015-03-01 19:07:30','2015-03-01 19:07:30'),(28,10,1,'width','100','2015-03-01 19:13:50','2015-03-01 19:13:50'),(29,10,2,'drop','100','2015-03-01 19:13:50','2015-03-01 19:13:50'),(30,10,4,'room','my name','2015-03-01 19:13:50','2015-03-01 19:13:50'),(31,11,1,'width','100','2015-03-01 19:14:07','2015-03-01 19:14:07'),(32,11,2,'drop','100','2015-03-01 19:14:07','2015-03-01 19:14:07'),(33,11,4,'room','my name','2015-03-01 19:14:07','2015-03-01 19:14:07'),(34,12,1,'width','100','2015-03-05 18:30:31','2015-03-05 18:30:31'),(35,12,2,'drop','100','2015-03-05 18:30:31','2015-03-05 18:30:31'),(36,12,4,'room','room name','2015-03-05 18:30:31','2015-03-05 18:30:31'),(37,13,1,'width','100','2015-03-05 18:30:36','2015-03-05 18:30:36'),(38,13,2,'drop','100','2015-03-05 18:30:36','2015-03-05 18:30:36'),(39,13,4,'room','room name','2015-03-05 18:30:36','2015-03-05 18:30:36'),(40,14,1,'width','100','2015-03-05 18:30:52','2015-03-05 18:30:52'),(41,14,2,'drop','100','2015-03-05 18:30:52','2015-03-05 18:30:52'),(42,14,4,'room','room name','2015-03-05 18:30:52','2015-03-05 18:30:52'),(43,15,1,'width','100','2015-03-05 18:35:46','2015-03-05 18:35:46'),(44,15,2,'drop','100','2015-03-05 18:35:46','2015-03-05 18:35:46'),(45,15,4,'room','room name','2015-03-05 18:35:46','2015-03-05 18:35:46'),(46,16,1,'width','100','2015-03-05 18:36:25','2015-03-05 18:36:25'),(47,16,2,'drop','100','2015-03-05 18:36:25','2015-03-05 18:36:25'),(48,16,4,'room','room name','2015-03-05 18:36:25','2015-03-05 18:36:25'),(49,17,1,'width','100','2015-03-05 18:37:24','2015-03-05 18:37:24'),(50,17,2,'drop','100','2015-03-05 18:37:24','2015-03-05 18:37:24'),(51,17,4,'room','room name','2015-03-05 18:37:24','2015-03-05 18:37:24'),(52,18,1,'width','100','2015-03-05 18:37:44','2015-03-05 18:37:44'),(53,18,2,'drop','100','2015-03-05 18:37:44','2015-03-05 18:37:44'),(54,18,4,'room','room name','2015-03-05 18:37:45','2015-03-05 18:37:45'),(55,19,1,'width','100','2015-03-05 18:38:38','2015-03-05 18:38:38'),(56,19,2,'drop','100','2015-03-05 18:38:38','2015-03-05 18:38:38'),(57,19,4,'room','room name','2015-03-05 18:38:38','2015-03-05 18:38:38'),(58,20,1,'width','200','2015-03-05 18:48:06','2015-03-05 18:48:06'),(59,20,2,'drop','200','2015-03-05 18:48:06','2015-03-05 18:48:06'),(60,20,4,'room','room name','2015-03-05 18:48:06','2015-03-05 18:48:06'),(61,21,1,'width','200','2015-03-05 18:48:24','2015-03-05 18:48:24'),(62,21,2,'drop','200','2015-03-05 18:48:24','2015-03-05 18:48:24'),(63,21,4,'room','room name','2015-03-05 18:48:24','2015-03-05 18:48:24'),(64,22,1,'width','200','2015-03-05 18:48:36','2015-03-05 18:48:36'),(65,22,2,'drop','200','2015-03-05 18:48:36','2015-03-05 18:48:36'),(66,22,4,'room','study','2015-03-05 18:48:36','2015-03-05 18:48:36'),(67,23,1,'width','100','2015-03-08 13:09:58','2015-03-08 13:09:58'),(68,23,2,'drop','100','2015-03-08 13:09:58','2015-03-08 13:09:58'),(69,23,4,'room','room name','2015-03-08 13:09:58','2015-03-08 13:09:58'),(70,24,1,'width','100','2015-03-08 13:11:23','2015-03-08 13:11:23'),(71,24,2,'drop','100','2015-03-08 13:11:23','2015-03-08 13:11:23'),(72,24,4,'room','My Room','2015-03-08 13:11:23','2015-03-08 13:11:23'),(73,25,1,'width','100','2015-03-08 13:14:39','2015-03-08 13:14:39'),(74,25,2,'drop','100','2015-03-08 13:14:39','2015-03-08 13:14:39'),(75,25,4,'room','My Room','2015-03-08 13:14:39','2015-03-08 13:14:39'),(76,26,1,'width','100','2015-03-08 13:16:19','2015-03-08 13:16:19'),(77,26,2,'drop','100','2015-03-08 13:16:20','2015-03-08 13:16:20'),(78,26,4,'room','room name','2015-03-08 13:16:20','2015-03-08 13:16:20'),(79,27,1,'width','200','2015-03-08 13:16:32','2015-03-08 13:16:32'),(80,27,2,'drop','200','2015-03-08 13:16:32','2015-03-08 13:16:32'),(81,27,4,'room','room name','2015-03-08 13:16:32','2015-03-08 13:16:32'),(82,29,5,'length','360','2015-03-08 13:47:27','2015-03-08 13:47:27'),(83,30,5,'length','420','2015-03-08 13:47:27','2015-03-08 13:47:27'),(84,31,5,'length','220','2015-03-08 13:47:48','2015-03-08 13:47:48'),(85,32,5,'length','220','2015-03-08 13:48:21','2015-03-08 13:48:21'),(86,33,5,'length','220','2015-03-08 13:48:52','2015-03-08 13:48:52'),(87,34,5,'length','220','2015-03-08 13:49:39','2015-03-08 13:49:39'),(88,35,5,'length','220','2015-03-08 13:50:06','2015-03-08 13:50:06'),(89,36,5,'length','220','2015-03-08 13:51:17','2015-03-08 13:51:17'),(90,37,5,'length','220','2015-03-08 13:52:00','2015-03-08 13:52:00'),(91,38,5,'length','220','2015-03-08 13:54:56','2015-03-08 13:54:56'),(92,39,5,'length','220','2015-03-08 14:26:44','2015-03-08 14:26:44'),(93,40,5,'length','220','2015-03-08 14:26:44','2015-03-08 14:26:44'),(94,41,5,'length','220','2015-03-08 14:26:44','2015-03-08 14:26:44'),(95,42,5,'length','220','2015-03-08 14:27:17','2015-03-08 14:27:17'),(96,43,5,'length','220','2015-03-08 14:28:34','2015-03-08 14:28:34'),(97,44,5,'length','220','2015-03-08 14:29:19','2015-03-08 14:29:19'),(98,45,5,'length','220','2015-03-08 14:29:58','2015-03-08 14:29:58'),(99,46,5,'length','220','2015-03-08 14:30:38','2015-03-08 14:30:38'),(100,47,5,'length','220','2015-03-08 14:31:27','2015-03-08 14:31:27'),(101,48,5,'length','220','2015-03-08 14:31:42','2015-03-08 14:31:42'),(102,49,5,'length','220','2015-03-08 14:31:58','2015-03-08 14:31:58'),(103,50,5,'length','220','2015-03-08 14:31:58','2015-03-08 14:31:58'),(104,51,5,'length','220','2015-03-08 14:31:59','2015-03-08 14:31:59'),(105,52,5,'length','220','2015-03-08 14:31:59','2015-03-08 14:31:59'),(106,53,5,'length','220','2015-03-08 14:32:55','2015-03-08 14:32:55'),(107,54,5,'length','220','2015-03-08 14:32:56','2015-03-08 14:32:56'),(108,55,5,'length','220','2015-03-08 14:32:56','2015-03-08 14:32:56'),(109,56,5,'length','220','2015-03-08 14:33:10','2015-03-08 14:33:10'),(110,57,5,'length','220','2015-03-08 14:33:10','2015-03-08 14:33:10'),(111,58,5,'length','220','2015-03-08 14:33:10','2015-03-08 14:33:10'),(112,59,5,'length','220','2015-03-08 14:33:24','2015-03-08 14:33:24'),(113,60,5,'length','220','2015-03-08 14:33:25','2015-03-08 14:33:25'),(114,61,5,'length','220','2015-03-08 14:33:25','2015-03-08 14:33:25'),(115,62,1,'width','123','2015-03-08 14:48:20','2015-03-08 14:48:20'),(116,62,2,'drop','100','2015-03-08 14:48:20','2015-03-08 14:48:20'),(117,62,4,'room','room name','2015-03-08 14:48:20','2015-03-08 14:48:20'),(118,63,1,'width','123','2015-03-08 14:49:31','2015-03-08 14:49:31'),(119,63,2,'drop','100','2015-03-08 14:49:31','2015-03-08 14:49:31'),(120,63,4,'room','room name','2015-03-08 14:49:31','2015-03-08 14:49:31'),(121,64,5,'length','220','2015-03-08 14:50:08','2015-03-08 14:50:08'),(122,65,5,'length','220','2015-03-08 14:50:08','2015-03-08 14:50:08'),(123,66,1,'width','100','2015-03-08 16:34:55','2015-03-08 16:34:55'),(124,66,2,'drop','100','2015-03-08 16:34:55','2015-03-08 16:34:55'),(125,66,4,'room','room name','2015-03-08 16:34:55','2015-03-08 16:34:55'),(126,67,1,'width','100','2015-03-08 16:35:01','2015-03-08 16:35:01'),(127,67,2,'drop','100','2015-03-08 16:35:01','2015-03-08 16:35:01'),(128,67,4,'room','room name','2015-03-08 16:35:01','2015-03-08 16:35:01'),(129,1,1,'width','100','2015-03-08 16:45:27','2015-03-08 16:45:27'),(130,1,2,'drop','100','2015-03-08 16:45:27','2015-03-08 16:45:27'),(131,1,4,'room','room name','2015-03-08 16:45:27','2015-03-08 16:45:27'),(132,2,1,'width','100','2015-03-08 16:46:01','2015-03-08 16:46:01'),(133,2,2,'drop','100','2015-03-08 16:46:01','2015-03-08 16:46:01'),(134,2,4,'room','room name','2015-03-08 16:46:01','2015-03-08 16:46:01'),(135,4,1,'width','100','2015-03-08 17:01:31','2015-03-08 17:01:31'),(136,4,2,'drop','100','2015-03-08 17:01:31','2015-03-08 17:01:31'),(137,4,4,'room','My Room','2015-03-08 17:01:31','2015-03-08 17:01:31'),(138,5,1,'width','100','2015-03-08 17:06:55','2015-03-08 17:06:55'),(139,5,2,'drop','100','2015-03-08 17:06:55','2015-03-08 17:06:55'),(140,5,4,'room','My Room','2015-03-08 17:06:55','2015-03-08 17:06:55'),(141,6,1,'width','100','2015-03-08 17:07:25','2015-03-08 17:07:25'),(142,6,2,'drop','100','2015-03-08 17:07:25','2015-03-08 17:07:25'),(143,6,4,'room','My Room','2015-03-08 17:07:25','2015-03-08 17:07:25'),(144,9,1,'width','100','2015-03-08 17:11:31','2015-03-08 17:11:31'),(145,9,2,'drop','100','2015-03-08 17:11:31','2015-03-08 17:11:31'),(146,9,4,'room','My Room','2015-03-08 17:11:31','2015-03-08 17:11:31'),(147,10,1,'width','100','2015-03-08 17:16:25','2015-03-08 17:16:25'),(148,10,2,'drop','100','2015-03-08 17:16:25','2015-03-08 17:16:25'),(149,10,4,'room','My Room','2015-03-08 17:16:25','2015-03-08 17:16:25'),(150,11,1,'width','100','2015-03-08 17:17:17','2015-03-08 17:17:17'),(151,11,2,'drop','100','2015-03-08 17:17:17','2015-03-08 17:17:17'),(152,11,4,'room','My Room','2015-03-08 17:17:17','2015-03-08 17:17:17'),(153,12,1,'width','100','2015-03-08 17:18:29','2015-03-08 17:18:29'),(154,12,2,'drop','100','2015-03-08 17:18:29','2015-03-08 17:18:29'),(155,12,4,'room','room name','2015-03-08 17:18:29','2015-03-08 17:18:29'),(156,13,5,'length','220','2015-03-08 17:18:43','2015-03-08 17:18:43'),(157,14,5,'length','220','2015-03-08 17:18:43','2015-03-08 17:18:43'),(158,15,5,'length','220','2015-03-08 17:18:44','2015-03-08 17:18:44'),(159,16,5,'length','220','2015-03-08 17:18:44','2015-03-08 17:18:44'),(160,17,5,'length','360','2015-03-08 17:19:52','2015-03-08 17:19:52'),(161,18,5,'length','420','2015-03-08 17:19:52','2015-03-08 17:19:52'),(162,19,5,'length','220','2015-03-08 17:20:54','2015-03-08 17:20:54'),(163,20,5,'length','220','2015-03-08 17:20:54','2015-03-08 17:20:54'),(164,21,5,'length','220','2015-03-08 17:20:54','2015-03-08 17:20:54'),(165,22,5,'length','220','2015-03-08 17:20:54','2015-03-08 17:20:54'),(166,23,5,'length','220','2015-03-08 17:21:59','2015-03-08 17:21:59'),(167,24,5,'length','220','2015-03-08 17:21:59','2015-03-08 17:21:59'),(168,25,5,'length','220','2015-03-08 17:21:59','2015-03-08 17:21:59'),(169,26,5,'length','220','2015-03-08 17:21:59','2015-03-08 17:21:59'),(170,27,5,'length','220','2015-03-08 17:23:20','2015-03-08 17:23:20'),(171,28,5,'length','220','2015-03-08 17:23:21','2015-03-08 17:23:21'),(172,29,5,'length','220','2015-03-08 17:23:21','2015-03-08 17:23:21'),(173,30,5,'length','220','2015-03-08 17:23:21','2015-03-08 17:23:21'),(174,31,1,'width','100','2015-03-08 18:13:20','2015-03-08 18:13:20'),(175,31,2,'drop','100','2015-03-08 18:13:20','2015-03-08 18:13:20'),(176,31,4,'room','room name','2015-03-08 18:13:20','2015-03-08 18:13:20'),(177,32,1,'width','100','2015-03-08 18:13:24','2015-03-08 18:13:24'),(178,32,2,'drop','100','2015-03-08 18:13:24','2015-03-08 18:13:24'),(179,32,4,'room','room name','2015-03-08 18:13:25','2015-03-08 18:13:25'),(180,33,1,'width','100','2015-03-08 18:13:27','2015-03-08 18:13:27'),(181,33,2,'drop','100','2015-03-08 18:13:27','2015-03-08 18:13:27'),(182,33,4,'room','room name','2015-03-08 18:13:27','2015-03-08 18:13:27'),(183,34,1,'width','100','2015-03-08 18:21:12','2015-03-08 18:21:12'),(184,34,2,'drop','100','2015-03-08 18:21:12','2015-03-08 18:21:12'),(185,34,4,'room','room name','2015-03-08 18:21:12','2015-03-08 18:21:12'),(186,35,1,'width','100','2015-03-08 18:25:09','2015-03-08 18:25:09'),(187,35,2,'drop','100','2015-03-08 18:25:09','2015-03-08 18:25:09'),(188,35,4,'room','room name','2015-03-08 18:25:09','2015-03-08 18:25:09'),(189,36,1,'width','100','2015-03-08 18:28:22','2015-03-08 18:28:22'),(190,36,2,'drop','100','2015-03-08 18:28:22','2015-03-08 18:28:22'),(191,36,4,'room','room name','2015-03-08 18:28:22','2015-03-08 18:28:22'),(192,37,1,'width','100','2015-03-08 18:30:22','2015-03-08 18:30:22'),(193,37,2,'drop','100','2015-03-08 18:30:22','2015-03-08 18:30:22'),(194,37,4,'room','room name','2015-03-08 18:30:22','2015-03-08 18:30:22'),(195,38,1,'width','100','2015-03-08 18:30:25','2015-03-08 18:30:25'),(196,38,2,'drop','100','2015-03-08 18:30:25','2015-03-08 18:30:25'),(197,38,4,'room','room name','2015-03-08 18:30:25','2015-03-08 18:30:25'),(198,39,1,'width','100','2015-03-08 18:30:28','2015-03-08 18:30:28'),(199,39,2,'drop','100','2015-03-08 18:30:28','2015-03-08 18:30:28'),(200,39,4,'room','room name','2015-03-08 18:30:28','2015-03-08 18:30:28'),(201,40,1,'width','100','2015-03-08 18:30:30','2015-03-08 18:30:30'),(202,40,2,'drop','100','2015-03-08 18:30:30','2015-03-08 18:30:30'),(203,40,4,'room','room name','2015-03-08 18:30:30','2015-03-08 18:30:30'),(204,43,1,'width','100','2015-03-08 18:33:15','2015-03-08 18:33:15'),(205,43,2,'drop','100','2015-03-08 18:33:15','2015-03-08 18:33:15'),(206,43,4,'room','room name','2015-03-08 18:33:15','2015-03-08 18:33:15'),(207,44,1,'width','100','2015-03-08 18:44:02','2015-03-08 18:44:02'),(208,44,2,'drop','100','2015-03-08 18:44:02','2015-03-08 18:44:02'),(209,44,4,'room','room name','2015-03-08 18:44:02','2015-03-08 18:44:02'),(210,45,1,'width','100','2015-03-08 18:46:01','2015-03-08 18:46:01'),(211,45,2,'drop','100','2015-03-08 18:46:01','2015-03-08 18:46:01'),(212,45,4,'room','room name','2015-03-08 18:46:01','2015-03-08 18:46:01'),(213,46,1,'width','100','2015-03-08 18:46:51','2015-03-08 18:46:51'),(214,46,2,'drop','100','2015-03-08 18:46:51','2015-03-08 18:46:51'),(215,46,4,'room','room name','2015-03-08 18:46:51','2015-03-08 18:46:51'),(216,47,1,'width','100','2015-03-08 18:58:42','2015-03-08 18:58:42'),(217,47,2,'drop','100','2015-03-08 18:58:42','2015-03-08 18:58:42'),(218,47,4,'room','room name','2015-03-08 18:58:43','2015-03-08 18:58:43'),(219,48,1,'width','100','2015-03-08 19:12:34','2015-03-08 19:12:34'),(220,48,2,'drop','100','2015-03-08 19:12:34','2015-03-08 19:12:34'),(221,48,4,'room','room name','2015-03-08 19:12:34','2015-03-08 19:12:34'),(222,49,1,'width','100','2015-03-08 19:12:39','2015-03-08 19:12:39'),(223,49,2,'drop','100','2015-03-08 19:12:39','2015-03-08 19:12:39'),(224,49,4,'room','room name','2015-03-08 19:12:39','2015-03-08 19:12:39'),(225,50,1,'width','100','2015-03-08 19:12:41','2015-03-08 19:12:41'),(226,50,2,'drop','100','2015-03-08 19:12:41','2015-03-08 19:12:41'),(227,50,4,'room','room name','2015-03-08 19:12:42','2015-03-08 19:12:42'),(228,51,1,'width','100','2015-03-08 19:12:51','2015-03-08 19:12:51'),(229,51,2,'drop','100','2015-03-08 19:12:51','2015-03-08 19:12:51'),(230,51,4,'room','room name','2015-03-08 19:12:51','2015-03-08 19:12:51'),(231,52,1,'width','100','2015-03-08 19:12:55','2015-03-08 19:12:55'),(232,52,2,'drop','100','2015-03-08 19:12:55','2015-03-08 19:12:55'),(233,52,4,'room','room name','2015-03-08 19:12:55','2015-03-08 19:12:55'),(234,53,1,'width','100','2015-03-08 19:13:40','2015-03-08 19:13:40'),(235,53,2,'drop','100','2015-03-08 19:13:40','2015-03-08 19:13:40'),(236,53,4,'room','room name','2015-03-08 19:13:40','2015-03-08 19:13:40'),(237,54,1,'width','100','2015-03-08 19:20:53','2015-03-08 19:20:53'),(238,54,2,'drop','100','2015-03-08 19:20:53','2015-03-08 19:20:53'),(239,54,4,'room','room name','2015-03-08 19:20:53','2015-03-08 19:20:53'),(240,55,1,'width','100','2015-03-09 17:19:15','2015-03-09 17:19:15'),(241,55,2,'drop','100','2015-03-09 17:19:15','2015-03-09 17:19:15'),(242,55,4,'room','room name','2015-03-09 17:19:15','2015-03-09 17:19:15'),(243,56,1,'width','100','2015-03-09 18:16:33','2015-03-09 18:16:33'),(244,56,2,'drop','100','2015-03-09 18:16:33','2015-03-09 18:16:33'),(245,56,4,'room','room name','2015-03-09 18:16:33','2015-03-09 18:16:33'),(246,57,1,'width','100','2015-03-09 18:17:13','2015-03-09 18:17:13'),(247,57,2,'drop','100','2015-03-09 18:17:13','2015-03-09 18:17:13'),(248,57,4,'room','room name','2015-03-09 18:17:13','2015-03-09 18:17:13'),(249,58,1,'width','100','2015-03-09 18:17:36','2015-03-09 18:17:36'),(250,58,2,'drop','100','2015-03-09 18:17:36','2015-03-09 18:17:36'),(251,58,4,'room','my bedroom','2015-03-09 18:17:36','2015-03-09 18:17:36');
  /*!40000 ALTER TABLE `order_item_fields` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `order_item_options`
  --
  
  DROP TABLE IF EXISTS `order_item_options`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `order_item_options` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `order_item_id` int(10) unsigned NOT NULL,
    `option_id` int(10) unsigned NOT NULL,
    `option_name` varchar(255) NOT NULL DEFAULT '',
    `option_value_id` int(12) DEFAULT NULL,
    `option_value` varchar(255) NOT NULL DEFAULT '',
    `created_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `order_item_options`
  --
  
  LOCK TABLES `order_item_options` WRITE;
  /*!40000 ALTER TABLE `order_item_options` DISABLE KEYS */;
  INSERT INTO `order_item_options` VALUES (1,1,15,'Slat Size',112,'50mm','2015-03-01 18:56:50','2015-03-01 18:56:50'),(2,1,18,'Recess or Exact',147,'Recess','2015-03-01 18:56:50','2015-03-01 18:56:50'),(3,2,15,'Slat Size',112,'50mm','2015-03-01 18:57:01','2015-03-01 18:57:01'),(4,2,18,'Recess or Exact',147,'Recess','2015-03-01 18:57:01','2015-03-01 18:57:01'),(5,3,15,'Slat Size',112,'50mm','2015-03-01 18:58:42','2015-03-01 18:58:42'),(6,3,18,'Recess or Exact',147,'Recess','2015-03-01 18:58:42','2015-03-01 18:58:42'),(7,4,15,'Slat Size',112,'50mm','2015-03-01 19:00:34','2015-03-01 19:00:34'),(8,4,18,'Recess or Exact',147,'Recess','2015-03-01 19:00:34','2015-03-01 19:00:34'),(9,5,15,'Slat Size',112,'50mm','2015-03-01 19:01:56','2015-03-01 19:01:56'),(10,5,18,'Recess or Exact',147,'Recess','2015-03-01 19:01:56','2015-03-01 19:01:56'),(11,6,15,'Slat Size',110,'27mm','2015-03-01 19:02:46','2015-03-01 19:02:46'),(12,6,18,'Recess or Exact',146,'Exact','2015-03-01 19:02:46','2015-03-01 19:02:46'),(13,7,15,'Slat Size',110,'27mm','2015-03-01 19:04:41','2015-03-01 19:04:41'),(14,7,18,'Recess or Exact',146,'Exact','2015-03-01 19:04:41','2015-03-01 19:04:41'),(15,8,15,'Slat Size',110,'27mm','2015-03-01 19:07:19','2015-03-01 19:07:19'),(16,8,18,'Recess or Exact',146,'Exact','2015-03-01 19:07:19','2015-03-01 19:07:19'),(17,9,15,'Slat Size',110,'27mm','2015-03-01 19:07:30','2015-03-01 19:07:30'),(18,9,18,'Recess or Exact',146,'Exact','2015-03-01 19:07:30','2015-03-01 19:07:30'),(19,10,15,'Slat Size',111,'35mm','2015-03-01 19:13:50','2015-03-01 19:13:50'),(20,10,18,'Recess or Exact',146,'Exact','2015-03-01 19:13:50','2015-03-01 19:13:50'),(21,11,15,'Slat Size',111,'35mm','2015-03-01 19:14:07','2015-03-01 19:14:07'),(22,11,18,'Recess or Exact',146,'Exact','2015-03-01 19:14:07','2015-03-01 19:14:07'),(23,12,15,'Slat Size',110,'27mm','2015-03-05 18:30:31','2015-03-05 18:30:31'),(24,12,18,'Recess or Exact',146,'Exact','2015-03-05 18:30:31','2015-03-05 18:30:31'),(25,13,15,'Slat Size',110,'27mm','2015-03-05 18:30:36','2015-03-05 18:30:36'),(26,13,18,'Recess or Exact',146,'Exact','2015-03-05 18:30:36','2015-03-05 18:30:36'),(27,14,15,'Slat Size',110,'27mm','2015-03-05 18:30:52','2015-03-05 18:30:52'),(28,14,18,'Recess or Exact',146,'Exact','2015-03-05 18:30:52','2015-03-05 18:30:52'),(29,15,15,'Slat Size',110,'27mm','2015-03-05 18:35:46','2015-03-05 18:35:46'),(30,15,18,'Recess or Exact',146,'Exact','2015-03-05 18:35:46','2015-03-05 18:35:46'),(31,16,15,'Slat Size',110,'27mm','2015-03-05 18:36:25','2015-03-05 18:36:25'),(32,16,18,'Recess or Exact',146,'Exact','2015-03-05 18:36:25','2015-03-05 18:36:25'),(33,17,15,'Slat Size',110,'27mm','2015-03-05 18:37:24','2015-03-05 18:37:24'),(34,17,18,'Recess or Exact',146,'Exact','2015-03-05 18:37:24','2015-03-05 18:37:24'),(35,18,15,'Slat Size',110,'27mm','2015-03-05 18:37:44','2015-03-05 18:37:44'),(36,18,18,'Recess or Exact',146,'Exact','2015-03-05 18:37:44','2015-03-05 18:37:44'),(37,19,15,'Slat Size',110,'27mm','2015-03-05 18:38:38','2015-03-05 18:38:38'),(38,19,18,'Recess or Exact',146,'Exact','2015-03-05 18:38:38','2015-03-05 18:38:38'),(39,20,15,'Slat Size',110,'27mm','2015-03-05 18:48:06','2015-03-05 18:48:06'),(40,20,18,'Recess or Exact',146,'Exact','2015-03-05 18:48:06','2015-03-05 18:48:06'),(41,21,15,'Slat Size',111,'35mm','2015-03-05 18:48:24','2015-03-05 18:48:24'),(42,21,18,'Recess or Exact',146,'Exact','2015-03-05 18:48:24','2015-03-05 18:48:24'),(43,22,15,'Slat Size',111,'35mm','2015-03-05 18:48:36','2015-03-05 18:48:36'),(44,22,18,'Recess or Exact',146,'Exact','2015-03-05 18:48:36','2015-03-05 18:48:36'),(45,23,15,'Slat Size',110,'27mm','2015-03-08 13:09:58','2015-03-08 13:09:58'),(46,23,18,'Recess or Exact',146,'Exact','2015-03-08 13:09:58','2015-03-08 13:09:58'),(47,24,15,'Slat Size',110,'27mm','2015-03-08 13:11:23','2015-03-08 13:11:23'),(48,24,18,'Recess or Exact',146,'Exact','2015-03-08 13:11:23','2015-03-08 13:11:23'),(49,25,15,'Slat Size',110,'27mm','2015-03-08 13:14:39','2015-03-08 13:14:39'),(50,25,18,'Recess or Exact',146,'Exact','2015-03-08 13:14:39','2015-03-08 13:14:39'),(51,26,15,'Slat Size',110,'27mm','2015-03-08 13:16:19','2015-03-08 13:16:19'),(52,26,18,'Recess or Exact',146,'Exact','2015-03-08 13:16:19','2015-03-08 13:16:19'),(53,27,15,'Slat Size',111,'35mm','2015-03-08 13:16:32','2015-03-08 13:16:32'),(54,27,18,'Recess or Exact',147,'Recess','2015-03-08 13:16:32','2015-03-08 13:16:32'),(55,62,15,'Slat Size',110,'27mm','2015-03-08 14:48:20','2015-03-08 14:48:20'),(56,62,18,'Recess or Exact',146,'Exact','2015-03-08 14:48:20','2015-03-08 14:48:20'),(57,63,15,'Slat Size',110,'27mm','2015-03-08 14:49:31','2015-03-08 14:49:31'),(58,63,18,'Recess or Exact',146,'Exact','2015-03-08 14:49:31','2015-03-08 14:49:31'),(59,66,15,'Slat Size',110,'27mm','2015-03-08 16:34:55','2015-03-08 16:34:55'),(60,66,18,'Recess or Exact',146,'Exact','2015-03-08 16:34:55','2015-03-08 16:34:55'),(61,67,15,'Slat Size',110,'27mm','2015-03-08 16:35:01','2015-03-08 16:35:01'),(62,67,18,'Recess or Exact',146,'Exact','2015-03-08 16:35:01','2015-03-08 16:35:01'),(63,1,15,'Slat Size',110,'27mm','2015-03-08 16:45:27','2015-03-08 16:45:27'),(64,1,18,'Recess or Exact',146,'Exact','2015-03-08 16:45:27','2015-03-08 16:45:27'),(65,2,15,'Slat Size',110,'27mm','2015-03-08 16:46:01','2015-03-08 16:46:01'),(66,2,18,'Recess or Exact',146,'Exact','2015-03-08 16:46:01','2015-03-08 16:46:01'),(67,9,15,'Slat Size',110,'27mm','2015-03-08 17:11:31','2015-03-08 17:11:31'),(68,9,18,'Recess or Exact',146,'Exact','2015-03-08 17:11:31','2015-03-08 17:11:31'),(69,10,15,'Slat Size',110,'27mm','2015-03-08 17:16:25','2015-03-08 17:16:25'),(70,10,18,'Recess or Exact',146,'Exact','2015-03-08 17:16:25','2015-03-08 17:16:25'),(71,11,15,'Slat Size',110,'27mm','2015-03-08 17:17:17','2015-03-08 17:17:17'),(72,11,18,'Recess or Exact',146,'Exact','2015-03-08 17:17:17','2015-03-08 17:17:17'),(73,12,15,'Slat Size',110,'27mm','2015-03-08 17:18:29','2015-03-08 17:18:29'),(74,12,18,'Recess or Exact',146,'Exact','2015-03-08 17:18:29','2015-03-08 17:18:29'),(75,31,15,'Slat Size',110,'27mm','2015-03-08 18:13:20','2015-03-08 18:13:20'),(76,31,18,'Recess or Exact',146,'Exact','2015-03-08 18:13:20','2015-03-08 18:13:20'),(77,32,15,'Slat Size',110,'27mm','2015-03-08 18:13:24','2015-03-08 18:13:24'),(78,32,18,'Recess or Exact',146,'Exact','2015-03-08 18:13:24','2015-03-08 18:13:24'),(79,33,15,'Slat Size',110,'27mm','2015-03-08 18:13:27','2015-03-08 18:13:27'),(80,33,18,'Recess or Exact',146,'Exact','2015-03-08 18:13:27','2015-03-08 18:13:27'),(81,34,15,'Slat Size',110,'27mm','2015-03-08 18:21:12','2015-03-08 18:21:12'),(82,34,18,'Recess or Exact',146,'Exact','2015-03-08 18:21:12','2015-03-08 18:21:12'),(83,35,15,'Slat Size',110,'27mm','2015-03-08 18:25:09','2015-03-08 18:25:09'),(84,35,18,'Recess or Exact',146,'Exact','2015-03-08 18:25:09','2015-03-08 18:25:09'),(85,36,15,'Slat Size',110,'27mm','2015-03-08 18:28:22','2015-03-08 18:28:22'),(86,36,18,'Recess or Exact',146,'Exact','2015-03-08 18:28:22','2015-03-08 18:28:22'),(87,37,15,'Slat Size',110,'27mm','2015-03-08 18:30:22','2015-03-08 18:30:22'),(88,37,18,'Recess or Exact',146,'Exact','2015-03-08 18:30:22','2015-03-08 18:30:22'),(89,38,15,'Slat Size',110,'27mm','2015-03-08 18:30:25','2015-03-08 18:30:25'),(90,38,18,'Recess or Exact',146,'Exact','2015-03-08 18:30:25','2015-03-08 18:30:25'),(91,39,15,'Slat Size',110,'27mm','2015-03-08 18:30:28','2015-03-08 18:30:28'),(92,39,18,'Recess or Exact',146,'Exact','2015-03-08 18:30:28','2015-03-08 18:30:28'),(93,40,15,'Slat Size',110,'27mm','2015-03-08 18:30:30','2015-03-08 18:30:30'),(94,40,18,'Recess or Exact',146,'Exact','2015-03-08 18:30:30','2015-03-08 18:30:30'),(95,43,15,'Slat Size',110,'27mm','2015-03-08 18:33:15','2015-03-08 18:33:15'),(96,43,18,'Recess or Exact',146,'Exact','2015-03-08 18:33:15','2015-03-08 18:33:15'),(97,44,15,'Slat Size',110,'27mm','2015-03-08 18:44:02','2015-03-08 18:44:02'),(98,44,18,'Recess or Exact',146,'Exact','2015-03-08 18:44:02','2015-03-08 18:44:02'),(99,45,15,'Slat Size',110,'27mm','2015-03-08 18:46:01','2015-03-08 18:46:01'),(100,45,18,'Recess or Exact',146,'Exact','2015-03-08 18:46:01','2015-03-08 18:46:01'),(101,46,15,'Slat Size',110,'27mm','2015-03-08 18:46:51','2015-03-08 18:46:51'),(102,46,18,'Recess or Exact',146,'Exact','2015-03-08 18:46:51','2015-03-08 18:46:51'),(103,47,15,'Slat Size',110,'27mm','2015-03-08 18:58:42','2015-03-08 18:58:42'),(104,47,18,'Recess or Exact',146,'Exact','2015-03-08 18:58:42','2015-03-08 18:58:42'),(105,48,15,'Slat Size',110,'27mm','2015-03-08 19:12:34','2015-03-08 19:12:34'),(106,48,18,'Recess or Exact',146,'Exact','2015-03-08 19:12:34','2015-03-08 19:12:34'),(107,49,15,'Slat Size',110,'27mm','2015-03-08 19:12:39','2015-03-08 19:12:39'),(108,49,18,'Recess or Exact',146,'Exact','2015-03-08 19:12:39','2015-03-08 19:12:39'),(109,50,15,'Slat Size',110,'27mm','2015-03-08 19:12:41','2015-03-08 19:12:41'),(110,50,18,'Recess or Exact',146,'Exact','2015-03-08 19:12:41','2015-03-08 19:12:41'),(111,51,15,'Slat Size',110,'27mm','2015-03-08 19:12:51','2015-03-08 19:12:51'),(112,51,18,'Recess or Exact',146,'Exact','2015-03-08 19:12:51','2015-03-08 19:12:51'),(113,52,15,'Slat Size',110,'27mm','2015-03-08 19:12:55','2015-03-08 19:12:55'),(114,52,18,'Recess or Exact',146,'Exact','2015-03-08 19:12:55','2015-03-08 19:12:55'),(115,53,15,'Slat Size',110,'27mm','2015-03-08 19:13:40','2015-03-08 19:13:40'),(116,53,18,'Recess or Exact',146,'Exact','2015-03-08 19:13:40','2015-03-08 19:13:40'),(117,54,15,'Slat Size',110,'27mm','2015-03-08 19:20:53','2015-03-08 19:20:53'),(118,54,18,'Recess or Exact',146,'Exact','2015-03-08 19:20:53','2015-03-08 19:20:53'),(119,55,15,'Slat Size',110,'27mm','2015-03-09 17:19:15','2015-03-09 17:19:15'),(120,55,18,'Recess or Exact',146,'Exact','2015-03-09 17:19:15','2015-03-09 17:19:15'),(121,56,15,'Slat Size',110,'27mm','2015-03-09 18:16:33','2015-03-09 18:16:33'),(122,56,18,'Recess or Exact',146,'Exact','2015-03-09 18:16:33','2015-03-09 18:16:33'),(123,57,15,'Slat Size',112,'50mm','2015-03-09 18:17:13','2015-03-09 18:17:13'),(124,57,18,'Recess or Exact',146,'Exact','2015-03-09 18:17:13','2015-03-09 18:17:13'),(125,58,15,'Slat Size',112,'50mm','2015-03-09 18:17:35','2015-03-09 18:17:35'),(126,58,18,'Recess or Exact',146,'Exact','2015-03-09 18:17:35','2015-03-09 18:17:35');
  /*!40000 ALTER TABLE `order_item_options` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `order_item_statuses`
  --
  
  DROP TABLE IF EXISTS `order_item_statuses`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `order_item_statuses` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(100) NOT NULL,
    `locked` tinyint(1) DEFAULT '0',
    `created_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `order_item_statuses`
  --
  
  LOCK TABLES `order_item_statuses` WRITE;
  /*!40000 ALTER TABLE `order_item_statuses` DISABLE KEYS */;
  INSERT INTO `order_item_statuses` VALUES (1,'new',0,NULL,NULL),(2,'allocated',1,NULL,NULL),(3,'failed allocation',0,NULL,NULL),(4,'dispatched',1,NULL,NULL),(5,'in cart',0,NULL,NULL),(6,'awaiting parts',1,NULL,NULL),(10,'Awaiting Order From Supplier',1,NULL,NULL),(15,'Ordered',1,NULL,NULL);
  /*!40000 ALTER TABLE `order_item_statuses` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `order_items`
  --
  
  DROP TABLE IF EXISTS `order_items`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `order_items` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `order_item_status_id` int(10) unsigned NOT NULL DEFAULT '5',
    `product_id` int(10) unsigned NOT NULL,
    `order_id` int(10) unsigned NOT NULL,
    `sku` varchar(100) NOT NULL,
    `name` text,
    `qty` int(3) unsigned NOT NULL,
    `price` float(7,2) DEFAULT NULL,
    `price_subtotal` float(7,2) DEFAULT NULL,
    `weight` float(6,2) DEFAULT NULL,
    `weight_subtotal` double DEFAULT NULL,
    `cost` float(7,2) DEFAULT NULL,
    `cost_subtotal` float(7,2) DEFAULT NULL,
    `type` tinyint(3) DEFAULT NULL,
    `lead_time` int(11) DEFAULT '0',
    `rrp` float(7,2) DEFAULT NULL,
    `discount` float(4,3) DEFAULT NULL,
    `vat` float(7,2) DEFAULT NULL,
    `vat_subtotal` float(7,2) DEFAULT NULL,
    `created_at` datetime DEFAULT '0000-00-00 00:00:00',
    `updated_at` datetime DEFAULT '0000-00-00 00:00:00',
    `item_id` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `order_items`
  --
  
  LOCK TABLES `order_items` WRITE;
  /*!40000 ALTER TABLE `order_items` DISABLE KEYS */;
  INSERT INTO `order_items` VALUES (3,5,396,27,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 17:01:01','2015-03-08 17:01:01',1),(4,5,396,27,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 17:01:31','2015-03-08 17:01:31',2),(5,5,396,27,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 17:06:55','2015-03-08 17:06:55',3),(6,5,396,27,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 17:07:24','2015-03-08 17:07:24',4),(7,5,396,27,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 17:10:53','2015-03-08 17:10:53',5),(8,5,396,27,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 17:11:09','2015-03-08 17:11:09',6),(9,5,396,27,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 17:11:31','2015-03-08 17:11:31',7),(10,5,396,27,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 17:16:25','2015-03-08 17:16:25',8),(11,5,396,27,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 17:17:17','2015-03-08 17:17:17',9),(17,5,3123,27,'1234','28mm Allure Antique Brass Ball Curtain Pole',1,23.99,23.99,1.00,1,11.99,11.99,1,1,23.99,0.000,4.80,4.80,'2015-03-08 17:19:51','2015-03-08 17:19:51',19),(18,5,3123,27,'1234','28mm Allure Antique Brass Ball Curtain Pole',1,42.99,42.99,1.00,1,21.50,21.50,1,1,42.99,0.000,8.60,8.60,'2015-03-08 17:19:52','2015-03-08 17:19:52',20),(48,5,396,48,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 19:12:34','2015-03-08 19:12:34',1),(49,5,396,48,'1234','GB Premier Simply White',2,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 19:12:39','2015-03-08 19:19:35',2),(51,5,396,48,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 19:12:50','2015-03-08 19:12:50',3),(52,5,396,48,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 19:12:55','2015-03-08 19:12:55',4),(53,5,396,48,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 19:13:40','2015-03-08 19:13:40',5),(54,5,396,48,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-08 19:20:52','2015-03-08 19:20:52',6),(55,5,396,49,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-09 17:19:15','2015-03-09 17:19:15',1),(56,5,396,49,'1234','GB Premier Simply White',1,34.33,34.33,1.00,1,17.16,17.16,1,1,34.33,0.000,6.87,6.87,'2015-03-09 18:16:33','2015-03-09 18:16:33',2),(57,5,396,49,'1234','GB Premier Simply White',1,42.22,42.22,1.00,1,21.11,21.11,1,1,42.22,0.000,8.44,8.44,'2015-03-09 18:17:13','2015-03-09 18:17:13',3),(58,5,396,49,'1234','GB Premier Simply White',1,42.22,42.22,1.00,1,21.11,21.11,1,1,42.22,0.000,8.44,8.44,'2015-03-09 18:17:35','2015-03-09 18:17:35',4),(59,5,123,234,'',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2015-03-15 14:39:35','2015-03-15 14:39:35',NULL);
  /*!40000 ALTER TABLE `order_items` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `order_statuses`
  --
  
  DROP TABLE IF EXISTS `order_statuses`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `order_statuses` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(30) DEFAULT NULL,
    `locked` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `order_statuses`
  --
  
  LOCK TABLES `order_statuses` WRITE;
  /*!40000 ALTER TABLE `order_statuses` DISABLE KEYS */;
  INSERT INTO `order_statuses` VALUES (1,'Shopping',0,'2014-02-12 15:58:00','2014-02-12 15:58:00'),(2,'Confirmed',1,'2014-02-12 15:58:00','2014-02-12 15:58:00');
  /*!40000 ALTER TABLE `order_statuses` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `orders`
  --
  
  DROP TABLE IF EXISTS `orders`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `orders` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `order_status_id` int(10) unsigned NOT NULL DEFAULT '1',
    `amount` float(8,2) DEFAULT '0.00',
    `total_items` int(5) unsigned DEFAULT '0',
    `ip` varchar(15) DEFAULT NULL,
    `customer_id` int(10) unsigned DEFAULT NULL,
    `weight` double DEFAULT '0',
    `tax` float(6,2) DEFAULT '0.00',
    `cost` float(6,2) DEFAULT '0.00',
    `ship_cost` float(6,2) DEFAULT '0.00',
    `is_vat_charged` tinyint(1) unsigned DEFAULT '1',
    `total` float(8,2) DEFAULT NULL,
    `vat_rate` float(4,2) DEFAULT '17.50',
    `priority` int(11) DEFAULT '0',
    `site_id` int(11) DEFAULT NULL,
    `billing_address_id` int(11) DEFAULT NULL,
    `shipping_address_id` int(11) DEFAULT NULL,
    `created_at` datetime DEFAULT '0000-00-00 00:00:00',
    `updated_at` datetime DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `orders`
  --
  
  LOCK TABLES `orders` WRITE;
  /*!40000 ALTER TABLE `orders` DISABLE KEYS */;
  INSERT INTO `orders` VALUES (1,2,0.00,6,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-12 15:48:24','2015-02-16 16:23:59'),(2,1,0.00,5,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-12 15:48:43','2015-02-12 15:48:43'),(3,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-16 09:26:04','2015-02-16 09:26:04'),(4,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-16 09:26:17','2015-02-16 09:26:17'),(5,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 10:09:36','2015-02-25 10:09:36'),(6,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 10:30:13','2015-02-25 10:30:13'),(7,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 14:48:52','2015-02-25 14:48:52'),(8,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 14:50:05','2015-02-25 14:50:05'),(9,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 14:55:13','2015-02-25 14:55:13'),(10,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 15:26:21','2015-02-25 15:26:21'),(11,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 15:28:08','2015-02-25 15:28:08'),(12,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 15:28:41','2015-02-25 15:28:41'),(13,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 15:28:51','2015-02-25 15:28:51'),(14,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 15:28:54','2015-02-25 15:28:54'),(15,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-25 15:29:46','2015-02-25 15:29:46'),(16,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-26 08:57:14','2015-02-26 08:57:14'),(17,1,0.00,0,'1.1.1.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-26 08:58:11','2015-02-26 08:58:11'),(18,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-27 15:11:34','2015-02-27 15:11:34'),(19,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-27 15:29:04','2015-02-27 15:29:04'),(20,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-27 15:46:35','2015-02-27 15:46:35'),(21,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-27 15:47:42','2015-02-27 15:47:42'),(22,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-02-27 15:49:22','2015-02-27 15:49:22'),(23,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 10:45:04','2015-03-01 10:45:04'),(24,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:00:07','2015-03-01 11:00:07'),(25,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:00:41','2015-03-01 11:00:41'),(26,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:01:52','2015-03-01 11:01:52'),(27,1,0.00,8,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:03:37','2015-03-08 17:17:17'),(28,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:09:13','2015-03-01 11:09:13'),(29,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:17:05','2015-03-01 11:17:05'),(30,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:17:30','2015-03-01 11:17:30'),(31,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:18:46','2015-03-01 11:18:46'),(32,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:18:50','2015-03-01 11:18:50'),(33,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:19:19','2015-03-01 11:19:19'),(34,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 11:23:43','2015-03-01 11:23:43'),(35,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 15:22:52','2015-03-01 15:22:52'),(36,1,0.00,21,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-01 16:59:48','2015-03-01 19:14:07'),(37,1,0.00,0,NULL,NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-05 18:22:06','2015-03-05 18:22:06'),(38,1,0.00,0,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-05 18:27:20','2015-03-05 18:27:20'),(39,1,0.00,0,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-05 18:28:51','2015-03-05 18:28:51'),(40,1,0.00,0,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-05 18:30:01','2015-03-05 18:30:01'),(41,1,0.00,13,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-05 18:30:09','2015-03-05 18:48:36'),(42,1,0.00,0,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-07 16:28:10','2015-03-07 16:28:10'),(43,1,0.00,0,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-08 12:59:02','2015-03-08 12:59:02'),(44,1,0.00,0,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-08 12:59:38','2015-03-08 12:59:38'),(45,1,0.00,0,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-08 13:00:01','2015-03-08 13:00:01'),(46,1,0.00,101,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-08 13:00:46','2015-03-08 14:49:31'),(47,1,0.00,0,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-08 14:28:33','2015-03-08 14:28:33'),(48,1,0.00,6,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-08 16:34:54','2015-03-08 19:20:53'),(49,1,0.00,3,'127.0.0.1',NULL,0,0.00,0.00,0.00,1,NULL,17.50,0,NULL,NULL,NULL,'2015-03-09 17:19:14','2015-03-09 18:17:36');
  /*!40000 ALTER TABLE `orders` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `password_resets`
  --
  
  DROP TABLE IF EXISTS `password_resets`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    KEY `password_resets_email_index` (`email`),
    KEY `password_resets_token_index` (`token`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `password_resets`
  --
  
  LOCK TABLES `password_resets` WRITE;
  /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
  /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `sites`
  --
  
  DROP TABLE IF EXISTS `sites`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `sites` (
    `id` int(10) unsigned NOT NULL DEFAULT '0',
    `name` varchar(100) DEFAULT NULL,
    `url` varchar(255) DEFAULT NULL,
    `code` varchar(7) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `sites`
  --
  
  LOCK TABLES `sites` WRITE;
  /*!40000 ALTER TABLE `sites` DISABLE KEYS */;
  INSERT INTO `sites` VALUES (1,'Test',NULL,'TST');
  /*!40000 ALTER TABLE `sites` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `users` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `users`
  --
  
  LOCK TABLES `users` WRITE;
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2015-03-15 14:46:59
  