<commit_before>URL Shortener

Copyright (c) 2011 <NAME>.

Written by <NAME>, mark [at] mark roland dot com

This code may be distributed and used for free. The author makes
no guarantee for this software and offers no support.

This project is documented at http://markroland.com/project/url-shortener

MySQL Tables:

CREATE TABLE `short_url` (
	`shortcut_id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
	`shortcut` varchar(32) NOT NULL DEFAULT '',
	`destination_url` varchar(255) NOT NULL DEFAULT '',
	`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
	`set_referrer` tinyint(3) unsigned NOT NULL DEFAULT '0',
	PRIMARY KEY (`shortcut_id`),
	UNIQUE KEY `shortcut` (`shortcut`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

CREATE TABLE `short_url_tracking` (
	`shortcut_id` smallint(3) unsigned DEFAULT '0',
	`request_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
	`ip_address` int(10) unsigned NOT NULL DEFAULT '0',
	`source` varchar(32) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;<commit_msg>Add MySQL info to readme<commit_after>URL Shortener

Copyright (c) 2011 <NAME>.

Written by <NAME>, mark [at] mark roland dot com

This code may be distributed and used for free. The author makes
no guarantee for this software and offers no support.

This project is documented at http://markroland.com/project/url-shortener

MySQL Tables:

CREATE TABLE `short_url` (
	`shortcut_id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
	`shortcut` varchar(32) NOT NULL DEFAULT '',
	`destination_url` varchar(255) NOT NULL DEFAULT '',
	`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
	`set_referrer` tinyint(3) unsigned NOT NULL DEFAULT '0',
	PRIMARY KEY (`shortcut_id`),
	UNIQUE KEY `shortcut` (`shortcut`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `short_url_tracking` (
	`shortcut_id` smallint(3) unsigned DEFAULT '0',
	`request_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
	`ip_address` int(10) unsigned NOT NULL DEFAULT '0',
	`source` varchar(32) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
{'fraction_non_alphanumeric': 0.10817307692307693, 'fraction_numerical': 0.047596153846153844, 'mean_word_length': 5.627388535031847, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7073308', 'n_tokens_mistral': 765, 'n_tokens_neox': 684, 'n_words': 238}