DROP TABLE IF EXISTS photo;

CREATE TABLE photo (
  photo_id VARCHAR(255) NOT NULL,
  photo_secret VARCHAR(255) NOT NULL,
  photo_server INT NOT NULL,
  photo_owner VARCHAR(255) NOT NULL,
  photo_owner_name VARCHAR(255) NOT NULL,
  photo_is_public TINYINT(1) NOT NULL,
  photo_is_friend TINYINT(1) NOT NULL,
  photo_is_family TINYINT(1) NOT NULL,
  photo_date_taken DATETIME NOT NULL,  
  photo_date_taken_granularity INT NOT NULL,
  photo_date_upload INT NOT NULL,
  photo_title VARCHAR(255) NOT NULL,
  photo_latitude DOUBLE NOT NULL,
  photo_longitude DOUBLE NOT NULL,
  photo_accuracy INT NOT NULL,
  PRIMARY KEY  (photo_id)
);
