Login   Register  
PHP Classes
elePHPant
Icontem

File: DatabaseTableStructure.txt

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ovunc Tukenmez  >  URL Shortener  >  DatabaseTableStructure.txt  >  Download  
File: DatabaseTableStructure.txt
Role: Auxiliary data
Content type: text/plain
Description: database table structure
Class: URL Shortener
Create and expand short URLs in a MySQL database
Author: By
Last change:
Date: 2012-11-04 15:17
Size: 269 bytes
 

Contents

Class file image Download 
CREATE TABLE shortLinks (
id int(11) UNSIGNED NOT NULL auto_increment,
ulid varchar(15) NOT NULL default '',
longLink varchar(255) NOT NULL default '',
PRIMARY KEY(id),
UNIQUE(ulid),
KEY(longLink)
) TYPE=MyISAM COMMENT='Link Table' CHARSET=utf8 COLLATE=utf8_bin;