Unable to find out the database in the code

[KPR111]

any one please create the all tables for the database and upload in the project

[atanu20]

Message me on LinkedIn https://www.linkedin.com/in/atanu20

…

On Mon, 17 Oct, 2022, 11:18 pm KPR111, ***@***.***> wrote: any one please create the all tables for the database and upload in the project — Reply to this email directly, view it on GitHub <#1>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/APUG4HALXZCP3YZ66N4F623WDWGNJANCNFSM6AAAAAARHJU6MU> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[VijayJr02]

create database ecom_react;
use ecom_react;
CREATE TABLE products (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
description TEXT,
price DECIMAL(10, 2) NOT NULL,
image_url VARCHAR(255), -- If you have images for products
stock INT DEFAULT 0
);

CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(255) NOT NULL,
email VARCHAR(255) UNIQUE NOT NULL,
password VARCHAR(255) NOT NULL
);

CREATE TABLE user_data (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
email VARCHAR(255),
phone VARCHAR(20),
address TEXT,
user_id INT,
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

CREATE TABLE orders (
id INT AUTO_INCREMENT PRIMARY KEY,
userid INT,
totalprice DECIMAL(10, 2),
orderstatus VARCHAR(50),
paymentmode VARCHAR(50),
paymentid VARCHAR(255),
FOREIGN KEY (userid) REFERENCES users(id) ON DELETE CASCADE
);

CREATE TABLE orderitems (
id INT AUTO_INCREMENT PRIMARY KEY,
orderid INT,
productid INT,
productqty INT,
productprice DECIMAL(10, 2),
FOREIGN KEY (orderid) REFERENCES orders(id) ON DELETE CASCADE,
FOREIGN KEY (productid) REFERENCES products(id) ON DELETE CASCADE
);

INSERT INTO products (id, name, description, price, stock, image_url) VALUES
(1, 'Snake Plant', 'Also known as "Mother-in-law's Tongue," this plant has tall, upright leaves with green bands. It's popular for its air-purifying qualities and easy maintenance, thriving in low light and requiring minimal watering.', 400.00, 10, 'img/snake_plant.png'),
(2, 'Nerve Plant', 'This plant has small, dark green leaves with prominent white or pink veins. It prefers indirect light and requires regular watering, as it enjoys a humid environment.', 200.00, 10, 'img/nerve_plant.png'),
(3, 'Spider Plant', 'This plant has long, arching leaves with green and white stripes. Known for its air-purifying properties, it grows quickly and can tolerate various light conditions, though it prefers indirect light.', 300.00, 10, 'img/spider_plant.png'),
(4, 'Rubber Plant', 'This plant features large, glossy, dark green leaves. It thrives in bright, indirect light and needs occasional watering, making it a popular indoor plant choice for improving air quality.', 450.00, 10, 'img/rubber_plant.png'),
(5, 'Golden Pothos / Money Plant', 'Known as the Money Plant, this plant has heart-shaped, green leaves with yellow variegation. It's resilient and grows well in low light, making it a great beginner-friendly indoor plant.', 350.00, 10, 'img/golden_pothos.png'),
(6, 'Jade Plant', 'The Jade Plant has thick, fleshy, oval-shaped leaves. It's a succulent that stores water in its leaves, requiring minimal watering and doing well in bright, indirect light.', 500.00, 10, 'img/jade_plant.png'),
(7, 'Anthurium', 'This plant has glossy green leaves and vibrant red or pink spathes (flower-like structures). It does best in bright, indirect light and prefers a humid environment.', 600.00, 10, 'img/anthurium.png'),
(8, 'Golden Money Plant', 'This variety of the Money Plant has bright, lime-green leaves. Like other pothos varieties, it’s easy to care for and can thrive in low to moderate light.', 300.00, 10, 'img/golden_money_plant.png'),
(9, 'Dracaena', 'This plant has long, green, lance-shaped leaves. Dracaena varieties are popular indoor plants that can tolerate low light and require moderate watering.', 550.00, 10, 'img/dracaena.png');

SELECT * FROM products;