[Opendnssec-develop] Database conversion tool

[Matthijs Mekking]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 07/03/2012 10:51 AM, Siôn Lloyd wrote:
> On 03/07/12 09:38, Jerry Lundström wrote:
>> On Tue, Jul 3, 2012 at 10:31 AM, Siôn Lloyd <sion at nominet.org.uk>
>> wrote:
>>> One thing that I was thinking about is where we have used
>>> tinyint or mediumint in the mysql schema but integer in the
>>> sqlite schema. However I think there should be no real issues
>>> unless someone has more than 127 HSMs or 8,388,607
>>> zones/policies (good luck with that).
>> Oh, maybe we should fix that for 1.4?
> 
> We have looked at this in the past and decided that the only one
> we needed to increase was for keys. This is when the script
> "migrate_id_mysql.pl" was created. (As you can see it is not as
> simple as just changing the column type; you need to drop and then
> recreate the FK constraints also.)
> 
> Does anyone think that these fields need to be increased?

"That ought to be enough for anybody"

> 
>> 
>>> The other thing is that in sqlite timestamps are stored as
>>> varchars; that should not be a problem, just something to be
>>> aware of.
>> MySQL is good at eating a lot of different timestamps layout but
>> it might not be as easy going from MySQL to SQLite, I'll keep
>> that in mind thanks.
>> 
>> /Jerry
> 
> 
> _______________________________________________ Opendnssec-develop
> mailing list Opendnssec-develop at lists.opendnssec.org 
> https://lists.opendnssec.org/mailman/listinfo/opendnssec-develop

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJP8rU5AAoJEA8yVCPsQCW5Z58H/3Aiy7RpL7uRxRbfardaM7sp
KUtWAkYCfhaivlggBDr2G8sevZG+oVVfU2WtRK6xeK+xMRtYaw5v8oGCRSv76bK1
rnU+iega6xpAgiTX3N2Ye4UU3U4mHcykVVbzZWEXfxVYruJB3q5J5wKVXPC3itg3
SjtPcqS4XDgvQHRxLzm9qC3HSUD/GVl8J6wgcU65+5tZUCu1AB+PXWX7e1GDeGct
MryhC6q8PXGI/aqJAQoBapyTVADkWxUJ4prRvDjarnxNiDhMgc1x0g4EJ/FMJnZ8
spkO98bRoZh8zxwEkNV+M2NGNF2zhJWVcEyj7jrhY94FC05Aq7zt5hMhUNrWH+g=
=+dyb
-----END PGP SIGNATURE-----