-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathbase_base.txt
95 lines (73 loc) · 6.48 KB
/
base_base.txt
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
--tu jest taki jakby staly zestaw tabelek ktorych wartosci poczatkowe sie za bardzo nie zmieniaja
--kraje
--INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES();
INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES(1,'Poland','1');
INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES(2,'Kenya','2');
INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES(3,'Germany','3');
INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES(4,'Peru','4');
INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES(5,'USA','5');
INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES(6,'Russia','6');
INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES(7,'China','7');
INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES(8,'France','8');
INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES(9,'Portugal','9');
INSERT INTO Country (ID_Country,Country_Name,Country_code) VALUES(10,'Great Britain','10');
--typy uzytkownikow
INSERT INTO AdminRank (ID_Rank,RankName) VALUES(0,'Admin');
INSERT INTO AdminRank (ID_Rank,RankName) VALUES(1,'User');
--danie im jakichs uprawnien
INSERT INTO Permissions (ID_Rank,OrderService,CreatingUser,DeletingUser,DatabaseAccess) VALUES(1,'T','F','F','F');
INSERT INTO Permissions (ID_Rank,OrderService,CreatingUser,DeletingUser,DatabaseAccess) VALUES(0,'T','T','T','T');
--Tworzenie OrderStatus
INSERT INTO OrderStatus (ID_status,Name_status) VALUES(0,'Pending');
INSERT INTO OrderStatus (ID_status,Name_status) VALUES(1,'Awaiting Payment');
INSERT INTO OrderStatus (ID_status,Name_status) VALUES(2,'Awaiting Pickup');
INSERT INTO OrderStatus (ID_status,Name_status) VALUES(3,'Cancelled');
INSERT INTO OrderStatus (ID_status,Name_status) VALUES(4,'Refunded');
INSERT INTO OrderStatus (ID_status,Name_status) VALUES(5,'Manual Verification Required');
INSERT INTO OrderStatus (ID_status,Name_status) VALUES(5,'Competed');
--DeliveryMethod
INSERT INTO DeliveryMethod (ID_delivery,Delivery_name) VALUES(0,'Long throw of the package by a qualified worker');
INSERT INTO DeliveryMethod (ID_delivery,Delivery_name) VALUES(1,'DPD');
INSERT INTO DeliveryMethod (ID_delivery,Delivery_name) VALUES(2,'InPost');
INSERT INTO DeliveryMethod (ID_delivery,Delivery_name) VALUES(3,'Pickup in person');
--PaymentMethod
INSERT INTO PaymentMethod(ID_payment,Payment_method) VALUES(0,'PayPal');
INSERT INTO PaymentMethod(ID_payment,Payment_method) VALUES(1,'Cash');
INSERT INTO PaymentMethod(ID_payment,Payment_method) VALUES(2,'Credit Card');
INSERT INTO PaymentMethod(ID_payment,Payment_method) VALUES(3,'Bitcoin');
INSERT INTO PaymentMethod(ID_payment,Payment_method) VALUES(4,'Payment with the help of organs');
INSERT INTO PaymentMethod(ID_payment,Payment_method) VALUES(5,'Payment on delivery');
--ProductCategory
INSERT INTO ProductCategory(ProductCategoryKey,ProductCategoryName) VALUES(0,'Mac');
INSERT INTO ProductCategory(ProductCategoryKey,ProductCategoryName) VALUES(1,'iPhone');
INSERT INTO ProductCategory(ProductCategoryKey,ProductCategoryName) VALUES(2,'iPad');
INSERT INTO ProductCategory(ProductCategoryKey,ProductCategoryName) VALUES(3,'Watch');
INSERT INTO ProductCategory(ProductCategoryKey,ProductCategoryName) VALUES(4,'iTruck');
INSERT INTO ProductCategory(ProductCategoryKey,ProductCategoryName) VALUES(5,'accessories');
--ProductSubCategory
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(0,'iMac',0);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(1,'MacBook Air',0);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(2,'MacBook Air',0);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(3,'MacBook Pro',0);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(4,'Mac mini',0);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(5,'Mac Pro',0);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(6,'iPhone 13 Pro MAX',1);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(7,'iPhone 13 Pro',1);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(8,'iPhone 13 ',1);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(9,'iPhone 13 mini,1);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(10,'iPhone 12',1);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(11,'iPhone 12 mini',1);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(11,'iPad Pro 12,9',2);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(12,'iPad Pro 11',2);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(13,'iPad mini',2);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(14,'Watch Series 7',3);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(15,'Watch Nike+ Series 7',3);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(16,'Watch Series 6',3);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(17,'Watch SE',3);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(18,'Watch Series 3',3);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(19,'iTruck Lite',4);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(20,'iTruck Pro',4);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(21,'Air Tag',5);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(22,'Charger',5);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(23,'Power Supply',5);
INSERT INTO ProductSubcategory(ProductSubcategoryKey,ProductSubcategoryName,ProductCategoryKey) VALUES(24,'Protective glass',5);