-
Notifications
You must be signed in to change notification settings - Fork 523
Expand file tree
/
Copy pathIntialScript.sql
More file actions
113 lines (71 loc) · 6.77 KB
/
IntialScript.sql
File metadata and controls
113 lines (71 loc) · 6.77 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
Go
INSERT INTO ProductCategories (id, Category,CreatedAt) VALUES
(NEWID(),'Books',GETDATE()),
(NEWID(),'Video Games',GETDATE()),
(NEWID(),'Beauty',GETDATE()),
(NEWID(),'Furniture',GETDATE()),
(NEWID(),'Watches',GETDATE()),
(NEWID(),'Health & Personal Care',GETDATE()),
(NEWID(),'Toys & Games',GETDATE()),
(NEWID(),'Software',GETDATE()),
(NEWID(),'Jewellery ',GETDATE()),
(NEWID(),'Computers & Accessories',GETDATE()),
(NEWID(),'Music',GETDATE()),
(NEWID(),'Electronics',GETDATE()),
(NEWID(),'Movies & TV Shows',GETDATE()),
(NEWID(),'Sports, Fitness & Outdoors',GETDATE()),
(NEWID(),'Luggage & Bags',GETDATE()),
(NEWID(),'Shoes & Handbags',GETDATE()),
(NEWID(),'Kindle Store',GETDATE()),
(NEWID(),'Baby',GETDATE()),
(NEWID(),'Clothing & Accessories',GETDATE()),
(NEWID(),'Office Products',GETDATE()),
(NEWID(),'Lawn & Garden',GETDATE()),
(NEWID(),'Home & Kitchen',GETDATE()),
(NEWID(),'Musical Instruments',GETDATE())
select * from products
Go
--Watches
insert into Products(ID,Name,Description,Price,Category,Image,CreatedAt) Values
(NewID(),'Rorlig RR-028 ','Rorlig RR-028 Expedition Analog Watch - For Men, Boys ',1099 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Minuut MNT-017','Minuut MNT-017-SPT-BLU Analog Watch - For Men ',1199 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'T STAR UFT-TSW','T STAR UFT-TSW-005-BK-BR Analog Watch - For Boys ',999 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Anno Dominii A','Anno Dominii ADWB0000139 Watch Box ',1499 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Alfajr WY16B Y','Alfajr WY16B Youth Digital Watch - For Men, Boys ',5495 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'TAG Heuer CAU1','TAG Heuer CAU1116.BA0858 Formula 1 Analog Watch - For Boys, Men ' ,1077 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Merchant eshop','Merchant eshop Boys, Men, Girls, Women ',399 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Romex Ultimate','Romex Ultimate Urban Analog Watch - For Boys, Men ',1199 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Ridas 1825_bla','Ridas 1825_black Sports Analog Watch - For Men ' ,677 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Relish R456 An','Relish R456 Analog Watch - For Men ' ,699 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Rich Club RC-2','Rich Club RC-2166WHT Solitaire Analog Watch - For Girls, Women ' ,999 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Costa Swiss CS','Costa Swiss CS-2001 Analog Watch - For Boys, Men ',1199 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Breitling AB01','Breitling AB011010/BB08 131S Chronomat 44 Analog Watch - For Boys, Men ' ,5712 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Calibro SW-125','Calibro SW-125 Analog-Digital Watch - For Men, Boys ' ,2000 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Rochees RW50 A','Rochees RW50 Analog Watch - For Boys ',1120 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Fluid DMF-002-','Fluid DMF-002-GR01 Digital Watch - For Boys ' ,1699 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Rorlig RR-030 ','Rorlig RR-030 Essentials Analog Watch - For Men, Boys ',1099 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Disney DW10023','Disney DW100230 Digital Watch - For Boys, Girls ' ,350 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Cartier W67010','Cartier W6701005 Analog Watch - For Boys, Men ',1010 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Lois Caron LCS','Lois Caron LCS-4032 Analog Watch - For Boys, Men ',1200 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Sakhi Styles B','Sakhi Styles Boys, Men ',299 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Sakhi Styles M','Sakhi Styles Men, Boys ',399 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Britex BT9026 ','Britex BT9026 Bluetec Bucherer Analog Watch - For Boys, Men ' ,2499 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Felix Y 39 Ana','Felix Y 39 Analog Watch - For Boys, Men ' ,1550 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Kool Kidz DMK-','Kool Kidz DMK-012-QU02 Analog Watch - For Girls, Boys ',375 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Franck Bella F','Franck Bella FB0128B Analog Watch - For Men, Boys ',1199 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Kool Kidz DMK-','Kool Kidz DMK-003-YL 03 Analog Watch - For Girls, Boys ' ,475 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Fogg Fashion S','Fogg Fashion Store 3003-PK Modish Analog Watch - For Women ' ,999 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Luba HH41 Styl','Luba HH41 Stylo Analog Watch - For Women ',350 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Vizion 8502-6B','Vizion 8502-6BLACK Sports Series Digital Watch - For Boys, Girls ',1095 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Luba DE45 Styl','Luba DE45 Stylo Analog Watch - For Women ',350 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Ridas 923_red ','Ridas 923_red Luxy Analog Watch - For Women, Girls ' ,449 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'SVM Navratri S','SVM Navratri Special 7 Analog Watch - For Girls, Women ' ,2499 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate()),
(NewID(),'Fighter FIGH_0','Fighter FIGH_008 Digital Watch - For Couple ' ,200 ,'2069294A-660E-42D6-ACAC-FED3E9D2678E',NULL,getDate())
GO
insert into AspNetRoles(id,Name)values
('B9F0FF29-C97E-4832-8D3B-0950C71A0D00','Admin'),
('DAB9E6DA-5F7B-4714-BE64-D6E22D027C21', 'User')
insert into AspNetUsers(id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName)values
('d6ee11f5-2403-426d-8ed0-461f51bed14f', 'admin@mlifestore.com', 0, 'ANy34NKbw5U7ZtnjoseXrrL+cSSIqKm66v3XEOC2j7ICWq+hd9nqc6uNI4gz9o5MHg==', '296f8155-e4fa-451d-9d3e-2d889bf28cb6', NULL, 0, 0, NULL, 1, 0, 'admin@mlifestore.com')
insert into AspNetUserRoles(UserId, RoleId)values
('d6ee11f5-2403-426d-8ed0-461f51bed14f', 'B9F0FF29-C97E-4832-8D3B-0950C71A0D00')