Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Newer
Older
100644 14 lines (13 sloc) 0.419 kb
6a70a9c Initial project files
Brian Cray authored
1 --
2 -- Table structure for table `shortenedurls`
3 --
4
5 CREATE TABLE `shortenedurls` (
6 `id` int(10) unsigned NOT NULL auto_increment,
7 `long_url` varchar(255) NOT NULL,
8 `created` int(10) unsigned NOT NULL,
9 `creator` char(15) NOT NULL,
10 `referrals` int(10) unsigned NOT NULL default '0',
11 PRIMARY KEY (`id`),
12 UNIQUE KEY `long` (`long_url`),
13 KEY `referrals` (`referrals`)
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Something went wrong with that request. Please try again.