summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorINOPIAE <inopiae@cacert.org>2013-11-26 22:00:24 +0100
committerINOPIAE <inopiae@cacert.org>2013-11-26 22:00:24 +0100
commitb9146efac50f027a1eac5f9a439bd276a6c71f0b (patch)
tree267a8862b17cb369f49dbbc2bdc9767cc55d2a15
parentfa490ac8dfbf9cd52fb31d5d46c4a928dacc6fb7 (diff)
downloadcacert-devel-b9146efac50f027a1eac5f9a439bd276a6c71f0b.tar.gz
cacert-devel-b9146efac50f027a1eac5f9a439bd276a6c71f0b.tar.xz
cacert-devel-b9146efac50f027a1eac5f9a439bd276a6c71f0b.zip
bug 1135: added some columns
-rw-r--r--scripts/db_migrations/version3.sh8
1 files changed, 8 insertions, 0 deletions
diff --git a/scripts/db_migrations/version3.sh b/scripts/db_migrations/version3.sh
index 2bf90e9..cbaa9ac 100644
--- a/scripts/db_migrations/version3.sh
+++ b/scripts/db_migrations/version3.sh
@@ -76,6 +76,14 @@ CREATE TABLE IF NOT EXISTS `orgadminlog` (
`information` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+-- alter table OrgDomainCerts
+ALTER TABLE `OrgDomainCerts` ADD orgadminid int(11) NULL,
+ ADD revokeorgadminid int(11) NULL
+
+-- alter table OrgEmailCerts
+ALTER TABLE `OrgEmailCerts` ADD orgadminid int(11) NULL,
+ ADD revokeorgadminid int(11) NULL
+
-- Update schema version number