-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathstoredatabase.sql
259 lines (251 loc) · 43.5 KB
/
storedatabase.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
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
USE [shop-store-system]
GO
/****** Object: Table [dbo].[table_categories] Script Date: 18.1.2021 г. 19:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table_categories](
[id] [int] IDENTITY(1,1) NOT NULL,
[title] [varchar](50) NULL,
[description] [text] NULL,
[added_date] [datetime] NULL,
[added_by] [int] NULL,
[added_by_name] [varchar](50) NULL,
CONSTRAINT [PK_table_categories] 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].[table_dealer_customer] Script Date: 18.1.2021 г. 19:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table_dealer_customer](
[id] [int] IDENTITY(1,1) NOT NULL,
[type] [varchar](50) NULL,
[name] [varchar](150) NULL,
[email] [varchar](150) NULL,
[contact] [varchar](15) NULL,
[address] [text] NULL,
[added_date] [datetime] NULL,
[added_by] [int] NULL,
[added_by_name] [varchar](50) NULL,
CONSTRAINT [PK_table_dealer_customer] 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].[table_logistic] Script Date: 18.1.2021 г. 19:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table_logistic](
[id] [int] IDENTITY(1,1) NOT NULL,
[employee] [varchar](50) NULL,
[first_name_employee] [varchar](50) NULL,
[last_name_employee] [varchar](50) NULL,
[address] [varchar](50) NULL,
[contact] [varchar](50) NULL,
[date] [varchar](50) NULL,
[description] [text] NULL,
[price] [decimal](18, 2) NULL,
[added_date] [datetime] NULL,
[added_by] [int] NULL,
[added_by_name] [varchar](50) NULL,
CONSTRAINT [PK_table_logistic] 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].[table_logistic_archive] Script Date: 18.1.2021 г. 19:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table_logistic_archive](
[id] [int] IDENTITY(1,1) NOT NULL,
[employee] [varchar](50) NULL,
[first_name_employee] [varchar](50) NULL,
[last_name_employee] [varchar](50) NULL,
[address] [varchar](50) NULL,
[contact] [varchar](50) NULL,
[date] [varchar](50) NULL,
[description] [text] NULL,
[price] [decimal](18, 2) NULL,
[added_date] [datetime] NULL,
[added_by] [int] NULL,
[added_by_name] [varchar](50) NULL,
CONSTRAINT [PK_table_logistic_archive_1] 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].[table_products] Script Date: 18.1.2021 г. 19:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table_products](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](50) NULL,
[category] [varchar](50) NULL,
[special_number] [varchar](50) NULL,
[description] [text] NULL,
[rate] [decimal](18, 2) NULL,
[qty] [decimal](18, 2) NULL,
[added_date] [datetime] NULL,
[added_by] [int] NULL,
[added_by_name] [varchar](50) NULL,
CONSTRAINT [PK_table_products] 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].[table_transactions] Script Date: 18.1.2021 г. 19:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table_transactions](
[id] [int] IDENTITY(1,1) NOT NULL,
[type] [varchar](50) NULL,
[dea_cust_id] [int] NULL,
[description] [text] NULL,
[grandTotal] [decimal](18, 2) NULL,
[transaction_date] [datetime] NULL,
[tax] [decimal](18, 2) NULL,
[discount] [decimal](18, 2) NULL,
[paid_amount] [decimal](18, 2) NULL,
[return_amount] [decimal](18, 2) NULL,
[added_by] [int] NULL,
[added_by_name] [varchar](50) NULL,
CONSTRAINT [PK_table_transactions] 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].[table_transactions_detail] Script Date: 18.1.2021 г. 19:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table_transactions_detail](
[id] [int] IDENTITY(1,1) NOT NULL,
[product_id] [int] NULL,
[rate] [decimal](18, 2) NULL,
[qty] [decimal](18, 2) NULL,
[total] [decimal](18, 2) NULL,
[dea_cust_id] [int] NULL,
[added_date] [datetime] NULL,
[added_by] [int] NULL,
[added_by_name] [varchar](50) NULL,
CONSTRAINT [PK_table_transactions_detail] 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].[table_users] Script Date: 18.1.2021 г. 19:24:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[table_users](
[id] [int] IDENTITY(1,1) NOT NULL,
[first_name] [varchar](50) NULL,
[last_name] [varchar](50) NULL,
[email] [varchar](150) NULL,
[username] [varchar](50) NULL,
[password] [varchar](15) NULL,
[contact] [varchar](50) NULL,
[address] [text] NULL,
[gender] [varchar](10) NULL,
[user_type] [varchar](15) NULL,
[added_date] [datetime] NULL,
[added_by] [int] NULL,
[added_by_name] [varchar](50) NULL,
CONSTRAINT [PK_table_users] 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].[table_categories] ON
INSERT [dbo].[table_categories] ([id], [title], [description], [added_date], [added_by], [added_by_name]) VALUES (3, N'Food', N'Something to eat', CAST(N'2021-01-15T12:26:08.233' AS DateTime), 5, N'admin')
INSERT [dbo].[table_categories] ([id], [title], [description], [added_date], [added_by], [added_by_name]) VALUES (4, N'Drink', N'Something to drink', CAST(N'2021-01-15T12:26:10.810' AS DateTime), 5, N'admin')
INSERT [dbo].[table_categories] ([id], [title], [description], [added_date], [added_by], [added_by_name]) VALUES (5, N'Object', N'Someting for home', CAST(N'2021-01-15T12:26:13.797' AS DateTime), 5, N'admin')
INSERT [dbo].[table_categories] ([id], [title], [description], [added_date], [added_by], [added_by_name]) VALUES (6, N'Tool', N'Something to use', CAST(N'2021-01-15T12:26:16.420' AS DateTime), 5, N'admin')
SET IDENTITY_INSERT [dbo].[table_categories] OFF
GO
SET IDENTITY_INSERT [dbo].[table_dealer_customer] ON
INSERT [dbo].[table_dealer_customer] ([id], [type], [name], [email], [contact], [address], [added_date], [added_by], [added_by_name]) VALUES (3, N'Dealer', N'Tolga', N'[email protected]', N'0887565412', N'Sofia St. Grad', CAST(N'2021-01-09T14:48:27.660' AS DateTime), 5, NULL)
INSERT [dbo].[table_dealer_customer] ([id], [type], [name], [email], [contact], [address], [added_date], [added_by], [added_by_name]) VALUES (4, N'Customer', N'Teodor', N'[email protected]', N'0876248351', N'Sofia St. Grad', CAST(N'2021-01-09T14:49:09.527' AS DateTime), 5, NULL)
SET IDENTITY_INSERT [dbo].[table_dealer_customer] OFF
GO
SET IDENTITY_INSERT [dbo].[table_logistic] ON
INSERT [dbo].[table_logistic] ([id], [employee], [first_name_employee], [last_name_employee], [address], [contact], [date], [description], [price], [added_date], [added_by], [added_by_name]) VALUES (23, N'admin', N'Master', N'Admin', N'aaaaaaaaa', N'1515151515', N'28.02.2021', N'Chips=2 ', CAST(13.38 AS Decimal(18, 2)), CAST(N'2021-01-14T15:22:28.680' AS DateTime), 5, N'admin')
SET IDENTITY_INSERT [dbo].[table_logistic] OFF
GO
SET IDENTITY_INSERT [dbo].[table_logistic_archive] ON
INSERT [dbo].[table_logistic_archive] ([id], [employee], [first_name_employee], [last_name_employee], [address], [contact], [date], [description], [price], [added_date], [added_by], [added_by_name]) VALUES (1, N'user', N'Normal', N'User', N'adasdasdasda', N'52515145152', N'02.01.21', N'Chips=2 ', CAST(13.38 AS Decimal(18, 2)), CAST(N'2021-01-14T18:04:31.000' AS DateTime), 5, N'admin')
SET IDENTITY_INSERT [dbo].[table_logistic_archive] OFF
GO
SET IDENTITY_INSERT [dbo].[table_products] ON
INSERT [dbo].[table_products] ([id], [name], [category], [special_number], [description], [rate], [qty], [added_date], [added_by], [added_by_name]) VALUES (4, N'Chips', N'Food', N'111', N'Fried potato.', CAST(2.69 AS Decimal(18, 2)), CAST(16.00 AS Decimal(18, 2)), CAST(N'2021-01-14T15:15:15.713' AS DateTime), 5, N'admin')
INSERT [dbo].[table_products] ([id], [name], [category], [special_number], [description], [rate], [qty], [added_date], [added_by], [added_by_name]) VALUES (5, N'Jellybeans', N'Food', N'112', N'Rubber candies.', CAST(2.20 AS Decimal(18, 2)), CAST(8.00 AS Decimal(18, 2)), CAST(N'2021-01-14T15:15:20.927' AS DateTime), 5, N'admin')
INSERT [dbo].[table_products] ([id], [name], [category], [special_number], [description], [rate], [qty], [added_date], [added_by], [added_by_name]) VALUES (6, N'Coca-Cola', N'Drink', N'211', N'Soda.', CAST(2.50 AS Decimal(18, 2)), CAST(14.00 AS Decimal(18, 2)), CAST(N'2021-01-14T15:15:25.253' AS DateTime), 5, N'admin')
INSERT [dbo].[table_products] ([id], [name], [category], [special_number], [description], [rate], [qty], [added_date], [added_by], [added_by_name]) VALUES (7, N'Core', N'Drink', N'212', N'Water.', CAST(1.70 AS Decimal(18, 2)), CAST(6.00 AS Decimal(18, 2)), CAST(N'2021-01-14T15:15:29.103' AS DateTime), 5, N'admin')
INSERT [dbo].[table_products] ([id], [name], [category], [special_number], [description], [rate], [qty], [added_date], [added_by], [added_by_name]) VALUES (8, N'Sprite', N'Drink', N'213', N'Soda.', CAST(2.50 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(N'2021-01-14T15:15:51.360' AS DateTime), 5, N'admin')
SET IDENTITY_INSERT [dbo].[table_products] OFF
GO
SET IDENTITY_INSERT [dbo].[table_transactions] ON
INSERT [dbo].[table_transactions] ([id], [type], [dea_cust_id], [description], [grandTotal], [transaction_date], [tax], [discount], [paid_amount], [return_amount], [added_by], [added_by_name]) VALUES (11, N'Purchase', 0, N'Core=4 Jellybeans=4 ', CAST(14.81 AS Decimal(18, 2)), CAST(N'2021-01-12T12:24:23.040' AS DateTime), CAST(1.00 AS Decimal(18, 2)), CAST(6.00 AS Decimal(18, 2)), CAST(15.00 AS Decimal(18, 2)), CAST(0.19 AS Decimal(18, 2)), 6, NULL)
INSERT [dbo].[table_transactions] ([id], [type], [dea_cust_id], [description], [grandTotal], [transaction_date], [tax], [discount], [paid_amount], [return_amount], [added_by], [added_by_name]) VALUES (12, N'Purchase', 0, N'Coca-Cola=7 ', CAST(16.06 AS Decimal(18, 2)), CAST(N'2021-01-12T12:24:51.470' AS DateTime), CAST(2.00 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(17.00 AS Decimal(18, 2)), CAST(0.94 AS Decimal(18, 2)), 6, NULL)
INSERT [dbo].[table_transactions] ([id], [type], [dea_cust_id], [description], [grandTotal], [transaction_date], [tax], [discount], [paid_amount], [return_amount], [added_by], [added_by_name]) VALUES (13, N'Sales', 0, N'Chips=5 ', CAST(12.91 AS Decimal(18, 2)), CAST(N'2021-01-12T15:16:33.760' AS DateTime), CAST(1.00 AS Decimal(18, 2)), CAST(5.00 AS Decimal(18, 2)), CAST(15.00 AS Decimal(18, 2)), CAST(2.09 AS Decimal(18, 2)), 6, NULL)
INSERT [dbo].[table_transactions] ([id], [type], [dea_cust_id], [description], [grandTotal], [transaction_date], [tax], [discount], [paid_amount], [return_amount], [added_by], [added_by_name]) VALUES (14, N'Purchase', 0, N'Chips=20 ', CAST(51.62 AS Decimal(18, 2)), CAST(N'2021-01-12T15:18:43.330' AS DateTime), CAST(1.00 AS Decimal(18, 2)), CAST(5.00 AS Decimal(18, 2)), CAST(100.00 AS Decimal(18, 2)), CAST(48.38 AS Decimal(18, 2)), 6, NULL)
INSERT [dbo].[table_transactions] ([id], [type], [dea_cust_id], [description], [grandTotal], [transaction_date], [tax], [discount], [paid_amount], [return_amount], [added_by], [added_by_name]) VALUES (18, N'Purchase', 0, N'Chips=5 ', CAST(12.34 AS Decimal(18, 2)), CAST(N'2021-01-14T15:21:21.817' AS DateTime), CAST(2.00 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(13.00 AS Decimal(18, 2)), CAST(0.66 AS Decimal(18, 2)), 6, N'user')
SET IDENTITY_INSERT [dbo].[table_transactions] OFF
GO
SET IDENTITY_INSERT [dbo].[table_transactions_detail] ON
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (1, 2, CAST(20.00 AS Decimal(18, 2)), CAST(1.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), 0, CAST(N'2020-12-12T17:39:41.053' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (2, 2, CAST(20.00 AS Decimal(18, 2)), CAST(1.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), 0, CAST(N'2020-12-13T15:19:14.203' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (3, 2, CAST(20.00 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(200.00 AS Decimal(18, 2)), 0, CAST(N'2020-12-13T15:22:10.637' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (4, 3, CAST(2.69 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(26.90 AS Decimal(18, 2)), 0, CAST(N'2021-01-09T14:21:28.633' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (5, 4, CAST(2.69 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(26.90 AS Decimal(18, 2)), 3, CAST(N'2021-01-09T14:51:09.247' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (6, 5, CAST(2.20 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(22.00 AS Decimal(18, 2)), 3, CAST(N'2021-01-09T14:51:09.263' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (7, 6, CAST(2.50 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 3, CAST(N'2021-01-09T14:51:09.273' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (8, 7, CAST(1.70 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(17.00 AS Decimal(18, 2)), 3, CAST(N'2021-01-09T14:51:09.273' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (9, 8, CAST(2.50 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(25.00 AS Decimal(18, 2)), 3, CAST(N'2021-01-09T14:51:09.277' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (10, 6, CAST(2.50 AS Decimal(18, 2)), CAST(5.00 AS Decimal(18, 2)), CAST(12.50 AS Decimal(18, 2)), 0, CAST(N'2021-01-09T17:34:46.993' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (11, 4, CAST(2.69 AS Decimal(18, 2)), CAST(2.00 AS Decimal(18, 2)), CAST(5.38 AS Decimal(18, 2)), 4, CAST(N'2021-01-11T13:03:51.853' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (12, 6, CAST(2.50 AS Decimal(18, 2)), CAST(3.00 AS Decimal(18, 2)), CAST(7.50 AS Decimal(18, 2)), 4, CAST(N'2021-01-11T13:03:51.863' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (13, 4, CAST(2.69 AS Decimal(18, 2)), CAST(2.00 AS Decimal(18, 2)), CAST(5.38 AS Decimal(18, 2)), 4, CAST(N'2021-01-11T13:04:34.110' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (14, 6, CAST(2.50 AS Decimal(18, 2)), CAST(3.00 AS Decimal(18, 2)), CAST(7.50 AS Decimal(18, 2)), 4, CAST(N'2021-01-11T13:04:34.123' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (15, 4, CAST(2.69 AS Decimal(18, 2)), CAST(2.00 AS Decimal(18, 2)), CAST(5.38 AS Decimal(18, 2)), 4, CAST(N'2021-01-11T13:04:34.127' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (16, 5, CAST(2.20 AS Decimal(18, 2)), CAST(2.00 AS Decimal(18, 2)), CAST(4.40 AS Decimal(18, 2)), 4, CAST(N'2021-01-11T13:04:34.130' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (17, 7, CAST(1.70 AS Decimal(18, 2)), CAST(2.00 AS Decimal(18, 2)), CAST(3.40 AS Decimal(18, 2)), 4, CAST(N'2021-01-11T13:06:29.203' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (18, 4, CAST(2.69 AS Decimal(18, 2)), CAST(1.00 AS Decimal(18, 2)), CAST(2.69 AS Decimal(18, 2)), 4, CAST(N'2021-01-11T13:06:29.210' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (19, 4, CAST(2.69 AS Decimal(18, 2)), CAST(7.00 AS Decimal(18, 2)), CAST(18.83 AS Decimal(18, 2)), 0, CAST(N'2021-01-11T14:30:41.953' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (20, 7, CAST(1.70 AS Decimal(18, 2)), CAST(4.00 AS Decimal(18, 2)), CAST(6.80 AS Decimal(18, 2)), 0, CAST(N'2021-01-12T12:24:23.267' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (21, 5, CAST(2.20 AS Decimal(18, 2)), CAST(4.00 AS Decimal(18, 2)), CAST(8.80 AS Decimal(18, 2)), 0, CAST(N'2021-01-12T12:24:23.277' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (22, 6, CAST(2.50 AS Decimal(18, 2)), CAST(7.00 AS Decimal(18, 2)), CAST(17.50 AS Decimal(18, 2)), 0, CAST(N'2021-01-12T12:24:51.593' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (23, 4, CAST(2.69 AS Decimal(18, 2)), CAST(5.00 AS Decimal(18, 2)), CAST(13.45 AS Decimal(18, 2)), 0, CAST(N'2021-01-12T15:16:33.837' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (24, 4, CAST(2.69 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(53.80 AS Decimal(18, 2)), 0, CAST(N'2021-01-12T15:18:43.333' AS DateTime), 6, NULL)
INSERT [dbo].[table_transactions_detail] ([id], [product_id], [rate], [qty], [total], [dea_cust_id], [added_date], [added_by], [added_by_name]) VALUES (26, 4, CAST(2.69 AS Decimal(18, 2)), CAST(5.00 AS Decimal(18, 2)), CAST(13.45 AS Decimal(18, 2)), 0, CAST(N'2021-01-14T15:21:21.823' AS DateTime), 6, N'user')
SET IDENTITY_INSERT [dbo].[table_transactions_detail] OFF
GO
SET IDENTITY_INSERT [dbo].[table_users] ON
INSERT [dbo].[table_users] ([id], [first_name], [last_name], [email], [username], [password], [contact], [address], [gender], [user_type], [added_date], [added_by], [added_by_name]) VALUES (5, N'Master', N'Admin', N'[email protected]', N'admin', N'admin', N'01234567891', N'Sofia Bulgariq', N'Male', N'Admin', CAST(N'2021-01-15T12:25:26.743' AS DateTime), 5, N'admin')
INSERT [dbo].[table_users] ([id], [first_name], [last_name], [email], [username], [password], [contact], [address], [gender], [user_type], [added_date], [added_by], [added_by_name]) VALUES (6, N'Normal', N'User', N'[email protected]', N'user', N'user', N'0123456789', N'Sofia Bulgaria', N'Male', N'User', CAST(N'2020-12-07T12:32:25.353' AS DateTime), 1, NULL)
INSERT [dbo].[table_users] ([id], [first_name], [last_name], [email], [username], [password], [contact], [address], [gender], [user_type], [added_date], [added_by], [added_by_name]) VALUES (10, N'Georgi', N'Anastasov', N'[email protected]', N'georgianastasov', N'123456789', N'08844556789', N'Sofia St. Grad', N'Male', N'User', CAST(N'2021-01-15T12:25:54.257' AS DateTime), 5, N'admin')
SET IDENTITY_INSERT [dbo].[table_users] OFF
GO