Repository navigation
Expand file tree
/
Copy pathdatabase.sql
More file actions
289 lines (240 loc) · 12.9 KB
/
Copy pathdatabase.sql
File metadata and controls
289 lines (240 loc) · 12.9 KB
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
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Nov 28, 2024 at 05:01 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4
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: `WebDev287`
--
-- --------------------------------------------------------
--
-- Table structure for table `bookings`
--
CREATE TABLE `bookings` (
`id` int(50) NOT NULL,
`clientID` double NOT NULL,
`service` varchar(100) NOT NULL,
`status` varchar(50) NOT NULL,
`payment` varchar(50) NOT NULL,
`price` varchar(150) NOT NULL,
`date` varchar(150) NOT NULL,
`time` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `bookings`
--
INSERT INTO `bookings` (`id`, `clientID`, `service`, `status`, `payment`, `price`, `date`, `time`) VALUES
(1, 2, 'Cleaning with Blastoise', 'Pending', 'Unpaid', '39.99', 'Mar. 28, 2024', '4:00 PM'),
(2, 2, 'Primeapes 1h Boxing Lesson', 'Pending', 'Unpaid', '59.99', 'Dec. 30, 2024', '12:00 PM'),
(3, 5, 'Sylveons Medical Care', 'Complete', 'Paid', '79.99', 'Oct. 29, 2024', '1:00 PM'),
(4, 6, 'Fishing with Cramorant', 'Cancelled', 'Unpaid', '39.99', 'Oct. 28, 2024', '3:00 PM'),
(5, 2, 'Roasting Smores with Cyndaquil', 'Pending', 'Unpaid', '29.99', 'Dec. 12, 2024', '3:00 PM'),
(6, 7, 'Playing with Togepi', 'Complete', 'Paid', '49.99', 'Oct. 22, 2024', '4:00 PM'),
(7, 8, 'Jigglypuff Singing a Lullaby', 'Complete', 'Unpaid', '39.99', 'Nov. 16, 2024', '10:00 AM'),
(8, 9, 'Bring Mr. Mime to your Party', 'Pending', 'Unpaid', '79.99', 'Dec. 30, 2024', '9:00 AM'),
(9, 10, 'Cleaning with Blastoise', 'Cancelled', 'Unpaid', '39.99', 'Oct. 10, 2024', '2:00 PM'),
(10, 12, 'Fishing with Cramorant', 'Complete', 'Paid', '39.99', 'Oct. 2, 2024', '2:00 PM'),
(11, 11, 'Primeapes 1h Boxing Lesson', 'Complete', 'Paid', '59.99', 'Oct. 8, 2024', '11:00 AM'),
(12, 13, 'Roasting Smores with Cyndaquil', 'Complete', 'Paid', '29.99', 'Oct. 1, 2024', '12:00 PM');
-- --------------------------------------------------------
--
-- Table structure for table `contact`
--
CREATE TABLE `contact` (
`id` int(50) NOT NULL,
`description` varchar(500) NOT NULL,
`email` varchar(50) NOT NULL,
`phone` varchar(50) NOT NULL,
`address` varchar(50) NOT NULL,
`city` varchar(50) NOT NULL,
`state` varchar(50) NOT NULL,
`zipcode` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `contact`
--
INSERT INTO `contact` (`id`, `description`, `email`, `phone`, `address`, `city`, `state`, `zipcode`) VALUES
(1, 'We\'d love to hear from you! Whether you have questions about our Pokémon services, need assistance with a booking, or want to share your experience with Pokerent, our team is here to help. Reach out, and let\'s make your Pokémon adventure unforgettable! ', 'pokerent@gmail.com', '(514) 123 - 4567', '123 Made-Up Road', 'Montreal', 'Quebec', 'H1A 123');
-- --------------------------------------------------------
--
-- Table structure for table `footer`
--
CREATE TABLE `footer` (
`id` int(50) NOT NULL,
`aboutUs` varchar(500) NOT NULL,
`facebook` varchar(50) NOT NULL,
`instagram` varchar(50) NOT NULL,
`twitter` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `footer`
--
INSERT INTO `footer` (`id`, `aboutUs`, `facebook`, `instagram`, `twitter`) VALUES
(1, 'PokéRent brings the magic of Pokémon to everyday life. From cleaning and healing to unforgettable events, our Pokémon partners are ready to lend a hand (or paw)! Rent your ideal Pokémon for any occasion and experience the wonder firsthand.', 'https://www.facebook.com', 'https://www.instagram.com', 'https://x.com/?lang=en');
-- --------------------------------------------------------
--
-- Table structure for table `homepage`
--
CREATE TABLE `homepage` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`logo` varchar(150) NOT NULL,
`welcome` varchar(150) NOT NULL,
`hook` varchar(500) NOT NULL,
`why` varchar(500) NOT NULL,
`reason1` varchar(500) NOT NULL,
`description1` varchar(500) NOT NULL,
`reason2` varchar(500) NOT NULL,
`description2` varchar(500) NOT NULL,
`reason3` varchar(500) NOT NULL,
`description3` varchar(500) NOT NULL,
`reason4` varchar(500) NOT NULL,
`description4` varchar(500) NOT NULL,
`backgroundImg` varchar(500) NOT NULL,
`slide1` varchar(500) NOT NULL,
`slide2` varchar(500) NOT NULL,
`slide3` varchar(500) NOT NULL,
`slide4` varchar(500) NOT NULL,
`caption1` varchar(500) NOT NULL,
`caption2` varchar(500) NOT NULL,
`caption3` varchar(500) NOT NULL,
`caption4` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `homepage`
--
INSERT INTO `homepage` (`id`, `name`, `logo`, `welcome`, `hook`, `why`, `reason1`, `description1`, `reason2`, `description2`, `reason3`, `description3`, `reason4`, `description4`, `backgroundImg`, `slide1`, `slide2`, `slide3`, `slide4`, `caption1`, `caption2`, `caption3`, `caption4`) VALUES
(1, 'PokéRent ', '/images/logo.png', 'Welcome to PokéRent!', 'Discover the magic of Pokémon-assisted services! From cleaning to healing, our friendly Pokémon are here to help you with a variety of tasks. Rent a Pokémon for your next project and experience the ease and efficiency of working alongside these amazing creatures. Let\'s make your life easier—one Pokémon at a time!', 'Why Choose Our PokéService Rentals?', 'Expert Assistance', 'Our Pokémon are specially trained to assist with various tasks, ensuring high-quality service every time. Whether it\'s cleaning or healing, our Pokémon have the skills you need!', 'Reliable and Trustworthy', 'We prioritize safety and trust. Each Pokémon in our service has been vetted and trained, so you can rest assured that they will handle your needs with care and professionalism.', 'Affordable Rentals', 'Enjoy competitive pricing on all our Pokémon rentals. We believe everyone should experience the magic of Pokémon assistance without breaking the bank!', 'Flexible Options', 'Whether you need a Pokémon for a one-time service or ongoing assistance, we offer flexible rental options to fit your needs. Choose the service that works best for you!', '/images/background.jpg', '/images/blastoise-cleaning.jpg', '/images/cramorant-fishing.webp', '/images/togepi-playing.avif', '/images/jigglipuff-singing.webp', 'Your Personal Car Cleaning Champion! Let our water-blasting Pokémon handle the tough grime while you sit back and relax.', 'Casting Lines with Cramorant! Experience a unique fishing adventure as our skilled Pokémon swoops in to catch your dinner—just watch out for the occasional snack!', 'Playtime with Togepi! Experience joy and laughter as this little bundle of happiness brings fun and smiles to your day. Let\'s make magical memories together!', 'Jigglypuff\'s Serenade! Let the enchanting melodies of Jigglypuff soothe your soul as it fills the air with magical tunes. Get ready to sing along and drift into dreamland!');
-- --------------------------------------------------------
--
-- Table structure for table `services`
--
CREATE TABLE `services` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`popular` tinyint(1) NOT NULL,
`price` varchar(150) NOT NULL,
`description` varchar(500) NOT NULL,
`image` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `services`
--
INSERT INTO `services` (`id`, `name`, `popular`, `price`, `description`, `image`) VALUES
(1, 'Cleaning with Blastoise', 1, '39.99', 'Let Blastoise take care of your cleaning needs with its powerful water jets, ensuring a spotless home while creating a fun and engaging atmosphere. Experience a clean like never before, as Blastoise tackles dirt and grime with ease!', '/images/9.png'),
(2, 'Primeapes 1h Boxing Lesson', 0, '59.99', 'Join Primeape for an exhilarating one-hour boxing lesson, tailored for all skill levels. Whether you are a beginner looking to learn the basics or an experienced fighter wanting to refine your techniques, Primeapes energetic training will keep you motivated!', '/images/57.png'),
(3, 'Sylveons Medical Care', 1, '79.99', 'Experience compassionate and gentle medical care with Sylveons nurturing approach. Ideal for those seeking health services, Sylveon ensures a comfortable environment that promotes healing and well-being.', '/images/700.png'),
(4, 'Fishing with Cramorant', 0, '39.99', 'Join Cramorant for an exciting fishing adventure, where you will explore the best fishing spots while learning valuable techniques. Enjoy a day out in nature as Cramorant helps you catch unique fish and creates unforgettable memories!', '/images/845.png'),
(5, 'Roasting Smores with Cyndaquil', 0, '29.99', 'Gather around the campfire with Cyndaquil to roast delicious smores in a cozy setting. This delightful experience is perfect for families and friends looking to bond over sweet treats and stories while enjoying the warmth of the fire.', '/images/155.png'),
(6, 'Playing with Togepi', 0, '49.99', 'Enjoy a playful afternoon with Togepi, known for its cheerful spirit and playful antics. This service is perfect for children and families looking to have fun while making new friends in a safe and joyful environment.', '/images/175.png'),
(7, 'Jigglypuff Singing a Lullaby', 0, '39.99', 'Unwind and relax as Jigglypuff serenades you with its soothing lullabies. This calming experience is perfect for those seeking a peaceful atmosphere, making it an excellent addition to your evening routine for stress relief.', '/images/39.png'),
(8, 'Bring Mr. Mime to your Party', 1, '79.99', 'Make your party unforgettable by inviting Mr. Mime! Known for its entertaining antics and magical performances, Mr. Mime will delight guests of all ages, ensuring your event is filled with laughter and joy.', '/images/122.png');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(10) NOT NULL,
`admin` tinyint(1) NOT NULL,
`first` varchar(50) NOT NULL,
`last` varchar(50) NOT NULL,
`email` varchar(100) NOT NULL,
`password` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `admin`, `first`, `last`, `email`, `password`) VALUES
(1, 1, 'Matteo', 'Butera', 'matteo@email.com', 'admin'),
(2, 0, 'John', 'Doe', 'john.doe@gmail.com', 'client123'),
(3, 0, 'Alice', 'Brown', 'alice.brown@gmail.com', 'client123'),
(4, 0, 'Sarah', 'Knowles', 'sarah.knowles@gmail.com', 'client123'),
(5, 0, 'Michael', 'Turner', 'michael.turner@gmail.com', 'client123'),
(6, 0, 'Rebecca', 'Lee', 'rebecca.lee@gmail.com', 'client123'),
(7, 0, 'Chris', 'Martin', 'chris.martin@gmail.com', 'client123'),
(8, 0, 'Lily', 'West', 'lily.west@gmail.com', 'client123'),
(9, 0, 'Jessica', 'Adams', 'jessica.adams@gmail.com', 'client123'),
(10, 0, 'Brad', 'Smith', 'brad.smith@gmail.com', 'client123'),
(11, 0, 'Theo', 'Manuel', 'theo.manuel@gmail.com', 'client123'),
(12, 0, 'Evan', 'Scott', 'evan.scott@gmail.com', 'client123'),
(13, 0, 'Jane', 'Doe', 'jane.doe@gmail.com', 'client123');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `footer`
--
ALTER TABLE `footer`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `homepage`
--
ALTER TABLE `homepage`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `services`
--
ALTER TABLE `services`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `footer`
--
ALTER TABLE `footer`
MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `homepage`
--
ALTER TABLE `homepage`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
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 */;