1 files changed, 8 insertions, 0 deletions
diff --git a/backend/migrations/2020-11-16-133516_create_products_table/up.sql b/backend/migrations/2020-11-16-133516_create_products_table/up.sql
new file mode 100644
index 0000000..829c5be
--- /dev/null
+++ b/backend/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)
+)

diff --git a/backend/migrations/2020-11-16-133516_create_products_table/up.sql b/backend/migrations/2020-11-16-133516_create_products_table/up.sql new file mode 100644 index 0000000..829c5be --- /dev/null +++ b/backend/migrations/2020-11-16-133516_create_products_table/up.sql
@@ -0,0 +1,8 @@
	1	-- Your SQL goes here
	2	CREATE TABLE product (
	3	id INTEGER PRIMARY KEY AUTO_INCREMENT,
	4	name VARCHAR(255) NOT NULL,
	5	kind VARCHAR(255),
	6	price FLOAT NOT NULL,
	7	description VARCHAR(255)
	8	)