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/5)