jro_apps/redmine Files · extra/svn/create_views.sql

Changes ruby bang path to #!/usr/bin/env ruby (#1876)....

Changes ruby bang path to #!/usr/bin/env ruby (#1876). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2017 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r393:4ff8386e3dfe


                r2015:ad97165f1b04

Download file

             create_views.sql
        
                    24 lines
            
             | 631 B
            
                | text/x-sql
            
             |
                SqlLexer
            
             / extra / svn / create_views.sql
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      /* 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;

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				/* 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;