This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
integration:rdbms:mysql:example [2011/04/05 20:07] doc |
integration:rdbms:mysql:example [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 21: | Line 21: | ||
==== Example ==== | ==== Example ==== | ||
- | The following example is a simple database using an MySQL database. The Omnidex Environment File is displayed below; however, the entire examplecan be downloaded as a ZIP file at the following link: **{{:integration:rdbms:mysql:mysql_example.zip|Download ZIP File}}**. This ZIP file also includes files that can be used to create the MySQL database. | + | The following example is a simple database using a MySQL database. The Omnidex Environment File is displayed below; however, the entire example can be downloaded as a ZIP file at the following link: **{{:integration:rdbms:mysql:mysql_example.zip|Download ZIP File}}**. This ZIP file also includes files that can be used to create the MySQL database. |
- | The following statements will create and build an Omnidex Environment against an MySQL database: | + | The following statements will create and build an Omnidex Environment against a MySQL database: |
<code> | <code> | ||
> use sql/create_all.sql | > use sql/create_all.sql | ||
Line 96: | Line 96: | ||
>> constraint HOUSEHOLDS_HOUSEHOLD_PK primary ("HOUSEHOLD"), | >> constraint HOUSEHOLDS_HOUSEHOLD_PK primary ("HOUSEHOLD"), | ||
>> constraint HOUSEHOLDS_STATE_FK foreign ("STATE") references "STATES", | >> constraint HOUSEHOLDS_STATE_FK foreign ("STATE") references "STATES", | ||
- | >> constraint HOUSEHOLDS_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES" | + | >> constraint HOUSEHOLDS_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES", |
- | , | + | |
>> native HOUSEHOLDS_HOUSEHOLD_IDX ("HOUSEHOLD") | >> native HOUSEHOLDS_HOUSEHOLD_IDX ("HOUSEHOLD") | ||
>> ) | >> ) | ||
Line 114: | Line 113: | ||
>> "EMAIL" CHARACTER(60) quicktext, | >> "EMAIL" CHARACTER(60) quicktext, | ||
>> constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"), | >> constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"), | ||
- | >> constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSE | + | >> constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", |
- | HOLDS", | + | |
>> constraint INDIVIDUALS_GENDER_FK foreign ("GENDER") references "GENDERS", | >> constraint INDIVIDUALS_GENDER_FK foreign ("GENDER") references "GENDERS", | ||
>> native INDIVIDUALS_INDIVIDUAL_IDX ("INDIVIDUAL") | >> native INDIVIDUALS_INDIVIDUAL_IDX ("INDIVIDUAL") |