diff options
| author | wei <> | 2006-07-16 06:27:25 +0000 |
|---|---|---|
| committer | wei <> | 2006-07-16 06:27:25 +0000 |
| commit | ed600b0d55dd7c38e4416cf4bd6df43a71244b81 (patch) | |
| tree | 697a6cd261201286b66230f5a9c4e344320f151e /demos/time-tracker/protected/App_Data/mysql-reset.sql | |
| parent | 567ab5d2b3545baf1fa536f23ea4f5ef6fe71d68 (diff) | |
Rename APP_CODE directory name again.
Diffstat (limited to 'demos/time-tracker/protected/App_Data/mysql-reset.sql')
| -rw-r--r-- | demos/time-tracker/protected/App_Data/mysql-reset.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/demos/time-tracker/protected/App_Data/mysql-reset.sql b/demos/time-tracker/protected/App_Data/mysql-reset.sql new file mode 100644 index 00000000..e9581952 --- /dev/null +++ b/demos/time-tracker/protected/App_Data/mysql-reset.sql @@ -0,0 +1,26 @@ +TRUNCATE `user_roles`;
+TRUNCATE `role_types`;
+TRUNCATE `project_members`;
+TRUNCATE `time_entry`;
+TRUNCATE `signon`;
+TRUNCATE `categories`;
+TRUNCATE `project`;
+TRUNCATE `users`;
+
+INSERT INTO role_types (RoleType, Description) VALUES
+('admin', 'Project administrator may additionally view the list of all users.'),
+('consultant', 'Consultant may log time entries only.'),
+('manager', 'Project manager may additionally edit all projects and view reports.');
+
+INSERT INTO users (Username, Password, EmailAddress, Disabled) VALUES
+('admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@pradosoft.com', 0),
+('manager', '1d0258c2440a8d19e716292b231e3190', 'manager@pradosoft.com', 0),
+('consultant', '7adfa4f2ba9323e6c1e024de375434b0', 'consultant@pradosoft.com', 0);
+
+INSERT INTO user_roles (UserID, RoleType) VALUES
+('admin', 'admin'),
+('admin', 'manager'),
+('admin', 'consultant'),
+('manager', 'manager'),
+('manager', 'consultant'),
+('consultant', 'consultant');
\ No newline at end of file |