[isf-wifidog] Terms of service support

[Robin Jones]

Hi Gabriel,
 
I agree with you about the TermsOfService Tables TOS_id being a Primary Key set to an auto incrementing integer and that the TOS_Accepted_Users table should be linked by a foreign key constraint. However the way I envisioned the version to work is that when the terms of service is updated, the TermsOfService version number is incremented, then when a user logs in, the TOS_Accepted_Users version number is checked against the TermsOfService Tables version number. If they are not equal, the user is prompted to agree to the new terms and the row is updated to reflect this.
 
The Nodes and networks table should also be linked to the TOS_id through a foreign key constraint.
 
 
Hope all that makes sense.
 
 
Regards,
 
Robin.

________________________________

From: wifidog-bounces at listes.ilesansfil.org on behalf of Gabriel Hahmann
Sent: Sun 9/28/2008 4:41 PM
To: WiFiDog Captive Portal
Subject: Re: [isf-wifidog] Terms of service support


Robin,
 
I have some suggestions to make to your DB implementation of the TOS.
 
If you think that this can help, latter I can add on the wiki page.
 
TermsOfService Table:
I think that the TOS_id could be of type integer as there would be fewer TOS on a whole network and this way we can create a sequence to generate them, we could add also a PRIMARY KEY constraint on the columns TOS_id and Version.
 
TOS_Accepted_Users Table:
The columns TOS_id and Version could reference the same columns on the TermsOfService with a FOREIGN KEY constraint and user_id references the same column name on the table user.

networks and nodes table:
I think that all tables that references the TOS need to use the TOS_id and Version columns.
 
Regards,
Gabriel.
 
On Fri, Sep 26, 2008 at 7:38 PM, Robin Jones <Robin at networkfusion.co.uk> wrote:


	Hi All,
	 
	I have created a new document in the Wiki about how to implement Terms Of Service support (http://dev.wifidog.org/wiki/doc/developer/TermsOfService), Could people have a look and add to if they can (Max?). I have tried to make it support as many scenarios as possible and hopefully cover all the bases!!!
	 
	 
	Regards,
	 
	
	Robin.

	_______________________________________________
	WiFiDog mailing list
	WiFiDog at listes.ilesansfil.org
	http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
	


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 6447 bytes
Desc: not available
Url : http://listes.ilesansfil.org/pipermail/wifidog/attachments/20080928/1a895545/attachment.bin