diff options
| author | Markus Warg <mw@it-sls.de> | 2010-04-14 12:46:51 +0200 |
|---|---|---|
| committer | Markus Warg <mw@it-sls.de> | 2010-04-14 12:46:51 +0200 |
| commit | d09a673644f87ee067f62f3de978cb046a02c7a8 (patch) | |
| tree | 74447b752918485fc07252815e9284752436823e /dbadm | |
| parent | 98a5e0d7416909104e4a665c421d5e42c8b91c2e (diff) | |
| download | cacert-mgr-d09a673644f87ee067f62f3de978cb046a02c7a8.tar.gz cacert-mgr-d09a673644f87ee067f62f3de978cb046a02c7a8.tar.xz cacert-mgr-d09a673644f87ee067f62f3de978cb046a02c7a8.zip | |
enable crt login
to use crt login, a string which resembles parts of the crt cn and dn needs to exist in an system_user
record. The string is combined from SSL_CLIENT_S_DN and SSL_CLIENT_I_DN:
SSL_CLIENT_S_DN + "//" + SSL_CLIENT_I_DN
Diffstat (limited to 'dbadm')
| -rw-r--r-- | dbadm/ca_mgr.mysql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/dbadm/ca_mgr.mysql b/dbadm/ca_mgr.mysql index 43f4f0e..1542932 100644 --- a/dbadm/ca_mgr.mysql +++ b/dbadm/ca_mgr.mysql @@ -153,8 +153,12 @@ SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `system_user` ( `id` bigint(20) NOT NULL auto_increment, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; + `system_role_id` bigint(20) NOT NULL, + `login` varchar(255) collate utf8_unicode_ci NOT NULL default '', + PRIMARY KEY (`id`), + KEY `fk_system_user_system_role1` (`system_role_id`), + CONSTRAINT `fk_system_user_system_role1` FOREIGN KEY (`system_role_id`) REFERENCES `system_role` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION +) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- |