1 CREATE TABLE moonshot_targeted_ids (
2 gss_acceptor varchar(254) NOT NULL DEFAULT '',
3 namespace varchar(36) NOT NULL DEFAULT '',
4 username varchar(64) NOT NULL DEFAULT '',
5 targeted_id varchar(128) NOT NULL DEFAULT '',
6 creationdate TIMESTAMP with time zone NOT NULL default 'now()',
7 PRIMARY KEY (username, gss_acceptor, namespace)