[Vtigercrm-developers] why _inventoryproductrel change to varchar

[Rishab K]

In Vtiger 6.1.0 length of the comment field is set to 500.Its the same in
the migrated instance.
Let me know me if have missed something here.I have posted the mysql
describe results.

mysql results:

mysql> desc vtiger_inventoryproductrel;
+------------------+---------------+------+-----+---------+----------------+
| Field            | Type          | Null | Key | Default | Extra          |
+------------------+---------------+------+-----+---------+----------------+
| id               | int(19)       | YES  | MUL | NULL    |                |
| productid        | int(19)       | YES  | MUL | NULL    |                |
| sequence_no      | int(4)        | YES  |     | NULL    |                |
| quantity         | decimal(25,3) | YES  |     | NULL    |                |
| listprice        | decimal(27,8) | YES  |     | NULL    |                |
| discount_percent | decimal(7,3)  | YES  |     | NULL    |                |
| discount_amount  | decimal(27,8) | YES  |     | NULL    |                |
| comment          | varchar(500)  | YES  |     | NULL    |                |
| description      | text          | YES  |     | NULL    |                |
| incrementondel   | int(11)       | NO   |     | 0       |                |
| lineitem_id      | int(11)       | NO   | PRI | NULL    | auto_increment |
| tax1             | decimal(7,3)  | YES  |     | NULL    |                |
| tax2             | decimal(7,3)  | YES  |     | NULL    |                |
| tax3             | decimal(7,3)  | YES  |     | NULL    |                |
+------------------+---------------+------+-----+---------+----------------+
14 rows in set (0.04 sec)

mysql> use vtigercrm540;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> desc vtiger_inventoryproductrel;
+------------------+---------------+------+-----+---------+----------------+
| Field            | Type          | Null | Key | Default | Extra          |
+------------------+---------------+------+-----+---------+----------------+
| id               | int(19)       | YES  | MUL | NULL    |                |
| productid        | int(19)       | YES  | MUL | NULL    |                |
| sequence_no      | int(4)        | YES  |     | NULL    |                |
| quantity         | decimal(25,3) | YES  |     | NULL    |                |
| listprice        | decimal(27,8) | YES  |     | NULL    |                |
| discount_percent | decimal(7,3)  | YES  |     | NULL    |                |
| discount_amount  | decimal(27,8) | YES  |     | NULL    |                |
| comment          | varchar(500)  | YES  |     | NULL    |                |
| description      | text          | YES  |     | NULL    |                |
| incrementondel   | int(11)       | NO   |     | 0       |                |
| lineitem_id      | int(11)       | NO   | PRI | NULL    | auto_increment |
| tax1             | decimal(7,3)  | YES  |     | NULL    |                |
| tax2             | decimal(7,3)  | YES  |     | NULL    |                |
| tax3             | decimal(7,3)  | YES  |     | NULL    |                |
+------------------+---------------+------+-----+---------+----------------+
14 rows in set (0.00 sec)



On Tue, Jun 10, 2014 at 7:39 PM, micker <micker at free.fr> wrote:

> hello i used vtiger 5.4 and use comment field to describ more my invoice
> now in vtiger 6.0 this field is limited to 250 caratere ..
> why this regression ?
> Regards
>
>
>
> --
> View this message in context:
> http://vtiger-crm.2324883.n4.nabble.com/why-inventoryproductrel-change-to-varchar-tp10920.html
> Sent from the vtigercrm-developers mailing list archive at Nabble.com.
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140611/2775c32a/attachment.html>