Robware/DB Scripts/create_images.sql

CREATE TABLE `robware-test`.`images` (
  `image_id` INT NOT NULL AUTO_INCREMENT,
  `album_id` INT NULL DEFAULT 0,
  `image_filename` VARCHAR(255) NOT NULL,
  `image_title` VARCHAR(255) NULL,
  `image_description` TEXT NULL,
  `image_timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `image_deleted` BIT NULL DEFAULT 0,
  `image_hidden` BIT NULL DEFAULT 1,
  PRIMARY KEY (`image_id`));