From 1ef9e40795384b1fd9b5bcb0798f7f210068dd1f Mon Sep 17 00:00:00 2001
From: Nathan Ringo <nathan@remexre.com>
Date: Tue, 16 Jan 2024 02:29:25 -0600
Subject: All the surrounding mechanisms for noticing user X.500s.

---
 migrations/20240116060938_init_x500s.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'migrations/20240116060938_init_x500s.sql')

diff --git a/migrations/20240116060938_init_x500s.sql b/migrations/20240116060938_init_x500s.sql
index 3d5ca68..adc1a4b 100644
--- a/migrations/20240116060938_init_x500s.sql
+++ b/migrations/20240116060938_init_x500s.sql
@@ -6,8 +6,8 @@ CREATE TABLE IF NOT EXISTS student_x500s
 
 -- In the common case, we can just map users to their X.500s.
 CREATE TABLE IF NOT EXISTS uids_to_x500s_clean
-  ( uid  TEXT NOT NULL
-  , x500 TEXT NOT NULL
+  ( uid  INTEGER NOT NULL
+  , x500 TEXT    NOT NULL
   , FOREIGN KEY(x500) REFERENCES student_x500s(x500)
   , UNIQUE(uid)
   , UNIQUE(x500)
@@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS uids_to_x500s_clean
 -- all_seen_uids_to_x500s. This lets us get a list of "suspicious tuples" by
 -- subtracting uids_to_x500s_clean from all_seen_uids_to_x500s.
 CREATE TABLE IF NOT EXISTS all_seen_uids_to_x500s
-  ( uid  TEXT NOT NULL
-  , x500 TEXT NOT NULL
+  ( uid  INTEGER NOT NULL
+  , x500 TEXT    NOT NULL
   , UNIQUE(uid, x500)
   );
-- 
cgit v1.2.3

