[Sommaire] [Imprimer]

   1  DELETE FROM geo_zones;
   2  DELETE FROM zones_to_geo_zones ;
   3  DELETE FROM tax_rates;
   4  
   5  INSERT INTO geo_zones (geo_zone_id,geo_zone_name,geo_zone_description,date_added) 
   6         VALUES (1,"Florida","Florida local sales tax zone",now());
   7  
   8  INSERT INTO zones_to_geo_zones (association_id,zone_country_id,zone_id,geo_zone_id,date_added) 
   9         VALUES (1,223,18,1,now()); # USA/Florida
  10  
  11  INSERT INTO tax_rates ( tax_rates_id, tax_zone_id, tax_class_id, tax_rate, tax_description, last_modified, date_added)
  12         VALUES (1, 1, 1, 7.0, 'FL TAX 7.0%', now(), now());