From 67e5016829787c2398dcb1ceea6b6dca192ac27c Mon Sep 17 00:00:00 2001
From: Akshay <nerdy@peppe.rs>
Date: Mon, 16 Nov 2020 19:45:42 +0530
Subject: add product table

---
 migrations/2020-11-16-133516_create_products_table/down.sql | 3 +++
 migrations/2020-11-16-133516_create_products_table/up.sql   | 8 ++++++++
 2 files changed, 11 insertions(+)
 create mode 100644 migrations/2020-11-16-133516_create_products_table/down.sql
 create mode 100644 migrations/2020-11-16-133516_create_products_table/up.sql

(limited to 'migrations/2020-11-16-133516_create_products_table')

diff --git a/migrations/2020-11-16-133516_create_products_table/down.sql b/migrations/2020-11-16-133516_create_products_table/down.sql
new file mode 100644
index 0000000..7d99a98
--- /dev/null
+++ b/migrations/2020-11-16-133516_create_products_table/down.sql
@@ -0,0 +1,3 @@
+-- This file should undo anything in `up.sql`
+
+DROP TABLE product;
diff --git a/migrations/2020-11-16-133516_create_products_table/up.sql b/migrations/2020-11-16-133516_create_products_table/up.sql
new file mode 100644
index 0000000..829c5be
--- /dev/null
+++ b/migrations/2020-11-16-133516_create_products_table/up.sql
@@ -0,0 +1,8 @@
+-- Your SQL goes here
+CREATE TABLE product (
+    id INTEGER PRIMARY KEY AUTO_INCREMENT,
+    name VARCHAR(255) NOT NULL,
+    kind VARCHAR(255),
+    price FLOAT NOT NULL,
+    description VARCHAR(255)
+)
-- 
cgit v1.2.3