search

formtools / core

The Form Tools Core.
https://formtools.org
207 stars 78 forks source link

DB Table Field Type consistency #700

Open apmuthu opened 4 years ago

apmuthu commented 4 years ago

The following is needed:

ALTER TABLE ft_field_options
    CHANGE list_group_id list_group_id MEDIUMINT(9) UNSIGNED NOT NULL, 
    CHANGE option_order option_order SMALLINT(4) UNSIGNED NOT NULL;

Also make changes in the main database schema for new installs in lines 338-339 of global/code/Installation.class.php:

                  list_group_id mediumint(9) NOT NULL,
                  option_order smallint(4) NOT NULL,

to be changed to:

                  list_group_id mediumint(9) unsigned NOT NULL,
                  option_order smallint(4) unsigned NOT NULL,