From b9146efac50f027a1eac5f9a439bd276a6c71f0b Mon Sep 17 00:00:00 2001 From: INOPIAE Date: Tue, 26 Nov 2013 22:00:24 +0100 Subject: bug 1135: added some columns --- scripts/db_migrations/version3.sh | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'scripts/db_migrations/version3.sh') 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 -- cgit v1.2.1