diff options
| author | INOPIAE <inopiae@cacert.org> | 2013-11-26 22:00:24 +0100 |
|---|---|---|
| committer | INOPIAE <inopiae@cacert.org> | 2013-11-26 22:00:24 +0100 |
| commit | b9146efac50f027a1eac5f9a439bd276a6c71f0b (patch) | |
| tree | 267a8862b17cb369f49dbbc2bdc9767cc55d2a15 /scripts | |
| parent | fa490ac8dfbf9cd52fb31d5d46c4a928dacc6fb7 (diff) | |
| download | cacert-devel-b9146efac50f027a1eac5f9a439bd276a6c71f0b.tar.gz cacert-devel-b9146efac50f027a1eac5f9a439bd276a6c71f0b.tar.xz cacert-devel-b9146efac50f027a1eac5f9a439bd276a6c71f0b.zip | |
bug 1135: added some columns
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/db_migrations/version3.sh | 8 |
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 |