Register to post in forums, or Log in to your existing account
 

Play RetroMUD
Post new topic  Reply to topic     Home » Forums » CMUD General Discussion
MattLofton
GURU


Joined: 23 Dec 2000
Posts: 4834
Location: USA

PostPosted: Tue Aug 09, 2011 4:16 am   

[3.34pro]SQL FOREIGN KEY support?
 
Foreign keys were added in version 3.6.something. What version does CMud use?
_________________
EDIT: I didn't like my old signature
Reply with quote
Anaristos
Sorcerer


Joined: 17 Jul 2007
Posts: 821
Location: California

PostPosted: Tue Aug 09, 2011 6:48 am   
 
The version is SQlite3.dll: 3007000

The latest version available is : 3007701
_________________
Sic itur ad astra.
Reply with quote
Daern
Sorcerer


Joined: 15 Apr 2011
Posts: 809

PostPosted: Tue Aug 09, 2011 8:17 pm   
 
You can update it yourself, even if the newest version isn't packaged with CMUD. You just need to download the newest sqlite3.dll from http://www.sqlite.org/download.html and overwrite the one in your CMUD directory.
Reply with quote
Zugg
MASTER


Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA

PostPosted: Tue Aug 16, 2011 9:39 pm   
 
Although honestly, whenever I've used FOREIGN KEY in my database schemas with other databases it just ends up being a slow mess. All it does is try to protect you from yourself and give more error messages if keys and tables don't stay in sync. I just do my own JOINS and not worry about it.
Reply with quote
Display posts from previous:   
Post new topic   Reply to topic     Home » Forums » CMUD General Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

© 2009 Zugg Software. Hosted by Wolfpaw.net