Changeset 997

Timestamp:

05/28/09 12:30:43 (4 years ago)

Author:

goldfd

Message:

Added 3 new mineral relationships
Can either rebuild the whole database or run the 05_28_09.sql migration

Location:

trunk/mpdb-server/schema

Files:

• migrations/05_28_09.sql (added)
• mineral-data.sql (modified) (1 diff)

trunk/mpdb-server/schema/mineral-data.sql

@@ -379 +379 @@
 insert into minerals (mineral_id, real_mineral_id, name)  VALUES (nextval('mineral_seq'),(select mineral_id from minerals where name='Biopyribole'), 'Biopyrobole');
 insert into mineral_relationships (parent_mineral_id, child_mineral_id) VALUES((select mineral_id from minerals where name='Other'),(select mineral_id from minerals where name='Biopyribole'));
+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'));
+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'));
+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'));