This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:basics:environments:create [2012/01/19 22:01] doc |
admin:basics:environments:create [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 19: | Line 19: | ||
| There are two methods to create Omnidex Environment Files. They can be created interactively using the [[programs:odxadmin:home|Omnidex Administrator]], or they can be created using SQL statements such as [[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]], [[dev:sql:statements:create_database:home|CREATE DATABASE]], [[dev:sql:statements:create_table:home|CREATE TABLE]] and [[dev:sql:statements:create_index:home|CREATE INDEX]]. Once created, a simple Omnidex Environment File will look like this: | There are two methods to create Omnidex Environment Files. They can be created interactively using the [[programs:odxadmin:home|Omnidex Administrator]], or they can be created using SQL statements such as [[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]], [[dev:sql:statements:create_database:home|CREATE DATABASE]], [[dev:sql:statements:create_table:home|CREATE TABLE]] and [[dev:sql:statements:create_index:home|CREATE INDEX]]. Once created, a simple Omnidex Environment File will look like this: | ||
| - | <code sql> | + | <code> |
| > create environment | > create environment | ||
| >> in "simple.xml" | >> in "simple.xml" | ||
| Line 69: | Line 69: | ||
| The easiest way to add Omnidex Indexing is to add indexing information beside each column. This will not work in all situations, such as when multi-column indexes are being created; however, it will work in many simpler installations. More complex installations will require the more complex features described in [[dev:sql:statements:create_table:home|CREATE TABLE]] and [[dev:sql:statements:create_index:home|CREATE INDEX]]. The example below shows the basic addition of Omnidex indexing to the same database. | The easiest way to add Omnidex Indexing is to add indexing information beside each column. This will not work in all situations, such as when multi-column indexes are being created; however, it will work in many simpler installations. More complex installations will require the more complex features described in [[dev:sql:statements:create_table:home|CREATE TABLE]] and [[dev:sql:statements:create_index:home|CREATE INDEX]]. The example below shows the basic addition of Omnidex indexing to the same database. | ||
| - | <code sql> | + | <code> |
| > create environment | > create environment | ||
| >> in "simple.xml" | >> in "simple.xml" | ||
| Line 128: | Line 128: | ||
| ---------------------------------------------------------------------------- | ---------------------------------------------------------------------------- | ||
| SIMPLE | SIMPLE | ||
| - | COUNTRIES 239 0:00 0:00 | ||
| - | STATES 76 0:00 0:00 | ||
| - | GENDERS 2 0:00 0:00 | ||
| HOUSEHOLDS 1,909 0:00 0:00 | HOUSEHOLDS 1,909 0:00 0:00 | ||
| INDIVIDUALS 5,000 0:00 0:00 | INDIVIDUALS 5,000 0:00 0:00 | ||