1 files changed, 36 insertions, 18 deletions
diff --git a/tests/queries.sql b/tests/queries.sql
index 85cc5fb..e57a637 100644
--- a/tests/queries.sql
+++ b/tests/queries.sql
@@ -88,24 +88,6 @@
 
 --    read:
 
--- byEmail.sql:
---   write:
-
---    read:
-		SELECT id, timestamp, uuid, salt, pwhash, (
-			CASE WHEN EXISTS (
-				SELECT id FROM "cracha_user_confirmations"
-				WHERE user_id = (
-					SELECT id FROM  "cracha_users"
-					WHERE email = ?
-				)
-			) THEN 1
-			ELSE   0
-			END
-		) as confirmed
-		FROM "cracha_users" WHERE email = ?;
-	
-
 -- register.sql:
 --   write:
 		INSERT INTO "cracha_users" (uuid, email, salt, pwhash)
@@ -145,6 +127,42 @@
 		WHERE token = ?;
 	
 
+-- byEmail.sql:
+--   write:
+
+--    read:
+		SELECT id, timestamp, uuid, salt, pwhash, (
+			CASE WHEN EXISTS (
+				SELECT id FROM "cracha_user_confirmations"
+				WHERE user_id = (
+					SELECT id FROM  "cracha_users"
+					WHERE email = ?
+				)
+			) THEN 1
+			ELSE   0
+			END
+		) as confirmed
+		FROM "cracha_users" WHERE email = ?;
+	
+
+-- userByUUID.sql:
+--   write:
+
+--    read:
+		SELECT id, timestamp, email, salt, pwhash, (
+			CASE WHEN EXISTS (
+				SELECT id FROM "cracha_user_confirmations"
+				WHERE user_id = (
+					SELECT id FROM "cracha_users"
+					WHERE uuid = ?
+				)
+			) THEN 1
+			ELSE   0
+			END
+		) as confirmed
+		FROM "cracha_users" WHERE uuid = ?;
+	
+
 -- login.sql:
 --   write: