X-Git-Url: https://git.auder.net/?p=qomet.git;a=blobdiff_plain;f=setup%2Fdatabase.js;h=2889816bcebd3e0619ff1fd24bff84c0c06f2224;hp=2070e719b3e7e73780e4bb130952438a5f51958d;hb=26325ff0a1789ee176f74f070059668b66aa0ad1;hpb=fdf62750d329257baae55a86e746902f310a2386

diff --git a/setup/database.js b/setup/database.js
index 2070e71..2889816 100644
--- a/setup/database.js
+++ b/setup/database.js
@@ -1,13 +1,7 @@
-// TODO: createCollections users, courses, assessments
-// with:
-// users
-//   unique initials, email
-//   index initials, email
-// courses
-//   unique (code,uid)
-//   index (code,uid)
-// evaluations
-//   unique (cid, name)
-//   index (cid, name)
-// db.evaluations.createIndex( { cid: 1, name: 1 } );
-// https://docs.mongodb.com/manual/core/index-compound/
+use qomet
+db.createCollection("users")
+db.createCollection("courses")
+db.createCollection("evaluations")
+db.users.createIndex({ initials: 1, email: 1 }, { unique: true } )
+db.courses.createIndex({ code: 1, uid: 1 }, { unique: true } )
+db.evaluations.createIndex({ cid: 1, name: 1 }, { unique: true } )