text: -- Starter data for a clean xCoLab instance
  -- created using ../database-reset.sql
  
  REPLACE INTO user__user (id, screen_name, email_address, is_email_confirmed, first_name, last_name, hashed_password, created_at, updated_at, password_updated_at, country, short_bio, facebook_id, google_id, open_id, login_ip, login_date, status, forgot_password_token, forgot_password_token_expire_time, portrait_file_entry_id, report_karma, auto_registered_member_status, uuid)
    VALUES (10144, 'admin', 'admin+u10144@example.com', 0, 'Admin', 'CoLab', 'PBKDF2_160_128000_g81/ioSNrXo=_pRj14MUWBMdoAVhbI7pqUlGdrII=', '2009-08-19 01:00:00', '2009-08-19 01:00:00', '2009-08-19 01:00:00', 'United States', '', 0, null, '', '127.0.0.1', '2009-08-19 01:00:00', 0, null, null, 0, 100, 0, null),
      (10145, 'member', 'member+u10145@example.com', 0, 'Member', 'CoLab', 'PBKDF2_160_128000_g81/ioSNrXo=_pRj14MUWBMdoAVhbI7pqUlGdrII=', '2009-08-19 01:00:00', '2009-08-19 01:00:00', '2009-08-19 01:00:00', 'United States', '', 0, null, '', '127.0.0.1', '2009-08-19 01:00:00', 0, null, null, 0, 100, 0, null);
  
  REPLACE INTO user__user_role (user_id, role_id) VALUES (10144, 10118), (10144, 10122), (10145, 10122);
  
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('CONTEST_NAME', 0, '', null, 'Contest', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('PROPOSAL_NAME', 0, '', null, 'Proposal', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('CONTEST_NAME', 0, 'es', null, 'Concurso', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('PROPOSAL_NAME', 0, 'es', null, 'Propuesta', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('CONTEST_NAME_PLURAL', 0, 'es', null, 'Concursos', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('PROPOSALS_CREATION_PROMPT', 0, 'es', null, 'CREAR propuesta', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('PROPOSAL_NAME_PLURAL', 0, 'es', null, 'Propuestas', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('RULES_NAME', 0, 'es', null, 'Reglas del concurso', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('CONTEST_NAME', 0, 'de', null, 'Wettbewerb', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('PROPOSAL_NAME', 0, 'de', null, 'Vorschlag', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('CONTEST_NAME_PLURAL', 0, 'de', null, 'Wettbewerbe', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('PROPOSALS_CREATION_PROMPT', 0, 'de', null, 'Vorschlag ERSTELLEN', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('PROPOSAL_NAME_PLURAL', 0, 'de', null, 'Vorschläge', null);
  REPLACE INTO admin__contest_type_attribute (name, additional_id, locale, numeric_value, string_value, real_value) VALUES ('RULES_NAME', 0, 'de', null, 'Wettbewerbregeln', null);
  
  REPLACE INTO comment__category (id, group_id, author_user_id, name, description, created_at, deleted_at, sort, is_quiet) VALUES (12501, 701, 10144, 'General Discussion', 'This set of discussions is where Climate CoLab members can engage around any topics that interest them.', '2010-10-02 00:00:00', null, null, 0);
  REPLACE INTO comment__category (id, group_id, author_user_id, name, description, created_at, deleted_at, sort, is_quiet) VALUES (12502, 701, 10144, 'Report bugs and request features', 'This group of discussions is where users can report bugs and suggest new features.', '2010-10-02 00:00:00', null, null, 0);
  REPLACE INTO comment__category_group (id, description, url, is_quiet) VALUES (701, 'Test Category', '/web/guest/discussion', 0);
  
  REPLACE INTO moderation__report_target (id, type, reason, notification_threshold, screening_threshold) VALUES (1, 'PROPOSAL', 'Spam', 0, -1);
  REPLACE INTO moderation__report_target (id, type, reason, notification_threshold, screening_threshold) VALUES (2, 'PROPOSAL', 'Inappropriate language', 0, 200);
  REPLACE INTO moderation__report_target (id, type, reason, notification_threshold, screening_threshold) VALUES (3, 'COMMENT', 'Spam', 0, -1);
  REPLACE INTO moderation__report_target (id, type, reason, notification_threshold, screening_threshold) VALUES (4, 'COMMENT', 'Inappropriate language', 0, 200);
  
  REPLACE INTO user__role_group (id, name) VALUES (1, 'Members');
  REPLACE INTO user__role_group (id, name) VALUES (2, 'Admins');
  REPLACE INTO user__role_group (id, name) VALUES (3, 'Privileged users');
  
  REPLACE INTO user__role_group_role (role_group_id, role_id) VALUES (1, 10122);
  REPLACE INTO user__role_group_role (role_group_id, role_id) VALUES (2, 10118);
  REPLACE INTO user__role_group_role (role_group_id, role_id) VALUES (3, 44201);
  REPLACE INTO user__role_group_role (role_group_id, role_id) VALUES (3, 193260);
  REPLACE INTO user__role_group_role (role_group_id, role_id) VALUES (3, 193261);
  REPLACE INTO user__role_group_role (role_group_id, role_id) VALUES (3, 1251483);
  REPLACE INTO user__role_group_role (role_group_id, role_id) VALUES (3, 1430078);
  REPLACE INTO user__role_group_role (role_group_id, role_id) VALUES (3, 1958405);
  REPLACE INTO user__role_group_role (role_group_id, role_id) VALUES (3, 1975251);
  
  REPLACE INTO user__role (id, name, title, description) VALUES (10118, 'Administrator', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Administrators are super users who can do anything.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (10119, 'Guest', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Unauthenticated users always have this role.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (10120, 'Owner', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">This is an implied role with respect to the objects users create.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (10121, 'Power User', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Power Users have their own personal site.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (10122, 'User', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Authenticated users should be assigned this role.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (10123, 'Site Administrator', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Site Administrators are super users of their site but cannot make other users into Site Administrators.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (10124, 'Site Member', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">All users who belong to a site have this role within that site.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (10125, 'Site Owner', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Site Owners are super users of their site and can assign site roles to users.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (10126, 'Organization Administrator', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Organization Administrators are super users of their organization but cannot make other users into Organization Administrators.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (10127, 'Organization User', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">All users who belong to an organization have this role within that organization.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (10128, 'Organization Owner', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Organization Owners are super users of their organization and can assign organization roles to users.</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (26021, 'Blogger', '', 'A user who can add entries to the blog');
  REPLACE INTO user__role (id, name, title, description) VALUES (31213, 'Moderator', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><title language-id="en_US">Moderator</title></root>', 'Responsible for curating content on the site.');
  REPLACE INTO user__role (id, name, title, description) VALUES (31704, 'Staff', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><title language-id="en_US">Collaboratorium team</title></root>', 'People involved in collaboratorium development');
  REPLACE INTO user__role (id, name, title, description) VALUES (38133, 'Wiki Maintainer', '', 'Enables admin access to wiki');
  REPLACE INTO user__role (id, name, title, description) VALUES (44201, 'Experts', '', 'Members of the Expert council');
  REPLACE INTO user__role (id, name, title, description) VALUES (193260, 'Advisor', '', 'Experienced professionals who provide input on proposals and help to bring the contest results to key stakeholders.');
  REPLACE INTO user__role (id, name, title, description) VALUES (193261, 'Fellow', '', 'Students and concerned citizens who encourage and moderate contest activity');
  REPLACE INTO user__role (id, name, title, description) VALUES (1013998, 'Outreach specialist', '', '');
  REPLACE INTO user__role (id, name, title, description) VALUES (1015916, 'Community Content Reviewer', null, null);
  REPLACE INTO user__role (id, name, title, description) VALUES (1015917, 'Organization Content Reviewer', null, null);
  REPLACE INTO user__role (id, name, title, description) VALUES (1015918, 'Portal Content Reviewer', null, null);
  REPLACE INTO user__role (id, name, title, description) VALUES (1251483, 'Judges', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="" default-locale="en_US" />', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Judges</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (1289509, 'predict_the_winners_admin', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Title language-id="en_US">predict_the_winners_admin</Title></root>', '');
  REPLACE INTO user__role (id, name, title, description) VALUES (1411593, 'Site Content Reviewer', '', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Autogenerated role from workflow definition</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (1423086, 'Supporter', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Title language-id="en_US">Supporter</Title></root>', '');
  REPLACE INTO user__role (id, name, title, description) VALUES (1427577, 'RedBalloon admin', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Title language-id="en_US">Red Balloon Admin</Title></root>', null);
  REPLACE INTO user__role (id, name, title, description) VALUES (1430078, 'Catalyst', '', '');
  REPLACE INTO user__role (id, name, title, description) VALUES (1958405, 'Contest Manager', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Title language-id="en_US">Contest Manager</Title></root>', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Description language-id="en_US">Contest Manager</Description></root>');
  REPLACE INTO user__role (id, name, title, description) VALUES (1975251, 'Impact Assessment Fellow', '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Title language-id="en_US">Impact Assessment Fellow</Title></root>', '');
  
  REPLACE INTO admin__configuration_attribute (name, additional_id, numeric_value, string_value, real_value) VALUES ('DISCUSSION_CONTENT_ARTICLE_ID', 0, 7, ' ', 0);
  REPLACE INTO admin__configuration_attribute (name, additional_id, numeric_value, string_value, real_value) VALUES ('IMAGE_UPLOAD_EXTERNAL_SERVICE_URL', 0, 0, 'http://imgur.com/MRfmcOs', 0);
  REPLACE INTO admin__configuration_attribute (name, additional_id, numeric_value, string_value, real_value) VALUES ('IMAGE_UPLOAD_HELP_TEXT', 0, 0, '<h4>Image upload in IMGUR:</h4><h5>This process works best on Google Chrome or Safari:</h5><br /><ol><li>Click on Upload - This will take you to Imgur, an image hosting platform where you can host your image.</li><li>On Imgur, click "New Post" and "Upload images."</li><li>Drag and drop or browse to the image you would like to use.</li> <li>After the image is uploaded to Imgur, right click on it, and select "Copy image address."</li><li>Return to the Climate CoLab page and paste it into the URL field.</li><li>Verify the image in the preview.</li><li>Click OK to insert the image to the Climate CoLab.</li></ol>', 0);
  REPLACE INTO admin__configuration_attribute (name, additional_id, numeric_value, string_value, real_value) VALUES ('LANDING_PAGE_BANNER_CONTENT_ARTICLE_ID', 0, 4, ' ', 0);
  REPLACE INTO admin__configuration_attribute (name, additional_id, numeric_value, string_value, real_value) VALUES ('LANDING_PAGE_BOTTOM_CONTENT_ARTICLE_ID', 0, 5, ' ', 0);
  REPLACE INTO admin__configuration_attribute (name, additional_id, numeric_value, string_value, real_value) VALUES ('MEMBERS_CONTENT_ARTICLE_ID', 0, 6, ' ', 0);
  REPLACE INTO admin__configuration_attribute (name, additional_id, numeric_value, string_value, real_value) VALUES ('META_PAGE_DESCRIPTION', 0, null, 'The xCoLab is a generic version of the Climate CoLab, a platform to crowdsource solutions to climate change.', null);
  REPLACE INTO admin__configuration_attribute (name, additional_id, numeric_value, string_value, real_value) VALUES ('META_PAGE_KEYWORDS', 0, null, 'xCoLab, CoLab, open source, open innovation', null);
  REPLACE INTO admin__configuration_attribute (name, additional_id, numeric_value, string_value, real_value) VALUES ('OPEN_GRAPH_SHARE_DESCRIPTION', 0, 0, 'The xCoLab is a generic version of the Climate CoLab, a platform to crowdsource solutions to climate change.', 0);
  
  REPLACE INTO content__content_article (id, author_user_id, created_at, max_version_id, folder_id, edit_role_group_id, view_role_group_id, visible) VALUES (1, 10144, '2016-05-11 09:21:08', 1, 2, null, null, 1);
  REPLACE INTO content__content_article (id, author_user_id, created_at, max_version_id, folder_id, edit_role_group_id, view_role_group_id, visible) VALUES (2, 10144, '2016-05-11 09:21:08', 2, 2, null, null, 1);
  REPLACE INTO content__content_article (id, author_user_id, created_at, max_version_id, folder_id, edit_role_group_id, view_role_group_id, visible) VALUES (4, 10144, '2016-05-11 09:21:08', 4, 2, null, null, 1);
  REPLACE INTO content__content_article (id, author_user_id, created_at, max_version_id, folder_id, edit_role_group_id, view_role_group_id, visible) VALUES (5, 10144, '2016-05-11 09:21:08', 5, 2, null, null, 1);
  REPLACE INTO content__content_article (id, author_user_id, created_at, max_version_id, folder_id, edit_role_group_id, view_role_group_id, visible) VALUES (6, 10144, '2016-05-11 09:21:08', 6, 2, null, null, 1);
  REPLACE INTO content__content_article (id, author_user_id, created_at, max_version_id, folder_id, edit_role_group_id, view_role_group_id, visible) VALUES (7, 10144, '2016-05-11 09:21:08', 7, 2, null, null, 1);
  
  REPLACE INTO content__content_article_version (id, article_id, folder_id, author_user_id, created_at, title, content) VALUES (1, 1, 2, 10144, '2016-07-19 12:38:47', 'Navigation', '<ul><li id="about"><a href="/web/guest/about">About the project</a></li></ul><script>var siteForNav=window.location.href.substring(window.location.href.lastIndexOf("/")+1);$("#"+siteForNav).addClass("c");</script>');
  REPLACE INTO content__content_article_version (id, article_id, folder_id, author_user_id, created_at, title, content) VALUES (2, 2, 2, 10144, '2016-07-19 12:38:47', 'About', 'About this CoLab.');
  REPLACE INTO content__content_article_version (id, article_id, folder_id, author_user_id, created_at, title, content) VALUES (4, 4, 2, 10144, '2016-07-19 12:38:47', 'Landing page top', 'Content.');
  REPLACE INTO content__content_article_version (id, article_id, folder_id, author_user_id, created_at, title, content) VALUES (5, 5, 2, 10144, '2016-07-19 12:38:47', 'Landing page bottom', 'Content.');
  REPLACE INTO content__content_article_version (id, article_id, folder_id, author_user_id, created_at, title, content) VALUES (6, 6, 2, 10144, '2016-07-19 12:38:47', 'Members menu', 'Content.');
  REPLACE INTO content__content_article_version (id, article_id, folder_id, author_user_id, created_at, title, content) VALUES (7, 7, 2, 10144, '2016-07-19 12:38:47', 'Discussion menu', 'Content.');
  
  REPLACE INTO content__content_folder (id, name, description, parent_folder_id) VALUES (1, 'Root', 'Content root', null);
  REPLACE INTO content__content_folder (id, name, description, parent_folder_id) VALUES (2, 'Static Content', 'Displays static content that should be editable on the site', 1);
  REPLACE INTO content__content_folder (id, name, description, parent_folder_id) VALUES (3, 'Wiki', 'Contains content for the wiki pages', 1);
  REPLACE INTO content__content_folder (id, name, description, parent_folder_id) VALUES (4, 'Resource Pages', 'Stores the resource pages for contests', 1);
  
  REPLACE INTO content__content_page (id, title, menu_article_id, content_article_id, created_at, updated_at) VALUES (50, 'about', 1, 2, '2017-03-10 06:00:00', '2017-03-10 06:00:00');
  
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('CONTEST_VOTE_DEFAULT', 'Your vote in the <contest-title/> contest', 'Dear <firstname/>,<br/><br/>This year''s voting period has started! We have automatically transferred your support for the proposal <proposal-link/> in the <contest-link/> contest to an official vote, as it was the only proposal you supported in this contest.<br/><br/>You can click the social media icons on the proposal page to share on <twitter>I just voted for a proposal at the @ClimateCoLab. Check it out!</twitter>, <facebook/>, <pinterest>I just voted for a proposal at the Climate CoLab. Check it out!</pinterest> or <linkedin title=''I just voted at the Climate CoLab''>I just voted for a proposal at the Climate CoLab. Check it out!</linkedin>, or simply forward this email to your friends.<br/><br/>Please note that you can only vote for one proposal per contest.  To change your vote in this contest, simply vote for another proposal in the <contest-link/> contest and your vote will transfer. To retract your vote in this contest, click "Retract vote" on the <proposal-link/> proposal page.<br/>We hope you''ll get a chance to cast your votes in <other-contests-link>other contests</other-contests-link> on the Climate CoLab as well.  Thank you for being an active member of the Climate CoLab!<br/><br/>Sincerely,<br/>The Climate CoLab Team<br /><a href=''http://www.climatecolab.org''>www.climatecolab.org</a>', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('CONTEST_VOTE_QUESTION_DEFAULT', 'Vote for your favorite proposal in the <contest-title/> contest', 'Dear <firstname/>,<br/><br/>The voting period for the <contest-title/> contest has started! Vote now to help your favorite proposal win the Popular Choice award.<br/><br/>You are currently supporting the Finalist proposal(s) below in the <b><contest-title/></b> contest.<br/><b>To cast your vote, click the link below of the proposal you would like to win.</b> You can vote for one proposal per contest.<br/><br/><supported-proposals/><br/>Please note that you must have a valid email address for your vote to be counted. Votes cast by members with invalid email addresses will be removed. See the other proposals in this contest by visiting <contest-link/>. <a href=''http://climatecolab.org/resources/-/wiki/Main/Contest+Rules#Voting''>Click here for the complete voting rules.</a><br/><br/>Thank you! And be sure to stay tuned for the results.<br/><br/>Sincerely,<br/>The Climate CoLab Team<br /><a href=''http://www.climatecolab.org''>www.climatecolab.org</a>', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('MEMBER_BATCH_REGISTERED_DEFAULT', 'Welcome to the <colab-name/>', 'Dear <firstname/>,<br/><br/>A new account has been created for you on the <colab-name/>. Please click <login-link/> to log in.<br/><br/>Sincerely,<br/>The <colab-name/> Team<br/><colab-admin-email/><br/><colab-url/>', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('MEMBER_REGISTERED_DEFAULT', 'Welcome to the <colab-name/>!', '<p>Dear <sender-name/> <sender-lastname/>,</p>  <p>Welcome! You recently created an account with Climate CoLab under the username&nbsp;<span style="font-size:14px;"><strong><sender-screenname/></strong></span>.&nbsp;</p> Through MIT''s&nbsp;<a href="http://climatecolab.org/" style="color: rgb(0, 104, 207); cursor: pointer;" target="_blank">Climate CoLab</a>, you can collaborate with people from all over the world to create proposals on how to address climate change.  <p><b>To get started:</b></p>  <ul style="line-height: 21px; margin: 0px 0px 20px 1em;"> <li> <p>Learn&nbsp;<a href="http://climatecolab.org/web/guest/about" target="_blank"><span class="ecxs2">how the Climate CoLab works</span></a>.</p> </li> <li> <p>Check out our current&nbsp;<a href="http://climatecolab.org/web/guest/plans" target="_blank">climate change contests</a>&nbsp;and join the conversation. You can submit,&nbsp;support,&nbsp;comment on, and vote for proposals throughout the year.</p> </li> <li> <div style="margin-top: 14pt; margin-bottom: 14pt;">Connect with our community of over 85,000&nbsp;<a href="https://climatecolab.org/members" target="_blank">Members</a>;&nbsp;we''re also&nbsp;on&nbsp;<a href="http://www.twitter.com/climatecolab" target="_blank">Twitter</a>,&nbsp;<a href="http://www.facebook.com/climatecolab" target="_blank">Facebook</a>,&nbsp;<a href="https://www.linkedin.com/groups/Climate-CoLab-5074465?home=&amp;trk=anet_ug_hm&amp;gid=5074465" target="_blank">LinkedIn</a>,&nbsp;<a href="https://plus.google.com/+MITClimateCoLab" target="_blank">Google+</a>&nbsp;&amp;&nbsp;<a href="http://www.youtube.com/channel/UC34kqww4yZDDnQt-t5Ro0Sg">YouTube</a>.</div> </li> </ul>  <p>As a member, you''ll also receive our newsletter, CoLab Talk. Be sure to add no-reply@climatecolab.org to your safe senders list.&nbsp;<span class="s1">If you did not create this account or believe you received this message in error, please email <a href="mailto:admin@climatecolab.org"><span class="s2">admin@climatecolab.org</span></a>.</span></p>  <p>Happy CoLaborating!</p> Sincerely,<br /> The Climate CoLab Team<br /> admin@climatecolab.org<br /> http://climatecolab.org <div>&nbsp;</div>', ' ');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('MEMBER_RESET_PASSWORD_DEFAULT', '<system-link/>: Reset Your Password', 'Dear <sender-name/> <sender-lastname/>,<br /> <br /> You can reset your password for the Climate CoLab <password-reset-link/> <br /> <br /> The request for a new password was made from <sender-ip/><br /> <br /> Sincerely,<br /> The Climate CoLab Team<br /> admin@climatecolab.org<br /> http://climatecolab.org', ' ');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('PROPOSAL_CREATION_DEFAULT', 'You created a proposal!  Here''s what''s next...', 'Dear <firstname/>,<br/><br/>Congratulations!  You recently created the proposal, <proposal-link/>, in the <contest-link/> contest on the Climate CoLab.<br/><br/><b>What''s next:</b><ul><li><b>Share your proposal</b> with your friends and colleagues over <twitter>I just created a new proposal at the Climate CoLab. Check it out!</twitter>, <facebook/>, I just created a new proposal at the Climate CoLab. Check it out!</pinterest>, <linkedin title=''New proposal at @ClimateCoLab''>I just created a new proposal at the Climate CoLab. Check it out!</linkedin> & more.  Ask for support, comments, or just to check out what you''re working on.  Don''t forget to mention us @ClimateCoLab!</li><contest-deadline-section><li><b>The contest deadline is <deadline/></b> (except for proposals created in the Workspace, where there is no deadline). You can edit your proposal as many times as you want before then, but make sure your final version is updated before the deadline.  At that point, the most recent version of your proposal will be frozen and submitted to the Judges for review. To learn more about the contest process, <a href=''http://climatecolab.org/web/guest/crowdsourcing''>click here</a>.</li></contest-deadline-section></ul>Happy CoLaborating!<br/><br/>Sincerely,<br/><br/>The Climate CoLab Team<br/><a href=''mailto:admin@climatecolab.org''>admin@climatecolab.org</a><br/><a href=''http://www.climatecolab.org''>www.climatecolab.org</a>', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('PROPOSAL_MEMBERSHIP_INVITE_DEFAULT', '<sender-name/> invites you to join the team working on the <proposal-string/> <proposal-title/>', 'User <sender-name/> invites you to join the team working on the <proposal-string/> <proposal-link/> with the following message: <br /><br /><message/><br /><br />Click <proposal-link tab="TEAM">here</proposal-link> to respond to the invitation. By accepting to participate as a contributor to this proposal, you agree to <colab-name/>''s Terms of Use, Contest Rules, and Community Policies. ', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('PROPOSAL_MEMBERSHIP_REQUEST_DEFAULT', '<sender-name/> wants to join the team working on your <proposal-string/> <proposal-title/>', 'User <sender-name/> wants to join the team working on your <proposal-string/> <proposal-link/>. Click <proposal-link tab="ADMIN">here</proposal-link> to respond to it.', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('PROPOSAL_VOTE_CONFIRMATION_DEFAULT', 'Please confirm your vote in the <contest-title/> contest', 'Dear <firstname/>,<br/><br/>Thank you for voting for the proposal <proposal-link/> in the <contest-link/> contest! Unfortunately, we have received a lot of votes from your network today. In order to make the voting process fair for everyone, we can only count your vote if you <confirmation-link>confirm it using this link</confirmation-link>.  <br /> <br /> Thank you for your understanding. If you have any questions, check out our <a href=''http://climatecolab.org/resources/-/wiki/Main/Contest+Rules#Voting''>voting rules</a>. <br /> <br />Thank you! <br/><br/>Sincerely,<br/>The Climate CoLab Team<br /><a href=''http://www.climatecolab.org''>www.climatecolab.org</a>', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('PROPOSAL_VOTE_DEFAULT', 'Your vote in the <contest-title/> contest', 'Dear <firstname/>,<br/><br/>Thank you for voting for the proposal <proposal-link/> in the <contest-link/> contest!  <br/> The <colab-name/> Team', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('TERMS_OF_SERVICE', '', 'See /page/terms-of-service.', '');
  
  REPLACE INTO contest__contest_phase_ribbon_type (id, ribbon, title, hover_text, show_text, description, copy_on_promote, sort_order) VALUES (1, 2, 'Finalist', 'Finalist', 1, '', 0, 18);
  REPLACE INTO contest__contest_phase_ribbon_type (id, ribbon, title, hover_text, show_text, description, copy_on_promote, sort_order) VALUES (2, 1, 'Winner', 'Popular Choice', 1, '', 0, 4);
  REPLACE INTO contest__contest_phase_ribbon_type (id, ribbon, title, hover_text, show_text, description, copy_on_promote, sort_order) VALUES (3, 3, 'Semi-finalist', 'Semi-finalist', 1, '', 0, 19);
  REPLACE INTO contest__contest_phase_ribbon_type (id, ribbon, title, hover_text, show_text, description, copy_on_promote, sort_order) VALUES (4, 1, 'Winner', 'Judges'' Choice', 1, '', 0, 3);
  REPLACE INTO contest__contest_phase_ribbon_type (id, ribbon, title, hover_text, show_text, description, copy_on_promote, sort_order) VALUES (5, 1, 'Winner', 'Judges'' & Popular Choice', 1, '', 0, 2);
  
  REPLACE INTO contest__contest_phase (id, contest_id, contest_phase_type_id, contest_schedule_id, contest_phase_autopromote, phase_start_date, phase_end_date, created_at, updated_at) VALUES (1, 0, 1, 1, 'DEFAULT', '2017-03-23 02:33:06', null, '2017-03-23 02:33:06', '2017-03-23 02:33:06');
  REPLACE INTO contest__contest_schedule (id, name, description, status, base_schedule_id) VALUES (1, '[DEFAULT] Contest Schedule', null, null, null);
  
  REPLACE INTO contest__contest_phase_type (id, name, description, status, fellow_screening_active_default, contest_phase_autopromote_default, invisible, points_accessible, default_promotion_type, default_flag_text, is_deprecated) VALUES (1, 'Proposal creation', '<p>CoLab members create proposals</p>', 'OPEN_FOR_SUBMISSION', 0, '', 0, 2, 'PROMOTE', 'Open for proposals', 0);
  REPLACE INTO contest__contest_phase_type (id, name, description, status, fellow_screening_active_default, contest_phase_autopromote_default, invisible, points_accessible, default_promotion_type, default_flag_text, is_deprecated) VALUES (11, 'Finalist selection', 'Expert judges select finalists<br/><br/>', 'CLOSED', 1, '', 0, 2, 'PROMOTE_JUDGED', null, 0);
  REPLACE INTO contest__contest_phase_type (id, name, description, status, fellow_screening_active_default, contest_phase_autopromote_default, invisible, points_accessible, default_promotion_type, default_flag_text, is_deprecated) VALUES (14, 'Completed', 'Winners are awarded<br/><br/>', 'COMPLETED', 0, '', 0, 1, '', 'Winners announced', 0);
  REPLACE INTO contest__contest_phase_type (id, name, description, status, fellow_screening_active_default, contest_phase_autopromote_default, invisible, points_accessible, default_promotion_type, default_flag_text, is_deprecated) VALUES (16, 'Semi-Finalist selection', 'Expert judges select semi-finalists<br/><br/>', 'CLOSED', 1, '', 0, 2, 'PROMOTE_JUDGED', null, 0);
  REPLACE INTO contest__contest_phase_type (id, name, description, status, fellow_screening_active_default, contest_phase_autopromote_default, invisible, points_accessible, default_promotion_type, default_flag_text, is_deprecated) VALUES (18, 'Proposal revisions', 'Semi-finalists can improve their proposals<br/><br/>', 'OPEN_FOR_EDIT', 0, '', 0, 2, 'PROMOTE', null, 0);
  REPLACE INTO contest__contest_phase_type (id, name, description, status, fellow_screening_active_default, contest_phase_autopromote_default, invisible, points_accessible, default_promotion_type, default_flag_text, is_deprecated) VALUES (20, 'Voting period', 'Public Voting Period <br/><br/>', 'VOTING', 0, '', 0, 1, 'PROMOTE_RIBBONIZE', 'Vote now!', 0);
  
  REPLACE INTO contest__contest_team_member_role (id, role, sort) VALUES (193260, 'Advisor', 0);
  REPLACE INTO contest__contest_team_member_role (id, role, sort) VALUES (193261, 'Fellow', 2);
  REPLACE INTO contest__contest_team_member_role (id, role, sort) VALUES (1251483, 'Judge', 1);
  REPLACE INTO contest__contest_team_member_role (id, role, sort) VALUES (1975251, 'Impact Fellow', 3);
  
  REPLACE INTO contest__focus_area (id, name, sort_order) VALUES (1, 'any-any-cement', 0);
  REPLACE INTO contest__focus_area (id, name, sort_order) VALUES (2, 'any-any-any', 0);
  
  REPLACE INTO contest__impact_iteration (iteration_id, year) VALUES (1, 2020);
  REPLACE INTO contest__impact_iteration (iteration_id, year) VALUES (1, 2030);
  REPLACE INTO contest__impact_iteration (iteration_id, year) VALUES (1, 2040);
  REPLACE INTO contest__impact_iteration (iteration_id, year) VALUES (1, 2050);
  
  REPLACE INTO contest__impact_template_series (series_id, iteration_id, name) VALUES (1, 1, 'Default series');
  
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (10118, 'Admin', 'Admin', 1, 0, 'icon_mem-staff', 'Site admins - non-visible role');
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (10122, 'Member', 'Members', 2, 1, 'icon_mem-member', '');
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (31213, 'Moderator', 'Moderators', 9, 0, 'icon_mem-moderator', '');
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (31704, 'Staff', 'Staff', 8, 1, 'icon_mem-staff', '');
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (44201, 'Expert', 'Experts', 6, 0, 'icon_mem-expert', '');
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (193260, 'Advisor', 'Advisors', 5, 1, 'icon_mem-advisor', '');
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (193261, 'Fellow', 'Fellows', 4, 1, 'icon_mem-fellow', '');
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (1251483, 'Judge', 'Judges', 7, 1, 'icon_mem-judges', '');
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (1430078, 'Catalyst', 'Catalysts', 3, 1, 'icon_mem-catalyst', '');
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (1958405, 'Contest Manager', 'Contest Managers', 6, 0, 'icon_mem-staff', '');
  REPLACE INTO user__member_category (role_id, display_name, category_name, sort_order, show_in_list, image_name, description) VALUES (1975251, 'Impact Assessment Fellow', 'IA Fellows', 4, 1, 'icon_mem-fellow', '');
  
  REPLACE INTO contest__ontology_space (id, name, description, sort_order) VALUES (102, 'Who', 'will take the actions', 3);
  REPLACE INTO contest__ontology_space (id, name, description, sort_order) VALUES (103, 'What', 'actions will be taken', 1);
  REPLACE INTO contest__ontology_space (id, name, description, sort_order) VALUES (104, 'Where', 'will the actions be taken', 2);
  REPLACE INTO contest__ontology_space (id, name, description, sort_order) VALUES (105, 'How', 'will the actions be taken', 4);
  
  REPLACE INTO contest__ontology_term (id, parent_id, ontology_space_id, name, description_url, sort_order) VALUES (1, 0, 102, 'Any Actor', '', 5);
  REPLACE INTO contest__ontology_term (id, parent_id, ontology_space_id, name, description_url, sort_order) VALUES (2, 0, 103, 'Any action', '', 5);
  REPLACE INTO contest__ontology_term (id, parent_id, ontology_space_id, name, description_url, sort_order) VALUES (3, 0, 104, 'Anywhere', '', 5);
  REPLACE INTO contest__ontology_term (id, parent_id, ontology_space_id, name, description_url, sort_order) VALUES (1300601, 0, 105, 'Any kind of action', '', 5);
  
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (1, 0, 1, 'DEFINED_BY_CHILDREN_PERCENTAGES', 'ANY_USER', '', 1);
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (2, 3, 0.9, 'USER_DEFINED', 'ANY_TEAM_MEMBER', '', 2);
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (3, 1, 0.05, 'DEFINED_BY_CHILDREN_PERCENTAGES', 'ANY_USER', '', 3);
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (4, 11, 0.02105263158, 'EQUAL_DIVISION', 'BASIC_SUBPROPOSALS', '', 4);
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (5, 3, 0.1, 'USER_DEFINED', 'ANY_NON_TEAM_MEMBER', '', 5);
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (6, 0, 1, 'DEFINED_BY_CHILDREN_PERCENTAGES', 'ANY_USER', '', 1);
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (7, 6, 0.1, 'USER_DEFINED', 'ANY_TEAM_MEMBER', '', 2);
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (8, 6, 0.9, 'EQUAL_DIVISION', 'SUBPROPOSALS', '', 3);
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (9, 11, 0.9789473684, 'SECTION_DEFINED', 'REGIONAL_SUBPROPOSALS', '', 5);
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (10, 0, 1, 'USER_DEFINED', 'ANY_TEAM_MEMBER', '', 6);
  REPLACE INTO contest__point_type (id, parent_point_type_id, percentage_of_parent, distribution_strategy, receiver_limitation_strategy, name, sort_order) VALUES (11, 1, 0.95, 'DEFINED_BY_CHILDREN_PERCENTAGES', 'ANY_USER', '', 4);
  
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (1, 'Novelty', 'The degree to which the proposal is original (not only rare but also ingenious, imaginative, or surprising), and modifies a paradigm.', 1, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (2, 'Feasibility', 'The degree to which the proposal is appealing (socially, legally and politically) and implementable (technically and economically).', 1, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (3, 'Impact', 'The degree to which the proposal, if successfully implemented, will be effective at solving the challenge in the contest prompt.', 1, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (4, 'Thoroughness', 'The degree to which the proposal is worked out in detail and there is a clear relationship between the recommended action and the expected outcome.', 1, 0);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (5, 'Presentation', 'The degree to which the proposal is presented in a clear, persuasive and appealing manner.', 1, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (6, 'Novelty', 'The degree to which the proposal is original (not only rare but also ingenious, imaginative, or surprising), and modifies a paradigm.', 2, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (7, 'Feasibility', 'The degree to which the proposal is appealing (socially, legally and politically) and implementable (technically and economically).', 2, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (8, 'Impact', 'The degree to which the proposal, if successfully implemented, will be effective at solving the challenge in the contest prompt.', 2, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (9, 'Thoroughness', 'The degree to which the proposal is worked out in detail and there is a clear relationship between the recommended action and the expected outcome.', 2, 0);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (10, 'Presentation', 'The degree to which the proposal is presented in a clear, persuasive and appealing manner.', 2, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (11, 'Novelty', 'The degree to which the proposal is original (not only rare but also ingenious, imaginative, or surprising), and modifies a paradigm.', 3, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (12, 'Feasibility', 'The degree to which the proposal is appealing (socially, legally and politically) and implementable (technically and economically).', 3, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (13, 'Impact', 'The degree to which the proposal, if successfully implemented, will be effective at solving the challenge in the contest prompt.', 3, 1);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (14, 'Thoroughness', 'The degree to which the proposal is worked out in detail and there is a clear relationship between the recommended action and the expected outcome.', 3, 0);
  REPLACE INTO contest__proposal_rating_type (id, label, description, judge_type, is_active) VALUES (15, 'Presentation', 'The degree to which the proposal is presented in a clear, persuasive and appealing manner.', 3, 1);
  
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (1, 1, 1, 'Common, mundane, boring', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (2, 1, 2, 'Interesting, but not unheard of', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (3, 1, 3, 'Unusual, interesting; imaginative', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (4, 1, 4, 'Rare; surprising; challenges paradigms', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (6, 2, 1, 'Infeasible socially, politically, legally or technically', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (7, 2, 2, 'Challenging; feasibility is questionnable', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (8, 2, 3, 'Acceptable; Objections & barriers partially addressed', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (9, 2, 4, 'Appealing; Potential objections & barriers well addressed', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (11, 3, 1, 'Benefits/impact not clear', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (12, 3, 2, 'Limited benefits/small impact', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (13, 3, 3, 'Partial solution/moderate impact', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (14, 3, 4, 'Large, direct, & positive impact', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (16, 4, 1, 'Poor. Missing details, unclear', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (17, 4, 2, 'Incomplete. Missing details, cause-effect unclear', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (18, 4, 3, 'Comprehensive. Clarifications needed', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (19, 4, 4, 'Comprehensive. Details worked out', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (21, 5, 1, 'Neither clear, persuasive or appealing', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (22, 5, 2, '1 of 3: Clear, Persuasive, Appealing', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (23, 5, 3, '2 of 3: Clear, Persuasive, Appealing', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (24, 5, 4, '3 of 3: Clear, Persuasive, Appealing', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (26, 6, 1, 'Common, mundane, boring', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (27, 6, 2, 'Interesting, but not unheard of', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (28, 6, 3, 'Unusual, interesting; imaginative', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (29, 6, 4, 'Rare; surprising; challenges paradigms', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (31, 7, 1, 'Infeasible socially, politically, legally or technically', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (32, 7, 2, 'Challenging; feasibility is questionnable', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (33, 7, 3, 'Acceptable; Objections & barriers partially addressed', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (34, 7, 4, 'Appealing; Potential objections & barriers well addressed', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (36, 8, 1, 'Benefits/impact not clear', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (37, 8, 2, 'Limited benefits/small impact', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (38, 8, 3, 'Partial solution/moderate impact', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (39, 8, 4, 'Large, direct, & positive impact', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (41, 9, 1, 'Poor. Missing details, unclear', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (42, 9, 2, 'Incomplete. Missing details, cause-effect unclear', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (43, 9, 3, 'Comprehensive. Clarifications needed', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (44, 9, 4, 'Comprehensive. Details worked out', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (46, 10, 1, 'Neither clear, persuasive or appealing', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (47, 10, 2, '1 of 3: Clear, Persuasive, Appealing', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (48, 10, 3, '2 of 3: Clear, Persuasive, Appealing', '');
  REPLACE INTO contest__proposal_rating_value (id, rating_type_id, value, name, description) VALUES (49, 10, 4, '3 of 3: Clear, Persuasive, Appealing', '');
  
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('ADVANCING_ADVANCE_TO_FINALIST', 'Congratulations! Your proposal has been selected as a Climate CoLab Finalist!', 'You can edit this content in the email tab of the admin interface: ADVANCING_ADVANCE_TO_FINALIST', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('ADVANCING_ADVANCE_TO_SEMIFINALIST', 'Congratulations!  Your proposal has been selected as a Semi-Finalist!', 'You can edit this content in the email tab of the admin interface: ADVANCING_ADVANCE_TO_SEMIFINALIST', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('ADVANCING_DO_NOT_ADVANCE', 'Climate CoLab Judging Results', 'You can edit this content in the email tab of the admin interface: ADVANCING_DO_NOT_ADVANCE', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('CONTEST_CREATION_DEFAULT', 'You created a contest!  Here''s what''s next...', 'You can edit this content in the email tab of the admin interface: CONTEST_CREATION_DEFAULT', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('CONTEST_VOTE_DEFAULT', 'Your vote in the <contest-title/> contest', 'You can edit this content in the email tab of the admin interface: CONTEST_VOTE_DEFAULT', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('CONTEST_VOTE_QUESTION_DEFAULT', 'Vote for your favorite proposal in the <contest-title/> contest', 'You can edit this content in the email tab of the admin interface: CONTEST_VOTE_QUESTION_DEFAULT', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('MEMBER_BATCH_REGISTERED_DEFAULT', 'Welcome to the <colab-name/>', 'You can edit this content in the email tab of the admin interface: MEMBER_BATCH_REGISTERED_DEFAULT', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('MEMBER_REGISTERED_DEFAULT', 'Welcome to the Climate CoLab!', 'You can edit this content in the email tab of the admin interface: MEMBER_REGISTERED_DEFAULT', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('MEMBER_RESET_PASSWORD_DEFAULT', '<system-link/>: Reset Your Password', 'You can edit this content in the email tab of the admin interface: MEMBER_RESET_PASSWORD_DEFAULT', ' ');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('PROPOSAL_CREATION_DEFAULT', 'You created a proposal!  Here''s what''s next...', 'You can edit this content in the email tab of the admin interface: PROPOSAL_CREATION_DEFAULT', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('PROPOSAL_MEMBERSHIP_INVITE_DEFAULT', '<sender-name/> invites you to join the team working on the <proposal-string/> <proposal-title/>', 'You can edit this content in the email tab of the admin interface: PROPOSAL_MEMBERSHIP_INVITE_DEFAULT', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('PROPOSAL_MEMBERSHIP_REQUEST_DEFAULT', '<sender-name/> wants to join the team working on your <proposal-string/> <proposal-title/>', 'You can edit this content in the email tab of the admin interface: PROPOSAL_MEMBERSHIP_REQUEST_DEFAULT', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('PROPOSAL_VOTE_CONFIRMATION_DEFAULT', 'Please confirm your vote in the <contest-title/> contest', 'You can edit this content in the email tab of the admin interface: PROPOSAL_VOTE_CONFIRMATION_DEFAULT', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('PROPOSAL_VOTE_DEFAULT', 'Your vote in the <contest-title/> contest', 'You can edit this content in the email tab of the admin interface: PROPOSAL_VOTE_DEFAULT', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('SCREENING_DO_NOT_ADVANCE_INCOMPLETE', 'Your proposal in the Climate CoLab', 'You can edit this content in the email tab of the admin interface: SCREENING_DO_NOT_ADVANCE_INCOMPLETE', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('SCREENING_DO_NOT_ADVANCE_OFF_TOPIC', 'Your proposal in the Climate CoLab', 'You can edit this content in the email tab of the admin interface: SCREENING_DO_NOT_ADVANCE_OFF_TOPIC', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('SCREENING_DO_NOT_ADVANCE_OTHER', 'Your proposal in the Climate CoLab', 'You can edit this content in the email tab of the admin interface: SCREENING_DO_NOT_ADVANCE_OTHER', '');
  REPLACE INTO admin__email_template (name, subject, header, footer) VALUES ('TERMS_OF_SERVICE', '', 'You can edit this content in the email tab of the admin interface: TERMS_OF_SERVICE', '');
  