create datasets model

6 files changed, 28 insertions, 18 deletions

diff --git a/migrations/20170628233335_createFolders.js b/migrations/20170628233335_createFolders.js
index 908a4fc..9311136 100644
--- a/migrations/20170628233335_createFolders.js
+++ b/migrations/20170628233335_createFolders.js
@@ -5,6 +5,10 @@ exports.up = function(knex, Promise) {
     table.string('name')
     table.string('datatype') // video, audio, audio spectrogram
     table.string('username')
+    table.string('activity')
+    table.string('module')
+    table.string('checkpoint')
+    table.json('opt')
     table.timestamps()
   })
 };
diff --git a/migrations/20170628233613_createFiles.js b/migrations/20170628233613_createFiles.js
index bb2da3c..99336bf 100644
--- a/migrations/20170628233613_createFiles.js
+++ b/migrations/20170628233613_createFiles.js
@@ -7,7 +7,7 @@ exports.up = function(knex, Promise) {
     table.string('name')
     table.string('url')
     table.string('mime')
-    table.string('type')
+    table.string('datatype')
     table.float('duration')
     table.text('analysis')
     table.integer('size')
diff --git a/migrations/20170628233706_createJobs.js b/migrations/20170628233706_createJobs.js
deleted file mode 100644
index 4b17c6f..0000000
--- a/migrations/20170628233706_createJobs.js
+++ /dev/null
@@ -1,15 +0,0 @@
-
-exports.up = function(knex, Promise) {
-  return knex.schema.createTable('jobs', function (table) {
-    table.increments()
-    table.string('name')
-    table.string('username')
-    table.boolean('completed')
-    table.string('tool')
-    table.timestamps()
-  })
-};
-
-exports.down = function(knex, Promise) {
-  return knex.schema.dropTable('jobs')
-};
diff --git a/migrations/20170628234104_createTasks.js b/migrations/20170628234104_createTasks.js
index 7329fc8..8f6430a 100644
--- a/migrations/20170628234104_createTasks.js
+++ b/migrations/20170628234104_createTasks.js
@@ -2,7 +2,6 @@
 exports.up = function(knex, Promise) {
   return knex.schema.createTable('tasks', function (table) {
     table.increments()
-    table.integer('job_id')
     table.string('username')
     table.boolean('completed')
     table.boolean('processing')
diff --git a/migrations/20180529000627_createUsers.js b/migrations/20180529000627_createUsers.js
index 3f86d5a..5346555 100644
--- a/migrations/20180529000627_createUsers.js
+++ b/migrations/20180529000627_createUsers.js
@@ -5,7 +5,8 @@ exports.up = function(knex, Promise) {
     table.string('username')

     table.string('password')

     table.string('realname')

-    table.string('level')

+    table.integer('level')

+    table.string('avatar')

     table.datetime('lastseen')

     table.json('profile')

     table.timestamps()

diff --git a/migrations/20180529002311_createDatasets.js b/migrations/20180529002311_createDatasets.js
new file mode 100644
index 0000000..41cd457
--- /dev/null
+++ b/migrations/20180529002311_createDatasets.js
@@ -0,0 +1,21 @@
+

+exports.up = function(knex, Promise) {

+  return knex.schema.createTable('datasets', function (table) {

+    table.increments()

+    table.string('username')

+    table.boolean('completed')

+    table.boolean('processing')

+    table.string('status')

+    table.string('status')

+    table.string('activity')

+    table.string('module')

+    table.string('checkpoint')

+    table.string('dataset')

+    table.json('opt')

+    table.timestamps()

+  })

+};

+

+exports.down = function(knex, Promise) {

+  return knex.schema.dropTable('datasets')

+};