create table_photo (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
body blob
);

CREATE TABLE photo_meta
(
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
save_date REAL,
delete_date REAL,
user_id integer NOT NULL,
name text collate russian NOT NULL,
size integer NOT NULL DEFAULT  0 ,
checksum text NOT NULL DEFAULT ''
);

select * from photo_meta, table_photo where photo_meta.id = table_photo.id 

select * from photo_meta, table_photo where photo_meta.id = table_photo.id order by photo_meta.id