diff options
| author | wei <> | 2006-07-28 12:32:01 +0000 |
|---|---|---|
| committer | wei <> | 2006-07-28 12:32:01 +0000 |
| commit | 623447ffea7a49359c773a0bc3a851397885f319 (patch) | |
| tree | 93676acdeea5697dd00fb10d0eb70948901b549e /demos/time-tracker/protected/App_Data/mysql-reset.sql | |
| parent | fbf05a159bc1a688940c16dc304eaaf140188b01 (diff) | |
Add sqlite support for time-tracker.
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, 0 insertions, 26 deletions
diff --git a/demos/time-tracker/protected/App_Data/mysql-reset.sql b/demos/time-tracker/protected/App_Data/mysql-reset.sql deleted file mode 100644 index e9581952..00000000 --- a/demos/time-tracker/protected/App_Data/mysql-reset.sql +++ /dev/null @@ -1,26 +0,0 @@ -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 |