


CREATE TABLE nameidmapping (
	idp varchar(80) NOT NULL,
	sp varchar(80) NOT NULL,
	nameid varchar(80) NOT NULL,
	localid varchar(80) NOT NULL,
	PRIMARY KEY (idp,sp,localid)
);

INSERT INTO nameidmapping VALUES ('openssodemo.idp.company.com', 'openssodemo.idp.company.com', 'YgolvKBPsL4ABSrdOpilovLnVq+X', 'johns');
INSERT INTO nameidmapping VALUES ('openssodemo.idp.company.com', 'openssodemo.idp.company.com', 'GsIcQLU2JvgDJ0ov2+SXVf29ncGF', 'admin');
