Файл: severus/UPGRADE.txt
Строк: 51
Please read the following instructions if you want to upgrade rather than
reinstalling.
Reinstalling is the easiest, but if you want to keep your
current server list / settings, do the following.
Copy you database file
from /application/config/database.php upload all the files then replace
database.php with your saved version
Check your current version and run
every SQL statement from your current version, up to the latest version
If
your current version
is:
============================
v1.1
============================
ALTER
TABLE `settings` ADD `setting_email_notification` VARCHAR( 255 ) NULL
DEFAULT
NULL
============================
v1.3
============================
ALTER
TABLE `settings` ADD `setting_theme` VARCHAR(255) NULL DEFAULT NULL ;
ALTER
TABLE `services` ADD `service_advanced` TINYINT(1) NOT NULL DEFAULT '0' ,
ADD `service_script` VARCHAR(255) NULL DEFAULT NULL ;
ALTER TABLE
`services` ADD INDEX(`service_advanced`);
ALTER TABLE `servers_services`
ADD `lnk_service_script` VARCHAR(255) NULL DEFAULT NULL ;
ALTER TABLE
`servers_services` CHANGE `lnk_service_port` `lnk_service_port` INT(11)
NULL DEFAULT NULL;
ALTER TABLE `server_responses` ADD `res_disk` TEXT NULL
DEFAULT NULL ;
CREATE TABLE IF NOT EXISTS `metrics` (
`metric_id` int(11)
NOT NULL AUTO_INCREMENT,
`metric_name` varchar(255) NOT NULL,
`metric_additional` tinyint(1) NOT NULL DEFAULT '0',
`metric_public`
tinyint(1) NOT NULL DEFAULT '1',
`metric_order` int(11) NOT NULL DEFAULT
'1',
PRIMARY KEY (`metric_id`),
KEY `metric_order` (`metric_order`),
KEY `metric_public` (`metric_public`)
) AUTO_INCREMENT=9 ;
INSERT INTO
`metrics` (`metric_id`, `metric_name`, `metric_additional`,
`metric_public`, `metric_order`) VALUES
(1, 'server_server', 0, 1, 1),
(2,
'server_ip', 0, 0, 2),
(3, 'server_load', 0, 1, 3),
(4, 'server_response',
1, 1, 4),
(5, 'server_model', 1, 1, 5),
(6, 'server_processes', 1, 1,
6),
(7, 'server_memory', 1, 1, 7),
(8, 'server_services', 0, 1, 8);