kurz/data/db-schema.sql

-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 25, 2015 at 05:22 PM
-- Server version: 5.5.40
-- PHP Version: 5.4.36-1+deb.sury.org~precise+2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `go_kurz`
--

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

--
-- Table structure for table `longurl`
--

CREATE TABLE IF NOT EXISTS `longurl` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(32) NOT NULL COMMENT 'The short URL itself',
  PRIMARY KEY (`id`),
  UNIQUE KEY `url` (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `shorturl`
--

CREATE TABLE IF NOT EXISTS `shorturl` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(32) NOT NULL COMMENT 'The short URL itself',
  `longurl` bigint(20) unsigned NOT NULL,
  `domain` int(11) NOT NULL,
  `strategy` varchar(8) NOT NULL DEFAULT 'base',
  `submittedBy` int(11) NOT NULL,
  `submittedInfo` int(11) NOT NULL,
  `isEnabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `url` (`url`),
  KEY `longurl` (`longurl`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


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

--
-- Table structure for table `eventinfo`
--

CREATE TABLE IF NOT EXISTS `eventinfo` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `source` varchar(8) DEFAULT NULL COMMENT 'The event source',
  `ip` varchar(30) NOT NULL DEFAULT '' COMMENT 'May be IPv4 or IPv6',
  UNIQUE KEY `id` (`id`),
  KEY `ip` (`ip`),
  KEY `source` (`source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Event info' AUTO_INCREMENT=1 ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `shorturl`
--
ALTER TABLE `shorturl`
  ADD CONSTRAINT `shorturl_fk_longurl` FOREIGN KEY (`longurl`) REFERENCES `longurl` (`id`);