X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=setup%2Fdatabase.js;h=2889816bcebd3e0619ff1fd24bff84c0c06f2224;hb=HEAD;hp=b9a392d8c557b7d9aac8b9c07c9266472d6930ef;hpb=e99c53fb3be56eb4c685dd061eef0e5b5bf22b73;p=qomet.git

diff --git a/setup/database.js b/setup/database.js
index b9a392d..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)
-// assessments
-//   unique (cid, name)
-//   index (cid, name)
-// db.assessments.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 } )