declare table engine (innodb, myisam)

Hi again, everybody,

This time, it will be really brief: does anyone know how to do this:

In order to create a plugin, i need some tables in the database to be created with ENGINE=INNODB (i need some FOREIGN KEYS). And i cannot find a way to do it. I know how to declare what fields it will contain, what keys, and such, but i can not find a way to specify what engine should be used. and i am afraid it can not be done, after looking at the code (1)

Anyone knows if there is a way to do this?

Thanks in advance!

(1) http://trac.rezo.net/trac/spip/browser/spip/ecrire/base/create.php#creer_ou_upgrader_table

Saúde,

Chaves.

I’m not a Spip specialist (I’m simply using it when required by my clients), so my first idea when I read your question is: why do you need to create your tables through Spip functions, rather than directly submitting the appropriate SQL query?

----- Original Message -----
From: José Manuel Castroagudín Silva
To: spip@rezo.net
Sent: Monday, July 20, 2009 6:32 PM
Subject: [Spip] declare table engine (innodb, myisam)

Hi again, everybody,

This time, it will be really brief: does anyone know how to do this:

In order to create a plugin, i need some tables in the database to be created with ENGINE=INNODB (i need some FOREIGN KEYS). And i cannot find a way to do it. I know how to declare what fields it will contain, what keys, and such, but i can not find a way to specify what engine should be used. and i am afraid it can not be done, after looking at the code (1)

Anyone knows if there is a way to do this?

Thanks in advance!

(1) http://trac.rezo.net/trac/spip/browser/spip/ecrire/base/create.php#creer_ou_upgrader_table

Saúde,

Chaves.



liste spip
spip@rezo.net - désabonnement : envoyer un mail à spip-off@rezo.net

Infos et archives : http://listes.rezo.net/mailman/listinfo/spip
Discuter chez rezo.net

Documentation de SPIP : http://www.spip.net/

Irc : de l’aide à toute heure : http://spip.net/irc

Well, my idea was to develop a complete and independent plugin, using « the right way of developing plugins™ ». That’s why i am looking for a way of doing it with spip.

I guess that, if nobody has a better suggestion (or, if somebody confirms there is no way of doing it « the spip way », hehe), i will do it that way (« create table (…)engine=innodb »)

Thanks, cFreed!

2009/7/21 cFreed <cfreed@orange.fr>

I’m not a Spip specialist (I’m simply using it when required by my clients), so my first idea when I read your question is: why do you need to create your tables through Spip functions, rather than directly submitting the appropriate SQL query?

----- Original Message -----
From: José Manuel Castroagudín Silva
To: spip@rezo.net
Sent: Monday, July 20, 2009 6:32 PM
Subject: [Spip] declare table engine (innodb, myisam)

Hi again, everybody,

This time, it will be really brief: does anyone know how to do this:

In order to create a plugin, i need some tables in the database to be created with ENGINE=INNODB (i need some FOREIGN KEYS). And i cannot find a way to do it. I know how to declare what fields it will contain, what keys, and such, but i can not find a way to specify what engine should be used. and i am afraid it can not be done, after looking at the code (1)

Anyone knows if there is a way to do this?

Thanks in advance!

(1) http://trac.rezo.net/trac/spip/browser/spip/ecrire/base/create.php#creer_ou_upgrader_table

Saúde,

Chaves.



liste spip
spip@rezo.net - désabonnement : envoyer un mail à spip-off@rezo.net

Infos et archives : http://listes.rezo.net/mailman/listinfo/spip
http://archives.rezo.net/spip.mbox/

Documentation de SPIP : http://www.spip.net/

Irc : de l’aide à toute heure : http://spip.net/irc


Saúde,

Chaves.