diff options
author | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2011-12-06 23:09:40 +0000 |
---|---|---|
committer | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2011-12-06 23:09:40 +0000 |
commit | 72eebe1ce102ec26b444b7bd25f07dd720150fe1 (patch) | |
tree | e06be9b3ba6a602578506f5a8848d7eebe3dc9d6 /extra/svn/create_views.sql | |
parent | a63027e1755f3de952b51ce6f1ca3432591fe363 (diff) | |
download | redmine-72eebe1ce102ec26b444b7bd25f07dd720150fe1.tar.gz redmine-72eebe1ce102ec26b444b7bd25f07dd720150fe1.zip |
Removed obsolete nss/svn scripts.
git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@8104 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'extra/svn/create_views.sql')
-rw-r--r-- | extra/svn/create_views.sql | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/extra/svn/create_views.sql b/extra/svn/create_views.sql deleted file mode 100644 index ce02e0817..000000000 --- a/extra/svn/create_views.sql +++ /dev/null @@ -1,24 +0,0 @@ -/* ssh views */ - -CREATE OR REPLACE VIEW ssh_users as -select login as username, hashed_password as password -from users -where status = 1; - - -/* nss views */ - -CREATE OR REPLACE VIEW nss_groups AS -select identifier AS name, (id + 5000) AS gid, 'x' AS password -from projects; - -CREATE OR REPLACE VIEW nss_users AS -select login AS username, CONCAT_WS(' ', firstname, lastname) as realname, (id + 5000) AS uid, 'x' AS password -from users -where status = 1; - -CREATE OR REPLACE VIEW nss_grouplist AS -select (members.project_id + 5000) AS gid, users.login AS username -from users, members -where users.id = members.user_id -and users.status = 1; |