· 8 years ago · Jun 22, 2018, 03:36 AM
1-- phpMyAdmin SQL Dump
2-- version 4.7.9
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Jun 22, 2018 at 03:31 AM
7-- Server version: 5.7.21
8-- PHP Version: 7.2.6
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `legacy_gamedata`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `radio`
29--
30
31DROP TABLE IF EXISTS `radio`;
32CREATE TABLE IF NOT EXISTS `radio` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `hosts` varchar(30) NOT NULL,
35 `guests` varchar(100) NOT NULL,
36 `title` varchar(50) NOT NULL,
37 `link` varchar(100) NOT NULL,
38 `likes` text NOT NULL,
39 `uploaded` date NOT NULL,
40 PRIMARY KEY (`id`)
41) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
42
43--
44-- Dumping data for table `radio`
45--
46
47INSERT INTO `radio` (`id`, `hosts`, `guests`, `title`, `link`, `likes`, `uploaded`) VALUES
48(1, 'MattG2, Zach', '', 'Legacy Podcast 1', 'https://soundcloud.com/mattygoku/official-legacy-podcast-episode-1', 'zorg', '2018-06-14'),
49(2, 'MattG2, Zach', 'Aldo', 'Legacy Podcast 2', 'https://soundcloud.com/mattygoku/legacy-podcast-episode-2', 'zorgdev,zorg', '2018-06-21');
50COMMIT;
51
52/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
53/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
54/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;