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 »

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: 17955
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: Unsupported data types by migrations - umil

Post by david63 »

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: 15672
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 »

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
:studio_microphone: Looking for a specific feature or alternative option?
shaim
Registered User
Posts: 2
Joined: Sat Dec 02, 2017 2:23 pm

Re: Unsupported data types by migrations - umil

Post by shaim »

thanks!! :-)
User avatar
3Di
Former Team Member
Posts: 15672
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 »

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
:studio_microphone: Looking for a specific feature or alternative option?
Post Reply

Return to “Extension Writers Discussion”