On Wednesday 18 July 2007, Dan Pascu wrote: > > we discussed this topic yesterday in the devel meeting, and decided to > > stay for now with the functionality neeeded for OpenSER. But extensions > > to the datatypes are not to hard to implement. Just take a look into > > the mysql.xsl file, 'column.type' template, and add the needed > > datatype. > > I know it's not hard to add, however I don't want to continuously patch my > openser with every release. So the question is if we provide a patch for > this that uses TIMESTAMP for MySQL and fallsback to DATETIME for the > other databases, will it be included?
Hi, i understand your concerns. I would be happy if i need to port only one patch from release to release.. :-) But i really want to stay with this tool only to the SQL subset that is needed for openser. If we introduce TIMESTAMP, then we must later also add CONSTRAINTS, and probably other stuff as well. We already support much more SQL then e.g. the SER db creation script, from that this version was forked. To be honest i don't want to create (and support) a generic SQL template system. You could use the following definition to create your tables. You get TIMESTAMP for mysql, and a fallback to the other databases. <column> <type db="mysql">TIMESTAMP</type <type>datetime</type> .. </column> Cheers, Henning _______________________________________________ Devel mailing list Devel@openser.org http://openser.org/cgi-bin/mailman/listinfo/devel
