From c251396987dcffa38d421303162661b68443314f Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Wed, 9 Jul 2014 16:59:22 -0400 Subject: got some datamodels --- server/models/Party.js | 13 +++++++++++++ server/models/User.js | 21 +++++++++++++++++++++ server/models/UserParty.js | 11 +++++++++++ server/models/index.js | 3 --- 4 files changed, 45 insertions(+), 3 deletions(-) create mode 100644 server/models/Party.js create mode 100644 server/models/User.js create mode 100644 server/models/UserParty.js delete mode 100644 server/models/index.js (limited to 'server/models') diff --git a/server/models/Party.js b/server/models/Party.js new file mode 100644 index 0000000..f48fde1 --- /dev/null +++ b/server/models/Party.js @@ -0,0 +1,13 @@ + +// 0 id 1 date +// 0 id 1 date 2 location + +var db = require("../db"), + Sequelize = require("sequelize"); + +var Party = db.sequelize.define('Party', { + date: Sequelize.INTEGER, + location: Sequelize.STRING, +}) + +module.exports = Party diff --git a/server/models/User.js b/server/models/User.js new file mode 100644 index 0000000..c379653 --- /dev/null +++ b/server/models/User.js @@ -0,0 +1,21 @@ +// 0 id 1 group 2 name 3 email 4 blurb +// 0 id 1 name 2 email 3 access 4 emailhidden 5 hostid 6 blurb +// 0 id 1 name 2 firstname 3 email 4 access + +var db = require("../db"), + Sequelize = require("sequelize"); + +var User = db.sequelize.define('User', { + email: Sequelize.STRING, + password: Sequelize.STRING, + + name: Sequelize.STRING, + + access: Sequelize.INTEGER, + emailhidden: Sequelize.BOOLEAN, + hostid: Sequelize.INTEGER, + blurb: Sequelize.BLOB, +}) + +module.exports = User + diff --git a/server/models/UserParty.js b/server/models/UserParty.js new file mode 100644 index 0000000..626135c --- /dev/null +++ b/server/models/UserParty.js @@ -0,0 +1,11 @@ + +var db = require("../db"), + Sequelize = require("sequelize"); + +var UserParty = db.sequelize.define('UserParty', { + user_id: Sequelize.INTEGER, + host_id: Sequelize.INTEGER, + party_id: Sequelize.INTEGER, +}) + +module.exports = UserParty diff --git a/server/models/index.js b/server/models/index.js deleted file mode 100644 index 7acaac2..0000000 --- a/server/models/index.js +++ /dev/null @@ -1,3 +0,0 @@ -module.exports = { - -} -- cgit v1.2.3-70-g09d2