|
Revision 1206, 0.9 kB
(checked in by rats, 6 months ago)
|
* Fixed 1346: client mysql password length
* Fixed #1215: POP/IMAP traffic is not added in domain statistics with courier and fedora core 8
* Fixed #1345: Bug in mail log collection (ispcp-vrl-traff)
|
| Line | |
|---|
| 1 |
-- |
|---|
| 2 |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
|---|
| 3 |
SET AUTOCOMMIT=0; |
|---|
| 4 |
|
|---|
| 5 |
START TRANSACTION; |
|---|
| 6 |
USE {DATABASE}; |
|---|
| 7 |
|
|---|
| 8 |
-- BEGIN: Upgrade database structure: |
|---|
| 9 |
UPDATE `config` SET `value` = '1' WHERE `name` = 'DATABASE_REVISION' LIMIT 1; |
|---|
| 10 |
ALTER IGNORE TABLE `sql_user` CHANGE `sqlu_name` `sqlu_name` varchar(64) binary DEFAULT 'n/a'; |
|---|
| 11 |
ALTER IGNORE TABLE `sql_user` CHANGE `sqlu_pass` `sqlu_pass` varchar(64) binary DEFAULT 'n/a'; |
|---|
| 12 |
-- END: Upgrade database structure |
|---|
| 13 |
|
|---|
| 14 |
-- BEGIN: Regenerate config files: |
|---|
| 15 |
UPDATE `domain` SET `domain_status` = 'change' WHERE `domain_status` = 'ok'; |
|---|
| 16 |
UPDATE `subdomain` SET `subdomain_status` = 'change' WHERE `subdomain_status` = 'ok'; |
|---|
| 17 |
UPDATE `domain_aliasses` SET `alias_status` = 'change' WHERE `alias_status` = 'ok'; |
|---|
| 18 |
UPDATE `mail_users` SET `status` = 'change' WHERE `status` = 'ok'; |
|---|
| 19 |
-- END: Regenerate config files |
|---|
| 20 |
|
|---|
| 21 |
COMMIT; |
|---|
| 22 |
|
|---|
| 23 |
-- Change charset: |
|---|
| 24 |
ALTER DATABASE `{DATABASE}` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; |
|---|
