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: 20646
Joined: Thu Dec 19, 2002 8:08 am

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!

I now no longer support any of my extensions but they will start to become available here
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
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.
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
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
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: Unsupported data types by migrations - umil

Post by 3Di »

Have fun :)
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
Post Reply

Return to “Extension Writers Discussion”