| リビジョン | db2a15fbdd7ce34a3a9dbf8fc3c6de469371107e (tree) |
|---|---|
| 日時 | 2019-07-19 23:20:35 |
| 作者 | paladz <453256728@qq.c...> |
| コミッター | paladz |
delete the key index
docs/federation/sql_dump/federation_shema.sql (diff)| @@ -54,13 +54,9 @@ CREATE TABLE `cross_transactions` ( | ||
| 54 | 54 | `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 55 | 55 | `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 56 | 56 | PRIMARY KEY (`id`), |
| 57 | - UNIQUE KEY `source_mux_id` (`chain_id`,`source_mux_id`), | |
| 58 | - UNIQUE KEY `source_tx_hash` (`chain_id`,`source_tx_hash`), | |
| 59 | - UNIQUE KEY `source_blockhash_txidx` (`chain_id`,`source_block_hash`,`source_tx_index`), | |
| 60 | - UNIQUE KEY `source_blockheight_txidx` (`chain_id`,`source_block_height`,`source_tx_index`), | |
| 61 | - UNIQUE KEY `dest_tx_hash` (`chain_id`,`dest_tx_hash`), | |
| 62 | - UNIQUE KEY `dest_blockhash_txidx` (`chain_id`,`dest_block_hash`,`dest_tx_index`), | |
| 63 | - UNIQUE KEY `dest_blockheight_txidx` (`chain_id`,`dest_block_height`,`dest_tx_index`), | |
| 57 | + UNIQUE KEY `chain_id` (`chain_id`), | |
| 58 | + UNIQUE KEY `source_tx_hash` (`source_tx_hash`), | |
| 59 | + UNIQUE KEY `dest_tx_hash` (`dest_tx_hash`), | |
| 64 | 60 | CONSTRAINT `cross_transactions_ibfk_1` FOREIGN KEY (`chain_id`) REFERENCES `chains` (`id`) |
| 65 | 61 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 66 | 62 |
| @@ -83,7 +79,6 @@ CREATE TABLE `cross_transaction_reqs` ( | ||
| 83 | 79 | `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 84 | 80 | `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 85 | 81 | PRIMARY KEY (`id`), |
| 86 | - UNIQUE KEY `req_id` (`cross_transaction_id`,`source_pos`), | |
| 87 | 82 | CONSTRAINT `cross_transaction_reqs_ibfk_1` FOREIGN KEY (`cross_transaction_id`) REFERENCES `cross_transactions` (`id`), |
| 88 | 83 | CONSTRAINT `cross_transaction_reqs_ibfk_2` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) |
| 89 | 84 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
Fork