SQLite format 3@ oK-ntableDB_APPROLESDB_APPROLESCREATE TABLE DB_APPROLES ( ROLE_NAME VARCHAR (128) COLLATE NOCASE, ROLE_PWD VARCHAR (128) COLLATE NOCASE, ROLE_TYPE INTEGER, ENCRYPTED INTEGER ),##tableDB_ADMROLESDB_ADMROLESCREATE TABLE DB_ADMROLES ( ROLE_NAME VARCHAR (128) COLLATE NOCASE, ROLE_PWD VARCHAR (128) COLLATE NOCASE, ENCRYPTED INTEGER )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)677 tableAPPLICATION_PARAMETERAPPLICATION_PARAMETERCREATE TABLE APPLICATION_PARAMETER ( PARAM_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, PARAMETER VARCHAR (128) NOT NULL COLLATE NOCASE, PARAM_VALUE VARCHAR (255) COLLATE NOCASE, USER_LOGIN_IhFbC\>U9O3H.E(B&?$;"8 52/-*&#!      USERS#USER_GROUPS GROUPS# DX_SETTINGS +!MDCS_MXAC_ADMINMXAC_ADMIN -MDCS_MXAC_COMMON-MDCS_MXAC_COMMON'MDCS_MXAC_APPMXAC_APP MDCS \ [B##KtableDB_APPROLESDB_APPROLESCREATE TABLE DB_APPROLES ( B##KtableDB_APPROLESDB_APPROLESCREATE TABLE DB_APPROLES ( ROLE_NAME VARCHAR (128) COLLATE NOCASE, ROLE_PWD VARCHAR (128) COLLATE NOCASE, ROLE_TYPE INTEGER, ENCRYPTED INTEGER ),##tableDB_ADMROLESDB_ADMROLESCREATE TABLE DB_ADMROLES ( ROLE_NAME VARCHAR (128) COLLATE NOCASE, ROLE_PWD VARCHAR (128) COLLATE NOCASE, ENCRYPTED INTEGER )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)677 tableAPPLICATION_PARAMETERAPPLICATION_PARAMETERCREATE TABLE APPLICATION_PARAMETER ( PARAM_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, PARAMETER VARCHAR (128) NOT NULL COLLATE NOCASE, PARAM_VALUE VARCHAR (255) COLLATE NOCASE, USER_LOGIN_ID INTEGER )i##tableAPP_VER_DX2APP_VER_DX2CREATE TABLE APP_VER_DX2 ( PRODUCT VARCHAR (128) COLLATE NOCASE ) ;$.$ {%%9tableDX_ABF_FILESDX_ABF_FILES CREATE TABLE DX_ABF_FILES ( ABF_FILEID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, PROJECTID INTEGER, SCREENID INTEGER, EXPERIMENTID INTEGER, CELL_PROC S##mtableDB_VERSIONSDB_VERSIONS CREATE TABLE DB_VERSIONS ( DB_VERSION_ID INTEGER NOT NULL, DB_VER_PARAM1 VARCHAR (2) NOT NULL COLLATE NOCASE, DB_VER_PARAM2 VARCHAR (2) NOT NULL COLLATE NOCASE, DB_VER_PARAM3 VARCHAR (2) NOT NULL COLLATE NOCASE, PRIMARY KEY ( DB_VERSION_ID ) )4CtableDB_IDSDB_IDSCREATE TABLE DB_IDS ( SITE_ID INTEGER NOT NULL DEFAULT 1, SITE_NAME VARCHAR (4) COLLATE NOCASE, PRIMARY KEY ( SITE_ID ) )##KtableDB_APPROLESDB_APPROLESCREATE TABLE DB_APPROLES ( ROLE_NAME VARCHAR (128) COLLATE NOCASE, ROLE_PWD VARCHAR (128) COLLATE NOCASE, ROLE_TYPE INTEGER, ENCRYPTED INTEGER )  100  EDUREID INTEGER, USER_LOGIN_ID INTEGER, FILE_SIZE INTEGER, PROGRAM_NAME VARCHAR (50) COLLATE NOCASE, PROGRAM_VERSION VARCHAR (50) COLLATE NOCASE, USER_NAME VARCHAR (75) COLLATE NOCASE, FILE_NAME VARCHAR (300) COLLATE NOCASE, GUID_NAME VARCHAR (100) COLLATE NOCASE, CREATION_DATE INTEGER, CREATION_TIME INTEGER, IMPORT_DATE INTEGER, IMPORT_TIME INTEGER, TRIAL_NUM SMALLINT, TRIAL_START_TIME INTEGER, TRIAL_COMPOUND VARCHAR (100) COLLATE NOCASE, TRIAL_CONCENTRATION FLOAT, PROTOCOL VARCHAR (260) COLLATE NOCASE, ACQUISITION_TYPE VARCHAR (50) COLLATE NOCASE, ACQUISITION_PROGRAM VARCHAR (50) COLLATE NOCASE, ACQUISITION_VERSION VARCHAR (20) COLLATE NOCASE, ANALOG_BANDWIDTH FLOAT, HARDWARE_FILTER FLOAT, SUSPECT BIT, ACQUISITION_MODE VARCHAR (50) COLLATE NOCASE, STOPWATCH INTEGER, SAMPLING_INTERVAL INTEGER, AMPLIFIER_MODE VARCHAR (25) COLLATE NOCASE, PCLAMP_ID1 FLOAT, PCLAMP_ID2 FLOAT, PCLAMP_ID3 FLOAT, LEAK BIT, USER_LIST BIT, DIGITAL_OUTPUT BIT, EXTERNAL_TAGS BIT, NUMBER_SWEEPS INTEGER, PRE_SWEEP_TRAIN BIT, SHAPE_STATISTICS BIT, MATH_SIGNAL BIT, HOLDING_LEVEL FLOAT, HOLDING_LEVEL2 FLOAT, FILE_COMMENT VARCHAR (512) COLLATE NOCASE, INPUT_SIGNAL VARCHAR (256) COLLATE NOCASE, OUTPUT_SIGNAL VARCHAR (256) COLLATE NOCASE, TRIAL_DURATION INTEGER, TEMPERATURE FLOAT, MEMBRANE_CAP FLOAT, CM_COMPENSATION FLOAT, RA_VALUE FLOAT, RM_VALUE FLOAT, FILE_STATUS SMALLINT, DUMMY_TRIAL BIT, VERSION_NUM SMALLINT, NUM_VERSIONS SMALLINT, FOREIGN KEY ( CELL_PROCEDUREID ) REFERENCES DX_CELL_PROCEDURES (CELL_PROCEDUREID) )  JJB & 11wtableDX_CELL_PROCEDURESDX_CELL_PROCEDURESCREATE TABLE DX_CELL_PROCEDURES ( CELL_PROCEDUREID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, PROJECTID INTEGER, SCREENID INTEGER, EXPERIMENTID INTEGER, USER_LOGIN_ID INTEGER, CELL_PROCEDURE_NAME VARCHAR (100) COLLATE NOCASE, START_TIME INTEGER, KEY_COMPOUND VARCHAR (100) COLLATE NOCASE, KEY_CONCENTRATION FLOAT, CHAMBER_NUM SMALLINT, SUSPECT_DATA BIT,z +++tableDX_ABF_VERSIONSDX_ABF_VERSIONSCREATE TABLE DX_ABF_VERSIONS ( ABF_VERID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ABF_FILEID INTEGER, VERSION_NUM SMALLINT, GUID_NAME VARCHAR (100) COLLATE NOCASE, USER_LOGIN_ID INTEGER, CREATION_DATE INTEGER, CREATION_TIME INTEGER, DESCRIPTION VARCHAR (256) COLLATE NOCASE )  FILE_SIZE INTEGER, PROGRAM_TYPE INTEGER, USER_NAME VARCHAR (75) COLLATE NOCASE, FILE_NAME VARCHAR (300) COLLATE NOCASE, GUID_NAME VARCHAR (100) COLLATE NOCASE, CREATION_DATE INTEGER, CREATION_TIME INTEGER, IMPORT_DATE INTEGER, IMPORT_TIME INTEGER, CELL_RUPTURE_TIME INTEGER, SEALCHIP_LOT VARCHAR (20) COLLATE NOCASE, SOLN_SETNAME VARCHAR (256) COLLATE NOCASE, SOLN_JUNCTION_POT FLOAT, SOLN_COMMENT VARCHAR (256) COLLATE NOCASE, SOLN_ICNAME VARCHAR (256) COLLATE NOCASE, SOLN_ICADJUSTED_WITH VARCHAR (256) COLLATE NOCASE, SOLN_ICPH FLOAT, SOLN_ICOSMOLARITY FLOAT, SOLN_ICCHEMICALS VARCHAR (2048) COLLATE NOCASE, SOLN_ECNAME VARCHAR (256) COLLATE NOCASE, SOLN_ECADJUSTED_WITH VARCHAR (256) COLLATE NOCASE, SOLN_ECPH FLOAT, SOLN_ECOSMOLARITY FLOAT, SOLN_ECCHEMICALS VARCHAR (2048) COLLATE NOCASE, CELL_TYPE VARCHAR (50) COLLATE NOCASE, CELL_DESCRIPTION VARCHAR (512) COLLATE NOCASE, CELL_CHANNEL_TYPE VARCHAR (50) COLLATE NOCASE, CELL_SUBTYPE1 VARCHAR (30) COLLATE NOCASE, CELL_SUBTYPE2 VARCHAR (30) COLLATE NOCASE, CELL_SUBTYPE3 VARCHAR (30) COLLATE NOCASE, CELL_SUBTYPE4 VARCHAR (30) COLLATE NOCASE, CELL_SUBTYPE5 VARCHAR (30) COLLATE NOCASE, FILE_STATUS SMALLINT, FLAGS SMALLINT, SEALCHIP_NUMBER SMALLINT, CELLPROC_INDEX INTEGER, PROCEDURE_GUID VARCHAR (100) COLLATE NOCASE, CELLEXP_INDEX INTEGER, CELL_SPLITTIME VARCHAR (50) COLLATE NOCASE, TIME_CELLSADDED FLOAT, TIME_CELLDETECTED FLOAT, TIME_GIGASEAL FLOAT, TIME_WHOLECELL FLOAT, TIME_CELLDIED FLOAT, TIME_FINISHED FLOAT, RE_VALUE FLOAT, CROSS_TALK FLOAT, HOLE_STATUS SMALLINT, CE_VALUE FLOAT, FROZEN_RSEAL FLOAT, MAX_RSEAL FLOAT, RSEAL_PRESSURE FLOAT, WHOLE_CELL SMALLINT, WC_PRESSURE FLOAT, RA_INITIAL FLOAT, RA_FINAL FLOAT, RA_MIN FLOAT, RA_MAX FLOAT, RM_INITIAL FLOAT, RM_FINAL FLOAT, RM_MIN FLOAT, RM_MAX FLOAT, CM_AVERAGE FLOAT, CM_STDDEV FLOAT, AVERAGE_NOISE FLOAT, KEYCOMPOUND_PLATE VARCHAR (50) COLLATE NOCASE, CELL_BATCH_NUMBER VARCHAR (50) COLLATE NOCASE, CELL_DATE_PREPARED VARCHAR (50) COLLATE NOCASE, BUFFER_A_NAME VARCHAR (50) COLLATE NOCASE, BUFFER_A_CONCENTRATION FLOAT, BUFFER_B_NAME VARCHAR (50) COLLATE NOCASE, BUFFER_B_CONCENTRATION FLOAT )  INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, CELL_PROCEDUREID INTEGER NOT NULL, ABF_FILEID INTEGER, COMPOUND_NAME VARCHAR (50) COLLATE NOCASE, CONCENTRATION FLOAT, TIME_ADDED INTEGER, SWEEP_NUM SMALLINT NOT NULL, COLUMN_NUM SMALLINT, ROW_NUM SMALLINT, PLATE_ID VARCHAR (25) COLLATE NOCASE, SUCTION BIT, COMPOUND_VOLUME FLOAT, PLATE_LOCATION SMALLINT, STEP_TYPE SMALLINT, COMPOUND_GROUP VARCHAR (50) COLLATE NOCASE, COMPOUND_INDEX SMALLINT, BATCH VARCHAR (50) COLLATE NOCASE, LOT VARCHAR (50) COLLATE NOCASE, SALT_CODE VARCHAR (50) COLLATE NOCASE, FLOW_RATE FLOAT, DURATION INTEGER, INITIAL_DURATION INTEGER, INITIAL_FLOW_RATE FLOAT, CUSTOM_DATA VARCHAR (256) COLLATE NOCASE ) P:PHg ==atableDX_DATASET_SHARED_GROUPSDX_DATASET_SHARED_GROUPSCREATE TABLE DX_DATASET_SHARED_GROUPS ( SHARE_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, DATASETID INTEGER NOT NULL, GROUP_ID INTEGER NOT NULL )U 55MtableDX_DATASET_ABF_LISTSDX_DATASET_ABF_LISTSCREATE TABLE DX_DATASET_ABF_LISTS ( DATASET_LISTID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, DATASETID INTEGER NOT NULL, ABF_FILEID INTEGER NOT NULL, VERSION_NUM SMALLINT, FOREIGN KEY ( DATASETID ) REFERENCES DX_DATASETS (DATASETID) ) 777tableDX_COMPOUND_ADDITIONSDX_COMPOUND_ADDITIONSCREATE TABLE DX_COMPOUND_ADDITIONS ( ROW_ID     | ))QtableDX_DEFAULT_IDSDX_DEFAULT_IDSCREATE TABLE DX_DEFAULT_IDS ( DEFAULTID INTEGER, TABLE_NAME VARCHAR (50) COLLATE NOCASE )##ItableDX_DATASETSDX_DATASETSCREATE TABLE DX_DATASETS ( DATASETID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, PROJECTID INTEGER, SCREENID INTEGER, PARENT_DATASETID INTEGER, USER_LOGIN_ID INTEGER, DATASET_NAME VARCHAR (64) COLLATE NOCASE, DESCRIPTION VARCHAR (256) COLLATE NOCASE, CREATION_INFO VARCHAR (1024) COLLATE NOCASE, CREATION_DATE INTEGER, CREATION_TIME INTEGER, STATUS SMALLINT, LAST_USED_DATE INTEGER, LAST_USED_TIME INTEGER, SESSION_ID INTEGER, TEST_COMPOUND VARCHAR (128) COLLATE NOCASE )  PERIMENT_TIME INTEGER, EXPERIMENT_COMMENT VARCHAR (200) COLLATE NOCASE, PLATE1_ID VARCHAR (25) COLLATE NOCASE, PLATE2_ID VARCHAR (25) COLLATE NOCASE, PLATE3_ID VARCHAR (25) COLLATE NOCASE, PLATE4_ID VARCHAR (25) COLLATE NOCASE, INTRACELLULAR_SOLUTION VARCHAR (75) COLLATE NOCASE, INTRACELLULAR_CONCENTRATION FLOAT, INTRACELLULAR_DESCRIPTION VARCHAR (512) COLLATE NOCASE, EXTRACELLULAR_SOLUTION VARCHAR (75) COLLATE NOCASE, EXTRACELLULAR_CONCENTRATION FLOAT, EXTRACELLULAR_DESCRIPTION VARCHAR (512) COLLATE NOCASE, CELL_TYPE VARCHAR (50) COLLATE NOCASE, CELL_DESCRIPTION VARCHAR (512) COLLATE NOCASE, CHANNEL_TYPE VARCHAR (50) COLLATE NOCASE, EXPERIMENT_STATUS SMALLINT, GUID_NAME VARCHAR (100) COLLATE NOCASE, FILE_SIZE INTEGER, FILE_NAME VARCHAR (300) COLLATE NOCASE, IMPORT_DATE INTEGER, IMPORT_TIME INTEGER, SEALCHIPLOT1 VARCHAR (25) COLLATE NOCASE, SEALCHIPLOT2 VARCHAR (25) COLLATE NOCASE, SEALCHIPLOT3 VARCHAR (25) COLLATE NOCASE, FILE_STATUS SMALLINT, PICKUP_MIX BIT, DELIVERY_MIX BIT, MIXING_CYCLES SMALLINT, MIX_DEAD_VOLUME INTEGER, DELIVERY_X_OFFSET FLOAT, DELIVERY_Z_OFFSET FLOAT, WASH_STATION_HEIGHT FLOAT, ACQUISITION_PROGRAM VARCHAR (50) COLLATE NOCASE, ACQUISITION_VERSION VARCHAR (50) COLLATE NOCASE, ACQ_SETTINGS_FILE VARCHAR (260) COLLATE NOCASE, SUCTION_IN_DELIVERY FLOAT, PLTLOC_1_WELLCOUNT INTEGER, PLTLOC_1_ID VARCHAR (260) COLLATE NOCASE, PLTLOC_1_COMPOUND_LAYOUT VARCHAR (100) COLLATE NOCASE, PLTLOC_1_VOLUME FLOAT, PLTLOC_1_BOTTOM_HEIGHT FLOAT, PLTLOC_1_TOP_HEIGHT FLOAT, PLTLOC_1_WELL_VOLUME INTEGER, PLTLOC_1_MANUFACTURER VARCHAR (256) COLLATE NOCASE, PLTLOC_1_CATNUM VARCHAR (256) COLLATE NOCASE, PLTLOC_1_MATERIAL VARCHAR (256) COLLATE NOCASE, PLTLOC_1_COMMENT VARCHAR (512) COLLATE NOCASE, PLTLOC_2_WELLCOUNT INTEGER, PLTLOC_2_ID VARCHAR (260) COLLATE NOCASE, PLTLOC_2_COMPOUND_LAYOUT VARCHAR (100) COLLATE NOCASE, PLTLOC_2_VOLUME FLOAT, PLTLOC_2_BOTTOM_HEIGHT FLOAT, PLTLOC_2_TOP_HEIGHT FLOAT, PLTLOC_2_WELL_VOLUME INTEGER, PLTLOC_2_MANUFACTURER VARCHAR (256) COLLATE NOCASE, PLTLOC_2_CATNUM VARCHAR (256) COLLATE NOCASE, PLTLOC_2_MATERIAL VARCHAR (256) COLLATE NOCASE, PLTLOC_2_COMMENT VARCHAR (512) COLLATE NOCASE, PLTLOC_3_WELLCOUNT INTEGER, PLTLOC_3_ID VARCHAR (260) COLLATE NOCASE, PLTLOC_3_COMPOUND_LAYOUT VARCHAR (100) COLLATE NOCASE, PLTLOC_3_VOLUME FLOAT, PLTLOC_3_BOTTOM_HEIGHT FLOAT, PLTLOC_3_TOP_HEIGHT FLOAT, PLTLOC_3_WELL_VOLUME INTEGER, PLTLOC_3_MANUFACTURER VARCHAR (256) COLLATE NOCASE, PLTLOC_3_CATNUM VARCHAR (256) COLLATE NOCASE, PLTLOC_3_MATERIAL VARCHAR (256) COLLATE NOCASE, PLTLOC_3_COMMENT VARCHAR (512) COLLATE NOCASE, PLTLOC_4_WELLCOUNT INTEGER, PLTLOC_4_ID VARCHAR (260) COLLATE NOCASE, PLTLOC_4_COMPOUND_LAYOUT VARCHAR (100) COLLATE NOCASE, PLTLOC_4_VOLUME FLOAT, PLTLOC_4_BOTTOM_HEIGHT FLOAT, PLTLOC_4_TOP_HEIGHT FLOAT, PLTLOC_4_WELL_VOLUME INTEGER, PLTLOC_4_MANUFACTURER VARCHAR (256) COLLATE NOCASE, PLTLOC_4_CATNUM VARCHAR (256) COLLATE NOCASE, PLTLOC_4_MATERIAL VARCHAR (256) COLLATE NOCASE, PLTLOC_4_COMMENT VARCHAR (512) COLLATE NOCASE ) **"?))9tableDX_EXPERIMENTSDX_EXPERIMENTSCREATE TABLE DX_EXPERIMENTS ( EXPERIMENTID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, PROJECTID INTEGER, SCREENID INTEGER, EXPERIMENT_NAME VARCHAR (50) COLLATE NOCASE, ACQUISITION_COMPUTER VARCHAR (50) COLLATE NOCASE, INSTRUMENT_MODEL VARCHAR (20) COLLATE NOCASE, INSTRUMENT_SERIAL VARCHAR (50) COLLATE NOCASE, INSTRUMENT_NAME VARCHAR (20) COLLATE NOCASE, OPERATOR_NAME VARCHAR (50) COLLATE NOCASE, PROCEDURE_NAME VARCHAR (50) COLLATE NOCASE, EXPERIMENT_DATE INTEGER, EX  g==atableDX_PROJECT_SHARED_GROUPSDX_PROJECT_SHARED_GROUPS$CREATE TABLE DX_PROJECT_SHARED_GROUPS ( SHARE_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, PROJECTID INTEGER NOT NULL, GROUP_ID INTEGER NOT NULL )^tableDX_FILESDX_FILES"CREATE TABLE DX_FILES ( FILEID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, PROGRAM_TYPE INTEGER, FILE_TYPE INTEGER, FILE_EXTENSION VARCHAR (10) COLLATE NOCASE, FILE_TITLE VARCHAR (100) COLLATE NOCASE, FILE_DESCRIPTION VARCHAR (100) COLLATE NOCASE, ORIG_FILENAME_PATH VARCHAR (512) COLLATE NOCASE, GUID_NAME VARCHAR (100) COLLATE NOCASE, USER_LOGIN_ID INTEGER, CREATION_DATE INTEGER, CREATION_TIME INTEGER, CHECK_SUM VARCHAR (50) COLLATE NOCASE )   F))AtableDX_RESULT_SETSDX_RESULT_SETS(CREATE TABLE DX_RESULT_SETS ( RESULT_SETID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, RESULT_SETNAME VARCHAR (50) COLLATE NOCASE, DATASETID INTEGER, CREATION_DATE INTEGER, CREATION_TIME INTEGER, ANALYSISID INTEGER, STATUS SMALLINT, FILE_DATA_ID INTEGER, CREATOR_ID INTEGER )O33EtableDX_RESULT_SET_FILESDX_RESULT_SET_FILES'CREATE TABLE DX_RESULT_SET_FILES ( RSFID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, RESULT_SETID INTEGER, FILEID INTEGER )e##tableDX_PROJECTSDX_PROJECTS%CREATE TABLE DX_PROJECTS ( PROJECTID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, PROJECT_NAME VARCHAR (100) COLLATE NOCASE, GROUP_ID INTEGER DEFAULT 1 )    !!tableDX_SCREENSDX_SCREENS+CREATE TABLE DX_SCREENS ( SCREENID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, PROJECTID INTEGER, SCREEN_NAME VARCHAR (100) COLLATE NOCASE, FOREIGN KEY ( PROJECTID ) REFERENCES DX_PROJECTS (PROJECTID) )`;;WtableDX_SCREEN_SHARED_GROUPSDX_SCREEN_SHARED_GROUPS)CREATE TABLE DX_SCREEN_SHARED_GROUPS ( SHARE_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, SCREENID INTEGER NOT NULL, GROUP_ID INTEGER NOT NULL )     s//tableDX_SEARCH_REGIONSDX_SEARCH_REGIONS,CREATE TABLE DX_SEARCH_REGIONS ( SEARCH_REGIONID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, REGION_NAME VARCHAR (256) NOT NULL COLLATE NOCASE, TRIAL_NUM INTEGER NOT NULL, REGION_TYPE SMALLINT NOT NULL, START_REGION FLOAT, END_REGION FLOAT, TRACE_NUM INTEGER, EPOCH INTEGER, WAVEFORM SMALLINT DEFAULT 0, RESULT_SETID INTEGER )  k##tableDX_SETTINGSDX_SETTINGS0CREATE TABLE DX_SETTINGS ( SETTINGID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, SETTING_NAME VARCHAR (255) COLLATE NOCASE, SETTING_VALUE VARCHAR (255) COLLATE NOCASE ) 11CtableDX_SESSION_LOGGINGDX_SESSION_LOGGING.CREATE TABLE DX_SESSION_LOGGING ( LOG_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, SESSION_ID INTEGER NOT NULL, DATASETID INTEGER, EVENT_DATE INTEGER, EVENT_TIME INTEGER, EVENT_CODE INTEGER, EVENT_DESCRIPTION VARCHAR (512) COLLATE NOCASE, EVENT_COMMENT VARCHAR (255) COLLATE NOCASE, STOP_WATCH INTEGER, PROJECTID INTEGER, SCREENID INTEGER ) %FDACompliant0  Pg--tableDX_USER_SESSIONSDX_USER_SESSIONS3CREATE TABLE DX_USER_SESSIONS ( SESSION_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, USER_LOGIN_ID INTEGER, PROGRAM_ID INTEGER, START_DATE INTEGER, START_TIME INTEGER, END_DATE INTEGER, END_TIME INTEGER, COMPUTER_NAME VARCHAR (255) COLLATE NOCASE )--- tableDX_SHEET_RESULTSDX_SHEET_RESULTS1CREATE TABLE DX_SHEET_RESULTS ( RESULTID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, SHEETID INTEGER NOT NULL, SEQNUM INTEGER NOT NULL, NAME VARCHAR (255) COLLATE NOCASE, DESCRIPTION VARCHAR (1024) COLLATE NOCASE, DATA_SIZE INTEGER, RESULT_DATA VARCHAR (4000) COLLATE NOCASE, RESULT_SETID INTEGER )   ))!s??utableDX_VALFILES_SHARED_GROUPSDX_VALFILES_SHARED_GROUPS6CREATE TABLE DX_VALFILES_SHARED_GROUPS ( SHARE_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, FILE_GROUPID INTEGER NOT NULL, GROUP_ID INTEGER NOT NULL )^11gtableDX_VAL_GROUP_FILESDX_VAL_GROUP_FILES4CREATE TABLE DX_VAL_GROUP_FILES ( VAL_FILEID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, FILE_GROUPID INTEGER NOT NULL, FILEID INTEGER NOT NULL )   vvn!L ''WtableFILE_LOCATIONFILE_LOCATION9CREATE TABLE FILE_LOCATION ( LOCATION_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, SERVER_NAME VARCHAR (256) COLLATE NOCASE, SERVER_ROOT VARCHAR (256) COLLATE NOCASE, SERVER_PORT INTEGER, DIRECTORY VARCHAR (256) COLLATE NOCASE, LOCATION_TYPE INTEGER )8;;tableDX_VALIDATE_FILE_GROUPSDX_VALIDATE_FILE_GROUPS7CREATE TABLE DX_VALIDATE_FILE_GROUPS ( FILE_GROUPID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, FILE_GROUP_TYPE INTEGER, USER_LOGIN_ID INTEGER, GROUP_NAME VARCHAR (100) COLLATE NOCASE, DESCRIPTION VARCHAR (100) COLLATE NOCASE, IMPORTED_DATE INTEGER, IMPORTED_TIME INTEGER, LAST_MODIFIED_DATE INTEGER, LAST_MODIFIED_TIME INTEGER, VALIDATED_DATE INTEGER, VALIDATED_TIME INTEGER, STATUS SMALLINT )   --%#^"''{tableGROUP_OBJECTSGROUP_OBJECTSCREATE TABLE GROUPS ( GROUP_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, GROUP_NAME VARCHAR (128) NOT NULL COLLATE NOCASE, GROUP_DESC VARCHAR (255) COLLATE NOCASE, IS_USER INTEGER, TIME_CREATED DATETIME NOT NULL, CREATOR_ID INTEGER, TO_DELETE INTEGER NOT NULL DEFAULT 0 )n''{tableGROUP_OBJECTSGROUP_OBJECTS%33#tableUSER_DATA_LOCATIONSUSER_DATA_LOCATIONSACREATE TABLE USER_DATA_LOCATIONS ( DATA_LOC_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, LOCATION_ID INTEGER NOT NULL, USER_LOGIN_ID INTEGER NOT NULL, TYPE INTEGER NOT NULL DEFAULT 0, FOREIGN KEY ( LOCATION_ID ) REFERENCES LOCATION_OPTIONS (LOCATION_ID), FOREIGN KEY ( USER_LOGIN_ID ) REFERENCES USERS (USER_LOGIN_ID) )    ?59saSystem Administrator2017-07-13 10:24:43.36 66(O%GindexDX_ABF_FILES_FK_CPID_DX_ABF_FILESDX_ABF_FILESFCREATE INDEX DX_ABF_FILES_FK_CPID_DX_ABF_FILES ON DX_ABF_FILES ( CELL_PROCEDUREID DESC )-'9tableUSERSUSERSDCREATE TABLE USERS ( USER_LOGIN_ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, LOGIN VARCHAR (50) NOT NULL COLLATE NOCASE, NAME VARCHAR (128) COLLATE NOCASE, DESCR VARCHAR (255) COLLATE NOCASE, USER_PERMISSIONS INTEGER, TO_DELETE INTEGER NOT NULL DEFAULT 0, PRIMARY_GROUP_ID INTEGER, TIME_CREATED DATETIME NOT NULL, CREATOR_ID INTEGER, PASSWORD VARCHAR (256) COLLATE NOCASE, LAST_LOGON_TIME INTEGER, LAST_LOGON_DATE INTEGER, LAST_LOGOFF_TIME INTEGER, LAST_LOGOFF_DATE INTEGER, PASSWORD_HINT VARCHAR (1024) COLLATE NOCASE, PASSWORD_EXPIRY_DATE INTEGER )   ,h?,6.i1_indexDX_CELL_PROCEDURES_FK_PRJID_DX_CELL_PROCEDURESDX_CELL_PROCEDURESMCREATE INDEX DX_CELL_PROCEDURES_FK_PRJID_DX_CELL_PROCEDURES ON DX_CELL_PROCEDURES ( PROJECTID DESC )9-i1eindexDX_CELL_PROCEDURES_FK_EXPID_DX_CELL_PROCEDURESDX_CELL_PROCEDURESLCREATE INDEX DX_CELL_PROCEDURES_FK_EXPID_DX_CELL_PROCEDURES ON DX_CELL_PROCEDURES ( EXPERIMENTID DESC ),S+EindexDX_ABF_VERSIONS_FK1_DX_ABF_VERSIONSDX_ABF_VERSIONSKCREATE INDEX DX_ABF_VERSIONS_FK1_DX_ABF_VERSIONS ON DX_ABF_VERSIONS ( ABF_FILEID DESC )+Q%9indexDX_ABF_FILES_FK_SCRID_DX_ABF_FILESDX_ABF_FILESJCREATE INDEX DX_ABF_FILES_FK_SCRID_DX_ABF_FILES ON DX_ABF_FILES ( SCREENID DESC )*Q%;indexDX_ABF_FILES_FK_PRJID_DX_ABF_FILESDX_ABF_FILESICREATE INDEX DX_ABF_FILES_FK_PRJID_DX_ABF_FILES ON DX_ABF_FILES ( PROJECTID DESC ))Q%AindexDX_ABF_FILES_FK_EXPID_DX_ABF_FILESDX_ABF_FILESGCREATE INDEX DX_ABF_FILES_FK_EXPID_DX_ABF_FILES ON DX_ABF_FILES ( EXPERIMENTID DESC )       HxX3=indexDX_DATASET_SHARED_GROUPS_FK_DSID_DX_DATASET_SHARED_GROUPSDX_DATASET_SHARED_GROUPSSCREATE INDEX DX_DATASET_SHARED_GROUPS_FK_DSID_DX_DATASET_SHARED_GROUPS ON DX_DATASET_SHARED_GROUPS ( DATASETID DESC )@2o5iindexDX_DATASET_ABF_LISTS_FX_DSID_DX_DATASET_ABF_LISTSDX_DATASET_ABF_LISTSRCREATE INDEX DX_DATASET_ABF_LISTS_FX_DSID_DX_DATASET_ABF_LISTS ON DX_DATASET_ABF_LISTS ( DATASETID DESC )C1q5mindexDX_DATASET_ABF_LISTS_FX_ABFID_DX_DATASET_ABF_LISTSDX_DATASET_ABF_LISTSQCREATE INDEX DX_DATASET_ABF_LISTS_FX_ABFID_DX_DATASET_ABF_LISTS ON DX_DATASET_ABF_LISTS ( ABF_FILEID DESC )M0s7}indexDX_COMPOUND_ADDITIONS_FK_CPID_DX_COMPOUND_ADDITIONSDX_COMPOUND_ADDITIONSPCREATE INDEX DX_COMPOUND_ADDITIONS_FK_CPID_DX_COMPOUND_ADDITIONS ON DX_COMPOUND_ADDITIONS ( CELL_PROCEDUREID DESC )5/i1]indexDX_CELL_PROCEDURES_FK_SCRID_DX_CELL_PROCEDURESDX_CELL_PROCEDURESNCREATE INDEX DX_CELL_PROCEDURES_FK_SCRID_DX_CELL_PROCEDURES ON DX_CELL_PROCEDURES ( SCREENID DESC )      b#E#`7Y)GindexDX_EXPERIMENTS_FK_PRJID_DX_EXPERIMENTSDX_EXPERIMENTSXCREATE INDEX DX_EXPERIMENTS_FK_PRJID_DX_EXPERIMENTS ON DX_EXPERIMENTS ( PROJECTID DESC )6?#)indexDX_DATASETS_IX_SESSION_IDDX_DATASETSWCREATE INDEX DX_DATASETS_IX_SESSION_ID ON DX_DATASETS ( SESSION_ID DESC ) 5M#3indexDX_DATASETS_FK_SCRID_DX_DATASETSDX_DATASETSVCREATE INDEX DX_DATASETS_FK_SCRID_DX_DATASETS ON DX_DATASETS ( SCREENID DESC ) 4M#5indexDX_DATASETS_FK_PRJID_DX_DATASETSDX_DATASETSTCREATE INDEX DX_DATASETS_FK_PRJID_DX_DATASETS ON DX_DATASETS ( PROJECTID DESC ) =indexDX_DATASET_SHARED[9=indexDX_PROJECT_SHARED_GROUPS_FK_PRJID_DX_PROJECT_SHARED_GROUPSDX_PROJECT_SHARED_GROUPSZCREATE INDEX DX_PROJECT_SHARED_GROUPS_FK_PRJID_DX_PROJECT_SHARED_GROUPS ON DX_PROJECT_SHARED_GROUPS ( PROJECTID DESC )8Y)EindexDX_EXPERIMENTS_FK_SCRID_DX_EXPERIMENTSDX_EXPERIMENTSYCREATE INDEX DX_EXPERIMENTS_FK_SCRID_DX_EXPERIMENTS ON DX_EXPERIMENTS ( SCREENID DESC )       ee*<W)EindexDX_RESULT_SETS_FK_DSID_DX_RESULT_SETSDX_RESULT_SETS^CREATE INDEX DX_RESULT_SETS_FK_DSID_DX_RESULT_SETS ON DX_RESULT_SETS ( DATASETID DESC )=;k3iindexDX_RESULT_SET_FILES_FK_RSID_DX_RESULT_SET_FILESDX_RESULT_SET_FILES]CREATE INDEX DX_RESULT_SET_FILES_FK_RSID_DX_RESULT_SET_FILES ON DX_RESULT_SET_FILES ( RESULT_SETID DESC );:o3aindexDX_RESULT_SET_FILES_FK_FILEID_DX_RESULT_SET_FILESDX_RESULT_SET_FILES[CREATE INDEX DX_RESULT_SET_FILES_FK_FILEID_DX_RESULT_SET_FILES ON DX_RESULT_SET_FILES ( FILEID DESC ),=indexDX_PROJECT_SHARED_GROUPS_FK_z>=!#indexDX_SCREENS_FK_DX_SCREENSDX_SCREENS`CREATE INDEX DX_SCREENS_FK_DX_SCREENS ON DX_SCREENS ( PROJECTID DESC )S=};{indexDX_SCREEN_SHARED_GROUPS_FK_SCRID_DX_SCREEN_SHARED_GROUPSDX_SCREEN_SHARED_GROUPS_CREATE INDEX DX_SCREEN_SHARED_GROUPS_FK_SCRID_DX_SCREEN_SHARED_GROUPS ON DX_SCREEN_SHARED_GROUPS ( SCREENID DESC )      |L.|/Ce1UindexDX_VAL_GROUP_FILES_FX_FID_DX_VAL_GROUP_FILESDX_VAL_GROUP_FILESfCREATE INDEX DX_VAL_GROUP_FILES_FX_FID_DX_VAL_GROUP_FILES ON DX_VAL_GROUP_FILES ( FILEID DESC )7Bg1cindexDX_VAL_GROUP_FILES_FX_FGID_DX_VAL_GROUP_FILESDX_VAL_GROUP_FILESeCREATE INDEX DX_VAL_GROUP_FILES_FX_FGID_DX_VAL_GROUP_FILES ON DX_VAL_GROUP_FILES ( FILE_GROUPID DESC )+A_-WindexDX_SHEET_RESULTS_FK_RSID_DX_SHEET_RESULTSDX_SHEET_RESULTSdCREATE INDEX DX_SHEET_RESULTS_FK_RSID_DX_SHEET_RESULTS ON DX_SHEET_RESULTS ( RESULT_SETID DESC )3@e1]indexDX_SESSION_LOGGING_FK_SID_DX_SESSION_LOGGINGDX_SESSION_LOGGINGcCREATE INDEX DX_SESSION_LOGGING_FK_SID_DX_SESSION_LOGGING ON DX_SESSION_LOGGING ( SESSION_ID DESC )1?c/]indexDX_SEARCH_REGIONS_FK_RSID_DX_SEARCH_REGIONSDX_SEARCH_REGIONSaCREATE INDEX DX_SEARCH_REGIONS_FK_RSID_DX_SEARCH_REGIONS ON DX_SEARCH_REGIONS ( RESULT_SETID DESC )      N i z]GO!9indexFILES_DATA_IX_FILES_DATA_LOCATIONFILES_DATAkCREATE INDEX FILES_DATA_IX_FILES_DATA_LOCATION ON FILES_DATA ( LOCATION_ID DESC )FG!-indexFILES_DATA_IX_FILES_DATA_GUIDFILES_DATAjCREATE INDEX FILES_DATA_IX_FILES_DATA_GUID ON FILES_DATA ( GUID_NAME DESC )TEy;indexDX_VALIDATE_FILE_GROUPS_FX_UID_DX_VALIDATE_FILE_GROUPSDX_VALIDATE_FILE_GROUPSiCREATE INDEX DX_VALIDATE_FILE_GROUPS_FX_UID_DX_VALIDATE_FILE_GROUPS ON DX_VALIDATE_FILE_GROUPS ( USER_LOGIN_ID DESC )bD? indexDX_VALFILES_SHARED_GROUPS_FK_FGID_DX_VALFILES_SHARED_GROUPSDX_VALFILES_SHARED_GROUPSgCREATE INDEX DX_VALFILES_SHARED_GROUPS_FK_FGID_DX_VALFILES_SHARED_GROUPS ON DX_VALFILES_SHARED_GROUPS ( FILE_GROUPID DESC )e1Uindex H['KindexGROUP_OBJECTS_IX_GROUP_OBJECTS_LOCATIONGROUP_OBJECTSlCREATE INDEX GROUP_OBJECTS_IX_GROUP_OBJECTS_LOCATION ON GROUP_OBJECTS ( LOCATION_ID DESC )      oJA#cindexUSER_GROUPS_IX_USER_GROUPSUSER_GROUPSoCREATE UNIQUE INDEX USER_GROUPS_IX_USER_GROUPS ON USER_GROUPS ( USER_LOGIN_ID DESC, GROUP_ID DESC )*IW3WindexUSER_DATA_LOCATIONS_IX_USER_LOCATIONSUSER_DATA_LOCATIONSmCREATE INDEX USER_DATA_LOCATIONS_IX_USER_LOCATIONS ON USER_DATA_LOCATIONS ( USER_LOGIN_ID DESC ) H['KindexGROUP_OBJECTS_IX_GROUP_OBJECTS_LOCATIONGROUP_OBJECTSlCREATE INDEX GROUP_OBJECTS_IX_GROUP_OBJECTS_LOCATION ON GROUP_OBJECTS ( LOCATION_ID DESC )GO!9indexFILES_DATA_IX_FILES_DATA_LOCATIONFILES_DATAkCREATE INDEX FILES_DATA_IX_FILES_DATA_LOCATION ON FILES_DATA ( LOCATION_ID DESC )