-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathDummy_SQL_Inserts.sql
100 lines (79 loc) · 3.93 KB
/
Dummy_SQL_Inserts.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
/* sign up user */
insert into philance.users(user_id,fname,lname,email,password,status, creation_date, created_by, last_updated_date, last_updated_by)
values (' 1', 'Karthik', 'Sarvepali', '[email protected]', 'welcome123','Active', CURTIME(), 1, CURTIME(), 1);
insert into philance.users(user_id,fname,lname,email,password,status, creation_date, created_by, last_updated_date, last_updated_by)
values (' 2', 'Vijay', 'Gandra', '[email protected]', 'welcome123','Active', CURTIME(), 2, CURTIME(), 2);
/* Update User Profile*/
Update philance.users
set Fname = 'Karthik',
lname ='Sarvepalli',
email = '[email protected]',
password ='welcome123',
ph_number = '1234567890',
organization = 'Philance',
title = 'Core Team',
rate = '50',
auth_src = 'email',
last_login = curtime(),
last_updated_date = curtime(),
last_updated_by = 1,
interests = '#Service #localCommunities #NGO'
where user_id = 1;
Update philance.users
set Fname = 'Vijay',
lname ='Gabdra',
email = '[email protected]',
password ='welcome123',
ph_number = '1234567890',
organization = 'Philance',
title = 'Core Team',
rate = '50',
auth_src = 'email',
last_login = curtime(),
last_updated_date = curtime(),
last_updated_by = 2,
interests = '#Help #Service #localCommunities #NGO'
where user_id = 2;
/*Add User Skills and Certifications*/
insert into philance.user_skills
values (1, 'Database Development','Database Development', 'Yes', null, curdate()-300, null, curtime(), 1, curtime(), 1);
insert into philance.user_skills
values (1, 'BUSINESS', 'Project Management', 'Yes', null, curdate()-300, null, curtime(), 1, curtime(), 1);
insert into philance.user_skills
values (2, 'JAVA Development', 'JAVA Development', 'Yes', null, curdate()-300, null, curtime(), 1, curtime(), 1);
insert into philance.user_skills
values (2, 'Other', 'Project Lead', 'Yes', null, curdate()-300, null, curtime(), 1, curtime(), 1);
/* insert notification preferences for users */
insert into philance.user_notifications
values (1, 'Project Updates', 'Yes', 'No', 'Yes', curtime(), 1, curtime(), 1);
insert into philance.user_notifications
values (2, 'Project Updates', 'Yes', 'Yes', 'Yes', curtime(), 2, curtime(), 2);
insert into philance.user_notifications
values (2, 'Message', 'Yes', 'No', 'Yes', curtime(), 2, curtime(), 2);
/* User Creates a Project */
insert into philance.projects
values(1, 'Develop a database', 'Develop a database to support oldage home operations', 2, 2, 'Detroit, MI', curtime(), curtime()+3, '150', 'Active', curtime(), 1, curtime(),1);
/* insert skills needed, impact categories, and any other lists'*/
insert into philance.project_details
values (1, 'SKILLS', 'Database Development', 'No', null,null, null,null,null,null, curtime(),1,curtime(),1);
insert into philance.project_details
values (1, 'IMPACT_CATEGORY', 'Elderly', 'No', null,null, null,null,null,null, curtime(),1,curtime(),1);
insert into philance.project_details
values (1, 'IMPACT_CATEGORY', 'Other', 'No', null,'Oldage Homes', null,null,null,null, curtime(),1,curtime(),1);
/* add project attachments */
insert into philance.project_attachments
values (1, 'Data captured', 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX', curtime(), 1, curtime(),1);
insert into philance.project_tasks
values(1, 1, 'Create logical Diagram', 'create logical DB diagram', null, null, 'Pending', 5, null);
insert into philance.project_tasks
values(1, 2, 'Create DB Scripts', 'create DB scripts', null, null, 'Pending', 10, null);
/* users apply for project */
insert into philance.project_team
values (1, 2, 'Applicant', null, curtime(), curtime(), 'Please consider my application', 'APPLIED');
/* approve applicant to a project and assign a role*/
update philance.project_team
set role = 'Developer',
type = 'Project Member',
status = 'APPROVED'
where project_id = 1
and user_id =2;