Unsupported data types by migrations - umil

Discussion forum for Extension Writers regarding Extension Development.
Post Reply
shaim
Registered User
Posts: 2
Joined: Sat Dec 02, 2017 2:23 pm

Unsupported data types by migrations - umil

Post by shaim » Sat Dec 02, 2017 2:27 pm

Hi all,
I'd like to use the update_schema() method to update table structure, but regretfully, supported data types do not include set, enum, or date types - as supported in mysql.

Will that be acceptable for when the extension is reviewed - if I run an "alter table" sql statement using $db->sql_query()?

Or is there any other way it should be done?

Thanks!

User avatar
david63
Registered User
Posts: 16187
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Unsupported data types by migrations - umil

Post by david63 » Sat Dec 02, 2017 2:51 pm

shaim wrote:
Sat Dec 02, 2017 2:27 pm
Will that be acceptable for when the extension is reviewed - if I run an "alter table" sql statement using $db->sql_query()?
It is highly unlikely that a non supported data type would be accepted for an extension submitted to the CDB.

I believe the reason why some MySql data types are not supported is because other supported database types do not allow them and any extension in the CDB has to be compatible with all database types.

There could be extenuating circumstances (for example if the extension related specifically to MySql) but they would be pretty rare.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
3Di
Former Team Member
Posts: 13780
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Unsupported data types by migrations - umil

Post by 3Di » Sat Dec 02, 2017 2:59 pm

You can crete a your own specified data type within a migration though , like this one
viewtopic.php?f=461&t=2398036&hilit=dat ... t&start=15

Thw full topic from which belongs the above link is worth reading, btw.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫

shaim
Registered User
Posts: 2
Joined: Sat Dec 02, 2017 2:23 pm

Re: Unsupported data types by migrations - umil

Post by shaim » Sat Dec 09, 2017 4:52 pm

thanks!! :-)

User avatar
3Di
Former Team Member
Posts: 13780
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Unsupported data types by migrations - umil

Post by 3Di » Sat Dec 09, 2017 4:54 pm

Have fun :)
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
👨‍🏫 | Take a tour to | The Studio | 👨‍🏫

Post Reply

Return to “Extension Writers Discussion”