PHP Classes

File: DatabaseTableStructure.txt

Recommend this page to a friend!
  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: 12 years ago
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;