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