MediaPortal Forums HTPC/MediaCenter

Go Back   MediaPortal Forum » MediaPortal TV-Server » Help on Development » Development


Development You want to code something for the TV-Server? Share it in here!

Reply
 
Thread Tools Display Modes
Old 2007-09-04, 21:37   #1 (permalink)
Portal Member
 
Join Date: Apr 2006
Posts: 210
Thanks: 0
Thanked 2 Times in 2 Posts


Default weirdness in mysql schema?

dont nail me to the cross but im just wondering here, im doing my own personal spring+hibernate+ajax based webinterface and i was going through the mysql schema of the TvLibrary from a dump i made and noticed some stuff

a) MyISAM, doesnt support FK's
b) all fk's are just indexes
c) default charset latin1

to begin with a+b means the database cant do integrity checks or cascades, which means that possible errors in coding wont result in errors and/or data might be left behind and the database will unnecessarily grow over time

and c just means that only basic western+nordic characters are supported

and to get to my question: is this a design choice (please explain ), or has it just been overlooked
__________________
amd BE2350 / 2GB / 8500gt / terratec diversity / xp sp2
deebo is offline   Reply With Quote
Reply

Bookmarks

Tags
mysql, schema, weirdness

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Info Weirdness bi_si_hawk Support 3 2007-03-10 20:58
Additions to tvengine db schema? AdmiralUD General Development (no feature request here!) 2 2007-01-30 14:26
Trailer weirdness emphatic 0.2.0.0 Final and SVN Builds 0 2006-12-25 17:49
Hauppauge remote weirdness. donfrenchiano General Support 1 2005-11-24 10:00
IR Transmitter: any public available schema? a.dimuzio Hardware Selection Help 0 2005-01-14 16:29


All times are GMT +1. The time now is 05:57.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 Protected by Akismet Blog with WordPress