PHP Classes

File: database.sql

Recommend this page to a friend!
  Classes of Bharat Parmar   PHP Tiny URL   database.sql   Download  
File: database.sql
Role: Auxiliary data
Content type: text/plain
Description: Database File
Class: PHP Tiny URL
Create short URLs storing them in a MySQL database
Author: By
Last change:
Date: 8 years ago
Size: 275 bytes
 

Contents

Class file image Download 

CREATE TABLE IF NOT EXISTS `tiny_url_master` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `long_url` varchar(256) NOT NULL,
  `tiny_url` varchar(200) NOT NULL,
  `created_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;