insert into topics values (default, 'History', NULL );
insert into items values (default, 'Studying History' );
insert into item_topics values ( (select item_id from items where item_name = 'Studying History'),
(select topic_id from topics where topic_name='History' ));

insert into topics values (default, 'California History',(select topic_id from topics where topic_name = 'History') );
insert into items values (default, 'Spanish California' );
insert into item_topics values ( (select item_id from items where item_name = 'Spanish California'),
(select topic_id from topics where topic_name='California History' ));
insert into items values (default, 'Gold Rush' );
insert into item_topics values ( (select item_id from items where item_name = 'Gold Rush'),
(select topic_id from topics where topic_name='California History' ));
insert into items values (default, 'Dot Coms' );
insert into item_topics values ( (select item_id from items where item_name = 'Dot Coms'),
(select topic_id from topics where topic_name='California History' ));

insert into topics values (default, 'American History', (select topic_id from topics where topic_name = 'History') );
insert into items values (default, 'American Presidents' );
insert into item_topics values ( (select item_id from items where item_name = 'American Presidents'),
(select topic_id from topics where topic_name='American History' ));
insert into items values (default, 'Civil War' );
insert into item_topics values ( (select item_id from items where item_name = 'Civil War'),
(select topic_id from topics where topic_name='American History' ));
insert into items values (default, 'Civil Rights' );
insert into item_topics values ( (select item_id from items where item_name = 'Civil Rights'),
(select topic_id from topics where topic_name='American History' ));
insert into items values (default, 'The Making of the Constitution' );
insert into item_topics values ( (select item_id from items where item_name = 'The Making of the Constitution'),
(select topic_id from topics where topic_name='American History' ));

insert into topics values (default, 'San Francisco History', (select topic_id from topics where topic_name = 'California History') );
insert into items values (default, 'The Golden Gate');
insert into item_topics values ( (select item_id from items where item_name = 'The Golden Gate'),
(select topic_id from topics where topic_name='San Francisco History' ));
insert into items values (default, 'Digging up Market Street');
insert into item_topics values ( (select item_id from items where item_name = 'Digging up Market Street'),
(select topic_id from topics where topic_name='San Francisco History' ));

insert into topics values (default, 'Computer Science', NULL );

insert into topics values (default, 'Computer Languages', (select topic_id from topics where topic_name = 'Computer Science') );
insert into topics values (default, 'Ada', (select topic_id from topics where topic_name = 'Computer Languages') );
insert into items values (default, 'Ada At A Glance');
insert into items values (default, 'Ada Lovelace: Scientific Computing');
insert into item_topics values ((select item_id from items where item_name = 'Ada Lovelace: Scientific Computing'), (select topic_id from topics where topic_name='History'));
insert into item_topics values ((select item_id from items where item_name = 'Ada Lovelace: Scientific Computing'), (select topic_id from topics where topic_name='Ada'));
insert into topics values (default, 'Perl', (select topic_id from topics where topic_name = 'Computer Languages') );
insert into items values (default, 'The Camel Book');
insert into item_topics values ((select item_id from items where item_name = 'The Camel Book'), (select topic_id from topics where topic_name='Perl'));
insert into items values (default, 'Bad Perl, Good Perl');
insert into item_topics values ((select item_id from items where item_name = 'Bad Perl, Good Perl'), (select topic_id from topics where topic_name='Perl'));
insert into topics values (default, 'Databases', (select topic_id from topics where topic_name = 'Computer Science') );
insert into items values (default, 'Comparing Databases');
insert into item_topics values ((select item_id from items where item_name = 'Comparing Databases'), (select topic_id from topics where topic_name='Databases'));

insert into topics values (default, 'Postgres', (select topic_id from topics where topic_name = 'Databases') );
insert into items values (default, 'General Bits');
insert into item_topics values ((select item_id from items where item_name = 'General Bits'), (select topic_id from topics where topic_name='Postgres'));
insert into items values (default, 'Practicing Postgres');
insert into item_topics values ((select item_id from items where item_name = 'Practicing Postgres'), (select topic_id from topics where topic_name='Postgres'));

insert into topics values (default, 'Ingres', (select topic_id from topics where topic_name = 'Databases') );
insert into items values (default, 'UCBerkeley Archives: Ingres');
insert into item_topics values ((select item_id from items where item_name = 'UCBerkeley Archives: Ingres'), (select topic_id from topics where topic_name='Ingres'));
insert into items values (default, 'Relational Technology, Inc.');
insert into item_topics values ((select item_id from items where item_name = 'Relational Technology, Inc.'), (select topic_id from topics where topic_name='Ingres'));