Project

General

Profile

« Previous | Next » 

Revision 57661

Added by Michele Artini over 4 years ago

national admin management

View differences:

schema.sql
48 48 
			('TT'), ('TV'), ('TW'), ('TZ'), ('UA'), ('UG'), ('US'), ('UY'), ('UZ'), ('VA'), ('VC'), ('VE'), ('VG'), ('VN'), ('WS'), ('XK'), ('YE'), ('ZA'), ('ZM'), ('ZW');
49 49 

  		




  50
  50
  
    
CREATE TABLE user_roles(role text PRIMARY KEY);


  		




  51
  
  
    
INSERT INTO user_roles VALUES ('USER'), ('SUPERUSER'), ('PENDING');


  		




  
  51
  
    
INSERT INTO user_roles VALUES ('ADMIN'), ('NATIONAL_ADMIN'), ('USER'), ('PENDING'), ('NOT_AUTHORIZED');


  		




  52
  52
  
    

  		




  53
  53
  
    
CREATE TABLE users (


  		




  54
  54
  
    
	email     text PRIMARY KEY,


  		












Also available in:  Unified diff