Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.6.5.2
- -- https://www.phpmyadmin.net/
- --
- -- Host: localhost:3306
- -- Generation Time: Mar 06, 2017 at 08:21 PM
- -- Server version: 5.6.35
- -- PHP Version: 7.0.15
- 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-1488820254480.png', 0, '2017-02-10 14:52:37'),
- (2, 'hcl', 'INSTAGRAM BRAND RESOURCES', 'demoImage-1488819974170.png', 0, '2017-02-10 14:53:22'),
- (4, '27i', 'FACEBOOK BRAND RESOURCES', 'demoImage-1488819624899.png', 0, '2017-02-10 14:55:16'),
- (7, '53ndfr', 'WE3', 'demoImage-1488819689146.png', 0, '2017-02-13 18:35:04'),
- (10, '68p9y9', 'DREAM', 'demoImage-1488820286387.png', 0, '2017-02-13 21:37:27'),
- (11, 'm4as2y', 'ETRADE WALL', 'demoImage-1488820236560.png', 0, '2017-02-13 21:39:36'),
- (12, 'f24q84', 'Test Demo', 'demoImage-1488820327857.png', 0, '2017-03-06 17:12:07'),
- (13, 'to1smo', 'asdasdad', 'demoImage-1488820351440.png', 0, '2017-03-06 17:12:31'),
- (14, 'grvymk', 'asdsadadadsad1', 'demoImage-1488820368238.png', 0, '2017-03-06 17:12:48'),
- (15, 'hg37vh', 'asdada121', 'demoImage-1488820410015.png', 0, '2017-03-06 17:13:30'),
- (16, 'hl4cks', 'ad2qwedsacx', 'demoImage-1488820427628.png', 0, '2017-03-06 17:13:47');
- -- --------------------------------------------------------
- --
- -- 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/'),
- ('f24q84', 'asdasda', 'http://192.168.0.73:9966/cms/demos'),
- ('grvymk', 'asdadadsada', 'http://192.168.0.73:9966/cms/demos'),
- ('hcl', 'The instagram brand resources site will allow download logos and badges.', 'http://en.dev-igbrc.jam3.net/'),
- ('hg37vh', 'asdasdada', 'http://192.168.0.73:9966/cms/demos'),
- ('hl4cks', 'asq3wesdvc', 'http://192.168.0.73:9966/cms/demos'),
- ('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'),
- ('to1smo', 'asdadasd', 'http://192.168.0.73:9966/cms/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=17;
- --
- -- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement