summaryrefslogtreecommitdiff
path: root/server/models
diff options
context:
space:
mode:
Diffstat (limited to 'server/models')
-rw-r--r--server/models/Party.js13
-rw-r--r--server/models/User.js21
-rw-r--r--server/models/UserParty.js11
-rw-r--r--server/models/index.js3
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 = {
-
-}