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