Xeround Dump
Adam Hani Schakaki edited this page May 3, 2013
·
1 revision
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: instance43701.db.xeround.com.:9049
-- Generation Time: May 03, 2013 at 10:36 AM
-- Server version: 5.5.20
-- PHP Version: 5.4.3
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: `shnergle`
--
-- --------------------------------------------------------
--
-- Table structure for table `countries`
--
CREATE TABLE IF NOT EXISTS `countries` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` (`id`, `code`) VALUES
(5, 'at'),
(4, 'ch'),
(1, 'gb'),
(3, 'de'),
(2, 'us');
-- --------------------------------------------------------
--
-- Table structure for table `languages`
--
CREATE TABLE IF NOT EXISTS `languages` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`country_id` bigint(20) unsigned DEFAULT NULL,
`code` varchar(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `languages`
--
INSERT INTO `languages` (`id`, `country_id`, `code`) VALUES
(5, 5, 'de'),
(4, 4, 'de'),
(1, 1, 'en'),
(2, 2, 'en'),
(3, 3, 'de');
-- --------------------------------------------------------
--
-- Table structure for table `media`
--
CREATE TABLE IF NOT EXISTS `media` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `media`
--
INSERT INTO `media` (`id`, `type`) VALUES
(1, 'facebook'),
(3, 'text'),
(2, 'twitter');
-- --------------------------------------------------------
--
-- Table structure for table `posts`
--
CREATE TABLE IF NOT EXISTS `posts` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`venue_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`lat` decimal(8,6) DEFAULT NULL,
`lon` decimal(9,6) DEFAULT NULL,
`caption` varchar(100) DEFAULT NULL,
`image` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `post_likes`
--
CREATE TABLE IF NOT EXISTS `post_likes` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`post_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `post_reports`
--
CREATE TABLE IF NOT EXISTS `post_reports` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`post_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `post_shares`
--
CREATE TABLE IF NOT EXISTS `post_shares` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`media_id` bigint(20) unsigned NOT NULL,
`post_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `post_views`
--
CREATE TABLE IF NOT EXISTS `post_views` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`post_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `promotions`
--
CREATE TABLE IF NOT EXISTS `promotions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`passcode` varchar(255) NOT NULL,
`venue_id` bigint(20) unsigned NOT NULL,
`start` timestamp NULL DEFAULT NULL,
`end` timestamp NULL DEFAULT NULL,
`limit` int(11) DEFAULT NULL,
`creator` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `promotion_redemptions`
--
CREATE TABLE IF NOT EXISTS `promotion_redemptions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`promotion_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `promotion_views`
--
CREATE TABLE IF NOT EXISTS `promotion_views` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`promotion_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`facebook_token` varchar(255) DEFAULT NULL,
`twitter_token` varchar(255) DEFAULT NULL,
`facebook` varchar(50) DEFAULT NULL,
`twitter` varchar(140) DEFAULT NULL,
`forename` varchar(255) NOT NULL,
`surname` varchar(255) NOT NULL,
`age` tinyint(3) unsigned DEFAULT NULL,
`birth_day` tinyint(2) unsigned DEFAULT NULL,
`birth_month` tinyint(2) unsigned DEFAULT NULL,
`birth_year` year(4) DEFAULT NULL,
`gender` enum('m','f','o') DEFAULT NULL,
`image` varchar(255) DEFAULT NULL,
`staff` timestamp NULL DEFAULT NULL,
`manager` tinyint(1) NOT NULL DEFAULT '0',
`venue_id` bigint(20) unsigned DEFAULT NULL,
`promotion_perm` tinyint(1) NOT NULL DEFAULT '0',
`employee` tinyint(1) NOT NULL DEFAULT '0',
`joined` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`country_id` bigint(20) DEFAULT NULL,
`language_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `facebook_token`, `twitter_token`, `facebook`, `twitter`, `forename`, `surname`, `age`, `birth_day`, `birth_month`, `birth_year`, `gender`, `image`, `staff`, `manager`, `venue_id`, `promotion_perm`, `employee`, `joined`, `country_id`, `language_id`) VALUES
(5, NULL, NULL, NULL, NULL, 'Max', 'Anders', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '2013-04-23 11:44:49', NULL, NULL),
(4, NULL, NULL, NULL, NULL, 'Max', 'Mustermann', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '2013-04-23 11:44:47', NULL, NULL),
(9, 'testnewnow', NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, '2013-04-26 10:15:07', 1, NULL, 0, 1, '2013-04-26 10:15:05', NULL, NULL),
(7, 'testaaa', NULL, NULL, NULL, 'Max', 'Mustermann', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '2013-04-23 11:46:56', NULL, NULL),
(6, 'test', NULL, NULL, NULL, 'Max', 'Mustermann', NULL, NULL, NULL, NULL, NULL, NULL, '2013-04-26 10:14:11', 1, NULL, 0, 1, '2013-04-23 11:46:53', 3, 1),
(1, NULL, NULL, NULL, NULL, 'Test', 'User', NULL, NULL, NULL, NULL, NULL, NULL, '2013-04-19 12:05:51', 0, NULL, 0, 0, '2013-04-19 12:05:51', NULL, NULL),
(8, 'testb', NULL, NULL, NULL, 'Max', 'Anders', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '2013-04-23 11:46:57', NULL, NULL),
(3, NULL, NULL, NULL, NULL, 'Max', 'Mustermann', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '2013-04-23 11:44:44', NULL, NULL),
(2, NULL, NULL, NULL, NULL, 'Max', 'Mustermann', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, 0, '2013-04-23 11:44:40', NULL, NULL),
(10, 'testnewaanow', NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, '2013-04-26 10:49:21', 1, NULL, 1, 1, '2013-04-26 10:49:21', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `user_searches`
--
CREATE TABLE IF NOT EXISTS `user_searches` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_id` bigint(20) unsigned NOT NULL,
`term` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `user_searches`
--
INSERT INTO `user_searches` (`id`, `time`, `user_id`, `term`) VALUES
(1, '2013-04-26 11:51:51', 6, 'test');
-- --------------------------------------------------------
--
-- Table structure for table `venues`
--
CREATE TABLE IF NOT EXISTS `venues` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`address` text NOT NULL,
`country_id` bigint(20) unsigned NOT NULL,
`phone` varchar(255) NOT NULL,
`email` varchar(254) NOT NULL,
`email_verified` tinyint(1) NOT NULL DEFAULT '0',
`category_id` bigint(20) unsigned NOT NULL,
`tooltip` varchar(60) DEFAULT NULL,
`tonight` text,
`website` varchar(255) NOT NULL,
`facebook` varchar(50) DEFAULT NULL,
`twitter` varchar(140) DEFAULT NULL,
`facebook_token` varchar(255) DEFAULT NULL,
`twitter_token` varchar(255) DEFAULT NULL,
`lat` decimal(8,6) NOT NULL,
`lon` decimal(9,6) NOT NULL,
`timezone` tinyint(2) NOT NULL,
`image` varchar(255) DEFAULT NULL,
`official` tinyint(1) NOT NULL DEFAULT '0',
`verified` tinyint(1) NOT NULL DEFAULT '0',
`customer_spend` decimal(10,2) NOT NULL DEFAULT '0.00',
`authenticated` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `venue_categories`
--
CREATE TABLE IF NOT EXISTS `venue_categories` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `venue_favourites`
--
CREATE TABLE IF NOT EXISTS `venue_favourites` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`venue_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `venue_loads`
--
CREATE TABLE IF NOT EXISTS `venue_loads` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`venue_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `venue_rsvps`
--
CREATE TABLE IF NOT EXISTS `venue_rsvps` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`venue_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
`maybe` tinyint(1) NOT NULL DEFAULT '0',
`going` tinyint(1) NOT NULL DEFAULT '0',
`checked_in` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `venue_shares`
--
CREATE TABLE IF NOT EXISTS `venue_shares` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`media_id` bigint(20) unsigned NOT NULL,
`venue_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `venue_views`
--
CREATE TABLE IF NOT EXISTS `venue_views` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`venue_id` bigint(20) unsigned NOT NULL,
`user_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!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 */;