--
-- This file contains additional database operations to be executed after the drush-update of all modules.
--  $ Id: $
-- 

-- --------------------------------------------------------

TRUNCATE TABLE `permission`;
CREATE TABLE IF NOT EXISTS `permission` (
  `pid` int(11) NOT NULL auto_increment,
  `rid` int(10) unsigned NOT NULL default '0',
  `perm` longtext,
  `tid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pid`),
  KEY `rid` (`rid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

INSERT INTO `permission` (`pid`, `rid`, `perm`, `tid`) VALUES
(1, 1, 'access comments, search Google CSE, view original images, access content, search content, use advanced search, view uploaded files', 0),
(2, 2, 'access comments, post comments, post comments without approval, create forum topics, edit own forum topics, search Google CSE, view original images, create issue, access content, view revisions, origo create project, origo request application key, search content, use advanced search, upload files, view uploaded files, access user profiles', 0),
(3, 3, 'create blog entries, delete any blog entry, delete own blog entries, edit any blog entry, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, administer forums, create forum topics, delete any forum topic, delete own forum topics, edit any forum topic, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, access content, create wiki content, delete any wiki content, delete own wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo create project, origo create release, origo delete release, origo project settings, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles', 0),
(4, 4, 'create blog entries, delete own blog entries, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, create forum topics, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, access content, create wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo create project, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles', 0),
(5, 5, 'create blog entries, delete any blog entry, delete own blog entries, edit any blog entry, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, administer forums, create forum topics, delete any forum topic, delete own forum topics, edit any forum topic, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, access content, create wiki content, delete any wiki content, delete own wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo admin access, origo create project, origo create release, origo delete release, origo project settings, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles', 0);

-- --------------------------------------------------------
-- remove artefact from old modules that are no longer supported.
--
DELETE FROM `system` WHERE `filename`='sites/all/modules/foaf/foaf.module';
DELETE FROM `system` WHERE `filename`='sites/all/modules/form_store/form_collect.module';
DELETE FROM `system` WHERE `filename`='sites/all/modules/form_store/form_store.module';
DELETE FROM `system` WHERE `filename`='sites/all/modules/origo_openid/origo_openid.module';
DELETE FROM `system` WHERE `filename`='sites/all/modules/password_strength/password_strength.module';
DELETE FROM `system` WHERE `filename`='sites/all/modules/profile_import/profile_import.module';
DELETE FROM `system` WHERE `filename`='sites/all/modules/recent_changes/recent_changes.module';
DELETE FROM `system` WHERE `filename`='sites/all/modules/sioc/sioc.module';

-- --------------------------------------------------------
-- update/set some drupal variables
--
DELETE FROM `variable` WHERE `name` LIKE 'pathauto_%';
INSERT IGNORE INTO `variable` (`name`, `value`) VALUES
  ('comment_preview_blog', 's:1:"0";'),
  ('comment_preview_image', 's:1:"0";'),
  ('comment_preview_issue', 's:1:"0";'),
  ('comment_preview_wiki', 's:1:"0";'),
  ('comment_preview_forum', 's:1:"0";'),
  ('google_cse_results_tab', 's:6:"Global";'),
  ('google_cse_sitesearch_default', 'i:1;'),
  ('node_options_page', 'a:1:{i:0;s:6:"status";}'),
  ('pathauto_blog_applytofeeds', 's:4:"feed";'),
  ('pathauto_blog_bulkupdate', 'i:0;'),
  ('pathauto_blog_pattern', 's:15:"blog/[author-name-raw]";'),
  ('pathauto_blog_supportsfeeds', 's:4:"feed";'),
  ('pathauto_case', 's:1:"1";'),
  ('pathauto_forum_applytofeeds', 's:6:"0/feed";'),
  ('pathauto_forum_bulkupdate', 'i:0;'),
  ('pathauto_forum_pattern', 's:25:"[vocab-raw]/[catpath-raw]";'),
  ('pathauto_forum_supportsfeeds', 's:6:"0/feed";'),
  ('pathauto_ignore_words', 's:0:"";'),
  ('pathauto_indexaliases', 'b:0;'),
  ('pathauto_indexaliases_bulkupdate', 'b:0;'),
  ('pathauto_max_bulk_update', 's:2:"50";'),
  ('pathauto_max_component_length', 's:3:"100";'),
  ('pathauto_max_length', 's:3:"100";'),
  ('pathauto_modulelist', 'a:5:{i:0;s:4:"blog";i:1;s:4:"node";i:2;s:8:"taxonomy";i:3;s:4:"user";i:4;s:5:"forum";}'),
  ('pathauto_node_applytofeeds', 's:4:"feed";'),
  ('pathauto_node_blog_pattern', 's:27:"blog/[user-raw]/[title-raw]";'),
  ('pathauto_node_book_pattern', 's:18:"[book]/[title-raw]";'),
  ('pathauto_node_bulkupdate', 'b:0;'),
  ('pathauto_node_forum_pattern', 's:0:"";'),
  ('pathauto_node_image_pattern', 's:17:"image/[title-raw]";'),
  ('pathauto_node_issue_pattern', 's:0:"";'),
  ('pathauto_node_page_pattern', 's:0:"";'),
  ('pathauto_node_pattern', 's:0:"";'),
  ('pathauto_node_story_pattern', 's:16:"news/[title-raw]";'),
  ('pathauto_node_supportsfeeds', 's:4:"feed";'),
  ('pathauto_node_wiki_pattern', 's:16:"wiki/[title-raw]";'),
  ('pathauto_punctuation_ampersand', 's:1:"0";'),
  ('pathauto_punctuation_asterisk', 's:1:"0";'),
  ('pathauto_punctuation_at', 's:1:"0";'),
  ('pathauto_punctuation_backtick', 's:1:"0";'),
  ('pathauto_punctuation_back_slash', 's:1:"0";'),
  ('pathauto_punctuation_caret', 's:1:"0";'),
  ('pathauto_punctuation_colon', 's:1:"0";'),
  ('pathauto_punctuation_comma', 's:1:"0";'),
  ('pathauto_punctuation_dollar', 's:1:"0";'),
  ('pathauto_punctuation_double_quotes', 's:1:"0";'),
  ('pathauto_punctuation_equal', 's:1:"0";'),
  ('pathauto_punctuation_exclamation', 's:1:"0";'),
  ('pathauto_punctuation_greater_than', 's:1:"0";'),
  ('pathauto_punctuation_hash', 's:1:"0";'),
  ('pathauto_punctuation_hyphen', 'i:1;'),
  ('pathauto_punctuation_left_curly', 's:1:"0";'),
  ('pathauto_punctuation_left_parenthesis', 's:1:"0";'),
  ('pathauto_punctuation_left_square', 's:1:"0";'),
  ('pathauto_punctuation_less_than', 's:1:"0";'),
  ('pathauto_punctuation_percent', 's:1:"0";'),
  ('pathauto_punctuation_period', 's:1:"0";'),
  ('pathauto_punctuation_pipe', 's:1:"0";'),
  ('pathauto_punctuation_plus', 's:1:"0";'),
  ('pathauto_punctuation_question_mark', 's:1:"0";'),
  ('pathauto_punctuation_quotes', 'i:0;'),
  ('pathauto_punctuation_right_curly', 's:1:"0";'),
  ('pathauto_punctuation_right_parenthesis', 's:1:"0";'),
  ('pathauto_punctuation_right_square', 's:1:"0";'),
  ('pathauto_punctuation_semicolon', 's:1:"0";'),
  ('pathauto_punctuation_tilde', 's:1:"0";'),
  ('pathauto_punctuation_underscore', 's:1:"1";'),
  ('pathauto_quotes', 's:1:"0";'),
  ('pathauto_reduce_ascii', 'i:0;'),
  ('pathauto_separator', 's:1:"_";'),
  ('pathauto_taxonomy_1_pattern', 's:0:"";'),
  ('pathauto_taxonomy_2_pattern', 's:0:"";'),
  ('pathauto_taxonomy_applytofeeds', 'b:0;'),
  ('pathauto_taxonomy_bulkupdate', 'b:0;'),
  ('pathauto_taxonomy_pattern', 's:34:"category/[vocab-raw]/[catpath-raw]";'),
  ('pathauto_taxonomy_supportsfeeds', 's:6:"0/feed";'),
  ('pathauto_transliterate', 'b:0;'),
  ('pathauto_update_action', 's:1:"2";'),
  ('pathauto_user_bulkupdate', 'b:0;'),
  ('pathauto_user_pattern', 's:15:"user/[user-raw]";'),
  ('pathauto_user_supportsfeeds', 'N;'),
  ('pathauto_verbose', 'i:0;'),
  ('views_defaults', 'a:1:{i:0;s:7:"tracker";}'),
  ('customerror_403', 's:683:"<?php global $user; if ($user->uid): ?> <p>Sorry <?php print $user->name; ?>, you don''t have permission to view the page you''ve just tried to access.</p><p>If you feel that you have received this message in error, please contact us with specific details so that we may review your access to this web site.</p> <?php else: ?> <p>This page may be available to clients and registered users only. Please select from one of the other options available to you below.</p><ul><li><a href="/user/login?<?php print drupal_get_destination(); ?>">Login</a> to view this page</li><li>Use the search form in the top right corner</li><li>Go to the <a href="/">home page</a></li></ul><?php endif; ?>";'),
  ('customerror_403_php', 'i:1;'),
  ('customerror_403_title', 's:50:"403 Forbidden Error: Access to this page is denied";'),
  ('customerror_404', 's:372:"<p>Sorry, no content was found at the requested path - it''s possible that you''ve requested this page in error.</p><p>Use the search form in the top right, or go to the <a href="/">home page.</a></p><?php if (module_exists(''search'') && user_access(''search content'')) { $path = $_REQUEST[''destination'']; $keys = strtolower(preg_replace(''/[^a-zA-Z0-9-]+/'', '' '', $path)); } ?>";'),
  ('customerror_404_php', 'i:1;'),
  ('customerror_404_title', 's:58:"404 Not Found Error: No content found at the requested URL";'),
  ('customerror_redirect', 's:0:"";'),
  ('site_403', 's:15:"customerror/403";'),
  ('site_404', 's:15:"customerror/404";'),
  ('feed_default_items', 's:2:"10";'),
  ('feed_item_length', 's:8:"fulltext";');

-- --------------------------------------------------------




