diff options
author | Trumeet <yuuta@yuuta.moe> | 2021-04-02 13:25:51 -0700 |
---|---|---|
committer | Trumeet <yuuta@yuuta.moe> | 2021-04-02 13:25:51 -0700 |
commit | 18fb0b5e37133d46736b74d1fd40815f48324df1 (patch) | |
tree | 07179c5d7f4c6b4b1e4946c9215efef73f447617 | |
parent | d1734e53e805ba44eb13c10a724ee3ca05013914 (diff) | |
download | dn42peering-18fb0b5e37133d46736b74d1fd40815f48324df1.tar dn42peering-18fb0b5e37133d46736b74d1fd40815f48324df1.tar.gz dn42peering-18fb0b5e37133d46736b74d1fd40815f48324df1.tar.bz2 dn42peering-18fb0b5e37133d46736b74d1fd40815f48324df1.zip |
feat(central): add internal IP unique index
If migration failed with duplication keys, manually remove duplicated nodes and repair.
-rw-r--r-- | central/src/main/resources/db/migration/V4__Node_Internal_IP_Unique.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/central/src/main/resources/db/migration/V4__Node_Internal_IP_Unique.sql b/central/src/main/resources/db/migration/V4__Node_Internal_IP_Unique.sql new file mode 100644 index 0000000..61c7431 --- /dev/null +++ b/central/src/main/resources/db/migration/V4__Node_Internal_IP_Unique.sql @@ -0,0 +1 @@ +ALTER TABLE `node` ADD UNIQUE `Internal_IP_Unique` (`internal_ip`);
\ No newline at end of file |