shorturl/init.sql

-- phpMyAdmin SQL Dump
-- version 4.2.12deb2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 2015-07-08 17:18:45
-- 服务器版本： 5.6.24-0ubuntu2
-- PHP Version: 5.6.4-4ubuntu6.2

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

--
-- Database: `shorturl`
--

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

--
-- 表的结构 `short_urls`
--

CREATE TABLE IF NOT EXISTS `short_urls` (
`id` int(10) unsigned NOT NULL,
  `long_url` varchar(255) NOT NULL,
  `code` varchar(32) NOT NULL,
  `short_code` varbinary(6) NOT NULL,
  `date_created` int(10) unsigned NOT NULL,
  `counter` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `short_urls`
--
ALTER TABLE `short_urls`
 ADD PRIMARY KEY (`id`), ADD KEY `short_code` (`short_code`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `short_urls`
--
ALTER TABLE `short_urls`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;