MariaDB [cbx]> show create table orders ; +--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | orders | CREATE TABLE `orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `date` date NOT NULL, `created_stamp` datetime(6) DEFAULT NULL, `expiry_stamp` datetime DEFAULT NULL, `status` enum('ACTIVE','EXPIRED','EXECUTED','CLOSED','DECLINED','SUSPENDED','ENGAGED') DEFAULT NULL, `bond_id` int(11) NOT NULL, `bs` enum('B','S') DEFAULT NULL, `type` enum('Outright','Swap','Both') DEFAULT NULL, `swap_size` decimal(12,0) DEFAULT NULL, `swap_filled` decimal(12,0) DEFAULT 0, `swap_price` decimal(12,4) DEFAULT NULL, `delta` decimal(6,3) DEFAULT NULL, `outright_size` decimal(12,0) DEFAULT NULL, `outright_filled` decimal(12,0) DEFAULT 0, `outright_price` decimal(12,4) DEFAULT NULL, `outright_floating` enum('Y','N') DEFAULT NULL, `price_adj` decimal(9,4) DEFAULT NULL, `price_type` enum('PX','SPREAD','YIELD','MMYld') DEFAULT 'PX', `ref_stock_price` decimal(9,3) DEFAULT NULL, `spot_stock_price` decimal(9,3) DEFAULT NULL, `spot_fx` decimal(9,5) DEFAULT NULL, `stock_above` decimal(10,4) DEFAULT NULL, `stock_below` decimal(10,4) DEFAULT NULL, `bd_type` enum('Standard','Block','Dark','Counter','BMP','BMP_Counter','Quote','QuoteResponse') DEFAULT NULL, `fill_or_kill` enum('N','Y') DEFAULT 'N', `all_or_nothing` enum('N','Y') DEFAULT 'N', `slippage` decimal(9,4) DEFAULT NULL, `exec_stamp` time DEFAULT NULL, `exec_stamp2` datetime(6) DEFAULT NULL, `reason` varchar(255) DEFAULT NULL, `min_delta` decimal(6,3) DEFAULT NULL, `max_delta` decimal(6,3) DEFAULT NULL, `account_id` varchar(64) DEFAULT NULL, `split_after` enum('N','Y') NOT NULL DEFAULT 'N', `cancel_suspend` enum('C','S') NOT NULL DEFAULT 'C', `stock_bond` enum('S','B') NOT NULL DEFAULT 'S', `euro_size` double DEFAULT NULL, `gbp_size` double DEFAULT NULL, `usd_size` double DEFAULT NULL, `ytm` decimal(10,6) DEFAULT NULL, `ytc` decimal(10,6) DEFAULT NULL, `x_order_id` varchar(64) DEFAULT NULL, `target` enum('All','BS','SS','Contra') DEFAULT NULL, `commission` decimal(10,4) DEFAULT NULL, `next_order_id` int(11) DEFAULT NULL, `comments` varchar(127) DEFAULT NULL, `am_bd` tinyint(1) NOT NULL DEFAULT 0, `ie_workflow_stage` enum('DARK','LIT','DARK_BLOCKS','DISPLAYED','RFQ','DARK_DISPLAYED','DARK_RFQ','DARK_ABOPT','ABOPT','DARK_ALGO','ALGO') DEFAULT NULL, `lis` decimal(18,3) DEFAULT NULL, `ssti` decimal(18,3) DEFAULT NULL, `is_liquid` tinyint(1) DEFAULT NULL, `sd_type` varchar(4) NOT NULL DEFAULT 'T+2', `sd` date DEFAULT NULL, `benchmark` varchar(12) DEFAULT NULL, `is_algo_eligible` tinyint(1) NOT NULL DEFAULT 0, `is_nit_firm` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), KEY `bond_id` (`bond_id`,`status`), KEY `user_id` (`user_id`), KEY `x_order_id` (`x_order_id`), KEY `status` (`status`), KEY `expiry_stamp` (`expiry_stamp`) ) ENGINE=Aria AUTO_INCREMENT=20921291 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 | +--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [cbx]> show create table bond ; +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | bond | CREATE TABLE `bond` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `isin` char(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `cusip` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `issuer_name` varchar(255) DEFAULT NULL, `issuer_country` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `currency` char(3) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `coupon` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `coupon_type` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `maturity` date DEFAULT NULL, `stock_id` int(11) DEFAULT NULL, `cross_ccy` smallint(6) DEFAULT 0, `denomination` double DEFAULT NULL, `min_denomination` double DEFAULT NULL, `conversion_price` decimal(18,8) DEFAULT NULL, `conversion_ratio` decimal(15,8) DEFAULT NULL, `put_date` date DEFAULT NULL, `put_redemption` decimal(12,6) DEFAULT NULL, `q_convention` enum('Notional','Units','Titles') NOT NULL DEFAULT 'Notional', `sector` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `mandatory` smallint(6) DEFAULT 0, `priority` smallint(6) DEFAULT 1, `status` enum('ACTIVE','CLOSED','SUSPENDED','CREATED','DELETED','PULLED') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `type` enum('CB','NewIssue','PricedNewIssue') DEFAULT 'CB', `min_dark` decimal(12,0) DEFAULT NULL, `min_block` decimal(12,0) DEFAULT NULL, `min_order` decimal(12,0) DEFAULT NULL, `min_bmp` decimal(12,0) DEFAULT NULL, `trading` enum('Normal','Stock Px ND','O/R only') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Normal', `country` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `region` enum('Europe','Middle East','Asia','US','Americas','Africa','Australia','Japan','Pacific') DEFAULT NULL, `execution_region` enum('US','EU','GB') GENERATED ALWAYS AS (if(`region` = 'US',1,if(`currency` in ('EUR','CZK','HUF','PLN','SEK','NOK','DKK'),2,3))) VIRTUAL, `stock_ref` decimal(9,3) DEFAULT NULL, `day_count` varchar(64) DEFAULT NULL, `calc_type` varchar(16) NOT NULL DEFAULT '', `start_date` date DEFAULT NULL, `prev_coupon_date` date DEFAULT NULL, `next_coupon_date` date DEFAULT NULL, `coupon_freq` int(11) DEFAULT NULL, `px_dirty_clean` enum('Dirty','Clean') CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `ex_coupon_date` date DEFAULT NULL, `next_next_coupon_date` date DEFAULT NULL, `issue_price` decimal(14,6) DEFAULT NULL, `issue_benchmark_spot` decimal(12,4) DEFAULT NULL, `issue_benchmark_spot_str` varchar(32) DEFAULT NULL, `issue_benchmark_yield` decimal(12,7) DEFAULT NULL, `issue_spread` decimal(12,7) DEFAULT NULL, `issue_date` date DEFAULT NULL, `pricing_date` date DEFAULT NULL, `announce_date` date DEFAULT NULL, `std_trading_date` date DEFAULT NULL, `std_commission_date` date DEFAULT NULL, `floor` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `accrued_param` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, `commission` double DEFAULT 0.0625, `redemption` decimal(15,6) DEFAULT NULL, `series` varchar(64) NOT NULL DEFAULT '', `call_date` date DEFAULT NULL, `call_redemption` decimal(12,6) DEFAULT NULL, `market` enum('CB','HY','ABS','IG','EM','TSY','ETF','Loan') DEFAULT NULL, `exchange` int(11) NOT NULL DEFAULT 0, `pay_in_kind` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'N', `bond_ticker` varchar(255) DEFAULT NULL, `short_ticker` varchar(32) DEFAULT NULL, `no_yield` int(1) DEFAULT 0, `is_tier1` int(1) DEFAULT 0, `last_activity` datetime DEFAULT NULL, `is_hy` int(1) DEFAULT 0, `is_defaulted` int(1) DEFAULT 0, `amnt_issued` double DEFAULT NULL, `amnt_out` double DEFAULT NULL, `rating_sp` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', `rating_m` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', `rating_bb` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', `rating_composite` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', `rating_xo` tinyint(1) NOT NULL DEFAULT 0, `des_note` varchar(255) DEFAULT NULL, `is_hy_hy` int(1) NOT NULL DEFAULT 0, `abs_category` int(11) DEFAULT NULL, `benchmark_bond` int(11) DEFAULT NULL, `benchmark_index` varchar(64) DEFAULT NULL, `floor_id` int(11) NOT NULL DEFAULT 1, `workout_date` date DEFAULT NULL, `bb_global` char(12) DEFAULT NULL, `bb_id` char(9) DEFAULT NULL, `idc_id` varchar(24) DEFAULT NULL, `cins` char(9) DEFAULT NULL, `SD_days` int(1) DEFAULT NULL, `SD_calendar` varchar(16) DEFAULT NULL, `update_stamp` datetime DEFAULT NULL, `manual_commission` int(1) NOT NULL DEFAULT 0, `markit_issuer_shortname` varchar(127) NOT NULL DEFAULT '', `clearing_agent` varchar(255) DEFAULT NULL, `trading_restriction` varchar(64) DEFAULT NULL, `trading_region` varchar(64) DEFAULT NULL, `is_trace_eligible` int(1) NOT NULL DEFAULT 0, `is_callable` int(1) NOT NULL DEFAULT 0, `is_sinkable` int(1) NOT NULL DEFAULT 0, `is_pik` int(1) NOT NULL DEFAULT 0, `id_bb_sec_num_des` varchar(128) DEFAULT NULL, `principal_factor` decimal(12,9) NOT NULL DEFAULT 1.000000000, `is_mifid_eligible` int(1) NOT NULL DEFAULT 0, `pre_trade_lis` decimal(18,3) DEFAULT NULL, `pre_trade_ssti` decimal(18,3) DEFAULT NULL, `post_trade_ssti` decimal(18,3) DEFAULT NULL, `post_trade_lis` decimal(18,3) DEFAULT NULL, `is_liquid` int(1) DEFAULT NULL, `issuer_lei` char(20) DEFAULT NULL, `mifid2_bond_type` enum('CORPORATE','CONVERTIBLE','PUBLIC','COVERED','SOVEREIGN','OTHER') DEFAULT NULL, `admission_date` date DEFAULT NULL, `cfi_code` varchar(255) DEFAULT NULL, `fisn` varchar(255) DEFAULT NULL, `issuer_short_name` varchar(255) DEFAULT NULL, `debt_rank` varchar(255) DEFAULT NULL, `benchmark_name` varchar(32) DEFAULT NULL, `benchmark_term` varchar(32) DEFAULT NULL, `benchmark_term_units` varchar(32) DEFAULT NULL, `benchmark_spread` varchar(32) DEFAULT NULL, `esma_is_liquid` varchar(32) DEFAULT NULL, `esma_bond_type` varchar(64) DEFAULT NULL, `esma_bond_type_desc` varchar(255) DEFAULT NULL, `trading_type` enum('PX','SPREAD','YIELD','MMYld') NOT NULL DEFAULT 'PX', `development_status` int(1) NOT NULL DEFAULT 1, `em_is_liquid` int(1) NOT NULL DEFAULT 0, `seasoning` int(1) NOT NULL DEFAULT 0, `esma_reportable` tinyint(1) NOT NULL DEFAULT 0, `fca_reportable` tinyint(1) NOT NULL DEFAULT 0, `nit_xo` tinyint(1) DEFAULT NULL, `mifid_seniority_of_bond` varchar(16) NOT NULL DEFAULT '', `is_hybrid` char(1) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `isin` (`isin`), KEY `cusip` (`cusip`), KEY `status` (`status`,`trading`), KEY `stock_id` (`stock_id`), KEY `status_market` (`status`,`market`), KEY `update_stamp` (`update_stamp`), KEY `idx_markit_issuer_shortname` (`markit_issuer_shortname`), KEY `bond_ticker` (`bond_ticker`,`status`), KEY `bb_global` (`bb_global`), KEY `short_ticker` (`short_ticker`,`status`), KEY `idx_bb_id` (`bb_id`) ) ENGINE=MyISAM AUTO_INCREMENT=155359 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci | +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [cbx]> show create table user \G; *************************** 1. row *************************** Table: user Create Table: CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_id` int(11) DEFAULT NULL, `login` varchar(255) DEFAULT '', `password` varchar(100) DEFAULT NULL, `name` varchar(64) DEFAULT NULL, `company` varchar(255) DEFAULT NULL, `status` enum('ACTIVE','DISABLED','CREATED','DELETED') DEFAULT 'ACTIVE', `CN` varchar(255) DEFAULT '', `ip` varchar(255) DEFAULT '', `session` enum('off','on','readonly') DEFAULT 'off', `onetimepass` enum('N','Y','E') DEFAULT NULL, `type` enum('Standard','Read Only','Admin','Supervisor') NOT NULL, `or_only` enum('N','Y') NOT NULL DEFAULT 'N', `stamp_duty` enum('A','M') NOT NULL DEFAULT 'A', `session_stamp` datetime DEFAULT NULL, `default_pass_exp_period` int(11) DEFAULT NULL, `password_expiry` date DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `build` varchar(64) DEFAULT NULL, `trace` tinyint(1) DEFAULT 0, `alias` varchar(128) NOT NULL DEFAULT '', `use_popup_px_prox` tinyint(1) NOT NULL DEFAULT 0, `bb_uuid` varchar(20) DEFAULT NULL, `show_off_the_desk` tinyint(1) NOT NULL DEFAULT 0, `allow_crossing` tinyint(1) NOT NULL DEFAULT 0, `spot_later_time` varchar(64) DEFAULT NULL, `crossing_disabled` tinyint(1) NOT NULL DEFAULT 0, `failed_login_counter` tinyint(1) NOT NULL DEFAULT 0, `committed_life_time` int(11) DEFAULT NULL, `has_service` tinyint(1) NOT NULL DEFAULT 0, `disable_remember_password` tinyint(1) NOT NULL DEFAULT 0, `gs_alias` varchar(32) NOT NULL DEFAULT '', `trader_code` varchar(64) NOT NULL DEFAULT '', `import_others` tinyint(1) NOT NULL DEFAULT 0, `import_from_holdings` tinyint(1) NOT NULL DEFAULT 0, `allow_refresh_blotter` tinyint(1) NOT NULL DEFAULT 0, `ti_enabled` tinyint(1) NOT NULL DEFAULT 1, `ti_rule` varchar(64) NOT NULL DEFAULT 'MANUAL', `ti_rule_param` varchar(64) NOT NULL DEFAULT '', `ti_period_days` int(11) NOT NULL DEFAULT 50, `ti_watchlists_default` tinyint(1) NOT NULL DEFAULT 0, `build2` int(11) NOT NULL DEFAULT 0, `build_time` datetime DEFAULT NULL, `auto_connection` tinyint(1) NOT NULL DEFAULT 0, `wakeup_connection` tinyint(1) NOT NULL DEFAULT 0, `team_view` tinyint(1) NOT NULL DEFAULT 0, `prev_indications_notify` tinyint(1) NOT NULL DEFAULT 0, `prev_indications_notify_time` varchar(32) NOT NULL DEFAULT '', `timezone` varchar(32) DEFAULT NULL, `coverage` varchar(255) DEFAULT NULL, `portfolio_manager` int(1) DEFAULT 0, `initials` varchar(32) NOT NULL DEFAULT '', `allow_put_through` tinyint(1) NOT NULL DEFAULT 0, `SD_types` varchar(32) NOT NULL DEFAULT 'T+1', `default_TSY_SD_type` varchar(32) NOT NULL DEFAULT 'T+1', `first_batch_time` int(11) NOT NULL DEFAULT 60, `next_batch_orders` int(11) NOT NULL DEFAULT 5, `next_batch_time` int(11) NOT NULL DEFAULT 20, `disable_dashboard_autopopup` tinyint(1) NOT NULL DEFAULT 0, `vht_dashboard_policy` int(11) NOT NULL DEFAULT 63, `vht_dashboard_times` varchar(255) DEFAULT '', `dot_net_version` varchar(32) DEFAULT NULL, `receive_TI_to_holdings` tinyint(1) NOT NULL DEFAULT 0, `auto_size_discovery` tinyint(1) NOT NULL DEFAULT 0, `show_my_matches` tinyint(1) NOT NULL DEFAULT 0, `block_oms_orders_from_history` tinyint(1) NOT NULL DEFAULT 0, `d2d_enabled` tinyint(1) NOT NULL DEFAULT 0, `export_from_vht_dashboard` tinyint(1) NOT NULL DEFAULT 0, `reveal_size` tinyint(1) NOT NULL DEFAULT 0, `suppress_prepopulate_idc_mid` tinyint(1) NOT NULL DEFAULT 0, `no_popup_from_pm` tinyint(1) NOT NULL DEFAULT 0, `team_trader` tinyint(1) NOT NULL DEFAULT 0, `show_import_price` tinyint(1) NOT NULL DEFAULT 0, `default_min_size_tolerance` decimal(5,3) DEFAULT NULL, `default_min_size_tolerance_ig` decimal(5,3) DEFAULT NULL, `tsox_manual` tinyint(1) NOT NULL DEFAULT 0, `see_liquidity_provider` tinyint(1) NOT NULL DEFAULT 0, `disable_group_ti` tinyint(1) NOT NULL DEFAULT 0, `virtual_user` tinyint(1) NOT NULL DEFAULT 0, `cpu_arch` varchar(16) DEFAULT NULL, `os_version` varchar(64) DEFAULT NULL, `os_release_id` varchar(64) DEFAULT NULL, `trade_ig_in_cash` tinyint(1) NOT NULL DEFAULT 0, `dealer_match_mode` tinyint(1) NOT NULL DEFAULT 0, `hide_size_from_sales` tinyint(1) DEFAULT 0, `abopt_no_responder_popup` tinyint(1) NOT NULL DEFAULT 0, `alerts_to_show` set('targeted_invitations','substitute_liquidity','displayed_liquidity','trade_postings','failed_matches') NOT NULL DEFAULT 'targeted_invitations,substitute_liquidity,displayed_liquidity,trade_postings', `abopt_enable_bval` tinyint(1) NOT NULL DEFAULT 0, `no_algo` tinyint(1) NOT NULL DEFAULT 0, `abopt_show_liquidity_target_selection` tinyint(1) NOT NULL DEFAULT 0, `straight_to_abopt` tinyint(1) NOT NULL DEFAULT 0, `abopt_default_target` tinyint(1) NOT NULL DEFAULT 0, `abopt_permissions` mediumtext DEFAULT NULL, `include_onboarded_dealers` tinyint(1) NOT NULL DEFAULT 0, `auto_abi` tinyint(1) NOT NULL DEFAULT 0, `manual_algo_responder` tinyint(1) NOT NULL DEFAULT 0, `algo_provider_currencies` varchar(255) DEFAULT NULL, `algo_markets_disabled` tinyint(1) NOT NULL DEFAULT 0, `is_nit_gross` tinyint(1) NOT NULL DEFAULT 0, `nit_zero_comm` tinyint(1) NOT NULL DEFAULT 0, `show_clouds` tinyint(1) NOT NULL DEFAULT 1, `disable_direct_to_lit` tinyint(1) NOT NULL DEFAULT 0, `new_issues_enabled` tinyint(1) NOT NULL DEFAULT 0, `is_web` tinyint(1) DEFAULT 0, `is_fusion` tinyint(1) NOT NULL DEFAULT 0, `no_tis_to_rms` tinyint(1) NOT NULL DEFAULT 0, `pt_to_tpicap` tinyint(1) NOT NULL DEFAULT 0, `gcd_posting_id` varchar(64) DEFAULT NULL, `gcd_broker_id` varchar(64) DEFAULT NULL, `gcd_legal_entity` varchar(64) DEFAULT NULL, `trading_coverage` varchar(255) NOT NULL DEFAULT '', `rfq` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `name` (`name`), KEY `cn` (`CN`), KEY `session` (`session`), KEY `group_id` (`group_id`) ) ENGINE=Aria AUTO_INCREMENT=8834 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY KEY (`id`) PARTITIONS 10 1 row in set (0.000 sec) ERROR: No query specified MariaDB [cbx]> show create table groups \G; *************************** 1. row *************************** Table: groups Create Table: CREATE TABLE `groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `company` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `coverage` varchar(255) DEFAULT NULL, `send_trade_confirmation` smallint(6) DEFAULT 0, `email` varchar(255) DEFAULT NULL, `country` varchar(255) DEFAULT NULL, `special_conditions` varchar(255) DEFAULT NULL, `is_cb` int(1) NOT NULL DEFAULT 0, `is_hy` int(1) NOT NULL DEFAULT 0, `is_hy_us` int(1) NOT NULL DEFAULT 0, `is_abs` int(1) NOT NULL DEFAULT 0, `is_ig` int(1) NOT NULL DEFAULT 0, `is_ig_us` int(1) NOT NULL DEFAULT 0, `is_em` int(1) NOT NULL DEFAULT 0, `is_etf` int(1) NOT NULL DEFAULT 0, `is_etf_us` int(1) NOT NULL DEFAULT 0, `is_net` int(1) NOT NULL DEFAULT 0, `signed` int(1) NOT NULL DEFAULT 0, `region` char(2) DEFAULT 'EU', `execution_region` enum('US','EU','GB','CA') GENERATED ALWAYS AS (if(`region` = 'US',if(`country` = 'CA','CA','US'),if(`country` in ('BE','BG','CZ','DK','DE','EE','IE','EL','ES','FR','HR','IT','CY','LV','LT','LU','HU','MT','NL','AT','PL','PT','RO','SI','SK','FI','SE'),'EU','GB'))) VIRTUAL, `is_ss` int(1) NOT NULL DEFAULT 0 COMMENT 'is sell side', `is_dealer` int(1) NOT NULL DEFAULT 0, `is_ta_initiator` int(1) NOT NULL DEFAULT 0, `is_ta_acceptor` int(1) NOT NULL DEFAULT 0, `equal_only_dealer` tinyint(1) NOT NULL DEFAULT 0, `dealer_gold_status` tinyint(1) NOT NULL DEFAULT 0, `is_ln` int(1) NOT NULL DEFAULT 0, `QIB` int(1) NOT NULL DEFAULT 1, `special_type` enum('','WMC') DEFAULT '', `short_code` varchar(32) DEFAULT '', `dealer_algo_name` varchar(64) NOT NULL DEFAULT '', `finra_mpid` varchar(4) DEFAULT NULL, `note` text DEFAULT NULL, `name_giveup` int(1) NOT NULL DEFAULT 0, `hide_disclosed_name` int(1) NOT NULL DEFAULT 0, `company_id` int(11) NOT NULL DEFAULT 0, `OMS` enum('None','SingleChild','MultiChild','PseudoBlotter','AdvancedBlotter','DoubleBlotter') DEFAULT 'None', `OMS_binding_policy` enum('None','Enforced','Free') DEFAULT 'None', `oms_blotter_only` int(1) NOT NULL DEFAULT 0, `no_144a` int(1) NOT NULL DEFAULT 0, `xl_user` int(1) NOT NULL DEFAULT 0, `blotter_matching` int(1) NOT NULL DEFAULT 0, `default_min_size_tolerance` decimal(5,3) NOT NULL DEFAULT 0.500, `default_min_size_tolerance_ig` decimal(5,3) NOT NULL DEFAULT 0.500, `max_min_size_tolerance` decimal(5,2) NOT NULL DEFAULT 1.00, `uncommitted_orders` int(1) NOT NULL DEFAULT 0, `show_trace_pxmove` int(1) NOT NULL DEFAULT 0, `show_best_price_analysis` int(1) NOT NULL DEFAULT 0, `trace_policy` enum('Default','Enabled','Disabled','Delayed') DEFAULT NULL, `show_industry_filter` int(1) NOT NULL DEFAULT 0, `oms_outofpool` int(1) NOT NULL DEFAULT 0, `oms_allow_manual_BMP` int(1) NOT NULL DEFAULT 1, `oms_allow_uncommitted_manual_BMP` int(1) NOT NULL DEFAULT 0, `show_dealer_liquidity` int(1) NOT NULL DEFAULT 0, `allow_dealer_negotiation` int(1) NOT NULL DEFAULT 0, `oms_firm` varchar(64) NOT NULL DEFAULT '', `placement_request_enabled` int(1) NOT NULL DEFAULT 0, `new_after_cancel` int(1) NOT NULL DEFAULT 0, `new_after_completed` int(1) NOT NULL DEFAULT 0, `check_oms_before_neg` int(1) NOT NULL DEFAULT 0, `split_upon_trade` int(1) NOT NULL DEFAULT 0, `placement_after_execution` int(1) NOT NULL DEFAULT 0, `no_auto_update` int(1) NOT NULL DEFAULT 0, `limits_currency` char(3) NOT NULL DEFAULT 'USD', `rolling_limits` int(1) NOT NULL DEFAULT 0, `oms_type` enum('None','OMSI','Committed FIX','Uncommitted FIX','TSOX Full Sweep','Uncommitted/Manual FIX','ALFA','Conditional FIX','Rebalance DarkPool FIX') NOT NULL DEFAULT 'None', `min_leave_size` int(11) DEFAULT NULL, `gs_account` varchar(32) NOT NULL DEFAULT '', `drop_copy_mode` int(11) NOT NULL DEFAULT 0, `restrict_ip` int(1) NOT NULL DEFAULT 0, `send_recaps_report` int(1) NOT NULL DEFAULT 0, `recaps_dest_type` int(1) NOT NULL DEFAULT 1, `recaps_report_email` varchar(1024) NOT NULL DEFAULT '', `recaps_schedule_type` enum('None','Periodic','Fixed time','On trade') NOT NULL DEFAULT 'None', `recaps_schedule_data` varchar(255) DEFAULT NULL, `recaps_delay` int(11) NOT NULL DEFAULT 15, `recaps_script` varchar(255) DEFAULT NULL, `recaps_send_empty` tinyint(1) NOT NULL DEFAULT 0, `recaps_monthly` tinyint(1) NOT NULL DEFAULT 0, `recaps_quarterly` tinyint(1) NOT NULL DEFAULT 0, `show_my_matches` int(1) NOT NULL DEFAULT 0, `allow_targeted_invitations` int(1) NOT NULL DEFAULT 1, `allow_intelligent_execution` int(1) NOT NULL DEFAULT 0, `show_alt_price` int(1) NOT NULL DEFAULT 0, `remember_out_of_pool_state` int(1) NOT NULL DEFAULT 0, `allow_non_standard_settlement_date` int(1) NOT NULL DEFAULT 0, `oms_resend_trades` int(1) NOT NULL DEFAULT 0, `member_id` varchar(255) NOT NULL DEFAULT '', `member_number` varchar(32) NOT NULL DEFAULT '', `confirm_PM_match` int(1) NOT NULL DEFAULT 0, `custom_PM_workflow` int(1) NOT NULL DEFAULT 0, `no_firm_orders` int(1) NOT NULL DEFAULT 0, `pm_orders_uncommitted` int(1) NOT NULL DEFAULT 0, `am_bd_option` int(1) NOT NULL DEFAULT 0, `all_or_nothing` int(1) NOT NULL DEFAULT 0, `no_idc_price_overwrite` int(1) NOT NULL DEFAULT 0, `bmp_order_cap` decimal(5,2) DEFAULT NULL, `deliver_to_comp_id` varchar(256) DEFAULT NULL, `is_rbc` int(1) NOT NULL DEFAULT 0, `trade_ig_in_cash` tinyint(1) NOT NULL DEFAULT 0, `pt_trade_ig_in_cash` int(1) NOT NULL DEFAULT 0, `trade_denomination` int(11) DEFAULT NULL, `ignore_limit_price` int(1) NOT NULL DEFAULT 0, `trade_note_required` int(1) NOT NULL DEFAULT 0, `lei` char(20) DEFAULT NULL, `additional_lei` varchar(1024) DEFAULT NULL, `BIC` varchar(11) DEFAULT NULL, `show_ubs_prices` int(1) NOT NULL DEFAULT 0, `send_best_ex_on_exec` int(1) NOT NULL DEFAULT 0, `send_always_market_venue` int(1) NOT NULL DEFAULT 0, `block_specific_bonds` int(1) NOT NULL DEFAULT 0, `use_liquidity_score` int(1) NOT NULL DEFAULT 0, `min_liquidity_score` int(2) NOT NULL DEFAULT 5, `allow_two_side_trading` int(1) NOT NULL DEFAULT 0, `allow_non_standard_benchmark` int(1) NOT NULL DEFAULT 0, `uncommitted_sweep` int(1) NOT NULL DEFAULT 0, `group_tis` int(1) NOT NULL DEFAULT 0, `no_oms_new_SD` int(1) NOT NULL DEFAULT 0, `bmp_matches_to_all` int(1) NOT NULL DEFAULT 0, `is_regs` int(1) NOT NULL DEFAULT 0, `n_orders_to_suppress_match_popups` int(11) NOT NULL DEFAULT 0, `trading_titles_notionally` int(1) NOT NULL DEFAULT 0, `pt_features` set('show_net_spread','show_benchmark','select_accept','simple_confirmation','hide_not_eligible','confirm_before_execution','change_bo') DEFAULT NULL, `pt_no_min_size_limit` tinyint(1) NOT NULL DEFAULT 0, `show_import_price` int(1) NOT NULL DEFAULT 0, `indication_price_required` tinyint(1) NOT NULL DEFAULT 0, `algo_provider` int(1) NOT NULL DEFAULT 0, `oms_visible_size_limit` decimal(5,2) NOT NULL DEFAULT 0.00, `etf_create_order` int(1) NOT NULL DEFAULT 0, `liquidity_provider` tinyint(1) NOT NULL DEFAULT 0, `send_benchmark_for_hy` tinyint(4) NOT NULL DEFAULT 0, `see_liquidity_provider` tinyint(1) NOT NULL DEFAULT 0, `allow_eu_on_uk_mtf` tinyint(1) NOT NULL DEFAULT 0, `dcm_status` enum('NONE','CLIENT','BANK') NOT NULL DEFAULT 'NONE', `syndicated_loans_enabled` int(1) NOT NULL DEFAULT 0, `fix_common_size_response` tinyint(1) NOT NULL DEFAULT 0, `abopt_uncommitted_manual` tinyint(1) NOT NULL DEFAULT 0, `no_algo` tinyint(1) NOT NULL DEFAULT 1, `algo_msg_speed_limit` int(11) NOT NULL DEFAULT 0, `algo_provider_currencies` varchar(256) DEFAULT NULL, `algo_msg_batch_size` int(11) NOT NULL DEFAULT 0, `manual_algo_responder` tinyint(1) NOT NULL DEFAULT 0, `nit_zero_comm` tinyint(1) NOT NULL DEFAULT 0, `disable_direct_to_lit` tinyint(1) NOT NULL DEFAULT 0, `new_issues_enabled` tinyint(1) NOT NULL DEFAULT 1, `no_tis_to_rms` tinyint(1) NOT NULL DEFAULT 0, `conditional_queue` int(1) NOT NULL DEFAULT 0, `pt_to_tpicap` tinyint(1) NOT NULL DEFAULT 0, `oms_restrict_non_priced_new_issues` tinyint(1) NOT NULL DEFAULT 0, `dont_show_lit` tinyint(1) NOT NULL DEFAULT 0, `oms_dfd_ack` int(1) NOT NULL DEFAULT 0, `CN` varchar(255) DEFAULT NULL, `dont_send_webview` tinyint(1) NOT NULL DEFAULT 0, `is_tpicap` tinyint(1) NOT NULL DEFAULT 0, `trading_coverage` varchar(255) NOT NULL DEFAULT '', `rfq_anonymous_responder` tinyint(1) NOT NULL DEFAULT 0, `rfq_anonymous_initiator` tinyint(1) NOT NULL DEFAULT 0, `rfq` tinyint(1) NOT NULL DEFAULT 1, `rfq_responder_comm_markup` tinyint(1) NOT NULL DEFAULT 0, `rfq_responder_monthly_comm` tinyint(1) NOT NULL DEFAULT 0, `is_bilateral_enablement` tinyint(1) NOT NULL DEFAULT 0, `is_tpfs` tinyint(1) NOT NULL DEFAULT 0, `ciq_daily_reset` tinyint(4) NOT NULL DEFAULT 1, `recaps_weekly` tinyint(4) NOT NULL DEFAULT 0, `recaps_alt_groups` varchar(255) DEFAULT NULL, `responder_types` set('buyside','dealer','dealer_api') DEFAULT NULL, PRIMARY KEY (`id`), KEY `algo_provider` (`algo_provider`) ) ENGINE=MyISAM AUTO_INCREMENT=2172 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci 1 row in set (0.000 sec) ERROR: No query specified MariaDB [cbx]> show create table dark_orders \G; *************************** 1. row *************************** Table: dark_orders Create Table: CREATE TABLE `dark_orders` ( `id` int(11) NOT NULL, `min_counter` decimal(12,0) DEFAULT NULL, `price_var` decimal(12,3) DEFAULT NULL, `visible_size` decimal(12,0) DEFAULT NULL, `committed_size` decimal(12,0) DEFAULT NULL, `penalty` varchar(32) DEFAULT NULL, `bmp_lock` int(11) NOT NULL DEFAULT 0, `manual_max_size` decimal(12,0) DEFAULT NULL, `activation_stamp` datetime DEFAULT NULL, `oms_size_adjustment` decimal(12,0) NOT NULL DEFAULT 0, `oms_adjustment_avg_px` decimal(14,6) NOT NULL DEFAULT 0.000000, `oms_adjustment_accrued` decimal(12,2) NOT NULL DEFAULT 0.00, `invitation_id` int(11) NOT NULL DEFAULT 0, `been_in_pool` int(1) NOT NULL DEFAULT 1, `seeker_id` int(11) DEFAULT NULL, `alt_price` decimal(9,4) DEFAULT NULL, `benchmark_price` decimal(12,8) DEFAULT NULL, `counter_parent_id` int(11) DEFAULT NULL, `negotiation_id` int(11) DEFAULT NULL, `tooltip` varchar(256) DEFAULT NULL, `substitute_liquidity_eligible` int(1) NOT NULL DEFAULT 0, `match_mode` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci 1 row in set (0.000 sec) ERROR: No query specified MariaDB [cbx]> show create table counter_orders \G; *************************** 1. row *************************** Table: counter_orders Create Table: CREATE TABLE `counter_orders` ( `id` int(11) NOT NULL, `counter_id` int(11) DEFAULT NULL, `abopt_id` int(11) DEFAULT NULL, `invitation_id` int(11) DEFAULT NULL, `ref_id` int(11) DEFAULT NULL, `rfq_id` int(11) DEFAULT NULL, `status` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE', PRIMARY KEY (`id`), KEY `counter_id` (`counter_id`), KEY `ref_id` (`ref_id`), KEY `invitation_id` (`invitation_id`), KEY `abopt_id` (`abopt_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci 1 row in set (0.000 sec) ERROR: No query specified MariaDB [cbx]> show create table traders \G ; ERROR 1146 (42S02): Table 'cbx.traders' doesn't exist ERROR: No query specified MariaDB [cbx]> show create table trader \G ; ERROR 1146 (42S02): Table 'cbx.trader' doesn't exist ERROR: No query specified MariaDB [cbx]> show create table arc_orders \G ; *************************** 1. row *************************** Table: arc_orders Create Table: CREATE TABLE `arc_orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `date` date NOT NULL, `created_stamp` datetime(6) DEFAULT NULL, `expiry_stamp` datetime DEFAULT NULL, `status` enum('ACTIVE','EXPIRED','EXECUTED','CLOSED','DECLINED','SUSPENDED','ENGAGED') DEFAULT NULL, `bond_id` int(11) NOT NULL, `bs` enum('B','S') DEFAULT NULL, `type` enum('Outright','Swap','Both') DEFAULT NULL, `swap_size` decimal(12,0) DEFAULT NULL, `swap_filled` decimal(12,0) DEFAULT 0, `swap_price` decimal(12,4) DEFAULT NULL, `delta` decimal(6,3) DEFAULT NULL, `outright_size` decimal(12,0) DEFAULT NULL, `outright_filled` decimal(12,0) DEFAULT 0, `outright_price` decimal(12,4) DEFAULT NULL, `outright_floating` enum('Y','N') DEFAULT NULL, `price_adj` decimal(9,4) DEFAULT NULL, `price_type` enum('PX','SPREAD','YIELD','MMYld') DEFAULT 'PX', `ref_stock_price` decimal(9,3) DEFAULT NULL, `spot_stock_price` decimal(9,3) DEFAULT NULL, `spot_fx` decimal(9,5) DEFAULT NULL, `stock_above` decimal(10,4) DEFAULT NULL, `stock_below` decimal(10,4) DEFAULT NULL, `bd_type` enum('Standard','Block','Dark','Counter','BMP','BMP_Counter','Quote','QuoteResponse') DEFAULT NULL, `fill_or_kill` enum('N','Y') DEFAULT 'N', `all_or_nothing` enum('N','Y') DEFAULT 'N', `slippage` decimal(9,4) DEFAULT NULL, `exec_stamp` time DEFAULT NULL, `exec_stamp2` datetime(6) DEFAULT NULL, `reason` varchar(255) DEFAULT NULL, `min_delta` decimal(6,3) DEFAULT NULL, `max_delta` decimal(6,3) DEFAULT NULL, `account_id` varchar(64) DEFAULT NULL, `split_after` enum('N','Y') NOT NULL DEFAULT 'N', `cancel_suspend` enum('C','S') NOT NULL DEFAULT 'C', `stock_bond` enum('S','B') NOT NULL DEFAULT 'S', `euro_size` double DEFAULT NULL, `gbp_size` double DEFAULT NULL, `usd_size` double DEFAULT NULL, `ytm` decimal(10,6) DEFAULT NULL, `ytc` decimal(10,6) DEFAULT NULL, `x_order_id` varchar(64) DEFAULT NULL, `target` enum('All','BS','SS','Contra') DEFAULT NULL, `commission` decimal(10,4) DEFAULT NULL, `next_order_id` int(11) DEFAULT NULL, `comments` varchar(127) DEFAULT NULL, `am_bd` tinyint(1) NOT NULL DEFAULT 0, `ie_workflow_stage` enum('DARK','LIT','DARK_BLOCKS','DISPLAYED','RFQ','DARK_DISPLAYED','DARK_RFQ','DARK_ABOPT','ABOPT','DARK_ALGO','ALGO') DEFAULT NULL, `lis` decimal(18,3) DEFAULT NULL, `ssti` decimal(18,3) DEFAULT NULL, `is_liquid` tinyint(1) DEFAULT NULL, `sd_type` varchar(4) NOT NULL DEFAULT 'T+2', `sd` date DEFAULT NULL, `benchmark` varchar(12) DEFAULT NULL, `is_algo_eligible` tinyint(1) NOT NULL DEFAULT 0, `is_nit_firm` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), KEY `bond_id` (`bond_id`,`status`), KEY `next_order_id` (`next_order_id`), KEY `x_order_id` (`x_order_id`), KEY `created_stamp__user_id_idx` (`created_stamp`,`user_id`), KEY `user_id__created_stamp_idx` (`user_id`,`created_stamp`) ) ENGINE=Aria AUTO_INCREMENT=20912067 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 1 row in set (0.000 sec) ERROR: No query specified MariaDB [cbx]> show create table arc_traders \G; ERROR 1146 (42S02): Table 'cbx.arc_traders' doesn't exist ERROR: No query specified MariaDB [cbx]> tee off