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

[iamdecal <iam...@us...>]

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

Added Files:
	1.2_to_1.3.xml 
Log Message:
work in progress, ditching this server cos its borked ;(



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

<comoblog_upgrade>


   <dbquery>
	ALTER TABLE comoblog_comments ADD comment_live VARCHAR( 1 ) NOT NULL default 'N' AFTER post_id;
   </dbquery>

   <dbquery>
	CREATE TABLE comoblog_commenters (commenter_id int(10) unsigned NOT NULL auto_increment,
	commenter_author_email varchar(128) default NULL, commenter_default varchar(1) default 'N' PRIMARY KEY (commenter_id), KEY (commenter_author_email));
   </dbquery>

	<dbquery>
        update comoblog_preferences set pref_value='1.3' where pref_name='CFG_VERSION';
   </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_COMMENTS_DEFAULT_STATE', 'no', 'Are Comments Live By Default?', 5, '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_COMMENTS_QUICK_PASS', '', 'Add a password for quick changes to commenting users (with Mod Comment Notify) DO NOT USE YOUR MAIN SITE PASSWORD', 5, 'Y', 'password', '16', '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_COMMENT_SORT_ORDER', 'no', 'Comment Sort Method?', 5, 'N', 'select', 'asc|desc', 'N', 'Y', 5, '');
   </dbquery>




</comoblog_upgrade>