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.sh12
1 files changed, 6 insertions, 6 deletions
diff --git a/scripts/db_migrations/version3.sh b/scripts/db_migrations/version3.sh
index 55dfeca..8febfe7 100644
--- a/scripts/db_migrations/version3.sh
+++ b/scripts/db_migrations/version3.sh
@@ -64,7 +64,7 @@ mysql $mysql_opt <<- 'SQL'
-- alter table Admin log
ALTER TABLE `adminlog` ADD `type` VARCHAR( 50 ) NOT NULL ,
- ADD `information` VARCHAR( 50 ) NOT NULL
+ ADD `information` VARCHAR( 50 ) NOT NULL;
-- create new table OrgAdminLog
@@ -73,16 +73,16 @@ CREATE TABLE IF NOT EXISTS `orgadminlog` (
`oid` int(11) NOT NULL,
`adminid` int(11) NOT NULL,
`type` varchar(50) NOT NULL,
- `information` varchar(100) NOT NULL
+ `information` varchar(50) 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 `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
+ALTER TABLE `orgemailcerts` ADD orgadminid int(11) NULL,
+ ADD revokeorgadminid int(11) NULL;