summaryrefslogtreecommitdiff
path: root/scripts/db_migrations/version3.sh
diff options
context:
space:
mode:
Diffstat (limited to 'scripts/db_migrations/version3.sh')
-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