$ echo ' create table articles (id integer not null, parsed text, primary key (id)); create table information (id integer not null, something text, primary key (id)); create table articles_information (articles_id integer not null, information_id integer not null, primary key (articles_id, information_id), foreign key (articles_id) references articles (id), foreign key (information_id) references information (id)); ' | sqlite3 M15U.sqlite