CREATE DATABASE tps
  DEFAULT CHARACTER SET utf8
  DEFAULT COLLATE utf8_general_ci;
use tps;

CREATE TABLE `fixtradedata` (
  `id` int(11) NOT NULL,
  `account` varchar(100) DEFAULT NULL,
  `avg_px` varchar(100) DEFAULT NULL,
  `begin_string` varchar(100) DEFAULT NULL,
  `body_length` varchar(100) DEFAULT NULL,
  `clearing_firm` varchar(100) DEFAULT NULL,
  `client_id` varchar(100) DEFAULT NULL,
  `connection_id` varchar(100) DEFAULT NULL,
  `contra_broker` varchar(100) DEFAULT NULL,
  `copy_book` varchar(100) DEFAULT NULL,
  `cum_qty` varchar(100) DEFAULT NULL,
  `currency` varchar(100) DEFAULT NULL,
  `exec_id` varchar(100) DEFAULT NULL,
  `exec_ref_id` varchar(100) DEFAULT NULL,
  `exec_trans_type` varchar(100) DEFAULT NULL,
  `exec_type` varchar(100) DEFAULT NULL,
  `fut_sett_date` varchar(100) DEFAULT NULL,
  `id_source` varchar(100) DEFAULT NULL,
  `last_capacity` varchar(100) DEFAULT NULL,
  `last_px` varchar(100) DEFAULT NULL,
  `last_shares` varchar(100) DEFAULT NULL,
  `leaves_qty` varchar(100) DEFAULT NULL,
  `msg_seq_num` int(11) DEFAULT NULL,
  `msg_type` varchar(100) DEFAULT NULL,
  `no_contra_brokers` varchar(100) DEFAULT NULL,
  `ord_status` varchar(100) DEFAULT NULL,
  `order_id` varchar(100) DEFAULT NULL,
  `order_qty` varchar(100) DEFAULT NULL,
  `poss_dup_flag` varchar(100) DEFAULT NULL,
  `poss_resend` varchar(100) DEFAULT NULL,
  `security_exchange` varchar(100) DEFAULT NULL,
  `security_id` varchar(100) DEFAULT NULL,
  `sender_comp_id` varchar(100) DEFAULT NULL,
  `sender_sub_id` varchar(100) DEFAULT NULL,
  `sending_time` varchar(100) DEFAULT NULL,
  `settlmnt_typ` varchar(100) DEFAULT NULL,
  `side` varchar(100) DEFAULT NULL,
  `symbol` varchar(100) DEFAULT NULL,
  `target_comp_id` varchar(100) DEFAULT NULL,
  `target_sub_id` varchar(100) DEFAULT NULL,
  `text` varchar(100) DEFAULT NULL,
  `transact_time` varchar(100) DEFAULT NULL,
  `version` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

CREATE TABLE `instructions` (
  `id` int(11) NOT NULL,
  `total` decimal(30,7) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

CREATE TABLE `positions` (
  `id` int(11) NOT NULL,
  `total` decimal(30,7) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;