dnet45/modules/uoa-claims/trunk/db_script.sql @ 61387
1 | 53201 | konstantin | ALTER TABLE project DROP COLUMN token RESTRICT; |
---|---|---|---|
2 | ALTER TABLE project DROP COLUMN notify RESTRICT; |
||
3 | |||
4 | 57029 | argiro.kok | -- 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 | -- );
|