aboutsummaryrefslogtreecommitdiffstats
path: root/src/internal-server/database/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'src/internal-server/database/migrations')
-rw-r--r--src/internal-server/database/migrations/1503250034279_user.js18
-rw-r--r--src/internal-server/database/migrations/1566385379883_service_schema.js21
-rw-r--r--src/internal-server/database/migrations/1566554231482_recipe_schema.js20
-rw-r--r--src/internal-server/database/migrations/1566554359294_workspace_schema.js22
4 files changed, 81 insertions, 0 deletions
diff --git a/src/internal-server/database/migrations/1503250034279_user.js b/src/internal-server/database/migrations/1503250034279_user.js
new file mode 100644
index 000000000..80b49020a
--- /dev/null
+++ b/src/internal-server/database/migrations/1503250034279_user.js
@@ -0,0 +1,18 @@
1/** @type {import('@adonisjs/lucid/src/Schema')} */
2const Schema = use('Schema');
3
4class UserSchema extends Schema {
5 up() {
6 this.create('users', (table) => {
7 table.increments();
8 table.json('settings');
9 table.timestamps();
10 });
11 }
12
13 down() {
14 this.drop('users');
15 }
16}
17
18module.exports = UserSchema;
diff --git a/src/internal-server/database/migrations/1566385379883_service_schema.js b/src/internal-server/database/migrations/1566385379883_service_schema.js
new file mode 100644
index 000000000..d887ef193
--- /dev/null
+++ b/src/internal-server/database/migrations/1566385379883_service_schema.js
@@ -0,0 +1,21 @@
1/** @type {import('@adonisjs/lucid/src/Schema')} */
2const Schema = use('Schema');
3
4class ServiceSchema extends Schema {
5 up() {
6 this.create('services', (table) => {
7 table.increments();
8 table.string('serviceId', 80).notNullable();
9 table.string('name', 80).notNullable();
10 table.string('recipeId', 254).notNullable();
11 table.json('settings');
12 table.timestamps();
13 });
14 }
15
16 down() {
17 this.drop('services');
18 }
19}
20
21module.exports = ServiceSchema;
diff --git a/src/internal-server/database/migrations/1566554231482_recipe_schema.js b/src/internal-server/database/migrations/1566554231482_recipe_schema.js
new file mode 100644
index 000000000..514d57600
--- /dev/null
+++ b/src/internal-server/database/migrations/1566554231482_recipe_schema.js
@@ -0,0 +1,20 @@
1/** @type {import('@adonisjs/lucid/src/Schema')} */
2const Schema = use('Schema');
3
4class RecipeSchema extends Schema {
5 up() {
6 this.create('recipes', (table) => {
7 table.increments();
8 table.string('name', 80).notNullable();
9 table.string('recipeId', 254).notNullable().unique();
10 table.json('data');
11 table.timestamps();
12 });
13 }
14
15 down() {
16 this.drop('recipes');
17 }
18}
19
20module.exports = RecipeSchema;
diff --git a/src/internal-server/database/migrations/1566554359294_workspace_schema.js b/src/internal-server/database/migrations/1566554359294_workspace_schema.js
new file mode 100644
index 000000000..421a406b5
--- /dev/null
+++ b/src/internal-server/database/migrations/1566554359294_workspace_schema.js
@@ -0,0 +1,22 @@
1/** @type {import('@adonisjs/lucid/src/Schema')} */
2const Schema = use('Schema');
3
4class WorkspaceSchema extends Schema {
5 up() {
6 this.create('workspaces', (table) => {
7 table.increments();
8 table.string('workspaceId', 80).notNullable().unique();
9 table.string('name', 80).notNullable();
10 table.integer('order');
11 table.json('services');
12 table.json('data');
13 table.timestamps();
14 });
15 }
16
17 down() {
18 this.drop('workspaces');
19 }
20}
21
22module.exports = WorkspaceSchema;