Site:Developer stuff/Commentary pages ordered

Created 1/22/06 by Matthew Faulconer

This is the process used to create the commentary pages ordered table, test.commentary_pages_ordered. This table is used by other sql code because it lists all scripture commentary pages and has an id for keeping them in the correct order.

#create table structure for new table
create table test.commentary_pages_ordered as 
select cur_id as order_id, cur_id, cur_title 
from cur
where 1=0


#create file to play with
create table test.del1 as 
select cur_id, cur_namespace, cur_title 
from feastupontheword.cur 
where cur_namespace=0 

#Export to excel

#Change to correct order

#Add order_id

#insert into test.commentary_pages_ordered

In case the table gets deleted in test, here is the complete content of the table. Note this is a large page: Site:Developer_stuff/Commentary_pages_ordered_table