Project

General

Profile

« Previous | Next » 

Revision 53201

Add database sql script to remove 'token' and 'notify' from project table and create notification table.

View differences:

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

Also available in: Unified diff