Project

General

Profile

« Previous | Next » 

Revision 59805

Added by Konstantinos Triantafyllou over 3 years ago

[User Management]: Update registered service table and methods

View differences:

create-table
12 12 

  		




  13
  13
  
    
CREATE TABLE registered_service (


  		




  14
  14
  
    
 id SERIAL PRIMARY KEY,


  		




  15
  
  
    
 aai_id VARCHAR(255) NOT NULL,


  		




  
  15
  
    
 client_id VARCHAR(255) NOT NULL,


  		




  16
  16
  
    
 owner VARCHAR(255) NOT NULL,


  		




  17
  17
  
    
 name VARCHAR(255) NOT NULL,


  		




  18
  
  
    
 creation_date TIMESTAMP NOT NULL


  		




  
  18
  
    
 creation_date TIMESTAMP NOT NULL,


  		




  
  19
  
    
 registration_access_token TEXT NOT NULL


  		




  19
  20
  
    
);


  		




  20
  21
  
    

  		




  21
  22
  
    
GRANT ALL PRIVILEGES ON TABLE registered_service TO postgresi2;


  		












Also available in:  Unified diff