-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathSkinGlowDB.sql
165 lines (136 loc) · 8.5 KB
/
SkinGlowDB.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 21, 2022 at 01:57 PM
-- Server version: 10.4.22-MariaDB
-- PHP Version: 8.1.2
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!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 */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `SkinGlowDB`
--
-- --------------------------------------------------------
--
-- Table structure for table `cart`
--
CREATE TABLE `cart` (
`session_uniqeID` varchar(255) NOT NULL,
`product_id` int(11) NOT NULL,
`id` int(100) NOT NULL,
`user_id` int(100) NOT NULL,
`itemname` varchar(255) NOT NULL,
`quantity` int(11) NOT NULL,
`price` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `contact`
--
CREATE TABLE `contact` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`message` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE `products` (
`id` int(11) NOT NULL,
`pname` varchar(255) NOT NULL,
`psize` varchar(255) NOT NULL,
`price` double(10,0) NOT NULL,
`pdesc` text NOT NULL,
`img` text NOT NULL,
`stock` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `products`
--
INSERT INTO `products` (`id`, `pname`, `psize`, `price`, `pdesc`, `img`, `stock`) VALUES
(1, 'Beauty set', '1.7 oz, 0.53 oz, 0.3 oz', 180, 'The beauty set consist of three products.A Facial Cream(1.1 oz) combines clean, weightless moisturizing formula of Resveratrol and Hyaluronic Acid that will help in diminishing existing skin damage, minimizing further oxidative skin damage, maintaining skin hydration & firmness, and brightening & balancing skin tone. An Eye Cream(0.53 oz) is rich in fermentation, peptides, and ceramides; this non-greasy eye treatment helps to firm, moisturize, and build elasticity for a youthful and rested look. A lip balm(0.3 oz )that Soothe and soften dry, chapped lips. Fortified with a nourishing cocktail of Honey, Beeswax and Colloidal Oatmeal, the concentrated treatment attracts and locks in moisture, whilst conditioning and restoring comfortable, deeply hydrated lips.', '1.jpg', 100),
(2, 'Pure Rosehip Seed Oil\n', '30 ml\r\n', 42, 'A rich, amber colored oil from the ripened fruit of the rose known as hips. Contains natural Retinol Acid (Vitamin A) and is well sought after for helping to replenish and restore mature or sun-exposed skin.\n', '2.jpg', 100),
(3, 'Brightening Facial Scrub\n', '118 ml\r\n', 30, 'Sea kelp super-nutrients soften and detox while lemon peel and French green clay cleanse. Madonna lily brings the brightness to round out this refreshing facial scrub.\n', '3.jpg', 100),
(4, 'Glycolic Acid 7% Toning Solution\n', ' 7 fl oz', 130, ' A Glycolic Acid 7% Toning Solution. The AHA solution works to gently exfoliate the surface of the skin, helping to combat the dead skin cell build up that can contribute to dullness, textural irregularities and congestion. pH balanced for optimal efficacy, the glycolic acid toner is infused with tasmanian pepperberry and aloe vera to help soothe the skin, alongside ginseng root to promote a radiant finish. Incorporate into your skincare routine to support a glowing, smooth and refined-looking complexion.', '4.jpg', 100),
(5, 'Night Set\n', '6.42 fl oz, 6.42 fl oz, 4 fl oz\n', 250, 'A purifying foaming face cleanser deeply cleans pores, drawing out dirt, oil, impurities and build up in the skin with its hero blend of moringa, papaya enzyme, green clay and sodium PCA. The soap-free, oil-free and pH-balanced formula ensures skin is gently cleaned and exfoliated, without over-stripping, leaving your complexion feeling supple and refreshed. Vitamin C brightening serum helps to boost radiance, even out skin tone, and reduce the appearance of pigmentation. A moisturizing face cream that is non-greasy, light weighted with Avocado Oil and Vitamins E, B5 & B3 is clinically tested to fully restore the skin\'s moisture barrier in 1 week.\n', '55.jpg', 100),
(6, 'Anti-Wrinkle Face Cream', '1.7 oz', 49, 'Eucerin®️ Q10 Anti-Wrinkle Face Cream is an anti-wrinkle moisturizing cream made for dry, sensitive skin. It is specially formulated to be non-irritating and to gently reduce the look of wrinkles and the signs of aging. Reduces the look of fine lines and wrinkles in as little as 5 weeks, Firms and moisturizes for softer, smoother looking skin, Can be used alone or under make-up, Fragrance-free, alcohol-free, non-comedogenic.', '6.jpg', 100),
(7, 'Rose Whipped Shea Body Butter', '15.0 oz', 45, 'Rose Whipped Shea Body Butter is the perfect skin-treat after bath or as a skin-refresher. The luscious scent of the rose will leave your skin feeling soft, hydrated and smelling amazing. Moroccan Argan Oil helps to improve skin elasticity, balance and help hydrate dry skin with lipids, fatty acids and vitamin E. Rosehip Oil is known to help visibly refine skin\'s texture and promote a radiant glow. Natural Shea Butter is known to deeply moisturize, nourish and soften dry, skin while helping to promote elasticity', '7.jpg', 100),
(8, 'Glow bath set', '100ml, 150 ml, 250ml, 30 ml', 380, 'Bath Salts (100ml) which is a mineral rich Himalayan Pink Bath Salt is as pristine and natural as originally deposited by the ancient primal ocean. Himalayan bath soaks have been used to purify, relax, rejuvenate, and restore one\'s balance. It\'s light sesame formula glides on easily to moisturize dry skin. A body oil (150 ml) It\'s so sheer it vanishes into shower-damp skin leaving it soft and silky, with a radiant, healthy glow. No moisturizer can touch this experience. Coconut Body Scrub(250ml) to exfoliate and moisturize your skin. This reparative scrub gently exfoliates the skin to reveal your natural, healthy glow. Formulated with Certified Organic Coconut Oil and other good-for-you ingredients, your skin will be left feeling silky smooth and smelling like paradise. Coconut is rich in fatty acids, this ingredient deeply hydrates skin while keeping surface lipids intact for lasting hydration. A hand cream(30 ml) that is a rich, deeply moisturizing that creates a glove-like protective barrier to seal in moisture, repair cracks and soften overall texture.', '8.jpg', 100),
(9, 'Collagen Serum', '30 ml', 70, 'Spurs on topical collagen levels for younger, fuller and firmer skin. Rejuvenates skin from within with a concentrated combination of hydration and collagen. Adds essential hydration, smoothing out skin texture and adding luminosity to the skin.', '9.jpg', 100);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL,
`uname` varchar(255) NOT NULL,
`fname` varchar(255) NOT NULL,
`lname` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`address1` varchar(255) NOT NULL,
`postcode` varchar(255) NOT NULL,
`bday` date NOT NULL,
`country` varchar(255) NOT NULL,
`gender` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`user_role` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `products`
--
ALTER TABLE `products`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1020;
COMMIT;
/*!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 */;