1 | 'use strict';
|
2 |
|
3 | var dbm;
|
4 | var type;
|
5 | var seed;
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 | exports.setup = function(options, seedLink) {
|
12 | dbm = options.dbmigrate;
|
13 | type = dbm.dataType;
|
14 | seed = seedLink;
|
15 | };
|
16 |
|
17 | exports.up = function(db) {
|
18 | return db.createTable('activity', {
|
19 | id: { type: 'int', primaryKey: true, autoIncrement: true},
|
20 | lastTime: {type: 'string', length: 50, unique: true},
|
21 | content: {type: 'string', length: 2000},
|
22 | status: {type: 'int', defaultValue: 0},
|
23 | createdAt: {type: 'datetime'},
|
24 | updatedAt: {type: 'datetime'},
|
25 | });
|
26 | };
|
27 |
|
28 | exports.down = function(db) {
|
29 | return db.dropTable('activity').then(
|
30 | function(result) {
|
31 | },
|
32 | function(err) {
|
33 | }
|
34 | );
|
35 | };
|
36 |
|
37 | exports._meta = {
|
38 | "version": 1
|
39 | };
|