enabled field can be tinyint(1) instead of varchar(1)

9 views
Skip to first unread message

Ap.Muthu

unread,
Oct 24, 2013, 12:45:56 AM10/24/13
to Justin James Kelly, SI Group
Hi Justin,

Can we make the "enabled" field as tinyint(1) instead of varchar(1) - it
might make simpler boolean comparisions and make both pgsql and mysql
compatible sql expressions for such boolean comparisions?

It is currentlly so in:
biller
customers
extensions
payment_types (pt_enabled)
preferences (pref_enabled)
products
products_attributes
tax (tax_enabled)

Only in the "user" table it is int(1)

Regards,
Ap.Muthu

Justin Kelly

unread,
Oct 24, 2013, 1:12:48 AM10/24/13
to Ap.Muthu, SI Group
hey ap - feel free to write the sql patches - and update the sql files to change to int
Reply all
Reply to author
Forward
0 new messages