-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathSQL_Insert.sql
74 lines (52 loc) · 3.49 KB
/
SQL_Insert.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
-- insert table script
/*-- job application status-------*/
insert into philance.philance_lookups
values('PROJECT', 'APPLICANT_STATUS', 'APPLIED', 'Applicant applied for a project', CURTIME(), 0, CURTIME(),0);
insert into philance.philance_lookups
values('PROJECT', 'APPLICANT_STATUS', 'IN REVIEW', 'Applicant being reviewed for a project', CURTIME(), 0, CURTIME(),0);
insert into philance.philance_lookups
values('PROJECT', 'APPLICANT_STATUS', 'APPROVED', 'Applicant approved for a project', CURTIME(), 0, CURTIME(),0);
insert into philance.philance_lookups
values('PROJECT', 'APPLICANT_STATUS', 'REJECTED', 'Applicant rejected for a project', CURTIME(), 0, CURTIME(),0);
/* Impact Categories*/
insert into philance.philance_lookups
values ('IMPACT_CATEGORIES', 'COMMUNITY', 'Community', 'Community Service', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('IMPACT_CATEGORIES', 'ELDERLY', 'Elderly', 'Elderly Service', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('IMPACT_CATEGORIES', 'HOMELESS', 'Homeless', 'Homeles Service', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('IMPACT_CATEGORIES', 'OTHER', 'Other', 'Other Service', curtime(), 0, curtime(), 0);
/*User Types*/
insert into philance.philance_lookups
values ('USER_TYPES', 'PROJECT', 'Project Owner', 'Person who creates a project', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('USER_TYPES', 'PROJECT', 'Project Sponsor', 'Person who funds a project', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('USER_TYPES', 'PROJECT', 'Project Member', 'All freelancers who support fulfill a project', curtime(), 0, curtime(), 0);
/*Project Roles*/
insert into philance.philance_lookups
values ('PROJECT_ROLES', 'PROJECT', 'Developer', 'Developer', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('PROJECT_ROLES', 'PROJECT', 'Manager', 'Project Manager', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('PROJECT_ROLES', 'PROJECT', 'Tester', 'Tester', curtime(), 0, curtime(), 0);
/* Skills Lookup*/
insert into philance.philance_lookups
values ('SKILLS', 'IT', 'Database Development', 'Database Development', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('SKILLS', 'IT', 'JAVA Development', 'JAVA Development', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('SKILLS', 'BUSINESS', 'Project Management', 'Project Development', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('SKILLS', 'OTHER', 'Other', 'Other', curtime(), 0, curtime(), 0);
/* Possible notificaiton that user can set */
insert into philance.philance_lookups
values ('NOTIFICATION', 'TRIGGER', 'Message', 'When another Philance members messages a user', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('NOTIFICATION', 'TRIGGER', 'Project Application Status', 'When a project application is approved/rejected', curtime(), 0, curtime(), 0);
insert into philance.philance_lookups
values ('NOTIFICATION', 'TRIGGER', 'Project Updates', 'When a updates are available on project', curtime(), 0, curtime(), 0);
-- insert into philance.users
-- values (100, 'Ram', 'Sailopal', '[email protected]', '$2b$10$lkezHqJk/Y5zup4gEEEXYeMfEBL0zVnRTrDFpNGZvVeZlERLtCtZi', null, null, null, null, null, null, null, null, null, null, null, null, 'Birmingham');
commit;