Super Extra Data

-- categories
INSERT INTO Categories (category_id, category_name, description) VALUES
('APP110', 'Apparel', 'Clothing items including shirts, pants, and dresses'),
('SHO221', 'Footwear', 'Shoes, sandals, and boots for all ages'),
('JEW333', 'Jewelry & Accessories', 'Rings, necklaces, bracelets, and watches'),
('HEA445', 'Health & Wellness', 'Vitamins, supplements, and fitness products'),
('PHA556', 'Pharmaceuticals', 'Medicines, first aid kits, and medical supplies'),
('HOM667', 'Home Appliances', 'Microwaves, refrigerators, and washing machines'),
('FUR778', 'Furniture', 'Tables, chairs, sofas, and wardrobes'),
('BED889', 'Bedding & Linens', 'Bedsheets, blankets, pillows, and mattress covers'),
('KIT990', 'Kitchenware', 'Cookware, cutlery, and kitchen utensils'),
('DEC105', 'Home Decor', 'Vases, wall art, candles, and decorative items'),
('STU216', 'School Supplies', 'Notebooks, pens, backpacks, and calculators'),
('OFF328', 'Office Supplies', 'Printers, paper, stationery, and organizers'),
('ENT439', 'Entertainment', 'Board games, puzzles, books, and comics'),
('TOY550', 'Toys & Games', 'Stuffed animals, action figures, and educational toys'),
('SPO661', 'Sports & Outdoor', 'Camping gear, bicycles, and fitness equipment'),
('AUT772', 'Automotive', 'Car accessories, lubricants, and maintenance tools'),
('GAD883', 'Gadgets', 'Smartwatches, power banks, and Bluetooth speakers'),
('CAM994', 'Cameras & Photography', 'DSLRs, tripods, and camera accessories'),
('MUS105', 'Musical Instruments', 'Guitars, pianos, and DJ equipment'),
('ART216', 'Art & Crafts', 'Paints, brushes, sketchbooks, and DIY supplies'),
('GAR327', 'Garden & Outdoors', 'Seeds, pots, gardening tools, and patio furniture'),
('TRA438', 'Travel & Luggage', 'Suitcases, travel bags, and accessories'),
('SAF549', 'Safety & Security', 'Locks, surveillance cameras, and alarms'),
('COS650', 'Cosmetics & Beauty', 'Makeup, perfumes, and skincare products'),
('LUX761', 'Luxury Items', 'Designer handbags, high-end watches, and fine jewelry'),
('WAT872', 'Watches', 'Luxury, sports, and casual wristwatches'),
('GIF983', 'Gifts & Souvenirs', 'Greeting cards, customized gifts, and memorabilia'),
('BAB107', 'Maternity & Baby Care', 'Pregnancy essentials and baby gear'),
('DIY218', 'DIY & Home Improvement', 'Power tools, hardware, and repair kits'),
('HOB329', 'Hobbies & Collectibles', 'Model kits, trading cards, and memorabilia');

-- customers
-- Customers.csv
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Customers.csv'
INTO TABLE Customers
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(@customer_id, @gender, @phone_number, @full_name, @location, @email)
SET location = ST_GeomFromText(@location),
customer_id = @customer_id,
gender = @gender,
phone_number = @phone_number,
full_name = @full_name,
email = @email;

-- dong nay can de them index vào cot location
ALTER TABLE Customers MODIFY COLUMN location POINT NOT NULL SRID 0;

-- orderdetails
-- OrderDetails.csv
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/OrderDetails.csv'
INTO TABLE OrderDetails
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

-- orders
-- Orders.csv
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Orders.csv'
INTO TABLE Orders
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

-- payments
-- Payments.csv
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Payments.csv'
INTO TABLE Payments
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

-- products
-- Products.csv
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Products.csv'
INTO TABLE Products
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

-- suppliers
-- Suppliers.csv
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Suppliers.csv'
INTO TABLE Suppliers
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;