db: Update users indexes

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>

diff --git a/src/database.sql b/src/database.sql
index a14d3ad50f4dc497917d66b86625b81e49c26420..df758a55cd31a43ad68cdff637906834070e1525 100644 (file)
--- a/src/database.sql
+++ b/src/database.sql
@@ -1391,14 +1391,6 @@ ALTER TABLE ONLY public.images_types
     ADD CONSTRAINT idx_2198057_primary PRIMARY KEY (id);
 
 
---
--- Name: users idx_2198244_primary; Type: CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.users
-    ADD CONSTRAINT idx_2198244_primary PRIMARY KEY (id);
-
-
 --
 -- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
 --
@@ -1543,6 +1535,14 @@ ALTER TABLE ONLY public.user_push_subscriptions
     ADD CONSTRAINT user_push_subscriptions_pkey PRIMARY KEY (id);
 
 
+--
+-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY public.users
+    ADD CONSTRAINT users_pkey PRIMARY KEY (id);
+
+
 --
 -- Name: build_bugs_unique; Type: INDEX; Schema: public; Owner: -
 --
@@ -1676,13 +1676,6 @@ CREATE UNIQUE INDEX distributions_unique ON public.distributions USING btree (di
 CREATE UNIQUE INDEX idx_2198199_k ON public.settings USING btree (k);
 
 
---
--- Name: idx_2198244_name; Type: INDEX; Schema: public; Owner: -
---
-
-CREATE UNIQUE INDEX idx_2198244_name ON public.users USING btree (name);
-
-
 --
 -- Name: job_packages_job_id; Type: INDEX; Schema: public; Owner: -
 --
@@ -1928,6 +1921,13 @@ CREATE UNIQUE INDEX uploads_uuid ON public.uploads USING btree (uuid);
 CREATE INDEX user_push_subscriptions_user_id ON public.user_push_subscriptions USING btree (user_id) WHERE (deleted_at IS NULL);
 
 
+--
+-- Name: users_name; Type: INDEX; Schema: public; Owner: -
+--
+
+CREATE UNIQUE INDEX users_name ON public.users USING btree (name) WHERE (deleted_at IS NULL);
+
+
 --
 -- Name: build_bugs build_bugs_added_by; Type: FK CONSTRAINT; Schema: public; Owner: -
 --