Creating SQL Table: Revision

Last updated by steven

CREATE TABLE `dropzones` (
  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  `name` VARCHAR( 60 ) NOT NULL ,
  `street` VARCHAR( 80 ) NOT NULL ,
  `city` VARCHAR( 80 ) NOT NULL ,
  `phone` VARCHAR( 80 ) NOT NULL ,
  `fax` VARCHAR( 80 ) NOT NULL ,
  `mail` VARCHAR( 80 ) NOT NULL ,
  `internet` VARCHAR( 80 ) NOT NULL ,
  `latitude` FLOAT( 10, 6 ) NOT NULL ,
  `longitude` FLOAT( 10, 6 ) NOT NULL ,
  `type` VARCHAR( 30 ) NOT NULL
) ENGINE = MYISAM ;

History