From: Paladz <yzhu101@uottawa.ca>
Date: Fri, 19 Jul 2019 14:32:50 +0000 (+0800)
Subject: delete the key index (#335)
X-Git-Tag: v1.0.5~93
X-Git-Url: http://git.osdn.net/view?p=bytom%2Fvapor.git;a=commitdiff_plain;h=ebb6ab44b37d29e524f27f503187a901422e1afa

delete the key index (#335)
---

diff --git a/docs/federation/sql_dump/federation_shema.sql b/docs/federation/sql_dump/federation_shema.sql
index 542e8c1d..adfaa62a 100644
--- a/docs/federation/sql_dump/federation_shema.sql
+++ b/docs/federation/sql_dump/federation_shema.sql
@@ -54,13 +54,9 @@ CREATE TABLE `cross_transactions` (
   `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`),
-  UNIQUE KEY `source_mux_id` (`chain_id`,`source_mux_id`),
-  UNIQUE KEY `source_tx_hash` (`chain_id`,`source_tx_hash`),
-  UNIQUE KEY `source_blockhash_txidx` (`chain_id`,`source_block_hash`,`source_tx_index`),
-  UNIQUE KEY `source_blockheight_txidx` (`chain_id`,`source_block_height`,`source_tx_index`),
-  UNIQUE KEY `dest_tx_hash` (`chain_id`,`dest_tx_hash`),
-  UNIQUE KEY `dest_blockhash_txidx` (`chain_id`,`dest_block_hash`,`dest_tx_index`),
-  UNIQUE KEY `dest_blockheight_txidx` (`chain_id`,`dest_block_height`,`dest_tx_index`),
+  UNIQUE KEY `chain_id` (`chain_id`),
+  UNIQUE KEY `source_tx_hash` (`source_tx_hash`),
+  UNIQUE KEY `dest_tx_hash` (`dest_tx_hash`),
   CONSTRAINT `cross_transactions_ibfk_1` FOREIGN KEY (`chain_id`) REFERENCES `chains` (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
@@ -83,7 +79,6 @@ CREATE TABLE `cross_transaction_reqs` (
   `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`id`),
-  UNIQUE KEY `req_id` (`cross_transaction_id`,`source_pos`),
   CONSTRAINT `cross_transaction_reqs_ibfk_1` FOREIGN KEY (`cross_transaction_id`) REFERENCES `cross_transactions` (`id`),
   CONSTRAINT `cross_transaction_reqs_ibfk_2` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;