Skip to content
Snippets Groups Projects
create-manager-db.sql 380 B
Newer Older
## Test IdP Account Manager DB creation script

CREATE TABLE `testaccounts` (
  `id` bigint(20) NOT NULL auto_increment,
  `user_password` varchar(50) NOT NULL,
  `creation_date` int default NULL,
  `expiration_date` int default NULL,
  `account_profile` varchar(100) NOT NULL,
  `sp_entityid` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;