This shows you the differences between two versions of the page.
|
admin:basics:environments:create [2011/01/13 16:35] els created |
admin:basics:environments:create [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | ====== Administration: Omnidex Basics ====== | ||
| - | |||
| - | ===== Omnidex Environments ===== | ||
| - | |||
| - | [[admin:basics:environments:home|Overview]] | | ||
| - | [[admin:basics:environments:types|Types]] | | ||
| - | **[[admin:basics:environments:create|Creating]]** | | ||
| - | [[admin:basics:environments:maintain|Maintaining]] | | ||
| - | [[admin:basics:environments:deploy|Deploying]] | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== Creating Environments ==== | ||
| - | |||
| - | There are two methods to create Omnidex Environments. 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> | ||
| - | create environment | ||
| - | in "simple.xml" | ||
| - | with delete; | ||
| - | |||
| - | |||
| - | create database "SIMPLE" | ||
| - | type FLATFILE | ||
| - | index_directory "idx" | ||
| - | in "simple.xml"; | ||
| - | |||
| - | |||
| - | create table "COUNTRIES" | ||
| - | physical "dat\cnt.dat" | ||
| - | ( | ||
| - | "COUNTRY" CHARACTER(2), | ||
| - | "DESCRIPTION" C STRING(47), | ||
| - | "LATITUDE" FLOAT usage "LATITUDE", | ||
| - | "LONGITUDE" FLOAT usage "LONGITUDE", | ||
| - | "CAPITAL" C STRING(31), | ||
| - | "CAPITAL_LAT" FLOAT usage "LATITUDE", | ||
| - | "CAPITAL_LONG" FLOAT usage "LONGITUDE", | ||
| - | constraint COUNTRIES_COUNTRY_PK primary ("COUNTRY") | ||
| - | ) | ||
| - | in "simple.xml"; | ||
| - | |||
| - | |||
| - | create table "STATES" | ||
| - | physical "dat\sta.dat" | ||
| - | ( | ||
| - | "STATE" CHARACTER(2), | ||
| - | "DESCRIPTION" C STRING(31), | ||
| - | "STATE_CODE" CHARACTER(2), | ||
| - | "REGION" CHARACTER(2), | ||
| - | "COUNTRY" CHARACTER(2), | ||
| - | "TAX_RATE" FLOAT, | ||
| - | constraint STATES_STATE_PK primary ("STATE"), | ||
| - | constraint STATES_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES" | ||
| - | ) | ||
| - | in "simple.xml"; | ||
| - | |||
| - | |||
| - | create table "GENDERS" | ||
| - | physical "dat\gdr.dat" | ||
| - | ( | ||
| - | "GENDER" CHARACTER(1), | ||
| - | "DESCRIPTION" C STRING(31), | ||
| - | constraint GENDERS_GENDER_PK primary ("GENDER") | ||
| - | ) | ||
| - | in "simple.xml"; | ||
| - | |||
| - | |||
| - | create table "HOUSEHOLDS" | ||
| - | physical "dat\households.dat" | ||
| - | ( | ||
| - | "HOUSEHOLD" CHARACTER(12), | ||
| - | "ADDRESS" CHARACTER(50), | ||
| - | "CITY" CHARACTER(28), | ||
| - | "STATE" CHARACTER(2), | ||
| - | "ZIP" CHARACTER(5), | ||
| - | "COUNTRY" CHARACTER(2), | ||
| - | constraint HSHD_HOUSEHOLD_PK primary ("HOUSEHOLD"), | ||
| - | constraint HSHD_STATE_FK foreign ("STATE") references "STATES", | ||
| - | constraint HSHD_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES" | ||
| - | ) | ||
| - | in "simple.xml"; | ||
| - | |||
| - | |||
| - | create table "INDIVIDUALS" | ||
| - | physical "dat\individuals.dat" | ||
| - | ( | ||
| - | "INDIVIDUAL" CHARACTER(12), | ||
| - | "HOUSEHOLD" CHARACTER(12), | ||
| - | "NAME" CHARACTER(50), | ||
| - | "GENDER" CHARACTER(1), | ||
| - | "BIRTHDATE" ANSI DATE, | ||
| - | "PHONE" CHARACTER(14), | ||
| - | "EMAIL" CHARACTER(60), | ||
| - | constraint IND_INDIVIDUAL_PK primary ("INDIVIDUAL"), | ||
| - | constraint IND_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", | ||
| - | constraint IND_GENDER_FK foreign ("GENDER") references "GENDERS", | ||
| - | ) | ||
| - | in "simple.xml"; | ||
| - | |||
| - | </code> | ||
| - | |||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[admin:basics:environments:home|Prev]]** | | ||
| - | **[[admin:basics:environments:create|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:admin:basics:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||