[Comoblog-commit] comoblog/_install/upgrades 0.5.1_to_1.0.xml,NONE,1.1

[Mark W. \(a. serialmonkey\) <mar...@us...>]

Update of /cvsroot/comoblog/comoblog/_install/upgrades
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23647/_install/upgrades

Added Files:
	0.5.1_to_1.0.xml 
Log Message:
UPGRADE component to installer added. Customed for 0.5.1->1.0 upgrade

--- NEW FILE: 0.5.1_to_1.0.xml ---
<?xml version="1.0" standalone="yes"?>

<comoblog_upgrade>

   <dbquery>  
	alter table comoblog_modules modify column mod_filter_posts enum('N','Y','O') NOT NULL default 'N';
   </dbquery>
   <dbquery>
	update comoblog_preferences SET pref_value='1.0' where pref_name='CFG_VERSION'; 
   </dbquery>
   <dbquery>
	update comoblog_preferences SET pref_description='Max width (in pixels) for post images (requires GD library)' where pref_name='CFG_IMG_MAX_W';
   </dbquery>
   <dbquery>
	update comoblog_preferences SET pref_description='Max height (in pixels) for post images (requirets GD library)' where pref_name='CFG_IMG_MAX_H';
   </dbquery>
   <dbquery>
	update comoblog_preferences SET pref_display_order=1 where pref_name='CFG_BODY_BGCOLOR';
   </dbquery>
   <dbquery>
	update comoblog_preferences SET pref_display_order=2 where pref_name='CFG_PAGE_WIDTH';
   </dbquery>
   <dbquery>
	update comoblog_preferences SET pref_display_order=3 where pref_name='CFG_BG_IMG';
   </dbquery>
   <dbquery>
	insert into comoblog_preferences (pref_name, pref_value, pref_description, pref_topic_id, pref_encrypt, pref_type, pref_restrict_values, pref_accept_null, pref_editable, pref_display_order, mod_name) VALUES ('CFG_CALENDAR_BUTTON_CONFIG','Skip One Day', 'When pressing the next/prev buttons the function should be', 0, 'N', 'select', 'Skip One Day|Skip One Month|Skip to Next Posted Day', 'N', 'Y', 0, 'mod_calendar'); 
   </dbquery>
   <dbquery>
	insert into comoblog_preferences (pref_name, pref_value, pref_description, pref_topic_id, pref_encrypt, pref_type, pref_restrict_values, pref_accept_null, pref_editable, pref_display_order, mod_name) VALUES ('CFG_CALENDAR_DAY_OFFSET','Sunday', 'Option to choose the first day of the week in the calendar', 0, 'N', 'select', 'Saturday|Sunday|Monday|Tuesday|Wednesday|Thursday|Friday', 'N', 'Y', 0, 'mod_calendar'); 
   </dbquery>
   <dbquery>
	insert into comoblog_preferences (pref_name, pref_value, pref_description, pref_topic_id, pref_encrypt, pref_type, pref_restrict_values, pref_accept_null, pref_editable, pref_display_order, mod_name) VALUES ('CFG_ALLOW_HTML','yes', 'Allow HTML from posts to be displayed', 1, 'N', 'select', 'yes|no', 'N', 'Y', 0, '');  
   </dbquery>
   <dbquery>
	insert into comoblog_preferences (pref_name, pref_value, pref_description, pref_topic_id, pref_encrypt, pref_type, pref_restrict_values, pref_accept_null, pref_editable, pref_display_order, mod_name) VALUES ('CFG_MAX_ALLOWED_IMAGES', 'unlimited', 'The maximum number of images that will be read from an email post.', 1, 'N', 'select', 'unlimited|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|10', 'N', 'Y', 0, ''); 
   </dbquery>
   <dbquery>
	insert into comoblog_preferences (pref_name, pref_value, pref_description, pref_topic_id, pref_encrypt, pref_type, pref_restrict_values, pref_accept_null, pref_editable, pref_display_order, mod_name) VALUES ('CFG_BG_IMG_REPEAT', 'repeat', 'Repeat of background image', 14, 'N', 'select', 'repeat|repeat-x|repeat-y|no-repeat', 'N', 'Y', 4, '');        
   </dbquery>
   <dbquery>
	insert into comoblog_preferences (pref_name, pref_value, pref_description, pref_topic_id, pref_encrypt, pref_type, pref_restrict_values, pref_accept_null, pref_editable, pref_display_order, mod_name) VALUES ('CFG_MAIL_DEBUG', 'no', 'POP3 enable debugging', 4, 'N', 'select', 'no|yes', 'N', 'Y', 5, '');
   </dbquery>
   <dbquery>
	insert into comoblog_preferences (pref_name, pref_value, pref_description, pref_topic_id, pref_encrypt, pref_type, pref_restrict_values, pref_accept_null, pref_editable, pref_display_order, mod_name) VALUES ('CFG_MAIL_APOP', 'no', 'POP3 enable APOP protocol', 4, 'N', 'select', 'no|yes', 'N', 'Y', 4, '');
   </dbquery>

</comoblog_upgrade>