gistfile1.txt

-- MySQL dump 10.13  Distrib 5.5.15, for osx10.7 (i386)
--
-- Host: localhost    Database: asgseedbank
-- ------------------------------------------------------
-- Server version	5.5.15

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `schema_migrations`
--

LOCK TABLES `schema_migrations` WRITE;
/*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */;
INSERT INTO `schema_migrations` VALUES ('20111230021128'),('20111230021129'),('20111230021130'),('20111230021131'),('20111230021132'),('20111230021133'),('20111230021134'),('20111230021135'),('20111230021136'),('20111230021137'),('20111230021138'),('20111230021139'),('20111230021140'),('20111230021141'),('20111230021142'),('20111230021143'),('20111230021144'),('20111230021145'),('20111230021146'),('20111230021147'),('20111230021148'),('20111230021149'),('20111230021150'),('20111230021151'),('20111230021152'),('20111230021153'),('20111230021154'),('20111230021155'),('20111230021156'),('20111230021157'),('20111230021158'),('20111230021159'),('20111230021160'),('20111230021161'),('20111230021162'),('20111230021163'),('20111230021164'),('20111230021165'),('20111230021166'),('20111230021167'),('20111230021168'),('20111230021169'),('20111230021170'),('20111230021171'),('20111230021172'),('20111230021173'),('20111230021174'),('20111230021175'),('20111230021176'),('20111230021177'),('20111230021178'),('20111230021179'),('20111230021180'),('20111230021181'),('20111230021182'),('20111230021183'),('20111230021184'),('20111230021185'),('20111230021186'),('20111230021187'),('20111230021188'),('20111230021189'),('20111230021190'),('20111230021191'),('20111230021192'),('20111230021193'),('20111230021194'),('20111230021195'),('20111230021196'),('20111230021197'),('20111230021198'),('20111230021199'),('20111230021200'),('20111230021201'),('20111230021202'),('20111230021203'),('20111230021204'),('20111230021205'),('20111230021206'),('20111230021207'),('20111230021208'),('20111230021209'),('20111230021210'),('20111230021211'),('20111230021212'),('20111230021213'),('20111230021214'),('20111230021215'),('20111230021216'),('20111230021217'),('20111230021218'),('20111230021219'),('20111230021220'),('20111230021221'),('20111230021222'),('20111230021223'),('20111230021224'),('20111230021225'),('20111230021226'),('20111230021227'),('20111230021228'),('20111230021229'),('20111230021230'),('20111230021231'),('20111230021232'),('20111230021233'),('20111230021234'),('20111230021235'),('20111230021236'),('20111230021237'),('20111230021238');
/*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `skrill_accounts`
--

LOCK TABLES `skrill_accounts` WRITE;
/*!40000 ALTER TABLE `skrill_accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `skrill_accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_activators`
--

LOCK TABLES `spree_activators` WRITE;
/*!40000 ALTER TABLE `spree_activators` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_activators` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_addresses`
--

LOCK TABLES `spree_addresses` WRITE;
/*!40000 ALTER TABLE `spree_addresses` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_addresses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_adjustments`
--

LOCK TABLES `spree_adjustments` WRITE;
/*!40000 ALTER TABLE `spree_adjustments` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_adjustments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_assets`
--

LOCK TABLES `spree_assets` WRITE;
/*!40000 ALTER TABLE `spree_assets` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_assets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_calculators`
--

LOCK TABLES `spree_calculators` WRITE;
/*!40000 ALTER TABLE `spree_calculators` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_calculators` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_configurations`
--

LOCK TABLES `spree_configurations` WRITE;
/*!40000 ALTER TABLE `spree_configurations` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_configurations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_countries`
--

LOCK TABLES `spree_countries` WRITE;
/*!40000 ALTER TABLE `spree_countries` DISABLE KEYS */;
INSERT INTO `spree_countries` VALUES (1,'AFGHANISTAN','AF','AFG','Afghanistan',4),(2,'ALBANIA','AL','ALB','Albania',8),(3,'ALGERIA','DZ','DZA','Algeria',12),(4,'AMERICAN SAMOA','AS','ASM','American Samoa',16),(5,'ANDORRA','AD','AND','Andorra',20),(6,'ANGOLA','AO','AGO','Angola',24),(7,'ANGUILLA','AI','AIA','Anguilla',660),(8,'ANTIGUA AND BARBUDA','AG','ATG','Antigua and Barbuda',28),(9,'ARGENTINA','AR','ARG','Argentina',32),(10,'ARMENIA','AM','ARM','Armenia',51),(11,'ARUBA','AW','ABW','Aruba',533),(12,'AUSTRALIA','AU','AUS','Australia',36),(13,'AUSTRIA','AT','AUT','Austria',40),(14,'AZERBAIJAN','AZ','AZE','Azerbaijan',31),(15,'BAHAMAS','BS','BHS','Bahamas',44),(16,'BAHRAIN','BH','BHR','Bahrain',48),(17,'BANGLADESH','BD','BGD','Bangladesh',50),(18,'BARBADOS','BB','BRB','Barbados',52),(19,'BELARUS','BY','BLR','Belarus',112),(20,'BELGIUM','BE','BEL','Belgium',56),(21,'BELIZE','BZ','BLZ','Belize',84),(22,'BENIN','BJ','BEN','Benin',204),(23,'BERMUDA','BM','BMU','Bermuda',60),(24,'BHUTAN','BT','BTN','Bhutan',64),(25,'BOLIVIA','BO','BOL','Bolivia',68),(26,'BOSNIA AND HERZEGOVINA','BA','BIH','Bosnia and Herzegovina',70),(27,'BOTSWANA','BW','BWA','Botswana',72),(28,'BRAZIL','BR','BRA','Brazil',76),(29,'BRUNEI DARUSSALAM','BN','BRN','Brunei Darussalam',96),(30,'BULGARIA','BG','BGR','Bulgaria',100),(31,'BURKINA FASO','BF','BFA','Burkina Faso',854),(32,'BURUNDI','BI','BDI','Burundi',108),(33,'CAMBODIA','KH','KHM','Cambodia',116),(34,'CAMEROON','CM','CMR','Cameroon',120),(35,'CANADA','CA','CAN','Canada',124),(36,'CAPE VERDE','CV','CPV','Cape Verde',132),(37,'CAYMAN ISLANDS','KY','CYM','Cayman Islands',136),(38,'CENTRAL AFRICAN REPUBLIC','CF','CAF','Central African Republic',140),(39,'CHAD','TD','TCD','Chad',148),(40,'CHILE','CL','CHL','Chile',152),(41,'CHINA','CN','CHN','China',156),(42,'COLOMBIA','CO','COL','Colombia',170),(43,'COMOROS','KM','COM','Comoros',174),(44,'CONGO','CG','COG','Congo',178),(45,'CONGO, THE DEMOCRATIC REPUBLIC OF THE','CD','COD','Congo, the Democratic Republic of the',180),(46,'COOK ISLANDS','CK','COK','Cook Islands',184),(47,'COSTA RICA','CR','CRI','Costa Rica',188),(48,'COTE D\'IVOIRE','CI','CIV','Cote D\'Ivoire',384),(49,'CROATIA','HR','HRV','Croatia',191),(50,'CUBA','CU','CUB','Cuba',192),(51,'CYPRUS','CY','CYP','Cyprus',196),(52,'CZECH REPUBLIC','CZ','CZE','Czech Republic',203),(53,'DENMARK','DK','DNK','Denmark',208),(54,'DJIBOUTI','DJ','DJI','Djibouti',262),(55,'DOMINICA','DM','DMA','Dominica',212),(56,'DOMINICAN REPUBLIC','DO','DOM','Dominican Republic',214),(57,'ECUADOR','EC','ECU','Ecuador',218),(58,'EGYPT','EG','EGY','Egypt',818),(59,'EL SALVADOR','SV','SLV','El Salvador',222),(60,'EQUATORIAL GUINEA','GQ','GNQ','Equatorial Guinea',226),(61,'ERITREA','ER','ERI','Eritrea',232),(62,'ESTONIA','EE','EST','Estonia',233),(63,'ETHIOPIA','ET','ETH','Ethiopia',231),(64,'FALKLAND ISLANDS (MALVINAS)','FK','FLK','Falkland Islands (Malvinas)',238),(65,'FAROE ISLANDS','FO','FRO','Faroe Islands',234),(66,'FIJI','FJ','FJI','Fiji',242),(67,'FINLAND','FI','FIN','Finland',246),(68,'FRANCE','FR','FRA','France',250),(69,'FRENCH GUIANA','GF','GUF','French Guiana',254),(70,'FRENCH POLYNESIA','PF','PYF','French Polynesia',258),(71,'GABON','GA','GAB','Gabon',266),(72,'GAMBIA','GM','GMB','Gambia',270),(73,'GEORGIA','GE','GEO','Georgia',268),(74,'GERMANY','DE','DEU','Germany',276),(75,'GHANA','GH','GHA','Ghana',288),(76,'GIBRALTAR','GI','GIB','Gibraltar',292),(77,'GREECE','GR','GRC','Greece',300),(78,'GREENLAND','GL','GRL','Greenland',304),(79,'GRENADA','GD','GRD','Grenada',308),(80,'GUADELOUPE','GP','GLP','Guadeloupe',312),(81,'GUAM','GU','GUM','Guam',316),(82,'GUATEMALA','GT','GTM','Guatemala',320),(83,'GUINEA','GN','GIN','Guinea',324),(84,'GUINEA-BISSAU','GW','GNB','Guinea-Bissau',624),(85,'GUYANA','GY','GUY','Guyana',328),(86,'HAITI','HT','HTI','Haiti',332),(87,'HOLY SEE (VATICAN CITY STATE)','VA','VAT','Holy See (Vatican City State)',336),(88,'HONDURAS','HN','HND','Honduras',340),(89,'HONG KONG','HK','HKG','Hong Kong',344),(90,'HUNGARY','HU','HUN','Hungary',348),(91,'ICELAND','IS','ISL','Iceland',352),(92,'INDIA','IN','IND','India',356),(93,'INDONESIA','ID','IDN','Indonesia',360),(94,'IRAN, ISLAMIC REPUBLIC OF','IR','IRN','Iran, Islamic Republic of',364),(95,'IRAQ','IQ','IRQ','Iraq',368),(96,'IRELAND','IE','IRL','Ireland',372),(97,'ISRAEL','IL','ISR','Israel',376),(98,'ITALY','IT','ITA','Italy',380),(99,'JAMAICA','JM','JAM','Jamaica',388),(100,'JAPAN','JP','JPN','Japan',392),(101,'JORDAN','JO','JOR','Jordan',400),(102,'KAZAKHSTAN','KZ','KAZ','Kazakhstan',398),(103,'KENYA','KE','KEN','Kenya',404),(104,'KIRIBATI','KI','KIR','Kiribati',296),(105,'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','KP','PRK','North Korea',408),(106,'KOREA, REPUBLIC OF','KR','KOR','South Korea',410),(107,'KUWAIT','KW','KWT','Kuwait',414),(108,'KYRGYZSTAN','KG','KGZ','Kyrgyzstan',417),(109,'LAO PEOPLE\'S DEMOCRATIC REPUBLIC','LA','LAO','Lao People\'s Democratic Republic',418),(110,'LATVIA','LV','LVA','Latvia',428),(111,'LEBANON','LB','LBN','Lebanon',422),(112,'LESOTHO','LS','LSO','Lesotho',426),(113,'LIBERIA','LR','LBR','Liberia',430),(114,'LIBYAN ARAB JAMAHIRIYA','LY','LBY','Libyan Arab Jamahiriya',434),(115,'LIECHTENSTEIN','LI','LIE','Liechtenstein',438),(116,'LITHUANIA','LT','LTU','Lithuania',440),(117,'LUXEMBOURG','LU','LUX','Luxembourg',442),(118,'MACAO','MO','MAC','Macao',446),(119,'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','MK','MKD','Macedonia',807),(120,'MADAGASCAR','MG','MDG','Madagascar',450),(121,'MALAWI','MW','MWI','Malawi',454),(122,'MALAYSIA','MY','MYS','Malaysia',458),(123,'MALDIVES','MV','MDV','Maldives',462),(124,'MALI','ML','MLI','Mali',466),(125,'MALTA','MT','MLT','Malta',470),(126,'MARSHALL ISLANDS','MH','MHL','Marshall Islands',584),(127,'MARTINIQUE','MQ','MTQ','Martinique',474),(128,'MAURITANIA','MR','MRT','Mauritania',478),(129,'MAURITIUS','MU','MUS','Mauritius',480),(130,'MEXICO','MX','MEX','Mexico',484),(131,'MICRONESIA, FEDERATED STATES OF','FM','FSM','Micronesia, Federated States of',583),(132,'MOLDOVA, REPUBLIC OF','MD','MDA','Moldova, Republic of',498),(133,'MONACO','MC','MCO','Monaco',492),(134,'MONGOLIA','MN','MNG','Mongolia',496),(135,'MONTSERRAT','MS','MSR','Montserrat',500),(136,'MOROCCO','MA','MAR','Morocco',504),(137,'MOZAMBIQUE','MZ','MOZ','Mozambique',508),(138,'MYANMAR','MM','MMR','Myanmar',104),(139,'NAMIBIA','NA','NAM','Namibia',516),(140,'NAURU','NR','NRU','Nauru',520),(141,'NEPAL','NP','NPL','Nepal',524),(142,'NETHERLANDS','NL','NLD','Netherlands',528),(143,'NETHERLANDS ANTILLES','AN','ANT','Netherlands Antilles',530),(144,'NEW CALEDONIA','NC','NCL','New Caledonia',540),(145,'NEW ZEALAND','NZ','NZL','New Zealand',554),(146,'NICARAGUA','NI','NIC','Nicaragua',558),(147,'NIGER','NE','NER','Niger',562),(148,'NIGERIA','NG','NGA','Nigeria',566),(149,'NIUE','NU','NIU','Niue',570),(150,'NORFOLK ISLAND','NF','NFK','Norfolk Island',574),(151,'NORTHERN MARIANA ISLANDS','MP','MNP','Northern Mariana Islands',580),(152,'NORWAY','NO','NOR','Norway',578),(153,'OMAN','OM','OMN','Oman',512),(154,'PAKISTAN','PK','PAK','Pakistan',586),(155,'PALAU','PW','PLW','Palau',585),(156,'PANAMA','PA','PAN','Panama',591),(157,'PAPUA NEW GUINEA','PG','PNG','Papua New Guinea',598),(158,'PARAGUAY','PY','PRY','Paraguay',600),(159,'PERU','PE','PER','Peru',604),(160,'PHILIPPINES','PH','PHL','Philippines',608),(161,'PITCAIRN','PN','PCN','Pitcairn',612),(162,'POLAND','PL','POL','Poland',616),(163,'PORTUGAL','PT','PRT','Portugal',620),(164,'PUERTO RICO','PR','PRI','Puerto Rico',630),(165,'QATAR','QA','QAT','Qatar',634),(166,'REUNION','RE','REU','Reunion',638),(167,'ROMANIA','RO','ROM','Romania',642),(168,'RUSSIAN FEDERATION','RU','RUS','Russian Federation',643),(169,'RWANDA','RW','RWA','Rwanda',646),(170,'SAINT HELENA','SH','SHN','Saint Helena',654),(171,'SAINT KITTS AND NEVIS','KN','KNA','Saint Kitts and Nevis',659),(172,'SAINT LUCIA','LC','LCA','Saint Lucia',662),(173,'SAINT PIERRE AND MIQUELON','PM','SPM','Saint Pierre and Miquelon',666),(174,'SAINT VINCENT AND THE GRENADINES','VC','VCT','Saint Vincent and the Grenadines',670),(175,'SAMOA','WS','WSM','Samoa',882),(176,'SAN MARINO','SM','SMR','San Marino',674),(177,'SAO TOME AND PRINCIPE','ST','STP','Sao Tome and Principe',678),(178,'SAUDI ARABIA','SA','SAU','Saudi Arabia',682),(179,'SENEGAL','SN','SEN','Senegal',686),(180,'SEYCHELLES','SC','SYC','Seychelles',690),(181,'SIERRA LEONE','SL','SLE','Sierra Leone',694),(182,'SINGAPORE','SG','SGP','Singapore',702),(183,'SLOVAKIA','SK','SVK','Slovakia',703),(184,'SLOVENIA','SI','SVN','Slovenia',705),(185,'SOLOMON ISLANDS','SB','SLB','Solomon Islands',90),(186,'SOMALIA','SO','SOM','Somalia',706),(187,'SOUTH AFRICA','ZA','ZAF','South Africa',710),(188,'SPAIN','ES','ESP','Spain',724),(189,'SRI LANKA','LK','LKA','Sri Lanka',144),(190,'SUDAN','SD','SDN','Sudan',736),(191,'SURINAME','SR','SUR','Suriname',740),(192,'SVALBARD AND JAN MAYEN','SJ','SJM','Svalbard and Jan Mayen',744),(193,'SWAZILAND','SZ','SWZ','Swaziland',748),(194,'SWEDEN','SE','SWE','Sweden',752),(195,'SWITZERLAND','CH','CHE','Switzerland',756),(196,'SYRIAN ARAB REPUBLIC','SY','SYR','Syrian Arab Republic',760),(197,'TAIWAN, PROVINCE OF CHINA','TW','TWN','Taiwan',158),(198,'TAJIKISTAN','TJ','TJK','Tajikistan',762),(199,'TANZANIA, UNITED REPUBLIC OF','TZ','TZA','Tanzania, United Republic of',834),(200,'THAILAND','TH','THA','Thailand',764),(201,'TOGO','TG','TGO','Togo',768),(202,'TOKELAU','TK','TKL','Tokelau',772),(203,'TONGA','TO','TON','Tonga',776),(204,'TRINIDAD AND TOBAGO','TT','TTO','Trinidad and Tobago',780),(205,'TUNISIA','TN','TUN','Tunisia',788),(206,'TURKEY','TR','TUR','Turkey',792),(207,'TURKMENISTAN','TM','TKM','Turkmenistan',795),(208,'TURKS AND CAICOS ISLANDS','TC','TCA','Turks and Caicos Islands',796),(209,'TUVALU','TV','TUV','Tuvalu',798),(210,'UGANDA','UG','UGA','Uganda',800),(211,'UKRAINE','UA','UKR','Ukraine',804),(212,'UNITED ARAB EMIRATES','AE','ARE','United Arab Emirates',784),(213,'UNITED KINGDOM','GB','GBR','United Kingdom',826),(214,'UNITED STATES','US','USA','United States',840),(215,'URUGUAY','UY','URY','Uruguay',858),(216,'UZBEKISTAN','UZ','UZB','Uzbekistan',860),(217,'VANUATU','VU','VUT','Vanuatu',548),(218,'VENEZUELA','VE','VEN','Venezuela',862),(219,'VIET NAM','VN','VNM','Viet Nam',704),(220,'VIRGIN ISLANDS, BRITISH','VG','VGB','Virgin Islands, British',92),(221,'VIRGIN ISLANDS, U.S.','VI','VIR','Virgin Islands, U.S.',850),(222,'WALLIS AND FUTUNA','WF','WLF','Wallis and Futuna',876),(223,'WESTERN SAHARA','EH','ESH','Western Sahara',732),(224,'YEMEN','YE','YEM','Yemen',887),(225,'ZAMBIA','ZM','ZMB','Zambia',894),(226,'ZIMBABWE','ZW','ZWE','Zimbabwe',716);
/*!40000 ALTER TABLE `spree_countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_creditcards`
--

LOCK TABLES `spree_creditcards` WRITE;
/*!40000 ALTER TABLE `spree_creditcards` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_creditcards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_gateways`
--

LOCK TABLES `spree_gateways` WRITE;
/*!40000 ALTER TABLE `spree_gateways` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_gateways` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_inventory_units`
--

LOCK TABLES `spree_inventory_units` WRITE;
/*!40000 ALTER TABLE `spree_inventory_units` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_inventory_units` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_line_items`
--

LOCK TABLES `spree_line_items` WRITE;
/*!40000 ALTER TABLE `spree_line_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_line_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_log_entries`
--

LOCK TABLES `spree_log_entries` WRITE;
/*!40000 ALTER TABLE `spree_log_entries` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_log_entries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_mail_methods`
--

LOCK TABLES `spree_mail_methods` WRITE;
/*!40000 ALTER TABLE `spree_mail_methods` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_mail_methods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_option_types`
--

LOCK TABLES `spree_option_types` WRITE;
/*!40000 ALTER TABLE `spree_option_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_option_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_option_types_prototypes`
--

LOCK TABLES `spree_option_types_prototypes` WRITE;
/*!40000 ALTER TABLE `spree_option_types_prototypes` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_option_types_prototypes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_option_values`
--

LOCK TABLES `spree_option_values` WRITE;
/*!40000 ALTER TABLE `spree_option_values` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_option_values` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_option_values_variants`
--

LOCK TABLES `spree_option_values_variants` WRITE;
/*!40000 ALTER TABLE `spree_option_values_variants` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_option_values_variants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_orders`
--

LOCK TABLES `spree_orders` WRITE;
/*!40000 ALTER TABLE `spree_orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_payment_methods`
--

LOCK TABLES `spree_payment_methods` WRITE;
/*!40000 ALTER TABLE `spree_payment_methods` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_payment_methods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_payments`
--

LOCK TABLES `spree_payments` WRITE;
/*!40000 ALTER TABLE `spree_payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_preferences`
--

LOCK TABLES `spree_preferences` WRITE;
/*!40000 ALTER TABLE `spree_preferences` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_preferences` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_product_groups`
--

LOCK TABLES `spree_product_groups` WRITE;
/*!40000 ALTER TABLE `spree_product_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_product_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_product_groups_products`
--

LOCK TABLES `spree_product_groups_products` WRITE;
/*!40000 ALTER TABLE `spree_product_groups_products` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_product_groups_products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_product_option_types`
--

LOCK TABLES `spree_product_option_types` WRITE;
/*!40000 ALTER TABLE `spree_product_option_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_product_option_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_product_properties`
--

LOCK TABLES `spree_product_properties` WRITE;
/*!40000 ALTER TABLE `spree_product_properties` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_product_properties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_product_scopes`
--

LOCK TABLES `spree_product_scopes` WRITE;
/*!40000 ALTER TABLE `spree_product_scopes` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_product_scopes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_products`
--

LOCK TABLES `spree_products` WRITE;
/*!40000 ALTER TABLE `spree_products` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_products_promotion_rules`
--

LOCK TABLES `spree_products_promotion_rules` WRITE;
/*!40000 ALTER TABLE `spree_products_promotion_rules` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_products_promotion_rules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_products_taxons`
--

LOCK TABLES `spree_products_taxons` WRITE;
/*!40000 ALTER TABLE `spree_products_taxons` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_products_taxons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_promotion_action_line_items`
--

LOCK TABLES `spree_promotion_action_line_items` WRITE;
/*!40000 ALTER TABLE `spree_promotion_action_line_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_promotion_action_line_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_promotion_actions`
--

LOCK TABLES `spree_promotion_actions` WRITE;
/*!40000 ALTER TABLE `spree_promotion_actions` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_promotion_actions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_promotion_rules`
--

LOCK TABLES `spree_promotion_rules` WRITE;
/*!40000 ALTER TABLE `spree_promotion_rules` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_promotion_rules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_promotion_rules_users`
--

LOCK TABLES `spree_promotion_rules_users` WRITE;
/*!40000 ALTER TABLE `spree_promotion_rules_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_promotion_rules_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_properties`
--

LOCK TABLES `spree_properties` WRITE;
/*!40000 ALTER TABLE `spree_properties` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_properties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_properties_prototypes`
--

LOCK TABLES `spree_properties_prototypes` WRITE;
/*!40000 ALTER TABLE `spree_properties_prototypes` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_properties_prototypes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_prototypes`
--

LOCK TABLES `spree_prototypes` WRITE;
/*!40000 ALTER TABLE `spree_prototypes` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_prototypes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_return_authorizations`
--

LOCK TABLES `spree_return_authorizations` WRITE;
/*!40000 ALTER TABLE `spree_return_authorizations` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_return_authorizations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_roles`
--

LOCK TABLES `spree_roles` WRITE;
/*!40000 ALTER TABLE `spree_roles` DISABLE KEYS */;
INSERT INTO `spree_roles` VALUES (770229923,'user'),(930089099,'admin');
/*!40000 ALTER TABLE `spree_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_roles_users`
--

LOCK TABLES `spree_roles_users` WRITE;
/*!40000 ALTER TABLE `spree_roles_users` DISABLE KEYS */;
INSERT INTO `spree_roles_users` VALUES (930089099,1),(930089099,1);
/*!40000 ALTER TABLE `spree_roles_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_shipments`
--

LOCK TABLES `spree_shipments` WRITE;
/*!40000 ALTER TABLE `spree_shipments` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_shipments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_shipping_categories`
--

LOCK TABLES `spree_shipping_categories` WRITE;
/*!40000 ALTER TABLE `spree_shipping_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_shipping_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_shipping_methods`
--

LOCK TABLES `spree_shipping_methods` WRITE;
/*!40000 ALTER TABLE `spree_shipping_methods` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_shipping_methods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_state_events`
--

LOCK TABLES `spree_state_events` WRITE;
/*!40000 ALTER TABLE `spree_state_events` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_state_events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_states`
--

LOCK TABLES `spree_states` WRITE;
/*!40000 ALTER TABLE `spree_states` DISABLE KEYS */;
INSERT INTO `spree_states` VALUES (6764998,'District of Columbia','DC',214),(17199670,'Utah','UT',214),(37199952,'Louisiana','LA',214),(41111624,'Virginia','VA',214),(51943165,'North Dakota','ND',214),(66390489,'Wyoming','WY',214),(69729944,'New Mexico','NM',214),(69870734,'Connecticut','CT',214),(91367981,'West Virginia','WV',214),(103680699,'Wisconsin','WI',214),(177087202,'North Carolina','NC',214),(179539703,'Nevada','NV',214),(199950338,'Hawaii','HI',214),(248548169,'Oklahoma','OK',214),(267271847,'Florida','FL',214),(276110813,'California','CA',214),(298914262,'Oregon','OR',214),(308473843,'Kentucky','KY',214),(385551075,'Massachusetts','MA',214),(403740659,'Alaska','AK',214),(414569975,'Washington','WA',214),(426832442,'New Hampshire','NH',214),(471470972,'Arkansas','AR',214),(471711976,'Pennsylvania','PA',214),(474001862,'Rhode Island','RI',214),(480368357,'Maryland','MD',214),(485193526,'Ohio','OH',214),(525212995,'Texas','TX',214),(532363768,'Mississippi','MS',214),(536031023,'Colorado','CO',214),(597434151,'South Carolina','SC',214),(615306087,'South Dakota','SD',214),(625629523,'Illinois','IL',214),(653576146,'Missouri','MO',214),(673350891,'Nebraska','NE',214),(721598219,'Delaware','DE',214),(726305632,'Tennessee','TN',214),(750950030,'New Jersey','NJ',214),(769938586,'Indiana','IN',214),(825306985,'Iowa','IA',214),(876916760,'Georgia','GA',214),(889445952,'New York','NY',214),(931624400,'Michigan','MI',214),(948208802,'Arizona','AZ',214),(969722173,'Kansas','KS',214),(982433740,'Idaho','ID',214),(989115415,'Vermont','VT',214),(999156632,'Montana','MT',214),(1032288924,'Minnesota','MN',214),(1055056709,'Maine','ME',214),(1061493585,'Alabama','AL',214);
/*!40000 ALTER TABLE `spree_states` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_tax_categories`
--

LOCK TABLES `spree_tax_categories` WRITE;
/*!40000 ALTER TABLE `spree_tax_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_tax_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_tax_rates`
--

LOCK TABLES `spree_tax_rates` WRITE;
/*!40000 ALTER TABLE `spree_tax_rates` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_tax_rates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_taxonomies`
--

LOCK TABLES `spree_taxonomies` WRITE;
/*!40000 ALTER TABLE `spree_taxonomies` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_taxonomies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_taxons`
--

LOCK TABLES `spree_taxons` WRITE;
/*!40000 ALTER TABLE `spree_taxons` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_taxons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_tokenized_permissions`
--

LOCK TABLES `spree_tokenized_permissions` WRITE;
/*!40000 ALTER TABLE `spree_tokenized_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_tokenized_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_trackers`
--

LOCK TABLES `spree_trackers` WRITE;
/*!40000 ALTER TABLE `spree_trackers` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_trackers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_users`
--

LOCK TABLES `spree_users` WRITE;
/*!40000 ALTER TABLE `spree_users` DISABLE KEYS */;
INSERT INTO `spree_users` VALUES (1,'fb9832db78d2efd791a8fd6f8bd8d9e4b2cb053e0dced0ef877bda8417e6d36f84b441679c5aff904f9eed7ef59e9b85a23299bac2299c86c5fc8f76d795ce6b','vSNa58hvAifcjsQn3vwZ','[email protected]',NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,'[email protected]',NULL,NULL,'2011-12-30 02:12:10','2011-12-30 02:12:10',NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `spree_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_variants`
--

LOCK TABLES `spree_variants` WRITE;
/*!40000 ALTER TABLE `spree_variants` DISABLE KEYS */;
/*!40000 ALTER TABLE `spree_variants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_zone_members`
--

LOCK TABLES `spree_zone_members` WRITE;
/*!40000 ALTER TABLE `spree_zone_members` DISABLE KEYS */;
INSERT INTO `spree_zone_members` VALUES (4914820,13,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(5807739,96,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(35022990,188,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(91991191,163,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(120011419,52,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(120937060,117,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(195044517,214,'Spree::Country',2,'2009-06-04 17:22:41','2009-06-04 17:22:41'),(244414130,68,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(394938353,162,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(423866172,20,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(424792003,90,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(477297967,184,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(506358563,53,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(507251676,116,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(546142054,142,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(690576312,62,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(691747661,110,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(729140670,183,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(739772837,213,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(776249265,30,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(777453396,74,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(807406092,51,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(808610553,125,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(847027202,167,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(890329113,194,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(929017584,98,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(966149671,67,'Spree::Country',1,'2009-06-04 13:22:26','2009-06-04 13:22:26'),(1017582644,35,'Spree::Country',2,'2009-06-04 17:22:41','2009-06-04 17:22:41');
/*!40000 ALTER TABLE `spree_zone_members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `spree_zones`
--

LOCK TABLES `spree_zones` WRITE;
/*!40000 ALTER TABLE `spree_zones` DISABLE KEYS */;
INSERT INTO `spree_zones` VALUES (1,'EU_VAT','Countries that make up the EU VAT zone.','2009-06-04 17:22:26','2009-06-04 17:22:26',0),(2,'North America','USA + Canada','2009-06-04 17:22:41','2009-06-04 17:22:41',0);
/*!40000 ALTER TABLE `spree_zones` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-12-30 16:20:22