GELXQjwG

1'use strict';
2
3var DataHelper = require('../models/DataHelper');
4
5exports.up = function (next) {
6    var createQuery = "CREATE TABLE device_settings(" +
7        "device_id integer NOT NULL," +
8        "setting_id smallint NOT NULL," +
9        "CONSTRAINT device_settings_pk PRIMARY KEY (device_id, setting_id)," +
10        "CONSTRAINT device_settings_to_settings_fk FOREIGN KEY (setting_id)" +
11        "REFERENCES settings (id) MATCH SIMPLE " +
12        "ON UPDATE NO ACTION ON DELETE NO ACTION" +
13        ")";
14    DataHelper.sql(createQuery, function () {
15        next();
16    });
17};
18
19exports.down = function (next) {
20    var dropQuery = "DROP TABLE IF EXISTS device_settings";
21    DataHelper.sql(dropQuery, function () {
22        next();
23    });
24};