CREATE TABLE `devcoin_blocks` (
  `id` int(11) NOT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(16) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `confirmations` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `devcoin_payouts` (
  `id` int(11) NOT NULL,
  `address` varchar(48) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `paid` varchar(48) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `devcoin_reg` (
  `BTC_address` varchar(48) NOT NULL,
  `NMC_address` varchar(48) DEFAULT NULL,
  PRIMARY KEY (`BTC_address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `i0coin_blocks` (
  `id` int(11) NOT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(16) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `confirmations` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `i0coin_payouts` (
  `id` int(11) NOT NULL,
  `address` varchar(48) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `paid` varchar(48) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `i0coin_reg` (
  `BTC_address` varchar(48) NOT NULL,
  `NMC_address` varchar(48) DEFAULT NULL,
  PRIMARY KEY (`BTC_address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `ixcoin_blocks` (
  `id` int(11) NOT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(16) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `confirmations` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `ixcoin_payouts` (
  `id` int(11) NOT NULL,
  `address` varchar(48) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `paid` varchar(48) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `ixcoin_reg` (
  `BTC_address` varchar(48) NOT NULL,
  `NMC_address` varchar(48) DEFAULT NULL,
  PRIMARY KEY (`BTC_address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `lminer_hist` (
  `id` int(11) NOT NULL,
  `address` varchar(48) DEFAULT NULL,
  `hashrate` bigint(20) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `lpayouts` (
  `id` int(11) DEFAULT NULL,
  `address` varchar(48) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `paddress` varchar(48) DEFAULT NULL,
  `paid` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `lpool_blocks` (
  `id` int(11) NOT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(16) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `confirmations` int(11) DEFAULT NULL,
  `blk_num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `lpool_data` (
  `id` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `hashrate` bigint(20) DEFAULT NULL,
  `shares` int(11) DEFAULT NULL,
  `stale_doa` int(11) DEFAULT NULL,
  `stale_orphan` int(11) DEFAULT NULL,
  `p2pool_hashrate` bigint(20) DEFAULT NULL,
  `p2pool_stale_rate` int(11) DEFAULT NULL,
  `block_value` decimal(16,8) DEFAULT NULL,
  `peers_out` int(11) DEFAULT NULL,
  `peers_in` int(11) DEFAULT NULL,
  `current_payout` decimal(16,8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `miner_data` (
  `id` int(11) NOT NULL,
  `address` varchar(48) DEFAULT NULL,
  `hashrate` bigint(20) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `miner_hist` (
  `id` int(11) NOT NULL,
  `address` varchar(48) DEFAULT NULL,
  `hashrate` bigint(20) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `namecoin_blocks` (
  `id` int(11) NOT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(16) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `confirmations` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `namecoin_payouts` (
  `id` int(11) NOT NULL,
  `address` varchar(48) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `paid` varchar(48) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `namecoin_reg` (
  `BTC_address` varchar(48) NOT NULL,
  `NMC_address` varchar(48) DEFAULT NULL,
  PRIMARY KEY (`BTC_address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `pay_address` (
  `address` varchar(48) NOT NULL,
  `paddress` varchar(48) DEFAULT NULL,
  PRIMARY KEY (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `payouts` (
  `id` int(11) DEFAULT NULL,
  `address` varchar(48) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `paddress` varchar(48) DEFAULT NULL,
  `paid` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `pool_blocks` (
  `id` int(11) NOT NULL,
  `txid` varchar(64) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type` varchar(16) DEFAULT NULL,
  `amount` decimal(16,8) DEFAULT NULL,
  `confirmations` int(11) DEFAULT NULL,
  `blk_num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `pool_data` (
  `id` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `hashrate` bigint(20) DEFAULT NULL,
  `shares` int(11) DEFAULT NULL,
  `stale_doa` int(11) DEFAULT NULL,
  `stale_orphan` int(11) DEFAULT NULL,
  `p2pool_hashrate` bigint(20) DEFAULT NULL,
  `p2pool_stale_rate` int(11) DEFAULT NULL,
  `block_value` decimal(16,8) DEFAULT NULL,
  `peers_out` int(11) DEFAULT NULL,
  `peers_in` int(11) DEFAULT NULL,
  `current_payout` decimal(16,8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `signtime` (
  `address` varchar(48) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;