-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdb-data.sql
More file actions
207 lines (199 loc) · 12.4 KB
/
db-data.sql
File metadata and controls
207 lines (199 loc) · 12.4 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
-- ----------------------------
-- Records for "PRIVILEGE"
-- ----------------------------
INSERT INTO PRIVILEGE VALUES ('31', 'Inquire Orders', 'I_ORDER', 'Can Search for Order Requests');
INSERT INTO PRIVILEGE VALUES ('30', 'Update Orders', 'U_ORDER', 'Can Update Order Requests');
INSERT INTO PRIVILEGE VALUES ('29', 'Read Orders', 'R_ORDER', 'Can only View Order Requests');
INSERT INTO PRIVILEGE VALUES ('28', 'Create Orders', 'C_ORDER', 'Can Create/Edit Order Requests');
INSERT INTO PRIVILEGE VALUES ('27', 'Inquire Advertisements', 'I_ADVT', 'Can search for Advertisements');
INSERT INTO PRIVILEGE VALUES ('26', 'Update Advertisements', 'U_ADVT', 'Can Update Advertisements');
INSERT INTO PRIVILEGE VALUES ('25', 'Read Advertisements', 'R_ADVT', 'Can only Read Advertisement Information');
INSERT INTO PRIVILEGE VALUES ('24', 'Create Advertisements', 'C_ADVT', 'Can Create/Edit Advertisements');
INSERT INTO PRIVILEGE VALUES ('23', 'Inquire Albums', 'I_ALBUM', 'Can Search for Albums');
INSERT INTO PRIVILEGE VALUES ('22', 'Read Albums', 'R_ALBUM', 'Can only View Albums');
INSERT INTO PRIVILEGE VALUES ('21', 'Create Albums', 'C_ALBUM', 'Can Create/Edit Albums');
INSERT INTO PRIVILEGE VALUES ('20', 'Inquire Role', 'I_ROLE', 'Can search for Roles');
INSERT INTO PRIVILEGE VALUES ('19', 'Read Role', 'R_ROLE', 'Can only Read Role Information');
INSERT INTO PRIVILEGE VALUES ('18', 'Create Role', 'C_ROLE', 'Can Create/Edit Role Information');
INSERT INTO PRIVILEGE VALUES ('17', 'Inquire Features', 'I_FEATURE', 'Can Search for Features & Feature Groups');
INSERT INTO PRIVILEGE VALUES ('16', 'Read Features', 'R_FEATURE', 'Can only Read Features & Feature Groups');
INSERT INTO PRIVILEGE VALUES ('15', 'Create Features', 'C_FEATURE', 'Can Create/Edit Features & Feature Groups');
INSERT INTO PRIVILEGE VALUES ('14', 'Inquire Categories', 'I_CATEGORY', 'Can Search for Categories');
INSERT INTO PRIVILEGE VALUES ('13', 'Read Categories', 'R_CATEGORY', 'Can Read Category Information');
INSERT INTO PRIVILEGE VALUES ('12', 'Create Categories', 'C_CATEGORY', 'Can Create/Edit Category Information');
INSERT INTO PRIVILEGE VALUES ('11', 'Inquire Items', 'I_ITEM', 'Can Search for Items');
INSERT INTO PRIVILEGE VALUES ('10', 'Read Items', 'R_ITEM', 'Can only Read Item Information');
INSERT INTO PRIVILEGE VALUES ('9', 'Create Items', 'C_ITEM', 'Can Create/Edit Item Information');
INSERT INTO PRIVILEGE VALUES ('8', 'Inquire Clients', 'I_CLIENT', 'Can Search for Clients');
INSERT INTO PRIVILEGE VALUES ('7', 'Update Clients', 'U_CLIENT', 'Can Edit Client Information');
INSERT INTO PRIVILEGE VALUES ('6', 'Read Clients', 'R_CLIENT', 'Can Read Client Information');
INSERT INTO PRIVILEGE VALUES ('5', 'Create Clients', 'C_CLIENT', 'Can Create/Edit Client Information');
INSERT INTO PRIVILEGE VALUES ('4', 'Inquire Users', 'I_USER', 'Can Search for Users');
INSERT INTO PRIVILEGE VALUES ('3', 'Update Users', 'U_USER', 'Can Edit User Information');
INSERT INTO PRIVILEGE VALUES ('2', 'Read Users', 'R_USER', 'Can only Read User Information');
INSERT INTO PRIVILEGE VALUES ('1', 'Create Users', 'C_USER', 'Can Create/Edit User Information');
-- ----------------------------
-- Records for "RL_ROLE_PRIVILEGE"
-- ----------------------------
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '1');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '2');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '3');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '4');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '5');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '6');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '7');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '8');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '9');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '10');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '11');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '12');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '13');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '14');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '15');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '16');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '17');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '18');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '19');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '20');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '21');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '22');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '23');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '24');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '25');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '26');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '27');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '28');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '29');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '30');
INSERT INTO RL_ROLE_PRIVILEGE VALUES ('1', '31');
-- ----------------------------
-- Records for "ROLE"
-- ----------------------------
INSERT INTO ROLE VALUES ('1', 'Application Administrator', 'Can edit all');
INSERT INTO ROLE VALUES ('2', 'Store Administrator', 'Can edit everything in his store');
INSERT INTO ROLE VALUES ('3', 'Employee', 'Employee who attends to the customer');
INSERT INTO ROLE VALUES ('4', 'Customer', 'Customer who registers into our system');
-- ----------------------------
-- Records for "ENUM_TYPE"
-- ----------------------------
INSERT INTO ENUM_TYPE VALUES ('1', 'USER_TYPE', 'Type of User', null);
INSERT INTO ENUM_TYPE VALUES ('2', 'USER_STATUS', 'Status of User', null);
INSERT INTO ENUM_TYPE VALUES ('3', 'LOCATION_TYPE', 'Type of Location', null);
INSERT INTO ENUM_TYPE VALUES ('4', 'STYLE_TYPE', 'Style of a Car : Trim/Package', null);
INSERT INTO ENUM_TYPE VALUES ('5', 'BODY_TYPE', 'Body type of a Vehicle', null);
INSERT INTO ENUM_TYPE VALUES ('6', 'CATEGORY_TYPE', 'Type of User', null);
INSERT INTO ENUM_TYPE VALUES ('7', 'FUEL_TYPE', 'Type of Fuel used for the car', null);
INSERT INTO ENUM_TYPE VALUES ('8', 'WARRANTY_TYPE', 'Type of Warranty', null);
INSERT INTO ENUM_TYPE VALUES ('9', 'VEHICLE_STATUS', 'Status of a car', null);
INSERT INTO ENUM_TYPE VALUES ('10', 'VEHICLE_CONDITION', 'Condition of a car', null);
INSERT INTO ENUM_TYPE VALUES ('11', 'DISPLAY_TYPE', 'Type of Display', null);
INSERT INTO ENUM_TYPE VALUES ('12', 'IMAGE_TYPE', 'Type of Photo for the car', null);
INSERT INTO ENUM_TYPE VALUES ('13', 'AD_STATUS', 'Status of Advertisement', null);
INSERT INTO ENUM_TYPE VALUES ('14', 'AD_UNITS', 'Unit of Advertisement', null);
INSERT INTO ENUM_TYPE VALUES ('15', 'LOAN_STATUS', 'Status of Loan', null);
INSERT INTO ENUM_TYPE VALUES ('16', 'FINANCE_TYPE', 'Type of Finance', null);
INSERT INTO ENUM_TYPE VALUES ('17', 'ACCOUNT_TYPE', 'Type of Account', null);
INSERT INTO ENUM_TYPE VALUES ('18', 'INQUIRY_TYPE', 'Type of Inquiry', null);
INSERT INTO ENUM_TYPE VALUES ('19', 'TRANSMISSION_TYPE', 'Type of Transmission', null);
INSERT INTO ENUM_TYPE VALUES ('20', 'DRIVE_TRAIN_TYPE', 'Type of Drive Train', null);
INSERT INTO ENUM_TYPE VALUES ('21', 'RESIDENCE_TYPE', 'Type of Residence', null);
INSERT INTO ENUM_TYPE VALUES ('22', 'AUDIT_TYPE', 'Type of Audit Log', null);
-- ----------------------------
-- Records for "ENUM"
-- ----------------------------
-- USER_TYPE
INSERT INTO ENUM VALUES ('1', '1', 'Client', 'Client', null);
INSERT INTO ENUM VALUES ('2', '1', 'Customer', 'Customer', null);
-- USER_STATUS
INSERT INTO ENUM VALUES ('10', '2', 'Active', 'Active', null);
INSERT INTO ENUM VALUES ('11', '2', 'In Active', 'In Active', null);
INSERT INTO ENUM VALUES ('12', '2', 'Suspended', 'Suspended', null);
-- LOCATION_TYPE
INSERT INTO ENUM VALUES ('20', '3', 'Primary', 'Primary', null);
INSERT INTO ENUM VALUES ('21', '3', 'Secondary', 'Secondary', null);
-- STYLE_TYPE
INSERT INTO ENUM VALUES ('30', '4', 'Trim', 'Trim', null);
INSERT INTO ENUM VALUES ('31', '4', 'Package', 'Package', null);
-- BODY_TYPE
INSERT INTO ENUM VALUES ('40', '5', 'Sedan', 'Sedan', null);
INSERT INTO ENUM VALUES ('41', '5', 'Wagon', 'Wagon', null);
INSERT INTO ENUM VALUES ('42', '5', 'Crossover', 'Crossover', null);
INSERT INTO ENUM VALUES ('43', '5', 'Luxury', 'Luxury', null);
INSERT INTO ENUM VALUES ('44', '5', 'Coupe', 'Coupe', null);
INSERT INTO ENUM VALUES ('45', '5', 'Hatchback', 'Hatchback', null);
INSERT INTO ENUM VALUES ('46', '5', 'SUV', 'SUV', null);
INSERT INTO ENUM VALUES ('47', '5', 'Hybrid', 'Hybrid', null);
INSERT INTO ENUM VALUES ('48', '5', 'Convertible', 'Convertible', null);
INSERT INTO ENUM VALUES ('49', '5', 'Pickup', 'Pickup', null);
INSERT INTO ENUM VALUES ('50', '5', 'Minivan', 'Minivan', null);
INSERT INTO ENUM VALUES ('51', '5', 'Truck', 'Truck', null);
-- CATEGORY_TYPE
INSERT INTO ENUM VALUES ('60', '6', 'Home Page', 'Home Page', 'Categories displayed on Home Page');
INSERT INTO ENUM VALUES ('61', '6', 'Main Menu', 'Main Menu', 'Main Menu displayed as part of website header');
-- FUEL_TYPE
INSERT INTO ENUM VALUES ('70', '7', 'Gasoline', 'Gasoline', null);
INSERT INTO ENUM VALUES ('71', '7', 'Prem Gas', 'Premium Gasoline', null);
INSERT INTO ENUM VALUES ('72', '7', 'Diesel', 'Diesel', null);
-- WARRANTY_TYPE
INSERT INTO ENUM VALUES ('80', '8', 'Standard', 'Standard', null);
INSERT INTO ENUM VALUES ('81', '8', 'Extended', 'Extended', null);
INSERT INTO ENUM VALUES ('82', '8', 'No Warranty', 'As Is - No Warranty', null);
-- VEHICLE_STATUS
INSERT INTO ENUM VALUES ('90', '9', 'Available', 'Available', null);
INSERT INTO ENUM VALUES ('91', '9', 'Sold', 'Sold', null);
INSERT INTO ENUM VALUES ('92', '9', 'On Hold', 'On Hold', null);
-- CONDITION
INSERT INTO ENUM VALUES ('100', '10', 'New', 'New', null);
INSERT INTO ENUM VALUES ('101', '10', 'Used', 'Pre-Owned', null);
INSERT INTO ENUM VALUES ('102', '10', 'Certified', 'Certified', null);
-- DISPLAY_TYPE
INSERT INTO ENUM VALUES ('110', '11', 'Select One', 'Select One', null);
INSERT INTO ENUM VALUES ('111', '11', 'Select Many', 'Select Many', null);
-- IMAGE_TYPE
INSERT INTO ENUM VALUES ('120', '12', 'Primary', 'Primary', null);
INSERT INTO ENUM VALUES ('121', '12', 'Logo', 'Logo', null);
-- AD_STATUS
INSERT INTO ENUM VALUES ('130', '13', 'Active', 'Active', null);
INSERT INTO ENUM VALUES ('131', '13', 'Suspended', 'Suspended', null);
INSERT INTO ENUM VALUES ('132', '13', 'Expired', 'Expired', null);
-- AD_UNITS
INSERT INTO ENUM VALUES ('140', '14', 'Hourly', 'Hourly', null);
INSERT INTO ENUM VALUES ('141', '14', 'Daily', 'Daily', null);
INSERT INTO ENUM VALUES ('142', '14', 'Weekly', 'Weekly', null);
INSERT INTO ENUM VALUES ('143', '14', 'Monthly', 'Monthly', null);
INSERT INTO ENUM VALUES ('144', '14', 'Yearly', 'Yearly', null);
-- LOAN_STATUS
INSERT INTO ENUM VALUES ('150', '15', 'Submitted', 'Submitted', null);
INSERT INTO ENUM VALUES ('151', '15', 'Under Review', 'Under Review', null);
INSERT INTO ENUM VALUES ('152', '15', 'Approved', 'Approved', null);
-- FINANCE_TYPE
INSERT INTO ENUM VALUES ('160', '16', 'Purchase', 'Purchase', null);
INSERT INTO ENUM VALUES ('161', '16', 'Lease', 'Lease', null);
-- ACCOUNT_TYPE
INSERT INTO ENUM VALUES ('170', '17', 'Checking', 'Checking', null);
INSERT INTO ENUM VALUES ('171', '17', 'Savings', 'Savings', null);
-- INQUIRY_TYPE
INSERT INTO ENUM VALUES ('180', '18', 'Reserved', 'Reserved', 'For future use');
-- TRANSMISSION_TYPE
INSERT INTO ENUM VALUES ('190', '19', 'Automatic', 'Automatic', 'Automatic Transmission');
INSERT INTO ENUM VALUES ('191', '19', 'Manual', '5 Speed Manual', '5 Speed Manual Transmission');
-- DRIVE_TRAIN_TYPE
INSERT INTO ENUM VALUES ('210', '20', 'AWD', 'AWD', 'All Wheel Drive');
INSERT INTO ENUM VALUES ('211', '20', 'FWD', 'FWD', 'Front Wheel Drive');
INSERT INTO ENUM VALUES ('212', '20', 'RWD', 'RWD', 'Rear Wheel Drive');
INSERT INTO ENUM VALUES ('213', '20', 'FIVE WD', '4WD', 'Four Wheel Drive');
-- RESIDENCE_TYPE
INSERT INTO ENUM VALUES ('220', '21', 'OWNED', 'Owned', 'Owned Property');
INSERT INTO ENUM VALUES ('221', '21', 'RENTED', 'Rented', 'Rented Property');
-- AUDIT_TYPE
INSERT INTO ENUM VALUES ('230', '22', 'CREATE', 'Create', 'Create');
INSERT INTO ENUM VALUES ('231', '22', 'READ', 'Read', 'Read');
INSERT INTO ENUM VALUES ('232', '22', 'UPDATE', 'Update', 'Update');
INSERT INTO ENUM VALUES ('233', '22', 'DELETE', 'Delete', 'Delete');
------------------------------------
------RECORDS FOR FEATURE_GROUP-----
------------------------------------
INSERT INTO FEATURE_GROUP VALUES(1, 'OPTIONS', 111, 'Vehicle Options', 0, null);
------------------------------------
------RECORDS FOR FEATURE-----------
------------------------------------