From f82d95c5f5b589bec0fc503c86f9e644b07b4ddd Mon Sep 17 00:00:00 2001
From: Jules Laplace <julescarbon@gmail.com>
Date: Tue, 29 May 2018 00:26:39 +0200
Subject: create datasets model

---
 migrations/20170628233335_createFolders.js  |  4 ++++
 migrations/20170628233613_createFiles.js    |  2 +-
 migrations/20170628233706_createJobs.js     | 15 ---------------
 migrations/20170628234104_createTasks.js    |  1 -
 migrations/20180529000627_createUsers.js    |  3 ++-
 migrations/20180529002311_createDatasets.js | 21 +++++++++++++++++++++
 6 files changed, 28 insertions(+), 18 deletions(-)
 delete mode 100644 migrations/20170628233706_createJobs.js
 create mode 100644 migrations/20180529002311_createDatasets.js

(limited to 'migrations')

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')
+};
-- 
cgit v1.2.3-70-g09d2