-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 10, 2016 at 11:30 AM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 7.0.8

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: `prankpack_db`
--

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

--
-- Table structure for table `sound`
--

CREATE TABLE `sound` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `url` varchar(100) DEFAULT NULL,
  `length` int(11) DEFAULT NULL,
  `category` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sound`
--

INSERT INTO `sound` (`id`, `name`, `url`, `length`, `category`) VALUES
(1, '1 Flirt', 'web/sounds/medicated_soundboards/FLIRT/1%20Flirt', NULL, 1),
(2, '2 Flirt', 'web/sounds/medicated_soundboards/FLIRT/2%20Flirt', NULL, 1),
(3, '3 Flirt', 'web/sounds/medicated_soundboards/FLIRT/3%20Flirt', NULL, 1),
(4, '4 Flirt', 'web/sounds/medicated_soundboards/FLIRT/4%20Flirt', NULL, 1),
(5, '5 Flirt', 'web/sounds/medicated_soundboards/FLIRT/5%20Flirt', NULL, 1),
(6, '6 Flirt', 'web/sounds/medicated_soundboards/FLIRT/6%20Flirt', NULL, 1),
(7, '7 Flirt', 'web/sounds/medicated_soundboards/FLIRT/7%20Flirt', NULL, 1),
(8, '8 Flirt', 'web/sounds/medicated_soundboards/FLIRT/8%20Flirt', NULL, 1),
(9, '9 Flirt', 'web/sounds/medicated_soundboards/FLIRT/9%20Flirt', NULL, 1),
(10, '10 Flirt', 'web/sounds/medicated_soundboards/FLIRT/10%20Flirt', NULL, 1),
(11, '11 Flirt', 'web/sounds/medicated_soundboards/FLIRT/11%20Flirt', NULL, 1),
(12, '12 Flirt', 'web/sounds/medicated_soundboards/FLIRT/12%20Flirt', NULL, 1),
(13, '13 Flirt', 'web/sounds/medicated_soundboards/FLIRT/13%20Flirt', NULL, 1),
(14, '14 Flirt', 'web/sounds/medicated_soundboards/FLIRT/14%20Flirt', NULL, 1),
(15, '15 Flirt', 'web/sounds/medicated_soundboards/FLIRT/15%20Flirt', NULL, 1),
(16, '16 Flirt', 'web/sounds/medicated_soundboards/FLIRT/16%20Flirt', NULL, 1),
(17, '17 Flirt', 'web/sounds/medicated_soundboards/FLIRT/17%20Flirt', NULL, 1),
(18, '18 Flirt', 'web/sounds/medicated_soundboards/FLIRT/18%20Flirt', NULL, 1),
(19, '19 Flirt', 'web/sounds/medicated_soundboards/FLIRT/19%20Flirt', NULL, 1),
(20, '20 Flirt', 'web/sounds/medicated_soundboards/FLIRT/20%20Flirt', NULL, 1),
(21, '21 Flirt', 'web/sounds/medicated_soundboards/FLIRT/21%20Flirt', NULL, 1),
(22, '22 Flirt', 'web/sounds/medicated_soundboards/FLIRT/22%20Flirt', NULL, 1),
(23, '23 Flirt', 'web/sounds/medicated_soundboards/FLIRT/23%20Flirt', NULL, 1),
(24, '24 Flirt', 'web/sounds/medicated_soundboards/FLIRT/24%20Flirt', NULL, 1),
(25, '25 Flirt', 'web/sounds/medicated_soundboards/FLIRT/25%20Flirt', NULL, 1),
(26, '26 Flirt', 'web/sounds/medicated_soundboards/FLIRT/26%20Flirt', NULL, 1),
(27, '27 Flirt', 'web/sounds/medicated_soundboards/FLIRT/27%20Flirt', NULL, 1),
(28, '28 Flirt', 'web/sounds/medicated_soundboards/FLIRT/28%20Flirt', NULL, 1),
(29, '29 Flirt', 'web/sounds/medicated_soundboards/FLIRT/29%20Flirt', NULL, 1),
(30, '30 Flirt', 'web/sounds/medicated_soundboards/FLIRT/30%20Flirt', NULL, 1),
(31, '31 Flirt', 'web/sounds/medicated_soundboards/FLIRT/31%20Flirt', NULL, 1),
(32, '32 Flirt', 'web/sounds/medicated_soundboards/FLIRT/32%20Flirt', NULL, 1),
(33, '33 Flirt', 'web/sounds/medicated_soundboards/FLIRT/33%20Flirt', NULL, 1),
(34, '34 Flirt', 'web/sounds/medicated_soundboards/FLIRT/34%20Flirt', NULL, 1),
(35, '35 Flirt', 'web/sounds/medicated_soundboards/FLIRT/35%20Flirt', NULL, 1),
(36, '36 Flirt', 'web/sounds/medicated_soundboards/FLIRT/36%20Flirt', NULL, 1),
(37, '37 Flirt', 'web/sounds/medicated_soundboards/FLIRT/37%20Flirt', NULL, 1),
(38, '38 Flirt', 'web/sounds/medicated_soundboards/FLIRT/38%20Flirt', NULL, 1),
(39, '39 Flirt', 'web/sounds/medicated_soundboards/FLIRT/39%20Flirt', NULL, 1),
(40, '40 Flirt', 'web/sounds/medicated_soundboards/FLIRT/40%20Flirt', NULL, 1),
(41, '41 Flirt', 'web/sounds/medicated_soundboards/FLIRT/41%20Flirt', NULL, 1),
(42, '42 Flirt', 'web/sounds/medicated_soundboards/FLIRT/42%20Flirt', NULL, 1),
(43, '43 Flirt', 'web/sounds/medicated_soundboards/FLIRT/43%20Flirt', NULL, 1),
(44, '44 Flirt', 'web/sounds/medicated_soundboards/FLIRT/44%20Flirt', NULL, 1),
(45, '45 Flirt', 'web/sounds/medicated_soundboards/FLIRT/45%20Flirt', NULL, 1),
(46, '46 Flirt', 'web/sounds/medicated_soundboards/FLIRT/46%20Flirt', NULL, 1),
(47, '1 Job', 'web/sounds/medicated_soundboards/JOB/1%20Job', NULL, 2),
(48, '2 Job', 'web/sounds/medicated_soundboards/JOB/2%20Job', NULL, 2),
(49, '3 Job', 'web/sounds/medicated_soundboards/JOB/3%20Job', NULL, 2),
(50, '4 Job', 'web/sounds/medicated_soundboards/JOB/4%20Job', NULL, 2),
(51, '5 Job', 'web/sounds/medicated_soundboards/JOB/5%20Job', NULL, 2),
(52, '6 Job', 'web/sounds/medicated_soundboards/JOB/6%20Job', NULL, 2),
(53, '7 Job', 'web/sounds/medicated_soundboards/JOB/7%20Job', NULL, 2),
(54, '8 Job', 'web/sounds/medicated_soundboards/JOB/8%20Job', NULL, 2),
(55, '9 Job', 'web/sounds/medicated_soundboards/JOB/9%20Job', NULL, 2),
(56, '10 Job', 'web/sounds/medicated_soundboards/JOB/10%20Job', NULL, 2),
(57, '11 Job', 'web/sounds/medicated_soundboards/JOB/11%20Job', NULL, 2),
(58, '12 Job', 'web/sounds/medicated_soundboards/JOB/12%20Job', NULL, 2),
(59, '13 Job', 'web/sounds/medicated_soundboards/JOB/13%20Job', NULL, 2),
(60, '14 Job', 'web/sounds/medicated_soundboards/JOB/14%20Job', NULL, 2),
(61, '15 Job', 'web/sounds/medicated_soundboards/JOB/15%20Job', NULL, 2),
(62, '16 Job', 'web/sounds/medicated_soundboards/JOB/16%20Job', NULL, 2),
(63, '17 Job', 'web/sounds/medicated_soundboards/JOB/17%20Job', NULL, 2),
(64, '18 Job', 'web/sounds/medicated_soundboards/JOB/18%20Job', NULL, 2),
(65, '19 Job', 'web/sounds/medicated_soundboards/JOB/19%20Job', NULL, 2),
(66, '20 Job', 'web/sounds/medicated_soundboards/JOB/20%20Job', NULL, 2),
(67, '21 Job', 'web/sounds/medicated_soundboards/JOB/21%20Job', NULL, 2),
(68, '22 Job', 'web/sounds/medicated_soundboards/JOB/22%20Job', NULL, 2),
(69, '23 Job', 'web/sounds/medicated_soundboards/JOB/23%20Job', NULL, 2),
(70, '24 Job', 'web/sounds/medicated_soundboards/JOB/24%20Job', NULL, 2),
(71, '25 Job', 'web/sounds/medicated_soundboards/JOB/25%20Job', NULL, 2),
(72, '26 Job', 'web/sounds/medicated_soundboards/JOB/26%20Job', NULL, 2),
(73, '27 Job', 'web/sounds/medicated_soundboards/JOB/27%20Job', NULL, 2),
(74, '28 Job', 'web/sounds/medicated_soundboards/JOB/28%20Job', NULL, 2),
(75, '29 Job', 'web/sounds/medicated_soundboards/JOB/29%20Job', NULL, 2),
(76, '30 Job', 'web/sounds/medicated_soundboards/JOB/30%20Job', NULL, 2),
(77, '31 Job', 'web/sounds/medicated_soundboards/JOB/31%20Job', NULL, 2),
(78, '32 Job', 'web/sounds/medicated_soundboards/JOB/32%20Job', NULL, 2),
(79, '33 Job', 'web/sounds/medicated_soundboards/JOB/33%20Job', NULL, 2),
(80, '1 Order', 'web/sounds/medicated_soundboards/ORDER/1%20Order', NULL, 0),
(81, '2 Order', 'web/sounds/medicated_soundboards/ORDER/2%20Order', NULL, 0),
(82, '3 Order', 'web/sounds/medicated_soundboards/ORDER/3%20Order', NULL, 0),
(83, '4 Order', 'web/sounds/medicated_soundboards/ORDER/4%20Order', NULL, 0),
(84, '5 Order', 'web/sounds/medicated_soundboards/ORDER/5%20Order', NULL, 0),
(85, '6 Order', 'web/sounds/medicated_soundboards/ORDER/6%20Order', NULL, 0),
(86, '7 Order', 'web/sounds/medicated_soundboards/ORDER/7%20Order', NULL, 0),
(87, '8 Order', 'web/sounds/medicated_soundboards/ORDER/8%20Order', NULL, 0),
(88, '9 Order', 'web/sounds/medicated_soundboards/ORDER/9%20Order', NULL, 0),
(89, '10 Order', 'web/sounds/medicated_soundboards/ORDER/10%20Order', NULL, 0),
(90, '11 Order', 'web/sounds/medicated_soundboards/ORDER/11%20Order', NULL, 0),
(91, '12 Order', 'web/sounds/medicated_soundboards/ORDER/12%20Order', NULL, 0),
(92, '13 Order', 'web/sounds/medicated_soundboards/ORDER/13%20Order', NULL, 0),
(93, '14 Order', 'web/sounds/medicated_soundboards/ORDER/14%20Order', NULL, 0),
(94, '15 Order', 'web/sounds/medicated_soundboards/ORDER/15%20Order', NULL, 0),
(95, '16 Order', 'web/sounds/medicated_soundboards/ORDER/16%20Order', NULL, 0),
(96, '17 Order', 'web/sounds/medicated_soundboards/ORDER/17%20Order', NULL, 0),
(97, '18 Order', 'web/sounds/medicated_soundboards/ORDER/18%20Order', NULL, 0),
(98, '19 Order', 'web/sounds/medicated_soundboards/ORDER/19%20Order', NULL, 0),
(99, '20 Order', 'web/sounds/medicated_soundboards/ORDER/20%20Order', NULL, 0),
(100, '21 Order', 'web/sounds/medicated_soundboards/ORDER/21%20Order', NULL, 0),
(101, '22 Order', 'web/sounds/medicated_soundboards/ORDER/22%20Order', NULL, 0),
(102, '23 Order', 'web/sounds/medicated_soundboards/ORDER/23%20Order', NULL, 0),
(103, '24 Order', 'web/sounds/medicated_soundboards/ORDER/24%20Order', NULL, 0),
(104, '25 Order', 'web/sounds/medicated_soundboards/ORDER/25%20Order', NULL, 0),
(105, '26 Order', 'web/sounds/medicated_soundboards/ORDER/26%20Order', NULL, 0),
(106, '27 Order', 'web/sounds/medicated_soundboards/ORDER/27%20Order', NULL, 0),
(107, '28 Order', 'web/sounds/medicated_soundboards/ORDER/28%20Order', NULL, 0),
(108, '29 Order', 'web/sounds/medicated_soundboards/ORDER/29%20Order', NULL, 0),
(109, '30 Order', 'web/sounds/medicated_soundboards/ORDER/30%20Order', NULL, 0),
(110, '31 Order', 'web/sounds/medicated_soundboards/ORDER/31%20Order', NULL, 0),
(111, '32 Order', 'web/sounds/medicated_soundboards/ORDER/32%20Order', NULL, 0),
(112, '33 Order', 'web/sounds/medicated_soundboards/ORDER/33%20Order', NULL, 0),
(113, '34 Order', 'web/sounds/medicated_soundboards/ORDER/34%20Order', NULL, 0),
(114, '35 Order', 'web/sounds/medicated_soundboards/ORDER/35%20Order', NULL, 0),
(115, '36 Order', 'web/sounds/medicated_soundboards/ORDER/36%20Order', NULL, 0),
(116, '37 Order', 'web/sounds/medicated_soundboards/ORDER/37%20Order', NULL, 0),
(117, '38 Order', 'web/sounds/medicated_soundboards/ORDER/38%20Order', NULL, 0),
(118, '39 Order', 'web/sounds/medicated_soundboards/ORDER/39%20Order', NULL, 0),
(119, '40 Order', 'web/sounds/medicated_soundboards/ORDER/40%20Order', NULL, 0),
(120, '41 Order', 'web/sounds/medicated_soundboards/ORDER/41%20Order', NULL, 0),
(121, '42 Order', 'web/sounds/medicated_soundboards/ORDER/42%20Order', NULL, 0),
(122, '43 Order', 'web/sounds/medicated_soundboards/ORDER/43%20Order', NULL, 0);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `sound`
--
ALTER TABLE `sound`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123;
/*!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 */;
