making a shoebox

1 files changed, 18 insertions, 0 deletions

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");
+};