diff options
| author | Markus Warg <mw@it-sls.de> | 2010-04-22 11:42:07 +0200 |
|---|---|---|
| committer | Markus Warg <mw@it-sls.de> | 2010-04-22 11:42:07 +0200 |
| commit | 80ef52e1a22bf509b684eaa716e9d3b3e99ce180 (patch) | |
| tree | cf58eccabc6b1ec963c79ef40042f30a6270d1fd /dbadm | |
| parent | acdc60dea4f73179c129e2cb59d9dbd13d9a9a28 (diff) | |
| download | cacert-mgr-80ef52e1a22bf509b684eaa716e9d3b3e99ce180.tar.gz cacert-mgr-80ef52e1a22bf509b684eaa716e9d3b3e99ce180.tar.xz cacert-mgr-80ef52e1a22bf509b684eaa716e9d3b3e99ce180.zip | |
db layout / data changes
add some config parameters to config db
add field to system_user (cert login)
Diffstat (limited to 'dbadm')
| -rw-r--r-- | dbadm/ca_mgr.mysql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/dbadm/ca_mgr.mysql b/dbadm/ca_mgr.mysql index 1542932..d497c2f 100644 --- a/dbadm/ca_mgr.mysql +++ b/dbadm/ca_mgr.mysql @@ -61,7 +61,7 @@ SET character_set_client = @saved_cs_client; LOCK TABLES `system_config` WRITE; /*!40000 ALTER TABLE `system_config` DISABLE KEYS */; -INSERT INTO `system_config` VALUES (588,'log.file.name','/tmp/ca_mgr.log'),(589,'log.file.enabled','0'),(590,'log.syslog.facility','128'),(591,'log.syslog.enabled','1'),(592,'log.priority','7'); +INSERT INTO `system_config` VALUES (588,'log.file.name','/tmp/ca_mgr.log'),(589,'log.file.enabled','0'),(590,'log.syslog.facility','128'),(591,'log.syslog.enabled','1'),(592,'log.priority','7'),(624,'imap.port','143'),(623,'log.application','ca_mgr'),(622,'imap.use_tls','1'),(621,'imap.password','cacertmail'),(620,'imap.username','cacertmail'),(619,'imap.mailhost','localhost'); /*!40000 ALTER TABLE `system_config` ENABLE KEYS */; UNLOCK TABLES; @@ -155,6 +155,7 @@ CREATE TABLE `system_user` ( `id` bigint(20) NOT NULL auto_increment, `system_role_id` bigint(20) NOT NULL, `login` varchar(255) collate utf8_unicode_ci NOT NULL default '', + `user_client_crt_s_dn_i_dn` varchar(128) collate utf8_unicode_ci NOT NULL, 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 @@ -167,6 +168,7 @@ SET character_set_client = @saved_cs_client; LOCK TABLES `system_user` WRITE; /*!40000 ALTER TABLE `system_user` DISABLE KEYS */; +INSERT INTO `system_user` VALUES (1,2,'cacert1@quarkus.de','/CN=Markus Warg/emailAddress=markus@cacert.org///O=CAcert Inc./OU=http://www.CAcert.org/CN=CAcert Class 3 Root'); /*!40000 ALTER TABLE `system_user` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |