Site:Developer stuff/Adding links to TOC

Here are the steps used to add the links at the top that take one to the table of contents lists. E.g. here's what is at the top of Gen 1:1-5:

The Old Testament > Genesis > Chapter 1

1. created file in excel. Here's the link.

2. uploaded file to test db.

3. ran the following code

UPDATE thestandardworks.cur b
INNER JOIN test.Adding_TOC_Links a
ON a.cur_id=b.cur_id
SET b.cur_text = concat(text_to_add,'
',b.cur_text),
cur_timestamp= 20061020045151,
cur_touched=20061020045151,
inverse_timestamp=79938979954848
where b.cur_id<>65260