# Exported from MS Access to MySQL
# (C) 1997-98 CYNERGI - www.cynergi.net, info@cynergi.net

CREATE TABLE Authority
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     AuthorityID                                                       SMALLINT NOT NULL DEFAULT 0,
     AuthorityName                                                     CHAR(230) NOT NULL,
     AuthorityTypeName                                                 CHAR(230) NOT NULL,
     AuthorityDescription                                              LONGBLOB
     )\g


CREATE TABLE DataElement
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     SortOrder                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementCode                                                   CHAR(15),
     DataElementName                                                   CHAR(230) NOT NULL,
     DataElementShort                                                  CHAR(25) NOT NULL,
     DataElementDOS                                                    CHAR(8) NOT NULL,
     DataElementPrompt                                                 CHAR(230) NOT NULL,
     MetaDataElement                                                   SMALLINT NOT NULL DEFAULT 0,
     DataTypeID                                                        SMALLINT NOT NULL DEFAULT 0,
     ValidFrom                                                         INT NOT NULL,
     ValidTo                                                           INT NOT NULL,
     DataElementDescription                                            LONGBLOB,
     AggregateStartLevel                                               SMALLINT,
     AggregateOperator                                                 CHAR(6),
     DataElementNameAlt1                                               CHAR(230),
     DataElementShortAlt1                                              CHAR(20),
     DataElementNameAlt2                                               CHAR(230),
     DataElementShortAlt2                                              CHAR(20),
     DataElementNameAlt3                                               CHAR(230),
     DataElementShortAlt3                                              CHAR(20)
     )\g


CREATE TABLE DataElementAndIndicatorGroup
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataElementAndIndicatorGroupID                                    SMALLINT NOT NULL DEFAULT 0,
     DataElementAndIndicatorGroupName                                  CHAR(70) NOT NULL,
     DataElementAndIndicatorGroupDescription                           LONGBLOB
     )\g


CREATE TABLE DataElementGroupMember
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataElementAndIndicatorGroupID                                    SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0
     )\g


CREATE TABLE DataElementOrgUnitGroupPeriodTarget
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     OrgUnitGroupID                                                    SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 1,
     EntryNumberMin                                                    REAL NOT NULL DEFAULT 0,
     EntryNumberMax                                                    REAL NOT NULL DEFAULT 0,
     AuthorityID                                                       SMALLINT NOT NULL DEFAULT 1,
     SourceID                                                          SMALLINT
     )\g


CREATE TABLE DataElementOrgUnitPeriodTarget
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumberMin                                                    REAL NOT NULL DEFAULT 0,
     EntryNumberMax                                                    REAL NOT NULL DEFAULT 0,
     AuthorityID                                                       SMALLINT NOT NULL DEFAULT 0,
     SourceID                                                          SMALLINT
     )\g


CREATE TABLE DataFileProperty
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     PropertyName                                                      CHAR(70) NOT NULL,
     EntryText                                                         CHAR(230),
     EntryNumber                                                       REAL,
     EntryDate                                                         DATETIME,
     Comment                                                           CHAR(230)
     )\g


CREATE TABLE DataPeriod
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataPeriodID                                                      SMALLINT NOT NULL,
     DataPeriodName                                                    CHAR(25) NOT NULL,
     DataPeriodTypeID                                                  SMALLINT NOT NULL DEFAULT 0,
     ValidFrom                                                         INT NOT NULL DEFAULT "1/1/1994",
     ValidTo                                                           INT NOT NULL DEFAULT "12/31/9999",
     DataPeriodNameAlt1                                                CHAR(25),
     DataPeriodNameAlt2                                                CHAR(25),
     DataPeriodNameAlt3                                                CHAR(25),
     KEY (ValidFrom, ValidTo)
     )\g


CREATE TABLE DataPeriodType
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataPeriodTypeID                                                  SMALLINT NOT NULL DEFAULT 0,
     DataPeriodTypeName                                                CHAR(25) NOT NULL,
     SortOrder                                                         SMALLINT NOT NULL DEFAULT 0,
     DataPeriodFormat                                                  CHAR(230),
     AnnualisationFactor                                               REAL,
     UpperRangeDayCount                                                SMALLINT,
     DataPeriodIntervalSetting                                         CHAR(10)
     )\g


CREATE TABLE DataSet
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataSetID                                                         SMALLINT NOT NULL DEFAULT 0,
     SortOrder                                                         SMALLINT NOT NULL DEFAULT 0,
     DataSetName                                                       CHAR(230) NOT NULL,
     TableListID                                                       SMALLINT NOT NULL DEFAULT 0,
     DataPeriodTypeID                                                  SMALLINT,
     DataSetGroupID                                                    SMALLINT,
     DataSetNameAlt1                                                   CHAR(230),
     DataSetNameAlt2                                                   CHAR(230),
     DataSetNameAlt3                                                   CHAR(230)
     )\g


CREATE TABLE DataSetElement
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataSetElementID                                                  SMALLINT NOT NULL,
     DataSetID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     SortOrder                                                         SMALLINT NOT NULL DEFAULT 0
     )\g


CREATE TABLE DataSetGroup
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataSetGroupID                                                    SMALLINT NOT NULL DEFAULT 0,
     DataSetGroupName                                                  CHAR(70) NOT NULL,
     DataSetGroupDescription                                           LONGBLOB
     )\g


CREATE TABLE DataSetMetaData
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataSetID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     EntryText                                                         CHAR(230),
     EntryYesNo                                                        SMALLINT,
     EntryNumber                                                       REAL,
     EntryDate                                                         INT,
     EntryMemo                                                         LONGBLOB,
     EntryObject                                                       LONGBLOB,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230)
     )\g


CREATE TABLE DataSetMetaElement
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataSetElementID                                                  SMALLINT NOT NULL,
     DataSetID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     SortOrder                                                         SMALLINT NOT NULL DEFAULT 0,
     KEY (DataSetID, DataElementID)
     )\g


CREATE TABLE DataSource
     (
     DataSourceID                                                      INT NOT NULL AUTO_INCREMENT,
     DataFileName                                                      CHAR(230) NOT NULL,
     KEY (DataFileName),
     KEY (DataSourceID),
     PRIMARY KEY (DataFileName)
     )\g


CREATE TABLE DataType
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataTypeID                                                        SMALLINT NOT NULL DEFAULT 0,
     DataTypeName                                                      CHAR(25) NOT NULL,
     DataTypeDisplay                                                   CHAR(25) NOT NULL
     )\g


CREATE TABLE DEandIndGroupSet
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DEandIndGroupSetID                                                SMALLINT,
     DEandIndGroupSetName                                              CHAR(230),
     DEandIndGroupSetDescription                                       LONGBLOB
     )\g


CREATE TABLE DEandIndGroupSetMember
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DEandIndGroupSetID                                                SMALLINT NOT NULL DEFAULT 0,
     DataElementAndIndicatorGroupID                                    SMALLINT NOT NULL DEFAULT 0
     )\g


CREATE TABLE Indicator
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     IndicatorID                                                       SMALLINT NOT NULL DEFAULT 0,
     SortOrder                                                         SMALLINT NOT NULL DEFAULT 0,
     IndicatorCode                                                     CHAR(15),
     IndicatorName                                                     CHAR(230) NOT NULL,
     IndicatorShort                                                    CHAR(25) NOT NULL,
     IndicatorDOS                                                      CHAR(8) NOT NULL,
     ValidFrom                                                         INT NOT NULL DEFAULT "1/1/1994",
     ValidTo                                                           INT NOT NULL DEFAULT "12/31/9999",
     IndicatorDescription                                              LONGBLOB,
     Comment                                                           LONGBLOB,
     IndicatorTypeID                                                   SMALLINT NOT NULL DEFAULT 0,
     DataPeriodTypeID                                                  SMALLINT NOT NULL DEFAULT 0,
     Annualised                                                        SMALLINT NOT NULL DEFAULT 0,
     IndicatorNameAlt1                                                 CHAR(230),
     IndicatorShortAlt1                                                CHAR(25),
     IndicatorNameAlt2                                                 CHAR(230),
     IndicatorShortAlt2                                                CHAR(25),
     IndicatorNameAlt3                                                 CHAR(230),
     IndicatorShortAlt3                                                CHAR(25),
     IndicatorNumerator                                                LONGBLOB,
     IndicatorNumeratorDescription                                     CHAR(50),
     IndicatorDenominator                                              LONGBLOB,
     IndicatorDenominatorDescription                                   CHAR(50)
     )\g


CREATE TABLE IndicatorBenchmark
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     IndicatorID                                                       SMALLINT NOT NULL DEFAULT 0,
     BenchmarkArea                                                     CHAR(230) NOT NULL,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumber                                                       REAL,
     SourceID                                                          SMALLINT
     )\g


CREATE TABLE IndicatorGroupMember
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     DataElementAndIndicatorGroupID                                    SMALLINT NOT NULL DEFAULT 0,
     IndicatorID                                                       SMALLINT NOT NULL DEFAULT 0
     )\g


CREATE TABLE IndicatorOrgUnitGroupPeriodTarget
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     IndicatorID                                                       SMALLINT NOT NULL DEFAULT 0,
     OrgUnitGroupID                                                    SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumberMin                                                    REAL NOT NULL DEFAULT 0,
     EntryNumberMax                                                    REAL NOT NULL DEFAULT 0,
     AuthorityID                                                       SMALLINT NOT NULL DEFAULT 0,
     SourceID                                                          SMALLINT
     )\g


CREATE TABLE IndicatorOrgUnitLevel
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     IndicatorID                                                       SMALLINT NOT NULL DEFAULT 0,
     OrgUnitLevel                                                      SMALLINT NOT NULL DEFAULT 0,
     Aggregated                                                        SMALLINT NOT NULL DEFAULT 0
     )\g


CREATE TABLE IndicatorOrgUnitPeriodTarget
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     IndicatorID                                                       SMALLINT NOT NULL DEFAULT 0,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumberMin                                                    REAL NOT NULL DEFAULT 0,
     EntryNumberMax                                                    REAL NOT NULL DEFAULT 0,
     AuthorityID                                                       SMALLINT NOT NULL DEFAULT 0,
     SourceID                                                          SMALLINT
     )\g


CREATE TABLE IndicatorOU1
     (
     DataSourceID                                                      SMALLINT,
     OrgUnitID                                                         SMALLINT,
     IndicatorID                                                       SMALLINT,
     DataPeriodTypeID                                                  SMALLINT,
     DataPeriod                                                        INT,
     NumeratorValue                                                    REAL,
     DenominatorValue                                                  REAL
     )\g


CREATE TABLE IndicatorOU2
     (
     DataSourceID                                                      SMALLINT,
     OrgUnitID                                                         SMALLINT,
     IndicatorID                                                       SMALLINT,
     DataPeriodTypeID                                                  SMALLINT,
     DataPeriod                                                        INT,
     NumeratorValue                                                    REAL,
     DenominatorValue                                                  REAL
     )\g


CREATE TABLE IndicatorOU3
     (
     DataSourceID                                                      SMALLINT,
     OrgUnitID                                                         SMALLINT,
     IndicatorID                                                       SMALLINT,
     DataPeriodTypeID                                                  SMALLINT,
     DataPeriod                                                        INT,
     NumeratorValue                                                    REAL,
     DenominatorValue                                                  REAL
     )\g


CREATE TABLE IndicatorOU4
     (
     DataSourceID                                                      SMALLINT,
     OrgUnitID                                                         SMALLINT,
     IndicatorID                                                       SMALLINT,
     DataPeriodTypeID                                                  SMALLINT,
     DataPeriod                                                        INT,
     NumeratorValue                                                    REAL,
     DenominatorValue                                                  REAL
     )\g


CREATE TABLE IndicatorOU5
     (
     DataSourceID                                                      SMALLINT,
     OrgUnitID                                                         SMALLINT,
     IndicatorID                                                       SMALLINT,
     DataPeriodTypeID                                                  SMALLINT,
     DataPeriod                                                        INT,
     NumeratorValue                                                    REAL,
     DenominatorValue                                                  REAL
     )\g


CREATE TABLE IndicatorOU6
     (
     DataSourceID                                                      SMALLINT,
     OrgUnitID                                                         SMALLINT,
     IndicatorID                                                       SMALLINT,
     DataPeriodTypeID                                                  SMALLINT,
     DataPeriod                                                        INT,
     NumeratorValue                                                    REAL,
     DenominatorValue                                                  REAL
     )\g


CREATE TABLE IndicatorOU7
     (
     DataSourceID                                                      SMALLINT,
     OrgUnitID                                                         SMALLINT,
     IndicatorID                                                       SMALLINT,
     DataPeriodTypeID                                                  SMALLINT,
     DataPeriod                                                        INT,
     NumeratorValue                                                    REAL,
     DenominatorValue                                                  REAL
     )\g


CREATE TABLE IndicatorOU8
     (
     DataSourceID                                                      SMALLINT,
     OrgUnitID                                                         SMALLINT,
     IndicatorID                                                       SMALLINT,
     DataPeriodTypeID                                                  SMALLINT,
     DataPeriod                                                        INT,
     NumeratorValue                                                    REAL,
     DenominatorValue                                                  REAL
     )\g


CREATE TABLE IndicatorType
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     IndicatorTypeID                                                   SMALLINT NOT NULL,
     IndicatorTypeName                                                 CHAR(230) NOT NULL,
     Factor                                                            REAL NOT NULL DEFAULT 1,
     KEY (IndicatorTypeName)
     )\g


CREATE TABLE OrgHierarchy
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgHierarchyID                                                    SMALLINT NOT NULL,
     OrgUnitStructureID                                                SMALLINT NOT NULL DEFAULT 1,
     OrgUnitChildID                                                    SMALLINT NOT NULL DEFAULT 0,
     OrgUnitParentID                                                   SMALLINT NOT NULL DEFAULT 0,
     KEY (OrgUnitStructureID, OrgUnitChildID, OrgUnitParentID)
     )\g


CREATE TABLE OrgUnit
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     OrgUnitCode                                                       CHAR(15),
     OrgUnitLevel                                                      SMALLINT NOT NULL DEFAULT 0,
     OrgUnitName                                                       CHAR(230) NOT NULL,
     OrgUnitShort                                                      CHAR(25) NOT NULL,
     ValidFrom                                                         INT NOT NULL DEFAULT "1/1/1994",
     ValidTo                                                           INT NOT NULL DEFAULT "12/31/9999",
     Active                                                            SMALLINT NOT NULL DEFAULT 1,
     Comment                                                           CHAR(230),
     OrgUnitNameOld                                                    CHAR(230),
     OrgUnitShortOld                                                   CHAR(25),
     OrgUnitNameAlt1                                                   CHAR(230),
     OrgUnitShortAlt1                                                  CHAR(25),
     OrgUnitNameAlt2                                                   CHAR(230),
     OrgUnitShortAlt2                                                  CHAR(25),
     OrgUnitNameAlt3                                                   CHAR(230),
     OrgUnitShortAlt3                                                  CHAR(25)
     )\g


CREATE TABLE OrgUnitGroup
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitGroupID                                                    SMALLINT NOT NULL DEFAULT 0,
     OrgUnitGroupName                                                  CHAR(230) NOT NULL,
     OrgUnitGroupDescription                                           LONGBLOB
     )\g


CREATE TABLE OrgUnitGroupMember
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitGroupID                                                    SMALLINT NOT NULL DEFAULT 0,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0
     )\g


CREATE TABLE OrgUnitGroupSet
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitGroupSetID                                                 SMALLINT NOT NULL DEFAULT 0,
     OrgUnitGroupSetName                                               CHAR(230) NOT NULL,
     OrgUnitGroupSetDescription                                        LONGBLOB
     )\g


CREATE TABLE OrgUnitGroupSetMember
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitGroupSetID                                                 SMALLINT NOT NULL,
     OrgUnitGroupID                                                    SMALLINT NOT NULL
     )\g


CREATE TABLE OrgUnitStructureOU1
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     OrgUnit1                                                          CHAR(230) NOT NULL,
     OU1Short                                                          CHAR(25) NOT NULL,
     OrgUnitComment                                                    CHAR(230),
     DateOpen                                                          INT NOT NULL,
     DateClose                                                         INT NOT NULL
     )\g


CREATE TABLE OrgUnitStructureOU2
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     OrgUnit1                                                          CHAR(230) NOT NULL,
     OU1Short                                                          CHAR(25) NOT NULL,
     OrgUnit2                                                          CHAR(230) NOT NULL,
     OU2Short                                                          CHAR(25) NOT NULL,
     OrgUnitComment                                                    CHAR(230),
     DateOpen                                                          INT NOT NULL,
     DateClose                                                         INT NOT NULL
     )\g


CREATE TABLE OrgUnitStructureOU3
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     OrgUnit1                                                          CHAR(230) NOT NULL,
     OU1Short                                                          CHAR(25) NOT NULL,
     OrgUnit2                                                          CHAR(230) NOT NULL,
     OU2Short                                                          CHAR(25) NOT NULL,
     OrgUnit3                                                          CHAR(230) NOT NULL,
     OU3Short                                                          CHAR(25) NOT NULL,
     OrgUnitComment                                                    CHAR(230),
     DateOpen                                                          INT NOT NULL,
     DateClose                                                         INT NOT NULL
     )\g


CREATE TABLE OrgUnitStructureOU4
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     OrgUnit1                                                          CHAR(230) NOT NULL,
     OU1Short                                                          CHAR(25) NOT NULL,
     OrgUnit2                                                          CHAR(230) NOT NULL,
     OU2Short                                                          CHAR(25) NOT NULL,
     OrgUnit3                                                          CHAR(230) NOT NULL,
     OU3Short                                                          CHAR(25) NOT NULL,
     OrgUnit4                                                          CHAR(230) NOT NULL,
     OU4Short                                                          CHAR(25) NOT NULL,
     OrgUnitComment                                                    CHAR(230),
     DateOpen                                                          INT NOT NULL,
     DateClose                                                         INT NOT NULL
     )\g


CREATE TABLE OrgUnitStructureOU5
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     OrgUnit1                                                          CHAR(230) NOT NULL,
     OU1Short                                                          CHAR(25) NOT NULL,
     OrgUnit2                                                          CHAR(230) NOT NULL,
     OU2Short                                                          CHAR(25) NOT NULL,
     OrgUnit3                                                          CHAR(230) NOT NULL,
     OU3Short                                                          CHAR(25) NOT NULL,
     OrgUnit4                                                          CHAR(230) NOT NULL,
     OU4Short                                                          CHAR(25) NOT NULL,
     OrgUnit5                                                          CHAR(230) NOT NULL,
     OU5Short                                                          CHAR(25) NOT NULL,
     OrgUnitComment                                                    CHAR(230),
     DateOpen                                                          INT NOT NULL,
     DateClose                                                         INT NOT NULL
     )\g


CREATE TABLE OrgUnitStructureOU6
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     OrgUnit1                                                          CHAR(230) NOT NULL,
     OU1Short                                                          CHAR(25) NOT NULL,
     OrgUnit2                                                          CHAR(230) NOT NULL,
     OU2Short                                                          CHAR(25) NOT NULL,
     OrgUnit3                                                          CHAR(230) NOT NULL,
     OU3Short                                                          CHAR(25) NOT NULL,
     OrgUnit4                                                          CHAR(230) NOT NULL,
     OU4Short                                                          CHAR(25) NOT NULL,
     OrgUnit5                                                          CHAR(230) NOT NULL,
     OU5Short                                                          CHAR(25) NOT NULL,
     OrgUnit6                                                          CHAR(230) NOT NULL,
     OU6Short                                                          CHAR(25) NOT NULL,
     OrgUnitComment                                                    CHAR(230),
     DateOpen                                                          INT NOT NULL,
     DateClose                                                         INT NOT NULL
     )\g


CREATE TABLE OrgUnitStructureOU7
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     OrgUnit1                                                          CHAR(230) NOT NULL,
     OU1Short                                                          CHAR(25) NOT NULL,
     OrgUnit2                                                          CHAR(230) NOT NULL,
     OU2Short                                                          CHAR(25) NOT NULL,
     OrgUnit3                                                          CHAR(230) NOT NULL,
     OU3Short                                                          CHAR(25) NOT NULL,
     OrgUnit4                                                          CHAR(230) NOT NULL,
     OU4Short                                                          CHAR(25) NOT NULL,
     OrgUnit5                                                          CHAR(230) NOT NULL,
     OU5Short                                                          CHAR(25) NOT NULL,
     OrgUnit6                                                          CHAR(230) NOT NULL,
     OU6Short                                                          CHAR(25) NOT NULL,
     OrgUnit7                                                          CHAR(230),
     OU7Short                                                          CHAR(25),
     OrgUnitComment                                                    CHAR(230),
     DateOpen                                                          INT NOT NULL,
     DateClose                                                         INT NOT NULL
     )\g


CREATE TABLE OrgUnitStructureOU8
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     OrgUnit1                                                          CHAR(230) NOT NULL,
     OU1Short                                                          CHAR(25) NOT NULL,
     OrgUnit2                                                          CHAR(230) NOT NULL,
     OU2Short                                                          CHAR(25) NOT NULL,
     OrgUnit3                                                          CHAR(230) NOT NULL,
     OU3Short                                                          CHAR(25) NOT NULL,
     OrgUnit4                                                          CHAR(230) NOT NULL,
     OU4Short                                                          CHAR(25) NOT NULL,
     OrgUnit5                                                          CHAR(230) NOT NULL,
     OU5Short                                                          CHAR(25) NOT NULL,
     OrgUnit6                                                          CHAR(230) NOT NULL,
     OU6Short                                                          CHAR(25) NOT NULL,
     OrgUnit7                                                          CHAR(230),
     OU7Short                                                          CHAR(25),
     OrgUnit8                                                          CHAR(230) NOT NULL,
     OU8Short                                                          CHAR(25),
     OrgUnitComment                                                    CHAR(230),
     DateOpen                                                          INT NOT NULL,
     DateClose                                                         INT NOT NULL
     )\g


CREATE TABLE RoutineDataOU1
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumber                                                       REAL,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Verified                                                          SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230),
     KEY (OrgUnitID, DataElementID, DataPeriodID)
     )\g


CREATE TABLE RoutineDataOU2
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumber                                                       REAL,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Verified                                                          SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230),
     KEY (OrgUnitID, DataElementID, DataPeriodID)
     )\g


CREATE TABLE RoutineDataOU3
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumber                                                       REAL,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Verified                                                          SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230),
     KEY (OrgUnitID, DataElementID, DataPeriodID)
     )\g


CREATE TABLE RoutineDataOU4
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumber                                                       REAL,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Verified                                                          SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230),
     KEY (OrgUnitID, DataElementID, DataPeriodID)
     )\g


CREATE TABLE RoutineDataOU5
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumber                                                       REAL,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Verified                                                          SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230),
     KEY (OrgUnitID, DataElementID, DataPeriodID)
     )\g


CREATE TABLE RoutineDataOU6
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumber                                                       REAL,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Verified                                                          SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230),
     KEY (OrgUnitID, DataElementID, DataPeriodID)
     )\g


CREATE TABLE RoutineDataOU7
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumber                                                       REAL,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Verified                                                          SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230),
     KEY (OrgUnitID, DataElementID, DataPeriodID)
     )\g


CREATE TABLE RoutineDataOU8
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     DataPeriodID                                                      SMALLINT NOT NULL DEFAULT 0,
     EntryNumber                                                       REAL,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Verified                                                          SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230),
     KEY (OrgUnitID, DataElementID, DataPeriodID)
     )\g


CREATE TABLE SemiPermanentData
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     ValidFrom                                                         INT NOT NULL DEFAULT "1/1/1994",
     ValidTo                                                           INT NOT NULL DEFAULT "12/31/9999",
     EntryText                                                         CHAR(230),
     EntryYesNo                                                        SMALLINT,
     EntryNumber                                                       REAL,
     EntryDate                                                         INT,
     EntryMemo                                                         LONGBLOB,
     EntryObject                                                       LONGBLOB,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Verified                                                          SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230),
     KEY (OrgUnitID, DataElementID, ValidFrom, ValidTo)
     )\g


CREATE TABLE SurveyAuditData
     (
     DataSourceID                                                      SMALLINT NOT NULL DEFAULT 1,
     OrgUnitID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataSetID                                                         SMALLINT NOT NULL DEFAULT 0,
     DataElementID                                                     SMALLINT NOT NULL DEFAULT 0,
     ValidFrom                                                         INT NOT NULL DEFAULT "1/1/1994",
     ValidTo                                                           INT NOT NULL DEFAULT "12/31/9999",
     EntryText                                                         CHAR(230),
     EntryYesNo                                                        SMALLINT,
     EntryNumber                                                       REAL,
     EntryDate                                                         INT,
     EntryMemo                                                         LONGBLOB,
     EntryObject                                                       LONGBLOB,
     _Check                                                            SMALLINT NOT NULL DEFAULT 0,
     Verified                                                          SMALLINT NOT NULL DEFAULT 0,
     Comment                                                           CHAR(230),
     KEY (OrgUnitID, DataSetID, DataElementID)
     )\g


CREATE TABLE tblMetaData_ComponentJoining
     (
     FactComponentID                                                   INT NOT NULL,
     FactJoinField                                                     CHAR(255),
     JoinExpression                                                    CHAR(255),
     DimensionComponentID                                              INT NOT NULL,
     DimensionJoinField                                                CHAR(50),
     KEY (DimensionComponentID),
     KEY (FactComponentID),
     KEY (FactComponentID),
     KEY (DimensionComponentID),
     PRIMARY KEY (FactComponentID, DimensionComponentID)
     )\g


CREATE TABLE tblMetaData_QueryComponent
     (
     ComponentID                                                       INT NOT NULL AUTO_INCREMENT,
     ComponentName                                                     CHAR(50) NOT NULL,
     Component                                                         CHAR(50) NOT NULL,
     SortOrder                                                         SMALLINT,
     ParameterFieldSource                                              CHAR(255),
     ParameterField                                                    CHAR(50),
     PeriodField                                                       CHAR(50),
     PeriodFrequency                                                   CHAR(50),
     NumeratorValueField                                               CHAR(50),
     NumeratorAggregationField                                         CHAR(50),
     DenominatorValueField                                             CHAR(50),
     DenominatorAggregationField                                       CHAR(50),
     UnitField                                                         CHAR(50),
     ComponentDescription                                              CHAR(255),
     FactComponentInd                                                  TINYINT,
     TimeDimensionInd                                                  TINYINT,
     KEY (Component),
     KEY (ComponentID),
     KEY (ComponentName),
     KEY (NumeratorAggregationField),
     KEY (DenominatorAggregationField),
     KEY (NumeratorValueField),
     KEY (DenominatorValueField),
     PRIMARY KEY (ComponentID)
     )\g


CREATE TABLE tblReport
     (
     ReportID                                                          INT NOT NULL AUTO_INCREMENT,
     ReportName                                                        CHAR(255) NOT NULL,
     ReportDescription                                                 LONGBLOB,
     DataTable                                                         CHAR(255),
     ReportBaseComponentID                                             INT,
     ReportCriteriaField                                               CHAR(255),
     ReportCriteria                                                    CHAR(255),
     ReportCriteriaAdditional                                          CHAR(255),
     DefaultFactComponentID                                            INT,
     ReportWizardTemplateName                                          CHAR(255),
     DateAdded                                                         DATETIME,
     CrossTabColumnHeading                                             CHAR(255),
     DisplayOrder                                                      SMALLINT,
     KEY (ReportBaseComponentID),
     KEY (DefaultFactComponentID),
     KEY (DefaultFactComponentID),
     PRIMARY KEY (ReportID),
     KEY (ReportName),
     KEY (ReportBaseComponentID),
     KEY (ReportID)
     )\g


CREATE TABLE tblReportCrosstabRowHeading
     (
     ReportID                                                          INT NOT NULL DEFAULT 0,
     RowHeadingField                                                   CHAR(255) NOT NULL,
     DisplayOrder                                                      SMALLINT,
     KEY (ReportID),
     PRIMARY KEY (ReportID, RowHeadingField),
     KEY (ReportID)
     )\g


CREATE TABLE tblReportElement
     (
     ReportElementID                                                   INT NOT NULL AUTO_INCREMENT,
     ReportID                                                          INT NOT NULL,
     ElementOrder                                                      INT,
     FactComponentID                                                   INT,
     ElementBase                                                       CHAR(255),
     ElementDescriptor                                                 CHAR(255),
     NamedPeriodParameterID                                            INT,
     WHERE_Additional                                                  LONGBLOB,
     GroupByTotal                                                      CHAR(255),
     sqlA                                                              LONGBLOB,
     sqlB                                                              LONGBLOB,
     sqlGrandTotal                                                     LONGBLOB,
     GrandTotal                                                        TINYINT,
     KEY (FactComponentID),
     KEY (ReportID),
     KEY (NamedPeriodParameterID),
     KEY (FactComponentID),
     KEY (NamedPeriodParameterID),
     PRIMARY KEY (ReportElementID),
     KEY (ReportElementID),
     KEY (ReportID)
     )\g


CREATE TABLE tblReportElementExpression
     (
     ExpressionOrder                                                   INT NOT NULL AUTO_INCREMENT,
     ReportElementID                                                   INT NOT NULL,
     Expression                                                        CHAR(255),
     AggregationPrescribed                                             TINYINT,
     AliasName                                                         CHAR(255),
     AggregateRounding                                                 SMALLINT,
     AggregateCriteriaOperator                                         CHAR(50),
     AggregateCriteria                                                 CHAR(255),
     FormatValue                                                       CHAR(255),
     KEY (ReportElementID),
     PRIMARY KEY (ExpressionOrder),
     KEY (ReportElementID)
     )\g


CREATE TABLE tblReportElementFROM
     (
     ReportElementID                                                   INT NOT NULL,
     DimensionComponentID                                              INT NOT NULL,
     KEY (ReportElementID),
     KEY (DimensionComponentID),
     KEY (ReportElementID),
     KEY (DimensionComponentID),
     PRIMARY KEY (ReportElementID, DimensionComponentID)
     )\g


CREATE TABLE tblReportElementGroupBy
     (
     GroupByOrder                                                      INT NOT NULL AUTO_INCREMENT,
     ReportElementID                                                   INT NOT NULL,
     GroupBy                                                           CHAR(255) NOT NULL,
     GroupByComponentID                                                INT NOT NULL,
     Display                                                           TINYINT,
     KEY (ReportElementID),
     KEY (GroupByComponentID),
     KEY (GroupByComponentID),
     PRIMARY KEY (GroupByOrder),
     KEY (ReportElementID)
     )\g


CREATE TABLE tblReportElementSorting
     (
     ReportElementID                                                   INT NOT NULL DEFAULT 0,
     DataTableField                                                    CHAR(255) NOT NULL,
     SortOrder                                                         INT NOT NULL AUTO_INCREMENT,
     KEY (ReportElementID),
     PRIMARY KEY (ReportElementID, DataTableField),
     KEY (ReportElementID),
     KEY (SortOrder)
     )\g


CREATE TABLE tblReportNamedPeriod
     (
     NamedPeriodID                                                     INT NOT NULL AUTO_INCREMENT,
     NamedPeriod                                                       CHAR(255) NOT NULL,
     PeriodPointIDFrom                                                 INT NOT NULL,
     PeriodPointIDTo                                                   INT NOT NULL,
     KEY (PeriodPointIDTo),
     KEY (PeriodPointIDFrom),
     KEY (NamedPeriod),
     KEY (NamedPeriodID),
     KEY (PeriodPointIDFrom),
     KEY (PeriodPointIDTo),
     PRIMARY KEY (NamedPeriodID)
     )\g


CREATE TABLE tblReportPeriodPoint
     (
     PeriodPointID                                                     INT NOT NULL AUTO_INCREMENT,
     PeriodPoint                                                       CHAR(255) NOT NULL,
     BaseDate                                                          DATETIME,
     DateBasedOnPeriodPointID                                          INT,
     PeriodsToAdd                                                      INT,
     PeriodsToAddType                                                  CHAR(50),
     BaseDateFormat                                                    CHAR(255),
     KEY (PeriodsToAddType),
     KEY (DateBasedOnPeriodPointID),
     KEY (DateBasedOnPeriodPointID),
     KEY (PeriodPointID),
     KEY (PeriodPoint),
     PRIMARY KEY (PeriodPointID)
     )\g


CREATE TABLE tlkDataMart
     (
     AliasName                                                         CHAR(255),
     SourceTables                                                      CHAR(255),
     FieldName                                                         CHAR(255),
     EntryText                                                         CHAR(255)
     )\g


CREATE TABLE tlkDatePart
     (
     DatePart                                                          CHAR(50) NOT NULL,
     DatePartDescription                                               CHAR(50),
     PRIMARY KEY (DatePart)
     )\g


CREATE TABLE tmpDataDuplicates
     (
     DataDuplicatesRowID                                               INT NOT NULL AUTO_INCREMENT,
     PRIMARY KEY (DataDuplicatesRowID)
     )\g