PHP Classes
elePHPant
Icontem

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: 3 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;