Project

General

Profile

« Previous | Next » 

Revision 57029

Added by Argiro Kokogiannaki over 4 years ago

-Remove methods and classes used for the migration from old database schema to new
-Remove communities XMLs
-rearrange packages (remove 'migration' and 'claimsDemo') Properties paths didn't change!

View differences:

db_script.sql
1 1 
ALTER TABLE project DROP COLUMN token RESTRICT;
2 2 
ALTER TABLE project DROP COLUMN notify RESTRICT;
3 3 

  		




  4
  
  
    
CREATE TABLE notification(


  		




  5
  
  
    
	openaire_id	VARCHAR(60)		NOT NULL,


  		




  6
  
  
    
	user_email	VARCHAR(256)	NOT NULL,


  		




  7
  
  
    
	frequency	INT				NOT NULL,


  		




  8
  
  
    
	notify		BOOLEAN			DEFAULT TRUE,


  		




  9
  
  
    
	last_interaction_date TIMESTAMP WITHOUT TIME ZONE,


  		




  10
  
  
    
	PRIMARY KEY(openaire_id, user_email)


  		




  11
  
  
    
);


  		




  
  4
  
    
-- CREATE TABLE notification(


  		




  
  5
  
    
-- 	openaire_id	VARCHAR(60)		NOT NULL,


  		




  
  6
  
    
-- 	user_email	VARCHAR(256)	NOT NULL,


  		




  
  7
  
    
-- 	frequency	INT				NOT NULL,


  		




  
  8
  
    
-- 	notify		BOOLEAN			DEFAULT TRUE,


  		




  
  9
  
    
-- 	last_interaction_date TIMESTAMP WITHOUT TIME ZONE,


  		




  
  10
  
    
-- 	PRIMARY KEY(openaire_id, user_email)


  		




  
  11
  
    
-- );


  		












Also available in:  Unified diff