#145 ipplanv6-CVS: Index creation fails, missing field in table

[Anonymous]

Error:

---
ALTER TABLE ipaddrlnk ADD INDEX ipaddrlnk_dst (dstipaddr, dstcustomer);

Failed to execute above statement against database
Key column 'dstcustomer' doesn't exist in table
---

Looking at schemacreate.php I see:

---
$tables['ipaddrlnk']=array(
array('ipaddr', 'C', '39', 'DEFAULT' => '', 'NotNull'),
# array('iptype','I4','DEFAULT' => AFI_INET),
array('baseindex', 'I8', 'DEFAULT' => 0, 'NotNull'),
array('customer', (DBF_TYPE=='mysql' or DBF_TYPE=='maxsql') ? 'SMALLINT UNSIGNED':'I4', 'DEFAULT' => 0, 'NotNull'),
array('dstipaddr', 'C', '39', 'DEFAULT' => '', 'NotNull'),
array('dstbaseindex', 'I8', 'DEFAULT' => 0, 'NotNull'),
);
---

The field 'dstcustomer' exists on a 4.91a install but no in ipplanv6.

Regards,

[Richard Ellerbrock]

Resolved in CVS