D11987.diff
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

D11987.diff
View Options

	diff --git a/keyserver/src/updaters/account-updaters.js b/keyserver/src/updaters/account-updaters.js
	--- a/keyserver/src/updaters/account-updaters.js
	+++ b/keyserver/src/updaters/account-updaters.js
	@@ -128,9 +128,9 @@
	START TRANSACTION;

	UPDATE uploads
	- SET container = NULL
	+ SET user_container = NULL
	WHERE uploader = ${viewer.userID}
	- AND container = ${viewer.userID}
	+ AND user_container = ${viewer.userID}
	AND (
	${mediaID} IS NULL
	OR EXISTS (
	@@ -139,15 +139,17 @@
	WHERE id = ${mediaID}
	AND uploader = ${viewer.userID}
	AND container IS NULL
	+ AND user_container IS NULL
	AND thread IS NULL
	)
	);

	UPDATE uploads
	- SET container = ${viewer.userID}
	+ SET user_container = ${viewer.userID}
	WHERE id = ${mediaID}
	AND uploader = ${viewer.userID}
	AND container IS NULL
	+ AND user_container IS NULL
	AND thread IS NULL;

	UPDATE users
	@@ -160,7 +162,7 @@
	FROM uploads
	WHERE id = ${mediaID}
	AND uploader = ${viewer.userID}
	- AND container = ${viewer.userID}
	+ AND user_container = ${viewer.userID}
	AND thread IS NULL
	)
	);
	@@ -171,7 +173,7 @@
	FROM uploads
	WHERE id = ${mediaID}
	AND uploader = ${viewer.userID}
	- AND container = ${viewer.userID};
	+ AND user_container = ${viewer.userID};
	`;

	const [resultSet] = await dbQuery(query, { multipleStatements: true });