# site\_settings 的 name 列没有唯一索引

**URL:** <https://meta.discourse.org/t/no-unique-index-on-site-settings-name-column/112047>\
**Category:** Development\
**Created:** [2019 年3 月 19 日 14:03 UTC](https://meta.discourse.org/t/no-unique-index-on-site-settings-name-column/112047 "2019-03-19T14:03:47Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

作者： ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)\
发布日期： [2019 年3 月 20 日 04:27 UTC](https://meta.discourse.org/t/no-unique-index-on-site-settings-name-column/112047/3 "2019-03-20T04:27:58Z")

</div>

Definitely relevant to @gerhard but strongly agree we should have a unique index on name on the `site_settings` table (and throw away non unique rows in the migration)

We will make that happen.

---

_[View the full topic](https://meta.discourse.org/t/no-unique-index-on-site-settings-name-column/112047)._