CREATE TABLE photos (
  id        VARCHAR(64)   NOT NULL  PRIMARY KEY,
  photo_url VARCHAR(255)  NOT NULL  DEFAULT '',
  message   VARCHAR(255)  NOT NULL  DEFAULT '',
  listing   INTEGER       NOT NULL  DEFAULT 0,
  ctime     DATETIME 
);

CREATE TRIGGER blank2zero -- listng: "" to "0"
AFTER INSERT ON photos
BEGIN
  UPDATE photos
  SET listing = 0
  WHERE id = new.id AND listing = "";
END;

CREATE TRIGGER insert_now -- ctime: default = NOW()
AFTER INSERT ON photos
BEGIN
  UPDATE photos
  SET ctime = datetime('now', 'localtime')
  WHERE id = new.id;
END;