database.js 643 B

123456789101112131415161718192021222324252627282930313233343536
  1. var Sequelize = require('sequelize');
  2. exports.sequelize = new Sequelize('stats', '', '', {
  3. host: 'localhost',
  4. dialect: 'sqlite',
  5. storage: './database.sqlite',
  6. // logging: true
  7. });
  8. exports.server = exports.sequelize.define("server", {
  9. type: {
  10. type: Sequelize.STRING
  11. },
  12. name:{
  13. type: Sequelize.STRING
  14. },
  15. address:{
  16. type: Sequelize.STRING
  17. }
  18. });
  19. exports.traffic = exports.sequelize.define("traffic", {
  20. players:{
  21. type: Sequelize.INTEGER
  22. },
  23. maxplayers:{
  24. type: Sequelize.INTEGER
  25. }
  26. });
  27. var Traffic = exports.traffic;
  28. var Server = exports.server;
  29. Traffic.belongsTo(Server);
  30. exports.sequelize.sync();