Quote:
|
Originally Posted by carlisleglass
This is the contents of 'PATCH.sql.txt'
Code:
ALTER TABLE xcart_register_field_values ADD `addressid` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE xcart_register_field_values DROP PRIMARY KEY;
ALTER TABLE xcart_register_field_values ADD PRIMARY KEY (`fieldid`, `userid`, `addressid`);
|
Yes, these are the SQL queries that are required.
The addressid field is already in the address book table, it is called "id" there.
It seems I was wrong when I said your query is required.
I missed the table name in your query. Sorry.
So, all the required SQL can be found in my first post.