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)
  );