| 1 |
lars |
1 |
TRUNCATE `user_roles`;
|
|
|
2 |
TRUNCATE `role_types`;
|
|
|
3 |
TRUNCATE `project_members`;
|
|
|
4 |
TRUNCATE `time_entry`;
|
|
|
5 |
TRUNCATE `signon`;
|
|
|
6 |
TRUNCATE `categories`;
|
|
|
7 |
TRUNCATE `project`;
|
|
|
8 |
TRUNCATE `users`;
|
|
|
9 |
|
|
|
10 |
INSERT INTO role_types (RoleType, Description) VALUES
|
|
|
11 |
('admin', 'Project administrator may additionally view the list of all users.'),
|
|
|
12 |
('consultant', 'Consultant may log time entries only.'),
|
|
|
13 |
('manager', 'Project manager may additionally edit all projects and view reports.');
|
|
|
14 |
|
|
|
15 |
INSERT INTO users (Username, Password, EmailAddress, Disabled) VALUES
|
|
|
16 |
('admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@pradosoft.com', 0),
|
|
|
17 |
('manager', '1d0258c2440a8d19e716292b231e3190', 'manager@pradosoft.com', 0),
|
|
|
18 |
('consultant', '7adfa4f2ba9323e6c1e024de375434b0', 'consultant@pradosoft.com', 0);
|
|
|
19 |
|
|
|
20 |
INSERT INTO user_roles (UserID, RoleType) VALUES
|
|
|
21 |
('admin', 'admin'),
|
|
|
22 |
('admin', 'manager'),
|
|
|
23 |
('admin', 'consultant'),
|
|
|
24 |
('manager', 'manager'),
|
|
|
25 |
('manager', 'consultant'),
|
|
|
26 |
('consultant', 'consultant');
|