Login   Register  
PHP Classes
elePHPant
Icontem

File: __DB/tables/locations.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of solomongaby  >  MySQL Versioning  >  __DB/tables/locations.sql  >  Download  
File: __DB/tables/locations.sql
Role: Auxiliary data
Content type: text/plain
Description: initial create for table locations.
Class: MySQL Versioning
Update MySQL databases using SQL change set files
Author: By
Last change:
Date: 2009-03-29 04:48
Size: 393 bytes
 

Contents

Class file image Download
--
-- Table structure for table `locations`
--

CREATE TABLE IF NOT EXISTS `locations` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `id_county` smallint(5) unsigned NOT NULL,
  `location` varchar(100) NOT NULL,
  `address` varchar(255) NOT NULL,
  `phone` varchar(10) NOT NULL,
  `city` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;