Xananax

CREATE TABLE tag (
  id serial primary key,
  name text not null,
  parent integer references tag(id),
  unique (parent, name)
);

CREATE TABLE photo (
  id serial primary key,
  path text not null