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