2015-10-24 01:03:54,647 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={reportsdb-000}
2015-10-24 01:03:56,038 INFO [reportsdb-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Microsoft SQL Server', version '11', protocol 'jtds'
2015-10-24 01:03:56,116 INFO [reportsdb-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform
2015-10-24 01:03:56,757 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect
2015-10-24 01:03:56,882 INFO [reportsdb-000] [StagingManager] [main] The staging directory was initialized at the following location: C:\Users\Faraz\Desktop\destination-node\symmetric-server-3.7.25\tmp\reportsdb-000
2015-10-24 01:03:57,272 INFO [reportsdb-000] [ClusterService] [main] This node picked a server id of BREPORTSDBVM
2015-10-24 01:03:59,647 INFO [reportsdb-000] [ClientExtensionService] [main] Found 9 extension points from spring that will be registered
2015-10-24 01:03:59,647 INFO [reportsdb-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database
2015-10-24 01:03:59,647 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Checking if SymmetricDS tables need created or altered
2015-10-24 01:04:02,413 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] There are SymmetricDS tables that needed altered
2015-10-24 01:04:02,429 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,429 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,507 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_channel"(
    "channel_id" VARCHAR(128) NOT NULL,
    "processing_order" INT DEFAULT 1 NOT NULL,
    "max_batch_size" INT DEFAULT 1000 NOT NULL,
    "max_batch_to_send" INT DEFAULT 60 NOT NULL,
    "max_data_to_route" INT DEFAULT 100000 NOT NULL,
    "extract_period_millis" INT DEFAULT 0 NOT NULL,
    "enabled" SMALLINT DEFAULT 1 NOT NULL,
    "use_old_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
    "use_row_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
    "use_pk_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
    "reload_flag" SMALLINT DEFAULT 0 NOT NULL,
    "file_sync_flag" SMALLINT DEFAULT 0 NOT NULL,
    "contains_big_lob" SMALLINT DEFAULT 0 NOT NULL,
    "batch_algorithm" VARCHAR(50) DEFAULT 'default' NOT NULL,
    "data_loader_type" VARCHAR(50) DEFAULT 'default' NOT NULL,
    "description" VARCHAR(255),
    "create_time" DATETIME,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME,
    PRIMARY KEY ("channel_id")
)
2015-10-24 01:04:02,522 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,538 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_conflict"(
    "conflict_id" VARCHAR(50) NOT NULL,
    "source_node_group_id" VARCHAR(50) NOT NULL,
    "target_node_group_id" VARCHAR(50) NOT NULL,
    "target_channel_id" VARCHAR(128),
    "target_catalog_name" VARCHAR(255),
    "target_schema_name" VARCHAR(255),
    "target_table_name" VARCHAR(255),
    "detect_type" VARCHAR(128) NOT NULL,
    "detect_expression" TEXT,
    "resolve_type" VARCHAR(128) NOT NULL,
    "ping_back" VARCHAR(128) NOT NULL,
    "resolve_changes_only" SMALLINT DEFAULT 0,
    "resolve_row_only" SMALLINT DEFAULT 0,
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("conflict_id")
)
2015-10-24 01:04:02,663 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,679 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data"(
    "data_id" BIGINT NOT NULL IDENTITY (1,1) ,
    "table_name" VARCHAR(255) NOT NULL,
    "event_type" CHAR(1) NOT NULL,
    "row_data" TEXT,
    "pk_data" TEXT,
    "old_data" TEXT,
    "trigger_hist_id" INT NOT NULL,
    "channel_id" VARCHAR(128),
    "transaction_id" VARCHAR(255),
    "source_node_id" VARCHAR(50),
    "external_data" VARCHAR(50),
    "node_list" VARCHAR(255),
    "create_time" DATETIME,
    PRIMARY KEY ("data_id")
)
2015-10-24 01:04:02,694 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_d_channel_id" ON "sym_data" ("data_id", "channel_id")
2015-10-24 01:04:02,710 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,725 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_event"(
    "data_id" BIGINT NOT NULL,
    "batch_id" BIGINT NOT NULL,
    "router_id" VARCHAR(50) NOT NULL,
    "create_time" DATETIME,
    PRIMARY KEY ("data_id", "batch_id", "router_id")
)
2015-10-24 01:04:02,725 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_de_batchid" ON "sym_data_event" ("batch_id")
2015-10-24 01:04:02,741 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,757 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_gap"(
    "start_id" BIGINT NOT NULL,
    "end_id" BIGINT NOT NULL,
    "status" CHAR(2),
    "create_time" DATETIME NOT NULL,
    "last_update_hostname" VARCHAR(255),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("start_id", "end_id")
)
2015-10-24 01:04:02,772 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_dg_status" ON "sym_data_gap" ("status")
2015-10-24 01:04:02,788 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,804 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_extension"(
    "extension_id" VARCHAR(50) NOT NULL,
    "extension_type" VARCHAR(10) NOT NULL,
    "interface_name" VARCHAR(255),
    "node_group_id" VARCHAR(50) NOT NULL,
    "enabled" SMALLINT DEFAULT 1 NOT NULL,
    "extension_order" INT DEFAULT 1 NOT NULL,
    "extension_text" TEXT,
    "create_time" DATETIME,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME,
    PRIMARY KEY ("extension_id")
)
2015-10-24 01:04:02,819 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,835 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_extract_request"(
    "request_id" BIGINT NOT NULL,
    "node_id" VARCHAR(50) NOT NULL,
    "status" CHAR(2),
    "start_batch_id" BIGINT NOT NULL,
    "end_batch_id" BIGINT NOT NULL,
    "trigger_id" VARCHAR(128) NOT NULL,
    "router_id" VARCHAR(50) NOT NULL,
    "last_update_time" DATETIME,
    "create_time" DATETIME,
    PRIMARY KEY ("request_id")
)
2015-10-24 01:04:02,835 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,850 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_incoming"(
    "relative_dir" VARCHAR(255) NOT NULL,
    "file_name" VARCHAR(128) NOT NULL,
    "last_event_type" CHAR(1) NOT NULL,
    "node_id" VARCHAR(50) NOT NULL,
    "file_modified_time" BIGINT,
    PRIMARY KEY ("relative_dir", "file_name")
)
2015-10-24 01:04:02,850 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_snapshot"(
    "trigger_id" VARCHAR(128) NOT NULL,
    "router_id" VARCHAR(50) NOT NULL,
    "relative_dir" VARCHAR(255) NOT NULL,
    "file_name" VARCHAR(128) NOT NULL,
    "channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
    "reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
    "last_event_type" CHAR(1) NOT NULL,
    "crc32_checksum" BIGINT,
    "file_size" BIGINT,
    "file_modified_time" BIGINT,
    "last_update_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "create_time" DATETIME NOT NULL,
    PRIMARY KEY ("trigger_id", "router_id", "relative_dir", "file_name")
)
2015-10-24 01:04:02,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_f_snpsht_chid" ON "sym_file_snapshot" ("reload_channel_id")
2015-10-24 01:04:02,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,882 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_trigger"(
    "trigger_id" VARCHAR(128) NOT NULL,
    "channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
    "reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
    "base_dir" VARCHAR(255) NOT NULL,
    "recurse" SMALLINT DEFAULT 1 NOT NULL,
    "includes_files" VARCHAR(255),
    "excludes_files" VARCHAR(255),
    "sync_on_create" SMALLINT DEFAULT 1 NOT NULL,
    "sync_on_modified" SMALLINT DEFAULT 1 NOT NULL,
    "sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
    "sync_on_ctl_file" SMALLINT DEFAULT 0 NOT NULL,
    "delete_after_sync" SMALLINT DEFAULT 0 NOT NULL,
    "before_copy_script" TEXT,
    "after_copy_script" TEXT,
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("trigger_id")
)
2015-10-24 01:04:02,882 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_trigger_router"(
    "trigger_id" VARCHAR(128) NOT NULL,
    "router_id" VARCHAR(50) NOT NULL,
    "enabled" SMALLINT DEFAULT 1 NOT NULL,
    "initial_load_enabled" SMALLINT DEFAULT 1 NOT NULL,
    "target_base_dir" VARCHAR(255),
    "conflict_strategy" VARCHAR(128) DEFAULT 'source_wins' NOT NULL,
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("trigger_id", "router_id")
)
2015-10-24 01:04:02,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_grouplet"(
    "grouplet_id" VARCHAR(50) NOT NULL,
    "grouplet_link_policy" CHAR(1) DEFAULT 'I' NOT NULL,
    "description" VARCHAR(255),
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("grouplet_id")
)
2015-10-24 01:04:02,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,913 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_grouplet_link"(
    "grouplet_id" VARCHAR(50) NOT NULL,
    "external_id" VARCHAR(255) NOT NULL,
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("grouplet_id", "external_id")
)
2015-10-24 01:04:02,913 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,944 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_batch"(
    "batch_id" BIGINT NOT NULL,
    "node_id" VARCHAR(50) NOT NULL,
    "channel_id" VARCHAR(128),
    "status" CHAR(2),
    "error_flag" SMALLINT DEFAULT 0,
    "network_millis" BIGINT DEFAULT 0 NOT NULL,
    "filter_millis" BIGINT DEFAULT 0 NOT NULL,
    "database_millis" BIGINT DEFAULT 0 NOT NULL,
    "failed_row_number" BIGINT DEFAULT 0 NOT NULL,
    "failed_line_number" BIGINT DEFAULT 0 NOT NULL,
    "byte_count" BIGINT DEFAULT 0 NOT NULL,
    "statement_count" BIGINT DEFAULT 0 NOT NULL,
    "fallback_insert_count" BIGINT DEFAULT 0 NOT NULL,
    "fallback_update_count" BIGINT DEFAULT 0 NOT NULL,
    "ignore_count" BIGINT DEFAULT 0 NOT NULL,
    "missing_delete_count" BIGINT DEFAULT 0 NOT NULL,
    "skip_count" BIGINT DEFAULT 0 NOT NULL,
    "sql_state" VARCHAR(10),
    "sql_code" INT DEFAULT 0 NOT NULL,
    "sql_message" TEXT,
    "last_update_hostname" VARCHAR(255),
    "last_update_time" DATETIME,
    "create_time" DATETIME,
    PRIMARY KEY ("batch_id", "node_id")
)
2015-10-24 01:04:02,944 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "sym_incoming_batch" ("create_time", "status")
2015-10-24 01:04:02,944 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_in_error" ON "sym_incoming_batch" ("error_flag")
2015-10-24 01:04:02,944 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:02,975 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_error"(
    "batch_id" BIGINT NOT NULL,
    "node_id" VARCHAR(50) NOT NULL,
    "failed_row_number" BIGINT NOT NULL,
    "failed_line_number" BIGINT DEFAULT 0 NOT NULL,
    "target_catalog_name" VARCHAR(255),
    "target_schema_name" VARCHAR(255),
    "target_table_name" VARCHAR(255) NOT NULL,
    "event_type" CHAR(1) NOT NULL,
    "binary_encoding" VARCHAR(10) DEFAULT 'HEX' NOT NULL,
    "column_names" TEXT NOT NULL,
    "pk_column_names" TEXT NOT NULL,
    "row_data" TEXT,
    "old_data" TEXT,
    "cur_data" TEXT,
    "resolve_data" TEXT,
    "resolve_ignore" SMALLINT DEFAULT 0,
    "conflict_id" VARCHAR(50),
    "create_time" DATETIME,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("batch_id", "node_id", "failed_row_number")
)
2015-10-24 01:04:02,991 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,007 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_load_filter"(
    "load_filter_id" VARCHAR(50) NOT NULL,
    "load_filter_type" VARCHAR(10) NOT NULL,
    "source_node_group_id" VARCHAR(50) NOT NULL,
    "target_node_group_id" VARCHAR(50) NOT NULL,
    "target_catalog_name" VARCHAR(255),
    "target_schema_name" VARCHAR(255),
    "target_table_name" VARCHAR(255),
    "filter_on_update" SMALLINT DEFAULT 1 NOT NULL,
    "filter_on_insert" SMALLINT DEFAULT 1 NOT NULL,
    "filter_on_delete" SMALLINT DEFAULT 1 NOT NULL,
    "before_write_script" TEXT,
    "after_write_script" TEXT,
    "batch_complete_script" TEXT,
    "batch_commit_script" TEXT,
    "batch_rollback_script" TEXT,
    "handle_error_script" TEXT,
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    "load_filter_order" INT DEFAULT 1 NOT NULL,
    "fail_on_error" SMALLINT DEFAULT 0 NOT NULL,
    PRIMARY KEY ("load_filter_id")
)
2015-10-24 01:04:03,007 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,022 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_lock"(
    "lock_action" VARCHAR(50) NOT NULL,
    "lock_type" VARCHAR(50) NOT NULL,
    "locking_server_id" VARCHAR(255),
    "lock_time" DATETIME,
    "shared_count" INT DEFAULT 0 NOT NULL,
    "shared_enable" INT DEFAULT 0 NOT NULL,
    "last_lock_time" DATETIME,
    "last_locking_server_id" VARCHAR(255),
    PRIMARY KEY ("lock_action")
)
2015-10-24 01:04:03,022 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,038 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node"(
    "node_id" VARCHAR(50) NOT NULL,
    "node_group_id" VARCHAR(50) NOT NULL,
    "external_id" VARCHAR(255) NOT NULL,
    "sync_enabled" SMALLINT DEFAULT 0,
    "sync_url" VARCHAR(255),
    "schema_version" VARCHAR(50),
    "symmetric_version" VARCHAR(50),
    "database_type" VARCHAR(50),
    "database_version" VARCHAR(50),
    "heartbeat_time" DATETIME,
    "timezone_offset" VARCHAR(6),
    "batch_to_send_count" INT DEFAULT 0,
    "batch_in_error_count" INT DEFAULT 0,
    "created_at_node_id" VARCHAR(50),
    "deployment_type" VARCHAR(50),
    PRIMARY KEY ("node_id")
)
2015-10-24 01:04:03,038 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,054 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_communication"(
    "node_id" VARCHAR(50) NOT NULL,
    "communication_type" VARCHAR(10) NOT NULL,
    "lock_time" DATETIME,
    "locking_server_id" VARCHAR(255),
    "last_lock_time" DATETIME,
    "last_lock_millis" BIGINT DEFAULT 0,
    "success_count" BIGINT DEFAULT 0,
    "fail_count" BIGINT DEFAULT 0,
    "total_success_count" BIGINT DEFAULT 0,
    "total_fail_count" BIGINT DEFAULT 0,
    "total_success_millis" BIGINT DEFAULT 0,
    "total_fail_millis" BIGINT DEFAULT 0,
    PRIMARY KEY ("node_id", "communication_type")
)
2015-10-24 01:04:03,054 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,069 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_channel_ctl"(
    "node_id" VARCHAR(50) NOT NULL,
    "channel_id" VARCHAR(128) NOT NULL,
    "suspend_enabled" SMALLINT DEFAULT 0,
    "ignore_enabled" SMALLINT DEFAULT 0,
    "last_extract_time" DATETIME,
    PRIMARY KEY ("node_id", "channel_id")
)
2015-10-24 01:04:03,069 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,069 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group"(
    "node_group_id" VARCHAR(50) NOT NULL,
    "description" VARCHAR(255),
    "create_time" DATETIME,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME,
    PRIMARY KEY ("node_group_id")
)
2015-10-24 01:04:03,069 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,085 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"(
    "node_group_id" VARCHAR(50) NOT NULL,
    "channel_id" VARCHAR(128) NOT NULL,
    "start_time" DATETIME NOT NULL,
    "end_time" DATETIME NOT NULL,
    "enabled" SMALLINT DEFAULT 0 NOT NULL,
    PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2015-10-24 01:04:03,085 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,100 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group_link"(
    "source_node_group_id" VARCHAR(50) NOT NULL,
    "target_node_group_id" VARCHAR(50) NOT NULL,
    "data_event_action" CHAR(1) DEFAULT 'W' NOT NULL,
    "sync_config_enabled" SMALLINT DEFAULT 1 NOT NULL,
    "create_time" DATETIME,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME,
    PRIMARY KEY ("source_node_group_id", "target_node_group_id")
)
2015-10-24 01:04:03,100 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,147 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host"(
    "node_id" VARCHAR(50) NOT NULL,
    "host_name" VARCHAR(60) NOT NULL,
    "ip_address" VARCHAR(50),
    "os_user" VARCHAR(50),
    "os_name" VARCHAR(50),
    "os_arch" VARCHAR(50),
    "os_version" VARCHAR(50),
    "available_processors" INT DEFAULT 0,
    "free_memory_bytes" BIGINT DEFAULT 0,
    "total_memory_bytes" BIGINT DEFAULT 0,
    "max_memory_bytes" BIGINT DEFAULT 0,
    "java_version" VARCHAR(50),
    "java_vendor" VARCHAR(255),
    "jdbc_version" VARCHAR(255),
    "symmetric_version" VARCHAR(50),
    "timezone_offset" VARCHAR(6),
    "heartbeat_time" DATETIME,
    "last_restart_time" DATETIME NOT NULL,
    "create_time" DATETIME NOT NULL,
    PRIMARY KEY ("node_id", "host_name")
)
2015-10-24 01:04:03,147 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,179 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_channel_stats"(
    "node_id" VARCHAR(50) NOT NULL,
    "host_name" VARCHAR(60) NOT NULL,
    "channel_id" VARCHAR(128) NOT NULL,
    "start_time" DATETIME NOT NULL,
    "end_time" DATETIME NOT NULL,
    "data_routed" BIGINT DEFAULT 0,
    "data_unrouted" BIGINT DEFAULT 0,
    "data_event_inserted" BIGINT DEFAULT 0,
    "data_extracted" BIGINT DEFAULT 0,
    "data_bytes_extracted" BIGINT DEFAULT 0,
    "data_extracted_errors" BIGINT DEFAULT 0,
    "data_bytes_sent" BIGINT DEFAULT 0,
    "data_sent" BIGINT DEFAULT 0,
    "data_sent_errors" BIGINT DEFAULT 0,
    "data_loaded" BIGINT DEFAULT 0,
    "data_bytes_loaded" BIGINT DEFAULT 0,
    "data_loaded_errors" BIGINT DEFAULT 0,
    PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2015-10-24 01:04:03,179 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "sym_node_host_channel_stats" ("node_id", "start_time", "end_time")
2015-10-24 01:04:03,179 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,194 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_job_stats"(
    "node_id" VARCHAR(50) NOT NULL,
    "host_name" VARCHAR(60) NOT NULL,
    "job_name" VARCHAR(50) NOT NULL,
    "start_time" DATETIME NOT NULL,
    "end_time" DATETIME NOT NULL,
    "processed_count" BIGINT DEFAULT 0,
    PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2015-10-24 01:04:03,194 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "sym_node_host_job_stats" ("node_id", "start_time", "end_time")
2015-10-24 01:04:03,194 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,225 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_stats"(
    "node_id" VARCHAR(50) NOT NULL,
    "host_name" VARCHAR(60) NOT NULL,
    "start_time" DATETIME NOT NULL,
    "end_time" DATETIME NOT NULL,
    "restarted" BIGINT DEFAULT 0 NOT NULL,
    "nodes_pulled" BIGINT DEFAULT 0,
    "total_nodes_pull_time" BIGINT DEFAULT 0,
    "nodes_pushed" BIGINT DEFAULT 0,
    "total_nodes_push_time" BIGINT DEFAULT 0,
    "nodes_rejected" BIGINT DEFAULT 0,
    "nodes_registered" BIGINT DEFAULT 0,
    "nodes_loaded" BIGINT DEFAULT 0,
    "nodes_disabled" BIGINT DEFAULT 0,
    "purged_data_rows" BIGINT DEFAULT 0,
    "purged_data_event_rows" BIGINT DEFAULT 0,
    "purged_batch_outgoing_rows" BIGINT DEFAULT 0,
    "purged_batch_incoming_rows" BIGINT DEFAULT 0,
    "triggers_created_count" BIGINT,
    "triggers_rebuilt_count" BIGINT,
    "triggers_removed_count" BIGINT,
    PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2015-10-24 01:04:03,225 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "sym_node_host_stats" ("node_id", "start_time", "end_time")
2015-10-24 01:04:03,225 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,241 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_identity"(
    "node_id" VARCHAR(50) NOT NULL,
    PRIMARY KEY ("node_id")
)
2015-10-24 01:04:03,241 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,257 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_security"(
    "node_id" VARCHAR(50) NOT NULL,
    "node_password" VARCHAR(50) NOT NULL,
    "registration_enabled" SMALLINT DEFAULT 0,
    "registration_time" DATETIME,
    "initial_load_enabled" SMALLINT DEFAULT 0,
    "initial_load_time" DATETIME,
    "initial_load_id" BIGINT,
    "initial_load_create_by" VARCHAR(255),
    "rev_initial_load_enabled" SMALLINT DEFAULT 0,
    "rev_initial_load_time" DATETIME,
    "rev_initial_load_id" BIGINT,
    "rev_initial_load_create_by" VARCHAR(255),
    "created_at_node_id" VARCHAR(50),
    PRIMARY KEY ("node_id")
)
2015-10-24 01:04:03,257 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,444 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_outgoing_batch"(
    "batch_id" BIGINT NOT NULL,
    "node_id" VARCHAR(50) NOT NULL,
    "channel_id" VARCHAR(128),
    "status" CHAR(2),
    "load_id" BIGINT,
    "extract_job_flag" SMALLINT DEFAULT 0,
    "load_flag" SMALLINT DEFAULT 0,
    "error_flag" SMALLINT DEFAULT 0,
    "common_flag" SMALLINT DEFAULT 0,
    "ignore_count" BIGINT DEFAULT 0 NOT NULL,
    "byte_count" BIGINT DEFAULT 0 NOT NULL,
    "extract_count" BIGINT DEFAULT 0 NOT NULL,
    "sent_count" BIGINT DEFAULT 0 NOT NULL,
    "load_count" BIGINT DEFAULT 0 NOT NULL,
    "data_event_count" BIGINT DEFAULT 0 NOT NULL,
    "reload_event_count" BIGINT DEFAULT 0 NOT NULL,
    "insert_event_count" BIGINT DEFAULT 0 NOT NULL,
    "update_event_count" BIGINT DEFAULT 0 NOT NULL,
    "delete_event_count" BIGINT DEFAULT 0 NOT NULL,
    "other_event_count" BIGINT DEFAULT 0 NOT NULL,
    "router_millis" BIGINT DEFAULT 0 NOT NULL,
    "network_millis" BIGINT DEFAULT 0 NOT NULL,
    "filter_millis" BIGINT DEFAULT 0 NOT NULL,
    "load_millis" BIGINT DEFAULT 0 NOT NULL,
    "extract_millis" BIGINT DEFAULT 0 NOT NULL,
    "transform_extract_millis" BIGINT DEFAULT 0 NOT NULL,
    "transform_load_millis" BIGINT DEFAULT 0 NOT NULL,
    "total_extract_millis" BIGINT DEFAULT 0 NOT NULL,
    "total_load_millis" BIGINT DEFAULT 0 NOT NULL,
    "sql_state" VARCHAR(10),
    "sql_code" INT DEFAULT 0 NOT NULL,
    "sql_message" TEXT,
    "failed_data_id" BIGINT DEFAULT 0 NOT NULL,
    "failed_line_number" BIGINT DEFAULT 0 NOT NULL,
    "last_update_hostname" VARCHAR(255),
    "last_update_time" DATETIME,
    "create_time" DATETIME,
    "create_by" VARCHAR(255),
    PRIMARY KEY ("batch_id", "node_id")
)
2015-10-24 01:04:03,460 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_node_status" ON "sym_outgoing_batch" ("node_id", "status")
2015-10-24 01:04:03,460 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_status" ON "sym_outgoing_batch" ("status")
2015-10-24 01:04:03,491 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_in_error" ON "sym_outgoing_batch" ("error_flag")
2015-10-24 01:04:03,491 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,491 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_parameter"(
    "external_id" VARCHAR(255) NOT NULL,
    "node_group_id" VARCHAR(50) NOT NULL,
    "param_key" VARCHAR(80) NOT NULL,
    "param_value" TEXT,
    "create_time" DATETIME,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME,
    PRIMARY KEY ("external_id", "node_group_id", "param_key")
)
2015-10-24 01:04:03,507 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,538 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_registration_redirect"(
    "registrant_external_id" VARCHAR(255) NOT NULL,
    "registration_node_id" VARCHAR(50) NOT NULL,
    PRIMARY KEY ("registrant_external_id")
)
2015-10-24 01:04:03,538 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,538 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_registration_request"(
    "node_group_id" VARCHAR(50) NOT NULL,
    "external_id" VARCHAR(255) NOT NULL,
    "status" CHAR(2) NOT NULL,
    "host_name" VARCHAR(60) NOT NULL,
    "ip_address" VARCHAR(50) NOT NULL,
    "attempt_count" INT DEFAULT 0,
    "registered_node_id" VARCHAR(50),
    "error_message" TEXT,
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("node_group_id", "external_id", "create_time")
)
2015-10-24 01:04:03,554 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address")
2015-10-24 01:04:03,554 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status")
2015-10-24 01:04:03,554 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,569 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_router"(
    "router_id" VARCHAR(50) NOT NULL,
    "target_catalog_name" VARCHAR(255),
    "target_schema_name" VARCHAR(255),
    "target_table_name" VARCHAR(255),
    "source_node_group_id" VARCHAR(50) NOT NULL,
    "target_node_group_id" VARCHAR(50) NOT NULL,
    "router_type" VARCHAR(50),
    "router_expression" TEXT,
    "sync_on_update" SMALLINT DEFAULT 1 NOT NULL,
    "sync_on_insert" SMALLINT DEFAULT 1 NOT NULL,
    "sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
    "use_source_catalog_schema" SMALLINT DEFAULT 1 NOT NULL,
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("router_id")
)
2015-10-24 01:04:03,569 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,585 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_sequence"(
    "sequence_name" VARCHAR(50) NOT NULL,
    "current_value" BIGINT DEFAULT 0 NOT NULL,
    "increment_by" INT DEFAULT 1 NOT NULL,
    "min_value" BIGINT DEFAULT 1 NOT NULL,
    "max_value" BIGINT DEFAULT 9999999999 NOT NULL,
    "cycle" SMALLINT DEFAULT 0,
    "create_time" DATETIME,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("sequence_name")
)
2015-10-24 01:04:03,585 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,600 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_table_reload_request"(
    "target_node_id" VARCHAR(50) NOT NULL,
    "source_node_id" VARCHAR(50) NOT NULL,
    "trigger_id" VARCHAR(128) NOT NULL,
    "router_id" VARCHAR(50) NOT NULL,
    "reload_select" TEXT,
    "reload_delete_stmt" TEXT,
    "reload_enabled" SMALLINT DEFAULT 0,
    "reload_time" DATETIME,
    "create_time" DATETIME,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id")
)
2015-10-24 01:04:03,600 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,616 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_transform_table"(
    "transform_id" VARCHAR(50) NOT NULL,
    "source_node_group_id" VARCHAR(50) NOT NULL,
    "target_node_group_id" VARCHAR(50) NOT NULL,
    "transform_point" VARCHAR(10) NOT NULL,
    "source_catalog_name" VARCHAR(255),
    "source_schema_name" VARCHAR(255),
    "source_table_name" VARCHAR(255) NOT NULL,
    "target_catalog_name" VARCHAR(255),
    "target_schema_name" VARCHAR(255),
    "target_table_name" VARCHAR(255),
    "update_first" SMALLINT DEFAULT 0,
    "update_action" VARCHAR(255) DEFAULT 'UPDATE_COL',
    "delete_action" VARCHAR(10) NOT NULL,
    "transform_order" INT DEFAULT 1 NOT NULL,
    "column_policy" VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL,
    "create_time" DATETIME,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME,
    PRIMARY KEY ("transform_id", "source_node_group_id", "target_node_group_id")
)
2015-10-24 01:04:03,616 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,694 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_transform_column"(
    "transform_id" VARCHAR(50) NOT NULL,
    "include_on" CHAR(1) DEFAULT '*' NOT NULL,
    "target_column_name" VARCHAR(128) NOT NULL,
    "source_column_name" VARCHAR(128),
    "pk" SMALLINT DEFAULT 0,
    "transform_type" VARCHAR(50) DEFAULT 'copy',
    "transform_expression" TEXT,
    "transform_order" INT DEFAULT 1 NOT NULL,
    "create_time" DATETIME,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME,
    PRIMARY KEY ("transform_id", "include_on", "target_column_name")
)
2015-10-24 01:04:03,694 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,725 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger"(
    "trigger_id" VARCHAR(128) NOT NULL,
    "source_catalog_name" VARCHAR(255),
    "source_schema_name" VARCHAR(255),
    "source_table_name" VARCHAR(255) NOT NULL,
    "channel_id" VARCHAR(128) NOT NULL,
    "reload_channel_id" VARCHAR(128) DEFAULT 'reload' NOT NULL,
    "sync_on_update" SMALLINT DEFAULT 1 NOT NULL,
    "sync_on_insert" SMALLINT DEFAULT 1 NOT NULL,
    "sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
    "sync_on_incoming_batch" SMALLINT DEFAULT 0 NOT NULL,
    "name_for_update_trigger" VARCHAR(255),
    "name_for_insert_trigger" VARCHAR(255),
    "name_for_delete_trigger" VARCHAR(255),
    "sync_on_update_condition" TEXT,
    "sync_on_insert_condition" TEXT,
    "sync_on_delete_condition" TEXT,
    "custom_on_update_text" TEXT,
    "custom_on_insert_text" TEXT,
    "custom_on_delete_text" TEXT,
    "external_select" TEXT,
    "tx_id_expression" TEXT,
    "channel_expression" TEXT,
    "excluded_column_names" TEXT,
    "sync_key_names" TEXT,
    "use_stream_lobs" SMALLINT DEFAULT 0 NOT NULL,
    "use_capture_lobs" SMALLINT DEFAULT 0 NOT NULL,
    "use_capture_old_data" SMALLINT DEFAULT 1 NOT NULL,
    "use_handle_key_updates" SMALLINT DEFAULT 0 NOT NULL,
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("trigger_id")
)
2015-10-24 01:04:03,741 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,757 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_hist"(
    "trigger_hist_id" INT NOT NULL,
    "trigger_id" VARCHAR(128) NOT NULL,
    "source_table_name" VARCHAR(255) NOT NULL,
    "source_catalog_name" VARCHAR(255),
    "source_schema_name" VARCHAR(255),
    "name_for_update_trigger" VARCHAR(255),
    "name_for_insert_trigger" VARCHAR(255),
    "name_for_delete_trigger" VARCHAR(255),
    "table_hash" BIGINT DEFAULT 0 NOT NULL,
    "trigger_row_hash" BIGINT DEFAULT 0 NOT NULL,
    "trigger_template_hash" BIGINT DEFAULT 0 NOT NULL,
    "column_names" TEXT NOT NULL,
    "pk_column_names" TEXT NOT NULL,
    "last_trigger_build_reason" CHAR(1) NOT NULL,
    "error_message" TEXT,
    "create_time" DATETIME NOT NULL,
    "inactive_time" DATETIME,
    PRIMARY KEY ("trigger_hist_id")
)
2015-10-24 01:04:03,757 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,757 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_router"(
    "trigger_id" VARCHAR(128) NOT NULL,
    "router_id" VARCHAR(50) NOT NULL,
    "enabled" SMALLINT DEFAULT 1 NOT NULL,
    "initial_load_order" INT DEFAULT 1 NOT NULL,
    "initial_load_select" TEXT,
    "initial_load_delete_stmt" TEXT,
    "initial_load_batch_count" INT DEFAULT 1,
    "ping_back_enabled" SMALLINT DEFAULT 0 NOT NULL,
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("trigger_id", "router_id")
)
2015-10-24 01:04:03,772 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on
2015-10-24 01:04:03,772 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_router_grouplet"(
    "grouplet_id" VARCHAR(50) NOT NULL,
    "trigger_id" VARCHAR(128) NOT NULL,
    "router_id" VARCHAR(50) NOT NULL,
    "applies_when" CHAR(1) NOT NULL,
    "create_time" DATETIME NOT NULL,
    "last_update_by" VARCHAR(50),
    "last_update_time" DATETIME NOT NULL,
    PRIMARY KEY ("grouplet_id", "trigger_id", "router_id", "applies_when")
)
2015-10-24 01:04:03,788 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_conflict"
    ADD CONSTRAINT "sym_fk_cf_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2015-10-24 01:04:03,788 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_file_trigger_router"
    ADD CONSTRAINT "sym_fk_ftr_2_ftrg" FOREIGN KEY ("trigger_id") REFERENCES "sym_file_trigger" ("trigger_id")
2015-10-24 01:04:03,804 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_file_trigger_router"
    ADD CONSTRAINT "sym_fk_ftr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2015-10-24 01:04:03,804 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_grouplet_link"
    ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2015-10-24 01:04:03,804 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_group_link"
    ADD CONSTRAINT "sym_fk_lnk_2_grp_src" FOREIGN KEY ("source_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2015-10-24 01:04:03,819 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_group_link"
    ADD CONSTRAINT "sym_fk_lnk_2_grp_tgt" FOREIGN KEY ("target_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2015-10-24 01:04:03,819 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_identity"
    ADD CONSTRAINT "sym_fk_ident_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2015-10-24 01:04:03,819 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_security"
    ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2015-10-24 01:04:03,835 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_router"
    ADD CONSTRAINT "sym_fk_rt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2015-10-24 01:04:03,835 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_transform_table"
    ADD CONSTRAINT "sym_fk_tt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2015-10-24 01:04:03,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger"
    ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id")
2015-10-24 01:04:03,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger"
    ADD CONSTRAINT "sym_fk_trg_2_rld_chnl" FOREIGN KEY ("reload_channel_id") REFERENCES "sym_channel" ("channel_id")
2015-10-24 01:04:03,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router"
    ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id")
2015-10-24 01:04:03,882 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router"
    ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2015-10-24 01:04:03,882 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
    ADD CONSTRAINT "sym_fk_trgplt_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2015-10-24 01:04:03,882 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
    ADD CONSTRAINT "sym_fk_trgplt_2_tr" FOREIGN KEY ("trigger_id", "router_id") REFERENCES "sym_trigger_router" ("trigger_id", "router_id")
2015-10-24 01:04:03,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Done with auto update of SymmetricDS tables
2015-10-24 01:04:04,054 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Updating indexes to prevent lock escalation
2015-10-24 01:04:04,210 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Installing SymmetricDS database object:
create function dbo.sym_base64_encode(@data varbinary(max)) returns varchar(max)                                                                                                                         
  with schemabinding, returns null on null input                                                                                                                       
  begin                                                                                                                                                                
    return ( select [text()] = @data for xml path('') )                                                                                                                
  end                                                                                                                                                                  
2015-10-24 01:04:04,210 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Just installed sym_base64_encode
2015-10-24 01:04:04,225 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Installing SymmetricDS database object:
create function dbo.sym_triggers_disabled() returns smallint                                                                                                                                                 
  begin                                                                                                                                                                  
    declare @disabled varchar(1);                                                                                                                                        
    set @disabled = coalesce(replace(substring(cast(context_info() as varchar), 1, 1), 0x0, ''), '');                                                                    
    if @disabled is null or @disabled != '1'                                                                                                                             
      return 0;                                                                                                                                                          
    return 1;                                                                                                                                                            
  end                                                                                                                                                                    
2015-10-24 01:04:04,225 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Just installed sym_triggers_disabled
2015-10-24 01:04:04,241 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Installing SymmetricDS database object:
create function dbo.sym_node_disabled() returns varchar(50)                                                                                                                                              
  begin                                                                                                                                                                  
    declare @node varchar(50);                                                                                                                                           
    set @node = coalesce(replace(substring(cast(context_info() as varchar) collate SQL_Latin1_General_CP1_CI_AS, 2, 50), 0x0, ''), '');                                  
    return @node;                                                                                                                                                        
  end                                                                                                                                                                    
2015-10-24 01:04:04,241 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Just installed sym_node_disabled
2015-10-24 01:04:04,272 INFO [reportsdb-000] [ConfigurationService] [main] Auto-configuring config channel
2015-10-24 01:04:04,319 INFO [reportsdb-000] [ConfigurationService] [main] Auto-configuring reload channel
2015-10-24 01:04:04,335 INFO [reportsdb-000] [ConfigurationService] [main] Auto-configuring heartbeat channel
2015-10-24 01:04:04,382 INFO [reportsdb-000] [ConfigurationService] [main] Auto-configuring default channel
2015-10-24 01:04:04,382 INFO [reportsdb-000] [ConfigurationService] [main] Auto-configuring dynamic channel
2015-10-24 01:04:04,491 INFO [reportsdb-000] [AbstractSymmetricEngine] [main] Done initializing SymmetricDS database
2015-10-24 01:05:48,866 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={reportsdb-000}
2015-10-24 01:05:48,882 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8080}
2015-10-24 01:05:48,960 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port default:8080
2015-10-24 01:05:49,757 INFO [startup] [/] [main] Initializing Spring root WebApplicationContext
2015-10-24 01:05:50,382 INFO [reportsdb-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-0] Detected database 'Microsoft SQL Server', version '11', protocol 'jtds'
2015-10-24 01:05:50,413 INFO [reportsdb-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-0] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform
2015-10-24 01:05:51,473 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect
2015-10-24 01:05:51,629 INFO [reportsdb-000] [ExtensionService] [symmetric-engine-startup-0] Found 0 extension points from the database that will be registered
2015-10-24 01:05:51,660 INFO [reportsdb-000] [StagingManager] [symmetric-engine-startup-0] The staging directory was initialized at the following location: C:\Users\Faraz\Desktop\destination-node\symmetric-server-3.7.25\tmp\reportsdb-000
2015-10-24 01:05:51,738 INFO [reportsdb-000] [ClusterService] [symmetric-engine-startup-0] This node picked a server id of BREPORTSDBVM
2015-10-24 01:05:53,144 INFO [reportsdb-000] [ExtensionService] [symmetric-engine-startup-0] Found 0 extension points from the database that will be registered
2015-10-24 01:05:53,144 INFO [reportsdb-000] [ClientExtensionService] [symmetric-engine-startup-0] Found 9 extension points from spring that will be registered
2015-10-24 01:05:53,223 INFO [reportsdb-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Initializing SymmetricDS database
2015-10-24 01:05:53,223 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Checking if SymmetricDS tables need created or altered
2015-10-24 01:05:53,410 INFO [startup] [/] [main] Initializing Spring FrameworkServlet 'rest'
2015-10-24 01:05:53,749 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8081
2015-10-24 01:05:53,791 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2015-10-24 01:05:55,226 INFO [reportsdb-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Done initializing SymmetricDS database
2015-10-24 01:05:55,268 INFO [reportsdb-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Starting registered node [group=reportsdb, id=000, externalId=000]
2015-10-24 01:05:55,282 INFO [reportsdb-000] [TriggerRouterService] [symmetric-engine-startup-0] Synchronizing triggers
2015-10-24 01:05:55,662 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_RTR_RPRTSDB trigger for dposdb.dbo.sym_router
2015-10-24 01:05:55,690 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_RTR_RPRTSDB trigger for dposdb.dbo.sym_router
2015-10-24 01:05:55,718 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_RTR_RPRTSDB trigger for dposdb.dbo.sym_router
2015-10-24 01:05:55,816 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRNSFRM_TBL_RPRTSDB trigger for dposdb.dbo.sym_transform_table
2015-10-24 01:05:55,873 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRNSFRM_TBL_RPRTSDB trigger for dposdb.dbo.sym_transform_table
2015-10-24 01:05:55,901 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRNSFRM_TBL_RPRTSDB trigger for dposdb.dbo.sym_transform_table
2015-10-24 01:05:55,967 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_PRMTR_RPRTSDB trigger for dposdb.dbo.sym_parameter
2015-10-24 01:05:55,989 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_PRMTR_RPRTSDB trigger for dposdb.dbo.sym_parameter
2015-10-24 01:05:56,007 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_PRMTR_RPRTSDB trigger for dposdb.dbo.sym_parameter
2015-10-24 01:05:56,097 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger_router
2015-10-24 01:05:56,139 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger_router
2015-10-24 01:05:56,153 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger_router
2015-10-24 01:05:56,223 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_GRP_CHNNL_WND_RPRTSDB trigger for dposdb.dbo.sym_node_group_channel_wnd
2015-10-24 01:05:56,251 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_GRP_CHNNL_WND_RPRTSDB trigger for dposdb.dbo.sym_node_group_channel_wnd
2015-10-24 01:05:56,265 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_GRP_CHNNL_WND_RPRTSDB trigger for dposdb.dbo.sym_node_group_channel_wnd
2015-10-24 01:05:56,350 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TBL_RLD_RQST_RPRTSDB trigger for dposdb.dbo.sym_table_reload_request
2015-10-24 01:05:56,364 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TBL_RLD_RQST_RPRTSDB trigger for dposdb.dbo.sym_table_reload_request
2015-10-24 01:05:56,378 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TBL_RLD_RQST_RPRTSDB trigger for dposdb.dbo.sym_table_reload_request
2015-10-24 01:05:56,519 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_GRPLT_LNK_RPRTSDB trigger for dposdb.dbo.sym_grouplet_link
2015-10-24 01:05:56,547 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_GRPLT_LNK_RPRTSDB trigger for dposdb.dbo.sym_grouplet_link
2015-10-24 01:05:56,561 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_GRPLT_LNK_RPRTSDB trigger for dposdb.dbo.sym_grouplet_link
2015-10-24 01:05:56,631 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_GRP_LNK_RPRTSDB trigger for dposdb.dbo.sym_node_group_link
2015-10-24 01:05:56,645 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_GRP_LNK_RPRTSDB trigger for dposdb.dbo.sym_node_group_link
2015-10-24 01:05:56,659 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_GRP_LNK_RPRTSDB trigger for dposdb.dbo.sym_node_group_link
2015-10-24 01:05:56,729 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_grouplet
2015-10-24 01:05:56,856 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_grouplet
2015-10-24 01:05:56,898 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_grouplet
2015-10-24 01:05:56,969 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_GRP_RPRTSDB trigger for dposdb.dbo.sym_node_group
2015-10-24 01:05:56,983 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_GRP_RPRTSDB trigger for dposdb.dbo.sym_node_group
2015-10-24 01:05:57,011 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_GRP_RPRTSDB trigger for dposdb.dbo.sym_node_group
2015-10-24 01:05:57,151 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_SCRTY_RPRTSDB trigger for dposdb.dbo.sym_node_security
2015-10-24 01:05:57,165 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_SCRTY_RPRTSDB trigger for dposdb.dbo.sym_node_security
2015-10-24 01:05:57,179 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_SCRTY_RPRTSDB trigger for dposdb.dbo.sym_node_security
2015-10-24 01:05:57,278 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger
2015-10-24 01:05:57,292 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger
2015-10-24 01:05:57,306 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger
2015-10-24 01:05:57,390 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRNSFRM_CLMN_RPRTSDB trigger for dposdb.dbo.sym_transform_column
2015-10-24 01:05:57,404 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRNSFRM_CLMN_RPRTSDB trigger for dposdb.dbo.sym_transform_column
2015-10-24 01:05:57,419 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRNSFRM_CLMN_RPRTSDB trigger for dposdb.dbo.sym_transform_column
2015-10-24 01:05:57,503 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_LD_FLTR_RPRTSDB trigger for dposdb.dbo.sym_load_filter
2015-10-24 01:05:57,517 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_LD_FLTR_RPRTSDB trigger for dposdb.dbo.sym_load_filter
2015-10-24 01:05:57,545 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_LD_FLTR_RPRTSDB trigger for dposdb.dbo.sym_load_filter
2015-10-24 01:05:57,615 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_XTNSN_RPRTSDB trigger for dposdb.dbo.sym_extension
2015-10-24 01:05:57,644 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_XTNSN_RPRTSDB trigger for dposdb.dbo.sym_extension
2015-10-24 01:05:57,658 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_XTNSN_RPRTSDB trigger for dposdb.dbo.sym_extension
2015-10-24 01:05:57,728 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_CNFLCT_RPRTSDB trigger for dposdb.dbo.sym_conflict
2015-10-24 01:05:57,756 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_CNFLCT_RPRTSDB trigger for dposdb.dbo.sym_conflict
2015-10-24 01:05:57,770 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_CNFLCT_RPRTSDB trigger for dposdb.dbo.sym_conflict
2015-10-24 01:05:57,854 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_trigger
2015-10-24 01:05:57,869 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_trigger
2015-10-24 01:05:57,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_trigger
2015-10-24 01:05:57,967 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_trigger_router
2015-10-24 01:05:57,995 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_trigger_router
2015-10-24 01:05:58,009 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_trigger_router
2015-10-24 01:05:58,079 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_CHNNL_RPRTSDB trigger for dposdb.dbo.sym_channel
2015-10-24 01:05:58,108 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_CHNNL_RPRTSDB trigger for dposdb.dbo.sym_channel
2015-10-24 01:05:58,122 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_CHNNL_RPRTSDB trigger for dposdb.dbo.sym_channel
2015-10-24 01:05:58,178 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_RPRTSDB trigger for dposdb.dbo.sym_node
2015-10-24 01:05:58,192 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_RPRTSDB trigger for dposdb.dbo.sym_node
2015-10-24 01:05:58,206 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_RPRTSDB trigger for dposdb.dbo.sym_node
2015-10-24 01:05:58,304 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_trigger_router_grouplet
2015-10-24 01:05:58,319 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_trigger_router_grouplet
2015-10-24 01:05:58,333 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_trigger_router_grouplet
2015-10-24 01:05:58,403 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_HST_RPRTSDB trigger for dposdb.dbo.sym_node_host
2015-10-24 01:05:58,431 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_HST_RPRTSDB trigger for dposdb.dbo.sym_node_host
2015-10-24 01:05:58,445 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_HST_RPRTSDB trigger for dposdb.dbo.sym_node_host
2015-10-24 01:05:58,459 INFO [reportsdb-000] [TriggerRouterService] [symmetric-engine-startup-0] Done synchronizing triggers
2015-10-24 01:05:58,473 INFO [reportsdb-000] [PushHeartbeatListener] [symmetric-engine-startup-0] Some attribute(s) of node changed.  Recording changes
2015-10-24 01:05:58,473 INFO [reportsdb-000] [PushHeartbeatListener] [symmetric-engine-startup-0] Updating my node configuration info according to the symmetric properties
2015-10-24 01:05:58,783 INFO [reportsdb-000] [RouterJob] [symmetric-engine-startup-0] Starting job.routing on periodic schedule: every 10000ms with the first run at Sat Oct 24 01:06:08 PKT 2015
2015-10-24 01:05:58,867 INFO [reportsdb-000] [PushJob] [symmetric-engine-startup-0] Starting job.push on periodic schedule: every 60000ms with the first run at Sat Oct 24 01:06:08 PKT 2015
2015-10-24 01:05:58,867 INFO [reportsdb-000] [PullJob] [symmetric-engine-startup-0] Starting job.pull on periodic schedule: every 60000ms with the first run at Sat Oct 24 01:06:08 PKT 2015
2015-10-24 01:05:58,881 INFO [reportsdb-000] [OfflinePushJob] [symmetric-engine-startup-0] Starting job.offline.push on periodic schedule: every 60000ms with the first run at Sat Oct 24 01:06:08 PKT 2015
2015-10-24 01:05:58,895 INFO [reportsdb-000] [OfflinePullJob] [symmetric-engine-startup-0] Starting job.offline.pull on periodic schedule: every 60000ms with the first run at Sat Oct 24 01:06:08 PKT 2015
2015-10-24 01:05:58,895 INFO [reportsdb-000] [OutgoingPurgeJob] [symmetric-engine-startup-0] Starting job.purge.outgoing with cron expression: 0 0 0 * * *
2015-10-24 01:05:58,909 INFO [reportsdb-000] [IncomingPurgeJob] [symmetric-engine-startup-0] Starting job.purge.incoming with cron expression: 0 0 0 * * *
2015-10-24 01:05:58,909 INFO [reportsdb-000] [StatisticFlushJob] [symmetric-engine-startup-0] Starting job.stat.flush with cron expression: 0 0/5 * * * *
2015-10-24 01:05:58,923 INFO [reportsdb-000] [SyncTriggersJob] [symmetric-engine-startup-0] Starting job.synctriggers with cron expression: 0 0 0 * * *
2015-10-24 01:05:58,923 INFO [reportsdb-000] [HeartbeatJob] [symmetric-engine-startup-0] Starting job.heartbeat on periodic schedule: every 900000ms with the first run at Sat Oct 24 01:06:08 PKT 2015
2015-10-24 01:05:58,937 INFO [reportsdb-000] [WatchdogJob] [symmetric-engine-startup-0] Starting job.watchdog on periodic schedule: every 3600000ms with the first run at Sat Oct 24 01:06:08 PKT 2015
2015-10-24 01:05:58,937 INFO [reportsdb-000] [StageManagementJob] [symmetric-engine-startup-0] Starting job.stage.management on periodic schedule: every 15000ms with the first run at Sat Oct 24 01:06:08 PKT 2015
2015-10-24 01:05:58,951 INFO [reportsdb-000] [JobManager] [symmetric-engine-startup-0] Job job.refresh.cache not configured for auto start
2015-10-24 01:05:58,951 INFO [reportsdb-000] [JobManager] [symmetric-engine-startup-0] Job job.file.sync.tracker not configured for auto start
2015-10-24 01:05:58,951 INFO [reportsdb-000] [JobManager] [symmetric-engine-startup-0] Job job.file.sync.pull not configured for auto start
2015-10-24 01:05:58,951 INFO [reportsdb-000] [JobManager] [symmetric-engine-startup-0] Job job.file.sync.push not configured for auto start
2015-10-24 01:05:58,965 INFO [reportsdb-000] [InitialLoadExtractorJob] [symmetric-engine-startup-0] Starting job.initial.load.extract on periodic schedule: every 10000ms with the first run at Sat Oct 24 01:06:08 PKT 2015
2015-10-24 01:05:58,965 INFO [reportsdb-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Started SymmetricDS
2015-10-24 01:05:58,965 INFO [reportsdb-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] SymmetricDS: type=server, name=reportsdb-000, version=3.7.25, groupId=reportsdb, externalId=000, databaseName=Microsoft SQL Server, databaseVersion=11.0, driverName=jTDS Type 4 JDBC Driver for MS SQL Server and Sybase, driverVersion=1.2.8
2015-10-24 01:06:08,211 INFO [reportsdb-000] [NodeCommunicationService] [reportsdb-000-job-3] pull will use 10 threads
2015-10-24 01:06:08,258 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'config' channel is NOT in common batch mode
2015-10-24 01:06:08,536 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'reload' channel is NOT in common batch mode
2015-10-24 01:06:08,552 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'heartbeat' channel is NOT in common batch mode
2015-10-24 01:06:08,660 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'RESTAURANT' channel is in common batch mode
2015-10-24 01:06:08,660 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'RESTAURANT' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,706 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'SHIFT' channel is in common batch mode
2015-10-24 01:06:08,706 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'SHIFT' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,722 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TERMINAL' channel is in common batch mode
2015-10-24 01:06:08,737 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TERMINAL' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,737 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_TYPE' channel is in common batch mode
2015-10-24 01:06:08,737 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_TYPE' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,753 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'EMPLOYEE_JOB_CODE' channel is in common batch mode
2015-10-24 01:06:08,753 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'EMPLOYEE_JOB_CODE' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,768 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USERS' channel is in common batch mode
2015-10-24 01:06:08,768 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USERS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,784 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_JOB_CODES' channel is in common batch mode
2015-10-24 01:06:08,784 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_JOB_CODES' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,799 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOMER' channel is in common batch mode
2015-10-24 01:06:08,799 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOMER' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,815 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ATTENDENCE_HISTORY' channel is in common batch mode
2015-10-24 01:06:08,815 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ATTENDENCE_HISTORY' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,830 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_CATEGORY' channel is in common batch mode
2015-10-24 01:06:08,830 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_CATEGORY' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,846 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_GROUP' channel is in common batch mode
2015-10-24 01:06:08,846 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_GROUP' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,861 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COUPON_AND_DISCOUNT' channel is in common batch mode
2015-10-24 01:06:08,861 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COUPON_AND_DISCOUNT' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,877 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMBO_CATEGORY' channel is in common batch mode
2015-10-24 01:06:08,877 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMBO_CATEGORY' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,892 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TAX' channel is in common batch mode
2015-10-24 01:06:08,892 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TAX' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,908 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_ITEM' channel is in common batch mode
2015-10-24 01:06:08,908 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_ITEM' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,923 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMBO_ITEM' channel is in common batch mode
2015-10-24 01:06:08,923 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMBO_ITEM' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,939 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'END_OF_DAY_REPORT' channel is in common batch mode
2015-10-24 01:06:08,939 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'END_OF_DAY_REPORT' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,954 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DRIVER_REPORT' channel is in common batch mode
2015-10-24 01:06:08,954 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DRIVER_REPORT' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:08,985 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DRAWER_PULL_REPORT' channel is in common batch mode
2015-10-24 01:06:08,985 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DRAWER_PULL_REPORT' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,000 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY' channel is in common batch mode
2015-10-24 01:06:09,000 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,016 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMPTICKETS' channel is in common batch mode
2015-10-24 01:06:09,016 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMPTICKETS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,031 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_TYPE' channel is in common batch mode
2015-10-24 01:06:09,031 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_TYPE' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,031 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'VOIDTICKETS' channel is in common batch mode
2015-10-24 01:06:09,047 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'VOIDTICKETS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,062 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY_RUN' channel is in common batch mode
2015-10-24 01:06:09,062 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY_RUN' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,062 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET' channel is in common batch mode
2015-10-24 01:06:09,078 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,078 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'GRATUITY' channel is in common batch mode
2015-10-24 01:06:09,093 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'GRATUITY' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,093 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_ITEM' channel is in common batch mode
2015-10-24 01:06:09,093 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_ITEM' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,109 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMP_REASONS' channel is in common batch mode
2015-10-24 01:06:09,124 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMP_REASONS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,124 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COOKING_INSTRUCTION' channel is in common batch mode
2015-10-24 01:06:09,124 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COOKING_INSTRUCTION' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,140 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CREDIT_CARD_INFO' channel is in common batch mode
2015-10-24 01:06:09,155 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CREDIT_CARD_INFO' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,155 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOMER_CREDIT_CARDS' channel is in common batch mode
2015-10-24 01:06:09,155 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOMER_CREDIT_CARDS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,171 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOM_PAYMENT_TYPE' channel is in common batch mode
2015-10-24 01:06:09,171 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOM_PAYMENT_TYPE' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,186 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'RETURN_REASON' channel is in common batch mode
2015-10-24 01:06:09,186 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'RETURN_REASON' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,201 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY_RETURN_REASON' channel is in common batch mode
2015-10-24 01:06:09,201 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY_RETURN_REASON' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,217 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'EMPLOYEE_DEPOSITS' channel is in common batch mode
2015-10-24 01:06:09,217 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'EMPLOYEE_DEPOSITS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,232 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'FAILED_OLO_TICKETS' channel is in common batch mode
2015-10-24 01:06:09,232 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'FAILED_OLO_TICKETS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,248 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKETITEM_MODIFIERGROUP' channel is in common batch mode
2015-10-24 01:06:09,263 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKETITEM_MODIFIERGROUP' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,263 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_COOKING_INSTRUCTION' channel is in common batch mode
2015-10-24 01:06:09,310 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_COOKING_INSTRUCTION' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,341 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_COUPON_DISCOUNT' channel is in common batch mode
2015-10-24 01:06:09,341 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_COUPON_DISCOUNT' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,341 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_ITEM_MODIFIER' channel is in common batch mode
2015-10-24 01:06:09,341 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_ITEM_MODIFIER' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,356 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ACTION_HISTORY' channel is in common batch mode
2015-10-24 01:06:09,356 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ACTION_HISTORY' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,372 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ADDRESSES_LATITUDES_LONGITUDES' channel is in common batch mode
2015-10-24 01:06:09,387 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ADDRESSES_LATITUDES_LONGITUDES' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,387 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'APPLICATION_DATA' channel is in common batch mode
2015-10-24 01:06:09,387 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'APPLICATION_DATA' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,403 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_MENUMODIFIERS' channel is in common batch mode
2015-10-24 01:06:09,418 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_MENUMODIFIERS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,418 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_MODIFIERGROUP' channel is in common batch mode
2015-10-24 01:06:09,418 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_MODIFIERGROUP' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,434 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_SHIFT' channel is in common batch mode
2015-10-24 01:06:09,434 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_SHIFT' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,449 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_ITEM_SUGGESTIONS' channel is in common batch mode
2015-10-24 01:06:09,449 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_ITEM_SUGGESTIONS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,464 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_MODIFIER' channel is in common batch mode
2015-10-24 01:06:09,464 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_MODIFIER' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,480 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_MODIFIER_GROUP' channel is in common batch mode
2015-10-24 01:06:09,480 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_MODIFIER_GROUP' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,495 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MODIFIERGROUP_SUBCATEGORY' channel is in common batch mode
2015-10-24 01:06:09,495 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MODIFIERGROUP_SUBCATEGORY' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,511 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'PAYOUT_REASONS' channel is in common batch mode
2015-10-24 01:06:09,511 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'PAYOUT_REASONS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,526 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'PAYOUT_RECEPIENTS' channel is in common batch mode
2015-10-24 01:06:09,526 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'PAYOUT_RECEPIENTS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,542 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TRANSACTIONS' channel is in common batch mode
2015-10-24 01:06:09,542 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TRANSACTIONS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,557 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_PERMISSION' channel is in common batch mode
2015-10-24 01:06:09,557 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_PERMISSION' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,573 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_PERMISSIONS' channel is in common batch mode
2015-10-24 01:06:09,573 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_PERMISSIONS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,588 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_TICKETS' channel is in common batch mode
2015-10-24 01:06:09,588 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_TICKETS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,604 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_USER_PERMISSION' channel is in common batch mode
2015-10-24 01:06:09,604 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_USER_PERMISSION' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,619 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'VOID_REASONS' channel is in common batch mode
2015-10-24 01:06:09,619 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'VOID_REASONS' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,635 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'default' channel is in common batch mode
2015-10-24 01:06:09,635 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'default' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,650 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'dynamic' channel is in common batch mode
2015-10-24 01:06:09,650 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'dynamic' channel for the 'reportsdb' node group has only default routers assigned to it.  Change data won't be selected during routing
2015-10-24 01:06:09,666 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] Routed 3 data events in 1501 ms
2015-10-24 01:06:59,385 INFO [reportsdb-000] [RegistrationService] [qtp28759214-16] Registration was opened for 001
2015-10-24 01:06:59,401 INFO [reportsdb-000] [MsSqlSymmetricDialect] [qtp28759214-16] This database DOES support disabling triggers during a symmetricds data load
2015-10-24 01:07:03,432 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-17] Routed 4 data events in 438 ms
2015-10-24 01:07:24,619 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-12] Routed 1 data events in 734 ms
2015-10-24 01:08:15,432 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:15,807 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:16,463 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_MODIFIER_GROUP">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="ENABLED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="EXCLUSIVED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="REQUIRED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="CATEGORY" type="VARCHAR" size="24">
			<platform-column name="derby" type="VARCHAR" size="24"/>
		</column>
		<index name="MG_ENABLE">
			<index-column name="ENABLED"/>
		</index>
	</table>
</database>
2015-10-24 01:08:16,510 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "menu_modifier_group"(
    "id" INT NOT NULL,
    "modified_time" DATETIME NOT NULL,
    "name" VARCHAR(60),
    "enabled" SMALLINT,
    "exclusived" SMALLINT,
    "required" SMALLINT,
    "category" VARCHAR(24),
    PRIMARY KEY ("id")
);
CREATE INDEX "mg_enable" ON "menu_modifier_group" ("enabled");

2015-10-24 01:08:16,635 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:17,072 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MODIFIERGROUP_SUBCATEGORY">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NAME" type="VARCHAR" size="24">
			<platform-column name="derby" type="VARCHAR" size="24"/>
		</column>
		<column name="MODIFIED_TIME" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="ENABLED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="EXCLUSIVED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="REQUIRED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="CATEGORY" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="VIEW_ORDER_VALUE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SUBCAT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="STYLE_NAME" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<foreign-key name="FK7D4CB47D7B72790" foreignTable="MENU_MODIFIER_GROUP">
			<reference local="SUBCAT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK7D4CB474324ED16" foreignTable="MENU_MODIFIER_GROUP">
			<reference local="SUBCAT_ID" foreign="ID"/>
		</foreign-key>
		<index name="MODIFIERGROUP_SUBCATEGORY_NAME_IDX">
			<index-column name="NAME"/>
		</index>
	</table>
</database>
2015-10-24 01:08:17,104 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "modifiergroup_subcategory"(
    "id" INT NOT NULL,
    "name" VARCHAR(24),
    "modified_time" DATETIME,
    "enabled" SMALLINT,
    "exclusived" SMALLINT,
    "required" SMALLINT,
    "category" VARCHAR(60),
    "view_order_value" INT,
    "subcat_id" INT,
    "style_name" VARCHAR(255),
    PRIMARY KEY ("id")
);
CREATE INDEX "modifiergroup_subcategory_name_idx" ON "modifiergroup_subcategory" ("name");
ALTER TABLE "modifiergroup_subcategory"
    ADD CONSTRAINT "fk7d4cb47d7b72790" FOREIGN KEY ("subcat_id") REFERENCES "menu_modifier_group" ("id");
ALTER TABLE "modifiergroup_subcategory"
    ADD CONSTRAINT "fk7d4cb474324ed16" FOREIGN KEY ("subcat_id") REFERENCES "menu_modifier_group" ("id");

2015-10-24 01:08:17,213 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:17,666 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TAX">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" required="true" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="RATE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
	</table>
</database>
2015-10-24 01:08:17,682 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "tax"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "modified_time" DATETIME NOT NULL,
    "name" VARCHAR(20) NOT NULL,
    "rate" FLOAT,
    PRIMARY KEY ("id")
);

2015-10-24 01:08:17,760 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:18,244 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_MODIFIER">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" type="VARCHAR" size="50">
			<platform-column name="derby" type="VARCHAR" size="50"/>
		</column>
		<column name="PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="EXTRA_PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="ENABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINT_TO_KITCHEN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="GROUP_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TAX_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VIEW_ORDER_VALUE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="BUTTON_COLOR" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="IN_STOCK" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="GROUP_SUBCAT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SUBCAT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PLU" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK59B6B1B717A96F7" foreignTable="MODIFIERGROUP_SUBCATEGORY">
			<reference local="SUBCAT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK59B6B1B7F8D2AEB1" foreignTable="MODIFIERGROUP_SUBCATEGORY">
			<reference local="SUBCAT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK59B6B1B7D9D8E77D" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK59B6B1B7A4802F83" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
		<index name="MODIFIERENABLED">
			<index-column name="ENABLE"/>
		</index>
	</table>
</database>
2015-10-24 01:08:18,276 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-20] Routed 1 data events in 532 ms
2015-10-24 01:08:18,276 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "menu_modifier"(
    "id" INT NOT NULL,
    "modified_time" DATETIME NOT NULL,
    "name" VARCHAR(50),
    "price" FLOAT,
    "extra_price" FLOAT,
    "enable" SMALLINT,
    "print_to_kitchen" SMALLINT,
    "group_id" INT,
    "tax_id" INT,
    "view_order_value" INT,
    "button_color" INT,
    "in_stock" SMALLINT,
    "group_subcat_id" INT,
    "subcat_id" INT,
    "plu" INT,
    PRIMARY KEY ("id")
);
CREATE INDEX "modifierenabled" ON "menu_modifier" ("enable");
ALTER TABLE "menu_modifier"
    ADD CONSTRAINT "fk59b6b1b717a96f7" FOREIGN KEY ("subcat_id") REFERENCES "modifiergroup_subcategory" ("id");
ALTER TABLE "menu_modifier"
    ADD CONSTRAINT "fk59b6b1b7f8d2aeb1" FOREIGN KEY ("subcat_id") REFERENCES "modifiergroup_subcategory" ("id");
ALTER TABLE "menu_modifier"
    ADD CONSTRAINT "fk59b6b1b7d9d8e77d" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id");
ALTER TABLE "menu_modifier"
    ADD CONSTRAINT "fk59b6b1b7a4802f83" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id");

2015-10-24 01:08:18,338 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:18,572 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="CUSTOMER">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MOBILE" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="FIRSTNAME" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="LASTNAME" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="EMAIL" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="CITY" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="STATE" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="ZIP" type="VARCHAR" size="10">
			<platform-column name="derby" type="VARCHAR" size="10"/>
		</column>
		<column name="BIRTHDAY" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="BIRTHDAY_STRING" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="CUSTOMERNOTES" type="VARCHAR" size="5000">
			<platform-column name="derby" type="VARCHAR" size="5000"/>
		</column>
		<column name="ADDRESS1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="CURRENT_ADDRESS" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="ADDRESS2LINE1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS2LINE2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS3LINE1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS3LINE2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS4LINE1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS4LINE2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS5LINE1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS5LINE2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS6LINE1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS6LINE2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS2_1" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS2_2" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS3_1" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS3_2" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS4_1" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS4_2" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS5_1" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS5_2" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS6_1" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS6_2" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="SELECTED_ADDRESS_INDEX" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="OPT_CC_TOKEN" required="true" type="SMALLINT" size="5" default="1">
			<platform-column name="derby" type="SMALLINT" size="5" default="1"/>
		</column>
	</table>
</database>
2015-10-24 01:08:18,635 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "customer"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "mobile" VARCHAR(250),
    "firstname" VARCHAR(100),
    "lastname" VARCHAR(250),
    "email" VARCHAR(100),
    "city" VARCHAR(20),
    "state" VARCHAR(30),
    "zip" VARCHAR(10),
    "birthday" DATETIME,
    "birthday_string" VARCHAR(255),
    "customernotes" VARCHAR(5000),
    "address1" VARCHAR(250),
    "address2" VARCHAR(250),
    "current_address" VARCHAR(255),
    "address2line1" VARCHAR(250),
    "address2line2" VARCHAR(250),
    "address3line1" VARCHAR(250),
    "address3line2" VARCHAR(250),
    "address4line1" VARCHAR(250),
    "address4line2" VARCHAR(250),
    "address5line1" VARCHAR(250),
    "address5line2" VARCHAR(250),
    "address6line1" VARCHAR(250),
    "address6line2" VARCHAR(250),
    "address2_1" VARCHAR(100),
    "address2_2" VARCHAR(100),
    "address3_1" VARCHAR(100),
    "address3_2" VARCHAR(100),
    "address4_1" VARCHAR(100),
    "address4_2" VARCHAR(100),
    "address5_1" VARCHAR(100),
    "address5_2" VARCHAR(100),
    "address6_1" VARCHAR(100),
    "address6_2" VARCHAR(100),
    "selected_address_index" INT,
    "opt_cc_token" SMALLINT DEFAULT 1 NOT NULL,
    PRIMARY KEY ("id")
);

2015-10-24 01:08:18,729 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:19,166 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="DELIVERY">
		<column name="DELIVERY_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="EMPLOYEE_ID" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DELIVERY_START_TIME" type="DATE" size="10">
			<platform-column name="derby" type="DATE" size="10"/>
		</column>
		<column name="ARRIVAL_TIME" type="DATE" size="10">
			<platform-column name="derby" type="DATE" size="10"/>
		</column>
	</table>
</database>
2015-10-24 01:08:19,182 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "delivery"(
    "delivery_id" INT NOT NULL,
    "employee_id" INT NOT NULL,
    "delivery_start_time" DATETIME,
    "arrival_time" DATETIME,
    PRIMARY KEY ("delivery_id")
);

2015-10-24 01:08:19,244 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:19,619 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="EMPLOYEE_JOB_CODE">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TITLE" required="true" type="VARCHAR" size="50">
			<platform-column name="derby" type="VARCHAR" size="50"/>
		</column>
	</table>
</database>
2015-10-24 01:08:19,635 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "employee_job_code"(
    "id" INT NOT NULL,
    "title" VARCHAR(50) NOT NULL,
    PRIMARY KEY ("id")
);

2015-10-24 01:08:19,729 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:20,182 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="SHIFT">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NAME" required="true" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="START_TIME" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="END_TIME" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="SHIFT_LEN" type="BIGINT" size="19">
			<platform-column name="derby" type="BIGINT" size="19"/>
		</column>
		<unique name="SQL091028025752330">
			<unique-column name="NAME"/>
		</unique>
	</table>
</database>
2015-10-24 01:08:20,197 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "shift"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "name" VARCHAR(60) NOT NULL,
    "start_time" DATETIME,
    "end_time" DATETIME,
    "shift_len" BIGINT,
    PRIMARY KEY ("id")
);
CREATE UNIQUE INDEX "sql091028025752330" ON "shift" ("name");

2015-10-24 01:08:20,276 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:20,651 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TERMINAL">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="OPENING_BALANCE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CURRENT_BALANCE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="IS_DB_MACHINE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
	</table>
</database>
2015-10-24 01:08:20,666 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "terminal"(
    "id" INT NOT NULL,
    "modified_time" DATETIME NOT NULL,
    "name" VARCHAR(60),
    "opening_balance" FLOAT,
    "current_balance" FLOAT,
    "is_db_machine" SMALLINT,
    PRIMARY KEY ("id")
);

2015-10-24 01:08:20,744 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:21,182 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="USER_TYPE">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="P_NAME" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
	</table>
</database>
2015-10-24 01:08:21,197 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "user_type"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "p_name" VARCHAR(60),
    PRIMARY KEY ("id")
);

2015-10-24 01:08:21,291 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:21,744 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="USERS">
		<column name="AUTO_ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="USER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="USER_PASS" required="true" type="VARCHAR" size="16">
			<platform-column name="derby" type="VARCHAR" size="16"/>
		</column>
		<column name="FIRST_NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="LAST_NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="SSN" required="true" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="COST_PER_HOUR" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CLOCKED_IN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="LAST_CLOCK_IN_TIME" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="SHIFT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CURRENTTERMINAL" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="N_USER_TYPE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CASH_OUT_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CURRENT_POSITION" type="VARBINARY" size="255">
			<platform-column name="derby" type="VARCHAR () FOR BIT DATA" size="255"/>
		</column>
		<column name="JOB_CODE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SHOW_IN_PAYROLL" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="DELIVERING" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FK4D495E84B915F0E" foreignTable="EMPLOYEE_JOB_CODE">
			<reference local="JOB_CODE" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E8C49ECE14" foreignTable="EMPLOYEE_JOB_CODE">
			<reference local="JOB_CODE" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E8B86B475D" foreignTable="SHIFT">
			<reference local="SHIFT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E87660A5E3" foreignTable="SHIFT">
			<reference local="SHIFT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E82C5DCDAE" foreignTable="TERMINAL">
			<reference local="CURRENTTERMINAL" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E8D9409968" foreignTable="TERMINAL">
			<reference local="CURRENTTERMINAL" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E8DC98527F" foreignTable="USER_TYPE">
			<reference local="N_USER_TYPE" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E8897B1E39" foreignTable="USER_TYPE">
			<reference local="N_USER_TYPE" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:21,791 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "users"(
    "auto_id" INT NOT NULL IDENTITY (1,1) ,
    "modified_time" DATETIME NOT NULL,
    "user_id" INT,
    "user_pass" VARCHAR(16) NOT NULL,
    "first_name" VARCHAR(30),
    "last_name" VARCHAR(30),
    "ssn" VARCHAR(30) NOT NULL,
    "cost_per_hour" FLOAT,
    "clocked_in" SMALLINT,
    "last_clock_in_time" DATETIME,
    "shift_id" INT,
    "currentterminal" INT,
    "n_user_type" INT,
    "cash_out_amount" FLOAT,
    "current_position" VARBINARY(255),
    "job_code" INT,
    "show_in_payroll" SMALLINT,
    "delivering" SMALLINT,
    PRIMARY KEY ("auto_id")
);
ALTER TABLE "users"
    ADD CONSTRAINT "fk4d495e84b915f0e" FOREIGN KEY ("job_code") REFERENCES "employee_job_code" ("id");
ALTER TABLE "users"
    ADD CONSTRAINT "fk4d495e8c49ece14" FOREIGN KEY ("job_code") REFERENCES "employee_job_code" ("id");
ALTER TABLE "users"
    ADD CONSTRAINT "fk4d495e8b86b475d" FOREIGN KEY ("shift_id") REFERENCES "shift" ("id");
ALTER TABLE "users"
    ADD CONSTRAINT "fk4d495e87660a5e3" FOREIGN KEY ("shift_id") REFERENCES "shift" ("id");
ALTER TABLE "users"
    ADD CONSTRAINT "fk4d495e82c5dcdae" FOREIGN KEY ("currentterminal") REFERENCES "terminal" ("id");
ALTER TABLE "users"
    ADD CONSTRAINT "fk4d495e8d9409968" FOREIGN KEY ("currentterminal") REFERENCES "terminal" ("id");
ALTER TABLE "users"
    ADD CONSTRAINT "fk4d495e8dc98527f" FOREIGN KEY ("n_user_type") REFERENCES "user_type" ("id");
ALTER TABLE "users"
    ADD CONSTRAINT "fk4d495e8897b1e39" FOREIGN KEY ("n_user_type") REFERENCES "user_type" ("id");

2015-10-24 01:08:21,901 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:22,369 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="DELIVERY_RUN">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="START_TIME" required="true" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="RETURN_TIME" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="TOTAL_ORDER_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="NUMBER_OF_ORDERS" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DRIVER_USER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FKB2D85FA0E2248B80" foreignTable="USERS">
			<reference local="DRIVER_USER_ID" foreign="AUTO_ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:22,401 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "delivery_run"(
    "id" INT NOT NULL,
    "start_time" DATETIME NOT NULL,
    "modified_time" DATETIME NOT NULL,
    "return_time" DATETIME,
    "total_order_amount" FLOAT,
    "number_of_orders" INT,
    "driver_user_id" INT,
    PRIMARY KEY ("id")
);
ALTER TABLE "delivery_run"
    ADD CONSTRAINT "fkb2d85fa0e2248b80" FOREIGN KEY ("driver_user_id") REFERENCES "users" ("auto_id");

2015-10-24 01:08:22,479 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:22,916 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="GRATUITY">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="PAID" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="OWNER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TERMINAL_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK34E4E3777DF00477" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK34E4E3772AD2D031" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK34E4E3771FC5A4AF" foreignTable="USERS">
			<reference local="OWNER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK34E4E377AA075D69" foreignTable="USERS">
			<reference local="OWNER_ID" foreign="AUTO_ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:22,947 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "gratuity"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "modified_time" DATETIME NOT NULL,
    "amount" FLOAT,
    "paid" SMALLINT,
    "ticket_id" INT,
    "owner_id" INT,
    "terminal_id" INT,
    PRIMARY KEY ("id")
);
ALTER TABLE "gratuity"
    ADD CONSTRAINT "fk34e4e3777df00477" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id");
ALTER TABLE "gratuity"
    ADD CONSTRAINT "fk34e4e3772ad2d031" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id");
ALTER TABLE "gratuity"
    ADD CONSTRAINT "fk34e4e3771fc5a4af" FOREIGN KEY ("owner_id") REFERENCES "users" ("auto_id");
ALTER TABLE "gratuity"
    ADD CONSTRAINT "fk34e4e377aa075d69" FOREIGN KEY ("owner_id") REFERENCES "users" ("auto_id");

2015-10-24 01:08:23,213 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:23,651 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKET_TYPE">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TYPE_NAME" required="true" type="VARCHAR" size="16">
			<platform-column name="derby" type="VARCHAR" size="16"/>
		</column>
		<column name="SURCHARGE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK97A4688DD9D8E77D" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK97A4688DA4802F83" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:23,682 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "ticket_type"(
    "id" INT NOT NULL,
    "type_name" VARCHAR(16) NOT NULL,
    "surcharge" FLOAT,
    "tax_id" INT,
    PRIMARY KEY ("id")
);
ALTER TABLE "ticket_type"
    ADD CONSTRAINT "fk97a4688dd9d8e77d" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id");
ALTER TABLE "ticket_type"
    ADD CONSTRAINT "fk97a4688da4802f83" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id");

2015-10-24 01:08:23,854 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:24,307 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKET">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="CREATE_DATE" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="CLOSING_DATE" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="ACTIVE_DATE" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="CREATION_HOUR" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PAID" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="VOIDED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="REASON" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="WASTED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="SETTLED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="DRAWER_RESETTED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="SUB_TOTAL" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_DISCOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_TAX" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="PAID_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DUE_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TABLE_NUMBER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NUMBER_OF_GUESTS" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TRANSACTION_TYPE" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="TRANSACTION_CODE" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="BAR_CODE" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="CARD_TYPE" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="CARD_NUMBER" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="IS_TAX_EXEMPT" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="IS_RE_OPENED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="SHIFT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="OWNER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="GRATUITY_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VOID_BY_USER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TERMINAL_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CUST_LASTNAME" type="VARCHAR" size="200">
			<platform-column name="derby" type="VARCHAR" size="200"/>
		</column>
		<column name="CUST_FIRSTNAME" type="VARCHAR" size="200">
			<platform-column name="derby" type="VARCHAR" size="200"/>
		</column>
		<column name="DELIVERY_ADDRESS" type="VARCHAR" size="500">
			<platform-column name="derby" type="VARCHAR" size="500"/>
		</column>
		<column name="CUST_PHONENO" type="VARCHAR" size="15">
			<platform-column name="derby" type="VARCHAR" size="15"/>
		</column>
		<column name="TICKET_STATUS" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="DRIVER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DRIVER_NAME" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="CUST_PHONE_NO" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="IS_DELIVERY" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="DELIVERY_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DELIVERY_STATUS" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DELIVERY_START_TIME" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="DELIVERY_END_TIME" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="DELIVERER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CUST_MOBILE_NUMBER" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="COMPED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="ONLINE_ORDER" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TICKET_TYPE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VOID_REASON" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="NOTES" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TRANSACTION_SUBTYPE" type="VARCHAR" size="1">
			<platform-column name="derby" type="VARCHAR" size="1"/>
		</column>
		<column name="SPLIT_TICKET" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="SPLIT_TICKET_ID" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TIP" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DISPLAY_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SURCHARGE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CUSTOMER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ONLINE_INVOICE_NUMBER" type="VARCHAR" size="25">
			<platform-column name="derby" type="VARCHAR" size="25"/>
		</column>
		<column name="MEMBER_ORDER" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="HEARTS_APPLIED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="DELIVERY_RUN_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="HEARTS_USED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="AMOUNT_OF_HEARTS_USED" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="AMOUNT_OF_HEARTS_APPLIED" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK937B5F0CF1397137" foreignTable="CUSTOMER">
			<reference local="CUSTOMER_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C9E1C3CF1" foreignTable="CUSTOMER">
			<reference local="CUSTOMER_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CDC30BD31" foreignTable="DELIVERY">
			<reference local="DELIVERY_ID" foreign="DELIVERY_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CC082E694" foreignTable="DELIVERY_RUN">
			<reference local="DELIVERY_RUN_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C14A61E97" foreignTable="GRATUITY">
			<reference local="GRATUITY_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CC188EA51" foreignTable="GRATUITY">
			<reference local="GRATUITY_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CB86B475D" foreignTable="SHIFT">
			<reference local="SHIFT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C7660A5E3" foreignTable="SHIFT">
			<reference local="SHIFT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C7DF00477" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C2AD2D031" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CF8C545F0" foreignTable="TICKET_TYPE">
			<reference local="TICKET_TYPE" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CF8240B2A" foreignTable="TICKET_TYPE">
			<reference local="TICKET_TYPE" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CE43D7670" foreignTable="USERS">
			<reference local="DELIVERER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C1FC5A4AF" foreignTable="USERS">
			<reference local="OWNER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C9528E190" foreignTable="USERS">
			<reference local="VOID_BY_USER" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C6E7F2F2A" foreignTable="USERS">
			<reference local="DELIVERER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CE672088" foreignTable="USERS">
			<reference local="DELIVERY_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CAA075D69" foreignTable="USERS">
			<reference local="OWNER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C1F6A9A4A" foreignTable="USERS">
			<reference local="VOID_BY_USER" foreign="AUTO_ID"/>
		</foreign-key>
		<index name="CREATIONHOUR">
			<index-column name="CREATION_HOUR"/>
		</index>
		<index name="DRAWERRESETTED">
			<index-column name="DRAWER_RESETTED"/>
		</index>
		<index name="TICKETACTIVEDATE">
			<index-column name="ACTIVE_DATE"/>
		</index>
		<index name="TICKETCLOSINGDATE">
			<index-column name="CLOSING_DATE"/>
		</index>
		<index name="TICKETCREATEDATE">
			<index-column name="CREATE_DATE"/>
		</index>
		<index name="TICKETPAID">
			<index-column name="PAID"/>
		</index>
		<index name="TICKETSETTLED">
			<index-column name="SETTLED"/>
		</index>
		<index name="TICKETTRANSACTIONTYPE">
			<index-column name="TRANSACTION_TYPE"/>
		</index>
		<index name="TICKETVOIDED">
			<index-column name="VOIDED"/>
		</index>
	</table>
</database>
2015-10-24 01:08:24,416 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "ticket"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "modified_time" DATETIME NOT NULL,
    "create_date" DATETIME,
    "closing_date" DATETIME,
    "active_date" DATETIME,
    "creation_hour" INT,
    "paid" SMALLINT,
    "voided" SMALLINT,
    "reason" VARCHAR(255),
    "wasted" SMALLINT,
    "settled" SMALLINT,
    "drawer_resetted" SMALLINT,
    "sub_total" FLOAT,
    "total_discount" FLOAT,
    "total_tax" FLOAT,
    "total_price" FLOAT,
    "paid_amount" FLOAT,
    "due_amount" FLOAT,
    "table_number" INT,
    "number_of_guests" INT,
    "transaction_type" VARCHAR(20),
    "transaction_code" VARCHAR(60),
    "bar_code" VARCHAR(60),
    "card_type" VARCHAR(60),
    "card_number" VARCHAR(60),
    "is_tax_exempt" SMALLINT,
    "is_re_opened" SMALLINT,
    "shift_id" INT,
    "owner_id" INT,
    "gratuity_id" INT,
    "void_by_user" INT,
    "terminal_id" INT,
    "cust_lastname" VARCHAR(200),
    "cust_firstname" VARCHAR(200),
    "delivery_address" VARCHAR(500),
    "cust_phoneno" VARCHAR(15),
    "ticket_status" VARCHAR(20),
    "driver_id" INT,
    "driver_name" VARCHAR(250),
    "cust_phone_no" VARCHAR(255),
    "is_delivery" SMALLINT,
    "delivery_id" INT,
    "delivery_status" INT,
    "delivery_start_time" DATETIME,
    "delivery_end_time" DATETIME,
    "deliverer_id" INT,
    "cust_mobile_number" VARCHAR(255),
    "comped" SMALLINT,
    "online_order" SMALLINT,
    "ticket_type" INT,
    "void_reason" VARCHAR(255),
    "notes" VARCHAR(255),
    "transaction_subtype" VARCHAR(1),
    "split_ticket" SMALLINT,
    "split_ticket_id" VARCHAR(255),
    "tip" FLOAT,
    "display_id" INT,
    "surcharge" FLOAT,
    "customer_id" INT,
    "online_invoice_number" VARCHAR(25),
    "member_order" SMALLINT,
    "hearts_applied" SMALLINT,
    "delivery_run_id" INT,
    "hearts_used" SMALLINT,
    "amount_of_hearts_used" INT,
    "amount_of_hearts_applied" INT,
    PRIMARY KEY ("id")
);
CREATE INDEX "creationhour" ON "ticket" ("creation_hour");
CREATE INDEX "drawerresetted" ON "ticket" ("drawer_resetted");
CREATE INDEX "ticketactivedate" ON "ticket" ("active_date");
CREATE INDEX "ticketclosingdate" ON "ticket" ("closing_date");
CREATE INDEX "ticketcreatedate" ON "ticket" ("create_date");
CREATE INDEX "ticketpaid" ON "ticket" ("paid");
CREATE INDEX "ticketsettled" ON "ticket" ("settled");
CREATE INDEX "tickettransactiontype" ON "ticket" ("transaction_type");
CREATE INDEX "ticketvoided" ON "ticket" ("voided");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0cf1397137" FOREIGN KEY ("customer_id") REFERENCES "customer" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0c9e1c3cf1" FOREIGN KEY ("customer_id") REFERENCES "customer" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0cdc30bd31" FOREIGN KEY ("delivery_id") REFERENCES "delivery" ("delivery_id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0cc082e694" FOREIGN KEY ("delivery_run_id") REFERENCES "delivery_run" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0c14a61e97" FOREIGN KEY ("gratuity_id") REFERENCES "gratuity" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0cc188ea51" FOREIGN KEY ("gratuity_id") REFERENCES "gratuity" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0cb86b475d" FOREIGN KEY ("shift_id") REFERENCES "shift" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0c7660a5e3" FOREIGN KEY ("shift_id") REFERENCES "shift" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0c7df00477" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0c2ad2d031" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0cf8c545f0" FOREIGN KEY ("ticket_type") REFERENCES "ticket_type" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0cf8240b2a" FOREIGN KEY ("ticket_type") REFERENCES "ticket_type" ("id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0ce43d7670" FOREIGN KEY ("deliverer_id") REFERENCES "users" ("auto_id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0c1fc5a4af" FOREIGN KEY ("owner_id") REFERENCES "users" ("auto_id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0c9528e190" FOREIGN KEY ("void_by_user") REFERENCES "users" ("auto_id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0c6e7f2f2a" FOREIGN KEY ("deliverer_id") REFERENCES "users" ("auto_id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0ce672088" FOREIGN KEY ("delivery_id") REFERENCES "users" ("auto_id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0caa075d69" FOREIGN KEY ("owner_id") REFERENCES "users" ("auto_id");
ALTER TABLE "ticket"
    ADD CONSTRAINT "fk937b5f0c1f6a9a4a" FOREIGN KEY ("void_by_user") REFERENCES "users" ("auto_id");

2015-10-24 01:08:24,682 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:25,135 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="USER_TICKETS">
		<column name="USER_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TICKET_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK925912531D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK925912531DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK92591253B3DEF497" foreignTable="USERS">
			<reference local="USER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK925912533E20AD51" foreignTable="USERS">
			<reference local="USER_ID" foreign="AUTO_ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:25,166 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "user_tickets"(
    "user_id" INT NOT NULL,
    "ticket_id" INT NOT NULL,
    PRIMARY KEY ("user_id", "ticket_id")
);
ALTER TABLE "user_tickets"
    ADD CONSTRAINT "fk925912531d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "user_tickets"
    ADD CONSTRAINT "fk925912531df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "user_tickets"
    ADD CONSTRAINT "fk92591253b3def497" FOREIGN KEY ("user_id") REFERENCES "users" ("auto_id");
ALTER TABLE "user_tickets"
    ADD CONSTRAINT "fk925912533e20ad51" FOREIGN KEY ("user_id") REFERENCES "users" ("auto_id");

2015-10-24 01:08:25,260 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:25,697 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_CATEGORY">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" required="true" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="VISIBLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="BEVERAGE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<index name="FOOD_CATEGORY_VISIBLE">
			<index-column name="VISIBLE"/>
		</index>
	</table>
</database>
2015-10-24 01:08:25,713 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "menu_category"(
    "id" INT NOT NULL,
    "modified_time" DATETIME NOT NULL,
    "name" VARCHAR(20) NOT NULL,
    "visible" SMALLINT,
    "beverage" SMALLINT,
    PRIMARY KEY ("id")
);
CREATE INDEX "food_category_visible" ON "menu_category" ("visible");

2015-10-24 01:08:25,791 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:26,244 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_GROUP">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" required="true" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="VISIBLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="CATEGORY_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MENU_CATEGORY_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="BAR" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="VIEW_ORDER_VALUE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="BUTTON_COLOR" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="IS_DEFAULT_SCREEN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINT_ORDER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK4DC1AB7F8B722136" foreignTable="MENU_CATEGORY">
			<reference local="CATEGORY_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4DC1AB7FF4397E56" foreignTable="MENU_CATEGORY">
			<reference local="MENU_CATEGORY_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4DC1AB7F2E347FF0" foreignTable="MENU_CATEGORY">
			<reference local="CATEGORY_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4DC1AB7F96FBDD10" foreignTable="MENU_CATEGORY">
			<reference local="MENU_CATEGORY_ID" foreign="ID"/>
		</foreign-key>
		<index name="MENUGROUPVISIBLE">
			<index-column name="VISIBLE"/>
		</index>
	</table>
</database>
2015-10-24 01:08:26,276 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "menu_group"(
    "id" INT NOT NULL,
    "modified_time" DATETIME NOT NULL,
    "name" VARCHAR(20) NOT NULL,
    "visible" SMALLINT,
    "category_id" INT,
    "menu_category_id" INT,
    "bar" SMALLINT,
    "view_order_value" INT,
    "button_color" INT,
    "is_default_screen" SMALLINT,
    "print_order" INT,
    PRIMARY KEY ("id")
);
CREATE INDEX "menugroupvisible" ON "menu_group" ("visible");
ALTER TABLE "menu_group"
    ADD CONSTRAINT "fk4dc1ab7f8b722136" FOREIGN KEY ("category_id") REFERENCES "menu_category" ("id");
ALTER TABLE "menu_group"
    ADD CONSTRAINT "fk4dc1ab7ff4397e56" FOREIGN KEY ("menu_category_id") REFERENCES "menu_category" ("id");
ALTER TABLE "menu_group"
    ADD CONSTRAINT "fk4dc1ab7f2e347ff0" FOREIGN KEY ("category_id") REFERENCES "menu_category" ("id");
ALTER TABLE "menu_group"
    ADD CONSTRAINT "fk4dc1ab7f96fbdd10" FOREIGN KEY ("menu_category_id") REFERENCES "menu_category" ("id");

2015-10-24 01:08:26,385 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:26,822 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_ITEM">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" required="true" type="VARCHAR" size="50">
			<platform-column name="derby" type="VARCHAR" size="50"/>
		</column>
		<column name="PRICE" required="true" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DISCOUNT_RATE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="VISIBLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="GROUP_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TAX_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PLU" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VIEW_ORDER_VALUE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="BUTTON_COLOR" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NEXT_SCREEN" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="BUFFET" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINT_TO_KITCHEN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="AVAILABLE_ONLINE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="ONLINE_SPECIFIC" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="ENABLED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FK4CD5A1F36211FE9E" foreignTable="MENU_GROUP">
			<reference local="GROUP_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4CD5A1F35188AA24" foreignTable="MENU_GROUP">
			<reference local="GROUP_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4CD5A1F3D9D8E77D" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4CD5A1F3A4802F83" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:26,854 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "menu_item"(
    "id" INT NOT NULL,
    "modified_time" DATETIME NOT NULL,
    "name" VARCHAR(50) NOT NULL,
    "price" FLOAT NOT NULL,
    "discount_rate" FLOAT,
    "visible" SMALLINT,
    "group_id" INT,
    "tax_id" INT,
    "plu" INT,
    "view_order_value" INT,
    "button_color" INT,
    "next_screen" VARCHAR(30),
    "buffet" SMALLINT,
    "print_to_kitchen" SMALLINT,
    "available_online" SMALLINT,
    "online_specific" VARCHAR(255),
    "enabled" SMALLINT,
    PRIMARY KEY ("id")
);
ALTER TABLE "menu_item"
    ADD CONSTRAINT "fk4cd5a1f36211fe9e" FOREIGN KEY ("group_id") REFERENCES "menu_group" ("id");
ALTER TABLE "menu_item"
    ADD CONSTRAINT "fk4cd5a1f35188aa24" FOREIGN KEY ("group_id") REFERENCES "menu_group" ("id");
ALTER TABLE "menu_item"
    ADD CONSTRAINT "fk4cd5a1f3d9d8e77d" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id");
ALTER TABLE "menu_item"
    ADD CONSTRAINT "fk4cd5a1f3a4802f83" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id");

2015-10-24 01:08:26,979 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:27,447 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKET_ITEM">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="ITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_COUNT" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="GROUP_NAME" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="CATEGORY_NAME" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="ITEM_PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DISCOUNT_RATE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="ITEM_TAX_RATE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SUB_TOTAL" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SUB_TOTAL_WITH_MODIFIERS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DISCOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_AMOUNT_WITH_MODIFIERS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_PRICE_WITH_MODIFIERS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="BEVERAGE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINT_TO_KITCHEN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="HAS_MODIIERS" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINTED_TO_KITCHEN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_ORDER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VOIDED" type="SMALLINT" size="5" default="0">
			<platform-column name="derby" type="SMALLINT" size="5" default="0"/>
		</column>
		<column name="COMPED" type="SMALLINT" size="5" default="0">
			<platform-column name="derby" type="SMALLINT" size="5" default="0"/>
		</column>
		<column name="BUFFET" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="MENU_ITEM" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ALREADY_SENT" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINT_ORDER_VALUE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VOID_REASON" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="CONSTRUCTION_ZONE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FK979F546664931EFC" foreignTable="MENU_ITEM">
			<reference local="MENU_ITEM" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK979F54661D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK979F54661DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:27,494 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "ticket_item"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "modified_time" DATETIME NOT NULL,
    "item_id" INT,
    "item_count" INT,
    "item_name" VARCHAR(30),
    "group_name" VARCHAR(20),
    "category_name" VARCHAR(20),
    "item_price" FLOAT,
    "discount_rate" FLOAT,
    "item_tax_rate" FLOAT,
    "sub_total" FLOAT,
    "sub_total_with_modifiers" FLOAT,
    "discount" FLOAT,
    "tax_amount" FLOAT,
    "tax_amount_with_modifiers" FLOAT,
    "total_price" FLOAT,
    "total_price_with_modifiers" FLOAT,
    "beverage" SMALLINT,
    "print_to_kitchen" SMALLINT,
    "has_modiiers" SMALLINT,
    "printed_to_kitchen" SMALLINT,
    "ticket_id" INT,
    "item_order" INT,
    "voided" SMALLINT DEFAULT 0,
    "comped" SMALLINT DEFAULT 0,
    "buffet" SMALLINT,
    "menu_item" INT,
    "already_sent" SMALLINT,
    "print_order_value" INT,
    "void_reason" VARCHAR(255),
    "construction_zone" SMALLINT,
    PRIMARY KEY ("id")
);
ALTER TABLE "ticket_item"
    ADD CONSTRAINT "fk979f546664931efc" FOREIGN KEY ("menu_item") REFERENCES "menu_item" ("id");
ALTER TABLE "ticket_item"
    ADD CONSTRAINT "fk979f54661d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "ticket_item"
    ADD CONSTRAINT "fk979f54661df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");

2015-10-24 01:08:27,619 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:28,072 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="COMP_REASONS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON_TEXT" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TICKET_ITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FKBD53115F1D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKBD53115F1DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKBD53115FDF674CD0" foreignTable="TICKET_ITEM">
			<reference local="TICKET_ITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKBD53115FDEC6120A" foreignTable="TICKET_ITEM">
			<reference local="TICKET_ITEM_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:28,104 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "comp_reasons"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "reason_text" VARCHAR(255),
    "ticket_id" INT,
    "item_id" INT,
    "ticket_item_id" INT,
    PRIMARY KEY ("id")
);
ALTER TABLE "comp_reasons"
    ADD CONSTRAINT "fkbd53115f1d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "comp_reasons"
    ADD CONSTRAINT "fkbd53115f1df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "comp_reasons"
    ADD CONSTRAINT "fkbd53115fdf674cd0" FOREIGN KEY ("ticket_item_id") REFERENCES "ticket_item" ("id");
ALTER TABLE "comp_reasons"
    ADD CONSTRAINT "fkbd53115fdec6120a" FOREIGN KEY ("ticket_item_id") REFERENCES "ticket_item" ("id");

2015-10-24 01:08:28,213 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:28,760 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="CREDIT_CARD_INFO">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CUSTOMER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CARD_NUMBER" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="CARD_TYPE" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="RECORD_NO" type="VARCHAR" size="150">
			<platform-column name="derby" type="VARCHAR" size="150"/>
		</column>
		<foreign-key name="FK5A3902B7F1397137" foreignTable="CUSTOMER">
			<reference local="CUSTOMER_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:28,776 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "credit_card_info"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "customer_id" INT,
    "card_number" VARCHAR(30),
    "card_type" VARCHAR(30),
    "record_no" VARCHAR(150),
    PRIMARY KEY ("id")
);
ALTER TABLE "credit_card_info"
    ADD CONSTRAINT "fk5a3902b7f1397137" FOREIGN KEY ("customer_id") REFERENCES "customer" ("id");

2015-10-24 01:08:28,901 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:29,322 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="END_OF_DAY_REPORT">
		<column name="ID" primaryKey="true" required="true" type="NUMERIC" size="5">
			<platform-column name="derby" type="NUMERIC" size="5"/>
		</column>
		<column name="DATE" required="true" type="DATE" size="10">
			<platform-column name="derby" type="DATE" size="10"/>
		</column>
		<column name="TOTAL_SALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_VOIDS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_COMPS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_LABOR_COST" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_LABOR_HOURS" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NUM_TICKETS" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NUM_DELIVERIES" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="AVERAGE_CLAIM_TIME" type="BIGINT" size="19">
			<platform-column name="derby" type="BIGINT" size="19"/>
		</column>
		<column name="AVERAGE_DELIVERY_ROUTE_TIME" type="BIGINT" size="19">
			<platform-column name="derby" type="BIGINT" size="19"/>
		</column>
		<column name="FINAL_TICKET_NUMBER" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTAL_LABOR_HRS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TIMESTAMP" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="CASH_DEPOSIT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DISCOUNTS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CHARGES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GIFT_CARD_REDEEMS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GIFT_CARD_SALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GROSS_SALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="NET_SALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="NET_TAXES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="OVER_UNDER" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="PAYOUTS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SALES_BEVERAGES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SALES_FOOD" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SALESMERCH" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_BEVERAGES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_FOOD" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_MERCH" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CHARGE_TIPS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DELIVERY_CHARGES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DELIVERY_FEES_PAID_OUT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="POS_VERSION" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<unique name="SQL130330031001490">
			<unique-column name="DATE"/>
		</unique>
		<unique name="SQL130330031001491">
			<unique-column name="FINAL_TICKET_NUMBER"/>
		</unique>
	</table>
</database>
2015-10-24 01:08:29,369 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "end_of_day_report"(
    "id" NUMERIC(5,0) NOT NULL,
    "date" DATETIME NOT NULL,
    "total_sales" FLOAT,
    "total_voids" FLOAT,
    "total_comps" FLOAT,
    "total_labor_cost" FLOAT,
    "total_labor_hours" INT,
    "num_tickets" INT,
    "num_deliveries" INT,
    "average_claim_time" BIGINT,
    "average_delivery_route_time" BIGINT,
    "final_ticket_number" INT NOT NULL,
    "total_labor_hrs" FLOAT,
    "timestamp" DATETIME,
    "cash_deposit" FLOAT,
    "discounts" FLOAT,
    "charges" FLOAT,
    "gift_card_redeems" FLOAT,
    "gift_card_sales" FLOAT,
    "gross_sales" FLOAT,
    "net_sales" FLOAT,
    "net_taxes" FLOAT,
    "over_under" FLOAT,
    "payouts" FLOAT,
    "sales_beverages" FLOAT,
    "sales_food" FLOAT,
    "salesmerch" FLOAT,
    "tax_beverages" FLOAT,
    "tax_food" FLOAT,
    "tax_merch" FLOAT,
    "charge_tips" FLOAT,
    "delivery_charges" FLOAT,
    "delivery_fees_paid_out" FLOAT,
    "pos_version" INT,
    PRIMARY KEY ("id")
);
CREATE UNIQUE INDEX "sql130330031001490" ON "end_of_day_report" ("date");
CREATE UNIQUE INDEX "sql130330031001491" ON "end_of_day_report" ("final_ticket_number");

2015-10-24 01:08:29,494 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:29,885 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="ADDRESSES_LATITUDES_LONGITUDES">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CUSTOMER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ADDRESS_1" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="ADDRESS_2" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="LATITUDE" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="LONGITUDE" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="IS_DELIVERY" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FK4A889B19F1397137" foreignTable="CUSTOMER">
			<reference local="CUSTOMER_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4A889B199E1C3CF1" foreignTable="CUSTOMER">
			<reference local="CUSTOMER_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:29,901 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "addresses_latitudes_longitudes"(
    "id" INT NOT NULL,
    "customer_id" INT,
    "address_1" VARCHAR(255),
    "address_2" VARCHAR(255),
    "latitude" VARCHAR(255),
    "longitude" VARCHAR(255),
    "is_delivery" SMALLINT,
    PRIMARY KEY ("id")
);
ALTER TABLE "addresses_latitudes_longitudes"
    ADD CONSTRAINT "fk4a889b19f1397137" FOREIGN KEY ("customer_id") REFERENCES "customer" ("id");
ALTER TABLE "addresses_latitudes_longitudes"
    ADD CONSTRAINT "fk4a889b199e1c3cf1" FOREIGN KEY ("customer_id") REFERENCES "customer" ("id");

2015-10-24 01:08:30,010 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:30,432 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKET_COUPON_DISCOUNT">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="COUPON_DISCOUNT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="TYPE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VALUE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="D_ORDER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK3A1F32071D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK3A1F32071DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:30,447 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "ticket_coupon_discount"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "coupon_discount_id" INT,
    "name" VARCHAR(30),
    "type" INT,
    "value" FLOAT,
    "ticket_id" INT,
    "d_order" INT,
    PRIMARY KEY ("id")
);
ALTER TABLE "ticket_coupon_discount"
    ADD CONSTRAINT "fk3a1f32071d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "ticket_coupon_discount"
    ADD CONSTRAINT "fk3a1f32071df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");

2015-10-24 01:08:30,541 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:30,994 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKETITEM_MODIFIERGROUP">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="GROUP_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MIN_QUANTITY" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MAX_QUANTITY" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PARENT" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TICKETITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_ORDER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK21D455C8A7DD55E6" foreignTable="TICKET_ITEM">
			<reference local="PARENT" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK21D455C8DCBC5677" foreignTable="TICKET_ITEM">
			<reference local="TICKETITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK21D455C8A73C1B20" foreignTable="TICKET_ITEM">
			<reference local="PARENT" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK21D455C8DC1B1BB1" foreignTable="TICKET_ITEM">
			<reference local="TICKETITEM_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:31,010 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "ticketitem_modifiergroup"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "modified_time" DATETIME NOT NULL,
    "group_id" INT,
    "min_quantity" INT,
    "max_quantity" INT,
    "parent" INT,
    "ticketitem_id" INT,
    "item_order" INT,
    PRIMARY KEY ("id")
);
ALTER TABLE "ticketitem_modifiergroup"
    ADD CONSTRAINT "fk21d455c8a7dd55e6" FOREIGN KEY ("parent") REFERENCES "ticket_item" ("id");
ALTER TABLE "ticketitem_modifiergroup"
    ADD CONSTRAINT "fk21d455c8dcbc5677" FOREIGN KEY ("ticketitem_id") REFERENCES "ticket_item" ("id");
ALTER TABLE "ticketitem_modifiergroup"
    ADD CONSTRAINT "fk21d455c8a73c1b20" FOREIGN KEY ("parent") REFERENCES "ticket_item" ("id");
ALTER TABLE "ticketitem_modifiergroup"
    ADD CONSTRAINT "fk21d455c8dc1b1bb1" FOREIGN KEY ("ticketitem_id") REFERENCES "ticket_item" ("id");

2015-10-24 01:08:31,119 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:31,604 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_ITEM_SUGGESTIONS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TYPE" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PARENT_ITEM_PLU" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SUGGESTION_PLU" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
	</table>
</database>
2015-10-24 01:08:31,619 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "menu_item_suggestions"(
    "id" INT NOT NULL,
    "type" INT NOT NULL,
    "parent_item_plu" INT NOT NULL,
    "suggestion_plu" INT NOT NULL,
    PRIMARY KEY ("id")
);

2015-10-24 01:08:31,713 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:32,166 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="RETURN_REASON">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TEXT" required="true" type="VARCHAR" size="256">
			<platform-column name="derby" type="VARCHAR" size="256"/>
		</column>
	</table>
</database>
2015-10-24 01:08:32,166 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "return_reason"(
    "id" INT NOT NULL,
    "text" VARCHAR(256) NOT NULL,
    PRIMARY KEY ("id")
);

2015-10-24 01:08:32,260 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:32,682 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="USER_PERMISSION">
		<column name="NAME" primaryKey="true" required="true" type="VARCHAR" size="40">
			<platform-column name="derby" type="VARCHAR" size="40"/>
		</column>
	</table>
</database>
2015-10-24 01:08:32,697 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "user_permission"(
    "name" VARCHAR(40) NOT NULL,
    PRIMARY KEY ("name")
);

2015-10-24 01:08:32,791 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:33,244 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="DRAWER_PULL_REPORT">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REPORT_TIME" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="REG" type="VARCHAR" size="15">
			<platform-column name="derby" type="VARCHAR" size="15"/>
		</column>
		<column name="TICKET_COUNT" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="BEGIN_CASH" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="NET_SALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SALES_TAX" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_TAX" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_REVENUE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GROSS_RECEIPTS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GIFTCERTRETURNCOUNT" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="GIFTCERTRETURNAMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GIFTCERTCHANGEAMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_RECEIPT_NO" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CASH_RECEIPT_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CREDIT_CARD_RECEIPT_NO" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CREDIT_CARD_RECEIPT_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DEBIT_CARD_RECEIPT_NO" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DEBIT_CARD_RECEIPT_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="RECEIPT_DIFFERENTIAL" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_BACK" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_TIPS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CHARGED_TIPS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TIPS_PAID" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TIPS_DIFFERENTIAL" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="PAY_OUT_NO" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PAY_OUT_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DRAWER_BLEED_NO" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DRAWER_BLEED_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DRAWER_ACCOUNTABLE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_TO_DEPOSIT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="VARIANCE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALVOIDWST" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALVOID" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALDISCOUNTCOUNT" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTALDISCOUNTAMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALDISCOUNTSALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALDISCOUNTGUEST" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTALDISCOUNTPARTYSIZE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTALDISCOUNTCHECKSIZE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTALDISCOUNTPERCENTAGE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALDISCOUNTRATIO" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TERMINAL_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTALCOMP" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<foreign-key name="FKAEC362207DF00477" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKAEC362202AD2D031" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<index name="DRAWER_REPORT_TIME">
			<index-column name="REPORT_TIME"/>
		</index>
	</table>
</database>
2015-10-24 01:08:33,291 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "drawer_pull_report"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "report_time" DATETIME,
    "reg" VARCHAR(15),
    "ticket_count" INT,
    "begin_cash" FLOAT,
    "net_sales" FLOAT,
    "sales_tax" FLOAT,
    "cash_tax" FLOAT,
    "total_revenue" FLOAT,
    "gross_receipts" FLOAT,
    "giftcertreturncount" INT,
    "giftcertreturnamount" FLOAT,
    "giftcertchangeamount" FLOAT,
    "cash_receipt_no" INT,
    "cash_receipt_amount" FLOAT,
    "credit_card_receipt_no" INT,
    "credit_card_receipt_amount" FLOAT,
    "debit_card_receipt_no" INT,
    "debit_card_receipt_amount" FLOAT,
    "receipt_differential" FLOAT,
    "cash_back" FLOAT,
    "cash_tips" FLOAT,
    "charged_tips" FLOAT,
    "tips_paid" FLOAT,
    "tips_differential" FLOAT,
    "pay_out_no" INT,
    "pay_out_amount" FLOAT,
    "drawer_bleed_no" INT,
    "drawer_bleed_amount" FLOAT,
    "drawer_accountable" FLOAT,
    "cash_to_deposit" FLOAT,
    "variance" FLOAT,
    "totalvoidwst" FLOAT,
    "totalvoid" FLOAT,
    "totaldiscountcount" INT,
    "totaldiscountamount" FLOAT,
    "totaldiscountsales" FLOAT,
    "totaldiscountguest" INT,
    "totaldiscountpartysize" INT,
    "totaldiscountchecksize" INT,
    "totaldiscountpercentage" FLOAT,
    "totaldiscountratio" FLOAT,
    "terminal_id" INT,
    "totalcomp" FLOAT,
    PRIMARY KEY ("id")
);
CREATE INDEX "drawer_report_time" ON "drawer_pull_report" ("report_time");
ALTER TABLE "drawer_pull_report"
    ADD CONSTRAINT "fkaec362207df00477" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id");
ALTER TABLE "drawer_pull_report"
    ADD CONSTRAINT "fkaec362202ad2d031" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id");

2015-10-24 01:08:33,463 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:33,932 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="COMPTICKETS">
		<column name="DPREPORT_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CODE" primaryKey="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON" primaryKey="true" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="HAST" primaryKey="true" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="QUANTITY" primaryKey="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="AMOUNT" primaryKey="true" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TICKET_ID" primaryKey="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_ID" primaryKey="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="COMPED_BY" primaryKey="true" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<foreign-key name="FK284DA0D896545BE1" foreignTable="DRAWER_PULL_REPORT">
			<reference local="DPREPORT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK284DA0D83EF4CD9B" foreignTable="DRAWER_PULL_REPORT">
			<reference local="DPREPORT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="SQL130209220535990" foreignTable="DRAWER_PULL_REPORT">
			<reference local="DPREPORT_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:33,947 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "comptickets"(
    "dpreport_id" INT NOT NULL,
    "code" INT,
    "reason" VARCHAR(255),
    "hast" VARCHAR(255),
    "quantity" INT,
    "amount" FLOAT,
    "ticket_id" INT,
    "item_id" INT,
    "comped_by" VARCHAR(100),
    PRIMARY KEY ("dpreport_id", "code", "reason", "hast", "quantity", "amount", "ticket_id", "item_id", "comped_by")
);
ALTER TABLE "comptickets"
    ADD CONSTRAINT "fk284da0d896545be1" FOREIGN KEY ("dpreport_id") REFERENCES "drawer_pull_report" ("id");
ALTER TABLE "comptickets"
    ADD CONSTRAINT "fk284da0d83ef4cd9b" FOREIGN KEY ("dpreport_id") REFERENCES "drawer_pull_report" ("id");
ALTER TABLE "comptickets"
    ADD CONSTRAINT "sql130209220535990" FOREIGN KEY ("dpreport_id") REFERENCES "drawer_pull_report" ("id");

2015-10-24 01:08:34,010 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:34,447 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="PAYOUT_RECEPIENTS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NAME" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
	</table>
</database>
2015-10-24 01:08:34,463 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "payout_recepients"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "name" VARCHAR(255),
    PRIMARY KEY ("id")
);

2015-10-24 01:08:34,557 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:35,041 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="COUPON_AND_DISCOUNT">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="TYPE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VALUE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="EXPIRY_DATE" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="DISABLED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="NEVER_EXPIRE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TIME_FROM" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TIME_TO" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="RULE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SUN_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="MON_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TUE_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="WED_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="THUR_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="FRI_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="SAT_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="AUTOMATIC" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRIORITY" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="COUPON_CODE" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
	</table>
</database>
2015-10-24 01:08:35,072 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "coupon_and_discount"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "name" VARCHAR(30),
    "type" INT,
    "value" FLOAT,
    "expiry_date" DATETIME,
    "disabled" SMALLINT,
    "never_expire" SMALLINT,
    "time_from" VARCHAR(255),
    "time_to" VARCHAR(255),
    "rule" INT,
    "sun_available" SMALLINT,
    "mon_available" SMALLINT,
    "tue_available" SMALLINT,
    "wed_available" SMALLINT,
    "thur_available" SMALLINT,
    "fri_available" SMALLINT,
    "sat_available" SMALLINT,
    "automatic" SMALLINT,
    "priority" INT,
    "coupon_code" VARCHAR(250),
    PRIMARY KEY ("id")
);

2015-10-24 01:08:35,166 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:35,604 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="COMBO_CATEGORY">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="COUPON_AND_DISCOUNT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="COMBO_GROUP" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MENU_GROUP_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="AVAILABILITY_DATE" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<foreign-key name="FK49760AF304A40ED" foreignTable="COUPON_AND_DISCOUNT">
			<reference local="COUPON_AND_DISCOUNT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK49760AF9BB80673" foreignTable="COUPON_AND_DISCOUNT">
			<reference local="COUPON_AND_DISCOUNT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK49760AF9E2CB57E" foreignTable="MENU_GROUP">
			<reference local="MENU_GROUP_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK49760AF8DA36104" foreignTable="MENU_GROUP">
			<reference local="MENU_GROUP_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:35,619 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "combo_category"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "coupon_and_discount_id" INT,
    "combo_group" INT,
    "menu_group_id" INT,
    "availability_date" DATETIME,
    PRIMARY KEY ("id")
);
ALTER TABLE "combo_category"
    ADD CONSTRAINT "fk49760af304a40ed" FOREIGN KEY ("coupon_and_discount_id") REFERENCES "coupon_and_discount" ("id");
ALTER TABLE "combo_category"
    ADD CONSTRAINT "fk49760af9bb80673" FOREIGN KEY ("coupon_and_discount_id") REFERENCES "coupon_and_discount" ("id");
ALTER TABLE "combo_category"
    ADD CONSTRAINT "fk49760af9e2cb57e" FOREIGN KEY ("menu_group_id") REFERENCES "menu_group" ("id");
ALTER TABLE "combo_category"
    ADD CONSTRAINT "fk49760af8da36104" FOREIGN KEY ("menu_group_id") REFERENCES "menu_group" ("id");

2015-10-24 01:08:35,729 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:36,182 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="DELIVERY_RETURN_REASON">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON_TEXT" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CUSTOM_REASON" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FK66917F287014AE47" foreignTable="RETURN_REASON">
			<reference local="REASON_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK66917F2812D70D01" foreignTable="RETURN_REASON">
			<reference local="REASON_ID" foreign="ID"/>
		</foreign-key>
		<index name="DELIVERY_RETURN_REASON_REASON_ID_IDX">
			<index-column name="REASON_ID"/>
		</index>
	</table>
</database>
2015-10-24 01:08:36,213 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "delivery_return_reason"(
    "id" INT NOT NULL,
    "reason_text" VARCHAR(255),
    "ticket_id" INT,
    "reason_id" INT,
    "custom_reason" SMALLINT,
    PRIMARY KEY ("id")
);
CREATE INDEX "delivery_return_reason_reason_id_idx" ON "delivery_return_reason" ("reason_id");
ALTER TABLE "delivery_return_reason"
    ADD CONSTRAINT "fk66917f287014ae47" FOREIGN KEY ("reason_id") REFERENCES "return_reason" ("id");
ALTER TABLE "delivery_return_reason"
    ADD CONSTRAINT "fk66917f2812d70d01" FOREIGN KEY ("reason_id") REFERENCES "return_reason" ("id");

2015-10-24 01:08:36,307 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:36,760 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENUITEM_MENUMODIFIERS">
		<column name="MENU_ITEM_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MENU_MODIFIER_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK616CF150DD1B5836" foreignTable="MENU_ITEM">
			<reference local="MENU_ITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK616CF15089FE23F0" foreignTable="MENU_ITEM">
			<reference local="MENU_ITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK616CF15014DA03B6" foreignTable="MENU_MODIFIER">
			<reference local="MENU_MODIFIER_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK616CF150B79C6270" foreignTable="MENU_MODIFIER">
			<reference local="MENU_MODIFIER_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:36,776 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "menuitem_menumodifiers"(
    "menu_item_id" INT NOT NULL,
    "menu_modifier_id" INT NOT NULL,
    PRIMARY KEY ("menu_item_id", "menu_modifier_id")
);
ALTER TABLE "menuitem_menumodifiers"
    ADD CONSTRAINT "fk616cf150dd1b5836" FOREIGN KEY ("menu_item_id") REFERENCES "menu_item" ("id");
ALTER TABLE "menuitem_menumodifiers"
    ADD CONSTRAINT "fk616cf15089fe23f0" FOREIGN KEY ("menu_item_id") REFERENCES "menu_item" ("id");
ALTER TABLE "menuitem_menumodifiers"
    ADD CONSTRAINT "fk616cf15014da03b6" FOREIGN KEY ("menu_modifier_id") REFERENCES "menu_modifier" ("id");
ALTER TABLE "menuitem_menumodifiers"
    ADD CONSTRAINT "fk616cf150b79c6270" FOREIGN KEY ("menu_modifier_id") REFERENCES "menu_modifier" ("id");

2015-10-24 01:08:36,885 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:37,338 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKET_COOKING_INSTRUCTION">
		<column name="TICKET_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DESCRIPTION" primaryKey="true" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="PRINTEDTOKITCHEN" primaryKey="true" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FKD2C835761D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKD2C835761DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:37,354 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "ticket_cooking_instruction"(
    "ticket_id" INT NOT NULL,
    "description" VARCHAR(60),
    "printedtokitchen" SMALLINT,
    PRIMARY KEY ("ticket_id", "description", "printedtokitchen")
);
ALTER TABLE "ticket_cooking_instruction"
    ADD CONSTRAINT "fkd2c835761d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "ticket_cooking_instruction"
    ADD CONSTRAINT "fkd2c835761df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");

2015-10-24 01:08:37,447 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:37,916 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="VOID_REASONS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON_TEXT" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TICKET_ITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK8B275EE41D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK8B275EE41DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK8B275EE4DF674CD0" foreignTable="TICKET_ITEM">
			<reference local="TICKET_ITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK8B275EE4DEC6120A" foreignTable="TICKET_ITEM">
			<reference local="TICKET_ITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK8B275EE460B3CC3D" foreignTable="TICKET_ITEM">
			<reference local="ITEM_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
2015-10-24 01:08:37,932 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "void_reasons"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "reason_text" VARCHAR(255),
    "ticket_id" INT,
    "item_id" INT,
    "ticket_item_id" INT,
    PRIMARY KEY ("id")
);
ALTER TABLE "void_reasons"
    ADD CONSTRAINT "fk8b275ee41d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "void_reasons"
    ADD CONSTRAINT "fk8b275ee41df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "void_reasons"
    ADD CONSTRAINT "fk8b275ee4df674cd0" FOREIGN KEY ("ticket_item_id") REFERENCES "ticket_item" ("id");
ALTER TABLE "void_reasons"
    ADD CONSTRAINT "fk8b275ee4dec6120a" FOREIGN KEY ("ticket_item_id") REFERENCES "ticket_item" ("id");
ALTER TABLE "void_reasons"
    ADD CONSTRAINT "fk8b275ee460b3cc3d" FOREIGN KEY ("item_id") REFERENCES "ticket_item" ("id");

2015-10-24 01:08:38,057 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:38,526 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="CUSTOM_PAYMENT_TYPE">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TYPE_NAME" required="true" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="TIPS" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
	</table>
</database>
2015-10-24 01:08:38,541 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "custom_payment_type"(
    "id" INT NOT NULL,
    "type_name" VARCHAR(30) NOT NULL,
    "tips" SMALLINT,
    PRIMARY KEY ("id")
);

2015-10-24 01:08:38,619 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:39,072 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="PAYOUT_REASONS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
	</table>
</database>
2015-10-24 01:08:39,088 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "payout_reasons"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "reason" VARCHAR(255),
    PRIMARY KEY ("id")
);

2015-10-24 01:08:39,182 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001.  There were 0 batches in error
2015-10-24 01:08:39,713 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TRANSACTIONS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PAYMENT_TYPE" required="true" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="TRANSACTION_TIME" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="SUB_TOTAL" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_DISCOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_TAX" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GRATUITY_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DRAWER_RESETTED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TERMINAL_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="USER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="FACE_VALUE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="PAID_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_BACK_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CARD_NUMBER" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="CARD_TYPE" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="NOTE" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="REASON_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="RECEPIENT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="RAW_XML_RESPONSE" type="VARCHAR" size="10000">
			<platform-column name="derby" type="VARCHAR" size="10000"/>
		</column>
		<column name="DUE_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TYPE_NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="DELIVERY_FEE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<foreign-key name="FKFE987155CDFC1E3D" foreignTable="PAYOUT_REASONS">
			<reference local="REASON_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE98715570BE7CF7" foreignTable="PAYOUT_REASONS">
			<reference local="REASON_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE987155B00959BD" foreignTable="PAYOUT_RECEPIENTS">
			<reference local="RECEPIENT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE9871557DF00477" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE9871552AD2D031" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE9871551D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE9871551DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE987155B3DEF497" foreignTable="USERS">
			<reference local="USER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FKFE9871553E20AD51" foreignTable="USERS">
			<reference local="USER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<index name="TRAN_DRAWER_RESETTED">
			<index-column name="DRAWER_RESETTED"/>
		</index>
	</table>
</database>
2015-10-24 01:08:39,744 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql:
SET quoted_identifier on;
SET quoted_identifier on;
CREATE TABLE "transactions"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "payment_type" VARCHAR(20) NOT NULL,
    "modified_time" DATETIME NOT NULL,
    "transaction_time" DATETIME,
    "sub_total" FLOAT,
    "total_discount" FLOAT,
    "total_tax" FLOAT,
    "total_price" FLOAT,
    "gratuity_amount" FLOAT,
    "drawer_resetted" SMALLINT,
    "terminal_id" INT,
    "ticket_id" INT,
    "user_id" INT,
    "face_value" FLOAT,
    "paid_amount" FLOAT,
    "cash_back_amount" FLOAT,
    "card_number" VARCHAR(30),
    "card_type" VARCHAR(30),
    "note" VARCHAR(255),
    "reason_id" INT,
    "recepient_id" INT,
    "raw_xml_response" VARCHAR(10000),
    "due_amount" FLOAT,
    "type_name" VARCHAR(30),
    "delivery_fee" FLOAT,
    PRIMARY KEY ("id")
);
CREATE INDEX "tran_drawer_resetted" ON "transactions" ("drawer_resetted");
ALTER TABLE "transactions"
    ADD CONSTRAINT "fkfe987155cdfc1e3d" FOREIGN KEY ("reason_id") REFERENCES "payout_reasons" ("id");
ALTER TABLE "transactions"
    ADD CONSTRAINT "fkfe98715570be7cf7" FOREIGN KEY ("reason_id") REFERENCES "payout_reasons" ("id");
ALTER TABLE "transactions"
    ADD CONSTRAINT "fkfe987155b00959bd" FOREIGN KEY ("recepient_id") REFERENCES "payout_recepients" ("id");
ALTER TABLE "transactions"
    ADD CONSTRAINT "fkfe9871557df00477" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id");
ALTER TABLE "transactions"
    ADD CONSTRAINT "fkfe9871552ad2d031" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id");
ALTER TABLE "transactions"
    ADD CONSTRAINT "fkfe9871551d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "transactions"
    ADD CONSTRAINT "fkfe9871551df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id");
ALTER TABLE "transactions"
    ADD CONSTRAINT "fkfe987155b3def497" FOREIGN KEY ("user_id") REFERENCES "users" ("auto_id");
ALTER TABLE "transactions"
    ADD CONSTRAINT "fkfe9871553e20ad51" FOREIGN KEY ("user_id") REFERENCES "users" ("auto_id");

2015-10-24 01:08:39,776 WARN [reportsdb-000] [JdbcSqlTemplate] [qtp28759214-11] The size (10000) given to the column 'raw_xml_response' exceeds the maximum allowed for any data type (8000)..  Failed to execute: CREATE TABLE "transactions"(
    "id" INT NOT NULL IDENTITY (1,1) ,
    "payment_type" VARCHAR(20) NOT NULL,
    "modified_time" DATETIME NOT NULL,
    "transaction_time" DATETIME,
    "sub_total" FLOAT,
    "total_discount" FLOAT,
    "total_tax" FLOAT,
    "total_price" FLOAT,
    "gratuity_amount" FLOAT,
    "drawer_resetted" SMALLINT,
    "terminal_id" INT,
    "ticket_id" INT,
    "user_id" INT,
    "face_value" FLOAT,
    "paid_amount" FLOAT,
    "cash_back_amount" FLOAT,
    "card_number" VARCHAR(30),
    "card_type" VARCHAR(30),
    "note" VARCHAR(255),
    "reason_id" INT,
    "recepient_id" INT,
    "raw_xml_response" VARCHAR(10000),
    "due_amount" FLOAT,
    "type_name" VARCHAR(30),
    "delivery_fee" FLOAT,
    PRIMARY KEY ("id")
)