uploads: Rewrite the whole thing

[pbs.git] / src / database.sql

diff --git a/src/database.sql b/src/database.sql
index ba33e806909190851af74b8e2fb40077ea992765..87a6791d7ce221b9b5f9cdc05da57e74b0877a26 100644 (file)
--- a/src/database.sql
+++ b/src/database.sql
@@ -1047,10 +1047,12 @@ CREATE TABLE public.uploads (
     user_id integer,
     builder_id integer,
     filename text NOT NULL,
-    path text NOT NULL,
+    path text,
     size bigint NOT NULL,
     created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
-    expires_at timestamp without time zone DEFAULT (CURRENT_TIMESTAMP + '24:00:00'::interval) NOT NULL
+    expires_at timestamp without time zone DEFAULT (CURRENT_TIMESTAMP + '24:00:00'::interval) NOT NULL,
+    digest_algo text NOT NULL,
+    digest bytea NOT NULL
 );
 
 
@@ -1873,6 +1875,20 @@ CREATE INDEX sources_repo_id ON public.sources USING btree (repo_id) WHERE (dele
 CREATE UNIQUE INDEX sources_slug ON public.sources USING btree (slug) WHERE (deleted_at IS NULL);
 
 
+--
+-- Name: uploads_builder_id; Type: INDEX; Schema: public; Owner: -
+--
+
+CREATE INDEX uploads_builder_id ON public.uploads USING btree (builder_id);
+
+
+--
+-- Name: uploads_user_id; Type: INDEX; Schema: public; Owner: -
+--
+
+CREATE INDEX uploads_user_id ON public.uploads USING btree (user_id);
+
+
 --
 -- Name: uploads_uuid; Type: INDEX; Schema: public; Owner: -
 --