Address book id

[peterr]

Hi,

 

Can someone please explain the db relationship between the 'customer' and 'address_book' tables, in regards to these 2 columns:

 

* customers_default_address_id

* address_book_id

 

The address_book_id defaults to a value of '1', we have some customers with multiple address book entries, the ID's being 1, 2 and sometimes 3.

 

Hence the no. of rows in the customers table is less than the number of rows in the address_book table.

 

I'm using a snapshot somewhere between MS-1 and MS-2, and I see in MS-2, the address_book_id is auto-increment and the primary key, whereas in the version of osC we are using (the snapshot), the address_book_id column has no auto-increment (defaults to value of '1'), and the primary key is "address_book_id / customers_id".

 

Also, would it matter if I deleted the rows in the address_book table, where the address_book_id value was NOT '1' ? I say this because in admin, it only displays the (value=1) row details, so how the other rows got into the address book I don't know, and I'm 99% certain they are not used (MS-1/MS-2).

 

Thanks,

 

Peter