|
Revision 997, 0.6 KB
(checked in by goldfd, 4 years ago)
|
|
Added 3 new mineral relationships
Can either rebuild the whole database or run the 05_28_09.sql migration
|
| Line | Â |
|---|
| 1 | -- adds 3 child relationships to biopyribole
|
|---|
| 2 | insert into mineral_relationships (parent_mineral_id, child_mineral_id) VALUES((select mineral_id from minerals where name='Biopyribole'),(select mineral_id from minerals where name='Mica'));
|
|---|
| 3 | insert into mineral_relationships (parent_mineral_id, child_mineral_id) VALUES((select mineral_id from minerals where name='Biopyribole'),(select mineral_id from minerals where name='Amphibole'));
|
|---|
| 4 | insert into mineral_relationships (parent_mineral_id, child_mineral_id) VALUES((select mineral_id from minerals where name='Biopyribole'),(select mineral_id from minerals where name='Pyroxene')); |
|---|
