summaryrefslogtreecommitdiffstats
path: root/extra/svn/create_views.sql
diff options
context:
space:
mode:
authorJean-Philippe Lang <jp_lang@yahoo.fr>2011-12-06 23:09:40 +0000
committerJean-Philippe Lang <jp_lang@yahoo.fr>2011-12-06 23:09:40 +0000
commit72eebe1ce102ec26b444b7bd25f07dd720150fe1 (patch)
treee06be9b3ba6a602578506f5a8848d7eebe3dc9d6 /extra/svn/create_views.sql
parenta63027e1755f3de952b51ce6f1ca3432591fe363 (diff)
downloadredmine-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.sql24
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;