Project

General

Profile

1
ALTER TABLE project DROP COLUMN token RESTRICT;
2
ALTER TABLE project DROP COLUMN notify RESTRICT;
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
);
(1-1/4)