Missing address format...

[Alex Clarke]

I've recently noticed that I'm missing an address format form my database.

When I checked the address_format table I only had 5 rows of data, not 6.

Can anyone advise me if it's safe to run the following SQL code on my database (via the Zen Cart admin) to re-create my address_format table?

#
# Table structure for table 'address_format'
#
DROP TABLE IF EXISTS address_format;
CREATE TABLE address_format (
address_format_id int(11) NOT NULL auto_increment,
address_format varchar(128) NOT NULL default '',
address_summary varchar(48) NOT NULL default '',
PRIMARY KEY (address_format_id)
) TYPE=MyISAM;

# 1 - Default, 2 - USA, 3 - Spain, 4 - Singapore, 5 - Germany, 6 - UK/GB
INSERT INTO address_format VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country');
INSERT INTO address_format VALUES (2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country');
INSERT INTO address_format VALUES (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country');
INSERT INTO address_format VALUES (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country');
INSERT INTO address_format VALUES (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country');
INSERT INTO address_format VALUES (6, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country','$postcode / $country');

The above SQL code was taken from the mysql_zencart.sql file (Zen Cart 1.3.8).

I'm sure running the above code will be fine, just want to get some confirmation.

Thanks in advance.

[DrByte]

Yes, it's fine to run that SQL.

[Mediatrend]

Just to follow this question.:)

$state calls the zone_id. I need the zone_name. How to do?

Than I need the European address format:

firstname lastname
street 1
street 2
country_id-post code city
country

How to do?

Thanks for your help.