CREATE DATABASE  IF NOT EXISTS `destramic` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `destramic`;
-- MySQL dump 10.13  Distrib 5.7.9, for Win64 (x86_64)
--
-- Host: localhost    Database: destramic
-- ------------------------------------------------------
-- Server version   5.7.10-log

/*!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 `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
  `category_id` INT(11) NOT NULL AUTO_INCREMENT,
  `name_en` VARCHAR(90) NOT NULL,
  `order_number` INT(11) DEFAULT NULL,
  `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`category_id`),
  UNIQUE KEY `categories_category_id_UNIQUE` (`category_id`,`order_number`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf16;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,'Antiques',1,'2015-01-26 00:00:50');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category_specifics`
--

DROP TABLE IF EXISTS `category_specifics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category_specifics` (
  `category_specific_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `category_id` INT(11) DEFAULT NULL,
  `specific_id` INT(11) DEFAULT NULL,
  `created` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`category_specific_id`),
  UNIQUE KEY `category_specific_id_UNIQUE` (`category_specific_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category_specifics`
--

LOCK TABLES `category_specifics` WRITE;
/*!40000 ALTER TABLE `category_specifics` DISABLE KEYS */;
INSERT INTO `category_specifics` VALUES (2,1,15,'2015-12-28 18:23:52');
/*!40000 ALTER TABLE `category_specifics` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `item_specific_values`
--

DROP TABLE IF EXISTS `item_specific_values`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_specific_values` (
  `item_specific_value_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `item_id` VARCHAR(45) DEFAULT NULL,
  `specific_value_id` VARCHAR(45) DEFAULT NULL,
  PRIMARY KEY (`item_specific_value_id`),
  UNIQUE KEY `item_specific_value_id_UNIQUE` (`item_specific_value_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `item_specific_values`
--

LOCK TABLES `item_specific_values` WRITE;
/*!40000 ALTER TABLE `item_specific_values` DISABLE KEYS */;
INSERT INTO `item_specific_values` VALUES (1,'29','1'),(2,'30','2'),(3,'31','3'),(4,'32','1'),(5,'33','2'),(6,'29','4'),(7,'30','5'),(8,'31','4'),(9,'32','5'),(10,'33','4');
/*!40000 ALTER TABLE `item_specific_values` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `items`
--

DROP TABLE IF EXISTS `items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `items` (
  `item_id` INT(11) NOT NULL AUTO_INCREMENT,
  `user_id` INT(11) NOT NULL,
  `category_id` INT(11) NOT NULL,
  `sub_category_id` INT(11) NOT NULL,
  `sub_sub_category_id` INT(11) DEFAULT NULL,
  `sub_sub_sub_category_id` INT(11) DEFAULT NULL,
  `user_address_id` INT(11) DEFAULT NULL,
  `condition_id` INT(11) DEFAULT NULL,
  `title` VARCHAR(90) NOT NULL,
  `description` text NOT NULL,
  `auction` INT(11) NOT NULL,
  `buy_now` tinyint(1) NOT NULL DEFAULT '0',
  `starting_price` DECIMAL(15,2) NOT NULL,
  `listing_duration` enum('1','3','7','10','30') NOT NULL,
  `buy_now_price` DECIMAL(15,2) NOT NULL,
  `quantity` INT(11) NOT NULL DEFAULT '1',
  `offers_accepted` tinyint(1) NOT NULL DEFAULT '0',
  `start_timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `dispatch_time` enum('Same Day','1 Working Day','2 Working Days','3 Working Days') NOT NULL,
  `returns` INT(1) NOT NULL DEFAULT '0',
  `return_policy` text,
  `free_delivery` INT(1) DEFAULT '0',
  `free_delivery_condition` enum('Town/City','County','Country','Continent','MENA Region','Worldwide') DEFAULT NULL,
  `collection` INT(1) DEFAULT '0',
  `collection_only` INT(1) DEFAULT '0',
  `created` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `personal_delivery` INT(1) DEFAULT '0',
  `personal_delivery_distance` INT(10) DEFAULT '0',
  `personal_delivery_price` DECIMAL(12,2) DEFAULT '0.00',
  `draft` INT(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`),
  UNIQUE KEY `items_item_id_UNIQUE` (`item_id`),
  KEY `items_user_id_INDEX` (`user_id`),
  KEY `items_category_id_INDEX` (`category_id`),
  KEY `items_sub_category_id_INDEX` (`sub_category_id`),
  KEY `items_user_address_id_INDEX` (`user_address_id`),
  KEY `items_condition_id_INDEX` (`condition_id`),
  FULLTEXT KEY `items_FULLTEXT` (`description`,`title`)
) ENGINE=InnoDB AUTO_INCREMENT=1243 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `items`
--

LOCK TABLES `items` WRITE;
/*!40000 ALTER TABLE `items` DISABLE KEYS */;
INSERT INTO `items` VALUES (29,1,1,4,67,10,1,NULL,'Clock 1','',0,0,0.00,'1',0.00,1,0,'2015-11-15 20:57:50','Same Day',0,NULL,0,NULL,0,0,'2015-11-15 20:57:50',0,0,0.01,1),(30,1,1,4,67,10,2,NULL,'Clock 2','',0,0,0.00,'1',0.00,1,0,'2015-11-15 20:59:13','Same Day',0,NULL,0,NULL,0,0,'2015-11-15 20:59:13',0,0,0.01,1),(31,1,1,4,61,1,1,NULL,'clock 3','',0,0,0.00,'1',0.00,1,0,'2015-11-15 21:10:09','Same Day',0,NULL,0,NULL,0,0,'2015-11-15 21:10:09',0,0,0.01,1),(32,1,1,4,61,2,1,NULL,'clock 4','',0,0,0.00,'1',0.00,1,0,'2015-11-15 21:10:28','Same Day',0,NULL,0,NULL,0,0,'2015-11-15 21:10:28',0,0,0.01,1),(33,1,1,4,63,4,1,NULL,'clock 5','',0,0,0.00,'1',0.00,1,0,'2015-11-15 21:11:03','Same Day',0,NULL,0,NULL,0,0,'2015-11-15 21:11:03',0,0,0.01,1);
/*!40000 ALTER TABLE `items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `specific_values`
--

DROP TABLE IF EXISTS `specific_values`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `specific_values` (
  `specific_value_id` INT(11) NOT NULL AUTO_INCREMENT,
  `specific_id` INT(11) DEFAULT NULL,
  `value` VARCHAR(90) DEFAULT NULL,
  PRIMARY KEY (`specific_value_id`),
  UNIQUE KEY `specific_value_id_UNIQUE` (`specific_value_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `specific_values`
--

LOCK TABLES `specific_values` WRITE;
/*!40000 ALTER TABLE `specific_values` DISABLE KEYS */;
INSERT INTO `specific_values` VALUES (1,15,'Alarm Clock'),(2,15,'Wall Clock'),(3,15,'Cuckoo Clock '),(4,19,'New'),(5,19,'Used');
/*!40000 ALTER TABLE `specific_values` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `specifics`
--

DROP TABLE IF EXISTS `specifics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `specifics` (
  `specific_id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(40) NOT NULL,
  `description` VARCHAR(90) DEFAULT NULL,
  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`specific_id`),
  UNIQUE KEY `specifics_specific_id_UNIQUE` (`specific_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf16;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `specifics`
--

LOCK TABLES `specifics` WRITE;
/*!40000 ALTER TABLE `specifics` DISABLE KEYS */;
INSERT INTO `specifics` VALUES (15,'Clock Type','Clocks','2015-09-21 19:27:14'),(19,'Condition','Clocks','2015-09-21 19:38:32');
/*!40000 ALTER TABLE `specifics` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sub_categories`
--

DROP TABLE IF EXISTS `sub_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sub_categories` (
  `sub_category_id` INT(11) NOT NULL AUTO_INCREMENT,
  `category_id` INT(11) NOT NULL,
  `name_en` VARCHAR(90) CHARACTER SET utf8mb4 NOT NULL,
  `order_number` INT(11) DEFAULT NULL,
  `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`sub_category_id`),
  UNIQUE KEY `sub_categories_sub_category_id_UNIQUE` (`sub_category_id`),
  KEY `sub_categories_category_id_INDEX` (`category_id`),
  CONSTRAINT `sub_categories_category_id_FOREIGN_KEY` FOREIGN KEY (`category_id`) REFERENCES `categories` (`category_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=581 DEFAULT CHARSET=utf16;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sub_categories`
--

LOCK TABLES `sub_categories` WRITE;
/*!40000 ALTER TABLE `sub_categories` DISABLE KEYS */;
INSERT INTO `sub_categories` VALUES (4,1,'Anitque Clocks',NULL,'2015-09-09 17:11:49');
/*!40000 ALTER TABLE `sub_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sub_category_specifics`
--

DROP TABLE IF EXISTS `sub_category_specifics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sub_category_specifics` (
  `sub_category_specific_id` INT(11) NOT NULL AUTO_INCREMENT,
  `sub_category_id` INT(11) DEFAULT NULL,
  `specific_id` INT(11) DEFAULT NULL,
  `created` TIMESTAMP NULL DEFAULT NULL,
  PRIMARY KEY (`sub_category_specific_id`),
  UNIQUE KEY `sub_category_specific_id_UNIQUE` (`sub_category_specific_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sub_category_specifics`
--

LOCK TABLES `sub_category_specifics` WRITE;
/*!40000 ALTER TABLE `sub_category_specifics` DISABLE KEYS */;
INSERT INTO `sub_category_specifics` VALUES (1,4,19,NULL);
/*!40000 ALTER TABLE `sub_category_specifics` 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-12-29  3:52:47