ALTER TABLE pphl_agents MODIFY browser varchar(8) NOT NULL DEFAULT '', MODIFY version FLOAT NOT NULL DEFAULT '0', MODIFY system varchar(15) NOT NULL DEFAULT ''<br />
ALTER TABLE pphl_css MODIFY css varchar(200) NOT NULL default ''<br />
INSERT INTO pphl_css VALUES (NULL, 0, 'tierwaisen', '800000', 'ffcf0f', '800000', 'navy', 'ffff99', '800000', '000000', '800000', 'ffffff', 'ffffff', '9e9e9e', 'navy', 'navy', '800000', '000000', 'E3E3D7', '800000', '800000', '800000', 'E3E3D7', '800000', '800000', 'CCCCCC', 'navy')<br />
<b>warning: Duplicate entry '0-tierwaisen' for key 'css_ind'</b><br />
UPDATE pphl_10859_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_10859_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_15362_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_15362_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_29245_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_29245_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_35119_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_35119_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_48708_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_48708_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_51259_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_51259_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_51618_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_51618_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_53378_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_53378_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_57850_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_57850_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_62211_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_62211_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_70038_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_70038_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_82575_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_82575_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_91077_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_91077_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_93240_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_93240_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_98662_logs SET agentid = 1079 WHERE agentid IS NULL<br />
ALTER TABLE pphl_98662_logs MODIFY agentid INT UNSIGNED NOT NULL DEFAULT '0'<br />
UPDATE pphl_settings SET type = 'mta' WHERE setting = 'mail_mod'<br />
UPDATE pphl_cache SET cache = '2221' WHERE type = 'curr_ver'<br />
<b>warning: Table 'DB497247.pphl_cache' doesn't exist</b><br />
[ total execution time: 0.047866106033325 seconds]<br />
<br />
<b>Your upgrade to v.2.2.2a was successful!</b>