From 06ecdf2af182034496e2123852deee4a58de1043 Mon Sep 17 00:00:00 2001
From: Jules Laplace <julescarbon@gmail.com>
Date: Sun, 17 Oct 2021 02:52:05 +0200
Subject: making a shoebox

---
 src/migrations/20211017023049_create_shoe.js | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 src/migrations/20211017023049_create_shoe.js

(limited to 'src/migrations')

diff --git a/src/migrations/20211017023049_create_shoe.js b/src/migrations/20211017023049_create_shoe.js
new file mode 100644
index 0000000..50f6add
--- /dev/null
+++ b/src/migrations/20211017023049_create_shoe.js
@@ -0,0 +1,18 @@
+/**
+ * Migration: Create shoe table.
+ */
+
+exports.up = function (knex) {
+  return knex.schema.createTable("shoe", function (table) {
+    table.increments("shoe_id").primary().unsigned();
+    table.string("shoelace", 16).nullable();
+    table.string("shoebox", 16).nullable();
+    table.string("type", 16).nullable();
+    table.jsonb("metadata").defaultTo({});
+    table.timestamp("created_at").defaultTo(knex.fn.now());
+  });
+};
+
+exports.down = function (knex) {
+  return knex.schema.dropTable("shoe");
+};
-- 
cgit v1.2.3-70-g09d2