-- Create syntax for TABLE 'api_user_calls'
CREATE TABLE `api_user_calls` (
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `endpoint_id` int(11) unsigned NOT NULL DEFAULT '0',
  `dtu_call` decimal(16,6) unsigned NOT NULL DEFAULT '0.000000',
  `endpoint` varchar(32) NOT NULL DEFAULT '',
  `time_exec` decimal(8,6) unsigned NOT NULL DEFAULT '0.000000',
  `vip` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`endpoint_id`,`dtu_call`)
) ENGINE=TokuDB DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'cluster_hosts'
CREATE TABLE `cluster_hosts` (
  `hostname_id` int(11) unsigned NOT NULL DEFAULT '0',
  `twone_node_id` int(11) unsigned NOT NULL DEFAULT '0',
  `hostname` varchar(128) NOT NULL DEFAULT '',
  `ipv4_grid` int(11) unsigned NOT NULL DEFAULT '0',
  `host_type` varchar(16) NOT NULL DEFAULT '',
  `twone_sync` tinyint(1) unsigned NOT NULL DEFAULT '0'
) ENGINE=TokuDB DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'counters'
CREATE TABLE `counters` (
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `counter_id` int(11) unsigned NOT NULL DEFAULT '0',
  `register_cksum` char(32) CHARACTER SET ascii NOT NULL DEFAULT '',
  `counter_name` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '',
  `dedupe` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `match` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sync_register` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=TokuDB DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'filters'
CREATE TABLE `filters` (
  `filter_id` int(11) unsigned NOT NULL DEFAULT '0',
  `filter_name` varchar(32) NOT NULL DEFAULT '',
  `gdpr` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ipv4` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`filter_id`)
) ENGINE=TokuDB DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'pipes'
CREATE TABLE `pipes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=TokuDB DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'users'
CREATE TABLE `users` (
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `email_id` int(11) unsigned NOT NULL DEFAULT '0',
  `user_cksum` char(32) CHARACTER SET ascii NOT NULL DEFAULT '',
  `dtu_update` int(11) unsigned NOT NULL DEFAULT '0',
  `user_name` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '',
  `email` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '',
  `node_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `vip` tinyint(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`email_id`)
) ENGINE=TokuDB DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'users_auth'
CREATE TABLE `users_auth` (
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `token_api` char(32) CHARACTER SET ascii NOT NULL DEFAULT '',
  `token_public` char(32) CHARACTER SET ascii NOT NULL DEFAULT '',
  `salt` char(8) CHARACTER SET ascii NOT NULL DEFAULT '',
  `facebook` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `token` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=TokuDB DEFAULT CHARSET=utf8;

-- Create syntax for TABLE 'users_payment'
CREATE TABLE `users_payment` (
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `dtu_payment` int(11) unsigned NOT NULL DEFAULT '0',
  `amount` double unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=TokuDB DEFAULT CHARSET=utf8;