title: Magento "General error: 1005 Can't create table"
body: <p>I'm freaking out... working on a Magento site and all was well. Woke up this morning to continue work and the entire site (both front-end and admin) are throwing errors. The error log says:</p>
  
  <pre><code>a:5:{i:0;s:249:"Error in file: "/home1/ameridq4/public_html/pursuityourself/magento/app/code/core/Mage/Admin/sql/admin_setup/    install-1.6.0.0.php" - SQLSTATE[HY000]: General error: 1005 Can't create table 'ameridq4_ecommerce-pursuit-magento.admin_assert' (errno: -1)";i:1;s:1168:"#0 /home1/ameridq4/public_html/pursuityourself/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
  #1 /home1/ameridq4/public_html/pursuityourself/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup-&gt;_modifyResourceDb('install', '', '1.6.1.0')
  #2 /home1/ameridq4/public_html/pursuityourself/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup-&gt;_installResourceDb('1.6.1.0')
  #3 /home1/ameridq4/public_html/pursuityourself/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup-&gt;applyUpdates()
  #4 /home1/ameridq4/public_html/pursuityourself/magento/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
  #5 /home1/ameridq4/public_html/pursuityourself/magento/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App-&gt;_initModules()
  #6 /home1/ameridq4/public_html/pursuityourself/magento/app/Mage.php(683): Mage_Core_Model_App-&gt;run(Array)
  #7 /home1/ameridq4/public_html/pursuityourself/magento/index.php(87): Mage::run('', 'store')
  #8 {main}";s:3:"url";s:10:"/magento/e";s:11:"script_name";s:18:"/magento/index.php";s:4:"skin";s:7:"default";}
  </code></pre>
  
  <p>I haven't done anything between last night when it was working fine and this morning... last thing I did yesterday was change the Default Store Name from "Default Store" to "Pursuit". Any ideas what happened and how to fix?</p>