-- Whose picture it is, for the pictures that come from somewhere else (the free photos of -- artists from Wikimedia Commons): the author, the licence and the page of the file are -- what a reader needs to give credit, so they are stored with the picture. Pictures from -- the user's own files leave them empty. ALTER TABLE images ADD COLUMN author TEXT NOT NULL DEFAULT ''; ALTER TABLE images ADD COLUMN license TEXT NOT NULL DEFAULT ''; ALTER TABLE images ADD COLUMN license_url TEXT NOT NULL DEFAULT ''; ALTER TABLE images ADD COLUMN page_url TEXT NOT NULL DEFAULT '';