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

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

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

Modified Files:
	1.0_to_1.1.xml 
Added Files:
	0.5.1_to_1.1.xml 
Log Message:
1378108 - DB data changes in point version upgrades now supported

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

<comoblog_upgrade>

   <dbquery>
	alter table comoblog_modules add column mod_version varchar(6) default NULL;
   </dbquery>

   <dbquery>
        alter table comoblog_modules add column mod_minimum_supported varchar(6) default NULL;
   </dbquery>    

   <dbquery>
        alter table comoblog_modules add column mod_certified varchar(255) default NULL;
   </dbquery>    

   <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_name='CFG_DISPLAY_COMOBLOGO',pref_description='Display "powered by CoMoblog" image' where pref_name="CFG_DISPLA
Y_EASYMOBLOGO"; 
   </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_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>

   <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_INTERACTION_HTML_COMMENTS', 'no', 'Allow HTML Comments', 4, 'N', 'select', 'no|yes', 'N', 'Y', 5, '');
   </dbquery>

   <dbquery>
	upgrade comoblog_preferences set pref_value='1.1' where pref_name='CFG_VERSION';
   </dbquery> 

   
</comoblog_upgrade>

Index: 1.0_to_1.1.xml
===================================================================
RCS file: /cvsroot/comoblog/comoblog/_install/upgrades/1.0_to_1.1.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- 1.0_to_1.1.xml	11 Dec 2005 12:22:30 -0000	1.1
+++ 1.0_to_1.1.xml	22 Dec 2005 05:30:19 -0000	1.2
@@ -6,5 +6,9 @@
 	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_INTERACTION_HTML_COMMENTS', 'no', 'Allow HTML Comments', 4, 'N', 'select', 'no|yes', 'N', 'Y', 5, '');
    </dbquery>
 
+   <dbquery>
+	update comoblog_preferences set pref_value='1.1' where pref_name='CFG_VERSION';
+   </dbquery> 
+
    
 </comoblog_upgrade>