DmmPpdiY

1'use strict';
2
3var DataHelper = require('../models/DataHelper');
4
5exports.up = function (next) {
6    var createQuery = "CREATE TABLE settings(" +
7        "id SERIAL PRIMARY KEY," +
8        "namespace character varying," +
9        "code character varying NOT NULL," +
10        "value character varying NOT NULL," +
11        "CONSTRAINT settings_namespace_code_key UNIQUE (namespace,code)" +
12        ")";
13    DataHelper.sql(createQuery, function () {
14        next();
15    });
16};
17
18exports.down = function (next) {
19    var dropQuery = "DROP TABLE IF EXISTS settings";
20    DataHelper.sql(dropQuery, function () {
21        next();
22    });
23};