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 NOT NULL default CURRENT_TIMESTAMP,
7 PRIMARY KEY (`username`,`gss_acceptor`,`namespace`)