[Comoblog-commit] comoblog/_install/upgrades 1.2_to_1.3.xml, NONE, 1.1
Status: Inactive
Brought to you by:
markwallis
|
From: iamdecal <iam...@us...> - 2006-10-22 11:44:16
|
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> |