| The brenbot SQLITE database is poorly constrcucted. [message #69395] | 
			Sun, 29 February 2004 01:27   | 
		 
		
			
				
				
				
					
						  
						Alkaline
						 Messages: 1132 Registered: November 2003 
						
	Karma: 
 
					 | 
					General (1 Star) Deleted  | 
					 | 
		 
		 
	 | 
 
	
		If your using a relation databse, at the very least use some Relations with the tables rather than having them just being there independantly... 
 
Right now there are just tables holding data, running a delete query in the database is pain. E.g. iff you have to delete all info for a single person, you have to go in and manually delete each record from each table id from each table... 
 
Although it takes less cpu power, running queries is a pain, espically edit queries...
		
		
  http://www.UNRules.com
		
 |  
	| 
		
	 | 
 
 
 |