-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 13, 2017 at 04:31 PM
-- Server version: 10.1.9-MariaDB
-- PHP Version: 7.0.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


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

--
-- Database: `imarasoft_amazon_survey`
--

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

--
-- Table structure for table `all_information`
--

CREATE TABLE `all_information` (
  `id` int(8) NOT NULL,
  `amazon_order_id` varchar(250) NOT NULL,
  `email` varchar(100) NOT NULL,
  `rebate` varchar(75) NOT NULL,
  `star` int(2) NOT NULL,
  `charity` varchar(100) NOT NULL,
  `address` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `all_information`
--

INSERT INTO `all_information` (`id`, `amazon_order_id`, `email`, `rebate`, `star`, `charity`, `address`) VALUES
(114, '4', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Gregory W Shirk","address":"9844 Foundry Rd","city":"East Liberty","state":"Ohio","Zip":"43319"}'),
(115, '5', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Yuliya Fedotov","address":"9 Danforth ln","city":"rocky hill","state":"CT","Zip":"06067-3206"}'),
(116, '6', 'test@test.com', 'No', 5, '1', '{"name":"Madiha khanum","address":"17738 GLADE LANDING LN","city":"RICHMOND","state":"TX","Zip":"77407-1795"}'),
(117, '7', 'rest@test.test', 'Yes', 4, '1', '{"name":"MICHELLE STINNETT","address":"2847 Joseph Pkwy","city":"Brunswick","state":"OH","Zip":"44212-1436"}'),
(118, '1', 'inter.aler@gm.con', 'No', 5, '1', '{"name":"Patty Bakken","address":"5143 81st Ave NE PO Box 294","city":"Devils Lake","state":"ND","Zip":"58301"}'),
(119, '1', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Patty Bakken","address":"5143 81st Ave NE PO Box 294","city":"Devils Lake","state":"ND","Zip":"58301"}'),
(120, '1', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Patty Bakken","address":"5143 81st Ave NE PO Box 294","city":"Devils Lake","state":"ND","Zip":"58301"}'),
(121, '1', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Patty Bakken","address":"5143 81st Ave NE PO Box 294","city":"Devils Lake","state":"ND","Zip":"58301"}'),
(122, '1', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Patty Bakken","address":"5143 81st Ave NE PO Box 294","city":"Devils Lake","state":"ND","Zip":"58301"}'),
(123, '2', 'test@test.com', 'No', 5, '1', '{"name":"MICHELLE STINNETT","address":"2847 Joseph Pkwy","city":"Brunswick","state":"OH","Zip":"44212-1436"}'),
(124, '', '', 'Yes', 0, '2', '{"name":"","address":"","city":"","state":"","Zip":""}'),
(125, '3', 'wow@wow.wow', 'No', 4, '1', '{"name":"Wendy carr","address":"1003 SUMMER COURT CIR APTD","city":"COLLEGE STATION","state":"TX","Zip":"77840"}'),
(126, '4', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Gregory W Shirk","address":"9844 Foundry Rd","city":"East Liberty","state":"Ohio","Zip":"43319"}'),
(127, '5', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Yuliya Fedotov","address":"9 Danforth ln","city":"rocky hill","state":"CT","Zip":"06067-3206"}'),
(128, '1', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Gregory W Shirk","address":"9844 Foundry Rd","city":"East Liberty","state":"Ohio","Zip":"43319"}'),
(129, '2', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Gregory W Shirk","address":"9844 Foundry Rd","city":"East Liberty","state":"Ohio","Zip":"43319"}'),
(130, '3', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Gregory W Shirk","address":"9844 Foundry Rd","city":"East Liberty","state":"Ohio","Zip":"43319"}'),
(131, '4', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Yuliya Fedotov","address":"9 Danforth ln","city":"rocky hill","state":"CT","Zip":"06067-3206"}'),
(132, '5', 'hymsalih@gmail.com', 'Yes', 5, '2', '{"name":"Gregory W Shirk","address":"9844 Foundry Rd","city":"East Liberty","state":"Ohio","Zip":"43319"}'),
(133, '6', 'hymsalih@gmail.com', 'Yes', 5, '1', '{"name":"Patty Bakken","address":"5143 81st Ave NE PO Box 294","city":"Devils Lake","state":"ND","Zip":"58301"}'),
(134, '1', 'hymsalih@gmail.com', 'Yes', 5, '1', '{"name":"Gregory W Shirk","address":"9844 Foundry Rd","city":"East Liberty","state":"Ohio","Zip":"43319"}'),
(135, '1', 'hymsalih@gmail.com', 'Yes', 5, '1', '{"name":"Gregory W Shirk","address":"9844 Foundry Rd","city":"East Liberty","state":"Ohio","Zip":"43319"}');

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

--
-- Table structure for table `amazon_key`
--

CREATE TABLE `amazon_key` (
  `id` int(11) NOT NULL,
  `market_place` varchar(8) NOT NULL,
  `aws_access_key_id` varchar(255) NOT NULL,
  `aws_secret_key_id` varchar(255) NOT NULL,
  `merchant_id` varchar(255) NOT NULL,
  `market_place_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `amazon_key`
--

INSERT INTO `amazon_key` (`id`, `market_place`, `aws_access_key_id`, `aws_secret_key_id`, `merchant_id`, `market_place_id`) VALUES
(1, 'com', 'AKIAJY6ANKO52LBF5ZOQ', 'DVeRRaAMI6iYA+JFRAjyqRtdvTAoR5PeXz8cg4zu', 'A986KTU1CD12A', 'ATVPDKIKX0DER');

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

--
-- Table structure for table `answers`
--

CREATE TABLE `answers` (
  `id` int(11) NOT NULL,
  `question_page` int(11) NOT NULL,
  `amazon_order_id` int(11) NOT NULL,
  `answer` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `answers`
--

INSERT INTO `answers` (`id`, `question_page`, `amazon_order_id`, `answer`) VALUES
(1, 1, 1, '{"product_imp":"Yes","star":"5","action":"step_2","stept2_success":""}'),
(2, 2, 1, '{"rebate":"Yes","name":"","address":"","city":"","state":"","Zip":""}'),
(3, 2, 1, '{"product_imp":"Yes","star":"5","action":"step_2","stept2_success":""}'),
(4, 2, 2, '{"rebate":"Yes","name":"","address":"","city":"","state":"","Zip":""}'),
(5, 3, 1, '{"product_imp":"Yes","star":"4.5","action":"step_2","stept2_success":""}'),
(6, 2, 3, '{"rebate":"Yes","name":"","address":"","city":"","state":"","Zip":""}'),
(7, 4, 1, '{"product_imp":"Yes","star":"5","action":"step_2","stept2_success":""}'),
(8, 2, 4, '{"rebate":"Yes","name":"","address":"","city":"","state":"","Zip":""}'),
(9, 5, 1, '{"product_imp":"Yes","star":"5","action":"step_2","stept2_success":""}'),
(10, 2, 5, '{"rebate":"Yes","name":"","address":"","city":"","state":"","Zip":""}'),
(11, 6, 1, '{"product_imp":"Yes","star":"4.5","action":"step_2","stept2_success":""}'),
(12, 2, 6, '{"rebate":"Yes","name":"","address":"","city":"","state":"","Zip":""}'),
(13, 2, 1, '{"rebate":"Yes","name":"","address":"","city":"","state":"","Zip":""}'),
(14, 2, 1, '{"rebate":"Yes","name":"","address":"","city":"","state":"","Zip":""}');

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

--
-- Table structure for table `charity`
--

CREATE TABLE `charity` (
  `id` int(9) NOT NULL,
  `value` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `charity`
--

INSERT INTO `charity` (`id`, `value`) VALUES
(1, 'Test x'),
(2, 'theresa');

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

--
-- Table structure for table `item`
--

CREATE TABLE `item` (
  `id` int(11) NOT NULL,
  `amazon_order_id` varchar(34) NOT NULL,
  `asin` varchar(34) NOT NULL,
  `item_url` varchar(255) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `zip` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `item`
--

INSERT INTO `item` (`id`, `amazon_order_id`, `asin`, `item_url`, `customer_name`, `address`, `city`, `state`, `zip`) VALUES
(1, '1', 'B00IOWOQQA', 'http://ecx.images-amazon.com/images/I/51n7nxBeAmL._SX522_.jpg', 'Gregory W Shirk', '9844 Foundry Rd', 'East Liberty', 'Ohio', '43319');

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

--
-- Table structure for table `order_details`
--

CREATE TABLE `order_details` (
  `id` int(11) NOT NULL,
  `email` varchar(34) NOT NULL,
  `amazon_order_id` varchar(34) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_details`
--

INSERT INTO `order_details` (`id`, `email`, `amazon_order_id`, `status`) VALUES
(1, 'hymsalih@gmail.com', '111-0796385-2395440', 1);

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

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` int(11) NOT NULL,
  `page` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `html` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` (`id`, `page`, `title`, `html`) VALUES
(1, 1, 'Would you like to join our product improvement program and get free products?', ' <div class="radio">\n                                                            <label><input type="radio" id="is_yes" name="product_imp" value="Yes">Yes</label>\n                                                        </div>\n                                                        <div class="radio">\n                                                            <label><input type="radio" id="is_yes" name="product_imp" value="No">No</label>\n                                                        </div>'),
(3, 1, 'How satisfied where you with your purchase?', ' <input required name="star" id="input-21e" value="0" type="text" class="rating" data-min=0 data-max=5 data-step=0.5 data-size="xs" title="">'),
(4, 2, 'Would you like to donate your $5 rebate to a charity? Its tax deductible! ', '<div class="radio">\n                            <label><input type="radio" id="rebate" name="rebate" required value="Yes">Yes</label>\n                        </div>\n                        <div class="radio">\n                            <label><input type="radio" id="rebate" name="rebate" required value="No">No</label>\n                        </div>     '),
(5, 2, 'Where do you want us to send your rebate?', '<div class="row" id="customerDetails">\n    <div class="col-md-12">\n        <br>\n        Name : \n        <br>\n        <input class="form-control" name="name" id="r_name" type="text">\n    </div>  \n    <div class="col-md-12">\n        <br>\n        Address : \n        <br>\n        <textarea class="form-control" id="r_address"  name="address" type="text"></textarea>\n    </div>\n    <div class="col-md-12">\n        <br>\n        City : \n        <br>\n        <input class="form-control" name="city" type="text" id="r_city">\n    </div>\n    <div class="col-md-12">\n        <br>\n        State : \n        <br>\n        <input class="form-control" name="state" type="text" id="r_state">\n    </div>\n	<div class="col-md-12">\n        <br>\n        Zip : \n        <br>\n        <input class="form-control" name="Zip" type="text" id="r_Zip">\n    </div>\n</div>');

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

--
-- Table structure for table `sortlink_asin`
--

CREATE TABLE `sortlink_asin` (
  `id` int(8) NOT NULL,
  `ASIN` varchar(244) NOT NULL,
  `sort_link` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sortlink_asin`
--

INSERT INTO `sortlink_asin` (`id`, `ASIN`, `sort_link`) VALUES
(2, 'B00IOWOQQA', 'https://goo.gl/1UGjou'),
(6, 'B00PAKXX5O', 'https://www.yahoo.com');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(5) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `user_name`, `password`) VALUES
(1, 'admin1', '6c7ca345f63f835cb353ff15bd6c5e052ec08e7a');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `all_information`
--
ALTER TABLE `all_information`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `amazon_key`
--
ALTER TABLE `amazon_key`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `answers`
--
ALTER TABLE `answers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `charity`
--
ALTER TABLE `charity`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `item`
--
ALTER TABLE `item`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_details`
--
ALTER TABLE `order_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `questions`
--
ALTER TABLE `questions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sortlink_asin`
--
ALTER TABLE `sortlink_asin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `all_information`
--
ALTER TABLE `all_information`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=136;
--
-- AUTO_INCREMENT for table `amazon_key`
--
ALTER TABLE `amazon_key`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `answers`
--
ALTER TABLE `answers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `charity`
--
ALTER TABLE `charity`
  MODIFY `id` int(9) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `item`
--
ALTER TABLE `item`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `order_details`
--
ALTER TABLE `order_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `questions`
--
ALTER TABLE `questions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `sortlink_asin`
--
ALTER TABLE `sortlink_asin`
  MODIFY `id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
/*!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 */;
