1 files changed, 47 insertions, 0 deletions
diff --git a/lib/db/index.js b/lib/db/index.js
new file mode 100644
index 0000000..e820758
--- /dev/null
+++ b/lib/db/index.js
@@ -0,0 +1,47 @@
+var db = module.exports
+
+var connection = require("./bookshelf")
+var bookshelf = connection.bookshelf
+var knex = connection.knex
+
+/* MODELS */
+
+var User = db.User = bookshelf.Model.extend({
+  tableName: 'users',
+  hasTimestamps: true,
+})
+var Thread = db.Thread = bookshelf.Model.extend({
+  tableName: 'threads',
+  hasTimestamps: true,
+})
+var Comment = db.Comment = bookshelf.Model.extend({
+  tableName: 'comments',
+  hasTimestamps: true,
+})
+var File = db.File = bookshelf.Model.extend({
+  tableName: 'files',
+  hasTimestamps: true,
+})
+var Keyword = db.Keyword = bookshelf.Model.extend({
+  tableName: 'keywords',
+  hasTimestamps: true,
+})
+var Mailbox = db.Mailbox = bookshelf.Model.extend({
+  tableName: 'boxes',
+  hasTimestamps: true,
+})
+var Message = db.Message = bookshelf.Model.extend({
+  tableName: 'messages',
+  hasTimestamps: true,
+})
+
+/* PICTURES */
+
+db.createUser = function(data){
+  return new db.User(data).save()
+}
+db.getUsers = function (callback) {
+  return User.query(function(qb){
+    qb.orderBy("id", "desc")
+  }).fetchAll()
+}