Add decimal digits validation on fields and fix precision errors

trytond/backend/mysql/table.py

 #This file is part of Tryton.  The COPYRIGHT file at the top level of
 #this repository contains the full copyright notices and license terms.
 
 from trytond.backend.table import TableHandlerInterface
 import logging
 
 
 class TableHandler(TableHandlerInterface):
 
     def __init__(self, cursor, model, module_name=None, history=False):
@@ skipping 379 matching lines @@
         if size is None:
             size = self._columns[column_name]['size']
         if default is None:
             default = self._columns[column_name]['default']
         res = ''
         if typname == 'varchar':
             if int(size) > 255:
                 size = 255
             res = 'varchar(%s)' % str(size)
         elif typname == 'decimal':
-            res = 'decimal(16, 8)'
+            res = 'decimal(65, 30)'
+        elif typname == 'double':
+            res = 'double(255, 30)'
         else:
             res = typname
         # Default value for timestamp doesn't work
         if typname == 'timestamp' and not nullable:
             nullable = True
         if nullable:
             res += ' NULL'
         else:
             res += ' NOT NULL'
         if default is not None:
             res += ' DEFAULT %s' % default
         return res