ReportRTS rts database dump

gistfile1.txt

-- phpMyAdmin SQL Dump
-- version 3.5.8.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 03, 2014 at 06:26 AM
-- Server version: 5.5.38-MariaDB
-- PHP Version: 5.5.15

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 utf8 */;

--
-- Database: `rts`
--

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

--
-- Table structure for table `reportrts_request`
--

CREATE TABLE IF NOT EXISTS `reportrts_request` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT '0',
  `mod_id` int(10) unsigned DEFAULT '0',
  `mod_timestamp` int(10) unsigned DEFAULT NULL,
  `mod_comment` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `tstamp` int(10) unsigned NOT NULL DEFAULT '0',
  `world` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `bc_server` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `x` int(10) NOT NULL DEFAULT '0',
  `y` int(10) NOT NULL DEFAULT '0',
  `z` int(10) NOT NULL DEFAULT '0',
  `yaw` smallint(6) NOT NULL DEFAULT '0',
  `pitch` smallint(6) NOT NULL DEFAULT '0',
  `text` varchar(255) CHARACTER SET utf8 NOT NULL,
  `status` tinyint(1) unsigned DEFAULT '0',
  `notified_of_completion` tinyint(1) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `reportrts_request`
--

INSERT INTO `reportrts_request` (`id`, `user_id`, `mod_id`, `mod_timestamp`, `mod_comment`, `tstamp`, `world`, `bc_server`, `x`, `y`, `z`, `yaw`, `pitch`, `text`, `status`, `notified_of_completion`) VALUES
(1, 1, 2, 1389460238, 'test', 1388249883, 'world', '', 187, 66, 285, -153, 18, 'test test test test', 3, 0),
(2, 1, 2, 1389460743, 'test', 1388254087, 'world', '', 184, 66, 276, -198, 27, 'heheheh eheheh hehehe', 3, 1),
(3, 1, 1, 1388298559, NULL, 1388294074, 'world', '', 63, 106, 495, -255, -40, 'this is a test', 3, 1),
(4, 1, 1, 1388298479, 'done', 1388298435, 'world', '', 63, 106, 495, -138, 9, 'this is a new request', 3, 1),
(5, 1, 2, 1389460771, NULL, 1388299217, 'world', '', 63, 106, 495, -219, 18, 'new request yay', 3, 1),
(6, 1, 1, 1388299688, NULL, 1388299383, 'world', '', 63, 106, 495, -235, 8, '1 1 1', 3, 1),
(7, 1, 1, 1388299690, NULL, 1388299563, 'world', '', 63, 106, 495, -235, 8, '2 2 2 2', 3, 1),
(8, 1, 1, 1389551265, NULL, 1388299699, 'world', '', 63, 106, 495, -270, -49, 'n n n n', 3, 1),
(9, 1, 1, 1389551267, NULL, 1388299930, 'world', '', 63, 106, 495, -263, -36, '1 1 1 1 1', 3, 1),
(10, 1, 1, 1388300072, 'done message', 1388299948, 'world', '', 63, 106, 495, -263, -36, '1 1 1 1 1', 3, 1),
(11, 1, 1, 1388532333, 'This is the mod note.', 1388532303, 'world', '', 134, 106, 443, 30, 34, 'this is a test', 3, 1),
(12, 1, 1, 1388532645, 'Comment.', 1388532635, 'world', '', 134, 106, 443, 17, 21, 'help help help2', 3, 1),
(13, 1, 1, 1388532656, NULL, 1388532652, 'world', '', 134, 106, 443, 17, 21, '1 1 1 1 1 1 1', 3, 1),
(14, 1, 1, 1390833488, NULL, 1390833386, 'world', '', 127, 63, 289, -83, 12, 'test tes tes', 3, 1),
(15, 1, 1, 1390834280, 'done', 1390834273, 'world', '', 127, 63, 289, -86, 26, 'tes test tes', 3, 1),
(16, 1, 1, 1392182393, NULL, 1392182338, 'world', '', 180, 71, 256, 85, 11, 'test test test', 3, 1),
(17, 1, 1, 1392182645, NULL, 1392182640, 'world', '', 180, 71, 258, -98, 28, 'test test test2', 3, 1),
(18, 1, 1, 1392182708, NULL, 1392182667, 'world', '', 180, 71, 258, -98, 29, 'test test test3', 3, 1),
(19, 1, 1, 1392183899, NULL, 1392183893, 'world', '', 180, 71, 258, -120, 12, 'test test test4', 3, 1),
(20, 1, 2, 1406959967, '0 yes', 1406959802, 'world', '', -212, 48, -105, -253, 11, 'test 1 2 3 4', 3, 0),
(21, 2, 0, NULL, NULL, 1406959987, 'world', '', -224, 64, 236, 0, 0, 'dfasd sdfasdf asdfa sfda', 0, 0);

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

--
-- Table structure for table `reportrts_user`
--

CREATE TABLE IF NOT EXISTS `reportrts_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `banned` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `reportrts_user`
--

INSERT INTO `reportrts_user` (`id`, `name`, `uuid`, `banned`) VALUES
(1, 'cnaude', 'aa5f67c4-91a7-4e95-a90e-2ab07120ed98', 0),
(2, 'CONSOLE', 'c8890543-b1c5-4139-95d9-3abd36729baf', 0),
(3, 'CONSOLE', 'eb956d7e-a1d4-4ef2-b100-3f22a7daac33', 0),
(4, 'CONSOLE', '74af38c8-d898-486a-a575-78834b52c7f4', 0);

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