dnet45/modules/uoa-claims/trunk/db_script.sql @ 55043
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 |
);
|