Bro where its database schemas .sql file about online-shopping HOT 1 CLOSED

-- MySQL dump 10.13 Distrib 8.0.22, for macos10.15 (x86_64)

-- Host: localhost Database: online_shopping_db

-- Server version 8.0.18

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!50503 SET NAMES utf8 /;
/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
/!40103 SET TIME_ZONE='+00:00' /;
/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table address

DROP TABLE IF EXISTS address;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE address (
id int(11) NOT NULL AUTO_INCREMENT,
address_line_one varchar(255) NOT NULL,
address_line_two varchar(255) NOT NULL,
billing bit(1) DEFAULT NULL,
city varchar(255) NOT NULL,
country varchar(255) NOT NULL,
postal_code varchar(255) NOT NULL,
shipping bit(1) DEFAULT NULL,
state varchar(255) NOT NULL,
user_id int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY FKla4tbftd6lxqr0bql5w3ipfrx (user_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table address

LOCK TABLES address WRITE;
/*!40000 ALTER TABLE address DISABLE KEYS /;
/!40000 ALTER TABLE address ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table cart

DROP TABLE IF EXISTS cart;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE cart (
id int(11) NOT NULL AUTO_INCREMENT,
cart_lines int(11) DEFAULT NULL,
grand_total double DEFAULT NULL,
user_id int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY FKs0ufxli8yj4umuhu7y54gf07q (user_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table cart

LOCK TABLES cart WRITE;
/*!40000 ALTER TABLE cart DISABLE KEYS /;
/!40000 ALTER TABLE cart ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table cart_line

DROP TABLE IF EXISTS cart_line;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE cart_line (
id int(11) NOT NULL AUTO_INCREMENT,
buying_price double DEFAULT NULL,
cart_id int(11) DEFAULT NULL,
is_available bit(1) DEFAULT NULL,
product_count int(11) DEFAULT NULL,
total double DEFAULT NULL,
product_id int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY FK6fx7athvka6ywajy8bsqc0mdh (product_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table cart_line

LOCK TABLES cart_line WRITE;
/*!40000 ALTER TABLE cart_line DISABLE KEYS /;
/!40000 ALTER TABLE cart_line ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table category

DROP TABLE IF EXISTS category;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE category (
id int(11) NOT NULL AUTO_INCREMENT,
is_active bit(1) DEFAULT NULL,
description varchar(255) DEFAULT NULL,
image_url varchar(255) DEFAULT NULL,
name varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table category

LOCK TABLES category WRITE;
/*!40000 ALTER TABLE category DISABLE KEYS /;
INSERT INTO category VALUES (1,_binary '�','Mobile Category',NULL,'Mobile');
/!40000 ALTER TABLE category ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table product

DROP TABLE IF EXISTS product;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE product (
id int(11) NOT NULL AUTO_INCREMENT,
is_active bit(1) DEFAULT NULL,
brand varchar(255) NOT NULL,
category_id int(11) DEFAULT NULL,
code varchar(255) DEFAULT NULL,
description varchar(255) NOT NULL,
name varchar(255) NOT NULL,
purchases int(11) DEFAULT NULL,
quantity int(11) DEFAULT NULL,
supplier_id int(11) DEFAULT NULL,
unit_price double DEFAULT NULL,
views int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table product

LOCK TABLES product WRITE;
/*!40000 ALTER TABLE product DISABLE KEYS /;
INSERT INTO product VALUES (1,_binary '\0','Samsung',1,'PROE9DE4EA3F2','test','Samsung',0,100,1,10000,1);
/!40000 ALTER TABLE product ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table user_detail

DROP TABLE IF EXISTS user_detail;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!50503 SET character_set_client = utf8mb4 /;
CREATE TABLE user_detail (
id int(11) NOT NULL AUTO_INCREMENT,
contact_number varchar(255) NOT NULL,
email varchar(255) DEFAULT NULL,
enabled bit(1) DEFAULT NULL,
first_name varchar(255) NOT NULL,
last_name varchar(255) NOT NULL,
password varchar(255) NOT NULL,
role varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table user_detail

LOCK TABLES user_detail WRITE;
/*!40000 ALTER TABLE user_detail DISABLE KEYS /;
INSERT INTO user_detail VALUES (1,'9876543210','[email protected]',_binary '�','admin','admin','$2a$10$6UVHQoHhpoYZxBB.k9r.deSLTT0RD1Yk8GdggRywGw0Snr8syRDtG','ADMIN');
/!40000 ALTER TABLE user_detail ENABLE KEYS /;
UNLOCK TABLES;
/!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE /;
/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
/!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-11-27 11:12:06

from online-shopping.