/[pdpsoft]/trunk/eu.rcauth.pilot-ica/DS/ansible/roles/delegserver/templates/oa4mp-server-mysql.sql.j2
ViewVC logotype

Diff of /trunk/eu.rcauth.pilot-ica/DS/ansible/roles/delegserver/templates/oa4mp-server-mysql.sql.j2

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 3006 by tamasb, Tue Mar 15 11:48:53 2016 UTC revision 3007 by tamasb, Tue May 3 17:07:17 2016 UTC
# Line 63  CREATE TABLE IF NOT EXISTS {{ oa4mp_serv Line 63  CREATE TABLE IF NOT EXISTS {{ oa4mp_serv
63    certificate         TEXT,    certificate         TEXT,
64    username            TEXT,    username            TEXT,
65    myproxyUsername     TEXT,    myproxyUsername     TEXT,
66      claims              TEXT CHARACTER SET 'utf8',
67      user_attributes     TEXT CHARACTER SET 'utf8',
68      trace_record        TEXT,
69    UNIQUE INDEX verifier (verifier_token(255)),    UNIQUE INDEX verifier (verifier_token(255)),
70    UNIQUE INDEX accessToken (access_token(255)),    UNIQUE INDEX accessToken (access_token(255)),
71    UNIQUE INDEX refreshToken (refresh_token(255)),    UNIQUE INDEX refreshToken (refresh_token(255)),
# Line 70  CREATE TABLE IF NOT EXISTS {{ oa4mp_serv Line 73  CREATE TABLE IF NOT EXISTS {{ oa4mp_serv
73  );  );
74    
75    
76    CREATE TABLE IF NOT EXISTS {{ oa4mp_server_db }}.trace_records (
77      cn_hash             CHAR(44),
78      sequence_nr         SMALLINT UNSIGNED,
79      attribute_hash      CHAR(44),
80      attribute_salt      CHAR(44),
81      attribute_names     TEXT,
82      first_seen          TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
83      last_seen           TIMESTAMP,
84      PRIMARY KEY (cn_hash, sequence_nr)
85    );
86    
87  COMMIT;  COMMIT;
88  # Now to grant restricted access. The  tables have to exist before this step  
89    /*
90     Now to grant restricted access. The  tables have to exist before this step
91    */
92    
93  GRANT ALL ON {{ oa4mp_server_db }}.client_approvals  GRANT ALL ON {{ oa4mp_server_db }}.client_approvals
94          TO '{{ oa4mp_server_db_user }}'@'localhost'          TO '{{ oa4mp_server_db_user }}'@'localhost'
# Line 89  GRANT ALL ON {{ oa4mp_server_db }}.trans Line 106  GRANT ALL ON {{ oa4mp_server_db }}.trans
106          TO '{{ oa4mp_server_db_user }}'@'localhost'          TO '{{ oa4mp_server_db_user }}'@'localhost'
107          IDENTIFIED BY '{{ oa4mp_server_db_pw }}';          IDENTIFIED BY '{{ oa4mp_server_db_pw }}';
108    
109    GRANT ALL ON {{ oa4mp_server_db }}.trace_records
110            TO '{{ oa4mp_server_db_user }}'@'localhost'
111            IDENTIFIED BY '{{ oa4mp_server_db_pw }}';
112    
113  COMMIT;  COMMIT;

Legend:
Removed from v.3006  
changed lines
  Added in v.3007

grid.support@nikhef.nl
ViewVC Help
Powered by ViewVC 1.1.28