diff options
| author | Roy Ben-Shabat <Roy@Twine-s.com> | 2018-08-02 18:58:54 +0300 |
|---|---|---|
| committer | Roy Ben-Shabat <Roy@Twine-s.com> | 2018-08-02 18:58:54 +0300 |
| commit | 6d54a5d28753a675cca9bb57549dbc75986be118 (patch) | |
| tree | 20654ce74d8f1ee0e036f8f1f1aa0292e3ee3aba /Software | |
| parent | 5efe56d0d4b2f4acd8cc275670955d68b7e196cf (diff) | |
| download | Tango-6d54a5d28753a675cca9bb57549dbc75986be118.tar.gz Tango-6d54a5d28753a675cca9bb57549dbc75986be118.zip | |
Working on SQL Examiner Library...
Diffstat (limited to 'Software')
44 files changed, 4997 insertions, 0 deletions
diff --git a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj new file mode 100644 index 000000000..1343686d3 --- /dev/null +++ b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj @@ -0,0 +1,1470 @@ +<SqlDataExaminer version="21"> + <Sources> + <Source id="1"> + <EngineType>MsSqlServer</EngineType> + <StorageType>LiveDb</StorageType> + <ServerName>localhost\sqlexpress</ServerName> + <Database>Tango</Database> + <WinAuth>False</WinAuth> + <AzurePwd>False</AzurePwd> + <Login>Synchronizer</Login> + <Password>Aa123456</Password> + <SavePasswords>true</SavePasswords> + </Source> + <Source id="2"> + <EngineType>MsSqlServer</EngineType> + <StorageType>LiveDb</StorageType> + <ServerName>twine.local\sqltwine</ServerName> + <Database>Tango</Database> + <WinAuth>True</WinAuth> + <AzurePwd>False</AzurePwd> + </Source> + </Sources> + <Items> + <Item name="dbo.ACTION_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.ADDRESSES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="ADDRESS_STRING" /> + <Column name="LOCALITY" /> + <Column name="COUNTRY" /> + <Column name="CITY" /> + <Column name="STATE" /> + <Column name="COUNTRY_CODE" /> + <Column name="POSTAL_CODE" /> + </Columns> + </Item> + <Item name="dbo.APPLICATION_DISPLAY_PANEL_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.APPLICATION_FIRMWARE_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.APPLICATION_OS_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.APPLICATION_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.BRUSH_STOPS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="SEGMENT_GUID" /> + <Column name="COLOR_SPACE_GUID" /> + <Column name="OFFSET_PERCENT" /> + <Column name="STOP_INDEX" /> + <Column name="CYAN" /> + <Column name="MAGENTA" /> + <Column name="YELLOW" /> + <Column name="BLACK" /> + <Column name="RED" /> + <Column name="GREEN" /> + <Column name="BLUE" /> + <Column name="L" /> + <Column name="A" /> + <Column name="B" /> + <Column name="V0" /> + <Column name="V1" /> + <Column name="V2" /> + <Column name="V3" /> + <Column name="V4" /> + <Column name="V5" /> + <Column name="V6" /> + <Column name="V7" /> + <Column name="CORRECTED" /> + <Column name="COLOR_CATALOG_GUID" /> + <Column name="COLOR_CATALOG_CODE" /> + </Columns> + </Item> + <Item name="dbo.CARTRIDGE_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.CATS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="MACHINE_GUID" /> + <Column name="RML_GUID" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="DATA" /> + </Columns> + </Item> + <Item name="dbo.CCTS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="FORWARD_FILE_NAME" /> + <Column name="INVERSE_FILE_NAME" /> + <Column name="FORWARD_DATA" /> + <Column name="INVERSE_DATA" /> + <Column name="VERSION" /> + <Column name="RML_GUID" /> + </Columns> + </Item> + <Item name="dbo.COLOR_CATALOGS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="COLOR_SPACE_GUID" /> + <Column name="COLOR_CODE" /> + <Column name="NAME" /> + <Column name="COLOR_GROUP" /> + <Column name="CYAN" /> + <Column name="MAGENTA" /> + <Column name="YELLOW" /> + <Column name="BLACK" /> + <Column name="RED" /> + <Column name="GREEN" /> + <Column name="BLUE" /> + <Column name="L" /> + <Column name="A" /> + <Column name="B" /> + <Column name="V0" /> + <Column name="V1" /> + <Column name="V2" /> + <Column name="V3" /> + <Column name="V4" /> + <Column name="V5" /> + <Column name="V6" /> + <Column name="V7" /> + </Columns> + </Item> + <Item name="dbo.COLOR_SPACES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.CONFIGURATIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CREATION_DATE" /> + <Column name="APPLICATION_VERSION_GUID" /> + <Column name="APPLICATION_OS_VERSION_GUID" /> + <Column name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + </Columns> + </Item> + <Item name="dbo.CONTACTS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="FIRST_NAME" /> + <Column name="LAST_NAME" /> + <Column name="FULL_NAME" /> + <Column name="EMAIL" /> + <Column name="PHONE_NUMBER" /> + <Column name="FAX" /> + </Columns> + </Item> + <Item name="dbo.CUSTOMERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="ORGANIZATION_GUID" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.DISPENSER_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="NL_PER_PULSE" /> + <Column name="CAPACITY" /> + </Columns> + </Item> + <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.EVENT_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="EVENT_TYPES_CATEGORY_GUID" /> + <Column name="EVENT_TYPES_GROUP_GUID" /> + <Column name="REQUIRES_USER_INTERVENTION" /> + <Column name="HTML_PAGE_GUID" /> + <Column name="RESOLVABLE" /> + </Columns> + </Item> + <Item name="dbo.EVENT_TYPES_ACTIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="EVENT_TYPE_GUID" /> + <Column name="ACTION_TYPE_GUID" /> + </Columns> + </Item> + <Item name="dbo.EVENT_TYPES_CATEGORIES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.EVENT_TYPES_GROUPS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.FIBER_SHAPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.FIBER_SYNTHS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_DANCER_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_DANCERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_DANCER_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="GRADUAL" /> + <Column name="K" /> + <Column name="X" /> + <Column name="PULSE_PER_MM_SPRING" /> + <Column name="MAXIMAL_MOVEMENT_MM" /> + <Column name="ZERO_POINT" /> + <Column name="RESOLUTION_BITS" /> + <Column name="ARM_LENGTH" /> + <Column name="ASSEMBLY_DIRECTION_RIGHT" /> + <Column name="ACCELERATE_ON_TENSION_RAISE" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="SUPPORTS_HOMING" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_MOTORS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_MOTOR_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="MIN_FREQUENCY" /> + <Column name="MAX_FREQUENCY" /> + <Column name="SET_MICRO_STEP" /> + <Column name="MICRO_STEP" /> + <Column name="MAX_CHANGE_SLOPE" /> + <Column name="HIGH_LENGTH_MICRO_SECOND" /> + <Column name="SPEED_MASTER" /> + <Column name="PULSE_PER_ROUND" /> + <Column name="PULLEY_RADIUS" /> + <Column name="CONFIG_WORD" /> + <Column name="DIRECTION_THREAD_WIZE" /> + <Column name="KVAL_HOLD" /> + <Column name="KVAL_RUN" /> + <Column name="KVAL_ACC" /> + <Column name="KVAL_DEC" /> + <Column name="OVER_CURRENT_THRESHOLD" /> + <Column name="STALL_THRESHOLD" /> + <Column name="THERMAL_COMPENSATION_FACTOR" /> + <Column name="LOW_SPEED_OPTIMIZATION" /> + <Column name="ST_SLP" /> + <Column name="INT_SPD" /> + <Column name="FN_SLP_ACC" /> + <Column name="FN_SLP_DEC" /> + <Column name="FS_SPD" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_PID_CONTROLS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_PID_CONTROL_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="OUTPUT_PROPORTIONAL_POWER_LIMIT" /> + <Column name="OUTPUT_PROPORTIONAL_BAND" /> + <Column name="INTEGRAL_TIME" /> + <Column name="DERIVATIVE_TIME" /> + <Column name="SENSOR_CORRECTION_ADJUSTMENT" /> + <Column name="SENSOR_MIN_VALUE" /> + <Column name="SENSOR_MAX_VALUE" /> + <Column name="SET_POINT_RAMP_RATEOR_SOFT_START_RAMP" /> + <Column name="SET_POINT_CONTROL_OUTPUT_RATE" /> + <Column name="CONTROL_OUTPUT_TYPE" /> + <Column name="SSR_CONTROL_OUTPUT_TYPE" /> + <Column name="OUTPUT_ON_OFF_HYSTERESIS_VALUE" /> + <Column name="PROCESS_VARIABLE_SAMPLING_RATE" /> + <Column name="PV_INPUT_FILTER_FACTOR_MODE" /> + <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" /> + <Column name="AC_HEATERS__HALF_CYCLE_TIME" /> + <Column name="PROPORTIONAL_GAIN" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_SPEED_SENSORS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_SPEED_SENSOR_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="RESOLUTION_BITS" /> + <Column name="PERIMETER" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_WINDER_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_WINDERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_WINDER_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="MILLIMETER_PER_ROTATION" /> + </Columns> + </Item> + <Item name="dbo.HTML_PAGES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="HTML" /> + </Columns> + </Item> + <Item name="dbo.IDS_PACK_FORMULAS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="AUTO_CALCULATED" /> + </Columns> + </Item> + <Item name="dbo.IDS_PACKS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CONFIGURATION_GUID" /> + <Column name="DISPENSER_TYPE_GUID" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="CARTRIDGE_TYPE_GUID" /> + <Column name="MID_TANK_TYPE_GUID" /> + <Column name="IDS_PACK_FORMULA_GUID" /> + <Column name="NAME" /> + <Column name="PACK_INDEX" /> + <Column name="IS_EMPTY" /> + </Columns> + </Item> + <Item name="dbo.JOB_RUNS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="JOB_GUID" /> + <Column name="START_DATE" /> + <Column name="END_DATE" /> + <Column name="SUCCESSFUL" /> + </Columns> + </Item> + <Item name="dbo.JOBS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CREATION_DATE" /> + <Column name="LAST_RUN" /> + <Column name="MACHINE_GUID" /> + <Column name="USER_GUID" /> + <Column name="RML_GUID" /> + <Column name="WINDING_METHOD_GUID" /> + <Column name="SPOOL_TYPE_GUID" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="INTER_SEGMENT_LENGTH" /> + <Column name="ENABLE_INTER_SEGMENT" /> + <Column name="ENABLE_LUBRICATION" /> + <Column name="JOB_INDEX" /> + <Column name="ESTIMATED_DURATION_MILI" /> + <Column name="HAS_EMBROIDERY_FILE" /> + <Column name="EMBROIDERY_FILE_DATA" /> + <Column name="EMBROIDERY_FILE_NAME" /> + <Column name="EMBROIDERY_JPEG" /> + <Column name="STATUS" /> + <Column name="COLOR_SPACE_GUID" /> + <Column name="NUMBER_OF_UNITS" /> + <Column name="TYPE" /> + <Column name="CUSTOMER_GUID" /> + <Column name="SPOOLS_DISTRIBUTION" /> + <Column name="NUMBER_OF_HEADS" /> + <Column name="SAMPLE_UNITS_OR_METERS" /> + <Column name="FINE_TUNING_STATUS" /> + <Column name="FINE_TUNING_APPROVE_DATE" /> + <Column name="SAMPLE_DYE_STATUS" /> + <Column name="SAMPLE_DYE_APPROVE_DATE" /> + <Column name="EDITING_STATE" /> + <Column name="LENGTH_PERCENTAGE_FACTOR" /> + </Columns> + </Item> + <Item name="dbo.LINEAR_MASS_DENSITY_UNITS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.LIQUID_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="VERSION" /> + <Column name="COLOR" /> + </Columns> + </Item> + <Item name="dbo.LIQUID_TYPES_RMLS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="RML_GUID" /> + <Column name="MAX_NL_PER_CM" /> + </Columns> + </Item> + <Item name="dbo.MACHINE_STUDIO_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="FTP_FILE_PATH" /> + <Column name="COMMENTS" /> + <Column name="USER_GUID" /> + <Column name="FORCE_UPDATE" /> + </Columns> + </Item> + <Item name="dbo.MACHINE_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + <Column name="DEFAULT_CONFIGURATION_GUID" /> + </Columns> + </Item> + <Item name="dbo.MACHINES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="SERIAL_NUMBER" /> + <Column name="NAME" /> + <Column name="PRODUCTION_DATE" /> + <Column name="ORGANIZATION_GUID" /> + <Column name="MACHINE_VERSION_GUID" /> + <Column name="CONFIGURATION_GUID" /> + <Column name="ENABLE_EXTERNAL_BRIDGE" /> + <Column name="EXTERNAL_BRIDGE_PASSWORD" /> + <Column name="DEFAULT_RML_GUID" /> + <Column name="TARGET_JOB_TYPES" /> + <Column name="DEFAULT_COLOR_SPACE_GUID" /> + <Column name="DEFAULT_SEGMENT_LENGTH" /> + <Column name="DEFAULT_SPOOL_TYPE_GUID" /> + <Column name="SYNCHED" /> + </Columns> + </Item> + <Item name="dbo.MACHINES_CONFIGURATIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="MACHINE_GUID" /> + <Column name="CONFIGURATION_GUID" /> + </Columns> + </Item> + <Item name="dbo.MACHINES_EVENTS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HOST_NAME" /> + <Column name="MACHINE_GUID" /> + <Column name="EVENT_TYPE_GUID" /> + <Column name="USER_GUID" /> + <Column name="DATE_TIME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.MACHINES_EVENTS_VIEW" type="view"> + <Columns> + <Column name="DATE" /> + <Column name="MACHINE" /> + <Column name="USER_NAME" /> + <Column name="GROUP" /> + <Column name="CATEGORY" /> + <Column name="TYPE" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.MEDIA_COLORS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="L" /> + <Column name="A" /> + <Column name="B" /> + </Columns> + </Item> + <Item name="dbo.MEDIA_CONDITIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.MEDIA_MATERIALS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.MEDIA_PURPOSES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.MID_TANK_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="LITER_CAPACITY" /> + </Columns> + </Item> + <Item name="dbo.ORGANIZATIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CONTACT_GUID" /> + <Column name="ADDRESS_GUID" /> + </Columns> + </Item> + <Item name="dbo.PERMISSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.PROCESS_PARAMETERS_TABLES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="DYEING_SPEED" /> + <Column name="MIN_INK_UPTAKE" /> + <Column name="FEEDER_TENSION" /> + <Column name="PULLER_TENSION" /> + <Column name="WINDER_TENSION" /> + <Column name="MIXER_TEMP" /> + <Column name="HEAD_ZONE1_TEMP" /> + <Column name="HEAD_ZONE2_TEMP" /> + <Column name="HEAD_ZONE3_TEMP" /> + <Column name="HEAD_ZONE4_TEMP" /> + <Column name="HEAD_ZONE5_TEMP" /> + <Column name="HEAD_ZONE6_TEMP" /> + <Column name="DRYER_AIR_FLOW" /> + <Column name="DRYER_ZONE1_TEMP" /> + <Column name="DRYER_ZONE2_TEMP" /> + <Column name="DRYER_ZONE3_TEMP" /> + <Column name="DRYER_BUFFER_LENGTH" /> + <Column name="HEAD_AIR_FLOW" /> + <Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" /> + <Column name="TABLE_INDEX" /> + </Columns> + </Item> + <Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="RML_GUID" /> + <Column name="NAME" /> + <Column name="ACTIVE" /> + <Column name="SAVE_DATE" /> + </Columns> + </Item> + <Item name="dbo.RMLS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="MANUFACTURER" /> + <Column name="CODE" /> + <Column name="MEDIA_MATERIAL_GUID" /> + <Column name="MEDIA_COLOR_GUID" /> + <Column name="MEDIA_PURPOSE_GUID" /> + <Column name="MEDIA_CONDITION_GUID" /> + <Column name="LINEAR_MASS_DENSITY_UNIT_GUID" /> + <Column name="FIBER_SHAPE_GUID" /> + <Column name="FIBER_SYNTH_GUID" /> + <Column name="FIBER_SIZE" /> + <Column name="NUMBER_OF_FIBERS" /> + <Column name="PLIES_PER_FIBER" /> + <Column name="PLIES_PER_THREAD" /> + <Column name="TWISTED" /> + <Column name="AIR_ENTANGLEMENT" /> + <Column name="LUBRICANT" /> + <Column name="TENSILE_STRENGTH" /> + <Column name="ELONGATION_AT_BREAK_PERCENTAGE" /> + <Column name="ESTIMATED_THREAD_DIAMETER" /> + </Columns> + </Item> + <Item name="dbo.ROLES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.ROLES_PERMISSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="ROLE_GUID" /> + <Column name="PERMISSION_GUID" /> + </Columns> + </Item> + <Item name="dbo.SEGMENTS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="JOB_GUID" /> + <Column name="LENGTH" /> + <Column name="SEGMENT_INDEX" /> + </Columns> + </Item> + <Item name="dbo.SPOOL_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="LENGTH" /> + <Column name="WEIGHT" /> + <Column name="DIAMETER" /> + <Column name="START_OFFSET_PULSES" /> + <Column name="BACKING_RATE" /> + <Column name="SEGMENT_OFFSET_PULSES" /> + <Column name="BOTTOM_BACKING_RATE" /> + <Column name="ROTATIONS_PER_PASSAGE" /> + </Columns> + </Item> + <Item name="dbo.SYNC_CONFIGURATIONS" type="table"> + <Columns> + <Column name="ID" key="true" /> + <Column name="TABLE_NAME" /> + <Column name="SYNC_TYPE" /> + </Columns> + </Item> + <Item name="dbo.TECH_CONTROLLERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="MIN" /> + <Column name="MAX" /> + <Column name="UNITS" /> + </Columns> + </Item> + <Item name="dbo.TECH_DISPENSERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.TECH_IOS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="PORT" /> + <Column name="TYPE" /> + <Column name="DESIGNATOR" /> + <Column name="ASM" /> + <Column name="INTERFACE_NAME" /> + <Column name="SENSOR" /> + <Column name="INIT_VALUE" /> + <Column name="AVERAGING" /> + <Column name="MIN" /> + <Column name="MAX" /> + </Columns> + </Item> + <Item name="dbo.TECH_MONITORS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="MIN" /> + <Column name="MAX" /> + <Column name="UNITS" /> + <Column name="POINTS_PER_FRAME" /> + <Column name="MULTI_CHANNEL" /> + <Column name="CHANNEL_COUNT" /> + </Columns> + </Item> + <Item name="dbo.TECH_VALVES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.USERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="EMAIL" /> + <Column name="PASSWORD" /> + <Column name="ORGANIZATION_GUID" /> + <Column name="CONTACT_GUID" /> + <Column name="ADDRESS_GUID" /> + <Column name="LAST_LOGIN" /> + </Columns> + </Item> + <Item name="dbo.USERS_ROLES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="USER_GUID" /> + <Column name="ROLE_GUID" /> + </Columns> + </Item> + <Item name="dbo.WINDING_METHODS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="Sync_Addresses" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="ADDRESS_STRING" /> + <Column name="LOCALITY" /> + <Column name="COUNTRY" /> + <Column name="CITY" /> + <Column name="STATE" /> + <Column name="COUNTRY_CODE" /> + <Column name="POSTAL_CODE" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT DISTINCT ADDRESSES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="ADDRESS_STRING" /> + <UpdateColumn name="LOCALITY" /> + <UpdateColumn name="COUNTRY" /> + <UpdateColumn name="CITY" /> + <UpdateColumn name="STATE" /> + <UpdateColumn name="COUNTRY_CODE" /> + <UpdateColumn name="POSTAL_CODE" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT DISTINCT ADDRESSES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="ADDRESS_STRING" /> + <UpdateColumn name="LOCALITY" /> + <UpdateColumn name="COUNTRY" /> + <UpdateColumn name="CITY" /> + <UpdateColumn name="STATE" /> + <UpdateColumn name="COUNTRY_CODE" /> + <UpdateColumn name="POSTAL_CODE" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_Configuration" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CREATION_DATE" /> + <Column name="APPLICATION_VERSION_GUID" /> + <Column name="APPLICATION_OS_VERSION_GUID" /> + <Column name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT CONFIGURATIONS.* +FROM CONFIGURATIONS +INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CREATION_DATE" /> + <UpdateColumn name="APPLICATION_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_OS_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <UpdateColumn name="HARDWARE_VERSION_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT CONFIGURATIONS.* +FROM CONFIGURATIONS +INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CREATION_DATE" /> + <UpdateColumn name="APPLICATION_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_OS_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <UpdateColumn name="HARDWARE_VERSION_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_Contacts" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="FIRST_NAME" /> + <Column name="LAST_NAME" /> + <Column name="FULL_NAME" /> + <Column name="EMAIL" /> + <Column name="PHONE_NUMBER" /> + <Column name="FAX" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT DISTINCT CONTACTS.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="FIRST_NAME" /> + <UpdateColumn name="LAST_NAME" /> + <UpdateColumn name="FULL_NAME" /> + <UpdateColumn name="EMAIL" /> + <UpdateColumn name="PHONE_NUMBER" /> + <UpdateColumn name="FAX" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT DISTINCT CONTACTS.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="FIRST_NAME" /> + <UpdateColumn name="LAST_NAME" /> + <UpdateColumn name="FULL_NAME" /> + <UpdateColumn name="EMAIL" /> + <UpdateColumn name="PHONE_NUMBER" /> + <UpdateColumn name="FAX" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_IdsPacks" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CONFIGURATION_GUID" /> + <Column name="DISPENSER_TYPE_GUID" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="CARTRIDGE_TYPE_GUID" /> + <Column name="MID_TANK_TYPE_GUID" /> + <Column name="IDS_PACK_FORMULA_GUID" /> + <Column name="NAME" /> + <Column name="PACK_INDEX" /> + <Column name="IS_EMPTY" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT IDS_PACKS.* + +FROM MACHINES + INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID + INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@' +]]></Text> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT IDS_PACKS.* + +FROM MACHINES + INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID + INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@' +]]></Text> + <UpdateTables> + <Table schema="dbo" name="IDS_PACKS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="CONFIGURATION_GUID" /> + <UpdateColumn name="DISPENSER_TYPE_GUID" /> + <UpdateColumn name="LIQUID_TYPE_GUID" /> + <UpdateColumn name="CARTRIDGE_TYPE_GUID" /> + <UpdateColumn name="MID_TANK_TYPE_GUID" /> + <UpdateColumn name="IDS_PACK_FORMULA_GUID" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="PACK_INDEX" /> + <UpdateColumn name="IS_EMPTY" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_Machine" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="SERIAL_NUMBER" /> + <Column name="NAME" /> + <Column name="PRODUCTION_DATE" /> + <Column name="ORGANIZATION_GUID" /> + <Column name="MACHINE_VERSION_GUID" /> + <Column name="CONFIGURATION_GUID" /> + <Column name="ENABLE_EXTERNAL_BRIDGE" /> + <Column name="EXTERNAL_BRIDGE_PASSWORD" /> + <Column name="DEFAULT_RML_GUID" /> + <Column name="TARGET_JOB_TYPES" /> + <Column name="DEFAULT_COLOR_SPACE_GUID" /> + <Column name="DEFAULT_SEGMENT_LENGTH" /> + <Column name="DEFAULT_SPOOL_TYPE_GUID" /> + <Column name="SYNCHED" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="SERIAL_NUMBER" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="PRODUCTION_DATE" /> + <UpdateColumn name="ORGANIZATION_GUID" /> + <UpdateColumn name="MACHINE_VERSION_GUID" /> + <UpdateColumn name="CONFIGURATION_GUID" /> + <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" /> + <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" /> + <UpdateColumn name="DEFAULT_RML_GUID" /> + <UpdateColumn name="TARGET_JOB_TYPES" /> + <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" /> + <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" /> + <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" /> + <UpdateColumn name="SYNCHED" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="SERIAL_NUMBER" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="PRODUCTION_DATE" /> + <UpdateColumn name="ORGANIZATION_GUID" /> + <UpdateColumn name="MACHINE_VERSION_GUID" /> + <UpdateColumn name="CONFIGURATION_GUID" /> + <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" /> + <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" /> + <UpdateColumn name="DEFAULT_RML_GUID" /> + <UpdateColumn name="TARGET_JOB_TYPES" /> + <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" /> + <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" /> + <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" /> + <UpdateColumn name="SYNCHED" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_Organization" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CONTACT_GUID" /> + <Column name="ADDRESS_GUID" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT ORGANIZATIONS.* + +FROM ORGANIZATIONS + +INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CONTACT_GUID" /> + <UpdateColumn name="ADDRESS_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT ORGANIZATIONS.* + +FROM ORGANIZATIONS + +INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CONTACT_GUID" /> + <UpdateColumn name="ADDRESS_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_UsersRoles" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="USER_GUID" /> + <Column name="ROLE_GUID" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT DISTINCT USERS_ROLES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="USER_GUID" /> + <UpdateColumn name="ROLE_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT DISTINCT USERS_ROLES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="USER_GUID" /> + <UpdateColumn name="ROLE_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + </Items> + <SchemaMapping> + <SMItem schema1="dbo" schema2="dbo" /> + </SchemaMapping> + <ProjectSettings> + <AllSettings> + <ComparisonCaseSensitive>1</ComparisonCaseSensitive> + <CompareTrimmedStrings>False</CompareTrimmedStrings> + <EmptyEqualsNull>False</EmptyEqualsNull> + <PrecedeStringConstWithNPrefix>0</PrecedeStringConstWithNPrefix> + <AutoSelectKeyColumns>0</AutoSelectKeyColumns> + <PerformanceOptions> + <PerformanceOption name="Auto" value="True" /> + </PerformanceOptions> + </AllSettings> + </ProjectSettings> +</SqlDataExaminer>
\ No newline at end of file diff --git a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj new file mode 100644 index 000000000..1343686d3 --- /dev/null +++ b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj @@ -0,0 +1,1470 @@ +<SqlDataExaminer version="21"> + <Sources> + <Source id="1"> + <EngineType>MsSqlServer</EngineType> + <StorageType>LiveDb</StorageType> + <ServerName>localhost\sqlexpress</ServerName> + <Database>Tango</Database> + <WinAuth>False</WinAuth> + <AzurePwd>False</AzurePwd> + <Login>Synchronizer</Login> + <Password>Aa123456</Password> + <SavePasswords>true</SavePasswords> + </Source> + <Source id="2"> + <EngineType>MsSqlServer</EngineType> + <StorageType>LiveDb</StorageType> + <ServerName>twine.local\sqltwine</ServerName> + <Database>Tango</Database> + <WinAuth>True</WinAuth> + <AzurePwd>False</AzurePwd> + </Source> + </Sources> + <Items> + <Item name="dbo.ACTION_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.ADDRESSES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="ADDRESS_STRING" /> + <Column name="LOCALITY" /> + <Column name="COUNTRY" /> + <Column name="CITY" /> + <Column name="STATE" /> + <Column name="COUNTRY_CODE" /> + <Column name="POSTAL_CODE" /> + </Columns> + </Item> + <Item name="dbo.APPLICATION_DISPLAY_PANEL_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.APPLICATION_FIRMWARE_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.APPLICATION_OS_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.APPLICATION_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.BRUSH_STOPS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="SEGMENT_GUID" /> + <Column name="COLOR_SPACE_GUID" /> + <Column name="OFFSET_PERCENT" /> + <Column name="STOP_INDEX" /> + <Column name="CYAN" /> + <Column name="MAGENTA" /> + <Column name="YELLOW" /> + <Column name="BLACK" /> + <Column name="RED" /> + <Column name="GREEN" /> + <Column name="BLUE" /> + <Column name="L" /> + <Column name="A" /> + <Column name="B" /> + <Column name="V0" /> + <Column name="V1" /> + <Column name="V2" /> + <Column name="V3" /> + <Column name="V4" /> + <Column name="V5" /> + <Column name="V6" /> + <Column name="V7" /> + <Column name="CORRECTED" /> + <Column name="COLOR_CATALOG_GUID" /> + <Column name="COLOR_CATALOG_CODE" /> + </Columns> + </Item> + <Item name="dbo.CARTRIDGE_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.CATS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="MACHINE_GUID" /> + <Column name="RML_GUID" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="DATA" /> + </Columns> + </Item> + <Item name="dbo.CCTS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="FORWARD_FILE_NAME" /> + <Column name="INVERSE_FILE_NAME" /> + <Column name="FORWARD_DATA" /> + <Column name="INVERSE_DATA" /> + <Column name="VERSION" /> + <Column name="RML_GUID" /> + </Columns> + </Item> + <Item name="dbo.COLOR_CATALOGS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="COLOR_SPACE_GUID" /> + <Column name="COLOR_CODE" /> + <Column name="NAME" /> + <Column name="COLOR_GROUP" /> + <Column name="CYAN" /> + <Column name="MAGENTA" /> + <Column name="YELLOW" /> + <Column name="BLACK" /> + <Column name="RED" /> + <Column name="GREEN" /> + <Column name="BLUE" /> + <Column name="L" /> + <Column name="A" /> + <Column name="B" /> + <Column name="V0" /> + <Column name="V1" /> + <Column name="V2" /> + <Column name="V3" /> + <Column name="V4" /> + <Column name="V5" /> + <Column name="V6" /> + <Column name="V7" /> + </Columns> + </Item> + <Item name="dbo.COLOR_SPACES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.CONFIGURATIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CREATION_DATE" /> + <Column name="APPLICATION_VERSION_GUID" /> + <Column name="APPLICATION_OS_VERSION_GUID" /> + <Column name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + </Columns> + </Item> + <Item name="dbo.CONTACTS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="FIRST_NAME" /> + <Column name="LAST_NAME" /> + <Column name="FULL_NAME" /> + <Column name="EMAIL" /> + <Column name="PHONE_NUMBER" /> + <Column name="FAX" /> + </Columns> + </Item> + <Item name="dbo.CUSTOMERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="ORGANIZATION_GUID" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.DISPENSER_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="NL_PER_PULSE" /> + <Column name="CAPACITY" /> + </Columns> + </Item> + <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.EVENT_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="EVENT_TYPES_CATEGORY_GUID" /> + <Column name="EVENT_TYPES_GROUP_GUID" /> + <Column name="REQUIRES_USER_INTERVENTION" /> + <Column name="HTML_PAGE_GUID" /> + <Column name="RESOLVABLE" /> + </Columns> + </Item> + <Item name="dbo.EVENT_TYPES_ACTIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="EVENT_TYPE_GUID" /> + <Column name="ACTION_TYPE_GUID" /> + </Columns> + </Item> + <Item name="dbo.EVENT_TYPES_CATEGORIES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.EVENT_TYPES_GROUPS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.FIBER_SHAPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.FIBER_SYNTHS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_DANCER_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_DANCERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_DANCER_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="GRADUAL" /> + <Column name="K" /> + <Column name="X" /> + <Column name="PULSE_PER_MM_SPRING" /> + <Column name="MAXIMAL_MOVEMENT_MM" /> + <Column name="ZERO_POINT" /> + <Column name="RESOLUTION_BITS" /> + <Column name="ARM_LENGTH" /> + <Column name="ASSEMBLY_DIRECTION_RIGHT" /> + <Column name="ACCELERATE_ON_TENSION_RAISE" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="SUPPORTS_HOMING" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_MOTORS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_MOTOR_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="MIN_FREQUENCY" /> + <Column name="MAX_FREQUENCY" /> + <Column name="SET_MICRO_STEP" /> + <Column name="MICRO_STEP" /> + <Column name="MAX_CHANGE_SLOPE" /> + <Column name="HIGH_LENGTH_MICRO_SECOND" /> + <Column name="SPEED_MASTER" /> + <Column name="PULSE_PER_ROUND" /> + <Column name="PULLEY_RADIUS" /> + <Column name="CONFIG_WORD" /> + <Column name="DIRECTION_THREAD_WIZE" /> + <Column name="KVAL_HOLD" /> + <Column name="KVAL_RUN" /> + <Column name="KVAL_ACC" /> + <Column name="KVAL_DEC" /> + <Column name="OVER_CURRENT_THRESHOLD" /> + <Column name="STALL_THRESHOLD" /> + <Column name="THERMAL_COMPENSATION_FACTOR" /> + <Column name="LOW_SPEED_OPTIMIZATION" /> + <Column name="ST_SLP" /> + <Column name="INT_SPD" /> + <Column name="FN_SLP_ACC" /> + <Column name="FN_SLP_DEC" /> + <Column name="FS_SPD" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_PID_CONTROLS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_PID_CONTROL_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="OUTPUT_PROPORTIONAL_POWER_LIMIT" /> + <Column name="OUTPUT_PROPORTIONAL_BAND" /> + <Column name="INTEGRAL_TIME" /> + <Column name="DERIVATIVE_TIME" /> + <Column name="SENSOR_CORRECTION_ADJUSTMENT" /> + <Column name="SENSOR_MIN_VALUE" /> + <Column name="SENSOR_MAX_VALUE" /> + <Column name="SET_POINT_RAMP_RATEOR_SOFT_START_RAMP" /> + <Column name="SET_POINT_CONTROL_OUTPUT_RATE" /> + <Column name="CONTROL_OUTPUT_TYPE" /> + <Column name="SSR_CONTROL_OUTPUT_TYPE" /> + <Column name="OUTPUT_ON_OFF_HYSTERESIS_VALUE" /> + <Column name="PROCESS_VARIABLE_SAMPLING_RATE" /> + <Column name="PV_INPUT_FILTER_FACTOR_MODE" /> + <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" /> + <Column name="AC_HEATERS__HALF_CYCLE_TIME" /> + <Column name="PROPORTIONAL_GAIN" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_SPEED_SENSORS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_SPEED_SENSOR_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="RESOLUTION_BITS" /> + <Column name="PERIMETER" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_WINDER_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.HARDWARE_WINDERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_WINDER_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="MILLIMETER_PER_ROTATION" /> + </Columns> + </Item> + <Item name="dbo.HTML_PAGES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="HTML" /> + </Columns> + </Item> + <Item name="dbo.IDS_PACK_FORMULAS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="AUTO_CALCULATED" /> + </Columns> + </Item> + <Item name="dbo.IDS_PACKS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CONFIGURATION_GUID" /> + <Column name="DISPENSER_TYPE_GUID" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="CARTRIDGE_TYPE_GUID" /> + <Column name="MID_TANK_TYPE_GUID" /> + <Column name="IDS_PACK_FORMULA_GUID" /> + <Column name="NAME" /> + <Column name="PACK_INDEX" /> + <Column name="IS_EMPTY" /> + </Columns> + </Item> + <Item name="dbo.JOB_RUNS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="JOB_GUID" /> + <Column name="START_DATE" /> + <Column name="END_DATE" /> + <Column name="SUCCESSFUL" /> + </Columns> + </Item> + <Item name="dbo.JOBS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CREATION_DATE" /> + <Column name="LAST_RUN" /> + <Column name="MACHINE_GUID" /> + <Column name="USER_GUID" /> + <Column name="RML_GUID" /> + <Column name="WINDING_METHOD_GUID" /> + <Column name="SPOOL_TYPE_GUID" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="INTER_SEGMENT_LENGTH" /> + <Column name="ENABLE_INTER_SEGMENT" /> + <Column name="ENABLE_LUBRICATION" /> + <Column name="JOB_INDEX" /> + <Column name="ESTIMATED_DURATION_MILI" /> + <Column name="HAS_EMBROIDERY_FILE" /> + <Column name="EMBROIDERY_FILE_DATA" /> + <Column name="EMBROIDERY_FILE_NAME" /> + <Column name="EMBROIDERY_JPEG" /> + <Column name="STATUS" /> + <Column name="COLOR_SPACE_GUID" /> + <Column name="NUMBER_OF_UNITS" /> + <Column name="TYPE" /> + <Column name="CUSTOMER_GUID" /> + <Column name="SPOOLS_DISTRIBUTION" /> + <Column name="NUMBER_OF_HEADS" /> + <Column name="SAMPLE_UNITS_OR_METERS" /> + <Column name="FINE_TUNING_STATUS" /> + <Column name="FINE_TUNING_APPROVE_DATE" /> + <Column name="SAMPLE_DYE_STATUS" /> + <Column name="SAMPLE_DYE_APPROVE_DATE" /> + <Column name="EDITING_STATE" /> + <Column name="LENGTH_PERCENTAGE_FACTOR" /> + </Columns> + </Item> + <Item name="dbo.LINEAR_MASS_DENSITY_UNITS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.LIQUID_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="VERSION" /> + <Column name="COLOR" /> + </Columns> + </Item> + <Item name="dbo.LIQUID_TYPES_RMLS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="RML_GUID" /> + <Column name="MAX_NL_PER_CM" /> + </Columns> + </Item> + <Item name="dbo.MACHINE_STUDIO_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="FTP_FILE_PATH" /> + <Column name="COMMENTS" /> + <Column name="USER_GUID" /> + <Column name="FORCE_UPDATE" /> + </Columns> + </Item> + <Item name="dbo.MACHINE_VERSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + <Column name="DEFAULT_CONFIGURATION_GUID" /> + </Columns> + </Item> + <Item name="dbo.MACHINES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="SERIAL_NUMBER" /> + <Column name="NAME" /> + <Column name="PRODUCTION_DATE" /> + <Column name="ORGANIZATION_GUID" /> + <Column name="MACHINE_VERSION_GUID" /> + <Column name="CONFIGURATION_GUID" /> + <Column name="ENABLE_EXTERNAL_BRIDGE" /> + <Column name="EXTERNAL_BRIDGE_PASSWORD" /> + <Column name="DEFAULT_RML_GUID" /> + <Column name="TARGET_JOB_TYPES" /> + <Column name="DEFAULT_COLOR_SPACE_GUID" /> + <Column name="DEFAULT_SEGMENT_LENGTH" /> + <Column name="DEFAULT_SPOOL_TYPE_GUID" /> + <Column name="SYNCHED" /> + </Columns> + </Item> + <Item name="dbo.MACHINES_CONFIGURATIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="MACHINE_GUID" /> + <Column name="CONFIGURATION_GUID" /> + </Columns> + </Item> + <Item name="dbo.MACHINES_EVENTS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HOST_NAME" /> + <Column name="MACHINE_GUID" /> + <Column name="EVENT_TYPE_GUID" /> + <Column name="USER_GUID" /> + <Column name="DATE_TIME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.MACHINES_EVENTS_VIEW" type="view"> + <Columns> + <Column name="DATE" /> + <Column name="MACHINE" /> + <Column name="USER_NAME" /> + <Column name="GROUP" /> + <Column name="CATEGORY" /> + <Column name="TYPE" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.MEDIA_COLORS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="L" /> + <Column name="A" /> + <Column name="B" /> + </Columns> + </Item> + <Item name="dbo.MEDIA_CONDITIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.MEDIA_MATERIALS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.MEDIA_PURPOSES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Item> + <Item name="dbo.MID_TANK_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="LITER_CAPACITY" /> + </Columns> + </Item> + <Item name="dbo.ORGANIZATIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CONTACT_GUID" /> + <Column name="ADDRESS_GUID" /> + </Columns> + </Item> + <Item name="dbo.PERMISSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.PROCESS_PARAMETERS_TABLES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="DYEING_SPEED" /> + <Column name="MIN_INK_UPTAKE" /> + <Column name="FEEDER_TENSION" /> + <Column name="PULLER_TENSION" /> + <Column name="WINDER_TENSION" /> + <Column name="MIXER_TEMP" /> + <Column name="HEAD_ZONE1_TEMP" /> + <Column name="HEAD_ZONE2_TEMP" /> + <Column name="HEAD_ZONE3_TEMP" /> + <Column name="HEAD_ZONE4_TEMP" /> + <Column name="HEAD_ZONE5_TEMP" /> + <Column name="HEAD_ZONE6_TEMP" /> + <Column name="DRYER_AIR_FLOW" /> + <Column name="DRYER_ZONE1_TEMP" /> + <Column name="DRYER_ZONE2_TEMP" /> + <Column name="DRYER_ZONE3_TEMP" /> + <Column name="DRYER_BUFFER_LENGTH" /> + <Column name="HEAD_AIR_FLOW" /> + <Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" /> + <Column name="TABLE_INDEX" /> + </Columns> + </Item> + <Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="RML_GUID" /> + <Column name="NAME" /> + <Column name="ACTIVE" /> + <Column name="SAVE_DATE" /> + </Columns> + </Item> + <Item name="dbo.RMLS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="MANUFACTURER" /> + <Column name="CODE" /> + <Column name="MEDIA_MATERIAL_GUID" /> + <Column name="MEDIA_COLOR_GUID" /> + <Column name="MEDIA_PURPOSE_GUID" /> + <Column name="MEDIA_CONDITION_GUID" /> + <Column name="LINEAR_MASS_DENSITY_UNIT_GUID" /> + <Column name="FIBER_SHAPE_GUID" /> + <Column name="FIBER_SYNTH_GUID" /> + <Column name="FIBER_SIZE" /> + <Column name="NUMBER_OF_FIBERS" /> + <Column name="PLIES_PER_FIBER" /> + <Column name="PLIES_PER_THREAD" /> + <Column name="TWISTED" /> + <Column name="AIR_ENTANGLEMENT" /> + <Column name="LUBRICANT" /> + <Column name="TENSILE_STRENGTH" /> + <Column name="ELONGATION_AT_BREAK_PERCENTAGE" /> + <Column name="ESTIMATED_THREAD_DIAMETER" /> + </Columns> + </Item> + <Item name="dbo.ROLES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.ROLES_PERMISSIONS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="ROLE_GUID" /> + <Column name="PERMISSION_GUID" /> + </Columns> + </Item> + <Item name="dbo.SEGMENTS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="JOB_GUID" /> + <Column name="LENGTH" /> + <Column name="SEGMENT_INDEX" /> + </Columns> + </Item> + <Item name="dbo.SPOOL_TYPES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="LENGTH" /> + <Column name="WEIGHT" /> + <Column name="DIAMETER" /> + <Column name="START_OFFSET_PULSES" /> + <Column name="BACKING_RATE" /> + <Column name="SEGMENT_OFFSET_PULSES" /> + <Column name="BOTTOM_BACKING_RATE" /> + <Column name="ROTATIONS_PER_PASSAGE" /> + </Columns> + </Item> + <Item name="dbo.SYNC_CONFIGURATIONS" type="table"> + <Columns> + <Column name="ID" key="true" /> + <Column name="TABLE_NAME" /> + <Column name="SYNC_TYPE" /> + </Columns> + </Item> + <Item name="dbo.TECH_CONTROLLERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="MIN" /> + <Column name="MAX" /> + <Column name="UNITS" /> + </Columns> + </Item> + <Item name="dbo.TECH_DISPENSERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.TECH_IOS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="PORT" /> + <Column name="TYPE" /> + <Column name="DESIGNATOR" /> + <Column name="ASM" /> + <Column name="INTERFACE_NAME" /> + <Column name="SENSOR" /> + <Column name="INIT_VALUE" /> + <Column name="AVERAGING" /> + <Column name="MIN" /> + <Column name="MAX" /> + </Columns> + </Item> + <Item name="dbo.TECH_MONITORS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="MIN" /> + <Column name="MAX" /> + <Column name="UNITS" /> + <Column name="POINTS_PER_FRAME" /> + <Column name="MULTI_CHANNEL" /> + <Column name="CHANNEL_COUNT" /> + </Columns> + </Item> + <Item name="dbo.TECH_VALVES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="dbo.USERS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="EMAIL" /> + <Column name="PASSWORD" /> + <Column name="ORGANIZATION_GUID" /> + <Column name="CONTACT_GUID" /> + <Column name="ADDRESS_GUID" /> + <Column name="LAST_LOGIN" /> + </Columns> + </Item> + <Item name="dbo.USERS_ROLES" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="USER_GUID" /> + <Column name="ROLE_GUID" /> + </Columns> + </Item> + <Item name="dbo.WINDING_METHODS" type="table"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Item> + <Item name="Sync_Addresses" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="ADDRESS_STRING" /> + <Column name="LOCALITY" /> + <Column name="COUNTRY" /> + <Column name="CITY" /> + <Column name="STATE" /> + <Column name="COUNTRY_CODE" /> + <Column name="POSTAL_CODE" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT DISTINCT ADDRESSES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="ADDRESS_STRING" /> + <UpdateColumn name="LOCALITY" /> + <UpdateColumn name="COUNTRY" /> + <UpdateColumn name="CITY" /> + <UpdateColumn name="STATE" /> + <UpdateColumn name="COUNTRY_CODE" /> + <UpdateColumn name="POSTAL_CODE" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT DISTINCT ADDRESSES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="ADDRESS_STRING" /> + <UpdateColumn name="LOCALITY" /> + <UpdateColumn name="COUNTRY" /> + <UpdateColumn name="CITY" /> + <UpdateColumn name="STATE" /> + <UpdateColumn name="COUNTRY_CODE" /> + <UpdateColumn name="POSTAL_CODE" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_Configuration" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CREATION_DATE" /> + <Column name="APPLICATION_VERSION_GUID" /> + <Column name="APPLICATION_OS_VERSION_GUID" /> + <Column name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT CONFIGURATIONS.* +FROM CONFIGURATIONS +INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CREATION_DATE" /> + <UpdateColumn name="APPLICATION_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_OS_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <UpdateColumn name="HARDWARE_VERSION_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT CONFIGURATIONS.* +FROM CONFIGURATIONS +INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CREATION_DATE" /> + <UpdateColumn name="APPLICATION_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_OS_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <UpdateColumn name="HARDWARE_VERSION_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_Contacts" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="FIRST_NAME" /> + <Column name="LAST_NAME" /> + <Column name="FULL_NAME" /> + <Column name="EMAIL" /> + <Column name="PHONE_NUMBER" /> + <Column name="FAX" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT DISTINCT CONTACTS.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="FIRST_NAME" /> + <UpdateColumn name="LAST_NAME" /> + <UpdateColumn name="FULL_NAME" /> + <UpdateColumn name="EMAIL" /> + <UpdateColumn name="PHONE_NUMBER" /> + <UpdateColumn name="FAX" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT DISTINCT CONTACTS.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="FIRST_NAME" /> + <UpdateColumn name="LAST_NAME" /> + <UpdateColumn name="FULL_NAME" /> + <UpdateColumn name="EMAIL" /> + <UpdateColumn name="PHONE_NUMBER" /> + <UpdateColumn name="FAX" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_IdsPacks" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CONFIGURATION_GUID" /> + <Column name="DISPENSER_TYPE_GUID" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="CARTRIDGE_TYPE_GUID" /> + <Column name="MID_TANK_TYPE_GUID" /> + <Column name="IDS_PACK_FORMULA_GUID" /> + <Column name="NAME" /> + <Column name="PACK_INDEX" /> + <Column name="IS_EMPTY" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT IDS_PACKS.* + +FROM MACHINES + INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID + INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@' +]]></Text> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT IDS_PACKS.* + +FROM MACHINES + INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID + INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@' +]]></Text> + <UpdateTables> + <Table schema="dbo" name="IDS_PACKS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="CONFIGURATION_GUID" /> + <UpdateColumn name="DISPENSER_TYPE_GUID" /> + <UpdateColumn name="LIQUID_TYPE_GUID" /> + <UpdateColumn name="CARTRIDGE_TYPE_GUID" /> + <UpdateColumn name="MID_TANK_TYPE_GUID" /> + <UpdateColumn name="IDS_PACK_FORMULA_GUID" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="PACK_INDEX" /> + <UpdateColumn name="IS_EMPTY" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_Machine" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="SERIAL_NUMBER" /> + <Column name="NAME" /> + <Column name="PRODUCTION_DATE" /> + <Column name="ORGANIZATION_GUID" /> + <Column name="MACHINE_VERSION_GUID" /> + <Column name="CONFIGURATION_GUID" /> + <Column name="ENABLE_EXTERNAL_BRIDGE" /> + <Column name="EXTERNAL_BRIDGE_PASSWORD" /> + <Column name="DEFAULT_RML_GUID" /> + <Column name="TARGET_JOB_TYPES" /> + <Column name="DEFAULT_COLOR_SPACE_GUID" /> + <Column name="DEFAULT_SEGMENT_LENGTH" /> + <Column name="DEFAULT_SPOOL_TYPE_GUID" /> + <Column name="SYNCHED" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="SERIAL_NUMBER" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="PRODUCTION_DATE" /> + <UpdateColumn name="ORGANIZATION_GUID" /> + <UpdateColumn name="MACHINE_VERSION_GUID" /> + <UpdateColumn name="CONFIGURATION_GUID" /> + <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" /> + <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" /> + <UpdateColumn name="DEFAULT_RML_GUID" /> + <UpdateColumn name="TARGET_JOB_TYPES" /> + <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" /> + <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" /> + <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" /> + <UpdateColumn name="SYNCHED" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="SERIAL_NUMBER" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="PRODUCTION_DATE" /> + <UpdateColumn name="ORGANIZATION_GUID" /> + <UpdateColumn name="MACHINE_VERSION_GUID" /> + <UpdateColumn name="CONFIGURATION_GUID" /> + <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" /> + <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" /> + <UpdateColumn name="DEFAULT_RML_GUID" /> + <UpdateColumn name="TARGET_JOB_TYPES" /> + <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" /> + <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" /> + <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" /> + <UpdateColumn name="SYNCHED" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_Organization" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CONTACT_GUID" /> + <Column name="ADDRESS_GUID" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT ORGANIZATIONS.* + +FROM ORGANIZATIONS + +INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CONTACT_GUID" /> + <UpdateColumn name="ADDRESS_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT ORGANIZATIONS.* + +FROM ORGANIZATIONS + +INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CONTACT_GUID" /> + <UpdateColumn name="ADDRESS_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + <Item name="Sync_UsersRoles" type="query" extracted="True"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="USER_GUID" /> + <Column name="ROLE_GUID" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT DISTINCT USERS_ROLES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="USER_GUID" /> + <UpdateColumn name="ROLE_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT DISTINCT USERS_ROLES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="USER_GUID" /> + <UpdateColumn name="ROLE_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Item> + </Items> + <SchemaMapping> + <SMItem schema1="dbo" schema2="dbo" /> + </SchemaMapping> + <ProjectSettings> + <AllSettings> + <ComparisonCaseSensitive>1</ComparisonCaseSensitive> + <CompareTrimmedStrings>False</CompareTrimmedStrings> + <EmptyEqualsNull>False</EmptyEqualsNull> + <PrecedeStringConstWithNPrefix>0</PrecedeStringConstWithNPrefix> + <AutoSelectKeyColumns>0</AutoSelectKeyColumns> + <PerformanceOptions> + <PerformanceOption name="Auto" value="True" /> + </PerformanceOptions> + </AllSettings> + </ProjectSettings> +</SqlDataExaminer>
\ No newline at end of file diff --git a/Software/DB/Tango.mdf b/Software/DB/Tango.mdf Binary files differindex 74e15e095..e73085417 100644 --- a/Software/DB/Tango.mdf +++ b/Software/DB/Tango.mdf diff --git a/Software/DB/Tango_log.ldf b/Software/DB/Tango_log.ldf Binary files differindex a25e2ea26..4635dbde3 100644 --- a/Software/DB/Tango_log.ldf +++ b/Software/DB/Tango_log.ldf diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Action.cs b/Software/Visual_Studio/Tango.SQLExaminer/Action.cs new file mode 100644 index 000000000..5f7be7751 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/Action.cs @@ -0,0 +1,29 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class Action + { + [XmlAttribute("type")] + public String Type { get; set; } + + [XmlAttribute("path")] + public String Path { get; set; } + + [XmlAttribute("reportType")] + public String ReportType { get; set; } + + [XmlAttribute("reportOn")] + public String ReportOn { get; set; } + + public Action() + { + Type = "synchronize"; + } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/AdditionalOption.cs b/Software/Visual_Studio/Tango.SQLExaminer/AdditionalOption.cs new file mode 100644 index 000000000..13c58f906 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/AdditionalOption.cs @@ -0,0 +1,18 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class AdditionalOption + { + [XmlAttribute("name")] + public String Name { get; set; } + + [XmlAttribute("value")] + public String Value { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Column.cs b/Software/Visual_Studio/Tango.SQLExaminer/Column.cs new file mode 100644 index 000000000..69a3e455f --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/Column.cs @@ -0,0 +1,17 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class Column + { + [XmlAttribute("name")] + public String Name { get; set; } + [XmlAttribute("key")] + public String Key { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/ComparisonOption.cs b/Software/Visual_Studio/Tango.SQLExaminer/ComparisonOption.cs new file mode 100644 index 000000000..9e2bbd613 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/ComparisonOption.cs @@ -0,0 +1,18 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class ComparisonOption + { + [XmlAttribute("name")] + public String Name { get; set; } + + [XmlAttribute("value")] + public String Value { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/DataSource.cs b/Software/Visual_Studio/Tango.SQLExaminer/DataSource.cs new file mode 100644 index 000000000..b2d21df88 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/DataSource.cs @@ -0,0 +1,30 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class DataSource + { + [XmlAttribute("id")] + public int ID { get; set; } + + [XmlAttribute("server")] + public String Server { get; set; } + + [XmlAttribute("database")] + public String DataBase { get; set; } + + [XmlAttribute("winAuth")] + public String IntegratedSecurity { get; set; } + + [XmlAttribute("login")] + public String UserName { get; set; } + + [XmlAttribute("password")] + public String Password { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfiguration.cs b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfiguration.cs new file mode 100644 index 000000000..37d9da0d0 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfiguration.cs @@ -0,0 +1,83 @@ +using System; +using System.Collections.Generic; +using System.IO; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + [XmlRoot("config")] + public class ExaminerConfiguration + { + [XmlAttribute("version")] + public int Version { get; set; } + + [XmlAttribute("maker")] + public String Maker { get; set; } + + public List<DataSource> DataSources { get; set; } + + public List<Action> Actions { get; set; } + + public Options Options { get; set; } + + public Objects Objects { get; set; } + + [XmlIgnore] + public ExaminerConfigurationType ConfigurationType { get; set; } + + public ExaminerConfiguration() + { + Version = 2; + Maker = "Twine"; + DataSources = new List<DataSource>(); + Actions = new List<Action>(); + Options = new Options(); + Objects = new Objects(); + } + + public static ExaminerConfiguration FromFile(String filePath) + { + return FromString(File.ReadAllText(filePath)); + } + + public static ExaminerConfiguration FromString(String xml) + { + XmlSerializer f = new XmlSerializer(typeof(ExaminerConfiguration), ""); + + ExaminerConfiguration config = null; + + using (var reader = new StringReader(xml)) + { + config = f.Deserialize(reader) as ExaminerConfiguration; + } + + return config; + } + + public void ToFile(String filePath) + { + File.WriteAllText(filePath, ToXml()); + } + + public String ToXml() + { + XmlSerializerNamespaces ns = new XmlSerializerNamespaces(); + ns.Add("", ""); + + XmlSerializer f = new XmlSerializer(typeof(ExaminerConfiguration), ""); + + String result = String.Empty; + + using (var st = new StringWriter()) + { + f.Serialize(st, this, ns); + result = st.ToString(); + } + + return result; + } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationBuilder.cs b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationBuilder.cs new file mode 100644 index 000000000..76c28c302 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationBuilder.cs @@ -0,0 +1,89 @@ +using System; +using System.Collections.Generic; +using System.IO; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using Tango.Core.Helpers; + +namespace Tango.SQLExaminer +{ + public class ExaminerConfigurationBuilder + { + private ExaminerConfiguration _config; + private static String _sql_examiner_folder; + private static String _sql_examiner_config_folder; + + static ExaminerConfigurationBuilder() + { + _sql_examiner_folder = Path.Combine(AssemblyHelper.GetCurrentAssemblyFolder(), "SQLExaminer"); + _sql_examiner_config_folder = Path.Combine(_sql_examiner_folder, "Configurations"); + } + + private String GetConfigurationFilePath(ExaminerConfigurationType type) + { + return Path.Combine(_sql_examiner_config_folder, type.ToString() + ".xml"); + } + + public ExaminerConfigurationBuilder(ExaminerConfigurationType type) + { + _config = ExaminerConfiguration.FromFile(GetConfigurationFilePath(type)); + _config.ConfigurationType = type; + _config.DataSources.Clear(); + } + + public ExaminerConfigurationBuilder SetSourceServer(String address, String userName, String password) + { + _config.DataSources.Add(new DataSource() + { + ID = 1, + DataBase = "Tango", + Server = address, + UserName = userName, + Password = password, + }); + + return this; + } + + public ExaminerConfigurationBuilder SetTargetServer(String address) + { + _config.DataSources.Add(new DataSource() + { + ID = 2, + DataBase = "Tango", + Server = address, + IntegratedSecurity = "True", + }); + + return this; + } + + public ExaminerConfigurationBuilder SetBackupFile(String path) + { + var backup_action = _config.Actions.SingleOrDefault(x => x.ReportType == "backup"); + if (backup_action != null) + { + backup_action.Path = path; + } + + return this; + } + + public ExaminerConfigurationBuilder SetReportFile(String path) + { + var Report_action = _config.Actions.SingleOrDefault(x => x.ReportType == "report"); + if (Report_action != null) + { + Report_action.Path = path; + } + + return this; + } + + public ExaminerConfiguration Build() + { + return _config; + } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationType.cs b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationType.cs new file mode 100644 index 000000000..be88dcb1e --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/ExaminerConfigurationType.cs @@ -0,0 +1,14 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace Tango.SQLExaminer +{ + public enum ExaminerConfigurationType + { + Schema, + OverrideData + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Filter.cs b/Software/Visual_Studio/Tango.SQLExaminer/Filter.cs new file mode 100644 index 000000000..373458139 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/Filter.cs @@ -0,0 +1,18 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace Tango.SQLExaminer +{ + public class Filter + { + public List<IncludeItem> Include { get; set; } + + public Filter() + { + Include = new List<IncludeItem>(); + } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/IncludeItem.cs b/Software/Visual_Studio/Tango.SQLExaminer/IncludeItem.cs new file mode 100644 index 000000000..6b708cc86 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/IncludeItem.cs @@ -0,0 +1,21 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class IncludeItem + { + [XmlAttribute("type")] + public String Type { get; set; } + + [XmlAttribute("expressiontype")] + public String ExpressionType { get; set; } + + [XmlAttribute("name")] + public String Name { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/KeyColumn.cs b/Software/Visual_Studio/Tango.SQLExaminer/KeyColumn.cs new file mode 100644 index 000000000..81fd7e126 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/KeyColumn.cs @@ -0,0 +1,15 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class KeyColumn + { + [XmlAttribute("name")] + public String Name { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Object.cs b/Software/Visual_Studio/Tango.SQLExaminer/Object.cs new file mode 100644 index 000000000..97ed81f0d --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/Object.cs @@ -0,0 +1,31 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class Object + { + [XmlAttribute("name")] + public String Name { get; set; } + + [XmlAttribute("type")] + public String Type { get; set; } + + [XmlAttribute("records")] + public String Records { get; set; } + + public List<Column> Columns { get; set; } + + public List<Query> Queries { get; set; } + + public Object() + { + Columns = new List<Column>(); + Queries = new List<Query>(); + } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/ObjectList.cs b/Software/Visual_Studio/Tango.SQLExaminer/ObjectList.cs new file mode 100644 index 000000000..7020e0d25 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/ObjectList.cs @@ -0,0 +1,23 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class ObjectList + { + [XmlAttribute("type")] + public String Type { get; set; } + + [XmlElement("")] + public List<Object> Object { get; set; } + + public ObjectList() + { + Object = new List<Object>(); + } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Objects.cs b/Software/Visual_Studio/Tango.SQLExaminer/Objects.cs new file mode 100644 index 000000000..8de85cdab --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/Objects.cs @@ -0,0 +1,24 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace Tango.SQLExaminer +{ + public class Objects + { + public SchemaMapping SchemaMapping { get; set; } + + public ObjectList ObjectList { get; set; } + + public Filter Filter { get; set; } + + public Objects() + { + SchemaMapping = new SchemaMapping(); + ObjectList = new ObjectList(); + Filter = new Filter(); + } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Options.cs b/Software/Visual_Studio/Tango.SQLExaminer/Options.cs new file mode 100644 index 000000000..80e9f5b1e --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/Options.cs @@ -0,0 +1,27 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace Tango.SQLExaminer +{ + public class Options + { + public List<ComparisonOption> ComparisonOptions { get; set; } + + public List<PerformanceOption> PerformanceOptions { get; set; } + + public List<SyncOption> SyncOptions { get; set; } + + public List<AdditionalOption> AdditionalOptions { get; set; } + + public Options() + { + ComparisonOptions = new List<ComparisonOption>(); + PerformanceOptions = new List<PerformanceOption>(); + SyncOptions = new List<SyncOption>(); + AdditionalOptions = new List<AdditionalOption>(); + } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/PerformanceOption.cs b/Software/Visual_Studio/Tango.SQLExaminer/PerformanceOption.cs new file mode 100644 index 000000000..c27c1fba8 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/PerformanceOption.cs @@ -0,0 +1,18 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class PerformanceOption + { + [XmlAttribute("name")] + public String Name { get; set; } + + [XmlAttribute("value")] + public String Value { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Properties/AssemblyInfo.cs b/Software/Visual_Studio/Tango.SQLExaminer/Properties/AssemblyInfo.cs new file mode 100644 index 000000000..490a21bee --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/Properties/AssemblyInfo.cs @@ -0,0 +1,6 @@ +using System.Reflection; +using System.Runtime.CompilerServices; +using System.Runtime.InteropServices; + +[assembly: AssemblyTitle("Tango - SQL Examiner synchronization library")] +[assembly: AssemblyVersion("1.0.0.0")] diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Query.cs b/Software/Visual_Studio/Tango.SQLExaminer/Query.cs new file mode 100644 index 000000000..c890c3edf --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/Query.cs @@ -0,0 +1,25 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class Query + { + [XmlAttribute("id")] + public String ID { get; set; } + + public XmlCDataSection Text { get; set; } + + public List<Table> UpdateTables { get; set; } + + public Query() + { + UpdateTables = new List<Table>(); + } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SMItem.cs b/Software/Visual_Studio/Tango.SQLExaminer/SMItem.cs new file mode 100644 index 000000000..0d981bf57 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SMItem.cs @@ -0,0 +1,18 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class SMItem + { + [XmlAttribute("schema1")] + public String Schema1 { get; set; } + + [XmlAttribute("schema2")] + public String Schema2 { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/OverrideData.xml b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/OverrideData.xml new file mode 100644 index 000000000..f6f21dd98 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/OverrideData.xml @@ -0,0 +1,722 @@ +<?xml version="1.0" encoding="utf-16"?> +<config version="2" maker="SQL Data Examiner"> + <DataSources> + <DataSource id="1" server="localhost\SQLEXPRESS" database="Tango" login="Synchronizer" password="Aa123456" /> + <DataSource id="2" server="twine.local\SQLTWINE" database="Tango" winAuth="True" /> + </DataSources> + <Actions> + <Action type="backup" path="C:\Program Files\Microsoft SQL Server\MSSQL14.SQLTWINE\MSSQL\Backup\%DB_db_%YYYY%MM%DD%HH%mm.bak" /> + <Action type="synchronize" /> + <Action type="report" path="C:\Users\Roy\Documents\%DB1_%DB2_%YYYY%MM%DD.htm" reportOn="Different, Same, OnlyInDb1, OnlyInDb2" /> + </Actions> + <Options> + <ComparisonOptions> + <ComparisonOption name="CompareTrimmedStrings" value="False" /> + <ComparisonOption name="EmptyEqualsNull" value="False" /> + <ComparisonOption name="ComparisonCaseSensitive" value="CaseSensitive" /> + <ComparisonOption name="AutoSelectKeyColumns" value="None" /> + </ComparisonOptions> + <PerformanceOptions> + <PerformanceOption name="Auto" value="True" /> + </PerformanceOptions> + <SyncOptions> + <SyncOption name="SynchronizeIdentity" value="True" /> + <SyncOption name="UseTransaction" value="True" /> + <SyncOption name="DoNotStopOnErrors" value="False" /> + <SyncOption name="DisableTriggers" value="True" /> + <SyncOption name="DisableUniques" value="True" /> + <SyncOption name="DisableForeignKeys" value="True" /> + <SyncOption name="SetAnsiWarningsOff" value="False" /> + <SyncOption name="SqlBatchMode" value="True" /> + <SyncOption name="SqlBatchSize" value="1MB" /> + <SyncOption name="PrecedeStringConstWithNPrefix" value="Always" /> + </SyncOptions> + <AdditionalOptions> + <AdditionalOption name="Nolog" value="True" /> + </AdditionalOptions> + </Options> + <Objects> + <SchemaMapping> + <SMItem schema1="dbo" schema2="dbo" /> + </SchemaMapping> + <ObjectList type="include"> + <Object name="dbo.ACTION_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.APPLICATION_DISPLAY_PANEL_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Object> + <Object name="dbo.APPLICATION_FIRMWARE_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Object> + <Object name="dbo.APPLICATION_OS_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Object> + <Object name="dbo.APPLICATION_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Object> + <Object name="dbo.CARTRIDGE_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + </Columns> + </Object> + <Object name="dbo.CATS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="MACHINE_GUID" /> + <Column name="RML_GUID" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="DATA" /> + </Columns> + </Object> + <Object name="dbo.CCTS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="FORWARD_FILE_NAME" /> + <Column name="INVERSE_FILE_NAME" /> + <Column name="FORWARD_DATA" /> + <Column name="INVERSE_DATA" /> + <Column name="VERSION" /> + <Column name="RML_GUID" /> + </Columns> + </Object> + <Object name="dbo.COLOR_CATALOGS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="COLOR_SPACE_GUID" /> + <Column name="COLOR_CODE" /> + <Column name="NAME" /> + <Column name="COLOR_GROUP" /> + <Column name="CYAN" /> + <Column name="MAGENTA" /> + <Column name="YELLOW" /> + <Column name="BLACK" /> + <Column name="RED" /> + <Column name="GREEN" /> + <Column name="BLUE" /> + <Column name="L" /> + <Column name="A" /> + <Column name="B" /> + <Column name="V0" /> + <Column name="V1" /> + <Column name="V2" /> + <Column name="V3" /> + <Column name="V4" /> + <Column name="V5" /> + <Column name="V6" /> + <Column name="V7" /> + </Columns> + </Object> + <Object name="dbo.COLOR_SPACES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.DISPENSER_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="NL_PER_PULSE" /> + <Column name="CAPACITY" /> + </Columns> + </Object> + <Object name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Object> + <Object name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Object> + <Object name="dbo.EVENT_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="EVENT_TYPES_CATEGORY_GUID" /> + <Column name="EVENT_TYPES_GROUP_GUID" /> + <Column name="REQUIRES_USER_INTERVENTION" /> + <Column name="HTML_PAGE_GUID" /> + <Column name="RESOLVABLE" /> + </Columns> + </Object> + <Object name="dbo.EVENT_TYPES_ACTIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="EVENT_TYPE_GUID" /> + <Column name="ACTION_TYPE_GUID" /> + </Columns> + </Object> + <Object name="dbo.EVENT_TYPES_CATEGORIES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.EVENT_TYPES_GROUPS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.FIBER_SHAPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Object> + <Object name="dbo.FIBER_SYNTHS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_DANCER_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_DANCERS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_DANCER_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="GRADUAL" /> + <Column name="K" /> + <Column name="X" /> + <Column name="PULSE_PER_MM_SPRING" /> + <Column name="MAXIMAL_MOVEMENT_MM" /> + <Column name="ZERO_POINT" /> + <Column name="RESOLUTION_BITS" /> + <Column name="ARM_LENGTH" /> + <Column name="ASSEMBLY_DIRECTION_RIGHT" /> + <Column name="ACCELERATE_ON_TENSION_RAISE" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_MOTOR_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="SUPPORTS_HOMING" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_MOTORS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_MOTOR_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="MIN_FREQUENCY" /> + <Column name="MAX_FREQUENCY" /> + <Column name="SET_MICRO_STEP" /> + <Column name="MICRO_STEP" /> + <Column name="MAX_CHANGE_SLOPE" /> + <Column name="HIGH_LENGTH_MICRO_SECOND" /> + <Column name="SPEED_MASTER" /> + <Column name="PULSE_PER_ROUND" /> + <Column name="PULLEY_RADIUS" /> + <Column name="CONFIG_WORD" /> + <Column name="DIRECTION_THREAD_WIZE" /> + <Column name="KVAL_HOLD" /> + <Column name="KVAL_RUN" /> + <Column name="KVAL_ACC" /> + <Column name="KVAL_DEC" /> + <Column name="OVER_CURRENT_THRESHOLD" /> + <Column name="STALL_THRESHOLD" /> + <Column name="THERMAL_COMPENSATION_FACTOR" /> + <Column name="LOW_SPEED_OPTIMIZATION" /> + <Column name="ST_SLP" /> + <Column name="INT_SPD" /> + <Column name="FN_SLP_ACC" /> + <Column name="FN_SLP_DEC" /> + <Column name="FS_SPD" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_PID_CONTROLS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_PID_CONTROL_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="OUTPUT_PROPORTIONAL_POWER_LIMIT" /> + <Column name="OUTPUT_PROPORTIONAL_BAND" /> + <Column name="INTEGRAL_TIME" /> + <Column name="DERIVATIVE_TIME" /> + <Column name="SENSOR_CORRECTION_ADJUSTMENT" /> + <Column name="SENSOR_MIN_VALUE" /> + <Column name="SENSOR_MAX_VALUE" /> + <Column name="SET_POINT_RAMP_RATEOR_SOFT_START_RAMP" /> + <Column name="SET_POINT_CONTROL_OUTPUT_RATE" /> + <Column name="CONTROL_OUTPUT_TYPE" /> + <Column name="SSR_CONTROL_OUTPUT_TYPE" /> + <Column name="OUTPUT_ON_OFF_HYSTERESIS_VALUE" /> + <Column name="PROCESS_VARIABLE_SAMPLING_RATE" /> + <Column name="PV_INPUT_FILTER_FACTOR_MODE" /> + <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" /> + <Column name="AC_HEATERS__HALF_CYCLE_TIME" /> + <Column name="PROPORTIONAL_GAIN" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_SPEED_SENSORS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_SPEED_SENSOR_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="RESOLUTION_BITS" /> + <Column name="PERIMETER" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_WINDER_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.HARDWARE_WINDERS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="HARDWARE_WINDER_TYPE_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + <Column name="MILLIMETER_PER_ROTATION" /> + </Columns> + </Object> + <Object name="dbo.HTML_PAGES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="HTML" /> + </Columns> + </Object> + <Object name="dbo.IDS_PACK_FORMULAS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="AUTO_CALCULATED" /> + </Columns> + </Object> + <Object name="dbo.LINEAR_MASS_DENSITY_UNITS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Object> + <Object name="dbo.LIQUID_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="VERSION" /> + <Column name="COLOR" /> + </Columns> + </Object> + <Object name="dbo.LIQUID_TYPES_RMLS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="RML_GUID" /> + <Column name="MAX_NL_PER_CM" /> + </Columns> + </Object> + <Object name="dbo.MACHINE_VERSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="VERSION" /> + <Column name="NAME" /> + <Column name="DEFAULT_CONFIGURATION_GUID" /> + </Columns> + </Object> + <Object name="dbo.MEDIA_COLORS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="L" /> + <Column name="A" /> + <Column name="B" /> + </Columns> + </Object> + <Object name="dbo.MEDIA_CONDITIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Object> + <Object name="dbo.MEDIA_MATERIALS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Object> + <Object name="dbo.MEDIA_PURPOSES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CODE" /> + </Columns> + </Object> + <Object name="dbo.MID_TANK_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="LITER_CAPACITY" /> + </Columns> + </Object> + <Object name="dbo.PERMISSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.PROCESS_PARAMETERS_TABLES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="DYEING_SPEED" /> + <Column name="MIN_INK_UPTAKE" /> + <Column name="FEEDER_TENSION" /> + <Column name="PULLER_TENSION" /> + <Column name="WINDER_TENSION" /> + <Column name="MIXER_TEMP" /> + <Column name="HEAD_ZONE1_TEMP" /> + <Column name="HEAD_ZONE2_TEMP" /> + <Column name="HEAD_ZONE3_TEMP" /> + <Column name="HEAD_ZONE4_TEMP" /> + <Column name="HEAD_ZONE5_TEMP" /> + <Column name="HEAD_ZONE6_TEMP" /> + <Column name="DRYER_AIR_FLOW" /> + <Column name="DRYER_ZONE1_TEMP" /> + <Column name="DRYER_ZONE2_TEMP" /> + <Column name="DRYER_ZONE3_TEMP" /> + <Column name="DRYER_BUFFER_LENGTH" /> + <Column name="HEAD_AIR_FLOW" /> + <Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" /> + <Column name="TABLE_INDEX" /> + </Columns> + </Object> + <Object name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="RML_GUID" /> + <Column name="NAME" /> + <Column name="ACTIVE" /> + <Column name="SAVE_DATE" /> + </Columns> + </Object> + <Object name="dbo.RMLS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="MANUFACTURER" /> + <Column name="CODE" /> + <Column name="MEDIA_MATERIAL_GUID" /> + <Column name="MEDIA_COLOR_GUID" /> + <Column name="MEDIA_PURPOSE_GUID" /> + <Column name="MEDIA_CONDITION_GUID" /> + <Column name="LINEAR_MASS_DENSITY_UNIT_GUID" /> + <Column name="FIBER_SHAPE_GUID" /> + <Column name="FIBER_SYNTH_GUID" /> + <Column name="FIBER_SIZE" /> + <Column name="NUMBER_OF_FIBERS" /> + <Column name="PLIES_PER_FIBER" /> + <Column name="PLIES_PER_THREAD" /> + <Column name="TWISTED" /> + <Column name="AIR_ENTANGLEMENT" /> + <Column name="LUBRICANT" /> + <Column name="TENSILE_STRENGTH" /> + <Column name="ELONGATION_AT_BREAK_PERCENTAGE" /> + <Column name="ESTIMATED_THREAD_DIAMETER" /> + </Columns> + </Object> + <Object name="dbo.ROLES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.ROLES_PERMISSIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="ROLE_GUID" /> + <Column name="PERMISSION_GUID" /> + </Columns> + </Object> + <Object name="dbo.SPOOL_TYPES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="LENGTH" /> + <Column name="WEIGHT" /> + <Column name="DIAMETER" /> + <Column name="START_OFFSET_PULSES" /> + <Column name="BACKING_RATE" /> + <Column name="SEGMENT_OFFSET_PULSES" /> + <Column name="BOTTOM_BACKING_RATE" /> + <Column name="ROTATIONS_PER_PASSAGE" /> + </Columns> + </Object> + <Object name="dbo.SYNC_CONFIGURATIONS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="ID" key="true" /> + <Column name="TABLE_NAME" /> + <Column name="SYNC_TYPE" /> + </Columns> + </Object> + <Object name="dbo.TECH_CONTROLLERS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="MIN" /> + <Column name="MAX" /> + <Column name="UNITS" /> + </Columns> + </Object> + <Object name="dbo.TECH_DISPENSERS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.TECH_IOS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="PORT" /> + <Column name="TYPE" /> + <Column name="DESIGNATOR" /> + <Column name="ASM" /> + <Column name="INTERFACE_NAME" /> + <Column name="SENSOR" /> + <Column name="INIT_VALUE" /> + <Column name="AVERAGING" /> + <Column name="MIN" /> + <Column name="MAX" /> + </Columns> + </Object> + <Object name="dbo.TECH_MONITORS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + <Column name="MIN" /> + <Column name="MAX" /> + <Column name="UNITS" /> + <Column name="POINTS_PER_FRAME" /> + <Column name="MULTI_CHANNEL" /> + <Column name="CHANNEL_COUNT" /> + </Columns> + </Object> + <Object name="dbo.TECH_VALVES" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + <Object name="dbo.WINDING_METHODS" type="table" records="OnlyDb1, OnlyDb2, OnlyDifferent"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CODE" /> + <Column name="NAME" /> + <Column name="DESCRIPTION" /> + </Columns> + </Object> + </ObjectList> + </Objects> +</config> + diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/ProvisionMachine.xml b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/ProvisionMachine.xml new file mode 100644 index 000000000..99f726462 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/ProvisionMachine.xml @@ -0,0 +1,560 @@ +<?xml version="1.0" encoding="utf-16"?> +<config version="2" maker="SQL Data Examiner"> + <DataSources> + <DataSource id="1" server="localhost\SQLEXPRESS" database="Tango" login="Synchronizer" password="Aa123456" /> + <DataSource id="2" server="twine.local\SQLTWINE" database="Tango" winAuth="True" /> + </DataSources> + <Actions> + <Action type="synchronize" /> + <Action type="report" path="C:\Users\Roy\Documents\%DB1_%DB2_%YYYY%MM%DD.htm" reportOn="Different, Same, OnlyInDb1, OnlyInDb2" /> + </Actions> + <Options> + <ComparisonOptions> + <ComparisonOption name="CompareTrimmedStrings" value="False" /> + <ComparisonOption name="EmptyEqualsNull" value="False" /> + <ComparisonOption name="ComparisonCaseSensitive" value="CaseSensitive" /> + <ComparisonOption name="AutoSelectKeyColumns" value="None" /> + </ComparisonOptions> + <PerformanceOptions> + <PerformanceOption name="Auto" value="True" /> + </PerformanceOptions> + <SyncOptions> + <SyncOption name="SynchronizeIdentity" value="True" /> + <SyncOption name="UseTransaction" value="True" /> + <SyncOption name="DoNotStopOnErrors" value="False" /> + <SyncOption name="DisableTriggers" value="True" /> + <SyncOption name="DisableUniques" value="True" /> + <SyncOption name="DisableForeignKeys" value="True" /> + <SyncOption name="SetAnsiWarningsOff" value="False" /> + <SyncOption name="SqlBatchMode" value="True" /> + <SyncOption name="SqlBatchSize" value="1MB" /> + <SyncOption name="PrecedeStringConstWithNPrefix" value="Always" /> + </SyncOptions> + <AdditionalOptions> + <AdditionalOption name="Nolog" value="True" /> + </AdditionalOptions> + </Options> + <Objects> + <SchemaMapping> + <SMItem schema1="dbo" schema2="dbo" /> + </SchemaMapping> + <ObjectList type="include"> + <Object name="Sync_Addresses" type="query"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="ADDRESS_STRING" /> + <Column name="LOCALITY" /> + <Column name="COUNTRY" /> + <Column name="CITY" /> + <Column name="STATE" /> + <Column name="COUNTRY_CODE" /> + <Column name="POSTAL_CODE" /> + </Columns> + <Queries> + <Query id="1"> + <Text> + <![CDATA[SELECT DISTINCT ADDRESSES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]> + </Text> + <UpdateTables> + <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="ADDRESS_STRING" /> + <UpdateColumn name="LOCALITY" /> + <UpdateColumn name="COUNTRY" /> + <UpdateColumn name="CITY" /> + <UpdateColumn name="STATE" /> + <UpdateColumn name="COUNTRY_CODE" /> + <UpdateColumn name="POSTAL_CODE" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text> + <![CDATA[SELECT DISTINCT ADDRESSES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]> + </Text> + <UpdateTables> + <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="ADDRESS_STRING" /> + <UpdateColumn name="LOCALITY" /> + <UpdateColumn name="COUNTRY" /> + <UpdateColumn name="CITY" /> + <UpdateColumn name="STATE" /> + <UpdateColumn name="COUNTRY_CODE" /> + <UpdateColumn name="POSTAL_CODE" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Object> + <Object name="Sync_Configuration" type="query"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CREATION_DATE" /> + <Column name="APPLICATION_VERSION_GUID" /> + <Column name="APPLICATION_OS_VERSION_GUID" /> + <Column name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <Column name="HARDWARE_VERSION_GUID" /> + </Columns> + <Queries> + <Query id="1"> + <Text> + <![CDATA[SELECT CONFIGURATIONS.* +FROM CONFIGURATIONS +INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID +WHERE MACHINES.SERIAL_NUMBER = '@']]> + </Text> + <UpdateTables> + <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CREATION_DATE" /> + <UpdateColumn name="APPLICATION_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_OS_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <UpdateColumn name="HARDWARE_VERSION_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text> + <![CDATA[SELECT CONFIGURATIONS.* +FROM CONFIGURATIONS +INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID +WHERE MACHINES.SERIAL_NUMBER = '@']]> + </Text> + <UpdateTables> + <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CREATION_DATE" /> + <UpdateColumn name="APPLICATION_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_OS_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" /> + <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" /> + <UpdateColumn name="HARDWARE_VERSION_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Object> + <Object name="Sync_Contacts" type="query"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="FIRST_NAME" /> + <Column name="LAST_NAME" /> + <Column name="FULL_NAME" /> + <Column name="EMAIL" /> + <Column name="PHONE_NUMBER" /> + <Column name="FAX" /> + </Columns> + <Queries> + <Query id="1"> + <Text> + <![CDATA[SELECT DISTINCT CONTACTS.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]> + </Text> + <UpdateTables> + <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="FIRST_NAME" /> + <UpdateColumn name="LAST_NAME" /> + <UpdateColumn name="FULL_NAME" /> + <UpdateColumn name="EMAIL" /> + <UpdateColumn name="PHONE_NUMBER" /> + <UpdateColumn name="FAX" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text> + <![CDATA[SELECT DISTINCT CONTACTS.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]> + </Text> + <UpdateTables> + <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="FIRST_NAME" /> + <UpdateColumn name="LAST_NAME" /> + <UpdateColumn name="FULL_NAME" /> + <UpdateColumn name="EMAIL" /> + <UpdateColumn name="PHONE_NUMBER" /> + <UpdateColumn name="FAX" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Object> + <Object name="Sync_IdsPacks" type="query"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="CONFIGURATION_GUID" /> + <Column name="DISPENSER_TYPE_GUID" /> + <Column name="LIQUID_TYPE_GUID" /> + <Column name="CARTRIDGE_TYPE_GUID" /> + <Column name="MID_TANK_TYPE_GUID" /> + <Column name="IDS_PACK_FORMULA_GUID" /> + <Column name="NAME" /> + <Column name="PACK_INDEX" /> + <Column name="IS_EMPTY" /> + </Columns> + <Queries> + <Query id="1"> + <Text> + <![CDATA[SELECT IDS_PACKS.* + +FROM MACHINES + INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID + INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@' +]]> + </Text> + </Query> + <Query id="2"> + <Text> + <![CDATA[SELECT IDS_PACKS.* + +FROM MACHINES + INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID + INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID + +WHERE MACHINES.SERIAL_NUMBER = '@' +]]> + </Text> + <UpdateTables> + <Table schema="dbo" name="IDS_PACKS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="CONFIGURATION_GUID" /> + <UpdateColumn name="DISPENSER_TYPE_GUID" /> + <UpdateColumn name="LIQUID_TYPE_GUID" /> + <UpdateColumn name="CARTRIDGE_TYPE_GUID" /> + <UpdateColumn name="MID_TANK_TYPE_GUID" /> + <UpdateColumn name="IDS_PACK_FORMULA_GUID" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="PACK_INDEX" /> + <UpdateColumn name="IS_EMPTY" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Object> + <Object name="Sync_Machine" type="query"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="SERIAL_NUMBER" /> + <Column name="NAME" /> + <Column name="PRODUCTION_DATE" /> + <Column name="ORGANIZATION_GUID" /> + <Column name="MACHINE_VERSION_GUID" /> + <Column name="CONFIGURATION_GUID" /> + <Column name="ENABLE_EXTERNAL_BRIDGE" /> + <Column name="EXTERNAL_BRIDGE_PASSWORD" /> + <Column name="DEFAULT_RML_GUID" /> + <Column name="TARGET_JOB_TYPES" /> + <Column name="DEFAULT_COLOR_SPACE_GUID" /> + <Column name="DEFAULT_SEGMENT_LENGTH" /> + <Column name="DEFAULT_SPOOL_TYPE_GUID" /> + <Column name="SYNCHED" /> + </Columns> + <Queries> + <Query id="1"> + <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="SERIAL_NUMBER" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="PRODUCTION_DATE" /> + <UpdateColumn name="ORGANIZATION_GUID" /> + <UpdateColumn name="MACHINE_VERSION_GUID" /> + <UpdateColumn name="CONFIGURATION_GUID" /> + <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" /> + <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" /> + <UpdateColumn name="DEFAULT_RML_GUID" /> + <UpdateColumn name="TARGET_JOB_TYPES" /> + <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" /> + <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" /> + <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" /> + <UpdateColumn name="SYNCHED" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text> + <UpdateTables> + <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="SERIAL_NUMBER" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="PRODUCTION_DATE" /> + <UpdateColumn name="ORGANIZATION_GUID" /> + <UpdateColumn name="MACHINE_VERSION_GUID" /> + <UpdateColumn name="CONFIGURATION_GUID" /> + <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" /> + <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" /> + <UpdateColumn name="DEFAULT_RML_GUID" /> + <UpdateColumn name="TARGET_JOB_TYPES" /> + <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" /> + <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" /> + <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" /> + <UpdateColumn name="SYNCHED" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Object> + <Object name="Sync_Organization" type="query"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="NAME" /> + <Column name="CONTACT_GUID" /> + <Column name="ADDRESS_GUID" /> + </Columns> + <Queries> + <Query id="1"> + <Text> + <![CDATA[SELECT ORGANIZATIONS.* + +FROM ORGANIZATIONS + +INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]> + </Text> + <UpdateTables> + <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CONTACT_GUID" /> + <UpdateColumn name="ADDRESS_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text> + <![CDATA[SELECT ORGANIZATIONS.* + +FROM ORGANIZATIONS + +INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]> + </Text> + <UpdateTables> + <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="NAME" /> + <UpdateColumn name="CONTACT_GUID" /> + <UpdateColumn name="ADDRESS_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Object> + <Object name="Sync_UsersRoles" type="query"> + <Columns> + <Column name="GUID" key="true" /> + <Column name="ID" /> + <Column name="LAST_UPDATED" /> + <Column name="DELETED" /> + <Column name="USER_GUID" /> + <Column name="ROLE_GUID" /> + </Columns> + <Queries> + <Query id="1"> + <Text> + <![CDATA[SELECT DISTINCT USERS_ROLES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]> + </Text> + <UpdateTables> + <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="USER_GUID" /> + <UpdateColumn name="ROLE_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + <Query id="2"> + <Text> + <![CDATA[SELECT DISTINCT USERS_ROLES.* + +FROM ORGANIZATIONS + +LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID +LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID +LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID + +WHERE MACHINES.SERIAL_NUMBER = '@']]> + </Text> + <UpdateTables> + <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True"> + <KeyColumns> + <KeyColumn name="GUID" /> + </KeyColumns> + <UpdateColumns> + <UpdateColumn name="ID" /> + <UpdateColumn name="GUID" /> + <UpdateColumn name="LAST_UPDATED" /> + <UpdateColumn name="DELETED" /> + <UpdateColumn name="USER_GUID" /> + <UpdateColumn name="ROLE_GUID" /> + </UpdateColumns> + </Table> + </UpdateTables> + </Query> + </Queries> + </Object> + </ObjectList> + </Objects> +</config> + diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/Schema.xml b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/Schema.xml Binary files differnew file mode 100644 index 000000000..8aab9ee1b --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Configurations/Schema.xml diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Interop.MSDASC.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Interop.MSDASC.dll Binary files differnew file mode 100644 index 000000000..0a7ae1c77 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/Interop.MSDASC.dll diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/License.lic b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/License.lic new file mode 100644 index 000000000..377894bba --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/License.lic @@ -0,0 +1 @@ +5lpcKnrNcQo4qolt46ab+yKW8NAq5WtFuPbvjdTl2SLX3qb8f6YTZpaZwa93aV+aBJUaf+HQrBauC/Fd1eiq9NquvvJpGiu94E5ZO5UrE12/fv8BiXG62PUI2gRD7UAcAw1BhHkeRsQ79kqyUaVJNTl2Cy3Sb9Xy6GKVaYWHLAnT0U/Nh1kiOXWJsiSwTFeKmiij9QSwd2zDFeQT1gyqZPKu/+JqADZckY5WiKm8XFz94iMBCpMmocccW2yc+wxDVWLpX3ExtodavcUbaB5paRwjQgUf/u0x5zi+i0xtasjrcLC5kv7dYdJTRuGTqg2Jop1PQEML62wN8jvrKKShrGlm/VpzfODBOrF8SYYqVuUJMonofAUrmmiFNTIuZdhCQT6ZPzNXDwKLVr7nkAqFiUot41jozp16brPaSBuiw6kaoT6NKI5HpuW7ECvIRv8dnraC1nf2C52wirCo9w9+LE3jF10gBZ2DLWR6LMGbtYO7+KBglC4CVeCy4dqiS4kC5JJ/nckOvkqKSrZO+Q/70iz6F8cCshKKR6Ni+uKCQGSs+vbHcukJXdQxMy3CvwBF0mwqNXrByuj5XBAd67ShcoPtSHJy0MhonxDnNyNptsbT3FBqGGV1b0bg02kDrRqpSrme6d+sL4yrJbtaTrpC0yT+7cgLk/YDDGDmIQCParywPh75C7NOAj4ZpcCLujDJI86U9O+j3m5u/BJ6yZobmcBEsw2qvqjqK9/09F1qb+f9w2NvXxugsKwk7Uf/ji0TSImp2OvDourEbq+XxOhBZg==
\ No newline at end of file diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Binary.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Binary.dll Binary files differnew file mode 100644 index 000000000..c75112cb3 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Binary.dll diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CodeView.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CodeView.dll Binary files differnew file mode 100644 index 000000000..e6841fda1 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CodeView.dll diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonTypes.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonTypes.dll Binary files differnew file mode 100644 index 000000000..c0c0b941f --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonTypes.dll diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonUI.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonUI.dll Binary files differnew file mode 100644 index 000000000..9a4bc8e42 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.CommonUI.dll diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SCBaseProvider.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SCBaseProvider.dll Binary files differnew file mode 100644 index 000000000..2c314b5a6 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SCBaseProvider.dll diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLDataExaminer.Engine.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLDataExaminer.Engine.dll Binary files differnew file mode 100644 index 000000000..a7dbc04ac --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLDataExaminer.Engine.dll diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLExaminer.Engine.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLExaminer.Engine.dll Binary files differnew file mode 100644 index 000000000..37dfba5bc --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.SQLExaminer.Engine.dll diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Utils.ErrorReporter.dll b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Utils.ErrorReporter.dll Binary files differnew file mode 100644 index 000000000..bbf9edc29 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SA.Utils.ErrorReporter.dll diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLDECmd.exe b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLDECmd.exe Binary files differnew file mode 100644 index 000000000..5399a70b9 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLDECmd.exe diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLECmd.exe b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLECmd.exe Binary files differnew file mode 100644 index 000000000..b1671b397 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SQLExaminer/SQLECmd.exe diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SchemaMapping.cs b/Software/Visual_Studio/Tango.SQLExaminer/SchemaMapping.cs new file mode 100644 index 000000000..b76f192f9 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SchemaMapping.cs @@ -0,0 +1,13 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; + +namespace Tango.SQLExaminer +{ + public class SchemaMapping : List<SMItem> + { + + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/SyncOption.cs b/Software/Visual_Studio/Tango.SQLExaminer/SyncOption.cs new file mode 100644 index 000000000..5b2b053f0 --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/SyncOption.cs @@ -0,0 +1,18 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class SyncOption + { + [XmlAttribute("name")] + public String Name { get; set; } + + [XmlAttribute("value")] + public String Value { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Table.cs b/Software/Visual_Studio/Tango.SQLExaminer/Table.cs new file mode 100644 index 000000000..e09792b0b --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/Table.cs @@ -0,0 +1,37 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class Table + { + [XmlAttribute("schema")] + public String Schema { get; set; } + + [XmlAttribute("name")] + public String Name { get; set; } + + [XmlAttribute("allowDelete")] + public String AllowDelete { get; set; } + + [XmlAttribute("allowInsert")] + public String AllowInsert { get; set; } + + [XmlAttribute("allowUpdate")] + public String AllowUpdate { get; set; } + + public List<KeyColumn> KeyColumns { get; set; } + + public List<UpdateColumn> UpdateColumns { get; set; } + + public Table() + { + KeyColumns = new List<KeyColumn>(); + UpdateColumns = new List<UpdateColumn>(); + } + } +} diff --git a/Software/Visual_Studio/Tango.SQLExaminer/Tango.SQLExaminer.csproj b/Software/Visual_Studio/Tango.SQLExaminer/Tango.SQLExaminer.csproj new file mode 100644 index 000000000..4858d8eaa --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/Tango.SQLExaminer.csproj @@ -0,0 +1,125 @@ +<?xml version="1.0" encoding="utf-8"?> +<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> + <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" /> + <PropertyGroup> + <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration> + <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform> + <ProjectGuid>{E1E66ED9-597D-45FA-8048-DE90A6930484}</ProjectGuid> + <OutputType>Library</OutputType> + <AppDesignerFolder>Properties</AppDesignerFolder> + <RootNamespace>Tango.SQLExaminer</RootNamespace> + <AssemblyName>Tango.SQLExaminer</AssemblyName> + <TargetFrameworkVersion>v4.6</TargetFrameworkVersion> + <FileAlignment>512</FileAlignment> + </PropertyGroup> + <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' "> + <DebugSymbols>true</DebugSymbols> + <DebugType>full</DebugType> + <Optimize>false</Optimize> + <OutputPath>..\Build\Debug\</OutputPath> + <DefineConstants>DEBUG;TRACE</DefineConstants> + <ErrorReport>prompt</ErrorReport> + <WarningLevel>4</WarningLevel> + </PropertyGroup> + <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' "> + <DebugType>pdbonly</DebugType> + <Optimize>true</Optimize> + <OutputPath>..\Build\Release\</OutputPath> + <DefineConstants>TRACE</DefineConstants> + <ErrorReport>prompt</ErrorReport> + <WarningLevel>4</WarningLevel> + </PropertyGroup> + <ItemGroup> + <Reference Include="System" /> + <Reference Include="System.Core" /> + <Reference Include="System.Xml.Linq" /> + <Reference Include="System.Data.DataSetExtensions" /> + <Reference Include="Microsoft.CSharp" /> + <Reference Include="System.Data" /> + <Reference Include="System.Net.Http" /> + <Reference Include="System.Xml" /> + </ItemGroup> + <ItemGroup> + <Compile Include="..\Versioning\GlobalVersionInfo.cs"> + <Link>GlobalVersionInfo.cs</Link> + </Compile> + <Compile Include="Action.cs" /> + <Compile Include="AdditionalOption.cs" /> + <Compile Include="Column.cs" /> + <Compile Include="ComparisonOption.cs" /> + <Compile Include="DataSource.cs" /> + <Compile Include="ExaminerConfiguration.cs" /> + <Compile Include="ExaminerConfigurationBuilder.cs" /> + <Compile Include="ExaminerConfigurationType.cs" /> + <Compile Include="Filter.cs" /> + <Compile Include="IncludeItem.cs" /> + <Compile Include="KeyColumn.cs" /> + <Compile Include="Object.cs" /> + <Compile Include="ObjectList.cs" /> + <Compile Include="Objects.cs" /> + <Compile Include="Options.cs" /> + <Compile Include="PerformanceOption.cs" /> + <Compile Include="Properties\AssemblyInfo.cs" /> + <Compile Include="Query.cs" /> + <Compile Include="SchemaMapping.cs" /> + <Compile Include="SMItem.cs" /> + <Compile Include="SyncOption.cs" /> + <Compile Include="Table.cs" /> + <Compile Include="UpdateColumn.cs" /> + </ItemGroup> + <ItemGroup> + <Content Include="SQLExaminer\Configurations\OverrideData.xml"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\Configurations\ProvisionMachine.xml" /> + <Content Include="SQLExaminer\Configurations\Schema.xml"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\Interop.MSDASC.dll"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\SA.Binary.dll"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\SA.CodeView.dll"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\SA.CommonTypes.dll"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\SA.CommonUI.dll"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\SA.SCBaseProvider.dll"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\SA.SQLDataExaminer.Engine.dll"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\SA.SQLExaminer.Engine.dll"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\SA.Utils.ErrorReporter.dll"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\SQLDECmd.exe"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + <Content Include="SQLExaminer\SQLECmd.exe"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + </ItemGroup> + <ItemGroup> + <Content Include="SQLExaminer\License.lic"> + <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory> + </Content> + </ItemGroup> + <ItemGroup /> + <ItemGroup> + <ProjectReference Include="..\Tango.Core\Tango.Core.csproj"> + <Project>{a34ee0f0-649d-41c8-8489-b6f1cc6924ee}</Project> + <Name>Tango.Core</Name> + </ProjectReference> + </ItemGroup> + <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" /> +</Project>
\ No newline at end of file diff --git a/Software/Visual_Studio/Tango.SQLExaminer/UpdateColumn.cs b/Software/Visual_Studio/Tango.SQLExaminer/UpdateColumn.cs new file mode 100644 index 000000000..cfac5d1bc --- /dev/null +++ b/Software/Visual_Studio/Tango.SQLExaminer/UpdateColumn.cs @@ -0,0 +1,15 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; +using System.Threading.Tasks; +using System.Xml.Serialization; + +namespace Tango.SQLExaminer +{ + public class UpdateColumn + { + [XmlAttribute("name")] + public String Name { get; set; } + } +} diff --git a/Software/Visual_Studio/Tango.sln b/Software/Visual_Studio/Tango.sln index 65b1ca8e8..ee189e840 100644 --- a/Software/Visual_Studio/Tango.sln +++ b/Software/Visual_Studio/Tango.sln @@ -212,6 +212,8 @@ Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Tango.PPC.MachineSettings", EndProject Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Tango.CSV", "Tango.CSV\Tango.CSV.csproj", "{58E8825F-0C96-449C-B320-1E82B0AA876B}" EndProject +Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Tango.SQLExaminer", "Tango.SQLExaminer\Tango.SQLExaminer.csproj", "{E1E66ED9-597D-45FA-8048-DE90A6930484}" +EndProject Global GlobalSection(SolutionConfigurationPlatforms) = preSolution AppVeyor|Any CPU = AppVeyor|Any CPU @@ -3691,6 +3693,46 @@ Global {58E8825F-0C96-449C-B320-1E82B0AA876B}.Release|x64.Build.0 = Release|x64 {58E8825F-0C96-449C-B320-1E82B0AA876B}.Release|x86.ActiveCfg = Release|x86 {58E8825F-0C96-449C-B320-1E82B0AA876B}.Release|x86.Build.0 = Release|x86 + {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|Any CPU.ActiveCfg = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|Any CPU.Build.0 = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|ARM.ActiveCfg = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|ARM.Build.0 = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|ARM64.ActiveCfg = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|ARM64.Build.0 = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|x64.ActiveCfg = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|x64.Build.0 = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|x86.ActiveCfg = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.AppVeyor|x86.Build.0 = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|Any CPU.ActiveCfg = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|Any CPU.Build.0 = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|ARM.ActiveCfg = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|ARM.Build.0 = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|ARM64.ActiveCfg = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|ARM64.Build.0 = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|x64.ActiveCfg = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|x64.Build.0 = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|x86.ActiveCfg = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Debug|x86.Build.0 = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|Any CPU.ActiveCfg = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|Any CPU.Build.0 = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|ARM.ActiveCfg = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|ARM.Build.0 = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|ARM64.ActiveCfg = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|ARM64.Build.0 = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|x64.ActiveCfg = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|x64.Build.0 = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|x86.ActiveCfg = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.DefaultBuild|x86.Build.0 = Debug|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|Any CPU.ActiveCfg = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|Any CPU.Build.0 = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|ARM.ActiveCfg = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|ARM.Build.0 = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|ARM64.ActiveCfg = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|ARM64.Build.0 = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|x64.ActiveCfg = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|x64.Build.0 = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|x86.ActiveCfg = Release|Any CPU + {E1E66ED9-597D-45FA-8048-DE90A6930484}.Release|x86.Build.0 = Release|Any CPU EndGlobalSection GlobalSection(SolutionProperties) = preSolution HideSolutionNode = FALSE |
