From 9d2b6ee10ec5359cc91769d430485c8c869ba1a8 Mon Sep 17 00:00:00 2001
From: Akshay <nerdy@peppe.rs>
Date: Thu, 24 Dec 2020 10:51:40 +0530
Subject: monorepo

---
 migrations/.gitkeep                                |  0
 migrations/2020-09-22-104623_create_users/down.sql |  3 --
 migrations/2020-09-22-104623_create_users/up.sql   |  8 ----
 .../down.sql                                       |  3 --
 .../2020-11-16-133516_create_products_table/up.sql |  8 ----
 migrations/2020-12-13-140215_all_tables/down.sql   | 11 -----
 migrations/2020-12-13-140215_all_tables/up.sql     | 47 ----------------------
 7 files changed, 80 deletions(-)
 delete mode 100644 migrations/.gitkeep
 delete mode 100644 migrations/2020-09-22-104623_create_users/down.sql
 delete mode 100644 migrations/2020-09-22-104623_create_users/up.sql
 delete mode 100644 migrations/2020-11-16-133516_create_products_table/down.sql
 delete mode 100644 migrations/2020-11-16-133516_create_products_table/up.sql
 delete mode 100644 migrations/2020-12-13-140215_all_tables/down.sql
 delete mode 100644 migrations/2020-12-13-140215_all_tables/up.sql

(limited to 'migrations')

diff --git a/migrations/.gitkeep b/migrations/.gitkeep
deleted file mode 100644
index e69de29..0000000
diff --git a/migrations/2020-09-22-104623_create_users/down.sql b/migrations/2020-09-22-104623_create_users/down.sql
deleted file mode 100644
index 2c92cb7..0000000
--- a/migrations/2020-09-22-104623_create_users/down.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- This file should undo anything in `up.sql`
-
-DROP TABLE members;
diff --git a/migrations/2020-09-22-104623_create_users/up.sql b/migrations/2020-09-22-104623_create_users/up.sql
deleted file mode 100644
index dfd27d9..0000000
--- a/migrations/2020-09-22-104623_create_users/up.sql
+++ /dev/null
@@ -1,8 +0,0 @@
--- Your SQL goes here
-CREATE TABLE members (
-    id INTEGER PRIMARY KEY AUTO_INCREMENT,
-    username VARCHAR(255) NOT NULL UNIQUE,
-    password VARCHAR(255) NOT NULL,
-    phone_number VARCHAR(10) NOT NULL,
-    email_id VARCHAR(255) NOT NULL
-)
diff --git a/migrations/2020-11-16-133516_create_products_table/down.sql b/migrations/2020-11-16-133516_create_products_table/down.sql
deleted file mode 100644
index 7d99a98..0000000
--- a/migrations/2020-11-16-133516_create_products_table/down.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- 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
deleted file mode 100644
index 829c5be..0000000
--- a/migrations/2020-11-16-133516_create_products_table/up.sql
+++ /dev/null
@@ -1,8 +0,0 @@
--- 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/migrations/2020-12-13-140215_all_tables/down.sql b/migrations/2020-12-13-140215_all_tables/down.sql
deleted file mode 100644
index 9c554a2..0000000
--- a/migrations/2020-12-13-140215_all_tables/down.sql
+++ /dev/null
@@ -1,11 +0,0 @@
--- This file should undo anything in `up.sql`
-
-drop table customer;
-
-drop table product;
-
-drop table cart_items;
-
-drop table rating;
-
-drop table transaction;
diff --git a/migrations/2020-12-13-140215_all_tables/up.sql b/migrations/2020-12-13-140215_all_tables/up.sql
deleted file mode 100644
index 527b926..0000000
--- a/migrations/2020-12-13-140215_all_tables/up.sql
+++ /dev/null
@@ -1,47 +0,0 @@
--- Your SQL goes here
-
-create table customer (
-    id integer primary key auto_increment,
-    username varchar(255) not null unique,
-    password varchar(255) not null,
-    phone_number varchar(10) not null,
-    email_id varchar(255) not null,
-    address text(500)
-);
-
-create table product (
-    id integer primary key auto_increment,
-    name varchar(255) not null,
-    kind varchar(255),
-    price float not null,
-    description varchar(255)
-);
-
-create table cart_items (
-    cart_id integer,
-    product_id integer,
-    constraint cart_items_pk primary key (cart_id, product_id),
-    foreign key (cart_id) references customer(id),
-    foreign key (product_id) references product(id)
-);
-
-create table rating (
-    id integer primary key auto_increment,
-    comment_text text(500),
-    comment_date date default curdate(),
-    product_id integer,
-    customer_id integer,
-
-    stars integer check (stars >= 0 AND stars <= 5),
-    foreign key (customer_id) references customer(id),
-    foreign key (product_id) references product(id)
-);
-
-create table transaction (
-    id integer primary key auto_increment,
-    payment_type varchar(255) not null,
-    amount float not null,
-    customer_id integer,
-
-    foreign key (customer_id) references customer(id)
-);
-- 
cgit v1.2.3