diff options
Diffstat (limited to 'server/models')
| -rw-r--r-- | server/models/Party.js | 13 | ||||
| -rw-r--r-- | server/models/User.js | 21 | ||||
| -rw-r--r-- | server/models/UserParty.js | 11 | ||||
| -rw-r--r-- | server/models/index.js | 3 |
4 files changed, 45 insertions, 3 deletions
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 = { - -} |
