-- phpMyAdmin SQL Dump
-- version 4.6.5.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 14, 2017 at 06:04 PM
-- Server version: 5.6.34
-- PHP Version: 7.1.0

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

--
-- Database: `demos`
--

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(10) NOT NULL,
  `name` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `categories` (`id`, `name`) VALUES
(0, 'All'),
(79, 'NodeJS'),
(80, 'ReactJS'),
(81, 'PHP'),
(85, 'Wordpress'),
(86, 'Joomla');

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

--
-- Table structure for table `demos`
--

CREATE TABLE `demos` (
  `order_key` int(20) NOT NULL,
  `id` varchar(10) NOT NULL,
  `name` varchar(60) NOT NULL,
  `img` varchar(90) NOT NULL,
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `demos`
--

INSERT INTO `demos` (`order_key`, `id`, `name`, `img`, `cat_id`, `created_at`) VALUES
(1, 'jqo', 'I SPY DOC', 'demoImage-1487015885194.png', 80, '2017-02-10 14:52:37'),
(2, 'hcl', 'INSTAGRAM BRAND RESOURCES', 'demoImage-1486738402434.png', 85, '2017-02-10 14:53:22'),
(4, '27i', 'FACEBOOK BRAND RESOURCES', 'demoImage-1486738516623.png', 85, '2017-02-10 14:55:16'),
(7, '53ndfr', 'WE3', 'demoImage-1487010904009.png', 80, '2017-02-13 18:35:04'),
(10, '68p9y9', 'DREAM', 'demoImage-1487021903890.png', 0, '2017-02-13 21:37:27'),
(11, 'm4as2y', 'ETRADE WALL', 'demoImage-1487021976247.png', 80, '2017-02-13 21:39:36');

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

--
-- Table structure for table `details`
--

CREATE TABLE `details` (
  `demo_id` varchar(10) NOT NULL,
  `description` varchar(120) NOT NULL,
  `url` varchar(120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `details`
--

INSERT INTO `details` (`demo_id`, `description`, `url`) VALUES
('27i', 'The facebook brand resources is a site where you can download logos.', 'https://en.facebookbrand.com/'),
('53ndfr', 'WE3 is a JAM3 internship program for discover the developers and designers work.', 'http://we3.jam3.net'),
('5quax9', 'tac', 'http://192.168.0.65:9966/demosk'),
('68p9y9', 'A real estate website for Homes by Dream.', 'http://dream.jam3.net/'),
('hcl', 'The instagram brand resources site will allow download logos and badges.', 'http://en.dev-igbrc.jam3.net/'),
('jqo', 'I spy is a documental of spying and cyberwarfare.', 'https://ispydoc.com/'),
('jw8080', 'as', 'http://192.168.0.65:9966/demos'),
('kydc25', 'A real estate website for Homes by Dream.', 'http://dream.jam3.net/'),
('m4as2y', 'ETrade visualization wall.', 'http://34.194.99.225/'),
('nnq2ou', 'undefined', 'http://we3.jam3.net'),
('tf0q1x', 'sdasdasda', 'http://192.168.0.65:9966/demos'),
('ujancv', 'asdada', 'http://192.168.0.65:9966/demos'),
('vfbzrn', 'sada', 'http://192.168.0.65:9966/demos'),
('ysm4n2', 'A real estate website for Homes by Dream', 'http://dream.jam3.net/');

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

--
-- Table structure for table `tokens`
--

CREATE TABLE `tokens` (
  `id` int(20) NOT NULL,
  `token` varchar(90) NOT NULL,
  `owner` varchar(90) NOT NULL DEFAULT 'Undefined',
  `status` varchar(20) NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tokens`
--

INSERT INTO `tokens` (`id`, `token`, `owner`, `status`, `date`) VALUES
(1, 'QImWzODr8YmnsTCZpNOkWB2X0', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 21:27:41'),
(2, 'RUyX7qM5iCsenUF95k0mq45qZ', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 21:39:37'),
(3, 'LfKvZCFrQQsJROqto2OWwyiXA', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 21:40:38'),
(4, 'me2e3oQDRb2vGkDRETkWUCYGg', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 21:41:34'),
(5, 'QLiIzIJfeopBfXjWurkMBmHET', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 21:42:13'),
(6, 'xJsVmDyROHjaHw41TDuvlzUXy', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 23:13:47'),
(7, 'TMxGW5LBth0241nQfIRdh5SW8', 'nico.dantuoni@hotmail.com', 'Done', '2017-01-31 23:14:15'),
(8, '8sQi7DEaOJXZTQXAoxwp2EooK', 'nico.dantuoni@hotmail.com', 'Done', '2017-01-31 23:16:03'),
(9, 'BoKBSPcw5RxZnC2Penu0WmaCZ', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 23:17:28'),
(10, 'wM5RhGMhHqOrN7HnPcSMCfpCl', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 23:19:33'),
(11, 'YpRh8tP0Jum550xWQtKIeAWqd', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 23:20:51'),
(12, 'irCC3yuiJIr8xX0hu4xGWryc9', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 23:36:12'),
(13, 'pYBhZRIFkuCopUMvRfLftTaWt', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 23:55:11'),
(14, 'I6wo7UHwevUf69TXmXCxeO3og', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 23:56:56'),
(15, 'NykRIqJqP54ncGLCmL7vLowD9', 'santiagodantuoni@gmail.com', 'Done', '2017-01-31 23:58:13'),
(16, 'lzphyTCrwxA0gqbNPonkqxYvw', 'santiagodantuoni@gmail.com', 'Done', '2017-02-01 00:11:23'),
(17, 'RRAlHv2TN8Y9xcuxiYLfl17yO', 'santiagodantuoni@gmail.com', 'Done', '2017-02-01 00:21:27'),
(18, '0kawKIi1TlF2bZl7eWDdDDv52', 'santiagodantuoni@gmail.com', 'Done', '2017-02-01 00:22:37'),
(20, 'pU7HomG3U7ge7byPN5k8uomWk', 'santiagodantuoni@gmail.com', 'Done', '2017-02-01 00:32:34'),
(30, 'JmTZYdQFq1C06lVXHV9bkzgvA', 'santiagodantuoni@gmail.com', 'Done', '2017-02-01 14:20:18'),
(49, '6hH2fnMt9qR6SYYYrxwO2fb1D', 'nico.dantuoni@hotmail.com', 'Done', '2017-02-06 17:43:16'),
(50, 'Qu11M9PhNTVB7VuLmSZzCDs2i', 'nico.dantuoni@hotmail.com', 'Active', '2017-02-06 17:45:08'),
(51, 'EDknah7uW6hoJIT4aBW1wTdRp', 'santiagodantuoni@gmail.com', 'Active', '2017-02-08 21:17:25');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) NOT NULL,
  `username` varchar(25) NOT NULL,
  `email` varchar(40) NOT NULL,
  `password` varchar(50) NOT NULL,
  `avatar` varchar(60) NOT NULL DEFAULT 'None',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `email`, `password`, `avatar`, `date`) VALUES
(22, 'test', 'test@test.com', '4d186321c1a7f0f354b297e8914ab240', 'None', '2017-01-17 20:53:31'),
(23, 'jam3', 'jam3@jam3.com', '501529bab78438ef977b38a0b77a3281', 'None', '2017-01-24 16:32:54'),
(29, 'nico', 'nico.dantuoni@hotmail.com', 'ae1d4b431ead52e5ee1788010e8ec110', 'None', '2017-02-06 20:40:30'),
(32, 'santiago.dantuoni', 'santiagodantuoni@gmail.com', '1acdd1f5f7bfb6a0a2a90d0ae6ac762b', 'None', '2017-02-13 20:54:41');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `demos`
--
ALTER TABLE `demos`
  ADD PRIMARY KEY (`order_key`),
  ADD UNIQUE KEY `order_key` (`order_key`),
  ADD UNIQUE KEY `order_key_2` (`order_key`);

--
-- Indexes for table `details`
--
ALTER TABLE `details`
  ADD PRIMARY KEY (`demo_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87;
--
-- AUTO_INCREMENT for table `demos`
--
ALTER TABLE `demos`
  MODIFY `order_key` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `tokens`
--
ALTER TABLE `tokens`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;