-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDatabase_Setup.sql
More file actions
331 lines (327 loc) · 108 KB
/
Database_Setup.sql
File metadata and controls
331 lines (327 loc) · 108 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
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
USE [E:\DBMS\RESTAURENTMANAGEMENTSYSTEM_TESTV3\RESTMANN2.MDF]
GO
/****** Object: Table [dbo].[customers] Script Date: 2/12/2026 9:12:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[customers](
[id] [int] IDENTITY(1,1) NOT NULL,
[customer_id] [int] NULL,
[total_price] [float] NULL,
[date] [date] NULL,
[amount] [float] NULL,
[change] [float] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[orders] Script Date: 2/12/2026 9:12:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[orders](
[id] [int] IDENTITY(1,1) NOT NULL,
[customer_id] [int] NULL,
[prod_id] [varchar](50) NOT NULL,
[prod_name] [varchar](max) NULL,
[prod_type] [varchar](max) NULL,
[prod_price] [float] NULL,
[order_date] [date] NULL,
[delete_order] [date] NULL,
[qty] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[products] Script Date: 2/12/2026 9:12:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[products](
[id] [int] IDENTITY(1,1) NOT NULL,
[prod_id] [varchar](50) NOT NULL,
[prod_name] [varchar](max) NULL,
[prod_type] [varchar](max) NULL,
[prod_stock] [int] NULL,
[prod_price] [float] NULL,
[prod_status] [varchar](max) NULL,
[prod_image] [varchar](max) NULL,
[date_insert] [date] NULL,
[date_update] [date] NULL,
[date_delete] [date] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[users] Script Date: 2/12/2026 9:12:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users](
[id] [int] IDENTITY(1,1) NOT NULL,
[username] [varchar](max) NULL,
[password] [varchar](max) NULL,
[profile_image] [varchar](max) NULL,
[role] [varchar](max) NULL,
[status] [varchar](max) NULL,
[date_reg] [date] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[customers] ON
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (1, 1, 28007928, CAST(N'2025-11-15' AS Date), 28007950, 22)
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (2, 2, 4999995, CAST(N'2025-11-15' AS Date), 4999995, 0)
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (3, 3, 4999995, CAST(N'2025-11-15' AS Date), 5000000, 5)
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (4, 4, 9, CAST(N'2025-11-15' AS Date), 10, 0)
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (5, 5, 9, CAST(N'2025-11-15' AS Date), 10, 1)
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (6, 6, 200, CAST(N'2025-11-15' AS Date), 500, 300)
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (7, 7, 200, CAST(N'2025-11-15' AS Date), 500, 300)
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (8, 8, 18, CAST(N'2025-11-15' AS Date), 50, 32)
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (9, 9, 2340, CAST(N'2025-11-15' AS Date), 3000, 660)
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (10, 10, 60, CAST(N'2025-11-15' AS Date), 100, 40)
INSERT [dbo].[customers] ([id], [customer_id], [total_price], [date], [amount], [change]) VALUES (11, 11, 100, CAST(N'2025-11-15' AS Date), 100, 0)
SET IDENTITY_INSERT [dbo].[customers] OFF
GO
SET IDENTITY_INSERT [dbo].[orders] ON
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (1, 1, N'999', N'Car', N'Meal', 11999988, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (2, 2, N'999', N'Car', N'Meal', 4999995, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (3, 1, N'999', N'Car', N'Meal', 3999996, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (4, 1, N'999', N'Car', N'Meal', 999999, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (5, 1, N'999', N'Car', N'Meal', 999999, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (6, 1, N'999', N'Car', N'Meal', 999999, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (7, 1, N'999', N'Car', N'Meal', 999999, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (8, 1, N'999', N'Car', N'Meal', 999999, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (9, 1, N'999', N'Car', N'Meal', 999999, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (10, 1, N'999', N'Car', N'Meal', 999999, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (11, 1, N'999', N'Car', N'Meal', 999999, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (12, 1, N'999', N'Car', N'Meal', 999999, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (13, 1, N'999', N'Car', N'Meal', 999999, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (14, 1, N'999', N'Car', N'Meal', 1999998, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (15, 1, N'cake111', N'cake', N'Meal', 200, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (16, 1, N'cake111', N'cake', N'Meal', 200, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (17, 1, N'cake111', N'cake', N'Meal', 200, CAST(N'2025-11-14' AS Date), NULL, NULL)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (18, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (19, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (20, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (21, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (22, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (23, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (24, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (25, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (26, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (27, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (28, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (29, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (30, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (31, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (32, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (33, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (34, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (35, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (36, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (37, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (38, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (39, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (40, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (41, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (42, 1, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (43, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (44, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (45, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (46, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (47, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (48, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (49, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (50, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (51, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (52, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (53, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (54, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (55, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (56, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (57, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (58, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (59, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (60, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (61, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (62, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (63, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (64, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (65, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (66, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (67, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (68, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (69, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (70, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (71, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (72, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (73, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (74, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (75, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (76, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (77, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (78, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (79, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (80, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (81, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (82, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (83, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (84, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (85, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (86, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (87, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (88, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (89, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (90, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (91, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (92, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (93, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (94, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (95, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (96, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (97, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (98, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (99, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
GO
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (100, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (101, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (102, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (103, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (104, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (105, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (106, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (107, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (108, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (109, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (110, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (111, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (112, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (113, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (114, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (115, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (116, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (117, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-14' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (118, 1, N'pppp', N'pppp', N'Drinks', 9, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (119, 1, N'pppp', N'pppp', N'Drinks', 9, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (120, 1, N'pppp', N'pppp', N'Drinks', 9, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (121, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (122, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (123, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (124, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (125, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (126, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (127, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (128, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (129, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (130, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (131, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (132, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (133, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (134, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (135, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (136, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (137, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (138, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (139, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (140, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (141, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (142, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (143, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (144, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (145, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (146, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (147, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (148, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (149, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (150, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (151, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (152, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (153, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (154, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (155, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (156, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (157, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (158, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (159, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (160, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (161, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (162, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (163, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (164, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (165, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (166, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (167, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (168, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (169, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (170, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (171, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (172, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (173, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (174, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (175, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (176, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (177, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (178, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (179, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (180, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (181, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (182, 1, N'qqqqqqqqqqq', N'qqqqqqqqqqq', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (183, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (184, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (185, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (186, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (187, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (188, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (189, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (190, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (191, 1, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (192, 1, N'pppp', N'pppp', N'Drinks', 9, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (193, 4, N'pppp', N'pppp', N'Drinks', 9, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (194, 6, N'Kottu_01', N'Kottu', N'Meal', 200, CAST(N'2025-11-15' AS Date), NULL, 2)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (195, 8, N'pppp', N'pppp', N'Drinks', 18, CAST(N'2025-11-15' AS Date), NULL, 2)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (196, 9, N'pppp', N'pppp', N'Drinks', 18, CAST(N'2025-11-15' AS Date), NULL, 2)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (197, 9, N'pppp', N'pppp', N'Drinks', 18, CAST(N'2025-11-15' AS Date), NULL, 2)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (198, 9, N'pppp', N'pppp', N'Drinks', 18, CAST(N'2025-11-15' AS Date), NULL, 2)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (199, 9, N'pppp', N'pppp', N'Drinks', 18, CAST(N'2025-11-15' AS Date), NULL, 2)
GO
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (200, 9, N'pppp', N'pppp', N'Drinks', 18, CAST(N'2025-11-15' AS Date), NULL, 2)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (201, 9, N'rice_01', N'Fried Rice', N'Meal', 2250, CAST(N'2025-11-15' AS Date), NULL, 3)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (202, 10, N'cake111', N'cake', N'Meal', 50, CAST(N'2025-11-15' AS Date), NULL, 1)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (203, 10, N'Product 100', N'Chesee Kottu', N'Meal', 10, CAST(N'2025-11-15' AS Date), NULL, 2)
INSERT [dbo].[orders] ([id], [customer_id], [prod_id], [prod_name], [prod_type], [prod_price], [order_date], [delete_order], [qty]) VALUES (204, 11, N'Kottu_01', N'Kottu', N'Meal', 100, CAST(N'2025-11-15' AS Date), NULL, 1)
SET IDENTITY_INSERT [dbo].[orders] OFF
GO
SET IDENTITY_INSERT [dbo].[products] ON
INSERT [dbo].[products] ([id], [prod_id], [prod_name], [prod_type], [prod_stock], [prod_price], [prod_status], [prod_image], [date_insert], [date_update], [date_delete]) VALUES (1017, N'BRG_001', N'Chicken Whopper', N'Meal', 150, 15, N'Available', N'E:\DBMS\RestaurentManagementSystem_Test\Product_Directory\BRG_001.jpg', CAST(N'2025-11-15' AS Date), NULL, NULL)
INSERT [dbo].[products] ([id], [prod_id], [prod_name], [prod_type], [prod_stock], [prod_price], [prod_status], [prod_image], [date_insert], [date_update], [date_delete]) VALUES (1018, N'KOT_002', N'Dolphin Kottu', N'Meal', 45, 8.5, N'Available', N'E:\DBMS\RestaurentManagementSystem_Test\Product_Directory\KOT_002.jpg', CAST(N'2025-11-15' AS Date), NULL, NULL)
INSERT [dbo].[products] ([id], [prod_id], [prod_name], [prod_type], [prod_stock], [prod_price], [prod_status], [prod_image], [date_insert], [date_update], [date_delete]) VALUES (1019, N'DRK_005', N'Coca Cola (L)', N'Drinks', 500, 3, N'Available', N'E:\DBMS\RestaurentManagementSystem_Test\Product_Directory\DRK_005.jpg', CAST(N'2025-11-15' AS Date), NULL, NULL)
INSERT [dbo].[products] ([id], [prod_id], [prod_name], [prod_type], [prod_stock], [prod_price], [prod_status], [prod_image], [date_insert], [date_update], [date_delete]) VALUES (1020, N'RIC_003', N'Nasigoreng', N'Meal', 80, 12, N'Unavailable', N'E:\DBMS\RestaurentManagementSystem_Test\Product_Directory\RIC_003.jpg', CAST(N'2025-11-15' AS Date), NULL, NULL)
INSERT [dbo].[products] ([id], [prod_id], [prod_name], [prod_type], [prod_stock], [prod_price], [prod_status], [prod_image], [date_insert], [date_update], [date_delete]) VALUES (1021, N'SDR_001', N'French Fries', N'Meal', 200, 5, N'Available', N'E:\DBMS\RestaurentManagementSystem_Test\Product_Directory\SDR_001.jpg', CAST(N'2025-11-15' AS Date), NULL, NULL)
INSERT [dbo].[products] ([id], [prod_id], [prod_name], [prod_type], [prod_stock], [prod_price], [prod_status], [prod_image], [date_insert], [date_update], [date_delete]) VALUES (1022, N'DRK_006', N'Iced Coffee', N'Drinks', 120, 4.5, N'Available', N'E:\DBMS\RestaurentManagementSystem_Test\Product_Directory\DRK_006.jpg', CAST(N'2025-11-15' AS Date), NULL, NULL)
INSERT [dbo].[products] ([id], [prod_id], [prod_name], [prod_type], [prod_stock], [prod_price], [prod_status], [prod_image], [date_insert], [date_update], [date_delete]) VALUES (1023, N'BRG_002', N'Double Cheeseburger', N'Meal', 100, 18, N'Available', N'E:\DBMS\RestaurentManagementSystem_Test\Product_Directory\BRG_002.jpg', CAST(N'2025-11-15' AS Date), NULL, NULL)
INSERT [dbo].[products] ([id], [prod_id], [prod_name], [prod_type], [prod_stock], [prod_price], [prod_status], [prod_image], [date_insert], [date_update], [date_delete]) VALUES (1024, N'SUB_001', N'Spicy Submarine', N'Meal', 60, 10, N'Available', N'E:\DBMS\RestaurentManagementSystem_Test\Product_Directory\SUB_001.jpg', CAST(N'2025-11-15' AS Date), NULL, NULL)
INSERT [dbo].[products] ([id], [prod_id], [prod_name], [prod_type], [prod_stock], [prod_price], [prod_status], [prod_image], [date_insert], [date_update], [date_delete]) VALUES (1025, N'DRK_007', N'Mineral Water', N'Drinks', 100, 1, N'Available', N'E:\DBMS\RestaurentManagementSystem_Test\Product_Directory\DRK_007.jpg', CAST(N'2025-11-15' AS Date), NULL, NULL)
INSERT [dbo].[products] ([id], [prod_id], [prod_name], [prod_type], [prod_stock], [prod_price], [prod_status], [prod_image], [date_insert], [date_update], [date_delete]) VALUES (1026, N'KOT_003', N'Cheese Kottu (L)', N'Meal', 30, 14, N'Available', N'E:\DBMS\RestaurentManagementSystem_Test\Product_Directory\KOT_003.jpg', CAST(N'2025-11-15' AS Date), NULL, NULL)
SET IDENTITY_INSERT [dbo].[products] OFF
GO
SET IDENTITY_INSERT [dbo].[users] ON
INSERT [dbo].[users] ([id], [username], [password], [profile_image], [role], [status], [date_reg]) VALUES (1, N'admin', N'admin', N'E:\DBMS\RestaurentManagementSystem_Test\User_Directory\admin.jpg', N'Admin', N'Active', CAST(N'2025-11-11' AS Date))
INSERT [dbo].[users] ([id], [username], [password], [profile_image], [role], [status], [date_reg]) VALUES (2, N'cashier2', N'cashier2', N'E:\DBMS\RestaurentManagementSystem_Test\User_Directory\cashier2.jpg', N'Cashier', N'Approval', CAST(N'2025-11-11' AS Date))
INSERT [dbo].[users] ([id], [username], [password], [profile_image], [role], [status], [date_reg]) VALUES (6, N'Thilina', N'Thilina', N'E:\DBMS\RestaurentManagementSystem_Test\User_Directory\Thilina.jpg', N'Admin', N'Active', CAST(N'2025-11-12' AS Date))
INSERT [dbo].[users] ([id], [username], [password], [profile_image], [role], [status], [date_reg]) VALUES (7, N'phantom', N'phantom', N'E:\DBMS\RestaurentManagementSystem_Test\User_Directory\phantom.jpg', N'Admin', N'Approval', CAST(N'2025-11-12' AS Date))
INSERT [dbo].[users] ([id], [username], [password], [profile_image], [role], [status], [date_reg]) VALUES (9, N'cashier', N'cashier', N'E:\DBMS\RestaurentManagementSystem_Test\User_Directory\cashier.jpg', N'Cashier', N'Active', CAST(N'2025-11-14' AS Date))
SET IDENTITY_INSERT [dbo].[users] OFF
GO