|
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
|
-- );
|
|
12
|
|
|
13
|
|
|
14
|
CREATE TABLE metrics(
|
|
15
|
id VARCHAR(60) NOT NULL,
|
|
16
|
metrics_per_dashboard json NOT NULL,
|
|
17
|
date TIMESTAMP WITH TIME ZONE,
|
|
18
|
PRIMARY KEY(id)
|
|
19
|
);
|
|
20
|
|
|
21
|
insert into metrics (id, metrics_per_dashboard, date) values('current', '[]', current_timestamp);
|