PHP Classes

File: database.sql

Recommend this page to a friend!
  Classes of anas khan   Custom PHP URL Shortener using PDO   database.sql   Download  
File: database.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Custom PHP URL Shortener using PDO
Create and expand short URLs in a custom domain
Author: By
Last change:
Date: 2 years ago
Size: 328 bytes


Class file image Download
CREATE TABLE `shortened_urls` ( `id` int(11) NOT NULL AUTO_INCREMENT, `long_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `short_code` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `hits` int(11) NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;