Attempt to resurrect qomet code - need some rewrite

[qomet.git] / setup / database.js

diff --git a/setup/database.js b/setup/database.js
index 2070e71..2889816 100644 (file)
--- 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 } )