Database ps_address fields?

[Oracle99]

Hi, I'm hoping someone can assist here...

I have recently performed an upgrade on my site from 1.6.1.5 to the latest upgrade. Unfortunately after the upgrade has installed my site has some issues.

When I try to access my orders from the back end I get the error

"Bad SQL query
Table 'xxx.ps_address' doesn't exist"

I have looked into this and it appears that the table has been deleted from the database during the upgrade

I have spoken with my ISP and they are able to get a backup which will hopefully work fine.

Just in case my ISP have difficulties in obtaining the backup of my database could someone please tell me what the table fields are within ps_address just incase I need to go down the manual input route?

Many thanks.

John.

[rocky]

​Here's the code PrestaShop v1.6.1.6 uses to install the ps_address field, assuming you're using InnoDB. I hope it helps. 

CREATE TABLE `ps_address` (
  `id_address` int(10) unsigned NOT NULL auto_increment,
  `id_country` int(10) unsigned NOT NULL,
  `id_state` int(10) unsigned DEFAULT NULL,
  `id_customer` int(10) unsigned NOT NULL DEFAULT '0',
  `id_manufacturer` int(10) unsigned NOT NULL DEFAULT '0',
  `id_supplier` int(10) unsigned NOT NULL DEFAULT '0',
  `id_warehouse` int(10) unsigned NOT NULL DEFAULT '0',
  `alias` varchar(32) NOT NULL,
  `company` varchar(64) DEFAULT NULL,
  `lastname` varchar(32) NOT NULL,
  `firstname` varchar(32) NOT NULL,
  `address1` varchar(128) NOT NULL,
  `address2` varchar(128) DEFAULT NULL,
  `postcode` varchar(12) DEFAULT NULL,
  `city` varchar(64) NOT NULL,
  `other` text,
  `phone` varchar(32) DEFAULT NULL,
  `phone_mobile` varchar(32) DEFAULT NULL,
  `vat_number` varchar(32) DEFAULT NULL,
  `dni` varchar(16) DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_address`),
  KEY `address_customer` (`id_customer`),
  KEY `id_country` (`id_country`),
  KEY `id_state` (`id_state`),
  KEY `id_manufacturer` (`id_manufacturer`),
  KEY `id_supplier` (`id_supplier`),
  KEY `id_warehouse` (`id_warehouse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATION;

[Oracle99]

Thank you for your help! - That's exactly what I need.

John