summaryrefslogtreecommitdiff
path: root/demos/time-tracker/protected/App_Data/mysql-reset.sql
diff options
context:
space:
mode:
authorwei <>2006-07-16 06:27:25 +0000
committerwei <>2006-07-16 06:27:25 +0000
commited600b0d55dd7c38e4416cf4bd6df43a71244b81 (patch)
tree697a6cd261201286b66230f5a9c4e344320f151e /demos/time-tracker/protected/App_Data/mysql-reset.sql
parent567ab5d2b3545baf1fa536f23ea4f5ef6fe71d68 (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.sql26
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