create table if not exists pages ( id integer primary key autoincrement, note_id integer, name string not null, tags string not null ); create table if not exists notes ( id integer primary key autoincrement, subject string not null, author string not null, author_string string not null, datestring string not null );